X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=sql%2Fdebbugs_schema.sql;h=151d434110e56e99027f937c96b843891ed216b3;hb=44c0f6eeca5d4204a0f27f383be1731968b6deec;hp=71a470d105b772e72aed1aa0c9c28bcd957a3a7d;hpb=5f151a345046da30697139fd9eabf6616fd08510;p=debbugs.git

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');