X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fextensions%2Fext-primera.php;h=9d7373da88558fcacc7211f59d90c4a830ed2104;hb=b38ad6ba590c952cfe839d11d467c41a8bfe4748;hp=f16e3637118b7771f2cc7430a979822117fea6fa;hpb=8d0ed5ed9a9ca0e07b9582f2311b44bdcc5a95ea;p=mailer.git diff --git a/inc/extensions/ext-primera.php b/inc/extensions/ext-primera.php index f16e363711..9d7373da88 100644 --- a/inc/extensions/ext-primera.php +++ b/inc/extensions/ext-primera.php @@ -55,7 +55,7 @@ switch (getExtensionMode()) { case 'register': // Do stuff when installation is running // SQL commands to run addDropTableSql('user_primera'); - addCreateTableSql('user_primera', "( + addCreateTableSql('user_primera', " `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `primera_account` VARCHAR(255) NOT NULL DEFAULT '', @@ -64,9 +64,9 @@ switch (getExtensionMode()) { `primera_type` ENUM('IN','OUT','FAILED') NOT NULL DEFAULT 'FAILED', `primera_api_message` TINYTEXT, `primera_api_status` VARCHAR(255) NULL DEFAULT NULL, -KEY (`userid`), -PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Transfers in Primera'"); +PRIMARY KEY (`id`), +INDEX (`userid`)", + 'Transfers in Primera'); // Configuration addConfigAddSql('primera_min_payout', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 40000'); @@ -84,7 +84,7 @@ PRIMARY KEY (`id`) addAdminMenuSql('primera', 'list_primera', 'Primera-Anfragen auflisten', 'Listet alle Primera-Auszahlungsanfragen Ihrer Mitglieder auf.', 2); // Member menu - addMemberMenuSql('main', 'primera', 'Primera-Ein-/Auszahlungen', 'N', 'Y', 11); + addMemberMenuSql('main', 'primera', 'Primera-Ein-/Auszahlungen', 11); break; case 'remove': // Do stuff when removing extension