- Surfbar extended with dynamic percentage (only config)

[mailer.git] / inc / extensions / ext-admins.php

diff --git a/inc/extensions/ext-admins.php b/inc/extensions/ext-admins.php
index 90702a10955de8efbe7ce06003c7f6c2e3731939..6c567fa5c3ed792d06c4f556be84612e426de3e1 100644 (file)
--- a/inc/extensions/ext-admins.php
+++ b/inc/extensions/ext-admins.php
@@ -90,20 +90,20 @@ case "update": // Update an extension
                $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('admins', 'config_admins', 'ACL einstellen', 'Richten Sie Zugriffskontrollzeilen für jeden Admin individuell ein, um ihm nur bestimmte Bereiche des Admin-Bereiches zugänglich zu machen oder zu sperren.', '4')";
 
                // Which is the default setting when you create a new admin login?
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD admins_default_acl enum('deny', 'allow') not null default 'deny'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD admins_default_acl ENUM('deny', 'allow') NOT NULL DEFAULT 'deny'";
 
                // Default is deny everything
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD default_acl enum('deny', 'allow') not null default 'deny'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD default_acl ENUM('deny', 'allow') NOT NULL DEFAULT 'deny'";
 
                // But allow current admin everything (THIS SHALL BE YOU!)
                $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',
-action_menu varchar(255) not null default '',
-what_menu varchar(255) not null default '',
-access_mode enum('deny', 'allow') not null default 'deny',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+admin_id BIGINT(20) 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',
 KEY (admin_id),
 PRIMARY KEY (id)
 ) TYPE=MyISAM";
@@ -113,15 +113,15 @@ PRIMARY KEY (id)
                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) 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',
-mail_template varchar(255) not null,
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+admin_id BIGINT(20) NOT NULL DEFAULT '0',
+mail_template VARCHAR(255) NOT NULL,
 KEY (admin_id),
 PRIMARY KEY (id)
 ) TYPE=MyISAM";
@@ -259,7 +259,7 @@ PRIMARY KEY (id)
                break;
 
        case "0.6.7": // SQL queries for v0.6.7
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD la_mode enum('global', 'OLD', 'NEW') not null default 'global'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD la_mode ENUM('global', 'OLD', 'NEW') NOT NULL DEFAULT 'global'";
 
                // Update notes (these will be set as task text!)
                $UPDATE_NOTES = "Namenskonflikt zwischen den Erweiterungen <STRONG>admins</STRONG> und (kommender) <STRONG>contact</STRONG>. Beseitigung eines Fehlers <STRONG>HTTP_POSR_VARS</STRONG> beim &Auml;ndern von Administratoren.";