Doni/QDAirPortBackend0122
5
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
master
QDAirPortBackend0122/sql/export/01_system_data.sql
sladro 725c0be448 Initial commit
2026-01-22 13:19:47 +08:00

427 lines
42 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- QAUP 系统基础配置数据
SET session_replication_role = replica;
--
-- PostgreSQL database dump
--
-- Dumped from database version 17.5 (Homebrew)
-- Dumped by pg_dump version 17.5 (Homebrew)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
--
-- Data for Name: sys_config; Type: TABLE DATA; Schema: public; Owner:
SET SESSION AUTHORIZATION DEFAULT;
ALTER TABLE public.sys_config DISABLE TRIGGER ALL;
INSERT INTO public.sys_config VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2021-05-26 18:56:31', 'admin', '2021-05-27 09:07:43.532263', '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO public.sys_config VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2021-05-26 18:56:31', 'admin', '2021-05-27 10:15:52.394492', '初始化密码 123456');
INSERT INTO public.sys_config VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2021-05-26 18:56:31', 'admin', NULL, '深色主题theme-dark，浅色主题theme-light');
INSERT INTO public.sys_config VALUES (4, '账号自助-验证码开关', 'sys.account.captchaEnabled', 'true', 'Y', 'admin', '2025-06-30 11:46:01.666022', 'admin', NULL, '是否开启验证码功能（true开启，false关闭）');
INSERT INTO public.sys_config VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2025-06-30 11:46:01.666242', 'admin', NULL, '是否开启注册用户功能（true开启，false关闭）');
INSERT INTO public.sys_config VALUES (6, '未管理车辆位置过滤开关', 'unmanaged.vehicle.filter.enabled', 'false', 'Y', 'admin', '2025-08-01 12:30:00', 'admin', NULL, '控制是否过滤未在sys_vehicle_info表中注册的车辆位置信息。true=启用过滤，false=禁用过滤（默认）');
ALTER TABLE public.sys_config ENABLE TRIGGER ALL;
--
-- Data for Name: sys_dept; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_dept DISABLE TRIGGER ALL;
INSERT INTO public.sys_dept VALUES (102, 100, '0,100', '长沙分公司', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-05-26 18:56:27', '', NULL);
INSERT INTO public.sys_dept VALUES (104, 101, '0,100,101', '市场部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-05-26 18:56:27', '', NULL);
INSERT INTO public.sys_dept VALUES (105, 101, '0,100,101', '测试部门', 3, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-05-26 18:56:27', '', NULL);
INSERT INTO public.sys_dept VALUES (106, 101, '0,100,101', '财务部门', 4, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-05-26 18:56:28', '', NULL);
INSERT INTO public.sys_dept VALUES (107, 101, '0,100,101', '运维部门', 5, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-05-26 18:56:28', '', NULL);
INSERT INTO public.sys_dept VALUES (108, 102, '0,100,102', '市场部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-05-26 18:56:28', '', NULL);
INSERT INTO public.sys_dept VALUES (109, 102, '0,100,102', '财务部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-05-26 18:56:28', '', NULL);
INSERT INTO public.sys_dept VALUES (103, 101, '0,100,101', '研发部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-05-26 18:56:27', 'admin', '2021-05-27 09:05:25.083296');
INSERT INTO public.sys_dept VALUES (101, 100, '0,100', '深圳总公司', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-05-26 18:56:27', 'admin', '2021-05-27 09:05:25.091901');
INSERT INTO public.sys_dept VALUES (100, 0, '0', '若依科技', 0, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-05-26 18:56:27', 'admin', '2021-05-27 10:00:30.143076');
ALTER TABLE public.sys_dept ENABLE TRIGGER ALL;
--
-- Data for Name: sys_dict_data; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_dict_data DISABLE TRIGGER ALL;
INSERT INTO public.sys_dict_data VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2025-06-30 11:46:01.674133', '', NULL, '性别男');
INSERT INTO public.sys_dict_data VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2025-06-30 11:46:01.674399', '', NULL, '性别女');
INSERT INTO public.sys_dict_data VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2025-06-30 11:46:01.674508', '', NULL, '性别未知');
INSERT INTO public.sys_dict_data VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2025-06-30 11:46:01.674611', '', NULL, '显示菜单');
INSERT INTO public.sys_dict_data VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2025-06-30 11:46:01.674709', '', NULL, '隐藏菜单');
INSERT INTO public.sys_dict_data VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2025-06-30 11:46:01.674806', '', NULL, '正常状态');
INSERT INTO public.sys_dict_data VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2025-06-30 11:46:01.674905', '', NULL, '停用状态');
INSERT INTO public.sys_dict_data VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2025-06-30 11:46:01.675012', '', NULL, '正常状态');
INSERT INTO public.sys_dict_data VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2025-06-30 11:46:01.675119', '', NULL, '停用状态');
INSERT INTO public.sys_dict_data VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2025-06-30 11:46:01.675224', '', NULL, '默认分组');
INSERT INTO public.sys_dict_data VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2025-06-30 11:46:01.675314', '', NULL, '系统分组');
INSERT INTO public.sys_dict_data VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2025-06-30 11:46:01.675411', '', NULL, '系统默认是');
INSERT INTO public.sys_dict_data VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2025-06-30 11:46:01.675508', '', NULL, '系统默认否');
INSERT INTO public.sys_dict_data VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2025-06-30 11:46:01.675613', '', NULL, '通知');
INSERT INTO public.sys_dict_data VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2025-06-30 11:46:01.675711', '', NULL, '公告');
INSERT INTO public.sys_dict_data VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2025-06-30 11:46:01.675807', '', NULL, '正常状态');
INSERT INTO public.sys_dict_data VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2025-06-30 11:46:01.675908', '', NULL, '关闭状态');
INSERT INTO public.sys_dict_data VALUES (18, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2025-06-30 11:46:01.676018', '', NULL, '新增操作');
INSERT INTO public.sys_dict_data VALUES (19, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2025-06-30 11:46:01.676142', '', NULL, '修改操作');
INSERT INTO public.sys_dict_data VALUES (20, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2025-06-30 11:46:01.676238', '', NULL, '删除操作');
INSERT INTO public.sys_dict_data VALUES (21, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2025-06-30 11:46:01.676344', '', NULL, '授权操作');
INSERT INTO public.sys_dict_data VALUES (22, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2025-06-30 11:46:01.676485', '', NULL, '导出操作');
INSERT INTO public.sys_dict_data VALUES (23, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2025-06-30 11:46:01.676579', '', NULL, '导入操作');
INSERT INTO public.sys_dict_data VALUES (24, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2025-06-30 11:46:01.676676', '', NULL, '强退操作');
INSERT INTO public.sys_dict_data VALUES (25, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2025-06-30 11:46:01.676769', '', NULL, '生成操作');
INSERT INTO public.sys_dict_data VALUES (26, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2025-06-30 11:46:01.676864', '', NULL, '清空操作');
INSERT INTO public.sys_dict_data VALUES (27, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2025-06-30 11:46:01.676959', '', NULL, '正常状态');
INSERT INTO public.sys_dict_data VALUES (28, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2025-06-30 11:46:01.677053', '', NULL, '停用状态');
ALTER TABLE public.sys_dict_data ENABLE TRIGGER ALL;
--
-- Data for Name: sys_dict_type; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_dict_type DISABLE TRIGGER ALL;
INSERT INTO public.sys_dict_type VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2021-05-26 18:56:30', '', NULL, '菜单状态列表');
INSERT INTO public.sys_dict_type VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2021-05-26 18:56:30', '', NULL, '系统开关列表');
INSERT INTO public.sys_dict_type VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2021-05-26 18:56:30', '', NULL, '任务状态列表');
INSERT INTO public.sys_dict_type VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2021-05-26 18:56:30', '', NULL, '任务分组列表');
INSERT INTO public.sys_dict_type VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2021-05-26 18:56:30', '', NULL, '系统是否列表');
INSERT INTO public.sys_dict_type VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2021-05-26 18:56:30', '', NULL, '通知类型列表');
INSERT INTO public.sys_dict_type VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2021-05-26 18:56:30', '', NULL, '通知状态列表');
INSERT INTO public.sys_dict_type VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2021-05-26 18:56:30', '', NULL, '操作类型列表');
INSERT INTO public.sys_dict_type VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2021-05-26 18:56:30', '', NULL, '登录状态列表');
INSERT INTO public.sys_dict_type VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2021-05-26 18:56:30', 'admin', '2021-05-27 10:07:12.015926', '用户性别列表');
ALTER TABLE public.sys_dict_type ENABLE TRIGGER ALL;
--
-- Data for Name: sys_menu; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_menu DISABLE TRIGGER ALL;
INSERT INTO public.sys_menu VALUES (109, '在线用户', 2, 1, 'online', 'monitor/online/index', '', '', 1, 0, 'C', '0', 0, 'monitor:online:list', 'online', 'admin', '2025-06-30 11:46:01.696006', '', NULL, '在线用户菜单');
INSERT INTO public.sys_menu VALUES (110, '定时任务', 2, 2, 'job', 'monitor/job/index', '', '', 1, 0, 'C', '0', 0, 'monitor:job:list', 'job', 'admin', '2025-06-30 11:46:01.696142', '', NULL, '定时任务菜单');
INSERT INTO public.sys_menu VALUES (111, '数据监控', 2, 3, 'druid', 'monitor/druid/index', '', '', 1, 0, 'C', '0', 0, 'monitor:druid:list', 'druid', 'admin', '2025-06-30 11:46:01.696275', '', NULL, '数据监控菜单');
INSERT INTO public.sys_menu VALUES (112, '服务监控', 2, 4, 'server', 'monitor/server/index', '', '', 1, 0, 'C', '0', 0, 'monitor:server:list', 'server', 'admin', '2025-06-30 11:46:01.696399', '', NULL, '服务监控菜单');
INSERT INTO public.sys_menu VALUES (113, '缓存监控', 2, 5, 'cache', 'monitor/cache/index', '', '', 1, 0, 'C', '0', 0, 'monitor:cache:list', 'redis', 'admin', '2025-06-30 11:46:01.696545', '', NULL, '缓存监控菜单');
INSERT INTO public.sys_menu VALUES (114, '缓存列表', 2, 6, 'cacheList', 'monitor/cache/list', '', '', 1, 0, 'C', '0', 0, 'monitor:cache:list', 'redis-list', 'admin', '2025-06-30 11:46:01.696676', '', NULL, '缓存列表菜单');
INSERT INTO public.sys_menu VALUES (115, '表单构建', 3, 1, 'build', 'tool/build/index', '', '', 1, 0, 'C', '0', 0, 'tool:build:list', 'build', 'admin', '2025-06-30 11:46:01.696799', '', NULL, '表单构建菜单');
INSERT INTO public.sys_menu VALUES (116, '代码生成', 3, 2, 'gen', 'tool/gen/index', '', '', 1, 0, 'C', '0', 0, 'tool:gen:list', 'code', 'admin', '2025-06-30 11:46:01.696924', '', NULL, '代码生成菜单');
INSERT INTO public.sys_menu VALUES (117, '系统接口', 3, 3, 'swagger', 'tool/swagger/index', '', '', 1, 0, 'C', '0', 0, 'tool:swagger:list', 'swagger', 'admin', '2025-06-30 11:46:01.697043', '', NULL, '系统接口菜单');
INSERT INTO public.sys_menu VALUES (500, '操作日志', 108, 1, 'operlog', 'monitor/operlog/index', '', '', 1, 0, 'C', '0', 0, 'monitor:operlog:list', 'form', 'admin', '2025-06-30 11:46:01.697161', '', NULL, '操作日志菜单');
INSERT INTO public.sys_menu VALUES (501, '登录日志', 108, 2, 'logininfor', 'monitor/logininfor/index', '', '', 1, 0, 'C', '0', 0, 'monitor:logininfor:list', 'logininfor', 'admin', '2025-06-30 11:46:01.69729', '', NULL, '登录日志菜单');
INSERT INTO public.sys_menu VALUES (1000, '用户查询', 100, 1, '', '', '', '', 1, 0, 'F', '0', 0, 'system:user:query', '#', 'admin', '2025-06-30 11:46:01.697409', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1001, '用户新增', 100, 2, '', '', '', '', 1, 0, 'F', '0', 0, 'system:user:add', '#', 'admin', '2025-06-30 11:46:01.697521', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1002, '用户修改', 100, 3, '', '', '', '', 1, 0, 'F', '0', 0, 'system:user:edit', '#', 'admin', '2025-06-30 11:46:01.697639', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1003, '用户删除', 100, 4, '', '', '', '', 1, 0, 'F', '0', 0, 'system:user:remove', '#', 'admin', '2025-06-30 11:46:01.697752', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1004, '用户导出', 100, 5, '', '', '', '', 1, 0, 'F', '0', 0, 'system:user:export', '#', 'admin', '2025-06-30 11:46:01.697866', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1005, '用户导入', 100, 6, '', '', '', '', 1, 0, 'F', '0', 0, 'system:user:import', '#', 'admin', '2025-06-30 11:46:01.697989', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1006, '重置密码', 100, 7, '', '', '', '', 1, 0, 'F', '0', 0, 'system:user:resetPwd', '#', 'admin', '2025-06-30 11:46:01.698107', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1007, '角色查询', 101, 1, '', '', '', '', 1, 0, 'F', '0', 0, 'system:role:query', '#', 'admin', '2025-06-30 11:46:01.698223', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1008, '角色新增', 101, 2, '', '', '', '', 1, 0, 'F', '0', 0, 'system:role:add', '#', 'admin', '2025-06-30 11:46:01.698338', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1009, '角色修改', 101, 3, '', '', '', '', 1, 0, 'F', '0', 0, 'system:role:edit', '#', 'admin', '2025-06-30 11:46:01.698449', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1010, '角色删除', 101, 4, '', '', '', '', 1, 0, 'F', '0', 0, 'system:role:remove', '#', 'admin', '2025-06-30 11:46:01.698567', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1011, '角色导出', 101, 5, '', '', '', '', 1, 0, 'F', '0', 0, 'system:role:export', '#', 'admin', '2025-06-30 11:46:01.698676', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1012, '菜单查询', 102, 1, '', '', '', '', 1, 0, 'F', '0', 0, 'system:menu:query', '#', 'admin', '2025-06-30 11:46:01.698788', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1013, '菜单新增', 102, 2, '', '', '', '', 1, 0, 'F', '0', 0, 'system:menu:add', '#', 'admin', '2025-06-30 11:46:01.698918', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1014, '菜单修改', 102, 3, '', '', '', '', 1, 0, 'F', '0', 0, 'system:menu:edit', '#', 'admin', '2025-06-30 11:46:01.699021', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1015, '菜单删除', 102, 4, '', '', '', '', 1, 0, 'F', '0', 0, 'system:menu:remove', '#', 'admin', '2025-06-30 11:46:01.699115', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1016, '部门查询', 103, 1, '', '', '', '', 1, 0, 'F', '0', 0, 'system:dept:query', '#', 'admin', '2025-06-30 11:46:01.699208', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1017, '部门新增', 103, 2, '', '', '', '', 1, 0, 'F', '0', 0, 'system:dept:add', '#', 'admin', '2025-06-30 11:46:01.699303', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1018, '部门修改', 103, 3, '', '', '', '', 1, 0, 'F', '0', 0, 'system:dept:edit', '#', 'admin', '2025-06-30 11:46:01.699397', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1019, '部门删除', 103, 4, '', '', '', '', 1, 0, 'F', '0', 0, 'system:dept:remove', '#', 'admin', '2025-06-30 11:46:01.699491', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1020, '岗位查询', 104, 1, '', '', '', '', 1, 0, 'F', '0', 0, 'system:post:query', '#', 'admin', '2025-06-30 11:46:01.699585', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1021, '岗位新增', 104, 2, '', '', '', '', 1, 0, 'F', '0', 0, 'system:post:add', '#', 'admin', '2025-06-30 11:46:01.699678', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1022, '岗位修改', 104, 3, '', '', '', '', 1, 0, 'F', '0', 0, 'system:post:edit', '#', 'admin', '2025-06-30 11:46:01.699773', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1023, '岗位删除', 104, 4, '', '', '', '', 1, 0, 'F', '0', 0, 'system:post:remove', '#', 'admin', '2025-06-30 11:46:01.699864', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1024, '岗位导出', 104, 5, '', '', '', '', 1, 0, 'F', '0', 0, 'system:post:export', '#', 'admin', '2025-06-30 11:46:01.699966', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1025, '字典查询', 105, 1, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:dict:query', '#', 'admin', '2025-06-30 11:46:01.700063', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1026, '字典新增', 105, 2, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:dict:add', '#', 'admin', '2025-06-30 11:46:01.700152', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1027, '字典修改', 105, 3, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:dict:edit', '#', 'admin', '2025-06-30 11:46:01.700241', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1028, '字典删除', 105, 4, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:dict:remove', '#', 'admin', '2025-06-30 11:46:01.700335', '', NULL, '');
INSERT INTO public.sys_menu VALUES (105, '字典管理', 1, 12, 'dict', 'system/dict/index', '', '', 1, 0, 'C', '0', 0, 'system:dict:list', 'dict', 'admin', '2025-06-30 11:46:01.695457', 'admin', '2025-07-01 12:54:54.93348', '字典管理菜单');
INSERT INTO public.sys_menu VALUES (104, '岗位管理', 1, 9, 'post', 'system/post/index', '', '', 1, 0, 'C', '0', 0, 'system:post:list', 'post', 'admin', '2025-06-30 11:46:01.695337', 'admin', '2025-07-01 12:54:34.819643', '岗位管理菜单');
INSERT INTO public.sys_menu VALUES (107, '通知公告', 1, 11, 'notice', 'system/notice/index', '', '', 1, 0, 'C', '0', 0, 'system:notice:list', 'message', 'admin', '2025-06-30 11:46:01.695711', 'admin', '2025-07-01 12:54:48.868867', '通知公告菜单');
INSERT INTO public.sys_menu VALUES (106, '参数设置', 1, 8, 'config', 'system/config/index', '', '', 1, 0, 'C', '0', 0, 'system:config:list', 'edit', 'admin', '2025-06-30 11:46:01.695586', 'admin', '2025-07-01 12:53:33.677329', '参数设置菜单');
INSERT INTO public.sys_menu VALUES (3, '系统工具', 0, 8, 'tool', NULL, '', '', 1, 0, 'M', '0', 0, '', 'tool', 'admin', '2025-06-30 11:46:01.694458', 'admin', '2025-07-02 11:36:57.346986', '系统工具目录');
INSERT INTO public.sys_menu VALUES (1, '系统管理', 0, 5, 'system', NULL, '', '', 1, 0, 'M', '1', 1, '', 'system', 'admin', '2025-06-30 11:46:01.694127', 'admin', '2025-07-02 14:58:36.14046', '系统管理目录');
INSERT INTO public.sys_menu VALUES (2, '系统监控', 0, 7, 'monitor', NULL, '', '', 1, 0, 'M', '0', 0, '', 'monitor', 'admin', '2025-06-30 11:46:01.694331', 'admin', '2025-07-02 11:37:44.548593', '系统监控目录');
INSERT INTO public.sys_menu VALUES (101, '角色管理', 0, 0, 'system/role', '', '', '', 1, 0, 'M', '0', 0, '', 'peoples', 'admin', '2025-06-30 11:46:01.694834', 'admin', '2025-07-02 14:54:00.466181', '角色管理菜单');
INSERT INTO public.sys_menu VALUES (108, '日志管理', 0, 6, 'log', '', '', '', 1, 0, 'M', '0', 0, '', 'log', 'admin', '2025-06-30 11:46:01.695861', 'admin', '2025-07-02 14:30:00.522418', '日志管理菜单');
INSERT INTO public.sys_menu VALUES (100, '用户管理', 2023, 1, 'user', 'system/user/index', '', '', 1, 0, 'C', '0', 0, 'system:user:list', 'user', 'admin', '2025-06-30 11:46:01.694702', 'admin', '2025-07-02 14:53:40.256578', '用户管理菜单');
INSERT INTO public.sys_menu VALUES (1029, '字典导出', 105, 5, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:dict:export', '#', 'admin', '2025-06-30 11:46:01.700427', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1030, '参数查询', 106, 1, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:config:query', '#', 'admin', '2025-06-30 11:46:01.700678', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1031, '参数新增', 106, 2, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:config:add', '#', 'admin', '2025-06-30 11:46:01.700768', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1032, '参数修改', 106, 3, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:config:edit', '#', 'admin', '2025-06-30 11:46:01.700855', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1033, '参数删除', 106, 4, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:config:remove', '#', 'admin', '2025-06-30 11:46:01.70095', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1034, '参数导出', 106, 5, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:config:export', '#', 'admin', '2025-06-30 11:46:01.701038', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1035, '公告查询', 107, 1, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:notice:query', '#', 'admin', '2025-06-30 11:46:01.701155', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1036, '公告新增', 107, 2, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:notice:add', '#', 'admin', '2025-06-30 11:46:01.701257', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1037, '公告修改', 107, 3, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:notice:edit', '#', 'admin', '2025-06-30 11:46:01.701375', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1038, '公告删除', 107, 4, '#', '', '', '', 1, 0, 'F', '0', 0, 'system:notice:remove', '#', 'admin', '2025-06-30 11:46:01.701487', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1039, '操作查询', 500, 1, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:operlog:query', '#', 'admin', '2025-06-30 11:46:01.70159', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1040, '操作删除', 500, 2, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:operlog:remove', '#', 'admin', '2025-06-30 11:46:01.701688', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1041, '日志导出', 500, 3, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:operlog:export', '#', 'admin', '2025-06-30 11:46:01.701788', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1042, '登录查询', 501, 1, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:logininfor:query', '#', 'admin', '2025-06-30 11:46:01.701882', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1043, '登录删除', 501, 2, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:logininfor:remove', '#', 'admin', '2025-06-30 11:46:01.701972', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1044, '日志导出', 501, 3, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:logininfor:export', '#', 'admin', '2025-06-30 11:46:01.702072', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1045, '账户解锁', 501, 4, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:logininfor:unlock', '#', 'admin', '2025-06-30 11:46:01.702166', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1046, '在线查询', 109, 1, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:online:query', '#', 'admin', '2025-06-30 11:46:01.70226', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1047, '批量强退', 109, 2, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:online:batchLogout', '#', 'admin', '2025-06-30 11:46:01.702352', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1048, '单条强退', 109, 3, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:online:forceLogout', '#', 'admin', '2025-06-30 11:46:01.702434', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1049, '任务查询', 110, 1, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:job:query', '#', 'admin', '2025-06-30 11:46:01.702526', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1050, '任务新增', 110, 2, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:job:add', '#', 'admin', '2025-06-30 11:46:01.702612', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1051, '任务修改', 110, 3, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:job:edit', '#', 'admin', '2025-06-30 11:46:01.702697', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1052, '任务删除', 110, 4, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:job:remove', '#', 'admin', '2025-06-30 11:46:01.702789', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1053, '状态修改', 110, 5, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:job:changeStatus', '#', 'admin', '2025-06-30 11:46:01.70289', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1054, '任务导出', 110, 6, '#', '', '', '', 1, 0, 'F', '0', 0, 'monitor:job:export', '#', 'admin', '2025-06-30 11:46:01.702993', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1055, '生成查询', 116, 1, '#', '', '', '', 1, 0, 'F', '0', 0, 'tool:gen:query', '#', 'admin', '2025-06-30 11:46:01.703083', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1056, '生成修改', 116, 2, '#', '', '', '', 1, 0, 'F', '0', 0, 'tool:gen:edit', '#', 'admin', '2025-06-30 11:46:01.70315', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1057, '生成删除', 116, 3, '#', '', '', '', 1, 0, 'F', '0', 0, 'tool:gen:remove', '#', 'admin', '2025-06-30 11:46:01.703215', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1058, '导入代码', 116, 4, '#', '', '', '', 1, 0, 'F', '0', 0, 'tool:gen:import', '#', 'admin', '2025-06-30 11:46:01.703271', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1059, '预览代码', 116, 5, '#', '', '', '', 1, 0, 'F', '0', 0, 'tool:gen:preview', '#', 'admin', '2025-06-30 11:46:01.703497', '', NULL, '');
INSERT INTO public.sys_menu VALUES (1060, '生成代码', 116, 6, '#', '', '', '', 1, 0, 'F', '0', 0, 'tool:gen:code', '#', 'admin', '2025-06-30 11:46:01.703551', '', NULL, '');
INSERT INTO public.sys_menu VALUES (2005, '驾驶员信息修改', 2001, 3, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'system:driver:edit', '#', 'admin', '2025-06-30 16:48:03.895169', 'admin', '2025-07-02 14:32:32.474994', '');
INSERT INTO public.sys_menu VALUES (2006, '驾驶员信息删除', 2001, 4, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'system:driver:remove', '#', 'admin', '2025-06-30 16:48:06.075078', 'admin', '2025-07-02 14:32:37.704155', '');
INSERT INTO public.sys_menu VALUES (103, '部门管理', 1, 6, 'dept', 'system/dept/index', '', '', 1, 0, 'C', '0', 0, 'system:dept:list', 'tree', 'admin', '2025-06-30 11:46:01.695074', 'admin', '2025-07-01 12:54:18.500819', '部门管理菜单');
INSERT INTO public.sys_menu VALUES (102, '菜单管理', 1, 10, 'menu', 'system/menu/index', '', '', 1, 0, 'C', '0', 0, 'system:menu:list', 'tree-table', 'admin', '2025-06-30 11:46:01.694955', 'admin', '2025-07-01 12:54:43.056581', '菜单管理菜单');
INSERT INTO public.sys_menu VALUES (2002, '驾驶员信息导出', 2001, 5, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'system:driver:export', '#', 'admin', '2025-06-30 16:46:39.603148', 'admin', '2025-07-02 14:32:42.629936', '');
INSERT INTO public.sys_menu VALUES (2013, '车辆信息新增', 2010, 2, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'car:park:add', '#', 'admin', '2025-07-01 14:52:13.574172', 'admin', '2025-07-02 14:24:09.379537', '');
INSERT INTO public.sys_menu VALUES (2010, '车辆入库', 2009, 1, 'park', 'car/park/index', NULL, '', 1, 0, 'C', '0', 0, 'car:park:list', 'example', 'admin', '2025-07-01 14:47:21.867082', 'admin', '2025-07-02 14:23:34.414488', '车辆信息菜单');
INSERT INTO public.sys_menu VALUES (2004, '驾驶员信息新增', 2001, 2, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'system:driver:add', '#', 'admin', '2025-06-30 16:48:01.358018', 'admin', '2025-07-02 14:32:27.609076', '');
INSERT INTO public.sys_menu VALUES (2003, '驾驶员信息查询', 2001, 1, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'system:driver:query', '#', 'admin', '2025-06-30 16:47:58.343736', 'admin', '2025-07-02 14:32:22.33353', '');
INSERT INTO public.sys_menu VALUES (2001, '驾驶员管理', 2023, 2, 'driver', 'system/driver/index', NULL, '', 1, 0, 'C', '0', 0, 'system:driver:list', 'people', 'admin', '2025-06-30 16:43:32.815121', 'admin', '2025-07-02 12:09:25.674259', '驾驶员信息菜单');
INSERT INTO public.sys_menu VALUES (2012, '车辆信息查询', 2010, 1, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'car:park:query', '#', 'admin', '2025-07-01 14:52:13.572937', 'admin', '2025-07-02 14:23:38.276845', '');
INSERT INTO public.sys_menu VALUES (2018, '车辆类型查询', 2017, 1, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'car:type:query', '#', 'admin', '2025-07-01 14:54:31.09987', 'admin', '2025-07-02 14:24:57.99149', '');
INSERT INTO public.sys_menu VALUES (2014, '车辆信息修改', 2010, 3, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'car:park:edit', '#', 'admin', '2025-07-01 14:52:13.57443', 'admin', '2025-07-02 14:24:13.908704', '');
INSERT INTO public.sys_menu VALUES (2015, '车辆信息删除', 2010, 4, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'car:park:remove', '#', 'admin', '2025-07-01 14:52:13.574789', 'admin', '2025-07-02 14:24:18.207907', '');
INSERT INTO public.sys_menu VALUES (2016, '车辆信息导出', 2010, 5, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'car:park:export', '#', 'admin', '2025-07-01 14:52:13.575014', 'admin', '2025-07-02 14:24:25.787294', '');
INSERT INTO public.sys_menu VALUES (2017, '类型管理', 2009, 2, 'type', 'car/type/index', NULL, '', 1, 0, 'C', '0', 0, 'car:type:list', 'date-range', 'admin', '2025-07-01 14:52:31.961971', 'admin', '2025-07-02 14:24:35.465997', '车辆类型菜单');
INSERT INTO public.sys_menu VALUES (2019, '车辆类型新增', 2017, 2, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'car:type:add', '#', 'admin', '2025-07-01 14:54:31.101193', 'admin', '2025-07-02 14:25:03.164353', '');
INSERT INTO public.sys_menu VALUES (2020, '车辆类型修改', 2017, 3, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'car:type:edit', '#', 'admin', '2025-07-01 14:54:31.101469', 'admin', '2025-07-02 14:25:07.76714', '');
INSERT INTO public.sys_menu VALUES (2021, '车辆类型删除', 2017, 4, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'car:type:remove', '#', 'admin', '2025-07-01 14:54:31.101709', 'admin', '2025-07-02 14:25:21.59183', '');
INSERT INTO public.sys_menu VALUES (2009, '车辆管理', 0, 3, 'car', NULL, NULL, '', 1, 0, 'M', '0', 0, '', 'guide', 'admin', '2025-07-01 12:57:34.659228', 'admin', '2025-07-02 14:28:10.386535', '车辆管理菜单');
INSERT INTO public.sys_menu VALUES (2024, '车辆监控', 0, 1, 'car/monitor', NULL, NULL, '', 1, 0, 'M', '0', 0, NULL, 'druid', 'admin', '2025-07-02 09:55:44.592567', 'admin', '2025-07-02 12:07:12.009308', NULL);
INSERT INTO public.sys_menu VALUES (2022, '车辆类型导出', 2017, 5, '#', '', NULL, '', 1, 0, 'F', '0', 0, 'car:type:export', '#', 'admin', '2025-07-01 14:54:31.10192', 'admin', '2025-07-02 14:25:16.681362', '');
INSERT INTO public.sys_menu VALUES (2025, '操作日志', 0, 4, 'system/operlog', NULL, NULL, '', 1, 0, 'M', '0', 0, NULL, 'monitor', 'admin', '2025-07-02 14:31:04.949382', 'admin', '2025-07-02 14:33:17.169498', NULL);
INSERT INTO public.sys_menu VALUES (2023, '人员管理', 0, 1, 'system', NULL, NULL, '', 1, 0, 'M', '0', 0, NULL, 'user', 'admin', '2025-07-02 09:48:27.911515', 'admin', '2025-07-02 14:54:06.9212', NULL);
INSERT INTO public.sys_menu VALUES (2027, '菜单管理', 2023, 3, 'menu', 'system/menu/index', NULL, '', 1, 0, 'C', '0', 0, 'system:menu:list', 'cascader', 'admin', '2025-07-02 14:57:41.672802', 'admin', '2025-07-02 14:58:10.960429', NULL);
ALTER TABLE public.sys_menu ENABLE TRIGGER ALL;
--
-- Data for Name: sys_notice; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_notice DISABLE TRIGGER ALL;
INSERT INTO public.sys_notice VALUES (2, '维护通知：2018-07-01 若依系统凌晨维护', '1', '\xe7bbb4e68aa4e58685e5aeb9', '0', 'admin', '2021-05-26 18:56:31', '', NULL, '管理员');
INSERT INTO public.sys_notice VALUES (1, '温馨提醒：2018-07-01 若依新版本发布啦', '2', '\', '0', 'admin', '2021-05-26 18:56:31', 'admin', '2021-05-27 09:08:41.403262', '管理员');
ALTER TABLE public.sys_notice ENABLE TRIGGER ALL;
--
-- Data for Name: sys_post; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_post DISABLE TRIGGER ALL;
INSERT INTO public.sys_post VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2021-05-26 18:56:28', '', NULL, '');
INSERT INTO public.sys_post VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2021-05-26 18:56:28', '', NULL, '');
INSERT INTO public.sys_post VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2021-05-26 18:56:28', '', NULL, '');
INSERT INTO public.sys_post VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2021-05-26 18:56:28', 'admin', '2021-05-27 09:07:17.160973', '');
ALTER TABLE public.sys_post ENABLE TRIGGER ALL;
--
-- Data for Name: sys_role; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_role DISABLE TRIGGER ALL;
INSERT INTO public.sys_role VALUES (1, '超级管理员', 'admin', 1, '1', true, true, '0', '0', 'admin', '2021-05-26 18:56:28', '', NULL, '超级管理员');
INSERT INTO public.sys_role VALUES (2, '普通角色', 'common', 2, '2', false, false, '0', '0', 'admin', '2021-05-26 18:56:28', 'admin', '2021-05-27 09:55:51.961721', '普通角色');
INSERT INTO public.sys_role VALUES (3, '驾驶员', 'driver', 3, NULL, true, true, '0', '0', 'admin', '2025-06-30 17:06:49.372252', 'admin', '2025-06-30 17:07:04.661292', NULL);
INSERT INTO public.sys_role VALUES (4, '普通管理员', '普通管理员', 0, NULL, true, false, '0', '2', 'admin', '2025-07-07 10:37:51.223819', NULL, NULL, NULL);
ALTER TABLE public.sys_role ENABLE TRIGGER ALL;
--
-- Data for Name: sys_role_dept; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_role_dept DISABLE TRIGGER ALL;
INSERT INTO public.sys_role_dept VALUES (2, 100);
INSERT INTO public.sys_role_dept VALUES (2, 101);
INSERT INTO public.sys_role_dept VALUES (2, 105);
ALTER TABLE public.sys_role_dept ENABLE TRIGGER ALL;
--
-- Data for Name: sys_role_menu; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_role_menu DISABLE TRIGGER ALL;
INSERT INTO public.sys_role_menu VALUES (2, 1);
INSERT INTO public.sys_role_menu VALUES (2, 100);
INSERT INTO public.sys_role_menu VALUES (2, 1001);
INSERT INTO public.sys_role_menu VALUES (2, 1002);
INSERT INTO public.sys_role_menu VALUES (2, 1003);
INSERT INTO public.sys_role_menu VALUES (2, 1004);
INSERT INTO public.sys_role_menu VALUES (2, 1005);
INSERT INTO public.sys_role_menu VALUES (2, 1006);
INSERT INTO public.sys_role_menu VALUES (2, 1007);
INSERT INTO public.sys_role_menu VALUES (2, 101);
INSERT INTO public.sys_role_menu VALUES (2, 1008);
INSERT INTO public.sys_role_menu VALUES (2, 1009);
INSERT INTO public.sys_role_menu VALUES (2, 1010);
INSERT INTO public.sys_role_menu VALUES (2, 1011);
INSERT INTO public.sys_role_menu VALUES (2, 1012);
INSERT INTO public.sys_role_menu VALUES (2, 102);
INSERT INTO public.sys_role_menu VALUES (2, 1013);
INSERT INTO public.sys_role_menu VALUES (2, 1014);
INSERT INTO public.sys_role_menu VALUES (2, 1015);
INSERT INTO public.sys_role_menu VALUES (2, 1016);
INSERT INTO public.sys_role_menu VALUES (2, 103);
INSERT INTO public.sys_role_menu VALUES (2, 1017);
INSERT INTO public.sys_role_menu VALUES (2, 1018);
INSERT INTO public.sys_role_menu VALUES (2, 1019);
INSERT INTO public.sys_role_menu VALUES (2, 1020);
INSERT INTO public.sys_role_menu VALUES (2, 104);
INSERT INTO public.sys_role_menu VALUES (2, 1021);
INSERT INTO public.sys_role_menu VALUES (2, 1022);
INSERT INTO public.sys_role_menu VALUES (2, 1023);
INSERT INTO public.sys_role_menu VALUES (2, 1024);
INSERT INTO public.sys_role_menu VALUES (2, 1025);
INSERT INTO public.sys_role_menu VALUES (2, 105);
INSERT INTO public.sys_role_menu VALUES (2, 1026);
INSERT INTO public.sys_role_menu VALUES (2, 1027);
INSERT INTO public.sys_role_menu VALUES (2, 1028);
INSERT INTO public.sys_role_menu VALUES (2, 1029);
INSERT INTO public.sys_role_menu VALUES (2, 1030);
INSERT INTO public.sys_role_menu VALUES (2, 106);
INSERT INTO public.sys_role_menu VALUES (2, 1031);
INSERT INTO public.sys_role_menu VALUES (2, 1032);
INSERT INTO public.sys_role_menu VALUES (2, 1033);
INSERT INTO public.sys_role_menu VALUES (2, 1034);
INSERT INTO public.sys_role_menu VALUES (2, 1035);
INSERT INTO public.sys_role_menu VALUES (2, 107);
INSERT INTO public.sys_role_menu VALUES (2, 1036);
INSERT INTO public.sys_role_menu VALUES (2, 1037);
INSERT INTO public.sys_role_menu VALUES (2, 1038);
INSERT INTO public.sys_role_menu VALUES (2, 1039);
INSERT INTO public.sys_role_menu VALUES (2, 108);
INSERT INTO public.sys_role_menu VALUES (2, 500);
INSERT INTO public.sys_role_menu VALUES (2, 1040);
INSERT INTO public.sys_role_menu VALUES (2, 1041);
INSERT INTO public.sys_role_menu VALUES (2, 1042);
INSERT INTO public.sys_role_menu VALUES (2, 501);
INSERT INTO public.sys_role_menu VALUES (2, 1043);
INSERT INTO public.sys_role_menu VALUES (2, 1044);
INSERT INTO public.sys_role_menu VALUES (2, 1045);
INSERT INTO public.sys_role_menu VALUES (2, 2);
INSERT INTO public.sys_role_menu VALUES (2, 109);
INSERT INTO public.sys_role_menu VALUES (2, 1046);
INSERT INTO public.sys_role_menu VALUES (2, 1047);
INSERT INTO public.sys_role_menu VALUES (2, 1048);
INSERT INTO public.sys_role_menu VALUES (2, 110);
INSERT INTO public.sys_role_menu VALUES (2, 1049);
INSERT INTO public.sys_role_menu VALUES (2, 1050);
INSERT INTO public.sys_role_menu VALUES (2, 1051);
INSERT INTO public.sys_role_menu VALUES (2, 1052);
INSERT INTO public.sys_role_menu VALUES (2, 1053);
INSERT INTO public.sys_role_menu VALUES (2, 1054);
INSERT INTO public.sys_role_menu VALUES (2, 111);
INSERT INTO public.sys_role_menu VALUES (2, 112);
INSERT INTO public.sys_role_menu VALUES (2, 113);
INSERT INTO public.sys_role_menu VALUES (2, 3);
INSERT INTO public.sys_role_menu VALUES (2, 114);
INSERT INTO public.sys_role_menu VALUES (2, 115);
INSERT INTO public.sys_role_menu VALUES (2, 1055);
INSERT INTO public.sys_role_menu VALUES (2, 1058);
INSERT INTO public.sys_role_menu VALUES (2, 1056);
INSERT INTO public.sys_role_menu VALUES (2, 1057);
INSERT INTO public.sys_role_menu VALUES (2, 1059);
INSERT INTO public.sys_role_menu VALUES (2, 1060);
INSERT INTO public.sys_role_menu VALUES (2, 116);
INSERT INTO public.sys_role_menu VALUES (2, 4);
ALTER TABLE public.sys_role_menu ENABLE TRIGGER ALL;
--
-- Data for Name: sys_user; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_user DISABLE TRIGGER ALL;
INSERT INTO public.sys_user VALUES (2, 105, 'ry', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2021-05-26 18:56:28', '2021-05-26 18:56:28', 'admin', '2021-05-26 18:56:28', 'admin', '2025-07-02 17:27:31.087052', '测试员');
INSERT INTO public.sys_user VALUES (1, 103, 'admin', '00', 'fx@163.com', '15888888888', '0', '/profile/avatar/2025/07/01/99A坦克_20250701170922A001.jpeg', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '10.0.0.170', '2025-07-31 17:22:11.353', '2021-05-26 18:56:28', 'admin', '2021-05-26 18:56:28', '', '2025-07-31 17:22:11.356625', '管理员');
INSERT INTO public.sys_user VALUES (3, 100, 'zhang', NULL, 'zhangsan@163.com', '19912341234', '0', NULL, '$2a$10$hiTYTe6fXCEt6CcTZh.nieKL5nR5WXqQww32JNFReSPMv/K4DyvaG', '0', '0', NULL, NULL, NULL, 'admin', '2025-06-30 17:09:19.239424', 'admin', '2025-07-02 17:42:30.645132', '货车驾驶员');
INSERT INTO public.sys_user VALUES (6, NULL, '辣辣', NULL, NULL, '17648598989', NULL, NULL, '$2a$10$4MvPf4uJvFZCx.bPnLCFqO5vkJflteWze7juoO2JV8wT0JKMkfhAO', '0', '2', NULL, NULL, NULL, 'admin', '2025-07-02 18:09:17.546309', NULL, NULL, NULL);
INSERT INTO public.sys_user VALUES (7, NULL, 'Ren', NULL, NULL, '18847025990', NULL, NULL, '$2a$10$Wh2w9DqRrR2SkE29ZO.B3Ojnc7wFIFA//tPnPnICoB9AXEwnCoft6', '0', '0', NULL, NULL, NULL, 'admin', '2025-07-02 18:12:15.667678', NULL, NULL, NULL);
ALTER TABLE public.sys_user ENABLE TRIGGER ALL;
--
-- Data for Name: sys_user_post; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_user_post DISABLE TRIGGER ALL;
INSERT INTO public.sys_user_post VALUES (1, 1);
ALTER TABLE public.sys_user_post ENABLE TRIGGER ALL;
--
-- Data for Name: sys_user_role; Type: TABLE DATA; Schema: public; Owner:
ALTER TABLE public.sys_user_role DISABLE TRIGGER ALL;
INSERT INTO public.sys_user_role VALUES (1, 1);
INSERT INTO public.sys_user_role VALUES (2, 1);
INSERT INTO public.sys_user_role VALUES (3, 2);
INSERT INTO public.sys_user_role VALUES (7, 3);
ALTER TABLE public.sys_user_role ENABLE TRIGGER ALL;
-- Name: sys_config_config_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
SELECT pg_catalog.setval('public.sys_config_config_id_seq', 100, false);
-- Name: sys_dept_dept_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
SELECT pg_catalog.setval('public.sys_dept_dept_id_seq', 110, false);
-- Name: sys_dict_data_dict_code_seq; Type: SEQUENCE SET; Schema: public; Owner:
SELECT pg_catalog.setval('public.sys_dict_data_dict_code_seq', 29, false);
-- Name: sys_dict_type_dict_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
SELECT pg_catalog.setval('public.sys_dict_type_dict_id_seq', 11, false);
-- Name: sys_menu_menu_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
SELECT pg_catalog.setval('public.sys_menu_menu_id_seq', 2027, true);
-- Name: sys_notice_notice_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
SELECT pg_catalog.setval('public.sys_notice_notice_id_seq', 3, false);
-- Name: sys_post_post_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
SELECT pg_catalog.setval('public.sys_post_post_id_seq', 5, false);
-- Name: sys_role_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
SELECT pg_catalog.setval('public.sys_role_role_id_seq', 4, true);
-- Name: sys_user_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
SELECT pg_catalog.setval('public.sys_user_user_id_seq', 7, true);
--
-- PostgreSQL database dump complete
--
SET session_replication_role = DEFAULT;
Reference in New Issue View Git Blame Copy Permalink