Hi, gerald_clark: > > KEY `Trap` (`IP`,`Type`,`epoch`), > > KEY `IP` (`IP`) > > > Your second key is redundant.
True (there's a UNIQUE missing in there). Deleting the first key, however, doesn't change anything. -- Matthias Urlichs | {M:U} IT Design @ m-u-it.de | [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]