X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-grade.php;h=abd36e7c82d5c725f371d547b205671494cc7bcf;hp=c09535931cf18fdb2bc6155b307e82017abeacf5;hb=0f3a135204757cc8750262871c8e62c42300acb4;hpb=56931cd9321119dd37372bd16d6c552857e40066 diff --git a/inc/extensions/ext-grade.php b/inc/extensions/ext-grade.php index c09535931c..abd36e7c82 100644 --- a/inc/extensions/ext-grade.php +++ b/inc/extensions/ext-grade.php @@ -59,7 +59,7 @@ switch (getExtensionMode()) { `grade_description` TINYTEXT NOT NULL, `grade_parent_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, PRIMARY KEY (`id`), -UNIQUE KEY (`grade_name`), +UNIQUE (`grade_name`), INDEX (`grade_parent_id`)", 'Grade general data'); @@ -73,7 +73,7 @@ INDEX (`grade_parent_id`)", `reached_mails` BIGINT(20) UNSIGNED NULL DEFAULT NULL, `time_valid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`), -UNIQUE KEY (`grade_cash_name`)", +UNIQUE (`grade_cash_name`)", 'Grade data if the grade have been "cashed"'); // Connection grade<->cash data @@ -83,7 +83,7 @@ UNIQUE KEY (`grade_cash_name`)", `grade_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `grade_cash_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`), -UNIQUE KEY `grade_cash` (`grade_id`, `grade_cash_id`), +UNIQUE `grade_cash` (`grade_id`,`grade_cash_id`), INDEX (`grade_cash_id`)", 'Grade<->cash data connection'); @@ -95,7 +95,7 @@ INDEX (`grade_cash_id`)", `grade_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `grade_expired` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), -UNIQUE KEY (`userid`, `grade_id`), +UNIQUE (`userid`,`grade_id`), INDEX (`grade_id`)", 'Grade<->user connection');