dev/2021/待发布/SQL/2021-004-wzw-003.sql

use dcp;

ALTER TABLE base_unit_entity
ADD COLUMN `reviewer_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人姓名' AFTER `child_count`,
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 base_unit_info
ADD COLUMN `reviewer_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人姓名' AFTER `showable`,
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 base_unit_view
ADD COLUMN `reviewer_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人姓名' AFTER `language`,
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.5.13*/