phpMyAdmin is giving me the following warning:
PRIMARY and INDEX keys should not both be set for column `referer`
Here is what the table looks like:
CREATE TABLE `myspacemap_visitors_2` (
`creation` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
`lat` double NOT NULL default '0',
`lon` double NOT NULL default '0',
`referer` int(12) NOT NULL default '0',
PRIMARY KEY (`referer`,`lat`,`lon`),
KEY `creation` (`creation`,`referer`),
KEY `referer` (`referer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
What does this warning mean, and should I do anything about it or
just ignore it? Everything is working fine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]