RUIAN_OA/sql/ruian.sql

--
-- Kingbase database dump
--

-- Dumped from database version 12.1
-- Dumped by sys_dump version 12.1

-- Started on 2024-10-23 14:41:15

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'GBK';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', 'public', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_with_oids = off;
SET default_with_rowid = off;

--
-- TOC entry 44 (class 2615 OID 16390)
-- Name: ruian_oa; Type: SCHEMA; Schema: -; Owner: system
--

CREATE SCHEMA ruian_oa;


ALTER SCHEMA ruian_oa OWNER TO system;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- TOC entry 697 (class 1259 OID 16391)
-- Name: infra_api_access_log; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_api_access_log (
    id numeric(20,0) NOT NULL,
    trace_id character varying(64 char),
    user_id character varying(36 char) DEFAULT 0,
    user_type numeric(4,0) DEFAULT 0,
    application_name character varying(50 char),
    request_method character varying(16 char),
    request_url character varying(255 char),
    request_params nclob,
    user_ip character varying(50 char),
    user_agent character varying(512 char),
    begin_time date,
    end_time date,
    duration numeric(11,0),
    result_code numeric(11,0),
    result_msg character varying(512 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    tenant_id numeric(20,0),
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.infra_api_access_log OWNER TO system;

--
-- TOC entry 748 (class 1259 OID 16760)
-- Name: infra_api_access_log_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_api_access_log_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_api_access_log_seq OWNER TO system;

--
-- TOC entry 698 (class 1259 OID 16400)
-- Name: infra_api_error_log; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_api_error_log (
    id numeric(11,0) NOT NULL,
    trace_id character varying(64 char),
    user_id character varying(36 char),
    user_type numeric(4,0),
    application_name character varying(50 char),
    request_method character varying(16 char),
    request_url character varying(255 char),
    request_params nclob,
    user_ip character varying(50 char),
    user_agent character varying(512 char),
    exception_time date,
    exception_name character varying(128 char),
    exception_message nclob,
    exception_root_cause_message nclob,
    exception_stack_trace nclob,
    exception_class_name character varying(512 char),
    exception_file_name character varying(512 char),
    exception_method_name character varying(512 char),
    exception_line_number numeric(11,0),
    process_status numeric(4,0),
    process_time date,
    process_user_id numeric(11,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    tenant_id numeric(20,0),
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.infra_api_error_log OWNER TO system;

--
-- TOC entry 749 (class 1259 OID 16762)
-- Name: infra_api_error_log_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_api_error_log_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_api_error_log_seq OWNER TO system;

--
-- TOC entry 699 (class 1259 OID 16407)
-- Name: infra_codegen_column; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_codegen_column (
    id numeric(20,0) NOT NULL,
    table_id numeric(20,0),
    column_name character varying(200 char),
    data_type character varying(100 char),
    column_comment character varying(500 char),
    nullable numeric(4,0),
    primary_key numeric(4,0),
    "auto_increment" numeric(4,0),
    ordinal_position numeric(11,0),
    java_type character varying(32 char),
    java_field character varying(64 char),
    dict_type character varying(200 char),
    example character varying(64 char),
    create_operation numeric(4,0),
    update_operation numeric(4,0),
    list_operation numeric(4,0),
    list_operation_condition character varying(32 char),
    list_operation_result numeric(4,0),
    html_type character varying(32 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(4,0) DEFAULT 0
);


ALTER TABLE ruian_oa.infra_codegen_column OWNER TO system;

--
-- TOC entry 750 (class 1259 OID 16764)
-- Name: infra_codegen_column_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_codegen_column_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_codegen_column_seq OWNER TO system;

--
-- TOC entry 700 (class 1259 OID 16414)
-- Name: infra_codegen_table; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_codegen_table (
    id numeric(20,0) NOT NULL,
    data_source_config_id numeric,
    scene numeric(4,0),
    table_name character varying(200 char),
    table_comment character varying(500 char),
    remark character varying(500 char),
    module_name character varying(30 char),
    business_name character varying(30 char),
    class_name character varying(100 char),
    class_comment character varying(50 char),
    author character varying(50 char),
    template_type numeric(4,0),
    parent_menu_id numeric(20,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(4,0) DEFAULT 0,
    front_type numeric(4,0)
);


ALTER TABLE ruian_oa.infra_codegen_table OWNER TO system;

--
-- TOC entry 751 (class 1259 OID 16766)
-- Name: infra_codegen_table_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_codegen_table_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_codegen_table_seq OWNER TO system;

--
-- TOC entry 701 (class 1259 OID 16421)
-- Name: infra_config; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_config (
    id numeric(11,0) NOT NULL,
    category character varying(50 char),
    type numeric(4,0),
    name character varying(100 char),
    config_key character varying(100 char),
    value character varying(500 char),
    visible numeric(4,0),
    remark character varying(500 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.infra_config OWNER TO system;

--
-- TOC entry 752 (class 1259 OID 16768)
-- Name: infra_config_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_config_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_config_seq OWNER TO system;

--
-- TOC entry 702 (class 1259 OID 16428)
-- Name: infra_data_source_config; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_data_source_config (
    id numeric NOT NULL,
    name character varying(100 char),
    url nclob,
    username character varying(255 char),
    password character varying(255 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric DEFAULT 0
);


ALTER TABLE ruian_oa.infra_data_source_config OWNER TO system;

--
-- TOC entry 753 (class 1259 OID 16770)
-- Name: infra_data_source_config_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_data_source_config_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_data_source_config_seq OWNER TO system;

--
-- TOC entry 703 (class 1259 OID 16435)
-- Name: infra_file; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_file (
    id numeric(20,0) NOT NULL,
    config_id numeric(20,0),
    path character varying(512 char),
    url nclob,
    type character varying(128 char),
    size numeric(11,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    name character varying(512 char),
    project_id character varying(60 char)
);


ALTER TABLE ruian_oa.infra_file OWNER TO system;

--
-- TOC entry 704 (class 1259 OID 16442)
-- Name: infra_file_config; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_file_config (
    id numeric(20,0) NOT NULL,
    name character varying(63 char),
    storage numeric(4,0),
    remark character varying(255 char),
    master numeric(4,0),
    config nclob,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(4,0) DEFAULT 0
);


ALTER TABLE ruian_oa.infra_file_config OWNER TO system;

--
-- TOC entry 754 (class 1259 OID 16772)
-- Name: infra_file_config_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_file_config_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_file_config_seq OWNER TO system;

--
-- TOC entry 705 (class 1259 OID 16449)
-- Name: infra_file_content; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_file_content (
    id numeric(20,0) NOT NULL,
    config_id numeric(20,0),
    path character varying(512 char),
    content blob,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(4,0) DEFAULT 0
);


ALTER TABLE ruian_oa.infra_file_content OWNER TO system;

--
-- TOC entry 755 (class 1259 OID 16774)
-- Name: infra_file_content_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_file_content_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_file_content_seq OWNER TO system;

--
-- TOC entry 756 (class 1259 OID 16776)
-- Name: infra_file_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_file_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_file_seq OWNER TO system;

--
-- TOC entry 706 (class 1259 OID 16456)
-- Name: infra_job; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_job (
    id numeric(20,0) NOT NULL,
    name character varying(32 char),
    status numeric(4,0),
    handler_name character varying(64 char),
    handler_param character varying(255 char),
    cron_expression character varying(32 char),
    retry_count numeric(11,0),
    retry_interval numeric(11,0),
    monitor_timeout numeric(11,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.infra_job OWNER TO system;

--
-- TOC entry 707 (class 1259 OID 16463)
-- Name: infra_job_log; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_job_log (
    id numeric(20,0) NOT NULL,
    job_id numeric(20,0),
    handler_name character varying(64 char),
    handler_param character varying(255 char),
    execute_index numeric(4,0),
    begin_time date,
    end_time date,
    duration numeric(11,0),
    status numeric(4,0),
    result nclob,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.infra_job_log OWNER TO system;

--
-- TOC entry 757 (class 1259 OID 16778)
-- Name: infra_job_log_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_job_log_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_job_log_seq OWNER TO system;

--
-- TOC entry 758 (class 1259 OID 16780)
-- Name: infra_job_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_job_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_job_seq OWNER TO system;

--
-- TOC entry 708 (class 1259 OID 16470)
-- Name: infra_msg_send_record; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_msg_send_record (
    id numeric NOT NULL,
    send_person_id character varying(64 byte),
    send_person character varying(64 byte),
    send_mobile character varying(32 byte),
    send_state numeric,
    send_type numeric,
    send_content character varying(2000 byte),
    send_result character varying(255 byte),
    third_id character varying(255 byte),
    send_time date,
    msg_type character varying(64 byte)
);


ALTER TABLE ruian_oa.infra_msg_send_record OWNER TO system;

--
-- TOC entry 759 (class 1259 OID 16782)
-- Name: infra_msg_send_record_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_msg_send_record_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 999999999999999
    CACHE 20;


ALTER TABLE ruian_oa.infra_msg_send_record_seq OWNER TO system;

--
-- TOC entry 709 (class 1259 OID 16476)
-- Name: infra_test_demo; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.infra_test_demo (
    id numeric(20,0) NOT NULL,
    name character varying(100 char),
    status numeric(4,0),
    type numeric(4,0),
    category numeric(4,0),
    remark character varying(500 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric DEFAULT 0
);


ALTER TABLE ruian_oa.infra_test_demo OWNER TO system;

--
-- TOC entry 760 (class 1259 OID 16784)
-- Name: infra_test_demo_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.infra_test_demo_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.infra_test_demo_seq OWNER TO system;

--
-- TOC entry 710 (class 1259 OID 16483)
-- Name: message_info; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.message_info (
    id character varying(36 byte) NOT NULL,
    message_id character varying(128 byte),
    create_time date,
    type numeric,
    status numeric,
    excute_time numeric,
    system_code character varying(52 byte),
    target_url character varying(256 byte),
    callback_url character varying(256 byte),
    ret_value character varying(2000 byte),
    request_ip character varying(24 byte),
    third_process_res numeric,
    isvalid numeric,
    create_worker character varying(36 byte),
    latest_modify_time date,
    latest_modify_worker character varying(36 byte),
    bz1 character varying(255 char),
    bz2 character varying(255 char),
    message_body clob
);


ALTER TABLE ruian_oa.message_info OWNER TO system;

--
-- TOC entry 711 (class 1259 OID 16531)
-- Name: system_area; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_area (
    id character varying(32 byte) NOT NULL,
    name character varying(255 byte),
    type character varying(10 byte),
    parent_id character varying(32 byte),
    full_name character varying(255 byte)
);


ALTER TABLE ruian_oa.system_area OWNER TO system;

--
-- TOC entry 712 (class 1259 OID 16534)
-- Name: system_company; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_company (
    id character varying(36 char) NOT NULL,
    parent_id character varying(36 char),
    name character varying(30 char),
    sort numeric(11,0),
    phone character varying(11 char),
    email character varying(50 char),
    status numeric(4,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    code character varying(10 byte)
);


ALTER TABLE ruian_oa.system_company OWNER TO system;

--
-- TOC entry 713 (class 1259 OID 16539)
-- Name: system_dept; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_dept (
    id character varying(36 char) NOT NULL,
    name character varying(30 char),
    parent_id_bak numeric(20,0),
    sort numeric(11,0),
    leader_user_id character varying(36 char),
    phone character varying(11 char),
    email character varying(50 char),
    status numeric(4,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    parent_id character varying(36 char),
    code character varying(32 byte),
    segment numeric(2,0)
);


ALTER TABLE ruian_oa.system_dept OWNER TO system;

--
-- TOC entry 714 (class 1259 OID 16543)
-- Name: system_dept_leader; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_dept_leader (
    id character varying(36 char) NOT NULL,
    dept_id character varying(36 char),
    user_id character varying(36 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_dept_leader OWNER TO system;

--
-- TOC entry 761 (class 1259 OID 16786)
-- Name: system_dept_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_dept_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_dept_seq OWNER TO system;

--
-- TOC entry 715 (class 1259 OID 16547)
-- Name: system_dict_data; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_dict_data (
    id numeric(20,0) NOT NULL,
    sort numeric(11,0),
    label character varying(100 char),
    value character varying(100 char),
    dict_type character varying(100 char),
    status numeric(4,0),
    color_type character varying(100 char),
    css_class character varying(100 char),
    remark character varying(500 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_dict_data OWNER TO system;

--
-- TOC entry 762 (class 1259 OID 16788)
-- Name: system_dict_data_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_dict_data_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_dict_data_seq OWNER TO system;

--
-- TOC entry 716 (class 1259 OID 16554)
-- Name: system_dict_type; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_dict_type (
    id numeric(20,0) NOT NULL,
    name character varying(100 char),
    type character varying(100 char),
    status numeric(4,0),
    remark character varying(500 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    deleted_time date
);


ALTER TABLE ruian_oa.system_dict_type OWNER TO system;

--
-- TOC entry 763 (class 1259 OID 16790)
-- Name: system_dict_type_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_dict_type_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_dict_type_seq OWNER TO system;

--
-- TOC entry 717 (class 1259 OID 16561)
-- Name: system_district; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_district (
    district_id character varying(36 char) NOT NULL,
    city_code character varying(16 char),
    city_name character varying(64 char),
    county_code character varying(16 char),
    county_name character varying(64 char),
    town_code character varying(16 char),
    town_name character varying(64 char),
    village_code character varying(16 char),
    village_name character varying(64 char),
    villagers_group_code character varying(16 char),
    villagers_group_name character varying(64 char),
    joincode character varying(64 char),
    short_name character varying(32 char),
    isvalid numeric(10,0),
    bz1 character varying(255 char),
    bz2 character varying(255 char),
    bz3 character varying(255 char),
    index_code numeric(10,0),
    province_code character varying(16 char),
    province_name character varying(64 char),
    qh character varying(36 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_district OWNER TO system;

--
-- TOC entry 718 (class 1259 OID 16568)
-- Name: system_error_code; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_error_code (
    id numeric(20,0) NOT NULL,
    type numeric(4,0),
    application_name character varying(50 char),
    code numeric(11,0),
    message character varying(512 char),
    memo character varying(512 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_error_code OWNER TO system;

--
-- TOC entry 764 (class 1259 OID 16792)
-- Name: system_error_code_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_error_code_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_error_code_seq OWNER TO system;

--
-- TOC entry 719 (class 1259 OID 16575)
-- Name: system_login_log; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_login_log (
    id numeric(20,0) NOT NULL,
    log_type numeric(20,0),
    trace_id character varying(64 char) DEFAULT NULL::varchar,
    user_id_bak numeric(20,0),
    user_type numeric(4,0),
    username character varying(50 char),
    result numeric(4,0),
    user_ip character varying(50 char),
    user_agent character varying(512 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    user_id character varying(36 byte)
);


ALTER TABLE ruian_oa.system_login_log OWNER TO system;

--
-- TOC entry 765 (class 1259 OID 16794)
-- Name: system_login_log_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_login_log_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_login_log_seq OWNER TO system;

--
-- TOC entry 720 (class 1259 OID 16583)
-- Name: system_mail_account; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_mail_account (
    id numeric(20,0) NOT NULL,
    mail character varying(255 char),
    username character varying(255 char),
    password character varying(255 char),
    host character varying(255 char),
    port numeric(11,0),
    ssl_enable character varying(1 byte),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_mail_account OWNER TO system;

--
-- TOC entry 721 (class 1259 OID 16590)
-- Name: system_mail_log; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_mail_log (
    id numeric(20,0) NOT NULL,
    user_id character varying(36 char),
    user_type numeric(4,0),
    to_mail character varying(255 char),
    account_id numeric(20,0),
    from_mail character varying(255 char),
    template_id numeric(20,0),
    template_code character varying(63 char),
    template_nickname character varying(255 char),
    template_title character varying(255 char),
    template_content nclob,
    template_params character varying(255 char),
    send_status numeric(4,0),
    send_time date,
    send_message_id character varying(255 char),
    send_exception nclob,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted character varying(1 byte)
);


ALTER TABLE ruian_oa.system_mail_log OWNER TO system;

--
-- TOC entry 722 (class 1259 OID 16596)
-- Name: system_mail_template; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_mail_template (
    id numeric(20,0) NOT NULL,
    name character varying(63 char),
    code character varying(63 char),
    account_id numeric(20,0),
    nickname character varying(255 char),
    title character varying(255 char),
    content nclob,
    params character varying(255 char),
    status numeric(4,0),
    remark character varying(255 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_mail_template OWNER TO system;

--
-- TOC entry 723 (class 1259 OID 16603)
-- Name: system_menu; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_menu (
    id numeric(20,0) NOT NULL,
    name character varying(50 char),
    permission character varying(100 char) DEFAULT NULL::varchar,
    type numeric(4,0),
    sort numeric(11,0),
    parent_id numeric(20,0),
    path character varying(200 char),
    icon character varying(100 char),
    component character varying(255 char),
    component_name character varying(255 char),
    status numeric(4,0),
    visible character varying(1 byte),
    keep_alive character varying(1 byte),
    always_show character varying(1 byte),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_menu OWNER TO system;

--
-- TOC entry 766 (class 1259 OID 16796)
-- Name: system_menu_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_menu_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_menu_seq OWNER TO system;

--
-- TOC entry 724 (class 1259 OID 16611)
-- Name: system_notice; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_notice (
    id numeric(20,0) NOT NULL,
    title character varying(50 char),
    content nclob,
    type numeric(4,0),
    status numeric(4,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_notice OWNER TO system;

--
-- TOC entry 767 (class 1259 OID 16798)
-- Name: system_notice_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_notice_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_notice_seq OWNER TO system;

--
-- TOC entry 725 (class 1259 OID 16618)
-- Name: system_notify_message; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_notify_message (
    id numeric(20,0) NOT NULL,
    user_id character varying(36 char),
    user_type numeric(4,0),
    template_id numeric(20,0),
    template_code character varying(64 char),
    template_nickname character varying(63 char),
    template_content nclob,
    template_type numeric(11,0),
    template_params character varying(255 char),
    read_status boolean,
    read_time date,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_notify_message OWNER TO system;

--
-- TOC entry 768 (class 1259 OID 16800)
-- Name: system_notify_message_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_notify_message_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_notify_message_seq OWNER TO system;

--
-- TOC entry 726 (class 1259 OID 16625)
-- Name: system_notify_template; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_notify_template (
    id numeric(20,0) NOT NULL,
    name character varying(63 char),
    code character varying(64 char),
    nickname character varying(255 char),
    content nclob,
    type numeric(4,0),
    params character varying(255 char),
    status numeric(4,0),
    remark character varying(255 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_notify_template OWNER TO system;

--
-- TOC entry 769 (class 1259 OID 16802)
-- Name: system_notify_template_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_notify_template_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_notify_template_seq OWNER TO system;

--
-- TOC entry 727 (class 1259 OID 16632)
-- Name: system_oauth2_access_token; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_oauth2_access_token (
    id numeric(20,0),
    user_id_bak numeric(20,0),
    user_type numeric(4,0),
    access_token character varying(255 char),
    refresh_token character varying(32 char),
    client_id character varying(255 char),
    scopes character varying(255 char),
    expires_time date,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    user_id character varying(36 char)
);


ALTER TABLE ruian_oa.system_oauth2_access_token OWNER TO system;

--
-- TOC entry 770 (class 1259 OID 16804)
-- Name: system_oauth2_access_token_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_oauth2_access_token_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_oauth2_access_token_seq OWNER TO system;

--
-- TOC entry 728 (class 1259 OID 16639)
-- Name: system_oauth2_approve; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_oauth2_approve (
    id numeric(20,0) NOT NULL,
    user_id character varying(36 char),
    user_type numeric(4,0),
    client_id character varying(255 char),
    scope character varying(255 char),
    approved character varying(1 byte),
    expires_time date,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_oauth2_approve OWNER TO system;

--
-- TOC entry 771 (class 1259 OID 16806)
-- Name: system_oauth2_approve_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_oauth2_approve_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_oauth2_approve_seq OWNER TO system;

--
-- TOC entry 729 (class 1259 OID 16646)
-- Name: system_oauth2_client; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_oauth2_client (
    id numeric(20,0) NOT NULL,
    client_id character varying(255 char),
    secret character varying(255 char),
    name character varying(255 char),
    logo character varying(255 char),
    description character varying(255 char),
    status numeric(4,0),
    access_token_validity_seconds numeric(11,0),
    refresh_token_validity_seconds numeric(11,0),
    redirect_uris character varying(255 char),
    authorized_grant_types character varying(255 char),
    scopes character varying(255 char),
    auto_approve_scopes character varying(255 char),
    authorities character varying(255 char),
    resource_ids character varying(255 char),
    additional_information nclob,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_oauth2_client OWNER TO system;

--
-- TOC entry 772 (class 1259 OID 16808)
-- Name: system_oauth2_client_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_oauth2_client_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_oauth2_client_seq OWNER TO system;

--
-- TOC entry 730 (class 1259 OID 16653)
-- Name: system_oauth2_code; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_oauth2_code (
    id numeric(20,0) NOT NULL,
    user_id character varying(36 char),
    user_type numeric(4,0),
    code character varying(32 char),
    client_id character varying(255 char),
    scopes character varying(255 char),
    expires_time date,
    redirect_uri character varying(255 char),
    state character varying(255 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_oauth2_code OWNER TO system;

--
-- TOC entry 773 (class 1259 OID 16810)
-- Name: system_oauth2_code_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_oauth2_code_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_oauth2_code_seq OWNER TO system;

--
-- TOC entry 731 (class 1259 OID 16660)
-- Name: system_oauth2_refresh_token; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_oauth2_refresh_token (
    id numeric(20,0) NOT NULL,
    user_id_bak numeric(20,0),
    refresh_token character varying(32 char),
    user_type numeric(4,0),
    client_id character varying(255 char),
    scopes character varying(255 char),
    expires_time date,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    user_id character varying(36 char)
);


ALTER TABLE ruian_oa.system_oauth2_refresh_token OWNER TO system;

--
-- TOC entry 732 (class 1259 OID 16667)
-- Name: system_operate_log; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_operate_log (
    id numeric(20,0) NOT NULL,
    trace_id character varying(64 char) DEFAULT NULL::varchar,
    user_id_bak numeric(20,0),
    user_type numeric(4,0),
    module character varying(50 char),
    name character varying(50 char),
    type numeric(20,0),
    content nclob,
    exts character varying(512 char) DEFAULT NULL::varchar,
    request_method character varying(16 char),
    request_url character varying(255 char),
    user_ip character varying(50 char),
    user_agent character varying(512 char),
    java_method character varying(512 char),
    java_method_args nclob,
    start_time date,
    duration numeric(11,0),
    result_code numeric(11,0),
    result_msg character varying(512 char),
    result_data nclob,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    user_id character varying(36 char)
);


ALTER TABLE ruian_oa.system_operate_log OWNER TO system;

--
-- TOC entry 774 (class 1259 OID 16812)
-- Name: system_operate_log_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_operate_log_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_operate_log_seq OWNER TO system;

--
-- TOC entry 733 (class 1259 OID 16676)
-- Name: system_post; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_post (
    id numeric(20,0) NOT NULL,
    code character varying(64 char),
    name character varying(50 char),
    sort numeric(11,0),
    status numeric(4,0),
    remark character varying(500 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_post OWNER TO system;

--
-- TOC entry 775 (class 1259 OID 16814)
-- Name: system_post_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_post_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_post_seq OWNER TO system;

--
-- TOC entry 734 (class 1259 OID 16683)
-- Name: system_role; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_role (
    id numeric(20,0) NOT NULL,
    name character varying(30 char),
    code character varying(100 char),
    sort numeric(11,0),
    data_scope numeric(4,0),
    data_scope_dept_ids character varying(500 char),
    status numeric(4,0),
    type numeric(4,0),
    remark character varying(500 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    flow_ids character varying(2000 char)
);


ALTER TABLE ruian_oa.system_role OWNER TO system;

--
-- TOC entry 735 (class 1259 OID 16690)
-- Name: system_role_menu; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_role_menu (
    id numeric(20,0) NOT NULL,
    role_id numeric(20,0),
    menu_id numeric(20,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_role_menu OWNER TO system;

--
-- TOC entry 776 (class 1259 OID 16816)
-- Name: system_role_menu_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_role_menu_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_role_menu_seq OWNER TO system;

--
-- TOC entry 777 (class 1259 OID 16818)
-- Name: system_role_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_role_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_role_seq OWNER TO system;

--
-- TOC entry 736 (class 1259 OID 16695)
-- Name: system_sensitive_word; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_sensitive_word (
    id numeric(20,0),
    name character varying(255 char),
    description character varying(512 char),
    tags character varying(255 char),
    status numeric(4,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_sensitive_word OWNER TO system;

--
-- TOC entry 778 (class 1259 OID 16820)
-- Name: system_sensitive_word_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_sensitive_word_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_sensitive_word_seq OWNER TO system;

--
-- TOC entry 737 (class 1259 OID 16702)
-- Name: system_sms_channel; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_sms_channel (
    id numeric(20,0),
    signature character varying(12 char),
    code character varying(63 char),
    status numeric(4,0),
    remark character varying(255 char),
    api_key character varying(128 char),
    api_secret character varying(128 char),
    callback_url character varying(255 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_sms_channel OWNER TO system;

--
-- TOC entry 779 (class 1259 OID 16822)
-- Name: system_sms_channel_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_sms_channel_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_sms_channel_seq OWNER TO system;

--
-- TOC entry 738 (class 1259 OID 16709)
-- Name: system_sms_code; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_sms_code (
    id numeric(20,0),
    mobile character varying(11 char),
    code character varying(6 char),
    create_ip character varying(15 char),
    scene numeric(4,0),
    today_index numeric(4,0),
    used numeric(4,0),
    used_time date,
    used_ip character varying(255 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_sms_code OWNER TO system;

--
-- TOC entry 780 (class 1259 OID 16824)
-- Name: system_sms_code_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_sms_code_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_sms_code_seq OWNER TO system;

--
-- TOC entry 739 (class 1259 OID 16713)
-- Name: system_sms_log; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_sms_log (
    id numeric(20,0),
    channel_id numeric(20,0),
    channel_code character varying(63 char),
    template_id numeric(20,0),
    template_code character varying(63 char),
    template_type numeric(4,0),
    template_content character varying(255 char),
    template_params character varying(255 char),
    api_template_id character varying(63 char),
    mobile character varying(11 char),
    user_id numeric(20,0),
    user_type numeric(4,0),
    send_status numeric(4,0),
    send_time date,
    send_code numeric(11,0),
    send_msg character varying(255 char),
    api_send_code character varying(63 char),
    api_send_msg character varying(255 char),
    api_request_id character varying(255 char),
    api_serial_no character varying(255 char),
    receive_status numeric(4,0),
    receive_time date,
    api_receive_code character varying(63 char),
    api_receive_msg character varying(255 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_sms_log OWNER TO system;

--
-- TOC entry 781 (class 1259 OID 16826)
-- Name: system_sms_log_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_sms_log_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_sms_log_seq OWNER TO system;

--
-- TOC entry 740 (class 1259 OID 16720)
-- Name: system_sms_template; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_sms_template (
    id numeric(20,0),
    type numeric(4,0),
    status numeric(4,0),
    code character varying(63 char),
    name character varying(63 char),
    content character varying(255 char),
    params character varying(255 char),
    remark character varying(255 char),
    api_template_id character varying(63 char),
    channel_id numeric(20,0),
    channel_code character varying(63 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_sms_template OWNER TO system;

--
-- TOC entry 782 (class 1259 OID 16828)
-- Name: system_sms_template_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_sms_template_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_sms_template_seq OWNER TO system;

--
-- TOC entry 741 (class 1259 OID 16727)
-- Name: system_social_user; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_social_user (
    id numeric(20,0) NOT NULL,
    type numeric(4,0),
    openid character varying(32 char),
    token character varying(256 char),
    raw_token_info nclob,
    nickname character varying(32 char),
    avatar character varying(255 char),
    raw_user_info nclob,
    code character varying(256 char),
    state character varying(256 char),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0
);


ALTER TABLE ruian_oa.system_social_user OWNER TO system;

--
-- TOC entry 742 (class 1259 OID 16734)
-- Name: system_social_user_bind; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_social_user_bind (
    id numeric(20,0) NOT NULL,
    user_id_bak numeric(20,0),
    user_type numeric(4,0),
    social_type numeric(4,0),
    social_user_id numeric(20,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    user_id character varying(36 char)
);


ALTER TABLE ruian_oa.system_social_user_bind OWNER TO system;

--
-- TOC entry 783 (class 1259 OID 16830)
-- Name: system_social_user_bind_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_social_user_bind_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_social_user_bind_seq OWNER TO system;

--
-- TOC entry 784 (class 1259 OID 16832)
-- Name: system_social_user_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_social_user_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_social_user_seq OWNER TO system;

--
-- TOC entry 785 (class 1259 OID 16834)
-- Name: system_tenant_package_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_tenant_package_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_tenant_package_seq OWNER TO system;

--
-- TOC entry 786 (class 1259 OID 16836)
-- Name: system_tenant_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_tenant_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_tenant_seq OWNER TO system;

--
-- TOC entry 744 (class 1259 OID 16746)
-- Name: system_user_dept; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_user_dept (
    id numeric(20,0) NOT NULL,
    user_id_bak numeric(20,0),
    dept_id_bak numeric(20,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    dept_id character varying(36 char),
    user_id character varying(36 char)
);


ALTER TABLE ruian_oa.system_user_dept OWNER TO system;

--
-- TOC entry 787 (class 1259 OID 16838)
-- Name: system_user_dept_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_user_dept_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_user_dept_seq OWNER TO system;

--
-- TOC entry 745 (class 1259 OID 16750)
-- Name: system_user_post; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_user_post (
    id numeric(20,0) NOT NULL,
    user_id_bak numeric(20,0),
    post_id numeric(20,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    user_id character varying(36 char)
);


ALTER TABLE ruian_oa.system_user_post OWNER TO system;

--
-- TOC entry 788 (class 1259 OID 16840)
-- Name: system_user_post_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_user_post_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_user_post_seq OWNER TO system;

--
-- TOC entry 746 (class 1259 OID 16754)
-- Name: system_user_role; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_user_role (
    id numeric(20,0) NOT NULL,
    user_id_bak numeric(20,0),
    role_id numeric(20,0),
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    user_id character varying(36 char)
);


ALTER TABLE ruian_oa.system_user_role OWNER TO system;

--
-- TOC entry 789 (class 1259 OID 16842)
-- Name: system_user_role_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_user_role_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_user_role_seq OWNER TO system;

--
-- TOC entry 790 (class 1259 OID 16844)
-- Name: system_user_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_user_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_user_seq OWNER TO system;

--
-- TOC entry 747 (class 1259 OID 16758)
-- Name: system_user_session_seq; Type: SEQUENCE; Schema: ruian_oa; Owner: system
--

CREATE SEQUENCE ruian_oa.system_user_session_seq
    START WITH 0
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 99999
    CACHE 20;


ALTER TABLE ruian_oa.system_user_session_seq OWNER TO system;

--
-- TOC entry 743 (class 1259 OID 16738)
-- Name: system_users; Type: TABLE; Schema: ruian_oa; Owner: system
--

SET escape = off;
CREATE TABLE ruian_oa.system_users (
    username character varying(30 char),
    password character varying(100 char),
    nickname character varying(30 char),
    remark character varying(500 char),
    post_ids character varying(255 char),
    email character varying(50 char),
    mobile character varying(11 char),
    sex numeric(4,0),
    avatar character varying(512 char),
    status numeric(4,0),
    login_ip character varying(50 char),
    login_date date,
    creator character varying(64 char),
    create_time date,
    updater character varying(64 char),
    update_time date,
    deleted numeric(1,0) DEFAULT 0,
    tenant_id numeric(20,0),
    id character varying(36 char) NOT NULL,
    dept_ids character varying(512 char),
    dept_id character varying(36 char),
    dept_name character varying(128 char),
    signature_url character varying(512 char),
    attendance_flag numeric(1,0) DEFAULT 1
);


ALTER TABLE ruian_oa.system_users OWNER TO system;

--
-- TOC entry 6805 (class 0 OID 16391)
-- Dependencies: 697
-- Data for Name: infra_api_access_log; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6806 (class 0 OID 16400)
-- Dependencies: 698
-- Data for Name: infra_api_error_log; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.infra_api_error_log VALUES (0, NULL, NULL, 2, 'system-server', 'POST', '/admin-api/system/oauth2/token', '{"query":{"password":"admin123","grant_type":"password","scope":"user.read user.write","client_secret":"admin123","client_id":"default","username":"admin"},"body":""}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:06:49', 'org.springframework.beans.factory.NoSuchBeanDefinitionException', 'NoSuchBeanDefinitionException: No qualifying bean of type ''org.springframework.transaction.TransactionManager'' available', 'NoSuchBeanDefinitionException: No qualifying bean of type ''org.springframework.transaction.TransactionManager'' available', 'org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type ''org.springframework.transaction.TransactionManager'' available
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:351)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:342)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.determineTransactionManager(TransactionAspectSupport.java:503)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:342)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
	at com.zjugis.module.system.service.oauth2.OAuth2TokenServiceImpl$$EnhancerBySpringCGLIB$$9d4d583.createAccessToken(<generated>)
	at com.zjugis.module.system.service.oauth2.OAuth2GrantServiceImpl.grantPassword(OAuth2GrantServiceImpl.java:79)
	at com.zjugis.module.system.controller.admin.oauth2.OAuth2OpenController.postAccessToken(OAuth2OpenController.java:130)
	at com.zjugis.module.system.controller.admin.oauth2.OAuth2OpenController$$FastClassBySpringCGLIB$$188afcf5.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.zjugis.framework.operatelog.core.aop.OperateLogAspect.around0(OperateLogAspect.java:101)
	at com.zjugis.framework.operatelog.core.aop.OperateLogAspect.around(OperateLogAspect.java:78)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.asp', 'org.springframework.beans.factory.support.DefaultListableBeanFactory', 'DefaultListableBeanFactory.java', 'getBean', 351, 0, NULL, NULL, NULL, '2024-10-23 11:06:57', NULL, '2024-10-23 11:06:57', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (1, NULL, NULL, 2, 'system-server', 'POST', '/admin-api/system/oauth2/token', '{"query":{"password":"admin123","grant_type":"password","scope":"user.read user.write","client_secret":"admin123","client_id":"default","username":"admin"},"body":""}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:14:44', 'org.springframework.beans.factory.NoSuchBeanDefinitionException', 'NoSuchBeanDefinitionException: No qualifying bean of type ''org.springframework.transaction.TransactionManager'' available', 'NoSuchBeanDefinitionException: No qualifying bean of type ''org.springframework.transaction.TransactionManager'' available', 'org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type ''org.springframework.transaction.TransactionManager'' available
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:351)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:342)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.determineTransactionManager(TransactionAspectSupport.java:503)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:342)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
	at com.zjugis.module.system.service.oauth2.OAuth2TokenServiceImpl$$EnhancerBySpringCGLIB$$aacfdcae.createAccessToken(<generated>)
	at com.zjugis.module.system.service.oauth2.OAuth2GrantServiceImpl.grantPassword(OAuth2GrantServiceImpl.java:79)
	at com.zjugis.module.system.controller.admin.oauth2.OAuth2OpenController.postAccessToken(OAuth2OpenController.java:130)
	at com.zjugis.module.system.controller.admin.oauth2.OAuth2OpenController$$FastClassBySpringCGLIB$$188afcf5.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.zjugis.framework.operatelog.core.aop.OperateLogAspect.around0(OperateLogAspect.java:101)
	at com.zjugis.framework.operatelog.core.aop.OperateLogAspect.around(OperateLogAspect.java:78)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.as', 'org.springframework.beans.factory.support.DefaultListableBeanFactory', 'DefaultListableBeanFactory.java', 'getBean', 351, 0, NULL, NULL, NULL, '2024-10-23 11:14:44', NULL, '2024-10-23 11:14:44', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (2, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/notify-message/get-unread-count', '{"query":{},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:18:45', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectCount(Unknown Source)
	at com.zjugis.module.system.dal.mysql.notify.NotifyMessageMapper.selectUnreadCountByUserIdAndUserType(NotifyMessageMapper.java:64)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectUnreadCountByUserIdAndUserType(Unknown Source)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl.getUnreadNotifyMessageCount(NotifyMessageServiceImpl.java:62)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl$$FastClassBySpringCGLIB$$f65b8551.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMet', 'org.springframework.jdbc.support.SQLStateSQLExceptionTranslator', 'SQLStateSQLExceptionTranslator.java', 'doTranslate', 101, 0, NULL, NULL, '1', '2024-10-23 11:18:45', '1', '2024-10-23 11:18:45', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (3, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/user/page', '{"query":{"pageNo":"1","deptId":"100","pageSize":"10","status":"0"},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:18:57', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130
### The error may exist in com/zjugis/module/system/dal/mysql/dept/DeptMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT    id,name,parent_id,sort,leader_user_id,phone,email,status,code,create_time,update_time,creator,updater,deleted    FROM  system_dept     WHERE deleted=0     AND (parent_id IN (?))
### Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130', 'PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130
### The error may exist in com/zjugis/module/system/dal/mysql/dept/DeptMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT    id,name,parent_id,sort,leader_user_id,phone,email,status,code,create_time,update_time,creator,updater,deleted    FROM  system_dept     WHERE deleted=0     AND (parent_id IN (?))
### Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy210.selectList(Unknown Source)
	at com.zjugis.framework.mybatis.core.mapper.BaseMapperX.selectList(BaseMapperX.java:83)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy210.selectList(Unknown Source)
	at com.zjugis.module.system.dal.mysql.dept.DeptMapper.selectListByParentId(DeptMapper.java:31)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy210.selectListByParentId(Unknown Source)
	at com.zjugis.module.system.service.dept.DeptServiceImpl.getChildDeptList(DeptServiceImpl.java:196)
	at com.zjugis.module.system.service.dept.DeptServiceImpl$$FastClassBySpringCGLIB$$49188932.invoke(<generated>)
	at org.springframework.cglib.p', 'org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator', 'SQLErrorCodeSQLExceptionTranslator.java', 'doTranslate', 239, 0, NULL, NULL, '1', '2024-10-23 11:18:57', '1', '2024-10-23 11:18:57', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (4, NULL, '1', 2, 'system-server', 'GET', '/rpc-api/system/permission/has-any-permissions', '{"query":{"permissions":"system:role:query","userId":"1"},"body":""}', '2.0.0.1', 'Java/1.8.0_91', '2024-10-23 11:19:27', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_menu" 不存在
  位置：180
### The error may exist in com/zjugis/module/system/dal/mysql/permission/MenuMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT    id,name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show,create_time,update_time,creator,updater,deleted    FROM  system_menu     WHERE deleted=0     AND (permission = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_menu" 不存在
  位置：180
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 关系 "system_menu" 不存在
  位置：180', 'PSQLException: ERROR: 关系 "system_menu" 不存在
  位置：180', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_menu" 不存在
  位置：180
### The error may exist in com/zjugis/module/system/dal/mysql/permission/MenuMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT    id,name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show,create_time,update_time,creator,updater,deleted    FROM  system_menu     WHERE deleted=0     AND (permission = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_menu" 不存在
  位置：180
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 关系 "system_menu" 不存在
  位置：180
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy229.selectList(Unknown Source)
	at com.zjugis.framework.mybatis.core.mapper.BaseMapperX.selectList(BaseMapperX.java:69)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy229.selectList(Unknown Source)
	at com.zjugis.module.system.dal.mysql.permission.MenuMapper.selectListByPermission(MenuMapper.java:29)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy229.selectListByPermission(Unknown Source)
	at com.zjugis.module.system.service.permission.MenuServiceImpl.getMenuIdListByPermissionFromCache(MenuServiceImpl.java:119)
	at com.zjugis.module.system.service.permission.MenuServ', 'org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator', 'SQLErrorCodeSQLExceptionTranslator.java', 'doTranslate', 239, 0, NULL, NULL, '1', '2024-10-23 11:19:27', '1', '2024-10-23 11:19:27', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (5, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/role/page', '{"query":{"code":"","pageNo":"1","name":"","pageSize":"10"},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:19:27', 'com.google.common.util.concurrent.UncheckedExecutionException', 'UncheckedExecutionException: ServiceException(super=com.zjugis.framework.common.exception.ServiceException: 系统异常, code=500, message=系统异常)', 'ServiceException: 系统异常', 'com.google.common.util.concurrent.UncheckedExecutionException: ServiceException(super=com.zjugis.framework.common.exception.ServiceException: 系统异常, code=500, message=系统异常)
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2085)
	at com.google.common.cache.LocalCache.get(LocalCache.java:4011)
	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4034)
	at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5010)
	at com.zjugis.framework.security.core.service.SecurityFrameworkServiceImpl.hasAnyPermissions(SecurityFrameworkServiceImpl.java:71)
	at com.zjugis.framework.security.core.service.SecurityFrameworkServiceImpl.hasPermission(SecurityFrameworkServiceImpl.java:65)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.expression.spel.support.ReflectiveMethodExecutor.execute(ReflectiveMethodExecutor.java:139)
	at org.springframework.expression.spel.ast.MethodReference.getValueInternal(MethodReference.java:139)
	at org.springframework.expression.spel.ast.MethodReference.access$000(MethodReference.java:55)
	at org.springframework.expression.spel.ast.MethodReference$MethodValueRef.getValue(MethodReference.java:383)
	at org.springframework.expression.spel.ast.CompoundExpression.getValueInternal(CompoundExpression.java:93)
	at org.springframework.expression.spel.ast.SpelNodeImpl.getTypedValue(SpelNodeImpl.java:119)
	at org.springframework.expression.spel.standard.SpelExpression.getValue(SpelExpression.java:309)
	at org.springframework.security.access.expression.ExpressionUtils.evaluateAsBoolean(ExpressionUtils.java:30)
	at org.springframework.security.access.expression.method.ExpressionBasedPreInvocationAdvice.before(ExpressionBasedPreInvocationAdvice.java:51)
	at org.springframework.security.access.prepost.PreInvocationAuthorizationAdviceVoter.vote(PreInvocationAuthorizationAdviceVoter.java:71)
	at org.springframework.security.access.prepost.PreInvocationAuthorizationAdviceVoter.vote(PreInvocationAuthorizationAdviceVoter.java:42)
	at org.springframework.security.access.vote.AffirmativeBased.decide(AffirmativeBased.java:60)
	at org.springframework.security.access.intercept.AbstractSecurityInterceptor.attemptAuthorization(AbstractSecurityInterceptor.java:239)
	at org.springframework.security.access.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:208)
	at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:58)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java', 'com.google.common.cache.LocalCache$Segment', 'LocalCache.java', 'get', 2085, 0, NULL, NULL, '1', '2024-10-23 11:19:27', '1', '2024-10-23 11:19:27', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (6, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/dept/list-all-simple', '{"query":{},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:19:48', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130
### The error may exist in com/zjugis/module/system/dal/mysql/dept/DeptMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT    id,name,parent_id,sort,leader_user_id,phone,email,status,code,create_time,update_time,creator,updater,deleted    FROM  system_dept     WHERE deleted=0     AND (status = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130', 'PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130
### The error may exist in com/zjugis/module/system/dal/mysql/dept/DeptMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT    id,name,parent_id,sort,leader_user_id,phone,email,status,code,create_time,update_time,creator,updater,deleted    FROM  system_dept     WHERE deleted=0     AND (status = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 关系 "system_dept" 不存在
  位置：130
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy210.selectList(Unknown Source)
	at com.zjugis.module.system.dal.mysql.dept.DeptMapper.selectList(DeptMapper.java:16)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy210.selectList(Unknown Source)
	at com.zjugis.module.system.service.dept.DeptServiceImpl.getDeptList(DeptServiceImpl.java:186)
	at com.zjugis.module.system.service.dept.DeptServiceImpl$$FastClassBySpringCGLIB$$49188932.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodVa', 'org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator', 'SQLErrorCodeSQLExceptionTranslator.java', 'doTranslate', 239, 0, NULL, NULL, '1', '2024-10-23 11:19:48', '1', '2024-10-23 11:19:48', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (7, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/user/page', '{"query":{"pageNo":"1","pageSize":"10","status":"0"},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:19:48', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_users" 不存在
  位置：31
### The error may exist in com/zjugis/module/system/dal/mysql/user/AdminUserMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) AS total FROM system_users WHERE deleted = 0 AND (status = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_users" 不存在
  位置：31
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 关系 "system_users" 不存在
  位置：31', 'PSQLException: ERROR: 关系 "system_users" 不存在
  位置：31', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_users" 不存在
  位置：31
### The error may exist in com/zjugis/module/system/dal/mysql/user/AdminUserMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) AS total FROM system_users WHERE deleted = 0 AND (status = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_users" 不存在
  位置：31
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 关系 "system_users" 不存在
  位置：31
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy212.selectList(Unknown Source)
	at com.baomidou.mybatisplus.core.mapper.BaseMapper.selectPage(BaseMapper.java:272)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy212.selectPage(Unknown Source)
	at com.zjugis.framework.mybatis.core.mapper.BaseMapperX.selectPage(BaseMapperX.java:27)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy212.selectPage(Unknown Source)
	at com.zjugis.module.system.dal.mysql.user.AdminUserMapper.selectPage(AdminUserMapper.java:52)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMa', 'org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator', 'SQLErrorCodeSQLExceptionTranslator.java', 'doTranslate', 239, 0, NULL, NULL, '1', '2024-10-23 11:19:48', '1', '2024-10-23 11:19:48', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (8, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/dict-type/page', '{"query":{"pageNo":"1","name":"","pageSize":"10","type":""},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:19:56', 'com.google.common.util.concurrent.UncheckedExecutionException', 'UncheckedExecutionException: ServiceException(super=com.zjugis.framework.common.exception.ServiceException: 系统异常, code=500, message=系统异常)', 'ServiceException: 系统异常', 'com.google.common.util.concurrent.UncheckedExecutionException: ServiceException(super=com.zjugis.framework.common.exception.ServiceException: 系统异常, code=500, message=系统异常)
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2085)
	at com.google.common.cache.LocalCache.get(LocalCache.java:4011)
	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4034)
	at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5010)
	at com.zjugis.framework.security.core.service.SecurityFrameworkServiceImpl.hasAnyPermissions(SecurityFrameworkServiceImpl.java:71)
	at com.zjugis.framework.security.core.service.SecurityFrameworkServiceImpl.hasPermission(SecurityFrameworkServiceImpl.java:65)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.expression.spel.support.ReflectiveMethodExecutor.execute(ReflectiveMethodExecutor.java:139)
	at org.springframework.expression.spel.ast.MethodReference.getValueInternal(MethodReference.java:139)
	at org.springframework.expression.spel.ast.MethodReference.access$000(MethodReference.java:55)
	at org.springframework.expression.spel.ast.MethodReference$MethodValueRef.getValue(MethodReference.java:383)
	at org.springframework.expression.spel.ast.CompoundExpression.getValueInternal(CompoundExpression.java:93)
	at org.springframework.expression.spel.ast.SpelNodeImpl.getTypedValue(SpelNodeImpl.java:119)
	at org.springframework.expression.spel.standard.SpelExpression.getValue(SpelExpression.java:309)
	at org.springframework.security.access.expression.ExpressionUtils.evaluateAsBoolean(ExpressionUtils.java:30)
	at org.springframework.security.access.expression.method.ExpressionBasedPreInvocationAdvice.before(ExpressionBasedPreInvocationAdvice.java:51)
	at org.springframework.security.access.prepost.PreInvocationAuthorizationAdviceVoter.vote(PreInvocationAuthorizationAdviceVoter.java:71)
	at org.springframework.security.access.prepost.PreInvocationAuthorizationAdviceVoter.vote(PreInvocationAuthorizationAdviceVoter.java:42)
	at org.springframework.security.access.vote.AffirmativeBased.decide(AffirmativeBased.java:60)
	at org.springframework.security.access.intercept.AbstractSecurityInterceptor.attemptAuthorization(AbstractSecurityInterceptor.java:239)
	at org.springframework.security.access.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:208)
	at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:58)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java', 'com.google.common.cache.LocalCache$Segment', 'LocalCache.java', 'get', 2085, 0, NULL, NULL, '1', '2024-10-23 11:19:56', '1', '2024-10-23 11:19:56', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (9, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/notify-message/get-unread-count', '{"query":{},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:33:21', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectCount(Unknown Source)
	at com.zjugis.module.system.dal.mysql.notify.NotifyMessageMapper.selectUnreadCountByUserIdAndUserType(NotifyMessageMapper.java:64)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectUnreadCountByUserIdAndUserType(Unknown Source)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl.getUnreadNotifyMessageCount(NotifyMessageServiceImpl.java:62)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl$$FastClassBySpringCGLIB$$f65b8551.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMet', 'org.springframework.jdbc.support.SQLStateSQLExceptionTranslator', 'SQLStateSQLExceptionTranslator.java', 'doTranslate', 101, 0, NULL, NULL, '1', '2024-10-23 11:33:22', '1', '2024-10-23 11:33:22', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (10, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/notify-message/get-unread-count', '{"query":{},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:35:21', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectCount(Unknown Source)
	at com.zjugis.module.system.dal.mysql.notify.NotifyMessageMapper.selectUnreadCountByUserIdAndUserType(NotifyMessageMapper.java:64)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectUnreadCountByUserIdAndUserType(Unknown Source)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl.getUnreadNotifyMessageCount(NotifyMessageServiceImpl.java:62)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl$$FastClassBySpringCGLIB$$f65b8551.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMet', 'org.springframework.jdbc.support.SQLStateSQLExceptionTranslator', 'SQLStateSQLExceptionTranslator.java', 'doTranslate', 101, 0, NULL, NULL, '1', '2024-10-23 11:35:21', '1', '2024-10-23 11:35:21', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (11, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/notify-message/get-unread-count', '{"query":{},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 11:37:21', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectCount(Unknown Source)
	at com.zjugis.module.system.dal.mysql.notify.NotifyMessageMapper.selectUnreadCountByUserIdAndUserType(NotifyMessageMapper.java:64)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectUnreadCountByUserIdAndUserType(Unknown Source)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl.getUnreadNotifyMessageCount(NotifyMessageServiceImpl.java:62)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl$$FastClassBySpringCGLIB$$f65b8551.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMet', 'org.springframework.jdbc.support.SQLStateSQLExceptionTranslator', 'SQLStateSQLExceptionTranslator.java', 'doTranslate', 101, 0, NULL, NULL, '1', '2024-10-23 11:37:21', '1', '2024-10-23 11:37:21', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (12, NULL, NULL, 2, 'system-server', 'GET', '/rpc-api/system/oauth2/token/check', '{"query":{"accessToken":"2dc53edf7bf84c7da0e08f2ed95f44af"},"body":""}', '2.0.0.1', 'ReactorNetty/1.0.35', '2024-10-23 11:39:21', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_oauth2_access_token" 不存在
  位置：146
### The error may exist in com/zjugis/module/system/dal/mysql/oauth2/OAuth2AccessTokenMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT    id,access_token,refresh_token,user_id,user_type,client_id,scopes,expires_time,create_time,update_time,creator,updater,deleted    FROM  system_oauth2_access_token     WHERE deleted=0     AND (access_token = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_oauth2_access_token" 不存在
  位置：146
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 关系 "system_oauth2_access_token" 不存在
  位置：146', 'PSQLException: ERROR: 关系 "system_oauth2_access_token" 不存在
  位置：146', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_oauth2_access_token" 不存在
  位置：146
### The error may exist in com/zjugis/module/system/dal/mysql/oauth2/OAuth2AccessTokenMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT    id,access_token,refresh_token,user_id,user_type,client_id,scopes,expires_time,create_time,update_time,creator,updater,deleted    FROM  system_oauth2_access_token     WHERE deleted=0     AND (access_token = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 关系 "system_oauth2_access_token" 不存在
  位置：146
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 关系 "system_oauth2_access_token" 不存在
  位置：146
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy259.selectList(Unknown Source)
	at com.baomidou.mybatisplus.core.mapper.BaseMapper.selectOne(BaseMapper.java:191)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy259.selectOne(Unknown Source)
	at com.baomidou.mybatisplus.core.mapper.BaseMapper.selectOne(BaseMapper.java:180)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy259.selectOne(Unknown Source)
	at com.zjugis.framework.mybatis.core.mapper.BaseMapperX.selectOne(BaseMapperX.java:37)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.my', 'org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator', 'SQLErrorCodeSQLExceptionTranslator.java', 'doTranslate', 239, 0, NULL, NULL, NULL, '2024-10-23 11:39:21', NULL, '2024-10-23 11:39:21', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (13, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/notify-message/get-unread-count', '{"query":{},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 14:12:43', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectCount(Unknown Source)
	at com.zjugis.module.system.dal.mysql.notify.NotifyMessageMapper.selectUnreadCountByUserIdAndUserType(NotifyMessageMapper.java:64)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectUnreadCountByUserIdAndUserType(Unknown Source)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl.getUnreadNotifyMessageCount(NotifyMessageServiceImpl.java:62)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl$$FastClassBySpringCGLIB$$f65b8551.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMet', 'org.springframework.jdbc.support.SQLStateSQLExceptionTranslator', 'SQLStateSQLExceptionTranslator.java', 'doTranslate', 101, 0, NULL, NULL, '1', '2024-10-23 14:12:45', '1', '2024-10-23 14:12:45', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (14, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/notify-message/get-unread-count', '{"query":{},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 14:16:53', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectCount(Unknown Source)
	at com.zjugis.module.system.dal.mysql.notify.NotifyMessageMapper.selectUnreadCountByUserIdAndUserType(NotifyMessageMapper.java:64)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectUnreadCountByUserIdAndUserType(Unknown Source)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl.getUnreadNotifyMessageCount(NotifyMessageServiceImpl.java:62)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl$$FastClassBySpringCGLIB$$f65b8551.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMet', 'org.springframework.jdbc.support.SQLStateSQLExceptionTranslator', 'SQLStateSQLExceptionTranslator.java', 'doTranslate', 101, 0, NULL, NULL, '1', '2024-10-23 14:16:53', '1', '2024-10-23 14:16:53', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (15, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/notify-message/get-unread-count', '{"query":{},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 14:18:53', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectCount(Unknown Source)
	at com.zjugis.module.system.dal.mysql.notify.NotifyMessageMapper.selectUnreadCountByUserIdAndUserType(NotifyMessageMapper.java:64)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectUnreadCountByUserIdAndUserType(Unknown Source)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl.getUnreadNotifyMessageCount(NotifyMessageServiceImpl.java:62)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl$$FastClassBySpringCGLIB$$f65b8551.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMet', 'org.springframework.jdbc.support.SQLStateSQLExceptionTranslator', 'SQLStateSQLExceptionTranslator.java', 'doTranslate', 101, 0, NULL, NULL, '1', '2024-10-23 14:18:53', '1', '2024-10-23 14:18:53', NULL, 0);
INSERT INTO ruian_oa.infra_api_error_log VALUES (16, NULL, '1', 2, 'system-server', 'GET', '/admin-api/system/notify-message/get-unread-count', '{"query":{},"body":""}', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '2024-10-23 14:20:53', 'org.springframework.jdbc.BadSqlGrammarException', 'BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97', 'org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
### The error may exist in com/zjugis/module/system/dal/mysql/notify/NotifyMessageMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT( * ) AS total FROM  system_notify_message     WHERE deleted=0     AND (read_status = ? AND user_id = ? AND user_type = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: 操作符不是唯一的: varcharbyte = boolean
  建议：无法选择最佳候选操作符. 您也许需要增加显式的类型转换.
  位置：97
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
	at com.sun.proxy.$Proxy201.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectCount(Unknown Source)
	at com.zjugis.module.system.dal.mysql.notify.NotifyMessageMapper.selectUnreadCountByUserIdAndUserType(NotifyMessageMapper.java:64)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy257.selectUnreadCountByUserIdAndUserType(Unknown Source)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl.getUnreadNotifyMessageCount(NotifyMessageServiceImpl.java:62)
	at com.zjugis.module.system.service.notify.NotifyMessageServiceImpl$$FastClassBySpringCGLIB$$f65b8551.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMet', 'org.springframework.jdbc.support.SQLStateSQLExceptionTranslator', 'SQLStateSQLExceptionTranslator.java', 'doTranslate', 101, 0, NULL, NULL, '1', '2024-10-23 14:20:53', '1', '2024-10-23 14:20:53', NULL, 0);


--
-- TOC entry 6807 (class 0 OID 16407)
-- Dependencies: 699
-- Data for Name: infra_codegen_column; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6808 (class 0 OID 16414)
-- Dependencies: 700
-- Data for Name: infra_codegen_table; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6809 (class 0 OID 16421)
-- Dependencies: 701
-- Data for Name: infra_config; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.infra_config VALUES (1, 'ui', 1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 0, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow', 'admin', '2021-01-05 17:03:48', '1', '2022-03-26 23:10:31', 0);
INSERT INTO ruian_oa.infra_config VALUES (2, 'biz', 1, '用户管理-账号初始密码', 'sys.user.init-password', '123456', 0, '初始化密码 123456', 'admin', '2021-01-05 17:03:48', '1', '2022-03-20 02:25:51', 0);
INSERT INTO ruian_oa.infra_config VALUES (3, 'ui', 1, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 0, '深色主题theme-dark，浅色主题theme-light', 'admin', '2021-01-05 17:03:48', NULL, '2021-01-19 03:05:21', 0);
INSERT INTO ruian_oa.infra_config VALUES (4, '1', 2, 'xxx', 'demo.test', '10', 0, '5', NULL, '2021-01-19 03:10:26', NULL, '2021-01-20 09:25:55', 0);
INSERT INTO ruian_oa.infra_config VALUES (5, 'xxx', 2, 'xxx', 'xxx', 'xxx', 1, 'xxx', NULL, '2021-02-09 20:06:47', NULL, '2021-02-09 20:06:47', 0);
INSERT INTO ruian_oa.infra_config VALUES (6, 'biz', 2, '登陆验证码的开关', 'zjugis.captcha.enable', 'true', 1, NULL, '1', '2022-02-17 00:03:11', '1', '2022-04-04 12:51:40', 0);


--
-- TOC entry 6810 (class 0 OID 16428)
-- Dependencies: 702
-- Data for Name: infra_data_source_config; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6811 (class 0 OID 16435)
-- Dependencies: 703
-- Data for Name: infra_file; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6812 (class 0 OID 16442)
-- Dependencies: 704
-- Data for Name: infra_file_config; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.infra_file_config VALUES (4, '数据库', 1, '我是数据库', 1, '{"@class":"com.zjugis.framework.file.core.client.db.DBFileClientConfig","domain":"http://127.0.0.1:48080"}', '1', '2022-03-15 23:56:24', '1', '2022-03-26 21:39:26', 0);
INSERT INTO ruian_oa.infra_file_config VALUES (5, '本地磁盘', 10, '测试下本地存储', 0, '{"@class":"com.zjugis.framework.file.core.client.local.LocalFileClientConfig","basePath":"/Users/yunai/file_test","domain":"http://127.0.0.1:48080"}', '1', '2022-03-15 23:57:00', '1', '2022-03-26 21:39:26', 0);
INSERT INTO ruian_oa.infra_file_config VALUES (11, 'S3 - 七牛云', 20, NULL, 0, '{"@class":"com.zjugis.framework.file.core.client.s3.S3FileClientConfig","endpoint":"s3-cn-south-1.qiniucs.com","domain":"http://test.zjugis.iocoder.cn","bucket":"ruoyi-vue-pro","accessKey":"b7yvuhBSAGjmtPhMFcn9iMOxUOY_I06cA_p0ZUx8","accessSecret":"kXM1l5ia1RvSX3QaOEcwI3RLz3Y2rmNszWonKZtP"}', '1', '2022-03-19 18:00:03', '1', '2022-05-26 00:03:47', 0);


--
-- TOC entry 6813 (class 0 OID 16449)
-- Dependencies: 705
-- Data for Name: infra_file_content; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6814 (class 0 OID 16456)
-- Dependencies: 706
-- Data for Name: infra_job; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6815 (class 0 OID 16463)
-- Dependencies: 707
-- Data for Name: infra_job_log; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6816 (class 0 OID 16470)
-- Dependencies: 708
-- Data for Name: infra_msg_send_record; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6817 (class 0 OID 16476)
-- Dependencies: 709
-- Data for Name: infra_test_demo; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6818 (class 0 OID 16483)
-- Dependencies: 710
-- Data for Name: message_info; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6819 (class 0 OID 16531)
-- Dependencies: 711
-- Data for Name: system_area; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6820 (class 0 OID 16534)
-- Dependencies: 712
-- Data for Name: system_company; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6821 (class 0 OID 16539)
-- Dependencies: 713
-- Data for Name: system_dept; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_dept VALUES ('103', '研发部门', NULL, 1, '104', '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', '103', '2022-01-14 01:04:14', 0, '101', NULL, NULL);
INSERT INTO ruian_oa.system_dept VALUES ('104', '市场部门', NULL, 2, NULL, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', NULL, '2021-12-15 05:01:38', 0, '101', NULL, NULL);
INSERT INTO ruian_oa.system_dept VALUES ('105', '测试部门', NULL, 3, NULL, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', NULL, '2021-12-15 05:01:37', 0, '101', NULL, NULL);
INSERT INTO ruian_oa.system_dept VALUES ('106', '财务部门', NULL, 4, '103', '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', '103', '2022-01-15 21:32:22', 0, '101', NULL, NULL);
INSERT INTO ruian_oa.system_dept VALUES ('107', '运维部门', NULL, 5, NULL, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', NULL, '2021-12-15 05:01:33', 0, '101', NULL, NULL);
INSERT INTO ruian_oa.system_dept VALUES ('108', '市场部门', NULL, 1, NULL, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', '1', '2022-02-16 08:35:45', 1, '102', NULL, NULL);
INSERT INTO ruian_oa.system_dept VALUES ('109', '财务部门', NULL, 2, NULL, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', NULL, '2021-12-15 05:01:29', 1, '102', NULL, NULL);
INSERT INTO ruian_oa.system_dept VALUES ('102', '长沙分公司', NULL, 2, NULL, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', NULL, '2021-12-15 05:01:40', 1, '100', NULL, NULL);
INSERT INTO ruian_oa.system_dept VALUES ('101', '分公司', NULL, 1, '104', '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', '1', '2024-10-23 14:30:45', 0, '100', NULL, NULL);
INSERT INTO ruian_oa.system_dept VALUES ('100', '顶级部门', NULL, 0, NULL, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', '1', '2024-10-23 14:30:54', 0, '0', NULL, NULL);


--
-- TOC entry 6822 (class 0 OID 16543)
-- Dependencies: 714
-- Data for Name: system_dept_leader; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_dept_leader VALUES ('52a8b7c92c26d64518374303f204c99b', '101', NULL, '1', '2024-10-23 14:30:45', '1', '2024-10-23 14:30:45', 0);
INSERT INTO ruian_oa.system_dept_leader VALUES ('2b16b8bfe5cbcbb3c4c8a8a590279904', '100', NULL, '1', '2024-10-23 14:30:26', '1', '2024-10-23 14:30:26', 0);


--
-- TOC entry 6823 (class 0 OID 16547)
-- Dependencies: 715
-- Data for Name: system_dict_data; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_dict_data VALUES (1, 1, '男', '1', 'system_user_sex', 0, 'default', 'A', '性别男', 'admin', '2021-01-05 17:03:48', '1', '2022-03-29 00:14:39', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (2, 2, '女', '2', 'system_user_sex', 1, 'success', NULL, '性别女', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 01:30:51', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (8, 1, '正常', '1', 'infra_job_status', 0, 'success', NULL, '正常状态', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 19:33:38', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (9, 2, '暂停', '2', 'infra_job_status', 0, 'danger', NULL, '停用状态', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 19:33:45', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (12, 1, '系统内置', '1', 'infra_config_type', 0, 'danger', NULL, '参数类型 - 系统内置', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 19:06:02', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (13, 2, '自定义', '2', 'infra_config_type', 0, 'primary', NULL, '参数类型 - 自定义', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 19:06:07', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (14, 1, '通知', '1', 'system_notice_type', 0, 'success', NULL, '通知', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 13:05:57', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (15, 2, '公告', '2', 'system_notice_type', 0, 'info', NULL, '公告', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 13:06:01', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (16, 0, '其它', '0', 'system_operate_type', 0, 'default', NULL, '其它操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:32:46', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (17, 1, '查询', '1', 'system_operate_type', 0, 'info', NULL, '查询操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:16', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (18, 2, '新增', '2', 'system_operate_type', 0, 'primary', NULL, '新增操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:13', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (19, 3, '修改', '3', 'system_operate_type', 0, 'warning', NULL, '修改操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:22', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (20, 4, '删除', '4', 'system_operate_type', 0, 'danger', NULL, '删除操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:27', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (22, 5, '导出', '5', 'system_operate_type', 0, 'default', NULL, '导出操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:32', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (23, 6, '导入', '6', 'system_operate_type', 0, 'default', NULL, '导入操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:35', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (27, 1, '开启', '0', 'common_status', 0, 'primary', NULL, '开启状态', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 08:00:39', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (28, 2, '关闭', '1', 'common_status', 0, 'info', NULL, '关闭状态', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 08:00:44', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (29, 1, '目录', '1', 'system_menu_type', 0, NULL, NULL, '目录', 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:43:45', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (30, 2, '菜单', '2', 'system_menu_type', 0, NULL, NULL, '菜单', 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:43:41', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (31, 3, '按钮', '3', 'system_menu_type', 0, NULL, NULL, '按钮', 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:43:39', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (32, 1, '内置', '1', 'system_role_type', 0, 'danger', NULL, '内置角色', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 13:02:08', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (33, 2, '自定义', '2', 'system_role_type', 0, 'primary', NULL, '自定义角色', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 13:02:12', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (34, 1, '全部数据权限', '1', 'system_data_scope', 0, NULL, NULL, '全部数据权限', 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:47:17', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (35, 2, '指定部门数据权限', '2', 'system_data_scope', 0, NULL, NULL, '指定部门数据权限', 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:47:18', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (36, 3, '本部门数据权限', '3', 'system_data_scope', 0, NULL, NULL, '本部门数据权限', 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:47:16', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (37, 4, '本部门及以下数据权限', '4', 'system_data_scope', 0, NULL, NULL, '本部门及以下数据权限', 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:47:21', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (38, 5, '仅本人数据权限', '5', 'system_data_scope', 0, NULL, NULL, '仅本人数据权限', 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:47:23', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (39, 0, '成功', '0', 'system_login_result', 0, 'success', NULL, '登陆结果 - 成功', NULL, '2021-01-18 06:17:36', '1', '2022-02-16 13:23:49', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (40, 10, '账号或密码不正确', '10', 'system_login_result', 0, 'primary', NULL, '登陆结果 - 账号或密码不正确', NULL, '2021-01-18 06:17:54', '1', '2022-02-16 13:24:27', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (41, 20, '用户被禁用', '20', 'system_login_result', 0, 'warning', NULL, '登陆结果 - 用户被禁用', NULL, '2021-01-18 06:17:54', '1', '2022-02-16 13:23:57', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (42, 30, '验证码不存在', '30', 'system_login_result', 0, 'info', NULL, '登陆结果 - 验证码不存在', NULL, '2021-01-18 06:17:54', '1', '2022-02-16 13:24:07', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (43, 31, '验证码不正确', '31', 'system_login_result', 0, 'info', NULL, '登陆结果 - 验证码不正确', NULL, '2021-01-18 06:17:54', '1', '2022-02-16 13:24:11', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (44, 100, '未知异常', '100', 'system_login_result', 0, 'danger', NULL, '登陆结果 - 未知异常', NULL, '2021-01-18 06:17:54', '1', '2022-02-16 13:24:23', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (45, 1, '是', 'true', 'infra_boolean_string', 0, 'danger', NULL, 'Boolean 是否类型 - 是', NULL, '2021-01-19 03:20:55', '1', '2022-03-15 23:01:45', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (46, 1, '否', 'false', 'infra_boolean_string', 0, 'info', NULL, 'Boolean 是否类型 - 否', NULL, '2021-01-19 03:20:55', '1', '2022-03-15 23:09:45', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (47, 1, '永不超时', '1', 'infra_redis_timeout_type', 0, 'primary', NULL, 'Redis 未设置超时的情况', NULL, '2021-01-26 00:53:17', '1', '2022-02-16 19:03:35', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (48, 1, '动态超时', '2', 'infra_redis_timeout_type', 0, 'info', NULL, '程序里动态传入超时时间，无法固定', NULL, '2021-01-26 00:55:00', '1', '2022-02-16 19:03:41', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (49, 3, '固定超时', '3', 'infra_redis_timeout_type', 0, 'success', NULL, 'Redis 设置了过期时间', NULL, '2021-01-26 00:55:26', '1', '2022-02-16 19:03:45', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (50, 1, '单表（增删改查）', '1', 'infra_codegen_template_type', 0, NULL, NULL, NULL, NULL, '2021-02-05 07:09:06', NULL, '2022-03-10 16:33:15', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (51, 2, '树表（增删改查）', '2', 'infra_codegen_template_type', 0, NULL, NULL, NULL, NULL, '2021-02-05 07:14:46', NULL, '2022-03-10 16:33:19', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (53, 0, '初始化中', '0', 'infra_job_status', 0, 'primary', NULL, NULL, NULL, '2021-02-07 07:46:49', '1', '2022-02-16 19:33:29', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (57, 0, '运行中', '0', 'infra_job_log_status', 0, 'primary', NULL, 'RUNNING', NULL, '2021-02-08 10:04:24', '1', '2022-02-16 19:07:48', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (58, 1, '成功', '1', 'infra_job_log_status', 0, 'success', NULL, NULL, NULL, '2021-02-08 10:06:57', '1', '2022-02-16 19:07:52', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (59, 2, '失败', '2', 'infra_job_log_status', 0, 'warning', NULL, '失败', NULL, '2021-02-08 10:07:38', '1', '2022-02-16 19:07:56', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (60, 1, '会员', '1', 'user_type', 0, 'primary', NULL, NULL, NULL, '2021-02-26 00:16:27', '1', '2022-02-16 10:22:19', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (61, 2, '管理员', '2', 'user_type', 0, 'success', NULL, NULL, NULL, '2021-02-26 00:16:34', '1', '2022-02-16 10:22:22', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (62, 0, '未处理', '0', 'infra_api_error_log_process_status', 0, 'primary', NULL, NULL, NULL, '2021-02-26 07:07:19', '1', '2022-02-16 20:14:17', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (63, 1, '已处理', '1', 'infra_api_error_log_process_status', 0, 'success', NULL, NULL, NULL, '2021-02-26 07:07:26', '1', '2022-02-16 20:14:08', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (64, 2, '已忽略', '2', 'infra_api_error_log_process_status', 0, 'danger', NULL, NULL, NULL, '2021-02-26 07:07:34', '1', '2022-02-16 20:14:14', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (66, 2, '阿里云', 'ALIYUN', 'system_sms_channel_code', 0, 'primary', NULL, NULL, '1', '2021-04-05 01:05:26', '1', '2022-02-16 10:09:52', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (67, 1, '验证码', '1', 'system_sms_template_type', 0, 'warning', NULL, NULL, '1', '2021-04-05 21:50:57', '1', '2022-02-16 12:48:30', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (68, 2, '通知', '2', 'system_sms_template_type', 0, 'primary', NULL, NULL, '1', '2021-04-05 21:51:08', '1', '2022-02-16 12:48:27', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (69, 0, '营销', '3', 'system_sms_template_type', 0, 'danger', NULL, NULL, '1', '2021-04-05 21:51:15', '1', '2022-02-16 12:48:22', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (70, 0, '初始化', '0', 'system_sms_send_status', 0, 'primary', NULL, NULL, '1', '2021-04-11 20:18:33', '1', '2022-02-16 10:26:07', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (71, 1, '发送成功', '10', 'system_sms_send_status', 0, 'success', NULL, NULL, '1', '2021-04-11 20:18:43', '1', '2022-02-16 10:25:56', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (72, 2, '发送失败', '20', 'system_sms_send_status', 0, 'danger', NULL, NULL, '1', '2021-04-11 20:18:49', '1', '2022-02-16 10:26:03', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (73, 3, '不发送', '30', 'system_sms_send_status', 0, 'info', NULL, NULL, '1', '2021-04-11 20:19:44', '1', '2022-02-16 10:26:10', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (74, 0, '等待结果', '0', 'system_sms_receive_status', 0, 'primary', NULL, NULL, '1', '2021-04-11 20:27:43', '1', '2022-02-16 10:28:24', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (75, 1, '接收成功', '10', 'system_sms_receive_status', 0, 'success', NULL, NULL, '1', '2021-04-11 20:29:25', '1', '2022-02-16 10:28:28', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (76, 2, '接收失败', '20', 'system_sms_receive_status', 0, 'danger', NULL, NULL, '1', '2021-04-11 20:29:31', '1', '2022-02-16 10:28:32', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (77, 0, '调试(钉钉)', 'DEBUG_DING_TALK', 'system_sms_channel_code', 0, 'info', NULL, NULL, '1', '2021-04-13 00:20:37', '1', '2022-02-16 10:10:00', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (78, 1, '自动生成', '1', 'system_error_code_type', 0, 'warning', NULL, NULL, '1', '2021-04-21 00:06:48', '1', '2022-02-16 13:57:20', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (79, 2, '手动编辑', '2', 'system_error_code_type', 0, 'primary', NULL, NULL, '1', '2021-04-21 00:07:14', '1', '2022-02-16 13:57:24', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (80, 100, '账号登录', '100', 'system_login_type', 0, 'primary', NULL, '账号登录', '1', '2021-10-06 00:52:02', '1', '2022-02-16 13:11:34', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (81, 101, '社交登录', '101', 'system_login_type', 0, 'info', NULL, '社交登录', '1', '2021-10-06 00:52:17', '1', '2022-02-16 13:11:40', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (83, 200, '主动登出', '200', 'system_login_type', 0, 'primary', NULL, '主动登出', '1', '2021-10-06 00:52:58', '1', '2022-02-16 13:11:49', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (85, 202, '强制登出', '202', 'system_login_type', 0, 'danger', NULL, '强制退出', '1', '2021-10-06 00:53:41', '1', '2022-02-16 13:11:57', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1145, 1, '管理后台', '1', 'infra_codegen_scene', 0, NULL, NULL, '代码生成的场景枚举 - 管理后台', '1', '2022-02-02 13:15:06', '1', '2022-03-10 16:32:59', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1146, 2, '用户 APP', '2', 'infra_codegen_scene', 0, NULL, NULL, '代码生成的场景枚举 - 用户 APP', '1', '2022-02-02 13:15:19', '1', '2022-03-10 16:33:03', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1150, 1, '数据库', '1', 'infra_file_storage', 0, 'default', NULL, NULL, '1', '2022-03-15 00:25:28', '1', '2022-03-15 00:25:28', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1151, 10, '本地磁盘', '10', 'infra_file_storage', 0, 'default', NULL, NULL, '1', '2022-03-15 00:25:41', '1', '2022-03-15 00:25:56', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1152, 11, 'FTP 服务器', '11', 'infra_file_storage', 0, 'default', NULL, NULL, '1', '2022-03-15 00:26:06', '1', '2022-03-15 00:26:10', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1153, 12, 'SFTP 服务器', '12', 'infra_file_storage', 0, 'default', NULL, NULL, '1', '2022-03-15 00:26:22', '1', '2022-03-15 00:26:22', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1154, 20, 'S3 对象存储', '20', 'infra_file_storage', 0, 'default', NULL, NULL, '1', '2022-03-15 00:26:31', '1', '2022-03-15 00:26:45', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1155, 103, '短信登录', '103', 'system_login_type', 0, 'default', NULL, NULL, '1', '2022-05-09 23:57:58', '1', '2022-05-09 23:58:09', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1156, 1, 'password', 'password', 'system_oauth2_grant_type', 0, 'default', NULL, '密码模式', '1', '2022-05-12 00:22:05', '1', '2022-05-11 16:26:01', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1157, 2, 'authorization_code', 'authorization_code', 'system_oauth2_grant_type', 0, 'primary', NULL, '授权码模式', '1', '2022-05-12 00:22:59', '1', '2022-05-11 16:26:02', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1158, 3, 'implicit', 'implicit', 'system_oauth2_grant_type', 0, 'success', NULL, '简化模式', '1', '2022-05-12 00:23:40', '1', '2022-05-11 16:26:05', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1159, 4, 'client_credentials', 'client_credentials', 'system_oauth2_grant_type', 0, 'default', NULL, '客户端模式', '1', '2022-05-12 00:23:51', '1', '2022-05-11 16:26:08', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1160, 5, 'refresh_token', 'refresh_token', 'system_oauth2_grant_type', 0, 'info', NULL, '刷新模式', '1', '2022-05-12 00:24:02', '1', '2022-05-11 16:26:11', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1161, 4, 'Vue 3 Vben', '30', 'infra_codegen_front_type', 0, NULL, NULL, NULL, '1', '2023-06-14 15:24:37', '1', '2023-06-14 15:24:37', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1162, 3, 'Vue 3 Schema', '21', 'infra_codegen_front_type', 0, NULL, NULL, 'Vue 3 Element Plus Schema', '1', '2023-06-14 15:24:19', '1', '2023-06-14 15:36:40', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1163, 2, 'Vue 3', '20', 'infra_codegen_front_type', 0, NULL, NULL, 'Vue 3 Element Plus', '1', '2023-06-14 15:24:06', '1', '2023-06-14 15:24:06', 0);
INSERT INTO ruian_oa.system_dict_data VALUES (1164, 1, 'Vue 2', '10', 'infra_codegen_front_type', 0, NULL, NULL, 'Vue 2', '1', '2023-06-14 15:23:12', '1', '2023-06-14 15:23:58', 0);


--
-- TOC entry 6824 (class 0 OID 16554)
-- Dependencies: 716
-- Data for Name: system_dict_type; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_dict_type VALUES (1, '用户性别', 'system_user_sex', 0, NULL, 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:30:31', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (6, '参数类型', 'infra_config_type', 0, NULL, 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:36:54', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (7, '通知类型', 'system_notice_type', 0, NULL, 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:35:26', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (9, '操作类型', 'system_operate_type', 0, NULL, 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:32:21', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (10, '系统状态', 'common_status', 0, NULL, 'admin', '2021-01-05 17:03:48', NULL, '2022-02-01 16:21:28', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (11, 'Boolean 是否类型', 'infra_boolean_string', 0, 'boolean 转是否', NULL, '2021-01-19 03:20:08', NULL, '2022-02-01 16:37:10', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (104, '登陆结果', 'system_login_result', 0, '登陆结果', NULL, '2021-01-18 06:17:11', NULL, '2022-02-01 16:36:00', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (105, 'Redis 超时类型', 'infra_redis_timeout_type', 0, 'RedisKeyDefine.TimeoutTypeEnum', NULL, '2021-01-26 00:52:50', NULL, '2022-02-01 16:50:29', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (106, '代码生成模板类型', 'infra_codegen_template_type', 0, NULL, NULL, '2021-02-05 07:08:06', NULL, '2022-03-10 16:33:42', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (107, '定时任务状态', 'infra_job_status', 0, NULL, NULL, '2021-02-07 07:44:16', NULL, '2022-02-01 16:51:11', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (108, '定时任务日志状态', 'infra_job_log_status', 0, NULL, NULL, '2021-02-08 10:03:51', NULL, '2022-02-01 16:50:43', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (109, '用户类型', 'user_type', 0, NULL, NULL, '2021-02-26 00:15:51', NULL, '2021-02-26 00:15:51', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (110, 'API 异常数据的处理状态', 'infra_api_error_log_process_status', 0, NULL, NULL, '2021-02-26 07:07:01', NULL, '2022-02-01 16:50:53', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (111, '短信渠道编码', 'system_sms_channel_code', 0, NULL, '1', '2021-04-05 01:04:50', '1', '2022-02-16 02:09:08', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (112, '短信模板的类型', 'system_sms_template_type', 0, NULL, '1', '2021-04-05 21:50:43', '1', '2022-02-01 16:35:06', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (113, '短信发送状态', 'system_sms_send_status', 0, NULL, '1', '2021-04-11 20:18:03', '1', '2022-02-01 16:35:09', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (114, '短信接收状态', 'system_sms_receive_status', 0, NULL, '1', '2021-04-11 20:27:14', '1', '2022-02-01 16:35:14', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (115, '错误码的类型', 'system_error_code_type', 0, NULL, '1', '2021-04-21 00:06:30', '1', '2022-02-01 16:36:49', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (116, '登陆日志的类型', 'system_login_type', 0, '登陆日志的类型', '1', '2021-10-06 00:50:46', '1', '2022-02-01 16:35:56', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (144, '代码生成的场景枚举', 'infra_codegen_scene', 0, '代码生成的场景枚举', '1', '2022-02-02 13:14:45', '1', '2022-03-10 16:33:46', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (145, '角色类型', 'system_role_type', 0, '角色类型', '1', '2022-02-16 13:01:46', '1', '2022-02-16 13:01:46', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (146, '文件存储器', 'infra_file_storage', 0, '文件存储器', '1', '2022-03-15 00:24:38', '1', '2022-03-15 00:24:38', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (147, 'OAuth 2.0 授权类型', 'system_oauth2_grant_type', 0, 'OAuth 2.0 授权类型（模式）', '1', '2022-05-12 00:20:52', '1', '2022-05-11 16:25:49', 0, NULL);
INSERT INTO ruian_oa.system_dict_type VALUES (148, '生成前端代码类型', 'infra_codegen_front_type', 0, '生成前端代码类型', '1', '2023-06-14 16:07:35', '1', '2023-06-14 16:07:39', 0, NULL);


--
-- TOC entry 6825 (class 0 OID 16561)
-- Dependencies: 717
-- Data for Name: system_district; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6826 (class 0 OID 16568)
-- Dependencies: 718
-- Data for Name: system_error_code; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6827 (class 0 OID 16575)
-- Dependencies: 719
-- Data for Name: system_login_log; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_login_log VALUES (0, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 11:05:20', NULL, '2024-10-23 11:05:20', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (1, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 11:17:45', NULL, '2024-10-23 11:17:45', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (2, 200, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '1', '2024-10-23 11:17:56', '1', '2024-10-23 11:17:56', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (3, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 11:18:41', NULL, '2024-10-23 11:18:41', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (4, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 11:33:14', NULL, '2024-10-23 11:33:14', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (5, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 14:08:40', NULL, '2024-10-23 14:08:40', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (6, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 14:16:51', NULL, '2024-10-23 14:16:51', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (7, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 14:25:14', NULL, '2024-10-23 14:25:14', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (8, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 14:29:01', NULL, '2024-10-23 14:29:01', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (9, 200, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '1', '2024-10-23 14:32:26', '1', '2024-10-23 14:32:26', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (10, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 14:32:34', NULL, '2024-10-23 14:32:34', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (11, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 14:37:41', NULL, '2024-10-23 14:37:41', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (12, 202, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '1', '2024-10-23 14:38:38', '1', '2024-10-23 14:38:38', 0, '1');
INSERT INTO ruian_oa.system_login_log VALUES (13, 100, NULL, NULL, 2, 'admin', 0, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', NULL, '2024-10-23 14:40:00', NULL, '2024-10-23 14:40:00', 0, '1');


--
-- TOC entry 6828 (class 0 OID 16583)
-- Dependencies: 720
-- Data for Name: system_mail_account; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6829 (class 0 OID 16590)
-- Dependencies: 721
-- Data for Name: system_mail_log; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6830 (class 0 OID 16596)
-- Dependencies: 722
-- Data for Name: system_mail_template; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6831 (class 0 OID 16603)
-- Dependencies: 723
-- Data for Name: system_menu; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_menu VALUES (1, '系统管理', NULL, 1, 10, 0, '/system', 'system', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-05-13 01:02:57', 0);
INSERT INTO ruian_oa.system_menu VALUES (2, '基础设施', NULL, 1, 20, 0, '/infra', 'monitor', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (5, 'OA 示例', NULL, 1, 40, 1185, 'oa', 'people', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-09-20 16:26:19', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (100, '用户管理', 'system:user:list', 2, 1, 1, 'user', 'user', 'system/user/index', 'User', 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (101, '角色管理', NULL, 2, 2, 1, 'role', 'peoples', 'system/role/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (102, '菜单管理', NULL, 2, 3, 1, 'menu', 'tree-table', 'system/menu/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (103, '部门管理', NULL, 2, 4, 1, 'dept', 'tree', 'system/dept/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (104, '岗位管理', NULL, 2, 5, 1, 'post', 'post', 'system/post/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (105, '字典管理', NULL, 2, 6, 1, 'dict', 'dict', 'system/dict/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (106, '配置管理', NULL, 2, 6, 2, 'config', 'edit', 'infra/config/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (107, '通知公告', NULL, 2, 8, 1, 'notice', 'message', 'system/notice/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (108, '审计日志', NULL, 1, 9, 1, 'log', 'log', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (109, '令牌管理', NULL, 2, 2, 1261, 'token', 'online', 'system/oauth2/token/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-05-11 23:31:42', 0);
INSERT INTO ruian_oa.system_menu VALUES (110, '定时任务', NULL, 2, 12, 2, 'job', 'job', 'infra/job/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (111, 'MySQL 监控', NULL, 2, 9, 2, 'druid', 'druid', 'infra/druid/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (112, 'Java 监控', NULL, 2, 11, 2, 'admin-server', 'server', 'infra/server/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (113, 'Redis 监控', NULL, 2, 10, 2, 'redis', 'redis', 'infra/redis/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (114, '表单构建', 'infra:build:list', 2, 2, 2, 'build', 'build', 'infra/build/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (115, '代码生成', 'infra:codegen:query', 2, 1, 2, 'codegen', 'code', 'infra/codegen/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (116, '系统接口', 'infra:swagger:list', 2, 3, 2, 'swagger', 'swagger', 'infra/swagger/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (500, '操作日志', NULL, 2, 1, 108, 'operate-log', 'form', 'system/operatelog/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (501, '登录日志', NULL, 2, 2, 108, 'login-log', 'logininfor', 'system/loginlog/index', NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1001, '用户查询', 'system:user:query', 3, 1, 100, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1002, '用户新增', 'system:user:create', 3, 2, 100, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1003, '用户修改', 'system:user:update', 3, 3, 100, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1004, '用户删除', 'system:user:delete', 3, 4, 100, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1005, '用户导出', 'system:user:export', 3, 5, 100, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1006, '用户导入', 'system:user:import', 3, 6, 100, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1007, '重置密码', 'system:user:update-password', 3, 7, 100, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1008, '角色查询', 'system:role:query', 3, 1, 101, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1009, '角色新增', 'system:role:create', 3, 2, 101, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1010, '角色修改', 'system:role:update', 3, 3, 101, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1011, '角色删除', 'system:role:delete', 3, 4, 101, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1012, '角色导出', 'system:role:export', 3, 5, 101, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1013, '菜单查询', 'system:menu:query', 3, 1, 102, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1014, '菜单新增', 'system:menu:create', 3, 2, 102, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1015, '菜单修改', 'system:menu:update', 3, 3, 102, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1016, '菜单删除', 'system:menu:delete', 3, 4, 102, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1017, '部门查询', 'system:dept:query', 3, 1, 103, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1018, '部门新增', 'system:dept:create', 3, 2, 103, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1019, '部门修改', 'system:dept:update', 3, 3, 103, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1020, '部门删除', 'system:dept:delete', 3, 4, 103, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1021, '岗位查询', 'system:post:query', 3, 1, 104, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1022, '岗位新增', 'system:post:create', 3, 2, 104, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1023, '岗位修改', 'system:post:update', 3, 3, 104, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1024, '岗位删除', 'system:post:delete', 3, 4, 104, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1025, '岗位导出', 'system:post:export', 3, 5, 104, NULL, '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1026, '字典查询', 'system:dict:query', 3, 1, 105, '#', '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1027, '字典新增', 'system:dict:create', 3, 2, 105, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1028, '字典修改', 'system:dict:update', 3, 3, 105, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1029, '字典删除', 'system:dict:delete', 3, 4, 105, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1030, '字典导出', 'system:dict:export', 3, 5, 105, '#', '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1031, '配置查询', 'infra:config:query', 3, 1, 106, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1032, '配置新增', 'infra:config:create', 3, 2, 106, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1033, '配置修改', 'infra:config:update', 3, 3, 106, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1034, '配置删除', 'infra:config:delete', 3, 4, 106, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1035, '配置导出', 'infra:config:export', 3, 5, 106, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1036, '公告查询', 'system:notice:query', 3, 1, 107, '#', '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1037, '公告新增', 'system:notice:create', 3, 2, 107, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1038, '公告修改', 'system:notice:update', 3, 3, 107, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1039, '公告删除', 'system:notice:delete', 3, 4, 107, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1040, '操作查询', 'system:operate-log:query', 3, 1, 500, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1042, '日志导出', 'system:operate-log:export', 3, 2, 500, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1043, '登录查询', 'system:login-log:query', 3, 1, 501, '#', '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1045, '日志导出', 'system:login-log:export', 3, 3, 501, '#', '#', NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1046, '令牌列表', 'system:oauth2-token:page', 3, 1, 109, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-05-09 23:54:42', 0);
INSERT INTO ruian_oa.system_menu VALUES (1048, '令牌删除', 'system:oauth2-token:delete', 3, 2, 109, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-05-09 23:54:53', 0);
INSERT INTO ruian_oa.system_menu VALUES (1050, '任务新增', 'infra:job:create', 3, 2, 110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1051, '任务修改', 'infra:job:update', 3, 3, 110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1052, '任务删除', 'infra:job:delete', 3, 4, 110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1053, '状态修改', 'infra:job:update', 3, 5, 110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1054, '任务导出', 'infra:job:export', 3, 7, 110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1056, '生成修改', 'infra:codegen:update', 3, 2, 115, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1057, '生成删除', 'infra:codegen:delete', 3, 3, 115, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1058, '导入代码', 'infra:codegen:create', 3, 2, 115, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1059, '预览代码', 'infra:codegen:preview', 3, 4, 115, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1060, '生成代码', 'infra:codegen:download', 3, 5, 115, NULL, NULL, NULL, NULL, 0, 't', 't', '1', 'admin', '2021-01-05 17:03:48', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1063, '设置角色菜单权限', 'system:permission:assign-role-menu', 3, 6, 101, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-01-06 17:53:44', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1064, '设置角色数据权限', 'system:permission:assign-role-data-scope', 3, 7, 101, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-01-06 17:56:31', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1065, '设置用户角色', 'system:permission:assign-user-role', 3, 8, 101, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-01-07 10:23:28', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1066, '获得 Redis 监控信息', 'infra:redis:get-monitor-info', 3, 1, 113, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-01-26 01:02:31', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1067, '获得 Redis Key 列表', 'infra:redis:get-key-list', 3, 2, 113, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-01-26 01:02:52', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1070, '代码生成示例', 'infra:test-demo:query', 2, 1, 2, 'test-demo', 'validCode', 'infra/testDemo/index', NULL, 0, 't', 't', '1', NULL, '2021-02-06 12:42:49', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1071, '测试示例表创建', 'infra:test-demo:create', 3, 1, 1070, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-02-06 12:42:49', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1072, '测试示例表更新', 'infra:test-demo:update', 3, 2, 1070, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-02-06 12:42:49', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1073, '测试示例表删除', 'infra:test-demo:delete', 3, 3, 1070, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-02-06 12:42:49', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1074, '测试示例表导出', 'infra:test-demo:export', 3, 4, 1070, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-02-06 12:42:49', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1075, '任务触发', 'infra:job:trigger', 3, 8, 110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-02-07 13:03:10', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1076, '数据库文档', NULL, 2, 4, 2, 'db-doc', 'table', 'infra/dbDoc/index', NULL, 0, 't', 't', '1', NULL, '2021-02-08 01:41:47', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1077, '监控平台', NULL, 2, 13, 2, 'skywalking', 'eye-open', 'infra/skywalking/index', NULL, 0, 't', 't', '1', NULL, '2021-02-08 20:41:31', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1078, '访问日志', NULL, 2, 1, 1083, 'api-access-log', 'log', 'infra/apiAccessLog/index', NULL, 0, 't', 't', '1', NULL, '2021-02-26 01:32:59', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1082, '日志导出', 'infra:api-access-log:export', 3, 2, 1078, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-02-26 01:32:59', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1083, 'API 日志', NULL, 2, 8, 2, 'log', 'log', NULL, NULL, 0, 't', 't', '1', NULL, '2021-02-26 02:18:24', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1084, '错误日志', 'infra:api-error-log:query', 2, 2, 1083, 'api-error-log', 'log', 'infra/apiErrorLog/index', NULL, 0, 't', 't', '1', NULL, '2021-02-26 07:53:20', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1085, '日志处理', 'infra:api-error-log:update-status', 3, 2, 1084, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-02-26 07:53:20', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1086, '日志导出', 'infra:api-error-log:export', 3, 3, 1084, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-02-26 07:53:20', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1087, '任务查询', 'infra:job:query', 3, 1, 110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', '1', '2021-03-10 01:26:19', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1088, '日志查询', 'infra:api-access-log:query', 3, 1, 1078, NULL, NULL, NULL, NULL, 0, 't', 't', '1', '1', '2021-03-10 01:28:04', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1089, '日志查询', 'infra:api-error-log:query', 3, 1, 1084, NULL, NULL, NULL, NULL, 0, 't', 't', '1', '1', '2021-03-10 01:29:09', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1090, '文件列表', NULL, 2, 5, 1243, 'file', 'upload', 'infra/file/index', NULL, 0, 't', 't', '1', NULL, '2021-03-12 20:16:20', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1091, '文件查询', 'infra:file:query', 3, 1, 1090, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-03-12 20:16:20', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1092, '文件删除', 'infra:file:delete', 3, 4, 1090, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-03-12 20:16:20', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1093, '短信管理', NULL, 1, 11, 1, 'sms', 'validCode', NULL, NULL, 0, 't', 't', '1', '1', '2021-04-05 01:10:16', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1094, '短信渠道', NULL, 2, 0, 1093, 'sms-channel', 'phone', 'system/sms/channel', NULL, 0, 't', 't', '1', NULL, '2021-04-01 11:07:15', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1095, '短信渠道查询', 'system:sms-channel:query', 3, 1, 1094, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-01 11:07:15', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1096, '短信渠道创建', 'system:sms-channel:create', 3, 2, 1094, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-01 11:07:15', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1097, '短信渠道更新', 'system:sms-channel:update', 3, 3, 1094, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-01 11:07:15', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1098, '短信渠道删除', 'system:sms-channel:delete', 3, 4, 1094, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-01 11:07:15', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1100, '短信模板', NULL, 2, 1, 1093, 'sms-template', 'phone', 'system/sms/template', NULL, 0, 't', 't', '1', NULL, '2021-04-01 17:35:17', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1101, '短信模板查询', 'system:sms-template:query', 3, 1, 1100, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-01 17:35:17', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1102, '短信模板创建', 'system:sms-template:create', 3, 2, 1100, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-01 17:35:17', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1103, '短信模板更新', 'system:sms-template:update', 3, 3, 1100, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-01 17:35:17', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1104, '短信模板删除', 'system:sms-template:delete', 3, 4, 1100, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-01 17:35:17', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1105, '短信模板导出', 'system:sms-template:export', 3, 5, 1100, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-01 17:35:17', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1106, '发送测试短信', 'system:sms-template:send-sms', 3, 6, 1100, NULL, NULL, NULL, NULL, 0, 't', 't', '1', '1', '2021-04-11 00:26:40', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1107, '短信日志', NULL, 2, 2, 1093, 'sms-log', 'phone', 'system/sms/log', NULL, 0, 't', 't', '1', NULL, '2021-04-11 08:37:05', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1108, '短信日志查询', 'system:sms-log:query', 3, 1, 1107, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-11 08:37:05', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1109, '短信日志导出', 'system:sms-log:export', 3, 5, 1107, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-11 08:37:05', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1110, '错误码管理', NULL, 2, 12, 1, 'error-code', 'code', 'system/errorCode/index', NULL, 0, 't', 't', '1', NULL, '2021-04-13 21:46:42', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1111, '错误码查询', 'system:error-code:query', 3, 1, 1110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-13 21:46:42', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1112, '错误码创建', 'system:error-code:create', 3, 2, 1110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-13 21:46:42', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1113, '错误码更新', 'system:error-code:update', 3, 3, 1110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-13 21:46:42', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1114, '错误码删除', 'system:error-code:delete', 3, 4, 1110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-13 21:46:42', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1115, '错误码导出', 'system:error-code:export', 3, 5, 1110, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2021-04-13 21:46:42', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1237, '文件配置', NULL, 2, 0, 1243, 'file-config', 'config', 'infra/fileConfig/index', NULL, 0, 't', 't', '1', NULL, '2022-03-15 14:35:28', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1238, '文件配置查询', 'infra:file-config:query', 3, 1, 1237, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-03-15 14:35:28', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1239, '文件配置创建', 'infra:file-config:create', 3, 2, 1237, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-03-15 14:35:28', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1240, '文件配置更新', 'infra:file-config:update', 3, 3, 1237, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-03-15 14:35:28', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1241, '文件配置删除', 'infra:file-config:delete', 3, 4, 1237, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-03-15 14:35:28', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1242, '文件配置导出', 'infra:file-config:export', 3, 5, 1237, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-03-15 14:35:28', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1243, '文件管理', NULL, 2, 5, 2, 'file', 'download', NULL, NULL, 0, 't', 't', '1', '1', '2022-03-16 23:47:40', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1247, '敏感词管理', NULL, 2, 13, 1, 'sensitive-word', 'education', 'system/sensitiveWord/index', NULL, 0, 't', 't', '1', NULL, '2022-04-07 16:55:03', '1', '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1248, '敏感词查询', 'system:sensitive-word:query', 3, 1, 1247, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-04-07 16:55:03', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1249, '敏感词创建', 'system:sensitive-word:create', 3, 2, 1247, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-04-07 16:55:03', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1250, '敏感词更新', 'system:sensitive-word:update', 3, 3, 1247, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-04-07 16:55:03', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1251, '敏感词删除', 'system:sensitive-word:delete', 3, 4, 1247, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-04-07 16:55:03', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1252, '敏感词导出', 'system:sensitive-word:export', 3, 5, 1247, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-04-07 16:55:03', NULL, '2022-04-20 17:03:10', 0);
INSERT INTO ruian_oa.system_menu VALUES (1255, '数据源配置', NULL, 2, 1, 2, 'data-source-config', 'rate', 'infra/dataSourceConfig/index', NULL, 0, 't', 't', '1', NULL, '2022-04-27 14:37:32', '1', '2022-04-27 22:42:06', 0);
INSERT INTO ruian_oa.system_menu VALUES (1256, '数据源配置查询', 'infra:data-source-config:query', 3, 1, 1255, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-04-27 14:37:32', NULL, '2022-04-27 14:37:32', 0);
INSERT INTO ruian_oa.system_menu VALUES (1257, '数据源配置创建', 'infra:data-source-config:create', 3, 2, 1255, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-04-27 14:37:32', NULL, '2022-04-27 14:37:32', 0);
INSERT INTO ruian_oa.system_menu VALUES (1258, '数据源配置更新', 'infra:data-source-config:update', 3, 3, 1255, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-04-27 14:37:32', NULL, '2022-04-27 14:37:32', 0);
INSERT INTO ruian_oa.system_menu VALUES (1259, '数据源配置删除', 'infra:data-source-config:delete', 3, 4, 1255, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-04-27 14:37:32', NULL, '2022-04-27 14:37:32', 0);
INSERT INTO ruian_oa.system_menu VALUES (1260, '数据源配置导出', 'infra:data-source-config:export', 3, 5, 1255, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-04-27 14:37:32', NULL, '2022-04-27 14:37:32', 0);
INSERT INTO ruian_oa.system_menu VALUES (1261, 'OAuth 2.0', NULL, 1, 10, 1, 'oauth2', 'people', NULL, NULL, 0, 't', 't', '1', '1', '2022-05-09 23:38:17', '1', '2022-05-11 23:51:46', 0);
INSERT INTO ruian_oa.system_menu VALUES (1263, '应用管理', NULL, 2, 0, 1261, 'oauth2/application', 'tool', 'system/oauth2/client/index', NULL, 0, 't', 't', '1', NULL, '2022-05-10 16:26:33', '1', '2022-05-11 23:31:36', 0);
INSERT INTO ruian_oa.system_menu VALUES (1264, '客户端查询', 'system:oauth2-client:query', 3, 1, 1263, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-05-10 16:26:33', '1', '2022-05-11 00:31:06', 0);
INSERT INTO ruian_oa.system_menu VALUES (1265, '客户端创建', 'system:oauth2-client:create', 3, 2, 1263, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-05-10 16:26:33', '1', '2022-05-11 00:31:23', 0);
INSERT INTO ruian_oa.system_menu VALUES (1266, '客户端更新', 'system:oauth2-client:update', 3, 3, 1263, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-05-10 16:26:33', '1', '2022-05-11 00:31:28', 0);
INSERT INTO ruian_oa.system_menu VALUES (1267, '客户端删除', 'system:oauth2-client:delete', 3, 4, 1263, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-05-10 16:26:33', '1', '2022-05-11 00:31:33', 0);
INSERT INTO ruian_oa.system_menu VALUES (1254, '作者动态', NULL, 1, 0, 0, 'https://www.iocoder.cn', 'people', NULL, NULL, 0, 't', 't', '1', '1', '2022-04-23 01:03:15', '1', '2022-04-23 01:03:15', 1);
INSERT INTO ruian_oa.system_menu VALUES (1227, '租户套餐创建', 'system:tenant-package:create', 3, 2, 1225, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-02-19 17:44:06', NULL, '2022-04-20 17:03:10', 1);
INSERT INTO ruian_oa.system_menu VALUES (1228, '租户套餐更新', 'system:tenant-package:update', 3, 3, 1225, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-02-19 17:44:06', NULL, '2022-04-20 17:03:10', 1);
INSERT INTO ruian_oa.system_menu VALUES (1229, '租户套餐删除', 'system:tenant-package:delete', 3, 4, 1225, NULL, NULL, NULL, NULL, 0, 't', 't', '1', NULL, '2022-02-19 17:44:06', NULL, '2022-04-20 17:03:10', 1);


--
-- TOC entry 6832 (class 0 OID 16611)
-- Dependencies: 724
-- Data for Name: system_notice; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6833 (class 0 OID 16618)
-- Dependencies: 725
-- Data for Name: system_notify_message; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6834 (class 0 OID 16625)
-- Dependencies: 726
-- Data for Name: system_notify_template; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6835 (class 0 OID 16632)
-- Dependencies: 727
-- Data for Name: system_oauth2_access_token; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_oauth2_access_token VALUES (2, NULL, 2, 'a9a4c4ee6c1c4348880f63eda6b6da37', '1b35d3e562674633a14bea3b0ece52c6', 'default', '["user.read","user.write"]', '2024-10-22 14:35:04', NULL, '2024-10-22 14:32:04', NULL, '2024-10-22 14:32:04', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (4, NULL, 2, 'de485c0c6f904df8b999d9b10e21178e', '8e1279573910434bbb1f9736c6a2ab83', 'default', '["user.read","user.write"]', '2024-10-22 14:43:09', NULL, '2024-10-22 14:40:09', NULL, '2024-10-22 14:40:09', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (6, NULL, 2, '3c9ba43deda74771b397ff967f85e548', 'ec3bbff895ef40439359e3aeb6c01dc4', 'default', '["user.read","user.write"]', '2024-10-22 14:44:50', NULL, '2024-10-22 14:41:50', NULL, '2024-10-22 14:41:50', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (8, NULL, 2, 'ee3ed862d4fe4055b8741349c8da9af5', '4be20c68acc14633987629da2e295b9c', 'default', '["user.read","user.write"]', '2024-10-22 14:50:37', NULL, '2024-10-22 14:47:37', NULL, '2024-10-22 14:47:37', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (10, NULL, 2, 'c9f43287f58e4c0297612a67d7b02083', 'cb37d3560be54d94aef57a1c56bfb6a3', 'default', '["user.read","user.write"]', '2024-10-23 11:20:39', NULL, '2024-10-23 11:17:39', NULL, '2024-10-23 11:17:39', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (12, NULL, 2, 'b9849f836d3840b48632ad6e8cf07b17', '76fc2b0c887d40a48c467bf56919de98', 'default', NULL, '2024-10-23 11:20:45', NULL, '2024-10-23 11:17:45', NULL, '2024-10-23 11:17:45', 1, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (14, NULL, 2, 'bb76352eafac45668688859db2401574', '983333a4186342058e5486dc9325cab4', 'default', NULL, '2024-10-23 11:21:41', NULL, '2024-10-23 11:18:41', NULL, '2024-10-23 11:18:41', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (16, NULL, 2, '2dc53edf7bf84c7da0e08f2ed95f44af', '8239819390e240d8b2e6da11b0190fca', 'default', NULL, '2024-10-23 11:36:14', NULL, '2024-10-23 11:33:14', NULL, '2024-10-23 11:33:14', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (18, NULL, 2, '7a3484d6efa347ca86d44b5bb7f9a72a', 'e1a25aca2e844287a2550daa56a55361', 'default', '["user.read","user.write"]', '2024-10-23 14:11:34', NULL, '2024-10-23 14:08:34', NULL, '2024-10-23 14:08:34', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (20, NULL, 2, 'dbc3f5b714744035ac09715ea8a57770', 'b4cadad0b2ec40e3bcc7718f9541fc9d', 'default', NULL, '2024-10-23 14:11:41', NULL, '2024-10-23 14:08:41', NULL, '2024-10-23 14:08:41', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (22, NULL, 2, '5dcf1e9194704e61815b2072a4343b1a', 'dc6771ca1981408084bc88ac423df2bf', 'default', '["user.read","user.write"]', '2024-10-23 14:16:15', NULL, '2024-10-23 14:13:15', NULL, '2024-10-23 14:13:15', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (24, NULL, 2, '72c078fdaae24289969c648f7f06d0dd', '2ebf28df3ce84b5aa725ac02c10d72c1', 'default', '["user.read","user.write"]', '2024-10-23 14:18:31', NULL, '2024-10-23 14:15:31', NULL, '2024-10-23 14:15:31', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (26, NULL, 2, 'abdc7e3cd0d34f45b9f7c88bb9f5d3a5', '5523c71aba3a47dbba80413d491860f4', 'default', '["user.read","user.write"]', '2024-10-23 14:19:25', NULL, '2024-10-23 14:16:25', NULL, '2024-10-23 14:16:25', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (28, NULL, 2, '6cf2e15adf584d15aed55db81a555dda', 'bcd6ee8cbb5045a39fe77a2b3bf4d424', 'default', NULL, '2024-10-23 14:19:51', NULL, '2024-10-23 14:16:51', NULL, '2024-10-23 14:16:51', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (30, NULL, 2, 'abe9d9bb4c4246e7abaaef4cbed430e6', '9619e5523332477c87eae4c0b8269db4', 'default', NULL, '2024-10-23 14:28:14', NULL, '2024-10-23 14:25:14', NULL, '2024-10-23 14:25:14', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (32, NULL, 2, 'c8a49e20e684411186f6be0ef143dcc1', '7a8c84f00e964952ac07a7dcf8f2fe0d', 'default', NULL, '2024-10-23 14:32:01', NULL, '2024-10-23 14:29:01', NULL, '2024-10-23 14:29:01', 1, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (34, NULL, 2, 'eeb6b351df6b4da587fa72cacadaa8bc', 'ce996503b75446889acd7efe4828ea4c', 'default', NULL, '2024-10-23 14:35:34', NULL, '2024-10-23 14:32:34', NULL, '2024-10-23 14:32:34', 0, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (36, NULL, 2, '61d86a705fbc4ad09a0e9da59b5f47ee', '506bb70ed89e41b0a05e237aa9d729b3', 'default', NULL, '2024-10-23 14:40:41', NULL, '2024-10-23 14:37:41', NULL, '2024-10-23 14:37:41', 1, '1');
INSERT INTO ruian_oa.system_oauth2_access_token VALUES (38, NULL, 2, '1a45c5c30a6241808af2b6a0eac5a07a', '6027b88a73794a90b129e2bc066ea7d2', 'default', NULL, '2024-10-24 02:40:00', NULL, '2024-10-23 14:40:00', NULL, '2024-10-23 14:40:00', 0, '1');


--
-- TOC entry 6836 (class 0 OID 16639)
-- Dependencies: 728
-- Data for Name: system_oauth2_approve; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6837 (class 0 OID 16646)
-- Dependencies: 729
-- Data for Name: system_oauth2_client; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_oauth2_client VALUES (40, 'test', 'test2', 'biubiu', 'http://test.zjugis.iocoder.cn/277a899d573723f1fcdfb57340f00379.png', NULL, 0, 43200, 43200, '["https://www.iocoder.cn"]', '["password","authorization_code","implicit"]', '[]', '[]', '[]', '[]', '{}', '1', '2022-05-12 00:28:20', '1', '2024-10-23 14:38:11', 0);
INSERT INTO ruian_oa.system_oauth2_client VALUES (1, 'default', 'admin123', '芋道源码', 'http://test.zjugis.iocoder.cn/a5e2e244368878a366b516805a4aabf1.png', '我是描述', 0, 43200, 43200, '["https://www.iocoder.cn","https://doc.iocoder.cn"]', '["password","authorization_code","implicit","refresh_token"]', '["user.read","user.write"]', NULL, '["system:user:query"]', '[]', '{}', '1', '2022-05-11 21:47:12', '1', '2024-10-23 14:38:28', 0);


--
-- TOC entry 6838 (class 0 OID 16653)
-- Dependencies: 730
-- Data for Name: system_oauth2_code; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6839 (class 0 OID 16660)
-- Dependencies: 731
-- Data for Name: system_oauth2_refresh_token; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (1, NULL, '1b35d3e562674633a14bea3b0ece52c6', 2, 'default', '["user.read","user.write"]', '2024-10-22 16:56:04', NULL, '2024-10-22 14:32:04', NULL, '2024-10-22 14:32:04', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (3, NULL, '8e1279573910434bbb1f9736c6a2ab83', 2, 'default', '["user.read","user.write"]', '2024-10-22 17:04:09', NULL, '2024-10-22 14:40:09', NULL, '2024-10-22 14:40:09', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (5, NULL, 'ec3bbff895ef40439359e3aeb6c01dc4', 2, 'default', '["user.read","user.write"]', '2024-10-22 17:05:50', NULL, '2024-10-22 14:41:50', NULL, '2024-10-22 14:41:50', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (7, NULL, '4be20c68acc14633987629da2e295b9c', 2, 'default', '["user.read","user.write"]', '2024-10-22 17:11:37', NULL, '2024-10-22 14:47:37', NULL, '2024-10-22 14:47:37', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (9, NULL, 'cb37d3560be54d94aef57a1c56bfb6a3', 2, 'default', '["user.read","user.write"]', '2024-10-23 13:41:39', NULL, '2024-10-23 11:17:39', NULL, '2024-10-23 11:17:39', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (11, NULL, '76fc2b0c887d40a48c467bf56919de98', 2, 'default', NULL, '2024-10-23 13:41:45', NULL, '2024-10-23 11:17:45', NULL, '2024-10-23 11:17:45', 1, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (13, NULL, '983333a4186342058e5486dc9325cab4', 2, 'default', NULL, '2024-10-23 13:42:41', NULL, '2024-10-23 11:18:41', NULL, '2024-10-23 11:18:41', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (15, NULL, '8239819390e240d8b2e6da11b0190fca', 2, 'default', NULL, '2024-10-23 13:57:14', NULL, '2024-10-23 11:33:14', NULL, '2024-10-23 11:33:14', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (17, NULL, 'e1a25aca2e844287a2550daa56a55361', 2, 'default', '["user.read","user.write"]', '2024-10-23 16:32:34', NULL, '2024-10-23 14:08:34', NULL, '2024-10-23 14:08:34', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (19, NULL, 'b4cadad0b2ec40e3bcc7718f9541fc9d', 2, 'default', NULL, '2024-10-23 16:32:41', NULL, '2024-10-23 14:08:41', NULL, '2024-10-23 14:08:41', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (21, NULL, 'dc6771ca1981408084bc88ac423df2bf', 2, 'default', '["user.read","user.write"]', '2024-10-23 16:37:15', NULL, '2024-10-23 14:13:15', NULL, '2024-10-23 14:13:15', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (23, NULL, '2ebf28df3ce84b5aa725ac02c10d72c1', 2, 'default', '["user.read","user.write"]', '2024-10-23 16:39:31', NULL, '2024-10-23 14:15:31', NULL, '2024-10-23 14:15:31', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (25, NULL, '5523c71aba3a47dbba80413d491860f4', 2, 'default', '["user.read","user.write"]', '2024-10-23 16:40:25', NULL, '2024-10-23 14:16:25', NULL, '2024-10-23 14:16:25', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (27, NULL, 'bcd6ee8cbb5045a39fe77a2b3bf4d424', 2, 'default', NULL, '2024-10-23 16:40:51', NULL, '2024-10-23 14:16:51', NULL, '2024-10-23 14:16:51', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (29, NULL, '9619e5523332477c87eae4c0b8269db4', 2, 'default', NULL, '2024-10-23 16:49:14', NULL, '2024-10-23 14:25:14', NULL, '2024-10-23 14:25:14', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (31, NULL, '7a8c84f00e964952ac07a7dcf8f2fe0d', 2, 'default', NULL, '2024-10-23 16:53:01', NULL, '2024-10-23 14:29:01', NULL, '2024-10-23 14:29:01', 1, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (33, NULL, 'ce996503b75446889acd7efe4828ea4c', 2, 'default', NULL, '2024-10-23 16:56:34', NULL, '2024-10-23 14:32:34', NULL, '2024-10-23 14:32:34', 0, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (35, NULL, '506bb70ed89e41b0a05e237aa9d729b3', 2, 'default', NULL, '2024-10-23 17:01:41', NULL, '2024-10-23 14:37:41', NULL, '2024-10-23 14:37:41', 1, '1');
INSERT INTO ruian_oa.system_oauth2_refresh_token VALUES (37, NULL, '6027b88a73794a90b129e2bc066ea7d2', 2, 'default', NULL, '2024-10-24 02:40:00', NULL, '2024-10-23 14:40:00', NULL, '2024-10-23 14:40:00', 0, '1');


--
-- TOC entry 6840 (class 0 OID 16667)
-- Dependencies: 732
-- Data for Name: system_operate_log; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_operate_log VALUES (0, NULL, NULL, 2, '管理后台 - 部门', '删除部门', 4, NULL, NULL, 'DELETE', '/admin-api/system/dept/delete', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.dept.DeptController.deleteDept(String)', '{"id":"102"}', '2024-10-23 14:29:24', 34, 500, 'ServiceException: 存在子部门，无法删除', 'null', '1', '2024-10-23 14:29:24', '1', '2024-10-23 14:29:24', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (1, NULL, NULL, 2, '管理后台 - 部门', '删除部门', 4, NULL, NULL, 'DELETE', '/admin-api/system/dept/delete', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.dept.DeptController.deleteDept(String)', '{"id":"108"}', '2024-10-23 14:29:27', 61, 0, 'success', 'true', '1', '2024-10-23 14:29:27', '1', '2024-10-23 14:29:27', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (2, NULL, NULL, 2, '管理后台 - 部门', '删除部门', 4, NULL, NULL, 'DELETE', '/admin-api/system/dept/delete', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.dept.DeptController.deleteDept(String)', '{"id":"109"}', '2024-10-23 14:29:30', 33, 0, 'success', 'true', '1', '2024-10-23 14:29:30', '1', '2024-10-23 14:29:30', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (3, NULL, NULL, 2, '管理后台 - 部门', '删除部门', 4, NULL, NULL, 'DELETE', '/admin-api/system/dept/delete', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.dept.DeptController.deleteDept(String)', '{"id":"102"}', '2024-10-23 14:29:33', 38, 0, 'success', 'true', '1', '2024-10-23 14:29:33', '1', '2024-10-23 14:29:33', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (4, NULL, NULL, 2, '管理后台 - 部门', '更新部门', 3, NULL, NULL, 'PUT', '/admin-api/system/dept/update', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.dept.DeptController.updateDept(DeptUpdateReqVO)', '{"reqVO":{"name":"顶级部门","parentId":"0","sort":0,"leaderUserId":"1","phone":"15888888888","email":"ry@qq.com","status":0,"code":null,"id":"100","deptLeaderUserId":null}}', '2024-10-23 14:30:26', 42, 0, 'success', 'true', '1', '2024-10-23 14:30:27', '1', '2024-10-23 14:30:27', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (5, NULL, NULL, 2, '管理后台 - 部门', '更新部门', 3, NULL, NULL, 'PUT', '/admin-api/system/dept/update', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.dept.DeptController.updateDept(DeptUpdateReqVO)', '{"reqVO":{"name":"分公司","parentId":"100","sort":1,"leaderUserId":"104","phone":"15888888888","email":"ry@qq.com","status":0,"code":null,"id":"101","deptLeaderUserId":null}}', '2024-10-23 14:30:45', 72, 0, 'success', 'true', '1', '2024-10-23 14:30:45', '1', '2024-10-23 14:30:45', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (6, NULL, NULL, 2, '管理后台 - 部门', '更新部门', 3, NULL, NULL, 'PUT', '/admin-api/system/dept/update', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.dept.DeptController.updateDept(DeptUpdateReqVO)', '{"reqVO":{"name":"顶级部门","parentId":"0","sort":0,"leaderUserId":"","phone":"15888888888","email":"ry@qq.com","status":0,"code":null,"id":"100","deptLeaderUserId":null}}', '2024-10-23 14:30:54', 24, 0, 'success', 'true', '1', '2024-10-23 14:30:54', '1', '2024-10-23 14:30:54', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (7, NULL, NULL, 2, '管理后台 - 用户', '修改用户', 3, NULL, NULL, 'PUT', '/admin-api/system/user/update', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.user.UserController.updateUser(UserUpdateReqVO)', '{"reqVO":{"username":"admin","nickname":"管理员","remark":"管理员","deptId":"103","deptName":"研发部门","deptIds":null,"postIds":[1],"email":"aoteman@126.com","mobile":"15612345678","sex":1,"avatar":null,"signatureUrl":null,"attendanceFlag":true,"id":"1"}}', '2024-10-23 14:31:10', 58, 0, 'success', 'true', '1', '2024-10-23 14:31:10', '1', '2024-10-23 14:31:10', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (8, NULL, NULL, 2, '管理后台 - 用户', '修改用户', 3, NULL, NULL, 'PUT', '/admin-api/system/user/update', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.user.UserController.updateUser(UserUpdateReqVO)', '{"reqVO":{"username":"admin","nickname":"管理员","remark":"管理员","deptId":"100","deptName":"顶级部门","deptIds":null,"postIds":[1],"email":"aoteman@126.com","mobile":"15612345678","sex":1,"avatar":null,"signatureUrl":null,"attendanceFlag":true,"id":"1"}}', '2024-10-23 14:31:16', 42, 0, 'success', 'true', '1', '2024-10-23 14:31:16', '1', '2024-10-23 14:31:16', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (9, NULL, NULL, 2, '管理后台 - 菜单', '删除菜单', 4, NULL, NULL, 'DELETE', '/admin-api/system/menu/delete', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.permission.MenuController.deleteMenu(Long)', '{"id":1254}', '2024-10-23 14:31:41', 87, 0, 'success', 'true', '1', '2024-10-23 14:31:41', '1', '2024-10-23 14:31:41', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (10, NULL, NULL, 2, '管理后台 - 菜单', '删除菜单', 4, NULL, NULL, 'DELETE', '/admin-api/system/menu/delete', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.permission.MenuController.deleteMenu(Long)', '{"id":1227}', '2024-10-23 14:31:55', 116, 0, 'success', 'true', '1', '2024-10-23 14:31:56', '1', '2024-10-23 14:31:56', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (11, NULL, NULL, 2, '管理后台 - 菜单', '删除菜单', 4, NULL, NULL, 'DELETE', '/admin-api/system/menu/delete', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.permission.MenuController.deleteMenu(Long)', '{"id":1228}', '2024-10-23 14:32:02', 19, 0, 'success', 'true', '1', '2024-10-23 14:32:02', '1', '2024-10-23 14:32:02', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (12, NULL, NULL, 2, '管理后台 - 菜单', '删除菜单', 4, NULL, NULL, 'DELETE', '/admin-api/system/menu/delete', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.permission.MenuController.deleteMenu(Long)', '{"id":1229}', '2024-10-23 14:32:06', 19, 0, 'success', 'true', '1', '2024-10-23 14:32:06', '1', '2024-10-23 14:32:06', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (13, NULL, NULL, 2, '管理后台 - OAuth2 客户端', '更新 OAuth2 客户端', 3, NULL, NULL, 'PUT', '/admin-api/system/oauth2-client/update', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.oauth2.OAuth2ClientController.updateOAuth2Client(OAuth2ClientUpdateReqVO)', '{"updateReqVO":{"clientId":"test","secret":"test2","name":"biubiu","logo":"http://test.zjugis.iocoder.cn/277a899d573723f1fcdfb57340f00379.png","description":null,"status":0,"accessTokenValiditySeconds":43200,"refreshTokenValiditySeconds":43200,"redirectUris":["https://www.iocoder.cn"],"authorizedGrantTypes":["password","authorization_code","implicit"],"scopes":[],"autoApproveScopes":[],"authorities":[],"resourceIds":[],"additionalInformation":"{}","id":40,"additionalInformationJson":true}}', '2024-10-23 14:38:11', 25, 0, 'success', 'true', '1', '2024-10-23 14:38:11', '1', '2024-10-23 14:38:11', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (14, NULL, NULL, 2, '管理后台 - OAuth2 客户端', '更新 OAuth2 客户端', 3, NULL, NULL, 'PUT', '/admin-api/system/oauth2-client/update', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.oauth2.OAuth2ClientController.updateOAuth2Client(OAuth2ClientUpdateReqVO)', '{"updateReqVO":{"clientId":"default","secret":"admin123","name":"芋道源码","logo":"http://test.zjugis.iocoder.cn/a5e2e244368878a366b516805a4aabf1.png","description":"我是描述","status":0,"accessTokenValiditySeconds":43200,"refreshTokenValiditySeconds":43200,"redirectUris":["https://www.iocoder.cn","https://doc.iocoder.cn"],"authorizedGrantTypes":["password","authorization_code","implicit","refresh_token"],"scopes":["user.read","user.write"],"autoApproveScopes":null,"authorities":["system:user:query"],"resourceIds":[],"additionalInformation":"{}","id":1,"additionalInformationJson":true}}', '2024-10-23 14:38:28', 17, 0, 'success', 'true', '1', '2024-10-23 14:38:28', '1', '2024-10-23 14:38:28', 0, '1');
INSERT INTO ruian_oa.system_operate_log VALUES (15, NULL, NULL, 2, '管理后台 - OAuth2.0 令牌', '删除访问令牌', 4, NULL, NULL, 'DELETE', '/admin-api/system/oauth2-token/delete', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'CommonResult com.zjugis.module.system.controller.admin.oauth2.OAuth2TokenController.deleteAccessToken(String)', '{"accessToken":"61d86a705fbc4ad09a0e9da59b5f47ee"}', '2024-10-23 14:38:38', 19, 0, 'success', 'true', '1', '2024-10-23 14:38:38', '1', '2024-10-23 14:38:38', 0, '1');


--
-- TOC entry 6841 (class 0 OID 16676)
-- Dependencies: 733
-- Data for Name: system_post; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_post VALUES (1, 'ceo', '董事长', 1, 0, NULL, 'admin', '2021-01-06 17:03:48', '1', '2022-04-19 16:53:39', 0);
INSERT INTO ruian_oa.system_post VALUES (2, 'se', '项目经理', 2, 0, NULL, 'admin', '2021-01-05 17:03:48', '1', '2021-12-12 10:47:47', 0);
INSERT INTO ruian_oa.system_post VALUES (4, 'user', '普通员工', 4, 0, '111', 'admin', '2021-01-05 17:03:48', '1', '2022-05-04 22:46:35', 0);


--
-- TOC entry 6842 (class 0 OID 16683)
-- Dependencies: 734
-- Data for Name: system_role; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_role VALUES (1, '超级管理员', 'super_admin', 1, 1, NULL, 0, 1, '超级管理员', 'admin', '2021-01-05 17:03:48', NULL, '2022-02-22 05:08:21', 0, NULL);
INSERT INTO ruian_oa.system_role VALUES (2, '普通角色', 'common', 2, 2, NULL, 0, 1, '普通角色', 'admin', '2021-01-05 17:03:48', NULL, '2022-02-22 05:08:20', 0, NULL);
INSERT INTO ruian_oa.system_role VALUES (101, '测试账号', 'test', 0, 1, '[]', 0, 2, '132', NULL, '2021-01-06 13:49:35', '1', '2022-04-01 21:37:13', 0, NULL);


--
-- TOC entry 6843 (class 0 OID 16690)
-- Dependencies: 735
-- Data for Name: system_role_menu; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6844 (class 0 OID 16695)
-- Dependencies: 736
-- Data for Name: system_sensitive_word; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6845 (class 0 OID 16702)
-- Dependencies: 737
-- Data for Name: system_sms_channel; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6846 (class 0 OID 16709)
-- Dependencies: 738
-- Data for Name: system_sms_code; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6847 (class 0 OID 16713)
-- Dependencies: 739
-- Data for Name: system_sms_log; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6848 (class 0 OID 16720)
-- Dependencies: 740
-- Data for Name: system_sms_template; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6849 (class 0 OID 16727)
-- Dependencies: 741
-- Data for Name: system_social_user; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6850 (class 0 OID 16734)
-- Dependencies: 742
-- Data for Name: system_social_user_bind; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6852 (class 0 OID 16746)
-- Dependencies: 744
-- Data for Name: system_user_dept; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--



--
-- TOC entry 6853 (class 0 OID 16750)
-- Dependencies: 745
-- Data for Name: system_user_post; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_user_post VALUES (112, NULL, 1, 'admin', '2022-05-02 07:25:24', 'admin', '2022-05-02 07:25:24', 0, '1');
INSERT INTO ruian_oa.system_user_post VALUES (113, NULL, 1, 'admin', '2022-05-02 07:25:24', 'admin', '2022-05-02 07:25:24', 0, '100');
INSERT INTO ruian_oa.system_user_post VALUES (114, NULL, 3, 'admin', '2022-05-02 07:25:24', 'admin', '2022-05-02 07:25:24', 0, '114');


--
-- TOC entry 6854 (class 0 OID 16754)
-- Dependencies: 746
-- Data for Name: system_user_role; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_user_role VALUES (1, NULL, 1, NULL, '2022-01-11 13:19:45', NULL, '2022-05-12 12:35:17', 0, '1');
INSERT INTO ruian_oa.system_user_role VALUES (2, NULL, 2, NULL, '2022-01-11 13:19:45', NULL, '2022-05-12 12:35:13', 0, '2');
INSERT INTO ruian_oa.system_user_role VALUES (4, NULL, 101, NULL, '2022-01-11 13:19:45', NULL, '2022-05-12 12:35:13', 0, '100');
INSERT INTO ruian_oa.system_user_role VALUES (5, NULL, 1, NULL, '2022-01-11 13:19:45', NULL, '2022-05-12 12:35:12', 0, '100');
INSERT INTO ruian_oa.system_user_role VALUES (6, NULL, 2, NULL, '2022-01-11 13:19:45', NULL, '2022-05-12 12:35:11', 0, '100');
INSERT INTO ruian_oa.system_user_role VALUES (7, NULL, 101, NULL, '2022-01-11 13:19:45', NULL, '2022-05-12 12:35:11', 0, '104');
INSERT INTO ruian_oa.system_user_role VALUES (10, NULL, 1, '1', '2022-01-11 13:19:45', '1', '2022-01-11 13:19:45', 0, '103');
INSERT INTO ruian_oa.system_user_role VALUES (17, NULL, 101, '1', '2022-03-19 21:51:13', '1', '2022-03-19 21:51:13', 0, '114');
INSERT INTO ruian_oa.system_user_role VALUES (18, NULL, 2, '1', '2022-05-12 20:39:29', '1', '2022-05-12 20:39:29', 0, '1');


--
-- TOC entry 6851 (class 0 OID 16738)
-- Dependencies: 743
-- Data for Name: system_users; Type: TABLE DATA; Schema: ruian_oa; Owner: system
--

INSERT INTO ruian_oa.system_users VALUES ('admin', '$2a$10$0acJOIk2D25/oC87nyclE..0lzeu9DtQ/n3geP4fkun/zIVRhHJIO', '管理员', '管理员', '[1]', 'aoteman@126.com', '15612345678', 1, NULL, 0, '0:0:0:0:0:0:0:1', '2024-10-23 14:40:00', 'admin', '2021-01-05 17:03:47', NULL, '2024-10-23 14:40:00', 0, NULL, '1', NULL, '100', '顶级部门', NULL, 1);


--
-- TOC entry 6905 (class 0 OID 0)
-- Dependencies: 748
-- Name: infra_api_access_log_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_api_access_log_seq', 0, false);


--
-- TOC entry 6906 (class 0 OID 0)
-- Dependencies: 749
-- Name: infra_api_error_log_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_api_error_log_seq', 16, true);


--
-- TOC entry 6907 (class 0 OID 0)
-- Dependencies: 750
-- Name: infra_codegen_column_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_codegen_column_seq', 0, false);


--
-- TOC entry 6908 (class 0 OID 0)
-- Dependencies: 751
-- Name: infra_codegen_table_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_codegen_table_seq', 0, false);


--
-- TOC entry 6909 (class 0 OID 0)
-- Dependencies: 752
-- Name: infra_config_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_config_seq', 0, false);


--
-- TOC entry 6910 (class 0 OID 0)
-- Dependencies: 753
-- Name: infra_data_source_config_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_data_source_config_seq', 0, false);


--
-- TOC entry 6911 (class 0 OID 0)
-- Dependencies: 754
-- Name: infra_file_config_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_file_config_seq', 0, false);


--
-- TOC entry 6912 (class 0 OID 0)
-- Dependencies: 755
-- Name: infra_file_content_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_file_content_seq', 0, false);


--
-- TOC entry 6913 (class 0 OID 0)
-- Dependencies: 756
-- Name: infra_file_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_file_seq', 0, false);


--
-- TOC entry 6914 (class 0 OID 0)
-- Dependencies: 757
-- Name: infra_job_log_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_job_log_seq', 0, false);


--
-- TOC entry 6915 (class 0 OID 0)
-- Dependencies: 758
-- Name: infra_job_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_job_seq', 0, false);


--
-- TOC entry 6916 (class 0 OID 0)
-- Dependencies: 759
-- Name: infra_msg_send_record_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_msg_send_record_seq', 1, false);


--
-- TOC entry 6917 (class 0 OID 0)
-- Dependencies: 760
-- Name: infra_test_demo_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.infra_test_demo_seq', 0, false);


--
-- TOC entry 6918 (class 0 OID 0)
-- Dependencies: 761
-- Name: system_dept_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_dept_seq', 0, false);


--
-- TOC entry 6919 (class 0 OID 0)
-- Dependencies: 762
-- Name: system_dict_data_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_dict_data_seq', 0, false);


--
-- TOC entry 6920 (class 0 OID 0)
-- Dependencies: 763
-- Name: system_dict_type_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_dict_type_seq', 0, false);


--
-- TOC entry 6921 (class 0 OID 0)
-- Dependencies: 764
-- Name: system_error_code_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_error_code_seq', 0, false);


--
-- TOC entry 6922 (class 0 OID 0)
-- Dependencies: 765
-- Name: system_login_log_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_login_log_seq', 13, true);


--
-- TOC entry 6923 (class 0 OID 0)
-- Dependencies: 766
-- Name: system_menu_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_menu_seq', 0, false);


--
-- TOC entry 6924 (class 0 OID 0)
-- Dependencies: 767
-- Name: system_notice_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_notice_seq', 0, false);


--
-- TOC entry 6925 (class 0 OID 0)
-- Dependencies: 768
-- Name: system_notify_message_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_notify_message_seq', 1, false);


--
-- TOC entry 6926 (class 0 OID 0)
-- Dependencies: 769
-- Name: system_notify_template_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_notify_template_seq', 1, false);


--
-- TOC entry 6927 (class 0 OID 0)
-- Dependencies: 770
-- Name: system_oauth2_access_token_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_oauth2_access_token_seq', 38, true);


--
-- TOC entry 6928 (class 0 OID 0)
-- Dependencies: 771
-- Name: system_oauth2_approve_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_oauth2_approve_seq', 1, false);


--
-- TOC entry 6929 (class 0 OID 0)
-- Dependencies: 772
-- Name: system_oauth2_client_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_oauth2_client_seq', 1, false);


--
-- TOC entry 6930 (class 0 OID 0)
-- Dependencies: 773
-- Name: system_oauth2_code_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_oauth2_code_seq', 1, false);


--
-- TOC entry 6931 (class 0 OID 0)
-- Dependencies: 774
-- Name: system_operate_log_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_operate_log_seq', 15, true);


--
-- TOC entry 6932 (class 0 OID 0)
-- Dependencies: 775
-- Name: system_post_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_post_seq', 0, false);


--
-- TOC entry 6933 (class 0 OID 0)
-- Dependencies: 776
-- Name: system_role_menu_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_role_menu_seq', 0, false);


--
-- TOC entry 6934 (class 0 OID 0)
-- Dependencies: 777
-- Name: system_role_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_role_seq', 0, false);


--
-- TOC entry 6935 (class 0 OID 0)
-- Dependencies: 778
-- Name: system_sensitive_word_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_sensitive_word_seq', 0, false);


--
-- TOC entry 6936 (class 0 OID 0)
-- Dependencies: 779
-- Name: system_sms_channel_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_sms_channel_seq', 0, false);


--
-- TOC entry 6937 (class 0 OID 0)
-- Dependencies: 780
-- Name: system_sms_code_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_sms_code_seq', 0, false);


--
-- TOC entry 6938 (class 0 OID 0)
-- Dependencies: 781
-- Name: system_sms_log_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_sms_log_seq', 0, false);


--
-- TOC entry 6939 (class 0 OID 0)
-- Dependencies: 782
-- Name: system_sms_template_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_sms_template_seq', 0, false);


--
-- TOC entry 6940 (class 0 OID 0)
-- Dependencies: 783
-- Name: system_social_user_bind_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_social_user_bind_seq', 0, false);


--
-- TOC entry 6941 (class 0 OID 0)
-- Dependencies: 784
-- Name: system_social_user_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_social_user_seq', 0, false);


--
-- TOC entry 6942 (class 0 OID 0)
-- Dependencies: 785
-- Name: system_tenant_package_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_tenant_package_seq', 0, false);


--
-- TOC entry 6943 (class 0 OID 0)
-- Dependencies: 786
-- Name: system_tenant_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_tenant_seq', 0, false);


--
-- TOC entry 6944 (class 0 OID 0)
-- Dependencies: 787
-- Name: system_user_dept_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_user_dept_seq', 0, false);


--
-- TOC entry 6945 (class 0 OID 0)
-- Dependencies: 788
-- Name: system_user_post_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_user_post_seq', 0, false);


--
-- TOC entry 6946 (class 0 OID 0)
-- Dependencies: 789
-- Name: system_user_role_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_user_role_seq', 0, false);


--
-- TOC entry 6947 (class 0 OID 0)
-- Dependencies: 790
-- Name: system_user_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_user_seq', 0, false);


--
-- TOC entry 6948 (class 0 OID 0)
-- Dependencies: 747
-- Name: system_user_session_seq; Type: SEQUENCE SET; Schema: ruian_oa; Owner: system
--

SELECT pg_catalog.setval('ruian_oa.system_user_session_seq', 0, false);


--
-- TOC entry 6904 (class 0 OID 0)
-- Dependencies: 44
-- Name: SCHEMA ruian_oa; Type: ACL; Schema: -; Owner: system
--

GRANT ALL ON SCHEMA ruian_oa TO ruian_oa;


-- Completed on 2024-10-23 14:41:17

--
-- Kingbase database dump complete
--