MWCONFIG_INITDB_DUMMY_REST.sql 2.4 KB

12345678910111213141516171819202122232425262728293031323334
  1. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('res-dummy.vaccount-btn-service', NULL, '[drs]', CURRENT USER, CURRENT TIMESTAMP);
  2. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  3. VALUES
  4. ('res-dummy.vaccount-btn-service', 1, '/Data', '/Data/response', NULL, NULL),
  5. ('res-dummy.vaccount-btn-service', 2, '/Data', '/Data/response/data', NULL, NULL);
  6. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
  7. VALUES
  8. ('res-dummy.vaccount-btn-service', 1, 'cnl','cnl', null),
  9. ('res-dummy.vaccount-btn-service', 1, 'tno','tno', null),
  10. ('res-dummy.vaccount-btn-service', 1, 'procode','procode', null),
  11. ('res-dummy.vaccount-btn-service', 1, 'iss','iss', null),
  12. ('res-dummy.vaccount-btn-service', 1, 'mid','mid', null),
  13. ('res-dummy.vaccount-btn-service', 1, 'exp_iso8601','exp_iso8601', null),
  14. ('res-dummy.vaccount-btn-service', 1, 'bic','bic', null),
  15. ('res-dummy.vaccount-btn-service', 1, 'iat','iat', null),
  16. ('res-dummy.vaccount-btn-service', 1, 'jti','jti', null),
  17. ('res-dummy.vaccount-btn-service', 1, 'tid','tid', null),
  18. ('res-dummy.vaccount-btn-service', 2, 'accNameFrom', 'accNameFrom', null),
  19. ('res-dummy.vaccount-btn-service', 2, 'accPoolingFrom', 'accPoolingFrom', null),
  20. ('res-dummy.vaccount-btn-service', 2, 'accPoolingNameFrom', 'accPoolingNameFrom', null),
  21. ('res-dummy.vaccount-btn-service', 2, 'balanceFrom', 'balanceFrom', null);
  22. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('res-dummy.btn-inqregnmb', NULL, '[drs]', CURRENT USER, CURRENT TIMESTAMP);
  23. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
  24. VALUES
  25. ('res-dummy.btn-inqregnmb', 1, '/Data', '/Data', NULL, NULL);
  26. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
  27. VALUES
  28. ('res-dummy.btn-inqregnmb', 1, '@', 'copyMessage();', null),
  29. ('res-dummy.btn-inqregnmb', 1, 'cif', '00002237', null),
  30. ('res-dummy.btn-inqregnmb', 1, 'rc', '000', null),
  31. ('res-dummy.btn-inqregnmb', 1, 'rsp', '000', null),
  32. ('res-dummy.btn-inqregnmb', 1, 'rspdesc', 'TransactionSuccess', null),
  33. ('res-dummy.btn-inqregnmb', 1, 'responseCode', '000', null);