devops/zzz/schema/sys_user.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost-mysql
 Source Server Type    : MySQL
 Source Server Version : 50732
 Source Host           : 127.0.0.1:3306
 Source Schema         : reghao_bnt_rdb

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

 Date: 18/12/2024 10:26:45
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `avatar_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` int(11) NOT NULL,
  `salt` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted` bit(1) NOT NULL,
  `create_at` datetime(6) DEFAULT NULL,
  `enabled` bit(1) DEFAULT NULL,
  `encoded_password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `locked` bit(1) DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screen_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code_repo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_sb8bbouer5wak8vyiiy4pf2bx` (`username`),
  KEY `FK4dm5kxn3potpfgdigehw7pdyu` (`role_id`),
  CONSTRAINT `FK4dm5kxn3potpfgdigehw7pdyu` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, '2021-05-11 15:20:05.995018', '2024-07-09 09:53:40.282301', '/dist/images/avatar.jpg', '', 1, 'ZECtOZ27sT6QfRhHhdhi2pOT8TjaAgAne5yh676NlsuqJZItwZkr5Kh1Vpngnq8+JsE7NHPaipuZa89dqxN7sg==', 'admin', b'0', '2021-05-11 15:20:05.995018', b'1', '712d5adb24c04a42e175dd4999aa6aae', b'0', NULL, '管理员', NULL, '712d5adb24c04a42e175dd4999aa6aae', 1);
INSERT INTO `sys_user` VALUES (2, '2024-07-24 10:01:21.803235', '2024-07-24 10:01:21.803241', '/dist/images/avatar.jpg', '', 3, 'LEdHIzGnKkz3g+hd7S1VFs2JAri4smljLNJ283xZMGeGfo9zWZbJEGSqT1+SQzxr55fTsLTGXq31jox7qjIYag==', 'gjsoss', b'0', '2024-07-24 10:01:21.802627', b'1', '347941db73b403756c229890f90ec5f9', b'0', NULL, 'gjsoss', NULL, '347941db73b403756c229890f90ec5f9', 4);
INSERT INTO `sys_user` VALUES (3, '2024-07-24 14:14:25.939487', '2024-08-21 20:02:16.967809', '/dist/images/avatar.jpg', '', 3, 'DrRN+RroDW3ocLz237fMWsRcIDKjYtPCEgG3xQMJ4CNrbOlhtOFZRv6c6pTW06ROmz5eQu7Qb6AdCtgdYpciww==', 'gjsblog', b'0', '2024-07-24 14:14:25.933995', b'1', 'd182c0ec8d63b38d51a3a6374b379051', b'0', NULL, 'gjsblog', NULL, 'd182c0ec8d63b38d51a3a6374b379051', 3);
INSERT INTO `sys_user` VALUES (4, '2024-07-24 10:01:10.143778', '2024-08-21 21:43:18.504841', '/dist/images/avatar.jpg', '', 3, '53AUSF60qImgqx/E8cm2dBROuG0DaOAHDgLOx0aNhAVN1qfXwY362EWh9qiw+/pVJ77jSyY0w/q9hT8YFXzZcw==', 'gjstnb', b'0', '2024-07-24 10:01:10.143205', b'1', '201544e0d8ed121e4a17a7bf652cad3c', b'0', NULL, 'gjstnb', NULL, '201544e0d8ed121e4a17a7bf652cad3c', 6);
INSERT INTO `sys_user` VALUES (5, '2024-07-24 10:02:59.133520', '2024-08-21 21:26:31.604453', '/dist/images/avatar.jpg', '', 3, 't5QQfMblpPOVxWiGVlwOjq1Qr5uUjRYU3baqNW7lzUVFBKprtb8jYVNRb1TdtvTs72biirOIhj9/BfwZmpb0cA==', 'gjs1990', b'0', '2024-07-24 10:02:59.131751', b'1', '4d22797bc713325d2eb8589ac6e41799', b'0', NULL, 'gjs', NULL, '4d22797bc713325d2eb8589ac6e41799', 5);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;