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

(-)a/installer/data/mysql/atomicupdate/bug_13535_alert_constraint.perl (+11 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    unless ( foreign_key_exists( 'alert', 'alert_ibfk_1' ) ) {
4
        $dbh->do(
5
            qq{
6
            ALTER TABLE alert ADD CONSTRAINT alert_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON UPDATE CASCADE ON DELETE CASCADE
7
              }
8
        );
9
    }
10
    NewVersion( $DBversion, 13535, "Add FK constraint on borrowernumber to alert table");
11
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 2768-2774 CREATE TABLE `alert` ( Link Here
2768
  `externalid` varchar(20) NOT NULL default '',
2768
  `externalid` varchar(20) NOT NULL default '',
2769
  PRIMARY KEY  (`alertid`),
2769
  PRIMARY KEY  (`alertid`),
2770
  KEY `borrowernumber` (`borrowernumber`),
2770
  KEY `borrowernumber` (`borrowernumber`),
2771
  KEY `type` (`type`,`externalid`)
2771
  KEY `type` (`type`,`externalid`),
2772
  CONSTRAINT alert_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON UPDATE CASCADE ON DELETE CASCADE
2772
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2773
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2773
2774
2774
--
2775
--
2775
- 

Return to bug 13535