yvjia/db/sys_queue.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023-12-30 12:49:53
*/

DROP TABLE IF EXISTS `sys_queue`;
CREATE TABLE `sys_queue` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `queue_code` VARCHAR(255) NOT NULL COMMENT '队列编码',
    `queue_type` VARCHAR(255) NOT NULL COMMENT '队列类型',
    `json_content` TEXT NOT NULL COMMENT '队列内容',
    `operator_user_id` BIGINT COMMENT '操作人用户ID',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统队列表';

INSERT INTO sys_queue(queue_code, queue_type, operator_user_id, json_content) VALUES
    ('QE-4F425F79051A4436AAC440C891523BF4', 'MAKE_VIRTUALMAN', 1, '{\'anchor_name\':\'张三\'}'),
    ('QE-4F425F79051A4436AAC440C891523BF5', 'MAKE_VIRTUALMAN', 1, '{\'anchor_name\':\'李四\'}'),
    ('QE-4F425F79051A4436AAC440C891523BF6', 'MAKE_TIMBRE', 1, '{\'video_name\':\'王五\'}')
;