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