cUfXxmC8

1DROP TABLE IF EXISTS `dietzeEnterprise`.`dtz_exhibitor_user_profiles`;
2CREATE TABLE  `dietzeEnterprise`.`dtz_exhibitor_user_profiles` (
3  `id` int(10) unsigned NOT NULL auto_increment,
4  `exhibitor_user_id` int(10) unsigned NOT NULL,
5  `profile_company_name` varchar(255) NOT NULL,
6  `profile_address_one` varchar(255) NOT NULL,
7  `profile_address_two` varchar(255) default NULL,
8  `profile_city` varchar(255) NOT NULL,
9  `profile_state` int(10) unsigned NOT NULL,
10  `profile_zipcode` varchar(20) NOT NULL,
11  `profile_phone` varchar(20) NOT NULL,
12  `profile_fax` varchar(20) default NULL,
13  `timestamp` int(15) unsigned NOT NULL,
14  `removed` tinyint(3) unsigned NOT NULL,
15  `profile_contact_name` varchar(255) NOT NULL,
16  PRIMARY KEY  (`id`)
17) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='holds all exhibitor user profile information';