Comment 2 for bug 1855798

Hi Rebecca,

With the 3 'Anomalies' we could fix up by adding an id column to the tables and then having that id be used in it's place else where, eg for view_type add an id column and then in view table in type column have the id rather than the word.

It would mean a bunch of changes and in the PHP code / SQL query structure to get things working right.

For the denormalized 'usr_friend' table it does kinda make sense to have usr1 and usr2 as they are users equal in weighting. Though we could change it to 'friend' and 'befriended' perhaps to make things clearer