Re: "Keys should not both be set for column..."

2006-09-30 Thread Pat Adams
On Sat, 2006-09-30 at 12:51 -0700, Brian Dunning wrote: > 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` timestam

"Keys should not both be set for column..."

2006-09-30 Thread Brian Dunning
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