|
Lines 4460-4465
CREATE TABLE `letter` (
Link Here
|
| 4460 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4460 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4461 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4461 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4462 |
|
4462 |
|
|
|
4463 |
-- |
| 4464 |
-- Table structure for table `library_float_limits` |
| 4465 |
-- |
| 4466 |
|
| 4467 |
DROP TABLE IF EXISTS `library_float_limits`; |
| 4468 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 4469 |
/*!40101 SET character_set_client = utf8mb4 */; |
| 4470 |
CREATE TABLE `library_float_limits` ( |
| 4471 |
`branchcode` varchar(10) NOT NULL, |
| 4472 |
`itemtype` varchar(10) NOT NULL, |
| 4473 |
`float_limit` int(11) DEFAULT NULL, |
| 4474 |
PRIMARY KEY (`branchcode`,`itemtype`), |
| 4475 |
KEY `itemtype_idx` (`itemtype`), |
| 4476 |
CONSTRAINT `library_float_limits_ibfk_bc` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 4477 |
CONSTRAINT `library_float_limits_ibfk_it` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
| 4478 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4479 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4480 |
|
| 4463 |
-- |
4481 |
-- |
| 4464 |
-- Table structure for table `library_groups` |
4482 |
-- Table structure for table `library_groups` |
| 4465 |
-- |
4483 |
-- |
|
Lines 6887-6906
CREATE TABLE `transport_cost` (
Link Here
|
| 6887 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6905 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 6888 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6906 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 6889 |
|
6907 |
|
| 6890 |
DROP TABLE IF EXISTS `library_float_limits`; |
|
|
| 6891 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 6892 |
/*!40101 SET character_set_client = utf8 */; |
| 6893 |
CREATE TABLE `library_float_limits` ( |
| 6894 |
`branchcode` varchar(10) NOT NULL, |
| 6895 |
`itemtype` varchar(10) NOT NULL, |
| 6896 |
`float_limit` int(11) NULL DEFAULT NULL, |
| 6897 |
PRIMARY KEY (`branchcode`,`itemtype`), |
| 6898 |
KEY `itemtype_idx` (`itemtype`), |
| 6899 |
CONSTRAINT `library_float_limits_ibfk_bc` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 6900 |
CONSTRAINT `library_float_limits_ibfk_it` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
| 6901 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 6902 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 6903 |
|
| 6904 |
-- |
6908 |
-- |
| 6905 |
-- Table structure for table `uploaded_files` |
6909 |
-- Table structure for table `uploaded_files` |
| 6906 |
-- |
6910 |
-- |
| 6907 |
- |
|
|