dev/2020/2020-016(OK)/2020-016-ljy-002.sql

use `dcp`;

ALTER TABLE `dcp`.`base_research_result_info` ADD `file_visible_status` varchar(12)DEFAULT NULL COMMENT '是否非会员可见' AFTER `weight`;

ALTER TABLE `dcp`.`base_research_result_info` ADD `file_visible_pages` varchar(12)DEFAULT NULL COMMENT '非会员可见页数' AFTER `file_visible_status`;

ALTER TABLE `dcp`.`base_research_result_view` ADD `file_visible_status` varchar(12)DEFAULT NULL COMMENT '是否非会员可见' AFTER `weight`;

ALTER TABLE `dcp`.`base_research_result_view` ADD `file_visible_pages` varchar(12)DEFAULT NULL COMMENT '非会员可见页数' AFTER `file_visible_status`;

ALTER TABLE `dcp`.`base_research_application` DROP COLUMN `date_of_visitors`;

ALTER TABLE `dcp`.`base_research_application` ADD `start_date_of_visitors` datetime COMMENT '参观开始时间' AFTER `number_of_visitors`;

ALTER TABLE `dcp`.`base_research_application` ADD `end_date_of_visitors` datetime COMMENT '参观结束时间' AFTER `start_date_of_visitors`;