ALTER TABLE `users_student` CHANGE `users_uid` `users_id` INT( 11 ) NOT NULL, CHANGE `students_active` `student_active` ENUM( 'no', 'yes' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , CHANGE `students_complete` `student_complete` ENUM( 'no', 'yes' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;