Return to Snippet

Revision: 10358
at December 22, 2008 06:39 by gerhardsletten


Initial Code
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`)
)

Initial URL

                                

Initial Description

                                

Initial Title
CakePHP user table

Initial Tags
cakephp

Initial Language
PHP