Create users table
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL auto_increment,
`slug` varchar(40) NOT NULL,
`username` varchar(30) NOT NULL,
`password` varchar(40) NOT NULL,
`first_name` varchar(40) NOT NULL,
`last_name` varchar(40) NOT NULL,
`email` varchar(100) NOT NULL,
`email_verified` tinyint(1) NOT NULL default '0',
`carrier_id` int(11) NOT NULL,
`cell_number` varchar(10) NOT NULL,
`modified` datetime NULL,
`created` datetime NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `slug` (`slug`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
The
created
and
modified
(or
updated
, either name works) fields will be filled in by CakePHP automatically, as long as they are set as
DATETIME
fields and default to
NULL
.
Long field names are separated with underscores '_' so CakePHP can easily understand them.
No comments:
Post a Comment