004_beta9.sql 1.2 KB

1234567891011121314151617181920
  1. ALTER TABLE `davinci_statistic_duration`
  2. ADD COLUMN `org_id` BIGINT(20) NULL COMMENT '报表关联组织ID' AFTER `email`;
  3. ALTER TABLE `davinci_statistic_duration`
  4. ADD COLUMN `project_id` BIGINT(20) NULL COMMENT '报表关联项目ID' AFTER `org_id`;
  5. ALTER TABLE `davinci_statistic_duration`
  6. ADD COLUMN `project_name` VARCHAR(255) NULL COMMENT '报表关联项目名称' AFTER `project_id`;
  7. ALTER TABLE `davinci_statistic_duration`
  8. ADD COLUMN `viz_type` VARCHAR(10) NULL COMMENT '报表关联应用类型(dashboard/display)' AFTER `project_name`;
  9. ALTER TABLE `davinci_statistic_duration`
  10. ADD COLUMN `viz_id` BIGINT(20) NULL COMMENT '报表关联应用ID' AFTER `viz_type`;
  11. ALTER TABLE `davinci_statistic_duration`
  12. ADD COLUMN `viz_name` VARCHAR(255) NULL COMMENT '报表关联应用名称' AFTER `viz_id`;
  13. ALTER TABLE `davinci_statistic_duration`
  14. ADD COLUMN `sub_viz_id` BIGINT(20) NULL COMMENT '报表ID' AFTER `viz_name`;
  15. ALTER TABLE `davinci_statistic_duration`
  16. ADD COLUMN `sub_viz_name` VARCHAR(255) NULL COMMENT '报表名称' AFTER `sub_viz_id`;
  17. ALTER TABLE `display`
  18. ADD COLUMN `config` text NULL AFTER `publish`;
  19. ALTER TABLE `cron_job`
  20. MODIFY COLUMN `update_by` bigint(20) NULL DEFAULT NULL AFTER `create_time`;