Lines 2025-2031
DROP TABLE IF EXISTS `course_items`;
Link Here
|
2025 |
/*!40101 SET character_set_client = utf8 */; |
2025 |
/*!40101 SET character_set_client = utf8 */; |
2026 |
CREATE TABLE `course_items` ( |
2026 |
CREATE TABLE `course_items` ( |
2027 |
`ci_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'course item id', |
2027 |
`ci_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'course item id', |
2028 |
`itemnumber` int(11) NOT NULL COMMENT 'items.itemnumber for the item on reserve', |
2028 |
`itemnumber` int(11) DEFAULT NULL COMMENT 'items.itemnumber for the item on reserve', |
|
|
2029 |
`biblionumber` int(11) NOT NULL COMMENT 'biblio.biblionumber for the bibliographic record on reserve', |
2029 |
`itype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'new itemtype for the item to have while on reserve (optional)', |
2030 |
`itype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'new itemtype for the item to have while on reserve (optional)', |
2030 |
`itype_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates if itype should be changed while on course reserve', |
2031 |
`itype_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates if itype should be changed while on course reserve', |
2031 |
`itype_storage` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a place to store the itype when item is on course reserve', |
2032 |
`itype_storage` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a place to store the itype when item is on course reserve', |
Lines 2048-2057
CREATE TABLE `course_items` (
Link Here
|
2048 |
KEY `holdingbranch` (`holdingbranch`), |
2049 |
KEY `holdingbranch` (`holdingbranch`), |
2049 |
KEY `fk_course_items_homebranch` (`homebranch`), |
2050 |
KEY `fk_course_items_homebranch` (`homebranch`), |
2050 |
KEY `fk_course_items_homebranch_storage` (`homebranch_storage`), |
2051 |
KEY `fk_course_items_homebranch_storage` (`homebranch_storage`), |
|
|
2052 |
KEY `fk_course_items_biblionumber` (`biblionumber`), |
2051 |
CONSTRAINT `course_items_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
2053 |
CONSTRAINT `course_items_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
2052 |
CONSTRAINT `course_items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
2054 |
CONSTRAINT `course_items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
2053 |
CONSTRAINT `fk_course_items_homebranch` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
2055 |
CONSTRAINT `fk_course_items_homebranch` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
2054 |
CONSTRAINT `fk_course_items_homebranch_storage` FOREIGN KEY (`homebranch_storage`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
2056 |
CONSTRAINT `fk_course_items_homebranch_storage` FOREIGN KEY (`homebranch_storage`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
2057 |
CONSTRAINT `fk_course_items_biblionumber` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2055 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2058 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2056 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2059 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2057 |
|
2060 |
|
2058 |
- |
|
|