CREATE TABLE AjaxMailFolders (
    FolderId int(11) NOT NULL auto_increment,
    Name text NOT NULL,
    PRIMARY KEY (FolderId)

    );

INSERT INTO AjaxMailFolders VALUES (1, 'Inbox');
INSERT INTO AjaxMailFolders VALUES (2, 'Trash');

CREATE TABLE AjaxMailMessages (
    MessageId int(11) NOT NULL auto_increment,
    `To` text NOT NULL,
    CC text NOT NULL,
    BCC text NOT NULL,
    `From` text NOT NULL,
    Subject text NOT NULL,
    Date bigint(2) 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)

    );