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 1373-1378 CREATE TABLE `search_field` ( Link Here
1373
  `facet_order` TINYINT(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted',
1373
  `facet_order` TINYINT(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted',
1374
  `staff_client` tinyint(1) NOT NULL DEFAULT 1,
1374
  `staff_client` tinyint(1) NOT NULL DEFAULT 1,
1375
  `opac` tinyint(1) NOT NULL DEFAULT 1,
1375
  `opac` tinyint(1) NOT NULL DEFAULT 1,
1376
  `mandatory` tinyint(1) NULL DEFAULT NULL COMMENT 'if marked this field is not editable or removable',
1376
  PRIMARY KEY (`id`),
1377
  PRIMARY KEY (`id`),
1377
  UNIQUE KEY (`name` (191))
1378
  UNIQUE KEY (`name` (191))
1378
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1379
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1379
- 

Return to bug 19482