Freelance Forum | Freelance Jobs » FreelanceGossip Website Development » Database Forum

[Annu]

Hello,
I am building a form/blog/personal site for a small company. I was wondering if someone could help me in setting up my database. i have thought of a few options but i am not quite sure what one is the best.

each user have a person page, they need all their information stored, mail, bulletins, friends, etc.

i have my MySQL server setup as such:
SCHEMA(users) -> TABLE(Username) -> COLUMNS(disname, email, mail_from, bulletin_from, etc.)
The problem i am having with this is when send a new email or bulletin it adds a new row leaving NULL spaces.

For example:
Friends---------mail_message-----bulletin_message
Bob-------------null-------------------null
Tom------------null-------------------null
Joe-------------null--------------------null
null-------------Hello this is...----- null
null-------------My name is...----- null
null-------------null-------------------This is a bullet...
null-------------Hello this is...------null


see how everytime i post a new message or add a friend or post a bulletin it drops it down a row instead of filling in the NULL space. i dont like this and i beleive its slowing my server down a bit.

My other idea was to setup MySQL server such as:
SCHEMA(Username) --> TABLE(Mail, Bulletins, UserData, etc.) --> COLUMNS(Data)
idk how well this works and if it slows down my server any when i try to access multiple SCHEMAs at once.

Please can someone help me and aid me twards a better solution

Thanks,
DV6500

Configuration: Windows Vista
Internet Explorer 7.0

______________________

smart lipo cost
laser hair removal clinic