CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`first_name` varchar(30) collate latin1_general_ci NOT NULL default '',
`last_name` varchar(30) collate latin1_general_ci NOT NULL default '',
`email` varchar(75) collate latin1_general_ci NOT NULL default '',
`password` varchar(15) collate latin1_general_ci NOT NULL default '',
`address1` varchar(100) collate latin1_general_ci NOT NULL default '',
`address2` varchar(100) collate latin1_general_ci NOT NULL default '',
`city` varchar(30) collate latin1_general_ci NOT NULL default '',
`state` varchar(30) collate latin1_general_ci NOT NULL default '',
`country` varchar(50) collate latin1_general_ci NOT NULL default '',
`postal_code` varchar(10) collate latin1_general_ci NOT NULL default '',
`type` int(1) NOT NULL default '0',
`date_joined` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`status` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;