CREATE TABLE `trn_comment_msg` (

  `comMsgId` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论消息主键',

  `msgId` int(11) NOT NULL COMMENT '消息ID',

  `comId` int(11) NOT NULL COMMENT '课程评论ID',

  `createUserId` int(11) NOT NULL COMMENT '消息创建人Id',

  PRIMARY KEY (`comMsgId`),

  KEY `fk_comMsg_msg_idx` (`msgId`),

  KEY `fk_comMsg_com_idx` (`comId`),

  KEY `fk_trn_comment_msg_vs_usr_user_info_idx` (`createUserId`),

  CONSTRAINT `fk_comMsg_com` FOREIGN KEY (`comId`) REFERENCES `trn_course_comment` (`comId`) ON DELETE CASCADE ON UPDATE NO ACTION,

  CONSTRAINT `fk_comMsg_msg` FOREIGN KEY (`msgId`) REFERENCES `sys_msg` (`msgId`) ON DELETE CASCADE ON UPDATE NO ACTION,

  CONSTRAINT `fk_trn_comment_msg_vs_usr_user_info_on_createUserId` FOREIGN KEY (`createUserId`) REFERENCES `sys_user` (`userId`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=189 DEFAULT CHARSET=utf8 COMMENT='评论消息表';

ALTER TABLE `trn_comment_msg`

ADD COLUMN `content` VARCHAR(1000) NOT NULL COMMENT '消息内容' AFTER `createUserId`,

ADD COLUMN `courseName` VARCHAR(20) NOT NULL COMMENT '课程名称' AFTER `content`;

-- trn_course_comment历史数据迁移

update trn_comment_msg tcm

inner join trn_course_comment tcc on tcm.comId=tcc.comId

inner join trn_course tc on tc.courseId=tcc.courseId

set tcm.content=tcc.content,tcm.courseName=tc.courseName

SET SQL_SAFE_UPDATES=0；

SET FOREIGN_KEY_CHECKS=0;