From 378d524fbd7687e577f5e9c4be5e0726435b2bad Mon Sep 17 00:00:00 2001
From: Jan-Philipp Litza <janphilipp@litza.de>
Date: Fri, 28 Dec 2012 03:27:08 +0100
Subject: polished the table view by offloading "is this shift free" to SQL.
 Might put too much load on db server, need to evaluate. Also, replaced loads
 of & with &amp; and simplified some expressions

---
 db/update.d/22_shifts.php | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 db/update.d/22_shifts.php

(limited to 'db')

diff --git a/db/update.d/22_shifts.php b/db/update.d/22_shifts.php
new file mode 100644
index 00000000..3055c778
--- /dev/null
+++ b/db/update.d/22_shifts.php
@@ -0,0 +1,5 @@
+<?php
+if(sql_num_query("SHOW INDEX FROM `ShiftEntry` WHERE `Key_name` = 'SID' AND `Column_name` = 'TID'") == 0) {
+  sql_query("ALTER TABLE `ShiftEntry` DROP INDEX `SID`, ADD INDEX `SID` ( `SID` , `TID` )");
+  $applied = true;
+}
-- 
cgit v1.2.3-54-g00ecf