X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fextensions%2Fext-user.php;h=a8f0afbeb3407d5a3f81820d51c0548f77ae4c5f;hb=20741b93fd58620af677a7f1039ffd16ea6ec689;hp=02fb15ab4f39fb13755ff3b27b0057842716f99f;hpb=61792dfed649685adf7d68e2b4b25195dd2712a1;p=mailer.git diff --git a/inc/extensions/ext-user.php b/inc/extensions/ext-user.php index 02fb15ab4f..a8f0afbeb3 100644 --- a/inc/extensions/ext-user.php +++ b/inc/extensions/ext-user.php @@ -17,7 +17,7 @@ * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -99,7 +99,7 @@ INDEX (`cat_id`)", PRIMARY KEY (`userid`), UNIQUE (`user_hash`), INDEX (`refid`), -INDEX `status_mails` (`status`, `max_mails`)", +INDEX `status_mails` (`status`,`max_mails`)", 'Main user data'); addDropTableSql('user_points'); @@ -372,7 +372,7 @@ INDEX (`userid`)", case '0.3.6': // SQL queries for v0.3.6 addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_cats` DROP INDEX `userid`'); - addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_cats` ADD UNIQUE `userid_catid` ( `userid` , `cat_id` )'); + addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_cats` ADD UNIQUE `userid_catid` (`userid` , `cat_id`)'); // Update notes (these will be set as task text!) setExtensionUpdateNotes("Der Sperrgrund wird nun mit abgespeichert und beim Löschen des Users mit ausgesendet."); @@ -464,7 +464,7 @@ INDEX (`userid`)", `level` smallINT(6) UNSIGNED NOT NULL DEFAULT 0, `refid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`), -UNIQUE `user_refid` (`userid`, `level`, `refid`), +UNIQUE `user_refid` (`userid`,`level`,`refid`), INDEX (`level`), INDEX (`refid`)", 'User referals');