duxgyiJq

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
3  `ip_address` int(10) unsigned NOT NULL,
4  `username` varchar(15) NOT NULL,
5  `password` varchar(40) NOT NULL,
6  `salt` varchar(40) DEFAULT NULL,
7  `email` varchar(100) NOT NULL,
8  `activation_code` varchar(40) DEFAULT NULL,
9  `forgotten_password_code` varchar(40) DEFAULT NULL,
10  `remember_code` varchar(40) DEFAULT NULL,
11  `created_on` int(11) unsigned NOT NULL,
12  `last_login` int(11) unsigned DEFAULT NULL,
13  `active` tinyint(1) unsigned DEFAULT NULL,
14  `first_name` varchar(50) DEFAULT NULL,
15  `last_name` varchar(50) DEFAULT NULL,
16  `company` varchar(100) DEFAULT NULL,
17  `phone` varchar(20) DEFAULT NULL,
18  PRIMARY KEY (`id`)
19) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;