|
Lines 2026-2031
CREATE TABLE `columns_settings` (
Link Here
|
| 2026 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2026 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2027 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2027 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2028 |
|
2028 |
|
|
|
2029 |
-- |
| 2030 |
-- Table structure for table `configurations` |
| 2031 |
-- |
| 2032 |
|
| 2033 |
DROP TABLE IF EXISTS `configurations`; |
| 2034 |
CREATE TABLE `configurations` ( |
| 2035 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
| 2036 |
-- Unique ID of the configuration entry |
| 2037 |
`library_id` VARCHAR(10) NULL DEFAULT NULL, |
| 2038 |
-- Internal identifier for the library the config applies to. NULL means global |
| 2039 |
`category_id` VARCHAR(10) NULL DEFAULT NULL, |
| 2040 |
-- Internal identifier for the category the config applies to. NULL means global |
| 2041 |
`item_type` VARCHAR(10) NULL DEFAULT NULL, |
| 2042 |
-- Internal identifier for the item type the config applies to. NULL means global |
| 2043 |
`name` VARCHAR(32) NOT NULL, |
| 2044 |
-- Configuration entry name |
| 2045 |
`value` MEDIUMTEXT NULL DEFAULT NULL, |
| 2046 |
-- Configuration entry value |
| 2047 |
`type` ENUM('text', 'boolean', 'integer') NOT NULL DEFAULT 'text', |
| 2048 |
-- Configuration entry type |
| 2049 |
PRIMARY KEY (`id`), |
| 2050 |
KEY `library_id_idx` (`library_id`), |
| 2051 |
KEY `category_id_idx` (`category_id`), |
| 2052 |
KEY `item_type_idx` (`item_type`), |
| 2053 |
KEY `name_idx` (`name`), |
| 2054 |
KEY `type_idx` (`type`), |
| 2055 |
UNIQUE (`library_id`, `category_id`, `item_type`, `name`), |
| 2056 |
CONSTRAINT `library_id_fk` FOREIGN KEY (`library_id`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2057 |
CONSTRAINT `category_id_fk` FOREIGN KEY (`category_id`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2058 |
CONSTRAINT `item_type_fk` FOREIGN KEY (`item_type`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2059 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2060 |
|
| 2029 |
-- |
2061 |
-- |
| 2030 |
-- Table structure for table `course_instructors` |
2062 |
-- Table structure for table `course_instructors` |
| 2031 |
-- |
2063 |
-- |
|
Lines 5355-5360
CREATE TABLE `zebraqueue` (
Link Here
|
| 5355 |
PRIMARY KEY (`id`), |
5387 |
PRIMARY KEY (`id`), |
| 5356 |
KEY `zebraqueue_lookup` (`server`,`biblio_auth_number`,`operation`,`done`) |
5388 |
KEY `zebraqueue_lookup` (`server`,`biblio_auth_number`,`operation`,`done`) |
| 5357 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5389 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
|
|
5390 |
|
| 5358 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5391 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5359 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
5392 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 5360 |
|
5393 |
|
| 5361 |
- |
|
|