609 lines
62 KiB
SQL
609 lines
62 KiB
SQL
-- QAUP 系统完整初始数据
|
||
-- 此文件由 db-manager.sh 自动生成
|
||
|
||
-- 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;
|
||
|
||
-- 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: airport_areas; Type: TABLE DATA; Schema: public; Owner:
|
||
SET SESSION AUTHORIZATION DEFAULT;
|
||
|
||
ALTER TABLE public.airport_areas DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.airport_areas VALUES (4, 'APRON_01', '停机坪区域01', 'APRON', '0103000020E6100000010000000500000085EB51B81E055E40560E2DB29D2F42401283C0CAA1055E40560E2DB29D2F42401283C0CAA1055E40022B8716D92E424085EB51B81E055E40022B8716D92E424085EB51B81E055E40560E2DB29D2F4240', '主要停机坪区域，覆盖无人车和航空器活动区域，包含route.md中所有测试路线', NULL, NULL, true, 8, NULL, 'AIRCRAFT_OPERATIONS', NULL, '2025-07-12 10:49:48.828993', '2025-07-12 10:49:48.828993', 0);
|
||
INSERT INTO public.airport_areas VALUES (5, 'TAXIWAY_ALPHA', '滑行道Alpha', 'TAXIWAY', '0103000020E610000001000000050000006891ED7C3F055E408FC2F5285C2F42402FDD240681055E408FC2F5285C2F42402FDD240681055E40C976BE9F1A2F42406891ED7C3F055E40C976BE9F1A2F42406891ED7C3F055E408FC2F5285C2F4240', '主要滑行道，连接停机坪和跑道', NULL, NULL, true, 7, NULL, 'AIRCRAFT_OPERATIONS', NULL, '2025-07-12 10:49:48.829562', '2025-07-12 10:49:48.829562', 0);
|
||
INSERT INTO public.airport_areas VALUES (1, 'UV_TEST_AREA_A', '无人车A测试区域', 'UNMANNED_VEHICLE_ZONE', '0103000020E610000001000000050000000C62E1F36D055E4011429BFFB42E4240E89C6DAF78055E400D35CF72D72E42407C50E0FB62055E40ED915C11F12E42403776FAAF5C055E401C76B36ECC2E42400C62E1F36D055E4011429BFFB42E4240', '无人车A运行测试区域，包含起点和终点的矩形区域', NULL, NULL, true, 5, NULL, 'UNMANNED_VEHICLE_OPERATIONS', NULL, '2025-07-12 10:49:48.826007', '2025-07-12 10:50:41.816828', 0);
|
||
INSERT INTO public.airport_areas VALUES (2, 'UV_TEST_AREA_B', '无人车B测试区域', 'UNMANNED_VEHICLE_ZONE', '0103000020E610000001000000070000002048279588055E40590F73545B2F424060D388A08E055E40ECA60720712F42405316FB3D73055E407823697B8F2F4240034599D277055E40CECE705F742F42406E4C62F772055E40A4B436CC692F42404073645A7F055E40F649299C572F42402048279588055E40590F73545B2F4240', '无人车B运行测试区域，包含起点和终点的矩形区域', NULL, NULL, true, 5, NULL, 'UNMANNED_VEHICLE_OPERATIONS', NULL, '2025-07-12 10:49:48.826788', '2025-07-12 10:49:48.826788', 0);
|
||
|
||
|
||
ALTER TABLE public.airport_areas ENABLE TRIGGER ALL;
|
||
|
||
--
|
||
-- Data for Name: spatial_rules; Type: TABLE DATA; Schema: public; Owner:
|
||
ALTER TABLE public.spatial_rules DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.spatial_rules VALUES ('GEOFENCE_UV_AREA_A_ACCESS', '无人车A区域准入控制', '限制无人车A测试区域的访问权限', 'ACCESS_CONTROL', 'ACTIVE', 1, 'AREA', 'UV_TEST_AREA_A', '{"accessControl": {"requiresPermission": true, "allowedOperationModes": ["AUTONOMOUS", "MANUAL"]}, "physicalLimits": {"maxSpeed": 20.0}, "safetyRequirements": {"minBatteryLevel": 30}}', 'WARNING', '进入无人车A测试区域需要授权', NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-12 10:49:48.827433', '2025-07-12 10:49:48.827433', 'system', NULL, 0, NULL);
|
||
INSERT INTO public.spatial_rules VALUES ('GEOFENCE_UV_AREA_B_ACCESS', '无人车B区域准入控制', '限制无人车B测试区域的访问权限', 'ACCESS_CONTROL', 'ACTIVE', 1, 'AREA', 'UV_TEST_AREA_B', '{"accessControl": {"requiresPermission": true, "allowedOperationModes": ["AUTONOMOUS", "MANUAL"]}, "physicalLimits": {"maxSpeed": 20.0}, "safetyRequirements": {"minBatteryLevel": 30}}', 'WARNING', '进入无人车B测试区域需要授权', NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-12 10:49:48.827913', '2025-07-12 10:49:48.827913', 'system', NULL, 0, NULL);
|
||
INSERT INTO public.spatial_rules VALUES ('SPEED_LIMIT_APRON', '停机坪限速规则', '停机坪区域内所有车辆的限速控制规则', 'SPEED_LIMIT', 'ACTIVE', 1, 'AREA', 'APRON_01', '{"unit": "kmh", "maxSpeed": 15.0, "strictMode": true, "warningThreshold": 0.8}', 'WARNING', '停机坪内超速行驶', NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-12 10:49:48.82917', '2025-07-12 10:49:48.82917', 'system', NULL, 0, NULL);
|
||
INSERT INTO public.spatial_rules VALUES ('SPEED_LIMIT_TAXIWAY', '滑行道限速规则', '滑行道区域内的限速控制', 'SPEED_LIMIT', 'ACTIVE', 2, 'AREA', 'TAXIWAY_ALPHA', '{"unit": "kmh", "maxSpeed": 25.0, "warningThreshold": 0.9}', 'WARNING', '滑行道内超速行驶', NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-12 10:49:48.82978', '2025-07-12 10:49:48.82978', 'system', NULL, 0, NULL);
|
||
|
||
|
||
ALTER TABLE public.spatial_rules ENABLE TRIGGER ALL;
|
||
|
||
--
|
||
-- Data for Name: spatial_rule_vehicle_types; Type: TABLE DATA; Schema: public; Owner:
|
||
ALTER TABLE public.spatial_rule_vehicle_types DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('GEOFENCE_UV_AREA_A_ACCESS', 'UNMANNED_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('GEOFENCE_UV_AREA_B_ACCESS', 'UNMANNED_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_APRON', 'UNMANNED_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_APRON', 'AIRCRAFT');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_APRON', 'SPECIAL_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_APRON', 'NORMAL_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_TAXIWAY', 'UNMANNED_VEHICLE');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_TAXIWAY', 'AIRCRAFT');
|
||
INSERT INTO public.spatial_rule_vehicle_types VALUES ('SPEED_LIMIT_TAXIWAY', 'SPECIAL_VEHICLE');
|
||
|
||
|
||
ALTER TABLE public.spatial_rule_vehicle_types ENABLE TRIGGER ALL;
|
||
|
||
--
|
||
-- Data for Name: sys_vehicle_type; Type: TABLE DATA; Schema: public; Owner:
|
||
ALTER TABLE public.sys_vehicle_type DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.sys_vehicle_type VALUES (1, 'UV', 'UNMANNED_VEHICLE', '无人车', 'Unmanned Vehicle', 1, NULL, '无人车', false, 1, true, '自动驾驶无人车辆', '{"category": "UNMANNED", "maxSpeed": 30, "autonomous": true, "requiresPermission": true}', NULL, '2025-07-13 11:25:17.226345', NULL, '2025-07-13 11:25:17.226345', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (2, 'SP', 'SPECIAL_VEHICLE', '特勤车', 'Special Vehicle', 1, NULL, '特勤车', false, 2, true, '具有特殊权限的车辆', '{"category": "SPECIAL", "priority": "HIGH", "accessAllAreas": true, "hasSpecialPrivileges": true}', NULL, '2025-07-13 11:25:17.226345', NULL, '2025-07-13 11:25:17.226345', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (3, 'NM', 'NORMAL_VEHICLE', '普通车', 'Normal Vehicle', 1, NULL, '普通车', false, 3, true, '一般机场运营车辆', '{"category": "NORMAL", "maxSpeed": 40, "priority": "NORMAL"}', NULL, '2025-07-13 11:25:17.226345', NULL, '2025-07-13 11:25:17.226345', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (4, 'UV.PT', 'PATROL_VEHICLE', '巡逻车', 'Patrol Vehicle', 2, 'UV', '无人车/巡逻车', true, 1, true, '自主巡逻无人车', '{"sensors": ["CAMERA", "RADAR"], "maxSpeed": 25, "patrolRange": 5000}', NULL, '2025-07-13 11:25:17.229016', NULL, '2025-07-13 11:25:17.229016', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (5, 'UV.DL', 'DELIVERY_VEHICLE', '配送车', 'Delivery Vehicle', 2, 'UV', '无人车/配送车', true, 2, true, '自主配送无人车', '{"maxSpeed": 30, "cargoCapacity": 500}', NULL, '2025-07-13 11:25:17.229016', NULL, '2025-07-13 11:25:17.229016', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (6, 'UV.IN', 'INSPECTION_VEHICLE', '检查车', 'Inspection Vehicle', 2, 'UV', '无人车/检查车', true, 3, true, '自主检查无人车', '{"sensors": ["CAMERA", "LIDAR", "THERMAL"], "maxSpeed": 20}', NULL, '2025-07-13 11:25:17.229016', NULL, '2025-07-13 11:25:17.229016', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (7, 'UV.SH', 'SHUTTLE_VEHICLE', '接驳车', 'Shuttle Vehicle', 2, 'UV', '无人车/接驳车', true, 4, true, '无人接驳车', '{"maxSpeed": 35, "passengerCapacity": 8}', NULL, '2025-07-13 11:25:17.229016', NULL, '2025-07-13 11:25:17.229016', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (8, 'UV.BD', 'BIRD_DETERRENT', '驱鸟车', 'Bird Deterrent Vehicle', 2, 'UV', '无人车/驱鸟车', true, 5, true, '自动驱鸟无人车', '{"maxSpeed": 25, "soundSystem": true}', NULL, '2025-07-13 11:25:17.229016', NULL, '2025-07-13 11:25:17.229016', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (9, 'SP.FT', 'FIRE_TRUCK', '消防车', 'Fire Truck', 2, 'SP', '特勤车/消防车', true, 1, true, '机场消防车', '{"maxSpeed": 60, "priority": "CRITICAL", "accessAllAreas": true, "emergencyVehicle": true}', NULL, '2025-07-13 11:25:17.229389', NULL, '2025-07-13 11:25:17.229389', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (10, 'SP.PC', 'POLICE_CAR', '警车', 'Police Car', 2, 'SP', '特勤车/警车', true, 2, true, '机场警车', '{"maxSpeed": 80, "priority": "HIGH", "accessAllAreas": true, "emergencyVehicle": true}', NULL, '2025-07-13 11:25:17.229389', NULL, '2025-07-13 11:25:17.229389', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (11, 'SP.AM', 'AMBULANCE', '救护车', 'Ambulance', 2, 'SP', '特勤车/救护车', true, 3, true, '机场救护车', '{"maxSpeed": 70, "priority": "CRITICAL", "emergencyVehicle": true}', NULL, '2025-07-13 11:25:17.229389', NULL, '2025-07-13 11:25:17.229389', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (12, 'SP.FM', 'FOLLOW_ME_CAR', '引导车', 'Follow Me Car', 2, 'SP', '特勤车/引导车', true, 4, true, '飞机引导车', '{"maxSpeed": 50, "priority": "HIGH", "followMode": true}', NULL, '2025-07-13 11:25:17.229389', NULL, '2025-07-13 11:25:17.229389', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (13, 'SP.SC', 'SECURITY_CAR', '安保车', 'Security Car', 2, 'SP', '特勤车/安保车', true, 5, true, '机场安保车辆', '{"maxSpeed": 60, "priority": "HIGH", "patrolVehicle": true}', NULL, '2025-07-13 11:25:17.229389', NULL, '2025-07-13 11:25:17.229389', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (14, 'NM.BG', 'BAGGAGE_CART', '行李车', 'Baggage Cart', 2, 'NM', '普通车/行李车', true, 1, true, '行李运输车', '{"maxSpeed": 25, "cargoType": "BAGGAGE"}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (15, 'NM.CL', 'CLEANING_VEHICLE', '清洁车', 'Cleaning Vehicle', 2, 'NM', '普通车/清洁车', true, 2, true, '机场清洁车', '{"maxSpeed": 20, "equipmentType": "CLEANING"}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (16, 'NM.CT', 'CATERING_TRUCK', '餐车', 'Catering Truck', 2, 'NM', '普通车/餐车', true, 3, true, '航空餐饮车', '{"maxSpeed": 25, "cargoType": "CATERING"}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (17, 'NM.TG', 'TUG_VEHICLE', '拖车', 'Tug Vehicle', 2, 'NM', '普通车/拖车', true, 4, true, '飞机拖车', '{"maxSpeed": 15, "towingCapacity": true}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (18, 'NM.FL', 'FUEL_TRUCK', '加油车', 'Fuel Truck', 2, 'NM', '普通车/加油车', true, 5, true, '燃料补给车', '{"maxSpeed": 20, "fuelCapacity": true, "hazardousMaterial": true}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (19, 'NM.MT', 'MAINTENANCE_VEHICLE', '维护车', 'Maintenance Vehicle', 2, 'NM', '普通车/维护车', true, 6, true, '设备维护车', '{"maxSpeed": 30, "equipmentType": "MAINTENANCE"}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
INSERT INTO public.sys_vehicle_type VALUES (20, 'NM.TR', 'TRANSPORT_TRUCK', '运输车', 'Transport Truck', 2, 'NM', '普通车/运输车', true, 7, true, '货物运输车', '{"maxSpeed": 40, "cargoCapacity": 5000}', NULL, '2025-07-13 11:25:17.229761', NULL, '2025-07-13 11:25:17.229761', 0);
|
||
|
||
|
||
ALTER TABLE public.sys_vehicle_type ENABLE TRIGGER ALL;
|
||
|
||
--
|
||
-- Data for Name: transport_routes; Type: TABLE DATA; Schema: public; Owner:
|
||
ALTER TABLE public.transport_routes DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.transport_routes VALUES (3, '特勤车鲁B123路径', 'SPECIAL_VEHICLE', '鲁B123特勤车的预定路径', '0102000020E610000002000000FB1EF5D72B055E4080EECB99ED2E4240B24AE9995E055E40E5B9BE0F072F4240', 30, 30, NULL, NULL, 'ACTIVE', false, NULL, NULL, '2025-07-11 17:56:56.179577+08', '2025-07-11 17:56:56.179577+08');
|
||
INSERT INTO public.transport_routes VALUES (4, '普通车鲁B234路径', 'UNMANNED_VEHICLE', '鲁B234普通车的预定路径', '0102000020E61000000200000007D2C5A695055E402313F06B242F4240B24AE9995E055E40E5B9BE0F072F4240', 30, 30, NULL, NULL, 'ACTIVE', false, NULL, NULL, '2025-07-11 17:56:56.179577+08', '2025-07-11 17:56:56.179577+08');
|
||
INSERT INTO public.transport_routes VALUES (5, '无人车鲁B567路径', 'UNMANNED_VEHICLE', '鲁B567无人车的预定路径', '0102000020E61000000200000089B48D3F51055E4023BBD232522F424005C24EB16A055E404AEEB089CC2E4240', 25, 25, NULL, NULL, 'ACTIVE', false, NULL, NULL, '2025-07-11 17:56:56.179577+08', '2025-07-11 17:56:56.179577+08');
|
||
INSERT INTO public.transport_routes VALUES (6, '无人车鲁B579路径', 'UNMANNED_VEHICLE', '鲁B579无人车的预定路径', '0102000020E61000000200000063B9A5D590055E404E2B85402E2F4240B6F63E5585055E407BD80B056C2F4240', 25, 25, NULL, NULL, 'ACTIVE', false, NULL, NULL, '2025-07-11 17:56:56.179577+08', '2025-07-11 17:56:56.179577+08');
|
||
INSERT INTO public.transport_routes VALUES (8, 'FLIGHT_CA3456_OUT', 'AIRCRAFT', '航空器路由 - 类型: OUT, 状态: COMPLETE, 路径: 138,L4,F1, 包含 31 个路径段, 总坐标点: 18', '0102000020E610000012000000ADF29129C75083417F9D95A0CCB74E419458A0C5C15083414885D130B9B74E4145473A77C1508341C08B4B63B7B74E411D4CF732C15083417E26D760B4B74E4178F8E8E3C0508341A0C9E344ADB74E414F1F55CCC0508341DDE2E2BCA4B74E41202D20DBC0508341D6B46B999FB74E41FADDB866C1508341A2CDC31284B74E419D0AA66AC1508341AA36A0DE7EB74E41C3F1A45AC15083410FDD70157BB74E412DF5813BC15083411B378EAF77B74E41804A5C0FC1508341B84440E874B74E412DDB8FC5C05083419ACE537C72B74E419946E687C05083418621CFCA71B74E4169747749C05083412DB6B01E72B74E41FFCA47F6BB508341D59E293581B74E411A2C3C87BB508341A591857C81B74E413AF00AF6AE5083419B5550A241B74E41', 50, 30, NULL, NULL, 'ACTIVE', false, 'DataCollectorService', 'DataCollectorService', '2025-07-24 19:03:23.383926+08', '2025-07-31 17:29:46.597627+08');
|
||
INSERT INTO public.transport_routes VALUES (7, 'FLIGHT_CA3456_IN', 'AIRCRAFT', '航空器路由 - 类型: IN, 状态: COMPLETE, 路径: F1,L4,138, 包含 31 个路径段, 总坐标点: 18', '0102000020E610000012000000ADF29129C75083417F9D95A0CCB74E419458A0C5C15083414885D130B9B74E4145473A77C1508341C08B4B63B7B74E411D4CF732C15083417E26D760B4B74E4178F8E8E3C0508341A0C9E344ADB74E414F1F55CCC0508341DDE2E2BCA4B74E41202D20DBC0508341D6B46B999FB74E41FADDB866C1508341A2CDC31284B74E419D0AA66AC1508341AA36A0DE7EB74E41C3F1A45AC15083410FDD70157BB74E412DF5813BC15083411B378EAF77B74E41804A5C0FC1508341B84440E874B74E412DDB8FC5C05083419ACE537C72B74E419946E687C05083418621CFCA71B74E4169747749C05083412DB6B01E72B74E41FFCA47F6BB508341D59E293581B74E411A2C3C87BB508341A591857C81B74E413AF00AF6AE5083419B5550A241B74E41', 50, 30, NULL, NULL, 'ACTIVE', false, 'DataCollectorService', 'DataCollectorService', '2025-07-24 19:02:48.474886+08', '2025-07-31 17:29:56.608121+08');
|
||
|
||
|
||
ALTER TABLE public.transport_routes ENABLE TRIGGER ALL;
|
||
-- Name: airport_areas_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
|
||
SELECT pg_catalog.setval('public.airport_areas_id_seq', 5, true);
|
||
|
||
-- Name: sys_vehicle_type_new_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
|
||
SELECT pg_catalog.setval('public.sys_vehicle_type_new_id_seq', 20, true);
|
||
|
||
-- Name: transport_routes_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
|
||
SELECT pg_catalog.setval('public.transport_routes_id_seq', 8, true);
|
||
|
||
|
||
--
|
||
-- PostgreSQL database dump complete
|
||
--
|
||
|
||
SET session_replication_role = DEFAULT;
|
||
|
||
-- 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_vehicle_info; Type: TABLE DATA; Schema: public; Owner:
|
||
SET SESSION AUTHORIZATION DEFAULT;
|
||
|
||
ALTER TABLE public.sys_vehicle_info DISABLE TRIGGER ALL;
|
||
|
||
INSERT INTO public.sys_vehicle_info VALUES (2, '鲁B123', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-01 15:19:12', NULL, '2025-07-01 15:57:56.774', NULL, 'SP.FT');
|
||
INSERT INTO public.sys_vehicle_info VALUES (5, '鲁B567', 'UNMANNED_A_567', '测试无人车A', '机场运营部', '系统管理员', '18888888888', '', 'system', '2025-07-08 16:18:39', 'system', '2025-07-10 17:48:38.952', '测试用无人车A，用于规则检测验证 - 更新于2025-07-08 16:23:43.864483+08', 'UV.SH');
|
||
INSERT INTO public.sys_vehicle_info VALUES (6, '鲁B579', 'UNMANNED_B_579', '测试无人车B', '机场运营部', '系统管理员', '18888888889', '', 'system', '2025-07-08 16:18:39', 'system', '2025-07-10 17:47:44.634', '测试用无人车B，用于规则检测验证 - 更新于2025-07-08 16:23:43.864483+08', 'UV.BD');
|
||
INSERT INTO public.sys_vehicle_info VALUES (4, '鲁A-666666', NULL, '特斯拉', 'XXXX有限公司', '刘某', '17689895656', 'http://10.0.0.124:8080/profile/upload/2025/07/07/car_20250707104751A001.png', '张三', '2025-07-07 10:47:53', NULL, '2025-07-07 10:50:58.411', NULL, 'UV.BD');
|
||
INSERT INTO public.sys_vehicle_info VALUES (3, '鲁B234', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-01 15:19:29', NULL, '2025-07-01 15:57:40.964', NULL, 'NM.TR');
|
||
|
||
|
||
ALTER TABLE public.sys_vehicle_info ENABLE TRIGGER ALL;
|
||
-- Name: sys_vehicle_info_vehicle_id_seq; Type: SEQUENCE SET; Schema: public; Owner:
|
||
SELECT pg_catalog.setval('public.sys_vehicle_info_vehicle_id_seq', 8, true);
|
||
|
||
|
||
--
|
||
-- PostgreSQL database dump complete
|
||
--
|
||
|
||
SET session_replication_role = DEFAULT;
|
||
|
||
|
||
INSERT INTO intersections (intersection_id, intersection_name, latitude, longitude, area_code, description)
|
||
VALUES
|
||
('DEFAULT_INTERSECTION', '默认路口', 36.35406879, 120.08341040, 'AREA_A', '机场主要路口，连接航站楼和跑道区域'),
|
||
('INTERSECTION_001', '主要路口1号', 36.35496367, 120.08688530, 'AREA_A', '机场主要路口，连接航站楼和跑道区域'),
|
||
('INTERSECTION_002', '次要路口2号', 36.35448347, 120.08502054, 'AREA_B', '机场次要路口，连接货运区域')
|
||
ON CONFLICT (intersection_id) DO NOTHING;
|
||
|
||
INSERT INTO traffic_lights (device_id, device_name, ip_address, intersection_id, device_type, manufacturer, model, install_date)
|
||
VALUES
|
||
('TL_001', '主路口红绿灯1号', '192.168.1.101', 'INTERSECTION_001', 'STANDARD', '海康威视', 'DS-TL100', '2024-01-01'),
|
||
('TL_002', '次路口红绿灯2号', '192.168.1.102', 'INTERSECTION_002', 'STANDARD', '大华技术', 'DH-TL200', '2024-01-15')
|
||
ON CONFLICT (device_id) DO NOTHING;
|