|
Lines 2178-2184
CREATE TABLE `collections_tracking` (
Link Here
|
| 2178 |
`itemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'items.itemnumber', |
2178 |
`itemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'items.itemnumber', |
| 2179 |
PRIMARY KEY (`collections_tracking_id`), |
2179 |
PRIMARY KEY (`collections_tracking_id`), |
| 2180 |
KEY `collectionst_ibfk_1` (`colId`), |
2180 |
KEY `collectionst_ibfk_1` (`colId`), |
| 2181 |
CONSTRAINT `collectionst_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE |
2181 |
KEY `collectionst_ibfk_2` (`itemnumber`), |
|
|
2182 |
CONSTRAINT `collectionst_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2183 |
CONSTRAINT `collectionst_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2182 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2184 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2183 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2185 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2184 |
|
2186 |
|
| 2185 |
- |
|
|