CREATE TABLE IF NOT EXISTS `messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from` int(11),
`to` int(11),
`title` varchar(120),
`text` tinytext,
`time` int(11),
`delete_from` tinyint(1),
`delete_to` tinyint(1),
`unread` tinyint(1),
PRIMARY KEY (`id`),
FOREIGN KEY (`from`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
FOREIGN KEY (`to`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;