|
Lines 2003-2008
CREATE TABLE `columns_settings` (
Link Here
|
| 2003 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2003 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2004 |
|
2004 |
|
| 2005 |
-- |
2005 |
-- |
|
|
2006 |
-- Table structure for table `configurations` |
| 2007 |
-- |
| 2008 |
|
| 2009 |
DROP TABLE IF EXISTS `configurations`; |
| 2010 |
CREATE TABLE `configurations` ( |
| 2011 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
| 2012 |
-- Unique ID of the configuration entry |
| 2013 |
`library_id` VARCHAR(10) NULL DEFAULT NULL, |
| 2014 |
-- Internal identifier for the library the config applies to. NULL means global |
| 2015 |
`category_id` VARCHAR(10) NULL DEFAULT NULL, |
| 2016 |
-- Internal identifier for the category the config applies to. NULL means global |
| 2017 |
`item_type` VARCHAR(10) NULL DEFAULT NULL, |
| 2018 |
-- Internal identifier for the item type the config applies to. NULL means global |
| 2019 |
`name` VARCHAR(32) NOT NULL, |
| 2020 |
-- Configuration entry name |
| 2021 |
`value` MEDIUMTEXT NULL DEFAULT NULL, |
| 2022 |
-- Configuration entry value |
| 2023 |
`type` ENUM('text', 'boolean', 'integer') NOT NULL DEFAULT 'text', |
| 2024 |
-- Configuration entry type |
| 2025 |
PRIMARY KEY (`id`), |
| 2026 |
KEY `library_id_idx` (`library_id`), |
| 2027 |
KEY `category_id_idx` (`category_id`), |
| 2028 |
KEY `item_type_idx` (`item_type`), |
| 2029 |
KEY `name_idx` (`name`), |
| 2030 |
KEY `type_idx` (`type`), |
| 2031 |
UNIQUE (`library_id`, `category_id`, `item_type`, `name`), |
| 2032 |
CONSTRAINT `library_id_fk` FOREIGN KEY (`library_id`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2033 |
CONSTRAINT `category_id_fk` FOREIGN KEY (`category_id`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2034 |
CONSTRAINT `item_type_fk` FOREIGN KEY (`item_type`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2035 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2036 |
|
| 2037 |
-- |
| 2006 |
-- Table structure for table `course_instructors` |
2038 |
-- Table structure for table `course_instructors` |
| 2007 |
-- |
2039 |
-- |
| 2008 |
|
2040 |
|
|
Lines 5324-5329
CREATE TABLE `zebraqueue` (
Link Here
|
| 5324 |
PRIMARY KEY (`id`), |
5356 |
PRIMARY KEY (`id`), |
| 5325 |
KEY `zebraqueue_lookup` (`server`,`biblio_auth_number`,`operation`,`done`) |
5357 |
KEY `zebraqueue_lookup` (`server`,`biblio_auth_number`,`operation`,`done`) |
| 5326 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5358 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
|
|
5359 |
|
| 5327 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5360 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5328 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
5361 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 5329 |
|
5362 |
|
| 5330 |
- |
|
|