diff options
| author | Jan-Philipp Litza <jplitza@sylar.(none)> | 2011-12-26 16:04:54 +0100 |
|---|---|---|
| committer | Jan-Philipp Litza <jplitza@sylar.(none)> | 2011-12-26 16:04:54 +0100 |
| commit | 7154097581f231753005aaabdc12d00173b7ce27 (patch) | |
| tree | 2fdc6e62e01a8f271c2d249756762e9fd91f7754 /db/update.d/03_Messages.php | |
| parent | bc471460fc8cce0bb9d8b5631e8d57fdec6a3b39 (diff) | |
database update script
Diffstat (limited to 'db/update.d/03_Messages.php')
| -rw-r--r-- | db/update.d/03_Messages.php | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/db/update.d/03_Messages.php b/db/update.d/03_Messages.php new file mode 100644 index 00000000..4c6ff232 --- /dev/null +++ b/db/update.d/03_Messages.php @@ -0,0 +1,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")); +?> |