Startseite Erkunden Hilfe
Anmelden
SupplyChain
/
doc
2
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Struktur: 73551ba85a
Branches Tags
doc
/
DB
/
data
/
insert_alert.sql

insert_alert.sql 20 KB
Verlauf Originalformat

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798 
  1. # 时间:20211009 是否已发版: 测试- 是  生产-否
    2. 

  2. ALTER TABLE `zc_finance_record` ADD `zfr_reason` varchar(300) DEFAULT NULL COMMENT '拒绝放款理由';
    3. 

  3. 

  4. 

  5. ALTER TABLE `pay_acc_inf` ADD `pai_accno_name` varchar(300) DEFAULT NULL COMMENT '账户名称';
    6. 

  6. ALTER TABLE `pay_acc_inf` ADD `pai_bank_name` varchar(300) DEFAULT NULL COMMENT '银行名称';
    7. 

  7. ALTER TABLE `pay_acc_detail` ADD `PAD_STATE` varchar(2) DEFAULT NULL COMMENT '状态（00：交易中 01：成功 02：失败）';
    8. 

  8. ALTER TABLE `pay_acc_detail` ADD `pad_business_id` varchar(64) DEFAULT NULL COMMENT '业务表主键';
    9. 

  9. ALTER TABLE `pay_acc_detail` ADD `pad_tar_count` varchar(64) DEFAULT NULL COMMENT '交易查询次数';
    10. 

  10. ALTER TABLE `pay_acc_detail` ADD `pad_pay_count` varchar(64) DEFAULT NULL COMMENT '转账查询次数';
    11. 

  11. 

  12. # 时间:20211012 是否已发版: 测试- 是  生产-否
    13. 

  13. UPDATE sys_menu SET parent_id = '0',order_num = '3' WHERE menu_id = '2517';
    14. 

  14. UPDATE sys_menu SET parent_id = '0',order_num = '4',path = 'Bill/creditLine' WHERE menu_id = '2530';
    15. 

  15. UPDATE sys_menu SET parent_id = '0',order_num = '5', path = 'Bill/Bill' WHERE menu_id = '2518';
    16. 

  16. UPDATE sys_menu SET parent_id = '0',order_num = '6' WHERE menu_id = '2528';
    17. 

  17. UPDATE sys_menu SET parent_id = '0',order_num = '7', path = 'Bill/contract' WHERE menu_id = '2544';
    18. 

  18. UPDATE sys_menu SET parent_id = '0',order_num = '8' WHERE menu_id = '2546';
    19. 

  19. UPDATE sys_menu SET parent_id = '0',order_num = '9' WHERE menu_id = '2575';
    20. 

  20. UPDATE sys_menu SET parent_id = '0',order_num = '10', path = 'Bill/rel' WHERE menu_id = '2536';
    21. 

  21. UPDATE sys_menu SET parent_id = '0',order_num = '11' WHERE menu_id = '2591';
    22. 

  22. UPDATE sys_menu SET parent_id = '0',order_num = '12',path = 'Bill/costManage' WHERE menu_id = '2576';
    23. 

  23. 

  24. # 时间:20211013 是否已发版: 测试- 是  生产-否
    25. 

  25. delete from sys_company where scy_id = '000000';
    26. 

  26. insert into `sys_company` (`scy_id`, `scy_license_file`, `scy_name`, `scy_social_code`, `scy_registered_capital`, `scy_start_time`, `scy_end_time`, `scy_address`, `scy_phone`, `scy_legal_file`, `scy_legal_back_file`, `scy_legal`, `scy_legal_id`, `scy_authorization_file`, `scy_commitment_file`, `scy_appendix_file`, `scy_type`, `scy_industry`, `scy_scale`, `scy_organization`, `scy_manager`, `scy_cfca_user_id`, `scy_cfca_auth_number`, `scy_cfca_bank_time`, `scy_remarks`, `scy_auth_status`, `scy_status`, `create_by`, `create_time`, `update_by`, `update_time`, `scy_contract_id`) values('000000',NULL,'招采云链（山东）信息服务有限公司','','无','','无','中国（山东）自由贸易试验区济南片区汉峪金谷A3-1-1401','18810133746',NULL,NULL,'丛美红','210282198912038724',NULL,NULL,NULL,'00',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'01','00',NULL,NULL,NULL,NULL,NULL);
    27. 

  27. 

  28. 

  29. UPDATE sys_user SET email = 'congmeihong@zcylian.com' WHERE user_id = '1' 
    30. 

  30. 

  31. insert into `pay_acc_inf` (`PAI_CSTNO`, `PAI_ACCNO`, `PAI_VERSION`, `PAI_STATUS`, `PAI_BALANCE`, `PAI_AVABALANCE`, `PAI_ACCTYPE`, `PAI_CRYTYPE`, `PAI_QLBANKNO`, `PAI_QLBANKNAME`, `create_by`, `create_time`, `update_by`, `update_time`, `pai_accno_name`, `pai_bank_name`) values('000000','3115730025233104147','1','2','0.00','0.00','07','CNY','302','中信银行',NULL,'2021-10-09 15:07:55',NULL,NULL,'招采云链（山东）信息服务有限公司','中信银行');
    32. 

  32. insert into `pay_acc_inf` (`PAI_CSTNO`, `PAI_ACCNO`, `PAI_VERSION`, `PAI_STATUS`, `PAI_BALANCE`, `PAI_AVABALANCE`, `PAI_ACCTYPE`, `PAI_CRYTYPE`, `PAI_QLBANKNO`, `PAI_QLBANKNAME`, `create_by`, `create_time`, `update_by`, `update_time`, `pai_accno_name`, `pai_bank_name`) values('000000','3115730025233104148','1','2','0.00','0.00','09','CNY','302','中信银行',NULL,'2021-10-09 15:07:55',NULL,NULL,'招采云链（山东）信息服务有限公司','中信银行');
    33. 

  33. insert into `pay_acc_inf` (`PAI_CSTNO`, `PAI_ACCNO`, `PAI_VERSION`, `PAI_STATUS`, `PAI_BALANCE`, `PAI_AVABALANCE`, `PAI_ACCTYPE`, `PAI_CRYTYPE`, `PAI_QLBANKNO`, `PAI_QLBANKNAME`, `create_by`, `create_time`, `update_by`, `update_time`, `pai_accno_name`, `pai_bank_name`) values('000000','3115730025230000214','1','2','0.00','0.00','06','CNY','302','中信银行',NULL,'2021-10-09 15:07:55',NULL,NULL,'招采云链（山东）信息服务有限公司','中信银行');
    34. 

  34. 

  35. # 时间:20211018 是否已发版: 测试- 是  生产-否
    36. 

  36. UPDATE sys_menu SET parent_id = '0',order_num = '3', path = 'Bill/repayment' WHERE menu_id = '2567';
    37. 

  37. UPDATE sys_menu SET parent_id = '0',order_num = '4', path = 'Bill/financeRecord' WHERE menu_id = '2569';
    38. 

  38. UPDATE sys_menu SET parent_id = '6',order_num = '2' WHERE menu_id = '2652';
    39. 

  39. UPDATE sys_menu SET parent_id = '6',order_num = '3' WHERE menu_id = '2648';
    40. 

  40. UPDATE sys_menu SET parent_id = '6',order_num = '4' WHERE menu_id = '2650';
    41. 

  41. UPDATE sys_menu SET parent_id = '6',order_num = '5' WHERE menu_id = '2649';
    42. 

  42. UPDATE sys_menu SET parent_id = '6',order_num = '6' WHERE menu_id = '2521';
    43. 

  43. DELETE FROM sys_menu WHERE menu_id = '2647';
    44. 

  44. 

  45. # 时间:20211020 是否已发版: 测试- 是  生产-否
    46. 

  46. # 账户历史信息交易状态
    47. 

  47. insert into `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('302','账户历史信息交易状态','pay_PAD_STATE','0','admin','2021-10-19 11:03:07','',NULL,NULL);
    48. 

  48. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('729','0','交易中','00','pay_PAD_STATE',NULL,NULL,'N','0','admin','2021-10-19 11:04:01','',NULL,NULL);
    49. 

  49. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('730','1','交易成功','01','pay_PAD_STATE',NULL,NULL,'N','0','admin','2021-10-19 11:04:29','',NULL,NULL);
    50. 

  50. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('731','2','交易失败','02','pay_PAD_STATE',NULL,NULL,'N','0','admin','2021-10-19 11:04:46','',NULL,NULL);
    51. 

  51. 

  52. # 账户历史信息交易用途
    53. 

  53. insert into `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('303','账户历史信息交易用途','pay_PAD_TRANTYPE','0','admin','2021-10-19 11:05:46','',NULL,NULL);
    54. 

  54. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('732','1','充值(CZ)','00','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:06:23','',NULL,NULL);
    55. 

  55. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('733','1','支付(ZF)','10','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:06:46','',NULL,NULL);
    56. 

  56. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('734','2','转账(ZZ)','20','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:07:10','',NULL,NULL);
    57. 

  57. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('735','3','退款(TK)','30','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:07:32','',NULL,NULL);
    58. 

  58. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('736','4','退款到银行卡','31','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:07:52','',NULL,NULL);
    59. 

  59. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('737','5','退卡','3A','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:08:11','',NULL,NULL);
    60. 

  60. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('738','6','预付卡充值','40','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:08:31','',NULL,NULL);
    61. 

  61. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('739','7','消费','41','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:08:50','',NULL,NULL);
    62. 

  62. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('740','8','消费撤销','42','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:09:06','',NULL,NULL);
    63. 

  63. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('741','9','消费冲正','43','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:09:23','',NULL,NULL);
    64. 

  64. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('742','10','消费撤销冲正','44','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:09:57','',NULL,NULL);
    65. 

  65. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('743','11','余额查询','50','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:10:36','',NULL,NULL);
    66. 

  66. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('744','12','提现(TX)','60','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:10:57','',NULL,NULL);
    67. 

  67. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('745','13','结算(JS)','70','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:11:33','',NULL,NULL);
    68. 

  68. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('746','14','银行结算','71','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:11:51','',NULL,NULL);
    69. 

  69. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('747','15','POS结算','72','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:12:12','',NULL,NULL);
    70. 

  70. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('748','16','批上送','73','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:12:31','',NULL,NULL);
    71. 

  71. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('749','17','手续费pos','80','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:12:46','',NULL,NULL);
    72. 

  72. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('750','18','个人调账','90','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:13:01','',NULL,NULL);
    73. 

  73. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('751','19','卡调账','91','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:13:18','',NULL,NULL);
    74. 

  74. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('752','20','商户调账','92','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:13:36','',NULL,NULL);
    75. 

  75. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('753','21','pos终端调账','93','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:13:58','',NULL,NULL);
    76. 

  76. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('754','22','平台调账','94','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:14:20','',NULL,NULL);
    77. 

  77. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('755','23','银行账户调账','95','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:14:33','',NULL,NULL);
    78. 

  78. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('756','24','提现失败','96','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:14:49','',NULL,NULL);
    79. 

  79. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('757','25','签到','S0','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:15:10','',NULL,NULL);
    80. 

  80. insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('758','26','签退','S1','pay_PAD_TRANTYPE',NULL,NULL,'N','0','admin','2021-10-19 11:15:29','',NULL,NULL);
    81. 

  81. 

  82. # 账户管理
    83. 

  83. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2655','账户管理','11','11','account','system/accInf/accInf','1','0','C','0','0','accInf:accInf:list','#','admin','2021-10-19 10:33:43','',NULL,'','0','','');
    84. 

  84. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2656','添加对公账户','2655','1','',NULL,'1','0','F','0','0','accInf:accInf:add','#','admin','2021-10-19 10:34:47','',NULL,'','0','','');
    85. 

  85. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2657','修改','2655','2','',NULL,'1','0','F','0','0','accInf:accInf:edit','#','admin','2021-10-19 10:35:31','',NULL,'','0','','');
    86. 

  86. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2658','删除','2655','3','',NULL,'1','0','F','0','0','accInf:accInf:delete','#','admin','2021-10-19 10:36:00','',NULL,'','0','','');
    87. 

  87. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2663','提现','2655','4','',NULL,'1','0','F','0','0','user:wthdrawal:add','#','admin','2021-10-20 14:59:35','',NULL,'','0','','');
    88. 

  88. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2664','充值','2655','5','',NULL,'1','0','F','0','0',NULL,'#','admin','2021-10-20 15:00:02','',NULL,'','0','','');
    89. 

  89. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2665','交易明细','2655','6','',NULL,'1','0','F','0','0',NULL,'#','admin','2021-10-20 15:00:19','',NULL,'','0','','');
    90. 

  90. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2666','交易明细详情','2655','7','',NULL,'1','0','F','0','0',NULL,'#','admin','2021-10-20 15:01:18','',NULL,'','0','','');
    91. 

  91. 

  92. # 平台账户管理
    93. 

  93. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2659','平台账户管理','11','12','adminAccount','system/adminAccInf/adminAccInf','1','0','C','0','0','admin:accInf:list','#','admin','2021-10-19 10:37:33','',NULL,'','0','','');
    94. 

  94. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2662','添加虚拟账户','2659','1','',NULL,'1','0','F','0','0',NULL,'#','admin','2021-10-20 14:58:29','',NULL,'','0','','');
    95. 

  95. 

  96. # 账单管理
    97. 

  97. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2660','账单管理','11','13','accDetail','system/accDetail/accDetail','1','0','C','0','0','acc:detail:list','#','admin','2021-10-19 10:39:09','',NULL,'','0','','');
    98. 

  98. insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2661','详情','2660','1','',NULL,'1','0','F','0','0','acc:detail:query','#','admin','2021-10-19 10:39:42','',NULL,'','0','','');
    99.