/*
 Navicat Premium Data Transfer

 Source Server         : DP Demo测试服务器
 Source Server Type    : MySQL
 Source Server Version : 50737
 Source Host           : 140.143.236.86:3306
 Source Schema         : dpdemo

 Target Server Type    : MySQL
 Target Server Version : 50737
 File Encoding         : 65001

 Date: 22/07/2022 04:31:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_account_auth
-- ----------------------------
DROP TABLE IF EXISTS `sys_account_auth`;
CREATE TABLE `sys_account_auth`  (
  `account_auth_id` int(20) NOT NULL AUTO_INCREMENT COMMENT 'PK',
  `rel_table` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联表名，一般情况下为SYS_USER，即关联sys_user表的用户数据，部分业务中，可能鉴权信息要对应例如sys_user、sys_admin两个表，那么rel_table就是需要关联的表',
  `rel_id` bigint(20) NOT NULL COMMENT '关联表的id，一般为用户表的id',
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'TOKEN',
  `valid_at` datetime(0) DEFAULT NULL COMMENT 'TOKEN有效期',
  `secret_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'key，加密用',
  `secret_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'sercret，加密用',
  `sort` int(6) DEFAULT 99 COMMENT '排序',
  `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '状态，是否生效，0：未生效；1：生效',
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '备注',
  `version` smallint(6) DEFAULT 0 COMMENT '版本号',
  `deleted_flag` tinyint(6) DEFAULT 0 COMMENT '删除标记',
  `created_by` int(11) DEFAULT NULL COMMENT '创建用户',
  `created_at` datetime(0) DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间戳',
  `updated_by` int(11) DEFAULT NULL COMMENT '更新用户',
  `updated_at` datetime(0) DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间戳',
  `deleted_by` int(11) DEFAULT NULL COMMENT '删除人',
  `deleted_at` datetime(0) DEFAULT NULL COMMENT '删除时间戳',
  PRIMARY KEY (`account_auth_id`) USING BTREE,
  INDEX `idx_token`(`token`) USING BTREE,
  INDEX `idx_rel_table`(`rel_table`) USING BTREE,
  INDEX `idx_rel_id`(`rel_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '鉴权信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_account_auth
-- ----------------------------
INSERT INTO `sys_account_auth` VALUES (1, 'SYS_USER', 1, 'e222836a6a464d119c2af43bca19a9ef', NULL, '8nvsoe', 'cjjhm668l19aqfrm', 1, '1', '99', NULL, 0, 1, '2022-01-08 17:05:24', 1, '2022-07-20 18:11:47', NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;