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>
28 __PACKAGE__->load_components("InflateColumn::DateTime");
30 =head1 TABLE: C<bug_status_cache>
34 __PACKAGE__->table("bug_status_cache");
43 sequence: 'bug_status_cache_id_seq'
45 Source <-> suite association id
53 Source <-> suite association id
61 Source <-> suite association id
69 Source <-> suite association id
74 extra: {custom_type_name => "bug_status_type",list => ["pending","forwarded","pending-fixed","fixed","absent","done"]}
77 Source <-> suite association id
81 data_type: 'timestamp with time zone'
82 default_value: current_timestamp
84 original: {default_value => \"now()"}
86 Source <-> suite association id
90 data_type: 'timestamp with time zone'
91 default_value: current_timestamp
93 original: {default_value => \"now()"}
95 Source <-> suite association id
99 __PACKAGE__->add_columns(
102 data_type => "integer",
103 is_auto_increment => 1,
105 sequence => "bug_status_cache_id_seq",
108 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
110 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
112 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
117 custom_type_name => "bug_status_type",
131 data_type => "timestamp with time zone",
132 default_value => \"current_timestamp",
134 original => { default_value => \"now()" },
138 data_type => "timestamp with time zone",
139 default_value => \"current_timestamp",
141 original => { default_value => \"now()" },
155 __PACKAGE__->set_primary_key("id");
157 =head1 UNIQUE CONSTRAINTS
159 =head2 C<bug_status_cache_bug_suite_arch_idx>
173 __PACKAGE__->add_unique_constraint(
174 "bug_status_cache_bug_suite_arch_idx",
175 ["bug", "suite", "arch"],
184 Related object: L<Debbugs::DB::Result::Arch>
188 __PACKAGE__->belongs_to(
190 "Debbugs::DB::Result::Arch",
195 on_delete => "CASCADE",
196 on_update => "CASCADE",
204 Related object: L<Debbugs::DB::Result::Bug>
208 __PACKAGE__->belongs_to(
210 "Debbugs::DB::Result::Bug",
212 { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
219 Related object: L<Debbugs::DB::Result::Suite>
223 __PACKAGE__->belongs_to(
225 "Debbugs::DB::Result::Suite",
230 on_delete => "CASCADE",
231 on_update => "CASCADE",
236 # Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54
237 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JJbS0LgqkbWIAEzmSvzSxw
240 # You can replace this text with custom code or comments, and it will be preserved on regeneration