wangxj3 commented on a change in pull request #6722:
URL: https://github.com/apache/dolphinscheduler/pull/6722#discussion_r759082935
##########
File path:
dolphinscheduler-dao/src/main/resources/sql/dolphinscheduler_mysql.sql
##########
@@ -1017,3 +1020,40 @@ CREATE TABLE `t_ds_environment_worker_group_relation` (
PRIMARY KEY (`id`),
UNIQUE KEY `environment_worker_group_unique`
(`environment_code`,`worker_group`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
+
+-- ----------------------------
+-- Table structure for t_ds_task_group_queue
+-- ----------------------------
+DROP TABLE IF EXISTS `t_ds_task_group_queue`;
+CREATE TABLE `t_ds_task_group_queue` (
+ `id` int(11) NOT NULL AUTO_INCREMENT COMMENT'key',
+ `task_id` int(11) DEFAULT NULL COMMENT 'taskintanceid',
+ `task_name` varchar(100) DEFAULT NULL COMMENT 'TaskInstance name',
+ `group_id` int(11) DEFAULT NULL COMMENT 'taskGroup id',
+ `process_id` int(11) DEFAULT NULL COMMENT 'processInstace id',
+ `priority` int(8) DEFAULT '0' COMMENT 'priority',
+ `status` tinyint(4) DEFAULT '-1' COMMENT '-1: waiting 1: running 2:
finished',
+ `force_start` tinyint(4) DEFAULT '0' COMMENT 'is force start 0 NO ,1 YES',
+ `in_queue` tinyint(4) DEFAULT '0' COMMENT 'ready to get the queue by other
task finish 0 NO ,1 YES',
+ `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
+ `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
+ PRIMARY KEY( `id` )
Review comment:
There are many different query scenarios, and the effect of adding
indexes is not obvious. We will consider whether to add task_id and group_id
later
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
