]> git.mxchange.org Git - mailer.git/blobdiff - inc/extensions/ext-payout.php
Added BACKSLASH to prevent massive escaping
[mailer.git] / inc / extensions / ext-payout.php
index 7994ab2d1cce202ec1a8043545aed960804b65e5..963246ade9a42068ea4be04822056ae2645f3180 100644 (file)
@@ -127,7 +127,7 @@ PRIMARY KEY (`id`)",
                                break;
 
                        case '0.1.6': // SQL queries for v0.1.6
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE pass_enc pass_enc ENUM('md5','base64','xxx') NOT NULL DEFAULT 'xxx'");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE `pass_enc` `pass_enc` ENUM('md5','base64','xxx') NOT NULL DEFAULT 'xxx'");
                                break;
 
                        case '0.1.8': // SQL queries for v0.1.8
@@ -146,8 +146,8 @@ PRIMARY KEY (`id`)",
                                break;
 
                        case '0.2.1': // SQL queries for v0.2.1
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_payouts` CHANGE payout_total payout_total FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE rate rate FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_payouts` CHANGE `payout_total` `payout_total` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE `rate` `rate` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Problem mit Speicherung der Einstellungen beseitigt.");