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 2713-2718 CREATE TABLE `accountlines` ( Link Here
2713
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2713
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2714
  `note` MEDIUMTEXT NULL default NULL,
2714
  `note` MEDIUMTEXT NULL default NULL,
2715
  `manager_id` int(11) NULL,
2715
  `manager_id` int(11) NULL,
2716
  `branchcode` VARCHAR( 10 ) NULL DEFAULT NULL, -- the branchcode of the library where a payment was made, a manual invoice created, etc.
2716
  PRIMARY KEY (`accountlines_id`),
2717
  PRIMARY KEY (`accountlines_id`),
2717
  KEY `acctsborridx` (`borrowernumber`),
2718
  KEY `acctsborridx` (`borrowernumber`),
2718
  KEY `timeidx` (`timestamp`),
2719
  KEY `timeidx` (`timestamp`),
2719
- 

Return to bug 19066