Changeset 2931 in subversion

Timestamp:

Sep 7, 2009 8:40:05 AM (4 years ago)

Author:

alec

Message:

• added index in messages table

Location:

trunk/roundcubemail/SQL

Files:

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

trunk/roundcubemail/SQL/mysql.initial.sql

@@ -54 +54 @@
  PRIMARY KEY(`message_id`),
  INDEX `created_index` (`created`),
+ INDEX `index_index` (`user_id`, `cache_key`, `idx`),
  UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`),
  CONSTRAINT `user_id_fk_messages` FOREIGN KEY (`user_id`)

trunk/roundcubemail/SQL/mysql.update.sql

@@ -45 +45 @@
 ALTER TABLE `users`
     CHANGE `language` `language` varchar(5);
+
+-- Updates from version 0.3-stable
+
+ALTER TABLE `messages`
+    ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`);

trunk/roundcubemail/SQL/postgres.initial.sql

@@ -175 +175 @@
 
 ALTER TABLE messages ADD UNIQUE (user_id, cache_key, uid);
+CREATE INDEX messages_index_idx ON messages (user_id, cache_key, idx);
 CREATE INDEX messages_created_idx ON messages (created);

trunk/roundcubemail/SQL/postgres.update.sql

@@ -37 +37 @@
 ALTER TABLE contacts ALTER del TYPE smallint;
 ALTER TABLE messages ALTER del TYPE smallint;
+
+-- Updates from version 0.3-stable
+
+CREATE INDEX messages_index_idx ON messages (user_id, cache_key, idx);

trunk/roundcubemail/SQL/sqlite.initial.sql

@@ -120 +120 @@
 );
 
-CREATE INDEX ix_messages_user_cache_uid ON messages(user_id,cache_key,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);
 CREATE INDEX ix_messages_created ON messages (created);

trunk/roundcubemail/SQL/sqlite.update.sql

@@ -35 +35 @@
 CREATE INDEX ix_session_changed ON session (changed);
 CREATE INDEX ix_cache_created ON cache (created);
+
+-- Updates from version 0.3-stable
+
+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);