DROP TABLE IF EXISTS `employment_application`;
CREATE TABLE IF NOT EXISTS `employment_application` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `position_applying` varchar(125) NOT NULL,
  `work_in_canada` varchar(125) NOT NULL,
  `date_to_start` varchar(125) NOT NULL,
  `desired_pay` varchar(125) NOT NULL,
  `first_name` varchar(125) NOT NULL,
  `last_name` varchar(125) NOT NULL,
  `phone` varchar(12) NOT NULL,
  `email` varchar(256) NOT NULL,
  `address` varchar(512) NOT NULL,
  `street_address` varchar(512) NOT NULL,
  `province` varchar(125) NOT NULL,
  `city` varchar(125) NOT NULL,
  `postal_code` varchar(16) NOT NULL,
  `education_type_1` varchar(512) NOT NULL,
  `school_name_1` varchar(512) NOT NULL,
  `school_city_1` varchar(512) NOT NULL,
  `school_state_1` varchar(512) NOT NULL,
  `areas_studied_1` varchar(512) NOT NULL,
  `primary_earned_1` varchar(512) NOT NULL,
  `secondary_earned_1` varchar(512) NOT NULL,
  `date_started_1` varchar(16) NOT NULL,
  `date_ended_1` varchar(16) NOT NULL,
  `education_type_2` varchar(512) NOT NULL,
  `school_name_2` varchar(512) NOT NULL,
  `school_city_2` varchar(512) NOT NULL,
  `school_state_2` varchar(512) NOT NULL,
  `areas_studied_2` varchar(512) NOT NULL,
  `primary_earned_2` varchar(512) NOT NULL,
  `secondary_earned_2` varchar(512) NOT NULL,
  `date_started_2` varchar(16) NOT NULL,
  `date_ended_2` varchar(16) NOT NULL,
  `employer_name_1` varchar(512) NOT NULL,
  `job_city_1` varchar(512) NOT NULL,
  `job_state_1` varchar(512) NOT NULL,
  `supervisor_1` varchar(512) NOT NULL,
  `supervisor_phone_1` varchar(512) NOT NULL,
  `job_title_1` varchar(512) NOT NULL,
  `job_description_1` varchar(512) NOT NULL,
  `start_date_1` varchar(16) NOT NULL,
  `end_date_1` varchar(16) NOT NULL,
  `employer_name_2` varchar(512) NOT NULL,
  `job_city_2` varchar(512) NOT NULL,
  `job_state_2` varchar(512) NOT NULL,
  `supervisor_2` varchar(512) NOT NULL,
  `supervisor_phone_2` varchar(512) NOT NULL,
  `job_title_2` varchar(512) NOT NULL,
  `job_description_2` varchar(512) NOT NULL,
  `start_date_2` varchar(16) NOT NULL,
  `end_date_2` varchar(16) NOT NULL,
  `aditional_information` varchar(512) NOT NULL,
  `resume` varchar(512) NOT NULL,
  `_form` text NOT NULL,
  `session` varchar(256) NOT NULL,
  `submitted` varchar(126) NOT NULL,
  PRIMARY KEY (`id`)
)