hi, so far i have created a user table, messages table, friends table and other tables which are not needed for this section of my project. my messages table currently reads as such. the fields are in order: message_id, owner_id, subject, body, date_time_posted, is_public.
1 1 Party at my place 2nite 7 pm till l8!!!! CU there!!! 2011-02-15 15:06:28 1
2 1 COMPSCI280 Just enrolled there, seems a cool course 2011-02-15 15:20:35 1
3 1 Hangover! Maaaan, that party rocked! 2011-02-16 11:45:15 0
so basically my current table has messages, and can distinguish between whether the message is public or only visible to the users friend. i now want to make a third type of message, which is only visible to selected friends (i.e. not all).
so i think i have to make a change to my messages table so it can now distinguisgh between the 3 types of messages. and also create a new table which will work as message membership table. how would i go about doing these?