Bugzilla – Attachment 65491 Details for
Bug 6758
Capture membership renewal date for reporting purposes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 6758: DBIx schema changes
Bug-6758-DBIx-schema-changes.patch (text/plain), 6.34 KB, created by
Marcel de Rooy
on 2017-08-04 07:10:50 UTC
(
hide
)
Description:
Bug 6758: DBIx schema changes
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2017-08-04 07:10:50 UTC
Size:
6.34 KB
patch
obsolete
>From f3d7de28f274296389a2665847434d1becc44339 Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >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 <m.de.rooy@rijksmuseum.nl> >--- > 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</aqorder_users> -> 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 6758
:
62696
|
62697
|
62698
|
62699
|
62929
|
65490
|
65491
|
65492
|
67218
|
67219