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