ks/20230218sql---.txt

ALTER TABLE EXAM_ANSWER_LOG 
ADD (DISCUSS_ANSWER CLOB );
ALTER TABLE EXAM_ANSWER_LOG 
ADD (discuss_scores INTEGER DEFAULT 0);

ALTER TABLE `practise_answer_log`
ADD COLUMN `discuss_answer`  CLOB NULL ,
ADD COLUMN `discuss_scores`  INTEGER NULL DEFAULT 0 ;

ALTER TABLE exam_log
ADD (discuss_answer_scores  INTEGER default 0, discuss_answer_count  INTEGER default 0);

ALTER TABLE exam_question
ADD (discuss_answer CLOB);




ALTER TABLE exam_paper
ADD (
	discuss_simple_count  INTEGER,
	discuss_mid_count  INTEGER,
	discuss_hard_count  INTEGER,
	discuss_scores  INTEGER,
	discuss_total_count  INTEGER,
	discuss_total_scores  INTEGER
);