From 7b2cb456194c06aa2110091b5718c272476b2560 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Wed, 9 Aug 2017 09:50:21 -0400 Subject: [PATCH] Bug 19066: Update Database Signed-off-by: Josef Moravec Signed-off-by: Martin Renvoize --- installer/data/mysql/atomicupdate/bug_19066.sql | 1 + installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 2 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_19066.sql diff --git a/installer/data/mysql/atomicupdate/bug_19066.sql b/installer/data/mysql/atomicupdate/bug_19066.sql new file mode 100644 index 0000000000..8fe161a6a3 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_19066.sql @@ -0,0 +1 @@ +ALTER TABLE accountlines ADD branchcode VARCHAR( 10 ) NULL DEFAULT NULL AFTER manager_id; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index c3c9570a29..9a4edd1b03 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2718,6 +2718,7 @@ CREATE TABLE `accountlines` ( `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `note` MEDIUMTEXT NULL default NULL, `manager_id` int(11) NULL, + `branchcode` VARCHAR( 10 ) NULL DEFAULT NULL, -- the branchcode of the library where a payment was made, a manual invoice created, etc. PRIMARY KEY (`accountlines_id`), KEY `acctsborridx` (`borrowernumber`), KEY `timeidx` (`timestamp`), -- 2.19.2