   `password_hash` char(128) COLLATE utf8_bin NOT NULL COMMENT 'SHA-512 hash represented as a hexidecimal string.',
   `password_salt` char(6) COLLATE utf8_bin NOT NULL COMMENT 'Password salt.',
   `authtoken` char(32) COLLATE utf8_bin NOT NULL COMMENT 'The user''s current authtoken.',
+  `gpc` tinyint(1) NOT NULL COMMENT 'The GPC of the user.  -1 is banned, 0 is guest, 1 is admin.',
+  `user_realname` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'The "real name" of the user.',
+  `user_dtype` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT 'Deviously Deviant' COMMENT 'The deviant type of the deviant.',
+  `user_symbol` char(1) COLLATE utf8_bin NOT NULL DEFAULT '~' COMMENT 'The usersymbol of the deviant.',
   PRIMARY KEY (`user_id`),
-  KEY `user_name` (`user_name`,`user_id`,`authtoken`,`password_hash`,`password_salt`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
+  UNIQUE KEY `user_name_2` (`user_name`),
+  KEY `user_name` (`user_name`,`user_id`,`authtoken`,`password_hash`,`password_salt`),
+  KEY `id_lookup` (`user_id`,`gpc`,`user_realname`,`user_dtype`,`user_symbol`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin ;
 
 --
 -- Constraints for dumped tables

  `privclass_id` int(8) unsigned NOT NULL COMMENT 'The ID of the privclass.',
  `privclass_name` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'The name of the privclass.',
  `order` smallint(2) unsigned NOT NULL COMMENT 'The chatroom order of the privclass.',
  `admin` bit(1) NOT NULL DEFAULT '\0' COMMENT 'Admin privs?',
  `kick` bit(1) NOT NULL DEFAULT '\0' COMMENT 'Kick privs?',
  `join` bit(1) NOT NULL DEFAULT '' COMMENT 'Join privs?',
  `msg` bit(1) NOT NULL DEFAULT '' COMMENT 'Message privs?',
  `topic` bit(1) NOT NULL DEFAULT '\0' COMMENT 'Topic privs?',
  `title` bit(1) NOT NULL DEFAULT '\0' COMMENT 'Title privs?',
  `shownotice` bit(1) NOT NULL DEFAULT '' COMMENT 'Show notices apon join/part?',
  `promote` smallint(2) unsigned NOT NULL DEFAULT '0' COMMENT 'Promote privs.',
  `demote` smallint(2) unsigned NOT NULL DEFAULT '0' COMMENT 'Demote privs.',
  `images` mediumint(3) NOT NULL DEFAULT '0' COMMENT 'Image privs. -1 for unlimited, 0 for none, [number] max.',

  PRIMARY KEY (`chatroom_id`),
  UNIQUE KEY `chatroom_name` (`chatroom_name`),
  KEY `roomcreatorid` (`chatroom_creator_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin ;

-- --------------------------------------------------------

