2 package Debbugs::DB::Result::BugStatusCache;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Debbugs::DB::Result::BugStatusCache - Source <-> suite associations
16 use base 'DBIx::Class::Core';
18 =head1 COMPONENTS LOADED
22 =item * L<DBIx::Class::InflateColumn::DateTime>
24 =item * L<DBIx::Class::TimeStamp>
30 __PACKAGE__->load_components("InflateColumn::DateTime", "TimeStamp");
32 =head1 TABLE: C<bug_status_cache>
36 __PACKAGE__->table("bug_status_cache");
45 sequence: 'bug_status_cache_id_seq'
47 Source <-> suite association id
55 Source <-> suite association id
63 Source <-> suite association id
71 Source <-> suite association id
76 extra: {custom_type_name => "bug_status_type",list => ["pending","forwarded","pending-fixed","fixed","absent","done"]}
79 Source <-> suite association id
83 data_type: 'timestamp with time zone'
84 default_value: current_timestamp
86 original: {default_value => \"now()"}
88 Source <-> suite association id
92 data_type: 'timestamp with time zone'
93 default_value: current_timestamp
95 original: {default_value => \"now()"}
97 Source <-> suite association id
101 __PACKAGE__->add_columns(
104 data_type => "integer",
105 is_auto_increment => 1,
107 sequence => "bug_status_cache_id_seq",
110 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
112 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
114 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
119 custom_type_name => "bug_status_type",
133 data_type => "timestamp with time zone",
134 default_value => \"current_timestamp",
136 original => { default_value => \"now()" },
140 data_type => "timestamp with time zone",
141 default_value => \"current_timestamp",
143 original => { default_value => \"now()" },
157 __PACKAGE__->set_primary_key("id");
159 =head1 UNIQUE CONSTRAINTS
161 =head2 C<bug_status_cache_bug_suite_arch_idx>
175 __PACKAGE__->add_unique_constraint(
176 "bug_status_cache_bug_suite_arch_idx",
177 ["bug", "suite", "arch"],
186 Related object: L<Debbugs::DB::Result::Arch>
190 __PACKAGE__->belongs_to(
192 "Debbugs::DB::Result::Arch",
197 on_delete => "CASCADE",
198 on_update => "CASCADE",
206 Related object: L<Debbugs::DB::Result::Bug>
210 __PACKAGE__->belongs_to(
212 "Debbugs::DB::Result::Bug",
214 { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
221 Related object: L<Debbugs::DB::Result::Suite>
225 __PACKAGE__->belongs_to(
227 "Debbugs::DB::Result::Suite",
232 on_delete => "CASCADE",
233 on_update => "CASCADE",
238 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-11-30 21:56:51
239 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A4gA20BsSs2R4VKmUCRs/g
242 # You can replace this text with custom code or comments, and it will be preserved on regeneration