X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-grade.php;h=4f2c430f2be7fff37547aac32cd051b1fc7e0b90;hp=0ec4081d60695cd907fd4eea216045eab8cd21fa;hb=2df9f7a53f8b1dd5164f87824a324ccb3b6634cb;hpb=a2c7de83aee38352745f21273b04dc43963da9b7

diff --git a/inc/extensions/ext-grade.php b/inc/extensions/ext-grade.php
index 0ec4081d60..4f2c430f2b 100644
--- a/inc/extensions/ext-grade.php
+++ b/inc/extensions/ext-grade.php
@@ -58,7 +58,7 @@ switch (getExtensionMode()) {
 `grade_name` VARCHAR(255) NOT NULL DEFAULT '',
 `grade_description` TINYTEXT NOT NULL,
 `grade_parent_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
-UNIQUE (`grade_name`),
+UNIQUE INDEX (`grade_name`),
 INDEX (`grade_parent_id`),
 PRIMARY KEY (`grade_id`)",
 			'Grade data');
@@ -72,7 +72,7 @@ PRIMARY KEY (`grade_id`)",
 `reached_points` FLOAT(20,5) UNSIGNED NULL DEFAULT NULL,
 `reached_mails` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
 `time_valid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-UNIQUE (`grade_cash_name`),
+UNIQUE INDEX (`grade_cash_name`),
 PRIMARY KEY (`cash_id`)",
 			'Data for "cashed" grades');
 
@@ -82,7 +82,7 @@ PRIMARY KEY (`cash_id`)",
 `connect_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `grade_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `grade_cash_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-UNIQUE INDEX `grade_cash` (`grade_id`,`grade_cash_id`),
+UNIQUE INDEX `grade_cash` (`grade_id`, `grade_cash_id`),
 INDEX (`grade_cash_id`),
 PRIMARY KEY (`connect_id`)",
 			'Grade<->cash data connection');
@@ -94,7 +94,7 @@ PRIMARY KEY (`connect_id`)",
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `grade_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `grade_expired` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
-UNIQUE (`userid`,`grade_id`),
+UNIQUE INDEX (`userid`, `grade_id`),
 INDEX (`grade_id`),
 PRIMARY KEY (`connect_id`)",
 			'Grade<->user connection');