X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fupdates%2Fupdate20021213.sql;h=1f2119d10b07881675083b9e2c533ecf0bbb7901;hb=cd057165b66c9ea25ed846c28a016409c0d9ae22;hp=dcd93b46616db7a822d672328fd1d13bceef51fa;hpb=7898d8e4c8a9def4a2c93a89982ef477739709c9;p=mir.git

diff --git a/dbscripts/updates/update20021213.sql b/dbscripts/updates/update20021213.sql
index dcd93b46..1f2119d1 100755
--- a/dbscripts/updates/update20021213.sql
+++ b/dbscripts/updates/update20021213.sql
@@ -33,13 +33,6 @@ BEGIN TRANSACTION;
 
   DROP TABLE "comment_status_old";
 
-  CREATE  INDEX "comment_checksum_index" on "comment" using btree ( "checksum" "int4_ops" );
-  CREATE  INDEX "idx_comment_to_media" on "comment" using btree ( "to_media" "int4_ops" );
-  create index idx_comment_webdb_create on comment(webdb_create);
-
-  CREATE  INDEX "idx_comment_tomedia_ispublished" on "comment" using btree ( "to_media" "int4_ops", "is_published" "bool_ops" );
-
-  CREATE UNIQUE INDEX "idx_comment_id" on "comment" using btree ( "id" "int4_ops" );
 
   
 -- task 2: add sequenced and unique id's to article_type
@@ -163,6 +156,12 @@ BEGIN TRANSACTION;
     relname = 'comment';
   
   DROP TABLE "comment_old";
+
+  CREATE  INDEX "comment_checksum_index" on "comment" using btree ( "checksum" "int4_ops" );
+  CREATE  INDEX "idx_comment_to_media" on "comment" using btree ( "to_media" "int4_ops" );
+  create index idx_comment_webdb_create on comment(webdb_create);
+  CREATE  INDEX "idx_comment_tomedia_ispublished" on "comment" using btree ( "to_media" "int4_ops", "is_published" "bool_ops" );
+  CREATE UNIQUE INDEX "idx_comment_id" on "comment" using btree ( "id" "int4_ops" );
   
 -- that's it!