Create Table AjaxMailFolders
(
Folderid int(11) Not null auto_increment ,
Name text not null ,
Primary key (Folderid)
) ;
Insert into AjaxMailFolders values ( 1 , 'in box' ) ;
Insert into AjaxMailFolders values ( 2 , 'in box' ) ;
====================================================
====================================================
Create Table Ajax Mailmessages
(
Messageid int (11) not null auto auto_increment ,
'To' text not null ,
cc text not null ,
bcc text not null ,
'from' text not null ,
subject text not null ,
date bigint (20) default null ,
message text not null ,
hasattachments tinyint (1) not null default "0" ,
unread tinyint (1) not null default "1" ,
folderid int (11) not null default "0" ,
Primary key (Messageid)
) ;
====================================================
====================================================
Create Table Ajaxmailattachments
(
Attachmentid int (11) not null auto_increment ,
Messageid int (11) not null default "0" ,
Filename text not null ,
Contenttype text not null ,
Size int (11) not null default "0" ,
Data longtext not null ,
Primary key (Attachmentid)
) ;