minor fixes

diff --git a/dbscripts/updates/update20031212.sql b/dbscripts/updates/update20031212.sql
index 9baa207..89ac22a 100755 (executable)
--- 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";
+