X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-country.php;h=0a28c5b1f59754f47c8fe018efc100d3b032ab36;hb=7b8e99bea1bd896d7d984bb5a04fdbf974890a7c;hp=43f430dbc1648b4dfa285a2e375db248a3aa8a5e;hpb=307a4e11763f0914e73dc756b219356e1c29ab25;p=mailer.git

diff --git a/inc/extensions/ext-country.php b/inc/extensions/ext-country.php
index 43f430dbc1..0a28c5b1f5 100644
--- a/inc/extensions/ext-country.php
+++ b/inc/extensions/ext-country.php
@@ -53,10 +53,10 @@ case "register": // Do stuff when installtion is running (modules.php?module=adm
 	// SQL commands to run
 	$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_countries";
 	$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_countries (
-id bigint(20) not null auto_increment,
-code char(2) not null default 'DE',
-descr varchar(255) not null default 'Deutschland',
-is_active enum('Y', 'N') not null default 'N',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+code CHAR(2) NOT NULL DEFAULT 'DE',
+descr VARCHAR(255) NOT NULL DEFAULT 'Deutschland',
+is_active ENUM('Y', 'N') NOT NULL DEFAULT 'N',
 KEY(code),
 PRIMARY KEY(id)
 ) TYPE=MyISAM";
@@ -67,7 +67,7 @@ PRIMARY KEY(id)
 	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('country', 'list_country', 'Verwalten', 'Hinzufügen, Ändern und Löschen von Ländercodes.', 1)";
 
 	// Add entry to user table
-	$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD country_code bigint(20) not null default '1'";
+	$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD country_code BIGINT(20) NOT NULL DEFAULT '1'";
 	break;
 
 case "remove": // Do stuff when removing extension