CakePHP user table


/ Published in: PHP
Save to your folder(s)



Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.