
-- QUARTZ_TASK_INFO - 定时任务信息表
INSERT INTO "SECURE_PRODUCTING"."QUARTZ_TASK_INFO"("SEND_TYPE","TASK_NAME","TIME_KEY","FROZEN_TIME","URL","IS_DELETE","TASK_NO","UNFROZEN_TIME","STATUS","VERSION","EXECUTOR","ID","CREATE_TIME","EXECUTE_PARAMETER","SCHEDULER_RULE") VALUES
('1','清理任务调度日志','',0,'',0,'T548502417961000960',0,1,1721281967117,'clearQuartzLog',548502417961000960,1721281967117,'{
  "keepDays": 15
}','0 0 1 * * ?'),
('1','用户登录数量统计','',0,'',0,'T550315534424612864',0,1,1721714247759,'userLoginStatistics',550315534424612864,1721714247759,'','0 0/5 * * * ?');


-- SYS_MENU - 菜单权限表
INSERT INTO "SECURE_PRODUCTING"."SYS_MENU"("PATH","IS_FRAME","MENU_TYPE","ORDER_NUM","PERMS","UPDATE_BY","GUID","QUERY_PARAM","MENU_ID","IS_CACHE","IS_DELETE","PARENT_ID","VISIBLE","STATUS","CREATE_BY","COMPONENT","ICON","CREATE_TIME","MENU_NAME","REMARK") VALUES
('system',1,'M',200,'CUSTOMS_SENDER,SYSTEM_ADMIN','admin',null,null,1733090896768442369,0,0,0,'0','0','lizhang',null,'system','2023-12-08 19:47:24.000','系统设置',''),
('configs',1,'C',10,'CUSTOMS_SENDER,SYSTEM_ADMIN','admin',null,null,1733091073520607234,0,0,1733090896768442369,'0','0','lizhang','system/config/index','settings','2023-12-08 19:48:06.000','参数设置',''),
('logs',1,'C',40,'CUSTOMS_SENDER,SYSTEM_ADMIN','admin',null,null,1733091321445916674,0,0,1733090896768442369,'0','0','lizhang','monitor/operlog/index','log','2023-12-08 19:49:05.000','操作日志',''),
('menu',1,'C',1,'CUSTOMS_SENDER,SYSTEM_ADMIN','admin',null,null,1733092599609729026,0,0,1733090896768442369,'0','0','lizhang','system/menu/index','nested','2023-12-08 19:54:10.000','菜单管理',''),
('dict',1,'C',20,'CUSTOMS_SENDER,SYSTEM_ADMIN','admin',null,null,1735216821698084865,0,0,1733090896768442369,'0','0','lizhang','system/dict/index','dict','2023-12-14 16:35:04.000','数据字典',''),
('users',1,'C',3,'CUSTOMS_SENDER,SYSTEM_ADMIN','admin',null,null,1797854677740847106,0,0,1733090896768442369,'0','0','admin','system/user/index','#','2024-06-04 12:55:32.000','用户管理',''),
('roles',1,'C',2,'CUSTOMS_SENDER,SYSTEM_ADMIN','admin',null,null,1797854758917406722,0,0,1733090896768442369,'0','0','admin','system/role/index','#','2024-06-04 12:55:52.000','角色管理',''),
('policy',1,'M',99,null,'admin',null,null,1797929126859235330,0,0,0,'0','0','admin',null,'#','2024-06-04 17:51:22.000','政策法规',''),
('category',1,'C',1,'SYSTEM_ADMIN','admin',null,null,1797929657216393218,0,0,1797929126859235330,'0','0','admin','policy/category','#','2024-06-04 17:53:29.000','政策法规分类',''),
('index',1,'C',2,'SYSTEM_ADMIN','admin',null,'',1797929901077422082,0,0,1797929126859235330,'0','0','admin','policy/index','#','2024-06-04 17:54:27.000','政策法规信息',''),
('index',1,'C',10,'','admin',null,null,1798596518526341121,0,0,0,'1','0','admin','index','server','2024-06-06 14:03:21.000','首页','');

INSERT INTO "SECURE_PRODUCTING"."SYS_MENU"("PATH","IS_FRAME","MENU_TYPE","ORDER_NUM","PERMS","UPDATE_BY","GUID","QUERY_PARAM","MENU_ID","IS_CACHE","IS_DELETE","PARENT_ID","VISIBLE","STATUS","CREATE_BY","COMPONENT","ICON","CREATE_TIME","MENU_NAME","REMARK") VALUES
('job',1,'M',70,null,'admin',null,null,1812787847363678210,0,0,0,'0','0','admin',null,'#','2024-07-15 17:54:37.000','任务调度',''),
('quartz',1,'C',10,'SYSTEM_ADMIN','admin',null,null,1812787974274928641,0,0,1812787847363678210,'0','0','admin','job/quartz','#','2024-07-15 17:55:08.000','定时任务',''),
('monitor',1,'M',1,null,'admin',null,null,1813493086597275650,0,0,0,'0','0','admin','','monitor','2024-07-17 16:37:00.000','系统监控',''),
('server',1,'C',10,'SYSTEM_ADMIN','admin',null,'',1813493520518995970,0,0,1813493086597275650,'0','0','admin','monitor/server/index','server','2024-07-17 16:38:43.000','服务监控',''),
('online',1,'C',20,'SYSTEM_ADMIN','admin',null,null,1813496864469803010,0,0,1813493086597275650,'0','0','admin','monitor/online/index','peoples','2024-07-17 16:52:00.000','在线用户',''),
('loginuser',1,'C',30,'SYSTEM_ADMIN','admin',null,null,1813497330201124866,0,0,1733090896768442369,'0','0','admin','monitor/logininfor/index','logininfor','2024-07-17 16:53:51.000','登录日志',''),
('user',1,'C',30,'SYSTEM_ADMIN','admin',null,null,1814213547404570625,0,0,1813493086597275650,'0','0','admin','statistics/user','#','2024-07-19 16:19:51.000','用户数据统计',''),
('oss-config/index',1,'C',21,null,'admin',null,null,1823265033300213762,0,0,1733090896768442369,'0','0','admin','system/oss/config','upload','2024-08-13 15:47:13.000','对象存储管理',null);



-- SYS_USER - 用户信息表
INSERT INTO "SECURE_PRODUCTING"."SYS_USER"("PHONENUMBER","ORG_CHU_NAME","SEX","USER_ID","EXPIRATION_TIME","NICK_NAME","EMAIL","STATUS","ORG_KE_ID","ORG_TYPE","GLOBAL_SORT","ALL_PATH_NAME","CREATE_TIME","AVATAR","REMARK","LOGIN_DATE","DEPT_ID","ORG_KE_NAME","RANK_NAME","UPDATE_BY","IS_DELETE","ORG_CHU_ID","LOGIN_IP","USER_NAME","PARENT_GUID","USER_GUID","SELECTED","RANK_CODE","PASSWORD","IS_MESSAGE","USER_TYPE","PERSON_ID","CREATE_BY","SLIDE_LINE","LOGIN_NAME") VALUES
('15888888888',null,'1',11111111,null,'疯狂的狮子Li','crazyLionLi@163.com','0',null,null,null,null,'2023-09-11 11:39:32.000','','管理员','2023-10-30 16:22:02.000',103,null,null,'admin1','0',null,'127.0.0.1','admin1',null,null,null,null,'$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,'admin',null,null),
('15666666666',null,'1',2,null,'疯狂的狮子Li','crazyLionLi@qq.com','0',null,null,null,null,'2023-09-11 11:39:32.000','','测试员','2023-09-13 16:49:23.000',105,null,null,'lionli','0',null,'0:0:0:0:0:0:0:1','lionli',null,null,null,null,'$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,'admin',null,null),
('',null,'0',3,null,'本部门及以下 密码666666','','0',null,null,null,null,'2023-09-11 11:39:47.000','',null,'2023-09-12 11:28:39.000',108,null,null,'cqc\\mingh','0',null,'0:0:0:0:0:0:0:1','test',null,null,null,null,'$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,'admin',null,null),
('',null,'0',4,null,'仅本人 密码666666','','0',null,null,null,null,'2023-09-11 11:39:47.000','',null,'2023-09-11 11:39:47.000',102,null,null,'test1','2',null,'127.0.0.1','test1',null,null,null,null,'$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,'admin',null,null),
('',null,'0',1,'2034-05-31 17:30:00.000','admin','admin2@gmail.com','0',null,null,null,'中国海关\admin','2023-10-30 15:37:29.000','',null,'2024-08-08 16:30:27.000',102,null,'','admin','0',null,'0:0:0:0:0:0:0:1','admin',null,'1e199af0-877b-41a7-9e0f-15a64bd889cd',null,'','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user','',null,'0','admin'),
('',null,'0',1718901033604476929,'2023-10-31 16:15:51.000','王某某','','0',null,null,null,'中国海关\重庆海关\办公室\王某某','2023-10-30 16:01:57.000','',null,'2023-10-30 16:20:17.000',1701775385459027970,null,'副主任(副处级)','wmm01','0',null,'0:0:0:0:0:0:0:1','wmm01',null,'5e1054d2-3393-484d-bf10-13122235608c',null,'09','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user','8000890',null,'0','wmm01'),
('',null,'0',1718902974619119618,'2023-12-29 09:51:21.000','曾剑','','0',null,null,null,'中国海关\重庆海关\数据分中心\曾剑','2023-10-30 16:09:39.000','',null,'2023-12-28 09:51:22.000',1701775894517510145,null,'','jianzeng','0',null,'0:0:0:0:0:0:0:1','jianzeng',null,'f5b46d7c-5c82-9246-4c45-4b06e4522ebd',null,'','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','jianzeng'),
('',null,'0',1718934931946754049,'2023-10-31 18:16:39.000','高晗博','','0',null,null,null,'中国海关\重庆海关\数据分中心\高晗博','2023-10-30 18:16:39.000','',null,'2023-10-31 10:28:35.000',1701775894517510145,null,'','hanbogao','0',null,'0:0:0:0:0:0:0:1','hanbogao',null,'b59b8020-4454-954f-45a2-50b7d3c41b2d',null,'','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','hanbogao'),
('',null,'0',1718978756771831810,'2024-01-31 17:25:19.000','顾海伟','','0',null,null,null,'中国海关\重庆海关\数据分中心\顾海伟','2023-10-30 21:10:47.000','',null,'2024-01-30 17:25:21.000',1701775894517510145,null,'','haiweigu','0',null,'0:0:0:0:0:0:0:1','haiweigu',null,'7e5a2e20-8284-9a56-4f11-73999f6d587c',null,'','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','haiweigu'),
('',null,'0',1719171190926286850,'2023-12-07 13:14:30.000','孟世醒','','0',null,null,null,'中国海关\重庆海关\数据分中心\孟世醒','2023-10-31 09:55:27.000','',null,'2023-12-06 13:14:39.000',1701775894517510145,null,'','shixingmeng','0',null,'0:0:0:0:0:0:0:1','shixingmeng',null,'8deb9924-815c-b291-43ab-6d2a10bc72f1',null,'','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','shixingmeng'),
('',null,'0',1719180711957610498,'2023-12-01 10:41:21.000','傅航','','0',null,null,null,'中国海关\重庆海关\数据分中心\傅航','2023-10-31 10:33:17.000','',null,'2023-11-30 10:41:25.000',1701775894517510145,null,'','hangfu','0',null,'192.168.1.104','hangfu',null,'8ebc46db-6854-9211-424d-639b2f2a10b8',null,'','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','hangfu');

INSERT INTO "SECURE_PRODUCTING"."SYS_USER"("PHONENUMBER","ORG_CHU_NAME","SEX","USER_ID","EXPIRATION_TIME","NICK_NAME","EMAIL","STATUS","ORG_KE_ID","ORG_TYPE","GLOBAL_SORT","ALL_PATH_NAME","CREATE_TIME","AVATAR","REMARK","LOGIN_DATE","DEPT_ID","ORG_KE_NAME","RANK_NAME","UPDATE_BY","IS_DELETE","ORG_CHU_ID","LOGIN_IP","USER_NAME","PARENT_GUID","USER_GUID","SELECTED","RANK_CODE","PASSWORD","IS_MESSAGE","USER_TYPE","PERSON_ID","CREATE_BY","SLIDE_LINE","LOGIN_NAME") VALUES
('',null,'0',1719959200852865026,null,'dianzikouan','','0',null,null,null,null,'2023-11-02 14:06:43.000','',null,'2024-01-18 13:53:35.000',null,null,null,'dianzikouan','0',null,'127.0.0.1','dianzikouan',null,null,null,null,'$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,'dianzikouan',null,null),
('',null,'0',1726567725311758338,'2024-04-11 16:39:24.000','李彬','','0',null,null,null,'中国海关\重庆海关\法规和综合业务处\处领导\李彬','2023-11-20 19:46:38.000','',null,'2024-04-11 15:58:19.000',1725429670029000706,null,'（县处级正职）','binli','0',null,'0:0:0:0:0:0:0:1','binli',null,'6e9342db-3d22-bcbf-4bac-ede07fa5c4aa',null,'07','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','binli'),
('',null,'0',1726622369593516034,'2024-04-13 10:03:46.000','向涛','','0',null,null,null,'中国海关\重庆海关\法规和综合业务处\业务改革科\向涛','2023-11-20 23:23:47.000','',null,'2024-04-12 10:03:48.000',1725429672814018562,null,'（乡科级正职）','taoxiang','0',null,'0:0:0:0:0:0:0:1','taoxiang',null,'111ed458-a3cc-b6a0-4b09-83b6d969da8b',null,'09','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','taoxiang'),
('',null,'0',1727656012495491073,'2024-02-05 13:15:43.000','陈东','','0',null,null,null,'中国海关\重庆海关\西永海关\办公室\陈东','2023-11-23 19:51:06.000','',null,'2024-02-04 13:15:46.000',1725429681844355074,null,'（县处级正职）','dongchen','0',null,'0:0:0:0:0:0:0:1','dongchen',null,'a7fe9b07-4109-8157-4112-0c1d14c8e841',null,'07','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','dongchen'),
('',null,'0',1727978258984398850,'2024-01-25 10:55:06.000','徐熙文','','0',null,null,null,'中国海关\重庆海关\西永海关\综合业务科\徐熙文','2023-11-24 17:11:36.000','',null,'2024-01-24 10:55:09.000',1725429678707015682,null,'（乡科级正职）','xiwenxu','0',null,'0:0:0:0:0:0:0:1','xiwenxu',null,'cb313db0-c7dd-8a8d-435a-7972fcf7fc51',null,'09','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','xiwenxu'),
('',null,'0',1728015951340576770,'2024-01-25 10:53:02.000','梁倩','','0',null,null,null,'中国海关\重庆海关\西永海关\综合业务科\梁倩','2023-11-24 19:41:22.000','',null,'2024-01-24 10:53:05.000',1725429678707015682,null,'（科员）','qianliang','0',null,'0:0:0:0:0:0:0:1','qianliang',null,'afd03aed-234c-9d19-4a95-4fc3c026800e',null,'11','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','qianliang'),
('15922111581',null,'0',1728313157637406722,'2024-08-07 16:20:37.000','张利','724263057@qq.com','0',null,null,null,'中国海关\重庆海关\法规和综合业务处\业务改革科\张利','2023-11-25 15:22:22.000','',null,'2024-08-06 16:26:31.000',1725429672814018562,null,'（科员）','lizhang','0',null,'192.168.9.14','lizhang',null,'074371b8-aba4-aaad-4194-5d866417b1f0',null,'11','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','lizhang'),
('',null,'0',1728750042352545793,'2024-04-02 16:32:47.000','黄杰','','0',null,null,null,'中国海关\重庆海关\西永海关\关领导\黄杰','2023-11-26 20:18:23.000','',null,'2024-04-01 16:32:48.000',1725429677058654209,null,'（县处级正职）','jiehuang','0',null,'0:0:0:0:0:0:0:1','jiehuang',null,'80b3634b-bf7d-aded-4434-511cfdd174b4',null,'07','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','jiehuang'),
('',null,'0',1729407109227462657,'2023-11-29 15:49:20.000','周勇','','0',null,null,null,'中国海关\重庆海关\机关生活服务中心\服务部\周勇','2023-11-28 15:49:20.000','',null,'2023-11-28 15:50:52.000',1701775840452931585,null,'（科员）','yongzhou','0',null,'0:0:0:0:0:0:0:1','yongzhou',null,'9c1203f3-9ddf-96b3-4dd8-564a126896ca',null,'11','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','yongzhou'),
('',null,'0',1729661092677644290,'2024-04-11 17:52:55.000','袁霞','','0',null,null,null,'中国海关\重庆海关\机关生活服务中心\办公室\袁霞','2023-11-29 08:38:35.000','',null,'2024-04-11 15:59:19.000',1701775830768283650,null,'（乡科级正职）','xiayuan','0',null,'0:0:0:0:0:0:0:1','xiayuan',null,'4926ee6f-c0c3-be75-4e36-866ce6d9bf73',null,'09','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','xiayuan');

INSERT INTO "SECURE_PRODUCTING"."SYS_USER"("PHONENUMBER","ORG_CHU_NAME","SEX","USER_ID","EXPIRATION_TIME","NICK_NAME","EMAIL","STATUS","ORG_KE_ID","ORG_TYPE","GLOBAL_SORT","ALL_PATH_NAME","CREATE_TIME","AVATAR","REMARK","LOGIN_DATE","DEPT_ID","ORG_KE_NAME","RANK_NAME","UPDATE_BY","IS_DELETE","ORG_CHU_ID","LOGIN_IP","USER_NAME","PARENT_GUID","USER_GUID","SELECTED","RANK_CODE","PASSWORD","IS_MESSAGE","USER_TYPE","PERSON_ID","CREATE_BY","SLIDE_LINE","LOGIN_NAME") VALUES
('',null,'0',1740227429183094786,'2024-01-30 17:08:53.000','李云云','','0',null,null,null,'中国海关\重庆海关\法规和综合业务处\业务运行科\李云云','2023-12-28 12:25:26.000','',null,'2024-01-29 17:10:57.000',1725429667290120193,null,'（科员）','yunyunli','0',null,'0:0:0:0:0:0:0:1','yunyunli',null,'2b56fe46-57fd-8369-4c06-c52c59dd8297',null,'11','$2a$10$XOEPEOmqBtnK2duIRMSdFu5BsNPbYffPA/BI0aCFI0NN6NDsZFl62',null,'sys_user',null,null,'0','yunyunli'),
('',null,'0',531041829425127424,'2034-05-31 17:30:00.000','萧炎','','0',null,null,null,null,'2024-05-31 09:30:39.000','',null,'2024-08-06 16:31:41.000',null,null,null,'xiaoyan','0',null,'192.168.9.14','xiaoyan',null,null,null,null,'$2a$10$FF5gmIhijPm6QOal8pz2FO3fO2mvKv/vacLUlhN.VErgfYmPtPlzG',null,'sys_user',null,'admin',null,'xiaoyan'),
('',null,'0',535390400370843648,'2034-05-31 17:30:00.000','周元','','0',null,null,null,null,'2024-06-12 09:30:19.000','',null,'2024-07-04 14:25:08.000',null,null,null,'zhouyuan','0',null,'192.168.9.14','zhouyuan',null,null,null,null,'$2a$10$DtESZ.VYWjvjPKW9hEsKlezZi/PIOLDiHc87jFCYftxJRhLTaaeam',null,'sys_user',null,'admin',null,'zhouyuan'),
('',null,'0',540479192903589888,'2124-06-26 10:31:21.000','张三','','0',null,null,null,null,'2024-06-26 10:31:21.000','',null,null,null,null,null,'admin','0',null,'','zhangsan',null,null,null,null,'$2a$10$V8mIow1zyamUz1C6D0DhjOc2kwYmw0bEvXGYIwxIPcFIRCsaywSQe',null,'sys_user',null,'admin',null,'zhangsan'),
('',null,'0',540479658387447808,'2124-06-26 10:33:12.000','李四','','0',null,null,null,null,'2024-06-26 10:33:12.000','',null,null,null,null,null,'admin','0',null,'','lisi',null,null,null,null,'$2a$10$AK.BqxrwkBqGuIy9Rrdu4OCope/N4UWDAe.RVjuvoMPnuXVs4HqqO',null,'sys_user',null,'admin',null,'lisi'),
('',null,'0',540480048742932480,'2124-06-26 10:34:45.000','王五','','0',null,null,null,null,'2024-06-26 10:34:45.000','',null,'2024-06-26 17:37:29.000',null,null,null,'wangwu','0',null,'192.168.9.14','wangwu',null,null,null,null,'$2a$10$5VnjjGdWhY33r72MDLgOkeOt8jj3lz9gT9FqsI25SaFoeeZviLjBq',null,'sys_user',null,'admin',null,'wangwu'),
('',null,'0',540480322421268480,'2124-06-26 10:35:51.000','苟六','','0',null,null,null,null,'2024-06-26 10:35:51.000','',null,null,null,null,null,'admin','0',null,'','gouliu',null,null,null,null,'$2a$10$4IIvnOE5tdBPqJOjv2cDpOy6MQqjHEUD6JZiPMehjfMcqjt8ucF4m',null,'sys_user',null,'admin',null,'gouliu'),
('',null,'0',549908993821253632,'2124-07-22 11:02:01.000','宋江','','0',null,null,null,null,'2024-07-22 11:02:01.000','',null,null,null,null,null,'admin','0',null,'','songjiang',null,null,null,null,'$2a$10$bdSFVEJk/aFZM4xVJ8T1fugQ7bzXy0v4L8p7bgOAE2GYnpw9vx86W',null,'sys_user',null,'admin',null,'songjiang'),
('',null,'0',550245387345207296,'2124-07-23 09:18:43.000','李逵','','0',null,null,null,null,'2024-07-23 09:18:43.000','',null,null,null,null,null,'admin','0',null,'','likui',null,null,null,null,'$2a$10$mW2tSpJTg2fkwz0VHKIhUemycrSpKS3iN0799ptxi/2xDuH40XEd.',null,'sys_user',null,'admin',null,'likui');


-- SYS_TOTAL_STATISTICS - 业务总数据统计
INSERT INTO "SECURE_PRODUCTING"."SYS_TOTAL_STATISTICS"("STATISTICS_TIME","STATISTICS_VALUE","STATISTICS_TYPE","ID","STATISTICS_NAME","CREATE_TIME","IS_DELETE") VALUES
('2024-08-08 17:30:00',7,3,548822481469841408,'累计登录数',1721358276211,0),
('2024-08-08 11:00:01',2101,4,548822511098404864,'累计登录数(历史)',1721358283275,0),
('2024-08-08 17:30:00',1,5,548824734184382464,'累计有效登录数',1721358813301,0),
('2024-08-08 11:00:01',388,6,548824753742422016,'累计有效登录数(历史)',1721358817963,0);

-- STATISTICS_USER_LOGIN - 统计-用户登录数量
INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(1,'2023-10-26','10','2023',548893510871425024,1698249600000,1721375209452,3,0),
(6,'2023-10-30','10','2023',548893538478333952,1698595200000,1721375216047,22,0),
(5,'2023-10-31','10','2023',548893549312221184,1698681600000,1721375218622,33,0),
(2,'2023-11-01','11','2023',548893560125136896,1698768000000,1721375221206,22,0),
(3,'2023-11-02','11','2023',548893570883526656,1698854400000,1721375223778,20,0),
(2,'2023-11-03','11','2023',548893581675470848,1698940800000,1721375226348,10,0),
(1,'2023-11-04','11','2023',548893592467415040,1699027200000,1721375228922,6,0),
(3,'2023-11-05','11','2023',548893603246776320,1699113600000,1721375231495,7,0),
(2,'2023-11-06','11','2023',548893614009360384,1699200000000,1721375234060,21,0),
(3,'2023-11-07','11','2023',548893624771944448,1699286400000,1721375236624,6,0),
(3,'2023-11-08','11','2023',548893635542917120,1699372800000,1721375239190,13,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(3,'2023-11-09','11','2023',548893646339055616,1699459200000,1721375241764,6,0),
(2,'2023-11-10','11','2023',548893657084862464,1699545600000,1721375244335,7,0),
(1,'2023-11-11','11','2023',548893667897778176,1699632000000,1721375246904,5,0),
(1,'2023-11-12','11','2023',548893678735859712,1699718400000,1721375249485,4,0),
(3,'2023-11-13','11','2023',548893689565552640,1699804800000,1721375252065,10,0),
(2,'2023-11-14','11','2023',548893700365885440,1699891200000,1721375254642,5,0),
(1,'2023-11-15','11','2023',548893711182995456,1699977600000,1721375257221,3,0),
(2,'2023-11-16','11','2023',548893722029465600,1700064000000,1721375259803,4,0),
(2,'2023-11-17','11','2023',548893732842381312,1700150400000,1721375262387,4,0),
(1,'2023-11-18','11','2023',548893743672074240,1700236800000,1721375264963,1,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(5,'2023-11-20','11','2023',548893759941779456,1700409600000,1721375268852,133,0),
(4,'2023-11-21','11','2023',548893770758889472,1700496000000,1721375271421,9,0),
(4,'2023-11-22','11','2023',548893781953486848,1700582400000,1721375274001,5,0),
(5,'2023-11-23','11','2023',548893792816734208,1700668800000,1721375276680,14,0),
(7,'2023-11-24','11','2023',548893804443344896,1700755200000,1721375279293,15,0),
(7,'2023-11-25','11','2023',548893815482753024,1700841600000,1721375282039,21,0),
(5,'2023-11-26','11','2023',548893826291474432,1700928000000,1721375284657,6,0),
(7,'2023-11-27','11','2023',548893839872630784,1701014400000,1721375287250,43,0),
(10,'2023-11-28','11','2023',548893851818008576,1701100800000,1721375290738,169,0),
(7,'2023-11-29','11','2023',548893862626729984,1701187200000,1721375293331,9,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(10,'2023-11-30','11','2023',548893873460617216,1701273600000,1721375295911,36,0),
(2,'2023-12-01','12','2023',548893884470665216,1701360000000,1721375298536,4,0),
(3,'2023-12-02','12','2023',548893895996612608,1701446400000,1721375301277,3,0),
(1,'2023-12-03','12','2023',548893906843082752,1701532800000,1721375303862,2,0),
(4,'2023-12-04','12','2023',548893917718913024,1701619200000,1721375306463,17,0),
(4,'2023-12-05','12','2023',548893928540217344,1701705600000,1721375309042,14,0),
(5,'2023-12-06','12','2023',548893939386687488,1701792000000,1721375311624,16,0),
(3,'2023-12-07','12','2023',548893951172681728,1701878400000,1721375314442,3,0),
(4,'2023-12-08','12','2023',548893961977208832,1701964800000,1721375317015,13,0),
(2,'2023-12-09','12','2023',548893972723015680,1702051200000,1721375319584,3,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(4,'2023-12-11','12','2023',548893988879474688,1702224000000,1721375323436,14,0),
(1,'2023-12-12','12','2023',548893999642058752,1702310400000,1721375326006,8,0),
(2,'2023-12-13','12','2023',548894010387865600,1702396800000,1721375328568,4,0),
(1,'2023-12-14','12','2023',548894021104312320,1702483200000,1721375331122,4,0),
(2,'2023-12-19','12','2023',548894053580808192,1702915200000,1721375338860,6,0),
(2,'2023-12-21','12','2023',548894069825347584,1703088000000,1721375342743,9,0),
(2,'2023-12-22','12','2023',548894080554377216,1703174400000,1721375345297,56,0),
(1,'2023-12-24','12','2023',548894096715030528,1703347200000,1721375349150,1,0),
(1,'2023-12-25','12','2023',548894107418894336,1703433600000,1721375351706,19,0),
(1,'2023-12-26','12','2023',548894118189867008,1703520000000,1721375354268,7,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(1,'2023-12-27','12','2023',548894128927285248,1703606400000,1721375356827,14,0),
(7,'2023-12-28','12','2023',548894139916361728,1703692800000,1721375359446,38,0),
(1,'2023-12-29','12','2023',548894151228399616,1703779200000,1721375362085,2,0),
(1,'2023-12-30','12','2023',548894161970012160,1703865600000,1721375364706,2,0),
(1,'2023-12-31','12','2023',548894172766150656,1703952000000,1721375367273,2,0),
(1,'2024-01-01','01','2024',548894183507763200,1704038400000,1721375369844,2,0),
(2,'2024-01-02','01','2024',548894194211627008,1704124800000,1721375372397,9,0),
(1,'2024-01-03','01','2024',548894204940656640,1704211200000,1721375374952,5,0),
(1,'2024-01-04','01','2024',548894215673880576,1704297600000,1721375377513,42,0),
(1,'2024-01-05','01','2024',548894226390327296,1704384000000,1721375380068,1,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(1,'2024-01-07','01','2024',548894242706169856,1704556800000,1721375383933,1,0),
(1,'2024-01-08','01','2024',548894253498114048,1704643200000,1721375386514,1,0),
(1,'2024-01-09','01','2024',548894264210366464,1704729600000,1721375389086,1,0),
(2,'2024-01-10','01','2024',548894275014893568,1704816000000,1721375391643,5,0),
(8,'2024-01-11','01','2024',548894285781671936,1704902400000,1721375394222,46,0),
(7,'2024-01-12','01','2024',548894296477147136,1704988800000,1721375396783,17,0),
(1,'2024-01-13','01','2024',548894307201982464,1705075200000,1721375399344,1,0),
(1,'2024-01-14','01','2024',548894317872291840,1705161600000,1721375401885,1,0),
(8,'2024-01-15','01','2024',548894328571961344,1705248000000,1721375404433,29,0),
(2,'2024-01-16','01','2024',548894339275825152,1705334400000,1721375406988,2,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(1,'2024-01-17','01','2024',548894349967106048,1705420800000,1721375409537,1,0),
(1,'2024-01-18','01','2024',548894360670969856,1705507200000,1721375412084,1,0),
(6,'2024-01-19','01','2024',548894371349667840,1705593600000,1721375414634,10,0),
(8,'2024-01-22','01','2024',548894392908390400,1705852800000,1721375419774,14,0),
(8,'2024-01-23','01','2024',548894403620642816,1705939200000,1721375422327,41,0),
(5,'2024-01-24','01','2024',548894414299340800,1706025600000,1721375424872,7,0),
(2,'2024-01-29','01','2024',548894447014912000,1706457600000,1721375432678,5,0),
(3,'2024-01-30','01','2024',548894457685221376,1706544000000,1721375435220,12,0),
(2,'2024-02-04','02','2024',548894490228826112,1706976000000,1721375442973,5,0),
(2,'2024-02-27','02','2024',548894620185141248,1708963200000,1721375473962,7,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(2,'2024-03-28','03','2024',548894788397703168,1711555200000,1721375514059,2,0),
(2,'2024-03-29','03','2024',548894799118344192,1711641600000,1721375516615,7,0),
(4,'2024-04-01','04','2024',548894820689649664,1711900800000,1721375521761,13,0),
(1,'2024-04-02','04','2024',548894831368347648,1711987200000,1721375524312,2,0),
(1,'2024-04-03','04','2024',548894842076405760,1712073600000,1721375526860,5,0),
(1,'2024-04-08','04','2024',548894874397712384,1712505600000,1721375534566,1,0),
(2,'2024-04-09','04','2024',548894885126742016,1712592000000,1721375537123,2,0),
(4,'2024-04-10','04','2024',548894895847383040,1712678400000,1721375539682,5,0),
(3,'2024-04-11','04','2024',548894906597384192,1712764800000,1721375542240,4,0),
(2,'2024-04-12','04','2024',548894917292859392,1712851200000,1721375544798,2,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(1,'2024-04-26','04','2024',548894998507167744,1714060800000,1721375564157,1,0),
(1,'2024-04-29','04','2024',548895020074278912,1714320000000,1721375569299,1,0),
(1,'2024-05-14','05','2024',548895120007766016,1715616000000,1721375593130,1,0),
(1,'2024-05-15','05','2024',548895130829070336,1715702400000,1721375595682,4,0),
(1,'2024-05-16','05','2024',548895141574877184,1715788800000,1721375598278,3,0),
(1,'2024-05-21','05','2024',548895174089121792,1716220800000,1721375606012,2,0),
(2,'2024-05-22','05','2024',548895185040449536,1716307200000,1721375608574,20,0),
(1,'2024-05-23','05','2024',548895195698176000,1716393600000,1721375611187,6,0),
(2,'2024-05-24','05','2024',548895206402039808,1716480000000,1721375613722,21,0),
(2,'2024-05-27','05','2024',548895227973345280,1716739200000,1721375618862,13,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(2,'2024-05-28','05','2024',548895238710763520,1716825600000,1721375621422,13,0),
(1,'2024-05-29','05','2024',548895249448181760,1716912000000,1721375623986,7,0),
(1,'2024-05-30','05','2024',548895260168822784,1716998400000,1721375626539,2,0),
(2,'2024-05-31','05','2024',548895270893658112,1717084800000,1721375629100,34,0),
(2,'2024-06-03','06','2024',548895292959891456,1717344000000,1721375634359,10,0),
(3,'2024-06-04','06','2024',548895303676338176,1717430400000,1721375636913,25,0),
(2,'2024-06-05','06','2024',548895314426339328,1717516800000,1721375639468,52,0),
(3,'2024-06-06','06','2024',548895325197312000,1717603200000,1721375642046,20,0),
(3,'2024-06-07','06','2024',548895335934730240,1717689600000,1721375644601,34,0),
(3,'2024-06-11','06','2024',548895363034128384,1718035200000,1721375651062,40,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(4,'2024-06-12','06','2024',548895373758963712,1718121600000,1721375653622,30,0),
(4,'2024-06-13','06','2024',548895384525742080,1718208000000,1721375656182,47,0),
(3,'2024-06-14','06','2024',548895395330269184,1718294400000,1721375658749,51,0),
(2,'2024-06-17','06','2024',548895417702686720,1718553600000,1721375664090,9,0),
(1,'2024-06-18','06','2024',548895428431716352,1718640000000,1721375666659,7,0),
(1,'2024-06-19','06','2024',548895439143968768,1718726400000,1721375669213,2,0),
(1,'2024-06-20','06','2024',548895449885581312,1718812800000,1721375671772,4,0),
(1,'2024-06-21','06','2024',548895460639776768,1718899200000,1721375674334,7,0),
(1,'2024-06-24','06','2024',548895482345299968,1719158400000,1721375679501,5,0),
(3,'2024-06-25','06','2024',548895493074329600,1719244800000,1721375682066,19,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(4,'2024-06-26','06','2024',548895503849496576,1719331200000,1721375684629,40,0),
(3,'2024-06-27','06','2024',548895514591109120,1719417600000,1721375687194,11,0),
(1,'2024-06-28','06','2024',548895525353693184,1719504000000,1721375689759,5,0),
(2,'2024-07-01','07','2024',548895547038244864,1719763200000,1721375694923,10,0),
(3,'2024-07-02','07','2024',548895557758885888,1719849600000,1721375697492,11,0),
(3,'2024-07-03','07','2024',548895568479526912,1719936000000,1721375700050,42,0),
(4,'2024-07-04','07','2024',548895579317608448,1720022400000,1721375702613,26,0),
(2,'2024-07-05','07','2024',548895590101164032,1720108800000,1721375705193,17,0),
(1,'2024-07-06','07','2024',548895600792444928,1720195200000,1721375707757,4,0),
(3,'2024-07-08','07','2024',548895616978264064,1720368000000,1721375711611,12,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(2,'2024-07-09','07','2024',548895627677933568,1720454400000,1721375714164,18,0),
(3,'2024-07-10','07','2024',548895638486654976,1720540800000,1721375716734,13,0),
(3,'2024-07-11','07','2024',548895649211490304,1720627200000,1721375719295,16,0),
(3,'2024-07-12','07','2024',548895659919548416,1720713600000,1721375721849,9,0),
(3,'2024-07-15','07','2024',548895681461493760,1720972800000,1721375726988,6,0),
(3,'2024-07-16','07','2024',548895692186329088,1721059200000,1721375729541,11,0),
(3,'2024-07-17','07','2024',548895702911164416,1721145600000,1721375732100,18,0),
(2,'2024-07-18','07','2024',548898881786748928,1721232000000,1721376478448,31,0),
(2,'2024-07-19','07','2024',549907120372457472,1721318400000,1721616874011,32,0),
(3,'2024-07-22','07','2024',550247294658813952,1721577600000,1721697977907,19,0);

INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
(1,'2024-08-05','08','2024',555397156446543872,1722787200000,1722925800396,2,0),
(3,'2024-08-06','08','2024',555746549083283456,1722873600000,1723009101177,13,0),
(1,'2024-08-07','08','2024',556069083871846400,1722960000000,1723086000366,3,0);