diff options
| author | Marvin Borner | 2018-09-16 00:58:33 +0200 |
|---|---|---|
| committer | Marvin Borner | 2018-09-16 00:58:33 +0200 |
| commit | 6a4d5ef83abc6b609309401f5a9b132cfc83db77 (patch) | |
| tree | b7f3ab5ddbabd5326ae6e23be989a25b796c56dc | |
| parent | e6386db06c1aae42f7df0727420c8c529c7f29ab (diff) | |
Added fulltext index :zap:
| -rw-r--r-- | database.sql | 6 |
1 files changed, 4 insertions, 2 deletions
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 |