X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fcreate_pg.sql;h=90d891cd1583e202ee22318eff331f3b7fa574af;hb=110da060ae8138c0dceb0462385ac977b67665d7;hp=c0a38058841abcb1f461ad5052389ded685f0999;hpb=201e8e36d3cc17a3ec704c0da074942c97b919fe;p=mir.git

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index c0a38058..90d891cd 100755
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -695,4 +695,5 @@ CREATE  INDEX "idx_content_is_published" on "content" using btree ( "is_publishe
 
 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" );