[eluser]jedd[/eluser]
Fuzzy - yup, the CI forums.
xwero - the clean methods there still allow for a huge amount of useless information to be retained. I'm pondering different approaches still. Sub-forums - as in the category of forums - I'm happy to leave entirely alone, as I don't need that second level of indirection. So for me, 'forum home' will be a list of forums. Within each forum will be a list of threads/topics. Within each thread will be a list of messages. So at the moment my table is easy:
id
user_id
thread_id
message_id
I was just doodling on some paper, trying to work out the next step - doing notifications (if the user wants them - which is a flag kept in the user table of course) for posts in a given thread. Given each row of this table identifies user & thread (because there'll only ever be one message_id per user/thread combo, as you pointed out) I'm thinking a fifth column in here - a boolean - for
notify. I can't see any benefit from putting that information into its own table .. yet.
