Lines 4581-4587
CREATE TABLE `search_marc_to_field` (
Link Here
|
4581 |
`search_field_id` int(11) NOT NULL, |
4581 |
`search_field_id` int(11) NOT NULL, |
4582 |
`facet` tinyint(1) DEFAULT 0 COMMENT 'true if a facet field should be generated for this', |
4582 |
`facet` tinyint(1) DEFAULT 0 COMMENT 'true if a facet field should be generated for this', |
4583 |
`suggestible` tinyint(1) DEFAULT 0 COMMENT 'true if this field can be used to generate suggestions for browse', |
4583 |
`suggestible` tinyint(1) DEFAULT 0 COMMENT 'true if this field can be used to generate suggestions for browse', |
4584 |
`sort` tinyint(1) DEFAULT NULL COMMENT 'true/false creates special sort handling, null doesn''t', |
4584 |
`sort` tinyint(1) DEFAULT 1 NOT NULL COMMENT 'Sort defaults to 1 (Yes) and creates sort fields in the index, 0 (no) will prevent this', |
4585 |
PRIMARY KEY (`search_marc_map_id`,`search_field_id`), |
4585 |
PRIMARY KEY (`search_marc_map_id`,`search_field_id`), |
4586 |
KEY `search_field_id` (`search_field_id`), |
4586 |
KEY `search_field_id` (`search_field_id`), |
4587 |
CONSTRAINT `search_marc_to_field_ibfk_1` FOREIGN KEY (`search_marc_map_id`) REFERENCES `search_marc_map` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
4587 |
CONSTRAINT `search_marc_to_field_ibfk_1` FOREIGN KEY (`search_marc_map_id`) REFERENCES `search_marc_map` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
4588 |
- |
|
|