From 55e1026c986f1c2c7e2a0376579b01111a93ab5d Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Sun, 20 May 2018 20:48:52 +0200 Subject: improve abconfig queries --- install/schema_mysql.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 1e91619e3..9bf91fc51 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -7,8 +7,7 @@ CREATE TABLE IF NOT EXISTS `abconfig` ( `k` char(191) NOT NULL DEFAULT '', `v` mediumtext NOT NULL, PRIMARY KEY (`id`), - KEY `chan` (`chan`), - KEY `xchan` (`xchan`), + KEY `chan_xchan` (`chan`, `xchan`), KEY `cat` (`cat`), KEY `k` (`k`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- cgit v1.2.3