|
Lines 2841-2847
CREATE TABLE `alert` (
Link Here
|
| 2841 |
`externalid` varchar(20) NOT NULL default '', |
2841 |
`externalid` varchar(20) NOT NULL default '', |
| 2842 |
PRIMARY KEY (`alertid`), |
2842 |
PRIMARY KEY (`alertid`), |
| 2843 |
KEY `borrowernumber` (`borrowernumber`), |
2843 |
KEY `borrowernumber` (`borrowernumber`), |
| 2844 |
KEY `type` (`type`,`externalid`) |
2844 |
KEY `type` (`type`,`externalid`), |
|
|
2845 |
CONSTRAINT alert_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON UPDATE CASCADE ON DELETE CASCADE |
| 2845 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2846 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2846 |
|
2847 |
|
| 2847 |
-- |
2848 |
-- |
| 2848 |
- |
|
|