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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 5247-5253 CREATE TABLE `search_marc_to_field` ( Link Here
5247
  `facet` tinyint(1) DEFAULT 0 COMMENT 'true if a facet field should be generated for this',
5247
  `facet` tinyint(1) DEFAULT 0 COMMENT 'true if a facet field should be generated for this',
5248
  `suggestible` tinyint(1) DEFAULT 0 COMMENT 'true if this field can be used to generate suggestions for browse',
5248
  `suggestible` tinyint(1) DEFAULT 0 COMMENT 'true if this field can be used to generate suggestions for browse',
5249
  `sort` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Sort defaults to 1 (Yes) and creates sort fields in the index, 0 (no) will prevent this',
5249
  `sort` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Sort defaults to 1 (Yes) and creates sort fields in the index, 0 (no) will prevent this',
5250
  PRIMARY KEY (`search_marc_map_id`,`search_field_id`),
5250
  PRIMARY KEY (`search_marc_map_id`,`search_field_id`,`filter`),
5251
  KEY `search_field_id` (`search_field_id`),
5251
  KEY `search_field_id` (`search_field_id`),
5252
  CONSTRAINT `search_marc_to_field_ibfk_1` FOREIGN KEY (`search_marc_map_id`) REFERENCES `search_marc_map` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
5252
  CONSTRAINT `search_marc_to_field_ibfk_1` FOREIGN KEY (`search_marc_map_id`) REFERENCES `search_marc_map` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
5253
  CONSTRAINT `search_marc_to_field_ibfk_2` FOREIGN KEY (`search_field_id`) REFERENCES `search_field` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
5253
  CONSTRAINT `search_marc_to_field_ibfk_2` FOREIGN KEY (`search_field_id`) REFERENCES `search_field` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
5254
- 

Return to bug 27153