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 AFTER `searchcategory` COMMENT 'If automatic checkin is enabled for items of this type'
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