
INSERT INTO "als"."sys_client"("id","client_id","client_key","client_secret","grant_type","device_type","active_timeout","timeout","status","version","del_flag","create_by","create_time","update_by","update_time") VALUES(1,'e5cd7e4891bf95d1d19206ce24a7b32e','pc','pc123','password,social','pc',1800,604800,'1',0,0,1,TO_DATE('2024-01-22 11:09:12.997334','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-01-22 11:09:12.997334','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "als"."sys_client"("id","client_id","client_key","client_secret","grant_type","device_type","active_timeout","timeout","status","version","del_flag","create_by","create_time","update_by","update_time") VALUES(2,'428a8310cd442757ae699df5d894f051','app','app123','password,sms,social','android',1800,604800,'1',0,0,1,TO_DATE('2024-01-22 11:09:12.997334','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-01-22 11:09:12.997334','YYYY-MM-DD HH24:MI:SS.FF'));

INSERT INTO "als"."sys_config"("config_id","tenant_id","config_name","config_key","config_value","config_type","version","create_by","create_time","update_by","update_time","remark") VALUES(1,0,'主框架页-默认皮肤样式名称','sys.index.skinName','skin-blue','Y',0,1,TO_DATE('2024-01-22 11:09:12.997334','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO "als"."sys_config"("config_id","tenant_id","config_name","config_key","config_value","config_type","version","create_by","create_time","update_by","update_time","remark") VALUES(2,0,'用户管理-账号初始密码','sys.user.initPassword','123456','Y',0,1,TO_DATE('2024-01-22 11:09:12.997334','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'初始化密码 123456');
INSERT INTO "als"."sys_config"("config_id","tenant_id","config_name","config_key","config_value","config_type","version","create_by","create_time","update_by","update_time","remark") VALUES(3,0,'主框架页-侧边栏主题','sys.index.sideTheme','theme-dark','Y',0,1,TO_DATE('2024-01-22 11:09:12.997334','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'深色主题theme-dark，浅色主题theme-light');
INSERT INTO "als"."sys_config"("config_id","tenant_id","config_name","config_key","config_value","config_type","version","create_by","create_time","update_by","update_time","remark") VALUES(5,0,'账号自助-是否开启用户注册功能','sys.account.registerUser','false','Y',0,1,TO_DATE('2024-01-22 11:09:12.997334','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'是否开启注册用户功能（true开启，false关闭）');
INSERT INTO "als"."sys_config"("config_id","tenant_id","config_name","config_key","config_value","config_type","version","create_by","create_time","update_by","update_time","remark") VALUES(6,0,'OSS预览列表资源开关','sys.oss.previewListResource','true','Y',0,1,TO_DATE('2024-01-22 11:09:12.997334','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'true:开启, false:关闭');

INSERT INTO "als"."sys_dept"("dept_id","tenant_id","parent_id","ancestors","dept_name","order_num","leader","phone","email","status","version","del_flag","create_by","create_time","update_by","update_time") VALUES(108150551736287232,0,1,'0,1','XX组',2,'eco','',null,'1',3,0,1,TO_DATE('2024-01-25 23:32:40.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-21 15:15:03.381000','YYYY-MM-DD HH24:MI:SS.FF'));
INSERT INTO "als"."sys_dept"("dept_id","tenant_id","parent_id","ancestors","dept_name","order_num","leader","phone","email","status","version","del_flag","create_by","create_time","update_by","update_time") VALUES(1,0,0,'0','XX部门',0,'eco-admin','18888888888','ecoadmin@wo.cn','1',7,0,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-21 15:15:03.534000','YYYY-MM-DD HH24:MI:SS.FF'));

INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(1,0,1,'男','0','sys_user_gender','','','Y',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-09-20 09:53:27.000000','YYYY-MM-DD HH24:MI:SS.FF'),'性别男');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(2,0,2,'女','1','sys_user_gender','','','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-09-20 09:53:27.000000','YYYY-MM-DD HH24:MI:SS.FF'),'性别女');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(3,0,3,'未知','2','sys_user_gender','','','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-09-20 09:53:27.000000','YYYY-MM-DD HH24:MI:SS.FF'),'性别未知');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(4,0,1,'显示','1','sys_show_hide','','primary','Y',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'显示菜单');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(5,0,2,'隐藏','0','sys_show_hide','','danger','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'隐藏菜单');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(6,0,1,'正常','1','sys_normal_disable','','primary','Y',1,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 16:17:22.739000','YYYY-MM-DD HH24:MI:SS.FF'),'正常状态');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(7,0,2,'停用','0','sys_normal_disable','','danger','N',1,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 16:17:28.453000','YYYY-MM-DD HH24:MI:SS.FF'),'停用状态');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(8,0,1,'正常','1','sys_job_status','','primary','Y',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'正常状态');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(9,0,2,'暂停','0','sys_job_status','','danger','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'停用状态');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(10,0,1,'默认','DEFAULT','sys_job_group','','','Y',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'默认分组');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(11,0,2,'系统','SYSTEM','sys_job_group','','','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'系统分组');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(12,0,1,'是','1','sys_yes_no','','primary','Y',1,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 17:03:06.185000','YYYY-MM-DD HH24:MI:SS.FF'),'系统默认是');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(13,0,2,'否','0','sys_yes_no','','danger','N',1,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 17:03:13.399000','YYYY-MM-DD HH24:MI:SS.FF'),'系统默认否');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(14,0,1,'通知','1','sys_notice_type','','warning','Y',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'通知');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(15,0,2,'公告','2','sys_notice_type','','success','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'公告');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(16,0,1,'正常','1','sys_notice_status','','primary','Y',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'正常状态');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(17,0,2,'关闭','0','sys_notice_status','','danger','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'关闭状态');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(18,0,99,'其他','0','sys_oper_type','','info','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'其他操作');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(19,0,1,'新增','1','sys_oper_type','','info','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'新增操作');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(20,0,2,'修改','2','sys_oper_type','','info','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'修改操作');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(21,0,3,'删除','3','sys_oper_type','','danger','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'删除操作');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(22,0,4,'授权','4','sys_oper_type','','primary','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'授权操作');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(23,0,5,'导出','5','sys_oper_type','','warning','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'导出操作');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(24,0,6,'导入','6','sys_oper_type','','warning','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'导入操作');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(25,0,7,'强退','7','sys_oper_type','','danger','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'强退操作');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(26,0,8,'生成代码','8','sys_oper_type','','warning','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'生成操作');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(27,0,9,'清空数据','9','sys_oper_type','','danger','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'清空操作');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(28,0,1,'成功','1','sys_common_status','','primary','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'正常状态');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(29,0,2,'失败','0','sys_common_status','','danger','N',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'停用状态');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(30,0,1,'密码认证','password','sys_grant_type','el-check-tag','default','N',0,1,TO_DATE('2023-10-21 11:10:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:10:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),'密码认证');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(31,0,2,'短信认证','sms','sys_grant_type','el-check-tag','default','N',0,1,TO_DATE('2023-10-21 11:10:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:10:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),'短信认证');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(32,0,3,'邮件认证','email','sys_grant_type','el-check-tag','default','N',0,1,TO_DATE('2023-10-21 11:10:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:10:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),'邮件认证');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(33,0,4,'小程序认证','xcx','sys_grant_type','el-check-tag','default','N',0,1,TO_DATE('2023-10-21 11:10:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:10:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),'小程序认证');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(34,0,5,'三方登录认证','social','sys_grant_type','el-check-tag','default','N',0,1,TO_DATE('2023-10-21 11:10:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:10:51.000000','YYYY-MM-DD HH24:MI:SS.FF'),'三方登录认证');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(35,0,1,'PC','pc','sys_device_type','','default','N',0,1,TO_DATE('2023-10-21 11:41:10.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:41:10.000000','YYYY-MM-DD HH24:MI:SS.FF'),'PC');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(36,0,2,'安卓','android','sys_device_type','','default','N',0,1,TO_DATE('2023-10-21 11:41:10.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:41:10.000000','YYYY-MM-DD HH24:MI:SS.FF'),'安卓');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(37,0,3,'iOS','ios','sys_device_type','','default','N',0,1,TO_DATE('2023-10-21 11:41:10.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:41:10.000000','YYYY-MM-DD HH24:MI:SS.FF'),'iOS');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(38,0,4,'小程序','xcx','sys_device_type','','default','N',0,1,TO_DATE('2023-10-21 11:41:10.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:41:10.000000','YYYY-MM-DD HH24:MI:SS.FF'),'小程序');
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(105,0,0,'计算机','1','sys_goods_type',null,'primary','N',0,1,TO_DATE('2023-06-05 07:23:48.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,null);
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(106,0,0,'打印设备','2','sys_goods_type',null,'success','N',0,1,TO_DATE('2023-06-05 07:24:14.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,null);
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(107,0,3,'衣服','3','sys_goods_type',null,'info','N',0,1,TO_DATE('2023-06-05 07:24:35.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,null);
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(111,0,4,'网络设备','4','sys_goods_type',null,'default',null,0,1,TO_DATE('2023-09-19 17:31:46.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-09-19 17:31:46.000000','YYYY-MM-DD HH24:MI:SS.FF'),null);
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(65923231885905920,0,1,'桌面微机','PC','sys_app_type',null,'default','N',0,1,TO_DATE('2023-10-01 10:56:23.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-01 10:56:23.000000','YYYY-MM-DD HH24:MI:SS.FF'),null);
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(65923379802230784,0,2,'平板','pad','sys_app_type',null,'default','N',0,1,TO_DATE('2023-10-01 10:56:59.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-01 10:56:59.000000','YYYY-MM-DD HH24:MI:SS.FF'),null);
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(65923470604718080,0,3,'手机','phone','sys_app_type',null,'default','N',0,1,TO_DATE('2023-10-01 10:57:20.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-01 10:57:20.000000','YYYY-MM-DD HH24:MI:SS.FF'),null);
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(163136166100500480,0,1,'是','Y','sys_y_n',null,'primary','N',0,1,TO_DATE('2024-06-25 17:05:52.922000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 17:05:52.922000','YYYY-MM-DD HH24:MI:SS.FF'),null);
INSERT INTO "als"."sys_dict_data"("dict_code","tenant_id","dict_sort","dict_label","dict_value","dict_type","css_class","list_class","is_default","version","create_by","create_time","update_by","update_time","remark") VALUES(163136226775302144,0,2,'否','N','sys_y_n',null,'primary','N',0,1,TO_DATE('2024-06-25 17:06:07.389000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 17:06:07.389000','YYYY-MM-DD HH24:MI:SS.FF'),null);

INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(1,0,'用户性别','sys_user_gender',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-09-20 09:53:27.000000','YYYY-MM-DD HH24:MI:SS.FF'),'用户性别列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(2,0,'菜单状态','sys_show_hide',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'菜单状态列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(3,0,'系统开关','sys_normal_disable',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'系统开关列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(4,0,'任务状态','sys_job_status',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'任务状态列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(5,0,'任务分组','sys_job_group',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'任务分组列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(6,0,'系统是否','sys_yes_no',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'系统是否列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(7,0,'通知类型','sys_notice_type',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'通知类型列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(8,0,'通知状态','sys_notice_status',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'通知状态列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(9,0,'操作类型','sys_oper_type',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'操作类型列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(10,0,'系统状态','sys_common_status',0,1,TO_DATE('2023-06-03 21:32:30.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'登录状态列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(11,0,'授权类型','sys_grant_type',0,1,TO_DATE('2023-10-21 11:06:33.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:06:33.000000','YYYY-MM-DD HH24:MI:SS.FF'),'认证授权类型');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(12,0,'设备类型','sys_device_type',0,1,TO_DATE('2023-10-21 11:38:41.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-21 11:38:41.000000','YYYY-MM-DD HH24:MI:SS.FF'),'客户端设备类型');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(102,0,'商品种类','sys_goods_type',0,1,TO_DATE('2023-06-05 07:23:20.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,null);
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(65922863223361536,0,'系统类型','sys_app_type',0,1,TO_DATE('2023-10-01 10:54:55.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-01 10:54:55.000000','YYYY-MM-DD HH24:MI:SS.FF'),'系统类型列表');
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(118192295228071936,0,'是否缓存','sys_cache',0,1,TO_DATE('2024-02-22 16:34:59.090000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-02-22 16:34:59.090000','YYYY-MM-DD HH24:MI:SS.FF'),null);
INSERT INTO "als"."sys_dict_type"("dict_id","tenant_id","dict_name","dict_type","version","create_by","create_time","update_by","update_time","remark") VALUES(163135360617971712,0,'系统是否YN','sys_y_n',0,1,TO_DATE('2024-06-25 17:02:40.880000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 17:02:40.880000','YYYY-MM-DD HH24:MI:SS.FF'),'对应值为Y N');

INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1011,'角色导出',101,5,'','',null,'','0','1','F','1','1','system:role:export','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1022,'岗位修改',104,3,'','',null,'','0','1','F','1','1','system:post:edit','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1016,'部门查询',103,1,'','',null,'','0','1','F','1','1','system:dept:query','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1018,'部门修改',103,3,'','',null,'','0','1','F','1','1','system:dept:edit','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1020,'岗位查询',104,1,'','',null,'','0','1','F','1','1','system:post:query','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1010,'角色删除',101,4,'','',null,'','0','1','F','1','1','system:role:remove','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1007,'角色查询',101,1,'','',null,'','0','1','F','1','1','system:role:query','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1029,'字典导出',105,5,'','',null,'','0','1','F','1','1','system:dict:export','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1015,'菜单删除',102,4,'','',null,'','0','1','F','1','1','system:menu:remove','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1014,'菜单修改',102,3,'','',null,'','0','1','F','1','1','system:menu:edit','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1013,'菜单新增',102,2,'','',null,'','0','1','F','1','1','system:menu:add','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1023,'岗位删除',104,4,'','',null,'','0','1','F','1','1','system:post:remove','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1012,'菜单查询',102,1,'','',null,'','0','1','F','1','1','system:menu:query','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1024,'岗位导出',104,5,'','',null,'','0','1','F','1','1','system:post:export','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1059,'预览代码',116,5,'','',null,'','0','1','F','1','1','tool:gen:preview','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1060,'生成代码',116,6,'','',null,'','0','1','F','1','1','tool:gen:code','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1008,'角色新增',101,2,'','',null,'','0','1','F','1','1','system:role:add','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1600,'文件查询',118,1,'','',null,'','0','1','F','1','1','system:oss:query','',0,1,TO_DATE('2023-12-25 15:09:14.342224','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1601,'文件上传',118,2,'','',null,'','0','1','F','1','1','system:oss:upload','',0,1,TO_DATE('2023-12-25 15:09:14.342224','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1602,'文件下载',118,3,'','',null,'','0','1','F','1','1','system:oss:download','',0,1,TO_DATE('2023-12-25 15:09:14.342224','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1017,'部门新增',103,2,'','',null,'','0','1','F','1','1','system:dept:add','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1021,'岗位新增',104,2,'','',null,'','0','1','F','1','1','system:post:add','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1019,'部门删除',103,4,'','',null,'','0','1','F','1','1','system:dept:remove','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1009,'角色修改',101,3,'','',null,'','0','1','F','1','1','system:role:edit','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1025,'字典查询',105,1,'','',null,'','0','1','F','1','1','system:dict:query','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1026,'字典新增',105,2,'','',null,'','0','1','F','1','1','system:dict:add','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1027,'字典修改',105,3,'','',null,'','0','1','F','1','1','system:dict:edit','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1028,'字典删除',105,4,'','',null,'','0','1','F','1','1','system:dict:remove','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1039,'操作查询',500,1,'','',null,'','0','1','F','1','1','monitor:operlog:query','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1040,'操作删除',500,2,'','',null,'','0','1','F','1','1','monitor:operlog:remove','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1041,'日志导出',500,3,'','',null,'','0','1','F','1','1','monitor:operlog:export','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1042,'登录查询',501,1,'','',null,'','0','1','F','1','1','monitor:logininfor:query','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1043,'登录删除',501,2,'','',null,'','0','1','F','1','1','monitor:logininfor:remove','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1044,'日志导出',501,3,'','',null,'','0','1','F','1','1','monitor:logininfor:export','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1045,'账户解锁',501,4,'','',null,'','0','1','F','1','1','monitor:logininfor:unlock','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1000,'用户查询',100,1,'','',null,'','0','1','F','1','1','system:user:query','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1055,'生成查询',116,1,'','',null,'','0','1','F','1','1','tool:gen:query','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1056,'生成修改',116,2,'','',null,'','0','1','F','1','1','tool:gen:edit','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1057,'生成删除',116,3,'','',null,'','0','1','F','1','1','tool:gen:remove','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1001,'用户新增',100,2,'','',null,'','0','1','F','1','1','system:user:add','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1002,'用户修改',100,3,'','',null,'','0','1','F','1','1','system:user:edit','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1603,'文件删除',118,4,'','',null,'','0','1','F','1','1','system:oss:remove','',0,1,TO_DATE('2023-12-25 15:09:14.342224','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1620,'配置列表',118,5,'','',null,'','0','1','F','1','1','system:ossConfig:list','',0,1,TO_DATE('2023-12-25 15:09:14.342224','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1621,'配置添加',118,6,'','',null,'','0','1','F','1','1','system:ossConfig:add','',0,1,TO_DATE('2023-12-25 15:09:14.342224','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1622,'配置编辑',118,6,'','',null,'','0','1','F','1','1','system:ossConfig:edit','',0,1,TO_DATE('2023-12-25 15:09:14.342224','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1623,'配置删除',118,6,'','',null,'','0','1','F','1','1','system:ossConfig:remove','',0,1,TO_DATE('2023-12-25 15:09:14.342224','YYYY-MM-DD HH24:MI:SS.FF'),null,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1003,'用户删除',100,4,'','',null,'','0','1','F','1','1','system:user:remove','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1004,'用户导出',100,5,'','',null,'','0','1','F','1','1','system:user:export','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1005,'用户导入',100,6,'','',null,'','0','1','F','1','1','system:user:import','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1006,'重置密码',100,7,'','',null,'','0','1','F','1','1','system:user:resetPwd','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1058,'导入代码',116,4,'','',null,'','0','1','F','1','1','tool:gen:import','',0,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(103,'部门管理',1,4,'dept','system/dept/index',null,'','0','1','C','1','1','system:dept:list','user',1,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:09:12.860000','YYYY-MM-DD HH24:MI:SS.FF'),'部门管理菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(3,'系统工具',0,4,'tool',null,null,'','0','1','M','1','1','','Setting',3,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:10:27.874000','YYYY-MM-DD HH24:MI:SS.FF'),'系统工具目录');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(100,'用户管理',1,1,'user','system/user/index','User','','0','1','C','1','1','system:user:list','User',10,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:06:29.359000','YYYY-MM-DD HH24:MI:SS.FF'),'用户管理菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(101,'角色管理',1,2,'role','system/role/index',null,'','0','1','C','1','1','system:role:list','peoples',5,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-26 00:02:56.851000','YYYY-MM-DD HH24:MI:SS.FF'),'角色管理菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(102,'菜单管理',1,3,'menu','system/menu/index',null,'','0','1','C','1','1','system:menu:list','Menu',3,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-26 00:03:41.324000','YYYY-MM-DD HH24:MI:SS.FF'),'菜单管理菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(1,'系统管理',0,1,'system',null,null,'','0','1','M','1','1','','system',10,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:14:23.227000','YYYY-MM-DD HH24:MI:SS.FF'),'系统管理目录');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(116,'代码生成',3,0,'gen','tool/gen/index','gen','','0','1','C','1','1','tool:gen:list','code',3,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:10:40.608000','YYYY-MM-DD HH24:MI:SS.FF'),'代码生成菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(105,'字典管理',1,6,'dict','system/dict/index',null,'','0','1','C','1','1','system:dict:list','dict',1,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:09:49.770000','YYYY-MM-DD HH24:MI:SS.FF'),'字典管理菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(500,'操作日志',108,1,'operlog','monitor/operlog/index',null,'','0','1','C','1','1','monitor:operlog:list','logininfor',1,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:10:59.271000','YYYY-MM-DD HH24:MI:SS.FF'),'操作日志菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(104,'岗位管理',1,5,'post','system/post/index',null,'','0','1','C','1','1','system:post:list','Connection',1,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:09:27.490000','YYYY-MM-DD HH24:MI:SS.FF'),'岗位管理菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(108,'日志管理',1,9,'log','',null,'','0','1','M','1','1','','log',1,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:09:58.829000','YYYY-MM-DD HH24:MI:SS.FF'),'日志管理菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(501,'登录日志',108,2,'logininfor','monitor/logininfor/index',null,'','0','1','C','1','1','monitor:logininfor:list','logininfor',1,1,TO_DATE('2023-06-03 21:32:29.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:11:12.076000','YYYY-MM-DD HH24:MI:SS.FF'),'登录日志菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(118,'文件管理',1,10,'oss','system/oss/index',null,'','0','1','C','1','1','system:oss:list','Files',1,1,TO_DATE('2023-12-03 08:46:11.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-20 23:10:13.192000','YYYY-MM-DD HH24:MI:SS.FF'),'文件管理菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(2024062414053900,'系统配置',1,11,'config','system/config/index','config',null,'0','1','C','1','1','system:config:list','system',5,1,TO_DATE('2024-06-24 14:06:29.531000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 22:46:45.372000','YYYY-MM-DD HH24:MI:SS.FF'),'参数配置菜单');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(2024062414053901,'系统配置查询',2024062414053900,1,'','',null,null,'0','1','F','1','1','system:config:query','',0,1,TO_DATE('2024-06-24 14:06:29.547000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(2024062414053902,'系统配置新增',2024062414053900,2,'','',null,null,'0','1','F','1','1','system:config:add','',0,1,TO_DATE('2024-06-24 14:06:29.563000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(2024062414053903,'系统配置修改',2024062414053900,3,'','',null,null,'0','1','F','1','1','system:config:edit','',0,1,TO_DATE('2024-06-24 14:06:29.579000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(2024062414053904,'系统配置删除',2024062414053900,4,'','',null,null,'0','1','F','1','1','system:config:remove','',0,1,TO_DATE('2024-06-24 14:06:29.594000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_menu"("menu_id","menu_name","parent_id","order_num","path","component","component_name","query_param","is_frame","is_cache","menu_type","visible","status","perms","icon","version","create_by","create_time","update_by","update_time","remark") VALUES(2024062414053905,'系统配置导出',2024062414053900,5,'','',null,null,'0','1','F','1','1','system:config:export','',0,1,TO_DATE('2024-06-24 14:06:29.610000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
insert into "als"."sys_menu" ("menu_id", "menu_name", "parent_id", "order_num", "path", "component", "component_name", "query_param", "is_frame", "is_cache", "menu_type", "visible", "status", "perms", "icon", "version", "create_by", "create_time", "update_by", "update_time", "remark") values (170345777982373888, '系统监控', 0, 20, 'monitor', null, null, null, '0', null, 'M', '1', '1', null, 'AlarmClock', 1, 1, '2024-07-15 14:34:18.342000', 1, '2024-07-15 14:34:48.311000', null);
insert into "als"."sys_menu" ("menu_id", "menu_name", "parent_id", "order_num", "path", "component", "component_name", "query_param", "is_frame", "is_cache", "menu_type", "visible", "status", "perms", "icon", "version", "create_by", "create_time", "update_by", "update_time", "remark") values (170346229411119104, '任务调度', 170345777982373888, 10, 'powerjob', 'monitor/powerjob/index', null, null, '0', null, 'C', '1', '1', null, 'job', 0, 1, '2024-07-15 14:36:05.971000', 1, '2024-07-15 14:36:05.971000', null);
insert into "als"."sys_menu" ("menu_id", "menu_name", "parent_id", "order_num", "path", "component", "component_name", "query_param", "is_frame", "is_cache", "menu_type", "visible", "status", "perms", "icon", "version", "create_by", "create_time", "update_by", "update_time", "remark") values (170346400798769152, '服务监控', 170345777982373888, 20, 'admin', 'monitor/admin/index', null, null, '0', null, 'C', '1', '1', null, 'server', 0, 1, '2024-07-15 14:36:46.833000', 1, '2024-07-15 14:36:46.833000', null);

INSERT INTO "als"."sys_oss"("oss_id","tenant_id","file_name","original_name","file_suffix","url","service","version","create_by","create_time","update_by","update_time") VALUES(163169678664970240,0,'2024/06/25/a76e13cfa29d49aca6a5f2c95ccda4b5.jpg','wallhaven-m3mmq9.jpg','.jpg','http://127.0.0.1:9000/eco-bucket/2024/06/25/a76e13cfa29d49aca6a5f2c95ccda4b5.jpg','minio',0,1,TO_DATE('2024-06-25 19:19:02.944000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 19:19:02.944000','YYYY-MM-DD HH24:MI:SS.FF'));

INSERT INTO "als"."sys_oss_config"("oss_config_id","tenant_id","config_key","access_key","secret_key","bucket_name","prefix","endpoint","domain_name","is_https","region","access_policy","status","ext1","version","create_by","create_time","update_by","update_time","remark") VALUES(1,0,'minio','rzbRpmQLtD49FRwDU0kW','3EcOTTxS9btVQlt9pXFAsM3p7E557B5kqn0aNKbx','eco-bucket','','127.0.0.1:9000','','N','','1','1','',3,1,TO_DATE('2023-11-30 11:54:13.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 18:53:12.414000','YYYY-MM-DD HH24:MI:SS.FF'),null);
INSERT INTO "als"."sys_oss_config"("oss_config_id","tenant_id","config_key","access_key","secret_key","bucket_name","prefix","endpoint","domain_name","is_https","region","access_policy","status","ext1","version","create_by","create_time","update_by","update_time","remark") VALUES(2,0,'qiniu','eco-qiniu','eco-qiniu','eco-bucket','','s3-cn-north-1.qiniucs.com','','N','','1','0','',4,1,TO_DATE('2023-11-30 11:54:13.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 17:17:19.858000','YYYY-MM-DD HH24:MI:SS.FF'),null);
INSERT INTO "als"."sys_oss_config"("oss_config_id","tenant_id","config_key","access_key","secret_key","bucket_name","prefix","endpoint","domain_name","is_https","region","access_policy","status","ext1","version","create_by","create_time","update_by","update_time","remark") VALUES(3,0,'aliyun','eco-aliyun','eco-aliyun','eco-bucket','','oss-cn-beijing.aliyuncs.com','','N','','1','0','',2,1,TO_DATE('2023-11-30 11:54:13.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-24 17:56:15.621000','YYYY-MM-DD HH24:MI:SS.FF'),null);
INSERT INTO "als"."sys_oss_config"("oss_config_id","tenant_id","config_key","access_key","secret_key","bucket_name","prefix","endpoint","domain_name","is_https","region","access_policy","status","ext1","version","create_by","create_time","update_by","update_time","remark") VALUES(4,0,'qcloud','eco-qcloud','eco-qcloud','eco-bucket','','cos.ap-beijing.myqcloud.com','','N','','1','0','',2,1,TO_DATE('2023-11-30 11:54:13.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-24 17:56:28.199000','YYYY-MM-DD HH24:MI:SS.FF'),null);
INSERT INTO "als"."sys_oss_config"("oss_config_id","tenant_id","config_key","access_key","secret_key","bucket_name","prefix","endpoint","domain_name","is_https","region","access_policy","status","ext1","version","create_by","create_time","update_by","update_time","remark") VALUES(5,0,'local','eco-local','eco-local','eco-bucket','','localhost','','N','','1','0','',8,1,TO_DATE('2024-06-25 15:35:13.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-26 11:07:04.099000','YYYY-MM-DD HH24:MI:SS.FF'),'');

INSERT INTO "als"."sys_post"("post_id","tenant_id","post_code","post_name","post_sort","status","version","create_by","create_time","update_by","update_time","remark") VALUES(1,0,'ceo','董事长',1,'1',0,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-09-02 15:43:55.000000','YYYY-MM-DD HH24:MI:SS.FF'),'');
INSERT INTO "als"."sys_post"("post_id","tenant_id","post_code","post_name","post_sort","status","version","create_by","create_time","update_by","update_time","remark") VALUES(2,0,'se','项目经理',2,'1',0,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_post"("post_id","tenant_id","post_code","post_name","post_sort","status","version","create_by","create_time","update_by","update_time","remark") VALUES(3,0,'hr','人力资源',3,'1',0,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'');
INSERT INTO "als"."sys_post"("post_id","tenant_id","post_code","post_name","post_sort","status","version","create_by","create_time","update_by","update_time","remark") VALUES(4,0,'users','普通员工',4,'1',0,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-07-13 21:30:24.000000','YYYY-MM-DD HH24:MI:SS.FF'),'');
INSERT INTO "als"."sys_post"("post_id","tenant_id","post_code","post_name","post_sort","status","version","create_by","create_time","update_by","update_time","remark") VALUES(5,0,'deptLeader','部门管理岗',5,'1',0,1,TO_DATE('2023-10-01 10:33:39.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-10-01 10:33:39.000000','YYYY-MM-DD HH24:MI:SS.FF'),'部门负责人岗位');

INSERT INTO "als"."sys_role"("role_id","tenant_id","role_name","role_key","role_sort","data_scope","menu_check_strictly","dept_check_strictly","status","version","del_flag","create_by","create_time","update_by","update_time","remark") VALUES(1,0,'超级管理员角色','superAdmin',1,'1',1,1,'1',0,0,1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,null,'超级管理员');

INSERT INTO "als"."sys_tenant"("tenant_id","contact_user_name","contact_phone","company_name","license_number","address","intro","domain_name","remark","package_id","expire_time","account_count","status","version","del_flag","create_by","create_time","update_by","update_time") VALUES(0,'联系人','18888888888','eco',null,null,'多租户通用后台管理管理系统',null,null,null,null,-1,'1',0,0,1,TO_DATE('2023-08-13 08:08:08.000000','YYYY-MM-DD HH24:MI:SS.FF'),null,null);

INSERT INTO "als"."sys_user"("user_id","tenant_id","dept_id","user_name","nick_name","user_type","email","phonenumber","gender","avatar","password","status","version","del_flag","login_ip","login_date","create_by","create_time","update_by","update_time","remark") VALUES(1,0,1,'superadmin','超级管理员','sys_user','eco@eco.com','15888888888',1,163169678664970240,'$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2','1',126,0,'0:0:0:0:0:0:0:1',TO_DATE('2024-06-26 09:30:03.943000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2023-06-03 21:32:28.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-26 09:30:03.950000','YYYY-MM-DD HH24:MI:SS.FF'),'管理员');
INSERT INTO "als"."sys_user"("user_id","tenant_id","dept_id","user_name","nick_name","user_type","email","phonenumber","gender","avatar","password","status","version","del_flag","login_ip","login_date","create_by","create_time","update_by","update_time","remark") VALUES(163042315792855040,0,1,'wanggaokun','wanggaokun','sys_user','','',0,null,'$2a$10$hDZjISygrEz.pzIYymHHsO5CmV02qj/ae5anSaympYxj3XreQSV0u','1',4,0,'0:0:0:0:0:0:0:1',TO_DATE('2024-06-25 10:55:29.659000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 10:52:57.000000','YYYY-MM-DD HH24:MI:SS.FF'),1,TO_DATE('2024-06-25 16:47:43.159000','YYYY-MM-DD HH24:MI:SS.FF'),null);

INSERT INTO "als"."sys_user_post"("user_id","post_id") VALUES(163042315792855040,4);
