From fc83926703b0410eba40f1560682ea5d67f7b98f Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Sun, 24 Nov 2013 20:30:30 -0800 Subject: [PATCH] fix mistake in bug_message indexes --- Debbugs/DB/Result/BugMessage.pm | 20 ++++++++++++++++++-- sql/debbugs_schema.sql | 4 ++-- 2 files changed, 20 insertions(+), 4 deletions(-) diff --git a/Debbugs/DB/Result/BugMessage.pm b/Debbugs/DB/Result/BugMessage.pm index 7870ed5..d5587da 100644 --- 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 + +=over 4 + +=item * L + +=item * L + +=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 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)'); -- 2.39.2