summaryrefslogtreecommitdiff
path: root/db/update.d/03_Messages.php
blob: 4c6ff23295c229b9cebb8ac5b26089d5fc37e8e0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
<?php
if(sql_num_query("DESCRIBE `Messages` `id`") === 0) {
    sql_query("ALTER TABLE `Messages`
        DROP PRIMARY KEY,
        ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
    ");
    $applied = true;
}

_add_index("Messages", array("SUID"));
_add_index("Messages", array("RUID"));
_datetime_to_int("Messages", "Datum");
_add_index("Messages", array("Datum"));
?>