diff options
| author | Philip Häusler <msquare@notrademark.de> | 2012-12-28 15:13:28 +0100 |
|---|---|---|
| committer | Philip Häusler <msquare@notrademark.de> | 2012-12-28 15:13:28 +0100 |
| commit | c5438d5228887e638208f347fa132bfd5b60dacb (patch) | |
| tree | 1bbf815d28e71eedf5c0280f87b64cd4f535372e /db | |
| parent | e61cb06ee83cda639663d093644097ea790f2fc2 (diff) | |
| parent | cc8f117ed128cf9b046f9835640b84362d151883 (diff) | |
merged shift view fixes
Diffstat (limited to 'db')
| -rw-r--r-- | db/update.d/22_shifts.php | 5 |
1 files changed, 5 insertions, 0 deletions
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; +} |