[Old Pedant]

That is *REALLY* what you got from SHOW CREATE TABLE users??

Then the display in PHPMyAdmin? Then I think you need to remove PHPMyAdmin from your system and re-install it.

Because it's clearly braindead.

HOWEVER...

You must have also done something wrong when you did the CREATE TABLE, in the first place.

You have THREE indexes all defined on the field userid which makes no sense at all.

On top of that, you are using the TEXT data type which is a VERY expensive data type for no reason at all! Not just once by FOUR times!

Try doing *JUST THIS*:

CREATE TABLE users (
    userid INT AUTO_INCREMENT PRIMARY KEY,
    uname VARCHAR(30) NOT NULL,
    pword VARCHAR(30) NOT NULL,
    email VARCHAR(200) NOT NULL,
    nickname VARCHAR(30) NOT NULL,
    verified BOOLEAN NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

When I do that and then do show create table users I get:

+-------+--------------------------------------------
| Table | Create Table
+-------+--------------------------------------------
| users | CREATE TABLE `users` (
  `userid` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(30) NOT NULL,
  `pword` varchar(30) NOT NULL,
  `email` varchar(200) NOT NULL,
  `nickname` varchar(30) NOT NULL,
  `verified` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+--------------------------------------------