ks/20230218sql.txt

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;