From: Don Armstrong Date: Sat, 25 Feb 2017 23:44:44 +0000 (-0800) Subject: reflow src_pkg obsolete constraint X-Git-Url: https://git.donarmstrong.com/?p=debbugs.git;a=commitdiff_plain;h=0d8767b1126aa1dc30cfd8599ecc8fa52c2f2cc8 reflow src_pkg obsolete constraint --- diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql index fc207c4..2556bac 100644 --- a/sql/debbugs_schema.sql +++ b/sql/debbugs_schema.sql @@ -178,7 +178,9 @@ CREATE TABLE src_pkg ( last_modified TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), obsolete BOOLEAN NOT NULL DEFAULT FALSE, CONSTRAINT src_pkg_doesnt_alias_itself CHECK (id <> alias_of), - CONSTRAINT src_pkg_is_obsolete_if_disabled CHECK ((obsolete IS FALSE AND disabled='infinity'::timestamp with time zone) OR (obsolete IS TRUE AND disabled < 'infinity'::timestamp with time zone)) + CONSTRAINT src_pkg_is_obsolete_if_disabled CHECK ( + (obsolete IS FALSE AND disabled='infinity'::timestamp with time zone) OR + (obsolete IS TRUE AND disabled < 'infinity'::timestamp with time zone)) ); CREATE INDEX src_pkg_pkg ON src_pkg(pkg); CREATE UNIQUE INDEX src_pkg_pkg_null ON src_pkg(pkg) WHERE disabled='infinity'::timestamp with time zone;