Still really confused, i just started over with a new table and I can't change primary keys or anything. Ugh!
I did show table and this is what I get:
CREATE TABLE `users` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`uname` text NOT NULL,
`pword` text NOT NULL,
`email` text NOT NULL,
`nickname` text NOT NULL,
`verified` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`),
UNIQUE KEY `userid` (`userid`),
KEY `userid_2` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
I *think* the query looks correct (except what is "KEY `userid_2` (`userid`)")... But this is what it actually shows:
Is anyone else confused?