2020-015-ljy-001.sql 1.3 KB

12345678910111213141516171819
  1. use `dcp`;
  2. ALTER TABLE `dcp`.`base_research_resources_entity` ADD `upload_carousel_map` varchar(12)DEFAULT NULL COMMENT '是否上传轮播图' AFTER `status`;
  3. ALTER TABLE `dcp`.`base_research_result_view` ADD `upload_carousel_map` varchar(12)DEFAULT NULL COMMENT '是否上传轮播图' AFTER `weight`;
  4. ALTER TABLE `dcp`.`base_research_result_entity` ADD `upload_carousel_map` varchar(12)DEFAULT NULL COMMENT '是否上传轮播图' AFTER `status`;
  5. ALTER TABLE `dcp`.`base_research_resources_view` ADD `upload_carousel_map` varchar(12)DEFAULT NULL COMMENT '是否上传轮播图' AFTER `file_address`;
  6. ALTER TABLE `dcp`.`base_research_resources_entity` ADD `carousel_map_address` varchar(2000) DEFAULT NULL COMMENT '轮播图片地址' AFTER `upload_carousel_map`;
  7. ALTER TABLE `dcp`.`base_research_resources_view` ADD `carousel_map_address` varchar(2000) DEFAULT NULL COMMENT '轮播图片地址' AFTER `upload_carousel_map`;
  8. ALTER TABLE `base_research_result_entity` ADD `carousel_map_address` varchar(2000) DEFAULT NULL COMMENT '轮播图片地址' AFTER `upload_carousel_map`;
  9. ALTER TABLE `dcp`.`base_research_result_view` ADD `carousel_map_address` varchar(2000) DEFAULT NULL COMMENT '轮播图片地址' AFTER `upload_carousel_map`;
  10. ALTER TABLE `dcp`.`base_research_resources_view` MODIFY COLUMN `name` varchar(64) DEFAULT NULL COMMENT '名称';