1 files changed, 29 insertions, 0 deletions
diff --git a/src/test/resources/juick-search-schema.sql b/src/test/resources/juick-search-schema.sql
new file mode 100644
index 00000000..bcf0fff7
--- /dev/null
+++ b/src/test/resources/juick-search-schema.sql
@@ -0,0 +1,29 @@
+--
+-- Table structure for table `search`
+--
+
+DROP TABLE IF EXISTS `search`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `search` (
+  `id` bigint(20) unsigned NOT NULL,
+  `weight` int(11) NOT NULL,
+  `query` varchar(3072) NOT NULL,
+  `group_id` int(11) DEFAULT NULL,
+  KEY `query` (`query`(768))
+) ENGINE=SPHINX DEFAULT CHARSET=utf8mb4 CONNECTION='sphinx://127.0.0.1:3312/messages';
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `sphinx`
+--
+
+DROP TABLE IF EXISTS `sphinx`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `sphinx` (
+  `counter_id` tinyint(3) unsigned NOT NULL,
+  `max_id` int(10) unsigned NOT NULL,
+  PRIMARY KEY (`counter_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+\ No newline at end of file