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 |
- |
|
|