diff options
author | Vitaly Takmazov | 2019-04-25 11:29:44 +0300 |
---|---|---|
committer | Vitaly Takmazov | 2019-04-25 11:29:44 +0300 |
commit | 1d873c6f85ca90d1448dd54cbe718d84e83d79ea (patch) | |
tree | 49e8c5ececa6b18278303910050568b567869e7b /src/test/resources/juick-search-schema.sql | |
parent | 364fb7fad241ab4945ec1069e199a1d6344ae0ad (diff) |
mysql test profile
run as SPRING_PROFILES_ACTIVE=mysql ./gradlew check
Diffstat (limited to 'src/test/resources/juick-search-schema.sql')
-rw-r--r-- | src/test/resources/juick-search-schema.sql | 29 |
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 |