From b05b235cf821ec2d9fc84779d09db71dc1bf7797 Mon Sep 17 00:00:00 2001 From: msquare Date: Tue, 27 Dec 2016 16:02:13 +0100 Subject: fix slow query --- db/update.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'db') diff --git a/db/update.sql b/db/update.sql index 6bfe0c4a..dd203a86 100644 --- a/db/update.sql +++ b/db/update.sql @@ -23,3 +23,4 @@ INSERT INTO `Privileges` (`id`, `name`, `desc`) VALUES (NULL, 'shiftentry_edit_a -- DB Performance ALTER TABLE `Shifts` ADD INDEX(`start`); +ALTER TABLE `NeededAngelTypes` ADD INDEX(`count`); \ No newline at end of file -- cgit v1.2.3-54-g00ecf