--
-- PostgreSQL database dump
--
\restrict ibmK4dL6M4pqEvlM3dWQ17oroD5brVW6TSvY5cbc3uscxoJgv6uf9828xVBKdKp
-- Dumped from database version 16.14 (Debian 16.14-1.pgdg13+1)
-- Dumped by pg_dump version 16.14 (Debian 16.14-1.pgdg13+1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_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;
--
-- Name: qiluoopen; Type: SCHEMA; Schema: -; Owner: -
--
CREATE SCHEMA qiluoopen;
--
-- Name: on_update_current_timestamp_test_api(); Type: FUNCTION; Schema: qiluoopen; Owner: -
--
CREATE FUNCTION qiluoopen.on_update_current_timestamp_test_api() RETURNS trigger
LANGUAGE plpgsql
AS $$
BEGIN
NEW.updated_at = now();
RETURN NEW;
END;
$$;
--
-- Name: on_update_current_timestamp_test_data_scope(); Type: FUNCTION; Schema: qiluoopen; Owner: -
--
CREATE FUNCTION qiluoopen.on_update_current_timestamp_test_data_scope() RETURNS trigger
LANGUAGE plpgsql
AS $$
BEGIN
NEW.updated_at = now();
RETURN NEW;
END;
$$;
--
-- Name: on_update_current_timestamp_wx_materials(); Type: FUNCTION; Schema: qiluoopen; Owner: -
--
CREATE FUNCTION qiluoopen.on_update_current_timestamp_wx_materials() RETURNS trigger
LANGUAGE plpgsql
AS $$
BEGIN
NEW.synced_at = now();
RETURN NEW;
END;
$$;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: seaql_migrations; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.seaql_migrations (
version character varying(255) NOT NULL,
applied_at bigint NOT NULL
);
--
-- Name: sys_api_permission; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_api_permission (
id bigint NOT NULL,
api character(255) NOT NULL,
method character(10) NOT NULL,
apiname character(20) NOT NULL,
logcache character(1) DEFAULT '0'::bpchar NOT NULL,
remark character varying(512),
sort bigint NOT NULL,
created_at timestamp with time zone NOT NULL
);
--
-- Name: sys_codegen_config; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_codegen_config (
id bigint NOT NULL,
module_name character varying(100) NOT NULL,
table_name character varying(100) NOT NULL,
config_json text NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL
);
--
-- Name: sys_dept; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_dept (
dept_id bigint NOT NULL,
parent_id bigint DEFAULT '0'::bigint NOT NULL,
dept_name character varying(30) DEFAULT ''::character varying,
lft bigint DEFAULT '0'::bigint NOT NULL,
rgt bigint DEFAULT '0'::bigint NOT NULL,
depth bigint DEFAULT '0'::bigint NOT NULL,
dept_category character varying(100),
"order" integer DEFAULT 0 NOT NULL,
leader bigint,
phone character varying(11),
email character varying(50),
status character(1) DEFAULT '0'::bpchar NOT NULL,
remark character varying(500),
created_at timestamp with time zone,
updated_at timestamp with time zone,
deleted_at timestamp with time zone
);
--
-- Name: sys_dict_data; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_dict_data (
dict_code bigint NOT NULL,
dict_sort integer DEFAULT 0 NOT NULL,
dict_label character varying(100) DEFAULT ''::character varying NOT NULL,
dict_value character varying(100) DEFAULT ''::character varying NOT NULL,
dict_type_id bigint NOT NULL,
created_at timestamp with time zone,
updated_at timestamp with time zone,
remark character varying(500)
);
--
-- Name: sys_dict_type; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_dict_type (
dict_id bigint NOT NULL,
dict_name character varying(100) NOT NULL,
dict_type character varying(100) NOT NULL,
"order" integer NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone NOT NULL,
remark character varying(500)
);
--
-- Name: sys_job; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_job (
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
job_id bigint NOT NULL,
task_type character(32) NOT NULL,
task_count bigint NOT NULL,
run_count bigint NOT NULL,
job_name character(32) NOT NULL,
job_params character(32),
job_group character(32) NOT NULL,
cron_expression character(32) NOT NULL,
status character(32) NOT NULL,
remark character varying(512) NOT NULL
);
--
-- Name: sys_job_log; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_job_log (
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
id bigint NOT NULL,
job_id bigint NOT NULL,
run_count bigint NOT NULL,
job_message character varying(2048),
status character(32) NOT NULL,
elapsed_time timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);
--
-- Name: sys_login_info; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_login_info (
info_id bigint NOT NULL,
uid bigint NOT NULL,
user_name character varying(50) DEFAULT ''::character varying NOT NULL,
device_type character varying(32) DEFAULT ''::character varying,
ipaddr character varying(128) DEFAULT ''::character varying,
login_location character varying(255) DEFAULT ''::character varying,
net_work character varying(255),
browser character varying(50) DEFAULT ''::character varying,
os character varying(50) DEFAULT ''::character varying,
status character(1) DEFAULT '0'::bpchar,
msg character varying(255) DEFAULT ''::character varying,
login_time timestamp with time zone
);
--
-- Name: sys_mail_log; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_mail_log (
id bigint NOT NULL,
recipient character varying(256) NOT NULL,
subject character varying(256) NOT NULL,
content_text text,
content_html text,
from_addr character varying(256),
reply_to character varying(256),
status character(32) NOT NULL,
error_message character varying(1024),
mail_type character(32),
created_by bigint,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone
);
--
-- Name: sys_mail_log_id_seq; Type: SEQUENCE; Schema: qiluoopen; Owner: -
--
CREATE SEQUENCE qiluoopen.sys_mail_log_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: sys_mail_log_id_seq; Type: SEQUENCE OWNED BY; Schema: qiluoopen; Owner: -
--
ALTER SEQUENCE qiluoopen.sys_mail_log_id_seq OWNED BY qiluoopen.sys_mail_log.id;
--
-- Name: sys_mail_template; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_mail_template (
id bigint NOT NULL,
name character varying(128) NOT NULL,
code character varying(64) NOT NULL,
subject character varying(256) NOT NULL,
text_content text,
html_content text,
description character varying(512),
status smallint DEFAULT '1'::smallint NOT NULL,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);
--
-- Name: sys_menu; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_menu (
id bigint NOT NULL,
name character varying(32),
title character varying(32) NOT NULL,
i18nkey character varying(32),
pid bigint DEFAULT '0'::bigint NOT NULL,
"order" integer DEFAULT 0 NOT NULL,
path character varying(200) DEFAULT ''::character varying,
component character varying(255),
redirect character varying(100),
href character varying(32) DEFAULT ''::character varying,
no_cache character(1) DEFAULT '0'::bpchar NOT NULL,
menu_type character(1) DEFAULT ''::bpchar NOT NULL,
hidden character(1) DEFAULT '0'::bpchar NOT NULL,
active_menu character(1) DEFAULT '0'::bpchar NOT NULL,
always_show character(1) DEFAULT '0'::bpchar NOT NULL,
breadcrumb character(1) DEFAULT '1'::bpchar NOT NULL,
affix character(1) DEFAULT '0'::bpchar NOT NULL,
no_tags_view character(1) DEFAULT '0'::bpchar NOT NULL,
can_to character(1) DEFAULT '0'::bpchar NOT NULL,
status character(1) DEFAULT '1'::bpchar NOT NULL,
perms character varying(100),
icon character varying(100) DEFAULT '#'::character varying,
created_at timestamp with time zone,
updated_at timestamp with time zone,
remark character varying(500) DEFAULT ''::character varying,
deleted_at timestamp with time zone
);
--
-- Name: sys_notice; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_notice (
notice_id bigint NOT NULL,
notice_title character varying(50) NOT NULL,
notice_type character(1) NOT NULL,
notice_content bytea,
status character(1) DEFAULT '0'::bpchar,
create_dept bigint,
create_by bigint,
created_at timestamp with time zone,
update_by bigint,
updated_at timestamp with time zone,
remark character varying(255)
);
--
-- Name: sys_oper_log; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_oper_log (
oper_id bigint NOT NULL,
api_name character varying(50) DEFAULT ''::character varying,
method character varying(100) DEFAULT ''::character varying,
request_method character varying(10) DEFAULT ''::character varying,
oper_name character varying(50) DEFAULT ''::character varying,
oper_url character varying(255) DEFAULT ''::character varying,
oper_ip character varying(128) DEFAULT ''::character varying,
oper_location character varying(255) DEFAULT ''::character varying,
oper_param character varying(2048) DEFAULT ''::character varying,
json_result character varying(2048) DEFAULT ''::character varying,
status character(1) DEFAULT '0'::bpchar,
error_msg character varying(2000) DEFAULT ''::character varying,
oper_time timestamp with time zone,
cost_time bigint DEFAULT '0'::bigint
);
--
-- Name: sys_post; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_post (
post_id bigint NOT NULL,
dept_id bigint NOT NULL,
post_code character varying(64) NOT NULL,
post_category character varying(100),
post_name character varying(50) NOT NULL,
post_sort integer NOT NULL,
status character(1) NOT NULL,
create_dept bigint,
created_at timestamp with time zone,
updated_at timestamp with time zone,
remark character varying(500)
);
--
-- Name: sys_role; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_role (
role_id bigint NOT NULL,
role_name character varying(30) NOT NULL,
role_key character varying(100) NOT NULL,
"order" integer NOT NULL,
data_scope character(1) DEFAULT '1'::bpchar NOT NULL,
status character(1) NOT NULL,
create_dept bigint,
remark character varying(500),
created_at timestamp with time zone,
updated_at timestamp with time zone,
deleted_at timestamp with time zone
);
--
-- Name: sys_role_api; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_role_api (
id bigint NOT NULL,
role_id bigint NOT NULL,
api_id bigint NOT NULL,
api character(255) NOT NULL,
method character(10) NOT NULL,
apiname character(32) NOT NULL,
sort bigint NOT NULL
);
--
-- Name: sys_role_dept; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_role_dept (
role_id bigint NOT NULL,
dept_id bigint NOT NULL
);
--
-- Name: sys_role_menu; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_role_menu (
role_id bigint NOT NULL,
menu_id bigint NOT NULL
);
--
-- Name: sys_user; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_user (
id bigint NOT NULL,
dept_id bigint NOT NULL,
role_id bigint NOT NULL,
user_name character varying(30) NOT NULL,
nick_name character varying(30) NOT NULL,
user_type character varying(10) DEFAULT 'sys_user'::character varying,
email character varying(50) DEFAULT ''::character varying,
phonenumber character varying(11) DEFAULT ''::character varying,
sex character(1) DEFAULT '0'::bpchar,
avatar character varying(256),
password character varying(100) DEFAULT ''::character varying NOT NULL,
status character(1) DEFAULT '0'::bpchar,
login_ip character varying(128) DEFAULT ''::character varying,
login_date timestamp with time zone,
create_dept bigint,
create_by bigint,
created_at timestamp with time zone,
update_by bigint,
updated_at timestamp with time zone,
deleted_at timestamp with time zone,
remark character varying(500)
);
--
-- Name: sys_user_dept; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_user_dept (
user_id bigint NOT NULL,
dept_id bigint NOT NULL
);
--
-- Name: sys_user_post; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_user_post (
user_id bigint NOT NULL,
post_id bigint NOT NULL
);
--
-- Name: sys_user_role; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_user_role (
user_id bigint NOT NULL,
role_id bigint NOT NULL
);
--
-- Name: sys_white_jwt; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.sys_white_jwt (
jid bigint NOT NULL,
uid bigint NOT NULL,
token_id bigint NOT NULL,
info_id bigint NOT NULL,
token_expr bigint NOT NULL,
created_at timestamp with time zone NOT NULL,
update_at timestamp with time zone NOT NULL,
deleted_at timestamp with time zone
);
--
-- Name: test_api; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.test_api (
id bigint NOT NULL,
name character varying(255) NOT NULL,
age integer NOT NULL,
email character varying(255) NOT NULL,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone
);
--
-- Name: test_article; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.test_article (
id bigint NOT NULL,
category_id bigint NOT NULL,
title character varying(255) NOT NULL,
content text NOT NULL,
author character varying(100),
password character varying(255) NOT NULL,
is_published boolean DEFAULT false NOT NULL,
view_count bigint DEFAULT '0'::bigint NOT NULL,
download_count bigint DEFAULT '0'::bigint NOT NULL,
rating double precision DEFAULT '0'::double precision NOT NULL,
cover character varying(500),
published_at timestamp with time zone,
created_at timestamp with time zone,
updated_at timestamp with time zone
);
--
-- Name: test_category; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.test_category (
id bigint NOT NULL,
name character varying(255) NOT NULL,
description text,
sort bigint DEFAULT '0'::bigint NOT NULL,
status character varying(50) DEFAULT 'active'::character varying NOT NULL,
cover character varying(500),
is_active boolean DEFAULT true NOT NULL,
weight bigint DEFAULT '0'::bigint NOT NULL,
view_count bigint DEFAULT '0'::bigint NOT NULL,
created_at timestamp with time zone,
updated_at timestamp with time zone
);
--
-- Name: test_data_scope; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.test_data_scope (
id bigint NOT NULL,
title character varying(200) NOT NULL,
content text,
dept_id bigint NOT NULL,
owner_id bigint NOT NULL,
status character(1) DEFAULT '0'::bpchar NOT NULL,
created_at timestamp with time zone NOT NULL,
updated_at timestamp with time zone,
deleted_at timestamp with time zone
);
--
-- Name: wx_accounts; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.wx_accounts (
id bigint NOT NULL,
app_id character varying(128) NOT NULL,
app_secret character varying(256) NOT NULL,
account_name character varying(128) NOT NULL,
account_type smallint NOT NULL,
original_id character varying(128),
wechat_id character varying(128),
status smallint,
message_mode smallint NOT NULL,
access_token character varying(512),
token_expires_at timestamp with time zone,
server_url character varying(512),
token character varying(128),
encoding_aes_key character varying(256),
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--
-- Name: wx_auto_replies; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.wx_auto_replies (
id bigint NOT NULL,
account_id bigint NOT NULL,
reply_type smallint NOT NULL,
keyword character varying(256),
match_type smallint,
message_type character(32) NOT NULL,
content text,
media_id character varying(128),
title character varying(256),
description text,
pic_url character varying(512),
url character varying(512),
music_url character varying(512),
hq_music_url character varying(512),
thumb_media_id character varying(128),
status smallint,
priority bigint,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--
-- Name: wx_materials; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.wx_materials (
id bigint NOT NULL,
account_id bigint NOT NULL,
media_type character(32) NOT NULL,
media_id character varying(128),
name character varying(256),
url character varying(512),
local_path character varying(512),
file_size bigint,
content_type character varying(128),
width bigint,
height bigint,
duration bigint,
description text,
title character varying(256),
introduction character varying(512),
thumb_media_id character varying(128),
thumb_url character varying(512),
content_source_url character varying(512),
digest character varying(512),
author character varying(128),
content text,
news_items text,
is_permanent smallint DEFAULT '0'::smallint NOT NULL,
sync_status smallint DEFAULT '0'::smallint NOT NULL,
synced_at timestamp with time zone,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--
-- Name: wx_menus; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.wx_menus (
id bigint NOT NULL,
account_id bigint NOT NULL,
parent_id bigint,
menu_name character varying(128) NOT NULL,
menu_type character(32) NOT NULL,
menu_key character varying(128),
url character varying(512),
media_id character varying(128),
appid character varying(128),
pagepath character varying(256),
article_id character varying(128),
sort_order bigint,
status smallint,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--
-- Name: wx_messages; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.wx_messages (
id bigint NOT NULL,
account_id bigint NOT NULL,
openid character varying(128) NOT NULL,
msg_id bigint,
msg_type character(32) NOT NULL,
direction smallint NOT NULL,
content text,
media_id character varying(128),
pic_url character varying(512),
voice_format character(32),
recognition text,
thumb_media_id character varying(128),
msg_title character varying(256),
msg_description text,
link_url character varying(512),
event_type character(64),
event_key character varying(256),
reply_msg_id bigint,
is_auto_reply smallint,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--
-- Name: wx_pay_orders; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.wx_pay_orders (
id bigint NOT NULL,
account_id bigint NOT NULL,
out_trade_no character varying(64) NOT NULL,
transaction_id character varying(64),
openid character varying(128) NOT NULL,
body character varying(256) NOT NULL,
total_fee bigint NOT NULL,
fee_type character(16),
trade_type character(32) NOT NULL,
spbill_create_ip character varying(64),
notify_url character varying(512) NOT NULL,
prepay_id character varying(64),
code_url character varying(512),
mch_id character varying(64) NOT NULL,
trade_state character(32),
trade_state_desc character varying(256),
attach text,
time_expire timestamp with time zone,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--
-- Name: wx_pay_refunds; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.wx_pay_refunds (
id bigint NOT NULL,
account_id bigint NOT NULL,
out_trade_no character varying(64) NOT NULL,
out_refund_no character varying(64) NOT NULL,
transaction_id character varying(64),
refund_id character varying(64),
total_fee bigint NOT NULL,
refund_fee bigint NOT NULL,
refund_reason character varying(256),
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--
-- Name: wx_template_logs; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.wx_template_logs (
id bigint NOT NULL,
account_id bigint NOT NULL,
template_id character varying(128) NOT NULL,
openid character varying(128) NOT NULL,
content text,
miniprogram_appid character varying(128),
miniprogram_pagepath character varying(256),
msg_id bigint,
errcode bigint,
errmsg character varying(512),
status smallint,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--
-- Name: wx_templates; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.wx_templates (
id bigint NOT NULL,
account_id bigint NOT NULL,
template_id character varying(128) NOT NULL,
title character varying(256),
industry character varying(128),
content text,
example text,
template_type character(32),
status smallint,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--
-- Name: wx_users; Type: TABLE; Schema: qiluoopen; Owner: -
--
CREATE TABLE qiluoopen.wx_users (
id bigint NOT NULL,
account_id bigint NOT NULL,
openid character varying(128) NOT NULL,
unionid character varying(128),
nickname character varying(128),
sex smallint,
city character varying(64),
country character varying(64),
province character varying(64),
language character varying(64),
headimgurl character varying(512),
subscribe_time timestamp with time zone,
unsubscribe_time timestamp with time zone,
subscribe_status smallint,
remark character varying(256),
subscribe_scene character varying(128),
qr_scene character varying(128),
qr_scene_str character varying(256),
last_interact_time timestamp with time zone,
message_count bigint,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);
--
-- Name: sys_mail_log id; Type: DEFAULT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_mail_log ALTER COLUMN id SET DEFAULT nextval('qiluoopen.sys_mail_log_id_seq'::regclass);
--
-- Data for Name: seaql_migrations; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.seaql_migrations (version, applied_at) FROM stdin;
m20220101_000001_create_table 1723226505
m20220101_000002_create_codegen_config 1778843787
\.
--
-- Data for Name: sys_api_permission; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_api_permission (id, api, method, apiname, logcache, remark, sort, created_at) FROM stdin;
7232752187397280768 /sys/job/add Post 添加定时任务 0 但凡 1 2024-08-23 22:15:00+00
7232752187535692800 /sys/job/validate_cron Post 验证cron表达式 0 \N 3 2024-08-23 22:15:00+00
7232752187606995968 /sys/job/list Get 获取定时任务列表 0 \N 3 2024-08-23 22:15:00+00
7232752187674104832 /sys/job/edit Put 编辑定时任务 0 \N 4 2024-08-23 22:15:00+00
7232752187741213696 /sys/job/del Delete 删除定时任务 0 \N 5 2024-08-23 22:15:00+00
7232752187812516864 /sys/roleapi/add_many_role_api_transfer Get 添加多个角色api 0 \N 6 2024-08-23 22:15:00+00
7232752187879625728 /sys/roleapi/del Delete 删除角色api 0 \N 7 2024-08-23 22:15:00+00
7232752187946734592 /sys/roleapi/role_api_transfer_list Get 获取角色api所有的选择列表 0 \N 8 2024-08-23 22:15:00+00
7232752188013843456 /sys/roleapi/list Get 获取角色api列表 0 \N 9 2024-08-23 22:15:00+00
7232752188085146624 /sys/roleapi/edit Put 编辑角色api 0 \N 10 2024-08-23 22:15:00+00
7232752188156449792 /sys/roleapi/role_permission_list Get 根据角色id获取api权限列表 0 \N 11 2024-08-23 22:15:00+00
7232752188219364352 /sys/roleapi/add Post 添加角色api 0 \N 12 2024-08-23 22:15:00+00
7232752188282278912 /sys/dicttype/list Get 获取字典类型列表 0 \N 13 2024-08-23 22:15:00+00
7232752188349387776 /sys/dicttype/add Post 添加字典类型 0 \N 14 2024-08-23 22:15:00+00
7232752188412302336 /sys/dicttype/del Delete 删除字典类型 0 \N 15 2024-08-23 22:15:00+00
7232752188479411200 /sys/dicttype/edit Put 编辑字典类型 0 \N 16 2024-08-23 22:15:00+00
7232752188546520064 /sys/menu/edit Put 编辑菜单 0 \N 17 2024-08-23 22:15:00+00
7232752188617823232 /sys/menu/list Get 菜单列表 0 \N 18 2024-08-23 22:15:00+00
7232752188697515008 /sys/menu/add Post 添加菜单 0 \N 19 2024-08-23 22:15:00+00
7232752188764623872 /sys/menu/del Delete 删除菜单 0 \N 20 2024-08-23 22:15:00+00
7232752188835927040 /sys/menu/all_router Get 全部路由 0 \N 21 2024-08-23 22:15:00+00
7232752188898841600 /sys/menu/tree Get 获取菜单树 0 \N 22 2024-08-23 22:15:00+00
7232752188965950464 /sys/serverinfo/server_update Get 更新服务器信息 0 \N 23 2024-08-23 22:15:00+00
7232752189028865024 /sys/jobinfo/add Post 添加定时任务日志 0 \N 24 2024-08-23 22:15:00+00
7232752189095973888 /sys/jobinfo/list Get 获取定时任务日志列表 0 \N 25 2024-08-23 22:15:00+00
7232752189158888448 /sys/dictdata/get_by_type Get 根据类型获取字典数据 0 \N 26 2024-08-23 22:15:00+00
7232752189221803008 /sys/dictdata/list Get 获取字典数据列表 0 \N 27 2024-08-23 22:15:00+00
7232752189280523264 /sys/dictdata/del Delete 删除字典数据 0 \N 28 2024-08-23 22:15:00+00
7232752189347632128 /sys/dictdata/edit Put 编辑字典数据 0 \N 29 2024-08-23 22:15:00+00
7232752189410546688 /sys/dictdata/add Post 添加字典数据 0 \N 30 2024-08-23 22:15:00+00
7232752189473461248 /sys/dashboard/add Post 添加仪表盘 0 \N 31 2024-08-23 22:15:00+00
7232752189557347328 /sys/dashboard/list Get 获取仪表盘列表 0 \N 32 2024-08-23 22:15:00+00
7232752189628650496 /sys/role/list Get 获取角色列表 0 \N 33 2024-08-23 22:15:00+00
7232752189691565056 /sys/role/get_role_menus Get 获取角色菜单 0 \N 34 2024-08-23 22:15:00+00
7232752189758673920 /sys/role/menu Get 获取角色菜单 0 \N 35 2024-08-23 22:15:00+00
7232752189821588480 /sys/role/edit Put 编辑角色 0 \N 36 2024-08-23 22:15:00+00
7232752189888697344 /sys/role/tree Get 获取角色树 0 \N 37 2024-08-23 22:15:00+00
7232752189951611904 /sys/role/add Post 添加角色 0 \N 38 2024-08-23 22:15:00+00
7232752190018720768 /sys/role/del Delete 删除角色 0 \N 39 2024-08-23 22:15:00+00
7232752190081635328 /sys/apipermission/list Get 获取api权限列表 0 \N 40 2024-08-23 22:15:00+00
7232752190144549888 /sys/user/reset_password Put 重置密码 0 \N 41 2024-08-23 22:15:00+00
7232752190207464448 /sys/user/userinfo Get 获取用户信息 0 \N 42 2024-08-23 22:15:00+00
7232752190270379008 /sys/user/depts_roles Get 获取用户拥有的用户部门和用户角色 0 \N 43 2024-08-23 22:15:00+00
7232752190333293568 /sys/user/del Delete 删除用户 0 \N 44 2024-08-23 22:15:00+00
7232752190396208128 /sys/user/list Get 获取用户列表 0 \N 45 2024-08-23 22:15:00+00
7232752190459122688 /sys/user/add Post 添加用户 0 \N 46 2024-08-23 22:15:00+00
7232752190526231552 /sys/user/change_password Put 修改密码 0 \N 47 2024-08-23 22:15:00+00
7232752190589146112 /sys/user/edit Put 编辑用户 0 \N 48 2024-08-23 22:15:00+00
7232752190656254976 /sys/dept/edit Put 编辑部门 0 \N 49 2024-08-23 22:15:00+00
7232752190727558144 /sys/dept/add Post 添加部门 0 \N 50 2024-08-23 22:15:00+00
7232752190794667008 /sys/dept/list Get 获取部门列表 0 \N 51 2024-08-23 22:15:00+00
7232752190861775872 /sys/dept/del Delete 删除部门 0 \N 52 2024-08-23 22:15:00+00
7232752190933079040 /sys/dept/dept_tree Get 获取部门树 0 \N 53 2024-08-23 22:15:00+00
7232752190995993600 /sys/useronline/list Get 获取在线用户列表 0 \N 54 2024-08-23 22:15:00+00
7232752191063102464 /sys/logininfo/list Get 获取登录日志列表 0 \N 55 2024-08-23 22:15:00+00
7232781502121939968 /sys/user/delusers Delete 删除用户 0 \N 25 2024-08-24 00:11:29+00
7232794958103483392 /sys/dashboard/analysis/weeklyUserActivity Get 获取仪表盘数据 0 \N 24 2024-08-24 01:04:57+00
7232794958170592256 /sys/dashboard/analysis/total Get 获取仪表盘数据 0 \N 25 2024-08-24 01:04:57+00
7232794958229312512 /sys/dashboard/analysis/monthlySales Get 获取仪表盘数据 0 \N 26 2024-08-24 01:04:57+00
7232794958279644160 /sys/dashboard/analysis/userAccessSource Get 获取仪表盘数据 0 \N 27 2024-08-24 01:04:57+00
7232794958317392896 /sys/dashboard/workplace/dynamic Get 获取仪表盘数据 0 \N 28 2024-08-24 01:04:57+00
7232794958363530240 /sys/dashboard/workplace/total Get 获取仪表盘数据 0 \N 29 2024-08-24 01:04:57+00
7232794958401278976 /sys/dashboard/workplace/radar Get 获取仪表盘数据 0 \N 30 2024-08-24 01:04:57+00
7232794958447416320 /sys/dashboard/workplace/project Get 获取仪表盘数据 0 \N 31 2024-08-24 01:04:57+00
7232794958493553664 /sys/dashboard/workplace/team Get 获取仪表盘数据 0 \N 32 2024-08-24 01:04:57+00
7233868069737501696 /sys/apipermission/edit Put 编辑api权限 0 \N 63 2024-08-27 00:09:07+00
7234253747373642752 /sys/operationlog/list Get 获取操作日志列表 0 \N 52 2024-08-28 01:41:39+00
7234570580194661376 /sys/useronline/del Delete 退出在线用户 0 \N 47 2024-08-28 22:40:38+00
7234616780964926464 /sys/cache/clear Post 清空缓存 0 \N 18 2024-08-29 01:44:13+00
7234616781027841024 /sys/cache/list Get 获取缓存列表 0 \N 19 2024-08-29 01:44:13+00
7235633673968456704 /sys/role/get_role_depts Get 获取角色部门 0 \N 12 2024-08-31 21:04:59+00
7235678367742071808 /sys/job/hand_execute_job Post 执行定时任务 0 \N 67 2024-09-01 00:02:35+00
7236784152022782976 /sys/user/fresh_token Put 刷新token 0 \N 36 2024-09-04 01:16:35+00
7236784153973134336 /sys/user/update_avatar Put 更新头像 0 \N 38 2024-09-04 01:16:35+00
7240020747752477696 /sys/user/refersh_token Put 刷新token 0 \N 66 2024-09-12 23:37:39+00
7241490807281062912 /sys/user/login_out Get 用户退出 0 \N 66 2024-09-17 00:59:09+00
7252729164858299392 /sys/role/user_role_name_list Get 获取用户拥有的角色名称列表 0 \N 14 2024-10-18 01:16:22+00
7252738573697192960 /sys/dept/user_dept_name_list Get 获取用户拥有的部门名称列表 0 \N 44 2024-10-18 01:53:45+00
7253067149336286208 /sys/user/update_role_or_dept Post 更新用户拥有的用户部门和用户角色 0 \N 57 2024-10-18 23:39:24+00
7348333842530210816 /wechat/wxaccounts/del Delete 删除微信公众号 0 \N 76 2025-07-08 20:55:13+00
7348333842559570944 /wechat/wxaccounts/edit Put 编辑微信公众号 0 \N 77 2025-07-08 20:55:14+00
7348333842567959552 /wechat/wxaccounts/list Get 获取微信公众号列表 0 \N 78 2025-07-08 20:55:14+00
7348333842572153856 /wechat/wxaccounts/add Post 添加微信公众号 0 \N 79 2025-07-08 20:55:14+00
7348333842584736768 /wechat/wxautoreplies/add Post 添加自动回复 0 \N 80 2025-07-08 20:55:14+00
7348333842609902592 /wechat/wxautoreplies/del Delete 删除自动回复 0 \N 81 2025-07-08 20:55:14+00
7348333842635068416 /wechat/wxautoreplies/list Get 获取自动回复列表 0 \N 82 2025-07-08 20:55:14+00
7348333843008361472 /wechat/wxautoreplies/edit Put 编辑自动回复 0 \N 83 2025-07-08 20:55:14+00
7348333843016750080 /wechat/wxmenus/list Get 获取微信菜单列表 0 \N 84 2025-07-08 20:55:14+00
7348333843071276032 /wechat/wxmenus/del Delete 删除微信菜单 0 \N 85 2025-07-08 20:55:14+00
7348333843075470336 /wechat/wxmenus/pull_menu Post 发布菜单到微信 0 \N 86 2025-07-08 20:55:14+00
7348333843092247552 /wechat/wxmenus/add Post 添加微信菜单 0 \N 87 2025-07-08 20:55:14+00
7348333843100636160 /wechat/wxmenus/edit Put 编辑微信菜单 0 \N 88 2025-07-08 20:55:14+00
7348333843104830464 /wechat/wxmessages/list Get 获取微信消息列表 0 \N 89 2025-07-08 20:55:14+00
7348333843125801984 /wechat/wxmessages/edit Put 编辑微信消息 0 \N 90 2025-07-08 20:55:14+00
7348333843138384896 /wechat/wxmessages/del Delete 删除微信消息 0 \N 91 2025-07-08 20:55:14+00
7348333843150967808 /wechat/wxmessages/add Post 添加微信消息 0 \N 92 2025-07-08 20:55:14+00
7348333843159356416 /wechat/wxusers/add Post 添加微信用户 0 \N 93 2025-07-08 20:55:14+00
7348333843167745024 /wechat/wxusers/edit Put 编辑微信用户 0 \N 94 2025-07-08 20:55:14+00
7348333843180327936 /wechat/wxusers/del Delete 删除微信用户 0 \N 95 2025-07-08 20:55:14+00
7348333843184522240 /wechat/wxusers/list Get 获取微信用户列表 0 \N 96 2025-07-08 20:55:14+00
7385368752226735104 /test/test_api/list Get 获取列表 0 \N 75 2025-10-19 01:38:44+00
7385368752235123712 /test/test_api/del Delete 删除TestApi 0 \N 76 2025-10-19 01:38:44+00
7385368752239318016 /test/test_api/add Post 添加TestApi 0 \N 77 2025-10-19 01:38:44+00
7385368752243512320 /test/test_api/edit Put 编辑TestApi 0 \N 78 2025-10-19 01:38:44+00
7401293722618336256 /test/test_api/db_read_write_test Put db_read_write_test 0 \N 76 2025-12-02 00:18:53+00
7401293722630919168 /test/test_api/db_name_test Put db_name_test 0 \N 77 2025-12-02 00:18:53+00
7401293722647696384 /test/test_api/db_index_test Put db_index_test 0 \N 81 2025-12-02 00:18:53+00
7401293722651890688 /test/test_api/db_auto_test Put db_auto_test 0 \N 82 2025-12-02 00:18:53+00
7402694868939478016 /test/test_data_scope/del Delete Delete 0 \N 83 2025-12-05 21:06:32+00
7402694868947866624 /test/test_data_scope/list Get list 0 \N 84 2025-12-05 21:06:32+00
7402694868947866625 /test/test_data_scope/add Post add 0 \N 85 2025-12-05 21:06:32+00
7402694868952060928 /test/test_data_scope/edit Put edit 0 \N 86 2025-12-05 21:06:32+00
7461047623965643776 /sys/codegen/scan Get 扫描所有Entity 0 \N 62 2026-05-15 21:39:33+00
7461047623990809600 /sys/codegen/generate Post 生成代码 0 \N 63 2026-05-15 21:39:33+00
7461309194964997120 /sys/codegen/load_config Get 加载字段配置 0 \N 37 2026-05-16 14:58:57+00
7461309194973385728 /sys/codegen/save_config Post 保存字段配置 0 \N 38 2026-05-16 14:58:57+00
7461472538283906048 /test/test_article/del Delete 删除TestArticle 0 \N 9 2026-05-17 01:48:01+00
7461472538304877568 /test/test_article/edit Put 编辑TestArticle 0 \N 10 2026-05-17 01:48:01+00
7461472538309071872 /test/test_article/add Post 添加TestArticle 0 \N 11 2026-05-17 01:48:01+00
7461472538313266176 /test/test_article/list Get 获取TestArticle列表 0 \N 12 2026-05-17 01:48:01+00
7461476362570601472 /test/test_category/list Get 获取TestCategory列表 0 \N 91 2026-05-17 02:03:12+00
7461476362583184384 /test/test_category/del Delete 删除TestCategory 0 \N 92 2026-05-17 02:03:12+00
7461476362591572992 /test/test_category/edit Put 编辑TestCategory 0 \N 93 2026-05-17 02:03:12+00
7461476362595767296 /test/test_category/add Post 添加TestCategory 0 \N 94 2026-05-17 02:03:12+00
7462535578852955136 /sys/upload Post 上传文件 0 \N 79 2026-05-20 00:12:09+00
7463953200110801920 /game/purchase/list Get 内购列表 0 \N 1 2026-05-23 22:05:16+00
7463953200127579136 /game/purchase/validate Post 验证内购 0 \N 2 2026-05-23 22:05:16+00
7463953200135967744 /game/purchase/confirm Post 确认内购 0 \N 3 2026-05-23 22:05:16+00
7463953200140162048 /game/purchase/refund Post 退款 0 \N 4 2026-05-23 22:05:16+00
7463953200144356352 /game/account/device_login Post 设备ID登录 0 \N 5 2026-05-23 22:05:16+00
7463953200148550656 /game/account/list Get 账号列表 0 \N 6 2026-05-23 22:05:16+00
7463953200152744960 /game/account/email_login Post 邮箱登录 0 \N 7 2026-05-23 22:05:16+00
7463953200156939264 /game/account/username_register Post 用户名注册 0 \N 8 2026-05-23 22:05:16+00
7463953200161133568 /game/account/email_register Post 邮箱注册 0 \N 9 2026-05-23 22:05:16+00
7463953200169522176 /game/account/get Get 获取账号信息 0 \N 10 2026-05-23 22:05:16+00
7463953200173716480 /game/account/update Put 更新账号资料 0 \N 11 2026-05-23 22:05:16+00
7463953200177910784 /game/account/link_device Post 关联设备ID 0 \N 12 2026-05-23 22:05:16+00
7463953200186299392 /game/account/link_custom_id Post 关联自定义ID 0 \N 13 2026-05-23 22:05:16+00
7463953200190493696 /game/account/username_login Post 用户名登录 0 \N 14 2026-05-23 22:05:16+00
7463953201851438080 /game/chat/join_channel Post 加入频道 0 \N 15 2026-05-23 22:05:17+00
7463953201855632384 /game/chat/send_direct Post 发送私聊消息 0 \N 16 2026-05-23 22:05:17+00
7463953201859826688 /game/chat/messages Get 消息列表 0 \N 17 2026-05-23 22:05:17+00
7463953201864020992 /game/chat/leave_channel Post 离开频道 0 \N 18 2026-05-23 22:05:17+00
7463953201868215296 /game/chat/send Post 发送频道消息 0 \N 19 2026-05-23 22:05:17+00
7463953201868215297 /game/chat/create_channel Post 创建频道 0 \N 20 2026-05-23 22:05:17+00
7463953201872409600 /game/group/kick Post 踢出成员 0 \N 21 2026-05-23 22:05:17+00
7463953201876603904 /game/group/list Get 群组列表 0 \N 22 2026-05-23 22:05:17+00
7463953201880798208 /game/group/update Put 更新群组 0 \N 23 2026-05-23 22:05:17+00
7463953201884992512 /game/group/leave Post 离开群组 0 \N 24 2026-05-23 22:05:17+00
7463953201889186816 /game/group/members Get 群组成员列表 0 \N 25 2026-05-23 22:05:17+00
7463953201893381120 /game/group/create Post 创建群组 0 \N 26 2026-05-23 22:05:17+00
7463953202581246976 /game/group/join Post 加入群组 0 \N 27 2026-05-23 22:05:17+00
7463953202585441280 /game/matchmaker/create_ticket Post 创建匹配票 0 \N 28 2026-05-23 22:05:17+00
7463953202589635584 /game/matchmaker/cancel_ticket Post 取消匹配 0 \N 29 2026-05-23 22:05:17+00
7463953202593829888 /game/matchmaker/get_ticket Get 查询匹配状态 0 \N 30 2026-05-23 22:05:17+00
7463953202598024192 /game/storage/write Post 写入存储对象 0 \N 31 2026-05-23 22:05:17+00
7463953202602218496 /game/storage/delete Delete 删除存储对象 0 \N 32 2026-05-23 22:05:17+00
7463953202606412800 /game/storage/list Get 存储对象列表 0 \N 33 2026-05-23 22:05:17+00
7463953202610607104 /game/storage/read Get 读取存储对象 0 \N 34 2026-05-23 22:05:17+00
7463953202614801408 /game/leaderboard/list Get 排行榜列表 0 \N 35 2026-05-23 22:05:17+00
7463953202618995712 /game/leaderboard/delete Delete 删除排行榜 0 \N 36 2026-05-23 22:05:17+00
7463953202623190016 /game/leaderboard/create Post 创建排行榜 0 \N 37 2026-05-23 22:05:17+00
7463953202627384320 /game/leaderboard/submit_score Post 提交分数 0 \N 38 2026-05-23 22:05:17+00
7463953202631578624 /game/leaderboard/records Get 获取排行榜记录 0 \N 39 2026-05-23 22:05:17+00
7463953202635772928 /game/friend/add Post 添加好友 0 \N 40 2026-05-23 22:05:17+00
7463953202639967232 /game/friend/block Post 屏蔽用户 0 \N 41 2026-05-23 22:05:17+00
7463953202644161536 /game/friend/list Get 好友列表 0 \N 42 2026-05-23 22:05:17+00
7463953202648355840 /game/friend/accept Post 接受好友请求 0 \N 43 2026-05-23 22:05:17+00
7463953202652550144 /game/friend/remove Delete 删除好友 0 \N 44 2026-05-23 22:05:17+00
7463953202656744448 /game/social/login Post 社交登录 0 \N 45 2026-05-23 22:05:17+00
7463953202660938752 /game/social/link Post 关联社交账号 0 \N 46 2026-05-23 22:05:17+00
7463953202660938753 /game/social/list Get 社交关联列表 0 \N 47 2026-05-23 22:05:17+00
7463953202665133056 /game/social/unlink Post 解除社交关联 0 \N 48 2026-05-23 22:05:17+00
7463953202669327360 /game/notification/unread_count Get 未读数量 0 \N 49 2026-05-23 22:05:17+00
7463953202677715968 /game/notification/delete Delete 删除通知 0 \N 50 2026-05-23 22:05:17+00
7463953202677715969 /game/notification/list Get 通知列表 0 \N 51 2026-05-23 22:05:17+00
7463953202681910272 /game/notification/mark_read Post 标记已读 0 \N 52 2026-05-23 22:05:17+00
7463953202686104576 /game/notification/send Post 发送通知 0 \N 53 2026-05-23 22:05:17+00
7463953202690298880 /game/match/list Get 对战列表 0 \N 54 2026-05-23 22:05:17+00
7463953202694493184 /game/match/get Get 对战详情 0 \N 55 2026-05-23 22:05:17+00
7463953202698687488 /game/match/players Get 对战成员列表 0 \N 56 2026-05-23 22:05:17+00
7463953203009065984 /game/match/delete Delete 删除对战 0 \N 57 2026-05-23 22:05:17+00
7463953203013260288 /game/match/join Post 加入对战 0 \N 58 2026-05-23 22:05:17+00
7463953203017454592 /game/match/create Post 创建对战 0 \N 59 2026-05-23 22:05:17+00
7463953203021648896 /game/match/leave Post 离开对战 0 \N 60 2026-05-23 22:05:17+00
7463953203051009024 /game/wallet/balance Get 获取余额 0 \N 61 2026-05-23 22:05:17+00
7463953203055203328 /game/wallet/ledger Post 钱包变动 0 \N 62 2026-05-23 22:05:17+00
7463953203059397632 /game/wallet/list_ledger Get 流水列表 0 \N 63 2026-05-23 22:05:17+00
7463953203063591936 /game/party/my_party Get 我的队伍 0 \N 64 2026-05-23 22:05:17+00
7463953203067786240 /game/party/create Post 创建组队 0 \N 65 2026-05-23 22:05:17+00
7463953203071980544 /game/party/transfer_leader Post 转让队长 0 \N 66 2026-05-23 22:05:17+00
7463953203076174848 /game/party/kick Post 踢出成员 0 \N 67 2026-05-23 22:05:17+00
7463953203080369152 /game/party/leave Post 离开组队 0 \N 68 2026-05-23 22:05:17+00
7463953203084563456 /game/party/join Post 加入组队 0 \N 69 2026-05-23 22:05:17+00
7463953203088757760 /game/party/get Get 获取组队信息 0 \N 70 2026-05-23 22:05:17+00
7463953203092952064 /game/tournament/list Get 锦标赛列表 0 \N 71 2026-05-23 22:05:17+00
7463953203097146368 /game/tournament/join Post 加入锦标赛 0 \N 72 2026-05-23 22:05:17+00
7463953203101340672 /game/tournament/delete Delete 删除锦标赛 0 \N 73 2026-05-23 22:05:17+00
7463953203101340673 /game/tournament/submit_score Post 提交锦标赛分数 0 \N 74 2026-05-23 22:05:17+00
7463953203105534976 /game/tournament/leave Post 离开锦标赛 0 \N 75 2026-05-23 22:05:17+00
7463953203109729280 /game/tournament/update_status Post 更新锦标赛状态 0 \N 76 2026-05-23 22:05:17+00
7463953203113923584 /game/tournament/participants Get 锦标赛参与者列表 0 \N 77 2026-05-23 22:05:17+00
7463953203118117888 /game/tournament/create Post 创建锦标赛 0 \N 78 2026-05-23 22:05:17+00
7463953203122312192 /game/presence/get Get 获取在线状态 0 \N 79 2026-05-23 22:05:17+00
7463953203126506496 /game/presence/update Post 更新在线状态 0 \N 80 2026-05-23 22:05:17+00
7463953203130700800 /game/script/get Get 脚本详情 0 \N 81 2026-05-23 22:05:17+00
7463953203134895104 /game/script/create Post 创建脚本 0 \N 82 2026-05-23 22:05:17+00
7463953203139089408 /game/script/execute Post 执行脚本 0 \N 83 2026-05-23 22:05:17+00
7463953203143283712 /game/script/list Get 脚本列表 0 \N 84 2026-05-23 22:05:17+00
7463953203147478016 /game/script/update Put 更新脚本 0 \N 85 2026-05-23 22:05:17+00
7463953203151672320 /game/script/publish Post 发布脚本 0 \N 86 2026-05-23 22:05:17+00
7463953203185226752 /game/script/logs Get 脚本日志 0 \N 87 2026-05-23 22:05:17+00
7463953203189421056 /game/script/delete Delete 删除脚本 0 \N 88 2026-05-23 22:05:17+00
7467279059899028480 /wechat/wxpay/notify/{account_id} Post 支付回调通知 0 \N 29 2026-06-02 02:21:03+00
7467279059911611392 /wechat/wxpay/query_order Post 查询订单状态 0 \N 30 2026-06-02 02:21:03+00
7467279059915805696 /wechat/wxpay/refunds Get 获取退款列表 0 \N 31 2026-06-02 02:21:03+00
7467279059924194304 /wechat/wxpay/close_order Post 关闭订单 0 \N 32 2026-06-02 02:21:03+00
7467279059928388608 /wechat/wxpay/create_order Post 创建支付订单 0 \N 33 2026-06-02 02:21:03+00
7467279059932582912 /wechat/wxpay/refund Post 申请退款 0 \N 34 2026-06-02 02:21:03+00
7467279059940971520 /wechat/wxpay/orders Get 获取支付订单列表 0 \N 35 2026-06-02 02:21:03+00
7467279059945165824 /wechat/wxmessages/conversation Get 获取会话消息列表 0 \N 36 2026-06-02 02:21:03+00
7467279059961943040 /wechat/wxmessages/reply Post 手动回复消息 0 \N 39 2026-06-02 02:21:03+00
7467279059999691776 /wechat/wxmenus/sync_menu Post 从微信同步菜单到本地 0 \N 45 2026-06-02 02:21:03+00
7467279060016468992 /wechat/wxmenus/delete_remote_menu Post 删除微信服务器上的自定义菜单 0 \N 48 2026-06-02 02:21:03+00
7467279060029051904 /wechat/official_account/callback Post 微信公众号消息回调 0 \N 49 2026-06-02 02:21:03+00
7467279060037440512 /wechat/official_account/verify Get 微信公众号验证 0 \N 50 2026-06-02 02:21:03+00
7467279060041634816 /wechat/wxtemplates/send Post 发送模板消息 0 \N 51 2026-06-02 02:21:03+00
7467279060045829120 /wechat/wxtemplates/del Delete 删除微信模板 0 \N 52 2026-06-02 02:21:03+00
7467279060050023424 /wechat/wxtemplates/list Get 获取微信模板列表 0 \N 53 2026-06-02 02:21:03+00
7467279060058412032 /wechat/wxtemplates/sync Post 从微信服务器同步模板 0 \N 54 2026-06-02 02:21:03+00
7467279060062606336 /wechat/wxtemplates/add Post 添加微信模板 0 \N 55 2026-06-02 02:21:03+00
7467279060066800640 /wechat/wxtemplates/logs Get 获取模板发送日志 0 \N 56 2026-06-02 02:21:03+00
7467279060075189248 /wechat/wxtemplates/edit Put 编辑微信模板 0 \N 57 2026-06-02 02:21:03+00
7467279060100355072 /sys/mailer/config Get 获取邮件配置 0 \N 62 2026-06-02 02:21:03+00
7467279060104549376 /sys/mailer/send Post 发送邮件 0 \N 63 2026-06-02 02:21:03+00
7467279060112937984 /sys/mailer/log_list Get 获取邮件日志列表 0 \N 64 2026-06-02 02:21:03+00
7467279060117132288 /sys/mailer/send_template Post 发送模板邮件 0 \N 65 2026-06-02 02:21:03+00
7467293259341927424 /wechat/wxmessages/stream Get SSE消息推送 0 \N 5 2026-06-02 03:17:29+00
7467489282072941568 /wechat/wxmaterials/sync_materials Post 从微信同步素材到本地 0 \N 136 2026-06-02 16:16:24+00
7467489282081330176 /wechat/wxmaterials/upload_news Post 上传永久图文素材到微信 0 \N 137 2026-06-02 16:16:24+00
7467489282085524480 /wechat/wxmaterials/list Get 获取微信素材列表 0 \N 138 2026-06-02 16:16:24+00
7467489282089718784 /wechat/wxmaterials/edit Put 编辑微信素材 0 \N 139 2026-06-02 16:16:24+00
7467489282093913088 /wechat/wxmaterials/del Delete 删除微信素材 0 \N 140 2026-06-02 16:16:24+00
7467489282098107392 /wechat/wxmaterials/upload_temp_media Post 上传临时素材到微信 0 \N 141 2026-06-02 16:16:24+00
7467489282102301696 /wechat/wxmaterials/upload_permanent_media Post 上传永久素材到微信 0 \N 142 2026-06-02 16:16:24+00
7467489282106496000 /wechat/wxmaterials/material_count Post 获取微信素材计数 0 \N 143 2026-06-02 16:16:24+00
7467489282110690304 /wechat/wxmaterials/delete_remote_media Post 删除微信服务器上的永久素材 0 \N 144 2026-06-02 16:16:24+00
7467489282114884608 /wechat/wxmaterials/upload_file Post 上传文件到服务器本地 0 \N 145 2026-06-02 16:16:24+00
7467489282119078912 /wechat/wxmaterials/add Post 添加微信素材 0 \N 146 2026-06-02 16:16:24+00
7467596925076673536 /sys/mailer/template/edit Put 编辑邮件模板 0 \N 91 2026-06-02 23:24:08+00
7467596925085062144 /sys/mailer/template/del/{id} Delete 删除邮件模板 0 \N 92 2026-06-02 23:24:08+00
7467596925089256448 /sys/mailer/template/list Get 获取邮件模板列表 0 \N 93 2026-06-02 23:24:08+00
7467596925093450752 /sys/mailer/template/add Post 新增邮件模板 0 \N 94 2026-06-02 23:24:08+00
7467601014565016576 /sys/mailer/template/del Delete 删除邮件模板 0 \N 6 2026-06-02 23:40:23+00
\.
--
-- Data for Name: sys_codegen_config; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_codegen_config (id, module_name, table_name, config_json, created_at, updated_at) FROM stdin;
7461365840546272256 test test_api [{"field_name":"id","show_in_list":true,"show_in_search":false,"show_in_form":false,"component":null,"show_in_detail":true,"required":true,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null},{"field_name":"id","show_in_list":true,"show_in_search":false,"show_in_form":false,"component":"InputNumber","show_in_detail":true,"required":null,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null},{"field_name":"name","show_in_list":true,"show_in_search":true,"show_in_form":true,"component":null,"show_in_detail":true,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null},{"field_name":"age","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":"Textarea","show_in_detail":true,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null},{"field_name":"email","show_in_list":true,"show_in_search":true,"show_in_form":true,"component":null,"show_in_detail":true,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null},{"field_name":"created_at","show_in_list":false,"show_in_search":false,"show_in_form":false,"component":"DatePicker","show_in_detail":true,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null},{"field_name":"updated_at","show_in_list":false,"show_in_search":false,"show_in_form":false,"component":"DatePicker","show_in_detail":true,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null}] 2026-05-16 18:44:02+00 2026-05-16 19:02:49+00
7461390264666330112 test test_category [{"field_name":"id","show_in_list":true,"show_in_search":false,"show_in_form":false,"component":null,"show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":true,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"name","show_in_list":true,"show_in_search":true,"show_in_form":true,"component":null,"show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"description","show_in_list":true,"show_in_search":true,"show_in_form":true,"component":"InputTextarea","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"sort","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":"InputNumber","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":null,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"status","show_in_list":true,"show_in_search":true,"show_in_form":true,"component":"Select","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":null,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"cover","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":"Upload","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":null,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"is_active","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":"Switch","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"weight","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":"InputNumber","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"view_count","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":null,"show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"created_at","show_in_list":true,"show_in_search":false,"show_in_form":false,"component":"DatePicker","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"updated_at","show_in_list":true,"show_in_search":false,"show_in_form":false,"component":"DatePicker","show_in_detail":true,"sortable":true,"sort_priority":1,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null}] 2026-05-16 20:21:05+00 2026-05-20 03:13:52+00
7461403558273782784 test test_article [{"field_name":"id","show_in_list":true,"show_in_search":false,"show_in_form":false,"component":null,"show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":true,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"category_id","show_in_list":true,"show_in_search":true,"show_in_form":true,"component":"Select","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":"TestCategory","relation_display_field":null},{"field_name":"title","show_in_list":true,"show_in_search":true,"show_in_form":true,"component":null,"show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"content","show_in_list":true,"show_in_search":true,"show_in_form":true,"component":"InputTextarea","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"author","show_in_list":true,"show_in_search":true,"show_in_form":true,"component":null,"show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"password","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":"InputPassword","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"is_published","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":"Switch","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"view_count","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":null,"show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"download_count","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":"InputNumber","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"rating","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":"InputNumber","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"cover","show_in_list":true,"show_in_search":false,"show_in_form":true,"component":"Upload","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"published_at","show_in_list":false,"show_in_search":false,"show_in_form":false,"component":"DatePicker","show_in_detail":true,"sortable":null,"sort_priority":null,"sort_order":null,"label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"created_at","show_in_list":false,"show_in_search":false,"show_in_form":false,"component":"DatePicker","show_in_detail":true,"sortable":true,"sort_priority":2,"sort_order":"asc","label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null},{"field_name":"updated_at","show_in_list":false,"show_in_search":false,"show_in_form":false,"component":"DatePicker","show_in_detail":true,"sortable":true,"sort_priority":4,"sort_order":"asc","label":null,"required":false,"min_length":null,"max_length":null,"pattern":null,"pattern_message":null,"relation_target":null,"relation_display_field":null}] 2026-05-16 21:13:54+00 2026-05-20 01:38:16+00
\.
--
-- Data for Name: sys_dept; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_dept (dept_id, parent_id, dept_name, lft, rgt, depth, dept_category, "order", leader, phone, email, status, remark, created_at, updated_at, deleted_at) FROM stdin;
100 0 科技 1 26 1 \N 1 \N 15888888888 xxx@qq.com 0 \N 2024-07-03 01:17:31+00 \N \N
101 100 深圳总公司 2 13 2 \N 1 \N 15888888888 xxx@qq.com 0 \N 2024-07-03 01:17:31+00 \N \N
102 100 长沙分公司 14 21 2 \N 2 \N 187554971 xxx@qq.com 0 长沙的公司 2024-07-03 01:17:31+00 \N \N
103 101 研发部门 3 4 3 \N 1 1 15888888888 xxx@qq.com 0 \N 2024-07-03 01:17:31+00 \N \N
104 101 市场部门 5 6 3 \N 2 \N 15888888888 xxx@qq.com 0 \N 2024-07-03 01:17:31+00 \N \N
105 101 测试部门 7 8 3 \N 3 \N 15888888888 xxx@qq.com 0 \N 2024-07-03 01:17:31+00 \N \N
106 101 财务部门 9 10 3 \N 4 \N 15888888888 xxx@qq.com 0 \N 2024-07-03 01:17:31+00 \N \N
107 101 运维部门 11 12 3 \N 5 \N 15888888888 xxx@qq.com 0 \N 2024-07-03 01:17:31+00 \N \N
108 102 市场部门 15 16 3 \N 1 \N 15888888888 xxx@qq.com 0 \N 2024-07-03 01:17:31+00 \N \N
109 102 财务部门 17 18 3 \N 2 \N 15888888888 xxx@qq.com 0 \N 2024-07-03 01:17:31+00 \N \N
7223731313261547520 102 运维部门 19 20 3 \N 3 \N \N \N 0 长沙运维部门 \N \N \N
7223731922878468096 100 广州分公司 22 25 2 \N 5 \N \N \N 0 \N \N \N \N
7223732104475054080 7223731922878468096 小部门 23 24 3 \N 3 \N \N \N 0 \N \N \N \N
\.
--
-- Data for Name: sys_dict_data; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type_id, created_at, updated_at, remark) FROM stdin;
1 1 男 0 1 2024-07-03 01:17:32+00 \N 性别男
2 2 女 1 1 2024-07-03 01:17:32+00 \N 性别女
3 3 未知 2 1 2024-07-03 01:17:32+00 \N 性别未知
4 1 显示 0 2 2024-07-03 01:17:32+00 \N 显示菜单a
5 2 隐藏 1 2 2024-07-03 01:17:32+00 \N 隐藏菜单
6 1 正常 0 3 2024-07-03 01:17:33+00 \N 正常状态
7 2 停用 1 3 2024-07-03 01:17:33+00 \N 停用状态
12 3 是 Y 6 2024-07-03 01:17:33+00 \N 系统默认是
13 4 否 N 6 2024-07-03 01:17:33+00 \N 系统默认否
14 1 通知 1 7 2024-07-03 01:17:33+00 \N 通知
15 2 公告 2 7 2024-07-03 01:17:33+00 \N 公告
16 1 正常 0 8 2024-07-03 01:17:33+00 \N 正常状态
17 2 关闭 1 8 2024-07-03 01:17:33+00 \N 关闭状态
18 1 新增 1 9 2024-07-03 01:17:33+00 \N 新增操作
19 2 修改 2 9 2024-07-03 01:17:33+00 \N 修改操作
20 3 删除 3 9 2024-07-03 01:17:33+00 \N 删除操作
21 4 授权 4 9 2024-07-03 01:17:33+00 \N 授权操作
22 5 导出 5 9 2024-07-03 01:17:33+00 \N 导出操作
23 6 导入 6 9 2024-07-03 01:17:33+00 \N 导入操作
24 7 强退 7 9 2024-07-03 01:17:33+00 \N 强退操作
25 8 生成代码 8 9 2024-07-03 01:17:33+00 \N 生成操作
26 9 清空数据 9 9 2024-07-03 01:17:33+00 \N 清空操作
27 1 成功 0 10 2024-07-03 01:17:33+00 \N 正常状态
28 2 失败 1 10 2024-07-03 01:17:33+00 \N 停用状态
29 99 其他 0 9 2024-07-03 01:17:33+00 \N 其他操作
30 0 密码认证 password 11 2024-07-03 01:17:33+00 \N 密码认证
31 0 短信认证 sms 11 2024-07-03 01:17:33+00 \N 短信认证
32 0 邮件认证 email 11 2024-07-03 01:17:33+00 \N 邮件认证
33 0 小程序认证 xcx 11 2024-07-03 01:17:33+00 \N 小程序认证
34 0 三方登录认证 social 11 2024-07-03 01:17:33+00 \N 三方登录认证
35 0 PC pc 12 2024-07-03 01:17:33+00 \N PC
36 0 安卓 android 12 2024-07-03 01:17:33+00 \N 安卓
37 0 iOS ios 12 2024-07-03 01:17:33+00 \N iOS
38 0 小程序 xcx 12 2024-07-03 01:17:33+00 \N 小程序
7229170738212769792 1 请求网址 geturl 7229170480917385217 \N \N GET请求网址
7229171315483217920 3 发送邮件 sendemail 7229170480917385217 \N \N 发送邮件
7230797167031619584 1 默认 default 7230795611045498880 \N \N \N
7230797303799484416 3 系统 system 7230795611045498880 \N \N \N
7233442254918947840 1 不记录 0 7233442155891430400 \N \N \N
7233442310988403712 3 数据库 2 7233442155891430400 \N \N \N
7233442350909789184 2 文件记录 1 7233442155891430400 \N \N \N
7233442400423547904 5 数据库和文件 3 7233442155891430400 \N \N \N
7235988025748919296 3 调用方法 invokefunction 7229170480917385217 \N \N 调用方法
\.
--
-- Data for Name: sys_dict_type; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_dict_type (dict_id, dict_name, dict_type, "order", created_at, updated_at, remark) FROM stdin;
1 用户性别 sys_user_sex 103 2024-07-03 01:17:32+00 2024-07-03 01:17:32+00 用户性别列表
2 菜单状态 sys_show_hide 103 2024-07-03 01:17:32+00 2024-07-03 01:17:32+00 菜单状态列表
3 系统开关 sys_normal_disable 103 2024-07-03 01:17:32+00 2024-07-03 01:17:32+00 系统开关列表
6 系统是否 sys_yes_no 103 2024-07-03 01:17:32+00 2024-07-03 01:17:32+00 系统是否列表
7 通知类型 sys_notice_type 103 2024-07-03 01:17:32+00 2024-08-14 01:06:32+00 通知类型列表
8 通知状态 sys_notice_status 103 2024-07-03 01:17:32+00 2024-07-03 01:17:32+00 通知状态列表
9 操作类型 sys_oper_type 103 2024-07-03 01:17:32+00 2024-07-03 01:17:32+00 操作类型列表
10 系统状态 sys_common_status 103 2024-07-03 01:17:32+00 2024-07-03 01:17:32+00 登录状态列表
11 授权类型 sys_grant_type 103 2024-07-03 01:17:32+00 2024-07-03 01:17:32+00 认证授权类型
12 设备类型 sys_device_type 103 2024-07-03 01:17:32+00 2024-07-03 01:17:32+00 客户端设备类型
7229170480917385217 定时任务 sys_job 1 2024-08-14 01:02:34+00 2024-08-14 01:02:34+00 定时任务类型
7230795611045498880 任务分组 sys_job_group 3 2024-08-18 12:40:15+00 2024-08-18 12:40:15+00 定时任务分组
7233442155891430400 日志记录 sys_logcache 2 2024-08-25 19:56:41+00 2024-08-25 20:46:41+00 日志记录
7235877375018177536 数据权限 sys_data_scope 4 2024-09-01 13:13:22+00 2024-09-01 13:13:22+00 数据权限
\.
--
-- Data for Name: sys_job; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_job (created_at, updated_at, job_id, task_type, task_count, run_count, job_name, job_params, job_group, cron_expression, status, remark) FROM stdin;
2024-08-16 00:34:21+00 2024-08-29 22:01:40+00 7227378358836924416 geturl 0 1737 请求百度 https://www.baidu.com/ default 30 * * * * ? 1 66
2024-08-16 00:34:21+00 2024-08-29 22:01:44+00 7227378358836924417 geturl 0 3479 请求QQ https://www.qq.com/ default 0/30 * * * * ? 1 99
2024-09-01 12:35:38+00 2024-09-01 22:24:37+00 7235988676738454528 invokefunction 0 13 清理过期的Token {"callfun":"clearuserinfo"} default * * 2 * * ? 1 晚上两点执行清理过期的Token
\.
--
-- Data for Name: sys_job_log; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_job_log (created_at, id, job_id, run_count, job_message, status, elapsed_time) FROM stdin;
\.
--
-- Data for Name: sys_login_info; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_login_info (info_id, uid, user_name, device_type, ipaddr, login_location, net_work, browser, os, status, msg, login_time) FROM stdin;
\.
--
-- Data for Name: sys_mail_log; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_mail_log (id, recipient, subject, content_text, content_html, from_addr, reply_to, status, error_message, mail_type, created_by, created_at, updated_at) FROM stdin;
7467793347218674688 761907552@qq.com boy 你好 boy 你好 boy 你好 boy 948547440@qq.com pending \N plain 1 2026-06-03 04:24:38+00 \N
7467793672268846080 761907552@qq.com boy boy d boydd \N 948547440@qq.com success \N plain 1 2026-06-03 04:25:56+00 \N
7467796447153263616 761907552@qq.com boy boy d boydd \N 948547440@qq.com failed no from sender configured plain 1 2026-06-03 04:36:57+00 \N
7467797633671533568 761907552@qq.com boy boy d boydd \N 948547440@qq.com success \N plain 1 2026-06-03 04:41:40+00 \N
7467808818831725568 761907552@qq.com 你是谁啊 你是谁啊 你是谁啊 激活ing \N success \N plain 1 2026-06-03 05:26:07+00 \N
\.
--
-- Data for Name: sys_mail_template; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_mail_template (id, name, code, subject, text_content, html_content, description, status, created_at, updated_at) FROM stdin;
7468353094338647040 注册验证 001 自助验证 {{name}} 欢迎 {{name}}, 您现在可以登录了。\n 使用以下链接验证您的帐户：\n\n{{host}}/api/sys/verify/{{verifyToken}} <html>\n\n<body>\n Dear {{name}},\n 欢迎使用Rust祺洛系统! 您现在可以登录到您的帐户。\n 开始之前，请单击下面的链接验证您的帐户:\n <a href="{{host}}/api/sys/verify/{{verifyToken}}">\n 验证您的帐户\n </a>\n <p>Best regards,<br>Rust祺洛</p>\n</body>\n\n</html> \N 1 2026-06-04 17:28:52+00 2026-06-04 17:28:52+00
\.
--
-- Data for Name: sys_menu; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_menu (id, name, title, i18nkey, pid, "order", path, component, redirect, href, no_cache, menu_type, hidden, active_menu, always_show, breadcrumb, affix, no_tags_view, can_to, status, perms, icon, created_at, updated_at, remark, deleted_at) FROM stdin;
1 Dashboard 首页 \N 0 0 /dashboard # /dashboard/analysis 0 M 0 0 0 1 0 1 1 0 \N vi-ant-design:dashboard-filled \N \N \N
2 Analysis 分析页 \N 1 1 analysis views/Dashboard/Analysis \N 0 C 0 0 0 1 0 1 1 0 \N vi-ant-design:dashboard-filled \N 2024-08-23 22:51:09+00 \N \N
3 Workplace 工作台 \N 1 2 workplace views/Dashboard/Workplace \N 0 C 0 0 0 1 0 1 1 0 \N vi-ant-design:codepen-outlined \N 2024-08-23 22:50:07+00 \N \N
4 Authorization 系统管理 \N 0 2 /authorization # \N 0 M 0 0 0 1 0 1 1 0 \N vi-ant-design:dashboard-filled \N \N \N
5 Department 部门管理 \N 4 5 department views/Authorization/Department/Department \N 0 C 0 0 0 1 0 1 1 0 \N vi-ant-design:dashboard-filled \N 2024-08-11 05:31:40+00 \N \N
6 User 用户管理 \N 4 2 user views/Authorization/User/User \N 0 C 0 0 0 1 0 1 1 0 \N vi-ant-design:dashboard-filled \N \N \N
7 Menu 菜单管理 \N 4 2 menu views/Authorization/Menu/Menu \N 0 C 0 0 0 1 0 0 1 0 \N vi-ant-design:dashboard-filled \N 2024-08-08 00:50:11+00 \N \N
8 Role 角色管理 \N 4 2 role views/Authorization/Role/Role \N 0 C 0 0 0 1 0 1 1 0 \N vi-ant-design:dashboard-filled \N \N \N
7224471859710005249 Monitor 系统监控 \N 0 5 /motion # \N \N 0 M 0 0 0 1 0 1 1 0 \N vi-tdesign:archway \N 2024-10-25 00:42:23+00 \N \N
7225437966700777473 SystemLog 操作日志 \N 7224471859710005249 4 systemlog views/Monitor/SystemLog/SystemLog \N \N 0 C 0 0 0 1 0 0 0 0 \N vi-tdesign:angry \N 2024-08-28 01:49:53+00 \N \N
7225439414641627136 LoginInfo 登陆日志 \N 7224471859710005249 2 logininfo views/Monitor/LoginInfo/LoginInfo \N \N 0 C 0 0 0 1 0 0 0 0 \N vi-tdesign:app \N 2024-08-25 00:53:36+00 \N \N
7226994818660044800 UserOnline 在线用户 \N 7224471859710005249 0 useronline views/Monitor/UserOnline/UserOnline \N 0 C 0 0 0 1 0 1 1 0 \N vi-ep:bell-filled 2024-08-08 00:57:16+00 2024-10-24 01:28:11+00 \N \N
7227715297679118337 Job 定时任务 \N 7224471859710005249 0 job views/Monitor/Job/Job \N 0 C 0 0 0 0 0 0 0 0 \N vi-ep:apple 2024-08-10 00:40:11+00 2024-08-10 00:40:11+00 \N \N
7228150987080470529 DictData 字典数据 \N 4 100 dictdata views/Authorization/DictData/DictData \N 0 C 1 0 0 0 0 1 0 0 \N vi-ant-design:aliwangwang-outlined 2024-08-11 05:31:28+00 2024-10-25 23:18:20+00 \N \N
7228186533035118593 DictType 字典管理 \N 4 7 dicttype views/Authorization/DictType/DictType \N 0 C 0 0 0 0 0 0 0 0 \N vi-ant-design:alert-filled 2024-08-11 07:52:43+00 2024-10-25 23:18:11+00 \N \N
7228454585970593792 ServerInfo 服务监控 \N 7224471859710005249 4 serverinfo views/Monitor/ServerInfo/ServerInfo \N 1 C 0 0 0 0 0 0 0 0 \N vi-ant-design:fund-projection-screen-outlined 2024-08-12 01:37:51+00 2024-08-25 00:54:16+00 \N \N
7230621134038896640 JobLog 定时日志 \N 7224471859710005249 0 joblog views/Monitor/JobLog/JobLog \N 1 C 1 0 0 0 0 0 0 0 \N vi-ep:baseball 2024-08-18 01:06:57+00 2024-09-01 00:09:39+00 \N \N
7230940389695426560 ApiPermission 权限查询 \N 4 7 apipermission views/Authorization/ApiPermission/ApiPermission \N 0 C 0 0 0 0 0 0 0 0 \N vi-ep:burger 2024-08-18 22:15:33+00 2024-08-24 01:22:22+00 \N \N
7231673632416502784 RoleApi 角色API \N 4 1 roleapi views/Authorization/RoleApi/RoleApi \N 0 C 1 0 0 0 0 0 0 0 \N vi-ep:basketball 2024-08-20 22:49:12+00 2024-10-24 01:32:15+00 \N \N
7234621748841190400 Cache 缓存管理 \N 7224471859710005249 1 cache views/Monitor/Cache/Cache \N 0 C 0 0 0 0 0 0 0 0 \N vi-ep:bicycle 2024-08-29 02:03:58+00 2024-08-29 02:03:58+00 \N \N
7402695499167208448 \N 测试 \N 0 15 /test # \N 0 M 0 0 0 0 0 0 0 0 \N vi-tdesign:application 2025-12-05 21:09:02+00 2025-12-05 21:09:02+00 \N \N
7402702074216879104 TestDataScope 测试数据 \N 7402695499167208448 2 test/TestDataScope views/Test/TestDataScope/TestDataScope \N 0 C 0 0 0 0 0 0 0 0 \N vi-tdesign:animation-1 2025-12-05 21:35:10+00 2026-06-02 21:38:42+00 \N \N
7461092148004164608 \N 工具 \N 0 25 /tools # \N 0 M 0 0 0 0 0 0 0 0 \N vi-tdesign:tools 2026-05-16 00:36:28+00 2026-05-16 00:37:00+00 \N \N
7461092495128957952 \N 代码生成 \N 7461092148004164608 1 tools/CodeGen views/Tool/CodeGen/CodeGen \N 0 C 0 0 0 0 0 0 0 0 \N \N 2026-05-16 00:37:51+00 2026-05-16 00:38:09+00 \N \N
7461476724811666432 \N 测试分类 \N 7402695499167208448 5 test/TestCategory views/Test/TestCategory/TestCategory \N 0 C 0 0 0 0 0 0 0 0 \N vi-tdesign:certificate-1 2026-05-17 02:04:39+00 2026-05-17 02:05:07+00 \N \N
7462558764051108864 \N 测试文章 \N 7402695499167208448 10 test/TestArticle views/Test/TestArticle/TestArticle \N 0 C 0 0 0 0 0 0 0 0 \N vi-tdesign:article 2026-05-20 01:44:17+00 2026-05-20 01:44:17+00 \N \N
7467279900517241856 \N 微信 \N 0 6 /wechat # \N 0 M 0 0 0 0 0 0 0 0 \N vi-tdesign:logo-wechat-stroke 2026-06-02 02:24:24+00 2026-06-02 02:24:36+00 \N \N
7467280164657730560 \N 公众号 \N 7467279900517241856 1 wechat/wechataccounts views/wechat/wechataccounts/wxaccounts \N 0 C 0 0 0 0 0 0 0 0 \N vi-tdesign:chat-message 2026-06-02 02:25:27+00 2026-06-02 02:26:15+00 \N \N
7467286094099158016 \N 微信用户 \N 7467279900517241856 5 wechat/wxusers views/wechat/wxusers/wxusers \N 0 C 0 0 0 0 0 0 0 0 \N vi-tdesign:usergroup-add 2026-06-02 02:49:00+00 2026-06-05 01:57:36+00 \N \N
7467286364820509696 \N 微信消息 \N 7467279900517241856 7 wechat/wxmessages views/wechat/wxmessages/wxmessages \N 0 C 0 0 0 0 0 0 0 0 \N vi-ant-design:message-outlined 2026-06-02 02:50:05+00 2026-06-02 02:50:27+00 \N \N
7467288062007874560 \N 微信菜单 \N 7467279900517241856 3 wechat/wxmenus views/wechat/wxmenus/wxmenus \N 0 C 0 0 0 0 0 0 0 0 \N vi-ant-design:menu-outlined 2026-06-02 02:56:49+00 2026-06-05 01:57:51+00 \N \N
7467447239728600064 \N 自动回复 \N 7467279900517241856 4 wechat/wxautoreplies views/wechat/wxautoreplies/wxautoreplies \N 0 C 0 0 0 0 0 0 0 0 \N vi-ant-design:message-twotone 2026-06-02 13:29:20+00 2026-06-05 01:57:44+00 \N \N
7467568513482134528 \N 素材管理 \N 7467279900517241856 15 wechat/wxmaterials views/wechat/wxmaterials/wxmaterials \N 0 C 0 0 0 0 0 0 0 0 \N vi-tdesign:animation 2026-06-02 21:31:14+00 2026-06-02 21:31:30+00 \N \N
7467597219751695360 \N 邮件模板 \N 7224471859710005249 1 monitor/Email views/Monitor/Email/Email \N 0 C 0 0 0 0 0 0 0 0 \N vi-ep:chat-line-round 2026-06-02 23:25:18+00 2026-06-02 23:26:12+00 \N \N
\.
--
-- Data for Name: sys_notice; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_notice (notice_id, notice_title, notice_type, notice_content, status, create_dept, create_by, created_at, update_by, updated_at, remark) FROM stdin;
1 温馨提醒：2018-07-01 新版本发布啦 2 \\xe696b0e78988e69cace58685e5aeb9 0 103 1 2024-07-03 01:17:33+00 \N \N 管理员
2 维护通知：2018-07-01 系统凌晨维护 1 \\xe7bbb4e68aa4e58685e5aeb9 0 103 1 2024-07-03 01:17:33+00 \N \N 管理员
\.
--
-- Data for Name: sys_oper_log; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_oper_log (oper_id, api_name, method, request_method, oper_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time, cost_time) FROM stdin;
\.
--
-- Data for Name: sys_post; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_post (post_id, dept_id, post_code, post_category, post_name, post_sort, status, create_dept, created_at, updated_at, remark) FROM stdin;
1 103 ceo \N 董事长 1 0 103 2024-07-03 01:17:32+00 \N
2 100 se \N 项目经理 2 0 103 2024-07-03 01:17:32+00 \N
3 100 hr \N 人力资源 3 0 103 2024-07-03 01:17:32+00 \N
4 100 user \N 普通员工 4 0 103 2024-07-03 01:17:32+00 \N
\.
--
-- Data for Name: sys_role; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_role (role_id, role_name, role_key, "order", data_scope, status, create_dept, remark, created_at, updated_at, deleted_at) FROM stdin;
1 管理员 admin 2 1 0 103 超级管理员 2024-07-03 01:17:32+00 \N \N
3 本部门及以下 test1 5 4 0 103 部门数据以及部门以下的数据 2024-07-03 01:17:32+00 \N \N
4 本人的数据权限 self 6 5 0 103 本人数据 2024-07-03 01:17:32+00 \N \N
7222985345490620417 自定义数据权限 self 7 2 0 \N 自定义数据权限 \N \N \N
7403403929607640064 本部门权限 Dept 5 3 0 \N 本部门数据 \N \N \N
\.
--
-- Data for Name: sys_role_api; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_role_api (id, role_id, api_id, api, method, apiname, sort) FROM stdin;
7402715253093340160 7222985345490620417 7232752187397280768 /sys/job/add Post 添加定时任务 1
7402715253202392064 7222985345490620417 7232752187535692800 /sys/job/validate_cron Post 验证cron表达式 2
7402715253261112320 7222985345490620417 7232752187606995968 /sys/job/list Get 获取定时任务列表 3
7402715253307249664 7222985345490620417 7232752187674104832 /sys/job/edit Put 编辑定时任务 4
7402715253361775616 7222985345490620417 7232752187741213696 /sys/job/del Delete 删除定时任务 5
7402715253412107264 7222985345490620417 7232752187812516864 /sys/roleapi/add_many_role_api_transfer Get 添加多个角色api 6
7402715253462438912 7222985345490620417 7232752187879625728 /sys/roleapi/del Delete 删除角色api 7
7402715253512770560 7222985345490620417 7232752187946734592 /sys/roleapi/role_api_transfer_list Get 获取角色api所有的选择列表 8
7402715253558907904 7222985345490620417 7232752188013843456 /sys/roleapi/list Get 获取角色api列表 9
7402715253609239552 7222985345490620417 7232752188085146624 /sys/roleapi/edit Put 编辑角色api 10
7402715253655376896 7222985345490620417 7232752188156449792 /sys/roleapi/role_permission_list Get 根据角色id获取api权限列表 11
7402715253705708544 7222985345490620417 7232752188219364352 /sys/roleapi/add Post 添加角色api 12
7402715253751845888 7222985345490620417 7235633673968456704 /sys/role/get_role_depts Get 获取角色部门 13
7402715253802177536 7222985345490620417 7232752188282278912 /sys/dicttype/list Get 获取字典类型列表 14
7402715253856703488 7222985345490620417 7252729164858299392 /sys/role/user_role_name_list Get 获取用户拥有的角色名称列表 15
7402715253898646528 7222985345490620417 7232752188349387776 /sys/dicttype/add Post 添加字典类型 16
7402715253957366784 7222985345490620417 7232752188412302336 /sys/dicttype/del Delete 删除字典类型 17
7402715254011892736 7222985345490620417 7232752188479411200 /sys/dicttype/edit Put 编辑字典类型 18
7402715254053835776 7222985345490620417 7232752188546520064 /sys/menu/edit Put 编辑菜单 19
7402715254112556032 7222985345490620417 7234616780964926464 /sys/cache/clear Post 清空缓存 20
7402715254162887680 7222985345490620417 7232752188617823232 /sys/menu/list Get 菜单列表 21
7402715254234190848 7222985345490620417 7234616781027841024 /sys/cache/list Get 获取缓存列表 22
7402715254288716800 7222985345490620417 7232752188697515008 /sys/menu/add Post 添加菜单 23
7402715254339048448 7222985345490620417 7232752188764623872 /sys/menu/del Delete 删除菜单 24
7402715254376797184 7222985345490620417 7232752188835927040 /sys/menu/all_router Get 全部路由 25
7402715254422934528 7222985345490620417 7232752188898841600 /sys/menu/tree Get 获取菜单树 26
7402715254469071872 7222985345490620417 7232752188965950464 /sys/serverinfo/server_update Get 更新服务器信息 27
7402715254515209216 7222985345490620417 7232752189028865024 /sys/jobinfo/add Post 添加定时任务日志 28
7402715254565540864 7222985345490620417 7232794958103483392 /sys/dashboard/analysis/weeklyUserActivity Get 获取仪表盘数据 29
7402715254620066816 7222985345490620417 7232752189095973888 /sys/jobinfo/list Get 获取定时任务日志列表 30
7402715254674592768 7222985345490620417 7232794958170592256 /sys/dashboard/analysis/total Get 获取仪表盘数据 31
7402715254729118720 7222985345490620417 7232781502121939968 /sys/user/delusers Delete 删除用户 32
7402715254771061760 7222985345490620417 7232752189158888448 /sys/dictdata/get_by_type Get 根据类型获取字典数据 33
7402715254821393408 7222985345490620417 7232794958229312512 /sys/dashboard/analysis/monthlySales Get 获取仪表盘数据 34
7402715254863336448 7222985345490620417 7232794958279644160 /sys/dashboard/analysis/userAccessSource Get 获取仪表盘数据 35
7402715254909473792 7222985345490620417 7232752189221803008 /sys/dictdata/list Get 获取字典数据列表 36
7402715254959805440 7222985345490620417 7232752189280523264 /sys/dictdata/del Delete 删除字典数据 37
7402715255005942784 7222985345490620417 7232794958317392896 /sys/dashboard/workplace/dynamic Get 获取仪表盘数据 38
7402715255056274432 7222985345490620417 7232794958363530240 /sys/dashboard/workplace/total Get 获取仪表盘数据 39
7402715255102411776 7222985345490620417 7232752189347632128 /sys/dictdata/edit Put 编辑字典数据 40
7402715255148549120 7222985345490620417 7232752189410546688 /sys/dictdata/add Post 添加字典数据 41
7402715255207269376 7222985345490620417 7232794958401278976 /sys/dashboard/workplace/radar Get 获取仪表盘数据 42
7402715255261795328 7222985345490620417 7232794958447416320 /sys/dashboard/workplace/project Get 获取仪表盘数据 43
7402715255307932672 7222985345490620417 7232752189473461248 /sys/dashboard/add Post 添加仪表盘 44
7402715255354070016 7222985345490620417 7232794958493553664 /sys/dashboard/workplace/team Get 获取仪表盘数据 45
7402715255396013056 7222985345490620417 7232752189557347328 /sys/dashboard/list Get 获取仪表盘列表 46
7402715255450539008 7222985345490620417 7232752189628650496 /sys/role/list Get 获取角色列表 47
7402715255496676352 7222985345490620417 7232752189691565056 /sys/role/get_role_menus Get 获取角色菜单 48
7402715255542813696 7222985345490620417 7232752189758673920 /sys/role/menu Get 获取角色菜单 49
7402715255597339648 7222985345490620417 7236784152022782976 /sys/user/fresh_token Put 刷新token 50
7402715255643476992 7222985345490620417 7232752189821588480 /sys/role/edit Put 编辑角色 51
7402715255685420032 7222985345490620417 7232752189888697344 /sys/role/tree Get 获取角色树 52
7402715255727363072 7222985345490620417 7232752189951611904 /sys/role/add Post 添加角色 53
7402715255773500416 7222985345490620417 7236784153973134336 /sys/user/update_avatar Put 更新头像 54
7402715255819637760 7222985345490620417 7232752190018720768 /sys/role/del Delete 删除角色 55
7402715255861580800 7222985345490620417 7232752190081635328 /sys/apipermission/list Get 获取api权限列表 56
7402715255903523840 7222985345490620417 7232752190144549888 /sys/user/reset_password Put 重置密码 57
7402715255949661184 7222985345490620417 7232752190207464448 /sys/user/userinfo Get 获取用户信息 58
7402715255991604224 7222985345490620417 7232752190270379008 /sys/user/depts_roles Get 获取用户拥有的用户部门和用户角色 59
7402715256029352960 7222985345490620417 7232752190333293568 /sys/user/del Delete 删除用户 60
7402715256075490304 7222985345490620417 7252738573697192960 /sys/dept/user_dept_name_list Get 获取用户拥有的部门名称列表 61
7402715256113239040 7222985345490620417 7232752190396208128 /sys/user/list Get 获取用户列表 62
7402715256159376384 7222985345490620417 7232752190459122688 /sys/user/add Post 添加用户 63
7402715256205513728 7222985345490620417 7232752190526231552 /sys/user/change_password Put 修改密码 64
7402715256289399808 7222985345490620417 7234570580194661376 /sys/useronline/del Delete 退出在线用户 65
7402715256339731456 7222985345490620417 7232752190589146112 /sys/user/edit Put 编辑用户 66
7402715256385868800 7222985345490620417 7232752190656254976 /sys/dept/edit Put 编辑部门 67
7402715256427811840 7222985345490620417 7232752190727558144 /sys/dept/add Post 添加部门 68
7402715256473949184 7222985345490620417 7232752190794667008 /sys/dept/list Get 获取部门列表 69
7402715256515892224 7222985345490620417 7234253747373642752 /sys/operationlog/list Get 获取操作日志列表 70
7402715256578806784 7222985345490620417 7232752190861775872 /sys/dept/del Delete 删除部门 71
7402715256629138432 7222985345490620417 7232752190933079040 /sys/dept/dept_tree Get 获取部门树 72
7402715256687858688 7222985345490620417 7232752190995993600 /sys/useronline/list Get 获取在线用户列表 73
7402715256733996032 7222985345490620417 7232752191063102464 /sys/logininfo/list Get 获取登录日志列表 74
7402715256784327680 7222985345490620417 7253067149336286208 /sys/user/update_role_or_dept Post 更新用户拥有的用户部门和用户角色 75
7402715256834659328 7222985345490620417 7233868069737501696 /sys/apipermission/edit Put 编辑api权限 76
7402715256884990976 7222985345490620417 7241490807281062912 /sys/user/login_out Get 用户退出 77
7402715256931128320 7222985345490620417 7240020747752477696 /sys/user/refersh_token Put 刷新token 78
7402715256968877056 7222985345490620417 7235678367742071808 /sys/job/hand_execute_job Post 执行定时任务 79
7402715257023403008 7222985345490620417 7385368752226735104 /test/test_api/list Get 获取列表 80
7402715257073734656 7222985345490620417 7385368752235123712 /test/test_api/del Delete 删除TestApi 81
7402715257119872000 7222985345490620417 7401293722618336256 /test/test_api/db_read_write_test Put db_read_write_test 82
7402715257174397952 7222985345490620417 7348333842530210816 /wechat/wxaccounts/del Delete 删除WxAccounts 83
7402715257212146688 7222985345490620417 7385368752239318016 /test/test_api/add Post 添加TestApi 84
7402715257262478336 7222985345490620417 7401293722630919168 /test/test_api/db_name_test Put db_name_test 85
7402715257308615680 7222985345490620417 7348333842559570944 /wechat/wxaccounts/edit Put 编辑WxAccounts 86
7402715257354753024 7222985345490620417 7348333842567959552 /wechat/wxaccounts/list Get 获取WxAccounts列表 87
7402715257400890368 7222985345490620417 7385368752243512320 /test/test_api/edit Put 编辑TestApi 88
7402715257451222016 7222985345490620417 7348333842572153856 /wechat/wxaccounts/add Post 添加WxAccounts 89
7402715257497359360 7222985345490620417 7348333842584736768 /wechat/wxautoreplies/add Post 添加WxAutoReplies 90
7402715257547691008 7222985345490620417 7401293722647696384 /test/test_api/db_index_test Put db_index_test 91
7402715257589634048 7222985345490620417 7348333842609902592 /wechat/wxautoreplies/del Delete 删除WxAutoReplies 92
7402715257644160000 7222985345490620417 7348333842635068416 /wechat/wxautoreplies/list Get 获取WxAutoReplies列表 93
7402715257698685952 7222985345490620417 7401293722651890688 /test/test_api/db_auto_test Put db_auto_test 94
7402715257749017600 7222985345490620417 7348333843008361472 /wechat/wxautoreplies/edit Put 编辑WxAutoReplies 95
7402715257790960640 7222985345490620417 7402694868939478016 /test/test_data_scope/del Delete Delete 96
7402715257832903680 7222985345490620417 7402694868947866624 /test/test_data_scope/list Get list 97
7402715257883235328 7222985345490620417 7348333843016750080 /wechat/wxmenus/list Get 获取WxMenus列表 98
7402715257929372672 7222985345490620417 7348333843071276032 /wechat/wxmenus/del Delete 删除WxMenus 99
7402715257975510016 7222985345490620417 7402694868947866625 /test/test_data_scope/add Post add 100
7402715258034230272 7222985345490620417 7402694868952060928 /test/test_data_scope/edit Put edit 101
7402715258088756224 7222985345490620417 7348333843075470336 /wechat/wxmenus/pull_menu Get 创建自定义菜单 102
7402715258134893568 7222985345490620417 7348333843092247552 /wechat/wxmenus/add Post 添加WxMenus 103
7402715258185225216 7222985345490620417 7348333843100636160 /wechat/wxmenus/edit Put 编辑WxMenus 104
7402715258231362560 7222985345490620417 7348333843104830464 /wechat/wxmessages/list Get 获取WxMessages列表 105
7402715258281694208 7222985345490620417 7348333843125801984 /wechat/wxmessages/edit Put 编辑WxMessages 106
7402715258332025856 7222985345490620417 7348333843138384896 /wechat/wxmessages/del Delete 删除WxMessages 107
7402715258403329024 7222985345490620417 7348333843150967808 /wechat/wxmessages/add Post 添加WxMessages 108
7402715258453660672 7222985345490620417 7348333843159356416 /wechat/wxusers/add Post 添加WxUsers 109
7402715258495603712 7222985345490620417 7348333843167745024 /wechat/wxusers/edit Put 编辑WxUsers 110
7402715258545935360 7222985345490620417 7348333843180327936 /wechat/wxusers/del Delete 删除WxUsers 111
7402715258587878400 7222985345490620417 7348333843184522240 /wechat/wxusers/list Get 获取WxUsers列表 112
7402715541250413568 4 7232752187397280768 /sys/job/add Post 添加定时任务 1
7402715541346882560 4 7232752187535692800 /sys/job/validate_cron Post 验证cron表达式 2
7402715541397214208 4 7232752187606995968 /sys/job/list Get 获取定时任务列表 3
7402715541430768640 4 7232752187674104832 /sys/job/edit Put 编辑定时任务 4
7402715541489488896 4 7232752187741213696 /sys/job/del Delete 删除定时任务 5
7402715541539820544 4 7232752187812516864 /sys/roleapi/add_many_role_api_transfer Get 添加多个角色api 6
7402715541585957888 4 7232752187879625728 /sys/roleapi/del Delete 删除角色api 7
7402715541636289536 4 7232752187946734592 /sys/roleapi/role_api_transfer_list Get 获取角色api所有的选择列表 8
7402715541690815488 4 7232752188013843456 /sys/roleapi/list Get 获取角色api列表 9
7402715541736952832 4 7232752188085146624 /sys/roleapi/edit Put 编辑角色api 10
7402715541787284480 4 7232752188156449792 /sys/roleapi/role_permission_list Get 根据角色id获取api权限列表 11
7402715541846004736 4 7232752188219364352 /sys/roleapi/add Post 添加角色api 12
7402715541896336384 4 7235633673968456704 /sys/role/get_role_depts Get 获取角色部门 13
7402715541946668032 4 7232752188282278912 /sys/dicttype/list Get 获取字典类型列表 14
7402715541992805376 4 7252729164858299392 /sys/role/user_role_name_list Get 获取用户拥有的角色名称列表 15
7402715542047331328 4 7232752188349387776 /sys/dicttype/add Post 添加字典类型 16
7402715542097662976 4 7232752188412302336 /sys/dicttype/del Delete 删除字典类型 17
7402715542152188928 4 7232752188479411200 /sys/dicttype/edit Put 编辑字典类型 18
7402715542210909184 4 7232752188546520064 /sys/menu/edit Put 编辑菜单 19
7402715542261240832 4 7234616780964926464 /sys/cache/clear Post 清空缓存 20
7402715542307378176 4 7232752188617823232 /sys/menu/list Get 菜单列表 21
7402715542361904128 4 7234616781027841024 /sys/cache/list Get 获取缓存列表 22
7402715542420624384 4 7232752188697515008 /sys/menu/add Post 添加菜单 23
7402715542466761728 4 7232752188764623872 /sys/menu/del Delete 删除菜单 24
7402715542508704768 4 7232752188835927040 /sys/menu/all_router Get 全部路由 25
7402715542554842112 4 7232752188898841600 /sys/menu/tree Get 获取菜单树 26
7402715542605173760 4 7232752188965950464 /sys/serverinfo/server_update Get 更新服务器信息 27
7402715542663894016 4 7232752189028865024 /sys/jobinfo/add Post 添加定时任务日志 28
7402715542697448448 4 7232794958103483392 /sys/dashboard/analysis/weeklyUserActivity Get 获取仪表盘数据 29
7402715542743585792 4 7232752189095973888 /sys/jobinfo/list Get 获取定时任务日志列表 30
7402715542781334528 4 7232794958170592256 /sys/dashboard/analysis/total Get 获取仪表盘数据 31
7402715542827471872 4 7232781502121939968 /sys/user/delusers Delete 删除用户 32
7402715542894580736 4 7232752189158888448 /sys/dictdata/get_by_type Get 根据类型获取字典数据 33
7402715542940718080 4 7232794958229312512 /sys/dashboard/analysis/monthlySales Get 获取仪表盘数据 34
7402715542991049728 4 7232794958279644160 /sys/dashboard/analysis/userAccessSource Get 获取仪表盘数据 35
7402715543041381376 4 7232752189221803008 /sys/dictdata/list Get 获取字典数据列表 36
7402715543100101632 4 7232752189280523264 /sys/dictdata/del Delete 删除字典数据 37
7402715543150433280 4 7232794958317392896 /sys/dashboard/workplace/dynamic Get 获取仪表盘数据 38
7402715543221736448 4 7232794958363530240 /sys/dashboard/workplace/total Get 获取仪表盘数据 39
7402715543280456704 4 7232752189347632128 /sys/dictdata/edit Put 编辑字典数据 40
7402715543330788352 4 7232752189410546688 /sys/dictdata/add Post 添加字典数据 41
7402715543389508608 4 7232794958401278976 /sys/dashboard/workplace/radar Get 获取仪表盘数据 42
7402715543444034560 4 7232794958447416320 /sys/dashboard/workplace/project Get 获取仪表盘数据 43
7402715543485977600 4 7232752189473461248 /sys/dashboard/add Post 添加仪表盘 44
7402715543548892160 4 7232794958493553664 /sys/dashboard/workplace/team Get 获取仪表盘数据 45
7402715543603418112 4 7232752189557347328 /sys/dashboard/list Get 获取仪表盘列表 46
7402715543666332672 4 7232752189628650496 /sys/role/list Get 获取角色列表 47
7402715543720858624 4 7232752189691565056 /sys/role/get_role_menus Get 获取角色菜单 48
7402715543787967488 4 7232752189758673920 /sys/role/menu Get 获取角色菜单 49
7402715543842493440 4 7236784152022782976 /sys/user/fresh_token Put 刷新token 50
7402715543897019392 4 7232752189821588480 /sys/role/edit Put 编辑角色 51
7402715543955739648 4 7232752189888697344 /sys/role/tree Get 获取角色树 52
7402715544006071296 4 7232752189951611904 /sys/role/add Post 添加角色 53
7402715544052208640 4 7236784153973134336 /sys/user/update_avatar Put 更新头像 54
7402715544106734592 4 7232752190018720768 /sys/role/del Delete 删除角色 55
7402715544157066240 4 7232752190081635328 /sys/apipermission/list Get 获取api权限列表 56
7402715544215786496 4 7232752190144549888 /sys/user/reset_password Put 重置密码 57
7402715544261923840 4 7232752190207464448 /sys/user/userinfo Get 获取用户信息 58
7402715544303866880 4 7232752190270379008 /sys/user/depts_roles Get 获取用户拥有的用户部门和用户角色 59
7402715544350004224 4 7232752190333293568 /sys/user/del Delete 删除用户 60
7402715544387752960 4 7252738573697192960 /sys/dept/user_dept_name_list Get 获取用户拥有的部门名称列表 61
7402715544433890304 4 7232752190396208128 /sys/user/list Get 获取用户列表 62
7402715544480027648 4 7232752190459122688 /sys/user/add Post 添加用户 63
7402715544534553600 4 7232752190526231552 /sys/user/change_password Put 修改密码 64
7402715544576496640 4 7234570580194661376 /sys/useronline/del Delete 退出在线用户 65
7402715544626828288 4 7232752190589146112 /sys/user/edit Put 编辑用户 66
7402715544677159936 4 7232752190656254976 /sys/dept/edit Put 编辑部门 67
7402715544727491584 4 7232752190727558144 /sys/dept/add Post 添加部门 68
7402715544782017536 4 7232752190794667008 /sys/dept/list Get 获取部门列表 69
7402715544828154880 4 7234253747373642752 /sys/operationlog/list Get 获取操作日志列表 70
7402715544870097920 4 7232752190861775872 /sys/dept/del Delete 删除部门 71
7402715544907846656 4 7232752190933079040 /sys/dept/dept_tree Get 获取部门树 72
7402715544958178304 4 7232752190995993600 /sys/useronline/list Get 获取在线用户列表 73
7402715545000121344 4 7232752191063102464 /sys/logininfo/list Get 获取登录日志列表 74
7402715545054647296 4 7253067149336286208 /sys/user/update_role_or_dept Post 更新用户拥有的用户部门和用户角色 75
7402715545109173248 4 7233868069737501696 /sys/apipermission/edit Put 编辑api权限 76
7402715545159504896 4 7241490807281062912 /sys/user/login_out Get 用户退出 77
7402715545205642240 4 7240020747752477696 /sys/user/refersh_token Put 刷新token 78
7402715545268556800 4 7235678367742071808 /sys/job/hand_execute_job Post 执行定时任务 79
7402715545323082752 4 7385368752226735104 /test/test_api/list Get 获取列表 80
7402715545373414400 4 7385368752235123712 /test/test_api/del Delete 删除TestApi 81
7402715545444717568 4 7401293722618336256 /test/test_api/db_read_write_test Put db_read_write_test 82
7402715545495049216 4 7348333842530210816 /wechat/wxaccounts/del Delete 删除WxAccounts 83
7402715545549575168 4 7385368752239318016 /test/test_api/add Post 添加TestApi 84
7402715545599906816 4 7401293722630919168 /test/test_api/db_name_test Put db_name_test 85
7402715545650238464 4 7348333842559570944 /wechat/wxaccounts/edit Put 编辑WxAccounts 86
7402715545704764416 4 7348333842567959552 /wechat/wxaccounts/list Get 获取WxAccounts列表 87
7402715545755096064 4 7385368752243512320 /test/test_api/edit Put 编辑TestApi 88
7402715545801233408 4 7348333842572153856 /wechat/wxaccounts/add Post 添加WxAccounts 89
7402715545847370752 4 7348333842584736768 /wechat/wxautoreplies/add Post 添加WxAutoReplies 90
7402715545893508096 4 7401293722647696384 /test/test_api/db_index_test Put db_index_test 91
7402715545939645440 4 7348333842609902592 /wechat/wxautoreplies/del Delete 删除WxAutoReplies 92
7402715545989977088 4 7348333842635068416 /wechat/wxautoreplies/list Get 获取WxAutoReplies列表 93
7402715546031920128 4 7401293722651890688 /test/test_api/db_auto_test Put db_auto_test 94
7402715546086446080 4 7348333843008361472 /wechat/wxautoreplies/edit Put 编辑WxAutoReplies 95
7402715546136777728 4 7402694868939478016 /test/test_data_scope/del Delete Delete 96
7402715546182915072 4 7402694868947866624 /test/test_data_scope/list Get list 97
7402715546233246720 4 7348333843016750080 /wechat/wxmenus/list Get 获取WxMenus列表 98
7402715546283578368 4 7348333843071276032 /wechat/wxmenus/del Delete 删除WxMenus 99
7402715546329715712 4 7402694868947866625 /test/test_data_scope/add Post add 100
7402715546384241664 4 7402694868952060928 /test/test_data_scope/edit Put edit 101
7402715546426184704 4 7348333843075470336 /wechat/wxmenus/pull_menu Get 创建自定义菜单 102
7402715546484904960 4 7348333843092247552 /wechat/wxmenus/add Post 添加WxMenus 103
7402715546535236608 4 7348333843100636160 /wechat/wxmenus/edit Put 编辑WxMenus 104
7402715546585568256 4 7348333843104830464 /wechat/wxmessages/list Get 获取WxMessages列表 105
7402715546635899904 4 7348333843125801984 /wechat/wxmessages/edit Put 编辑WxMessages 106
7402715546690425856 4 7348333843138384896 /wechat/wxmessages/del Delete 删除WxMessages 107
7402715546740757504 4 7348333843150967808 /wechat/wxmessages/add Post 添加WxMessages 108
7402715546791089152 4 7348333843159356416 /wechat/wxusers/add Post 添加WxUsers 109
7402715546841420800 4 7348333843167745024 /wechat/wxusers/edit Put 编辑WxUsers 110
7402715546900141056 4 7348333843180327936 /wechat/wxusers/del Delete 删除WxUsers 111
7402715546954667008 4 7348333843184522240 /wechat/wxusers/list Get 获取WxUsers列表 112
7402728415402300416 3 7232752187397280768 /sys/job/add Post 添加定时任务 1
7402728415490380800 3 7232752187535692800 /sys/job/validate_cron Post 验证cron表达式 2
7402728415574266880 3 7232752187606995968 /sys/job/list Get 获取定时任务列表 3
7402728415649764352 3 7232752187674104832 /sys/job/edit Put 编辑定时任务 4
7402728415712678912 3 7232752187741213696 /sys/job/del Delete 删除定时任务 5
7402728415758816256 3 7232752187812516864 /sys/roleapi/add_many_role_api_transfer Get 添加多个角色api 6
7402728415825925120 3 7232752187879625728 /sys/roleapi/del Delete 删除角色api 7
7402728415893033984 3 7232752187946734592 /sys/roleapi/role_api_transfer_list Get 获取角色api所有的选择列表 8
7402728415955948544 3 7232752188013843456 /sys/roleapi/list Get 获取角色api列表 9
7402728416023057408 3 7232752188085146624 /sys/roleapi/edit Put 编辑角色api 10
7402728416077583360 3 7232752188156449792 /sys/roleapi/role_permission_list Get 根据角色id获取api权限列表 11
7402728416123720704 3 7232752188219364352 /sys/roleapi/add Post 添加角色api 12
7402728416174052352 3 7235633673968456704 /sys/role/get_role_depts Get 获取角色部门 13
7402728416228578304 3 7232752188282278912 /sys/dicttype/list Get 获取字典类型列表 14
7402728416283104256 3 7252729164858299392 /sys/role/user_role_name_list Get 获取用户拥有的角色名称列表 15
7402728416333435904 3 7232752188349387776 /sys/dicttype/add Post 添加字典类型 16
7402728416379573248 3 7232752188412302336 /sys/dicttype/del Delete 删除字典类型 17
7402728416429904896 3 7232752188479411200 /sys/dicttype/edit Put 编辑字典类型 18
7402728416480236544 3 7232752188546520064 /sys/menu/edit Put 编辑菜单 19
7402728416530568192 3 7234616780964926464 /sys/cache/clear Post 清空缓存 20
7402728416580899840 3 7232752188617823232 /sys/menu/list Get 菜单列表 21
7402728416631231488 3 7234616781027841024 /sys/cache/list Get 获取缓存列表 22
7402728416681563136 3 7232752188697515008 /sys/menu/add Post 添加菜单 23
7402728416731894784 3 7232752188764623872 /sys/menu/del Delete 删除菜单 24
7402728416773837824 3 7232752188835927040 /sys/menu/all_router Get 全部路由 25
7402728416824169472 3 7232752188898841600 /sys/menu/tree Get 获取菜单树 26
7402728416887084032 3 7232752188965950464 /sys/serverinfo/server_update Get 更新服务器信息 27
7402728416937415680 3 7232752189028865024 /sys/jobinfo/add Post 添加定时任务日志 28
7402728416991941632 3 7232794958103483392 /sys/dashboard/analysis/weeklyUserActivity Get 获取仪表盘数据 29
7402728417042273280 3 7232752189095973888 /sys/jobinfo/list Get 获取定时任务日志列表 30
7402728417088410624 3 7232794958170592256 /sys/dashboard/analysis/total Get 获取仪表盘数据 31
7402728417138742272 3 7232781502121939968 /sys/user/delusers Delete 删除用户 32
7402728417189073920 3 7232752189158888448 /sys/dictdata/get_by_type Get 根据类型获取字典数据 33
7402728417226822656 3 7232794958229312512 /sys/dashboard/analysis/monthlySales Get 获取仪表盘数据 34
7402728417281348608 3 7232794958279644160 /sys/dashboard/analysis/userAccessSource Get 获取仪表盘数据 35
7402728417323291648 3 7232752189221803008 /sys/dictdata/list Get 获取字典数据列表 36
7402728417369428992 3 7232752189280523264 /sys/dictdata/del Delete 删除字典数据 37
7402728417423954944 3 7232794958317392896 /sys/dashboard/workplace/dynamic Get 获取仪表盘数据 38
7402728417486869504 3 7232794958363530240 /sys/dashboard/workplace/total Get 获取仪表盘数据 39
7402728417541395456 3 7232752189347632128 /sys/dictdata/edit Put 编辑字典数据 40
7402728417587532800 3 7232752189410546688 /sys/dictdata/add Post 添加字典数据 41
7402728417637864448 3 7232794958401278976 /sys/dashboard/workplace/radar Get 获取仪表盘数据 42
7402728417688196096 3 7232794958447416320 /sys/dashboard/workplace/project Get 获取仪表盘数据 43
7402728417738527744 3 7232752189473461248 /sys/dashboard/add Post 添加仪表盘 44
7402728417776276480 3 7232794958493553664 /sys/dashboard/workplace/team Get 获取仪表盘数据 45
7402728417826608128 3 7232752189557347328 /sys/dashboard/list Get 获取仪表盘列表 46
7402728417872745472 3 7232752189628650496 /sys/role/list Get 获取角色列表 47
7402728417927271424 3 7232752189691565056 /sys/role/get_role_menus Get 获取角色菜单 48
7402728417981797376 3 7232752189758673920 /sys/role/menu Get 获取角色菜单 49
7402728418036323328 3 7236784152022782976 /sys/user/fresh_token Put 刷新token 50
7402728418095043584 3 7232752189821588480 /sys/role/edit Put 编辑角色 51
7402728418145375232 3 7232752189888697344 /sys/role/tree Get 获取角色树 52
7402728418195706880 3 7232752189951611904 /sys/role/add Post 添加角色 53
7402728418250232832 3 7236784153973134336 /sys/user/update_avatar Put 更新头像 54
7402728418304758784 3 7232752190018720768 /sys/role/del Delete 删除角色 55
7402728418355090432 3 7232752190081635328 /sys/apipermission/list Get 获取api权限列表 56
7402728418405422080 3 7232752190144549888 /sys/user/reset_password Put 重置密码 57
7402728418455753728 3 7232752190207464448 /sys/user/userinfo Get 获取用户信息 58
7402728418506085376 3 7232752190270379008 /sys/user/depts_roles Get 获取用户拥有的用户部门和用户角色 59
7402728418552222720 3 7232752190333293568 /sys/user/del Delete 删除用户 60
7402728418602554368 3 7252738573697192960 /sys/dept/user_dept_name_list Get 获取用户拥有的部门名称列表 61
7402728418669663232 3 7232752190396208128 /sys/user/list Get 获取用户列表 62
7402728418715800576 3 7232752190459122688 /sys/user/add Post 添加用户 63
7402728418757743616 3 7232752190526231552 /sys/user/change_password Put 修改密码 64
7402728418803880960 3 7234570580194661376 /sys/useronline/del Delete 退出在线用户 65
7402728418854212608 3 7232752190589146112 /sys/user/edit Put 编辑用户 66
7402728418908738560 3 7232752190656254976 /sys/dept/edit Put 编辑部门 67
7402728418963264512 3 7232752190727558144 /sys/dept/add Post 添加部门 68
7402728419017790464 3 7232752190794667008 /sys/dept/list Get 获取部门列表 69
7402728419072316416 3 7234253747373642752 /sys/operationlog/list Get 获取操作日志列表 70
7402728419122648064 3 7232752190861775872 /sys/dept/del Delete 删除部门 71
7402728419177174016 3 7232752190933079040 /sys/dept/dept_tree Get 获取部门树 72
7402728419227505664 3 7232752190995993600 /sys/useronline/list Get 获取在线用户列表 73
7402728419265254400 3 7232752191063102464 /sys/logininfo/list Get 获取登录日志列表 74
7402728419328168960 3 7253067149336286208 /sys/user/update_role_or_dept Post 更新用户拥有的用户部门和用户角色 75
7402728419382694912 3 7233868069737501696 /sys/apipermission/edit Put 编辑api权限 76
7402728419433026560 3 7241490807281062912 /sys/user/login_out Get 用户退出 77
7402728419479163904 3 7240020747752477696 /sys/user/refersh_token Put 刷新token 78
7402728419529495552 3 7235678367742071808 /sys/job/hand_execute_job Post 执行定时任务 79
7402728419584021504 3 7385368752226735104 /test/test_api/list Get 获取列表 80
7402728419638547456 3 7385368752235123712 /test/test_api/del Delete 删除TestApi 81
7402728419688879104 3 7401293722618336256 /test/test_api/db_read_write_test Put db_read_write_test 82
7402728419751793664 3 7348333842530210816 /wechat/wxaccounts/del Delete 删除WxAccounts 83
7402728419818902528 3 7385368752239318016 /test/test_api/add Post 添加TestApi 84
7402728419873428480 3 7401293722630919168 /test/test_api/db_name_test Put db_name_test 85
7402728419940537344 3 7348333842559570944 /wechat/wxaccounts/edit Put 编辑WxAccounts 86
7402728419999257600 3 7348333842567959552 /wechat/wxaccounts/list Get 获取WxAccounts列表 87
7402728420053783552 3 7385368752243512320 /test/test_api/edit Put 编辑TestApi 88
7402728420099920896 3 7348333842572153856 /wechat/wxaccounts/add Post 添加WxAccounts 89
7402728420150252544 3 7348333842584736768 /wechat/wxautoreplies/add Post 添加WxAutoReplies 90
7402728420192195584 3 7401293722647696384 /test/test_api/db_index_test Put db_index_test 91
7402728420242527232 3 7348333842609902592 /wechat/wxautoreplies/del Delete 删除WxAutoReplies 92
7402728420292858880 3 7348333842635068416 /wechat/wxautoreplies/list Get 获取WxAutoReplies列表 93
7402728420351579136 3 7401293722651890688 /test/test_api/db_auto_test Put db_auto_test 94
7402728420406105088 3 7348333843008361472 /wechat/wxautoreplies/edit Put 编辑WxAutoReplies 95
7402728420460631040 3 7402694868939478016 /test/test_data_scope/del Delete Delete 96
7402728420506768384 3 7402694868947866624 /test/test_data_scope/list Get list 97
7402728420548711424 3 7348333843016750080 /wechat/wxmenus/list Get 获取WxMenus列表 98
7402728420624208896 3 7348333843071276032 /wechat/wxmenus/del Delete 删除WxMenus 99
7402728420682929152 3 7402694868947866625 /test/test_data_scope/add Post add 100
7402728420733260800 3 7402694868952060928 /test/test_data_scope/edit Put edit 101
7402728420796175360 3 7348333843075470336 /wechat/wxmenus/pull_menu Get 创建自定义菜单 102
7402728420854895616 3 7348333843092247552 /wechat/wxmenus/add Post 添加WxMenus 103
7402728420909421568 3 7348333843100636160 /wechat/wxmenus/edit Put 编辑WxMenus 104
7402728420959753216 3 7348333843104830464 /wechat/wxmessages/list Get 获取WxMessages列表 105
7402728421018473472 3 7348333843125801984 /wechat/wxmessages/edit Put 编辑WxMessages 106
7402728421072999424 3 7348333843138384896 /wechat/wxmessages/del Delete 删除WxMessages 107
7402728421127525376 3 7348333843150967808 /wechat/wxmessages/add Post 添加WxMessages 108
7402728421194634240 3 7348333843159356416 /wechat/wxusers/add Post 添加WxUsers 109
7402728421249160192 3 7348333843167745024 /wechat/wxusers/edit Put 编辑WxUsers 110
7402728421303686144 3 7348333843180327936 /wechat/wxusers/del Delete 删除WxUsers 111
7402728421358212096 3 7348333843184522240 /wechat/wxusers/list Get 获取WxUsers列表 112
7403405998959793152 1 7232752187397280768 /sys/job/add Post 添加定时任务 1
7403405999001736192 1 7232752187535692800 /sys/job/validate_cron Post 验证cron表达式 2
7403405999039484928 1 7232752187606995968 /sys/job/list Get 获取定时任务列表 3
7403405999068845056 1 7232752187674104832 /sys/job/edit Put 编辑定时任务 4
7403405999094010880 1 7232752187741213696 /sys/job/del Delete 删除定时任务 5
7403405999119176704 1 7232752187812516864 /sys/roleapi/add_many_role_api_transfer Get 添加多个角色api 6
7403405999148536832 1 7232752187879625728 /sys/roleapi/del Delete 删除角色api 7
7403405999182091264 1 7232752187946734592 /sys/roleapi/role_api_transfer_list Get 获取角色api所有的选择列表 8
7403405999215645696 1 7232752188013843456 /sys/roleapi/list Get 获取角色api列表 9
7403405999245005824 1 7232752188085146624 /sys/roleapi/edit Put 编辑角色api 10
7403405999274365952 1 7232752188156449792 /sys/roleapi/role_permission_list Get 根据角色id获取api权限列表 11
7403405999303726080 1 7232752188219364352 /sys/roleapi/add Post 添加角色api 12
7403405999358252032 1 7235633673968456704 /sys/role/get_role_depts Get 获取角色部门 13
7403405999391806464 1 7232752188282278912 /sys/dicttype/list Get 获取字典类型列表 14
7403405999425360896 1 7252729164858299392 /sys/role/user_role_name_list Get 获取用户拥有的角色名称列表 15
7403405999458915328 1 7232752188349387776 /sys/dicttype/add Post 添加字典类型 16
7403405999488275456 1 7232752188412302336 /sys/dicttype/del Delete 删除字典类型 17
7403405999517635584 1 7232752188479411200 /sys/dicttype/edit Put 编辑字典类型 18
7403405999551190016 1 7232752188546520064 /sys/menu/edit Put 编辑菜单 19
7403405999584744448 1 7234616780964926464 /sys/cache/clear Post 清空缓存 20
7403405999618298880 1 7232752188617823232 /sys/menu/list Get 菜单列表 21
7403405999651853312 1 7234616781027841024 /sys/cache/list Get 获取缓存列表 22
7403405999677019136 1 7232752188697515008 /sys/menu/add Post 添加菜单 23
7403405999710573568 1 7232752188764623872 /sys/menu/del Delete 删除菜单 24
7403405999739933696 1 7232752188835927040 /sys/menu/all_router Get 全部路由 25
7403405999769293824 1 7232752188898841600 /sys/menu/tree Get 获取菜单树 26
7403405999802848256 1 7232752188965950464 /sys/serverinfo/server_update Get 更新服务器信息 27
7403405999840596992 1 7232752189028865024 /sys/jobinfo/add Post 添加定时任务日志 28
7403405999878345728 1 7232794958103483392 /sys/dashboard/analysis/weeklyUserActivity Get 获取仪表盘数据 29
7403405999911900160 1 7232752189095973888 /sys/jobinfo/list Get 获取定时任务日志列表 30
7403405999941260288 1 7232794958170592256 /sys/dashboard/analysis/total Get 获取仪表盘数据 31
7403405999966426112 1 7232781502121939968 /sys/user/delusers Delete 删除用户 32
7403405999999980544 1 7232752189158888448 /sys/dictdata/get_by_type Get 根据类型获取字典数据 33
7403406000033534976 1 7232794958229312512 /sys/dashboard/analysis/monthlySales Get 获取仪表盘数据 34
7403406000067089408 1 7232794958279644160 /sys/dashboard/analysis/userAccessSource Get 获取仪表盘数据 35
7403406000100643840 1 7232752189221803008 /sys/dictdata/list Get 获取字典数据列表 36
7403406000125809664 1 7232752189280523264 /sys/dictdata/del Delete 删除字典数据 37
7403406000155169792 1 7232794958317392896 /sys/dashboard/workplace/dynamic Get 获取仪表盘数据 38
7403406000188724224 1 7232794958363530240 /sys/dashboard/workplace/total Get 获取仪表盘数据 39
7403406000213890048 1 7232752189347632128 /sys/dictdata/edit Put 编辑字典数据 40
7403406000251638784 1 7232752189410546688 /sys/dictdata/add Post 添加字典数据 41
7403406000280998912 1 7232794958401278976 /sys/dashboard/workplace/radar Get 获取仪表盘数据 42
7403406000310359040 1 7232794958447416320 /sys/dashboard/workplace/project Get 获取仪表盘数据 43
7403406000339719168 1 7232752189473461248 /sys/dashboard/add Post 添加仪表盘 44
7403406000373273600 1 7232794958493553664 /sys/dashboard/workplace/team Get 获取仪表盘数据 45
7403406000402633728 1 7232752189557347328 /sys/dashboard/list Get 获取仪表盘列表 46
7403406000431993856 1 7232752189628650496 /sys/role/list Get 获取角色列表 47
7403406000461353984 1 7232752189691565056 /sys/role/get_role_menus Get 获取角色菜单 48
7403406000490714112 1 7232752189758673920 /sys/role/menu Get 获取角色菜单 49
7403406000520074240 1 7236784152022782976 /sys/user/fresh_token Put 刷新token 50
7403406000553628672 1 7232752189821588480 /sys/role/edit Put 编辑角色 51
7403406000578794496 1 7232752189888697344 /sys/role/tree Get 获取角色树 52
7403406000616543232 1 7232752189951611904 /sys/role/add Post 添加角色 53
7403406000645903360 1 7236784153973134336 /sys/user/update_avatar Put 更新头像 54
7403406000675263488 1 7232752190018720768 /sys/role/del Delete 删除角色 55
7403406000708817920 1 7232752190081635328 /sys/apipermission/list Get 获取api权限列表 56
7403406000738178048 1 7232752190144549888 /sys/user/reset_password Put 重置密码 57
7403406000767538176 1 7232752190207464448 /sys/user/userinfo Get 获取用户信息 58
7403406000796898304 1 7232752190270379008 /sys/user/depts_roles Get 获取用户拥有的用户部门和用户角色 59
7403406000838841344 1 7232752190333293568 /sys/user/del Delete 删除用户 60
7403406000868201472 1 7252738573697192960 /sys/dept/user_dept_name_list Get 获取用户拥有的部门名称列表 61
7403406000901755904 1 7232752190396208128 /sys/user/list Get 获取用户列表 62
7403406000931116032 1 7232752190459122688 /sys/user/add Post 添加用户 63
7403406000960476160 1 7232752190526231552 /sys/user/change_password Put 修改密码 64
7403406000994030592 1 7234570580194661376 /sys/useronline/del Delete 退出在线用户 65
7403406001019196416 1 7232752190589146112 /sys/user/edit Put 编辑用户 66
7403406001048556544 1 7232752190656254976 /sys/dept/edit Put 编辑部门 67
7403406001077916672 1 7232752190727558144 /sys/dept/add Post 添加部门 68
7403406001107276800 1 7232752190794667008 /sys/dept/list Get 获取部门列表 69
7403406001136636928 1 7234253747373642752 /sys/operationlog/list Get 获取操作日志列表 70
7403406001165997056 1 7232752190861775872 /sys/dept/del Delete 删除部门 71
7403406001199551488 1 7232752190933079040 /sys/dept/dept_tree Get 获取部门树 72
7403406001233105920 1 7232752190995993600 /sys/useronline/list Get 获取在线用户列表 73
7403406001258271744 1 7232752191063102464 /sys/logininfo/list Get 获取登录日志列表 74
7403406001291826176 1 7253067149336286208 /sys/user/update_role_or_dept Post 更新用户拥有的用户部门和用户角色 75
7403406001321186304 1 7233868069737501696 /sys/apipermission/edit Put 编辑api权限 76
7403406001350546432 1 7241490807281062912 /sys/user/login_out Get 用户退出 77
7403406001375712256 1 7240020747752477696 /sys/user/refersh_token Put 刷新token 78
7403406001405072384 1 7235678367742071808 /sys/job/hand_execute_job Post 执行定时任务 79
7403406001434432512 1 7385368752226735104 /test/test_api/list Get 获取列表 80
7403406001463792640 1 7385368752235123712 /test/test_api/del Delete 删除TestApi 81
7403406001493152768 1 7401293722618336256 /test/test_api/db_read_write_test Put db_read_write_test 82
7403406001522512896 1 7348333842530210816 /wechat/wxaccounts/del Delete 删除WxAccounts 83
7403406001560261632 1 7385368752239318016 /test/test_api/add Post 添加TestApi 84
7403406001589621760 1 7401293722630919168 /test/test_api/db_name_test Put db_name_test 85
7403406001623176192 1 7348333842559570944 /wechat/wxaccounts/edit Put 编辑WxAccounts 86
7403406001652536320 1 7348333842567959552 /wechat/wxaccounts/list Get 获取WxAccounts列表 87
7403406001681896448 1 7385368752243512320 /test/test_api/edit Put 编辑TestApi 88
7403406001711256576 1 7348333842572153856 /wechat/wxaccounts/add Post 添加WxAccounts 89
7403406001740616704 1 7348333842584736768 /wechat/wxautoreplies/add Post 添加WxAutoReplies 90
7403406001769976832 1 7401293722647696384 /test/test_api/db_index_test Put db_index_test 91
7403406001795142656 1 7348333842609902592 /wechat/wxautoreplies/del Delete 删除WxAutoReplies 92
7403406001858057216 1 7348333842635068416 /wechat/wxautoreplies/list Get 获取WxAutoReplies列表 93
7403406001887417344 1 7401293722651890688 /test/test_api/db_auto_test Put db_auto_test 94
7403406001912583168 1 7348333843008361472 /wechat/wxautoreplies/edit Put 编辑WxAutoReplies 95
7403406001937748992 1 7402694868939478016 /test/test_data_scope/del Delete Delete 96
7403406001971303424 1 7402694868947866624 /test/test_data_scope/list Get list 97
7403406002004857856 1 7348333843016750080 /wechat/wxmenus/list Get 获取WxMenus列表 98
7403406002042606592 1 7348333843071276032 /wechat/wxmenus/del Delete 删除WxMenus 99
7403406002071966720 1 7402694868947866625 /test/test_data_scope/add Post add 100
7403406002113909760 1 7402694868952060928 /test/test_data_scope/edit Put edit 101
7403406002139075584 1 7348333843075470336 /wechat/wxmenus/pull_menu Get 创建自定义菜单 102
7403406002168435712 1 7348333843092247552 /wechat/wxmenus/add Post 添加WxMenus 103
7403406002197795840 1 7348333843100636160 /wechat/wxmenus/edit Put 编辑WxMenus 104
7403406002227155968 1 7348333843104830464 /wechat/wxmessages/list Get 获取WxMessages列表 105
7403406002252321792 1 7348333843125801984 /wechat/wxmessages/edit Put 编辑WxMessages 106
7403406002285876224 1 7348333843138384896 /wechat/wxmessages/del Delete 删除WxMessages 107
7403406002319430656 1 7348333843150967808 /wechat/wxmessages/add Post 添加WxMessages 108
7403406002348790784 1 7348333843159356416 /wechat/wxusers/add Post 添加WxUsers 109
7403406002378150912 1 7348333843167745024 /wechat/wxusers/edit Put 编辑WxUsers 110
7403406002411705344 1 7348333843180327936 /wechat/wxusers/del Delete 删除WxUsers 111
7403406002441065472 1 7348333843184522240 /wechat/wxusers/list Get 获取WxUsers列表 112
\.
--
-- Data for Name: sys_role_dept; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_role_dept (role_id, dept_id) FROM stdin;
7222985345490620417 101
7222985345490620417 103
7222985345490620417 104
\.
--
-- Data for Name: sys_role_menu; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_role_menu (role_id, menu_id) FROM stdin;
1 1
3 1
4 1
7222985345490620417 1
1 2
3 2
4 2
7222985345490620417 2
1 3
7222985345490620417 3
1 4
3 4
7222985345490620417 4
1 5
3 5
7222985345490620417 5
1 6
3 6
4 6
7222985345490620417 6
1 7
4 7
7222985345490620417 7
1 8
4 8
7222985345490620417 8
3 7224471859710005249
3 7225439414641627136
3 7228454585970593792
3 7402695499167208448
4 7402695499167208448
7222985345490620417 7402695499167208448
3 7402702074216879104
4 7402702074216879104
\.
--
-- Data for Name: sys_user; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_user (id, dept_id, role_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, login_ip, login_date, create_dept, create_by, created_at, update_by, updated_at, deleted_at, remark) FROM stdin;
1 100 1 admin 管理员 sys_user willmagic@qq.com 18588719996 1 static/2024-10/25_7255598825434158080.png $argon2id$v=19$m=19456,t=2,p=1$M6+FVFGkM/zIAC7VZgGoLQ$zSAK9IIFN28ZsskO5s1eKKNv2g4yGw2b+CKjRa1cLvo 0 127.0.0.1 2024-07-03 01:17:31+00 103 1 2024-07-03 01:17:31+00 \N \N \N 管理员
3 104 3 test 测试1 sys_user test@qq.com 15888888889 0 \N $argon2id$v=19$m=19456,t=2,p=1$mO97IyGb5zSmoGrmB3ET1A$x8CKk5Z33siO3zVtMUm2AjMQsRrfNISa35S+sGmksf4 0 127.0.0.1 2024-07-03 01:17:31+00 103 1 2024-07-03 01:17:31+00 3 2024-07-03 01:17:31+00 \N \N
4 102 3 test1 测试q sys_user test1@qq.com 15888888887 0 \N $2a$10$b8yUzN0C71sbz.PhNOCgJe.Tu1yWC3RNrTyjSQ8p1W0.aaUXUJ.Ne 0 127.0.0.1 2024-07-03 01:17:31+00 103 1 2024-07-03 01:17:31+00 4 2024-07-03 01:17:31+00 2024-08-24 00:21:07+00 \N
5 102 3 test2 测试2 sys_user test2@qq.com 15888888886 0 \N $2a$10$b8yUzN0C71sbz.PhNOCgJe.Tu1yWC3RNrTyjSQ8p1W0.aaUXUJ.Ne 0 127.0.0.1 2024-07-03 01:17:31+00 103 1 2024-07-03 01:17:31+00 4 2024-07-03 01:17:31+00 \N \N
7222295451336314881 103 4 test3 测试3 sys_user test3@qq.com 0588445337 1 \N $argon2id$v=19$m=19456,t=2,p=1$2ekLWIma6X91vcafwSnWmA$/l1xAacSwe3c/urIwRNTCb3l0hf1zDmUSdpAsm1V/ok 0 2024-07-03 01:17:31+00 \N \N 2024-07-03 01:17:31+00 \N \N \N \N
7222299781468655617 104 3 test4 测试4 sys_user test4@qq.com 0588445337 0 \N $argon2id$v=19$m=19456,t=2,p=1$JJh+GICj7Ii7dnexWgNrZQ$h/MU+GhTX5O9SMu7p9S899QUBWLM8QPo3lpFk7KGars 0 2024-07-03 01:17:31+00 \N \N 2024-07-03 01:17:31+00 \N \N \N 1
7223731680347033600 7223731313261547520 7222985345490620417 test5 test5 sys_user test5@qq.com 0588445337 \N \N $argon2id$v=19$m=19456,t=2,p=1$VsofXU4ao39GasijfbQvjw$sASrh2idw664BmrRN8XPguppliyXbFmYJhvclNtSi3w \N 2024-07-03 01:17:31+00 \N \N 2024-07-03 01:17:31+00 \N \N \N \N
7402727913407026176 101 3 test6 test7 sys_user test7@qq.com \N \N \N $argon2id$v=19$m=19456,t=2,p=1$gD8LZFl1wYA5iG8kf97ELw$pl5iL7eE7U5p97o6mu92vbft0VwsjbTa3iATXSKkJRw 0 \N \N \N \N \N \N \N \N
\.
--
-- Data for Name: sys_user_dept; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_user_dept (user_id, dept_id) FROM stdin;
1 100
7402727913407026176 101
1 103
7222295451336314881 103
3 104
7222299781468655617 104
7223731680347033600 7223731313261547520
\.
--
-- Data for Name: sys_user_post; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_user_post (user_id, post_id) FROM stdin;
1 1
\.
--
-- Data for Name: sys_user_role; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_user_role (user_id, role_id) FROM stdin;
1 1
1 3
3 3
7222299781468655617 3
7402727913407026176 3
4 4
7222295451336314881 4
7223731680347033600 7222985345490620417
\.
--
-- Data for Name: sys_white_jwt; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.sys_white_jwt (jid, uid, token_id, info_id, token_expr, created_at, update_at, deleted_at) FROM stdin;
7338250336651351040 1 7338250336584242176 7338250336584242177 1750180018 2025-06-11 01:06:58+00 2025-06-11 01:06:58+00 \N
7348334080116560896 1 7348334080074617856 7348334080074617857 1752584170 2025-07-08 20:56:10+00 2025-07-08 20:56:10+00 \N
7350937685579437056 1 7350937685495550976 7350937685495550977 1753204918 2025-07-16 01:21:58+00 2025-07-16 01:21:58+00 \N
7351264641399297024 1 7351264641348965376 7351264641348965377 1753282870 2025-07-16 23:01:10+00 2025-07-16 23:01:10+00 \N
7395848975468631040 1 7395848975426688000 7395848975426688001 1763912603 2025-11-16 23:43:24+00 2025-11-16 23:43:24+00 \N
7402412372016403456 1 7402412371378869248 7402412371378869249 1765477439 2025-12-05 02:24:00+00 2025-12-05 02:24:00+00 \N
7402695033029039104 1 7402695032978707456 7402695032978707457 1765544831 2025-12-05 21:07:11+00 2025-12-05 21:07:11+00 \N
7402709166579422208 1 7402709166432621568 7402709166432621569 1765548200 2025-12-05 22:03:21+00 2025-12-05 22:03:21+00 \N
7402714693157950464 7222295451336314881 7402714693057287168 7402714693057287169 1765549518 2025-12-05 22:25:19+00 2025-12-05 22:25:19+00 \N
7402715852635542528 7222295451336314881 7402715852585210880 7402715852585210881 1765549795 2025-12-05 22:29:55+00 2025-12-05 22:29:55+00 \N
7402728157268055040 7402727913407026176 7402728157159003136 7402728157159003137 1765552728 2025-12-05 23:18:49+00 2025-12-05 23:18:49+00 \N
7402749118914663424 1 7402749118885303296 7402749118889497600 1765557726 2025-12-06 00:42:06+00 2025-12-06 00:42:06+00 \N
7402749256496223232 7222295451336314881 7402749256399754240 7402749256399754241 1765557759 2025-12-06 00:42:39+00 2025-12-06 00:42:39+00 \N
7403508110926451712 1 7403508110842565632 7403508110842565633 1765738684 2025-12-08 02:58:04+00 2025-12-08 02:58:04+00 \N
7403508317714027520 7402727913407026176 7403508317600781312 7403508317604975616 1765738733 2025-12-08 02:58:53+00 2025-12-08 02:58:53+00 \N
7408879230387131392 1 7408879230340994048 7408879230340994049 1767019258 2025-12-22 22:40:59+00 2025-12-22 22:40:59+00 \N
7447696444581909504 1 7447696444028261376 7447696444028261377 1776274003 2026-04-09 01:26:44+00 2026-04-09 01:26:44+00 \N
7451645776330920960 1 7451645775789855744 7451645775789855745 1777215597 2026-04-19 22:59:58+00 2026-04-19 22:59:58+00 \N
7461085845278069760 1 7461085845202572288 7461085845202572289 1779466285 2026-05-16 00:11:26+00 2026-05-16 00:11:26+00 \N
7461092002507953152 1 7461092002415678464 7461092002419872768 1779467753 2026-05-16 00:35:54+00 2026-05-16 00:35:54+00 \N
7467279097853285376 1 7467279097819730944 7467279097819730945 1780942872 2026-06-02 02:21:12+00 2026-06-02 02:21:12+00 \N
7467616830538814464 1 7467616830505260032 7467616830505260033 1781023394 2026-06-03 00:43:14+00 2026-06-03 00:43:14+00 \N
7467626537966015488 1 7467626537877935104 7467626537877935105 1781025708 2026-06-03 01:21:48+00 2026-06-03 01:21:48+00 \N
\.
--
-- Data for Name: test_api; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.test_api (id, name, age, email, created_at, updated_at) FROM stdin;
7402976005653959680 韶颖 86 uclgm3.tny@139.com 2025-12-06 15:43:40+00 2025-12-06 15:43:40+00
\.
--
-- Data for Name: test_article; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.test_article (id, category_id, title, content, author, password, is_published, view_count, download_count, rating, cover, published_at, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: test_category; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.test_category (id, name, description, sort, status, cover, is_active, weight, view_count, created_at, updated_at) FROM stdin;
1 技术 技术相关文章 1 active t 10 0 \N 2026-05-20 01:50:32+00
2 生活 生活随笔 2 active http://localhost:5001/static/uploads/2026-05/20-7462542739511350272.png t 8 0 \N 2026-05-20 00:40:38+00
3 产品 产品设计相关 3 active \N t 5 0 \N \N
7462560992648401920 游戏 游戏 1 active \N f 1 1 \N \N
7462561771895559168 音乐 音乐 5 active \N f 1 1 2026-05-20 01:56:14+00 2026-05-20 01:56:14+00
7462563304137724928 驾驭 驾驭 0 active \N f 0 1 2026-05-20 02:02:19+00 2026-05-20 02:02:19+00
7462563461537371136 但凡 但凡 0 active \N f 0 0 2026-05-20 02:02:57+00 2026-05-20 02:02:57+00
\.
--
-- Data for Name: test_data_scope; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.test_data_scope (id, title, content, dept_id, owner_id, status, created_at, updated_at, deleted_at) FROM stdin;
7402711480572744704 胡说并列于长略微整齐耶耶耶渐渐画渐渐反正 cillum anim do nulla magna 103 7222295451336314881 0 2025-12-05 22:12:33+00 2025-12-08 01:19:17+00 \N
7402712010544026624 攥广告此外不像嗯油门却一齐尽管直到 incididunt laboris ipsum irure 72 35 0 2025-12-05 22:14:39+00 2025-12-08 01:19:17+00 \N
7402712077673862144 摘擅自共枯萎笔直长椅 elit sed velit quis 103 7222295451336314881 0 2025-12-05 22:14:55+00 2025-12-08 01:19:17+00 \N
7402712087106851840 出生写搜一同面对甚至拨多轻松 ea 55 72 0 2025-12-05 22:14:57+00 2025-12-08 01:19:17+00 \N
7402712096971854848 耶耶耶统统坐抄勇敢哎呀关于揽 adipisicing 56 89 0 2025-12-05 22:15:00+00 2025-12-08 01:19:17+00 \N
7402712106258043904 特地大哎哟朝向以呼必定 veniam 33 15 0 2025-12-05 22:15:02+00 2025-12-08 01:19:17+00 \N
7402749020059112448 特地大哎哟朝向以呼必定 veniam 33 15 0 2025-12-06 00:41:43+00 2025-12-08 01:19:17+00 \N
7402749295490667520 特地大哎哟朝向以呼必定 veniam 103 7222295451336314881 0 2025-12-06 00:42:48+00 2025-12-08 01:19:17+00 \N
7402749517151245312 哦糟糕嘘除了 in consequat exercitation velit 103 7222295451336314881 0 2025-12-06 00:43:41+00 2025-12-08 01:19:17+00 \N
7403506317010048000 fgdfsg sdfgsdfg123 103 7222295451336314881 0 2025-12-08 02:50:56+00 2025-12-08 02:56:49+00 \N
7403508171047605248 955 456 100 1 0 2025-12-08 02:58:19+00 2025-12-08 02:58:19+00 \N
7403508420336063488 测试6 测试6的数据 101 7402727913407026176 0 2025-12-08 02:59:18+00 2025-12-08 02:59:18+00 \N
\.
--
-- Data for Name: wx_accounts; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.wx_accounts (id, app_id, app_secret, account_name, account_type, original_id, wechat_id, status, message_mode, access_token, token_expires_at, server_url, token, encoding_aes_key, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: wx_auto_replies; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.wx_auto_replies (id, account_id, reply_type, keyword, match_type, message_type, content, media_id, title, description, pic_url, url, music_url, hq_music_url, thumb_media_id, status, priority, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: wx_materials; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.wx_materials (id, account_id, media_type, media_id, name, url, local_path, file_size, content_type, width, height, duration, description, title, introduction, thumb_media_id, thumb_url, content_source_url, digest, author, content, news_items, is_permanent, sync_status, synced_at, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: wx_menus; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.wx_menus (id, account_id, parent_id, menu_name, menu_type, menu_key, url, media_id, appid, pagepath, article_id, sort_order, status, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: wx_messages; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.wx_messages (id, account_id, openid, msg_id, msg_type, direction, content, media_id, pic_url, voice_format, recognition, thumb_media_id, msg_title, msg_description, link_url, event_type, event_key, reply_msg_id, is_auto_reply, created_at) FROM stdin;
\.
--
-- Data for Name: wx_pay_orders; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.wx_pay_orders (id, account_id, out_trade_no, transaction_id, openid, body, total_fee, fee_type, trade_type, spbill_create_ip, notify_url, prepay_id, code_url, mch_id, trade_state, trade_state_desc, attach, time_expire, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: wx_pay_refunds; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.wx_pay_refunds (id, account_id, out_trade_no, out_refund_no, transaction_id, refund_id, total_fee, refund_fee, refund_reason, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: wx_template_logs; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.wx_template_logs (id, account_id, template_id, openid, content, miniprogram_appid, miniprogram_pagepath, msg_id, errcode, errmsg, status, created_at) FROM stdin;
\.
--
-- Data for Name: wx_templates; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.wx_templates (id, account_id, template_id, title, industry, content, example, template_type, status, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: wx_users; Type: TABLE DATA; Schema: qiluoopen; Owner: -
--
COPY qiluoopen.wx_users (id, account_id, openid, unionid, nickname, sex, city, country, province, language, headimgurl, subscribe_time, unsubscribe_time, subscribe_status, remark, subscribe_scene, qr_scene, qr_scene_str, last_interact_time, message_count, created_at, updated_at) FROM stdin;
\.
--
-- Name: sys_mail_log_id_seq; Type: SEQUENCE SET; Schema: qiluoopen; Owner: -
--
SELECT pg_catalog.setval('qiluoopen.sys_mail_log_id_seq', 7467808818831725568, true);
--
-- Name: seaql_migrations idx_16878_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.seaql_migrations
ADD CONSTRAINT idx_16878_primary PRIMARY KEY (version);
--
-- Name: sys_api_permission idx_16881_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_api_permission
ADD CONSTRAINT idx_16881_primary PRIMARY KEY (id);
--
-- Name: sys_codegen_config idx_16887_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_codegen_config
ADD CONSTRAINT idx_16887_primary PRIMARY KEY (id);
--
-- Name: sys_dept idx_16892_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_dept
ADD CONSTRAINT idx_16892_primary PRIMARY KEY (dept_id);
--
-- Name: sys_dict_data idx_16904_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_dict_data
ADD CONSTRAINT idx_16904_primary PRIMARY KEY (dict_code);
--
-- Name: sys_dict_type idx_16912_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_dict_type
ADD CONSTRAINT idx_16912_primary PRIMARY KEY (dict_id);
--
-- Name: sys_job idx_16917_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_job
ADD CONSTRAINT idx_16917_primary PRIMARY KEY (job_id);
--
-- Name: sys_job_log idx_16924_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_job_log
ADD CONSTRAINT idx_16924_primary PRIMARY KEY (id);
--
-- Name: sys_login_info idx_16931_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_login_info
ADD CONSTRAINT idx_16931_primary PRIMARY KEY (info_id);
--
-- Name: sys_mail_log idx_16945_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_mail_log
ADD CONSTRAINT idx_16945_primary PRIMARY KEY (id);
--
-- Name: sys_mail_template idx_16952_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_mail_template
ADD CONSTRAINT idx_16952_primary PRIMARY KEY (id);
--
-- Name: sys_menu idx_16960_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_menu
ADD CONSTRAINT idx_16960_primary PRIMARY KEY (id);
--
-- Name: sys_notice idx_16981_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_notice
ADD CONSTRAINT idx_16981_primary PRIMARY KEY (notice_id);
--
-- Name: sys_oper_log idx_16987_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_oper_log
ADD CONSTRAINT idx_16987_primary PRIMARY KEY (oper_id);
--
-- Name: sys_post idx_17004_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_post
ADD CONSTRAINT idx_17004_primary PRIMARY KEY (post_id);
--
-- Name: sys_role idx_17009_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_role
ADD CONSTRAINT idx_17009_primary PRIMARY KEY (role_id);
--
-- Name: sys_role_api idx_17015_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_role_api
ADD CONSTRAINT idx_17015_primary PRIMARY KEY (id);
--
-- Name: sys_role_dept idx_17018_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_role_dept
ADD CONSTRAINT idx_17018_primary PRIMARY KEY (role_id, dept_id);
--
-- Name: sys_role_menu idx_17021_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_role_menu
ADD CONSTRAINT idx_17021_primary PRIMARY KEY (role_id, menu_id);
--
-- Name: sys_user idx_17024_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_user
ADD CONSTRAINT idx_17024_primary PRIMARY KEY (id);
--
-- Name: sys_user_dept idx_17036_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_user_dept
ADD CONSTRAINT idx_17036_primary PRIMARY KEY (user_id, dept_id);
--
-- Name: sys_user_post idx_17039_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_user_post
ADD CONSTRAINT idx_17039_primary PRIMARY KEY (user_id, post_id);
--
-- Name: sys_user_role idx_17042_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_user_role
ADD CONSTRAINT idx_17042_primary PRIMARY KEY (user_id, role_id);
--
-- Name: sys_white_jwt idx_17045_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_white_jwt
ADD CONSTRAINT idx_17045_primary PRIMARY KEY (jid);
--
-- Name: test_api idx_17048_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.test_api
ADD CONSTRAINT idx_17048_primary PRIMARY KEY (id);
--
-- Name: test_article idx_17054_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.test_article
ADD CONSTRAINT idx_17054_primary PRIMARY KEY (id);
--
-- Name: test_category idx_17063_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.test_category
ADD CONSTRAINT idx_17063_primary PRIMARY KEY (id);
--
-- Name: test_data_scope idx_17073_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.test_data_scope
ADD CONSTRAINT idx_17073_primary PRIMARY KEY (id);
--
-- Name: wx_accounts idx_17079_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_accounts
ADD CONSTRAINT idx_17079_primary PRIMARY KEY (id);
--
-- Name: wx_auto_replies idx_17086_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_auto_replies
ADD CONSTRAINT idx_17086_primary PRIMARY KEY (id);
--
-- Name: wx_materials idx_17093_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_materials
ADD CONSTRAINT idx_17093_primary PRIMARY KEY (id);
--
-- Name: wx_menus idx_17102_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_menus
ADD CONSTRAINT idx_17102_primary PRIMARY KEY (id);
--
-- Name: wx_messages idx_17109_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_messages
ADD CONSTRAINT idx_17109_primary PRIMARY KEY (id);
--
-- Name: wx_pay_orders idx_17115_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_pay_orders
ADD CONSTRAINT idx_17115_primary PRIMARY KEY (id);
--
-- Name: wx_pay_refunds idx_17122_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_pay_refunds
ADD CONSTRAINT idx_17122_primary PRIMARY KEY (id);
--
-- Name: wx_templates idx_17129_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_templates
ADD CONSTRAINT idx_17129_primary PRIMARY KEY (id);
--
-- Name: wx_template_logs idx_17136_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_template_logs
ADD CONSTRAINT idx_17136_primary PRIMARY KEY (id);
--
-- Name: wx_users idx_17142_primary; Type: CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_users
ADD CONSTRAINT idx_17142_primary PRIMARY KEY (id);
--
-- Name: idx_16881_api; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE UNIQUE INDEX idx_16881_api ON qiluoopen.sys_api_permission USING btree (api);
--
-- Name: idx_16887_uk_codegen_module_table; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE UNIQUE INDEX idx_16887_uk_codegen_module_table ON qiluoopen.sys_codegen_config USING btree (module_name, table_name);
--
-- Name: idx_16912_tenant_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE UNIQUE INDEX idx_16912_tenant_id ON qiluoopen.sys_dict_type USING btree (dict_type);
--
-- Name: idx_16917_job_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE UNIQUE INDEX idx_16917_job_id ON qiluoopen.sys_job USING btree (job_id);
--
-- Name: idx_16924_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE UNIQUE INDEX idx_16924_id ON qiluoopen.sys_job_log USING btree (id);
--
-- Name: idx_16931_idx_sys_logininfor_lt; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_16931_idx_sys_logininfor_lt ON qiluoopen.sys_login_info USING btree (login_time);
--
-- Name: idx_16931_idx_sys_logininfor_s; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_16931_idx_sys_logininfor_s ON qiluoopen.sys_login_info USING btree (status);
--
-- Name: idx_16952_code; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE UNIQUE INDEX idx_16952_code ON qiluoopen.sys_mail_template USING btree (code);
--
-- Name: idx_16987_idx_sys_oper_log_ot; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_16987_idx_sys_oper_log_ot ON qiluoopen.sys_oper_log USING btree (oper_time);
--
-- Name: idx_16987_idx_sys_oper_log_s; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_16987_idx_sys_oper_log_s ON qiluoopen.sys_oper_log USING btree (status);
--
-- Name: idx_17018_dept_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17018_dept_id ON qiluoopen.sys_role_dept USING btree (dept_id);
--
-- Name: idx_17021_menu_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17021_menu_id ON qiluoopen.sys_role_menu USING btree (menu_id);
--
-- Name: idx_17036_dept_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17036_dept_id ON qiluoopen.sys_user_dept USING btree (dept_id);
--
-- Name: idx_17039_post_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17039_post_id ON qiluoopen.sys_user_post USING btree (post_id);
--
-- Name: idx_17042_role_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17042_role_id ON qiluoopen.sys_user_role USING btree (role_id);
--
-- Name: idx_17054_idx_category_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17054_idx_category_id ON qiluoopen.test_article USING btree (category_id);
--
-- Name: idx_17073_idx_test_data_scope_dept_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17073_idx_test_data_scope_dept_id ON qiluoopen.test_data_scope USING btree (dept_id);
--
-- Name: idx_17073_idx_test_data_scope_owner_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17073_idx_test_data_scope_owner_id ON qiluoopen.test_data_scope USING btree (owner_id);
--
-- Name: idx_17079_app_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE UNIQUE INDEX idx_17079_app_id ON qiluoopen.wx_accounts USING btree (app_id);
--
-- Name: idx_17086_account_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17086_account_id ON qiluoopen.wx_auto_replies USING btree (account_id);
--
-- Name: idx_17093_account_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17093_account_id ON qiluoopen.wx_materials USING btree (account_id);
--
-- Name: idx_17102_account_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17102_account_id ON qiluoopen.wx_menus USING btree (account_id);
--
-- Name: idx_17109_account_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17109_account_id ON qiluoopen.wx_messages USING btree (account_id);
--
-- Name: idx_17115_account_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17115_account_id ON qiluoopen.wx_pay_orders USING btree (account_id);
--
-- Name: idx_17122_account_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17122_account_id ON qiluoopen.wx_pay_refunds USING btree (account_id);
--
-- Name: idx_17129_account_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17129_account_id ON qiluoopen.wx_templates USING btree (account_id);
--
-- Name: idx_17136_account_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17136_account_id ON qiluoopen.wx_template_logs USING btree (account_id);
--
-- Name: idx_17142_account_id; Type: INDEX; Schema: qiluoopen; Owner: -
--
CREATE INDEX idx_17142_account_id ON qiluoopen.wx_users USING btree (account_id);
--
-- Name: test_api on_update_current_timestamp; Type: TRIGGER; Schema: qiluoopen; Owner: -
--
CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON qiluoopen.test_api FOR EACH ROW EXECUTE FUNCTION qiluoopen.on_update_current_timestamp_test_api();
--
-- Name: test_data_scope on_update_current_timestamp; Type: TRIGGER; Schema: qiluoopen; Owner: -
--
CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON qiluoopen.test_data_scope FOR EACH ROW EXECUTE FUNCTION qiluoopen.on_update_current_timestamp_test_data_scope();
--
-- Name: wx_materials on_update_current_timestamp; Type: TRIGGER; Schema: qiluoopen; Owner: -
--
CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON qiluoopen.wx_materials FOR EACH ROW EXECUTE FUNCTION qiluoopen.on_update_current_timestamp_wx_materials();
--
-- Name: test_article fk_article_category; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.test_article
ADD CONSTRAINT fk_article_category FOREIGN KEY (category_id) REFERENCES qiluoopen.test_category(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: sys_role_dept sys_role_dept_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_role_dept
ADD CONSTRAINT sys_role_dept_ibfk_1 FOREIGN KEY (role_id) REFERENCES qiluoopen.sys_role(role_id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: sys_role_dept sys_role_dept_ibfk_2; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_role_dept
ADD CONSTRAINT sys_role_dept_ibfk_2 FOREIGN KEY (dept_id) REFERENCES qiluoopen.sys_dept(dept_id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: sys_role_menu sys_role_menu_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_role_menu
ADD CONSTRAINT sys_role_menu_ibfk_1 FOREIGN KEY (menu_id) REFERENCES qiluoopen.sys_menu(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: sys_role_menu sys_role_menu_ibfk_2; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_role_menu
ADD CONSTRAINT sys_role_menu_ibfk_2 FOREIGN KEY (role_id) REFERENCES qiluoopen.sys_role(role_id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: sys_user_dept sys_user_dept_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_user_dept
ADD CONSTRAINT sys_user_dept_ibfk_1 FOREIGN KEY (user_id) REFERENCES qiluoopen.sys_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: sys_user_dept sys_user_dept_ibfk_2; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_user_dept
ADD CONSTRAINT sys_user_dept_ibfk_2 FOREIGN KEY (dept_id) REFERENCES qiluoopen.sys_dept(dept_id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: sys_user_post sys_user_post_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_user_post
ADD CONSTRAINT sys_user_post_ibfk_1 FOREIGN KEY (user_id) REFERENCES qiluoopen.sys_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: sys_user_post sys_user_post_ibfk_2; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_user_post
ADD CONSTRAINT sys_user_post_ibfk_2 FOREIGN KEY (post_id) REFERENCES qiluoopen.sys_post(post_id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: sys_user_role sys_user_role_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_user_role
ADD CONSTRAINT sys_user_role_ibfk_1 FOREIGN KEY (role_id) REFERENCES qiluoopen.sys_role(role_id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: sys_user_role sys_user_role_ibfk_2; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.sys_user_role
ADD CONSTRAINT sys_user_role_ibfk_2 FOREIGN KEY (user_id) REFERENCES qiluoopen.sys_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: wx_auto_replies wx_auto_replies_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_auto_replies
ADD CONSTRAINT wx_auto_replies_ibfk_1 FOREIGN KEY (account_id) REFERENCES qiluoopen.wx_accounts(id) ON UPDATE RESTRICT ON DELETE CASCADE;
--
-- Name: wx_materials wx_materials_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_materials
ADD CONSTRAINT wx_materials_ibfk_1 FOREIGN KEY (account_id) REFERENCES qiluoopen.wx_accounts(id) ON UPDATE RESTRICT ON DELETE CASCADE;
--
-- Name: wx_menus wx_menus_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_menus
ADD CONSTRAINT wx_menus_ibfk_1 FOREIGN KEY (account_id) REFERENCES qiluoopen.wx_accounts(id) ON UPDATE RESTRICT ON DELETE CASCADE;
--
-- Name: wx_messages wx_messages_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_messages
ADD CONSTRAINT wx_messages_ibfk_1 FOREIGN KEY (account_id) REFERENCES qiluoopen.wx_accounts(id) ON UPDATE RESTRICT ON DELETE CASCADE;
--
-- Name: wx_pay_orders wx_pay_orders_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_pay_orders
ADD CONSTRAINT wx_pay_orders_ibfk_1 FOREIGN KEY (account_id) REFERENCES qiluoopen.wx_accounts(id) ON UPDATE RESTRICT ON DELETE CASCADE;
--
-- Name: wx_pay_refunds wx_pay_refunds_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_pay_refunds
ADD CONSTRAINT wx_pay_refunds_ibfk_1 FOREIGN KEY (account_id) REFERENCES qiluoopen.wx_accounts(id) ON UPDATE RESTRICT ON DELETE CASCADE;
--
-- Name: wx_template_logs wx_template_logs_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_template_logs
ADD CONSTRAINT wx_template_logs_ibfk_1 FOREIGN KEY (account_id) REFERENCES qiluoopen.wx_accounts(id) ON UPDATE RESTRICT ON DELETE CASCADE;
--
-- Name: wx_templates wx_templates_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_templates
ADD CONSTRAINT wx_templates_ibfk_1 FOREIGN KEY (account_id) REFERENCES qiluoopen.wx_accounts(id) ON UPDATE RESTRICT ON DELETE CASCADE;
--
-- Name: wx_users wx_users_ibfk_1; Type: FK CONSTRAINT; Schema: qiluoopen; Owner: -
--
ALTER TABLE ONLY qiluoopen.wx_users
ADD CONSTRAINT wx_users_ibfk_1 FOREIGN KEY (account_id) REFERENCES qiluoopen.wx_accounts(id) ON UPDATE RESTRICT ON DELETE CASCADE;
--
-- PostgreSQL database dump complete
--
\unrestrict ibmK4dL6M4pqEvlM3dWQ17oroD5brVW6TSvY5cbc3uscxoJgv6uf9828xVBKdKp