From cd057165b66c9ea25ed846c28a016409c0d9ae22 Mon Sep 17 00:00:00 2001 From: zapata Date: Thu, 19 Dec 2002 16:14:34 +0000 Subject: [PATCH] fixed a bug in the update script --- dbscripts/updates/update20021213.sql | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-) 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! -- 2.11.0