fix mistake in bug_message indexes

diff --git a/Debbugs/DB/Result/BugMessage.pm b/Debbugs/DB/Result/BugMessage.pm
index 7870ed572f8771e575061414481d05fe20479231..d5587da87f8dbb1317e66bd85eaa38833a13043c 100644 (file)
--- a/Debbugs/DB/Result/BugMessage.pm
+++ b/Debbugs/DB/Result/BugMessage.pm
@@ -113,6 +113,22 @@ __PACKAGE__->add_columns(
 
 __PACKAGE__->set_primary_key("id");
 
+=head1 UNIQUE CONSTRAINTS
+
+=head2 C<bug_message_bug_message_idx>
+
+=over 4
+
+=item * L</bug>
+
+=item * L</message>
+
+=back
+
+=cut
+
+__PACKAGE__->add_unique_constraint("bug_message_bug_message_idx", ["bug", "message"]);
+
 =head1 RELATIONS
 
 =head2 bug
@@ -146,8 +162,8 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mDjAtzaj5diA9b0YFK/7cA
+# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-11-24 20:30:07
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j9PbT+q4tBJhimXl7TQgLg
 
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration

diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql
index e1e06287859024f375b6b797bd48ee87d6c25b68..e2eebe8bcf481169a6f08cee01a38b91097dc2e7 100644 (file)
--- 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)');