|
Lines 2912-2920
CREATE TABLE `displays` (
Link Here
|
| 2912 |
KEY `display_branch` (`display_branch`), |
2912 |
KEY `display_branch` (`display_branch`), |
| 2913 |
KEY `display_holding_branch` (`display_holding_branch`), |
2913 |
KEY `display_holding_branch` (`display_holding_branch`), |
| 2914 |
KEY `display_itype` (`display_itype`), |
2914 |
KEY `display_itype` (`display_itype`), |
| 2915 |
CONSTRAINT `displays_ibfk_1` FOREIGN KEY (`display_branch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
2915 |
CONSTRAINT `displays_ibfk_1` FOREIGN KEY (`display_branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 2916 |
CONSTRAINT `displays_ibfk_2` FOREIGN KEY (`display_holding_branch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
2916 |
CONSTRAINT `displays_ibfk_2` FOREIGN KEY (`display_holding_branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 2917 |
CONSTRAINT `displays_ibfk_3` FOREIGN KEY (`display_itype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
2917 |
CONSTRAINT `displays_ibfk_3` FOREIGN KEY (`display_itype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE CASCADE |
| 2918 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2918 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2919 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2919 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2920 |
|
2920 |
|
| 2921 |
- |
|
|