Attachment #71161 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 @ 2018-02-02 18:06:00
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2A/rG4CezUzUbGb/zBZ2kg

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




  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 @ 2018-02-02 18:06:00
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yXBCiydR72Ko5AgJN5fNZg


# 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 @ 2018-02-02 18:06:00
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KBg6ZIlzc1pcfTVMNDmI4Q


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

Return to bug 14570

Lines 260-296 __PACKAGE__->table("borrowers"); Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-38 / +32 lines)
260	is_nullable: 1	260	is_nullable: 1
261	size: 255	261	size: 255
262		262
263	=head2 contactname
264
265	data_type: 'mediumtext'
266	is_nullable: 1
267
268	=head2 contactfirstname
269
270	data_type: 'text'
271	is_nullable: 1
272
273	=head2 contacttitle
274
275	data_type: 'text'
276	is_nullable: 1
277
278	=head2 guarantorid
279
280	data_type: 'integer'
281	is_nullable: 1
282
283	=head2 borrowernotes	263	=head2 borrowernotes
284		264
285	data_type: 'mediumtext'	265	data_type: 'mediumtext'
286	is_nullable: 1	266	is_nullable: 1
287		267
288	=head2 relationship
289
290	data_type: 'varchar'
291	is_nullable: 1
292	size: 100
293
294	=head2 sex	268	=head2 sex
295		269
296	data_type: 'varchar'	270	data_type: 'varchar'
Lines 568-585 __PACKAGE__->add_columns( Link Here
568	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	542	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
569	"debarredcomment",	543	"debarredcomment",
570	{ data_type => "varchar", is_nullable => 1, size => 255 },	544	{ data_type => "varchar", is_nullable => 1, size => 255 },
571	"contactname",
572	{ data_type => "mediumtext", is_nullable => 1 },
573	"contactfirstname",
574	{ data_type => "text", is_nullable => 1 },
575	"contacttitle",
576	{ data_type => "text", is_nullable => 1 },
577	"guarantorid",
578	{ data_type => "integer", is_nullable => 1 },
579	"borrowernotes",	545	"borrowernotes",
580	{ data_type => "mediumtext", is_nullable => 1 },	546	{ data_type => "mediumtext", is_nullable => 1 },
581	"relationship",
582	{ data_type => "varchar", is_nullable => 1, size => 100 },
583	"sex",	547	"sex",
584	{ data_type => "varchar", is_nullable => 1, size => 1 },	548	{ data_type => "varchar", is_nullable => 1, size => 1 },
585	"password",	549	"password",
Lines 1190-1195 __PACKAGE__->has_many( Link Here
1190	{ cascade_copy => 0, cascade_delete => 0 },	1154	{ cascade_copy => 0, cascade_delete => 0 },
1191	);	1155	);
1192		1156
		1157	=head2 relationships_guarantees
		1158
		1159	Type: has_many
		1160
		1161	Related object: L<Koha::Schema::Result::Relationship>
		1162
		1163	=cut
		1164
		1165	__PACKAGE__->has_many(
		1166	"relationships_guarantees",
		1167	"Koha::Schema::Result::Relationship",
		1168	{ "foreign.guarantee_id" => "self.borrowernumber" },
		1169	{ cascade_copy => 0, cascade_delete => 0 },
		1170	);
		1171
		1172	=head2 relationships_guarantors
		1173
		1174	Type: has_many
		1175
		1176	Related object: L<Koha::Schema::Result::Relationship>
		1177
		1178	=cut
		1179
		1180	__PACKAGE__->has_many(
		1181	"relationships_guarantors",
		1182	"Koha::Schema::Result::Relationship",
		1183	{ "foreign.guarantor_id" => "self.borrowernumber" },
		1184	{ cascade_copy => 0, cascade_delete => 0 },
		1185	);
		1186
1193	=head2 reserves	1187	=head2 reserves
1194		1188
1195	Type: has_many	1189	Type: has_many
Lines 1386-1393 Composing rels: L</aqorder_users> -> ordernumber Link Here
1386	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1380	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1387		1381
1388		1382
1389	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-11-09 11:42:45	1383	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-02 18:06:00
1390	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UitEC1xK/a76Ff4ZCS2BKA	1384	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2A/rG4CezUzUbGb/zBZ2kg
1391		1385
1392	__PACKAGE__->add_columns(	1386	__PACKAGE__->add_columns(
1393	'+lost' => { is_boolean => 1 },	1387	'+lost' => { is_boolean => 1 },

Lines 270-306 __PACKAGE__->table("borrower_modifications"); Link Here

(-)a/Koha/Schema/Result/BorrowerModification.pm (-38 / +2 lines)
270	is_nullable: 1	270	is_nullable: 1
271	size: 255	271	size: 255
272		272
273	=head2 contactname
274
275	data_type: 'mediumtext'
276	is_nullable: 1
277
278	=head2 contactfirstname
279
280	data_type: 'text'
281	is_nullable: 1
282
283	=head2 contacttitle
284
285	data_type: 'text'
286	is_nullable: 1
287
288	=head2 guarantorid
289
290	data_type: 'integer'
291	is_nullable: 1
292
293	=head2 borrowernotes	273	=head2 borrowernotes
294		274
295	data_type: 'mediumtext'	275	data_type: 'mediumtext'
296	is_nullable: 1	276	is_nullable: 1
297		277
298	=head2 relationship
299
300	data_type: 'varchar'
301	is_nullable: 1
302	size: 100
303
304	=head2 sex	278	=head2 sex
305		279
306	data_type: 'varchar'	280	data_type: 'varchar'
Lines 529-546 __PACKAGE__->add_columns( Link Here
529	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	503	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
530	"debarredcomment",	504	"debarredcomment",
531	{ data_type => "varchar", is_nullable => 1, size => 255 },	505	{ data_type => "varchar", is_nullable => 1, size => 255 },
532	"contactname",
533	{ data_type => "mediumtext", is_nullable => 1 },
534	"contactfirstname",
535	{ data_type => "text", is_nullable => 1 },
536	"contacttitle",
537	{ data_type => "text", is_nullable => 1 },
538	"guarantorid",
539	{ data_type => "integer", is_nullable => 1 },
540	"borrowernotes",	506	"borrowernotes",
541	{ data_type => "mediumtext", is_nullable => 1 },	507	{ data_type => "mediumtext", is_nullable => 1 },
542	"relationship",
543	{ data_type => "varchar", is_nullable => 1, size => 100 },
544	"sex",	508	"sex",
545	{ data_type => "varchar", is_nullable => 1, size => 1 },	509	{ data_type => "varchar", is_nullable => 1, size => 1 },
546	"password",	510	"password",
Lines 598-605 __PACKAGE__->add_columns( Link Here
598	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");	562	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
599		563
600		564
601	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-27 13:24:06	565	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-02 18:06:00
602	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PUS/k4r20connTfZWAWmxg	566	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yXBCiydR72Ko5AgJN5fNZg
603		567
604		568
605	# You can replace this text with custom content, and it will be preserved on regeneration	569	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 258-294 __PACKAGE__->table("deletedborrowers"); Link Here

(-)a/Koha/Schema/Result/Deletedborrower.pm (-39 / +2 lines)
258	is_nullable: 1	258	is_nullable: 1
259	size: 255	259	size: 255
260		260
261	=head2 contactname
262
263	data_type: 'mediumtext'
264	is_nullable: 1
265
266	=head2 contactfirstname
267
268	data_type: 'text'
269	is_nullable: 1
270
271	=head2 contacttitle
272
273	data_type: 'text'
274	is_nullable: 1
275
276	=head2 guarantorid
277
278	data_type: 'integer'
279	is_nullable: 1
280
281	=head2 borrowernotes	261	=head2 borrowernotes
282		262
283	data_type: 'mediumtext'	263	data_type: 'mediumtext'
284	is_nullable: 1	264	is_nullable: 1
285		265
286	=head2 relationship
287
288	data_type: 'varchar'
289	is_nullable: 1
290	size: 100
291
292	=head2 sex	266	=head2 sex
293		267
294	data_type: 'varchar'	268	data_type: 'varchar'
Lines 553-570 __PACKAGE__->add_columns( Link Here
553	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	527	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
554	"debarredcomment",	528	"debarredcomment",
555	{ data_type => "varchar", is_nullable => 1, size => 255 },	529	{ data_type => "varchar", is_nullable => 1, size => 255 },
556	"contactname",
557	{ data_type => "mediumtext", is_nullable => 1 },
558	"contactfirstname",
559	{ data_type => "text", is_nullable => 1 },
560	"contacttitle",
561	{ data_type => "text", is_nullable => 1 },
562	"guarantorid",
563	{ data_type => "integer", is_nullable => 1 },
564	"borrowernotes",	530	"borrowernotes",
565	{ data_type => "mediumtext", is_nullable => 1 },	531	{ data_type => "mediumtext", is_nullable => 1 },
566	"relationship",
567	{ data_type => "varchar", is_nullable => 1, size => 100 },
568	"sex",	532	"sex",
569	{ data_type => "varchar", is_nullable => 1, size => 1 },	533	{ data_type => "varchar", is_nullable => 1, size => 1 },
570	"password",	534	"password",
Lines 641-648 __PACKAGE__->add_columns( Link Here
641	);	605	);
642		606
643		607
644	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-27 13:24:06	608	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-02 18:06:00
645	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LZK8S3YPK3zZAhH28j8gng	609	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KBg6ZIlzc1pcfTVMNDmI4Q
646		610
647		611
648	# You can replace this text with custom code or comments, and it will be preserved on regeneration	612	# You can replace this text with custom code or comments, and it will be preserved on regeneration
649	-