Advanced Search

CakePHP user table

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

Expand | Embed | Plain Text

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.