From: zapata <zapata>
Date: Sat, 24 Jan 2004 00:51:53 +0000 (+0000)
Subject: fixed a big bug
X-Git-Tag: LATEST_MERGED_1_1~180
X-Git-Url: http://erislabs.net/gitweb/?p=mir.git;a=commitdiff_plain;h=c7058c905b32413deda3fa5bf5e488e5f2bbbafc

fixed a big bug
---

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index a355655a..31fba74c 100755
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -364,8 +364,8 @@ CREATE        INDEX idx_content_webdb_create on content(webdb_create);
       "media_id" integer
     );
 
-    CREATE UNIQUE INDEX "idx_cxm_content" on "content_x_media" using btree ( "content_id" "int4_ops" );
-    CREATE UNIQUE INDEX "idx_cxm_media" on "content_x_media" using btree ( "media_id" "int4_ops" );
+    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" );
 
 --
 -- breaking