|
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 |
- |
|
|