summaryrefslogtreecommitdiff
path: root/SQL
diff options
context:
space:
mode:
authorthomascube <thomas@roundcube.net>2011-01-29 14:55:12 +0000
committerthomascube <thomas@roundcube.net>2011-01-29 14:55:12 +0000
commit98cb0f179206843ceaa87df6bfb3d1da045ed8ad (patch)
treeade6196094997c24b48e8a432383bd2da9f6bc5c /SQL
parenta32679e69f7d6c265f85015677743272740dcc8e (diff)
Apply bug fixes and localization updated from trunk for release 0.5.1
Diffstat (limited to 'SQL')
-rw-r--r--SQL/mysql.update.sql2
-rw-r--r--SQL/postgres.update.sql1
-rw-r--r--SQL/sqlite.update.sql2
3 files changed, 5 insertions, 0 deletions
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index 2af0a47e6..aaab43fb2 100644
--- a/SQL/mysql.update.sql
+++ b/SQL/mysql.update.sql
@@ -131,3 +131,5 @@ ALTER TABLE `users` ADD UNIQUE `username` (`username`, `mail_host`);
ALTER TABLE `contacts` MODIFY `email` varchar(255) NOT NULL;
+TRUNCATE TABLE `messages`;
+
diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql
index 444caf6f6..2f4498d36 100644
--- a/SQL/postgres.update.sql
+++ b/SQL/postgres.update.sql
@@ -88,3 +88,4 @@ DROP INDEX users_username_id_idx;
ALTER TABLE users ADD UNIQUE (username, mail_host);
ALTER TABLE contacts ALTER email TYPE varchar(255);
+TRUNCATE messages;
diff --git a/SQL/sqlite.update.sql b/SQL/sqlite.update.sql
index 328693944..6f2acf913 100644
--- a/SQL/sqlite.update.sql
+++ b/SQL/sqlite.update.sql
@@ -180,3 +180,5 @@ INSERT INTO contacts (contact_id, user_id, changed, del, name, email, firstname,
CREATE INDEX ix_contacts_user_id ON contacts(user_id, email);
DROP TABLE contacts_tmp;
+DELETE FROM messages;
+