Attachment #58835 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 @ 2017-01-09 16:20:34
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MlntmtWrUZQhQs5K9xCH8w


# 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 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-01-09 16:20:34
594	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IZNhBX5Bj+x4S8JCWG+7lA	558	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MlntmtWrUZQhQs5K9xCH8w
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 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	-