X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Ffix_menu.php;h=da6e5dcf97ebc0efa53d8aa0deda9a10f5b4f52f;hb=34ac21e92a4bb77b1151e0ddba1242d20c3394b6;hp=99fda9dab2e687895e053895dc6bab6955597c18;hpb=0a37fc5afcd828646d4e62e68fea07c3d2c54a87;p=mailer.git diff --git a/inc/fix_menu.php b/inc/fix_menu.php index 99fda9dab2..da6e5dcf97 100644 --- a/inc/fix_menu.php +++ b/inc/fix_menu.php @@ -99,11 +99,11 @@ foreach (array('guest','member','admin') as $menu) { // Now insert our unqiue key for action-what combination addSql(sprintf("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` DROP KEY `action_what`", $menu)); - addSql(sprintf("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` ADD UNIQUE `action_what` (`action` , `what`)", $menu)); + addSql(sprintf("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` ADD UNIQUE INDEX `action_what` (`action` , `what`)", $menu)); // Now insert our unqiue key for what addSql(sprintf("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` DROP KEY `what`", $menu)); - addSql(sprintf("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` ADD UNIQUE `what` (`what`)", $menu)); + addSql(sprintf("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` ADD UNIQUE INDEX `what` (`what`)", $menu)); // And run all runFilterChain('run_sqls');