• Registered: 2007-05-02
  • Posts: 15

Topic: MySQL: Index types INDEX und UNIQUE

Hello,

I've spotted a strange warning in table "Online":
http://www.wechselbass.de/punbb.jpg

It says: The index-types INDEX and UNIQUE should not be set  for Column "user_id" at the same time.

I'm not a MySQL-Pro at all. Perhaps that's normal?

If not, how can I fix the problem?

Regards
Tom

  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: MySQL: Index types INDEX und UNIQUE

phpMyAdmin isn't taking in account that user_id and ident are a linked unique key, so that it isn't redundant at all.

Ignore the warning.

  • Registered: 2007-05-02
  • Posts: 15

Re: MySQL: Index types INDEX und UNIQUE

Hi elbekko,

thanks for the answer.
The Problem is that i'm not able to optimize the table "Online" due to that behavior.

What would you suggest to do?

Regards
Tom

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: MySQL: Index types INDEX und UNIQUE

That's not the reason you can't optimize it, you can't optimize it because it's a HEAP table and thus doesn't require optimization.

  • Registered: 2007-05-02
  • Posts: 15

Re: MySQL: Index types INDEX und UNIQUE

Hi Smartys,

thanks a lot!
I still have to learn so much...

Regards
Tom