استشارة في بناء جداول في قاعدة بيانت

salam aliko

from your wards, i see that you wil do mail server

so youmust know some steps

1 - not all the data store in the DB

like attachment and picture coz it's will make the server too slow

you will use the server to ensure login and prvent any one from enter in different place

the idea of mail server

conatins table for user data

contains id, name , mail, password,picturepath on server

anther table for message contain id , textin htmlformat,type,attachfoldermessage,r

textinhtml coz color and size and font

type to determine if it inbox, send

it will be char(1)

attach folder from it you storw all data you can name it u100m200r

u100 mean user number 100

m200 mean message number 200 and r mean read or not

all i like to say that the db it so simple all you need is the arrange of folders that conatins user data

this is simple sturute user100

in it

inbox,draft, sent,..

inbox folder will conatins

attach , picture

etc

look small note

if user load attach called xyz make it as alias and make anther one like u200m120att24

from this way you can dertmine the attach in message

okay good luck

if you need any thing

eng_makin@hotmail.com

isdep_makin@yahoo.com

salam alikom