# Sample table structure for the SimpleLoginSecure CodeIgniter Library.

# Version for MySQL 5.0 or 5.5

CREATE TABLE `users` (

`user_id` int(10) unsigned NOT NULL auto_increment,

`user_email` varchar(255) NOT NULL default '',

`user_pass` varchar(60) NOT NULL default '',

`user_date` datetime NOT NULL default '0000-00-00 00:00:00',

`user_modified` datetime NOT NULL default '0000-00-00 00:00:00',

`user_last_login` datetime NULL default NULL,

PRIMARY KEY (`user_id`),

UNIQUE KEY `user_email` (`user_email`)

) DEFAULT CHARSET=utf8;