DROP TABLE IF EXISTS `__PREFIX__jxapi_jxtoken`;
CREATE TABLE `__PREFIX__jxapi_jxtoken`  (
                                     `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
                                     `appkey` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'appkey',
                                     `appsecret` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'appsecret',
                                     `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'token',
                                     `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',
                                     `expiretime` int(11) NULL DEFAULT NULL COMMENT '过期时间',
                                     PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '匠星token' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of fa_jxapi_jxtoken
-- ----------------------------
INSERT INTO `__PREFIX__jxapi_jxtoken` VALUES (1, '20240109', '946fc1ced7d12ecd3cb2c854400f6061', NULL, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;

DROP TABLE IF EXISTS `__PREFIX__jxapi_fail_log`;
CREATE TABLE `__PREFIX__jxapi_fail_log`  (
                                    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                    `fail_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '参数',
                                    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建失败',
                                    `number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
                                    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '匠星提交失败表' ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;