CREATE TABLE `tbl_company_profiles` (
  `company_id` int(10) unsigned NOT NULL auto_increment,
  `company_name` varchar(100) NOT NULL,
  `company_type` smallint(5) unsigned NOT NULL,
  `company_addressLine1` varchar(100) NOT NULL,
  `company_addressLine2` varchar(100) default NULL,
  `company_city` varchar(50) NOT NULL,
  `company_state` varchar(50) NOT NULL,
  `country_id` int(10) unsigned NOT NULL,
  `company_zipcode` varchar(20) NOT NULL,
  `company_phone` varchar(30) NOT NULL,
  `company_fax` varchar(30) default NULL,
  `company_email` varchar(100) NOT NULL,
  `company_url` varchar(100) NOT NULL,
  `company_desc` text NOT NULL,
  `company_add_date` datetime NOT NULL,
  PRIMARY KEY  (`company_id`),
  KEY `country_id` (`country_id`),
  KEY `company_name` (`company_name`),
  CONSTRAINT `tbl_company_profiles_ibfk_2` FOREIGN KEY (`country_id`) REFERENCES `tbl_countries` (`country_id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=3 /*!40100 DEFAULT CHARSET=utf8*/;

CREATE TABLE `tbl_images` (
  `image_id` int(10) unsigned NOT NULL auto_increment,
  `company_id` int(10) unsigned NOT NULL,
  `image_name` varchar(50) NOT NULL,
  `image_height` tinyint(3) unsigned NOT NULL,
  `image_width` tinyint(3) unsigned NOT NULL,
  `image_type` varchar(50) NOT NULL,
  `image_ext` varchar(10) NOT NULL,
  PRIMARY KEY  (`image_id`),
  KEY `company_id` (`company_id`),
  CONSTRAINT `tbl_images_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `tbl_company_profiles` (`company_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 /*!40100 DEFAULT CHARSET=utf8*/;