use dcp;

ALTER TABLE cms_information_entity
ADD COLUMN `reviewer_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人姓名' AFTER `information_status_dict`,
ADD COLUMN `reviewer_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人id' AFTER `reviewer_name`,
ADD COLUMN `reviewer_date` datetime(0) COMMENT '审核时间' AFTER `reviewer_id`;


ALTER TABLE cms_information_info
ADD COLUMN `reviewer_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人姓名' AFTER `information_status_dict`,
ADD COLUMN `reviewer_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人id' AFTER `reviewer_name`,
ADD COLUMN `reviewer_date` datetime(0) COMMENT '审核时间' AFTER `reviewer_id`;


ALTER TABLE cms_information_view
ADD COLUMN `reviewer_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人姓名' AFTER `information_status_dict`,
ADD COLUMN `reviewer_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人id' AFTER `reviewer_name`,
ADD COLUMN `reviewer_date` datetime(0) COMMENT '审核时间' AFTER `reviewer_id`;

/*161  159 已执行  2021.4.27*/