View | Details | Raw Unified | Return to bug 19066
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_19066.sql (+1 lines)
Line 0 Link Here
1
ALTER TABLE accountlines ADD branchcode VARCHAR( 10 ) NULL DEFAULT NULL AFTER manager_id;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2699-2704 CREATE TABLE `accountlines` ( Link Here
2699
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2699
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2700
  `note` MEDIUMTEXT NULL default NULL,
2700
  `note` MEDIUMTEXT NULL default NULL,
2701
  `manager_id` int(11) NULL,
2701
  `manager_id` int(11) NULL,
2702
  `branchcode` VARCHAR( 10 ) NULL DEFAULT NULL, -- the branchcode of the library where a payment was made, a manual invoice created, etc.
2702
  PRIMARY KEY (`accountlines_id`),
2703
  PRIMARY KEY (`accountlines_id`),
2703
  KEY `acctsborridx` (`borrowernumber`),
2704
  KEY `acctsborridx` (`borrowernumber`),
2704
  KEY `timeidx` (`timestamp`),
2705
  KEY `timeidx` (`timestamp`),
2705
- 

Return to bug 19066