Attachment #58146 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 @ 2016-12-12 16:31:58
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gDowcouH821/r88EUCdq9Q

__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 @ 2016-12-12 16:31:58
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ASoLkpLc0w2j8MRLFmCeIw


# 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 @ 2016-12-12 16:31:58
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aww4S4vMbSwAvHi2GJW7AA


# 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 542-559 __PACKAGE__->add_columns( Link Here
542	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	516	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
543	"debarredcomment",	517	"debarredcomment",
544	{ data_type => "varchar", is_nullable => 1, size => 255 },	518	{ data_type => "varchar", is_nullable => 1, size => 255 },
545	"contactname",
546	{ data_type => "mediumtext", is_nullable => 1 },
547	"contactfirstname",
548	{ data_type => "text", is_nullable => 1 },
549	"contacttitle",
550	{ data_type => "text", is_nullable => 1 },
551	"guarantorid",
552	{ data_type => "integer", is_nullable => 1 },
553	"borrowernotes",	519	"borrowernotes",
554	{ data_type => "mediumtext", is_nullable => 1 },	520	{ data_type => "mediumtext", is_nullable => 1 },
555	"relationship",
556	{ data_type => "varchar", is_nullable => 1, size => 100 },
557	"sex",	521	"sex",
558	{ data_type => "varchar", is_nullable => 1, size => 1 },	522	{ data_type => "varchar", is_nullable => 1, size => 1 },
559	"password",	523	"password",
Lines 1138-1143 __PACKAGE__->has_many( Link Here
1138	{ cascade_copy => 0, cascade_delete => 0 },	1102	{ cascade_copy => 0, cascade_delete => 0 },
1139	);	1103	);
1140		1104
		1105	=head2 relationships_guarantees
		1106
		1107	Type: has_many
		1108
		1109	Related object: L<Koha::Schema::Result::Relationship>
		1110
		1111	=cut
		1112
		1113	__PACKAGE__->has_many(
		1114	"relationships_guarantees",
		1115	"Koha::Schema::Result::Relationship",
		1116	{ "foreign.guarantee_id" => "self.borrowernumber" },
		1117	{ cascade_copy => 0, cascade_delete => 0 },
		1118	);
		1119
		1120	=head2 relationships_guarantors
		1121
		1122	Type: has_many
		1123
		1124	Related object: L<Koha::Schema::Result::Relationship>
		1125
		1126	=cut
		1127
		1128	__PACKAGE__->has_many(
		1129	"relationships_guarantors",
		1130	"Koha::Schema::Result::Relationship",
		1131	{ "foreign.guarantor_id" => "self.borrowernumber" },
		1132	{ cascade_copy => 0, cascade_delete => 0 },
		1133	);
		1134
1141	=head2 reserves	1135	=head2 reserves
1142		1136
1143	Type: has_many	1137	Type: has_many
Lines 1334-1341 Composing rels: L</aqorder_users> -> ordernumber Link Here
1334	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1328	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1335		1329
1336		1330
1337	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-31 10:39:35	1331	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 16:31:58
1338	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Lc6GQ2E7d+tyzTk3v2sWjQ	1332	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gDowcouH821/r88EUCdq9Q
1339		1333
1340	__PACKAGE__->belongs_to(	1334	__PACKAGE__->belongs_to(
1341	"guarantor",	1335	"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 516-533 __PACKAGE__->add_columns( Link Here
516	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	490	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
517	"debarredcomment",	491	"debarredcomment",
518	{ data_type => "varchar", is_nullable => 1, size => 255 },	492	{ data_type => "varchar", is_nullable => 1, size => 255 },
519	"contactname",
520	{ data_type => "mediumtext", is_nullable => 1 },
521	"contactfirstname",
522	{ data_type => "text", is_nullable => 1 },
523	"contacttitle",
524	{ data_type => "text", is_nullable => 1 },
525	"guarantorid",
526	{ data_type => "integer", is_nullable => 1 },
527	"borrowernotes",	493	"borrowernotes",
528	{ data_type => "mediumtext", is_nullable => 1 },	494	{ data_type => "mediumtext", is_nullable => 1 },
529	"relationship",
530	{ data_type => "varchar", is_nullable => 1, size => 100 },
531	"sex",	495	"sex",
532	{ data_type => "varchar", is_nullable => 1, size => 1 },	496	{ data_type => "varchar", is_nullable => 1, size => 1 },
533	"password",	497	"password",
Lines 583-590 __PACKAGE__->add_columns( Link Here
583	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");	547	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
584		548
585		549
586	# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-10-06 10:38:42	550	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 16:31:58
587	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vZ9XjkjQv0q6l2kW3KMsLg	551	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ASoLkpLc0w2j8MRLFmCeIw
588		552
589		553
590	# You can replace this text with custom content, and it will be preserved on regeneration	554	# 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 527-544 __PACKAGE__->add_columns( Link Here
527	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	501	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
528	"debarredcomment",	502	"debarredcomment",
529	{ data_type => "varchar", is_nullable => 1, size => 255 },	503	{ data_type => "varchar", is_nullable => 1, size => 255 },
530	"contactname",
531	{ data_type => "mediumtext", is_nullable => 1 },
532	"contactfirstname",
533	{ data_type => "text", is_nullable => 1 },
534	"contacttitle",
535	{ data_type => "text", is_nullable => 1 },
536	"guarantorid",
537	{ data_type => "integer", is_nullable => 1 },
538	"borrowernotes",	504	"borrowernotes",
539	{ data_type => "mediumtext", is_nullable => 1 },	505	{ data_type => "mediumtext", is_nullable => 1 },
540	"relationship",
541	{ data_type => "varchar", is_nullable => 1, size => 100 },
542	"sex",	506	"sex",
543	{ data_type => "varchar", is_nullable => 1, size => 1 },	507	{ data_type => "varchar", is_nullable => 1, size => 1 },
544	"password",	508	"password",
Lines 604-611 __PACKAGE__->add_columns( Link Here
604	);	568	);
605		569
606		570
607	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-09-13 17:32:29	571	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 16:31:58
608	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pcdyzQacTbFDJ9R1k0E8mA	572	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aww4S4vMbSwAvHi2GJW7AA
609		573
610		574
611	# You can replace this text with custom code or comments, and it will be preserved on regeneration	575	# You can replace this text with custom code or comments, and it will be preserved on regeneration
612	-