By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,743 Members | 804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,743 IT Pros & Developers. It's quick & easy.

webmail mysql table question

P: n/a
joe
I am writting a webmail client using mysql as the backend. I wrote the
scripts using a table for each separate user. I am thinkig about putting
all users in one table. the table structure now is
pk, msg, folder. i am thinking about adding a separate field called user
are there any advantages or disadvanges for doing this.
I think some disadvantages could be larger/file table size and need of
locking tables for updates, and probably less security.
the advantages would be to have all the data in one table, and no need to
setup a table for each user.
i am new to my sql i aprreciate some feedback. this is the link for
the demo of the webmail. username demo password password. i am planning on
adding and address book, and bcc and cc fields for new messages. Right now
i get the address from a search feature but most email clients have
addressbook, so i figured i should add one too.
www.wittyadmin.com/demo.html
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
joe wrote:
pk, msg, folder. i am thinking about adding a separate field called user
are there any advantages or disadvanges for doing this.


That is exactly how I would do it and this is how databases are ment to
be done. I hope you ment that you add a field where you have userid
value, and you have a separate table called "user" where you have id,
name and other information about that users.
Jul 20 '05 #2

P: n/a
joe wrote:
pk, msg, folder. i am thinking about adding a separate field called user
are there any advantages or disadvanges for doing this.


That is exactly how I would do it and this is how databases are ment to
be done. I hope you ment that you add a field where you have userid
value, and you have a separate table called "user" where you have id,
name and other information about that users.
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.