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