Suite id
-=head2 suite_name
+=head2 codename
data_type: 'text'
is_nullable: 0
-Suite name
+Suite codename (sid, squeeze, etc.)
-=head2 version
+=head2 suite_name
data_type: 'text'
is_nullable: 1
-Suite version; NULL if there is no appropriate version
+Suite name (testing, stable, etc.)
-=head2 codename
+=head2 version
data_type: 'text'
is_nullable: 1
-Suite codename
+Suite version; NULL if there is no appropriate version
=head2 active
is_nullable => 0,
sequence => "suite_id_seq",
},
- "suite_name",
+ "codename",
{ data_type => "text", is_nullable => 0 },
- "version",
+ "suite_name",
{ data_type => "text", is_nullable => 1 },
- "codename",
+ "version",
{ data_type => "text", is_nullable => 1 },
"active",
{ data_type => "boolean", default_value => \"true", is_nullable => 1 },
=head1 UNIQUE CONSTRAINTS
+=head2 C<suite_idx_codename>
+
+=over 4
+
+=item * L</codename>
+
+=back
+
+=cut
+
+__PACKAGE__->add_unique_constraint("suite_idx_codename", ["codename"]);
+
=head2 C<suite_suite_name_key>
=over 4
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-11-30 21:56:51
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3csVa5t/HsPdWr0/Nmr7WA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-23 18:13:51
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:32GH2trGMuarLv+EjO1l8w
# You can replace this text with custom code or comments, and it will be preserved on regeneration
dbicdump -I. -o dump_directory=. \
-o components='["InflateColumn::DateTime","TimeStamp"]' \
-o preserve_case=1 \
+ -o skip_load_external=1 \
-o exclude='qr/^dbix_class_deploymenthandler_versions$/' \
Debbugs::DB dbi:Pg:service=$DEBBUGS_SERVICE '' '';
CREATE TABLE suite (
id SERIAL PRIMARY KEY,
- suite_name TEXT NOT NULL,
+ codename TEXT NOT NULL,
+ suite_name TEXT,
version TEXT,
- codename TEXT,
active BOOLEAN DEFAULT TRUE);
+CREATE UNIQUE INDEX suite_idx_codename ON suite(codename);
CREATE UNIQUE INDEX suite_suite_name_key ON suite(suite_name);
-CREATE INDEX suite_idx_codename ON suite(codename);
-CREATE INDEX suite_idx_version ON suite(version);
+CREATE UNIQUE INDEX suite_idx_version ON suite(version);
INSERT INTO table_comments VALUES ('suite','Debian Release Suite (stable, testing, etc.)');
INSERT INTO column_comments VALUES ('suite','id','Suite id');
-INSERT INTO column_comments VALUES ('suite','suite_name','Suite name');
+INSERT INTO column_comments VALUES ('suite','suite_name','Suite name (testing, stable, etc.)');
INSERT INTO column_comments VALUES ('suite','version','Suite version; NULL if there is no appropriate version');
-INSERT INTO column_comments VALUES ('suite','codename','Suite codename');
+INSERT INTO column_comments VALUES ('suite','codename','Suite codename (sid, squeeze, etc.)');
INSERT INTO column_comments VALUES ('suite','active','TRUE if the suite is still accepting uploads');
CREATE TABLE bin_associations (