Home Explore Help
Register Sign In
lizhenghang
/
dev
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
dev
/
2021
/
待发布
/
SQL
/
2021-004-wzw-001.sql

2021-004-wzw-001.sql 1.2 KB
Permalink History Raw

1234567891011121314151617181920 
  1. use dcp;
    2. 

  2. 

  3. ALTER TABLE cms_information_entity
    4. 

  4. ADD COLUMN `reviewer_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人姓名' AFTER `information_status_dict`,
    5. 

  5. ADD COLUMN `reviewer_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人id' AFTER `reviewer_name`,
    6. 

  6. ADD COLUMN `reviewer_date` datetime(0) COMMENT '审核时间' AFTER `reviewer_id`;
    7. 

  7. 

  8. 

  9. ALTER TABLE cms_information_info
    10. 

  10. ADD COLUMN `reviewer_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人姓名' AFTER `information_status_dict`,
    11. 

  11. ADD COLUMN `reviewer_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人id' AFTER `reviewer_name`,
    12. 

  12. ADD COLUMN `reviewer_date` datetime(0) COMMENT '审核时间' AFTER `reviewer_id`;
    13. 

  13. 

  14. 

  15. ALTER TABLE cms_information_view
    16. 

  16. ADD COLUMN `reviewer_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人姓名' AFTER `information_status_dict`,
    17. 

  17. ADD COLUMN `reviewer_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核人id' AFTER `reviewer_name`,
    18. 

  18. ADD COLUMN `reviewer_date` datetime(0) COMMENT '审核时间' AFTER `reviewer_id`;
    19. 

  19. 

  20. /*161  159 已执行  2021.4.27*/
    21.