=head1 NAME
-Debbugs::DB::Result::MessageRef
+Debbugs::DB::Result::MessageRef - Message references
=cut
=item * L<DBIx::Class::InflateColumn::DateTime>
+=item * L<DBIx::Class::TimeStamp>
+
=back
=cut
-__PACKAGE__->load_components("InflateColumn::DateTime");
+__PACKAGE__->load_components("InflateColumn::DateTime", "TimeStamp");
=head1 TABLE: C<message_refs>
is_foreign_key: 1
is_nullable: 0
+Message id (matches message)
+
=head2 refs
data_type: 'integer'
is_foreign_key: 1
is_nullable: 0
+Reference id (matches message)
+
+=head2 inferred
+
+ data_type: 'boolean'
+ default_value: false
+ is_nullable: 1
+
+TRUE if this message reference was reconstructed; primarily of use for messages which lack In-Reply-To: or References: headers
+
+=head2 primary_ref
+
+ data_type: 'boolean'
+ default_value: false
+ is_nullable: 1
+
+TRUE if this message->ref came from In-Reply-To: or similar.
+
=cut
__PACKAGE__->add_columns(
{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
"refs",
{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ "inferred",
+ { data_type => "boolean", default_value => \"false", is_nullable => 1 },
+ "primary_ref",
+ { data_type => "boolean", default_value => \"false", is_nullable => 1 },
);
+=head1 UNIQUE CONSTRAINTS
+
+=head2 C<message_refs_message_refs_idx>
+
+=over 4
+
+=item * L</message>
+
+=item * L</refs>
+
+=back
+
+=cut
+
+__PACKAGE__->add_unique_constraint("message_refs_message_refs_idx", ["message", "refs"]);
+
=head1 RELATIONS
=head2 message
"message",
"Debbugs::DB::Result::Message",
{ id => "message" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 ref
"ref",
"Debbugs::DB::Result::Message",
{ id => "refs" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2012-11-29 15:37:55
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uCScDuC5TprnuyEjg25eXg
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2017-03-04 10:59:03
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0YaAP/sB5N2Xr2rAFNK1lg
+sub sqlt_deploy_hook {
+ my ($self, $sqlt_table) = @_;
+ for my $idx (qw(refs message)) {
+ $sqlt_table->add_index(name => 'message_refs_idx_'.$idx,
+ fields => [$idx]);
+ }
+}
-# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;