summaryrefslogtreecommitdiff
path: root/db/update.d/05_ShiftEntry.php
blob: 3e3a7b6b5e494c77bbbcd7d86500bce8e805e2d2 (plain)
1
2
3
4
5
6
7
8
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"));
?>