From f4f307230ab0aeb3d28566dd0e5e9f7b851800b0 Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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. Signed-off-by: Hector Castro Signed-off-by: Katrin Fischer Signed-off-by: Brendan Gallagher brendan@bywatersolutions.com --- 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 0000000000..d2b459e570 --- /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 25ea499db0..866e1ea808 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -897,9 +897,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.39.5