Do not add columns to CREATE statements if you already add them with ALTER TABLE

[mailer.git] / inc / extensions / ext-refback.php

diff --git a/inc/extensions/ext-refback.php b/inc/extensions/ext-refback.php
index adbaa02b933daabf996a4802a3834dac2ab525d1..192176096e86feffaa1945380682cc98392859b5 100644 (file)
--- a/inc/extensions/ext-refback.php
+++ b/inc/extensions/ext-refback.php
@@ -108,10 +108,10 @@ switch (getExtensionMode()) {
                                addExtensionDependency('user');
 
                                // SQL commands to run - drop old first, add new next
-                               addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_refs` DROP `refback`');
-                               addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_refs` DROP `points`');
-                               addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_refs` ADD `refback_percents` FLOAT(4,1) NOT NULL DEFAULT 0.0');
-                               addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_refs` ADD `refback_points` FLOAT(20,5) NOT NULL DEFAULT 0.00000');
+                               addExtensionDropTableColumnSql('user_refs', 'refback`');
+                               addExtensionDropTableColumnSql('user_refs', 'points`');
+                               addExtensionAddTableColumnSql('user_refs', 'refback_percents', 'FLOAT(4,1) NOT NULL DEFAULT 0.0');
+                               addExtensionAddTableColumnSql('user_refs', 'refback_points', 'FLOAT(20,5) NOT NULL DEFAULT 0.00000');
 
                                // Update notes
                                setExtensionUpdateNotes("Refback-Gutschriften werden nun &uuml;ber die Tabelle <strong>{OPEN_CONFIG}_MYSQL_PREFIX{CLOSE_CONFIG}_points_data</strong> verwaltet.");