squiblo Posted February 4, 2012 Share Posted February 4, 2012 I'm trying to come up with a mysql database design so I can have a messaging system, much like facebook's. I want users to be able to send and reply to messages to more than one user at a time, and to delete whole threads without removing it from other users. Please help! Any questions please ask! Thanks Quote Link to comment Share on other sites More sharing options...
Andy-H Posted February 4, 2012 Share Posted February 4, 2012 users -user_id -name -pass -etc message_thread -message_thread_id -subject messages -message_id -message_thread_id -message -date_posted message_thread_subscribers -message_thread_id -user_id status_updates -user_id -status_url -viewed Quote Link to comment Share on other sites More sharing options...
squiblo Posted February 4, 2012 Author Share Posted February 4, 2012 Thanks Andy! I was trying to work it with just 2 tables. Much appreciated! Quote Link to comment Share on other sites More sharing options...
Andy-H Posted February 4, 2012 Share Posted February 4, 2012 np Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.