1 -- Updates from version 0.6
3 ALTER TABLE `users` CHANGE `alias` `alias` varchar(128) BINARY NOT NULL;
4 ALTER TABLE `users` CHANGE `username` `username` varchar(128) BINARY NOT NULL;
6 CREATE TABLE `dictionary` (
7 `user_id` int(10) UNSIGNED DEFAULT NULL,
8 `language` varchar(5) NOT NULL,
9 `data` longtext NOT NULL,
10 CONSTRAINT `user_id_fk_dictionary` FOREIGN KEY (`user_id`)
11 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
12 UNIQUE `uniqueness` (`user_id`, `language`)
13 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
15 CREATE TABLE `searches` (
16 `search_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
17 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
18 `type` int(3) NOT NULL DEFAULT '0',
19 `name` varchar(128) NOT NULL,
21 PRIMARY KEY(`search_id`),
22 CONSTRAINT `user_id_fk_searches` FOREIGN KEY (`user_id`)
23 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
24 UNIQUE `uniqueness` (`user_id`, `type`, `name`)
25 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
27 DROP TABLE `messages`;
29 CREATE TABLE `cache_index` (
30 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
31 `mailbox` varchar(255) BINARY NOT NULL,
32 `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
33 `valid` tinyint(1) NOT NULL DEFAULT '0',
34 `data` longtext NOT NULL,
35 CONSTRAINT `user_id_fk_cache_index` FOREIGN KEY (`user_id`)
36 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
37 INDEX `changed_index` (`changed`),
38 PRIMARY KEY (`user_id`, `mailbox`)
39 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
41 CREATE TABLE `cache_thread` (
42 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
43 `mailbox` varchar(255) BINARY NOT NULL,
44 `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
45 `data` longtext NOT NULL,
46 CONSTRAINT `user_id_fk_cache_thread` FOREIGN KEY (`user_id`)
47 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
48 INDEX `changed_index` (`changed`),
49 PRIMARY KEY (`user_id`, `mailbox`)
50 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
52 CREATE TABLE `cache_messages` (
53 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
54 `mailbox` varchar(255) BINARY NOT NULL,
55 `uid` int(11) UNSIGNED NOT NULL DEFAULT '0',
56 `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
57 `data` longtext NOT NULL,
58 `flags` int(11) NOT NULL DEFAULT '0',
59 CONSTRAINT `user_id_fk_cache_messages` FOREIGN KEY (`user_id`)
60 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
61 INDEX `changed_index` (`changed`),
62 PRIMARY KEY (`user_id`, `mailbox`, `uid`)
63 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
65 -- Updates from version 0.7-beta
67 ALTER TABLE `session` CHANGE `sess_id` `sess_id` varchar(128) NOT NULL;