Imported Upstream version 0.2~stable

[roundcube.git] / SQL / mysql.update.sql

diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index 2a9603f3e005a72b6afc6aa865761cede76c2a63..5590099d02682af9fec9784659ce5be7eea26594 100644 (file)
--- a/SQL/mysql.update.sql
+++ b/SQL/mysql.update.sql
@@ -19,9 +19,28 @@ ALTER TABLE `users`
 -- Updates from version 0.1.1
 
 ALTER TABLE `identities`
-    MODIFY `signature` text NOT NULL DEFAULT '', 
+    MODIFY `signature` text, 
     MODIFY `bcc` varchar(128) NOT NULL DEFAULT '', 
     MODIFY `reply-to` varchar(128) NOT NULL DEFAULT '', 
     MODIFY `organization` varchar(128) NOT NULL DEFAULT '',
     MODIFY `name` varchar(128) NOT NULL, 
     MODIFY `email` varchar(128) NOT NULL; 
+
+-- Updates from version 0.2-alpha
+
+ALTER TABLE `messages`
+    ADD INDEX `created_index` (`created`);
+
+-- Updates from version 0.2-beta (InnoDB only)
+
+ALTER TABLE `cache`
+    DROP `session_id`;
+    
+ALTER TABLE `session`
+    ADD INDEX `changed_index` (`changed`);
+
+ALTER TABLE `cache`
+    ADD INDEX `created_index` (`created`);
+
+ALTER TABLE `users`
+    CHANGE `language` `language` varchar(5);