Home Explore Help
Register Sign In
zoie
/
Medical_OAuth
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Medical_OAuth
/
conf
/
db.sql

db.sql 11 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869 
  1. INSERT INTO sys_dict_data VALUES (1, 0, '正常', '2', 'sys_normal_disable', '', '', '', '2', '', '系统正常', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:40.168', NULL);
    2. 

  2. INSERT INTO sys_dict_data VALUES (2, 0, '停用', '1', 'sys_normal_disable', '', '', '', '2', '', '系统停用', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    3. 

  3. INSERT INTO sys_dict_data VALUES (3, 0, '男', '0', 'sys_user_sex', '', '', '', '2', '', '性别男', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    4. 

  4. INSERT INTO sys_dict_data VALUES (4, 0, '女', '1', 'sys_user_sex', '', '', '', '2', '', '性别女', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    5. 

  5. INSERT INTO sys_dict_data VALUES (5, 0, '未知', '2', 'sys_user_sex', '', '', '', '2', '', '性别未知', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    6. 

  6. INSERT INTO sys_dict_data VALUES (6, 0, '显示', '0', 'sys_show_hide', '', '', '', '2', '', '显示菜单', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    7. 

  7. INSERT INTO sys_dict_data VALUES (7, 0, '隐藏', '1', 'sys_show_hide', '', '', '', '2', '', '隐藏菜单', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    8. 

  8. INSERT INTO sys_dict_data VALUES (8, 0, '是', 'Y', 'sys_yes_no', '', '', '', '2', '', '系统默认是', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    9. 

  9. INSERT INTO sys_dict_data VALUES (9, 0, '否', 'N', 'sys_yes_no', '', '', '', '2', '', '系统默认否', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    10. 

  10. INSERT INTO sys_dict_data VALUES (10, 0, '正常', '2', 'sys_job_status', '', '', '', '2', '', '正常状态', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    11. 

  11. INSERT INTO sys_dict_data VALUES (11, 0, '停用', '1', 'sys_job_status', '', '', '', '2', '', '停用状态', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    12. 

  12. INSERT INTO sys_dict_data VALUES (12, 0, '默认', 'DEFAULT', 'sys_job_group', '', '', '', '2', '', '默认分组', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    13. 

  13. INSERT INTO sys_dict_data VALUES (13, 0, '系统', 'SYSTEM', 'sys_job_group', '', '', '', '2', '', '系统分组', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    14. 

  14. INSERT INTO sys_dict_data VALUES (14, 0, '通知', '1', 'sys_notice_type', '', '', '', '2', '', '通知', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    15. 

  15. INSERT INTO sys_dict_data VALUES (15, 0, '公告', '2', 'sys_notice_type', '', '', '', '2', '', '公告', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    16. 

  16. INSERT INTO sys_dict_data VALUES (16, 0, '正常', '2', 'sys_common_status', '', '', '', '2', '', '正常状态', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    17. 

  17. INSERT INTO sys_dict_data VALUES (17, 0, '关闭', '1', 'sys_common_status', '', '', '', '2', '', '关闭状态', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    18. 

  18. INSERT INTO sys_dict_data VALUES (18, 0, '新增', '1', 'sys_opera_type', '', '', '', '2', '', '新增操作', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    19. 

  19. INSERT INTO sys_dict_data VALUES (19, 0, '修改', '2', 'sys_opera_type', '', '', '', '2', '', '修改操作', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    20. 

  20. INSERT INTO sys_dict_data VALUES (20, 0, '删除', '3', 'sys_opera_type', '', '', '', '2', '', '删除操作', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    21. 

  21. INSERT INTO sys_dict_data VALUES (21, 0, '授权', '4', 'sys_opera_type', '', '', '', '2', '', '授权操作', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    22. 

  22. INSERT INTO sys_dict_data VALUES (22, 0, '导出', '5', 'sys_opera_type', '', '', '', '2', '', '导出操作', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    23. 

  23. INSERT INTO sys_dict_data VALUES (23, 0, '导入', '6', 'sys_opera_type', '', '', '', '2', '', '导入操作', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    24. 

  24. INSERT INTO sys_dict_data VALUES (24, 0, '强退', '7', 'sys_opera_type', '', '', '', '2', '', '强退操作', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    25. 

  25. INSERT INTO sys_dict_data VALUES (25, 0, '生成代码', '8', 'sys_opera_type', '', '', '', '2', '', '生成操作', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    26. 

  26. INSERT INTO sys_dict_data VALUES (26, 0, '清空数据', '9', 'sys_opera_type', '', '', '', '2', '', '清空操作', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    27. 

  27. INSERT INTO sys_dict_data VALUES (27, 0, '成功', '0', 'sys_notice_status', '', '', '', '2', '', '成功状态', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    28. 

  28. INSERT INTO sys_dict_data VALUES (28, 0, '失败', '1', 'sys_notice_status', '', '', '', '2', '', '失败状态', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    29. 

  29. INSERT INTO sys_dict_data VALUES (29, 0, '登录', '10', 'sys_opera_type', '', '', '', '2', '', '登录操作', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    30. 

  30. INSERT INTO sys_dict_data VALUES (30, 0, '退出', '11', 'sys_opera_type', '', '', '', '2', '', '', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    31. 

  31. INSERT INTO sys_dict_data VALUES (31, 0, '获取验证码', '12', 'sys_opera_type', '', '', '', '2', '', '获取验证码', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    32. 

  32. INSERT INTO sys_dict_data VALUES (32, 0, '正常', '1', 'sys_content_status', '', '', '', '1', '', '', 1, 1, '2022-08-23 19:56:40.845', '2022-08-23 19:56:40.845', NULL);
    33. 

  33. INSERT INTO sys_dict_data VALUES (33, 1, '禁用', '2', 'sys_content_status', '', '', '', '1', '', '', 1, 1, '2022-08-23 19:56:40.845', '2022-08-23 19:56:40.845', NULL);
    34. 

  34. INSERT INTO sys_dict_data VALUES (48, 1, '全部数据权限', '1', 'sys_role_data_scope', '', '', '', '2', '', '全部数据权限', 1, 1, '2022-08-23 19:56:40.845', '2022-08-23 19:56:40.845', NULL);
    35. 

  35. INSERT INTO sys_dict_data VALUES (49, 2, '自定数据权限', '2', 'sys_role_data_scope', '', '', '', '2', '', '自定数据权限', 1, 1, '2022-08-23 19:56:40.845', '2022-08-23 19:56:40.845', NULL);
    36. 

  36. INSERT INTO sys_dict_data VALUES (50, 3, '本机构数据权限', '3', 'sys_role_data_scope', '', '', '', '2', '', '本部门数据权限', 1, 1, '2022-08-23 19:56:40.845', '2022-08-23 19:56:40.845', NULL);
    37. 

  37. INSERT INTO sys_dict_data VALUES (51, 4, '本机构及以下数据权限', '4', 'sys_role_data_scope', '', '', '', '2', '', '本部门及以下数据权限', 1, 1, '2022-08-23 19:56:40.845', '2022-08-23 19:56:40.845', NULL);
    38. 

  38. INSERT INTO sys_dict_data VALUES (52, 5, '仅本人数据权限', '5', 'sys_role_data_scope', '', '', '', '2', '', '仅本人数据权限', 1, 1, '2022-08-23 19:56:40.845', '2022-08-23 19:56:40.845', NULL);
    39. 

  39. 

  40. INSERT INTO sys_dict_type VALUES (1, '系统开关', 'sys_normal_disable', '2', '系统开关列表', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    41. 

  41. INSERT INTO sys_dict_type VALUES (2, '用户性别', 'sys_user_sex', '2', '用户性别列表', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    42. 

  42. INSERT INTO sys_dict_type VALUES (3, '菜单状态', 'sys_show_hide', '2', '菜单状态列表', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    43. 

  43. INSERT INTO sys_dict_type VALUES (4, '系统是否', 'sys_yes_no', '2', '系统是否列表', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    44. 

  44. INSERT INTO sys_dict_type VALUES (5, '任务状态', 'sys_job_status', '2', '任务状态列表', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    45. 

  45. INSERT INTO sys_dict_type VALUES (6, '任务分组', 'sys_job_group', '2', '任务分组列表', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    46. 

  46. INSERT INTO sys_dict_type VALUES (7, '通知类型', 'sys_notice_type', '2', '通知类型列表', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    47. 

  47. INSERT INTO sys_dict_type VALUES (8, '系统状态', 'sys_common_status', '2', '登录状态列表', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    48. 

  48. INSERT INTO sys_dict_type VALUES (9, '操作类型', 'sys_opera_type', '2', '操作类型列表', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    49. 

  49. INSERT INTO sys_dict_type VALUES (10, '通知状态', 'sys_notice_status', '2', '通知状态列表', 1, 1, '2022-08-23 19:56:37.914', '2022-08-23 19:56:37.914', NULL);
    50. 

  50. INSERT INTO sys_dict_type VALUES (11, '内容状态', 'sys_content_status', '2', '', 1, 1, '2022-08-23 19:56:40.813', '2022-08-23 19:56:40.813', NULL);
    51. 

  51. INSERT INTO sys_dict_type VALUES (12, '角色数据权限', 'sys_role_data_scope', 2, '角色数据权限列表', 1, 1, '2022-09-27 14:51:23.000', '2022-09-27 14:51:26.000', NULL);
    52. 

  52. 

  53. 

  54. INSERT INTO sys_config VALUES (1, '皮肤样式', 'sys_index_skinName', 'skin-green', 'Y', '0', '主框架页-默认皮肤样式名称:蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow', 1, 1, '2021-05-13 19:56:37.913', '2021-06-05 13:50:13.123', NULL);
    55. 

  55. INSERT INTO sys_config VALUES (2, '初始密码', 'sys_user_initPassword', '123456', 'Y', '0', '用户管理-账号初始密码:123456', 1, 1, '2021-05-13 19:56:37.913', '2021-05-13 19:56:37.913', NULL);
    56. 

  56. INSERT INTO sys_config VALUES (3, '侧栏主题', 'sys_index_sideTheme', 'theme-dark', 'Y', '0', '主框架页-侧边栏主题:深色主题theme-dark，浅色主题theme-light', 1, 1, '2021-05-13 19:56:37.913', '2021-05-13 19:56:37.913', NULL);
    57. 

  57. INSERT INTO sys_config VALUES (4, '系统名称', 'sys_app_name', 'go-admin管理系统', 'Y', '1', '', 1, 0, '2021-03-17 08:52:06.067', '2021-05-28 10:08:25.248', NULL);
    58. 

  58. INSERT INTO sys_config VALUES (5, '系统logo', 'sys_app_logo', 'https://doc-image.zhangwj.com/img/go-admin.png', 'Y', '1', '', 1, 0, '2021-03-17 08:53:19.462', '2021-03-17 08:53:19.462', NULL);
    59. 

  59. INSERT INTO sys_config VALUES (6, '单点登录', 'sys_single_login', '否', '1', '备注', 0, 0, '2023-06-30 10:42:08.290', '2023-06-30 11:42:29.485', NULL);
    60. 

  60. INSERT INTO sys_config VALUES (7, '服务发现', 'sys_service_discovery', 'https://doc-image.zhangwj.com/img/go-admin.png', '1', '备注', 0, 0, '2023-06-30 10:42:08.290', '2023-06-30 11:42:29.485', NULL);
    61. 

  61. 

  62. 

  63. INSERT INTO sys_dept VALUES (1, 0, '/0/1/', '贵州宝智达网络科技有限公司', 0, 1, 1, 1, '2023-06-07 14:43:53.000', '2023-06-07 14:43:55.000', NULL);
    64. 

  64. INSERT INTO sys_role VALUES (1, '系统管理员', '2', 'admin', 1, '', '', 1, '', 1, 1, '2022-08-23 19:56:37.913', '2022-08-23 19:56:37.913', NULL);
    65. 

  65. INSERT INTO sys_user VALUES (1, 'a192362a-5119-46ab-a9a7-a7b57029ce48', 'admin', '$2a$10$X3RBKl2.WonUVKBVyP43EOUHcyZEolRrRhftpD6sc/0dcruxtOWme', 'admin', '12322334455', 1, '', 1, '', '2', 0, 0, '2023-06-07 14:40:54.226', '2023-06-07 14:40:54.226', NULL);
    66. 

  66. 

  67. INSERT INTO sys_user (`id`, `uuid`, `username`, `password`, `nick_name`, `phone`, `role_id`, `salt`, `dept_id`, `post_id`, `remark`, `status`, `create_by`, `update_by`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'b583d1fa-3317-48de-9a55-eaa204c43060', 'admin', '$2a$10$Zls2VZVy0Lpm7ugbfq6eVe6ajAvchj9AS7bM8LgoY1iirknoxgC6u', 'test', '', 1, '', 0, 0, '', '2', 8, 0, '2023-11-15 16:57:47.764', '2023-11-15 16:57:47.764', NULL);
    68. 

  68. INSERT INTO sys_role (`id`, `name`, `status`, `role_key`, `sort`, `data_scope`, `remark`, `create_by`, `update_by`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, '管理员', '2', 'admin', 0, 3, '', 1, 1, '2022-08-23 19:56:37.913', '2023-06-15 17:19:50.932', NULL);
    69. 

  69.