]> git.mxchange.org Git - mailer.git/blobdiff - inc/extensions/ext-holiday.php
Some HTML fixes, ext-sql_patches downgraded (!):
[mailer.git] / inc / extensions / ext-holiday.php
index 160a3ba580844dae63437359985ce861885649fe..0a984730fd7696122c13e13b3a98b69ac8ff78cd 100644 (file)
@@ -154,7 +154,7 @@ INDEX (`userid`)",
                                break;
 
                        case '0.1.3': // SQL queries for v0.1.3
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` ADD `holiday_active` ENUM('Y','N') NOT NULL DEFAULT 'N'");
+                               addExtensionAddTableColumnSql('user_data', 'holiday_active', "ENUM('Y','N') NOT NULL DEFAULT 'N'");
                                addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_max_receive` WHERE `value`=0 LIMIT 1");
                                addConfigAddSql('holiday_lock', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (getOneDay() * 2));
 
@@ -175,7 +175,7 @@ INDEX (`userid`)",
                                break;
 
                        case '0.1.6': // SQL queries for v0.1.6
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` ADD holiday_activated BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
+                               addExtensionAddTableColumnSql('user_data', 'holiday_activated', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 0');
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Fehlende Tabellenspalte hinzugefügt.");