[GitHub] [dolphinscheduler] JinyLeeChina edited a comment on issue #6597: [Feature][Install] Upgrade dolphinscheduler version 1. X to version 2.0

[GitBox <gi...@apache.org>]

JinyLeeChina edited a comment on issue #6597:
URL: https://github.com/apache/dolphinscheduler/issues/6597#issuecomment-952508320


   ## Tables to modify
   t_ds_command
   t_ds_error_command
   t_ds_process_definition
   t_ds_process_instance
   t_ds_project
   t_ds_schedules
   t_ds_task_instance
   ## Tables to add
   t_ds_alert_plugin_instance
   t_ds_environment
   t_ds_environment_worker_group_relation
   t_ds_plugin_define
   t_ds_process_definition_log
   t_ds_process_task_relation
   t_ds_process_task_relation_log
   t_ds_task_definition
   t_ds_task_definition_log
   ## Table structure change no data migration
   ### t_ds_command
   ```
   alter table t_ds_command change process_definition_id process_definition_code bigint(20) DEFAULT NULL COMMENT 'process definition code';
   alter table t_ds_command add environment_code bigint(20) DEFAULT '-1' COMMENT 'environment code' AFTER worker_group;
   alter table t_ds_command add dry_run tinyint(4) DEFAULT '0' COMMENT 'dry run flag：0 normal, 1 dry run' AFTER environment_code;
   alter table t_ds_command add process_definition_version int(11) DEFAULT '0' COMMENT 'process definition version' AFTER process_definition_code;
   alter table t_ds_command add process_instance_id int(11) DEFAULT '0' COMMENT 'process instance id' AFTER process_definition_version;
   alter table t_ds_command add KEY `priority_id_index` (`process_instance_priority`,`id`) USING BTREE;
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org