Koha/Schema/Result/SavedSql.pm

   1 use utf8;
   2 package Koha::Schema::Result::SavedSql;
   3
   4 # Created by DBIx::Class::Schema::Loader
   5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
   6
   7 =head1 NAME
   8
   9 Koha::Schema::Result::SavedSql
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<saved_sql>
  19
  20 =cut
  21
  22 __PACKAGE__->table("saved_sql");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 id
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 =head2 borrowernumber
  33
  34   data_type: 'integer'
  35   is_nullable: 1
  36
  37 =head2 date_created
  38
  39   data_type: 'datetime'
  40   datetime_undef_if_invalid: 1
  41   is_nullable: 1
  42
  43 =head2 last_modified
  44
  45   data_type: 'datetime'
  46   datetime_undef_if_invalid: 1
  47   is_nullable: 1
  48
  49 =head2 savedsql
  50
  51   data_type: 'mediumtext'
  52   is_nullable: 1
  53
  54 =head2 last_run
  55
  56   data_type: 'datetime'
  57   datetime_undef_if_invalid: 1
  58   is_nullable: 1
  59
  60 =head2 report_name
  61
  62   data_type: 'varchar'
  63   default_value: (empty string)
  64   is_nullable: 0
  65   size: 255
  66
  67 =head2 type
  68
  69   data_type: 'varchar'
  70   is_nullable: 1
  71   size: 255
  72
  73 =head2 notes
  74
  75   data_type: 'mediumtext'
  76   is_nullable: 1
  77
  78 =head2 cache_expiry
  79
  80   data_type: 'integer'
  81   default_value: 300
  82   is_nullable: 0
  83
  84 =head2 public
  85
  86   data_type: 'tinyint'
  87   default_value: 0
  88   is_nullable: 0
  89
  90 =head2 report_area
  91
  92   data_type: 'varchar'
  93   is_nullable: 1
  94   size: 6
  95
  96 =head2 report_group
  97
  98   data_type: 'varchar'
  99   is_nullable: 1
 100   size: 80
 101
 102 =head2 report_subgroup
 103
 104   data_type: 'varchar'
 105   is_nullable: 1
 106   size: 80
 107
 108 =head2 mana_id
 109
 110   data_type: 'integer'
 111   is_nullable: 1
 112
 113 =cut
 114
 115 __PACKAGE__->add_columns(
 116   "id",
 117   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 118   "borrowernumber",
 119   { data_type => "integer", is_nullable => 1 },
 120   "date_created",
 121   {
 122     data_type => "datetime",
 123     datetime_undef_if_invalid => 1,
 124     is_nullable => 1,
 125   },
 126   "last_modified",
 127   {
 128     data_type => "datetime",
 129     datetime_undef_if_invalid => 1,
 130     is_nullable => 1,
 131   },
 132   "savedsql",
 133   { data_type => "mediumtext", is_nullable => 1 },
 134   "last_run",
 135   {
 136     data_type => "datetime",
 137     datetime_undef_if_invalid => 1,
 138     is_nullable => 1,
 139   },
 140   "report_name",
 141   { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
 142   "type",
 143   { data_type => "varchar", is_nullable => 1, size => 255 },
 144   "notes",
 145   { data_type => "mediumtext", is_nullable => 1 },
 146   "cache_expiry",
 147   { data_type => "integer", default_value => 300, is_nullable => 0 },
 148   "public",
 149   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 150   "report_area",
 151   { data_type => "varchar", is_nullable => 1, size => 6 },
 152   "report_group",
 153   { data_type => "varchar", is_nullable => 1, size => 80 },
 154   "report_subgroup",
 155   { data_type => "varchar", is_nullable => 1, size => 80 },
 156   "mana_id",
 157   { data_type => "integer", is_nullable => 1 },
 158 );
 159
 160 =head1 PRIMARY KEY
 161
 162 =over 4
 163
 164 =item * L</id>
 165
 166 =back
 167
 168 =cut
 169
 170 __PACKAGE__->set_primary_key("id");
 171
 172
 173 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-23 12:56:39
 174 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f7wxGGnBk3z6mw2CkaeD9A
 175
 176 __PACKAGE__->add_columns(
 177     '+public' => { is_boolean => 1 }
 178 );
 179
 180 sub koha_object_class {
 181     'Koha::Report';
 182 }
 183 sub koha_objects_class {
 184     'Koha::Reports';
 185 }
 186
 187 1;