ALTER TABLE `exam_answer_log` ADD COLUMN `discuss_answer` longtext NULL AFTER `main_id`, ADD COLUMN `discuss_scores` int(5) NULL DEFAULT 0 AFTER `discuss_answer`; ALTER TABLE `practise_answer_log` ADD COLUMN `discuss_answer` longtext NULL , ADD COLUMN `discuss_scores` int(5) NULL DEFAULT 0 ; ALTER TABLE `exam_paper` ADD COLUMN `discuss_simple_count` int(11) NULL, ADD COLUMN `discuss_mid_count` int(11) NULL, ADD COLUMN `discuss_hard_count` int(11) NULL, ADD COLUMN `discuss_scores` int(11) NULL, ADD COLUMN `discuss_total_count` int(11) NULL, ADD COLUMN `discuss_total_scores` int(11) NULL; ALTER TABLE `exam_question` ADD COLUMN `discuss_answer` longtext NULL AFTER `create_user_id`; ALTER TABLE `exam_log` ADD COLUMN `discuss_answer_scores` int(11) default 0 , ADD COLUMN `discuss_answer_count` int(11) default 0;