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

(-)a/installer/data/mysql/atomicupdate/bug_21401_add_accountlines_branchcode.perl (+10 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    if( !column_exists( 'accountlines', 'branchcode' ) ) {
4
        $dbh->do( "ALTER TABLE accountlines ADD COLUMN branchcode varchar(10) default NULL AFTER manager_id" );
5
        $dbh->do( "ALTER TABLE accountlines ADD CONSTRAINT `accountlines_ibfk_3` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE" );
6
    }
7
8
    SetVersion( $DBversion );
9
    print "Upgrade to $DBversion done (Bug 21401 - Add branchcode to accountlines)\n";
10
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +3 lines)
Lines 2697-2708 CREATE TABLE `accountlines` ( Link Here
2697
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2697
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2698
  `note` MEDIUMTEXT NULL default NULL,
2698
  `note` MEDIUMTEXT NULL default NULL,
2699
  `manager_id` int(11) NULL,
2699
  `manager_id` int(11) NULL,
2700
  `branchcode` varchar(10) default NULL, -- library where the accountline was created
2700
  PRIMARY KEY (`accountlines_id`),
2701
  PRIMARY KEY (`accountlines_id`),
2701
  KEY `acctsborridx` (`borrowernumber`),
2702
  KEY `acctsborridx` (`borrowernumber`),
2702
  KEY `timeidx` (`timestamp`),
2703
  KEY `timeidx` (`timestamp`),
2703
  KEY `itemnumber` (`itemnumber`),
2704
  KEY `itemnumber` (`itemnumber`),
2704
  CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2705
  CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2705
  CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
2706
  CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
2707
  CONSTRAINT `accountlines_ibfk_3` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE
2706
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2708
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2707
2709
2708
--
2710
--
2709
- 

Return to bug 21401