X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-country.php;h=733fc6c6213a30ecdd636adea56c1a60e5c3f59c;hb=5ef42cb239e9225f160f5963a718f14bc70a1866;hp=5e62d49da6326ac38ad2d756fa3bbd8145ee4227;hpb=596c8ab32594401ca84abfbfe35513ddfff31bec;p=mailer.git diff --git a/inc/extensions/ext-country.php b/inc/extensions/ext-country.php index 5e62d49da6..733fc6c621 100644 --- a/inc/extensions/ext-country.php +++ b/inc/extensions/ext-country.php @@ -63,7 +63,7 @@ UNIQUE INDEX (`code`)", 'Country codes and their full-length descriptions'); // Insert first (Germany) country - addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (code, descr, is_active) VALUES ('DE','Deutschland','Y')"); + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DE','Deutschland','Y')"); // Admin menu addAdminMenuSql('country', NULL, 'Ländercodes verwalten','Stellen Sie hier Ländercodes ein, damit auch internationale Mitglieder sich zu Ihrem {OPEN_CONFIG}mt_word{CLOSE_CONFIG} anmelden können.', 8); @@ -73,7 +73,7 @@ UNIQUE INDEX (`code`)", addExtensionDependency('user'); // Add entry to user table - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` ADD `country_code` BIGINT(20) UNSIGNED NOT NULL DEFAULT 1"); + addExtensionAddTableColumnSql('user_data', 'country_code', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 1'); break; case 'remove': // Do stuff when removing extension