X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=Debbugs%2FDB%2FResult%2FMessage.pm;fp=Debbugs%2FDB%2FResult%2FMessage.pm;h=0000000000000000000000000000000000000000;hb=1e6633a3780f4fd53fc4303852e84d13cdad2dc6;hp=cd42f48efef4bbabd3a8cb46de904e722b01c2f7;hpb=466f7faff129a5699c7674f59900a92aa256175d;p=debbugs.git diff --git a/Debbugs/DB/Result/Message.pm b/Debbugs/DB/Result/Message.pm deleted file mode 100644 index cd42f48..0000000 --- a/Debbugs/DB/Result/Message.pm +++ /dev/null @@ -1,255 +0,0 @@ -use utf8; -package Debbugs::DB::Result::Message; - -# Created by DBIx::Class::Schema::Loader -# DO NOT MODIFY THE FIRST PART OF THIS FILE - -=head1 NAME - -Debbugs::DB::Result::Message - Messages sent to bugs - -=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("message"); - -=head1 ACCESSORS - -=head2 id - - data_type: 'integer' - is_auto_increment: 1 - is_nullable: 0 - sequence: 'message_id_seq' - -Message id - -=head2 msgid - - data_type: 'text' - default_value: (empty string) - is_nullable: 0 - -Message id header - -=head2 from_complete - - data_type: 'text' - default_value: (empty string) - is_nullable: 0 - -Complete from header of message - -=head2 to_complete - - data_type: 'text' - default_value: (empty string) - is_nullable: 0 - -Complete to header of message - -=head2 subject - - data_type: 'text' - default_value: (empty string) - is_nullable: 0 - -Subject of the message - -=head2 sent_date - - data_type: 'timestamp with time zone' - is_nullable: 1 - -Time/date message was sent (from Date header) - -=head2 refs - - data_type: 'text' - default_value: (empty string) - is_nullable: 0 - -Contents of References: header - -=head2 spam_score - - data_type: 'double precision' - default_value: 0 - is_nullable: 0 - -Spam score from spamassassin - -=head2 is_spam - - data_type: 'boolean' - default_value: false - is_nullable: 0 - -True if this message was spam and should not be shown - -=cut - -__PACKAGE__->add_columns( - "id", - { - data_type => "integer", - is_auto_increment => 1, - is_nullable => 0, - sequence => "message_id_seq", - }, - "msgid", - { data_type => "text", default_value => "", is_nullable => 0 }, - "from_complete", - { data_type => "text", default_value => "", is_nullable => 0 }, - "to_complete", - { data_type => "text", default_value => "", is_nullable => 0 }, - "subject", - { data_type => "text", default_value => "", is_nullable => 0 }, - "sent_date", - { data_type => "timestamp with time zone", is_nullable => 1 }, - "refs", - { data_type => "text", default_value => "", is_nullable => 0 }, - "spam_score", - { data_type => "double precision", default_value => 0, is_nullable => 0 }, - "is_spam", - { data_type => "boolean", default_value => \"false", is_nullable => 0 }, -); - -=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 - -=item * L - -=back - -=cut - -__PACKAGE__->add_unique_constraint( - "message_msgid_from_complete_to_complete_subject_idx", - ["msgid", "from_complete", "to_complete", "subject"], -); - -=head1 RELATIONS - -=head2 bug_messages - -Type: has_many - -Related object: L - -=cut - -__PACKAGE__->has_many( - "bug_messages", - "Debbugs::DB::Result::BugMessage", - { "foreign.message" => "self.id" }, - { cascade_copy => 0, cascade_delete => 0 }, -); - -=head2 message_correspondents - -Type: has_many - -Related object: L - -=cut - -__PACKAGE__->has_many( - "message_correspondents", - "Debbugs::DB::Result::MessageCorrespondent", - { "foreign.message" => "self.id" }, - { cascade_copy => 0, cascade_delete => 0 }, -); - -=head2 message_refs_messages - -Type: has_many - -Related object: L - -=cut - -__PACKAGE__->has_many( - "message_refs_messages", - "Debbugs::DB::Result::MessageRef", - { "foreign.message" => "self.id" }, - { cascade_copy => 0, cascade_delete => 0 }, -); - -=head2 message_refs_refs - -Type: has_many - -Related object: L - -=cut - -__PACKAGE__->has_many( - "message_refs_refs", - "Debbugs::DB::Result::MessageRef", - { "foreign.refs" => "self.id" }, - { cascade_copy => 0, cascade_delete => 0 }, -); - - -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2017-03-07 19:03:32 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:n8U0vD9R8M5wFoeoLlIWeQ - -__PACKAGE__->many_to_many(bugs => 'bug_messages','bug'); -__PACKAGE__->many_to_many(correspondents => 'message_correspondents','correspondent'); -__PACKAGE__->many_to_many(references => 'message_refs_message','message'); -__PACKAGE__->many_to_many(referenced_by => 'message_refs_refs','message'); - - -sub sqlt_deploy_hook { - my ($self, $sqlt_table) = @_; - for my $idx (qw(msgid subject)) { - $sqlt_table->add_index(name => 'message_'.$idx.'_idx', - fields => [$idx]); - } -} - -1;