Applied message threading patch from Chris January: http://www.atomice.com/blog/?p=33

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` (