From 4a7bb4582d68bc35c5b5e2eff8d7b98633c6d8f0 Mon Sep 17 00:00:00 2001 From: Marvin Borner Date: Sat, 15 Sep 2018 23:46:04 +0200 Subject: Removed unnecessary index :rocket: :zap: --- database.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/database.sql b/database.sql index 24b316a..0c39192 100644 --- a/database.sql +++ b/database.sql @@ -28,8 +28,7 @@ CREATE TABLE `queue` ( `hash` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `queue_id_uindex` (`id`), - UNIQUE KEY `queue_hash_uindex` (`hash`), - KEY `queue_hash_index` (`hash`) + UNIQUE KEY `queue_hash_uindex` (`hash`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 @@ -68,4 +67,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 20:02:58 +-- Dump completed on 2018-09-15 23:44:21 -- cgit v1.2.3