|
Lines 6823-6828
CREATE TABLE `z3950servers` (
Link Here
|
| 6823 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6823 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 6824 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6824 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 6825 |
|
6825 |
|
|
|
6826 |
-- |
| 6827 |
-- Table structure for table `z3950servers_branches` |
| 6828 |
-- |
| 6829 |
|
| 6830 |
DROP TABLE IF EXISTS `z3950servers_branches`; |
| 6831 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 6832 |
/*!40101 SET character_set_client = utf8mb4 */; |
| 6833 |
CREATE TABLE `z3950servers_branches` ( |
| 6834 |
`server_id` int(11) NOT NULL COMMENT 'z3950server id', |
| 6835 |
`branchcode` varchar(10) NOT NULL COMMENT 'branch code', |
| 6836 |
PRIMARY KEY (`server_id`,`branchcode`), |
| 6837 |
KEY `z3950servers_branches_ibfk_2` (`branchcode`), |
| 6838 |
CONSTRAINT `z3950servers_branches_ibfk_1` FOREIGN KEY (`server_id`) REFERENCES `z3950servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 6839 |
CONSTRAINT `z3950servers_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 6840 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 6841 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 6842 |
|
| 6826 |
-- |
6843 |
-- |
| 6827 |
-- Table structure for table `zebraqueue` |
6844 |
-- Table structure for table `zebraqueue` |
| 6828 |
-- |
6845 |
-- |
| 6829 |
- |
|
|