20 lines
1.5 KiB
SQL
20 lines
1.5 KiB
SQL
--平安银行软负载初始化SQL
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL)
|
|
values ('PAB', '001', null, null, 'url=192.168.80.14&&port=6300', ' ', 'S', null, 'PAB_CHECK_HEART', 'S', '192.168.80.14');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL)
|
|
values ('PAB', '002', null, null, 'url=192.168.80.15&&port=6300', ' ', 'S', null, 'PAB_CHECK_HEART', 'S', '192.168.80.15');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL)
|
|
values ('PAB', '003', null, null, 'url=192.168.80.45&&port=6300', ' ', 'S', null, 'PAB_CHECK_HEART', 'S', '192.168.80.45');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL)
|
|
values ('PAB', '004', null, null, 'url=192.168.80.46&&port=6300', ' ', 'S', null, 'PAB_CHECK_HEART', 'S', '192.168.80.46');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL)
|
|
values ('PAB', '005', null, null, 'url=192.168.80.55&&port=6300', ' ', 'S', null, 'PAB_CHECK_HEART', 'S', '192.168.80.55');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL)
|
|
values ('PAB', '006', null, null, 'url=192.168.80.56&&port=6300', ' ', 'S', null, 'PAB_CHECK_HEART', 'S', '192.168.80.56');
|
|
|