summaryrefslogtreecommitdiff
path: root/db/update.d/13_User.php
diff options
context:
space:
mode:
Diffstat (limited to 'db/update.d/13_User.php')
-rw-r--r--db/update.d/13_User.php18
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;
+}
+?>