|
Lines 6849-6854
CREATE TABLE `z3950servers` (
Link Here
|
| 6849 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6849 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 6850 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6850 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 6851 |
|
6851 |
|
|
|
6852 |
-- |
| 6853 |
-- Table structure for table `z3950servers_branches` |
| 6854 |
-- |
| 6855 |
|
| 6856 |
DROP TABLE IF EXISTS `z3950servers_branches`; |
| 6857 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 6858 |
/*!40101 SET character_set_client = utf8mb4 */; |
| 6859 |
CREATE TABLE `z3950servers_branches` ( |
| 6860 |
`server_id` int(11) NOT NULL COMMENT 'z3950server id', |
| 6861 |
`branchcode` varchar(10) NOT NULL COMMENT 'branch code', |
| 6862 |
PRIMARY KEY (`server_id`,`branchcode`), |
| 6863 |
KEY `z3950servers_branches_ibfk_2` (`branchcode`), |
| 6864 |
CONSTRAINT `z3950servers_branches_ibfk_1` FOREIGN KEY (`server_id`) REFERENCES `z3950servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 6865 |
CONSTRAINT `z3950servers_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 6866 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 6867 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 6868 |
|
| 6852 |
-- |
6869 |
-- |
| 6853 |
-- Table structure for table `zebraqueue` |
6870 |
-- Table structure for table `zebraqueue` |
| 6854 |
-- |
6871 |
-- |
| 6855 |
- |
|
|