From 6a4d5ef83abc6b609309401f5a9b132cfc83db77 Mon Sep 17 00:00:00 2001
From: Marvin Borner
Date: Sun, 16 Sep 2018 00:58:33 +0200
Subject: Added fulltext index :zap:

---
 database.sql | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 0c39192..c53110f 100644
--- a/database.sql
+++ b/database.sql
@@ -51,7 +51,9 @@ CREATE TABLE `url_data` (
   `hash` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `url_data_hash_uindex` (`hash`),
-  KEY `url_data_hash_index` (`hash`)
+  KEY `url_data_hash_index` (`hash`),
+  FULLTEXT KEY `url_data_title_index` (`title`),
+  FULLTEXT KEY `url_data_description_index` (`description`)
 )
   ENGINE = InnoDB
   DEFAULT CHARSET = utf8mb4
@@ -67,4 +69,4 @@ CREATE TABLE `url_data` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2018-09-15 23:44:21
+-- Dump completed on 2018-09-16  0:57:12
-- 
cgit v1.2.3

