Attachment #76781 for bug #20819

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




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

=head2 patron_consents

Type: has_many

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

=cut

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

=head2 patron_list_patrons

Type: has_many

Lines 415-420 __PACKAGE__->table("borrower_modifications"); Link Here

(-)a/Koha/Schema/Result/BorrowerModification.pm (-2 / +14 lines)
415	data_type: 'mediumtext'	415	data_type: 'mediumtext'
416	is_nullable: 1	416	is_nullable: 1
417		417
		418	=head2 gdpr_proc_consent
		419
		420	data_type: 'datetime'
		421	datetime_undef_if_invalid: 1
		422	is_nullable: 1
		423
418	=cut	424	=cut
419		425
420	__PACKAGE__->add_columns(	426	__PACKAGE__->add_columns(
Lines 581-586 __PACKAGE__->add_columns( Link Here
581	{ data_type => "integer", is_nullable => 1 },	587	{ data_type => "integer", is_nullable => 1 },
582	"extended_attributes",	588	"extended_attributes",
583	{ data_type => "mediumtext", is_nullable => 1 },	589	{ data_type => "mediumtext", is_nullable => 1 },
		590	"gdpr_proc_consent",
		591	{
		592	data_type => "datetime",
		593	datetime_undef_if_invalid => 1,
		594	is_nullable => 1,
		595	},
584	);	596	);
585		597
586	=head1 PRIMARY KEY	598	=head1 PRIMARY KEY
Lines 598-605 __PACKAGE__->add_columns( Link Here
598	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");	610	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
599		611
600		612
601	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	613	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-06-04 14:17:47
602	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vv0bJqR71Ust1MZAkYqTig	614	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NE/d8+g2NbRoj/VCd2ecyg
603		615
604		616
605	# You can replace this text with custom content, and it will be preserved on regeneration	617	# You can replace this text with custom content, and it will be preserved on regeneration




use utf8;
package Koha::Schema::Result::PatronConsent;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::PatronConsent

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<patron_consent>

=cut

__PACKAGE__->table("patron_consent");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=head2 type

  data_type: 'enum'
  extra: {list => ["GDPR_PROCESSING"]}
  is_nullable: 1

=head2 given_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 refused_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=cut

__PACKAGE__->add_columns(
  "id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "borrowernumber",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "type",
  {
    data_type => "enum",
    extra => { list => ["GDPR_PROCESSING"] },
    is_nullable => 1,
  },
  "given_on",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "refused_on",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
);

=head1 PRIMARY KEY

=over 4

=item * L</id>

=back

=cut

__PACKAGE__->set_primary_key("id");

=head1 RELATIONS

=head2 borrowernumber

Type: belongs_to

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

=cut

__PACKAGE__->belongs_to(
  "borrowernumber",
  "Koha::Schema::Result::Borrower",
  { borrowernumber => "borrowernumber" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);


# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-06-04 14:17:47
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rCOHwL/2vlzKAUM517J+HA


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

Return to bug 20819

Lines 1160-1165 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Borrower.pm (+15 lines)
1160	{ cascade_copy => 0, cascade_delete => 0 },	1160	{ cascade_copy => 0, cascade_delete => 0 },
1161	);	1161	);
1162		1162
		1163	=head2 patron_consents
		1164
		1165	Type: has_many
		1166
		1167	Related object: L<Koha::Schema::Result::PatronConsent>
		1168
		1169	=cut
		1170
		1171	__PACKAGE__->has_many(
		1172	"patron_consents",
		1173	"Koha::Schema::Result::PatronConsent",
		1174	{ "foreign.borrowernumber" => "self.borrowernumber" },
		1175	{ cascade_copy => 0, cascade_delete => 0 },
		1176	);
		1177
1163	=head2 patron_list_patrons	1178	=head2 patron_list_patrons
1164		1179
1165	Type: has_many	1180	Type: has_many

Line 0 Link Here

(-)a/Koha/Schema/Result/PatronConsent.pm (-1 / +118 lines)
0	-	1	use utf8;
		2	package Koha::Schema::Result::PatronConsent;
		3
		4	# Created by DBIx::Class::Schema::Loader
		5	# DO NOT MODIFY THE FIRST PART OF THIS FILE
		6
		7	=head1 NAME
		8
		9	Koha::Schema::Result::PatronConsent
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<patron_consent>
		19
		20	=cut
		21
		22	__PACKAGE__->table("patron_consent");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	=head2 borrowernumber
		33
		34	data_type: 'integer'
		35	is_foreign_key: 1
		36	is_nullable: 0
		37
		38	=head2 type
		39
		40	data_type: 'enum'
		41	extra: {list => ["GDPR_PROCESSING"]}
		42	is_nullable: 1
		43
		44	=head2 given_on
		45
		46	data_type: 'datetime'
		47	datetime_undef_if_invalid: 1
		48	is_nullable: 1
		49
		50	=head2 refused_on
		51
		52	data_type: 'datetime'
		53	datetime_undef_if_invalid: 1
		54	is_nullable: 1
		55
		56	=cut
		57
		58	__PACKAGE__->add_columns(
		59	"id",
		60	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
		61	"borrowernumber",
		62	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
		63	"type",
		64	{
		65	data_type => "enum",
66	extra => { list => ["GDPR_PROCESSING"] },
67	is_nullable => 1,
68	},
69	"given_on",
70	{
71	data_type => "datetime",
72	datetime_undef_if_invalid => 1,
73	is_nullable => 1,
74	},
75	"refused_on",
76	{
77	data_type => "datetime",
78	datetime_undef_if_invalid => 1,
79	is_nullable => 1,
80	},
81	);
82
83	=head1 PRIMARY KEY
84
85	=over 4
86
87	=item * L</id>
88
89	=back
90
91	=cut
92
93	__PACKAGE__->set_primary_key("id");
94
95	=head1 RELATIONS
96
97	=head2 borrowernumber
98
99	Type: belongs_to
100
101	Related object: L<Koha::Schema::Result::Borrower>
102
103	=cut
104
105	__PACKAGE__->belongs_to(
106	"borrowernumber",
107	"Koha::Schema::Result::Borrower",
108	{ borrowernumber => "borrowernumber" },
109	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
110	);
111
112
113	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-06-04 14:17:47
114	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rCOHwL/2vlzKAUM517J+HA
115
116
117	# You can replace this text with custom code or comments, and it will be preserved on regeneration
118	1;