]> git.mxchange.org Git - mailer.git/blobdiff - inc/extensions/ext-birthday.php
Encapsulated adding configuration entries with new wrapper function addConfigAddSql()
[mailer.git] / inc / extensions / ext-birthday.php
index 610dfb29d6adc12cf1af67e350eb09475070f5d4..42e797914b54c12eb1b914282a861630daa86feb 100644 (file)
@@ -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.");