X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fdebbugs_schema.sql;fp=sql%2Fdebbugs_schema.sql;h=e2eebe8bcf481169a6f08cee01a38b91097dc2e7;hb=fc83926703b0410eba40f1560682ea5d67f7b98f;hp=e1e06287859024f375b6b797bd48ee87d6c25b68;hpb=81aa6d6f82cb952c3ecef474240272b8e9f68225;p=debbugs.git

diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql
index e1e0628..e2eebe8 100644
--- a/sql/debbugs_schema.sql
+++ b/sql/debbugs_schema.sql
@@ -492,8 +492,8 @@ CREATE TABLE bug_message (
        bug_log_offset INT,
        offset_valid TIMESTAMP WITH TIME ZONE
 );
-CREATE UNIQUE INDEX bug_message(bug,message);
-CREATE INDEX bug_message(bug,message_number);
+CREATE UNIQUE INDEX ON bug_message(bug,message);
+CREATE INDEX ON bug_message(bug,message_number);
 INSERT INTO table_comments VALUES ('bug_mesage','Mapping between a bug and a message');
 INSERT INTO column_comments VALUES ('bug_message','bug','Bug id (matches bug)');
 INSERT INTO column_comments VALUES ('bug_message','message','Message id (matches message)');