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