From deb41c4b64a59301aceb63257388bb2707bc9a75 Mon Sep 17 00:00:00 2001
From: msquare <msquare@notrademark.de>
Date: Mon, 26 Dec 2016 14:26:49 +0100
Subject: reduce number of sql queries on shift calendar

---
 db/update.sql | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'db/update.sql')

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`);
-- 
cgit v1.2.3-70-g09d2

