From 4d43f0a9dc8902277b79b750d325580390dc3305 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 --- 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 8151a2901c..52b8c38d12 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2686,6 +2686,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.14.3 (Apple Git-98)