luffy
(Kingla Pei)
November 5, 2011, 7:18am
1
Well, There is no relation between the topic and Yii.
It’s a database design only.
User A wants to send user B a message.
How will u design the table?
How many tables will u divide.
For me
It could be
t_message (id, from_id, to_id, title, content, created_at)
t_message_thread(id, message_id, content, user_id, created_at)
Any better solution?
yiqing95
(Yiqing 95)
November 5, 2011, 7:52am
2
jayant
(Codesutras)
November 5, 2011, 9:36am
3
Please check an attached file for mysql dump which i am using for a internal messaging. i have used this mysql dump in my lots of projects.and this schema is working fine.
I am also working to develop a extension in yii for internal messaging.
luffy
(Kingla Pei)
November 5, 2011, 2:48pm
4
jayant:
Please check an attached file for mysql dump which i am using for a internal messaging. i have used this mysql dump in my lots of projects.and this schema is working fine.
I am also working to develop a extension in yii for internal messaging.
awesome, all in one table