ALTER TABLE `be_FormCareer`
 ADD `older18` ENUM('y','n') NULL DEFAULT NULL AFTER `email`,
 ADD `legally` ENUM('y','n') NULL DEFAULT NULL AFTER `older18`; 

ALTER TABLE `be_FormCareer` 
 ADD `positionAppliedFor` VARCHAR(255) NOT NULL AFTER `workExperience`,
 ADD `workTime` ENUM('full','part','temporary') NOT NULL AFTER `positionAppliedFor`,
 ADD `partTimeSpecify` VARCHAR(255) NULL DEFAULT NULL AFTER `workTime`,
 ADD `workStartDate` DATE NOT NULL AFTER `partTimeSpecify`,
 ADD `salary` DECIMAL(10,2) NOT NULL AFTER `workStartDate`,
 ADD `wasApplied` ENUM('y','n') NOT NULL AFTER `salary`,
 ADD `alreadyWorked` ENUM('y','n') NOT NULL AFTER `wasApplied`,
 ADD `skills` TEXT NOT NULL AFTER `alreadyWorked`,
 ADD `wasTerminated` ENUM('y','n') NOT NULL AFTER `skills`,
 ADD `terminationDetails` TEXT NULL DEFAULT NULL AFTER `wasTerminated`; 
 
ALTER TABLE `be_FormCareer`  
 ADD `reference1Name` VARCHAR(255) NULL DEFAULT NULL  AFTER `terminationDetails`,
 ADD `reference1Phone` VARCHAR(255) NULL DEFAULT NULL  AFTER `reference1Name`,
 ADD `reference1Address` VARCHAR(255) NULL DEFAULT NULL  AFTER `reference1Phone`,
 ADD `reference1Description` TEXT NULL DEFAULT NULL  AFTER `reference1Address`,
 ADD `reference2Name` VARCHAR(255) NULL DEFAULT NULL  AFTER `reference1Description`,
 ADD `reference2Phone` VARCHAR(255) NULL DEFAULT NULL  AFTER `reference2Name`,
 ADD `reference2Address` VARCHAR(255) NULL DEFAULT NULL  AFTER `reference2Phone`,
 ADD `reference2Description` TEXT NULL DEFAULT NULL  AFTER `reference2Address`,
 ADD `reference3Name` VARCHAR(255) NULL DEFAULT NULL  AFTER `reference2Description`,  
 ADD `reference3Phone` VARCHAR(255) NULL DEFAULT NULL  AFTER `reference3Name`,  
 ADD `reference3Address` VARCHAR(255) NULL DEFAULT NULL  AFTER `reference3Phone`,  
 ADD `reference3Description` TEXT NULL DEFAULT NULL  AFTER `reference3Address`;
 
 
 UPDATE `be_zz_Settings` SET `description` = 'Constants: {jobTitle} {jobLocation} {firstName} {middleName} {lastName} {address} {address2} {city} {state} {zip} {phone} {phone2} {email} {file} {education} {workExperience} {older18} {legally} {positionAppliedFor} {workTime} {partTimeSpecify} {workStartDate} {salary} {wasApplied} {alreadyWorked} {skills} {wasTerminated} {terminationDetails} {reference1Name} {reference1Phone} {reference1Address} {reference1Description} {reference2Name} {reference2Phone} {reference2Address} {reference2Description} {reference3Name} {reference3Phone} {reference3Address} {reference3Description} {link}' WHERE `be_zz_Settings`.`name` = 'careerFormEmailBody';
 
 UPDATE `be_zz_Settings` SET `description` = 'Constants: {jobTitle} {jobLocation} {firstName} {middleName} {lastName} {address} {address2} {city} {state} {zip} {phone} {phone2} {email} {file} {education} {workExperience} {older18} {legally} {positionAppliedFor} {workTime} {partTimeSpecify} {workStartDate} {salary} {wasApplied} {alreadyWorked} {skills} {wasTerminated} {terminationDetails} {reference1Name} {reference1Phone} {reference1Address} {reference1Description} {reference2Name} {reference2Phone} {reference2Address} {reference2Description} {reference3Name} {reference3Phone} {reference3Address} {reference3Description}' WHERE `be_zz_Settings`.`name` = 'careerFormUserEmailBody';


 ALTER TABLE `be_Career` ADD `expirationDate` DATE NOT NULL AFTER `jobLocation`;