X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fextensions%2Fext-mediadata.php;h=7c0aebd8bb3ae4c912666dd933114b3a10e00b38;hb=3e64a94e122e30dd66db07fd8c8cfae05871c460;hp=f8fa3e0d58f83b485a25dd2bfefa43ed97f1a5a7;hpb=e1653405d28923c78b2e292125306ccf61138f24;p=mailer.git diff --git a/inc/extensions/ext-mediadata.php b/inc/extensions/ext-mediadata.php index f8fa3e0d58..7c0aebd8bb 100644 --- a/inc/extensions/ext-mediadata.php +++ b/inc/extensions/ext-mediadata.php @@ -92,8 +92,8 @@ case "update": // Update an extension // SQL commands to run $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_mediadata"; $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_mediadata ( -media_key varchar(255) not null default '', -media_value varchar(255) not null default '', +media_key VARCHAR(255) NOT NULL DEFAULT '', +media_value VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY(media_key) ) TYPE=MyISAM"; @@ -112,8 +112,8 @@ PRIMARY KEY(media_key) break; case "0.0.7": // SQL queries for v0.0.7 - $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_start bigint(20) not null default '0'"; - $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_stage bigint(20) not null default '500'"; + $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_start BIGINT(20) UNSIGNED NOT NULL DEFAULT '0'"; + $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_stage BIGINT(20) UNSIGNED NOT NULL DEFAULT '500'"; $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('setup', 'config_mediadata', 'Mediendaten', 'Stellen Sie allgemeine Einstellungen zu den Mediendaten ein.', 10)"; // Update notes (these will be set as task text!) @@ -129,10 +129,9 @@ Bitte stellen Sie diesen derzeit manuell unter