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

(-)a/installer/data/mysql/atomicupdate/bug_19482_add_mandatory_field_to_mapping.perl (+10 lines)
Line 0 Link Here
1 
$DBversion = 'XXX';  # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 

            

            

              4
              
    if( !column_exists( 'search_field', 'mandatory' ) ) {

            

            

              5
              
        $dbh->do( "ALTER TABLE search_field ADD COLUMN mandatory tinyint(1) NULL DEFAULT NULL" );

            

            

              6
              
    }

            

            

              7
              

            

            

              8
              
    SetVersion( $DBversion );

            

            

              9
              
    print "Upgrade to $DBversion done (Bug 19482 - Add mandatory column to search_field for ES mapping)\n";

            

            

              10
              
}

            



(-)a/installer/data/mysql/kohastructure.sql
      (-1 / +1 lines)




  

    
      
            Lines 1396-1401
          CREATE TABLE `search_field` (
      
      
        Link Here
      
    
  

        

          1396
          
  `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum', 'isbn', 'stdno') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',

          1396
          
  `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum', 'isbn', 'stdno') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',

        

        

          1397
          
  `weight` decimal(5,2) DEFAULT NULL,

          1397
          
  `weight` decimal(5,2) DEFAULT NULL,

        

        

          1398
          
  `facet_order` TINYINT(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted',

          1398
          
  `facet_order` TINYINT(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted',

        

            

              
              
              1399
              
  `mandatory` tinyint(1) NULL DEFAULT NULL COMMENT 'if marked this field is not editable or removable',

            

        

          1399
          
  PRIMARY KEY (`id`),

          1400
          
  PRIMARY KEY (`id`),

        

        

          1400
          
  UNIQUE KEY (`name` (191))

          1401
          
  UNIQUE KEY (`name` (191))

        

        

          1401
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

          1402
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

        

            

              1402
              
- 

              
              
            






  

  Return to bug 19482