CREATE TABLE `messages` (
`ID` BIGINT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`From` TINYTEXT NOT NULL ,
`To` TINYTEXT NOT NULL ,
`Subject` TINYTEXT NOT NULL ,
`Message` TEXT NOT NULL ,
`Priority` CHAR( 1 ) NOT NULL DEFAULT '1',
`DateTime` DATETIME NOT NULL ,
`DeletedFrom` CHAR( 1 ) NOT NULL DEFAULT '0',
`DeletedTo` CHAR( 1 ) NOT NULL DEFAULT '0',
`Special` CHAR( 1 ) NOT NULL DEFAULT '0'
) TYPE = MYISAM COMMENT = 'User and system messages';