From f3d7de28f274296389a2665847434d1becc44339 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 4 Aug 2017 08:46:51 +0200 Subject: [PATCH] Bug 6758: DBIx schema changes Content-Type: text/plain; charset=utf-8 Signed-off-by: Marcel de Rooy --- Koha/Schema/Result/Borrower.pm | 28 ++++++++++++++++++---------- Koha/Schema/Result/BorrowerModification.pm | 12 ++++++++++-- Koha/Schema/Result/Deletedborrower.pm | 28 ++++++++++++++++++---------- 3 files changed, 46 insertions(+), 22 deletions(-) diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index e50268d..7dce5b4 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -232,6 +232,12 @@ __PACKAGE__->table("borrowers"); 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' @@ -427,6 +433,12 @@ __PACKAGE__->table("borrowers"); datetime_undef_if_invalid: 1 is_nullable: 1 +=head2 login_attempts + + data_type: 'integer' + default_value: 0 + is_nullable: 1 + =head2 lang data_type: 'varchar' @@ -434,12 +446,6 @@ __PACKAGE__->table("borrowers"); is_nullable: 0 size: 25 -=head2 login_attempts - - data_type: 'integer' - default_value: 0 - is_nullable: 1 - =head2 overdrive_auth_token data_type: 'text' @@ -552,6 +558,8 @@ __PACKAGE__->add_columns( { 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", @@ -634,6 +642,8 @@ __PACKAGE__->add_columns( datetime_undef_if_invalid => 1, is_nullable => 1, }, + "login_attempts", + { data_type => "integer", default_value => 0, is_nullable => 1 }, "lang", { data_type => "varchar", @@ -641,8 +651,6 @@ __PACKAGE__->add_columns( 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 }, ); @@ -1378,8 +1386,8 @@ Composing rels: L -> ordernumber __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-05-09 21:24:02 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7llO928plwtX2Q+I9nQA8A +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-08-04 08:45:24 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7XtfPJMmCC7/TKL4LQWtRg __PACKAGE__->belongs_to( "guarantor", diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm index af4895a..8264b99 100644 --- a/Koha/Schema/Result/BorrowerModification.pm +++ b/Koha/Schema/Result/BorrowerModification.pm @@ -242,6 +242,12 @@ __PACKAGE__->table("borrower_modifications"); 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' @@ -513,6 +519,8 @@ __PACKAGE__->add_columns( { 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", @@ -590,8 +598,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("verification_token", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 20:04:12 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IZNhBX5Bj+x4S8JCWG+7lA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-08-04 08:45:24 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wmc+b+L1cze/k31FFXPTTw # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm index 33e3947..1c0400e 100644 --- a/Koha/Schema/Result/Deletedborrower.pm +++ b/Koha/Schema/Result/Deletedborrower.pm @@ -230,6 +230,12 @@ __PACKAGE__->table("deletedborrowers"); 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' @@ -424,6 +430,12 @@ __PACKAGE__->table("deletedborrowers"); datetime_undef_if_invalid: 1 is_nullable: 1 +=head2 login_attempts + + data_type: 'integer' + default_value: 0 + is_nullable: 1 + =head2 lang data_type: 'varchar' @@ -431,12 +443,6 @@ __PACKAGE__->table("deletedborrowers"); is_nullable: 0 size: 25 -=head2 login_attempts - - data_type: 'integer' - default_value: 0 - is_nullable: 1 - =head2 overdrive_auth_token data_type: 'text' @@ -537,6 +543,8 @@ __PACKAGE__->add_columns( { 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", @@ -619,6 +627,8 @@ __PACKAGE__->add_columns( datetime_undef_if_invalid => 1, is_nullable => 1, }, + "login_attempts", + { data_type => "integer", default_value => 0, is_nullable => 1 }, "lang", { data_type => "varchar", @@ -626,15 +636,13 @@ __PACKAGE__->add_columns( 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 }, ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-05-09 21:24:03 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SpP0xoSTFIweqTp1muUwvg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-08-04 08:45:24 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9IUe4uGtD0oZO9gvJG5T3Q # You can replace this text with custom code or comments, and it will be preserved on regeneration -- 2.1.4