2 package Koha::Schema::Result::MessageQueue;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::MessageQueue
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<message_queue>
22 __PACKAGE__->table("message_queue");
38 Foreign key to the letters table
48 data_type: 'mediumtext'
53 data_type: 'mediumtext'
58 data_type: 'mediumtext'
67 =head2 message_transport_type
77 default_value: 'pending'
78 extra: {list => ["sent","pending","failed","deleted"]}
83 data_type: 'timestamp'
84 datetime_undef_if_invalid: 1
89 data_type: 'timestamp'
90 datetime_undef_if_invalid: 1
91 default_value: current_timestamp
101 data_type: 'longtext'
106 data_type: 'longtext'
111 data_type: 'mediumtext'
116 data_type: 'mediumtext'
121 __PACKAGE__->add_columns(
123 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
125 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
127 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
129 { data_type => "mediumtext", is_nullable => 1 },
131 { data_type => "mediumtext", is_nullable => 1 },
133 { data_type => "mediumtext", is_nullable => 1 },
135 { data_type => "varchar", is_nullable => 1, size => 64 },
136 "message_transport_type",
137 { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 20 },
141 default_value => "pending",
142 extra => { list => ["sent", "pending", "failed", "deleted"] },
147 data_type => "timestamp",
148 datetime_undef_if_invalid => 1,
153 data_type => "timestamp",
154 datetime_undef_if_invalid => 1,
155 default_value => \"current_timestamp",
159 { data_type => "longtext", is_nullable => 1 },
161 { data_type => "longtext", is_nullable => 1 },
163 { data_type => "longtext", is_nullable => 1 },
165 { data_type => "mediumtext", is_nullable => 1 },
167 { data_type => "mediumtext", is_nullable => 1 },
174 =item * L</message_id>
180 __PACKAGE__->set_primary_key("message_id");
184 =head2 borrowernumber
188 Related object: L<Koha::Schema::Result::Borrower>
192 __PACKAGE__->belongs_to(
194 "Koha::Schema::Result::Borrower",
195 { borrowernumber => "borrowernumber" },
199 on_delete => "CASCADE",
200 on_update => "CASCADE",
208 Related object: L<Koha::Schema::Result::Letter>
212 __PACKAGE__->belongs_to(
214 "Koha::Schema::Result::Letter",
215 { id => "letter_id" },
219 on_delete => "SET NULL",
220 on_update => "CASCADE",
224 =head2 message_transport_type
228 Related object: L<Koha::Schema::Result::MessageTransportType>
232 __PACKAGE__->belongs_to(
233 "message_transport_type",
234 "Koha::Schema::Result::MessageTransportType",
235 { message_transport_type => "message_transport_type" },
236 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" },
240 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-18 12:50:14
241 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PX9JzZw0v134xuHqNbB0cA
243 sub koha_object_class {
244 'Koha::Notice::Message';
246 sub koha_objects_class {
247 'Koha::Notice::Messages';