39 lines
1.2 KiB
SQL
39 lines
1.2 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : localhost_3306
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80023 (8.0.23)
|
|
Source Host : localhost:3306
|
|
Source Schema : step
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80023 (8.0.23)
|
|
File Encoding : 65001
|
|
|
|
Date: 25/12/2024 15:06:14
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for step_task
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `step_task`;
|
|
CREATE TABLE `step_task` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`biz_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`state` tinyint NOT NULL DEFAULT '0',
|
|
`error_info` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`message_body` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`create_time` datetime DEFAULT NULL,
|
|
`update_time` datetime DEFAULT NULL,
|
|
`task_id` bigint DEFAULT '0',
|
|
`test` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `key` (`biz_key`,`state`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|