Lines 4731-4743
DROP TABLE IF EXISTS `search_filters`;
Link Here
|
4731 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4731 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4732 |
/*!40101 SET character_set_client = utf8 */; |
4732 |
/*!40101 SET character_set_client = utf8 */; |
4733 |
CREATE TABLE `search_filters` ( |
4733 |
CREATE TABLE `search_filters` ( |
4734 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4734 |
`search_filter_id` int(11) NOT NULL AUTO_INCREMENT, |
4735 |
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, |
4735 |
`name` varchar(255) NOT NULL COMMENT 'filter name', |
4736 |
`query` mediumtext COLLATE utf8mb4_unicode_ci, |
4736 |
`query` mediumtext NULL DEFAULT NULL COMMENT 'filter query part', |
4737 |
`limits` mediumtext COLLATE utf8mb4_unicode_ci, |
4737 |
`limits` mediumtext NULL DEFAULT NULL COMMENT 'filter limits part', |
4738 |
`opac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether this filter is shown on OPAC', |
4738 |
`opac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether this filter is shown on OPAC', |
4739 |
`staff_client` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether this filter is shown in staff client', |
4739 |
`staff_client` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether this filter is shown in staff client', |
4740 |
PRIMARY KEY (`id`) |
4740 |
PRIMARY KEY (`search_filter_id`) |
4741 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4741 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4742 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4742 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4743 |
|
4743 |
|
4744 |
- |
|
|