dev/2020/2020-018(OK)/2020-018-cf-002.sql

use `dcp`;

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

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

ALTER TABLE `dcp`.`base_investment_guidelines_info` ADD `pdf_to_picture_file_ids` varchar(1024)DEFAULT NULL COMMENT 'pdf图片id' AFTER `file_visible_pages`;

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

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

ALTER TABLE `dcp`.`base_project_evaluation_report_info` ADD `pdf_to_picture_file_ids` varchar(1024)DEFAULT NULL COMMENT 'pdf图片id' AFTER `file_visible_pages`;

-- 159,161 已执行