mysql_init.sql

-- SYS_USER
DROP TABLE IF EXISTS MEE_ADMIN.SYS_USER;
CREATE TABLE mee_admin.sys_user (
  id int8 PRIMARY KEY  comment '表ID/用户ID',
  dept_id int8 comment '部门ID(保留字段暂不使用)',
  user_name varchar(50) NOT NULL comment '用户名称',
  nick_name varchar(50) comment '用户昵称',
  gender varchar(1) comment 'M.男 F.女',
  phone varchar(22) comment '手机号码',
  email varchar(50)  comment '用户email(可用于登陆)',
  password varchar(256) NOT NULL comment '用户密码',
  register_date timestamp(6) NOT NULL comment '用户注册时间',
  last_login_date timestamp(6) comment '最后登录时间',
  pwd_reset_time timestamp(6) comment '密码最后重置时间',
  status int2 NOT NULL comment '状态1.启用 0.禁用',
  del_flag int2 NOT NULL comment '删除标记1.正常 0.删除',
  create_time timestamp(6) NOT NULL comment '创建时间',
  create_by varchar(50) comment '创建人',
  update_time timestamp(6) NOT NULL comment '创建时间',
  update_by varchar(50) comment '创建人'
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统::用户信息表';

INSERT INTO mee_admin.sys_user VALUES (161456761080011000, NULL, 'N183006', '林仙儿', 'F', '18854783006', 'N183006@mee-admin.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161640203380011000, NULL, 'H183872', '赵敏', 'F', '13325203872', 'H183872@mee-admin.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161516867680011000, NULL, 'K454320', '阿飞', 'M', '13325204308', 'K454320@mee-admin.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '0', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161820545280011000, NULL, 'K454322', '任我行', 'M', '18854784320', 'K454322@mee-admin.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161405991780011001, NULL, 'L454325', '水笙', 'F', '13325204322', 'L454325@mee-admin.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '0', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161404345580011000, NULL, 'Z454394', '帝释天', 'M', '13657894325', 'Z454394@mee-admin.me', '3bf2612bf2f595481897c675cc7ae915', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161829606280011000, NULL, 'Z094395', '叶丽娜', 'F', '13325204394', 'Z094395@mee-admin.me', 'e040a1080a3a414a3aa29b6990d93b57', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161784598780011000, NULL, 'Z094401', '紫衣侯', 'M', '13325204395', 'Z094401@mee-admin.me', 'b1b35ecceb709edc2b136a2ee10d5c81', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '0', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161830720080011000, NULL, 'Z094604', '程灵素', 'F', '18854784401', 'Z094604@mee-admin.me', '8e72de6cc33e7a46e324a9c7db59472f', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161966714280011000, NULL, 'Z096123', '岳不群', 'F', '18854784604', 'Z096123@mee-admin.me', '57356f900f91b04ceebeb5aaf1d59fb8', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (166789588780011000, NULL, 'Y096554', '李寻欢', 'M', '13325206123', 'Y096554@mee-admin.me', '6b9d38e73066d0f607c32ec7aed617e5f2d8855207bea57ef14ec49f1e4d554b6bbac7479e77c9e6b58209422d731484d891c7a8efd6b81b93f8baf065c7a8b7', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-06-02 16:44:43.039', '0', '1', '2023-05-30 05:50:41.886', '1', '2023-06-02 16:44:43.039', '1');
INSERT INTO mee_admin.sys_user VALUES (160939731380011001, NULL, 'J182674', '成是非(程成)', 'F', '18854782674', '7002674@mee.me', 'e10adc3949ba59abbe56e057f20f883e', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (160445277280011000, NULL, 'J182990', '石破天 ', 'M', '13325202990', '7002990@mee.me', 'e10adc3949ba59abbe56e057f20f883e', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (160121139280019000, NULL, 'N183049', '谢烟客', 'M', '18854783049', '7003049@mee.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (160992643480011000, NULL, 'N183284', '薛采月', 'F', '13325203284', '7003284@mee.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161181835980011001, NULL, 'N183362', '袁紫霞', 'F', '13325203362', '7003362@mee.me', '3b433860e24e1d8b6b871c3f6b276f89', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (160992661280011003, NULL, 'H183826', '无名', 'M', '18755553826', '7003826@mee.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161110935880011000, NULL, 'J183965', '高老大', 'F', '13325203965', '7003965@mee.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161000690380011000, NULL, 'J183998', '血刀老祖', 'M', '13325203968', '7003968@mee.me', 'e10adc3949ba59abbe56e057f20f883e', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (160992649780011001, NULL, 'J284062', '诸葛一笑', 'M', '13657893998', '7003998@mee.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '0', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (160888911880011000, NULL, 'L284284', '方可可', 'F', '13325204153', '7004153@mee.me', 'e10adc3949ba59abbe56e057f20f883e', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (161232166980011000, NULL, 'K284308', '宋终', 'M', '18854784284', '7004284@mee.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '0', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (160914442780011000, NULL, 'H183642', '戚芳', 'F', '13325203642', '7003642@mail.cn', 'e10adc3949ba59abbe56e057f20f883e', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (164247652300801000, NULL, 'test', '蔡语袂', 'F', '18371086755', 'test@mee-admin.me', 'a7e2a48da5e0b8bb6da6d0c240765c1d0a184a2edb9a906a36a991bb3a3c96ff3692daf11338d7e598462cdc2fcc842aa9ad865a83fafc8818f521621063df17', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-06-09 18:14:05.367918', '1');
INSERT INTO mee_admin.sys_user VALUES (1, NULL, 'admin', '超级管理员', 'M', '13816349201', 'admin@mail.com', '039df5f4fe7f76ce0251bec67ceea39747284c1a68d6a0bb215a830a7eb47cfdb52e90aecaff84574180a6318a3f43e0333e594059de4783123380ce7cfc28d1', '2023-05-30 05:50:41.886', '2023-06-11 19:22:12.690766', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (162614362600801000, NULL, 'default', '第三梦', 'F', '136578984411', '136578984411@mail.com', 'ec9c1820c000201a45e41f06701fba0109177f91c705e327c30c463de2375acdb54ed7e3821423bc952be7ef19f2cae836abc79250f13d723c6d10d929002eb5', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '1', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');
INSERT INTO mee_admin.sys_user VALUES (2306111723021000, NULL, 'J7877', '诸葛丑', '', '', NULL, '1a734c08892dcabc31875ab016d31a1f93bd098bf68455c3b301d2d05c022cb22d8b0f44fc77500a055806e4661b9a1ce358b44105524b81d3f3b355da606b5d', '2023-06-11 17:23:02.359984', NULL, '2023-06-11 17:23:02.359984', '0', '0', '2023-06-11 17:23:02.359984', '1', '2023-06-11 17:23:02.359984', '1');
INSERT INTO mee_admin.sys_user VALUES (161000029780011000, NULL, 'L284153', '灭绝师太', 'F', '13325204062', '7004062@mee.me', 'df10ef8509dc176d733d59549e7dbfaf', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '2023-05-30 05:50:41.886', '0', '1', '2023-05-30 05:50:41.886', '1', '2023-05-30 05:50:41.886', '1');

-- T_OFFLINE_STORE
DROP TABLE IF EXISTS MEE_ADMIN.T_OFFLINE_STORE;
CREATE TABLE MEE_ADMIN.T_OFFLINE_STORE (
	ID INT8 PRIMARY KEY COMMENT '主键',
	OPEN_DATE DATE NOT NULL COMMENT '开店时间',
	CODE VARCHAR(50) NOT NULL COMMENT '编号',
	NAME VARCHAR(100) NOT NULL COMMENT '名称',
	NICK_NAME VARCHAR(100) COMMENT '店铺简称或昵称',
	ADDR VARCHAR(255) COMMENT '店铺地址',
	BRAND INT2  COMMENT '品牌(从字典获,)',
	STATUS INT2 NOT NULL COMMENT '状态 0,关闭 1.开启',
	DESCRIPTION varchar(255) COMMENT '备注',
    CREATE_BY    INT8 NOT NULL COMMENT '更新人',
    CREATE_TIME  TIMESTAMP(6) NOT NULL COMMENT '更新时间',
    UPDATE_BY    INT8 COMMENT '创建人',
    UPDATE_TIME  TIMESTAMP(6) COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='测试::线下店铺';

INSERT INTO mee_admin.t_offline_store (id,open_date,code,`name`,nick_name,addr,brand,status,description,create_by,create_time,update_by,update_time) VALUES
	 (230616151615801000,'2023-06-01','C001','西藏南路店','xznl','黄浦区西藏南路102号',1,1,'靠近地铁 集合店',1,'2023-06-16 15:16:15.986',1,'2023-06-16 15:16:15.986'),
	 (230616151747801001,'2018-05-10','C002','襄阳路店','xyl','徐汇区淮海中路1008号',3,1,' 旗舰店',1,'2023-06-16 15:17:47.000',1,'2023-06-16 15:18:28.758'),
	 (230616152253801002,'2019-09-09','C003','来福士广场店','lfs','长宁区长宁路1191号',NULL,1,'老店，待装修',1,'2023-06-16 15:22:53.598',1,'2023-06-16 15:22:53.598'),
	 (230616155255801000,'2023-06-01','C0034','测试01店','cs01','某某区某某路8号',NULL,0,'',1,'2023-06-16 15:52:55.706',1,'2023-06-16 15:52:55.706'),
	 (230616155255801011,'2020-01-01','C0035','测试02店','cs02','某某区某某路9号',NULL,0,'',1,'2023-06-16 15:55:03.712',1,'2023-06-16 15:55:03.712'),
	 (230616155255801012,'2020-02-01','C0036','测试03店','cs03','某某区某某路10号',NULL,0,'',1,'2023-06-16 15:55:03.712',1,'2023-06-16 15:55:03.712'),
	 (230616155255801013,'2020-03-01','C0037','测试04店','cs04','某某区某某路11号',NULL,0,'',1,'2023-06-16 15:55:03.712',1,'2023-06-16 15:55:03.712');


DROP TABLE  IF EXISTS mee_admin.sys_menu;
CREATE TABLE mee_admin.sys_menu (
  id INT8 primary key comment '菜单',
  pid INT8 comment '父ID',
  type INT2 NOT NULL comment '菜单类型(1.目录 2.菜单 3.按钮)',
  title VARCHAR(100) NOT NULL comment '菜单名称',
  icon VARCHAR(50) comment '菜单图标',
  path VARCHAR(100) NOT NULL default '' comment '路径(不含context-path 且于/开始)',
  target VARCHAR(100) comment '_blank.在新窗口中打开 _self.当前框架中打开 _parent.在父框架中打开 _top.在整个窗口中打开 _content.在右侧框架中打开',
  permission VARCHAR(80) comment '权限标识(菜单或按钮，具体用于权限管控的对象)',
  sub_count INT4 comment '子级个数(含隐藏的 show=1)',
  `show` INT2 NOT NULL comment '是否显示(0:否 1:是)',
  sort INT4 DEFAULT '1' comment '排序(1开始 越大越靠前)',
  create_time TIMESTAMP comment '父ID',
  create_by VARCHAR(64) comment '创建时间',
  update_time TIMESTAMP comment '创建人',
  UPDATE_BY VARCHAR(64) comment '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统::新菜单表';

INSERT INTO sys_menu (id,pid,`type`,title,icon,`path`,target,permission,sub_count,`show`,sort,create_time,create_by,update_time,UPDATE_BY) VALUES
	 (1,0,1,'主页',NULL,'',NULL,NULL,0,1,1,'2020-11-27 03:09:22','sys','2023-05-08 09:59:44','SYS'),
	 (2,0,1,'业务系统1',NULL,'',NULL,NULL,4,1,2,'2020-11-27 03:09:24','sys','2023-06-16 14:19:05','1'),
	 (4,0,1,'系统管理',NULL,'',NULL,NULL,2,1,5,'2020-11-27 03:09:30','sys','2023-05-24 17:08:59','1'),
	 (202,2306161419041075,1,'华南电商',NULL,'',NULL,NULL,9,1,2,'2020-11-27 03:28:44','sys','2023-05-24 17:51:42','1'),
	 (205,2306161419041075,1,'店铺日报',NULL,'',NULL,NULL,3,0,4,'2020-11-27 03:44:24','admin','2023-06-16 14:16:05','1'),
	 (207,2,1,'基础信息',NULL,'',NULL,NULL,5,1,NULL,'2020-11-27 03:45:34','admin','2023-06-16 14:33:10','1'),
	 (401,4,1,'系统配置',NULL,'',NULL,NULL,5,1,1,'2020-11-27 03:09:40','sys','2023-06-07 10:41:50','1'),
	 (402,4,1,'基础管理',NULL,'',NULL,NULL,5,1,2,'2020-11-27 03:09:37','sys','2024-06-20 15:58:08','1'),
	 (20201,202,2,'品牌一部',NULL,'/huanan/brand','_content',NULL,0,1,1,'2020-09-22 06:53:34','1',NULL,NULL),
	 (20202,202,2,'直营渠道',NULL,'/huanan/official','_content',NULL,0,1,2,'2020-09-22 06:53:53','1',NULL,NULL);
INSERT INTO sys_menu (id,pid,`type`,title,icon,`path`,target,permission,sub_count,`show`,sort,create_time,create_by,update_time,UPDATE_BY) VALUES
	 (20203,202,2,'产品研发',NULL,'/huanan/developer','_content',NULL,0,1,3,'2020-10-09 11:31:11','1',NULL,NULL),
	 (20501,205,2,'店铺01',NULL,'','/mall/01',NULL,0,1,1,'2020-11-27 03:44:24','admin',NULL,NULL),
	 (20502,205,2,'店铺02',NULL,'','/mall/02',NULL,0,1,2,'2020-11-27 03:44:24','admin',NULL,NULL),
	 (20503,205,2,'店铺03',NULL,'','/mall/03',NULL,0,1,3,'2021-04-02 14:54:08','admin',NULL,NULL),
	 (20701,207,2,'线下店铺',NULL,'/sv1/t_offline_store','_content','sv1:t_offline_store:list',5,1,2,'2020-11-27 03:45:34','admin','2023-06-16 16:45:04','1'),
	 (20702,207,2,'渠道',NULL,'/mallinfo/channel','_content','channel:list',0,1,3,'2020-11-27 03:45:34','admin',NULL,NULL),
	 (20703,207,2,'品牌',NULL,'/mallinfo/brand','_content','brand:list',0,1,1,'2020-11-27 03:45:34','admin',NULL,NULL),
	 (20704,207,2,'商品',NULL,'/mallinfo/goods','_content','goods:list',0,1,4,'2022-04-13 13:29:22','admin',NULL,NULL),
	 (40104,401,2,'角色&用户配置',NULL,'/sys/sys_role_user','_content','sys:sys_role_user:list',3,1,5,'2020-11-27 03:09:13','sys','2023-06-07 10:51:32','1'),
	 (40105,401,2,'角色&菜单配置',NULL,'/sys/sys_role_menu','_content','sys:sys_role_menu:list',3,1,6,'2020-11-27 08:04:41','sys','2023-06-07 10:54:10','1');
INSERT INTO sys_menu (id,pid,`type`,title,icon,`path`,target,permission,sub_count,`show`,sort,create_time,create_by,update_time,UPDATE_BY) VALUES
	 (40106,401,2,'菜单配置',NULL,'/sys/sys_menu','_content','sys:sys_menu:list',4,1,4,'2023-05-06 05:04:12','sys','2023-06-07 10:38:16','1'),
	 (40202,402,2,'日志配置',NULL,'/sys/sys_log','_content','sys:sys_log:list',3,1,3,'2020-11-27 03:09:53','sys','2023-06-07 11:23:18','1'),
	 (40204,402,2,'文件管理',NULL,'/sys/sys_file','_content','sys:sys_file:list',2,1,2,'2020-09-21 08:33:16','1','2023-06-07 11:20:45','1'),
	 (40205,402,2,'定时任务',NULL,'/sys/sys_shedlock_app','_content','sys:sys_shedlock:list',4,1,5,'2020-10-19 05:46:22','1','2024-06-20 15:58:08','1'),
	 (2305252217261000,402,2,'字典配置','','/sys/sys_dict','_content','sys:sys_dict:list',4,1,1,'2023-05-25 22:17:27','1','2023-06-07 11:18:30','1'),
	 (2305281726041000,401,2,'角色配置','','/sys/sys_role','_content','sys:sys_role:list',4,1,2,'2023-05-28 17:26:05','1','2023-06-07 10:57:07','1'),
	 (2305312137051000,401,2,'用户配置','','/sys/sys_user','_content','sys:sys_user:list',9,1,1,'2023-05-31 21:37:06','1','2023-06-11 19:08:17','1'),
	 (2306040014281000,402,2,'系统信息','','/sys/server_info','_content','sys:server_info:list',0,1,4,'2023-06-04 00:14:29','1','2023-06-07 11:24:11','1'),
	 (2306061317111000,0,1,'业务系统2','','https://www.csdn.net/','_content','',0,1,3,'2023-06-06 13:17:12','1','2023-06-06 13:29:09','1'),
	 (2306071035211000,40106,3,'查詢','','','','sys:sys_menu:list',0,0,1,'2023-06-07 10:35:21','1','2023-06-07 10:36:29','1');
INSERT INTO sys_menu (id,pid,`type`,title,icon,`path`,target,permission,sub_count,`show`,sort,create_time,create_by,update_time,UPDATE_BY) VALUES
	 (2306071036061001,40106,3,'新增','','','','sys:sys_menu:add',0,0,2,'2023-06-07 10:36:06','1','2023-06-07 10:36:46','1'),
	 (2306071037411002,40106,3,'更新','','','','sys:sys_menu:update',0,0,3,'2023-06-07 10:37:42','1','2023-06-07 10:37:42','1'),
	 (2306071038151003,40106,3,'刪除','','','','sys:sys_menu:delete',0,0,4,'2023-06-07 10:38:16','1','2023-06-07 10:38:16','1'),
	 (2306071050181034,40104,3,'查詢','','','','sys:sys_role_user:list',0,0,1,'2023-06-07 10:50:19','1','2023-06-07 10:50:19','1'),
	 (2306071050571035,40104,3,'添加','','','','sys:sys_role_user:add',0,0,2,'2023-06-07 10:50:58','1','2023-06-07 10:50:58','1'),
	 (2306071051311036,40104,3,'刪除','','','','sys:sys_role_user:delete',0,0,3,'2023-06-07 10:51:32','1','2023-06-07 10:51:32','1'),
	 (2306071052151037,40105,3,'查詢','','','','sys:sys_role_menu:list',0,0,1,'2023-06-07 10:52:15','1','2023-06-07 10:52:15','1'),
	 (2306071052451038,40105,3,'添加','','','','sys:sys_role_menu:add',0,0,2,'2023-06-07 10:52:45','1','2023-06-07 10:52:45','1'),
	 (2306071054101039,40105,3,'刪除','','','','sys:sys_role_menu:delete',0,0,3,'2023-06-07 10:54:10','1','2023-06-07 10:54:10','1'),
	 (2306071054451040,2305281726041000,3,'查詢','','','','sys:sys_role:list',0,0,1,'2023-06-07 10:54:45','1','2023-06-07 10:54:45','1');
INSERT INTO sys_menu (id,pid,`type`,title,icon,`path`,target,permission,sub_count,`show`,sort,create_time,create_by,update_time,UPDATE_BY) VALUES
	 (2306071055271041,2305281726041000,3,'添加','','','','sys:sys_role:add',0,0,2,'2023-06-07 10:55:27','1','2023-06-07 10:55:27','1'),
	 (2306071056141042,2305281726041000,3,'修改','','','','sys:sys_role:update',0,0,3,'2023-06-07 10:56:15','1','2023-06-07 10:56:15','1'),
	 (2306071057061043,2305281726041000,3,'刪除','','','','sys:sys_role:delete',0,0,4,'2023-06-07 10:57:07','1','2023-06-07 10:57:07','1'),
	 (2306071059211044,2305312137051000,3,'查詢','','','','sys:sys_user:list',0,0,1,'2023-06-07 10:59:22','1','2023-06-07 10:59:22','1'),
	 (2306071059581045,2305312137051000,3,'添加','','','','sys:sys_user:add',0,0,2,'2023-06-07 10:59:58','1','2023-06-07 10:59:58','1'),
	 (2306071100531046,2305312137051000,3,'更新','','','','sys:sys_user:update',0,0,3,'2023-06-07 11:00:53','1','2023-06-07 11:00:53','1'),
	 (2306071101221047,2305312137051000,3,'刪除','','','','sys:sys_user:delete',0,0,4,'2023-06-07 11:01:23','1','2023-06-07 11:01:23','1'),
	 (2306071102041048,2305312137051000,3,'狀態切換','','','','sys:sys_user:change_status',0,0,5,'2023-06-07 11:02:04','1','2023-06-07 11:02:04','1'),
	 (2306071103001049,2305312137051000,3,'解鎖操作','','','','sys:sys_user:unlock',0,0,6,'2023-06-07 11:03:01','1','2023-06-07 11:03:01','1'),
	 (2306071103581050,2305312137051000,3,'重置密碼','','','','sys:sys_user:reset_pwd',0,0,7,'2023-06-07 11:03:58','1','2023-06-07 11:03:58','1');
INSERT INTO sys_menu (id,pid,`type`,title,icon,`path`,target,permission,sub_count,`show`,sort,create_time,create_by,update_time,UPDATE_BY) VALUES
	 (2306071104431051,2305312137051000,3,'角色信息','','','','sys:sys_user:get_roles',0,0,8,'2023-06-07 11:04:44','1','2023-06-07 11:04:44','1'),
	 (2306071117001052,2305252217261000,3,'查詢','','','','sys:sys_dict:list',0,0,1,'2023-06-07 11:17:01','1','2023-06-07 11:17:01','1'),
	 (2306071117421053,2305252217261000,3,'添加','','','','sys:sys_dict:add',0,0,2,'2023-06-07 11:17:42','1','2023-06-07 11:17:42','1'),
	 (2306071118051054,2305252217261000,3,'更新','','','','sys:sys_dict:update',0,0,3,'2023-06-07 11:18:05','1','2023-06-07 11:18:05','1'),
	 (2306071118301055,2305252217261000,3,'刪除','','','','sys:sys_dict:delete',0,0,4,'2023-06-07 11:18:30','1','2023-06-07 11:18:30','1'),
	 (2306071120161056,40204,3,'查詢','','','','sys:sys_file:list',0,0,1,'2023-06-07 11:20:17','1','2023-06-07 11:20:17','1'),
	 (2306071120451057,40204,3,'刪除','','','','sys:sys_file:delete',0,0,2,'2023-06-07 11:20:45','1','2023-06-07 11:20:45','1'),
	 (2306071122221058,40202,3,'查詢','','','','sys:sys_log:list',0,0,1,'2023-06-07 11:22:22','1','2023-06-07 11:22:22','1'),
	 (2306071122481059,40202,3,'刪除','','','','sys:sys_log:delete',0,0,2,'2023-06-07 11:22:48','1','2023-06-07 11:22:48','1'),
	 (2306071123171060,40202,3,'導出','','','','sys:sys_log:export',0,0,3,'2023-06-07 11:23:18','1','2023-06-07 11:23:18','1');
INSERT INTO sys_menu (id,pid,`type`,title,icon,`path`,target,permission,sub_count,`show`,sort,create_time,create_by,update_time,UPDATE_BY) VALUES
	 (2306071125011061,40205,3,'查詢','','','','sys:sys_shedlock:list',0,0,1,'2023-06-07 11:25:02','1','2023-06-07 11:25:29','1'),
	 (2306071125291062,40205,3,'更新','','','','sys:sys_shedlock:update',0,0,2,'2023-06-07 11:25:29','1','2023-06-07 11:25:29','1'),
	 (2306071126091063,40205,3,'刪除','','','','sys:sys_shedlock:delete',0,0,3,'2023-06-07 11:26:09','1','2023-06-07 11:26:09','1'),
	 (2306111900571000,0,3,'开发者','','','','dev',0,0,9,'2023-06-11 19:00:58','1','2023-06-11 19:00:58','1'),
	 (2306111908171001,2305312137051000,3,'导出','','','','sys:sys_user:export',0,0,4,'2023-06-11 19:08:17','1','2023-06-11 19:08:17','1'),
	 (2306161410011000,20701,3,'查询','','','','sv1:t_offline_store:list',0,0,1,'2023-06-16 14:10:01','1','2023-06-16 14:10:01','1'),
	 (2306161411461001,20701,3,'新增','','','','sv1:t_offline_store:add',0,0,2,'2023-06-16 14:11:46','1','2023-06-16 14:11:46','1'),
	 (2306161412271002,20701,3,'修改','','','','sv1:t_offline_store:update',0,0,3,'2023-06-16 14:12:27','1','2023-06-16 14:12:27','1'),
	 (2306161413241003,20701,3,'删除','','','','sv1:t_offline_store:delete',0,0,4,'2023-06-16 14:13:25','1','2023-06-16 14:13:25','1'),
	 (2306161418111074,207,2,'其他','','https://cn.bing.com/','_content','',0,1,5,'2023-06-16 14:18:11','1','2023-06-16 14:33:10','1');
INSERT INTO sys_menu (id,pid,`type`,title,icon,`path`,target,permission,sub_count,`show`,sort,create_time,create_by,update_time,UPDATE_BY) VALUES
	 (2306161419041075,2,1,'地区','','','','',2,1,1,'2023-06-16 14:19:05','1','2023-06-16 14:19:05','1'),
	 (2306161645031000,20701,3,'导出','','','','sv1:t_offline_store:export',0,0,5,'2023-06-16 16:45:04','1','2023-06-16 16:45:04','1'),
	 (2406201557181000,40205,3,'添加','','','','sys:sys_shedlock:add',0,0,4,'2024-06-20 15:57:18','1','2024-06-20 15:57:18','1');
INSERT INTO sys_menu (id,pid,`type`,title,icon,`path`,target,"permission",sub_count,`show`,sort,create_time,create_by,update_time,update_by) VALUES
	 (2409141751571004,2409141749091000,3,'添加','','','','sys:qrtz_job:add',0,0,4,'2024-09-14 17:51:57.043','1','2024-09-14 17:51:57.043','1'),
	 (2409141749091000,402,2,'QUARTZ任务-任务&执行','','/sys/qrtz_job','_content','sys:qrtz_job:list',4,1,7,'2024-09-14 17:49:09.821','1','2024-09-14 17:51:57.043','1'),
	 (2409141103551001,2409141044001000,3,'查询','','','','sys:qrtz_app:list',0,0,1,'2024-09-14 11:03:55.218','1','2024-09-14 11:13:03.218','1'),
	 (2409141104551002,2409141044001000,3,'更新','','','','sys:qrtz_app:update',0,0,2,'2024-09-14 11:04:55.462','1','2024-09-14 11:13:22.618','1'),
	 (2409141105481003,2409141044001000,3,'删除','','','','sys:qrtz_app:delete',0,0,3,'2024-09-14 11:05:48.879','1','2024-09-14 11:13:38.601','1'),
	 (2409141106261004,2409141044001000,3,'添加','','','','sys:qrtz_app:add',0,0,4,'2024-09-14 11:06:26.046','1','2024-09-14 11:14:07.427','1'),
	 (2409141044001000,402,2,'QUARTZ任务-应用&节点','','/sys/qrtz_app','_content','sys:qrtz_app:list',4,1,6,'2024-09-14 10:44:00.422','1','2024-09-14 17:46:40.544','1'),
	 (2409141750251001,2409141749091000,3,'查询','','','','sys:qrtz_job:list',0,0,1,'2024-09-14 17:50:25.588','1','2024-09-14 17:50:25.588','1'),
	 (2409141750581002,2409141749091000,3,'更新','','','','sys:qrtz_job:update',0,0,2,'2024-09-14 17:50:58.505','1','2024-09-14 17:50:58.505','1'),
	 (2409141751291003,2409141749091000,3,'删除','','','','sys:qrtz_job:delete',0,0,3,'2024-09-14 17:51:29.459','1','2024-09-14 17:51:29.459','1');

DROP TABLE IF EXISTS mee_admin.sys_log;
CREATE TABLE mee_admin.sys_log (
  id numeric(24,0) primary key comment '日志表ID',
  log_type char(2)  NOT NULL comment '1.用户登录 ... 7.电八填报',
  log_title varchar(100) NOT NULL comment '日志标题',
  log_date timestamp(6) NOT NULL comment '日志时间',
  remote_address varchar(30)  comment '远程地址IP',
  log_content varchar(1024)  comment '日志内容'
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统::日志表';

INSERT INTO mee_admin.sys_log VALUES (2010201821080080100000, '1 ', 'admin', '2020-10-20 18:21:09', '10.0.132.37', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010201824420080100000, '1 ', 'admin', '2020-10-20 18:24:43', '10.0.132.37', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010201826330080100000, '1 ', 'admin', '2020-10-20 18:26:33', '10.0.132.37', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010201846270080100000, '1 ', 'admin', '2020-10-20 18:46:28', '10.0.132.37', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010210908060080100000, '1 ', 'admin', '2020-10-21 09:08:07', '127.0.0.1', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010211146200080100000, '1 ', 'admin', '2020-10-21 11:46:21', '127.0.0.1', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010230909400080100000, '1 ', 'admin', '2020-10-23 09:09:41', '127.0.0.1', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010231101180080100000, '1 ', 'admin', '2020-10-23 11:01:19', '127.0.0.1', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010231113540080100000, '1 ', 'admin', '2020-10-23 11:13:54', '127.0.0.1', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010231121420080100000, '1 ', 'admin', '2020-10-23 11:21:43', '127.0.0.1', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010231153350080100000, '1 ', 'admin', '2020-10-23 11:53:36', '127.0.0.1', 'user login record');
INSERT INTO mee_admin.sys_log VALUES (2010231325030080100001, '1 ', 'admin', '2020-10-23 13:25:04', '127.0.0.1', 'user login record');

-- 定时任务应用配置
DROP TABLE IF EXISTS SYS_SHEDLOCK_APP;
CREATE TABLE SYS_SHEDLOCK_APP (
  APPLICATION VARCHAR(64) NOT NULL COMMENT '当前实例应用',
  HOST_IP VARCHAR(32) not null COMMENT '当前实例应用所属IP',
  HOST_NAME varchar(100) COMMENT '创建机器',
  STATE CHAR(1) NOT NULL DEFAULT 1 COMMENT '状态 0.关闭 1.开启',
  LABEL VARCHAR(50) COMMENT '备注信息',
  UPDATE_TIME TIMESTAMP(3) NOT NULL COMMENT '创建及更新时间',
  PRIMARY KEY (APPLICATION,HOST_IP)
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COMMENT='集群分佈式鎖-应用配置';

-- 定时任务锁(new)
DROP TABLE IF EXISTS SYS_SHEDLOCK_JOB;
CREATE TABLE SYS_SHEDLOCK_JOB (
  APPLICATION VARCHAR(64) NOT NULL COMMENT '当前实例应用',
  NAME varchar(64) not null COMMENT '任務名稱',
  HOST_IP varchar(32) not null COMMENT '当前实例应用所属IP',
  LOCKED_AT timestamp(6) NOT NULL COMMENT '任務開始鎖定',
  LOCK_UNTIL timestamp(6) NOT NULL COMMENT '任務鎖定至',
  LOCKED_BY varchar(100) NOT NULL COMMENT '任務執行人',
  STATE CHAR(1) NOT NULL DEFAULT 1 COMMENT '0.close关闭 1.open开启(默认) 具体是否关闭取决于lock_until',
  DATA VARCHAR(256)  COMMENT '任务数据',
  LABEL varchar(100) COMMENT '任务备注',
  CALL_TYPE VARCHAR(20),
  CALL_VALUE VARCHAR(100),
  UPDATE_TIME TIMESTAMP(3) NOT NULL COMMENT '创建及更新时间',
  PRIMARY KEY (APPLICATION, NAME)
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COMMENT='集群分佈式鎖-任务配置';

DROP TABLE IF EXISTS mee_admin.sys_file;
CREATE TABLE mee_admin.sys_file (
  ID numeric(24,0) primary key comment '文件表ID',
  ORIGINAL_NAME varchar(100) NOT NULL comment '上传文件名称',
  NAME varchar(50) NOT NULL comment '保存文件名',
  FILE_PATH varchar(255) NOT NULL comment '文件保存路径',
  FILE_TYPE varchar(10) NOT NULL comment '文件类型',
  CATEGORY varchar(100) NOT NULL comment '文件分类(手动名称)',
  CREATE_TIME timestamp(6) NOT NULL comment '创建时间',
  CREATE_BY varchar(255)  comment '创建人'
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统::文件表';

INSERT INTO mee_admin.sys_file VALUES (2009221707508001100027, '14909_20190901.zip', '2009221707489000.zip', '/2020-09-22/2009221707509002.zip', '.zip', '2', '2020-09-22 09:07:51', '2');
INSERT INTO mee_admin.sys_file VALUES (2009221730358001100028, '14909_201910全月.zip', '2009221730329003.zip', '/2020-09-22/2009221730359005.zip', '.zip', '3', '2020-09-22 09:30:35', '2');
INSERT INTO mee_admin.sys_file VALUES (2009221748238001100007, '14909_201909全月.zip', '2009221748209000.zip', '/2020-09-22/2009221748239002.zip', '.zip', '3', '2020-09-22 09:48:24', '3');
INSERT INTO mee_admin.sys_file VALUES (2009221753208001100008, '14909_20190902.zip', '2009221753199003.zip', '/2020-09-22/2009221753209005.zip', '.zip', '2', '2020-09-22 09:53:20', '3');
INSERT INTO mee_admin.sys_file VALUES (2009221812290080100001, '14909_20200901.zip', '2009221812279000.zip', '/2020-09-22/2009221812299002.zip', '.zip', '2', '2020-09-22 10:12:29', '1');
INSERT INTO mee_admin.sys_file VALUES (2009221821368001100002, '14909_201908全月-.zip', '2009221821339000.zip', '/2020-09-22/2009221821369002.zip', '.zip', '3', '2020-09-22 10:21:36', '3');
INSERT INTO mee_admin.sys_file VALUES (2009221823148001100003, '14909_201910全月.zip', '2009221823119003.zip', '/2020-09-22/2009221823149005.zip', '.zip', '3', '2020-09-22 10:23:15', '3');
INSERT INTO mee_admin.sys_file VALUES (2009221823268001100004, '14909_201911月全月.zip', '2009221823249006.zip', '/2020-09-22/2009221823269008.zip', '.zip', '3', '2020-09-22 10:23:27', '3');
INSERT INTO mee_admin.sys_file VALUES (2009221823438001100005, '14909_201912月全月.zip', '2009221823419009.zip', '/2020-09-22/2009221823439011.zip', '.zip', '3', '2020-09-22 10:23:44', '3');
INSERT INTO mee_admin.sys_file VALUES (2009221912000080100001, '14909_202001全月.zip', '2009221911299000.zip', '/2020-09-22/2009221912009002.zip', '.zip', '3', '2020-09-22 11:12:01', '1');
INSERT INTO mee_admin.sys_file VALUES (2009222020218001100002, '14909_201901全月.zip', '2009222020189000.zip', '/2020-09-22/2009222020219002.zip', '.zip', '3', '2020-09-22 12:20:21', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222021018001100003, '14909_201902全月.zip', '2009222020599003.zip', '/2020-09-22/2009222021019005.zip', '.zip', '3', '2020-09-22 12:21:01', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222021138001100004, '14909_201903全月.zip', '2009222021119006.zip', '/2020-09-22/2009222021139008.zip', '.zip', '3', '2020-09-22 12:21:13', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222021348001100005, '14909_201904全月.zip', '2009222021329009.zip', '/2020-09-22/2009222021349011.zip', '.zip', '3', '2020-09-22 12:21:35', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222021448001100006, '14909_201905全月.zip', '2009222021429012.zip', '/2020-09-22/2009222021449014.zip', '.zip', '3', '2020-09-22 12:21:45', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222021548001100007, '14909_201906全月.zip', '2009222021529015.zip', '/2020-09-22/2009222021549017.zip', '.zip', '3', '2020-09-22 12:21:55', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222022058001100008, '14909_201907全月.zip', '2009222022029018.zip', '/2020-09-22/2009222022059020.zip', '.zip', '3', '2020-09-22 12:22:05', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222025338001100009, '14909_202001全月.zip', '2009222025319021.zip', '/2020-09-22/2009222025339023.zip', '.zip', '3', '2020-09-22 12:25:34', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222025430080100001, '14909_202004全月.zip', '2009222024599000.zip', '/2020-09-22/2009222025439002.zip', '.zip', '3', '2020-09-22 12:25:44', '1');
INSERT INTO mee_admin.sys_file VALUES (2009222025548001100010, '14909_202002全月.zip', '2009222025529024.zip', '/2020-09-22/2009222025549026.zip', '.zip', '3', '2020-09-22 12:25:55', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222026358001100011, '14909_202003全月.zip', '2009222026329027.zip', '/2020-09-22/2009222026359029.zip', '.zip', '3', '2020-09-22 12:26:35', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222039568001100012, '14909_202005全月.zip', '2009222039539030.zip', '/2020-09-22/2009222039569032.zip', '.zip', '3', '2020-09-22 12:39:57', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222040118001100013, '14909_202006全月.zip', '2009222040089033.zip', '/2020-09-22/2009222040119035.zip', '.zip', '3', '2020-09-22 12:40:11', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222040288001100014, '14909_202007全月.zip', '2009222040259036.zip', '/2020-09-22/2009222040289038.zip', '.zip', '3', '2020-09-22 12:40:28', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222040538001100015, '14909_202008全月.zip', '2009222040499039.zip', '/2020-09-22/2009222040539041.zip', '.zip', '3', '2020-09-22 12:40:53', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222044218001100016, '14909_20190903.zip', '2009222044209042.zip', '/2020-09-22/2009222044219044.zip', '.zip', '2', '2020-09-22 12:44:21', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222044488001100017, '14909_20200901.zip', '2009222044479045.zip', '/2020-09-22/2009222044489047.zip', '.zip', '2', '2020-09-22 12:44:48', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222045038001100018, '14909_20200902.zip', '2009222045039048.zip', '/2020-09-22/2009222045039050.zip', '.zip', '2', '2020-09-22 12:45:04', '3');
INSERT INTO mee_admin.sys_file VALUES (2009222045188001100019, '14909_20200903.zip', '2009222045179051.zip', '/2020-09-22/2009222045189053.zip', '.zip', '2', '2020-09-22 12:45:18', '3');
INSERT INTO mee_admin.sys_file VALUES (2009240917378001100030, '14909_20190904-.zip', '2009240917369054.zip', '/2020-09-24/2009240917379056.zip', '.zip', '2', '2020-09-24 01:17:37', '3');

DROP TABLE IF EXISTS mee_admin.sys_dict;
CREATE TABLE mee_admin.sys_dict (
	ID INT8 PRIMARY KEY comment '主键(字典ID)',
	`name` varchar(127) NOT NULL comment '字典名称',
	description varchar(255) NULL comment '描述',
	create_by int8 NULL comment '创建者',
	update_by int8 NULL comment '更新者',
	create_time timestamp(6) NOT NULL comment '创建日期',
	update_time timestamp(6) NULL comment '更新时间'
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统::数据字典';

INSERT INTO mee_admin.sys_dict (id,`name`,description,create_by,update_by,create_time,update_time) VALUES
	 (12,'sys_notice_type','通知类型',1,1,'2022-07-15 18:05:17.118','2022-07-15 18:05:17.118'),
	 (13,'sys_notice_status','通知状态',1,1,'2022-07-15 18:05:17.118','2022-07-15 18:05:17.118'),
	 (14,'sys_oper_type','操作类型',1,1,'2022-07-15 18:05:17.118','2022-07-15 18:05:17.118'),
	 (15,'sys_common_status','系统状态',1,1,'2022-07-15 18:05:17.118','2022-07-15 18:05:17.118'),
	 (4,'dept_status','部门状态',1,1,'2019-10-27 20:31:36.000',NULL),
	 (10,'sys_job_group','定时任务分组',1,1,'2022-07-15 18:05:17.118','2022-09-26 17:53:11.995'),
	 (2209291138521000,'online_status','在线状态',2,2,'2022-09-29 11:38:52.297','2022-09-29 11:38:52.297'),
	 (2209291139241001,'login_status','登录状态',2,2,'2022-09-29 11:39:24.550','2022-09-29 11:39:24.550'),
	 (2210091418521000,'scope_type','数据权限类型',1,1,'2022-10-09 14:18:52.027','2022-10-09 14:18:52.027'),
	 (6,'sys_user_sex','用户性别',2209221730491000,2209221730491000,'2022-07-15 18:05:17.118','2022-07-15 18:05:17.118');
INSERT INTO mee_admin.sys_dict (id,`name`,description,create_by,update_by,create_time,update_time) VALUES
	 (7,'sys_show_hide','菜单状态',2,2,'2022-07-15 18:05:17.118','2022-07-15 18:05:17.118'),
	 (8,'sys_normal_disable','系统开关',2110201751031000,2110201751031000,'2022-07-15 18:05:17.118','2022-07-15 18:05:17.118'),
	 (9,'sys_job_status','任务状态',1,1,'2022-07-15 18:05:17.118','2022-07-15 18:05:17.118'),
	 (11,'sys_yes_no','系统是否',2210091451531000,2210091451531000,'2022-07-15 18:05:17.118','2022-07-15 18:05:17.118'),
	 (5,'job_status','岗位状态',2209221730491000,2209221730491000,'2019-10-27 20:31:36.000',NULL),
	 (1,'sys_user_status','用户状态',2,2,'2019-10-27 20:31:36.000',NULL),
	 (2210131610061000,'shedlock_status','定时任务状态',2,2,'2022-10-13 16:10:06.416','2022-10-13 16:10:06.416'),
	 (2210141744331000,'user_enabled','用户状态',2,2,'2022-10-14 17:44:33.310','2022-10-14 17:44:33.310'),
	 (16,'sys_menu_show','菜单是否显示',1,1,'2023-05-15 14:01:56.769','2023-05-15 14:01:56.769'),
	 (18,'sys_menu_type','菜单类型',1,1,'2023-05-24 14:53:09.776','2023-05-24 14:53:09.776');
INSERT INTO mee_admin.sys_dict (id,`name`,description,create_by,update_by,create_time,update_time) VALUES
	 (17,'sys_menu_target','打开目标',1,1,'2023-05-24 14:48:24.801','2023-05-24 14:48:24.801'),
	 (2305261513591000,'test001_dict','测试字典001',1,1,'2023-05-26 15:13:59.886','2023-05-26 15:13:59.886'),
	 (2305301426501000,'sys_role_status','角色状态',1,1,'2023-05-30 14:26:50.674','2023-05-30 14:26:50.674'),
	 (2305311325251001,'sys_user_gender','用户性别',1,1,'2023-05-31 13:25:25.110','2023-05-31 13:25:25.110'),
	 (2305311326281004,'del_flag','删除标记',1,1,'2023-05-31 13:26:28.749','2023-05-31 13:26:28.749'),
	 (2306161442571000,'t_offline_store_brand','测试品牌',1,1,'2023-06-16 14:42:57.169','2023-06-16 14:42:57.169'),
	 (2306161451241004,'common_status','通用状态',1,1,'2023-06-16 14:51:24.190','2023-06-16 14:51:24.190');
INSERT INTO sys_menu (id,pid,"type",title,icon,"path",target,"permission",sub_count,"show",sort,create_time,create_by,update_time,update_by) VALUES
	 (40205,402,2,'定时任务',NULL,'/sys/sys_shedlock_app','_content','sys:sys_shedlock:list',4,1,5,'2020-10-19 05:46:22.000','1','2024-06-19 11:07:38.127','1'),
	 (2406191107381000,40205,3,'添加','','','','sys:sys_shedlock:add',0,0,4,'2024-06-19 11:07:38.127','1','2024-06-19 11:07:38.127','1');
INSERT INTO mee_admin.sys_dict (id,name,description,create_by,update_by,create_time,update_time) VALUES
	 (2406181655071000,'shedlock_state','定时任务状态',1,1,'2024-06-18 16:55:07.974','2024-06-18 16:55:07.974');

-- sys_dict_detail
DROP TABLE IF EXISTS mee_admin.sys_dict_detail;
CREATE TABLE MEE_ADMIN.SYS_DICT_DETAIL (
	ID INT8 PRIMARY KEY  comment '主键(字典项id)',
	dict_id int8 NOT NULL comment '字典id',
	`label` varchar(128) NOT NULL comment '字典标签',
	`value` varchar(127) NOT NULL comment '字典值',
	sort int4 NOT NULL default '1' comment '排序',
	create_by int8 NULL comment '创建者',
	update_by int8 NULL comment '更新者',
	create_time timestamp(6) NOT NULL comment '创建日期',
	update_time timestamp(6) NULL comment '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统::数据字典详情';

INSERT INTO mee_admin.sys_dict_detail  VALUES
	 (16,8,'正常','0',7,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (17,8,'停用','1',8,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (18,13,'正常','0',9,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (19,13,'关闭','1',10,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (20,12,'通知','1',11,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (21,12,'公告','2',12,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (31,7,'显示','0',22,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (32,7,'隐藏','1',23,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (33,6,'男','0',24,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (34,6,'女','1',25,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000');
INSERT INTO mee_admin.sys_dict_detail  VALUES
	 (35,6,'未知','2',26,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (36,11,'是','Y',27,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (37,11,'否','N',28,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (10,15,'成功','0',1,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (11,15,'失败','1',2,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (12,10,'默认','DEFAULT',3,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (13,10,'系统','SYSTEM',4,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (1,1,'激活(有效)','1',1,1,NULL,'2019-10-27 20:31:36.000',NULL),
	 (6,5,'停用','0',2,1,NULL,'2019-10-27 20:31:36.000',NULL),
	 (4,4,'停用','0',2,1,NULL,'2019-10-27 20:31:36.000',NULL);
INSERT INTO mee_admin.sys_dict_detail VALUES
	 (5,5,'启用','1',1,1,NULL,'2022-09-23 17:57:46.831','2022-09-23 17:57:46.831'),
	 (3,4,'启用','1',1,1,NULL,'2022-09-23 17:57:46.831','2022-09-23 17:57:46.831'),
	 (2,1,'禁用(无效)','0',2,1,NULL,'2022-09-23 17:57:46.831','2022-09-23 17:57:46.831'),
	 (2209291142151000,2209291139241001,'登录失败','0',1,2,2,'2022-09-29 11:42:15.962','2022-09-29 11:42:15.962'),
	 (2209291142371001,2209291139241001,'登录成功','1',2,2,2,'2022-09-29 11:42:37.027','2022-09-29 11:42:37.027'),
	 (2209291143111002,2209291139241001,'ignore','2',3,2,2,'2022-09-29 11:43:11.756','2022-09-29 11:43:11.756'),
	 (2209291146371003,2209291138521000,'在线','1',1,2,1,'2022-09-29 11:46:37.062','2022-09-29 14:19:01.286'),
	 (2209291146571004,2209291138521000,'离线','0',2,2,1,'2022-09-29 11:46:57.793','2022-09-29 14:19:06.205'),
	 (2210091419301001,2210091418521000,'全部','1',1,1,1,'2022-10-09 14:19:30.040','2022-10-09 14:19:30.040'),
	 (2210091419411002,2210091418521000,'仅所在部门','2',2,1,1,'2022-10-09 14:19:41.370','2022-10-09 14:19:41.370');
INSERT INTO mee_admin.sys_dict_detail  VALUES
	 (2210091420051003,2210091418521000,'所在部门及所有子级','3',3,1,1,'2022-10-09 14:20:05.508','2022-10-09 14:20:05.508'),
	 (2210091420151004,2210091418521000,'本人数据','4',4,1,1,'2022-10-09 14:20:15.559','2022-10-09 14:20:15.559'),
	 (2210091420241005,2210091418521000,'自定义','5',5,1,1,'2022-10-09 14:20:24.318','2022-10-09 14:20:24.318'),
	 (2210131610431002,2210131610061000,'关闭','0',1,2,2,'2022-10-13 16:10:43.034','2022-10-13 16:13:09.086'),
	 (2210131610291001,2210131610061000,'开启','1',2,2,2,'2022-10-13 16:10:29.573','2022-10-13 16:13:16.536'),
	 (2210141745051001,2210141744331000,'禁用','0',1,2,2,'2022-10-14 17:45:05.468','2022-10-14 17:45:05.468'),
	 (2210141745161002,2210141744331000,'启用','1',2,2,2,'2022-10-14 17:45:16.992','2022-10-14 17:46:19.874'),
	 (14,9,'正常','0',1,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (15,9,'暂停','1',2,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (22,14,'新增','1',1,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000');
INSERT INTO mee_admin.sys_dict_detail VALUES
	 (23,14,'修改','2',2,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (24,14,'删除','3',3,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (25,14,'授权','4',4,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (26,14,'导出','5',5,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (27,14,'导入','6',6,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (28,14,'强退','7',7,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (29,14,'生成代码','8',8,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (30,14,'清空数据','9',9,1,NULL,'2022-07-15 18:11:00.000','2022-07-15 18:11:00.000'),
	 (38,17,'在新窗口中打开','_blank',5,1,NULL,'2023-05-24 14:48:16.214','2023-05-24 14:48:16.214'),
	 (39,17,'当前框架中打开','_self',4,1,NULL,'2023-05-24 14:48:16.214','2023-05-24 14:48:16.214');
INSERT INTO mee_admin.sys_dict_detail VALUES
	 (40,17,'在父框架中打开','_parent',3,1,NULL,'2023-05-24 14:48:16.214','2023-05-24 14:48:16.214'),
	 (41,17,'在整个窗口中打开','_top',2,1,NULL,'2023-05-24 14:48:16.214','2023-05-24 14:48:16.214'),
	 (42,17,'在右侧框架中打开','_content',1,1,NULL,'2023-05-24 14:48:16.214','2023-05-24 14:48:16.214'),
	 (43,18,'目录','1',1,1,NULL,'2023-05-24 14:53:09.778','2023-05-24 14:53:09.778'),
	 (44,18,'菜单','2',2,1,NULL,'2023-05-24 14:53:09.778','2023-05-24 14:53:09.778'),
	 (45,18,'按钮','3',3,1,NULL,'2023-05-24 14:53:09.778','2023-05-24 14:53:09.778'),
	 (46,16,'否','0',1,1,NULL,'2023-05-24 15:00:45.854','2023-05-24 15:00:45.854'),
	 (47,16,'是','1',1,1,NULL,'2023-05-24 15:00:45.854','2023-05-24 15:00:45.854'),
	 (2305301427041001,2305301426501000,'开启','1',2,1,1,'2023-05-30 14:27:04.716','2023-05-30 14:27:04.716'),
	 (2305301427141002,2305301426501000,'关闭','0',1,1,1,'2023-05-30 14:27:14.254','2023-05-30 14:27:14.254');
INSERT INTO mee_admin.sys_dict_detail  VALUES
	 (2305311325501003,2305311325251001,'男','M',2,1,1,'2023-05-31 13:25:50.158','2023-05-31 13:25:50.158'),
	 (2305311325351002,2305311325251001,'女','F',1,1,1,'2023-05-31 13:25:35.846','2023-05-31 13:26:01.837'),
	 (2305311327011006,2305311326281004,'正常','1',2,1,1,'2023-05-31 13:27:01.580','2023-05-31 13:27:01.580'),
	 (2305311326421005,2305311326281004,'已删除','0',1,1,1,'2023-05-31 13:26:42.693','2023-05-31 13:27:09.413'),
	 (2306161453401006,2306161451241004,'禁用','0',2,1,1,'2023-06-16 14:53:40.879','2023-06-16 14:53:40.879'),
	 (2306161443211001,2306161442571000,'品牌1','1',1,1,1,'2023-06-16 14:43:21.047','2023-06-16 15:01:45.303'),
	 (2306161443381002,2306161442571000,'品牌2','2',2,1,1,'2023-06-16 14:43:38.238','2023-06-16 15:01:49.620'),
	 (2306161444081003,2306161442571000,'品牌3','3',3,1,1,'2023-06-16 14:44:08.533','2023-06-16 15:01:53.205'),
	 (2306161451401005,2306161451241004,'启用','1',1,1,1,'2023-06-16 14:51:40.402','2023-06-16 16:05:12.194');
INSERT INTO sys_dict_detail (id,dict_id,label,value,sort,create_by,update_by,create_time,update_time) VALUES
	 (2406181700341001,2406181655071000,'关闭','0',2,1,1,'2024-06-18 17:00:34.902','2024-06-18 17:00:34.902'),
	 (2406181700171000,2406181655071000,'开启','1',1,1,1,'2024-06-18 17:00:17.200','2024-06-18 17:00:17.200');

-- 角色相关
DROP TABLE IF EXISTS mee_admin.sys_role;
CREATE TABLE mee_admin.sys_role (
  id int8 primary key  comment '角色id',
  name varchar(80)  NOT NULL comment '角色名称(en)',
  description varchar(128) comment '角色描述',
  status int4 NOT NULL comment '角色状态 0.关闭 1.开启',
  create_by int8 comment '创建人',
  create_time timestamp comment '创建时间',
  update_by int8 comment '更新人',
  update_time timestamp comment '更新时间'
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统::角色';

INSERT INTO mee_admin.sys_role (id,name,description,status,create_by,create_time,update_by,update_time) VALUES
	 (2201181119100002,'ROLE_test','测试用户组',1,1,'2023-05-28 01:03:04.277',1,'2023-05-28 01:03:04.277'),
	 (2205101711100002,'ROLE_admin','管理员组',1,1,'2023-05-28 01:03:04.277',1,'2023-05-28 01:03:04.277'),
	 (2305301619401000,'ROLE_demo1','demo角色',0,1,'2023-05-30 16:19:40.568',1,'2023-05-30 16:19:40.568'),
	 (2101071443100107,'ROLE_brand2_report','品牌二日报组',1,1,'2023-05-28 01:03:04.277',1,'2023-06-07 15:07:50.100'),
	 (2203251821100455,'ROLE_it','技术支持部',1,1,'2023-05-28 01:03:04.277',1,'2023-06-07 15:09:47.381'),
	 (2211081625100056,'ROLE_leader','主管组',1,1,'2023-05-28 01:03:04.277',1,'2023-05-28 01:03:04.277'),
	 (2107191139100327,'ROLE_bi','BI报表组',1,1,'2023-05-28 01:03:04.277',1,'2023-05-28 01:03:04.277'),
	 (2203251821100307,'ROLE_dev','开发组',1,1,'2023-05-28 01:03:04.277',1,'2023-05-28 01:03:04.277'),
	 (2104080940104802,'ROLE_jf_center','运营组',1,1,'2023-05-28 01:03:04.277',1,'2023-06-07 15:06:01.517'),
	 (2105121352100002,'ROLE_brand1','华南一部角色',1,1,'2023-05-28 01:03:04.277',1,'2023-06-07 15:07:15.404');
INSERT INTO mee_admin.sys_role (id,name,description,status,create_by,create_time,update_by,update_time) VALUES
	 (2104131519103477,'ROLE_brand3','江南三日报',1,1,'2023-05-28 01:03:04.277',1,'2023-06-07 15:08:14.543'),
	 (2101130936104294,'ROLE_brand2_tk','抖二音组',1,1,'2023-05-28 01:03:04.277',1,'2023-06-07 15:09:07.733');

CREATE TABLE mee_admin.sys_role_menu(
  id int8 primary key    comment '主键',
  menu_id int8 NOT NULL comment '菜单ID',
  role_id int8 NOT NULL comment '角色ID',
  create_by int8 comment '创建人',
  create_time timestamp comment '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统::角色菜单关联';

INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (2406201602271001,1,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271002,2,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271003,207,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271004,20703,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271005,20701,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271006,20702,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271007,20704,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271008,202,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271009,20201,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271010,20202,2205101711100002,1,'2024-06-20 16:02:27');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (2406201602271011,20203,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271012,205,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271013,20501,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271014,20502,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271015,20503,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271016,2306061317111000,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271017,4,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271018,401,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271019,2305312137051000,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271020,2306071059211044,2205101711100002,1,'2024-06-20 16:02:27');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (2406201602271021,2306071059581045,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271022,2306071100531046,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271023,2306071101221047,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271024,2306071102041048,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271025,2306071103001049,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271026,2306071103581050,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271027,2306071104431051,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271028,2305281726041000,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271029,2306071054451040,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271030,2306071055271041,2205101711100002,1,'2024-06-20 16:02:27');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (2406201602271031,2306071056141042,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271032,2306071057061043,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271033,40106,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271034,2306071035211000,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271035,2306071036061001,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271036,2306071037411002,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271037,2306071038151003,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271038,40104,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271039,2306071050181034,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271040,2306071050571035,2205101711100002,1,'2024-06-20 16:02:27');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (2406201602271041,2306071051311036,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271042,40105,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271043,2306071052151037,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271044,2306071052451038,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271045,2306071054101039,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271046,402,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271047,2305252217261000,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271048,2306071117001052,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271049,2306071117421053,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271050,2306071118051054,2205101711100002,1,'2024-06-20 16:02:27');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (2406201602271051,2306071118301055,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271052,40204,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271053,2306071120161056,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271054,2306071120451057,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271055,40202,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271056,2306071122221058,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271057,2306071122481059,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271058,2306071123171060,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271059,2306040014281000,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271060,40205,2205101711100002,1,'2024-06-20 16:02:27');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (2406201602271061,2306071125011061,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271062,2306071125291062,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271063,2306071126091063,2205101711100002,1,'2024-06-20 16:02:27'),
	 (2406201602271064,2406201557181000,2205101711100002,1,'2024-06-20 16:02:27'),
	 (210408094001104805,1,2104080940104802,1,'2023-05-28 01:21:48'),
	 (210408094001104806,2,2104080940104802,1,'2023-05-28 01:21:48'),
	 (210408094001104807,205,2104080940104802,1,'2023-05-28 01:21:48'),
	 (210408094001104808,20501,2104080940104802,1,'2023-05-28 01:21:48'),
	 (210408094001104809,20502,2104080940104802,1,'2023-05-28 01:21:48'),
	 (210408094001104810,4,2104080940104802,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (210408094001104811,402,2104080940104802,1,'2023-05-28 01:21:48'),
	 (210408094001104812,40204,2104080940104802,1,'2023-05-28 01:21:48'),
	 (210408094001104813,20503,2104080940104802,1,'2023-05-28 01:21:48'),
	 (210408094001104814,3,2104080940104802,1,'2023-05-28 01:21:48'),
	 (210408094001104815,301,2104080940104802,1,'2023-05-28 01:21:48'),
	 (210408094001104816,30109,2104080940104802,1,'2023-05-28 01:21:48'),
	 (220118111980100003,402,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100004,40202,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100005,20105,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100006,20104,2201181119100002,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220118111980100007,20103,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100008,20102,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100009,20101,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100010,201,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100011,2,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100012,1,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100013,3,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100014,40204,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100015,202,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100016,20201,2201181119100002,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220118111980100017,20202,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100018,203,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100019,20301,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100020,20302,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100021,301,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100022,30101,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100023,30102,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100024,30103,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100025,302,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100026,303,2201181119100002,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220118111980100027,4,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100028,20203,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100029,40101,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100030,401,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100031,40102,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100032,40201,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100033,20106,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100034,20107,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100035,20108,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100036,40205,2201181119100002,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220118111980100037,20109,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100038,20110,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100039,20111,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100040,6,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100041,20208,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100042,20209,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100043,20303,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100044,20501,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100045,20503,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100046,205,2201181119100002,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220118111980100047,20502,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100048,207,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100049,20702,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100050,20703,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100051,20701,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100053,601,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100054,602,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220118111980100055,603,2201181119100002,1,'2023-05-28 01:21:48'),
	 (220325182180100310,20703,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100311,20702,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100312,20701,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100313,207,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100314,20505,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100315,20504,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100316,20503,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100317,20502,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100318,20501,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100319,205,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100320,20307,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100321,20305,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100322,20304,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100323,20303,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100324,20302,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100325,20301,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100326,203,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100327,20306,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100328,20204,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100329,20111,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100330,20110,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100331,20109,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100332,20108,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100333,20107,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100334,20106,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100335,20105,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100336,20104,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100337,20103,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100338,20102,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100339,20101,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100340,201,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100341,40104,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100342,40103,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100344,1,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100345,301,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100346,3,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100347,30101,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100348,30102,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100349,302,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100350,303,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100351,3010101,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100352,3010102,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100353,3010104,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100354,3010103,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100355,3010105,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100356,3010201,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100357,3010202,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100358,3010204,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100359,3010205,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100360,3010203,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100361,3010206,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100362,3010208,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100363,3010207,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100364,3010209,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100365,3010210,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100366,3010212,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100367,30103,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100368,3010301,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100369,3010302,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100370,3010303,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100371,3010304,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100372,3010305,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100373,3010306,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100374,3010307,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100375,3010313,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100376,30104,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100377,30105,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100378,3010404,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100379,3010401,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100380,3010402,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100381,3010403,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100382,3010501,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100383,3010503,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100384,3010504,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100385,30106,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100386,3010601,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100387,3010602,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100388,3010603,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100389,30202,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100390,30201,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100391,60401,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100392,60402,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100393,60404,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100394,60403,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100395,60405,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100396,40204,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100397,3010213,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100398,3010701,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100399,30107,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100400,3010702,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100401,30108,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100402,3010801,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100403,3010802,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100404,3010804,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100405,3010806,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100406,3010807,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100407,3010805,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100408,3010803,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100409,3010800,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100410,604,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100411,6,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100412,402,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100413,4,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100414,2,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100415,202,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100416,20201,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100417,20202,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100418,20203,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100419,20208,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100420,20209,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100421,210,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100422,21001,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100423,21002,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100424,21003,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100425,603,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100426,602,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100427,60101,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100428,601,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100429,40205,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100430,40202,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100431,40201,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100432,40105,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100433,401,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100434,30109,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100435,2130108,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100436,2130107,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100437,2130106,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100438,2130105,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100439,2130103,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100440,2130102,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100441,2130101,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100442,21301,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100443,213,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100444,2130104,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100445,20205,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100446,30110,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100447,3011000,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100448,30111,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100449,20308,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100450,20210,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100451,20704,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100452,20705,2203251821100307,1,'2023-05-28 01:21:48');
INSERT INTO sys_role_menu (id,menu_id,role_id,create_by,create_time) VALUES
	 (220325182180100453,30112,2203251821100307,1,'2023-05-28 01:21:48'),
	 (220325182180100454,30113,2203251821100307,1,'2023-05-28 01:21:48');


CREATE TABLE mee_admin.sys_role_user (
  id int8 primary key comment '主键',
  user_id int8 NOT NULL comment '用户ID',
  role_id int8 NOT NULL comment '角色ID',
  create_by int8 comment '创建人',
  create_time timestamp not null comment '创建时间'
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统::角色用户';

INSERT INTO mee_admin.sys_role_user (id,user_id,role_id,create_by,create_time) VALUES
	 (201127152080100001,160369509280019000,2010261453100047,1,'2023-05-28 01:35:54.978'),
	 (201127152880100001,160369509280019000,2011271522100068,1,'2023-05-28 01:35:54.978'),
	 (210107144301100108,161000029780011000,2101071443100107,1,'2023-05-28 01:35:54.978'),
	 (210113093601104295,160888911880011000,2101130936104294,1,'2023-05-28 01:35:54.978'),
	 (210719113980100328,160281680680019000,2107191139100327,1,'2023-05-28 01:35:54.978'),
	 (210719113980100329,160939731380011001,2107191139100327,1,'2023-05-28 01:35:54.978'),
	 (210719113980100330,161603004480011000,2107191139100327,1,'2023-05-28 01:35:54.978'),
	 (210719113980100331,161966714280011000,2107191139100327,1,'2023-05-28 01:35:54.978'),
	 (210719113980100332,162313684780011000,2107191139100327,1,'2023-05-28 01:35:54.978'),
	 (210408094001104803,161726665280011000,2104080940104802,1,'2023-05-28 01:35:54.978');
INSERT INTO mee_admin.sys_role_user (id,user_id,role_id,create_by,create_time) VALUES
	 (210408094001104804,161784598780011000,2104080940104802,1,'2023-05-28 01:35:54.978'),
	 (210412181501100491,160992657280011002,2104121815100490,1,'2023-05-28 01:35:54.978'),
	 (210412181501100492,160992649780011001,2104121815100490,1,'2023-05-28 01:35:54.978'),
	 (210412181501100493,3,2104121815100490,1,'2023-05-28 01:35:54.978'),
	 (210412181501100494,161767261980011000,2104121815100490,1,'2023-05-28 01:35:54.978'),
	 (210412181501100495,161767266280011001,2104121815100490,1,'2023-05-28 01:35:54.978'),
	 (210412181501100496,161793361380011000,2104121815100490,1,'2023-05-28 01:35:54.978'),
	 (210413151901103478,161051692680011000,2104131519103477,1,'2023-05-28 01:35:54.978'),
	 (210413151901103479,161102240880011000,2104131519103477,1,'2023-05-28 01:35:54.978'),
	 (210413151901103480,161605787580011001,2104131519103477,1,'2023-05-28 01:35:54.978');
INSERT INTO mee_admin.sys_role_user (id,user_id,role_id,create_by,create_time) VALUES
	 (210413151901103481,161829606280011000,2104131519103477,1,'2023-05-28 01:35:54.978'),
	 (210512135280100003,160628674600801000,2105121352100002,1,'2023-05-28 01:35:54.978'),
	 (221108162501100058,161640203380011000,2211081625100056,1,'2023-05-28 01:35:54.978'),
	 (221108162501100060,164238498300801000,2211081625100056,1,'2023-05-28 01:35:54.978'),
	 (220325182180100308,160369509280019000,2203251821100307,1,'2023-05-28 01:35:54.978'),
	 (220325182180100309,162035287280011000,2203251821100307,1,'2023-05-28 01:35:54.978'),
	 (220325182180100456,160369509280019000,2203251821100455,1,'2023-05-28 01:35:54.978'),
	 (220510171180100003,1,2205101711100002,1,'2023-05-28 01:35:54.978'),
	 (220510171180100004,164238498300801000,2205101711100002,1,'2023-05-28 01:35:54.978'),
	 (220510171180100005,162313684780011000,2205101711100002,1,'2023-05-28 01:35:54.978');
INSERT INTO mee_admin.sys_role_user (id,user_id,role_id,create_by,create_time) VALUES
	 (2306060948261000,161838568080011000,2201181119100002,1,'2023-06-06 09:48:26.707'),
	 (2306060950521001,161603004480011000,2201181119100002,1,'2023-06-06 09:50:52.998'),
	 (2306060950531002,161519267780011001,2201181119100002,1,'2023-06-06 09:50:52.998'),
	 (2306060950531003,161404345580011000,2201181119100002,1,'2023-06-06 09:50:52.998'),
	 (2306060950591004,1,2201181119100002,1,'2023-06-06 09:50:59.355'),
	 (2306060959211005,161110935880011000,2201181119100002,1,'2023-06-06 09:59:21.619'),
	 (2306060959341006,160973949180011000,2201181119100002,1,'2023-06-06 09:59:34.707'),
	 (2306060959341007,160992643480011000,2201181119100002,1,'2023-06-06 09:59:34.707'),
	 (2306060959501008,160750575380011000,2201181119100002,1,'2023-06-06 09:59:50.173'),
	 (2306060959501009,160888911880011000,2201181119100002,1,'2023-06-06 09:59:50.173');
INSERT INTO mee_admin.sys_role_user (id,user_id,role_id,create_by,create_time) VALUES
	 (2306060959501010,160914442780011000,2201181119100002,1,'2023-06-06 09:59:50.173'),
	 (2306060959501011,160939731380011001,2201181119100002,1,'2023-06-06 09:59:50.173'),
	 (2306061000011012,164247652300801000,2201181119100002,1,'2023-06-06 10:00:01.372'),
	 (2306061000101013,161767261980011000,2201181119100002,1,'2023-06-06 10:00:10.268'),
	 (2306061001591014,160689294880011004,2101071443100107,1,'2023-06-06 10:01:59.508'),
	 (2306061001591015,160628674600801000,2101071443100107,1,'2023-06-06 10:01:59.508'),
	 (2306061001591016,160619769300801000,2101071443100107,1,'2023-06-06 10:01:59.508'),
	 (2306061001591017,160445277280011000,2101071443100107,1,'2023-06-06 10:01:59.508'),
	 (2306061001591018,160369509280019000,2101071443100107,1,'2023-06-06 10:01:59.508'),
	 (2306061001591019,160281680680019000,2101071443100107,1,'2023-06-06 10:01:59.508');
INSERT INTO mee_admin.sys_role_user (id,user_id,role_id,create_by,create_time) VALUES
	 (2306061001591020,160121139280019000,2101071443100107,1,'2023-06-06 10:01:59.508'),
	 (2306061001591021,160092623080019000,2101071443100107,1,'2023-06-06 10:01:59.508'),
	 (2306061001591022,157925105000801000,2101071443100107,1,'2023-06-06 10:01:59.508'),
	 (2306061001591023,3,2101071443100107,1,'2023-06-06 10:01:59.508'),
	 (2306061001591024,1,2101071443100107,1,'2023-06-06 10:01:59.508'),
	 (2306061032441025,164247652300801000,2211081625100056,1,'2023-06-06 10:32:44.063'),
	 (2306061032441027,162313684780011000,2211081625100056,1,'2023-06-06 10:32:44.063'),
	 (2306061032441028,162035287280011000,2211081625100056,1,'2023-06-06 10:32:44.063'),
	 (2306061032441029,161966714280011000,2211081625100056,1,'2023-06-06 10:32:44.063'),
	 (2306061032441030,161838568080011000,2211081625100056,1,'2023-06-06 10:32:44.063');
INSERT INTO mee_admin.sys_role_user (id,user_id,role_id,create_by,create_time) VALUES
	 (2306061032441031,161830720080011000,2211081625100056,1,'2023-06-06 10:32:44.063'),
	 (2306061032441032,161829606280011000,2211081625100056,1,'2023-06-06 10:32:44.063'),
	 (2306061032441033,161820545280011000,2211081625100056,1,'2023-06-06 10:32:44.063'),
	 (2306061032441034,161793361380011000,2211081625100056,1,'2023-06-06 10:32:44.063'),
	 (2306061032441035,161784598780011000,2211081625100056,1,'2023-06-06 10:32:44.063'),
	 (2306061032541036,161767266280011001,2211081625100056,1,'2023-06-06 10:32:54.965'),
	 (2306061032541037,161767261980011000,2211081625100056,1,'2023-06-06 10:32:54.965'),
	 (2306061033421000,160628674600801000,2211081625100056,1,'2023-06-06 10:33:42.936'),
	 (2306061033421001,160445277280011000,2211081625100056,1,'2023-06-06 10:33:42.936'),
	 (2306061033421002,1,2211081625100056,1,'2023-06-06 10:33:42.936');
INSERT INTO mee_admin.sys_role_user (id,user_id,role_id,create_by,create_time) VALUES
	 (2306061033531003,160992657280011002,2211081625100056,1,'2023-06-06 10:33:53.657'),
	 (2306061033561004,161603004480011000,2211081625100056,1,'2023-06-06 10:33:56.142'),
	 (2306061033581005,161726665280011000,2211081625100056,1,'2023-06-06 10:33:58.173'),
	 (2306061047451006,161102240880011000,2211081625100056,1,'2023-06-06 10:47:45.260'),
	 (2306061047581007,162035287280011000,2203251821100455,1,'2023-06-06 10:47:58.004'),
	 (2306061101361000,161640203380011000,2203251821100455,1,'2023-06-06 11:01:36.752'),
	 (2306061102351002,160121139280019000,2211081625100056,1,'2023-06-06 11:02:35.865');