From cd025131a467f833da2c83aece00ef77cfac2e86 Mon Sep 17 00:00:00 2001
From: rk <rk>
Date: Fri, 12 Dec 2003 18:30:39 +0000
Subject: [PATCH] minor fixes

---
 dbscripts/updates/update20031212.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/dbscripts/updates/update20031212.sql b/dbscripts/updates/update20031212.sql
index 9baa2076..89ac22a2 100755
--- a/dbscripts/updates/update20031212.sql
+++ b/dbscripts/updates/update20031212.sql
@@ -19,7 +19,6 @@
 BEGIN TRANSACTION;
 
 ALTER TABLE "webdb_users" ADD CONSTRAINT "webdb_users_login_key" UNIQUE (login);
-DROP INDEX "idx_webdb_user_log_pas_is_admin";
 
 --
 -- ogg format support
@@ -46,11 +45,12 @@ DROP INDEX "idx_comment_id";
 --
 DROP INDEX "idx_content_media";
 DROP INDEX "idx_media_content";
-CREATE INDEX "idx_cxm_content" using btree ( "content_id" "int4_ops" );
-CREATE INDEX "idx_cxm_media" using btree ( "media_id" "int4_ops" );
-ANALYZE "content_x_media";
+CREATE INDEX "idx_cxm_content" ON "content_x_media" using btree ( "content_id" "int4_ops" );
+CREATE INDEX "idx_cxm_media" ON "content_x_media" using btree ( "media_id" "int4_ops" );
 
 --
 -- that's it!
   
 COMMIT TRANSACTION;
+ANALYZE "content_x_media";
+
-- 
2.11.0