$SQLs[] = "UPDATE "._MYSQL_PREFIX."_admins SET default_acl='allow' WHERE login='".get_session('admin_login')."' LIMIT 1";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_admins_acls";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_admins_acls (
-id BIGINT(20) NOT NULL AUTO_INCREMENT,
-admin_id BIGINT(20) NOT NULL DEFAULT '0',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+admin_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
action_menu VARCHAR(255) NOT NULL DEFAULT '',
what_menu VARCHAR(255) NOT NULL DEFAULT '',
access_mode ENUM('deny', 'allow') NOT NULL DEFAULT 'deny',
break;
case "0.3.1": // SQL queries for v0.3.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins_acls MODIFY id BIGINT(20) NOT NULL AUTO_INCREMENT";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins_acls MODIFY id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT";
break;
case "0.4.0": // SQL queries for v0.4.0
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_admins_mails";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_admins_mails (
-id BIGINT(20) NOT NULL AUTO_INCREMENT,
-admin_id BIGINT(20) NOT NULL DEFAULT '0',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+admin_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
mail_template VARCHAR(255) NOT NULL,
KEY (admin_id),
PRIMARY KEY (id)
case "0.5.3": // SQL queries for v0.5.3
// Update notes (these will be set as task text!)
- $UPDATE_NOTES = "Seit <A href=\"".SERVER_URL."/patches/340-Gast_Mitgliedsmenue_Deaktivieren.zip\">Patch 340</A> überflüssige HTML-Tags entfernt.";
+ $UPDATE_NOTES = "Seit <A href=\"#\">Patch 340</A> überflüssige HTML-Tags entfernt.";
break;
case "0.5.4": // SQL queries for v0.5.4