summaryrefslogtreecommitdiff
path: root/SQL/mysql.update.sql
diff options
context:
space:
mode:
Diffstat (limited to 'SQL/mysql.update.sql')
-rw-r--r--SQL/mysql.update.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index 103cb61db..2a9603f3e 100644
--- a/SQL/mysql.update.sql
+++ b/SQL/mysql.update.sql
@@ -15,3 +15,13 @@ ALTER TABLE `cache`
ALTER TABLE `users`
ADD INDEX `username_index` (`username`),
ADD INDEX `alias_index` (`alias`);
+
+-- Updates from version 0.1.1
+
+ALTER TABLE `identities`
+ MODIFY `signature` text NOT NULL DEFAULT '',
+ 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;