X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=SQL%2Fmysql.update.sql;h=5590099d02682af9fec9784659ce5be7eea26594;hb=3adad46e27086084a8b28a32fc4fbc953dbfef6c;hp=2a9603f3e005a72b6afc6aa865761cede76c2a63;hpb=48e8459231a1efa3e97284d07a328776a5b7485b;p=roundcube.git

diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index 2a9603f..5590099 100644
--- 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);