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

Return to bug 19066