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