data_type: 'varchar'
is_nullable: 1
- size: 16
+ size: 32
=head2 surname
- data_type: 'mediumtext'
- is_nullable: 0
+ data_type: 'longtext'
+ is_nullable: 1
=head2 firstname
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 title
- data_type: 'mediumtext'
+ data_type: 'longtext'
is_nullable: 1
=head2 othernames
- data_type: 'mediumtext'
+ data_type: 'longtext'
is_nullable: 1
=head2 initials
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 streetnumber
=head2 address
- data_type: 'mediumtext'
- is_nullable: 0
+ data_type: 'longtext'
+ is_nullable: 1
=head2 address2
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 city
- data_type: 'mediumtext'
- is_nullable: 0
+ data_type: 'longtext'
+ is_nullable: 1
=head2 state
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 zipcode
=head2 country
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 email
- data_type: 'mediumtext'
+ data_type: 'longtext'
is_nullable: 1
=head2 phone
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 mobile
=head2 fax
- data_type: 'mediumtext'
+ data_type: 'longtext'
is_nullable: 1
=head2 emailpro
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 phonepro
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 B_streetnumber
=head2 B_address2
accessor: 'b_address2'
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 B_city
accessor: 'b_city'
- data_type: 'mediumtext'
+ data_type: 'longtext'
is_nullable: 1
=head2 B_state
accessor: 'b_state'
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 B_zipcode
=head2 B_country
accessor: 'b_country'
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 B_email
accessor: 'b_email'
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 B_phone
accessor: 'b_phone'
- data_type: 'mediumtext'
+ data_type: 'longtext'
is_nullable: 1
=head2 dateofbirth
datetime_undef_if_invalid: 1
is_nullable: 1
+=head2 date_renewed
+
+ data_type: 'date'
+ datetime_undef_if_invalid: 1
+ is_nullable: 1
+
=head2 gonenoaddress
data_type: 'tinyint'
=head2 contactname
- data_type: 'mediumtext'
+ data_type: 'longtext'
is_nullable: 1
=head2 contactfirstname
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 contacttitle
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 guarantorid
=head2 borrowernotes
- data_type: 'mediumtext'
+ data_type: 'longtext'
is_nullable: 1
=head2 relationship
=head2 opacnote
- data_type: 'mediumtext'
+ data_type: 'longtext'
is_nullable: 1
=head2 contactnote
=head2 altcontactstate
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 altcontactzipcode
=head2 altcontactcountry
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 altcontactphone
datetime_undef_if_invalid: 1
is_nullable: 1
+=head2 lang
+
+ data_type: 'varchar'
+ default_value: 'default'
+ is_nullable: 0
+ size: 25
+
+=head2 login_attempts
+
+ data_type: 'integer'
+ default_value: 0
+ is_nullable: 1
+
+=head2 overdrive_auth_token
+
+ data_type: 'mediumtext'
+ is_nullable: 1
+
=cut
__PACKAGE__->add_columns(
"borrowernumber",
{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
"cardnumber",
- { data_type => "varchar", is_nullable => 1, size => 16 },
+ { data_type => "varchar", is_nullable => 1, size => 32 },
"surname",
- { data_type => "mediumtext", is_nullable => 0 },
+ { data_type => "longtext", is_nullable => 1 },
"firstname",
- { data_type => "text", is_nullable => 1 },
- "title",
{ data_type => "mediumtext", is_nullable => 1 },
+ "title",
+ { data_type => "longtext", is_nullable => 1 },
"othernames",
- { data_type => "mediumtext", is_nullable => 1 },
+ { data_type => "longtext", is_nullable => 1 },
"initials",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"streetnumber",
{ data_type => "varchar", is_nullable => 1, size => 10 },
"streettype",
{ data_type => "varchar", is_nullable => 1, size => 50 },
"address",
- { data_type => "mediumtext", is_nullable => 0 },
+ { data_type => "longtext", is_nullable => 1 },
"address2",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"city",
- { data_type => "mediumtext", is_nullable => 0 },
+ { data_type => "longtext", is_nullable => 1 },
"state",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"zipcode",
{ data_type => "varchar", is_nullable => 1, size => 25 },
"country",
- { data_type => "text", is_nullable => 1 },
- "email",
{ data_type => "mediumtext", is_nullable => 1 },
+ "email",
+ { data_type => "longtext", is_nullable => 1 },
"phone",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"mobile",
{ data_type => "varchar", is_nullable => 1, size => 50 },
"fax",
- { data_type => "mediumtext", is_nullable => 1 },
+ { data_type => "longtext", is_nullable => 1 },
"emailpro",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"phonepro",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"B_streetnumber",
{
accessor => "b_streetnumber",
size => 100,
},
"B_address2",
- { accessor => "b_address2", data_type => "text", is_nullable => 1 },
+ { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
"B_city",
- { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
+ { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
"B_state",
- { accessor => "b_state", data_type => "text", is_nullable => 1 },
+ { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
"B_zipcode",
{
accessor => "b_zipcode",
size => 25,
},
"B_country",
- { accessor => "b_country", data_type => "text", is_nullable => 1 },
+ { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
"B_email",
- { accessor => "b_email", data_type => "text", is_nullable => 1 },
+ { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
"B_phone",
- { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
+ { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
"dateofbirth",
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
"branchcode",
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
"dateexpiry",
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
+ "date_renewed",
+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
"gonenoaddress",
{ data_type => "tinyint", is_nullable => 1 },
"lost",
"debarredcomment",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"contactname",
- { data_type => "mediumtext", is_nullable => 1 },
+ { data_type => "longtext", is_nullable => 1 },
"contactfirstname",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"contacttitle",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"guarantorid",
{ data_type => "integer", is_nullable => 1 },
"borrowernotes",
- { data_type => "mediumtext", is_nullable => 1 },
+ { data_type => "longtext", is_nullable => 1 },
"relationship",
{ data_type => "varchar", is_nullable => 1, size => 100 },
"sex",
"userid",
{ data_type => "varchar", is_nullable => 1, size => 75 },
"opacnote",
- { data_type => "mediumtext", is_nullable => 1 },
+ { data_type => "longtext", is_nullable => 1 },
"contactnote",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"sort1",
"altcontactaddress3",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"altcontactstate",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"altcontactzipcode",
{ data_type => "varchar", is_nullable => 1, size => 50 },
"altcontactcountry",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"altcontactphone",
{ data_type => "varchar", is_nullable => 1, size => 50 },
"smsalertnumber",
datetime_undef_if_invalid => 1,
is_nullable => 1,
},
+ "lang",
+ {
+ data_type => "varchar",
+ default_value => "default",
+ is_nullable => 0,
+ size => 25,
+ },
+ "login_attempts",
+ { data_type => "integer", default_value => 0, is_nullable => 1 },
"overdrive_auth_token",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
);
=head1 PRIMARY KEY
{ cascade_copy => 0, cascade_delete => 0 },
);
-=head2 accountoffsets
+=head2 api_keys
Type: has_many
-Related object: L<Koha::Schema::Result::Accountoffset>
+Related object: L<Koha::Schema::Result::ApiKey>
=cut
__PACKAGE__->has_many(
- "accountoffsets",
- "Koha::Schema::Result::Accountoffset",
- { "foreign.borrowernumber" => "self.borrowernumber" },
+ "api_keys",
+ "Koha::Schema::Result::ApiKey",
+ { "foreign.patron_id" => "self.borrowernumber" },
{ cascade_copy => 0, cascade_delete => 0 },
);
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 aqorders
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Aqorder>
+
+=cut
+
+__PACKAGE__->has_many(
+ "aqorders",
+ "Koha::Schema::Result::Aqorder",
+ { "foreign.created_by" => "self.borrowernumber" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 article_requests
Type: has_many
{ cascade_copy => 0, cascade_delete => 0 },
);
-=head2 borrower_syncs
-
-Type: has_many
-
-Related object: L<Koha::Schema::Result::BorrowerSync>
-
-=cut
-
-__PACKAGE__->has_many(
- "borrower_syncs",
- "Koha::Schema::Result::BorrowerSync",
- { "foreign.borrowernumber" => "self.borrowernumber" },
- { cascade_copy => 0, cascade_delete => 0 },
-);
-
=head2 branchcode
Type: belongs_to
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 illcomments
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Illcomment>
+
+=cut
+
+__PACKAGE__->has_many(
+ "illcomments",
+ "Koha::Schema::Result::Illcomment",
+ { "foreign.borrowernumber" => "self.borrowernumber" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
+=head2 illrequests
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Illrequest>
+
+=cut
+
+__PACKAGE__->has_many(
+ "illrequests",
+ "Koha::Schema::Result::Illrequest",
+ { "foreign.borrowernumber" => "self.borrowernumber" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 issues
Type: has_many
{ 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
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-31 10:39:35
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Lc6GQ2E7d+tyzTk3v2sWjQ
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-27 13:16:48
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c3Tb59Kku0Hh+tsVV5eCDg
__PACKAGE__->belongs_to(
"guarantor",
sub koha_objects_class {
'Koha::Patrons';
}
+sub koha_object_class {
+ 'Koha::Patron';
+}
1;