X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Ffix_refsystem.php;h=916795cd0fc3cb526672c55f331b0fd574a9df08;hb=846ac0998b0735e3c538de5b3c22e4e199cb2cb2;hp=31bbf1d420d76955b8ec2768731979be5702bf08;hpb=20741b93fd58620af677a7f1039ffd16ea6ec689;p=mailer.git

diff --git a/inc/fix_refsystem.php b/inc/fix_refsystem.php
index 31bbf1d420..916795cd0f 100644
--- a/inc/fix_refsystem.php
+++ b/inc/fix_refsystem.php
@@ -50,7 +50,7 @@ if (!SQL_HASZERONUMS($result)) {
 	SQL_QUERY('UPDATE `{?_MYSQL_PREFIX?}_refsystem` SET `level`=`level`+1', __FILE__, __LINE__);
 
 	// Add it again
-	SQL_ALTER_TABLE('ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` ADD UNIQUE `userid_level` (`userid`,`level`)', __FILE__, __LINE__);
+	SQL_ALTER_TABLE('ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` ADD UNIQUE INDEX `userid_level` (`userid`,`level`)', __FILE__, __LINE__);
 
 	// Rebuild cache
 	rebuildCache('refsystem', 'refsystem');