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

Return to bug 19066