|
Lines 7093-7098
CREATE TABLE `z3950servers` (
Link Here
|
| 7093 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
7093 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 7094 |
/*!40101 SET character_set_client = @saved_cs_client */; |
7094 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 7095 |
|
7095 |
|
|
|
7096 |
-- |
| 7097 |
-- Table structure for table `z3950servers_branches` |
| 7098 |
-- |
| 7099 |
|
| 7100 |
DROP TABLE IF EXISTS `z3950servers_branches`; |
| 7101 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 7102 |
/*!40101 SET character_set_client = utf8mb4 */; |
| 7103 |
CREATE TABLE `z3950servers_branches` ( |
| 7104 |
`server_id` int(11) NOT NULL COMMENT 'z3950server id', |
| 7105 |
`branchcode` varchar(10) NOT NULL COMMENT 'branch code', |
| 7106 |
PRIMARY KEY (`server_id`,`branchcode`), |
| 7107 |
KEY `z3950servers_branches_ibfk_2` (`branchcode`), |
| 7108 |
CONSTRAINT `z3950servers_branches_ibfk_1` FOREIGN KEY (`server_id`) REFERENCES `z3950servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 7109 |
CONSTRAINT `z3950servers_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 7110 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 7111 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 7112 |
|
| 7096 |
-- |
7113 |
-- |
| 7097 |
-- Table structure for table `zebraqueue` |
7114 |
-- Table structure for table `zebraqueue` |
| 7098 |
-- |
7115 |
-- |
| 7099 |
- |
|
|