reduce number of sql queries on shift calendar

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`);