2 package Koha::Schema::Result::SavedSql;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::SavedSql
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<saved_sql>
22 __PACKAGE__->table("saved_sql");
32 unique id and primary key assigned by Koha
39 the staff member who created this report (borrowers.borrowernumber)
44 datetime_undef_if_invalid: 1
47 the date this report was created
52 datetime_undef_if_invalid: 1
55 the date this report was last edited
59 data_type: 'mediumtext'
62 the SQL for this report
67 datetime_undef_if_invalid: 1
73 default_value: (empty string)
77 the name of this report
89 data_type: 'mediumtext'
92 the notes or description given to this report
118 =head2 report_subgroup
131 __PACKAGE__->add_columns(
133 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
135 { data_type => "integer", is_nullable => 1 },
138 data_type => "datetime",
139 datetime_undef_if_invalid => 1,
144 data_type => "datetime",
145 datetime_undef_if_invalid => 1,
149 { data_type => "mediumtext", is_nullable => 1 },
152 data_type => "datetime",
153 datetime_undef_if_invalid => 1,
157 { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
159 { data_type => "varchar", is_nullable => 1, size => 255 },
161 { data_type => "mediumtext", is_nullable => 1 },
163 { data_type => "integer", default_value => 300, is_nullable => 0 },
165 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
167 { data_type => "varchar", is_nullable => 1, size => 6 },
169 { data_type => "varchar", is_nullable => 1, size => 80 },
171 { data_type => "varchar", is_nullable => 1, size => 80 },
173 { data_type => "integer", is_nullable => 1 },
186 __PACKAGE__->set_primary_key("id");
189 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
190 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:198dNG9DGQzop+s5IHy7sw
192 __PACKAGE__->add_columns(
193 '+public' => { is_boolean => 1 }
196 sub koha_object_class {
199 sub koha_objects_class {