Attachment #100524 for bug #4461

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




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 problem_reports

Type: has_many

Related object: L<Koha::Schema::Result::ProblemReport>

=cut

__PACKAGE__->has_many(
  "problem_reports",
  "Koha::Schema::Result::ProblemReport",
  { "foreign.borrowernumber" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 ratings

Type: has_many

__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-11 08:28:15
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+RbSlEZfJCRAxREgz8Ee2A

__PACKAGE__->add_columns(
    '+anonymized'    => { is_boolean => 1 },




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 problem_reports

Type: has_many

Related object: L<Koha::Schema::Result::ProblemReport>

=cut

__PACKAGE__->has_many(
  "problem_reports",
  "Koha::Schema::Result::ProblemReport",
  { "foreign.branchcode" => "self.branchcode" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 repeatable_holidays

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-11 08:28:15
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YmKhbiPGSFOM0DsZu4WdVA

__PACKAGE__->add_columns(
    '+pickup_location' => { is_boolean => 1 }




use utf8;
package Koha::Schema::Result::ProblemReport;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::ProblemReport

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<problem_reports>

=cut

__PACKAGE__->table("problem_reports");

=head1 ACCESSORS

=head2 reportid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 title

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 40

=head2 content

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 255

=head2 borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=head2 branchcode

  data_type: 'varchar'
  default_value: (empty string)
  is_foreign_key: 1
  is_nullable: 0
  size: 10

=head2 username

  data_type: 'varchar'
  is_nullable: 1
  size: 75

=head2 problempage

  data_type: 'varchar'
  is_nullable: 1
  size: 255

=head2 recipient

  data_type: 'enum'
  default_value: 'library'
  extra: {list => ["admin","library"]}
  is_nullable: 0

=head2 created_on

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

=head2 status

  data_type: 'varchar'
  default_value: 'N'
  is_nullable: 0
  size: 1

=cut

__PACKAGE__->add_columns(
  "reportid",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "title",
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 40 },
  "content",
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
  "borrowernumber",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "branchcode",
  {
    data_type => "varchar",
    default_value => "",
    is_foreign_key => 1,
    is_nullable => 0,
    size => 10,
  },
  "username",
  { data_type => "varchar", is_nullable => 1, size => 75 },
  "problempage",
  { data_type => "varchar", is_nullable => 1, size => 255 },
  "recipient",
  {
    data_type => "enum",
    default_value => "library",
    extra => { list => ["admin", "library"] },
    is_nullable => 0,
  },
  "created_on",
  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => \"current_timestamp",
    is_nullable => 0,
  },
  "status",
  { data_type => "varchar", default_value => "N", is_nullable => 0, size => 1 },
);

=head1 PRIMARY KEY

=over 4

=item * L</reportid>

=back

=cut

__PACKAGE__->set_primary_key("reportid");

=head1 RELATIONS

=head2 borrowernumber

Type: belongs_to

Related object: L<Koha::Schema::Result::Borrower>

=cut

__PACKAGE__->belongs_to(
  "borrowernumber",
  "Koha::Schema::Result::Borrower",
  { borrowernumber => "borrowernumber" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

=head2 branchcode

Type: belongs_to

Related object: L<Koha::Schema::Result::Branch>

=cut

__PACKAGE__->belongs_to(
  "branchcode",
  "Koha::Schema::Result::Branch",
  { branchcode => "branchcode" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-11 08:28:15
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qVNVIuurFD6Q6p4YA5Kptg


# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;

Return to bug 4461

Lines 1319-1324 __PACKAGE__->might_have( Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +17 lines)
1319	{ cascade_copy => 0, cascade_delete => 0 },	1319	{ cascade_copy => 0, cascade_delete => 0 },
1320	);	1320	);
1321		1321
		1322	=head2 problem_reports
		1323
		1324	Type: has_many
		1325
		1326	Related object: L<Koha::Schema::Result::ProblemReport>
		1327
		1328	=cut
		1329
		1330	__PACKAGE__->has_many(
		1331	"problem_reports",
		1332	"Koha::Schema::Result::ProblemReport",
		1333	{ "foreign.borrowernumber" => "self.borrowernumber" },
		1334	{ cascade_copy => 0, cascade_delete => 0 },
		1335	);
		1336
1322	=head2 ratings	1337	=head2 ratings
1323		1338
1324	Type: has_many	1339	Type: has_many
Lines 1650-1657 Composing rels: L</aqorder_users> -> ordernumber Link Here
1650	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1665	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1651		1666
1652		1667
1653	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-03 16:19:12	1668	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-11 08:28:15
1654	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+f1QrESEOMGM1coANPgWtQ	1669	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+RbSlEZfJCRAxREgz8Ee2A
1655		1670
1656	__PACKAGE__->add_columns(	1671	__PACKAGE__->add_columns(
1657	'+anonymized' => { is_boolean => 1 },	1672	'+anonymized' => { is_boolean => 1 },

Lines 623-628 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
623	{ cascade_copy => 0, cascade_delete => 0 },	623	{ cascade_copy => 0, cascade_delete => 0 },
624	);	624	);
625		625
		626	=head2 problem_reports
		627
		628	Type: has_many
		629
		630	Related object: L<Koha::Schema::Result::ProblemReport>
		631
		632	=cut
		633
		634	__PACKAGE__->has_many(
		635	"problem_reports",
		636	"Koha::Schema::Result::ProblemReport",
		637	{ "foreign.branchcode" => "self.branchcode" },
		638	{ cascade_copy => 0, cascade_delete => 0 },
		639	);
		640
626	=head2 repeatable_holidays	641	=head2 repeatable_holidays
627		642
628	Type: has_many	643	Type: has_many
Lines 729-736 __PACKAGE__->has_many( Link Here
729	);	744	);
730		745
731		746
732	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-10 09:57:08	747	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-11 08:28:15
733	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:juk2V/100I2EIrxFNhjI7A	748	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YmKhbiPGSFOM0DsZu4WdVA
734		749
735	__PACKAGE__->add_columns(	750	__PACKAGE__->add_columns(
736	'+pickup_location' => { is_boolean => 1 }	751	'+pickup_location' => { is_boolean => 1 }

Line 0 Link Here

(-)a/Koha/Schema/Result/ProblemReport.pm (-1 / +189 lines)
0	-	1	use utf8;
		2	package Koha::Schema::Result::ProblemReport;
		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::ProblemReport
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<problem_reports>
		19
		20	=cut
		21
		22	__PACKAGE__->table("problem_reports");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 reportid
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	=head2 title
		33
		34	data_type: 'varchar'
		35	default_value: (empty string)
		36	is_nullable: 0
		37	size: 40
		38
		39	=head2 content
		40
		41	data_type: 'varchar'
		42	default_value: (empty string)
		43	is_nullable: 0
		44	size: 255
		45
		46	=head2 borrowernumber
		47
		48	data_type: 'integer'
		49	is_foreign_key: 1
		50	is_nullable: 1
		51
		52	=head2 branchcode
		53
		54	data_type: 'varchar'
		55	default_value: (empty string)
		56	is_foreign_key: 1
		57	is_nullable: 0
		58	size: 10
		59
		60	=head2 username
		61
		62	data_type: 'varchar'
		63	is_nullable: 1
		64	size: 75
		65
66	=head2 problempage
67
68	data_type: 'varchar'
69	is_nullable: 1
70	size: 255
71
72	=head2 recipient
73
74	data_type: 'enum'
75	default_value: 'library'
76	extra: {list => ["admin","library"]}
77	is_nullable: 0
78
79	=head2 created_on
80
81	data_type: 'timestamp'
82	datetime_undef_if_invalid: 1
83	default_value: current_timestamp
84	is_nullable: 0
85
86	=head2 status
87
88	data_type: 'varchar'
89	default_value: 'N'
90	is_nullable: 0
91	size: 1
92
93	=cut
94
95	__PACKAGE__->add_columns(
96	"reportid",
97	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
98	"title",
99	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 40 },
100	"content",
101	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
102	"borrowernumber",
103	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
104	"branchcode",
105	{
106	data_type => "varchar",
107	default_value => "",
108	is_foreign_key => 1,
109	is_nullable => 0,
110	size => 10,
111	},
112	"username",
113	{ data_type => "varchar", is_nullable => 1, size => 75 },
114	"problempage",
115	{ data_type => "varchar", is_nullable => 1, size => 255 },
116	"recipient",
117	{
118	data_type => "enum",
119	default_value => "library",
120	extra => { list => ["admin", "library"] },
121	is_nullable => 0,
122	},
123	"created_on",
124	{
125	data_type => "timestamp",
126	datetime_undef_if_invalid => 1,
127	default_value => \"current_timestamp",
128	is_nullable => 0,
129	},
130	"status",
131	{ data_type => "varchar", default_value => "N", is_nullable => 0, size => 1 },
132	);
133
134	=head1 PRIMARY KEY
135
136	=over 4
137
138	=item * L</reportid>
139
140	=back
141
142	=cut
143
144	__PACKAGE__->set_primary_key("reportid");
145
146	=head1 RELATIONS
147
148	=head2 borrowernumber
149
150	Type: belongs_to
151
152	Related object: L<Koha::Schema::Result::Borrower>
153
154	=cut
155
156	__PACKAGE__->belongs_to(
157	"borrowernumber",
158	"Koha::Schema::Result::Borrower",
159	{ borrowernumber => "borrowernumber" },
160	{
161	is_deferrable => 1,
162	join_type => "LEFT",
163	on_delete => "CASCADE",
164	on_update => "CASCADE",
165	},
166	);
167
168	=head2 branchcode
169
170	Type: belongs_to
171
172	Related object: L<Koha::Schema::Result::Branch>
173
174	=cut
175
176	__PACKAGE__->belongs_to(
177	"branchcode",
178	"Koha::Schema::Result::Branch",
179	{ branchcode => "branchcode" },
180	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
181	);
182
183
184	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-11 08:28:15
185	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qVNVIuurFD6Q6p4YA5Kptg
186
187
188	# You can replace this text with custom code or comments, and it will be preserved on regeneration
189	1;