/* Navicat MySQL Data Transfer Source Server : 192.168.1.201(会议室服务器) Source Server Version : 50734 Source Host : 192.168.1.201:3306 Source Database : mx-boot Target Server Type : MYSQL Target Server Version : 50734 File Encoding : 65001 Date: 2021-07-02 12:19:53 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for onl_auth_data -- ---------------------------- DROP TABLE IF EXISTS `onl_auth_data`; CREATE TABLE `onl_auth_data` ( `id` varchar(32) NOT NULL COMMENT '主键', `cgform_id` varchar(32) DEFAULT NULL COMMENT 'online表ID', `rule_name` varchar(50) DEFAULT NULL COMMENT '规则名', `rule_column` varchar(50) DEFAULT NULL COMMENT '规则列', `rule_operator` varchar(50) DEFAULT NULL COMMENT '规则条件 大于小于like', `rule_value` varchar(255) DEFAULT NULL COMMENT '规则值', `status` int(1) DEFAULT NULL COMMENT '1有效 0无效', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '创建人', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_auth_data -- ---------------------------- -- ---------------------------- -- Table structure for onl_auth_page -- ---------------------------- DROP TABLE IF EXISTS `onl_auth_page`; CREATE TABLE `onl_auth_page` ( `id` varchar(32) NOT NULL COMMENT ' 主键', `cgform_id` varchar(32) DEFAULT NULL COMMENT 'online表id', `code` varchar(255) DEFAULT NULL COMMENT '字段名/按钮编码', `type` int(1) DEFAULT NULL COMMENT '1字段 2按钮', `control` int(1) DEFAULT NULL COMMENT '3可编辑 5可见(仅支持两种状态值3,5)', `page` int(1) DEFAULT NULL COMMENT '3列表 5表单(仅支持两种状态值3,5)', `status` int(1) DEFAULT NULL COMMENT '1有效 0无效', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '创建人', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_auth_page -- ---------------------------- -- ---------------------------- -- Table structure for onl_auth_relation -- ---------------------------- DROP TABLE IF EXISTS `onl_auth_relation`; CREATE TABLE `onl_auth_relation` ( `id` varchar(32) NOT NULL, `role_id` varchar(32) DEFAULT NULL COMMENT '角色id', `auth_id` varchar(32) DEFAULT NULL COMMENT '权限id', `type` int(1) DEFAULT NULL COMMENT '1字段 2按钮 3数据权限', `cgform_id` varchar(32) DEFAULT NULL COMMENT 'online表单ID', `auth_mode` varchar(50) DEFAULT NULL COMMENT '授权方式role角色，depart部门，user人', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_auth_relation -- ---------------------------- -- ---------------------------- -- Table structure for onl_cgform_button -- ---------------------------- DROP TABLE IF EXISTS `onl_cgform_button`; CREATE TABLE `onl_cgform_button` ( `ID` varchar(32) NOT NULL COMMENT '主键ID', `BUTTON_CODE` varchar(50) DEFAULT NULL COMMENT '按钮编码', `BUTTON_ICON` varchar(20) DEFAULT NULL COMMENT '按钮图标', `BUTTON_NAME` varchar(50) DEFAULT NULL COMMENT '按钮名称', `BUTTON_STATUS` varchar(2) DEFAULT NULL COMMENT '按钮状态', `BUTTON_STYLE` varchar(20) DEFAULT NULL COMMENT '按钮样式', `EXP` varchar(255) DEFAULT NULL COMMENT '表达式', `CGFORM_HEAD_ID` varchar(32) DEFAULT NULL COMMENT '表单ID', `OPT_TYPE` varchar(20) DEFAULT NULL COMMENT '按钮类型', `ORDER_NUM` int(11) DEFAULT NULL COMMENT '排序', `OPT_POSITION` varchar(3) DEFAULT NULL COMMENT '按钮位置1侧面 2底部', PRIMARY KEY (`ID`) USING BTREE, KEY `index_formid` (`CGFORM_HEAD_ID`) USING BTREE, KEY `index_button_code` (`BUTTON_CODE`) USING BTREE, KEY `index_button_status` (`BUTTON_STATUS`) USING BTREE, KEY `index_button_order` (`ORDER_NUM`) USING BTREE, KEY `idx_ocb_CGFORM_HEAD_ID` (`CGFORM_HEAD_ID`) USING BTREE, KEY `idx_ocb_BUTTON_CODE` (`BUTTON_CODE`) USING BTREE, KEY `idx_ocb_BUTTON_STATUS` (`BUTTON_STATUS`) USING BTREE, KEY `idx_ocb_ORDER_NUM` (`ORDER_NUM`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Online表单自定义按钮'; -- ---------------------------- -- Records of onl_cgform_button -- ---------------------------- -- ---------------------------- -- Table structure for onl_cgform_enhance_java -- ---------------------------- DROP TABLE IF EXISTS `onl_cgform_enhance_java`; CREATE TABLE `onl_cgform_enhance_java` ( `ID` varchar(36) NOT NULL, `BUTTON_CODE` varchar(32) DEFAULT NULL COMMENT '按钮编码', `CG_JAVA_TYPE` varchar(32) NOT NULL COMMENT '类型', `CG_JAVA_VALUE` varchar(200) NOT NULL COMMENT '数值', `CGFORM_HEAD_ID` varchar(32) NOT NULL COMMENT '表单ID', `ACTIVE_STATUS` varchar(2) DEFAULT '1' COMMENT '生效状态', `EVENT` varchar(10) NOT NULL DEFAULT 'end' COMMENT '事件状态(end:结束，start:开始)', PRIMARY KEY (`ID`) USING BTREE, KEY `index_buttoncode` (`BUTTON_CODE`) USING BTREE, KEY `index_status` (`ACTIVE_STATUS`) USING BTREE, KEY `idx_ejava_cgform_head_id` (`CGFORM_HEAD_ID`) USING BTREE, KEY `idx_ocej_BUTTON_CODE` (`BUTTON_CODE`) USING BTREE, KEY `idx_ocej_ACTIVE_STATUS` (`ACTIVE_STATUS`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_cgform_enhance_java -- ---------------------------- -- ---------------------------- -- Table structure for onl_cgform_enhance_js -- ---------------------------- DROP TABLE IF EXISTS `onl_cgform_enhance_js`; CREATE TABLE `onl_cgform_enhance_js` ( `ID` varchar(32) NOT NULL COMMENT '主键ID', `CG_JS` longtext COMMENT 'JS增强内容', `CG_JS_TYPE` varchar(20) DEFAULT NULL COMMENT '类型', `CONTENT` varchar(1000) DEFAULT NULL COMMENT '备注', `CGFORM_HEAD_ID` varchar(32) DEFAULT NULL COMMENT '表单ID', PRIMARY KEY (`ID`) USING BTREE, KEY `index_fmid` (`CGFORM_HEAD_ID`) USING BTREE, KEY `index_jstype` (`CG_JS_TYPE`) USING BTREE, KEY `idx_ejs_cgform_head_id` (`CGFORM_HEAD_ID`) USING BTREE, KEY `idx_ejs_cg_js_type` (`CG_JS_TYPE`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_cgform_enhance_js -- ---------------------------- -- ---------------------------- -- Table structure for onl_cgform_enhance_sql -- ---------------------------- DROP TABLE IF EXISTS `onl_cgform_enhance_sql`; CREATE TABLE `onl_cgform_enhance_sql` ( `ID` varchar(32) NOT NULL COMMENT '主键ID', `BUTTON_CODE` varchar(50) DEFAULT NULL COMMENT '按钮编码', `CGB_SQL` longtext COMMENT 'SQL内容', `CGB_SQL_NAME` varchar(50) DEFAULT NULL COMMENT 'Sql名称', `CONTENT` varchar(1000) DEFAULT NULL COMMENT '备注', `CGFORM_HEAD_ID` varchar(32) DEFAULT NULL COMMENT '表单ID', PRIMARY KEY (`ID`) USING BTREE, KEY `index_formid` (`CGFORM_HEAD_ID`) USING BTREE, KEY `idx_oces_CGFORM_HEAD_ID` (`CGFORM_HEAD_ID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_cgform_enhance_sql -- ---------------------------- -- ---------------------------- -- Table structure for onl_cgform_field -- ---------------------------- DROP TABLE IF EXISTS `onl_cgform_field`; CREATE TABLE `onl_cgform_field` ( `id` varchar(32) NOT NULL COMMENT '主键ID', `cgform_head_id` varchar(32) NOT NULL COMMENT '表ID', `db_field_name` varchar(32) NOT NULL COMMENT '字段名字', `db_field_txt` varchar(200) DEFAULT NULL COMMENT '字段备注', `db_field_name_old` varchar(32) DEFAULT NULL COMMENT '原字段名', `db_is_key` tinyint(1) DEFAULT NULL COMMENT '是否主键 0否 1是', `db_is_null` tinyint(1) DEFAULT NULL COMMENT '是否允许为空0否 1是', `db_type` varchar(32) NOT NULL COMMENT '数据库字段类型', `db_length` int(11) NOT NULL COMMENT '数据库字段长度', `db_point_length` int(11) DEFAULT NULL COMMENT '小数点', `db_default_val` varchar(20) DEFAULT NULL COMMENT '表字段默认值', `dict_field` varchar(100) DEFAULT NULL COMMENT '字典code', `dict_table` varchar(255) DEFAULT NULL COMMENT '字典表', `dict_text` varchar(100) DEFAULT NULL COMMENT '字典Text', `field_show_type` varchar(10) DEFAULT NULL COMMENT '表单控件类型', `field_href` varchar(200) DEFAULT NULL COMMENT '跳转URL', `field_length` int(11) DEFAULT NULL COMMENT '表单控件长度', `field_valid_type` varchar(300) DEFAULT NULL COMMENT '表单字段校验规则', `field_must_input` varchar(2) DEFAULT NULL COMMENT '字段是否必填', `field_extend_json` varchar(500) DEFAULT NULL COMMENT '扩展参数JSON', `field_default_value` varchar(100) DEFAULT NULL COMMENT '控件默认值，不同的表达式展示不同的结果。\r\n1. 纯字符串直接赋给默认值；\r\n2. #{普通变量}；\r\n3. {{ 动态JS表达式 }}；\r\n4. ${填值规则编码}；\r\n填值规则表达式只允许存在一个，且不能和其他规则混用。', `is_query` tinyint(1) DEFAULT NULL COMMENT '是否查询条件0否 1是', `is_show_form` tinyint(1) DEFAULT NULL COMMENT '表单是否显示0否 1是', `is_show_list` tinyint(1) DEFAULT NULL COMMENT '列表是否显示0否 1是', `is_read_only` tinyint(1) DEFAULT '0' COMMENT '是否是只读（1是 0否）', `query_mode` varchar(10) DEFAULT NULL COMMENT '查询模式', `main_table` varchar(100) DEFAULT NULL COMMENT '外键主表名', `main_field` varchar(100) DEFAULT NULL COMMENT '外键主键字段', `order_num` int(11) DEFAULT NULL COMMENT '排序', `update_by` varchar(32) DEFAULT NULL COMMENT '修改人', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(255) DEFAULT NULL COMMENT '创建人', `converter` varchar(255) DEFAULT NULL COMMENT '自定义值转换器', `query_def_val` varchar(50) DEFAULT NULL COMMENT '查询默认值', `query_dict_text` varchar(100) DEFAULT NULL COMMENT '查询配置字典text', `query_dict_field` varchar(100) DEFAULT NULL COMMENT '查询配置字典code', `query_dict_table` varchar(500) DEFAULT NULL COMMENT '查询配置字典table', `query_show_type` varchar(50) DEFAULT NULL COMMENT '查询显示控件', `query_config_flag` varchar(3) DEFAULT NULL COMMENT '是否启用查询配置1是0否', `query_valid_type` varchar(50) DEFAULT NULL COMMENT '查询字段校验类型', `query_must_input` varchar(3) DEFAULT NULL COMMENT '查询字段是否必填1是0否', `sort_flag` varchar(3) DEFAULT NULL COMMENT '是否支持排序1是0否', PRIMARY KEY (`id`) USING BTREE, KEY `inex_table_id` (`cgform_head_id`) USING BTREE, KEY `idx_ocf_cgform_head_id` (`cgform_head_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_cgform_field -- ---------------------------- -- ---------------------------- -- Table structure for onl_cgform_head -- ---------------------------- DROP TABLE IF EXISTS `onl_cgform_head`; CREATE TABLE `onl_cgform_head` ( `id` varchar(32) NOT NULL COMMENT '主键ID', `table_name` varchar(50) NOT NULL COMMENT '表名', `table_type` int(11) NOT NULL COMMENT '表类型: 0单表、1主表、2附表', `table_version` int(11) DEFAULT '1' COMMENT '表版本', `table_txt` varchar(200) NOT NULL COMMENT '表说明', `is_checkbox` varchar(5) NOT NULL COMMENT '是否带checkbox', `is_db_synch` varchar(20) NOT NULL DEFAULT 'N' COMMENT '同步数据库状态', `is_page` varchar(5) NOT NULL COMMENT '是否分页', `is_tree` varchar(5) NOT NULL COMMENT '是否是树', `id_sequence` varchar(200) DEFAULT NULL COMMENT '主键生成序列', `id_type` varchar(100) DEFAULT NULL COMMENT '主键类型', `query_mode` varchar(10) DEFAULT NULL COMMENT '查询模式', `relation_type` int(11) DEFAULT NULL COMMENT '映射关系 0一对多 1一对一', `sub_table_str` varchar(1000) DEFAULT NULL COMMENT '子表', `tab_order_num` int(11) DEFAULT NULL COMMENT '附表排序序号', `tree_parent_id_field` varchar(50) DEFAULT NULL COMMENT '树形表单父id', `tree_id_field` varchar(50) DEFAULT NULL COMMENT '树表主键字段', `tree_fieldname` varchar(50) DEFAULT NULL COMMENT '树开表单列字段', `form_category` varchar(50) NOT NULL DEFAULT 'bdfl_ptbd' COMMENT '表单分类', `form_template` varchar(50) DEFAULT NULL COMMENT 'PC表单模板', `form_template_mobile` varchar(50) DEFAULT NULL COMMENT '表单模板样式(移动端)', `scroll` int(3) DEFAULT '0' COMMENT '是否有横向滚动条', `copy_version` int(11) DEFAULT NULL COMMENT '复制版本号', `copy_type` int(3) DEFAULT '0' COMMENT '复制表类型1为复制表 0为原始表', `physic_id` varchar(32) DEFAULT NULL COMMENT '原始表ID', `update_by` varchar(32) DEFAULT NULL COMMENT '修改人', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `theme_template` varchar(50) DEFAULT NULL COMMENT '主题模板', `is_des_form` varchar(2) DEFAULT NULL COMMENT '是否用设计器表单', `des_form_code` varchar(50) DEFAULT NULL COMMENT '设计器表单编码', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `index_onlineform_table_name` (`table_name`) USING BTREE, KEY `index_form_templdate` (`form_template`) USING BTREE, KEY `index_templdate_mobile` (`form_template_mobile`) USING BTREE, KEY `index_onlineform_table_version` (`table_version`) USING BTREE, KEY `idx_och_cgform_head_id` (`table_name`) USING BTREE, KEY `idx_och_table_name` (`form_template`) USING BTREE, KEY `idx_och_form_template_mobile` (`form_template_mobile`) USING BTREE, KEY `idx_och_table_version` (`table_version`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_cgform_head -- ---------------------------- -- ---------------------------- -- Table structure for onl_cgform_index -- ---------------------------- DROP TABLE IF EXISTS `onl_cgform_index`; CREATE TABLE `onl_cgform_index` ( `id` varchar(36) NOT NULL COMMENT '主键', `cgform_head_id` varchar(32) DEFAULT NULL COMMENT '主表id', `index_name` varchar(100) DEFAULT NULL COMMENT '索引名称', `index_field` varchar(500) DEFAULT NULL COMMENT '索引栏位', `index_type` varchar(32) DEFAULT NULL COMMENT '索引类型', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `is_db_synch` varchar(2) DEFAULT 'N' COMMENT '是否同步数据库 N未同步 Y已同步', `del_flag` int(1) DEFAULT '0' COMMENT '是否删除 0未删除 1删除', PRIMARY KEY (`id`) USING BTREE, KEY `index_table_id` (`cgform_head_id`) USING BTREE, KEY `idx_oci_cgform_head_id` (`cgform_head_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_cgform_index -- ---------------------------- -- ---------------------------- -- Table structure for onl_cgreport_head -- ---------------------------- DROP TABLE IF EXISTS `onl_cgreport_head`; CREATE TABLE `onl_cgreport_head` ( `id` varchar(36) NOT NULL, `code` varchar(100) NOT NULL COMMENT '报表编码', `name` varchar(100) NOT NULL COMMENT '报表名字', `cgr_sql` varchar(1000) NOT NULL COMMENT '报表SQL', `return_val_field` varchar(100) DEFAULT NULL COMMENT '返回值字段', `return_txt_field` varchar(100) DEFAULT NULL COMMENT '返回文本字段', `return_type` varchar(2) DEFAULT '1' COMMENT '返回类型，单选或多选', `db_source` varchar(100) DEFAULT NULL COMMENT '动态数据源', `content` varchar(1000) DEFAULT NULL COMMENT '描述', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `update_by` varchar(32) DEFAULT NULL COMMENT '修改人id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人id', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `index_onlinereport_code` (`code`) USING BTREE, KEY `idx_och_code` (`code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_cgreport_head -- ---------------------------- -- ---------------------------- -- Table structure for onl_cgreport_item -- ---------------------------- DROP TABLE IF EXISTS `onl_cgreport_item`; CREATE TABLE `onl_cgreport_item` ( `id` varchar(36) NOT NULL, `cgrhead_id` varchar(36) NOT NULL COMMENT '报表ID', `field_name` varchar(36) NOT NULL COMMENT '字段名字', `field_txt` varchar(300) DEFAULT NULL COMMENT '字段文本', `field_width` int(3) DEFAULT NULL, `field_type` varchar(10) DEFAULT NULL COMMENT '字段类型', `search_mode` varchar(10) DEFAULT NULL COMMENT '查询模式', `is_order` int(2) DEFAULT '0' COMMENT '是否排序 0否,1是', `is_search` int(2) DEFAULT '0' COMMENT '是否查询 0否,1是', `dict_code` varchar(500) DEFAULT NULL COMMENT '字典CODE', `field_href` varchar(120) DEFAULT NULL COMMENT '字段跳转URL', `is_show` int(2) DEFAULT '1' COMMENT '是否显示 0否,1显示', `order_num` int(11) DEFAULT NULL COMMENT '排序', `replace_val` varchar(200) DEFAULT NULL COMMENT '取值表达式', `is_total` varchar(2) DEFAULT NULL COMMENT '是否合计 0否,1是（仅对数值有效）', `group_title` varchar(50) DEFAULT NULL COMMENT '分组标题', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) DEFAULT NULL COMMENT '修改人', `update_time` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE, KEY `index_CGRHEAD_ID` (`cgrhead_id`) USING BTREE, KEY `index_isshow` (`is_show`) USING BTREE, KEY `index_order_num` (`order_num`) USING BTREE, KEY `idx_oci_cgrhead_id` (`cgrhead_id`) USING BTREE, KEY `idx_oci_is_show` (`is_show`) USING BTREE, KEY `idx_oci_order_num` (`order_num`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_cgreport_item -- ---------------------------- -- ---------------------------- -- Table structure for onl_cgreport_param -- ---------------------------- DROP TABLE IF EXISTS `onl_cgreport_param`; CREATE TABLE `onl_cgreport_param` ( `id` varchar(36) NOT NULL, `cgrhead_id` varchar(36) NOT NULL COMMENT '动态报表ID', `param_name` varchar(32) NOT NULL COMMENT '参数字段', `param_txt` varchar(32) DEFAULT NULL COMMENT '参数文本', `param_value` varchar(32) DEFAULT NULL COMMENT '参数默认值', `order_num` int(11) DEFAULT NULL COMMENT '排序', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称', `update_time` datetime DEFAULT NULL COMMENT '更新日期', PRIMARY KEY (`id`) USING BTREE, KEY `idx_cgrheadid` (`cgrhead_id`) USING BTREE, KEY `idx_ocp_cgrhead_id` (`cgrhead_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of onl_cgreport_param -- ---------------------------- -- ---------------------------- -- Table structure for oss_file -- ---------------------------- DROP TABLE IF EXISTS `oss_file`; CREATE TABLE `oss_file` ( `id` varchar(32) NOT NULL COMMENT '主键id', `file_name` varchar(255) DEFAULT NULL COMMENT '文件名称', `url` varchar(255) DEFAULT NULL COMMENT '文件地址', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人登录名称', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人登录名称', `update_time` datetime DEFAULT NULL COMMENT '更新日期', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Oss File'; -- ---------------------------- -- Records of oss_file -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_blob_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_blob_triggers`; CREATE TABLE `qrtz_blob_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `BLOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE, CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 504832 kB; (`SCHED_NAME` `TRIGGER_NAME` `TRIGGE'; -- ---------------------------- -- Records of qrtz_blob_triggers -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_calendars -- ---------------------------- DROP TABLE IF EXISTS `qrtz_calendars`; CREATE TABLE `qrtz_calendars` ( `SCHED_NAME` varchar(120) NOT NULL, `CALENDAR_NAME` varchar(200) NOT NULL, `CALENDAR` blob NOT NULL, PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of qrtz_calendars -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_cron_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_cron_triggers`; CREATE TABLE `qrtz_cron_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `CRON_EXPRESSION` varchar(200) NOT NULL, `TIME_ZONE_ID` varchar(80) DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE, CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 504832 kB; (`SCHED_NAME` `TRIGGER_NAME` `TRIGGE'; -- ---------------------------- -- Records of qrtz_cron_triggers -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_fired_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_fired_triggers`; CREATE TABLE `qrtz_fired_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `ENTRY_ID` varchar(95) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `INSTANCE_NAME` varchar(200) NOT NULL, `FIRED_TIME` bigint(13) NOT NULL, `SCHED_TIME` bigint(13) NOT NULL, `PRIORITY` int(11) NOT NULL, `STATE` varchar(16) NOT NULL, `JOB_NAME` varchar(200) DEFAULT NULL, `JOB_GROUP` varchar(200) DEFAULT NULL, `IS_NONCONCURRENT` varchar(1) DEFAULT NULL, `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of qrtz_fired_triggers -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_job_details -- ---------------------------- DROP TABLE IF EXISTS `qrtz_job_details`; CREATE TABLE `qrtz_job_details` ( `SCHED_NAME` varchar(120) NOT NULL, `JOB_NAME` varchar(200) NOT NULL, `JOB_GROUP` varchar(200) NOT NULL, `DESCRIPTION` varchar(250) DEFAULT NULL, `JOB_CLASS_NAME` varchar(250) NOT NULL, `IS_DURABLE` varchar(1) NOT NULL, `IS_NONCONCURRENT` varchar(1) NOT NULL, `IS_UPDATE_DATA` varchar(1) NOT NULL, `REQUESTS_RECOVERY` varchar(1) NOT NULL, `JOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of qrtz_job_details -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_locks -- ---------------------------- DROP TABLE IF EXISTS `qrtz_locks`; CREATE TABLE `qrtz_locks` ( `SCHED_NAME` varchar(120) NOT NULL, `LOCK_NAME` varchar(40) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of qrtz_locks -- ---------------------------- INSERT INTO `qrtz_locks` VALUES ('MyScheduler', 'STATE_ACCESS'); INSERT INTO `qrtz_locks` VALUES ('MyScheduler', 'TRIGGER_ACCESS'); INSERT INTO `qrtz_locks` VALUES ('quartzScheduler', 'TRIGGER_ACCESS'); -- ---------------------------- -- Table structure for qrtz_paused_trigger_grps -- ---------------------------- DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`; CREATE TABLE `qrtz_paused_trigger_grps` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of qrtz_paused_trigger_grps -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_scheduler_state -- ---------------------------- DROP TABLE IF EXISTS `qrtz_scheduler_state`; CREATE TABLE `qrtz_scheduler_state` ( `SCHED_NAME` varchar(120) NOT NULL, `INSTANCE_NAME` varchar(200) NOT NULL, `LAST_CHECKIN_TIME` bigint(13) NOT NULL, `CHECKIN_INTERVAL` bigint(13) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of qrtz_scheduler_state -- ---------------------------- INSERT INTO `qrtz_scheduler_state` VALUES ('MyScheduler', 'DESKTOP-BA1KOFH1625199523355', '1625199590288', '10000'); -- ---------------------------- -- Table structure for qrtz_simple_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_simple_triggers`; CREATE TABLE `qrtz_simple_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `REPEAT_COUNT` bigint(7) NOT NULL, `REPEAT_INTERVAL` bigint(12) NOT NULL, `TIMES_TRIGGERED` bigint(10) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE, CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 504832 kB; (`SCHED_NAME` `TRIGGER_NAME` `TRIGGE'; -- ---------------------------- -- Records of qrtz_simple_triggers -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_simprop_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_simprop_triggers`; CREATE TABLE `qrtz_simprop_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `STR_PROP_1` varchar(512) DEFAULT NULL, `STR_PROP_2` varchar(512) DEFAULT NULL, `STR_PROP_3` varchar(512) DEFAULT NULL, `INT_PROP_1` int(11) DEFAULT NULL, `INT_PROP_2` int(11) DEFAULT NULL, `LONG_PROP_1` bigint(20) DEFAULT NULL, `LONG_PROP_2` bigint(20) DEFAULT NULL, `DEC_PROP_1` decimal(13,4) DEFAULT NULL, `DEC_PROP_2` decimal(13,4) DEFAULT NULL, `BOOL_PROP_1` varchar(1) DEFAULT NULL, `BOOL_PROP_2` varchar(1) DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE, CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 504832 kB; (`SCHED_NAME` `TRIGGER_NAME` `TRIGGE'; -- ---------------------------- -- Records of qrtz_simprop_triggers -- ---------------------------- -- ---------------------------- -- Table structure for qrtz_triggers -- ---------------------------- DROP TABLE IF EXISTS `qrtz_triggers`; CREATE TABLE `qrtz_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `JOB_NAME` varchar(200) NOT NULL, `JOB_GROUP` varchar(200) NOT NULL, `DESCRIPTION` varchar(250) DEFAULT NULL, `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL, `PREV_FIRE_TIME` bigint(13) DEFAULT NULL, `PRIORITY` int(11) DEFAULT NULL, `TRIGGER_STATE` varchar(16) NOT NULL, `TRIGGER_TYPE` varchar(8) NOT NULL, `START_TIME` bigint(13) NOT NULL, `END_TIME` bigint(13) DEFAULT NULL, `CALENDAR_NAME` varchar(200) DEFAULT NULL, `MISFIRE_INSTR` smallint(2) DEFAULT NULL, `JOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE, KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE, CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 504832 kB; (`SCHED_NAME` `JOB_NAME` `JOB_GROUP`'; -- ---------------------------- -- Records of qrtz_triggers -- ---------------------------- -- ---------------------------- -- Table structure for rep_demo_dxtj -- ---------------------------- DROP TABLE IF EXISTS `rep_demo_dxtj`; CREATE TABLE `rep_demo_dxtj` ( `id` varchar(36) NOT NULL COMMENT '主键', `name` varchar(50) DEFAULT NULL COMMENT '姓名', `gtime` datetime DEFAULT NULL COMMENT '雇佣日期', `update_by` varchar(50) DEFAULT NULL COMMENT '职务', `jphone` varchar(125) DEFAULT NULL COMMENT '家庭电话', `birth` datetime DEFAULT NULL COMMENT '出生日期', `hukou` varchar(32) DEFAULT NULL COMMENT '户口所在地', `laddress` varchar(125) DEFAULT NULL COMMENT '联系地址', `jperson` varchar(32) DEFAULT NULL COMMENT '紧急联系人', `sex` varchar(32) DEFAULT NULL COMMENT 'xingbie', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of rep_demo_dxtj -- ---------------------------- INSERT INTO `rep_demo_dxtj` VALUES ('1338808084247613441', '张三', '2019-11-06 00:00:00', '1', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809169074982920', '张小哲', '2019-11-06 00:00:00', '2', '18034596971', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809448658898952', '闫妮', '2019-11-06 00:00:00', '2', '18034596972', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809620973490184', '陌生', '2019-11-06 00:00:00', '2', '18034596973', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809652606930952', '贺江', '2019-11-06 00:00:00', '2', '18034596974', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '2'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809685200867336', '村子明', '2019-11-06 00:00:00', '3', '18034596975', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '2'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809710203113481', '尚德', '2019-11-06 00:00:00', '4', '18034596977', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809749470187528', '郑恺', '2019-11-06 00:00:00', '4', '18034596978', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809774971555849', '未名园', '2019-11-06 00:00:00', '4', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809805199904777', '韩寒', '2019-11-06 00:00:00', '5', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809830017601544', '迪丽热拉', '2019-11-06 00:00:00', '6', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1338809864356368393', '张一山', '2019-11-06 00:00:00', '6', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157602480137', '张三', '2019-11-06 00:00:00', '1', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157602480146', '张大大', '2019-11-06 00:00:00', '2', '18034596971', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674439', '郭美美', '2019-11-06 00:00:00', '2', '18034596972', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674448', '莫愁', '2019-11-06 00:00:00', '2', '18034596973', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674457', '鲁与', '2019-11-06 00:00:00', '2', '18034596974', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '2'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674466', '高尚', '2019-11-06 00:00:00', '3', '18034596975', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '2'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674475', '尚北京', '2019-11-06 00:00:00', '4', '18034596977', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674484', '杨颖花', '2019-11-06 00:00:00', '4', '18034596978', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674493', '李丽', '2019-11-06 00:00:00', '4', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674502', '韩露露', '2019-11-06 00:00:00', '5', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674511', '李凯泽', '2019-11-06 00:00:00', '6', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674520', '王明阳', '2019-11-06 00:00:00', '6', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1'); -- ---------------------------- -- Table structure for rep_demo_employee -- ---------------------------- DROP TABLE IF EXISTS `rep_demo_employee`; CREATE TABLE `rep_demo_employee` ( `id` varchar(10) NOT NULL COMMENT '主键', `num` varchar(50) DEFAULT NULL COMMENT '编号', `name` varchar(100) DEFAULT NULL COMMENT '姓名', `sex` varchar(10) DEFAULT NULL COMMENT '性别', `birthday` datetime DEFAULT NULL COMMENT '出生日期', `nation` varchar(30) DEFAULT NULL COMMENT '民族', `political` varchar(30) DEFAULT NULL COMMENT '政治面貌', `native_place` varchar(30) DEFAULT NULL COMMENT '籍贯', `height` varchar(30) DEFAULT NULL COMMENT '身高', `weight` varchar(30) DEFAULT NULL COMMENT '体重', `health` varchar(30) DEFAULT NULL COMMENT '健康状况', `id_card` varchar(80) DEFAULT NULL COMMENT '身份证号', `education` varchar(30) DEFAULT NULL COMMENT '学历', `school` varchar(80) DEFAULT NULL COMMENT '毕业学校', `major` varchar(80) DEFAULT NULL COMMENT '专业', `address` varchar(100) DEFAULT NULL COMMENT '联系地址', `zip_code` varchar(30) DEFAULT NULL COMMENT '邮编', `email` varchar(30) DEFAULT NULL COMMENT 'Email', `phone` varchar(30) DEFAULT NULL COMMENT '手机号', `foreign_language` varchar(30) DEFAULT NULL COMMENT '外语语种', `foreign_language_level` varchar(30) DEFAULT NULL COMMENT '外语水平', `computer_level` varchar(30) DEFAULT NULL COMMENT '计算机水平', `graduation_time` datetime DEFAULT NULL COMMENT '毕业时间', `arrival_time` datetime DEFAULT NULL COMMENT '到职时间', `positional_titles` varchar(30) DEFAULT NULL COMMENT '职称', `education_experience` text COMMENT '教育经历', `work_experience` text COMMENT '工作经历', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) DEFAULT NULL COMMENT '修改人', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `del_flag` tinyint(1) DEFAULT NULL COMMENT '删除标识0-正常,1-已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of rep_demo_employee -- ---------------------------- INSERT INTO `rep_demo_employee` VALUES ('1', '001', '张三', '男', '2000-02-04 13:36:19', '汉族', '团员', '北京', '170', '65', '良好', '110101200002044853', '大专', '北京科技', '计算机', '北京朝阳区', '1001', 'zhang@163.com', '18011111111', '英语', '三级', '三级', '2019-02-04 13:41:17', '2020-02-04 13:41:31', '项目经理', '2018年9月—2019年7月：北京语言文化大学比较文学研究所攻读博士学位，获得比较文学博士学位', '2019年5月---至今 XX公司     网络系统工程师  \n2019年5月---至今 XX公司     网络系统工程师', null, '2020-02-04 15:18:03', null, null, null); INSERT INTO `rep_demo_employee` VALUES ('2', '002', '王红', '女', '2000-02-04 13:36:19', '汉族', '团员', '北京', '170', '65', '良好', '110101200002044853', '大专', '北京科技', '计算机', '北京朝阳区', '1001', 'zhang@163.com', '18011111111', '英语', '三级', '三级', '2019-02-04 13:41:17', '2020-02-04 13:41:31', '项目经理', '2018年9月—2019年7月：北京语言文化大学比较文学研究所攻读博士学位，获得比较文学博士学位', '2019年5月---至今 XX公司     网络系统工程师  \n2019年5月---至今 XX公司     网络系统工程师', null, '2020-02-04 18:39:27', null, null, null); -- ---------------------------- -- Table structure for rep_demo_gongsi -- ---------------------------- DROP TABLE IF EXISTS `rep_demo_gongsi`; CREATE TABLE `rep_demo_gongsi` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gname` varchar(125) NOT NULL COMMENT '货品名称', `gdata` varchar(255) NOT NULL COMMENT '返利', `tdata` varchar(125) NOT NULL COMMENT '备注', `didian` varchar(255) NOT NULL, `zhaiyao` varchar(255) NOT NULL, `num` varchar(255) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of rep_demo_gongsi -- ---------------------------- INSERT INTO `rep_demo_gongsi` VALUES ('1', '北京天山海世界', '2020-02-30 11:12:25', '2020-02-25', '天山大厦', '1', '2399845661'); INSERT INTO `rep_demo_gongsi` VALUES ('2', 'dd天山海世界', '2020-02-30 11:12:25', '2020-02-25', '天山大厦', '1', '2399845661'); -- ---------------------------- -- Table structure for rep_demo_jianpiao -- ---------------------------- DROP TABLE IF EXISTS `rep_demo_jianpiao`; CREATE TABLE `rep_demo_jianpiao` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bnum` varchar(125) NOT NULL, `ftime` varchar(125) NOT NULL, `sfkong` varchar(125) NOT NULL, `kaishi` varchar(125) NOT NULL, `jieshu` varchar(125) NOT NULL, `hezairen` varchar(125) NOT NULL, `jpnum` varchar(125) NOT NULL, `shihelv` varchar(125) NOT NULL, `s_id` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of rep_demo_jianpiao -- ---------------------------- INSERT INTO `rep_demo_jianpiao` VALUES ('1', 'K7725', '21:13', '否', '秦皇岛', '邯郸', '300', '258', '86', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('2', 'k99', '16:55', '否', '包头', '广州', '800', '700', '88', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('3', 'G6737', '05:34', '否', '北京西', '邯郸东', '500', '256', '51', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('4', 'K7705', '07:03', '否', '北京', '邯郸', '400', '200', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('5', 'G437', '06:27', '否', '北京西', '兰州西', '800', '586', '73', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('6', 'G673', '06:32', '否', '北京西', '邯郸东', '300', '289', '87', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('7', 'G507', '06:43', '否', '北京西', '邯郸东', '300', '200', '67', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('8', 'G89', '06:53', '否', '北京西', '成都东', '800', '500', '62', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('9', 'K7712', '09:43', '否', '北京西', '西安北', '400', '200', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('10', 'G405', '10:05', '否', '北京西', '昆明南', '300', '200', '67', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('11', 'G6701', '10:38', '否', '北京西', '石家庄', '300', '200', '67', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('12', 'G487', '10:52', '否', '北京西', '南昌西', '800', '700', '88', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('13', 'G607', '11:14', '否', '北京西', '太原南', '400', '200', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('14', 'G667', '11:19', '否', '北京西', '西安北', '400', '200', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('15', 'Z49', '11:28', '否', '北京西', '成都', '400', '200', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('16', 'Z49', '11:28', '否', '北京西', '上海', '300', '200', '80', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('17', 'Z49', '11:56', '否', '北京西', '上海', '200', '180', '95', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('18', 'Z49', '11:36', '否', '北京南', '大晒', '200', '180', '96', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('19', 'Z123', '12:00', '否', '北京南', '重庆', '1000', '1000', '100', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('20', 'G78', '13:56', '否', '北京东', '厦门北', '800', '700', '90', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('21', 'G56', '18:36', '否', '上海西', '深圳', '800', '700', '90', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('22', 'H78', '12:00', '否', '上海', '北京西', '800', '700', '90', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('23', 'H78', '12:00', '否', '上海', '北京西', '800', '700', '90', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('24', 'H78', '12:00', '否', '上海', '北京西', '800', '700', '90', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('25', 'H78', '12:00', '否', '北京西', '南昌', '800', '700', '90', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('26', 'G70', '7:23', '是', '北京西', '厦门', '500', '450', '95', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('27', 'G14', '9:50', '是', '北京西', '上海', '800', '700', '95', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('28', 'G90', '8:30', '是', '北京南', '武昌', '1000', '1000', '100', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('29', 'G25', '7:56', '是', '厦门北', '福州', '500', '100', '20', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('30', 'G50', '14:23', '否', '北京西', '深圳', '500', '100', '20', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('31', 'G10', '13:00', '否', '北京西', '深圳', '500', '100', '20', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('32', 'G10', '13:00', '否', '北京西', '深圳', '500', '100', '20', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('33', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('34', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('35', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('36', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('37', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('38', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('39', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('40', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('41', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('42', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('43', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('44', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('45', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('46', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('47', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('48', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('49', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('50', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('51', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('52', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('53', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('54', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('55', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('56', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('57', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('58', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('59', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('60', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('61', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('62', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('63', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('64', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('65', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('66', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('67', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('68', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('69', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('70', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('71', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('72', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('73', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('74', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('75', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('76', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('77', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('78', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('79', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('80', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('81', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('82', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('83', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('84', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('85', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); INSERT INTO `rep_demo_jianpiao` VALUES ('86', 'G10', '13:00', '否', '北京西', '深圳', '200', '100', '50', '1'); -- ---------------------------- -- Table structure for sys_announcement -- ---------------------------- DROP TABLE IF EXISTS `sys_announcement`; CREATE TABLE `sys_announcement` ( `id` varchar(32) NOT NULL, `titile` varchar(100) DEFAULT NULL COMMENT '标题', `msg_content` text COMMENT '内容', `start_time` datetime DEFAULT NULL COMMENT '开始时间', `end_time` datetime DEFAULT NULL COMMENT '结束时间', `sender` varchar(100) DEFAULT NULL COMMENT '发布人', `priority` varchar(255) DEFAULT NULL COMMENT '优先级（L低，M中，H高）', `msg_category` varchar(10) NOT NULL DEFAULT '2' COMMENT '消息类型1:通知公告2:系统消息', `msg_type` varchar(10) DEFAULT NULL COMMENT '通告对象类型（USER:指定用户，ALL:全体用户）', `send_status` varchar(10) DEFAULT NULL COMMENT '发布状态（0未发布，1已发布，2已撤销）', `send_time` datetime DEFAULT NULL COMMENT '发布时间', `cancel_time` datetime DEFAULT NULL COMMENT '撤销时间', `del_flag` varchar(1) DEFAULT NULL COMMENT '删除状态（0，正常，1已删除）', `bus_type` varchar(20) DEFAULT NULL COMMENT '业务类型(email:邮件 bpm:流程)', `bus_id` varchar(50) DEFAULT NULL COMMENT '业务id', `open_type` varchar(20) DEFAULT NULL COMMENT '打开方式(组件：component 路由：url)', `open_page` varchar(255) DEFAULT NULL COMMENT '组件/路由 地址', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `user_ids` text COMMENT '指定用户', `msg_abstract` text COMMENT '摘要', `dt_task_id` varchar(100) DEFAULT NULL COMMENT '钉钉task_id，用于撤回消息', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统通告表'; -- ---------------------------- -- Records of sys_announcement -- ---------------------------- -- ---------------------------- -- Table structure for sys_announcement_send -- ---------------------------- DROP TABLE IF EXISTS `sys_announcement_send`; CREATE TABLE `sys_announcement_send` ( `id` varchar(32) DEFAULT NULL, `annt_id` varchar(32) DEFAULT NULL COMMENT '通告ID', `user_id` varchar(32) DEFAULT NULL COMMENT '用户id', `read_flag` varchar(10) DEFAULT NULL COMMENT '阅读状态（0未读，1已读）', `read_time` datetime DEFAULT NULL COMMENT '阅读时间', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户通告阅读标记表'; -- ---------------------------- -- Records of sys_announcement_send -- ---------------------------- -- ---------------------------- -- Table structure for sys_category -- ---------------------------- DROP TABLE IF EXISTS `sys_category`; CREATE TABLE `sys_category` ( `id` varchar(36) NOT NULL, `pid` varchar(36) DEFAULT NULL COMMENT '父级节点', `name` varchar(100) DEFAULT NULL COMMENT '类型名称', `code` varchar(100) DEFAULT NULL COMMENT '类型编码', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门', `has_child` varchar(3) DEFAULT NULL COMMENT '是否有子节点', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `index_code` (`code`) USING BTREE, KEY `idx_sc_code` (`code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_category -- ---------------------------- INSERT INTO `sys_category` VALUES ('1230769196661510146', '0', '省', null, 'admin', '2020-02-21 16:20:16', 'admin', '2020-02-21 16:20:31', 'A01A03', '1'); INSERT INTO `sys_category` VALUES ('1230769253267836929', '1230769196661510146', '安徽省', null, 'admin', '2020-02-21 16:20:31', 'admin', '2020-02-21 16:20:53', 'A01A03', '1'); INSERT INTO `sys_category` VALUES ('1230769290609725441', '1230769196661510146', '山东省', null, 'admin', '2020-02-21 16:20:40', 'admin', '2020-02-21 16:21:23', 'A01A03', '1'); INSERT INTO `sys_category` VALUES ('1230769347157331969', '1230769253267836929', '合肥市', null, 'admin', '2020-02-21 16:20:53', 'admin', '2020-02-21 16:21:08', 'A01A03', '1'); INSERT INTO `sys_category` VALUES ('1230769407907631106', '1230769347157331969', '包河区', null, 'admin', '2020-02-21 16:21:08', null, null, 'A01A03', null); INSERT INTO `sys_category` VALUES ('1230769470889299970', '1230769290609725441', '济南市', null, 'admin', '2020-02-21 16:21:23', 'admin', '2020-02-21 16:21:41', 'A01A03', '1'); INSERT INTO `sys_category` VALUES ('1230769547519234050', '1230769470889299970', 'A区', null, 'admin', '2020-02-21 16:21:41', null, null, 'A01A03', null); INSERT INTO `sys_category` VALUES ('1230769620021972993', '1230769470889299970', 'B区', null, 'admin', '2020-02-21 16:21:58', null, null, 'A01A03', null); INSERT INTO `sys_category` VALUES ('1230769769930592257', '1230769253267836929', '淮南市', null, 'admin', '2020-02-21 16:22:34', 'admin', '2020-02-21 16:22:54', 'A01A03', '1'); INSERT INTO `sys_category` VALUES ('1230769855347593217', '1230769769930592257', 'C区', null, 'admin', '2020-02-21 16:22:54', null, null, 'A01A03', null); INSERT INTO `sys_category` VALUES ('22a50b413c5e1ef661fb8aea9469cf52', 'e9ded10fd33e5753face506f4f1564b5', 'MacBook', 'B01-2-1', 'admin', '2019-06-10 15:43:13', null, null, 'A01', null); INSERT INTO `sys_category` VALUES ('5c8f68845e57f68ab93a2c8d82d26ae1', '0', '笔记本', 'B01', 'admin', '2019-06-10 15:34:11', 'admin', '2019-06-10 15:34:24', 'A01', '1'); INSERT INTO `sys_category` VALUES ('937fd2e9aa13b8bab1da1ca36d3fd344', 'e9ded10fd33e5753face506f4f1564b5', '台式机', 'B02-2-2', 'admin', '2019-06-10 15:43:32', 'admin', '2019-08-21 12:01:59', 'A01', null); INSERT INTO `sys_category` VALUES ('e9ded10fd33e5753face506f4f1564b5', '5c8f68845e57f68ab93a2c8d82d26ae1', '苹果电脑', 'B01-2', 'admin', '2019-06-10 15:41:14', 'admin', '2019-06-10 15:43:13', 'A01', '1'); INSERT INTO `sys_category` VALUES ('f39a06bf9f390ba4a53d11bc4e0018d7', '5c8f68845e57f68ab93a2c8d82d26ae1', '华为', 'B01-1', 'admin', '2019-06-10 15:34:24', 'admin', '2019-08-21 12:01:56', 'A01', null); -- ---------------------------- -- Table structure for sys_check_rule -- ---------------------------- DROP TABLE IF EXISTS `sys_check_rule`; CREATE TABLE `sys_check_rule` ( `id` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '主键id', `rule_name` varchar(100) DEFAULT NULL COMMENT '规则名称', `rule_code` varchar(100) DEFAULT NULL COMMENT '规则Code', `rule_json` varchar(1024) DEFAULT NULL COMMENT '规则JSON', `rule_description` varchar(200) DEFAULT NULL COMMENT '规则描述', `update_by` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `create_by` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uni_sys_check_rule_code` (`rule_code`) USING BTREE, UNIQUE KEY `uk_scr_rule_code` (`rule_code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_check_rule -- ---------------------------- INSERT INTO `sys_check_rule` VALUES ('1224980593992388610', '通用编码规则', 'common', '[{\"digits\":\"1\",\"pattern\":\"^[a-z|A-Z]$\",\"message\":\"第一位只能是字母\"},{\"digits\":\"*\",\"pattern\":\"^[0-9|a-z|A-Z|_]{0,}$\",\"message\":\"只能填写数字、大小写字母、下划线\"},{\"digits\":\"*\",\"pattern\":\"^.{3,}$\",\"message\":\"最少输入3位数\"},{\"digits\":\"*\",\"pattern\":\"^.{3,12}$\",\"message\":\"最多输入12位数\"}]', '规则：1、首位只能是字母；2、只能填写数字、大小写字母、下划线；3、最少3位数，最多12位数。', 'admin', '2020-02-07 11:25:48', 'admin', '2020-02-05 16:58:27'); INSERT INTO `sys_check_rule` VALUES ('1225001845524004866', '负责的功能测试', 'test', '[{\"digits\":\"*\",\"pattern\":\"^.{3,12}$\",\"message\":\"只能输入3-12位字符\"},{\"digits\":\"3\",\"pattern\":\"^\\\\d{3}$\",\"message\":\"前3位必须是数字\"},{\"digits\":\"*\",\"pattern\":\"^[^pP]*$\",\"message\":\"不能输入P\"},{\"digits\":\"4\",\"pattern\":\"^@{4}$\",\"message\":\"第4-7位必须都为 @\"},{\"digits\":\"2\",\"pattern\":\"^#=$\",\"message\":\"第8-9位必须是 #=\"},{\"digits\":\"1\",\"pattern\":\"^O$\",\"message\":\"第10位必须为大写的O\"},{\"digits\":\"*\",\"pattern\":\"^.*。$\",\"message\":\"必须以。结尾\"}]', '包含长度校验、特殊字符校验等', 'admin', '2020-02-07 11:57:31', 'admin', '2020-02-05 18:22:54'); -- ---------------------------- -- Table structure for sys_data_log -- ---------------------------- DROP TABLE IF EXISTS `sys_data_log`; CREATE TABLE `sys_data_log` ( `id` varchar(32) NOT NULL COMMENT 'id', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人登录名称', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人登录名称', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `data_table` varchar(32) DEFAULT NULL COMMENT '表名', `data_id` varchar(32) DEFAULT NULL COMMENT '数据ID', `data_content` text COMMENT '数据内容', `data_version` int(11) DEFAULT NULL COMMENT '版本号', PRIMARY KEY (`id`) USING BTREE, KEY `sindex` (`data_table`,`data_id`) USING BTREE, KEY `idx_sdl_data_table_id` (`data_table`,`data_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_data_log -- ---------------------------- -- ---------------------------- -- Table structure for sys_data_source -- ---------------------------- DROP TABLE IF EXISTS `sys_data_source`; CREATE TABLE `sys_data_source` ( `id` varchar(36) NOT NULL, `code` varchar(100) DEFAULT NULL COMMENT '数据源编码', `name` varchar(100) DEFAULT NULL COMMENT '数据源名称', `remark` varchar(200) DEFAULT NULL COMMENT '备注', `db_type` varchar(10) DEFAULT NULL COMMENT '数据库类型', `db_driver` varchar(100) DEFAULT NULL COMMENT '驱动类', `db_url` varchar(500) DEFAULT NULL COMMENT '数据源地址', `db_name` varchar(100) DEFAULT NULL COMMENT '数据库名称', `db_username` varchar(100) DEFAULT NULL COMMENT '用户名', `db_password` varchar(100) DEFAULT NULL COMMENT '密码', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `sys_data_source_code_uni` (`code`) USING BTREE, UNIQUE KEY `uk_sdc_rule_code` (`code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_data_source -- ---------------------------- INSERT INTO `sys_data_source` VALUES ('1209779538310004737', 'local_mysql', 'MySQL5.7', '本地数据库MySQL5.7', '1', 'com.mysql.jdbc.Driver', 'jdbc:mysql://127.0.0.1:3306/mx-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false', 'mx-boot', 'root', 'f5b6775e8d1749483f2320627de0e706', 'admin', '2019-12-25 18:14:53', 'admin', '2020-07-10 16:54:42', 'A01'); -- ---------------------------- -- Table structure for sys_depart -- ---------------------------- DROP TABLE IF EXISTS `sys_depart`; CREATE TABLE `sys_depart` ( `id` varchar(32) NOT NULL COMMENT 'ID', `parent_id` varchar(32) DEFAULT NULL COMMENT '父机构ID', `depart_name` varchar(100) NOT NULL COMMENT '机构/部门名称', `depart_name_en` varchar(500) DEFAULT NULL COMMENT '英文名', `depart_name_abbr` varchar(500) DEFAULT NULL COMMENT '缩写', `depart_order` int(11) DEFAULT '0' COMMENT '排序', `description` varchar(500) DEFAULT NULL COMMENT '描述', `org_category` varchar(10) NOT NULL DEFAULT '1' COMMENT '机构类别 1公司，2组织机构，2岗位', `org_type` varchar(10) DEFAULT NULL COMMENT '机构类型 1一级部门 2子部门', `org_code` varchar(64) NOT NULL COMMENT '机构编码', `mobile` varchar(32) DEFAULT NULL COMMENT '手机号', `fax` varchar(32) DEFAULT NULL COMMENT '传真', `address` varchar(100) DEFAULT NULL COMMENT '地址', `memo` varchar(500) DEFAULT NULL COMMENT '备注', `status` varchar(1) DEFAULT NULL COMMENT '状态（1启用，0不启用）', `del_flag` varchar(1) DEFAULT NULL COMMENT '删除状态（0，正常，1已删除）', `qywx_identifier` varchar(100) DEFAULT NULL COMMENT '对接企业微信的ID', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniq_depart_org_code` (`org_code`) USING BTREE, KEY `index_depart_parent_id` (`parent_id`) USING BTREE, KEY `index_depart_depart_order` (`depart_order`) USING BTREE, KEY `index_depart_org_code` (`org_code`) USING BTREE, KEY `idx_sd_parent_id` (`parent_id`) USING BTREE, KEY `idx_sd_depart_order` (`depart_order`) USING BTREE, KEY `idx_sd_org_code` (`org_code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='组织机构表'; -- ---------------------------- -- Records of sys_depart -- ---------------------------- INSERT INTO `sys_depart` VALUES ('4f1765520d6346f9bd9c79e2479e5b12', 'c6d7cb4deeac411cb3384b1b31278596', '市场部', null, null, '0', null, '1', '2', 'A01A03', null, null, null, null, null, '0', null, 'admin', '2019-02-20 17:15:34', 'admin', '2019-02-26 16:36:18'); INSERT INTO `sys_depart` VALUES ('57197590443c44f083d42ae24ef26a2c', 'c6d7cb4deeac411cb3384b1b31278596', '研发部', null, null, '0', null, '1', '2', 'A01A05', null, null, null, null, null, '0', null, 'admin', '2019-02-21 16:14:41', 'admin', '2019-03-27 19:05:49'); INSERT INTO `sys_depart` VALUES ('63775228b7b041a99825f79760590b7d', '57197590443c44f083d42ae24ef26a2c', '研发经理', null, null, '0', null, '3', '3', 'A01A05A01', null, null, null, null, null, '0', null, 'admin', '2020-05-02 15:29:09', null, null); INSERT INTO `sys_depart` VALUES ('67fc001af12a4f9b8458005d3f19934a', 'c6d7cb4deeac411cb3384b1b31278596', '财务部', null, null, '0', null, '1', '2', 'A01A04', null, null, null, null, null, '0', null, 'admin', '2019-02-21 16:14:35', 'admin', '2019-02-25 12:49:41'); INSERT INTO `sys_depart` VALUES ('743ba9dbdc114af8953a11022ef3096a', 'f28c6f53abd841ac87ead43afc483433', '财务部', null, null, '0', null, '1', '2', 'A03A01', null, null, null, null, null, '0', null, 'admin', '2019-03-22 16:45:43', null, null); INSERT INTO `sys_depart` VALUES ('c6d7cb4deeac411cb3384b1b31278596', '', '北京国炬软件', null, null, '0', null, '1', '1', 'A01', null, null, null, null, null, '0', null, 'admin', '2019-02-11 14:21:51', 'admin', '2020-05-02 18:21:27'); -- ---------------------------- -- Table structure for sys_depart_permission -- ---------------------------- DROP TABLE IF EXISTS `sys_depart_permission`; CREATE TABLE `sys_depart_permission` ( `id` varchar(32) NOT NULL, `depart_id` varchar(32) DEFAULT NULL COMMENT '部门id', `permission_id` varchar(32) DEFAULT NULL COMMENT '权限id', `data_rule_ids` varchar(1000) DEFAULT NULL COMMENT '数据规则id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门权限表'; -- ---------------------------- -- Records of sys_depart_permission -- ---------------------------- -- ---------------------------- -- Table structure for sys_depart_role -- ---------------------------- DROP TABLE IF EXISTS `sys_depart_role`; CREATE TABLE `sys_depart_role` ( `id` varchar(32) NOT NULL, `depart_id` varchar(32) DEFAULT NULL COMMENT '部门id', `role_name` varchar(200) DEFAULT NULL COMMENT '部门角色名称', `role_code` varchar(100) DEFAULT NULL COMMENT '部门角色编码', `description` varchar(255) DEFAULT NULL COMMENT '描述', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门角色表'; -- ---------------------------- -- Records of sys_depart_role -- ---------------------------- -- ---------------------------- -- Table structure for sys_depart_role_permission -- ---------------------------- DROP TABLE IF EXISTS `sys_depart_role_permission`; CREATE TABLE `sys_depart_role_permission` ( `id` varchar(32) NOT NULL, `depart_id` varchar(32) DEFAULT NULL COMMENT '部门id', `role_id` varchar(32) DEFAULT NULL COMMENT '角色id', `permission_id` varchar(32) DEFAULT NULL COMMENT '权限id', `data_rule_ids` varchar(1000) DEFAULT NULL COMMENT '数据权限ids', `operate_date` datetime DEFAULT NULL COMMENT '操作时间', `operate_ip` varchar(20) DEFAULT NULL COMMENT '操作ip', PRIMARY KEY (`id`) USING BTREE, KEY `index_group_role_per_id` (`role_id`,`permission_id`) USING BTREE, KEY `index_group_role_id` (`role_id`) USING BTREE, KEY `index_group_per_id` (`permission_id`) USING BTREE, KEY `idx_sdrp_role_per_id` (`role_id`,`permission_id`) USING BTREE, KEY `idx_sdrp_role_id` (`role_id`) USING BTREE, KEY `idx_sdrp_per_id` (`permission_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='部门角色权限表'; -- ---------------------------- -- Records of sys_depart_role_permission -- ---------------------------- -- ---------------------------- -- Table structure for sys_depart_role_user -- ---------------------------- DROP TABLE IF EXISTS `sys_depart_role_user`; CREATE TABLE `sys_depart_role_user` ( `id` varchar(32) NOT NULL COMMENT '主键id', `user_id` varchar(32) DEFAULT NULL COMMENT '用户id', `drole_id` varchar(32) DEFAULT NULL COMMENT '角色id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门角色用户表'; -- ---------------------------- -- Records of sys_depart_role_user -- ---------------------------- -- ---------------------------- -- Table structure for sys_dict -- ---------------------------- DROP TABLE IF EXISTS `sys_dict`; CREATE TABLE `sys_dict` ( `id` varchar(32) NOT NULL, `dict_name` varchar(100) NOT NULL COMMENT '字典名称', `dict_code` varchar(100) NOT NULL COMMENT '字典编码', `description` varchar(255) DEFAULT NULL COMMENT '描述', `del_flag` int(1) DEFAULT NULL COMMENT '删除状态', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `type` int(1) unsigned zerofill DEFAULT '0' COMMENT '字典类型0为string,1为number', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `indextable_dict_code` (`dict_code`) USING BTREE, UNIQUE KEY `uk_sd_dict_code` (`dict_code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_dict -- ---------------------------- INSERT INTO `sys_dict` VALUES ('0b5d19e1fce4b2e6647e6b4a17760c14', '通告类型', 'msg_category', '消息类型1:通知公告2:系统消息', '0', 'admin', '2019-04-22 18:01:35', null, null, '0'); INSERT INTO `sys_dict` VALUES ('1174509082208395266', '职务职级', 'position_rank', '职务表职级字典', '0', 'admin', '2019-09-19 10:22:41', null, null, '0'); INSERT INTO `sys_dict` VALUES ('1174511106530525185', '机构类型', 'org_category', '机构类型 1公司，2部门 3岗位', '0', 'admin', '2019-09-19 10:30:43', null, null, '0'); INSERT INTO `sys_dict` VALUES ('1178295274528845826', '表单权限策略', 'form_perms_type', '', '0', 'admin', '2019-09-29 21:07:39', 'admin', '2019-09-29 21:08:26', null); INSERT INTO `sys_dict` VALUES ('1199517671259906049', '紧急程度', 'urgent_level', '日程计划紧急程度', '0', 'admin', '2019-11-27 10:37:53', null, null, '0'); INSERT INTO `sys_dict` VALUES ('1199518099888414722', '日程计划类型', 'eoa_plan_type', '', '0', 'admin', '2019-11-27 10:39:36', null, null, '0'); INSERT INTO `sys_dict` VALUES ('1199520177767587841', '分类栏目类型', 'eoa_cms_menu_type', '', '0', 'admin', '2019-11-27 10:47:51', 'admin', '2019-11-27 10:49:35', '0'); INSERT INTO `sys_dict` VALUES ('1199525215290306561', '日程计划状态', 'eoa_plan_status', '', '0', 'admin', '2019-11-27 11:07:52', 'admin', '2019-11-27 11:10:11', '0'); INSERT INTO `sys_dict` VALUES ('1209733563293962241', '数据库类型', 'database_type', '', '0', 'admin', '2019-12-25 15:12:12', null, null, '0'); INSERT INTO `sys_dict` VALUES ('1232913193820581889', 'Online表单业务分类', 'ol_form_biz_type', '', '0', 'admin', '2020-02-27 14:19:46', 'admin', '2020-02-27 14:20:23', '0'); INSERT INTO `sys_dict` VALUES ('1250687930947620866', '定时任务状态', 'quartz_status', '', '0', 'admin', '2020-04-16 15:30:14', '', null, null); INSERT INTO `sys_dict` VALUES ('1280401766745718786', '租户状态', 'tenant_status', '租户状态', '0', 'admin', '2020-07-07 15:22:25', null, null, '0'); INSERT INTO `sys_dict` VALUES ('1356445645198135298', '开关', 'is_open', '', '0', 'admin', '2021-02-02 11:33:38', 'admin', '2021-02-02 15:28:12', '0'); INSERT INTO `sys_dict` VALUES ('236e8a4baff0db8c62c00dd95632834f', '同步工作流引擎', 'activiti_sync', '同步工作流引擎', '0', 'admin', '2019-05-15 15:27:33', null, null, '0'); INSERT INTO `sys_dict` VALUES ('2e02df51611a4b9632828ab7e5338f00', '权限策略', 'perms_type', '权限策略', '0', 'admin', '2019-04-26 18:26:55', null, null, '0'); INSERT INTO `sys_dict` VALUES ('2f0320997ade5dd147c90130f7218c3e', '推送类别', 'msg_type', '', '0', 'admin', '2019-03-17 21:21:32', 'admin', '2019-03-26 19:57:45', '0'); INSERT INTO `sys_dict` VALUES ('3486f32803bb953e7155dab3513dc68b', '删除状态', 'del_flag', null, '0', 'admin', '2019-01-18 21:46:26', 'admin', '2019-03-30 11:17:11', '0'); INSERT INTO `sys_dict` VALUES ('3d9a351be3436fbefb1307d4cfb49bf2', '性别', 'sex', null, '0', null, '2019-01-04 14:56:32', 'admin', '2019-03-30 11:28:27', '1'); INSERT INTO `sys_dict` VALUES ('4274efc2292239b6f000b153f50823ff', '全局权限策略', 'global_perms_type', '全局权限策略', '0', 'admin', '2019-05-10 17:54:05', null, null, '0'); INSERT INTO `sys_dict` VALUES ('4c03fca6bf1f0299c381213961566349', 'Online图表展示模板', 'online_graph_display_template', 'Online图表展示模板', '0', 'admin', '2019-04-12 17:28:50', null, null, '0'); INSERT INTO `sys_dict` VALUES ('4c753b5293304e7a445fd2741b46529d', '字典状态', 'dict_item_status', null, '0', 'admin', '2020-06-18 23:18:42', 'admin', '2019-03-30 19:33:52', '1'); INSERT INTO `sys_dict` VALUES ('4d7fec1a7799a436d26d02325eff295e', '优先级', 'priority', '优先级', '0', 'admin', '2019-03-16 17:03:34', 'admin', '2019-04-16 17:39:23', '0'); INSERT INTO `sys_dict` VALUES ('4e4602b3e3686f0911384e188dc7efb4', '条件规则', 'rule_conditions', '', '0', 'admin', '2019-04-01 10:15:03', 'admin', '2019-04-01 10:30:47', '0'); INSERT INTO `sys_dict` VALUES ('4f69be5f507accea8d5df5f11346181a', '发送消息类型', 'msgType', null, '0', 'admin', '2019-04-11 14:27:09', null, null, '0'); INSERT INTO `sys_dict` VALUES ('68168534ff5065a152bfab275c2136f8', '有效无效状态', 'valid_status', '有效无效状态', '0', 'admin', '2020-09-26 19:21:14', 'admin', '2019-04-26 19:21:23', '0'); INSERT INTO `sys_dict` VALUES ('6b78e3f59faec1a4750acff08030a79b', '用户类型', 'user_type', null, '0', null, '2019-01-04 14:59:01', 'admin', '2019-03-18 23:28:18', '0'); INSERT INTO `sys_dict` VALUES ('72cce0989df68887546746d8f09811aa', 'Online表单类型', 'cgform_table_type', '', '0', 'admin', '2019-01-27 10:13:02', 'admin', '2019-03-30 11:37:36', '0'); INSERT INTO `sys_dict` VALUES ('78bda155fe380b1b3f175f1e88c284c6', '流程状态', 'bpm_status', '流程状态', '0', 'admin', '2019-05-09 16:31:52', null, null, '0'); INSERT INTO `sys_dict` VALUES ('83bfb33147013cc81640d5fd9eda030c', '日志类型', 'log_type', null, '0', 'admin', '2019-03-18 23:22:19', null, null, '1'); INSERT INTO `sys_dict` VALUES ('845da5006c97754728bf48b6a10f79cc', '状态', 'status', null, '0', 'admin', '2019-03-18 21:45:25', 'admin', '2019-03-18 21:58:25', '0'); INSERT INTO `sys_dict` VALUES ('880a895c98afeca9d9ac39f29e67c13e', '操作类型', 'operate_type', '操作类型', '0', 'admin', '2019-07-22 10:54:29', null, null, '0'); INSERT INTO `sys_dict` VALUES ('8dfe32e2d29ea9430a988b3b558bf233', '发布状态', 'send_status', '发布状态', '0', 'admin', '2019-04-16 17:40:42', null, null, '0'); INSERT INTO `sys_dict` VALUES ('a7adbcd86c37f7dbc9b66945c82ef9e6', '1是0否', 'yn', '', '0', 'admin', '2019-05-22 19:29:29', null, null, '0'); INSERT INTO `sys_dict` VALUES ('a9d9942bd0eccb6e89de92d130ec4c4a', '消息发送状态', 'msgSendStatus', null, '0', 'admin', '2019-04-12 18:18:17', null, null, '0'); INSERT INTO `sys_dict` VALUES ('ac2f7c0c5c5775fcea7e2387bcb22f01', '菜单类型', 'menu_type', null, '0', 'admin', '2020-12-18 23:24:32', 'admin', '2019-04-01 15:27:06', '1'); INSERT INTO `sys_dict` VALUES ('ad7c65ba97c20a6805d5dcdf13cdaf36', 'onlineT类型', 'ceshi_online', null, '0', 'admin', '2019-03-22 16:31:49', 'admin', '2019-03-22 16:34:16', '0'); INSERT INTO `sys_dict` VALUES ('bd1b8bc28e65d6feefefb6f3c79f42fd', 'Online图表数据类型', 'online_graph_data_type', 'Online图表数据类型', '0', 'admin', '2019-04-12 17:24:24', 'admin', '2019-04-12 17:24:57', '0'); INSERT INTO `sys_dict` VALUES ('c36169beb12de8a71c8683ee7c28a503', '部门状态', 'depart_status', null, '0', 'admin', '2019-03-18 21:59:51', null, null, '0'); INSERT INTO `sys_dict` VALUES ('c5a14c75172783d72cbee6ee7f5df5d1', 'Online图表类型', 'online_graph_type', 'Online图表类型', '0', 'admin', '2019-04-12 17:04:06', null, null, '0'); INSERT INTO `sys_dict` VALUES ('d6e1152968b02d69ff358c75b48a6ee1', '流程类型', 'bpm_process_type', null, '0', 'admin', '2021-02-22 19:26:54', 'admin', '2019-03-30 18:14:44', '0'); INSERT INTO `sys_dict` VALUES ('fc6cd58fde2e8481db10d3a1e68ce70c', '用户状态', 'user_status', null, '0', 'admin', '2019-03-18 21:57:25', 'admin', '2019-03-18 23:11:58', '1'); -- ---------------------------- -- Table structure for sys_dict_item -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_item`; CREATE TABLE `sys_dict_item` ( `id` varchar(32) NOT NULL, `dict_id` varchar(32) DEFAULT NULL COMMENT '字典id', `item_text` varchar(100) NOT NULL COMMENT '字典项文本', `item_value` varchar(100) NOT NULL COMMENT '字典项值', `description` varchar(255) DEFAULT NULL COMMENT '描述', `sort_order` int(10) DEFAULT NULL COMMENT '排序', `status` int(11) DEFAULT NULL COMMENT '状态（1启用 0不启用）', `create_by` varchar(32) DEFAULT NULL, `create_time` datetime DEFAULT NULL, `update_by` varchar(32) DEFAULT NULL, `update_time` datetime DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `index_table_dict_id` (`dict_id`) USING BTREE, KEY `index_table_sort_order` (`sort_order`) USING BTREE, KEY `index_table_dict_status` (`status`) USING BTREE, KEY `idx_sdi_role_dict_id` (`dict_id`) USING BTREE, KEY `idx_sdi_role_sort_order` (`sort_order`) USING BTREE, KEY `idx_sdi_status` (`status`) USING BTREE, KEY `idx_sdi_dict_val` (`dict_id`,`item_value`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_dict_item -- ---------------------------- INSERT INTO `sys_dict_item` VALUES ('0072d115e07c875d76c9b022e2179128', '4d7fec1a7799a436d26d02325eff295e', '低', 'L', '低', '3', '1', 'admin', '2019-04-16 17:04:59', null, null); INSERT INTO `sys_dict_item` VALUES ('05a2e732ce7b00aa52141ecc3e330b4e', '3486f32803bb953e7155dab3513dc68b', '已删除', '1', null, null, '1', 'admin', '2025-10-18 21:46:56', 'admin', '2019-03-28 22:23:20'); INSERT INTO `sys_dict_item` VALUES ('096c2e758d823def3855f6376bc736fb', 'bd1b8bc28e65d6feefefb6f3c79f42fd', 'SQL', 'sql', null, '1', '1', 'admin', '2019-04-12 17:26:26', null, null); INSERT INTO `sys_dict_item` VALUES ('0c9532916f5cd722017b46bc4d953e41', '2f0320997ade5dd147c90130f7218c3e', '指定用户', 'USER', null, null, '1', 'admin', '2019-03-17 21:22:19', 'admin', '2019-03-17 21:22:28'); INSERT INTO `sys_dict_item` VALUES ('0ca4beba9efc4f9dd54af0911a946d5c', '72cce0989df68887546746d8f09811aa', '附表', '3', null, '3', '1', 'admin', '2019-03-27 10:13:43', null, null); INSERT INTO `sys_dict_item` VALUES ('1030a2652608f5eac3b49d70458b8532', '2e02df51611a4b9632828ab7e5338f00', '禁用', '2', '禁用', '2', '1', 'admin', '2021-03-26 18:27:28', 'admin', '2019-04-26 18:39:11'); INSERT INTO `sys_dict_item` VALUES ('1174509082208395266', '1174511106530525185', '岗位', '3', '岗位', '1', '1', 'admin', '2019-09-19 10:31:16', '', null); INSERT INTO `sys_dict_item` VALUES ('1174509601047994369', '1174509082208395266', '员级', '1', '', '1', '1', 'admin', '2019-09-19 10:24:45', 'admin', '2019-09-23 11:46:39'); INSERT INTO `sys_dict_item` VALUES ('1174509667297026049', '1174509082208395266', '助级', '2', '', '2', '1', 'admin', '2019-09-19 10:25:01', 'admin', '2019-09-23 11:46:47'); INSERT INTO `sys_dict_item` VALUES ('1174509713568587777', '1174509082208395266', '中级', '3', '', '3', '1', 'admin', '2019-09-19 10:25:12', 'admin', '2019-09-23 11:46:56'); INSERT INTO `sys_dict_item` VALUES ('1174509788361416705', '1174509082208395266', '副高级', '4', '', '4', '1', 'admin', '2019-09-19 10:25:30', 'admin', '2019-09-23 11:47:06'); INSERT INTO `sys_dict_item` VALUES ('1174509835803189250', '1174509082208395266', '正高级', '5', '', '5', '1', 'admin', '2019-09-19 10:25:41', 'admin', '2019-09-23 11:47:12'); INSERT INTO `sys_dict_item` VALUES ('1174511197735665665', '1174511106530525185', '公司', '1', '公司', '1', '1', 'admin', '2019-09-19 10:31:05', null, null); INSERT INTO `sys_dict_item` VALUES ('1174511244036587521', '1174511106530525185', '部门', '2', '部门', '1', '1', 'admin', '2019-09-19 10:31:16', null, null); INSERT INTO `sys_dict_item` VALUES ('1178295553450061826', '1178295274528845826', '可编辑(未授权禁用)', '2', '', '2', '1', 'admin', '2019-09-29 21:08:46', 'admin', '2019-09-29 21:09:18'); INSERT INTO `sys_dict_item` VALUES ('1178295639554928641', '1178295274528845826', '可见(未授权不可见)', '1', '', '1', '1', 'admin', '2019-09-29 21:09:06', 'admin', '2019-09-29 21:09:24'); INSERT INTO `sys_dict_item` VALUES ('1199517884758368257', '1199517671259906049', '一般', '1', '', '1', '1', 'admin', '2019-11-27 10:38:44', null, null); INSERT INTO `sys_dict_item` VALUES ('1199517914017832962', '1199517671259906049', '重要', '2', '', '1', '1', 'admin', '2019-11-27 10:38:51', null, null); INSERT INTO `sys_dict_item` VALUES ('1199517941339529217', '1199517671259906049', '紧急', '3', '', '1', '1', 'admin', '2019-11-27 10:38:58', null, null); INSERT INTO `sys_dict_item` VALUES ('1199518186144276482', '1199518099888414722', '日常记录', '1', '', '1', '1', 'admin', '2019-11-27 10:39:56', null, null); INSERT INTO `sys_dict_item` VALUES ('1199518214858481666', '1199518099888414722', '本周工作', '2', '', '1', '1', 'admin', '2019-11-27 10:40:03', null, null); INSERT INTO `sys_dict_item` VALUES ('1199518235943247874', '1199518099888414722', '下周计划', '3', '', '1', '1', 'admin', '2019-11-27 10:40:08', null, null); INSERT INTO `sys_dict_item` VALUES ('1199520817285701634', '1199520177767587841', '列表', '1', '', '1', '1', 'admin', '2019-11-27 10:50:24', null, null); INSERT INTO `sys_dict_item` VALUES ('1199520835035996161', '1199520177767587841', '链接', '2', '', '1', '1', 'admin', '2019-11-27 10:50:28', null, null); INSERT INTO `sys_dict_item` VALUES ('1199525468672405505', '1199525215290306561', '未开始', '0', '', '1', '1', 'admin', '2019-11-27 11:08:52', null, null); INSERT INTO `sys_dict_item` VALUES ('1199525490575060993', '1199525215290306561', '进行中', '1', '', '1', '1', 'admin', '2019-11-27 11:08:58', null, null); INSERT INTO `sys_dict_item` VALUES ('1199525506429530114', '1199525215290306561', '已完成', '2', '', '1', '1', 'admin', '2019-11-27 11:09:02', 'admin', '2019-11-27 11:10:02'); INSERT INTO `sys_dict_item` VALUES ('1199607547704647681', '4f69be5f507accea8d5df5f11346181a', '系统', '4', '', '1', '1', 'admin', '2019-11-27 16:35:02', 'admin', '2019-11-27 19:37:46'); INSERT INTO `sys_dict_item` VALUES ('1209733775114702850', '1209733563293962241', 'MySQL5.5', '1', '', '1', '1', 'admin', '2019-12-25 15:13:02', null, null); INSERT INTO `sys_dict_item` VALUES ('1209733839933476865', '1209733563293962241', 'Oracle', '2', '', '3', '1', 'admin', '2019-12-25 15:13:18', null, null); INSERT INTO `sys_dict_item` VALUES ('1209733903020003330', '1209733563293962241', 'SQLServer', '3', '', '4', '1', 'admin', '2019-12-25 15:13:33', null, null); INSERT INTO `sys_dict_item` VALUES ('1232913424813486081', '1232913193820581889', '官方示例', 'demo', '', '1', '1', 'admin', '2020-02-27 14:20:42', 'admin', '2020-02-27 14:21:37'); INSERT INTO `sys_dict_item` VALUES ('1232913493717512194', '1232913193820581889', '流程表单', 'bpm', '', '2', '1', 'admin', '2020-02-27 14:20:58', 'admin', '2020-02-27 14:22:20'); INSERT INTO `sys_dict_item` VALUES ('1232913605382467585', '1232913193820581889', '测试表单', 'temp', '', '4', '1', 'admin', '2020-02-27 14:21:25', 'admin', '2020-02-27 14:22:16'); INSERT INTO `sys_dict_item` VALUES ('1232914232372195330', '1232913193820581889', '导入表单', 'bdfl_include', '', '5', '1', 'admin', '2020-02-27 14:23:54', null, null); INSERT INTO `sys_dict_item` VALUES ('1234371726545010689', '4e4602b3e3686f0911384e188dc7efb4', '左模糊', 'LEFT_LIKE', '左模糊', '7', '1', 'admin', '2020-03-02 14:55:27', null, null); INSERT INTO `sys_dict_item` VALUES ('1234371809495760898', '4e4602b3e3686f0911384e188dc7efb4', '右模糊', 'RIGHT_LIKE', '右模糊', '7', '1', 'admin', '2020-03-02 14:55:47', null, null); INSERT INTO `sys_dict_item` VALUES ('1250688147579228161', '1250687930947620866', '正常', '0', '', '1', '1', 'admin', '2020-04-16 15:31:05', '', null); INSERT INTO `sys_dict_item` VALUES ('1250688201064992770', '1250687930947620866', '停止', '-1', '', '1', '1', 'admin', '2020-04-16 15:31:18', '', null); INSERT INTO `sys_dict_item` VALUES ('1280401815068295170', '1280401766745718786', '正常', '1', '', '1', '1', 'admin', '2020-07-07 15:22:36', null, null); INSERT INTO `sys_dict_item` VALUES ('1280401847607705602', '1280401766745718786', '冻结', '0', '', '1', '1', 'admin', '2020-07-07 15:22:44', null, null); INSERT INTO `sys_dict_item` VALUES ('1305827309355302914', 'bd1b8bc28e65d6feefefb6f3c79f42fd', 'API', 'api', '', '3', '1', 'admin', '2020-09-15 19:14:26', 'admin', '2020-09-15 19:14:41'); INSERT INTO `sys_dict_item` VALUES ('1334440962954936321', '1209733563293962241', 'MYSQL5.7', '4', null, '1', '1', 'admin', '2020-12-03 18:16:02', 'admin', '2020-12-03 18:16:02'); INSERT INTO `sys_dict_item` VALUES ('1356445705549975553', '1356445645198135298', '是', 'Y', '', '1', '1', 'admin', '2021-02-02 11:33:52', null, null); INSERT INTO `sys_dict_item` VALUES ('1356445754212290561', '1356445645198135298', '否', 'N', '', '1', '1', 'admin', '2021-02-02 11:34:04', null, null); INSERT INTO `sys_dict_item` VALUES ('147c48ff4b51545032a9119d13f3222a', 'd6e1152968b02d69ff358c75b48a6ee1', '测试流程', 'test', null, '1', '1', 'admin', '2019-03-22 19:27:05', null, null); INSERT INTO `sys_dict_item` VALUES ('1543fe7e5e26fb97cdafe4981bedc0c8', '4c03fca6bf1f0299c381213961566349', '单排布局', 'single', null, '2', '1', 'admin', '2022-07-12 17:43:39', 'admin', '2019-04-12 17:43:57'); INSERT INTO `sys_dict_item` VALUES ('1ce390c52453891f93514c1bd2795d44', 'ad7c65ba97c20a6805d5dcdf13cdaf36', '000', '00', null, '1', '1', 'admin', '2019-03-22 16:34:34', null, null); INSERT INTO `sys_dict_item` VALUES ('1db531bcff19649fa82a644c8a939dc4', '4c03fca6bf1f0299c381213961566349', '组合布局', 'combination', '', '4', '1', 'admin', '2019-05-11 16:07:08', null, null); INSERT INTO `sys_dict_item` VALUES ('222705e11ef0264d4214affff1fb4ff9', '4f69be5f507accea8d5df5f11346181a', '短信', '1', '', '1', '1', 'admin', '2023-02-28 10:50:36', 'admin', '2019-04-28 10:58:11'); INSERT INTO `sys_dict_item` VALUES ('23a5bb76004ed0e39414e928c4cde155', '4e4602b3e3686f0911384e188dc7efb4', '不等于', '!=', '不等于', '3', '1', 'admin', '2019-04-01 16:46:15', 'admin', '2019-04-01 17:48:40'); INSERT INTO `sys_dict_item` VALUES ('25847e9cb661a7c711f9998452dc09e6', '4e4602b3e3686f0911384e188dc7efb4', '小于等于', '<=', '小于等于', '6', '1', 'admin', '2019-04-01 16:44:34', 'admin', '2019-04-01 17:49:10'); INSERT INTO `sys_dict_item` VALUES ('2d51376643f220afdeb6d216a8ac2c01', '68168534ff5065a152bfab275c2136f8', '有效', '1', '有效', '2', '1', 'admin', '2019-04-26 19:22:01', null, null); INSERT INTO `sys_dict_item` VALUES ('308c8aadf0c37ecdde188b97ca9833f5', '8dfe32e2d29ea9430a988b3b558bf233', '已发布', '1', '已发布', '2', '1', 'admin', '2019-04-16 17:41:24', null, null); INSERT INTO `sys_dict_item` VALUES ('333e6b2196e01ef9a5f76d74e86a6e33', '8dfe32e2d29ea9430a988b3b558bf233', '未发布', '0', '未发布', '1', '1', 'admin', '2019-04-16 17:41:12', null, null); INSERT INTO `sys_dict_item` VALUES ('337ea1e401bda7233f6258c284ce4f50', 'bd1b8bc28e65d6feefefb6f3c79f42fd', 'JSON', 'json', null, '1', '1', 'admin', '2019-04-12 17:26:33', null, null); INSERT INTO `sys_dict_item` VALUES ('33bc9d9f753cf7dc40e70461e50fdc54', 'a9d9942bd0eccb6e89de92d130ec4c4a', '发送失败', '2', null, '3', '1', 'admin', '2019-04-12 18:20:02', null, null); INSERT INTO `sys_dict_item` VALUES ('3fbc03d6c994ae06d083751248037c0e', '78bda155fe380b1b3f175f1e88c284c6', '已完成', '3', '已完成', '3', '1', 'admin', '2019-05-09 16:33:25', null, null); INSERT INTO `sys_dict_item` VALUES ('41d7aaa40c9b61756ffb1f28da5ead8e', '0b5d19e1fce4b2e6647e6b4a17760c14', '通知公告', '1', null, '1', '1', 'admin', '2019-04-22 18:01:57', null, null); INSERT INTO `sys_dict_item` VALUES ('41fa1e9571505d643aea87aeb83d4d76', '4e4602b3e3686f0911384e188dc7efb4', '等于', '=', '等于', '4', '1', 'admin', '2019-04-01 16:45:24', 'admin', '2019-04-01 17:49:00'); INSERT INTO `sys_dict_item` VALUES ('43d2295b8610adce9510ff196a49c6e9', '845da5006c97754728bf48b6a10f79cc', '正常', '1', null, null, '1', 'admin', '2019-03-18 21:45:51', null, null); INSERT INTO `sys_dict_item` VALUES ('4f05fb5376f4c61502c5105f52e4dd2b', '83bfb33147013cc81640d5fd9eda030c', '操作日志', '2', null, null, '1', 'admin', '2019-03-18 23:22:49', null, null); INSERT INTO `sys_dict_item` VALUES ('50223341bfb5ba30bf6319789d8d17fe', 'd6e1152968b02d69ff358c75b48a6ee1', '业务办理', 'business', null, '3', '1', 'admin', '2023-04-22 19:28:05', 'admin', '2019-03-22 23:24:39'); INSERT INTO `sys_dict_item` VALUES ('51222413e5906cdaf160bb5c86fb827c', 'a7adbcd86c37f7dbc9b66945c82ef9e6', '是', '1', '', '1', '1', 'admin', '2019-05-22 19:29:45', null, null); INSERT INTO `sys_dict_item` VALUES ('538fca35afe004972c5f3947c039e766', '2e02df51611a4b9632828ab7e5338f00', '显示', '1', '显示', '1', '1', 'admin', '2025-03-26 18:27:13', 'admin', '2019-04-26 18:39:07'); INSERT INTO `sys_dict_item` VALUES ('5584c21993bde231bbde2b966f2633ac', '4e4602b3e3686f0911384e188dc7efb4', '自定义SQL表达式', 'USE_SQL_RULES', '自定义SQL表达式', '9', '1', 'admin', '2019-04-01 10:45:24', 'admin', '2019-04-01 17:49:27'); INSERT INTO `sys_dict_item` VALUES ('58b73b344305c99b9d8db0fc056bbc0a', '72cce0989df68887546746d8f09811aa', '主表', '2', null, '2', '1', 'admin', '2019-03-27 10:13:36', null, null); INSERT INTO `sys_dict_item` VALUES ('5b65a88f076b32e8e69d19bbaadb52d5', '2f0320997ade5dd147c90130f7218c3e', '全体用户', 'ALL', null, null, '1', 'admin', '2020-10-17 21:22:43', 'admin', '2019-03-28 22:17:09'); INSERT INTO `sys_dict_item` VALUES ('5d833f69296f691843ccdd0c91212b6b', '880a895c98afeca9d9ac39f29e67c13e', '修改', '3', '', '3', '1', 'admin', '2019-07-22 10:55:07', 'admin', '2019-07-22 10:55:41'); INSERT INTO `sys_dict_item` VALUES ('5d84a8634c8fdfe96275385075b105c9', '3d9a351be3436fbefb1307d4cfb49bf2', '女', '2', null, '2', '1', null, '2019-01-04 14:56:56', null, '2019-01-04 17:38:12'); INSERT INTO `sys_dict_item` VALUES ('66c952ae2c3701a993e7db58f3baf55e', '4e4602b3e3686f0911384e188dc7efb4', '大于', '>', '大于', '1', '1', 'admin', '2019-04-01 10:45:46', 'admin', '2019-04-01 17:48:29'); INSERT INTO `sys_dict_item` VALUES ('6937c5dde8f92e9a00d4e2ded9198694', 'ad7c65ba97c20a6805d5dcdf13cdaf36', 'easyui', '3', null, '1', '1', 'admin', '2019-03-22 16:32:15', null, null); INSERT INTO `sys_dict_item` VALUES ('69cacf64e244100289ddd4aa9fa3b915', 'a9d9942bd0eccb6e89de92d130ec4c4a', '未发送', '0', null, '1', '1', 'admin', '2019-04-12 18:19:23', null, null); INSERT INTO `sys_dict_item` VALUES ('6a7a9e1403a7943aba69e54ebeff9762', '4f69be5f507accea8d5df5f11346181a', '邮件', '2', '', '2', '1', 'admin', '2031-02-28 10:50:44', 'admin', '2019-04-28 10:59:03'); INSERT INTO `sys_dict_item` VALUES ('6c682d78ddf1715baf79a1d52d2aa8c2', '72cce0989df68887546746d8f09811aa', '单表', '1', null, '1', '1', 'admin', '2019-03-27 10:13:29', null, null); INSERT INTO `sys_dict_item` VALUES ('6d404fd2d82311fbc87722cd302a28bc', '4e4602b3e3686f0911384e188dc7efb4', '模糊', 'LIKE', '模糊', '7', '1', 'admin', '2019-04-01 16:46:02', 'admin', '2019-04-01 17:49:20'); INSERT INTO `sys_dict_item` VALUES ('6d4e26e78e1a09699182e08516c49fc4', '4d7fec1a7799a436d26d02325eff295e', '高', 'H', '高', '1', '1', 'admin', '2019-04-16 17:04:24', null, null); INSERT INTO `sys_dict_item` VALUES ('700e9f030654f3f90e9ba76ab0713551', '6b78e3f59faec1a4750acff08030a79b', '333', '333', null, null, '1', 'admin', '2019-02-21 19:59:47', null, null); INSERT INTO `sys_dict_item` VALUES ('7050c1522702bac3be40e3b7d2e1dfd8', 'c5a14c75172783d72cbee6ee7f5df5d1', '柱状图', 'bar', null, '1', '1', 'admin', '2019-04-12 17:05:17', null, null); INSERT INTO `sys_dict_item` VALUES ('71b924faa93805c5c1579f12e001c809', 'd6e1152968b02d69ff358c75b48a6ee1', 'OA办公', 'oa', null, '2', '1', 'admin', '2021-03-22 19:27:17', 'admin', '2019-03-22 23:24:36'); INSERT INTO `sys_dict_item` VALUES ('75b260d7db45a39fc7f21badeabdb0ed', 'c36169beb12de8a71c8683ee7c28a503', '不启用', '0', null, null, '1', 'admin', '2019-03-18 23:29:41', 'admin', '2019-03-18 23:29:54'); INSERT INTO `sys_dict_item` VALUES ('7688469db4a3eba61e6e35578dc7c2e5', 'c36169beb12de8a71c8683ee7c28a503', '启用', '1', null, null, '1', 'admin', '2019-03-18 23:29:28', null, null); INSERT INTO `sys_dict_item` VALUES ('78ea6cadac457967a4b1c4eb7aaa418c', 'fc6cd58fde2e8481db10d3a1e68ce70c', '正常', '1', null, null, '1', 'admin', '2019-03-18 23:30:28', null, null); INSERT INTO `sys_dict_item` VALUES ('7ccf7b80c70ee002eceb3116854b75cb', 'ac2f7c0c5c5775fcea7e2387bcb22f01', '按钮权限', '2', null, null, '1', 'admin', '2019-03-18 23:25:40', null, null); INSERT INTO `sys_dict_item` VALUES ('81fb2bb0e838dc68b43f96cc309f8257', 'fc6cd58fde2e8481db10d3a1e68ce70c', '冻结', '2', null, null, '1', 'admin', '2019-03-18 23:30:37', null, null); INSERT INTO `sys_dict_item` VALUES ('83250269359855501ec4e9c0b7e21596', '4274efc2292239b6f000b153f50823ff', '可见/可访问(授权后可见/可访问)', '1', '', '1', '1', 'admin', '2019-05-10 17:54:51', null, null); INSERT INTO `sys_dict_item` VALUES ('84778d7e928bc843ad4756db1322301f', '4e4602b3e3686f0911384e188dc7efb4', '大于等于', '>=', '大于等于', '5', '1', 'admin', '2019-04-01 10:46:02', 'admin', '2019-04-01 17:49:05'); INSERT INTO `sys_dict_item` VALUES ('848d4da35ebd93782029c57b103e5b36', 'c5a14c75172783d72cbee6ee7f5df5d1', '饼图', 'pie', null, '3', '1', 'admin', '2019-04-12 17:05:49', null, null); INSERT INTO `sys_dict_item` VALUES ('84dfc178dd61b95a72900fcdd624c471', '78bda155fe380b1b3f175f1e88c284c6', '处理中', '2', '处理中', '2', '1', 'admin', '2019-05-09 16:33:01', null, null); INSERT INTO `sys_dict_item` VALUES ('86f19c7e0a73a0bae451021ac05b99dd', 'ac2f7c0c5c5775fcea7e2387bcb22f01', '子菜单', '1', null, null, '1', 'admin', '2019-03-18 23:25:27', null, null); INSERT INTO `sys_dict_item` VALUES ('8bccb963e1cd9e8d42482c54cc609ca2', '4f69be5f507accea8d5df5f11346181a', '微信', '3', null, '3', '1', 'admin', '2021-05-11 14:29:12', 'admin', '2019-04-11 14:29:31'); INSERT INTO `sys_dict_item` VALUES ('8c618902365ca681ebbbe1e28f11a548', '4c753b5293304e7a445fd2741b46529d', '启用', '1', '', '0', '1', 'admin', '2020-07-18 23:19:27', 'admin', '2019-05-17 14:51:18'); INSERT INTO `sys_dict_item` VALUES ('8cdf08045056671efd10677b8456c999', '4274efc2292239b6f000b153f50823ff', '可编辑(未授权时禁用)', '2', '', '2', '1', 'admin', '2019-05-10 17:55:38', null, null); INSERT INTO `sys_dict_item` VALUES ('8ff48e657a7c5090d4f2a59b37d1b878', '4d7fec1a7799a436d26d02325eff295e', '中', 'M', '中', '2', '1', 'admin', '2019-04-16 17:04:40', null, null); INSERT INTO `sys_dict_item` VALUES ('948923658baa330319e59b2213cda97c', '880a895c98afeca9d9ac39f29e67c13e', '添加', '2', '', '2', '1', 'admin', '2019-07-22 10:54:59', 'admin', '2019-07-22 10:55:36'); INSERT INTO `sys_dict_item` VALUES ('9a96c4a4e4c5c9b4e4d0cbf6eb3243cc', '4c753b5293304e7a445fd2741b46529d', '不启用', '0', null, '1', '1', 'admin', '2019-03-18 23:19:53', null, null); INSERT INTO `sys_dict_item` VALUES ('a1e7d1ca507cff4a480c8caba7c1339e', '880a895c98afeca9d9ac39f29e67c13e', '导出', '6', '', '6', '1', 'admin', '2019-07-22 12:06:50', null, null); INSERT INTO `sys_dict_item` VALUES ('a2be752dd4ec980afaec1efd1fb589af', '8dfe32e2d29ea9430a988b3b558bf233', '已撤销', '2', '已撤销', '3', '1', 'admin', '2019-04-16 17:41:39', null, null); INSERT INTO `sys_dict_item` VALUES ('aa0d8a8042a18715a17f0a888d360aa4', 'ac2f7c0c5c5775fcea7e2387bcb22f01', '一级菜单', '0', null, null, '1', 'admin', '2019-03-18 23:24:52', null, null); INSERT INTO `sys_dict_item` VALUES ('adcf2a1fe93bb99a84833043f475fe0b', '4e4602b3e3686f0911384e188dc7efb4', '包含', 'IN', '包含', '8', '1', 'admin', '2019-04-01 16:45:47', 'admin', '2019-04-01 17:49:24'); INSERT INTO `sys_dict_item` VALUES ('b029a41a851465332ee4ee69dcf0a4c2', '0b5d19e1fce4b2e6647e6b4a17760c14', '系统消息', '2', null, '1', '1', 'admin', '2019-02-22 18:02:08', 'admin', '2019-04-22 18:02:13'); INSERT INTO `sys_dict_item` VALUES ('b2a8b4bb2c8e66c2c4b1bb086337f393', '3486f32803bb953e7155dab3513dc68b', '正常', '0', null, null, '1', 'admin', '2022-10-18 21:46:48', 'admin', '2019-03-28 22:22:20'); INSERT INTO `sys_dict_item` VALUES ('b57f98b88363188daf38d42f25991956', '6b78e3f59faec1a4750acff08030a79b', '22', '222', null, null, '0', 'admin', '2019-02-21 19:59:43', 'admin', '2019-03-11 21:23:27'); INSERT INTO `sys_dict_item` VALUES ('b5f3bd5f66bb9a83fecd89228c0d93d1', '68168534ff5065a152bfab275c2136f8', '无效', '0', '无效', '1', '1', 'admin', '2019-04-26 19:21:49', null, null); INSERT INTO `sys_dict_item` VALUES ('b9fbe2a3602d4a27b45c100ac5328484', '78bda155fe380b1b3f175f1e88c284c6', '待提交', '1', '待提交', '1', '1', 'admin', '2019-05-09 16:32:35', null, null); INSERT INTO `sys_dict_item` VALUES ('ba27737829c6e0e582e334832703d75e', '236e8a4baff0db8c62c00dd95632834f', '同步', '1', '同步', '1', '1', 'admin', '2019-05-15 15:28:15', null, null); INSERT INTO `sys_dict_item` VALUES ('bcec04526b04307e24a005d6dcd27fd6', '880a895c98afeca9d9ac39f29e67c13e', '导入', '5', '', '5', '1', 'admin', '2019-07-22 12:06:41', null, null); INSERT INTO `sys_dict_item` VALUES ('c53da022b9912e0aed691bbec3c78473', '880a895c98afeca9d9ac39f29e67c13e', '查询', '1', '', '1', '1', 'admin', '2019-07-22 10:54:51', null, null); INSERT INTO `sys_dict_item` VALUES ('c5700a71ad08994d18ad1dacc37a71a9', 'a7adbcd86c37f7dbc9b66945c82ef9e6', '否', '0', '', '1', '1', 'admin', '2019-05-22 19:29:55', null, null); INSERT INTO `sys_dict_item` VALUES ('cbfcc5b88fc3a90975df23ffc8cbe29c', 'c5a14c75172783d72cbee6ee7f5df5d1', '曲线图', 'line', null, '2', '1', 'admin', '2019-05-12 17:05:30', 'admin', '2019-04-12 17:06:06'); INSERT INTO `sys_dict_item` VALUES ('d217592908ea3e00ff986ce97f24fb98', 'c5a14c75172783d72cbee6ee7f5df5d1', '数据列表', 'table', null, '4', '1', 'admin', '2019-04-12 17:05:56', null, null); INSERT INTO `sys_dict_item` VALUES ('df168368dcef46cade2aadd80100d8aa', '3d9a351be3436fbefb1307d4cfb49bf2', '男', '1', null, '1', '1', null, '2027-08-04 14:56:49', 'admin', '2019-03-23 22:44:44'); INSERT INTO `sys_dict_item` VALUES ('e6329e3a66a003819e2eb830b0ca2ea0', '4e4602b3e3686f0911384e188dc7efb4', '小于', '<', '小于', '2', '1', 'admin', '2019-04-01 16:44:15', 'admin', '2019-04-01 17:48:34'); INSERT INTO `sys_dict_item` VALUES ('e94eb7af89f1dbfa0d823580a7a6e66a', '236e8a4baff0db8c62c00dd95632834f', '不同步', '0', '不同步', '2', '1', 'admin', '2019-05-15 15:28:28', null, null); INSERT INTO `sys_dict_item` VALUES ('f0162f4cc572c9273f3e26b2b4d8c082', 'ad7c65ba97c20a6805d5dcdf13cdaf36', 'booostrap', '1', null, '1', '1', 'admin', '2021-08-22 16:32:04', 'admin', '2019-03-22 16:33:57'); INSERT INTO `sys_dict_item` VALUES ('f16c5706f3ae05c57a53850c64ce7c45', 'a9d9942bd0eccb6e89de92d130ec4c4a', '发送成功', '1', null, '2', '1', 'admin', '2019-04-12 18:19:43', null, null); INSERT INTO `sys_dict_item` VALUES ('f2a7920421f3335afdf6ad2b342f6b5d', '845da5006c97754728bf48b6a10f79cc', '冻结', '2', null, null, '1', 'admin', '2019-03-18 21:46:02', null, null); INSERT INTO `sys_dict_item` VALUES ('f37f90c496ec9841c4c326b065e00bb2', '83bfb33147013cc81640d5fd9eda030c', '登录日志', '1', null, null, '1', 'admin', '2019-03-18 23:22:37', null, null); INSERT INTO `sys_dict_item` VALUES ('f753aff60ff3931c0ecb4812d8b5e643', '4c03fca6bf1f0299c381213961566349', '双排布局', 'double', null, '3', '1', 'admin', '2019-04-12 17:43:51', null, null); INSERT INTO `sys_dict_item` VALUES ('f80a8f6838215753b05e1a5ba3346d22', '880a895c98afeca9d9ac39f29e67c13e', '删除', '4', '', '4', '1', 'admin', '2019-07-22 10:55:14', 'admin', '2019-07-22 10:55:30'); INSERT INTO `sys_dict_item` VALUES ('fcec03570f68a175e1964808dc3f1c91', '4c03fca6bf1f0299c381213961566349', 'Tab风格', 'tab', null, '1', '1', 'admin', '2019-04-12 17:43:31', null, null); INSERT INTO `sys_dict_item` VALUES ('fe50b23ae5e68434def76f67cef35d2d', '78bda155fe380b1b3f175f1e88c284c6', '已作废', '4', '已作废', '4', '1', 'admin', '2021-09-09 16:33:43', 'admin', '2019-05-09 16:34:40'); -- ---------------------------- -- Table structure for sys_fill_rule -- ---------------------------- DROP TABLE IF EXISTS `sys_fill_rule`; CREATE TABLE `sys_fill_rule` ( `id` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '主键ID', `rule_name` varchar(100) DEFAULT NULL COMMENT '规则名称', `rule_code` varchar(100) DEFAULT NULL COMMENT '规则Code', `rule_class` varchar(100) DEFAULT NULL COMMENT '规则实现类', `rule_params` varchar(200) DEFAULT NULL COMMENT '规则参数', `update_by` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '修改人', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `create_by` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uni_sys_fill_rule_code` (`rule_code`) USING BTREE, UNIQUE KEY `uk_sfr_rule_code` (`rule_code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_fill_rule -- ---------------------------- INSERT INTO `sys_fill_rule` VALUES ('1202551334738382850', '机构编码生成', 'org_num_role', 'org.jeecg.modules.system.rule.OrgCodeRule', '{\"parentId\":\"c6d7cb4deeac411cb3384b1b31278596\"}', 'admin', '2019-12-09 10:37:06', 'admin', '2019-12-05 19:32:35'); INSERT INTO `sys_fill_rule` VALUES ('1202787623203065858', '分类字典编码生成', 'category_code_rule', 'org.jeecg.modules.system.rule.CategoryCodeRule', '{\"pid\":\"\"}', 'admin', '2019-12-09 10:36:54', 'admin', '2019-12-06 11:11:31'); INSERT INTO `sys_fill_rule` VALUES ('1260134137920090113', '订单流水号', 'shop_order_num', 'org.jeecg.modules.online.cgform.rule.OrderNumberRule', '{}', 'admin', '2020-12-07 18:29:50', 'admin', '2020-05-12 17:06:05'); -- ---------------------------- -- Table structure for sys_gateway_route -- ---------------------------- DROP TABLE IF EXISTS `sys_gateway_route`; CREATE TABLE `sys_gateway_route` ( `id` varchar(36) NOT NULL, `router_id` varchar(50) DEFAULT NULL COMMENT '路由ID', `name` varchar(32) DEFAULT NULL COMMENT '服务名', `uri` varchar(32) DEFAULT NULL COMMENT '服务地址', `predicates` text COMMENT '断言', `filters` text COMMENT '过滤器', `retryable` int(3) DEFAULT NULL COMMENT '是否重试:0-否 1-是', `strip_prefix` int(3) DEFAULT NULL COMMENT '是否忽略前缀0-否 1-是', `persistable` int(3) DEFAULT NULL COMMENT '是否为保留数据:0-否 1-是', `show_api` int(3) DEFAULT NULL COMMENT '是否在接口文档中展示:0-否 1-是', `status` int(3) DEFAULT NULL COMMENT '状态:0-无效 1-有效', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of sys_gateway_route -- ---------------------------- INSERT INTO `sys_gateway_route` VALUES ('1331051599401857026', 'jeecg-demo-websocket', 'jeecg-demo-websocket', 'lb:ws://jeecg-demo', '[{\"args\":[\"/vxeSocket/**\"],\"name\":\"Path\"}]', '[]', null, null, null, null, '1', 'admin', '2020-11-24 09:46:46', null, null, null); INSERT INTO `sys_gateway_route` VALUES ('jeecg-cloud-websocket', 'jeecg-system-websocket', 'jeecg-system-websocket', 'lb:ws://jeecg-system', '[{\"args\":[\"/websocket/**\",\"/eoaSocket/**\",\"/newsWebsocket/**\"],\"name\":\"Path\"}]', '[]', null, null, null, null, '1', 'admin', '2020-11-16 19:41:51', null, null, null); INSERT INTO `sys_gateway_route` VALUES ('jeecg-demo', 'jeecg-demo', 'jeecg-demo', 'lb://jeecg-demo', '[{\"args\":[\"/mock/**\",\"/test/**\",\"/bigscreen/template1/**\",\"/bigscreen/template2/**\"],\"name\":\"Path\"}]', '[]', null, null, null, null, '1', 'admin', '2020-11-16 19:41:51', null, null, null); INSERT INTO `sys_gateway_route` VALUES ('jeecg-system', 'jeecg-system', 'jeecg-system', 'lb://jeecg-system', '[{\"args\":[\"/sys/**\",\"/eoa/**\",\"/joa/**\",\"/online/**\",\"/bigscreen/**\",\"/jmreport/**\",\"/desform/**\",\"/process/**\",\"/act/**\",\"/plug-in/***/\",\"/druid/**\",\"/generic/**\"],\"name\":\"Path\"}]', '[]', null, null, null, null, '1', 'admin', '2020-11-16 19:41:51', null, null, null); -- ---------------------------- -- Table structure for sys_log -- ---------------------------- DROP TABLE IF EXISTS `sys_log`; CREATE TABLE `sys_log` ( `id` varchar(32) NOT NULL, `log_type` int(2) DEFAULT NULL COMMENT '日志类型（1登录日志，2操作日志）', `log_content` varchar(1000) DEFAULT NULL COMMENT '日志内容', `operate_type` int(2) DEFAULT NULL COMMENT '操作类型', `userid` varchar(32) DEFAULT NULL COMMENT '操作用户账号', `username` varchar(100) DEFAULT NULL COMMENT '操作用户名称', `ip` varchar(100) DEFAULT NULL COMMENT 'IP', `method` varchar(500) DEFAULT NULL COMMENT '请求java方法', `request_url` varchar(255) DEFAULT NULL COMMENT '请求路径', `request_param` longtext COMMENT '请求参数', `request_type` varchar(10) DEFAULT NULL COMMENT '请求类型', `cost_time` bigint(20) DEFAULT NULL COMMENT '耗时', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, KEY `index_table_userid` (`userid`) USING BTREE, KEY `index_logt_ype` (`log_type`) USING BTREE, KEY `index_operate_type` (`operate_type`) USING BTREE, KEY `index_log_type` (`log_type`) USING BTREE, KEY `idx_sl_userid` (`userid`) USING BTREE, KEY `idx_sl_log_type` (`log_type`) USING BTREE, KEY `idx_sl_operate_type` (`operate_type`) USING BTREE, KEY `idx_sl_create_time` (`create_time`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统日志表'; -- ---------------------------- -- Records of sys_log -- ---------------------------- -- ---------------------------- -- Table structure for sys_permission -- ---------------------------- DROP TABLE IF EXISTS `sys_permission`; CREATE TABLE `sys_permission` ( `id` varchar(32) NOT NULL COMMENT '主键id', `parent_id` varchar(32) DEFAULT NULL COMMENT '父id', `name` varchar(100) DEFAULT NULL COMMENT '菜单标题', `url` varchar(255) DEFAULT NULL COMMENT '路径', `component` varchar(255) DEFAULT NULL COMMENT '组件', `component_name` varchar(100) DEFAULT NULL COMMENT '组件名字', `redirect` varchar(255) DEFAULT NULL COMMENT '一级菜单跳转地址', `menu_type` int(11) DEFAULT NULL COMMENT '菜单类型(0:一级菜单; 1:子菜单:2:按钮权限)', `perms` varchar(255) DEFAULT NULL COMMENT '菜单权限编码', `perms_type` varchar(10) DEFAULT '0' COMMENT '权限策略1显示2禁用', `sort_no` double(8,2) DEFAULT NULL COMMENT '菜单排序', `always_show` tinyint(1) DEFAULT NULL COMMENT '聚合子路由: 1是0否', `icon` varchar(100) DEFAULT NULL COMMENT '菜单图标', `is_route` tinyint(1) DEFAULT '1' COMMENT '是否路由菜单: 0:不是 1:是（默认值1）', `is_leaf` tinyint(1) DEFAULT NULL COMMENT '是否叶子节点: 1:是 0:不是', `keep_alive` tinyint(1) DEFAULT NULL COMMENT '是否缓存该页面: 1:是 0:不是', `hidden` int(2) DEFAULT '0' COMMENT '是否隐藏路由: 0否,1是', `description` varchar(255) DEFAULT NULL COMMENT '描述', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `del_flag` int(1) DEFAULT '0' COMMENT '删除状态 0正常 1已删除', `rule_flag` int(3) DEFAULT '0' COMMENT '是否添加数据权限1是0否', `status` varchar(2) DEFAULT NULL COMMENT '按钮权限状态(0无效1有效)', `internal_or_external` tinyint(1) DEFAULT NULL COMMENT '外链菜单打开方式 0/内部打开 1/外部打开', PRIMARY KEY (`id`) USING BTREE, KEY `index_prem_pid` (`parent_id`) USING BTREE, KEY `index_prem_is_route` (`is_route`) USING BTREE, KEY `index_prem_is_leaf` (`is_leaf`) USING BTREE, KEY `index_prem_sort_no` (`sort_no`) USING BTREE, KEY `index_prem_del_flag` (`del_flag`) USING BTREE, KEY `index_menu_type` (`menu_type`) USING BTREE, KEY `index_menu_hidden` (`hidden`) USING BTREE, KEY `index_menu_status` (`status`) USING BTREE, KEY `idx_sp_parent_id` (`parent_id`) USING BTREE, KEY `idx_sp_is_route` (`is_route`) USING BTREE, KEY `idx_sp_is_leaf` (`is_leaf`) USING BTREE, KEY `idx_sp_sort_no` (`sort_no`) USING BTREE, KEY `idx_sp_del_flag` (`del_flag`) USING BTREE, KEY `idx_sp_menu_type` (`menu_type`) USING BTREE, KEY `idx_sp_hidden` (`hidden`) USING BTREE, KEY `idx_sp_status` (`status`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单权限表'; -- ---------------------------- -- Records of sys_permission -- ---------------------------- INSERT INTO `sys_permission` VALUES ('024f1fd1283dc632458976463d8984e1', '700b7f95165c46cc7a78bf227aa8fed3', 'Tomcat信息', '/monitor/TomcatInfo', 'modules/monitor/TomcatInfo', null, null, '1', null, null, '4.00', '0', null, '1', '1', null, '0', null, 'admin', '2019-04-02 09:44:29', 'admin', '2019-05-07 15:19:10', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('08e6b9dc3c04489c8e1ff2ce6f105aa4', '', '系统监控', '/dashboard3', 'layouts/RouteView', null, null, '0', null, null, '6.00', '0', 'dashboard', '1', '0', null, '0', null, null, '2018-12-25 20:34:38', 'admin', '2019-03-31 22:19:58', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('0ac2ad938963b6c6d1af25477d5b8b51', '8d4683aacaa997ab86b966b464360338', '代码生成按钮', null, null, null, null, '2', 'online:goGenerateCode', '1', '1.00', '0', null, '1', '1', null, '0', null, 'admin', '2019-06-11 14:20:09', null, null, '0', '0', '1', null); INSERT INTO `sys_permission` VALUES ('109c78a583d4693ce2f16551b7786786', 'e41b69c57a941a3bbcce45032fe57605', 'Online报表配置', '/online/cgreport', 'modules/online/cgreport/OnlCgreportHeadList', null, null, '1', null, null, '2.00', '0', null, '1', '1', null, '0', null, 'admin', '2019-03-08 10:51:07', 'admin', '2019-03-30 19:04:28', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('1174506953255182338', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '职务管理', '/isystem/position', 'system/SysPositionList', null, null, '1', null, '1', '2.00', '0', null, '1', '1', '0', '0', null, 'admin', '2019-09-19 10:14:13', 'admin', '2019-09-19 10:15:22', '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('1174590283938041857', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '通讯录', '/isystem/addressList', 'system/AddressList', null, null, '1', null, '1', '3.00', '0', null, '1', '1', '0', '0', null, 'admin', '2019-09-19 15:45:21', null, null, '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('1192318987661234177', 'e41b69c57a941a3bbcce45032fe57605', '系统编码规则', '/isystem/fillRule', 'system/SysFillRuleList', null, null, '1', null, '1', '3.00', '0', null, '1', '1', '0', '0', null, 'admin', '2019-11-07 13:52:53', 'admin', '2020-07-10 16:55:03', '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('1209731624921534465', 'e41b69c57a941a3bbcce45032fe57605', '多数据源管理', '/isystem/dataSource', 'system/SysDataSourceList', null, null, '1', null, '1', '6.00', '0', null, '1', '1', '0', '0', null, 'admin', '2019-12-25 15:04:30', 'admin', '2020-02-23 22:43:37', '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('1224641973866467330', 'e41b69c57a941a3bbcce45032fe57605', '系统校验规则', '/isystem/checkRule', 'system/SysCheckRuleList', null, null, '1', null, '1', '5.00', '0', null, '1', '1', '0', '0', null, 'admin', '2019-11-07 13:52:53', 'admin', '2020-07-10 16:55:12', '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('1260928341675982849', '3f915b2769fc80648e92d04e84ca059d', '添加按钮', null, null, null, null, '2', 'user:add', '1', '1.00', '0', null, '1', '1', '0', '0', null, 'admin', '2020-05-14 21:41:58', null, null, '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('1260929666434318338', '3f915b2769fc80648e92d04e84ca059d', '用户编辑', null, null, null, null, '2', 'user:edit', '1', '1.00', '0', null, '1', '1', '0', '0', null, 'admin', '2020-05-14 21:47:14', null, null, '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('1260931366557696001', '3f915b2769fc80648e92d04e84ca059d', '表单性别可见', '', null, null, null, '2', 'user:sex', '1', '1.00', '0', null, '1', '1', '0', '0', null, 'admin', '2020-05-14 21:53:59', 'admin', '2020-05-14 21:57:00', '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('1260933542969458689', '3f915b2769fc80648e92d04e84ca059d', '禁用生日字段', null, null, null, null, '2', 'user:form:birthday', '2', '1.00', '0', null, '1', '1', '0', '0', null, 'admin', '2020-05-14 22:02:38', null, null, '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('1265162119913824258', '08e6b9dc3c04489c8e1ff2ce6f105aa4', '路由网关', '/isystem/gatewayroute', 'system/SysGatewayRouteList', null, null, '1', null, '1', '0.00', '0', null, '1', '1', '0', '0', null, null, '2020-05-26 14:05:30', 'admin', '2020-09-09 14:47:52', '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('1280350452934307841', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '租户管理', '/isys/tenant', 'system/TenantList', null, null, '1', null, '1', '10.00', '0', null, '1', '1', '0', '0', null, 'admin', '2020-07-07 11:58:30', 'admin', '2020-07-10 15:46:35', '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('190c2b43bec6a5f7a4194a85db67d96a', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '角色管理', '/isystem/roleUserList', 'system/RoleUserList', null, null, '1', null, null, '1.20', '0', null, '1', '1', '0', '0', null, 'admin', '2019-04-17 15:13:56', 'admin', '2019-12-25 09:36:31', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('1a0811914300741f4e11838ff37a1d3a', '3f915b2769fc80648e92d04e84ca059d', '手机号禁用', null, null, null, null, '2', 'user:form:phone', '2', '1.00', '0', null, '0', '1', null, '0', null, 'admin', '2019-05-11 17:19:30', 'admin', '2019-05-11 18:00:22', '0', '0', '1', null); INSERT INTO `sys_permission` VALUES ('3f915b2769fc80648e92d04e84ca059d', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '用户管理', '/isystem/user', 'system/UserList', null, null, '1', null, null, '1.10', '0', null, '1', '0', '0', '0', null, null, '2018-12-25 20:34:38', 'admin', '2019-12-25 09:36:24', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('45c966826eeff4c99b8f8ebfe74511fc', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '部门管理', '/isystem/depart', 'system/DepartList', null, null, '1', null, null, '1.40', '0', null, '1', '1', '0', '0', null, 'admin', '2019-01-29 18:47:40', 'admin', '2019-12-25 09:36:47', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('54dd5457a3190740005c1bfec55b1c34', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '菜单管理', '/isystem/permission', 'system/PermissionList', null, null, '1', null, null, '1.30', '0', null, '1', '1', '0', '0', null, null, '2018-12-25 20:34:38', 'admin', '2019-12-25 09:36:39', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('58857ff846e61794c69208e9d3a85466', '08e6b9dc3c04489c8e1ff2ce6f105aa4', '日志管理', '/isystem/log', 'system/LogList', null, null, '1', null, null, '2.00', '0', '', '1', '1', '0', '0', null, null, '2018-12-26 10:11:18', 'admin', '2020-09-09 14:48:25', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('5c2f42277948043026b7a14692456828', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '我的部门', '/isystem/departUserList', 'system/DepartUserList', null, null, '1', null, null, '2.00', '0', null, '1', '1', '0', '0', null, 'admin', '2019-04-17 15:12:24', 'admin', '2019-12-25 09:35:26', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('700b7f95165c46cc7a78bf227aa8fed3', '08e6b9dc3c04489c8e1ff2ce6f105aa4', '性能监控', '/monitor', 'layouts/RouteView', null, null, '1', null, null, '3.00', '0', null, '1', '0', '0', '0', null, 'admin', '2019-04-02 11:34:34', 'admin', '2020-09-09 14:48:51', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('841057b8a1bef8f6b4b20f9a618a7fa6', '08e6b9dc3c04489c8e1ff2ce6f105aa4', '数据日志', '/sys/dataLog-list', 'system/DataLogList', null, null, '1', null, null, '2.10', '0', null, '1', '1', '0', '0', null, 'admin', '2019-03-11 19:26:49', 'admin', '2020-09-09 14:48:32', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('8b3bff2eee6f1939147f5c68292a1642', '700b7f95165c46cc7a78bf227aa8fed3', '服务器信息', '/monitor/SystemInfo', 'modules/monitor/SystemInfo', null, null, '1', null, null, '4.00', '0', null, '1', '1', null, '0', null, 'admin', '2019-04-02 11:39:19', 'admin', '2019-04-02 15:40:02', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('8d1ebd663688965f1fd86a2f0ead3416', '700b7f95165c46cc7a78bf227aa8fed3', 'Redis监控', '/monitor/redis/info', 'modules/monitor/RedisInfo', null, null, '1', null, null, '1.00', '0', null, '1', '1', null, '0', null, 'admin', '2019-04-02 13:11:33', 'admin', '2019-05-07 15:18:54', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('8d4683aacaa997ab86b966b464360338', 'e41b69c57a941a3bbcce45032fe57605', 'Online表单开发', '/online/cgform', 'modules/online/cgform/OnlCgformHeadList', null, null, '1', null, null, '1.00', '0', null, '1', '0', null, '0', null, 'admin', '2019-03-12 15:48:14', 'admin', '2019-06-11 14:19:17', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('9502685863ab87f0ad1134142788a385', '', '首页', '/dashboard/analysis', 'dashboard/Analysis', null, null, '0', null, null, '0.00', '0', 'home', '1', '1', null, '0', null, null, '2018-12-25 20:34:38', 'admin', '2019-03-29 11:04:13', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('97c8629abc7848eccdb6d77c24bb3ebb', '700b7f95165c46cc7a78bf227aa8fed3', '磁盘监控', '/monitor/Disk', 'modules/monitor/DiskMonitoring', null, null, '1', null, null, '6.00', '0', null, '1', '1', null, '0', null, 'admin', '2019-04-25 14:30:06', 'admin', '2019-05-05 14:37:14', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('9cb91b8851db0cf7b19d7ecc2a8193dd', '1939e035e803a99ceecb6f5563570fb2', '我的任务表单', '/modules/bpm/task/form/FormModule', 'modules/bpm/task/form/FormModule', null, null, '1', null, null, '1.00', '0', null, '1', '1', null, '0', null, 'admin', '2019-03-08 16:49:05', 'admin', '2019-03-08 18:37:56', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('aedbf679b5773c1f25e9f7b10111da73', '08e6b9dc3c04489c8e1ff2ce6f105aa4', 'SQL监控', '{{ window._CONFIG[\'domianURL\'] }}/druid/', 'layouts/IframePageView', null, null, '1', null, null, '3.00', '0', null, '1', '1', '0', '0', null, 'admin', '2019-01-30 09:43:22', 'admin', '2020-09-09 14:48:38', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('b1cb0a3fedf7ed0e4653cb5a229837ee', '08e6b9dc3c04489c8e1ff2ce6f105aa4', '定时任务', '/isystem/QuartzJobList', 'system/QuartzJobList', null, null, '1', null, null, '1.00', '0', null, '1', '1', '0', '0', null, null, '2019-01-03 09:38:52', 'admin', '2020-09-09 14:48:16', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('b6bcee2ccc854052d3cc3e9c96d90197', '71102b3b87fb07e5527bbd2c530dd90a', '加班申请', '/modules/extbpm/joa/JoaOvertimeList', 'modules/extbpm/joa/JoaOvertimeList', null, null, '1', null, null, '1.00', '0', null, '1', '1', null, '0', null, 'admin', '2019-04-03 15:33:10', 'admin', '2019-04-03 15:34:48', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('d07a2c87a451434c99ab06296727ec4f', '700b7f95165c46cc7a78bf227aa8fed3', 'JVM信息', '/monitor/JvmInfo', 'modules/monitor/JvmInfo', null, null, '1', null, null, '4.00', '0', null, '1', '1', null, '0', null, 'admin', '2019-04-01 23:07:48', 'admin', '2019-04-02 11:37:16', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('d7d6e2e4e2934f2c9385a623fd98c6f3', '', '系统管理', '/isystem', 'layouts/RouteView', null, null, '0', null, null, '4.00', '0', 'setting', '1', '0', null, '0', null, null, '2018-12-25 20:34:38', 'admin', '2019-03-31 22:19:52', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('e08cb190ef230d5d4f03824198773950', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '系统通告', '/isystem/annountCement', 'system/SysAnnouncementList', null, null, '1', 'annountCement', null, '6.00', null, '', '1', '1', null, null, null, null, '2019-01-02 17:23:01', null, '2019-01-02 17:31:23', '0', '0', null, null); INSERT INTO `sys_permission` VALUES ('e41b69c57a941a3bbcce45032fe57605', '', '在线开发', '/online', 'layouts/RouteView', null, null, '0', null, null, '2.00', '0', 'cloud', '1', '0', '0', '0', null, 'admin', '2019-03-08 10:43:10', 'admin', '2021-01-24 14:15:12', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('ebb9d82ea16ad864071158e0c449d186', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '分类字典', '/isys/category', 'system/SysCategoryList', null, null, '1', null, '1', '5.20', '0', null, '1', '1', '0', '0', null, 'admin', '2019-05-29 18:48:07', 'admin', '2020-02-23 22:45:33', '0', '0', '1', '0'); INSERT INTO `sys_permission` VALUES ('f1cb187abf927c88b89470d08615f5ac', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '数据字典', '/isystem/dict', 'system/DictList', null, null, '1', null, null, '5.00', '0', null, '1', '1', '0', '0', null, null, '2018-12-28 13:54:43', 'admin', '2020-02-23 22:45:25', '0', '0', null, '0'); INSERT INTO `sys_permission` VALUES ('fc810a2267dd183e4ef7c71cc60f4670', '700b7f95165c46cc7a78bf227aa8fed3', '请求追踪', '/monitor/HttpTrace', 'modules/monitor/HttpTrace', null, null, '1', null, null, '4.00', '0', null, '1', '1', null, '0', null, 'admin', '2019-04-02 09:46:19', 'admin', '2019-04-02 11:37:27', '0', '0', null, null); -- ---------------------------- -- Table structure for sys_permission_data_rule -- ---------------------------- DROP TABLE IF EXISTS `sys_permission_data_rule`; CREATE TABLE `sys_permission_data_rule` ( `id` varchar(32) NOT NULL COMMENT 'ID', `permission_id` varchar(32) DEFAULT NULL COMMENT '菜单ID', `rule_name` varchar(50) DEFAULT NULL COMMENT '规则名称', `rule_column` varchar(50) DEFAULT NULL COMMENT '字段', `rule_conditions` varchar(50) DEFAULT NULL COMMENT '条件', `rule_value` varchar(300) DEFAULT NULL COMMENT '规则值', `status` varchar(3) DEFAULT NULL COMMENT '权限有效状态1有0否', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(32) DEFAULT NULL, `update_time` datetime DEFAULT NULL COMMENT '修改时间', `update_by` varchar(32) DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE, KEY `index_fucntionid` (`permission_id`) USING BTREE, KEY `idx_spdr_permission_id` (`permission_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_permission_data_rule -- ---------------------------- INSERT INTO `sys_permission_data_rule` VALUES ('32b62cb04d6c788d9d92e3ff5e66854e', '8d4683aacaa997ab86b966b464360338', '000', '00', '!=', '00', '1', '2019-04-02 18:36:08', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('40283181614231d401614234fe670003', '40283181614231d401614232cd1c0001', 'createBy', 'createBy', '=', '#{sys_user_code}', '1', '2018-01-29 21:57:04', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('4028318161424e730161424fca6f0004', '4028318161424e730161424f61510002', 'createBy', 'createBy', '=', '#{sys_user_code}', '1', '2018-01-29 22:26:20', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402880e6487e661a01487e732c020005', '402889fb486e848101486e93a7c80014', 'SYS_ORG_CODE', 'SYS_ORG_CODE', 'LIKE', '010201%', '1', '2014-09-16 20:32:30', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402880e6487e661a01487e8153ee0007', '402889fb486e848101486e93a7c80014', 'create_by', 'create_by', '', '#{SYS_USER_CODE}', '1', '2014-09-16 20:47:57', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402880ec5ddec439015ddf9225060038', '40288088481d019401481d2fcebf000d', '复杂关系', '', 'USE_SQL_RULES', 'name like \'%张%\' or age > 10', '1', null, null, '2017-08-14 15:10:25', 'demo'); INSERT INTO `sys_permission_data_rule` VALUES ('402880ec5ddfdd26015ddfe3e0570011', '4028ab775dca0d1b015dca3fccb60016', '复杂sql配置', '', 'USE_SQL_RULES', 'table_name like \'%test%\' or is_tree = \'Y\'', '1', null, null, '2017-08-14 16:38:55', 'demo'); INSERT INTO `sys_permission_data_rule` VALUES ('402880f25b1e2ac7015b1e5fdebc0012', '402880f25b1e2ac7015b1e5cdc340010', '只能看自己数据', 'create_by', '=', '#{sys_user_code}', '1', '2017-03-30 16:40:51', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402881875b19f141015b19f8125e0014', '40288088481d019401481d2fcebf000d', '可看下属业务数据', 'sys_org_code', 'LIKE', '#{sys_org_code}', '1', null, null, '2017-08-14 15:04:32', 'demo'); INSERT INTO `sys_permission_data_rule` VALUES ('402881e45394d66901539500a4450001', '402881e54df73c73014df75ab670000f', 'sysCompanyCode', 'sysCompanyCode', '=', '#{SYS_COMPANY_CODE}', '1', '2016-03-21 01:09:21', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402881e45394d6690153950177cb0003', '402881e54df73c73014df75ab670000f', 'sysOrgCode', 'sysOrgCode', '=', '#{SYS_ORG_CODE}', '1', '2016-03-21 01:10:15', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402881e56266f43101626727aff60067', '402881e56266f43101626724eb730065', '销售自己看自己的数据', 'createBy', '=', '#{sys_user_code}', '1', '2018-03-27 19:11:16', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402881e56266f4310162672fb1a70082', '402881e56266f43101626724eb730065', '销售经理看所有下级数据', 'sysOrgCode', 'LIKE', '#{sys_org_code}', '1', '2018-03-27 19:20:01', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402881e56266f431016267387c9f0088', '402881e56266f43101626724eb730065', '只看金额大于1000的数据', 'money', '>=', '1000', '1', '2018-03-27 19:29:37', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402881f3650de25101650dfb5a3a0010', '402881e56266f4310162671d62050044', '22', '', 'USE_SQL_RULES', '22', '1', '2018-08-06 14:45:01', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402889fb486e848101486e913cd6000b', '402889fb486e848101486e8e2e8b0007', 'userName', 'userName', '=', 'admin', '1', '2014-09-13 18:31:25', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('402889fb486e848101486e98d20d0016', '402889fb486e848101486e93a7c80014', 'title', 'title', '=', '12', '1', null, null, '2014-09-13 22:18:22', 'scott'); INSERT INTO `sys_permission_data_rule` VALUES ('402889fe47fcb29c0147fcb6b6220001', '8a8ab0b246dc81120146dc8180fe002b', '12', '12', '>', '12', '1', '2014-08-22 15:55:38', '8a8ab0b246dc81120146dc8181950052', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('4028ab775dca0d1b015dca4183530018', '4028ab775dca0d1b015dca3fccb60016', '表名限制', 'isDbSynch', '=', 'Y', '1', null, null, '2017-08-14 16:43:45', 'demo'); INSERT INTO `sys_permission_data_rule` VALUES ('4028ef815595a881015595b0ccb60001', '40288088481d019401481d2fcebf000d', '限只能看自己', 'create_by', '=', '#{sys_user_code}', '1', null, null, '2017-08-14 15:03:56', 'demo'); INSERT INTO `sys_permission_data_rule` VALUES ('4028ef81574ae99701574aed26530005', '4028ef81574ae99701574aeb97bd0003', '用户名', 'userName', '!=', 'admin', '1', '2016-09-21 12:07:18', 'admin', null, null); INSERT INTO `sys_permission_data_rule` VALUES ('f852d85d47f224990147f2284c0c0005', null, '小于', 'test', '<=', '11', '1', '2014-08-20 14:43:52', '8a8ab0b246dc81120146dc8181950052', null, null); -- ---------------------------- -- Table structure for sys_position -- ---------------------------- DROP TABLE IF EXISTS `sys_position`; CREATE TABLE `sys_position` ( `id` varchar(32) NOT NULL, `code` varchar(100) DEFAULT NULL COMMENT '职务编码', `name` varchar(100) DEFAULT NULL COMMENT '职务名称', `post_rank` varchar(2) DEFAULT NULL COMMENT '职级', `company_id` varchar(255) DEFAULT NULL COMMENT '公司id', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(50) DEFAULT NULL COMMENT '修改人', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `sys_org_code` varchar(50) DEFAULT NULL COMMENT '组织机构编码', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniq_code` (`code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_position -- ---------------------------- INSERT INTO `sys_position` VALUES ('1185040064792571906', 'devleader', '研发部经理', '2', null, 'admin', '2019-10-18 11:49:03', 'admin', '2020-02-23 22:55:42', 'A01'); INSERT INTO `sys_position` VALUES ('1256485574212153345', '总经理', 'laozong', '5', null, 'admin', '2020-05-02 15:28:00', 'admin', '2020-05-02 15:28:03', '北京国炬公司'); -- ---------------------------- -- Table structure for sys_quartz_job -- ---------------------------- DROP TABLE IF EXISTS `sys_quartz_job`; CREATE TABLE `sys_quartz_job` ( `id` varchar(32) NOT NULL, `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `del_flag` int(1) DEFAULT NULL COMMENT '删除状态', `update_by` varchar(32) DEFAULT NULL COMMENT '修改人', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `job_class_name` varchar(255) DEFAULT NULL COMMENT '任务类名', `cron_expression` varchar(255) DEFAULT NULL COMMENT 'cron表达式', `parameter` varchar(255) DEFAULT NULL COMMENT '参数', `description` varchar(255) DEFAULT NULL COMMENT '描述', `status` int(1) DEFAULT NULL COMMENT '状态 0正常 -1停止', PRIMARY KEY (`id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_quartz_job -- ---------------------------- INSERT INTO `sys_quartz_job` VALUES ('df26ecacf0f75d219d746750fe84bbee', null, null, '0', 'admin', '2020-05-02 15:40:35', 'org.jeecg.modules.quartz.job.SampleParamJob', '0/1 * * * * ?', 'scott', '带参测试 后台将每隔1秒执行输出日志', '-1'); INSERT INTO `sys_quartz_job` VALUES ('a253cdfc811d69fa0efc70d052bc8128', 'admin', '2019-03-30 12:44:48', '0', 'admin', '2020-05-02 15:48:49', 'org.jeecg.modules.quartz.job.SampleJob', '0/1 * * * * ?', null, null, '-1'); INSERT INTO `sys_quartz_job` VALUES ('5b3d2c087ad41aa755fc4f89697b01e7', 'admin', '2019-04-11 19:04:21', '0', 'admin', '2020-05-02 15:48:48', 'org.jeecg.modules.message.job.SendMsgJob', '0/50 * * * * ? *', null, null, '-1'); -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` varchar(32) NOT NULL COMMENT '主键id', `role_name` varchar(200) DEFAULT NULL COMMENT '角色名称', `role_code` varchar(100) NOT NULL COMMENT '角色编码', `description` varchar(255) DEFAULT NULL COMMENT '描述', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniq_sys_role_role_code` (`role_code`) USING BTREE, KEY `idx_sr_role_code` (`role_code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色表'; -- ---------------------------- -- Records of sys_role -- ---------------------------- INSERT INTO `sys_role` VALUES ('1169504891467464705', '第三方登录角色', 'third_role', '第三方登录角色', 'admin', '2019-09-05 14:57:49', 'admin', '2020-05-02 18:20:58'); INSERT INTO `sys_role` VALUES ('f6817f48af4fb3af11b9e8bf182f618b', '管理员', 'admin', '管理员', null, '2018-12-21 18:03:39', 'admin', '2019-05-20 11:40:26'); -- ---------------------------- -- Table structure for sys_role_permission -- ---------------------------- DROP TABLE IF EXISTS `sys_role_permission`; CREATE TABLE `sys_role_permission` ( `id` varchar(32) NOT NULL, `role_id` varchar(32) DEFAULT NULL COMMENT '角色id', `permission_id` varchar(32) DEFAULT NULL COMMENT '权限id', `data_rule_ids` varchar(1000) DEFAULT NULL COMMENT '数据权限ids', `operate_date` datetime DEFAULT NULL COMMENT '操作时间', `operate_ip` varchar(20) DEFAULT NULL COMMENT '操作ip', PRIMARY KEY (`id`) USING BTREE, KEY `index_group_role_per_id` (`role_id`,`permission_id`) USING BTREE, KEY `index_group_role_id` (`role_id`) USING BTREE, KEY `index_group_per_id` (`permission_id`) USING BTREE, KEY `idx_srp_role_per_id` (`role_id`,`permission_id`) USING BTREE, KEY `idx_srp_role_id` (`role_id`) USING BTREE, KEY `idx_srp_permission_id` (`permission_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色权限表'; -- ---------------------------- -- Records of sys_role_permission -- ---------------------------- INSERT INTO `sys_role_permission` VALUES ('00b0748f04d3ea52c8cfa179c1c9d384', '52b0cf022ac4187b2a70dfa4f8b2d940', 'd7d6e2e4e2934f2c9385a623fd98c6f3', null, null, null); INSERT INTO `sys_role_permission` VALUES ('0c2d2db76ee3aa81a4fe0925b0f31365', 'f6817f48af4fb3af11b9e8bf182f618b', '024f1fd1283dc632458976463d8984e1', null, null, null); INSERT INTO `sys_role_permission` VALUES ('0c6b8facbb1cc874964c87a8cf01e4b1', 'f6817f48af4fb3af11b9e8bf182f618b', '841057b8a1bef8f6b4b20f9a618a7fa6', null, null, null); INSERT INTO `sys_role_permission` VALUES ('0c6e1075e422972083c3e854d9af7851', 'f6817f48af4fb3af11b9e8bf182f618b', '08e6b9dc3c04489c8e1ff2ce6f105aa4', null, null, null); INSERT INTO `sys_role_permission` VALUES ('0e1469997af2d3b97fff56a59ee29eeb', 'f6817f48af4fb3af11b9e8bf182f618b', 'e41b69c57a941a3bbcce45032fe57605', null, null, null); INSERT INTO `sys_role_permission` VALUES ('0f861cb988fdc639bb1ab943471f3a72', 'f6817f48af4fb3af11b9e8bf182f618b', '97c8629abc7848eccdb6d77c24bb3ebb', null, null, null); INSERT INTO `sys_role_permission` VALUES ('115a6673ae6c0816d3f60de221520274', '21c5a3187763729408b40afb0d0fdfa8', '63b551e81c5956d5c861593d366d8c57', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1185039870491439105', 'f6817f48af4fb3af11b9e8bf182f618b', '1174506953255182338', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1185039870529187841', 'f6817f48af4fb3af11b9e8bf182f618b', '1174590283938041857', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1197431682208206850', 'f6817f48af4fb3af11b9e8bf182f618b', '1192318987661234177', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1197795315916271617', 'f6817f48af4fb3af11b9e8bf182f618b', '109c78a583d4693ce2f16551b7786786', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1209423580355481602', 'f6817f48af4fb3af11b9e8bf182f618b', '190c2b43bec6a5f7a4194a85db67d96a', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1231590078632955905', 'f6817f48af4fb3af11b9e8bf182f618b', '1224641973866467330', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1231590078658121729', 'f6817f48af4fb3af11b9e8bf182f618b', '1209731624921534465', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1260928399955836929', 'f6817f48af4fb3af11b9e8bf182f618b', '1260928341675982849', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1269526122208522241', 'f6817f48af4fb3af11b9e8bf182f618b', '1267412134208319489', null, null, null); INSERT INTO `sys_role_permission` VALUES ('126ea9faebeec2b914d6d9bef957afb6', 'f6817f48af4fb3af11b9e8bf182f618b', 'f1cb187abf927c88b89470d08615f5ac', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1281494164924653569', 'f6817f48af4fb3af11b9e8bf182f618b', '1280350452934307841', null, '2020-07-10 15:43:13', '127.0.0.1'); INSERT INTO `sys_role_permission` VALUES ('1281494684632473602', 'f6817f48af4fb3af11b9e8bf182f618b', '1265162119913824258', null, '2020-07-10 15:45:16', '127.0.0.1'); INSERT INTO `sys_role_permission` VALUES ('17ead5b7d97ed365398ab20009a69ea3', '52b0cf022ac4187b2a70dfa4f8b2d940', 'e08cb190ef230d5d4f03824198773950', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1ac1688ef8456f384091a03d88a89ab1', '52b0cf022ac4187b2a70dfa4f8b2d940', '693ce69af3432bd00be13c3971a57961', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1e47db875601fd97723254046b5bba90', 'f6817f48af4fb3af11b9e8bf182f618b', 'baf16b7174bd821b6bab23fa9abb200d', null, null, null); INSERT INTO `sys_role_permission` VALUES ('1fe4d408b85f19618c15bcb768f0ec22', '1750a8fb3e6d90cb7957c02de1dc8e59', '9502685863ab87f0ad1134142788a385', null, null, null); INSERT INTO `sys_role_permission` VALUES ('248d288586c6ff3bd14381565df84163', '52b0cf022ac4187b2a70dfa4f8b2d940', '3f915b2769fc80648e92d04e84ca059d', null, null, null); INSERT INTO `sys_role_permission` VALUES ('25491ecbd5a9b34f09c8bc447a10ede1', 'f6817f48af4fb3af11b9e8bf182f618b', 'd07a2c87a451434c99ab06296727ec4f', null, null, null); INSERT INTO `sys_role_permission` VALUES ('27489816708b18859768dfed5945c405', 'a799c3b1b12dd3ed4bd046bfaef5fe6e', '9502685863ab87f0ad1134142788a385', null, null, null); INSERT INTO `sys_role_permission` VALUES ('2779cdea8367fff37db26a42c1a1f531', 'f6817f48af4fb3af11b9e8bf182f618b', 'fef097f3903caf3a3c3a6efa8de43fbb', null, null, null); INSERT INTO `sys_role_permission` VALUES ('296f9c75ca0e172ae5ce4c1022c996df', '646c628b2b8295fbdab2d34044de0354', '732d48f8e0abe99fe6a23d18a3171cd1', null, null, null); INSERT INTO `sys_role_permission` VALUES ('2ad37346c1b83ddeebc008f6987b2227', 'f6817f48af4fb3af11b9e8bf182f618b', '8d1ebd663688965f1fd86a2f0ead3416', null, null, null); INSERT INTO `sys_role_permission` VALUES ('2c462293cbb0eab7e8ae0a3600361b5f', '52b0cf022ac4187b2a70dfa4f8b2d940', '9502685863ab87f0ad1134142788a385', null, null, null); INSERT INTO `sys_role_permission` VALUES ('2fdaed22dfa4c8d4629e44ef81688c6a', '52b0cf022ac4187b2a70dfa4f8b2d940', 'aedbf679b5773c1f25e9f7b10111da73', null, null, null); INSERT INTO `sys_role_permission` VALUES ('35ac7cae648de39eb56213ca1b649713', '52b0cf022ac4187b2a70dfa4f8b2d940', 'b1cb0a3fedf7ed0e4653cb5a229837ee', null, null, null); INSERT INTO `sys_role_permission` VALUES ('38a2e55db0960262800576e34b3af44c', 'f6817f48af4fb3af11b9e8bf182f618b', '5c2f42277948043026b7a14692456828', null, null, null); INSERT INTO `sys_role_permission` VALUES ('3de2a60c7e42a521fecf6fcc5cb54978', 'f6817f48af4fb3af11b9e8bf182f618b', '2d83d62bd2544b8994c8f38cf17b0ddf', null, null, null); INSERT INTO `sys_role_permission` VALUES ('3e563751942b0879c88ca4de19757b50', '1750a8fb3e6d90cb7957c02de1dc8e59', '58857ff846e61794c69208e9d3a85466', null, null, null); INSERT INTO `sys_role_permission` VALUES ('412e2de37a35b3442d68db8dd2f3c190', '52b0cf022ac4187b2a70dfa4f8b2d940', 'f1cb187abf927c88b89470d08615f5ac', null, null, null); INSERT INTO `sys_role_permission` VALUES ('4204f91fb61911ba8ce40afa7c02369f', 'f6817f48af4fb3af11b9e8bf182f618b', '3f915b2769fc80648e92d04e84ca059d', null, null, null); INSERT INTO `sys_role_permission` VALUES ('45a358bb738782d1a0edbf7485e81459', 'f6817f48af4fb3af11b9e8bf182f618b', '0ac2ad938963b6c6d1af25477d5b8b51', null, null, null); INSERT INTO `sys_role_permission` VALUES ('4dab5a06acc8ef3297889872caa74747', 'f6817f48af4fb3af11b9e8bf182f618b', 'ffb423d25cc59dcd0532213c4a518261', null, null, null); INSERT INTO `sys_role_permission` VALUES ('4f254549d9498f06f4cc9b23f3e2c070', 'f6817f48af4fb3af11b9e8bf182f618b', '93d5cfb4448f11e9916698e7f462b4b6', null, null, null); INSERT INTO `sys_role_permission` VALUES ('4faad8ff93cb2b5607cd3d07c1b624ee', 'a799c3b1b12dd3ed4bd046bfaef5fe6e', '70b8f33da5f39de1981bf89cf6c99792', null, null, null); INSERT INTO `sys_role_permission` VALUES ('504e326de3f03562cdd186748b48a8c7', 'f6817f48af4fb3af11b9e8bf182f618b', '027aee69baee98a0ed2e01806e89c891', null, null, null); INSERT INTO `sys_role_permission` VALUES ('57c0b3a547b815ea3ec8e509b08948b3', '1750a8fb3e6d90cb7957c02de1dc8e59', '3f915b2769fc80648e92d04e84ca059d', null, null, null); INSERT INTO `sys_role_permission` VALUES ('5d230e6cd2935c4117f6cb9a7a749e39', 'f6817f48af4fb3af11b9e8bf182f618b', 'fc810a2267dd183e4ef7c71cc60f4670', null, null, null); INSERT INTO `sys_role_permission` VALUES ('5de6871fadb4fe1cdd28989da0126b07', 'f6817f48af4fb3af11b9e8bf182f618b', 'a400e4f4d54f79bf5ce160a3432231af', null, null, null); INSERT INTO `sys_role_permission` VALUES ('5fc194b709336d354640fe29fefd65a3', 'a799c3b1b12dd3ed4bd046bfaef5fe6e', '9ba60e626bf2882c31c488aba62b89f0', null, null, null); INSERT INTO `sys_role_permission` VALUES ('6daddafacd7eccb91309530c17c5855d', 'f6817f48af4fb3af11b9e8bf182f618b', 'edfa74d66e8ea63ea432c2910837b150', null, null, null); INSERT INTO `sys_role_permission` VALUES ('7413acf23b56c906aedb5a36fb75bd3a', 'f6817f48af4fb3af11b9e8bf182f618b', 'a4fc7b64b01a224da066bb16230f9c5a', null, null, null); INSERT INTO `sys_role_permission` VALUES ('75002588591820806', '16457350655250432', '5129710648430592', null, null, null); INSERT INTO `sys_role_permission` VALUES ('75002588604403712', '16457350655250432', '5129710648430593', null, null, null); INSERT INTO `sys_role_permission` VALUES ('75002588612792320', '16457350655250432', '40238597734928384', null, null, null); INSERT INTO `sys_role_permission` VALUES ('75002588625375232', '16457350655250432', '57009744761589760', null, null, null); INSERT INTO `sys_role_permission` VALUES ('75002588633763840', '16457350655250432', '16392452747300864', null, null, null); INSERT INTO `sys_role_permission` VALUES ('75002588637958144', '16457350655250432', '16392767785668608', null, null, null); INSERT INTO `sys_role_permission` VALUES ('75002588650541056', '16457350655250432', '16439068543946752', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277779875336192', '496138616573952', '5129710648430592', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780043108352', '496138616573952', '5129710648430593', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780055691264', '496138616573952', '15701400130424832', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780064079872', '496138616573952', '16678126574637056', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780072468480', '496138616573952', '15701915807518720', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780076662784', '496138616573952', '15708892205944832', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780085051392', '496138616573952', '16678447719911424', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780089245696', '496138616573952', '25014528525733888', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780097634304', '496138616573952', '56898976661639168', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780135383040', '496138616573952', '40238597734928384', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780139577344', '496138616573952', '45235621697949696', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780147965952', '496138616573952', '45235787867885568', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780156354560', '496138616573952', '45235939278065664', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780164743168', '496138616573952', '43117268627886080', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780168937472', '496138616573952', '45236734832676864', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780181520384', '496138616573952', '45237010692050944', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780189908992', '496138616573952', '45237170029465600', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780198297600', '496138616573952', '57009544286441472', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780206686208', '496138616573952', '57009744761589760', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780215074816', '496138616573952', '57009981228060672', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780219269120', '496138616573952', '56309618086776832', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780227657728', '496138616573952', '57212882168844288', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780236046336', '496138616573952', '61560041605435392', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780244434944', '496138616573952', '61560275261722624', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780257017856', '496138616573952', '61560480518377472', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780265406464', '496138616573952', '44986029924421632', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780324126720', '496138616573952', '45235228800716800', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780332515328', '496138616573952', '45069342940860416', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780340903937', '496138616573952', '5129710648430594', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780349292544', '496138616573952', '16687383932047360', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780357681152', '496138616573952', '16689632049631232', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780366069760', '496138616573952', '16689745006432256', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780370264064', '496138616573952', '16689883993083904', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780374458369', '496138616573952', '16690313745666048', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780387041280', '496138616573952', '5129710648430595', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780395429888', '496138616573952', '16694861252005888', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780403818496', '496138616573952', '16695107491205120', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780412207104', '496138616573952', '16695243126607872', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780420595712', '496138616573952', '75002207560273920', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780428984320', '496138616573952', '76215889006956544', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780433178624', '496138616573952', '76216071333351424', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780441567232', '496138616573952', '76216264070008832', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780449955840', '496138616573952', '76216459709124608', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780458344448', '496138616573952', '76216594207870976', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780466733056', '496138616573952', '76216702639017984', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780475121664', '496138616573952', '58480609315524608', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780483510272', '496138616573952', '61394706252173312', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780491898880', '496138616573952', '61417744146370560', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780496093184', '496138616573952', '76606430504816640', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780504481792', '496138616573952', '76914082455752704', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780508676097', '496138616573952', '76607201262702592', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780517064704', '496138616573952', '39915540965232640', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780525453312', '496138616573952', '41370251991977984', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780538036224', '496138616573952', '45264987354042368', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780546424832', '496138616573952', '45265487029866496', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780554813440', '496138616573952', '45265762415284224', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780559007744', '496138616573952', '45265886315024384', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780567396352', '496138616573952', '45266070000373760', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780571590656', '496138616573952', '41363147411427328', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780579979264', '496138616573952', '41363537456533504', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780588367872', '496138616573952', '41364927394353152', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780596756480', '496138616573952', '41371711400054784', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780605145088', '496138616573952', '41469219249852416', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780613533696', '496138616573952', '39916171171991552', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780621922304', '496138616573952', '39918482854252544', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780630310912', '496138616573952', '41373430515240960', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780718391296', '496138616573952', '41375330996326400', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780722585600', '496138616573952', '63741744973352960', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780730974208', '496138616573952', '42082442672082944', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780739362816', '496138616573952', '41376192166629376', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780747751424', '496138616573952', '41377034236071936', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780756140032', '496138616573952', '56911328312299520', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780764528640', '496138616573952', '41378916912336896', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780768722944', '496138616573952', '63482475359244288', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780772917249', '496138616573952', '64290663792906240', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780785500160', '496138616573952', '66790433014943744', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780789694464', '496138616573952', '42087054753927168', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780798083072', '496138616573952', '67027338952445952', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780806471680', '496138616573952', '67027909637836800', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780810665985', '496138616573952', '67042515441684480', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780823248896', '496138616573952', '67082402312228864', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780827443200', '496138616573952', '16392452747300864', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780835831808', '496138616573952', '16392767785668608', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780840026112', '496138616573952', '16438800255291392', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780844220417', '496138616573952', '16438962738434048', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277780852609024', '496138616573952', '16439068543946752', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860062040064', '496138616573953', '5129710648430592', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860070428672', '496138616573953', '5129710648430593', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860078817280', '496138616573953', '40238597734928384', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860091400192', '496138616573953', '43117268627886080', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860099788800', '496138616573953', '57009744761589760', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860112371712', '496138616573953', '56309618086776832', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860120760320', '496138616573953', '44986029924421632', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860129148928', '496138616573953', '5129710648430594', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860141731840', '496138616573953', '5129710648430595', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860150120448', '496138616573953', '75002207560273920', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860158509056', '496138616573953', '58480609315524608', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860162703360', '496138616573953', '76606430504816640', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860171091968', '496138616573953', '76914082455752704', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860179480576', '496138616573953', '76607201262702592', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860187869184', '496138616573953', '39915540965232640', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860196257792', '496138616573953', '41370251991977984', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860204646400', '496138616573953', '41363147411427328', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860208840704', '496138616573953', '41371711400054784', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860213035009', '496138616573953', '39916171171991552', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860221423616', '496138616573953', '39918482854252544', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860225617920', '496138616573953', '41373430515240960', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860234006528', '496138616573953', '41375330996326400', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860242395136', '496138616573953', '63741744973352960', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860250783744', '496138616573953', '42082442672082944', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860254978048', '496138616573953', '41376192166629376', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860263366656', '496138616573953', '41377034236071936', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860271755264', '496138616573953', '56911328312299520', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860313698304', '496138616573953', '41378916912336896', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860322086912', '496138616573953', '63482475359244288', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860326281216', '496138616573953', '64290663792906240', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860334669824', '496138616573953', '66790433014943744', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860343058432', '496138616573953', '42087054753927168', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860347252736', '496138616573953', '67027338952445952', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860351447041', '496138616573953', '67027909637836800', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860359835648', '496138616573953', '67042515441684480', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860364029952', '496138616573953', '67082402312228864', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860368224256', '496138616573953', '16392452747300864', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860372418560', '496138616573953', '16392767785668608', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860376612865', '496138616573953', '16438800255291392', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860385001472', '496138616573953', '16438962738434048', null, null, null); INSERT INTO `sys_role_permission` VALUES ('77277860389195776', '496138616573953', '16439068543946752', null, null, null); INSERT INTO `sys_role_permission` VALUES ('7a5d31ba48fe3fb1266bf186dc5f7ba7', '52b0cf022ac4187b2a70dfa4f8b2d940', '58857ff846e61794c69208e9d3a85466', null, null, null); INSERT INTO `sys_role_permission` VALUES ('7de42bdc0b8c5446b7d428c66a7abc12', '52b0cf022ac4187b2a70dfa4f8b2d940', '54dd5457a3190740005c1bfec55b1c34', null, null, null); INSERT INTO `sys_role_permission` VALUES ('7e19d90cec0dd87aaef351b9ff8f4902', '646c628b2b8295fbdab2d34044de0354', 'f9d3f4f27653a71c52faa9fb8070fbe7', null, null, null); INSERT INTO `sys_role_permission` VALUES ('84eac2f113c23737128fb099d1d1da89', 'f6817f48af4fb3af11b9e8bf182f618b', '03dc3d93261dda19fc86dd7ca486c6cf', null, null, null); INSERT INTO `sys_role_permission` VALUES ('86060e2867a5049d8a80d9fe5d8bc28b', 'f6817f48af4fb3af11b9e8bf182f618b', '765dd244f37b804e3d00f475fd56149b', null, null, null); INSERT INTO `sys_role_permission` VALUES ('8a60df8d8b4c9ee5fa63f48aeee3ec00', '1750a8fb3e6d90cb7957c02de1dc8e59', 'd7d6e2e4e2934f2c9385a623fd98c6f3', null, null, null); INSERT INTO `sys_role_permission` VALUES ('8b09925bdc194ab7f3559cd3a7ea0507', 'f6817f48af4fb3af11b9e8bf182f618b', 'ebb9d82ea16ad864071158e0c449d186', null, null, null); INSERT INTO `sys_role_permission` VALUES ('8ce1022dac4e558ff9694600515cf510', '1750a8fb3e6d90cb7957c02de1dc8e59', '08e6b9dc3c04489c8e1ff2ce6f105aa4', null, null, null); INSERT INTO `sys_role_permission` VALUES ('8e3dc1671abad4f3c83883b194d2e05a', 'f6817f48af4fb3af11b9e8bf182f618b', 'b1cb0a3fedf7ed0e4653cb5a229837ee', null, null, null); INSERT INTO `sys_role_permission` VALUES ('9264104cee9b10c96241d527b2d0346d', '1750a8fb3e6d90cb7957c02de1dc8e59', '54dd5457a3190740005c1bfec55b1c34', null, null, null); INSERT INTO `sys_role_permission` VALUES ('94911fef73a590f6824105ebf9b6cab3', 'f6817f48af4fb3af11b9e8bf182f618b', '8b3bff2eee6f1939147f5c68292a1642', null, null, null); INSERT INTO `sys_role_permission` VALUES ('980171fda43adfe24840959b1d048d4d', 'f6817f48af4fb3af11b9e8bf182f618b', 'd7d6e2e4e2934f2c9385a623fd98c6f3', null, null, null); INSERT INTO `sys_role_permission` VALUES ('9d8772c310b675ae43eacdbc6c7fa04a', 'a799c3b1b12dd3ed4bd046bfaef5fe6e', '1663f3faba244d16c94552f849627d84', null, null, null); INSERT INTO `sys_role_permission` VALUES ('9f8311ecccd44e079723098cf2ffe1cc', '1750a8fb3e6d90cb7957c02de1dc8e59', '693ce69af3432bd00be13c3971a57961', null, null, null); INSERT INTO `sys_role_permission` VALUES ('a034ed7c38c996b880d3e78f586fe0ae', 'f6817f48af4fb3af11b9e8bf182f618b', 'c89018ea6286e852b424466fd92a2ffc', null, null, null); INSERT INTO `sys_role_permission` VALUES ('acacce4417e5d7f96a9c3be2ded5b4be', 'f6817f48af4fb3af11b9e8bf182f618b', 'f9d3f4f27653a71c52faa9fb8070fbe7', null, null, null); INSERT INTO `sys_role_permission` VALUES ('ae1852fb349d8513eb3fdc173da3ee56', 'f6817f48af4fb3af11b9e8bf182f618b', '8d4683aacaa997ab86b966b464360338', null, null, null); INSERT INTO `sys_role_permission` VALUES ('aefc8c22e061171806e59cd222f6b7e1', '52b0cf022ac4187b2a70dfa4f8b2d940', 'e8af452d8948ea49d37c934f5100ae6a', null, null, null); INSERT INTO `sys_role_permission` VALUES ('af60ac8fafd807ed6b6b354613b9ccbc', 'f6817f48af4fb3af11b9e8bf182f618b', '58857ff846e61794c69208e9d3a85466', null, null, null); INSERT INTO `sys_role_permission` VALUES ('b128ebe78fa5abb54a3a82c6689bdca3', 'f6817f48af4fb3af11b9e8bf182f618b', 'aedbf679b5773c1f25e9f7b10111da73', null, null, null); INSERT INTO `sys_role_permission` VALUES ('bea2986432079d89203da888d99b3f16', 'f6817f48af4fb3af11b9e8bf182f618b', '54dd5457a3190740005c1bfec55b1c34', null, null, null); INSERT INTO `sys_role_permission` VALUES ('cf1feb1bf69eafc982295ad6c9c8d698', 'f6817f48af4fb3af11b9e8bf182f618b', 'a2b11669e98c5fe54a53c3e3c4f35d14', null, null, null); INSERT INTO `sys_role_permission` VALUES ('cf43895aef7fc684669483ab00ef2257', 'f6817f48af4fb3af11b9e8bf182f618b', '700b7f95165c46cc7a78bf227aa8fed3', null, null, null); INSERT INTO `sys_role_permission` VALUES ('d37ad568e26f46ed0feca227aa9c2ffa', 'f6817f48af4fb3af11b9e8bf182f618b', '9502685863ab87f0ad1134142788a385', null, null, null); INSERT INTO `sys_role_permission` VALUES ('d3fe195d59811531c05d31d8436f5c8b', '1750a8fb3e6d90cb7957c02de1dc8e59', 'e8af452d8948ea49d37c934f5100ae6a', null, null, null); INSERT INTO `sys_role_permission` VALUES ('dbc5dd836d45c5bc7bc94b22596ab956', 'f6817f48af4fb3af11b9e8bf182f618b', '1939e035e803a99ceecb6f5563570fb2', null, null, null); INSERT INTO `sys_role_permission` VALUES ('dc83bb13c0e8c930e79d28b2db26f01f', 'f6817f48af4fb3af11b9e8bf182f618b', '63b551e81c5956d5c861593d366d8c57', null, null, null); INSERT INTO `sys_role_permission` VALUES ('dc8fd3f79bd85bd832608b42167a1c71', 'f6817f48af4fb3af11b9e8bf182f618b', '91c23960fab49335831cf43d820b0a61', null, null, null); INSERT INTO `sys_role_permission` VALUES ('de82e89b8b60a3ea99be5348f565c240', 'f6817f48af4fb3af11b9e8bf182f618b', '56ca78fe0f22d815fabc793461af67b8', null, null, null); INSERT INTO `sys_role_permission` VALUES ('e3e922673f4289b18366bb51b6200f17', '52b0cf022ac4187b2a70dfa4f8b2d940', '45c966826eeff4c99b8f8ebfe74511fc', null, null, null); INSERT INTO `sys_role_permission` VALUES ('e7467726ee72235baaeb47df04a35e73', 'f6817f48af4fb3af11b9e8bf182f618b', 'e08cb190ef230d5d4f03824198773950', null, null, null); INSERT INTO `sys_role_permission` VALUES ('ec846a3f85fdb6813e515be71f11b331', 'f6817f48af4fb3af11b9e8bf182f618b', '732d48f8e0abe99fe6a23d18a3171cd1', null, null, null); INSERT INTO `sys_role_permission` VALUES ('ecdd72fe694e6bba9c1d9fc925ee79de', 'f6817f48af4fb3af11b9e8bf182f618b', '45c966826eeff4c99b8f8ebfe74511fc', null, null, null); INSERT INTO `sys_role_permission` VALUES ('f177acac0276329dc66af0c9ad30558a', 'f6817f48af4fb3af11b9e8bf182f618b', 'c2c356bf4ddd29975347a7047a062440', null, null, null); INSERT INTO `sys_role_permission` VALUES ('f17ab8ad1e71341140857ef4914ef297', '21c5a3187763729408b40afb0d0fdfa8', '732d48f8e0abe99fe6a23d18a3171cd1', null, null, null); INSERT INTO `sys_role_permission` VALUES ('fafe73c4448b977fe42880a6750c3ee8', 'f6817f48af4fb3af11b9e8bf182f618b', '9cb91b8851db0cf7b19d7ecc2a8193dd', null, null, null); -- ---------------------------- -- Table structure for sys_sms -- ---------------------------- DROP TABLE IF EXISTS `sys_sms`; CREATE TABLE `sys_sms` ( `id` varchar(32) NOT NULL COMMENT 'ID', `es_title` varchar(100) DEFAULT NULL COMMENT '消息标题', `es_type` varchar(1) DEFAULT NULL COMMENT '发送方式：1短信 2邮件 3微信', `es_receiver` varchar(50) DEFAULT NULL COMMENT '接收人', `es_param` varchar(1000) DEFAULT NULL COMMENT '发送所需参数Json格式', `es_content` longtext COMMENT '推送内容', `es_send_time` datetime DEFAULT NULL COMMENT '推送时间', `es_send_status` varchar(1) DEFAULT NULL COMMENT '推送状态 0未推送 1推送成功 2推送失败 -1失败不再发送', `es_send_num` int(11) DEFAULT NULL COMMENT '发送次数 超过5次不再发送', `es_result` varchar(255) DEFAULT NULL COMMENT '推送失败原因', `remark` varchar(500) DEFAULT NULL COMMENT '备注', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人登录名称', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人登录名称', `update_time` datetime DEFAULT NULL COMMENT '更新日期', PRIMARY KEY (`id`) USING BTREE, KEY `index_type` (`es_type`) USING BTREE, KEY `index_receiver` (`es_receiver`) USING BTREE, KEY `index_sendtime` (`es_send_time`) USING BTREE, KEY `index_status` (`es_send_status`) USING BTREE, KEY `idx_ss_es_type` (`es_type`) USING BTREE, KEY `idx_ss_es_receiver` (`es_receiver`) USING BTREE, KEY `idx_ss_es_send_time` (`es_send_time`) USING BTREE, KEY `idx_ss_es_send_status` (`es_send_status`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_sms -- ---------------------------- INSERT INTO `sys_sms` VALUES ('402880e74dc2f361014dc2f8411e0001', '消息推送测试333', '2', '411944058@qq.com', null, '张三你好，你的订单4028d881436d514601436d521ae80165已付款!', '2015-06-05 17:06:01', '3', null, null, '认证失败错误的用户名或者密码', 'admin', '2015-06-05 17:05:59', 'admin', '2015-11-19 22:30:39'); INSERT INTO `sys_sms` VALUES ('402880ea533647b00153364e74770001', '发个问候', '3', 'admin', null, '你好', '2016-03-02 00:00:00', '2', null, null, null, 'admin', '2016-03-02 15:50:24', 'admin', '2018-07-05 19:53:01'); INSERT INTO `sys_sms` VALUES ('402880ee5a17e711015a17f3188e013f', '消息推送测试333', '2', '411944058@qq.com', null, '张三你好，你的订单4028d881436d514601436d521ae80165已付款!', null, '2', null, null, null, 'admin', '2017-02-07 17:41:31', 'admin', '2017-03-10 11:37:05'); INSERT INTO `sys_sms` VALUES ('402880f05ab649b4015ab64b9cd80012', '消息推送测试333', '2', '411944058@qq.com', null, '张三你好，你的订单4028d881436d514601436d521ae80165已付款!', '2017-11-16 15:58:15', '3', null, null, null, 'admin', '2017-03-10 11:38:13', 'admin', '2017-07-31 17:24:54'); INSERT INTO `sys_sms` VALUES ('402880f05ab7b035015ab7c4462c0004', '消息推送测试333', '2', '411944058@qq.com', null, '张三你好，你的订单4028d881436d514601436d521ae80165已付款!', '2017-11-16 15:58:15', '3', null, null, null, 'admin', '2017-03-10 18:29:37', null, null); INSERT INTO `sys_sms` VALUES ('402881f3646a472b01646a4a5af00001', '催办：HR审批', '3', 'admin', null, 'admin，您好！\r\n请前待办任务办理事项！HR审批\r\n\r\n\r\n===========================\r\n此消息由系统发出', '2018-07-05 19:53:35', '2', null, null, null, 'admin', '2018-07-05 19:53:35', 'admin', '2018-07-07 13:45:24'); INSERT INTO `sys_sms` VALUES ('402881f3647da06c01647da43a940014', '催办：HR审批', '3', 'admin', null, 'admin，您好！\r\n请前待办任务办理事项！HR审批\r\n\r\n\r\n===========================\r\n此消息由系统发出', '2018-07-09 14:04:32', '2', null, null, null, 'admin', '2018-07-09 14:04:32', 'admin', '2018-07-09 18:51:30'); -- ---------------------------- -- Table structure for sys_sms_template -- ---------------------------- DROP TABLE IF EXISTS `sys_sms_template`; CREATE TABLE `sys_sms_template` ( `id` varchar(32) NOT NULL COMMENT '主键', `template_name` varchar(50) DEFAULT NULL COMMENT '模板标题', `template_code` varchar(32) NOT NULL COMMENT '模板CODE', `template_type` varchar(1) NOT NULL COMMENT '模板类型：1短信 2邮件 3微信', `template_content` varchar(1000) NOT NULL COMMENT '模板内容', `template_test_json` varchar(1000) DEFAULT NULL COMMENT '模板测试json', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人登录名称', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人登录名称', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniq_templatecode` (`template_code`) USING BTREE, UNIQUE KEY `uk_sst_template_code` (`template_code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_sms_template -- ---------------------------- INSERT INTO `sys_sms_template` VALUES ('1199606397416775681', '系统消息通知', 'sys_ts_note', '4', '

    系统通知

\n', null, '2019-11-27 16:30:27', 'admin', '2019-11-27 19:36:50', 'admin'); INSERT INTO `sys_sms_template` VALUES ('1199615897335095298', '流程催办', 'bpm_cuiban', '4', '

   流程催办提醒

\n', null, '2019-11-27 17:08:12', 'admin', '2019-11-27 19:36:45', 'admin'); INSERT INTO `sys_sms_template` VALUES ('1199648914107625473', '流程办理超时提醒', 'bpm_chaoshi_tip', '4', '

   流程办理超时提醒

\n', null, '2019-11-27 19:19:24', 'admin', '2019-11-27 19:36:37', 'admin'); INSERT INTO `sys_sms_template` VALUES ('4028608164691b000164693108140003', '催办：${taskName}', 'SYS001', '3', '${userName}，您好！\r\n请前待办任务办理事项！${taskName}\r\n\r\n\r\n===========================\r\n此消息由系统发出', '{\r\n\"taskName\":\"HR审批\",\r\n\"userName\":\"admin\"\r\n}', '2018-07-05 14:46:18', 'admin', '2018-07-05 18:31:34', 'admin'); -- ---------------------------- -- Table structure for sys_tenant -- ---------------------------- DROP TABLE IF EXISTS `sys_tenant`; CREATE TABLE `sys_tenant` ( `id` int(5) NOT NULL COMMENT '租户编码', `name` varchar(100) DEFAULT NULL COMMENT '租户名称', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(100) DEFAULT NULL COMMENT '创建人', `begin_date` datetime DEFAULT NULL COMMENT '开始时间', `end_date` datetime DEFAULT NULL COMMENT '结束时间', `status` int(1) DEFAULT NULL COMMENT '状态 1正常 0冻结', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='多租户信息表'; -- ---------------------------- -- Records of sys_tenant -- ---------------------------- INSERT INTO `sys_tenant` VALUES ('1', '北京租户001', '2020-07-10 15:43:32', 'admin', null, null, '1'); -- ---------------------------- -- Table structure for sys_third_account -- ---------------------------- DROP TABLE IF EXISTS `sys_third_account`; CREATE TABLE `sys_third_account` ( `id` varchar(32) NOT NULL COMMENT '编号', `sys_user_id` varchar(32) DEFAULT NULL COMMENT '第三方登录id', `third_type` varchar(255) DEFAULT NULL COMMENT '登录来源', `avatar` varchar(255) DEFAULT NULL COMMENT '头像', `status` tinyint(1) DEFAULT NULL COMMENT '状态(1-正常,2-冻结)', `del_flag` tinyint(1) DEFAULT NULL COMMENT '删除状态(0-正常,1-已删除)', `realname` varchar(100) DEFAULT NULL COMMENT '真实姓名', `third_user_uuid` varchar(100) DEFAULT NULL COMMENT '第三方账号', `third_user_id` varchar(100) DEFAULT NULL COMMENT '第三方app用户账号', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_third_account -- ---------------------------- -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` varchar(32) NOT NULL COMMENT '主键id', `username` varchar(100) DEFAULT NULL COMMENT '登录账号', `realname` varchar(100) DEFAULT NULL COMMENT '真实姓名', `password` varchar(255) DEFAULT NULL COMMENT '密码', `salt` varchar(45) DEFAULT NULL COMMENT 'md5密码盐', `avatar` varchar(255) DEFAULT NULL COMMENT '头像', `birthday` datetime DEFAULT NULL COMMENT '生日', `sex` tinyint(1) DEFAULT NULL COMMENT '性别(0-默认未知,1-男,2-女)', `email` varchar(45) DEFAULT NULL COMMENT '电子邮件', `phone` varchar(45) DEFAULT NULL COMMENT '电话', `org_code` varchar(64) DEFAULT NULL COMMENT '机构编码', `status` tinyint(1) DEFAULT NULL COMMENT '性别(1-正常,2-冻结)', `del_flag` tinyint(1) DEFAULT NULL COMMENT '删除状态(0-正常,1-已删除)', `third_id` varchar(100) DEFAULT NULL COMMENT '第三方登录的唯一标识', `third_type` varchar(100) DEFAULT NULL COMMENT '第三方类型', `activiti_sync` tinyint(1) DEFAULT NULL COMMENT '同步工作流引擎(1-同步,0-不同步)', `work_no` varchar(100) DEFAULT NULL COMMENT '工号，唯一键', `post` varchar(100) DEFAULT NULL COMMENT '职务，关联职务表', `telephone` varchar(45) DEFAULT NULL COMMENT '座机号', `create_by` varchar(32) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `user_identity` tinyint(1) DEFAULT NULL COMMENT '身份（1普通成员 2上级）', `depart_ids` longtext COMMENT '负责部门', `rel_tenant_ids` varchar(100) DEFAULT NULL COMMENT '多租户标识', `client_id` varchar(64) DEFAULT NULL COMMENT '设备ID', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `index_user_name` (`username`) USING BTREE, UNIQUE KEY `uniq_sys_user_work_no` (`work_no`) USING BTREE, UNIQUE KEY `uniq_sys_user_username` (`username`) USING BTREE, UNIQUE KEY `uniq_sys_user_phone` (`phone`) USING BTREE, UNIQUE KEY `uniq_sys_user_email` (`email`) USING BTREE, KEY `index_user_status` (`status`) USING BTREE, KEY `index_user_del_flag` (`del_flag`) USING BTREE, KEY `idx_su_username` (`username`) USING BTREE, KEY `idx_su_status` (`status`) USING BTREE, KEY `idx_su_del_flag` (`del_flag`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表'; -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES ('3d464b4ea0d2491aab8a7bde74c57e95', 'zhangsan', '张三', '02ea098224c7d0d2077c14b9a3a1ed16', 'x5xRdeKB', 'https://static.jeecg.com/temp/jmlogo_1606575041993.png', null, null, null, null, '财务部', '1', '0', null, null, '1', '0005', '总经理', null, 'admin', '2020-05-14 21:26:24', 'admin', '2020-09-09 14:42:51', '1', '', '', null); INSERT INTO `sys_user` VALUES ('a75d45a015c44384a04449ee80dc3503', 'jeecg', 'jeecg', '58a714412072f0b9', 'mIgiYJow', 'https://static.jeecg.com/temp/国炬软件logo_1606575029126.png', null, '1', null, null, 'A02A01', '1', '1', null, null, '1', '00002', 'devleader', null, 'admin', '2019-02-13 16:02:36', 'admin', '2020-11-26 15:16:05', '1', '', null, null); INSERT INTO `sys_user` VALUES ('e9ca23d68d884d4ebb19d07889727dae', 'admin', '管理员', 'cb362cfeefbf3d8d', 'RCGTeGiH', 'https://static.jeecg.com/temp/国炬软件logo_1606575029126.png', '2018-12-05 00:00:00', '1', 'jeecg@163.com', '18611111111', 'A01', '1', '0', null, null, '1', '00001', '总经理', null, null, '2019-06-21 17:54:10', 'admin', '2020-07-10 15:27:10', '2', 'c6d7cb4deeac411cb3384b1b31278596', '', null); INSERT INTO `sys_user` VALUES ('f0019fdebedb443c98dcb17d88222c38', 'zhagnxiao', '张小红', 'f898134e5e52ae11a2ffb2c3b57a4e90', 'go3jJ4zX', 'https://static.jeecg.com/temp/jmlogo_1606575041993.png', '2019-04-01 00:00:00', null, null, null, '研发部,财务部', '2', '1', null, null, '1', '00003', '', null, 'admin', '2020-10-01 19:34:10', 'admin', '2020-11-26 15:24:59', '1', '', '', null); -- ---------------------------- -- Table structure for sys_user_agent -- ---------------------------- DROP TABLE IF EXISTS `sys_user_agent`; CREATE TABLE `sys_user_agent` ( `id` varchar(32) NOT NULL COMMENT '序号', `user_name` varchar(100) DEFAULT NULL COMMENT '用户名', `agent_user_name` varchar(100) DEFAULT NULL COMMENT '代理人用户名', `start_time` datetime DEFAULT NULL COMMENT '代理开始时间', `end_time` datetime DEFAULT NULL COMMENT '代理结束时间', `status` varchar(2) DEFAULT NULL COMMENT '状态0无效1有效', `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门', `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniq_username` (`user_name`) USING BTREE, UNIQUE KEY `uk_sug_user_name` (`user_name`) USING BTREE, KEY `statux_index` (`status`) USING BTREE, KEY `begintime_index` (`start_time`) USING BTREE, KEY `endtime_index` (`end_time`) USING BTREE, KEY `idx_sug_status` (`status`) USING BTREE, KEY `idx_sug_start_time` (`start_time`) USING BTREE, KEY `idx_sug_end_time` (`end_time`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户代理人设置'; -- ---------------------------- -- Records of sys_user_agent -- ---------------------------- -- ---------------------------- -- Table structure for sys_user_depart -- ---------------------------- DROP TABLE IF EXISTS `sys_user_depart`; CREATE TABLE `sys_user_depart` ( `ID` varchar(32) NOT NULL COMMENT 'id', `user_id` varchar(32) DEFAULT NULL COMMENT '用户id', `dep_id` varchar(32) DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`ID`) USING BTREE, KEY `index_depart_groupk_userid` (`user_id`) USING BTREE, KEY `index_depart_groupkorgid` (`dep_id`) USING BTREE, KEY `index_depart_groupk_uidanddid` (`user_id`,`dep_id`) USING BTREE, KEY `idx_sud_user_id` (`user_id`) USING BTREE, KEY `idx_sud_dep_id` (`dep_id`) USING BTREE, KEY `idx_sud_user_dep_id` (`user_id`,`dep_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_user_depart -- ---------------------------- INSERT INTO `sys_user_depart` VALUES ('1281490128540393474', 'e9ca23d68d884d4ebb19d07889727dae', 'c6d7cb4deeac411cb3384b1b31278596'); INSERT INTO `sys_user_depart` VALUES ('1303623812558958593', 'f0019fdebedb443c98dcb17d88222c38', '57197590443c44f083d42ae24ef26a2c'); INSERT INTO `sys_user_depart` VALUES ('1303623812588318722', 'f0019fdebedb443c98dcb17d88222c38', '67fc001af12a4f9b8458005d3f19934a'); -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `id` varchar(32) NOT NULL COMMENT '主键id', `user_id` varchar(32) DEFAULT NULL COMMENT '用户id', `role_id` varchar(32) DEFAULT NULL COMMENT '角色id', PRIMARY KEY (`id`) USING BTREE, KEY `index2_groupuu_user_id` (`user_id`) USING BTREE, KEY `index2_groupuu_ole_id` (`role_id`) USING BTREE, KEY `index2_groupuu_useridandroleid` (`user_id`,`role_id`) USING BTREE, KEY `idx_sur_user_id` (`user_id`) USING BTREE, KEY `idx_sur_role_id` (`role_id`) USING BTREE, KEY `idx_sur_user_role_id` (`user_id`,`role_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户角色表'; -- ---------------------------- -- Records of sys_user_role -- ---------------------------- INSERT INTO `sys_user_role` VALUES ('b3ffd9311a1ca296c44e2409b547384f', '01b802058ea94b978a2c96f4807f6b48', '1'); INSERT INTO `sys_user_role` VALUES ('f2922a38ba24fb53749e45a0c459adb3', '439ae3e9bcf7418583fcd429cadb1d72', '1'); INSERT INTO `sys_user_role` VALUES ('ee45d0343ecec894b6886effc92cb0b7', '4d8fef4667574b24a9ccfedaf257810c', 'f6817f48af4fb3af11b9e8bf182f618b'); INSERT INTO `sys_user_role` VALUES ('1281490128242597889', 'e9ca23d68d884d4ebb19d07889727dae', 'f6817f48af4fb3af11b9e8bf182f618b');