X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-earning.php;h=cd8f3a9f4ac0a73caf92d5f29a38379c80f1738b;hp=4ef86a53cfdfc86b428ea30109293eff3ebf254a;hb=31281c21661cd6329c45305a0544268388801791;hpb=75c607f5f29956eb71599aee3f682753e4d21fef diff --git a/inc/extensions/ext-earning.php b/inc/extensions/ext-earning.php index 4ef86a53cf..cd8f3a9f4a 100644 --- a/inc/extensions/ext-earning.php +++ b/inc/extensions/ext-earning.php @@ -65,7 +65,7 @@ switch (getExtensionMode()) { `earning_provider` 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_provider`)", +UNIQUE INDEX `earning_group_name` (`earning_group`,`earning_provider`)", 'Registered (extra) earnings'); // User->earnings connection table @@ -81,7 +81,7 @@ UNIQUE `earning_group_name` (`earning_group`,`earning_provider`)", `earning_current_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`), +UNIQUE INDEX `user_earning` (`earning_id`,`earning_userid`), INDEX (`earning_userid`)", 'User->Earning connections');