easydo-zcgx/script/db/boot/oracle/BOOT_ORACLE_DATA.sql

INSERT INTO XXL_JOB_USER (ID, USERNAME, PASSWORD, ROLE, PERMISSION) VALUES (1, 'admin', 'c963cf2d6d412dba46630197b35fe93a', 1, null);

INSERT INTO T_SYS_USER (ID, DEPT_ID, USERNAME, PASSWORD, NAME, MOBILE, EMAIL, AVATAR, ADDRESS, STATE, TYPE, CODE,
                        COMPANY, PROVINCE, CITY, EXT_TYPE, EXT_DEPT, EXT_CODE, EXT_CODE_HS, EXT_CODE_GH, EXT_CODE_GJ,
                        EXT_CODE_GK, EXT_DDBB, UPDATED_AT, CREATED_AT, PASSWORD_WRONG_TIMES, LAST_LOGIN_DATE,
                        EXT_UNIT_ID, EXT_MEMO, JOB, IS_QDPORT_USER, LAST_UPDATE_PWD_DATE)
VALUES (1, 1635579167369170959, '099999', '1400e86e5679f760411e33a5a2267781d40adc19', '超级管理员', null,
        null, null, null, 0, null, 'admin', null, null, null, null, null, null, null, null, null, null,
        null, SYSDATE, SYSDATE, 0, SYSDATE,
        null, null, null, '99', SYSDATE);

INSERT INTO T_SYS_ROLE (ID, NAME, CODE, DESCRIPTION, SORT, STATE, UPDATED_AT, CREATED_AT, IS_SHOW)
VALUES (1, '超级管理员', 'sysadmin', '超级管理员', 1, 0, null, null, 0);


INSERT INTO "T_TOP_MENU" ("ID", "CODE", "NAME", "SOURCE", "SORT", "IS_DEFAULT", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('1661988539567120385', '10005', '工作流平台', NULL, '5', '0', '1670723238158213121', NULL, NULL, '2', TO_DATE('2023-05-26 14:52:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, '0');
INSERT INTO "T_TOP_MENU" ("ID", "CODE", "NAME", "SOURCE", "SORT", "IS_DEFAULT", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('1', '10001', '平台菜单', NULL, '1', '1', '1679036002075394050', '1635579166396092418', NULL, '2', TO_DATE('2023-04-23 14:13:55', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');

INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1, 0, '根目录', 'root', 'root1', '/', null, 1, 0, '10001', 0, TIMESTAMP '2024-06-25 08:09:57', TIMESTAMP '2024-05-11 15:09:07', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1762659463383281665, 1, 'boot菜单', 'boot', null, '/boot', null, 1, 0, '10001', 0, TIMESTAMP '2024-02-28 10:07:05', TIMESTAMP '2024-02-28 10:02:19', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1805413566949187586, 1, 'APP菜单', 'appMenu', 'tjm-checkbox', '/aoi', 'app菜单', 1, 0, '10001', 0, TIMESTAMP '2024-06-25 07:51:26', TIMESTAMP '2024-06-25 09:31:51', 2);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1762659615074480130, 1762659463383281665, '平台运维', 'boot-sys', 'ep-Briefcase', '/system', null, 1, 1, '10001', 0, TIMESTAMP '2024-03-04 09:41:42', TIMESTAMP '2024-02-28 10:02:55', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1762659730841464833, 1762659615074480130, '数据权限', 'boot-dataList', 'ep-Box', '/system/dataList', null, 1, 5, '10001', 0, TIMESTAMP '2024-04-02 00:47:41', TIMESTAMP '2024-02-28 10:03:23', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1762660776364011522, 1762659615074480130, '用户管理', 'boot-user', 'ep-Sugar', '/system/user', null, 1, 0, '10001', 0, TIMESTAMP '2024-02-28 10:31:29', TIMESTAMP '2024-02-28 10:07:32', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1762660101475332097, 1762659615074480130, '部门管理', 'boot-dept', 'ep-Money', '/system/dept', null, 1, 1, '10001', 0, TIMESTAMP '2024-04-02 00:47:18', TIMESTAMP '2024-02-28 10:04:51', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1762659927214583809, 1762659615074480130, '角色管理', 'boot-role', 'ep-Collection', '/system/role', null, 1, 3, '10001', 0, TIMESTAMP '2024-04-02 00:47:30', TIMESTAMP '2024-02-28 10:04:09', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1762659831794167810, 1762659615074480130, '菜单管理', 'boot-menu', 'ep-Calendar', '/system/menu', null, 1, 4, '10001', 0, TIMESTAMP '2024-04-02 00:47:37', TIMESTAMP '2024-02-28 10:03:47', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1774724813254107138, 1774724256531554306, '公告管理', 'boot-announcM', 'ep-Briefcase', '/message/announcement', null, 1, 0, '10001', 0, TIMESTAMP '2024-04-01 09:05:42', TIMESTAMP '2024-04-01 09:05:42', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777215985532510210, 1762659463383281665, '协同办公', 'workFlow', 'ep-Notebook', '/workflow', '工作流-协同办公', 1, 1, '10001', 0, TIMESTAMP '2024-07-24 02:56:28', TIMESTAMP '2024-04-08 14:04:44', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777216539411324930, 1777215985532510210, '流程设计', 'Processdesign', 'ep-Notebook', '/processDesign', '流程设计', 1, 3, '10001', 0, TIMESTAMP '2024-05-17 17:09:37', TIMESTAMP '2024-04-08 14:06:56', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777218643492315138, 1777216539411324930, '模型设计', 'Modeldesign', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/design/model', '模型设计', 1, 0, '10001', 0, TIMESTAMP '2024-04-08 14:15:18', TIMESTAMP '2024-04-08 14:15:18', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777218865048035330, 1777216539411324930, '表单设计', ' Formdesign', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/design/form', '表单设计', 1, 1, '10001', 0, TIMESTAMP '2024-04-08 14:16:11', TIMESTAMP '2024-04-08 14:16:11', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1782667965017071618, 1777216539411324930, '部署管理', 'bsgl', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/design/deployment', null, 1, 2, '10001', 0, TIMESTAMP '2024-04-23 15:11:53', TIMESTAMP '2024-04-23 15:08:57', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783371935725363201, 1777216539411324930, '流程按钮', 'lcan', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/design/button', '流程按钮', 1, 3, '10001', 0, TIMESTAMP '2024-04-25 13:46:17', TIMESTAMP '2024-04-25 13:46:17', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783372240391217154, 1777216539411324930, '流程分类', 'lcfl', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/design/category', null, 1, 4, '10001', 0, TIMESTAMP '2024-04-25 13:47:30', TIMESTAMP '2024-04-25 13:47:30', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783372479575597057, 1777216539411324930, '表单默认值', 'bdmrz', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/design/form-default-values', null, 1, 5, '10001', 0, TIMESTAMP '2024-04-25 13:48:27', TIMESTAMP '2024-04-25 13:48:27', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783372686140874753, 1777216539411324930, '流程表达式', 'lcbds', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/design/condition', null, 1, 6, '10001', 0, TIMESTAMP '2024-04-25 13:49:16', TIMESTAMP '2024-04-25 13:49:16', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777216667895439361, 1777215985532510210, '我的事务', 'Mybusiness', 'ep-Notebook', '/myBusiness', '我的事务', 1, 1, '10001', 0, TIMESTAMP '2024-04-08 14:07:27', TIMESTAMP '2024-04-08 14:07:27', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777219460102332417, 1777216667895439361, '新建流程', 'CreateNewProcess', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/process/start', null, 1, 0, '10001', 0, TIMESTAMP '2024-04-08 14:18:33', TIMESTAMP '2024-04-08 14:18:33', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783373405266878465, 1777216667895439361, '待办事宜', 'dbsy', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/process/todo', null, 1, 1, '10001', 0, TIMESTAMP '2024-04-25 13:52:07', TIMESTAMP '2024-04-25 13:52:07', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783373687338016769, 1777216667895439361, '我的请求', 'wdqq', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/process/send', null, 1, 2, '10001', 0, TIMESTAMP '2024-04-25 13:53:15', TIMESTAMP '2024-04-25 13:53:15', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783373891042779137, 1777216667895439361, '我的已办', 'wdyb', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/process/my-done', null, 1, 3, '10001', 0, TIMESTAMP '2024-04-25 13:54:03', TIMESTAMP '2024-04-25 13:54:03', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783374092725886978, 1777216667895439361, '办结事宜', 'bjsy', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/process/done', null, 1, 4, '10001', 0, TIMESTAMP '2024-04-25 13:54:51', TIMESTAMP '2024-04-25 13:54:51', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783374309579792386, 1777216667895439361, '待签事务', 'dqsw', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/process/claim', null, 1, 5, '10001', 0, TIMESTAMP '2024-04-25 13:55:43', TIMESTAMP '2024-04-25 13:55:43', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783374491302207490, 1777216667895439361, '抄送事宜', 'cssy', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/process/copy', null, 1, 6, '10001', 0, TIMESTAMP '2024-04-25 13:56:26', TIMESTAMP '2024-04-25 13:56:26', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777217414867427330, 1777215985532510210, '流程运维', 'Processoperationmaintenance', 'ep-Notebook', '/processOperation ', '流程运维', 1, 2, '10001', 0, TIMESTAMP '2024-04-08 14:10:25', TIMESTAMP '2024-04-08 14:10:25', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777219691195899906, 1777217414867427330, '运维调度', 'Operationandmaintenancescheduling', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/ops/index	', '运维调度', 1, 0, '10001', 0, TIMESTAMP '2024-04-08 14:19:28', TIMESTAMP '2024-04-08 14:19:28', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783374958145019905, 1777217414867427330, '办结流程', 'bjlc', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/ops/done', null, 1, 1, '10001', 0, TIMESTAMP '2024-04-25 13:58:18', TIMESTAMP '2024-04-25 13:58:18', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783375155969368066, 1777217414867427330, '流程列表', 'lclb', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/ops/list', null, 1, 2, '10001', 0, TIMESTAMP '2024-04-25 13:59:05', TIMESTAMP '2024-04-25 13:59:05', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1783375393924816898, 1777217414867427330, '流程代理', 'lcdl', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/ops/proxy', null, 1, 3, '10001', 0, TIMESTAMP '2024-04-25 14:00:02', TIMESTAMP '2024-04-25 14:00:02', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777219947157495809, 1777218113659445249, '请假流程业务示例', 'Business example of leave process', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/demo/leave/index', '请假流程业务示例', 1, 0, '10001', 0, TIMESTAMP '2024-04-08 14:20:29', TIMESTAMP '2024-04-08 14:20:29', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777218350369185794, 1777215985532510210, '流程统计', 'Processstatistics', 'ep-Notebook', '/processStatistics', '流程统计', 1, 5, '10001', 0, TIMESTAMP '2024-05-17 17:09:42', TIMESTAMP '2024-04-08 14:14:08', 3);
INSERT INTO T_SYS_MENU (ID, PARENT_ID, NAME, CODE, ICON, PATH, DESCRIPTION, TYPE, SORT, SYSTEM_CODE, STATE, UPDATED_AT, CREATED_AT, MENU_TYPE) VALUES (1777220140628156417, 1777218350369185794, '总览', 'Overview', 'ep-Notebook', '/tjmchild/workflow/plugin/workflow/statistics/index', '总览', 1, 0, '10001', 0, TIMESTAMP '2024-04-08 14:21:15', TIMESTAMP '2024-04-08 14:21:15', 3);



INSERT INTO T_SYS_DEPT (ID, PARENT_ID, NAME, CODE, DESCRIPTION, SORT, STATE, UPDATED_AT, CREATED_AT, ANCESTORS, DEPT_TYPE, EX_WECHAT, EX_PORTRAIT, EX_GENDER, EX_REGION, EX_PROVINCE) VALUES (1678687232259869038, 0, '青岛港人力资源组织机构', '101', null, null, 0, TIMESTAMP '2023-08-01 17:30:37', TIMESTAMP '2023-07-11 16:46:44', null, 1, null, null, null, null, null);

INSERT INTO T_SCOPE_DATA (ID, MENU_ID, RESOURCE_CODE, SCOPE_NAME, SCOPE_FIELD, SCOPE_CLASS, SCOPE_COLUMN, SCOPE_TYPE, SCOPE_VALUE, REMARK, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, SORT) VALUES (1722184428242403329, 1, 'root', '根目录[全部可见]', '*', '2222', '-', 1, null, null, 1722063562541436929, 1635579166396092418, TIMESTAMP '2023-11-08 17:28:58', 1722063562541436929, TIMESTAMP '2023-11-08 17:28:58', 1, 0, null);

INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1100000000000000007, 0, 'sys_notice_type', '-1', '通知类型', 1, '通知类型列表', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1100000000000000008, 0, 'sys_notice_status', '-1', '通知状态', 1, '通知状态列表', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1100000000000000009, 0, 'sys_oper_type', '-1', '操作类型', 1, '操作类型列表', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1100000000000000010, 0, 'sys_common_status', '-1', '系统状态', 1, '登录状态列表', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1100000000000000100, 0, 'sys_process_category', '-1', '流程分类', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1100000000000000101, 0, 'common_status', '-1', '通用状态', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1100000000000000102, 0, 'sys_listener_type', '-1', '监听类型', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1100000000000000103, 0, 'sys_listener_value_type', '-1', '监听值类型', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1100000000000000104, 0, 'sys_listener_event_type', '-1', '监听属性', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000001, 1, 'sys_user_sex', '0', '男', 1, '性别男', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000002, 1, 'sys_user_sex', '1', '女', 1, '性别女', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000003, 1, 'sys_user_sex', '2', '未知', 1, '性别未知', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000004, 2, 'sys_show_hide', '0', '显示', 1, '显示菜单', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000005, 2, 'sys_show_hide', '1', '隐藏', 1, '隐藏菜单', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000006, 3, 'sys_normal_disable', '0', '正常', 1, '正常状态', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000007, 3, 'sys_normal_disable', '1', '停用', 1, '停用状态', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000008, 4, 'sys_job_status', '0', '正常', 1, '正常状态', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000009, 4, 'sys_job_status', '1', '暂停', 1, '停用状态', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000010, 5, 'sys_job_group', 'DEFAULT', '默认', 1, '默认分组', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000011, 5, 'sys_job_group', 'SYSTEM', '系统', 1, '系统分组', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000012, 6, 'sys_yes_no', 'Y', '是', 1, '系统默认是', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000013, 6, 'sys_yes_no', 'N', '否', 1, '系统默认否', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000014, 7, 'sys_notice_type', '1', '通知', 1, '通知', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000015, 7, 'sys_notice_type', '2', '公告', 1, '公告', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000016, 8, 'sys_notice_status', '0', '正常', 1, '正常状态', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000017, 8, 'sys_notice_status', '1', '关闭', 1, '关闭状态', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000018, 9, 'sys_oper_type', '0', '其他', 1, '其他操作', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000019, 9, 'sys_oper_type', '1', '新增', 1, '新增操作', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000020, 9, 'sys_oper_type', '2', '修改', 1, '修改操作', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000021, 9, 'sys_oper_type', '3', '删除', 1, '删除操作', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000022, 9, 'sys_oper_type', '4', '授权', 1, '授权操作', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000023, 9, 'sys_oper_type', '5', '导出', 1, '导出操作', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000024, 9, 'sys_oper_type', '6', '导入', 1, '导入操作', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000025, 9, 'sys_oper_type', '7', '强退', 1, '强退操作', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000026, 9, 'sys_oper_type', '8', '生成代码', 1, '生成操作', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000027, 9, 'sys_oper_type', '9', '清空数据', 1, '清空操作', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000028, 10, 'sys_common_status', '0', '成功', 1, '正常状态', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000029, 10, 'sys_common_status', '1', '失败', 1, '停用状态', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000100, 100, 'sys_process_category', 'leave', '请假流程', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000101, 100, 'sys_process_category', 'oa', 'OA流程', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000102, 101, 'common_status', '0', '正常', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000103, 101, 'common_status', '1', '禁用', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000104, 102, 'sys_listener_type', '1', '任务监听', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000105, 102, 'sys_listener_type', '2', '执行监听', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000106, 103, 'sys_listener_value_type', '1', 'JAVA类', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000107, 103, 'sys_listener_value_type', '2', '表达式', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1000000000000000108, 103, 'sys_listener_value_type', '3', '代理表达式', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675201, 0, 'sex', '-1', '性别', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675202, 1123598814738675201, 'sex', '1', '男', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675203, 1123598814738675201, 'sex', '2', '女', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675204, 0, 'notice', '-1', '通知类型', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675205, 1123598814738675204, 'notice', '1', '发布通知', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675206, 1123598814738675204, 'notice', '2', '批转通知', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675207, 1123598814738675204, 'notice', '3', '转发通知', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675208, 1123598814738675204, 'notice', '4', '指示通知', 4, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675209, 1123598814738675204, 'notice', '5', '任免通知', 5, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675210, 1123598814738675204, 'notice', '6', '事务通知', 6, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675211, 0, 'menu_category', '-1', '菜单类型', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675212, 1123598814738675211, 'menu_category', '1', '菜单', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675213, 1123598814738675211, 'menu_category', '2', '按钮', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675214, 0, 'button_func', '-1', '按钮功能', 4, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675215, 1123598814738675214, 'button_func', '1', '工具栏', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675216, 1123598814738675214, 'button_func', '2', '操作栏', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675217, 1123598814738675214, 'button_func', '3', '工具操作栏', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675218, 0, 'yes_no', '-1', '是否', 5, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675219, 1123598814738675218, 'yes_no', '1', '否', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675220, 1123598814738675218, 'yes_no', '2', '是', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675221, 0, 'flow', '-1', '流程类型', 5, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675222, 1123598814738675221, 'flow', '1', '请假流程', 1, 'leave', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675223, 1123598814738675221, 'flow', '2', '报销流程', 2, 'expense', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675227, 0, 'org_category', '-1', '机构类型', 7, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675228, 1123598814738675227, 'org_category', '1', '公司', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675229, 1123598814738675227, 'org_category', '2', '部门', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675230, 1123598814738675227, 'org_category', '3', '小组', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675231, 0, 'data_scope_type', '-1', '数据权限', 8, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675232, 1123598814738675231, 'data_scope_type', '1', '全部可见', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675233, 1123598814738675231, 'data_scope_type', '2', '本人可见', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675234, 1123598814738675231, 'data_scope_type', '3', '所在机构可见', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675235, 1123598814738675231, 'data_scope_type', '4', '所在机构及子级可见', 4, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675236, 1123598814738675231, 'data_scope_type', '5', '自定义', 5, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675237, 0, 'api_scope_type', '-1', '接口权限', 10, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675238, 1123598814738675237, 'api_scope_type', '1', '系统接口', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675239, 1123598814738675237, 'api_scope_type', '2', '业务接口', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675240, 0, 'scope_category', '-1', '权限类型', 10, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675241, 1123598814738675240, 'scope_category', '1', '数据权限', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738675242, 1123598814738675240, 'scope_category', '2', '接口权限', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738676224, 0, 'oss', '-1', '对象存储类型', 6, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738676225, 1123598814738676224, 'oss', '1', 'minio', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738676226, 1123598814738676224, 'oss', '2', 'qiniu', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738676227, 1123598814738676224, 'oss', '3', 'ali', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738676228, 1123598814738676224, 'oss', '4', 'tencent', 4, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738677220, 0, 'sms', '-1', '短信服务类型', 11, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738677221, 1123598814738677220, 'sms', '1', 'yunpian', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738677222, 1123598814738677220, 'sms', '2', 'qiniu', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738677223, 1123598814738677220, 'sms', '3', 'ali', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777221, 1123598814738777220, 'post_category', '1', '高层', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777222, 1123598814738777220, 'post_category', '2', '中层', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777223, 1123598814738777220, 'post_category', '3', '基层', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777224, 1123598814738777220, 'post_category', '4', '其他', 4, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777230, 0, 'region', '-1', '行政区划', 13, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777231, 1123598814738777230, 'region', '0', '国家', 0, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777232, 1123598814738777230, 'region', '1', '省份/直辖市', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777233, 1123598814738777230, 'region', '2', '地市', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777234, 1123598814738777230, 'region', '3', '区县', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777235, 1123598814738777230, 'region', '4', '乡镇', 4, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777236, 1123598814738777230, 'region', '5', '村委', 5, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778200, 0, 'user_type', '-1', '用户平台', 14, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778201, 1123598814738778200, 'user_type', '1', 'WEB', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778202, 1123598814738778200, 'user_type', '2', 'APP', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778203, 1123598814738778200, 'user_type', '3', 'OTHER', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778204, 0, 'app_type', '1', 'Web应用', 1, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778205, 0, 'app_type', '2', '移动应用', 2, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778206, 0, 'app_type', '3', '数据应用', 3, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778207, 0, 'app_type', '4', '4C客户端应用', 4, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778208, 0, 'app_type', '5', 'AI应用', 5, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778209, 0, 'app_type', '6', '第三方应用', 6, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738778210, 0, 'app_type', '7', '算法应用', 7, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738677224, 1123598814738677220, 'sms', '4', 'tencent', 4, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1123598814738777220, 0, 'post_category', '-1', '岗位类型', 12, null, 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1767444642148028418, 0, 'app_classify', '-1', '应用分类', 1, '应用分类', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1767444642148028419, 1767444642148028418, 'app_classify', '1', '办公管理', 2, '应用分类', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1767444642148028420, 1767444642148028418, 'app_classify', '2', '协同效率', 3, '应用分类', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1767444642148028421, 1767444642148028418, 'app_classify', '3', '经营管理', 4, '应用分类', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1767444642148028422, 1767444642148028418, 'app_classify', '4', '安全环保', 5, '应用分类', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1767444642148028423, 1767444642148028418, 'app_classify', '5', '生产业务', 6, '应用分类', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1767444642148028424, 1767444642148028418, 'app_classify', '6', '快捷功能', 7, '应用分类', 0, 0);
INSERT INTO T_DICT (ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_SEALED, IS_DELETED) VALUES (1767444642148028426, 1767444642148028418, 'app_classify', '8', '其他', 9, '应用分类', 0, 0);

INSERT INTO T_CLIENT (ID, CLIENT_ID, CLIENT_SECRET, RESOURCE_IDS, SCOPE, AUTHORIZED_GRANT_TYPES, WEB_SERVER_REDIRECT_URI, AUTHORITIES, ACCESS_TOKEN_VALIDITY, REFRESH_TOKEN_VALIDITY, ADDITIONAL_INFORMATION, AUTOAPPROVE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, CLIENT_NAME, TWO_FACTOR_AUTH, LOGOUT_ADDRESS, IS_LOGON_CONF, MODIFY_USER) VALUES (1666610333753716737, 'frame-demo', 'F1F09CFFC2E5F7719ADC2025447AE7BA', null, 'all', 'refresh_token,password,authorization_code,captcha,social,edge', 'http://10.205.81.1:31304/login', null, 3600, 604800, null, 'true', 1635577609139097602, null, TIMESTAMP '2023-06-08 08:57:22', null, null, 0, 0, '边端平台', null, null, 0, null);
INSERT INTO T_CLIENT (ID, CLIENT_ID, CLIENT_SECRET, RESOURCE_IDS, SCOPE, AUTHORIZED_GRANT_TYPES, WEB_SERVER_REDIRECT_URI, AUTHORITIES, ACCESS_TOKEN_VALIDITY, REFRESH_TOKEN_VALIDITY, ADDITIONAL_INFORMATION, AUTOAPPROVE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, CLIENT_NAME, TWO_FACTOR_AUTH, LOGOUT_ADDRESS, IS_LOGON_CONF, MODIFY_USER) VALUES (1123598811738675202, 'pcManageId', 'pcManageSecret', null, 'all', 'refresh_token,password,authorization_code,captcha,social,edge,ticket,iam', 'http://sso-test.10.236.3.36.nip.io/sso-test11', null, 3600, 604800, null, 'true', 1123598815738675201, 1123598813738675201, TIMESTAMP '2019-03-24 10:42:29', 1679036002075394050, TIMESTAMP '2023-11-08 16:43:12', 1, 0, '测试测试', null, null, null, 'WB0003');

INSERT INTO T_APP_VERSION (ID, TYPE, LATEST_VERSION, LATEST_APK, UP_INSTRUCTIONS, REVISE_DATE, COMMENTS, APP_ID, CREATE_USER, CREATE_TIME, UPDATE_USER, UPDATE_TIME, CREATE_DEPT, STATUS, IS_DELETED) VALUES ('1650674861940862978', 0, 'v1.0.1', 'www.example.com', null, TIMESTAMP '2023-04-25 09:35:29', null, '1', null, TIMESTAMP '2023-04-25 09:35:29', null, TIMESTAMP '2023-04-25 09:35:29', null, 1, 0);


INSERT INTO "R_SYS_USER_ROLE" ("USER_ID", "ROLE_ID") VALUES ('1', '2');
INSERT INTO "R_SYS_USER_ROLE" ("USER_ID", "ROLE_ID") VALUES ('1', '1');


INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '3');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '5');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '6');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '7');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '8');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '9');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '47');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '48');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '49');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '50');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '55');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '56');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '145');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '146');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '147');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '148');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '181');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '182');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '186');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '187');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '188');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '189');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '190');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '192');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '193');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '194');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '195');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '196');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '247');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '248');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '249');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '250');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '251');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '2');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1638367957414776834');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1638369338691358722');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1638399698686906370');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1638400062911877121');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1638406083659108353');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1638437389741273089');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1638469645386067970');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1661992237236166658');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1661992372968038401');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1661992621925146626');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1661993654353076225');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1661993815397572610');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664157385082216450');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664157504871538689');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664157992081891329');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664162083805798402');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664163437236396034');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664163998501380098');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664164150209355778');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664164345202548737');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664178729068994561');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664178897243807746');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664179012318732290');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664179147119468546');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664179259723948033');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664179400128274434');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664179503421399042');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664182047325495297');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664182188220555265');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664182287101272065');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664182369175412738');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664182497936351234');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1664182579331014658');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1670994760432791554');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1671026561331146754');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1671033491629977602');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1676474224961884162');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1683778995270635522');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1683779065932075009');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1683779372176175106');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1683779623003942913');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1684855093614813186');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1687380104654622722');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1687380232337625089');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1687380449048924161');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1687649237719846914');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1688390462571810818');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1688749567760199682');
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES ('1', '1688749685683056642');

INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777215985532510210);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777216539411324930);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777218643492315138);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777218865048035330);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1782667965017071618);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783371935725363201);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783372240391217154);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783372479575597057);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783372686140874753);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777216667895439361);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777219460102332417);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783373405266878465);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783373687338016769);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783373891042779137);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783374092725886978);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783374309579792386);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783374491302207490);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777217414867427330);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777219691195899906);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783374958145019905);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783375155969368066);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1783375393924816898);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777219947157495809);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777218350369185794);
INSERT INTO "R_SYS_ROLE_MENU" ("ROLE_ID", "MENU_ID") VALUES (1, 1777220140628156417);


INSERT INTO QDPORT_WF_MODEL_SCOPE (ID, MODEL_ID, MODEL_KEY, TYPE, VAL, TEXT) VALUES (1808051835136233473, 'ac5c5dc0de3b4f96727cda8da30207e4', 'AppAudit', 'WF_ALL', 'WF_ALL', null);
INSERT INTO QDPORT_WF_MODEL_SCOPE (ID, MODEL_ID, MODEL_KEY, TYPE, VAL, TEXT) VALUES (1808051846846730241, '62d518b837911f65e6d10e6d90b31b28', 'projectRelease', 'WF_ALL', 'WF_ALL', null);

INSERT INTO QDPORT_WF_FORM_DEFAULT_VALUES (ID, NAME, CONTENT, FIELD_TYPE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1399346112331087873, '当前操作人姓名', '${this.$store.getters.userInfo.nick_name}', 'input', 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-31 20:44:46', 1123598821738675201, TIMESTAMP '2021-05-31 20:56:32', '1', 0, '000000');
INSERT INTO QDPORT_WF_FORM_DEFAULT_VALUES (ID, NAME, CONTENT, FIELD_TYPE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1399347906465595393, '当前操作人部门', '${this.$store.getters.userInfo.dept_name}', 'input', 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-31 20:51:54', 1123598821738675201, TIMESTAMP '2021-05-31 20:56:41', '1', 0, '000000');
INSERT INTO QDPORT_WF_FORM_DEFAULT_VALUES (ID, NAME, CONTENT, FIELD_TYPE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1399717069960855553, '当前日期', '${this.dateFormat(new Date(),"yyyy-MM-dd")}', 'input', 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-06-01 21:18:50', 1123598821738675201, TIMESTAMP '2021-06-01 21:34:25', '1', 0, '000000');
INSERT INTO QDPORT_WF_FORM_DEFAULT_VALUES (ID, NAME, CONTENT, FIELD_TYPE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1399717187904684034, '当前操作人职位', '${this.$store.getters.userInfo.post_name}', 'input', 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-06-01 21:19:18', 1123598821738675201, TIMESTAMP '2021-06-01 21:19:18', '1', 0, '000000');
INSERT INTO QDPORT_WF_FORM_DEFAULT_VALUES (ID, NAME, CONTENT, FIELD_TYPE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1399717285564858369, '当前时间', '${this.dateFormat(new Date(),"hh:mm:ss")}', 'input', 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-06-01 21:19:41', 1123598821738675201, TIMESTAMP '2021-06-01 21:34:34', '1', 0, '000000');
INSERT INTO QDPORT_WF_FORM_DEFAULT_VALUES (ID, NAME, CONTENT, FIELD_TYPE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1399718803940655106, '当前操作人姓名和日期', '${this.$store.getters.userInfo.nick_name} - ${this.dateFormat(new Date(),"yyyy-MM-dd")}', 'input', 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-06-01 21:25:43', 1123598821738675201, TIMESTAMP '2021-06-01 21:34:40', '1', 0, '000000');
INSERT INTO QDPORT_WF_FORM_DEFAULT_VALUES (ID, NAME, CONTENT, FIELD_TYPE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1408401952027443201, '当前操作人姓名', '${this.$store.getters.userInfo.nick_name}', 'input', 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-06-25 20:29:27', 1123598821738675201, TIMESTAMP '2021-06-25 20:29:32', '1', 1, '000000');

INSERT INTO QDPORT_WF_CONDITION (ID, NAME, EXPRESSION, TYPE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1408267023015739393, '流程发起人', 'applyUser', 'user', 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-06-25 11:33:17', 1123598821738675201, TIMESTAMP '2021-06-25 11:33:17', '1', 0, '000000');
INSERT INTO QDPORT_WF_CONDITION (ID, NAME, EXPRESSION, TYPE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1408267100878798850, '当前操作人', 'currentUser', 'user', 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-06-25 11:33:36', 1123598821738675201, TIMESTAMP '2021-06-25 11:33:36', '1', 0, '000000');
INSERT INTO QDPORT_WF_CONDITION (ID, NAME, EXPRESSION, TYPE, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1408305933398896641, '上级部门领导', 'leader', 'user', 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-06-25 14:07:54', 1123598821738675201, TIMESTAMP '2021-06-25 14:07:54', '1', 0, '000000');

INSERT INTO QDPORT_WF_BUTTON (ID, BUTTON_KEY, NAME, DISPLAY, SORT, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1394176899911041025, 'wf_pass', '通过', 1, 1, 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-16 14:24:10', 1123598821738675201, TIMESTAMP '2021-05-16 14:24:10', '1', 0, '000000');
INSERT INTO QDPORT_WF_BUTTON (ID, BUTTON_KEY, NAME, DISPLAY, SORT, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1394177198465794050, 'wf_reject', '驳回', 1, 2, 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-16 14:25:21', 1123598821738675201, TIMESTAMP '2021-05-16 14:25:21', '1', 0, '000000');
INSERT INTO QDPORT_WF_BUTTON (ID, BUTTON_KEY, NAME, DISPLAY, SORT, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1394179125421326337, 'wf_print', '打印', 1, 3, 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-16 14:33:01', 1123598821738675201, TIMESTAMP '2021-05-16 14:33:01', '1', 0, '000000');
INSERT INTO QDPORT_WF_BUTTON (ID, BUTTON_KEY, NAME, DISPLAY, SORT, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1394609969089761281, 'wf_transfer', '转办', 1, 4, 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-16 19:05:02', 1123598821738675201, TIMESTAMP '2021-05-16 19:05:02', '1', 0, '000000');
INSERT INTO QDPORT_WF_BUTTON (ID, BUTTON_KEY, NAME, DISPLAY, SORT, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1394610036672581634, 'wf_delegate', '委托', 1, 5, 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-16 19:05:18', 1123598821738675201, TIMESTAMP '2021-05-16 19:05:18', '1', 0, '000000');
INSERT INTO QDPORT_WF_BUTTON (ID, BUTTON_KEY, NAME, DISPLAY, SORT, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1395271519601426433, 'wf_terminate', '终止', 1, 6, 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-20 14:53:48', 1123598821738675201, TIMESTAMP '2021-05-20 14:53:48', '1', 0, '000000');
INSERT INTO QDPORT_WF_BUTTON (ID, BUTTON_KEY, NAME, DISPLAY, SORT, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1395274709692579841, 'wf_add_instance', '加签', 1, 7, 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-20 15:06:28', 1123598821738675201, TIMESTAMP '2021-05-20 15:06:28', '1', 0, '000000');
INSERT INTO QDPORT_WF_BUTTON (ID, BUTTON_KEY, NAME, DISPLAY, SORT, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1395274774674931713, 'wf_del_instance', '减签', 1, 8, 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-20 15:06:44', 1123598821738675201, TIMESTAMP '2021-05-20 15:06:44', '1', 0, '000000');
INSERT INTO QDPORT_WF_BUTTON (ID, BUTTON_KEY, NAME, DISPLAY, SORT, CREATE_USER, CREATE_DEPT, CREATE_TIME, UPDATE_USER, UPDATE_TIME, STATUS, IS_DELETED, TENANT_ID) VALUES (1395274955986305025, 'wf_rollback', '指定回退', 1, 9, 1123598821738675201, 1123598813738675201, TIMESTAMP '2021-05-20 15:07:27', 1123598821738675201, TIMESTAMP '2021-05-20 15:07:27', '1', 0, '000000');

INSERT INTO "T_PARAM" ("ID", "PARAM_NAME", "PARAM_KEY", "PARAM_VALUE", "REMARK", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('4', '当前日志总容量', 'es.total.capacity', '1024', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO "T_PARAM" ("ID", "PARAM_NAME", "PARAM_KEY", "PARAM_VALUE", "REMARK", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('5', '日志已使用容量', 'es.used.capacity', '331', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO "T_PARAM" ("ID", "PARAM_NAME", "PARAM_KEY", "PARAM_VALUE", "REMARK", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('1123598819738675203', '账号错误锁定次数', 'account.failCount', '5', '锁定次数', '1123598821738675201', '1123598813738675201', TO_DATE('2021-12-01 12:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2021-12-01 12:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "T_PARAM" ("ID", "PARAM_NAME", "PARAM_KEY", "PARAM_VALUE", "REMARK", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('1238706101399142402', '租户默认管理密码', 'tenant.default.password', 'admin', NULL, '1123598821738675201', '1123598813738675201', TO_DATE('2020-03-14 13:58:43', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2020-03-14 13:58:43', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "T_PARAM" ("ID", "PARAM_NAME", "PARAM_KEY", "PARAM_VALUE", "REMARK", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('1238706160295559170', '租户默认账号额度', 'tenant.default.accountNumber', '100', NULL, '1123598821738675201', '1123598813738675201', TO_DATE('2020-03-14 13:58:57', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2020-03-14 13:58:57', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "T_PARAM" ("ID", "PARAM_NAME", "PARAM_KEY", "PARAM_VALUE", "REMARK", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('1238706330076790786', '租户默认菜单集合', 'tenant.default.menuCode', 'desk,flow,work,monitor,resource,role,user,dept,post,dictbiz,topmenu', NULL, '1123598821738675201', '1123598813738675201', TO_DATE('2020-03-14 13:59:38', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2020-03-14 13:59:38', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "T_PARAM" ("ID", "PARAM_NAME", "PARAM_KEY", "PARAM_VALUE", "REMARK", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('1640239194376769537', '测试1', 'tes1t', 'true1', '01', NULL, NULL, TO_DATE('2023-03-27 14:27:52', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2023-03-27 14:31:31', 'SYYYY-MM-DD HH24:MI:SS'), '1', '1');
INSERT INTO "T_PARAM" ("ID", "PARAM_NAME", "PARAM_KEY", "PARAM_VALUE", "REMARK", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('1123598819738675201', '是否开启注册功能', 'account.registerUser', 'true', '开启注册', '1123598821738675201', '1123598813738675201', TO_DATE('2018-12-28 12:19:01', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2018-12-28 12:19:01', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "T_PARAM" ("ID", "PARAM_NAME", "PARAM_KEY", "PARAM_VALUE", "REMARK", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED") VALUES ('1123598819738675202', '账号初始密码', 'account.initPassword', '123456', '初始密码', '1123598821738675201', '1123598813738675201', TO_DATE('2018-12-28 12:19:01', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2018-12-28 12:19:01', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');



commit;