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 1460-1465
          CREATE TABLE `search_field` (
      
      
        Link Here
      
    
  

        

          1460
          
  `name` varchar(255) NOT NULL COMMENT 'the name of the field as it will be stored in the search engine',

          1460
          
  `name` varchar(255) NOT NULL COMMENT 'the name of the field as it will be stored in the search engine',

        

        

          1461
          
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',

          1461
          
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',

        

        

          1462
          
  `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',

          1462
          
  `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',

        

            

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

            

        

          1463
          
  PRIMARY KEY (`id`),

          1464
          
  PRIMARY KEY (`id`),

        

        

          1464
          
  UNIQUE KEY (`name` (191))

          1465
          
  UNIQUE KEY (`name` (191))

        

        

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

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

        

            

              1466
              
- 

              
              
            






  

  Return to bug 19482