+
+ case "0.3.5": // SQL queries for v0.3.5
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_user_data` ADD `lock_reason` TINYTEXT";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_user_data` ADD `lock_timestamp` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00'";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `user_delete_purge` BIGINT(20) UNSIGNED NOT NULL DEFAULT ".($_CONFIG['one_day'] * 30)."";
+ $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('user','list_user_del','Löschungen auflisten','Listet die Löschungen von Usern auf.', 9)";
+ $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_user_del`";
+ $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_user_del` (
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`email` VARCHAR(255) NOT NULL DEFAULT '',
+`surname` VARCHAR(255) NOT NULL DEFAULT '',
+`family` VARCHAR(255) NOT NULL DEFAULT '',
+`joined` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`last_online` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`del_timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+`del_reason` TINYTEXT,
+INDEX (`userid`),
+PRIMARY KEY(`id`)
+) TYPE=MyISAM COMMENT='List of deleted users'";
+
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Der Sperrgrund wird nun mit abgespeichert und beim Löschen des Users mit ausgesendet.";
+ break;