init-data.sql 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254
  1. -- QUARTZ_TASK_INFO - 定时任务信息表
  2. 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
  3. ('1','清理任务调度日志','',0,'',0,'T548502417961000960',0,1,1721281967117,'clearQuartzLog',548502417961000960,1721281967117,'{
  4. "keepDays": 15
  5. }','0 0 1 * * ?'),
  6. ('1','用户登录数量统计','',0,'',0,'T550315534424612864',0,1,1721714247759,'userLoginStatistics',550315534424612864,1721714247759,'','0 0/5 * * * ?');
  7. -- SYS_MENU - 菜单权限表
  8. 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
  9. ('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','系统设置',''),
  10. ('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','参数设置',''),
  11. ('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','操作日志',''),
  12. ('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','菜单管理',''),
  13. ('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','数据字典',''),
  14. ('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','用户管理',''),
  15. ('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','角色管理',''),
  16. ('policy',1,'M',99,null,'admin',null,null,1797929126859235330,0,0,0,'0','0','admin',null,'#','2024-06-04 17:51:22.000','政策法规',''),
  17. ('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','政策法规分类',''),
  18. ('index',1,'C',2,'SYSTEM_ADMIN','admin',null,'',1797929901077422082,0,0,1797929126859235330,'0','0','admin','policy/index','#','2024-06-04 17:54:27.000','政策法规信息',''),
  19. ('index',1,'C',10,'','admin',null,null,1798596518526341121,0,0,0,'1','0','admin','index','server','2024-06-06 14:03:21.000','首页','');
  20. 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
  21. ('job',1,'M',70,null,'admin',null,null,1812787847363678210,0,0,0,'0','0','admin',null,'#','2024-07-15 17:54:37.000','任务调度',''),
  22. ('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','定时任务',''),
  23. ('monitor',1,'M',1,null,'admin',null,null,1813493086597275650,0,0,0,'0','0','admin','','monitor','2024-07-17 16:37:00.000','系统监控',''),
  24. ('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','服务监控',''),
  25. ('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','在线用户',''),
  26. ('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','登录日志',''),
  27. ('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','用户数据统计',''),
  28. ('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);
  29. -- SYS_USER - 用户信息表
  30. 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
  31. ('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),
  32. ('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),
  33. ('',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),
  34. ('',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),
  35. ('',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'),
  36. ('',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'),
  37. ('',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'),
  38. ('',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'),
  39. ('',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'),
  40. ('',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'),
  41. ('',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');
  42. 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
  43. ('',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),
  44. ('',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'),
  45. ('',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'),
  46. ('',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'),
  47. ('',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'),
  48. ('',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'),
  49. ('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'),
  50. ('',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'),
  51. ('',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'),
  52. ('',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');
  53. 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
  54. ('',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'),
  55. ('',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'),
  56. ('',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'),
  57. ('',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'),
  58. ('',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'),
  59. ('',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'),
  60. ('',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'),
  61. ('',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'),
  62. ('',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');
  63. -- SYS_TOTAL_STATISTICS - 业务总数据统计
  64. INSERT INTO "SECURE_PRODUCTING"."SYS_TOTAL_STATISTICS"("STATISTICS_TIME","STATISTICS_VALUE","STATISTICS_TYPE","ID","STATISTICS_NAME","CREATE_TIME","IS_DELETE") VALUES
  65. ('2024-08-08 17:30:00',7,3,548822481469841408,'累计登录数',1721358276211,0),
  66. ('2024-08-08 11:00:01',2101,4,548822511098404864,'累计登录数(历史)',1721358283275,0),
  67. ('2024-08-08 17:30:00',1,5,548824734184382464,'累计有效登录数',1721358813301,0),
  68. ('2024-08-08 11:00:01',388,6,548824753742422016,'累计有效登录数(历史)',1721358817963,0);
  69. -- STATISTICS_USER_LOGIN - 统计-用户登录数量
  70. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  71. (1,'2023-10-26','10','2023',548893510871425024,1698249600000,1721375209452,3,0),
  72. (6,'2023-10-30','10','2023',548893538478333952,1698595200000,1721375216047,22,0),
  73. (5,'2023-10-31','10','2023',548893549312221184,1698681600000,1721375218622,33,0),
  74. (2,'2023-11-01','11','2023',548893560125136896,1698768000000,1721375221206,22,0),
  75. (3,'2023-11-02','11','2023',548893570883526656,1698854400000,1721375223778,20,0),
  76. (2,'2023-11-03','11','2023',548893581675470848,1698940800000,1721375226348,10,0),
  77. (1,'2023-11-04','11','2023',548893592467415040,1699027200000,1721375228922,6,0),
  78. (3,'2023-11-05','11','2023',548893603246776320,1699113600000,1721375231495,7,0),
  79. (2,'2023-11-06','11','2023',548893614009360384,1699200000000,1721375234060,21,0),
  80. (3,'2023-11-07','11','2023',548893624771944448,1699286400000,1721375236624,6,0),
  81. (3,'2023-11-08','11','2023',548893635542917120,1699372800000,1721375239190,13,0);
  82. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  83. (3,'2023-11-09','11','2023',548893646339055616,1699459200000,1721375241764,6,0),
  84. (2,'2023-11-10','11','2023',548893657084862464,1699545600000,1721375244335,7,0),
  85. (1,'2023-11-11','11','2023',548893667897778176,1699632000000,1721375246904,5,0),
  86. (1,'2023-11-12','11','2023',548893678735859712,1699718400000,1721375249485,4,0),
  87. (3,'2023-11-13','11','2023',548893689565552640,1699804800000,1721375252065,10,0),
  88. (2,'2023-11-14','11','2023',548893700365885440,1699891200000,1721375254642,5,0),
  89. (1,'2023-11-15','11','2023',548893711182995456,1699977600000,1721375257221,3,0),
  90. (2,'2023-11-16','11','2023',548893722029465600,1700064000000,1721375259803,4,0),
  91. (2,'2023-11-17','11','2023',548893732842381312,1700150400000,1721375262387,4,0),
  92. (1,'2023-11-18','11','2023',548893743672074240,1700236800000,1721375264963,1,0);
  93. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  94. (5,'2023-11-20','11','2023',548893759941779456,1700409600000,1721375268852,133,0),
  95. (4,'2023-11-21','11','2023',548893770758889472,1700496000000,1721375271421,9,0),
  96. (4,'2023-11-22','11','2023',548893781953486848,1700582400000,1721375274001,5,0),
  97. (5,'2023-11-23','11','2023',548893792816734208,1700668800000,1721375276680,14,0),
  98. (7,'2023-11-24','11','2023',548893804443344896,1700755200000,1721375279293,15,0),
  99. (7,'2023-11-25','11','2023',548893815482753024,1700841600000,1721375282039,21,0),
  100. (5,'2023-11-26','11','2023',548893826291474432,1700928000000,1721375284657,6,0),
  101. (7,'2023-11-27','11','2023',548893839872630784,1701014400000,1721375287250,43,0),
  102. (10,'2023-11-28','11','2023',548893851818008576,1701100800000,1721375290738,169,0),
  103. (7,'2023-11-29','11','2023',548893862626729984,1701187200000,1721375293331,9,0);
  104. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  105. (10,'2023-11-30','11','2023',548893873460617216,1701273600000,1721375295911,36,0),
  106. (2,'2023-12-01','12','2023',548893884470665216,1701360000000,1721375298536,4,0),
  107. (3,'2023-12-02','12','2023',548893895996612608,1701446400000,1721375301277,3,0),
  108. (1,'2023-12-03','12','2023',548893906843082752,1701532800000,1721375303862,2,0),
  109. (4,'2023-12-04','12','2023',548893917718913024,1701619200000,1721375306463,17,0),
  110. (4,'2023-12-05','12','2023',548893928540217344,1701705600000,1721375309042,14,0),
  111. (5,'2023-12-06','12','2023',548893939386687488,1701792000000,1721375311624,16,0),
  112. (3,'2023-12-07','12','2023',548893951172681728,1701878400000,1721375314442,3,0),
  113. (4,'2023-12-08','12','2023',548893961977208832,1701964800000,1721375317015,13,0),
  114. (2,'2023-12-09','12','2023',548893972723015680,1702051200000,1721375319584,3,0);
  115. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  116. (4,'2023-12-11','12','2023',548893988879474688,1702224000000,1721375323436,14,0),
  117. (1,'2023-12-12','12','2023',548893999642058752,1702310400000,1721375326006,8,0),
  118. (2,'2023-12-13','12','2023',548894010387865600,1702396800000,1721375328568,4,0),
  119. (1,'2023-12-14','12','2023',548894021104312320,1702483200000,1721375331122,4,0),
  120. (2,'2023-12-19','12','2023',548894053580808192,1702915200000,1721375338860,6,0),
  121. (2,'2023-12-21','12','2023',548894069825347584,1703088000000,1721375342743,9,0),
  122. (2,'2023-12-22','12','2023',548894080554377216,1703174400000,1721375345297,56,0),
  123. (1,'2023-12-24','12','2023',548894096715030528,1703347200000,1721375349150,1,0),
  124. (1,'2023-12-25','12','2023',548894107418894336,1703433600000,1721375351706,19,0),
  125. (1,'2023-12-26','12','2023',548894118189867008,1703520000000,1721375354268,7,0);
  126. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  127. (1,'2023-12-27','12','2023',548894128927285248,1703606400000,1721375356827,14,0),
  128. (7,'2023-12-28','12','2023',548894139916361728,1703692800000,1721375359446,38,0),
  129. (1,'2023-12-29','12','2023',548894151228399616,1703779200000,1721375362085,2,0),
  130. (1,'2023-12-30','12','2023',548894161970012160,1703865600000,1721375364706,2,0),
  131. (1,'2023-12-31','12','2023',548894172766150656,1703952000000,1721375367273,2,0),
  132. (1,'2024-01-01','01','2024',548894183507763200,1704038400000,1721375369844,2,0),
  133. (2,'2024-01-02','01','2024',548894194211627008,1704124800000,1721375372397,9,0),
  134. (1,'2024-01-03','01','2024',548894204940656640,1704211200000,1721375374952,5,0),
  135. (1,'2024-01-04','01','2024',548894215673880576,1704297600000,1721375377513,42,0),
  136. (1,'2024-01-05','01','2024',548894226390327296,1704384000000,1721375380068,1,0);
  137. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  138. (1,'2024-01-07','01','2024',548894242706169856,1704556800000,1721375383933,1,0),
  139. (1,'2024-01-08','01','2024',548894253498114048,1704643200000,1721375386514,1,0),
  140. (1,'2024-01-09','01','2024',548894264210366464,1704729600000,1721375389086,1,0),
  141. (2,'2024-01-10','01','2024',548894275014893568,1704816000000,1721375391643,5,0),
  142. (8,'2024-01-11','01','2024',548894285781671936,1704902400000,1721375394222,46,0),
  143. (7,'2024-01-12','01','2024',548894296477147136,1704988800000,1721375396783,17,0),
  144. (1,'2024-01-13','01','2024',548894307201982464,1705075200000,1721375399344,1,0),
  145. (1,'2024-01-14','01','2024',548894317872291840,1705161600000,1721375401885,1,0),
  146. (8,'2024-01-15','01','2024',548894328571961344,1705248000000,1721375404433,29,0),
  147. (2,'2024-01-16','01','2024',548894339275825152,1705334400000,1721375406988,2,0);
  148. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  149. (1,'2024-01-17','01','2024',548894349967106048,1705420800000,1721375409537,1,0),
  150. (1,'2024-01-18','01','2024',548894360670969856,1705507200000,1721375412084,1,0),
  151. (6,'2024-01-19','01','2024',548894371349667840,1705593600000,1721375414634,10,0),
  152. (8,'2024-01-22','01','2024',548894392908390400,1705852800000,1721375419774,14,0),
  153. (8,'2024-01-23','01','2024',548894403620642816,1705939200000,1721375422327,41,0),
  154. (5,'2024-01-24','01','2024',548894414299340800,1706025600000,1721375424872,7,0),
  155. (2,'2024-01-29','01','2024',548894447014912000,1706457600000,1721375432678,5,0),
  156. (3,'2024-01-30','01','2024',548894457685221376,1706544000000,1721375435220,12,0),
  157. (2,'2024-02-04','02','2024',548894490228826112,1706976000000,1721375442973,5,0),
  158. (2,'2024-02-27','02','2024',548894620185141248,1708963200000,1721375473962,7,0);
  159. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  160. (2,'2024-03-28','03','2024',548894788397703168,1711555200000,1721375514059,2,0),
  161. (2,'2024-03-29','03','2024',548894799118344192,1711641600000,1721375516615,7,0),
  162. (4,'2024-04-01','04','2024',548894820689649664,1711900800000,1721375521761,13,0),
  163. (1,'2024-04-02','04','2024',548894831368347648,1711987200000,1721375524312,2,0),
  164. (1,'2024-04-03','04','2024',548894842076405760,1712073600000,1721375526860,5,0),
  165. (1,'2024-04-08','04','2024',548894874397712384,1712505600000,1721375534566,1,0),
  166. (2,'2024-04-09','04','2024',548894885126742016,1712592000000,1721375537123,2,0),
  167. (4,'2024-04-10','04','2024',548894895847383040,1712678400000,1721375539682,5,0),
  168. (3,'2024-04-11','04','2024',548894906597384192,1712764800000,1721375542240,4,0),
  169. (2,'2024-04-12','04','2024',548894917292859392,1712851200000,1721375544798,2,0);
  170. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  171. (1,'2024-04-26','04','2024',548894998507167744,1714060800000,1721375564157,1,0),
  172. (1,'2024-04-29','04','2024',548895020074278912,1714320000000,1721375569299,1,0),
  173. (1,'2024-05-14','05','2024',548895120007766016,1715616000000,1721375593130,1,0),
  174. (1,'2024-05-15','05','2024',548895130829070336,1715702400000,1721375595682,4,0),
  175. (1,'2024-05-16','05','2024',548895141574877184,1715788800000,1721375598278,3,0),
  176. (1,'2024-05-21','05','2024',548895174089121792,1716220800000,1721375606012,2,0),
  177. (2,'2024-05-22','05','2024',548895185040449536,1716307200000,1721375608574,20,0),
  178. (1,'2024-05-23','05','2024',548895195698176000,1716393600000,1721375611187,6,0),
  179. (2,'2024-05-24','05','2024',548895206402039808,1716480000000,1721375613722,21,0),
  180. (2,'2024-05-27','05','2024',548895227973345280,1716739200000,1721375618862,13,0);
  181. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  182. (2,'2024-05-28','05','2024',548895238710763520,1716825600000,1721375621422,13,0),
  183. (1,'2024-05-29','05','2024',548895249448181760,1716912000000,1721375623986,7,0),
  184. (1,'2024-05-30','05','2024',548895260168822784,1716998400000,1721375626539,2,0),
  185. (2,'2024-05-31','05','2024',548895270893658112,1717084800000,1721375629100,34,0),
  186. (2,'2024-06-03','06','2024',548895292959891456,1717344000000,1721375634359,10,0),
  187. (3,'2024-06-04','06','2024',548895303676338176,1717430400000,1721375636913,25,0),
  188. (2,'2024-06-05','06','2024',548895314426339328,1717516800000,1721375639468,52,0),
  189. (3,'2024-06-06','06','2024',548895325197312000,1717603200000,1721375642046,20,0),
  190. (3,'2024-06-07','06','2024',548895335934730240,1717689600000,1721375644601,34,0),
  191. (3,'2024-06-11','06','2024',548895363034128384,1718035200000,1721375651062,40,0);
  192. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  193. (4,'2024-06-12','06','2024',548895373758963712,1718121600000,1721375653622,30,0),
  194. (4,'2024-06-13','06','2024',548895384525742080,1718208000000,1721375656182,47,0),
  195. (3,'2024-06-14','06','2024',548895395330269184,1718294400000,1721375658749,51,0),
  196. (2,'2024-06-17','06','2024',548895417702686720,1718553600000,1721375664090,9,0),
  197. (1,'2024-06-18','06','2024',548895428431716352,1718640000000,1721375666659,7,0),
  198. (1,'2024-06-19','06','2024',548895439143968768,1718726400000,1721375669213,2,0),
  199. (1,'2024-06-20','06','2024',548895449885581312,1718812800000,1721375671772,4,0),
  200. (1,'2024-06-21','06','2024',548895460639776768,1718899200000,1721375674334,7,0),
  201. (1,'2024-06-24','06','2024',548895482345299968,1719158400000,1721375679501,5,0),
  202. (3,'2024-06-25','06','2024',548895493074329600,1719244800000,1721375682066,19,0);
  203. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  204. (4,'2024-06-26','06','2024',548895503849496576,1719331200000,1721375684629,40,0),
  205. (3,'2024-06-27','06','2024',548895514591109120,1719417600000,1721375687194,11,0),
  206. (1,'2024-06-28','06','2024',548895525353693184,1719504000000,1721375689759,5,0),
  207. (2,'2024-07-01','07','2024',548895547038244864,1719763200000,1721375694923,10,0),
  208. (3,'2024-07-02','07','2024',548895557758885888,1719849600000,1721375697492,11,0),
  209. (3,'2024-07-03','07','2024',548895568479526912,1719936000000,1721375700050,42,0),
  210. (4,'2024-07-04','07','2024',548895579317608448,1720022400000,1721375702613,26,0),
  211. (2,'2024-07-05','07','2024',548895590101164032,1720108800000,1721375705193,17,0),
  212. (1,'2024-07-06','07','2024',548895600792444928,1720195200000,1721375707757,4,0),
  213. (3,'2024-07-08','07','2024',548895616978264064,1720368000000,1721375711611,12,0);
  214. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  215. (2,'2024-07-09','07','2024',548895627677933568,1720454400000,1721375714164,18,0),
  216. (3,'2024-07-10','07','2024',548895638486654976,1720540800000,1721375716734,13,0),
  217. (3,'2024-07-11','07','2024',548895649211490304,1720627200000,1721375719295,16,0),
  218. (3,'2024-07-12','07','2024',548895659919548416,1720713600000,1721375721849,9,0),
  219. (3,'2024-07-15','07','2024',548895681461493760,1720972800000,1721375726988,6,0),
  220. (3,'2024-07-16','07','2024',548895692186329088,1721059200000,1721375729541,11,0),
  221. (3,'2024-07-17','07','2024',548895702911164416,1721145600000,1721375732100,18,0),
  222. (2,'2024-07-18','07','2024',548898881786748928,1721232000000,1721376478448,31,0),
  223. (2,'2024-07-19','07','2024',549907120372457472,1721318400000,1721616874011,32,0),
  224. (3,'2024-07-22','07','2024',550247294658813952,1721577600000,1721697977907,19,0);
  225. INSERT INTO "SECURE_PRODUCTING"."STATISTICS_USER_LOGIN"("LOGIN_COUNT_DISTINCT","DATE","MONTH","YEAR","ID","DATE_TIME","CREATE_TIME","LOGIN_COUNT","IS_DELETE") VALUES
  226. (1,'2024-08-05','08','2024',555397156446543872,1722787200000,1722925800396,2,0),
  227. (3,'2024-08-06','08','2024',555746549083283456,1722873600000,1723009101177,13,0),
  228. (1,'2024-08-07','08','2024',556069083871846400,1722960000000,1723086000366,3,0);