From 7154097581f231753005aaabdc12d00173b7ce27 Mon Sep 17 00:00:00 2001
From: Jan-Philipp Litza <jplitza@sylar.(none)>
Date: Mon, 26 Dec 2011 16:04:54 +0100
Subject: database update script

---
 db/update.d/05_ShiftEntry.php | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 db/update.d/05_ShiftEntry.php

(limited to 'db/update.d/05_ShiftEntry.php')

diff --git a/db/update.d/05_ShiftEntry.php b/db/update.d/05_ShiftEntry.php
new file mode 100644
index 00000000..3e3a7b6b
--- /dev/null
+++ b/db/update.d/05_ShiftEntry.php
@@ -0,0 +1,9 @@
+<?php
+if(sql_num_query("DESCRIBE `ShiftEntry` `id`") === 0) {
+    sql_query("ALTER TABLE `ShiftEntry` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST");
+    $applied = true;
+}
+_add_index("ShiftEntry", array("SID"));
+_add_index("ShiftEntry", array("TID"));
+_add_index("ShiftEntry", array("UID"));
+?>
-- 
cgit v1.2.3-54-g00ecf