View | Details | Raw Unified | Return to bug 14237
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_14237-add_course_items.biblionumber_column.perl (+10 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ){
3
    unless( column_exists( 'course_items', 'biblionumber') ) {
4
        $dbh->do(q{ ALTER TABLE course_items ADD `biblionumber` int(11) NOT NULL AFTER `itemnumber` });
5
        $dbh->do(q{ ALTER TABLE course_items ADD CONSTRAINT `fk_course_items_biblionumber` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE });
6
        $dbh->do(q{ ALTER TABLE course_items CHANGE `itemnumber` `itemnumber` int(11) DEFAULT NULL });
7
    }
8
9
    NewVersion( $DBversion, 14237, ["Add course_items.biblionumber column", "Add fk_course_items_biblionumber constraint", "Change course_items.itemnumber to allow NULL values"] );
10
}
(-)a/installer/data/mysql/kohastructure.sql (-3 / +5 lines)
Lines 2028-2034 DROP TABLE IF EXISTS `course_items`; Link Here
2028
/*!40101 SET character_set_client = utf8 */;
2028
/*!40101 SET character_set_client = utf8 */;
2029
CREATE TABLE `course_items` (
2029
CREATE TABLE `course_items` (
2030
  `ci_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'course item id',
2030
  `ci_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'course item id',
2031
  `itemnumber` int(11) NOT NULL COMMENT 'items.itemnumber for the item on reserve',
2031
  `itemnumber` int(11) DEFAULT NULL COMMENT 'items.itemnumber for the item on reserve',
2032
  `biblionumber` int(11) NOT NULL COMMENT 'biblio.biblionumber for the bibliographic record on reserve',
2032
  `itype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'new itemtype for the item to have while on reserve (optional)',
2033
  `itype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'new itemtype for the item to have while on reserve (optional)',
2033
  `itype_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates if itype should be changed while on course reserve',
2034
  `itype_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates if itype should be changed while on course reserve',
2034
  `itype_storage` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a place to store the itype when item is on course reserve',
2035
  `itype_storage` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a place to store the itype when item is on course reserve',
Lines 2051-2060 CREATE TABLE `course_items` ( Link Here
2051
  KEY `holdingbranch` (`holdingbranch`),
2052
  KEY `holdingbranch` (`holdingbranch`),
2052
  KEY `fk_course_items_homebranch` (`homebranch`),
2053
  KEY `fk_course_items_homebranch` (`homebranch`),
2053
  KEY `fk_course_items_homebranch_storage` (`homebranch_storage`),
2054
  KEY `fk_course_items_homebranch_storage` (`homebranch_storage`),
2055
  KEY `fk_course_items_biblionumber` (`biblionumber`),
2054
  CONSTRAINT `course_items_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2056
  CONSTRAINT `course_items_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2055
  CONSTRAINT `course_items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2057
  CONSTRAINT `course_items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2056
  CONSTRAINT `fk_course_items_homebranch` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2058
  CONSTRAINT `fk_course_items_homebranch` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2057
  CONSTRAINT `fk_course_items_homebranch_storage` FOREIGN KEY (`homebranch_storage`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
2059
  CONSTRAINT `fk_course_items_homebranch_storage` FOREIGN KEY (`homebranch_storage`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2060
  CONSTRAINT `fk_course_items_biblionumber` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
2058
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2061
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2059
/*!40101 SET character_set_client = @saved_cs_client */;
2062
/*!40101 SET character_set_client = @saved_cs_client */;
2060
2063
2061
- 

Return to bug 14237