diff options
Diffstat (limited to 'roundcubemail/SQL/mysql.initial.sql')
| -rw-r--r-- | roundcubemail/SQL/mysql.initial.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/roundcubemail/SQL/mysql.initial.sql b/roundcubemail/SQL/mysql.initial.sql index 9815282f3..f06ecc842 100644 --- a/roundcubemail/SQL/mysql.initial.sql +++ b/roundcubemail/SQL/mysql.initial.sql @@ -65,6 +65,29 @@ CREATE TABLE `messages` ( ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; +-- Table structure for table `threads` + +CREATE TABLE `threads` ( + `thread_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', + `mailbox` varchar(128) /*!40101 CHARACTER SET ascii COLLATE ascii_general_ci */ NOT NULL, + `idx` int(11) UNSIGNED NOT NULL DEFAULT '0', + `has_children` tinyint(1) NOT NULL DEFAULT '0', + `is_root` tinyint(1) NOT NULL DEFAULT '0', + `root` int(11) UNSIGNED NOT NULL DEFAULT '0', + `depth` int(4) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY(`thread_id`), + UNIQUE `uniqueness` (`user_id`, `mailbox`, `idx`), + INDEX `is_root_index` (`is_root`), + INDEX `root_index` (`root`), + CONSTRAINT `user_id_fk_threads` FOREIGN KEY (`user_id`) + REFERENCES `users`(`user_id`) + /*!40008 + ON DELETE CASCADE + ON UPDATE CASCADE */ +) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; + + -- Table structure for table `cache` CREATE TABLE `cache` ( |