X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-birthday.php;h=42e797914b54c12eb1b914282a861630daa86feb;hp=610dfb29d6adc12cf1af67e350eb09475070f5d4;hb=b8e38719844932afed4b1ac23755a4c05b72eb99;hpb=5261b522112c11417fc87bb0b14ca078bfa398e3 diff --git a/inc/extensions/ext-birthday.php b/inc/extensions/ext-birthday.php index 610dfb29d6..42e797914b 100644 --- a/inc/extensions/ext-birthday.php +++ b/inc/extensions/ext-birthday.php @@ -77,7 +77,7 @@ switch (getExtensionMode()) { break; case '0.2.0': // SQL queries for v0.2 - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `birthday_points` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0"); + addConfigAddSql('birthday_points', "BIGINT(20) UNSIGNED NOT NULL DEFAULT 0"); addDropTableSql('user_birthday'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_birthday` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, @@ -159,8 +159,8 @@ PRIMARY KEY (`id`) break; case '0.3.6': // SQL queries for v0.3.6 - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD birthday_mode ENUM('DIRECT','REF') NOT NULL DEFAULT 'DIRECT'"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD birthday_active ENUM('Y','N') NOT NULL DEFAULT 'N'"); + addConfigAddSql('birthday_mode', "ENUM('DIRECT','REF') NOT NULL DEFAULT 'DIRECT'"); + addConfigAddSql('birthday_active', "ENUM('Y','N') NOT NULL DEFAULT 'N'"); // Update notes (these will be set as task text!) setExtensionUpdateNotes("Vergütungsmodus des Geburtstagsbonus einstellbar.");