I need some help in creating the right tables for a private messaging system for cakephp. Can anyone help.
Basically at the moment i have the following tables Users - id - name - email Messages - id - subject - body - datesent MessageFolders - id - foldername - status The messagefolders table contains inbox and outbox i need to link the users, messages and messagesfolders tables together but what i need practically is for a message to be stored in the sending users outbox and in the receiving users inbox but both users are able to delete their messages but it should not effect the other user. E.g if i sent a message to a user and i delete it from my outbox the recipient user should still have the message in their inbox. I'm not sure if there should be 2 copies of the message or some status field as to whether a user can see it or not. I'm just looking for some guidance, Any help much appreciated --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
