Changeset cdb8b96 in github

Timestamp:

Jan 26, 2011 6:53:18 AM (2 years ago)

Author:

thomascube <thomas@…>

Branches:

master, HEAD, courier-fix, dev-browser-capabilities, pdo, release-0.6, release-0.7, release-0.8

Children:

f6c7afd

Parents:

a4b0885

Message:

Clear message cache table when upgrading

Location:

SQL

Files:

• mysql.update.sql (modified) (1 diff)
• postgres.update.sql (modified) (1 diff)
• sqlite.update.sql (modified) (1 diff)

SQL/mysql.update.sql

@@ -132 +132 @@
 ALTER TABLE `contacts` MODIFY `email` varchar(255) NOT NULL;
 
+TRUNCATE TABLE `messages`;
+

SQL/postgres.update.sql

@@ -89 +89 @@
 ALTER TABLE contacts ALTER email TYPE varchar(255);
 
+TRUNCATE messages;

SQL/sqlite.update.sql

@@ -181 +181 @@
 DROP TABLE contacts_tmp;
 
+DELETE FROM messages;
+