From 6ada4f38fba631f2a9725d248e3d574e311d30a4 Mon Sep 17 00:00:00 2001
From: Don Armstrong <don@donarmstrong.com>
Date: Wed, 13 Nov 2013 09:21:06 -0800
Subject: [PATCH] remove pkg/alias_of/obsolete index; add obsolete/disabled
 time constraint

---
 Debbugs/DB/Result/SrcPkg.pm | 20 ++------------------
 sql/debbugs_schema.sql      |  4 ++--
 2 files changed, 4 insertions(+), 20 deletions(-)

diff --git a/Debbugs/DB/Result/SrcPkg.pm b/Debbugs/DB/Result/SrcPkg.pm
index cf45e3b..2c9c38e 100644
--- a/Debbugs/DB/Result/SrcPkg.pm
+++ b/Debbugs/DB/Result/SrcPkg.pm
@@ -140,22 +140,6 @@ __PACKAGE__->set_primary_key("id");
 
 =head1 UNIQUE CONSTRAINTS
 
-=head2 C<src_pkg_pkg_alias>
-
-=over 4
-
-=item * L</pkg>
-
-=item * L</alias_of>
-
-=item * L</obsolete>
-
-=back
-
-=cut
-
-__PACKAGE__->add_unique_constraint("src_pkg_pkg_alias", ["pkg", "alias_of", "obsolete"]);
-
 =head2 C<src_pkg_pkg_disabled>
 
 =over 4
@@ -253,8 +237,8 @@ __PACKAGE__->has_many(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-11-13 09:14:52
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3Jq0yBnJv5OW6jfXwUPUBg
+# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-11-13 09:19:59
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XKxXxExb3rnZZyuA+70mww
 
 
 # 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 71a470d..151d434 100644
--- a/sql/debbugs_schema.sql
+++ b/sql/debbugs_schema.sql
@@ -165,9 +165,9 @@ CREATE TABLE src_pkg (
        disabled TIMESTAMP WITH TIME ZONE DEFAULT NULL,
        last_modified TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
        obsolete BOOLEAN DEFAULT FALSE,
-       CONSTRAINT src_pkg_doesnt_alias_itself CHECK (id <> alias_of)
+       CONSTRAINT src_pkg_doesnt_alias_itself CHECK (id <> alias_of),
+       CONSTRAINT src_pkg_is_obsolete_if_disabled CHECK ((obsolete IS FALSE AND disabled IS NULL) OR (obsolete IS TRUE AND disabled IS NOT NULL))
 );
-CREATE UNIQUE INDEX src_pkg_pkg_alias ON src_pkg(pkg,alias_of,obsolete);
 CREATE INDEX src_pkg_pkg ON src_pkg(pkg);
 CREATE UNIQUE INDEX src_pkg_pkg_disabled ON src_pkg(pkg,disabled);
 INSERT INTO table_comments VALUES ('src_pkg','Source packages');
-- 
2.39.2