View | Details | Raw Unified | Return to bug 8628
Collapse All | Expand All

(-)a/Koha/Schema/Result/SavedSql.pm (-2 / +19 lines)
Lines 169-177 __PACKAGE__->add_columns( Link Here
169
169
170
__PACKAGE__->set_primary_key("id");
170
__PACKAGE__->set_primary_key("id");
171
171
172
=head1 RELATIONS
172
173
173
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-23 12:56:39
174
=head2 sign_streams
174
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f7wxGGnBk3z6mw2CkaeD9A
175
176
Type: has_many
177
178
Related object: L<Koha::Schema::Result::SignStream>
179
180
=cut
181
182
__PACKAGE__->has_many(
183
  "sign_streams",
184
  "Koha::Schema::Result::SignStream",
185
  { "foreign.saved_sql_id" => "self.id" },
186
  { cascade_copy => 0, cascade_delete => 0 },
187
);
188
189
190
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-04-23 22:14:56
191
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:49NVnmBe/cLc8xLJ2UFmpw
175
192
176
sub koha_object_class {
193
sub koha_object_class {
177
    'Koha::Report';
194
    'Koha::Report';
(-)a/Koha/Schema/Result/Sign.pm (+132 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::Sign;
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::Sign
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<signs>
19
20
=cut
21
22
__PACKAGE__->table("signs");
23
24
=head1 ACCESSORS
25
26
=head2 sign_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 name
33
34
  data_type: 'varchar'
35
  is_nullable: 1
36
  size: 64
37
38
=head2 webapp
39
40
  data_type: 'integer'
41
  default_value: 0
42
  is_nullable: 0
43
44
=head2 transition
45
46
  data_type: 'char'
47
  default_value: 'none'
48
  is_nullable: 0
49
  size: 16
50
51
=head2 swatch
52
53
  data_type: 'char'
54
  default_value: (empty string)
55
  is_nullable: 0
56
  size: 1
57
58
=head2 idleafter
59
60
  data_type: 'integer'
61
  default_value: 0
62
  is_nullable: 0
63
64
=head2 pagedelay
65
66
  data_type: 'integer'
67
  default_value: 0
68
  is_nullable: 0
69
70
=head2 reloadafter
71
72
  data_type: 'integer'
73
  default_value: 0
74
  is_nullable: 0
75
76
=cut
77
78
__PACKAGE__->add_columns(
79
  "sign_id",
80
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
81
  "name",
82
  { data_type => "varchar", is_nullable => 1, size => 64 },
83
  "webapp",
84
  { data_type => "integer", default_value => 0, is_nullable => 0 },
85
  "transition",
86
  { data_type => "char", default_value => "none", is_nullable => 0, size => 16 },
87
  "swatch",
88
  { data_type => "char", default_value => "", is_nullable => 0, size => 1 },
89
  "idleafter",
90
  { data_type => "integer", default_value => 0, is_nullable => 0 },
91
  "pagedelay",
92
  { data_type => "integer", default_value => 0, is_nullable => 0 },
93
  "reloadafter",
94
  { data_type => "integer", default_value => 0, is_nullable => 0 },
95
);
96
97
=head1 PRIMARY KEY
98
99
=over 4
100
101
=item * L</sign_id>
102
103
=back
104
105
=cut
106
107
__PACKAGE__->set_primary_key("sign_id");
108
109
=head1 RELATIONS
110
111
=head2 signs_to_streams
112
113
Type: has_many
114
115
Related object: L<Koha::Schema::Result::SignsToStream>
116
117
=cut
118
119
__PACKAGE__->has_many(
120
  "signs_to_streams",
121
  "Koha::Schema::Result::SignsToStream",
122
  { "foreign.sign_id" => "self.sign_id" },
123
  { cascade_copy => 0, cascade_delete => 0 },
124
);
125
126
127
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-04-23 22:14:56
128
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sPXDFstwvROyMN0guYnQiA
129
130
131
# You can replace this text with custom code or comments, and it will be preserved on regeneration
132
1;
(-)a/Koha/Schema/Result/SignStream.pm (+105 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::SignStream;
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::SignStream
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<sign_streams>
19
20
=cut
21
22
__PACKAGE__->table("sign_streams");
23
24
=head1 ACCESSORS
25
26
=head2 sign_stream_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 saved_sql_id
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
38
=head2 name
39
40
  data_type: 'varchar'
41
  is_nullable: 1
42
  size: 64
43
44
=cut
45
46
__PACKAGE__->add_columns(
47
  "sign_stream_id",
48
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
49
  "saved_sql_id",
50
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
51
  "name",
52
  { data_type => "varchar", is_nullable => 1, size => 64 },
53
);
54
55
=head1 PRIMARY KEY
56
57
=over 4
58
59
=item * L</sign_stream_id>
60
61
=back
62
63
=cut
64
65
__PACKAGE__->set_primary_key("sign_stream_id");
66
67
=head1 RELATIONS
68
69
=head2 saved_sql
70
71
Type: belongs_to
72
73
Related object: L<Koha::Schema::Result::SavedSql>
74
75
=cut
76
77
__PACKAGE__->belongs_to(
78
  "saved_sql",
79
  "Koha::Schema::Result::SavedSql",
80
  { id => "saved_sql_id" },
81
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
82
);
83
84
=head2 signs_to_streams
85
86
Type: has_many
87
88
Related object: L<Koha::Schema::Result::SignsToStream>
89
90
=cut
91
92
__PACKAGE__->has_many(
93
  "signs_to_streams",
94
  "Koha::Schema::Result::SignsToStream",
95
  { "foreign.sign_stream_id" => "self.sign_stream_id" },
96
  { cascade_copy => 0, cascade_delete => 0 },
97
);
98
99
100
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-04-23 22:14:56
101
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k94lZfT0zHEvDtc4GPWQKQ
102
103
104
# You can replace this text with custom code or comments, and it will be preserved on regeneration
105
1;
(-)a/Koha/Schema/Result/SignsToStream.pm (-1 / +114 lines)
Line 0 Link Here
0
- 
1
use utf8;
2
package Koha::Schema::Result::SignsToStream;
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::SignsToStream
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<signs_to_streams>
19
20
=cut
21
22
__PACKAGE__->table("signs_to_streams");
23
24
=head1 ACCESSORS
25
26
=head2 sign_to_stream_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 sign_stream_id
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
38
=head2 sign_id
39
40
  data_type: 'integer'
41
  is_foreign_key: 1
42
  is_nullable: 0
43
44
=head2 params
45
46
  data_type: 'varchar'
47
  default_value: (empty string)
48
  is_nullable: 0
49
  size: 255
50
51
=cut
52
53
__PACKAGE__->add_columns(
54
  "sign_to_stream_id",
55
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
56
  "sign_stream_id",
57
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
58
  "sign_id",
59
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
60
  "params",
61
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
62
);
63
64
=head1 PRIMARY KEY
65
66
=over 4
67
68
=item * L</sign_to_stream_id>
69
70
=back
71
72
=cut
73
74
__PACKAGE__->set_primary_key("sign_to_stream_id");
75
76
=head1 RELATIONS
77
78
=head2 sign
79
80
Type: belongs_to
81
82
Related object: L<Koha::Schema::Result::Sign>
83
84
=cut
85
86
__PACKAGE__->belongs_to(
87
  "sign",
88
  "Koha::Schema::Result::Sign",
89
  { sign_id => "sign_id" },
90
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
91
);
92
93
=head2 sign_stream
94
95
Type: belongs_to
96
97
Related object: L<Koha::Schema::Result::SignStream>
98
99
=cut
100
101
__PACKAGE__->belongs_to(
102
  "sign_stream",
103
  "Koha::Schema::Result::SignStream",
104
  { sign_stream_id => "sign_stream_id" },
105
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
106
);
107
108
109
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-04-23 22:14:56
110
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I8v4LIKe5HxaemotFqXI6A
111
112
113
# You can replace this text with custom code or comments, and it will be preserved on regeneration
114
1;

Return to bug 8628