Merge branch 'master' of https://vcs.wybt.net/engelsystem/git

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;
+}
+?>