From c57b2d25b2e377621087f0bde45b9df73edcfed9 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Sun, 4 Feb 2018 21:13:24 +0100 Subject: remove indices from mysql schema file --- install/schema_mysql.sql | 7 ------- 1 file changed, 7 deletions(-) (limited to 'install/schema_mysql.sql') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 673e4cd75..a3c80aafd 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -690,14 +690,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `item_verified` (`item_verified`), KEY `item_retained` (`item_retained`), KEY `item_rss` (`item_rss`), - KEY `item_deleted` (`item_deleted`), - KEY `item_type` (`item_type`), - KEY `item_hidden` (`item_hidden`), KEY `item_consensus` (`item_consensus`), - KEY `item_unpublished` (`item_unpublished`), - KEY `item_delayed` (`item_delayed`), - KEY `item_pending_remove` (`item_pending_remove`), - KEY `item_blocked` (`item_blocked`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS `item_id` ( -- cgit v1.2.3