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