Attachment #62451 for bug #14570

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




  is_nullable: 1
  size: 255

=head2 contactname

  data_type: 'mediumtext'
  is_nullable: 1

=head2 contactfirstname

  data_type: 'text'
  is_nullable: 1

=head2 contacttitle

  data_type: 'text'
  is_nullable: 1

=head2 guarantorid

  data_type: 'integer'
  is_nullable: 1

=head2 borrowernotes

  data_type: 'mediumtext'
  is_nullable: 1

=head2 relationship

  data_type: 'varchar'
  is_nullable: 1
  size: 100

=head2 sex

  data_type: 'varchar'

  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "debarredcomment",
  { data_type => "varchar", is_nullable => 1, size => 255 },
  "contactname",
  { data_type => "mediumtext", is_nullable => 1 },
  "contactfirstname",
  { data_type => "text", is_nullable => 1 },
  "contacttitle",
  { data_type => "text", is_nullable => 1 },
  "guarantorid",
  { data_type => "integer", is_nullable => 1 },
  "borrowernotes",
  { data_type => "mediumtext", is_nullable => 1 },
  "relationship",
  { data_type => "varchar", is_nullable => 1, size => 100 },
  "sex",
  { data_type => "varchar", is_nullable => 1, size => 1 },
  "password",

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

=head2 relationships_guarantees

Type: has_many

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

=cut

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

=head2 relationships_guarantors

Type: has_many

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

=cut

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

=head2 reserves

Type: has_many

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


# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-18 23:02:13
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cQWHRJh+82G6Bn+R5yn2ig

__PACKAGE__->belongs_to(
    "guarantor",




  is_nullable: 1
  size: 255

=head2 contactname

  data_type: 'mediumtext'
  is_nullable: 1

=head2 contactfirstname

  data_type: 'text'
  is_nullable: 1

=head2 contacttitle

  data_type: 'text'
  is_nullable: 1

=head2 guarantorid

  data_type: 'integer'
  is_nullable: 1

=head2 borrowernotes

  data_type: 'mediumtext'
  is_nullable: 1

=head2 relationship

  data_type: 'varchar'
  is_nullable: 1
  size: 100

=head2 sex

  data_type: 'varchar'

  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "debarredcomment",
  { data_type => "varchar", is_nullable => 1, size => 255 },
  "contactname",
  { data_type => "mediumtext", is_nullable => 1 },
  "contactfirstname",
  { data_type => "text", is_nullable => 1 },
  "contacttitle",
  { data_type => "text", is_nullable => 1 },
  "guarantorid",
  { data_type => "integer", is_nullable => 1 },
  "borrowernotes",
  { data_type => "mediumtext", is_nullable => 1 },
  "relationship",
  { data_type => "varchar", is_nullable => 1, size => 100 },
  "sex",
  { data_type => "varchar", is_nullable => 1, size => 1 },
  "password",

__PACKAGE__->set_primary_key("verification_token", "borrowernumber");


# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-18 23:02:13
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:H1psseFzVAZYCvWtJwrB8w


# You can replace this text with custom content, and it will be preserved on regeneration




  is_nullable: 1
  size: 255

=head2 contactname

  data_type: 'mediumtext'
  is_nullable: 1

=head2 contactfirstname

  data_type: 'text'
  is_nullable: 1

=head2 contacttitle

  data_type: 'text'
  is_nullable: 1

=head2 guarantorid

  data_type: 'integer'
  is_nullable: 1

=head2 borrowernotes

  data_type: 'mediumtext'
  is_nullable: 1

=head2 relationship

  data_type: 'varchar'
  is_nullable: 1
  size: 100

=head2 sex

  data_type: 'varchar'

  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "debarredcomment",
  { data_type => "varchar", is_nullable => 1, size => 255 },
  "contactname",
  { data_type => "mediumtext", is_nullable => 1 },
  "contactfirstname",
  { data_type => "text", is_nullable => 1 },
  "contacttitle",
  { data_type => "text", is_nullable => 1 },
  "guarantorid",
  { data_type => "integer", is_nullable => 1 },
  "borrowernotes",
  { data_type => "mediumtext", is_nullable => 1 },
  "relationship",
  { data_type => "varchar", is_nullable => 1, size => 100 },
  "sex",
  { data_type => "varchar", is_nullable => 1, size => 1 },
  "password",

);


# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-18 23:02:13
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yA+G1XIiCqQQpkd6rPUW/Q


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

Return to bug 14570

Lines 254-290 __PACKAGE__->table("borrowers"); Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-38 / +32 lines)
254	is_nullable: 1	254	is_nullable: 1
255	size: 255	255	size: 255
256		256
257	=head2 contactname
258
259	data_type: 'mediumtext'
260	is_nullable: 1
261
262	=head2 contactfirstname
263
264	data_type: 'text'
265	is_nullable: 1
266
267	=head2 contacttitle
268
269	data_type: 'text'
270	is_nullable: 1
271
272	=head2 guarantorid
273
274	data_type: 'integer'
275	is_nullable: 1
276
277	=head2 borrowernotes	257	=head2 borrowernotes
278		258
279	data_type: 'mediumtext'	259	data_type: 'mediumtext'
280	is_nullable: 1	260	is_nullable: 1
281		261
282	=head2 relationship
283
284	data_type: 'varchar'
285	is_nullable: 1
286	size: 100
287
288	=head2 sex	262	=head2 sex
289		263
290	data_type: 'varchar'	264	data_type: 'varchar'
Lines 547-564 __PACKAGE__->add_columns( Link Here
547	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	521	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
548	"debarredcomment",	522	"debarredcomment",
549	{ data_type => "varchar", is_nullable => 1, size => 255 },	523	{ data_type => "varchar", is_nullable => 1, size => 255 },
550	"contactname",
551	{ data_type => "mediumtext", is_nullable => 1 },
552	"contactfirstname",
553	{ data_type => "text", is_nullable => 1 },
554	"contacttitle",
555	{ data_type => "text", is_nullable => 1 },
556	"guarantorid",
557	{ data_type => "integer", is_nullable => 1 },
558	"borrowernotes",	524	"borrowernotes",
559	{ data_type => "mediumtext", is_nullable => 1 },	525	{ data_type => "mediumtext", is_nullable => 1 },
560	"relationship",
561	{ data_type => "varchar", is_nullable => 1, size => 100 },
562	"sex",	526	"sex",
563	{ data_type => "varchar", is_nullable => 1, size => 1 },	527	{ data_type => "varchar", is_nullable => 1, size => 1 },
564	"password",	528	"password",
Lines 1145-1150 __PACKAGE__->has_many( Link Here
1145	{ cascade_copy => 0, cascade_delete => 0 },	1109	{ cascade_copy => 0, cascade_delete => 0 },
1146	);	1110	);
1147		1111
		1112	=head2 relationships_guarantees
		1113
		1114	Type: has_many
		1115
		1116	Related object: L<Koha::Schema::Result::Relationship>
		1117
		1118	=cut
		1119
		1120	__PACKAGE__->has_many(
		1121	"relationships_guarantees",
		1122	"Koha::Schema::Result::Relationship",
		1123	{ "foreign.guarantee_id" => "self.borrowernumber" },
		1124	{ cascade_copy => 0, cascade_delete => 0 },
		1125	);
		1126
		1127	=head2 relationships_guarantors
		1128
		1129	Type: has_many
		1130
		1131	Related object: L<Koha::Schema::Result::Relationship>
		1132
		1133	=cut
		1134
		1135	__PACKAGE__->has_many(
		1136	"relationships_guarantors",
		1137	"Koha::Schema::Result::Relationship",
		1138	{ "foreign.guarantor_id" => "self.borrowernumber" },
		1139	{ cascade_copy => 0, cascade_delete => 0 },
		1140	);
		1141
1148	=head2 reserves	1142	=head2 reserves
1149		1143
1150	Type: has_many	1144	Type: has_many
Lines 1341-1348 Composing rels: L</aqorder_users> -> ordernumber Link Here
1341	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1335	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1342		1336
1343		1337
1344	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-10 07:30:06	1338	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-18 23:02:13
1345	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:35WEsGd5LmkZ3bB486M1yA	1339	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cQWHRJh+82G6Bn+R5yn2ig
1346		1340
1347	__PACKAGE__->belongs_to(	1341	__PACKAGE__->belongs_to(
1348	"guarantor",	1342	"guarantor",

Lines 264-300 __PACKAGE__->table("borrower_modifications"); Link Here

(-)a/Koha/Schema/Result/BorrowerModification.pm (-38 / +2 lines)
264	is_nullable: 1	264	is_nullable: 1
265	size: 255	265	size: 255
266		266
267	=head2 contactname
268
269	data_type: 'mediumtext'
270	is_nullable: 1
271
272	=head2 contactfirstname
273
274	data_type: 'text'
275	is_nullable: 1
276
277	=head2 contacttitle
278
279	data_type: 'text'
280	is_nullable: 1
281
282	=head2 guarantorid
283
284	data_type: 'integer'
285	is_nullable: 1
286
287	=head2 borrowernotes	267	=head2 borrowernotes
288		268
289	data_type: 'mediumtext'	269	data_type: 'mediumtext'
290	is_nullable: 1	270	is_nullable: 1
291		271
292	=head2 relationship
293
294	data_type: 'varchar'
295	is_nullable: 1
296	size: 100
297
298	=head2 sex	272	=head2 sex
299		273
300	data_type: 'varchar'	274	data_type: 'varchar'
Lines 521-538 __PACKAGE__->add_columns( Link Here
521	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	495	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
522	"debarredcomment",	496	"debarredcomment",
523	{ data_type => "varchar", is_nullable => 1, size => 255 },	497	{ data_type => "varchar", is_nullable => 1, size => 255 },
524	"contactname",
525	{ data_type => "mediumtext", is_nullable => 1 },
526	"contactfirstname",
527	{ data_type => "text", is_nullable => 1 },
528	"contacttitle",
529	{ data_type => "text", is_nullable => 1 },
530	"guarantorid",
531	{ data_type => "integer", is_nullable => 1 },
532	"borrowernotes",	498	"borrowernotes",
533	{ data_type => "mediumtext", is_nullable => 1 },	499	{ data_type => "mediumtext", is_nullable => 1 },
534	"relationship",
535	{ data_type => "varchar", is_nullable => 1, size => 100 },
536	"sex",	500	"sex",
537	{ data_type => "varchar", is_nullable => 1, size => 1 },	501	{ data_type => "varchar", is_nullable => 1, size => 1 },
538	"password",	502	"password",
Lines 590-597 __PACKAGE__->add_columns( Link Here
590	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");	554	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
591		555
592		556
593	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 20:04:12	557	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-18 23:02:13
594	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IZNhBX5Bj+x4S8JCWG+7lA	558	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:H1psseFzVAZYCvWtJwrB8w
595		559
596		560
597	# You can replace this text with custom content, and it will be preserved on regeneration	561	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 252-288 __PACKAGE__->table("deletedborrowers"); Link Here

(-)a/Koha/Schema/Result/Deletedborrower.pm (-39 / +2 lines)
252	is_nullable: 1	252	is_nullable: 1
253	size: 255	253	size: 255
254		254
255	=head2 contactname
256
257	data_type: 'mediumtext'
258	is_nullable: 1
259
260	=head2 contactfirstname
261
262	data_type: 'text'
263	is_nullable: 1
264
265	=head2 contacttitle
266
267	data_type: 'text'
268	is_nullable: 1
269
270	=head2 guarantorid
271
272	data_type: 'integer'
273	is_nullable: 1
274
275	=head2 borrowernotes	255	=head2 borrowernotes
276		256
277	data_type: 'mediumtext'	257	data_type: 'mediumtext'
278	is_nullable: 1	258	is_nullable: 1
279		259
280	=head2 relationship
281
282	data_type: 'varchar'
283	is_nullable: 1
284	size: 100
285
286	=head2 sex	260	=head2 sex
287		261
288	data_type: 'varchar'	262	data_type: 'varchar'
Lines 532-549 __PACKAGE__->add_columns( Link Here
532	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	506	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
533	"debarredcomment",	507	"debarredcomment",
534	{ data_type => "varchar", is_nullable => 1, size => 255 },	508	{ data_type => "varchar", is_nullable => 1, size => 255 },
535	"contactname",
536	{ data_type => "mediumtext", is_nullable => 1 },
537	"contactfirstname",
538	{ data_type => "text", is_nullable => 1 },
539	"contacttitle",
540	{ data_type => "text", is_nullable => 1 },
541	"guarantorid",
542	{ data_type => "integer", is_nullable => 1 },
543	"borrowernotes",	509	"borrowernotes",
544	{ data_type => "mediumtext", is_nullable => 1 },	510	{ data_type => "mediumtext", is_nullable => 1 },
545	"relationship",
546	{ data_type => "varchar", is_nullable => 1, size => 100 },
547	"sex",	511	"sex",
548	{ data_type => "varchar", is_nullable => 1, size => 1 },	512	{ data_type => "varchar", is_nullable => 1, size => 1 },
549	"password",	513	"password",
Lines 611-618 __PACKAGE__->add_columns( Link Here
611	);	575	);
612		576
613		577
614	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-10 07:30:06	578	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-18 23:02:13
615	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tq4JDUSFKuU5K69TTVSkVg	579	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yA+G1XIiCqQQpkd6rPUW/Q
616		580
617		581
618	# You can replace this text with custom code or comments, and it will be preserved on regeneration	582	# You can replace this text with custom code or comments, and it will be preserved on regeneration
619	-