Bug 7567 - Schema update for opac_news
[koha.git] / Koha / Schema / Result / OpacNews.pm
blob8a4246737f20c4f21e19c8403549f5e0196b976e
1 use utf8;
2 package Koha::Schema::Result::OpacNews;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
7 =head1 NAME
9 Koha::Schema::Result::OpacNews
11 =cut
13 use strict;
14 use warnings;
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<opac_news>
20 =cut
22 __PACKAGE__->table("opac_news");
24 =head1 ACCESSORS
26 =head2 idnew
28 data_type: 'integer'
29 extra: {unsigned => 1}
30 is_auto_increment: 1
31 is_nullable: 0
33 =head2 branchcode
35 data_type: 'varchar'
36 is_foreign_key: 1
37 is_nullable: 1
38 size: 10
40 =head2 title
42 data_type: 'varchar'
43 default_value: (empty string)
44 is_nullable: 0
45 size: 250
47 =head2 new
49 accessor: undef
50 data_type: 'text'
51 is_nullable: 0
53 =head2 lang
55 data_type: 'varchar'
56 default_value: (empty string)
57 is_nullable: 0
58 size: 25
60 =head2 timestamp
62 data_type: 'timestamp'
63 datetime_undef_if_invalid: 1
64 default_value: current_timestamp
65 is_nullable: 0
67 =head2 expirationdate
69 data_type: 'date'
70 datetime_undef_if_invalid: 1
71 is_nullable: 1
73 =head2 number
75 data_type: 'integer'
76 is_nullable: 1
78 =cut
80 __PACKAGE__->add_columns(
81 "idnew",
83 data_type => "integer",
84 extra => { unsigned => 1 },
85 is_auto_increment => 1,
86 is_nullable => 0,
88 "branchcode",
89 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
90 "title",
91 { data_type => "varchar", default_value => "", is_nullable => 0, size => 250 },
92 "new",
93 { accessor => undef, data_type => "text", is_nullable => 0 },
94 "lang",
95 { data_type => "varchar", default_value => "", is_nullable => 0, size => 25 },
96 "timestamp",
98 data_type => "timestamp",
99 datetime_undef_if_invalid => 1,
100 default_value => \"current_timestamp",
101 is_nullable => 0,
103 "expirationdate",
104 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
105 "number",
106 { data_type => "integer", is_nullable => 1 },
109 =head1 PRIMARY KEY
111 =over 4
113 =item * L</idnew>
115 =back
117 =cut
119 __PACKAGE__->set_primary_key("idnew");
121 =head1 RELATIONS
123 =head2 branchcode
125 Type: belongs_to
127 Related object: L<Koha::Schema::Result::Branch>
129 =cut
131 __PACKAGE__->belongs_to(
132 "branchcode",
133 "Koha::Schema::Result::Branch",
134 { branchcode => "branchcode" },
136 is_deferrable => 1,
137 join_type => "LEFT",
138 on_delete => "CASCADE",
139 on_update => "CASCADE",
144 # Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-02-16 23:15:22
145 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/q+riAqsYmCQkUCUL9MU7g
148 # You can replace this text with custom content, and it will be preserved on regeneration