From e006147b882bd053c62ee3ec415a19b8aef4b63e 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 383ea48d1f..529fba862f 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2699,6 +2699,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.17.1 (Apple Git-112)