Lines 3344-3350
CREATE TABLE `itemtypes` (
Link Here
|
3344 |
PRIMARY KEY (`itemtype`), |
3344 |
PRIMARY KEY (`itemtype`), |
3345 |
UNIQUE KEY `itemtype` (`itemtype`), |
3345 |
UNIQUE KEY `itemtype` (`itemtype`), |
3346 |
KEY `itemtypes_ibfk_1` (`parent_type`), |
3346 |
KEY `itemtypes_ibfk_1` (`parent_type`), |
3347 |
CONSTRAINT `itemtypes_ibfk_1` FOREIGN KEY (`parent_type`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
3347 |
CONSTRAINT `itemtypes_ibfk_1` FOREIGN KEY (`parent_type`) REFERENCES `itemtypes` (`itemtype`) |
3348 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3348 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3349 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3349 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3350 |
|
3350 |
|
3351 |
- |
|
|