Attachment #80849 for bug #14570

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




  data_type: 'mediumtext'
  is_nullable: 1

=head2 guarantorid

  data_type: 'integer'
  is_nullable: 1

=head2 borrowernotes

  data_type: 'longtext'

  { data_type => "mediumtext", is_nullable => 1 },
  "contacttitle",
  { data_type => "mediumtext", is_nullable => 1 },
  "guarantorid",
  { data_type => "integer", is_nullable => 1 },
  "borrowernotes",
  { data_type => "longtext", is_nullable => 1 },
  "relationship",

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

=head2 borrower_relationships_guarantees

Type: has_many

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

=cut

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

=head2 borrower_relationships_guarantors

Type: has_many

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

=cut

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

=head2 branchcode

Type: belongs_to

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


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-10-17 19:00:05
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7tupSyGTfkBlvucK3b+e7A

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




  is_nullable: 1
  size: 255

=head2 contactname

  data_type: 'longtext'
  is_nullable: 1

=head2 contactfirstname

  data_type: 'mediumtext'
  is_nullable: 1

=head2 contacttitle

  data_type: 'mediumtext'
  is_nullable: 1

=head2 guarantorid

  data_type: 'integer'
  is_nullable: 1

=head2 borrowernotes

  data_type: 'longtext'
  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 => "longtext", is_nullable => 1 },
  "contactfirstname",
  { data_type => "mediumtext", is_nullable => 1 },
  "contacttitle",
  { data_type => "mediumtext", is_nullable => 1 },
  "guarantorid",
  { data_type => "integer", is_nullable => 1 },
  "borrowernotes",
  { data_type => "longtext", 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.07046 @ 2018-10-17 19:00:05
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i4vwnuatrQPW3X/T/rtReg


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




  data_type: 'mediumtext'
  is_nullable: 1

=head2 guarantorid

  data_type: 'integer'
  is_nullable: 1

=head2 borrowernotes

  data_type: 'longtext'

  { data_type => "mediumtext", is_nullable => 1 },
  "contacttitle",
  { data_type => "mediumtext", is_nullable => 1 },
  "guarantorid",
  { data_type => "integer", is_nullable => 1 },
  "borrowernotes",
  { data_type => "longtext", is_nullable => 1 },
  "relationship",

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-10-17 19:00:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nLdE751wCr/CSDydnzmGJw


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

Return to bug 14570

Lines 275-285 __PACKAGE__->table("borrowers"); Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-9 / +32 lines)
275	data_type: 'mediumtext'	275	data_type: 'mediumtext'
276	is_nullable: 1	276	is_nullable: 1
277		277
278	=head2 guarantorid
279
280	data_type: 'integer'
281	is_nullable: 1
282
283	=head2 borrowernotes	278	=head2 borrowernotes
284		279
285	data_type: 'longtext'	280	data_type: 'longtext'
Lines 574-581 __PACKAGE__->add_columns( Link Here
574	{ data_type => "mediumtext", is_nullable => 1 },	569	{ data_type => "mediumtext", is_nullable => 1 },
575	"contacttitle",	570	"contacttitle",
576	{ data_type => "mediumtext", is_nullable => 1 },	571	{ data_type => "mediumtext", is_nullable => 1 },
577	"guarantorid",
578	{ data_type => "integer", is_nullable => 1 },
579	"borrowernotes",	572	"borrowernotes",
580	{ data_type => "longtext", is_nullable => 1 },	573	{ data_type => "longtext", is_nullable => 1 },
581	"relationship",	574	"relationship",
Lines 860-865 __PACKAGE__->has_many( Link Here
860	{ cascade_copy => 0, cascade_delete => 0 },	853	{ cascade_copy => 0, cascade_delete => 0 },
861	);	854	);
862		855
		856	=head2 borrower_relationships_guarantees
		857
		858	Type: has_many
		859
		860	Related object: L<Koha::Schema::Result::BorrowerRelationship>
		861
		862	=cut
		863
		864	__PACKAGE__->has_many(
		865	"borrower_relationships_guarantees",
		866	"Koha::Schema::Result::BorrowerRelationship",
		867	{ "foreign.guarantee_id" => "self.borrowernumber" },
		868	{ cascade_copy => 0, cascade_delete => 0 },
		869	);
		870
		871	=head2 borrower_relationships_guarantors
		872
		873	Type: has_many
		874
		875	Related object: L<Koha::Schema::Result::BorrowerRelationship>
		876
		877	=cut
		878
		879	__PACKAGE__->has_many(
		880	"borrower_relationships_guarantors",
		881	"Koha::Schema::Result::BorrowerRelationship",
		882	{ "foreign.guarantor_id" => "self.borrowernumber" },
		883	{ cascade_copy => 0, cascade_delete => 0 },
		884	);
		885
863	=head2 branchcode	886	=head2 branchcode
864		887
865	Type: belongs_to	888	Type: belongs_to
Lines 1416-1423 Composing rels: L</aqorder_users> -> ordernumber Link Here
1416	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1439	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1417		1440
1418		1441
1419	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-20 13:00:20	1442	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-10-17 19:00:05
1420	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QT6EPIG26F/kNK6prauRgw	1443	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7tupSyGTfkBlvucK3b+e7A
1421		1444
1422	__PACKAGE__->add_columns(	1445	__PACKAGE__->add_columns(
1423	'+lost' => { is_boolean => 1 },	1446	'+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: 'longtext'
276	is_nullable: 1
277
278	=head2 contactfirstname
279
280	data_type: 'mediumtext'
281	is_nullable: 1
282
283	=head2 contacttitle
284
285	data_type: 'mediumtext'
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: 'longtext'	275	data_type: 'longtext'
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 535-552 __PACKAGE__->add_columns( Link Here
535	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	509	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
536	"debarredcomment",	510	"debarredcomment",
537	{ data_type => "varchar", is_nullable => 1, size => 255 },	511	{ data_type => "varchar", is_nullable => 1, size => 255 },
538	"contactname",
539	{ data_type => "longtext", is_nullable => 1 },
540	"contactfirstname",
541	{ data_type => "mediumtext", is_nullable => 1 },
542	"contacttitle",
543	{ data_type => "mediumtext", is_nullable => 1 },
544	"guarantorid",
545	{ data_type => "integer", is_nullable => 1 },
546	"borrowernotes",	512	"borrowernotes",
547	{ data_type => "longtext", is_nullable => 1 },	513	{ data_type => "longtext", is_nullable => 1 },
548	"relationship",
549	{ data_type => "varchar", is_nullable => 1, size => 100 },
550	"sex",	514	"sex",
551	{ data_type => "varchar", is_nullable => 1, size => 1 },	515	{ data_type => "varchar", is_nullable => 1, size => 1 },
552	"password",	516	"password",
Lines 610-617 __PACKAGE__->add_columns( Link Here
610	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");	574	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
611		575
612		576
613	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-20 13:00:20	577	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-10-17 19:00:05
614	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qQ0BWngri+79YvK9S8zZPg	578	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i4vwnuatrQPW3X/T/rtReg
615		579
616		580
617	# You can replace this text with custom content, and it will be preserved on regeneration	581	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 273-283 __PACKAGE__->table("deletedborrowers"); Link Here

(-)a/Koha/Schema/Result/Deletedborrower.pm (-10 / +2 lines)
273	data_type: 'mediumtext'	273	data_type: 'mediumtext'
274	is_nullable: 1	274	is_nullable: 1
275		275
276	=head2 guarantorid
277
278	data_type: 'integer'
279	is_nullable: 1
280
281	=head2 borrowernotes	276	=head2 borrowernotes
282		277
283	data_type: 'longtext'	278	data_type: 'longtext'
Lines 559-566 __PACKAGE__->add_columns( Link Here
559	{ data_type => "mediumtext", is_nullable => 1 },	554	{ data_type => "mediumtext", is_nullable => 1 },
560	"contacttitle",	555	"contacttitle",
561	{ data_type => "mediumtext", is_nullable => 1 },	556	{ data_type => "mediumtext", is_nullable => 1 },
562	"guarantorid",
563	{ data_type => "integer", is_nullable => 1 },
564	"borrowernotes",	557	"borrowernotes",
565	{ data_type => "longtext", is_nullable => 1 },	558	{ data_type => "longtext", is_nullable => 1 },
566	"relationship",	559	"relationship",
Lines 641-648 __PACKAGE__->add_columns( Link Here
641	);	634	);
642		635
643		636
644	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	637	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-10-17 19:00:06
645	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DNkNHNcv0lkMH6/seu89hg	638	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nLdE751wCr/CSDydnzmGJw
646		639
647		640
648	# You can replace this text with custom code or comments, and it will be preserved on regeneration	641	# You can replace this text with custom code or comments, and it will be preserved on regeneration
649	-