Extension ext-earning introduced (unfinished), renamings:

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

diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index b6b738dffbb20d8897c5f82600da5966447e8089..d2f04f2fd87efe0f78dded2bb32f1e72e28e60ed 100644 (file)
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -77,8 +77,7 @@ IN (
        'config_proxy',
        'config_session',
        'list_filter',
-       'list_point_accounts',
-       'list_earnings'
+       'list_point_accounts'
 )");
 
                // Delete/update member menu entries
@@ -192,7 +191,7 @@ IN (
                                break;
 
                        case '0.1.2': // SQL queries for v0.1.2
-                               addAdminMenuSql('setup','config_refid','Standard-Ref-Id','Stellen Sie hier die Mitglieder-Id ein, die genommen werden soll, wenn der Gast n icht per Referal-Link Ihren {?mt_word?} aufgerufen hat.', 7);
+                               addAdminMenuSql('setup','config_refid','Standard-Ref-Id','Stellen Sie hier die Mitglied-Id ein, die genommen werden soll, wenn der Gast n icht per Referal-Link Ihren {?mt_word?} aufgerufen hat.', 7);
                                addConfigAddSql('def_refid', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 0');
 
                                // Update notes (these will be set as task text!)
@@ -874,41 +873,8 @@ INDEX (`history_last_used` DESC)",
                                // Old-lost configuration entry
                                addConfigDropSql('ext_autopurge');
 
-                               // Extra earning for our members :-)
-                               addMemberMenuSql('earn', 'earnings', 'Zusatzverdienste', 2);
-
-                               // Admin menu
-                               addAdminMenuSql('setup', 'list_earnings', 'Zusatzverdienste...', 'Veralten Sie hier bequem alle Zusatzverdienste (wie z.B. vergütete PopUps usw.).', 6);
-
-                               // Earning data table
-                               addDropTableSql('earning_data');
-                               addCreateTableSql('earning_data', "
-`earning_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`earning_group` VARCHAR(255) NOT NULL DEFAULT 'INVALID',
-`earning_name` VARCHAR(255) NOT NULL DEFAULT 'INVALID',
-`earning_sorting` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-PRIMARY KEY (`earning_id`),
-UNIQUE `earning_group_name` (`earning_group`,`earning_name`)",
-                                       'Registered (extra) earnings');
-
-                               // User->earnings connection table
-                               addDropTableSql('user_earning');
-                               addCreateTableSql('user_earning', "
-`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`earning_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`earning_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`earning_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
-`earning_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-`earning_cancelled` TIMESTAMP NULL DEFAULT NULL,
-`earning_daily_amount` SMALLINT(7) NOT NULL DEFAULT 0,
-`earning_points` FLOAT(20,5) NOT NULL DEFAULT 0.00000,
-PRIMARY KEY (`id`),
-UNIQUE `user_earning` (`earning_id`,`earning_userid`),
-INDEX (`earning_userid`)",
-                                       'User->Earning connections');
-
                                // Update notes (these will be set as task text!)
-                               setExtensionUpdateNotes("Menüpunkt für Zusatzverdienste wie z.B. Forced-PopUps hinzugefügt und uralten Konfigurationseintrag entfernt.");
+                               setExtensionUpdateNotes("Uralten Konfigurationseintrag entfernt.");
                                break;
                } // END - switch
                break;