diff options
| author | Philip Häusler <msquare@notrademark.de> | 2011-12-26 16:09:15 +0100 |
|---|---|---|
| committer | Philip Häusler <msquare@notrademark.de> | 2011-12-26 16:09:15 +0100 |
| commit | d0bb9fbbebf2112b7330476a471c18e06222634b (patch) | |
| tree | abc17d687448e1844c0cff3ca953bbf54f17d7be /db/update.d/05_ShiftEntry.php | |
| parent | 1852a2a1ae190391d47d5ce15398bc0c02c7071b (diff) | |
| parent | 7154097581f231753005aaabdc12d00173b7ce27 (diff) | |
Merge branch 'master' of https://vcs.wybt.net/engelsystem/git
Diffstat (limited to 'db/update.d/05_ShiftEntry.php')
| -rw-r--r-- | db/update.d/05_ShiftEntry.php | 9 |
1 files changed, 9 insertions, 0 deletions
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")); +?> |