X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=Debbugs%2FDB%2FResult%2FBugVer.pm;fp=Debbugs%2FDB%2FResult%2FBugVer.pm;h=0000000000000000000000000000000000000000;hb=1e6633a3780f4fd53fc4303852e84d13cdad2dc6;hp=472a1dffc31eb73a902605a802696e866a873ae9;hpb=466f7faff129a5699c7674f59900a92aa256175d;p=debbugs.git diff --git a/Debbugs/DB/Result/BugVer.pm b/Debbugs/DB/Result/BugVer.pm deleted file mode 100644 index 472a1df..0000000 --- a/Debbugs/DB/Result/BugVer.pm +++ /dev/null @@ -1,247 +0,0 @@ -use utf8; -package Debbugs::DB::Result::BugVer; - -# Created by DBIx::Class::Schema::Loader -# DO NOT MODIFY THE FIRST PART OF THIS FILE - -=head1 NAME - -Debbugs::DB::Result::BugVer - Bug versions - -=cut - -use strict; -use warnings; - -use base 'DBIx::Class::Core'; - -=head1 COMPONENTS LOADED - -=over 4 - -=item * L - -=item * L - -=back - -=cut - -__PACKAGE__->load_components("InflateColumn::DateTime", "TimeStamp"); - -=head1 TABLE: C - -=cut - -__PACKAGE__->table("bug_ver"); - -=head1 ACCESSORS - -=head2 id - - data_type: 'integer' - is_auto_increment: 1 - is_nullable: 0 - sequence: 'bug_ver_id_seq' - -Bug version id - -=head2 bug - - data_type: 'integer' - is_foreign_key: 1 - is_nullable: 0 - -Bug number - -=head2 ver_string - - data_type: 'text' - is_nullable: 1 - -Version string - -=head2 src_pkg - - data_type: 'integer' - is_foreign_key: 1 - is_nullable: 1 - -Source package id (matches src_pkg table) - -=head2 src_ver - - data_type: 'integer' - is_foreign_key: 1 - is_nullable: 1 - -Source package version id (matches src_ver table) - -=head2 found - - data_type: 'boolean' - default_value: true - is_nullable: 0 - -True if this is a found version; false if this is a fixed version - -=head2 creation - - data_type: 'timestamp with time zone' - default_value: current_timestamp - is_nullable: 0 - original: {default_value => \"now()"} - -Time that this entry was created - -=head2 last_modified - - data_type: 'timestamp with time zone' - default_value: current_timestamp - is_nullable: 0 - original: {default_value => \"now()"} - -Time that this entry was modified - -=cut - -__PACKAGE__->add_columns( - "id", - { - data_type => "integer", - is_auto_increment => 1, - is_nullable => 0, - sequence => "bug_ver_id_seq", - }, - "bug", - { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, - "ver_string", - { data_type => "text", is_nullable => 1 }, - "src_pkg", - { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, - "src_ver", - { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, - "found", - { data_type => "boolean", default_value => \"true", is_nullable => 0 }, - "creation", - { - data_type => "timestamp with time zone", - default_value => \"current_timestamp", - is_nullable => 0, - original => { default_value => \"now()" }, - }, - "last_modified", - { - data_type => "timestamp with time zone", - default_value => \"current_timestamp", - is_nullable => 0, - original => { default_value => \"now()" }, - }, -); - -=head1 PRIMARY KEY - -=over 4 - -=item * L - -=back - -=cut - -__PACKAGE__->set_primary_key("id"); - -=head1 UNIQUE CONSTRAINTS - -=head2 C - -=over 4 - -=item * L - -=item * L - -=item * L - -=back - -=cut - -__PACKAGE__->add_unique_constraint( - "bug_ver_bug_ver_string_found_idx", - ["bug", "ver_string", "found"], -); - -=head1 RELATIONS - -=head2 bug - -Type: belongs_to - -Related object: L - -=cut - -__PACKAGE__->belongs_to( - "bug", - "Debbugs::DB::Result::Bug", - { id => "bug" }, - { is_deferrable => 0, on_delete => "RESTRICT", on_update => "CASCADE" }, -); - -=head2 src_pkg - -Type: belongs_to - -Related object: L - -=cut - -__PACKAGE__->belongs_to( - "src_pkg", - "Debbugs::DB::Result::SrcPkg", - { id => "src_pkg" }, - { - is_deferrable => 0, - join_type => "LEFT", - on_delete => "SET NULL", - on_update => "CASCADE", - }, -); - -=head2 src_ver - -Type: belongs_to - -Related object: L - -=cut - -__PACKAGE__->belongs_to( - "src_ver", - "Debbugs::DB::Result::SrcVer", - { id => "src_ver" }, - { - is_deferrable => 0, - join_type => "LEFT", - on_delete => "SET NULL", - on_update => "CASCADE", - }, -); - - -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-11-30 21:56:51 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cvdjFL2o+rBg2PfcintuNA - - -sub sqlt_deploy_hook { - my ($self, $sqlt_table) = @_; - for my $idx (qw(src_pkg src_ver)) { - $sqlt_table->add_index(name => 'bug_ver_'.$idx.'_id_idx', - fields => [$idx]); - } - $sqlt_table->add_index(name => 'bug_ver_src_pkg_id_src_ver_id_idx', - fields => [qw(src_pkg src_ver)], - ); -} -1;