privmsg system db schema
- by Bartek
I'm making a PM-system on my site. And I want to know ultimate db schema.
I have always just used only 1 table. But my users have started complained that the messages in their outbox suddently dissapers =D Thats because if the other users deletes it, the one who sent it wont see it to.
So im thinking of making another table with the same fields
So im thinking something like this:
privmsgs
id | to | from | subject | message | date
-- -- ---- ------- ------- ----
1 76 893 blabla. blabla. 20100404
sent_msgs
id | to | from | subject | message | date
-- -- ---- ------- ------- ----
1 76 893 blabla. blabla. 20100404
Whatya think?
Sorry for my bad english