From f6afe8aee8adedec0b2a4d48212c6671cb25afcc Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Tue, 13 Dec 2016 17:42:35 -0300 Subject: [PATCH] Bug 17767: Add borrower_modification.extended_attributes This patch changes the DB structure adding borrower_modifications.extended_attributes Signed-off-by: Owen Leonard Signed-off-by: Jonathan Druart --- .../mysql/atomicupdate/bug_extended_attr_modification.sql | 12 ++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 13 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_extended_attr_modification.sql diff --git a/installer/data/mysql/atomicupdate/bug_extended_attr_modification.sql b/installer/data/mysql/atomicupdate/bug_extended_attr_modification.sql new file mode 100644 index 0000000..58c1253 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_extended_attr_modification.sql @@ -0,0 +1,12 @@ +ALTER TABLE borrower_modifications ADD COLUMN extended_attributes text DEFAULT NULL AFTER privacy; + +-- $DBversion = "16.12.00.XXX"; +-- if ( CheckVersion($DBversion) ) { +-- +-- $dbh->do( "ALTER TABLE borrower_modifications +-- ADD COLUMN extended_attributes text DEFAULT NULL +-- AFTER privacy" ); +-- print "Upgrade to $DBversion done (Bug 8835). Everything is fine.\n"; +-- +-- SetVersion($DBversion); +-- } diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 514c13d..f40692e 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3424,6 +3424,7 @@ CREATE TABLE IF NOT EXISTS `borrower_modifications` ( `altcontactphone` varchar(50) DEFAULT NULL, `smsalertnumber` varchar(50) DEFAULT NULL, `privacy` int(11) DEFAULT NULL, + `extended_attributes` text DEFAULT NULL, PRIMARY KEY (`verification_token`,`borrowernumber`), KEY `verification_token` (`verification_token`), KEY `borrowernumber` (`borrowernumber`) -- 2.9.3