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/13_User.php | |
parent | bc471460fc8cce0bb9d8b5631e8d57fdec6a3b39 (diff) |
database update script
Diffstat (limited to 'db/update.d/13_User.php')
-rw-r--r-- | db/update.d/13_User.php | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/db/update.d/13_User.php b/db/update.d/13_User.php new file mode 100644 index 00000000..f4da5692 --- /dev/null +++ b/db/update.d/13_User.php @@ -0,0 +1,18 @@ +<?php +_datetime_to_int("User", "lastLogin"); + +if(sql_num_query("DESCRIBE `User` `ical_key`") === 0) { + sql_query("ALTER TABLE `User` ADD `ical_key` VARCHAR( 32 ) NOT NULL"); +# _add_index("User", array("ical_key"), "UNIQUE"); +# XXX: not everybody has an ical_key, why? + + $applied = true; +} + +$res = sql_select("DESCRIBE `User` `DECT`"); +if($res[0]['Type'] == 'varchar(4)') { + sql_query("ALTER TABLE `User` CHANGE `DECT` `DECT` VARCHAR(5) NULL"); + + $applied = true; +} +?> |