Attachment 46403 Details for Bug 15517 – Bug 15517: Resync borrowers and deletedborrowers tables

[patch] Bug 15517: Resync borrowers and deletedborrowers tables

Bug-15517-Resync-borrowers-and-deletedborrowers-ta.patch (text/plain), 2.30 KB, created by Jonathan Druart on 2016-01-07 15:28:42 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2016-01-07 15:28:42 UTC

Size: 2.30 KB

patch

obsolete

>From e06cd8c69b386142998dea6c2ea0ebf6b123bf99 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 7 Jan 2016 15:24:05 +0000
>Subject: [PATCH] Bug 15517: Resync borrowers and deletedborrowers tables
>
>The 2 columns password and userid are not sync and could cause errors
>when deleting patrons.
>---
> installer/data/mysql/atomicupdate/bug_15517.sql | 2 ++
> installer/data/mysql/kohastructure.sql          | 4 ++--
> 2 files changed, 4 insertions(+), 2 deletions(-)
> create mode 100644 installer/data/mysql/atomicupdate/bug_15517.sql
>
>diff --git a/installer/data/mysql/atomicupdate/bug_15517.sql b/installer/data/mysql/atomicupdate/bug_15517.sql
>new file mode 100644
>index 0000000..d2b459e
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_15517.sql
>@@ -0,0 +1,2 @@
>+ALTER TABLE deletedborrowers MODIFY COLUMN userid VARCHAR(75) DEFAULT NULL;
>+ALTER TABLE deletedborrowers MODIFY COLUMN password VARCHAR(60) DEFAULT NULL;
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 431a541..56391d3 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -881,9 +881,9 @@ CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
>   `borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client
>   `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor
>   `sex` varchar(1) default NULL, -- patron/borrower's gender
>-  `password` varchar(30) default NULL, -- patron/borrower's encrypted password
>+  `password` varchar(60) default NULL, -- patron/borrower's encrypted password
>   `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
>-  `userid` varchar(30) default NULL, -- patron/borrower's opac and/or staff client log in
>+  `userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in
>   `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client
>   `contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address
>   `sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library
>-- 
>2.1.0

Actions: View | Diff | Splinter Review

Attachments on bug 15517: 46403 | 46404 | 46457 | 46458 | 46466 | 46467 | 46472