Mailer project continued:

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

diff --git a/inc/extensions/ext-grade.php b/inc/extensions/ext-grade.php
index 0ec4081d60695cd907fd4eea216045eab8cd21fa..4f2c430f2be7fff37547aac32cd051b1fc7e0b90 100644 (file)
--- 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');