Ic_ouath/global/user.sql

/*
 Navicat Premium Dump SQL

 Source Server         : 物联智控-统一登录
 Source Server Type    : MySQL
 Source Server Version : 80403 (8.4.3)
 Source Host           : 203.15.11.41:3306
 Source Schema         : Ic_ouath

 Target Server Type    : MySQL
 Target Server Version : 80403 (8.4.3)
 File Encoding         : 65001

 Date: 06/12/2024 16:13:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `username` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `account` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `phone` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `avatar` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `password` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `open_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `role` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `state` tinyint(1) NULL DEFAULT NULL,
  `session_key` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `update_by` bigint NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_deleted_at`(`deleted_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '2024-12-06 10:53:46.000', '2024-12-06 10:53:49.000', NULL, 'admin', 'admin', NULL, NULL, '5625be821f2fcbada6125fce0126d0e6', NULL, 'admin', 1, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;