Posted By

gerhardsletten on 12/22/08


Tagged

cakephp


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

jpsirois
rubenrails
hmvrulz


CakePHP user table


 / Published in: PHP
 

  1. CREATE TABLE `cake_users` (
  2. `id` int(10) unsigned NOT NULL auto_increment,
  3. `username` varchar(50) collate utf8_bin NOT NULL default '',
  4. `password` varchar(60) collate utf8_bin NOT NULL default '',
  5. `firstname` varchar(50) collate utf8_bin NOT NULL default '',
  6. `lastname` varchar(50) collate utf8_bin NOT NULL default '',
  7. `email` varchar(100) collate utf8_bin NOT NULL default '',
  8. `bio` text collate utf8_bin NOT NULL,
  9. `location` varchar(250) collate utf8_bin NOT NULL,
  10. `cookie` varchar(200) collate utf8_bin NOT NULL,
  11. `admin` tinyint(1) NOT NULL,
  12. `created` datetime NOT NULL,
  13. `modified` datetime NOT NULL,
  14. PRIMARY KEY (`id`),
  15. UNIQUE KEY `username` (`username`)
  16. )

Report this snippet  

You need to login to post a comment.