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

(-)a/installer/data/mysql/atomicupdate/bug_xxxxx.sql (+10 lines)
Line 0 Link Here
1 
ALTER TABLE search_field ADD COLUMN facet_order TINYINT(4) DEFAULT '0' AFTER type;
2 
UPDATE search_field SET facet_order=1 WHERE name='author';
3 
UPDATE search_field SET facet_order=2 WHERE name='itype';
4 
UPDATE search_field SET facet_order=3 WHERE name='location';
5 
UPDATE search_field SET facet_order=4 WHERE name='su-geo';
6 
UPDATE search_field SET facet_order=5 WHERE name='se';
7 
UPDATE search_field SET facet_order=6 WHERE name='subject';
8 
UPDATE search_field SET facet_order=7 WHERE name='ccode';
9 
UPDATE search_field SET facet_order=8 WHERE name='holdingbranch';
10 
UPDATE search_field SET facet_order=9 WHERE name='homebranch';
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1456-1461 CREATE TABLE `search_field` ( Link Here
1456 
  `name` varchar(255) NOT NULL COMMENT 'the name of the field as it will be stored in the search engine',
 1456 
  `name` varchar(255) NOT NULL COMMENT 'the name of the field as it will be stored in the search engine',
1457 
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
 1457 
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
1458 
  `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
 1458 
  `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
1459 
  `facet_order` TINYINT(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted',
1459 
  PRIMARY KEY (`id`),
 1460 
  PRIMARY KEY (`id`),
1460 
  UNIQUE KEY (`name` (191))
 1461 
  UNIQUE KEY (`name` (191))
1461 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 1462 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1462 
-

Return to bug 18235