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 |
- |
|
|