4483 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4483 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4484 |
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the name of the field as it will be stored in the search engine', |
4484 |
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the name of the field as it will be stored in the search engine', |
4485 |
`label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the human readable name of the field, for display', |
4485 |
`label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the human readable name of the field, for display', |
4486 |
`type` enum('','string','date','number','boolean','sum','isbn','stdno','year') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine', |
4486 |
`type` enum('','string','date','number','boolean','sum','isbn','stdno','year','callnumber') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine', |
4487 |
`weight` decimal(5,2) DEFAULT NULL, |
4487 |
`weight` decimal(5,2) DEFAULT NULL, |
4488 |
`facet_order` tinyint(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted', |
4488 |
`facet_order` tinyint(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted', |
4489 |
`staff_client` tinyint(1) NOT NULL DEFAULT 1, |
4489 |
`staff_client` tinyint(1) NOT NULL DEFAULT 1, |