| 123456789101112131415161718192021 |
- # /**
- # Source Server Version: 8.0.31
- # Source Database: backendsys
- # Date: 2025/06/03 10:09:22
- # */
- #
- # DROP TABLE IF EXISTS `comfyui_task`;
- # CREATE TABLE `comfyui_task` (
- # PRIMARY KEY (`id`),
- # `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
- # `user_id` BIGINT NOT NULL COMMENT '用户ID',
- # `client_id` VARCHAR(255) COMMENT 'Client ID',
- # `task_type` VARCHAR(255) NOT NULL COMMENT '任务类型 (Text2Image, ..)',
- # `task_status` TINYINT DEFAULT '-1' COMMENT '任务状态 (-1:未提交, 1:已提交)',
- # `generate_request` TEXT COMMENT '任务请求原始参数 (JSONString)',
- # `in_master` TINYINT DEFAULT '-1' COMMENT '队列状态 (-1:未进主队列, 1:已进主队列)',
- # `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- # `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- # INDEX `idx_user_id` (`user_id`),
- # INDEX `idx_in_master` (`in_master`)
- # ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='任务表';
|
