DROP TABLE IF EXISTS `mvr_verifications`;
CREATE TABLE `mvr_verifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(9) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `vehicle_id` mediumint(9) DEFAULT NULL,
  `license_number` varchar(100) DEFAULT NULL,
  `license_country_id` varchar(255) DEFAULT NULL,
  `license_state_id` varchar(255) DEFAULT NULL,
  `chauffeur_cdl` varchar(10) DEFAULT NULL,
  `license_clear` varchar(10) DEFAULT NULL,
  `chauffeur_cdl_endorsement` varchar(255) DEFAULT NULL,
  
  `verified_by_src` varchar(255) DEFAULT NULL,
  `verified_by_emp` varchar(255) DEFAULT NULL,
  `fees` decimal(9,2) DEFAULT NULL,
  `verified_date` varchar(255) DEFAULT NULL,
  `verification_status` varchar(255) DEFAULT NULL,
  `employee` varchar(255) DEFAULT NULL,
  `last_update` varchar(255) DEFAULT NULL,
  `added_by_recruiter` char(1) DEFAULT NULL,
  `hard_copies_required` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `lrc_verifications`;
CREATE TABLE `lrc_verifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(9) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,

  `lrc_id` mediumint(9) DEFAULT NULL,
  `license_number` varchar(255) DEFAULT NULL,
  `license_expiration_date` varchar(255) DEFAULT NULL,


  `resp_lrc` varchar(255) DEFAULT NULL,
  `resp_license_number` varchar(255) DEFAULT NULL,
  `resp_license_expiration_date` varchar(255) DEFAULT NULL,

  `issued_date` varchar(255) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT NULL,
  `disciplinary_action` char(1) DEFAULT NULL,
  `disciplinary_action_description` varchar(255) DEFAULT NULL,


  `verified_by_src` varchar(255) DEFAULT NULL,
  `verified_by_emp` varchar(255) DEFAULT NULL,
  `fees` decimal(9,2) DEFAULT NULL,
  `verified_date` varchar(255) DEFAULT NULL,
  `verification_status` varchar(255) DEFAULT NULL,
  `employee` varchar(255) DEFAULT NULL,
  `last_update` varchar(255) DEFAULT NULL,
  `lifetime_certification` char(1) DEFAULT NULL,
  `added_by_recruiter` char(1) DEFAULT NULL,
  `hard_copies_required` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `malpractice_verifications`;
CREATE TABLE `malpractice_verifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(9) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `type_id` char(1) DEFAULT NULL,
  `other_name_used` varchar(255) DEFAULT NULL,
  `is_flagged` char(1) DEFAULT NULL,
  `organization_id` mediumint(9) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `street_address1` varchar(255) DEFAULT NULL,
  `street_address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state_id` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,

  `insurance_company` varchar(100) DEFAULT NULL,
  `start_date` varchar(50) DEFAULT NULL,
  `end_date` varchar(50) DEFAULT NULL,
  `policy_limits` varchar(255) DEFAULT NULL,
  `policy_number` varchar(50) DEFAULT NULL,

  `resp_insurance_company` varchar(100) DEFAULT NULL,
  `resp_start_date` varchar(50) DEFAULT NULL,
  `resp_end_date` varchar(50) DEFAULT NULL,
  `resp_policy_limits` varchar(255) DEFAULT NULL,
  `resp_policy_number` varchar(50) DEFAULT NULL,

  `general_comments` text DEFAULT NULL,
  `claims_history` char(1) DEFAULT NULL,
  `claims_history_explanation` text DEFAULT NULL,

  `verified_by_src` varchar(255) DEFAULT NULL,
  `verified_by_emp` varchar(255) DEFAULT NULL,
  `fees` decimal(9,2) DEFAULT NULL,
  `verified_date` varchar(255) DEFAULT NULL,
  `verification_status` varchar(255) DEFAULT NULL,
  `employee` varchar(255) DEFAULT NULL,
  `last_update` varchar(255) DEFAULT NULL,
  `added_by_recruiter` char(1) DEFAULT NULL,
  `hard_copies_required` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `id_verifications`;
CREATE TABLE `id_verifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(9) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,

  `e_verify` char(1) DEFAULT NULL,

  `applicant_name` varchar(255) DEFAULT NULL,
  `other_name` varchar(255) DEFAULT NULL,
  `resp_applicant_name` varchar(255) DEFAULT NULL,
  `resp_other_name` varchar(255) DEFAULT NULL,

  `ssn_valid` char(1) DEFAULT NULL,
  `compatible_with_app` char(1) DEFAULT NULL,
  `no_name_attached` char(1) DEFAULT NULL,
  `unable_to_determine` char(1) DEFAULT NULL,

  `verified_by_src` varchar(255) DEFAULT NULL,
  `verified_by_emp` varchar(255) DEFAULT NULL,
  `fees` decimal(9,2) DEFAULT NULL,
  `verified_date` varchar(255) DEFAULT NULL,
  `verification_status` varchar(255) DEFAULT NULL,
  `employee` varchar(255) DEFAULT NULL,
  `last_update` varchar(255) DEFAULT NULL,
  `added_by_recruiter` char(1) DEFAULT NULL,
  `hard_copies_required` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;





DROP TABLE IF EXISTS `drug_verifications`;
CREATE TABLE `drug_verifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(9) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,

  `drug_screening_id` mediumint(9) DEFAULT NULL,
  `drug_screening_clear` char(2) DEFAULT NULL,

  `verified_by_src` varchar(255) DEFAULT NULL,
  `verified_by_emp` varchar(255) DEFAULT NULL,
  `fees` decimal(9,2) DEFAULT NULL,
  `verified_date` varchar(255) DEFAULT NULL,
  `verification_status` varchar(255) DEFAULT NULL,
  `employee` varchar(255) DEFAULT NULL,
  `last_update` varchar(255) DEFAULT NULL,
  `added_by_recruiter` char(1) DEFAULT NULL,
  `hard_copies_required` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;