summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authormsquare <msquare@notrademark.de>2016-12-26 14:26:49 +0100
committermsquare <msquare@notrademark.de>2016-12-26 14:26:49 +0100
commitdeb41c4b64a59301aceb63257388bb2707bc9a75 (patch)
tree11a9a463dbf206e91ae39efc0f2e059249541a7e /db
parent99c7e8ce1a668f567afed2a40d994961b2da0578 (diff)
reduce number of sql queries on shift calendar
Diffstat (limited to 'db')
-rw-r--r--db/update.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/db/update.sql b/db/update.sql
index 9a665566..6bfe0c4a 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -19,3 +19,7 @@ ALTER TABLE `AngelTypes`
INSERT INTO `Privileges` (`id`, `name`, `desc`) VALUES (NULL, 'shiftentry_edit_angeltype_supporter', 'If user with this privilege is angeltype supporter, he can put users in shifts for their angeltype');
+
+
+-- DB Performance
+ALTER TABLE `Shifts` ADD INDEX(`start`);