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

(-)a/installer/data/mysql/atomicupdate/bug_23027.perl (-3 / +4 lines)
Lines 1-9 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
    if( !column_exists( 'itemtypes', 'automatic_checkin' ) ) {
3
    if( !column_exists( 'itemtypes', 'automatic_checkin' ) ) {
4
       $dbh->do(q{
4
        $dbh->do(q{
5
           ALTER TABLE itemtypes ADD COLUMN `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 AFTER `searchcategory` -- 1 if automatic checkin is enabled for items of this type
5
            ALTER TABLE itemtypes
6
       });
6
                ADD COLUMN `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If automatic checkin is enabled for items of this type' AFTER `searchcategory`
7
        });
7
    }
8
    }
8
9
9
    # Always end with this (adjust the bug info)
10
    # Always end with this (adjust the bug info)
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 3133-3139 CREATE TABLE `itemtypes` ( Link Here
3133
  `sip_media_type` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SIP2 protocol media type for this itemtype',
3133
  `sip_media_type` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SIP2 protocol media type for this itemtype',
3134
  `hideinopac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Hide the item type from the search options in OPAC',
3134
  `hideinopac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Hide the item type from the search options in OPAC',
3135
  `searchcategory` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Group this item type with others with the same value on OPAC search options',
3135
  `searchcategory` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Group this item type with others with the same value on OPAC search options',
3136
  `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0, -- 1 if automatic checkin is enabled for items of this type
3136
  `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If automatic checkin is enabled for items of this type',
3137
  PRIMARY KEY (`itemtype`),
3137
  PRIMARY KEY (`itemtype`),
3138
  UNIQUE KEY `itemtype` (`itemtype`),
3138
  UNIQUE KEY `itemtype` (`itemtype`),
3139
  KEY `itemtypes_ibfk_1` (`parent_type`),
3139
  KEY `itemtypes_ibfk_1` (`parent_type`),
3140
- 

Return to bug 23207