Changeset f47e2dc in github

Timestamp:

Dec 11, 2009 2:18:19 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:

2717f9f

Parents:

3f5cce66

Message:

• move TRUNCATE before CREATE INDEX (#1486362)

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

@@ -48 +48 @@
 -- Updates from version 0.3-stable
 
+TRUNCATE `messages`;
+
 ALTER TABLE `messages`
     ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`);
-
-TRUNCATE `messages`;
 
 ALTER TABLE `session` 

SQL/postgres.update.sql

@@ -40 +40 @@
 -- Updates from version 0.3-stable
 
+TRUNCATE messages;
 CREATE INDEX messages_index_idx ON messages (user_id, cache_key, idx);
-TRUNCATE messages;
 DROP INDEX contacts_user_id_idx;
 CREATE INDEX contacts_user_id_idx ON contacts (user_id, email);

SQL/sqlite.update.sql

@@ -38 +38 @@
 -- Updates from version 0.3-stable
 
+TRUNCATE messages;
 DROP INDEX ix_messages_user_cache_uid;
 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;
 DROP INDEX ix_contacts_user_id;
 CREATE INDEX ix_contacts_user_id ON contacts(user_id, email);