X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-birthday.php;h=330bc843d64b426ffbfcaa63702f2812a7b27d3c;hp=e820a089fd194539c8914c3ac63cb4f6a1c27e47;hb=be39a7fb887473487fd2c5f8d550aa03b720cb73;hpb=9725980ca9c052e5c1a9edb8b815e8506b876448

diff --git a/inc/extensions/ext-birthday.php b/inc/extensions/ext-birthday.php
index e820a089fd..330bc843d6 100644
--- a/inc/extensions/ext-birthday.php
+++ b/inc/extensions/ext-birthday.php
@@ -55,7 +55,7 @@ switch (getExtensionMode()) {
 	case 'remove': // Do stuff when removing extension
 		// SQL commands to run
 		addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` DROP birthday_sent");
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_user_birthday`');
+		addDropTableSql('user_birthday');
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='config_birthday'");
 		break;
 
@@ -77,16 +77,16 @@ 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");
-				addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_user_birthday`');
-				addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_birthday` (
+				addConfigAddSql('birthday_points', "BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
+				addDropTableSql('user_birthday');
+				addCreateTableSql('user_birthday', "(
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `points` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `chk_value` VARCHAR(255) NOT NULL DEFAULT '',
 KEY (`userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Pending birthday codes'");
 				addAdminMenuSql('setup','config_birthday','Geburtstagsmails','Stellen Sie hier ein, ob die Mitglieder {OPEN_CONFIG}POINTS{CLOSE_CONFIG} (nicht automatisch) gutgeschrieben kommen sollen oder nicht.', 9);
 
 				// Update notes (these will be set as task text!)
@@ -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.");