Etusivu Tutki Apua
Kirjaudu sisään
WangKang
/
emoon-backend
1
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Haara: master-arch-20260326
Haarat Tagit
emoon-backend
/
script
/
sql
/
mysql-bak-2025-09-26
/
sys_user.sql

sys_user.sql 8.8 KB
Pysyvä linkki Historia Raaka

1234567891011121314151617181920212223242526272829303132333435363738394041 
  1. create table sys_user
    2. 

  2. (
    3. 

  3.     user_id     bigint                          not null comment '用户ID'
    4. 

  4.         primary key,
    5. 

  5.     tenant_id   varchar(20)  default '000000'   null comment '租户编号',
    6. 

  6.     dept_id     bigint                          null comment '部门ID',
    7. 

  7.     user_name   varchar(30)                     not null comment '用户账号',
    8. 

  8.     nick_name   varchar(30)                     not null comment '用户昵称',
    9. 

  9.     user_type   varchar(10)  default 'sys_user' null comment '用户类型（sys_user系统用户）',
    10. 

  10.     email       varchar(50)  default ''         null comment '用户邮箱',
    11. 

  11.     phonenumber varchar(11)  default ''         null comment '手机号码',
    12. 

  12.     sex         char         default '0'        null comment '用户性别（0男 1女 2未知）',
    13. 

  13.     avatar      bigint                          null comment '头像地址',
    14. 

  14.     password    varchar(100) default ''         null comment '密码',
    15. 

  15.     status      char         default '0'        null comment '帐号状态（0正常 1停用）',
    16. 

  16.     del_flag    char         default '0'        null comment '删除标志（0代表存在 1代表删除）',
    17. 

  17.     login_ip    varchar(128) default ''         null comment '最后登录IP',
    18. 

  18.     login_date  datetime                        null comment '最后登录时间',
    19. 

  19.     create_dept bigint                          null comment '创建部门',
    20. 

  20.     create_by   bigint                          null comment '创建者',
    21. 

  21.     create_time datetime                        null comment '创建时间',
    22. 

  22.     update_by   bigint                          null comment '更新者',
    23. 

  23.     update_time datetime                        null comment '更新时间',
    24. 

  24.     remark      varchar(500)                    null comment '备注'
    25. 

  25. )
    26. 

  26.     comment '用户信息表';
    27. 

  27. 

  28. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1, '000000', 103, 'admin', '疯狂的狮子Li', 'sys_user', 'crazyLionLi@163.com', '15888888888', '1', null, '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '0:0:0:0:0:0:0:1', '2025-09-25 14:37:40', 103, 1, '2025-08-23 21:51:22', -1, '2025-09-25 14:37:40', '管理员');
    29. 

  29. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (3, '000000', 108, 'test', '本部门及以下 密码666666', 'sys_user', '', '', '0', null, '$2a$10$b8yUzN0C71sbz.PhNOCgJe.Tu1yWC3RNrTyjSQ8p1W0.aaUXUJ.Ne', '0', '1', '127.0.0.1', '2025-08-23 21:51:22', 103, 1, '2025-08-23 21:51:22', 1, '2025-08-25 21:41:42', null);
    30. 

  30. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (4, '000000', 102, 'test1', '仅本人 密码666666', 'sys_user', '', '', '0', null, '$2a$10$b8yUzN0C71sbz.PhNOCgJe.Tu1yWC3RNrTyjSQ8p1W0.aaUXUJ.Ne', '0', '1', '127.0.0.1', '2025-08-23 21:51:22', 103, 1, '2025-08-23 21:51:22', 1, '2025-08-25 21:41:40', null);
    31. 

  31. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959256836340740098, '889144', 1959256835975835649, 'wangkang', 'wangkang', 'sys_user', '', '', '0', null, '$2a$10$5NUcnT9ky1WT/j8lTI60husf7xDnqVGi0rvgxS0DHd42Scv4Zt72G', '0', '1', '0:0:0:0:0:0:0:1', '2025-08-23 22:34:15', 103, 1, '2025-08-23 22:10:06', 1, '2025-08-25 21:33:37', null);
    32. 

  32. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959258627635703810, '889144', 1959258497121546242, 'wangkangtest', '王康', 'sys_user', '', '', '0', null, '$2a$10$borHXQ2zopVohRws5xLlmO6RYQGfGWX3uD7bwcLNjDCjIhEOLkpD6', '0', '1', '', null, 1959256835975835649, 1959256836340740098, '2025-08-23 22:17:13', 1, '2025-08-25 21:33:32', '');
    33. 

  33. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959895782492508161, '000000', 101, 'wangkang1', 'wangkang1', 'sys_user', '', '', '0', null, '$2a$10$R0bdjrrgunthQVslIi8e1O0lQMQskJCaOXYftDldscgfVb7m79W7u', '0', '1', '', null, 103, 1, '2025-08-25 16:29:02', 1, '2025-08-25 21:41:38', '');
    34. 

  34. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959895868698038273, '000000', 103, 'wangkang11', 'wangkang11', 'sys_user', '', '', '0', null, '$2a$10$6xm4MT8QZd.Htc5IcBayZe4AWZDeJ82PfofGK/zdaBT2SsTOqiR.W', '0', '1', '', null, 103, 1, '2025-08-25 16:29:23', 1, '2025-08-25 21:41:35', '');
    35. 

  35. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959974023941099522, '889144', 1959973138921984002, 'hantuo', '韩拓', 'sys_user', '', '', '0', null, '$2a$10$Hv0mYBTQBNJCGIcZuZWtVOqB1xdCUXsLnOGnCUtIQJkXtMgwwEnpK', '0', '0', '', null, 103, 1, '2025-08-25 21:39:57', 1, '2025-08-25 21:39:57', '');
    36. 

  36. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959974153628979201, '889144', 1959973138921984002, 'fansicheng', '樊思呈', 'sys_user', '', '', '0', null, '$2a$10$yKWbl1JNQ3uhAlO4bxw/8uZem0Gxyq5gfSB0t72KJIzjEiROIQHE2', '0', '0', '', null, 103, 1, '2025-08-25 21:40:27', 1, '2025-08-25 21:41:23', '');
    37. 

  37. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959974270645866497, '889144', 1959973199605174273, 'wangkang', '王康', 'sys_user', '', '', '0', null, '$2a$10$00qbRAzZOxCn9Qa1KfeuMOWnz.TgIfCQvcgsVJPJNKWZ6vgIFBaB.', '0', '0', '', null, 103, 1, '2025-08-25 21:40:55', 1, '2025-08-25 21:51:36', '');
    38. 

  38. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959976407979298818, '841063', 1959976407618588674, 'wangkang', 'wangkang', 'sys_user', '', '', '0', null, '$2a$10$nmAHXPceOPlaUq7Ybgok2O1LG2OwppK8VoFoHUOeSuoOC7yd88Vsm', '0', '0', '', null, 103, 1, '2025-08-25 21:49:25', 1, '2025-08-25 21:49:25', null);
    39. 

  39. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1960316478058205186, '938163', 1960316477680717825, 'emoonadmin', 'emoonadmin', 'sys_user', '', '', '0', null, '$2a$10$6E/nPk7e1fHtRUomiajyEe0K/47x8PGtkz4gpKinkqfjpNlSWW5W.', '0', '0', '0:0:0:0:0:0:0:1', '2025-08-26 20:31:29', 103, 1, '2025-08-26 20:20:44', -1, '2025-08-26 20:31:29', null);
    40. 

  40. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1960318326831910913, '938163', 1960317285679828994, 'gaoli', '高力', 'sys_user', '', '', '0', null, '$2a$10$bbX9X150tKRHfyJcBE6QeOcDXvDndkEGCFh8D0zUbuQDb9N.gx7Dq', '0', '0', '0:0:0:0:0:0:0:1', '2025-08-26 20:28:31', 1960316477680717825, 1960316478058205186, '2025-08-26 20:28:05', -1, '2025-08-26 20:28:31', '');
    41. 

  41. INSERT INTO ruoyi.sys_user (user_id, tenant_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1970144018062905346, '000000', 101, 'wangkangtest', '王康', 'sys_user', '', '', '0', null, '$2a$10$dXA.d6sDIle75bVb3OnEMeBp..bgBUUCXC07xeDXGop.xIQHWG5m.', '0', '0', '0:0:0:0:0:0:0:1', '2025-09-22 23:12:19', 103, 1, '2025-09-22 23:11:52', -1, '2025-09-22 23:12:19', '');
    42.