ALTER TABLE `students_current` CHANGE `NCCAOMDate` `NCCAOMDate` DATE NULL, CHANGE `NCCAOMStatus` `NCCAOMStatus` TINYINT(1) NULL DEFAULT '0', CHANGE `ProgramLevel` `ProgramLevel` VARCHAR(35) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'Program level as in UnderGrad or Grad for MSAOM', CHANGE `gpa` `gpa` DOUBLE NULL DEFAULT '0', CHANGE `cgpa` `cgpa` DOUBLE NULL DEFAULT '0', CHANGE `ReferredBy` `ReferredBy` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `CALicenseLanguage` `CALicenseLanguage` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `NCCAOMOption` `NCCAOMOption` VARCHAR(35) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `JobPlacementStatusId` `JobPlacementStatusId` INT(2) NULL DEFAULT '0', CHANGE `AdmissionStatusId` `AdmissionStatusId` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0', CHANGE `ToeflWaived` `ToeflWaived` INT(1) NULL DEFAULT '0', CHANGE `TseWaived` `TseWaived` INT(1) NULL DEFAULT '0', CHANGE `sevisdateissue` `sevisdateissue` VARCHAR(35) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `sevisdateexpire` `sevisdateexpire` VARCHAR(35) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `financialaidfile` `financialaidfile` INT(1) NULL DEFAULT '0' COMMENT 'Financial Aid File Completion Status', CHANGE `folderlocationmemo` `folderlocationmemo` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `epatscore` `epatscore` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `tuitiongroupid` `tuitiongroupid` INT(2) NULL DEFAULT '1', CHANGE `active` `active` INT(1) NULL DEFAULT '1' COMMENT '1=active, 0=inactive', CHANGE `opt_startdate` `opt_startdate` DATE NULL DEFAULT NULL, CHANGE `sevis_remarks` `sevis_remarks` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `disableOnlineLogin_reason` `disableOnlineLogin_reason` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `disableEnrollmentClinic_reason` `disableEnrollmentClinic_reason` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `disableEnrollmentCourse_reason` `disableEnrollmentCourse_reason` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `programenrollment` `programenrollment` VARCHAR(35) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', CHANGE `programid` `programid` INT(3) NULL DEFAULT '0', CHANGE `Email2` `Email2` VARCHAR(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `birthcountry` `birthcountry` VARCHAR(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `ge_status` `ge_status` ENUM('Passed','Required','Not Applicable','') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'Not Applicable' COMMENT 'ge = general education', CHANGE `ge_memo` `ge_memo` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'ge = general education', CHANGE `cce1_memo` `cce1_memo` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `cce2_memo` `cce2_memo` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `bsc_student` `bsc_student` INT(1) NULL DEFAULT '0', CHANGE `bsc_starttermid` `bsc_starttermid` INT(4) NULL, CHANGE `bsc_endtermid` `bsc_endtermid` INT(4) NULL, CHANGE `first_available_exam_date` `first_available_exam_date` DATE NULL, CHANGE `date_of_cale_application` `date_of_cale_application` DATE NULL, CHANGE `license_passed_status` `license_passed_status` INT(1) NULL DEFAULT '0', CHANGE `programstartingtermid` `programstartingtermid` INT(4) NULL, CHANGE `cale_memo` `cale_memo` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `bce` `bce` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `bce_date` `bce_date` DATE NULL, CHANGE `ReferredBy_memo` `ReferredBy_memo` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `transcript_memo` `transcript_memo` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;