JYMSdcCx

11. Error in query (1005): Can't create table 'dubaycloud.catalogsearch_query'. (errno: -1)
2
32. Error in query (1146): Table 'dubaycloud.catalogsearch_query' doesn't exist.
4
53. Error in query (1050): Table '`dubaycloud`.`catalogsearch_result`' already exists.
6	
7DROP TABLE IF EXISTS `catalogsearch_query`;
8CREATE TABLE `catalogsearch_query` (
9  `query_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Query ID',
10  `query_text` varchar(255) DEFAULT NULL COMMENT 'Query text',
11  `num_results` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Num results',
12  `popularity` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Popularity',
13  `redirect` varchar(255) DEFAULT NULL COMMENT 'Redirect',
14  `synonym_for` varchar(255) DEFAULT NULL COMMENT 'Synonym for',
15  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
16  `display_in_terms` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Display in terms',
17  `is_active` smallint(6) DEFAULT '1' COMMENT 'Active status',
18  `is_processed` smallint(6) DEFAULT '0' COMMENT 'Processed status',
19  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated at',
20  PRIMARY KEY (`query_id`),
21  KEY `IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`,`store_id`,`popularity`),
22  KEY `IDX_CATALOGSEARCH_QUERY_STORE_ID` (`store_id`),
23  KEY `IDX_CATALOGSEARCH_QUERY_NUM_RESULTS` (`num_results`),
24  KEY `IDX_CATALOGSEARCH_QUERY_QUERY_TEXT` (`query_text`),
25  KEY `IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_NUM_RESULTS` (`query_text`,`store_id`,`num_results`),
26  KEY `IDX_CATALOGSEARCH_QUERY_SYNONYM_FOR` (`synonym_for`),
27  CONSTRAINT `FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
28) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog search query table';