Lines 3334-3340
CREATE TABLE `itemtypes` (
Link Here
|
3334 |
PRIMARY KEY (`itemtype`), |
3334 |
PRIMARY KEY (`itemtype`), |
3335 |
UNIQUE KEY `itemtype` (`itemtype`), |
3335 |
UNIQUE KEY `itemtype` (`itemtype`), |
3336 |
KEY `itemtypes_ibfk_1` (`parent_type`), |
3336 |
KEY `itemtypes_ibfk_1` (`parent_type`), |
3337 |
CONSTRAINT `itemtypes_ibfk_1` FOREIGN KEY (`parent_type`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
3337 |
CONSTRAINT `itemtypes_ibfk_1` FOREIGN KEY (`parent_type`) REFERENCES `itemtypes` (`itemtype`) |
3338 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3338 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3339 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3339 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3340 |
|
3340 |
|
3341 |
- |
|
|