Changeset 1240 in subversion

Timestamp:

Apr 3, 2008 6:26:32 AM (5 years ago)

Author:

alec

Message:

fix: there's no ALTER TABLE ... ADD INDEX in postgresql

File:

• trunk/roundcubemail/SQL/postgres.initial.sql (modified) (1 diff)

trunk/roundcubemail/SQL/postgres.initial.sql

@@ -132 +132 @@
 );
 
-ALTER TABLE "cache" ADD INDEX (user_id, cache_key);
+CREATE INDEX cache_user_id_idx ON "cache" (user_id, cache_key);
 
 --