From fa96296059ee69b1d79f246b323cf2d5ae12fdf4 Mon Sep 17 00:00:00 2001 From: mh Date: Sun, 28 Apr 2002 18:54:49 +0000 Subject: [PATCH] added id index for comment table --- dbscripts/create_pg.sql | 1 + 1 file changed, 1 insertion(+) 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" ); -- 2.11.0