1 CREATE TABLE IF NOT EXISTS `mail` (
2 `id` int(10) unsigned NOT NULL,
3 `uid` int(10) unsigned NOT NULL,
4 `from-name` char(255) NOT NULL,
5 `from-photo` char(255) NOT NULL,
6 `from-url` char(255) NOT NULL,
7 `contact-id` char(255) NOT NULL,
8 `title` char(255) NOT NULL,
10 `delivered` tinyint(1) NOT NULL,
11 `seen` tinyint(1) NOT NULL,
12 `replied` tinyint(1) NOT NULL,
13 `uri` char(255) NOT NULL,
14 `parent-uri` char(255) NOT NULL,
15 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
17 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
19 ALTER TABLE `user` ADD `notify-flags` INT(11) UNSIGNED NOT NULL DEFAULT 65535 AFTER `blocked`;