Changeset 7fec6b2 in github

Timestamp:

Sep 13, 2009 4:12:58 AM (4 years ago)

Author:

alecpl <alec@…>

Branches:

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

Children:

c678da1

Parents:

9ab7bc6

Message:

• "TRUNCATE messages" is required to remove buggy cache entries

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

@@ -50 +50 @@
 ALTER TABLE `messages`
     ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`);
+
+TRUNCATE `messages`;

SQL/postgres.update.sql

@@ -41 +41 @@
 
 CREATE INDEX messages_index_idx ON messages (user_id, cache_key, idx);
+TRUNCATE messages;

SQL/sqlite.update.sql

@@ -41 +41 @@
 CREATE UNIQUE INDEX ix_messages_user_cache_uid ON messages (user_id,cache_key,uid);
 CREATE INDEX ix_messages_index ON messages (user_id,cache_key,idx);
+TRUNCATE messages;