Lines 2441-2447
DROP TABLE IF EXISTS `serialitems`;
Link Here
|
2441 |
CREATE TABLE `serialitems` ( |
2441 |
CREATE TABLE `serialitems` ( |
2442 |
`itemnumber` int(11) NOT NULL, |
2442 |
`itemnumber` int(11) NOT NULL, |
2443 |
`serialid` int(11) NOT NULL, |
2443 |
`serialid` int(11) NOT NULL, |
2444 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2444 |
PRIMARY KEY (`itemnumber`), |
2445 |
KEY `serialitems_sfk_1` (`serialid`), |
2445 |
KEY `serialitems_sfk_1` (`serialid`), |
2446 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2446 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2447 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2447 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2448 |
- |
|
|