CREATE TABLE `cake_users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(50) collate utf8_bin NOT NULL default '',
  `password` varchar(60) collate utf8_bin NOT NULL default '',
  `firstname` varchar(50) collate utf8_bin NOT NULL default '',
  `lastname` varchar(50) collate utf8_bin NOT NULL default '',
  `email` varchar(100) collate utf8_bin NOT NULL default '',
  `bio` text collate utf8_bin NOT NULL,
  `location` varchar(250) collate utf8_bin NOT NULL,
  `cookie` varchar(200) collate utf8_bin NOT NULL,
  `admin` tinyint(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
)

CakePHP user table

cakephp

PHP