science-ation/db/db.update.186.sql
2010-06-17 15:11:59 +00:00

5 lines
332 B
SQL

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;