@@ -, +, @@ --- 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 --- a/installer/data/mysql/atomicupdate/bug_19066.sql +++ a/installer/data/mysql/atomicupdate/bug_19066.sql @@ -0,0 +1, @@ +ALTER TABLE accountlines ADD branchcode VARCHAR( 10 ) NULL DEFAULT NULL AFTER manager_id; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2713,6 +2713,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`), --