1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
|
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE DemobankConfigs (id INTEGER PRIMARY KEY AUTOINCREMENT, currency TEXT NOT NULL, allowRegistrations BOOLEAN NOT NULL, withSignupBonus BOOLEAN NOT NULL, bankDebtLimit INT NOT NULL, usersDebtLimit INT NOT NULL, hostname TEXT NOT NULL, suggestedExchangeBaseUrl TEXT NULL, suggestedExchangePayto TEXT NULL, uiTitle TEXT NOT NULL);
INSERT INTO DemobankConfigs VALUES(1,'TESTKUDOS',1,0,1000000,1000,'default','http://localhost:8081/','payto://iban/SANDBOXX/DE989651?receiver-name=Exchange+Company','Demo Bank');
CREATE TABLE EbicsSubscriberPublicKeys (id INTEGER PRIMARY KEY AUTOINCREMENT, rsaPublicKey BLOB NOT NULL, "state" INT NOT NULL);
INSERT INTO EbicsSubscriberPublicKeys VALUES(1,X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100b4a8cc3bea3b5665b907fb57e985671d835884ce3c67b90647b8c215334f0efcdb93e603401468008d124d401599344b753cd875365cacabd7056527ed8c5cd2326fb21c4745dbad244bc7e517ff8367f49df434b4ae73041f90d0ad0a52772f93e2f84d837a1269394acb482236e94404a525d771b3f24d2908212fe6c0f365f069a7d495742f2830f6a96a9fdb40eb4dcf53503207564b129a53a689278b9e832535d1d61fd5ffeac5f1fd9da9ff6b7257fc24c1c808d1e82ae4f94f11d8cb9f8deb98650f05291b6ed28d6b3d3fc2cb81a528a3efa58525b3e47148ee16a62c715d3a652bb540bd62b18c96848da311b3b9c9df1dfcd838a5f411a9d220ad0203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(2,X'30820122300d06092a864886f70d01010105000382010f003082010a02820101009b7fe49949f285635680bdb9161b8b7feda8ff74e8c227ac784440662085dfa3ab928db25e2ee07f09ab42e6129763505a8992c9dc2d9a8a813ed7a90cdd4712aee0767ac95264d6c0e325010a8236ecb4c217c09db759741439eafc072d450ac6a60684f1cc961c7f228ed1551ec40edcd3fa8a49a791cf6a905cb12f35c089d3f86dc6d73e5e01f7be1cd1948ba7a1995d22fb6da5e2b0c068e250dc222e97a927fbed12dd3f2945d903119a0639781c8e2bb1297426f602d285caf632c8804553cc83a8c2505d8598314a181eb1fc63d77f2acaec7ed24d89fbaeaf0347178f0a87f39d29244e59f9f1dca9c1d8c32034113a21880d61d6e998145896b00d0203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(3,X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100b57cad0d7220494d675f05937b26c9f141f6f1352f54ceca6eed39a355d11925768acf8324956bb940cd36a1fb349621721a8ecbeeb62a02cf575735a0cdc7fbd2167334505985509baf9945385f50fd9ca714f87e2cf6b1a519983feb6443273e345e4d2856693ab44efc4ffae82905516ac28ac33035aa3a3a422f627c8217c4bf12b057978f5a507916a6c1dcbaf8d7250a980ded9e6f1739d8b2d86aaaf45522540713c55f2a22fafc0931826f420578203a72ff9927120671f0465fc9efba9631d322bb3c6498245457514cbeb40dd09b996dd35da0be90e74a7860605482f0f0cfaa332858a23efcc7f9324e354e03d4518f4c6ed2769f80ebc777bab90203010001',1);
CREATE TABLE BankAccountTransactions (id INTEGER PRIMARY KEY AUTOINCREMENT, creditorIban TEXT NOT NULL, creditorBic TEXT NULL, creditorName TEXT NOT NULL, debtorIban TEXT NOT NULL, debtorBic TEXT NULL, debtorName TEXT NOT NULL, subject TEXT NOT NULL, amount TEXT NOT NULL, currency TEXT NOT NULL, "date" BIGINT NOT NULL, accountServicerReference TEXT NOT NULL, pmtInfId TEXT NULL, direction TEXT NOT NULL, account INT NOT NULL, demobank BIGINT NOT NULL, CONSTRAINT fk_BankAccountTransactions_account_id FOREIGN KEY (account) REFERENCES BankAccounts(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_BankAccountTransactions_demobank_id FOREIGN KEY (demobank) REFERENCES DemobankConfigs(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO BankAccountTransactions VALUES(1,'DE989651','SANDBOXX','Exchange Company','DE371825','SANDBOXX','Name unknown','FMQZEATC840WP331DVFWF05XGB5TZ02Z0RTSS19EBR92F8W6MFKG','10','TESTKUDOS',1660992701609,'8SB18L48',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(2,'DE989651','SANDBOXX','Exchange Company','DE371825','SANDBOXX','Name unknown','FMQZEATC840WP331DVFWF05XGB5TZ02Z0RTSS19EBR92F8W6MFKG','10','TESTKUDOS',1660992701609,'8SB18L48',NULL,'DBIT',9,1);
INSERT INTO BankAccountTransactions VALUES(3,'DE989651','SANDBOXX','Exchange Company','DE328996','SANDBOXX','Name unknown','BXCD619SVE1MCJGCBKD1CFAMPAEZ6BRJNW8FARPV56GMV3YM1BXG','18','TESTKUDOS',1660992708719,'L8FTQHU4',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(4,'DE989651','SANDBOXX','Exchange Company','DE328996','SANDBOXX','Name unknown','BXCD619SVE1MCJGCBKD1CFAMPAEZ6BRJNW8FARPV56GMV3YM1BXG','18','TESTKUDOS',1660992708719,'L8FTQHU4',NULL,'DBIT',10,1);
CREATE TABLE BankAccounts (id INTEGER PRIMARY KEY AUTOINCREMENT, iban TEXT NOT NULL, bic TEXT DEFAULT 'SANDBOXX' NOT NULL, label TEXT NOT NULL, owner TEXT NOT NULL, isPublic BOOLEAN DEFAULT 0 NOT NULL, demoBank BIGINT NOT NULL, lastTransaction BIGINT NULL, CONSTRAINT fk_BankAccounts_demoBank_id FOREIGN KEY (demoBank) REFERENCES DemobankConfigs(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_BankAccounts_lastTransaction_id FOREIGN KEY (lastTransaction) REFERENCES BankAccountTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO BankAccounts VALUES(1,'DE157556','SANDBOXX','bank','bank',0,1,NULL);
INSERT INTO BankAccounts VALUES(2,'DE437731','SANDBOXX','fortytwo','fortytwo',0,1,NULL);
INSERT INTO BankAccounts VALUES(3,'DE323952','SANDBOXX','fortythree','fortythree',0,1,NULL);
INSERT INTO BankAccounts VALUES(4,'DE989651','SANDBOXX','exchange','exchange',0,1,3);
INSERT INTO BankAccounts VALUES(5,'DE591332','SANDBOXX','tor','tor',0,1,NULL);
INSERT INTO BankAccounts VALUES(6,'DE922290','SANDBOXX','gnunet','gnunet',0,1,NULL);
INSERT INTO BankAccounts VALUES(7,'DE172185','SANDBOXX','tutorial','tutorial',0,1,NULL);
INSERT INTO BankAccounts VALUES(8,'DE596376','SANDBOXX','survey','survey',0,1,NULL);
INSERT INTO BankAccounts VALUES(9,'DE371825','SANDBOXX','testuser-q75takwr','testuser-q75takwr',0,1,2);
INSERT INTO BankAccounts VALUES(10,'DE328996','SANDBOXX','testuser-cyokoxmp','testuser-cyokoxmp',0,1,4);
CREATE TABLE EbicsSubscribers (id INTEGER PRIMARY KEY AUTOINCREMENT, userID TEXT NOT NULL, partnerID TEXT NOT NULL, systemID TEXT NULL, hostID TEXT NOT NULL, signatureKey INT NULL, encryptionKey INT NULL, authorizationKey INT NULL, nextOrderID INT NOT NULL, "state" INT NOT NULL, bankAccount INT NULL, CONSTRAINT fk_EbicsSubscribers_signatureKey_id FOREIGN KEY (signatureKey) REFERENCES EbicsSubscriberPublicKeys(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_EbicsSubscribers_encryptionKey_id FOREIGN KEY (encryptionKey) REFERENCES EbicsSubscriberPublicKeys(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_EbicsSubscribers_authorizationKey_id FOREIGN KEY (authorizationKey) REFERENCES EbicsSubscriberPublicKeys(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_EbicsSubscribers_bankAccount_id FOREIGN KEY (bankAccount) REFERENCES BankAccounts(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO EbicsSubscribers VALUES(1,'exchangeebics','talerpartner',NULL,'talerebics',1,3,2,1,3,4);
CREATE TABLE EbicsHosts (id INTEGER PRIMARY KEY AUTOINCREMENT, hostID TEXT NOT NULL, ebicsVersion TEXT NOT NULL, signaturePrivateKey BLOB NOT NULL, encryptionPrivateKey BLOB NOT NULL, authenticationPrivateKey BLOB NOT NULL);
INSERT INTO EbicsHosts VALUES(1,'talerebics','2.5',X'308204bc020100300d06092a864886f70d0101010500048204a6308204a2020100028201010089e537c2e5b9f29165a35e5b685af488ab9ca9d49e765fb82d5a49cd120a30b3a58f0ff7fa91fc756fdf2b7b24c0cfdb691660e0fbe9a58c14232aa92107e3903c1840f86982d0aad9b3b71efdac30dc8cf9253b001525256e74671ea1a72e5adf4e0325a198c0e6c4ca3731ca8738972545ebaf6fae8f4978e67428477be2a0eca3a7c14353708758de4155b58f8d93a11e018127748fe387402e9deca3e383d3c581b26782b9bd8fe7c71edb25ab9fd92493263c8100bd47d4b3037420abbb98be0106bcb70007645fe8820407e43e32dcf604c72b448edfeb4f12988ca3033aaaf7f1a3bbbe03a0eb66c178f70035f91ba94a6caafdb716b6ff881b6ed8550203010001028201003cf51a284afb5f528cf6a220904a1ced49c7b07fb0292df931fb46c2a3a5e38f96b15e62c5dec1167d04cfa8d93f6ee3545a332b61d1108092ea54d27d2a8a9b5925739b1cb15a631c67c89ca790f5ec99590def3e031aefa81b46f69089620183d36daab5fbdbd267cde886573c5d74db624464c25f0d3272829578b4d8fbfe773654b02325797bb4032ce07454ef360dcdc852a64cbad70fa92ff99d2fd8282c4863749500934e4d63ab7b834e5d6f48bbb9042fc68475b74d08d9dee911a2f9a007cda36cfb9fa7b8d4f1108cf030c49b556541b67c9af5a1ab3300d5bc552d6f4431fd6ac8af7296cb039869652e8c9eddf193847dfb51976c720783d1e502818100c4672469fa225fb525424a48dde8213780564ed4be5a7eb85f032fd6dbc9dbe0345f8a2af70da8afc9e3c5861ccccb70bc7ac770bb571a0a04999c816994a70ccb7370a8c2799d133c7beec34a6ab93150824debef33a0ee086b72e6c929f527970ae8ee0099c921cae83a7288c984ee85d5dbe24d1c1a379299d59ecf554bbf02818100b3bd20c8c180c3c1d082846218280cdfa3f0c70094b04470797823ff95081bd6cca082b1b3297c6898d14dd169d3ef1ca22e7a11f1b73f1b497f7f8799f66e34fd513240d77f9226fad8d3b483bf40a62e24aa835494b1e76ccfd040f24f2f3b988ee00514bc5638df50a53fc0e29d38650f5d7201d4f2c05ecf0ee97bb1b0eb02818062f85ac830ad1baf8bcc00e50135d56f4373ba9bc8249010d68823965101429493afc54f6b596db4cfb6c0b59953b5fce46db68cdf4ac02b66300646cc6e8553943e62fa17adf2f25b9b543103120eaa841875adbbc737845ba7d1a9ec9b0117e72c2f3ea7fcd6f6f969d6f21a6dfa57bc078d9b57221f2ffbe71b57c0c109bf0281801c11ee5bcbf48b1deaad6775566672d43e6b2cf9073f9c00a0c7c57f75cbe5651f61f5e7409ebb022ed3893eaa3362056bc2ac67bf032a44ddae9ec113a76bc0b4cb08791dee9b69a10559d2b83c97211cd5b717798f1b559425c455504253931019481d2306e2c45103ec3acfa9d479e936841678f8c3cc8d41f3073dbd1b6f02818039ffe6be900595e7f275d1f7ac8334b207fa478b74809c355aa1bfebe0c9009f9516eb4db0e22fabad377d5c85aceb5269375ef91009de406f270fb2734648f6290cd054fe1839b8e4b5a53f97de204f515b514ea245f7c63176abe776321afc7712aff869457698a011351276397a5c2ced6eb4067fe8ba49606c04cc66f26b',X'308204bd020100300d06092a864886f70d0101010500048204a7308204a30201000282010100b65ae153acab4789c4c18cca8cac4a8393ebbb10e1553b34836d6fb8073870d64f2c6183a908a4b52f11a688d15a2f2faed5acc3563530a9c7a7ab21787877d79c3bbfd5195e5d4197c12fa9e505546b86b0a8aa91d3ca14ee26b0b266c29097a15984aafda5e4f44e9948e8f722546c394a864ab30c67baeeee9427e644eceb3706293bf6eef501278b90925b441e57c58c7842f53bd9c4337b80b505651a296a31a7a18668733b375d2d859800fba8c8de71b7b520c8c4cb4b20e5b86909bd8ba1777a90208c8cd1b9d305b0c11ff5f94763a7cd8a3b64d0ab2b15735dd663b9c017ad7d4823112e93d1fec324829e76a0e083fb5b866a665a6b6aabffd3ef0203010001028201007ef8486c3a8e0801a53e1f09e9690d791045d2baae2aea4e66348cd55631b65f824124a4c7cd7ce1ab245f1064b4a6a64cd5fab508118110b633c8b4456d9c04448455cdcb1c2952c29780d88ade6b29735f0e11b5f8017d11555f32d8da205373c520daee41d4694750f3b3426064e7f5fc2e0555260e13dac9c3df043679bf1d9f43bd837c9954e59efc886a678a7e75d387c6a63170850c42a818bd7f01bf2d603ecabf9e74c1fe3693308e465b82f033c91d1d85e0b2efbbf28f5d252320c162c5d40a51bf8a376084e403fb2cfcd4101031257cc4bff1ae77976b1a7408c7af2547e077ffe705850d58871fa1928753ef8f21e615b32ec241f0ac5cb60102818100f7ae40eb734a12381bd1e483a5afe6c766b8f6cdf95ef224041c1db3e95583ad531805b4aca4bcd1fd6778d73754ca180aa04583eb111e67de7d6bf052d6a8f77973df400bdfe81d6b139f07c25309433658d62300e60fa094a8b6133c8cbb8d4ca794091175457f54efbbc46bf76f4f01fd9ec78bb7b123385a3f62e3438a3d02818100bc7ae8272ef13378fbfec6c3cf294895c11a9c3d12e2e1934706c482df9b9ec0c3441c7a52e41787d184de1c6ac6e33dbcdbd4dbf71ace4ed47c02cee405457400ec911964cdb1343594458f4b9b69aece59585f8437249aa3837b703f2775d6733eae0f627d3b1b559fac24aed3cdbba87bd014a9ddafcba48b915ad2b6b59b02818100bfc0667e62a96be588943d2836b432251a4004c37e56a57c80ba0bbce7deceacf771d7a903281f0f2bf259b9b51aadc36326a5eaf5a83134152a60d09431a06ac7da8f72943eeb032b8ceb48248808d9c24f90a954dec82678310d956301498aa157f3e1f9642343eb4c16c0811df54ce3aba8abb05dac8429f2a4b4386267b902818069425a94476afccbfc2f74e1b5b7e08981a652cae8d93c10fc01938d63438d8d297fc847a83329d0f7f9b3f13ad087e7daa90a5f2dc9129e839c1e155cd274cf2c14f193b4f00a9e95ad908b4e3624f732d642bc55225696e5ea6fed67d7a9bf71ecf7583030afe9bc0fc81b546784e5e05a0503053a810ac1821053208a593102818011c5374608abc41cc4f26d8aa3391b94353fd9cbefe6ff04680ac58e6b2cc75d44fc6715e22e660449b8eb9861567e8ea4c806dfa3ed1fec3ffd23eded49aa9f03d05b630b7b9b17835d542cbc6662d4f5056568f0f6698892d64f629597f45e25812bb1424a3d35ca127f864f6add4d9be34dfa4df5553a9519a1c2aa19acff',X'308204be020100300d06092a864886f70d0101010500048204a8308204a402010002820101008d9d5ae949959e7093cb4501aa9339911ae2f7eff547dcef6e3051e81c8939a0f9a73fcc04e4d3afae16eabf097d67d78e6ca66b7d99113fc46750e7c6d0331aa9ca119f6e4cda1f1076ac23229e57cbf2e69eeb9b7ba7ebbec78c3fe5f244204fc86943e6f0c39498f26f029dd996c56de91fed31794f52a69ac383c00560e868812bcaa3ae6a12e6dc9363c86fba1ee11c3cb8fb99330d911a488812e6d000e2584239c96d95a58512f41c7acb2de6d33bc5a9b1c5799e0d844ba0a30cbe21ec069ee72ae43f6d582e682c7afd0d2b2ec734d081f1711528cd1b0b12ee157d01198001cc89b1197b0291e21da5c4f4c88ece7fa72f93a3ad5bd42f04d60ad1020301000102820101008aeafe8074b7b9ea1381465b411a15519bbf649ad6d13d10fed595b38d32abfe96889393ae854e873aceae4ee29f4b5b7012731a64e5dfbedf0abe99ef34d3bce72c1b277b8b16397cebfd26a652102c38463545488c0008c96874d345dde7288f3b38cfec5ee86cffb06a6775b33a2cc809f550b7c499a4a95c8e48d2f833bba49f8ba8d963b8b731f84ad2d3014b449b31bbed9d2fda68ca64fa80d89c4849ea669e6a2e22c2071e3a0b30b3d52f469044deccadce2b86aae48e4dc18de7d3987ecf0febb3630bd76de0ec7c56ff808d9a2d53adce8fa3e2d761a5a4664cdcd533b0b7396a8d86cb9deea822c97ee725e01630929977c9fa1cae52a8e70de502818100fb5ee58c23858474e2d2a087f09160125b5b369233fe82e1a514112e6e5b222dd14f3853a5f8acc979e2fc3d73a2c2d40f53811ff19f109ad68f1c2db56e656874254bfafeb1b7c88dd596a4bf96dd58c61dd5b58a07fd088676e94b2521c0f621d2690d6f208f03182d29245091f81ac5a569a3dd2fb6662622c4921e7f625702818100903901b12ebcb584ce8ef3f10019326a916564afec88190500a3de647f4e263544b225d46476a00d84eed73631bae7832be7694c4307140f91b8118bf5b1023fbc979f5bc508b42864ed11500ef1a85afcd8758b6a857ca81d3677b7b9cb111c5954165980ef662aa86fb925643b75571769026ba0dd743c99cdea429c4e5317028180290a59580404ac9798e0e2accf2e2d0d52351637d09d61290e16b4a76c051d1375f50531430bd2ca224858fe7f7eb76880081630ecf61773f04bf541d13970fd18d96e0a50c31b4a773dc416a9e12bca6eae385227731e70e1e3503ba0985e34d158d526085abc7eb8d7c6bbd31bc1f23d0ac0b0ac5039eb7b96799991b9228902818021a4aab86266b3115ffe08f9d7440976c2a41c70cd84921190aca95c58362ac3925adc68476744bee29bb4a877c159f047759c22a6202895d9304f278f10d3ad7a99041bac42f383d8c7549a9061df1c1a8f841c19a53a071d896f33f4ab623a72bc22da8e314a6bf90ed6e9da0fe4b7844682c208aca048e2b81e459ba0c9d102818100c6c31103e951c161f808e90bea94cc0f781355bed0da7599d6a7ff2407a34fef7f32371ae5b447f84f3e9dc729986c27f27965357dd85ae13a765bab9ca2f8306ac818ebbc9a5d6a35062c80c8d38b554d11574d29e31ac290022fa4f0faa1abae1301bed9d0484d44d7a7b01d8990604e6f1f0eea788bffb88f1a6ceae3da49');
CREATE TABLE EbicsDownloadTransactions (transactionID TEXT NOT NULL, orderType TEXT NOT NULL, host INT NOT NULL, subscriber INT NOT NULL, encodedResponse TEXT NOT NULL, transactionKeyEnc BLOB NOT NULL, numSegments INT NOT NULL, segmentSize INT NOT NULL, receiptReceived BOOLEAN NOT NULL, CONSTRAINT fk_EbicsDownloadTransactions_host_id FOREIGN KEY (host) REFERENCES EbicsHosts(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_EbicsDownloadTransactions_subscriber_id FOREIGN KEY (subscriber) REFERENCES EbicsSubscribers(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO EbicsDownloadTransactions VALUES('1C2E392D0E852928C7A4DA0DB30CE628','HTD',1,1,'xthTzlDhcgK4FNcskzqLV2FudhAjIavuzLCMdXCoiTp0PTyhcbkskjcik7vDkFluwT//DefD3R3YI4uzpQ1JL6I7LcTxVxKDGlQHzHWX28qQw4dSIuCdhKxcXO0bBo4TyuEUwUj8QwfYslTy+OwFx93d6UJQ5E+CJjn7N++sK6Qi6foPmdV4pSuhmuQ1X++31KJzvBkUBWzcNIROBzADd8LWpjRIF/dRc+CSqalrul8PXyGAukthSPSORwRw7zPFdZHaWtvOyBp9MXX+EjpEimc/Op45EpQWVwXFTcl0keUaWxQDw7sdS/zKLtpoV3r8FU20umth4ZSfGCrImkCMgZa0IWgB/rVIJTZmX57TUsV1vHxdKmIoA7KnKpJ2901bw2Kw6DAnPvosZQt5iGx59pUzZi0fEK8Elx48aZQOhIdplM8G+0/QPCvmFQzmjDTqBiQtpRoK+5nvbYg1reSxg/1+1em0oT9Xte2ggdLkDlhEF8rIiGN/0P9EawpPwzJEimpKAy9Z0r6eaJuA8qhAlD1ziSf35IcN7U/zwBvlYOa37/AzOapXY+YjM5+E3kvbidSpCgUCG94gw0/NvOCuTNMt/8ezz5fEj1K6cSfLBKzM/9Ry+KR6fx+srfQM/kWZoC8KP+QEpVIFUzxtac1FRVnHdCQ3AW1KWHnq9w3Br7KGedMui0oCbMy1CVtmnTlx6W63RnvNqUSSmDfzqDiPqQ==',X'3175a4296e45e513340ce59395e74770a618506394c937e2f03c2494c9a13bbde7d09290410a1e98eb62477b47d9dcee39edb7b9fb97141038d4c4a1a07d787581031d6f87b9b43fd96bbbdddbdacd8c50f735a9f3fde65fcb95e74f5a868ba8b77b9de0535cb862f5ce9167ad996a4209a68cd1b3ffae25a6a7e4a744716424921ca4ea90ef2c161f542b2fb0a05b304524e73a20515895772de8799c9e8597a0490f81c479c7dab327de4ca26dc480b0bb8c077afd3ca8c9300b66d19271b76f4d12c036c26910ec9ff13227daec10d916799569bea218c8843b5040c82eb77cb937f97f3c6e1439153f780358d1857a25da61aac620940429ff7f4ba13164',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('6C231DAD31FDA057CB7614F65A4F794E','C52',1,1,'JQpVkH3G8yhYRpzHNuekU5/dbwxxuTo5iQKYZs6xnY9PZfNi/mo1CJW5FmRml6to8hLVeY4OAgyfx4MWHEDuouGnRnt7uVWX2L7w4973cT04oj3cVmkPRapPS3+th0+zO1LJqUtwX7RauOgCht0IrodRvq/8rhZggjYLHtAipWGGxwZ3n5UNHgG5BXuApxPz/9mRdfciygnHor0Gd77syPErIfGZgi34JiiSH0nYSLQH1KKRkhHi6unfQTPblNPCD4JCTIKJDC/oK6P6E7vccRT5/x15jc58pxU3kU2u76Wgca3fV78F86ke0LGQksNDgt3Odh/YDBtLCvmDJ/fD5E9AD0dDV8YZwv2AuT38bU6DF3KtqlcBWrkTHVg2fTahzSrOzk/Qsa6SaHbHvpElIln0WgQgknh2uqYhz6esFQo0pTbC9h0gNimaHXA8G9nSGEhabqAqE0W2GErANFXqY4lJkuRkckAqQI4WSquRL2LbBEL4wg0Rqq89aJKblE4m54O5UdMp/SklWI9tFe03Qk5UA+eeEi2YL/FaIU2lnTsouUGkdWu+KzQVhj8+rkK7dtMZZY5SvduVCLUhota/FmzuwZYI9SSnU9FrNRFeK9LwW/sjgGpJOzFbcgZDbV//jtNLtFCq8LOedmP4HpdYa1LsIJLxBm3Iug6GKHNscC0ScGgTTBuYerLZtAiCat1Ehbqsi7Mu5Q6TTVkzPtp+Br2zcWpxsG7kkwdfpmiy65g3YazqgN4cSexftXOGSvRS3mzlBXndK47X5OwnNqL63LvhQzzgAf3+aokdjL/xjzIatDFqp1mEkJ+h5J7ey21g9CY4b9oQX9ak8jrRAhSt3NSsX0mud/lEQ9KzVZIHADw=',X'312416adc5e56d5a1ff596e461f0a70d19ec282d4828734bcda76ff1b14ce1a215f815c1e0ea32a1d247a5e2f058a997dffc3490211e50f267e4796b86488947007a3b89e5ab12bc7a4c8f1ae3ebceac82595daa2f284f4ef3e390b12b579b479f36f2f24045b889f9247b72d0b0bbf05037db9cf1c43453f9f6cdb7510b075d6f753803677e96789178d8538d676ed6647fbe3dec23e5cd430e11e8147e4a16599df2b9b7d5a73312b3db9231f9dc24b5522f2e59d7001dd8384ac89c180d26bcab91764a5653dacb9ad98f8aec59be3bbc0099b45e5325499dc459b5c5d9b25fec53f167eb419acaff3c1b9037ff9b79bde57ba1f476e777610ed4b2f18f90',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('684FF43133D1E8286EEA636ED799C11B','C52',1,1,'vfr4kbiYbtyg8hkKtpNvzEPAnCsEGkgpoLq0Vi/fosLjpbb87ZJhvqbrKGJW08ctU6qoaJWoNWbsikYdqWSZqS9D6w+XsUYKUSubpdtqApPF5BDczDiPji+E73+AbrNpq3D+9QqftFvWWkZreKLUf0EvPuwOTTACPJ6Z6roG5B3RMSOMVQYl/rlXiCC43dHs6dVb0YBdUqmRL44I/OpetJeUmORsww3zgc3Ge0LcUme+lHwVHsAuHKzKx4ahg0yx/VmHsj4L3zR3LLdqTtKRq+Z2a3rkp0+nTFI49bNsxQsFNcKwb4wdGBAzYh2HBBX48ve/VoDV5gWAkoDIoqWa1cvK5PGmqVolPtrsqSSbgJxpFQyXP9bGcFY9FZylfclLfZ96em4cqNJ8Vk4TMkjNTOKWa1ay9oNMsAKwLLGrxJ1V6zpl/qsrj8126HNOyoKVvCG/CZJubfK2Ewjj0r7weepwFWkVoobFXwAsl/ZLitZIJq7pczE/hgBg/KSfVCFBTJlYj4RX9O6Nry//y3mhdPVFZbMQ8tH3XaBObQapOULaeHFiUPkPQ2mkNY5uczMXYLHxYxYl2YY5BDG77NtTzsWz173up0uyzHogiqvIzU3UogBm1zKnWb+Ujb/dmZlwmr91eMDE+dsTaifB3tGqhM3vCoR1GxHQXpGUU0Bv19ZASj4ZVgcZRwcPLi1aTseilgDOuy03PQMjxOFWmGqYmqbE2FYHOEuRTnzKXMh48cg5GMER27k/NmzdcRxJTs5OAtIZaZ6Iys+dcWOTmQv6ny55QtdAD0xeL+N8gWkJlbZ3T3nlb9+U5jaKSteMo2pPjUUvMUrZMAOyFjtlfG/9y1fZ7gCze43XKphC9o0TKXA=',X'581ae7f2a9cac15e4bf77f7c848c437a5d5e21bf3fef7b287211ccef266ef6685865bdb2dbfc3c4dba67ead7b7b3f3ed764d4bf103a13ad7c380d22aa56e260bd7a9362e45d985b9e8112ec83b65fc9d90aa2d4c4ad3392931d96f42131625730aebb8283afcc5cde666767f2e0840fa6761ad99b2e40c35781d8c6bbdcb3624b84f5acce07fbadf23379cc35d159ebb4a3fdee3397d352b530a3b7c2fdf2e73610bf285fd61430678d30c7d4756a6eb5dc36954e29ae4232b8ba4b39223079031f08c3329c896db0b7eb8701318be0830d3817ae82a7f29eda558f6cd6be4c3f16973c6ecb5d4049b7bb0432038e9b44bf821a1964138158d5b478a2f0c3796',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('4A8219186838B05F5B45ECBDA709F528','C52',1,1,'Rf2U2imL+Ud7I3gSTQOsyQl1u1CSO4MW15GuRPf6tCXrDUdeltAb9Xoek+ACS6qcuBkPrhBdDkJsygX/o+sCyUxo8qvhDwhd1czwx1mLbZuPQoaz6/cuwanL6rLgFo4wMcdMEsq7E+UePAlTUUbKpjg227lBpOwMy56Pw4cdTK6YgJbdRGHJfuLLYnKDQm9Qq4o6Ow7nau5ZX+rRnXLPjexF7TQOMVrI+HbUo8WEOys/WhGdlHLXjuqiucdoiJm8b4erT9XfeHUIGCQvyFZLwDVkRGhOhVrLr9XUOeMPNUTvAUwku2mVQSMeSqdIwUCawjwQjhL88Yf0+oZv3y1lmUnRVldJGLQAqlJfvI79Q15dwNsn0sF3sq1Ib/R08xk7t+7OfB//Xy0QfpQhBrTom3abHSQ1rzG5ZIBlVspt99x/7ri6eKYv/9JNpk57Z4jTjvqml7FnZXq6UgxojfW9yKd9sbwmn4siEcyfzwTeKxjpTSIJpJw9+CKBGadie4KHLwJ6EmI8ykqH70jeXUufDPGosZ+Iu2B+0IkcOGHBVl0qGDA8KesdA4cfZy5+2tKSTK57jW/fDhxxJsS8x60fUZjeKTsLUM7X6NNMKBBtgJN3XmZmDtz/1rjImSHcmRdrvoKZhrCGGo9iusXafm6VmP67YhN9E9siH7CyrBRPMOjtDq9Oye4sg0uP//bjnc/6/lurwTVI6ru/mVdZux4wa6GFXih+wpIfC1+BpC4G7pBOcNZdpuYKy/Y70St5sGthc2TNhoZ8muok+4faRooyzLtS2iPnM7SGr/mE1GuYOcP9X9XxL/DTrWgzMqPa/kKU1W3+G/5q6USE6aEOM9WmcnPCZVBctI+DyPDtnhGqaxU=',X'743c80519b97ca421d58d73e11782741f7637f0a35b68cc28448363324da276fb70de8a57c4f746c909d52f0c709133e6741e5632cfa5a92d19d5cfc78580e7629868a883523ea95bad301f1137378428ca3fdae629ad3debffb985b102cb8f0336b1c3e4fb68a9f26e6ea379e820ae0e36ae384060ffa98e8c53cc7b5ac416ea0db85c95ccdb0e751839fe831aa2e9c4e1f5ebe7d9a67b55de0d3df4b59874096f4e26cc1dccc8d4c1b3ee51d1a024cf240f3fb50474f54707da3b3e3a20c3c05792df67cab3c0621fb1d8be37483dfcd63cb870f3c9fb137f91ea7b72030a45108e54e7729672f1f5162260e0837f1e11b875923862fb901487d56833a8bb1',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('E62F18550A8CA4A9E01E6983614A4EB4','C52',1,1,'D7rHoxxS1+tB9Nk+eNo1Mkp2CJcHOCXvYqOK52GJ6ViLHGPfz4uO15ncgh5nT9RxJa3sz/8hvpD+3bX03t/jrEOOXQPWlI0NWefzDmMYvs7kwvuS3nPFIsV//OeAcn2kQ7t3vEdUHFNKZvKVNQcpjMSiTAUO9PST3AoPJciUc8maxtzOz/P07hHSf5VsQxUYhVKOYmCH1vP/Y7OSZW8Tp1QetiPOJNNz1WwpJ9voQpsiNC0du0xJsdl0ySCWBmmTWzy7zzJ6jbm769jcp0tXYu7dhcUQMOHt4WMQMoL+2R11CuHREeJU2XCNy3339ztBovdwEGjohDrhSLzXKFTYtvrkS23NeTke4qqvvKuL2l2ZZh6h153PjAPG2Dhcq71zUlNR40DJ2PyQGjGmUTzUOFIwTDjQJe4KBeUWEvQk8F7yNIcP1X4GRrN/hSXUVYmXV7nF38dXFMJMgyu2DYc2ZC3w4k9Udoc4UeLqU52sDYjhK8bCKF5Z0bnMgcjA7/tlqSio8UdaldH9/cW3+4dryMfZU8goP44LwpWR4tpdq6ygSgomfWi8EjubqLhjRKUNiY9O/NuGazi5PoTxEbKWh16Vb1CTrtiTGpeQk5DYa8AMtuW4NFFKXnxRZzH8AYr4G3fnPdyJ/PzAvraSGA7gVu9h7sVdi+ExoAK1pMsdVXfVqJ0kjcfe141BnUyqHn4muSBjWtNdIXTnsX+zGBXVqpPswFwXkwgj3P5VvMv2b8kfM/aaABhXcT1zp73ehoYpLQ/VF7QQ1B8B18wcV3fV6Hv0SvGLApAymbIL0/fKVEpRRxriSaIxW1arRibfj3l6hBmTA0ciywsuuaVL79zMz7dV9aYoiw0oMzY6mqGAM5w=',X'58d68edd93913bd8a27e6702df7a6bdfe075aaacde375513ad569e6b9a3367c42f6d9c4e3d3f4a05c4fbd81beb809498bc58dbd566f471f3dd3404bddad33c027df8725883149938d9c54263ed9af19610746f6ac0a9359969143b745fe4f8d014133e952c8221f943e8fa63c6a9704d4f8396063ec46bcf974c68b97803bbb169cb26e46bf5f68276d3c1224243641a4d86ca05732f3ae289aa1e6296eee0722aa64f829d60a430da289dbb2b7c6e707de19302a70f47eb5e8d9f792e1729aabef0f2aea98e0bc3d00a585b737b42fee0ed8380a3544cd630147e980392e1c1a4f2e5271f2027cd70283a64cd653b3e1f1956febbe902dadea748e3fcc58a0c',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('B8FC4065CA6561981128547E60F977B1','C52',1,1,'RKEcsrK2wCcBshC2S5w5Rt67iEz4hXwS26VEi+Bcw0pna8BfZUU5PXmdYNq9Elaarv6IH23arILRzDPsu6EMcffZjrFOsVtoPMdm9VlNM9VU6tkuzCeWpAOrVlUiFQFZGbG5sKHqoY8Waorr2xuUri2jBTi0z1qjpPGJMM4AiK96T45pqts1mmkMpPbut1WMeIk8EkFyI0iag49Yf/82ADpspksIKiu6Wj1L+Dj3pY2q0ouqAUdVOs4YvoeTqnl+F+uQJjhqquSxZKD3Xjw1sLCZegmf9exK+7Rj8lrCpMY+ugSNl1EIoVBi/76bgPhYge+uAzPDaT0P/2xFLIEZiKHRUfq+CXCnhbFUYXsttAhVlY/Tvi29AkAXYUcpIzdsUcxgk0ErfgDsucxpKCnafGhnXfWMhD0JPgXw0el0sZWy7+jejQKFmJ4EK2NoPDDNfaRIFe7YxHuab4diru6vk9VI+444CnD8WLrddUwGykJCy7uGRvU704RWWxzeoBMatwQms/SCH9tL1KDNX+yJum7A7qg4rkbwvkFLtUw42syN3dNzeAc2FMtg0ba8svKzzVBf1HzfD6KerHUt0icnd5Fmsvp+m8/OFSTDt8amwA9lePmsFl0OlwANM3yXTcoiT3BKD1LWqTfM8fyDt+j6WBIx0RwSJmqokaI7ZmElz5wlqWYjmSgiaZ9V9hY/mrMQpjeXrw8opXQxhJRiKefRf3Slw9GFcZ53vyKYeefcgloN7po+qKWAKKPIO86qQMccRXyKZU9QjUfbgadoJzSIdTxrpTpA/TMM4JMbu3HnhGNhZfN07RDJsb55K+mvUgarFxYdMK3zHn2q1EHU6lUjhYJWujQVLCwc3dd7v52lM6o=',X'7872a881cb784df863801e7152fe163c3fb489198c1ab6cf1e18c83d0af3b8a58befe9a09c2d3af95c2f87499c941fa4661c9d360ab2f4e569da2dd500952ad6d7948cb26a7476ddd75c1f957413103d8a4509ac5be8d9e37586afbaa0ec99761dc2bbd0f95962905f5754ee4cba76874a7d28c5e37e2bb3fdb098680d759e6e0eda5333954c6dba23e06177fea9dfe639afe6ab6976a7029e37cb7f6070c00d21983e621704985f7cbcbdd5577a3a230309c52d0974bee186b972dc4bfc81b8a68095a0419260658aa0443138eb9945692845dd70b1bdf1a3cb451e8c3ba0ed5f4ae5c402ed3a84194306bdd71072ccf6473b00b53eb87dd9d1706fd425077d',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('C0037F8E926B18B9CC340323F80FE285','C52',1,1,'JquX9xPC8rmW25VvqTxl9Mh9ZHaB+53MuyZ6TC8BsLss7t0cD5EGVi5nXcT9rQiUggRcvYDZSIdBJddKI488JnmAYO33ik4oQymSVPWeGNoKU/x3TEyh/ClzumUYJOzJ7i70hSzeTHvryrc9C+h7EyfEjWBtQ7p/1wviOQJ5yQoFD0btQhtGoO0X32MtOfJCCMbKbXjBbFjvIge3ssnkOdSUCkeUo8mQPxxNvEdISMfVkHg0qvCXjiLy+gYZn4DpaeZ+nsNyQe9nqMPYvIhA28/xmrIcL0GlXo9VZOhYAJexEOkLciAK7WVhinzP10QuUla28lvvBgSrVhiE9XS7miZUWSOyQi6M61LMH9a9lyEqDFtcnKnxbTU6CRQalF3T1pwRX9D7rZoSThP/7nHFejx2fIqJ4fRjvsLwnzrnVuuugE404LjOTtAnaxUdoX/i7zulegGUrt7sg73bk9I+cqcQEoyQDPS2E5TiRG0l+wzjSwkHBJ9RRY8KD/QC0uGXWW+14TW2d+HCxj6gn26M+ziA0MNJH7IHtyOeawFYS0wkdnHHtF0oGdqh/Coc8jpKH/307X50Ljp/ONlGlOwWnH/ljQoS+0Hm2qAUJNEgN/mv3HRkwjUUa3tNXrNgJbn8RPXQfUWNwj2qI4LWcFh6kwsYUqUAySNeosxTA7xWoIVrQZ7BUaMAVDl3I1LTuJQyAS6ssyXbdTDQVUh8Eh3jtfZomv07VBpn/Jc3Epf8xJhRNHtaiWoda629GZ5oqv7qg/UZ7zL39LYOw8ArppucdEq8vemzUJsP3W78mkxE0y1j7W9VOsI9Ua3iaL7NxFVs8cNxFmXwqJsR5Em74Bclx44WEUeP/uPDacNFxJasI6bTAD+cCQrdUl0AbbK5FwbFoYmQfad/qIbaB1ZRWBEKDDEAO2B2QwDWrOJQ3u/RgTulF9LCrtj9iWhUkPvdXG8Ey69rzJIRBlOWpczS9UDWen2CUALgdV4OTkbNSifxV7EMc9Ec/PaaVcljPrUKzJ3CZf4VSqeonG5d7vba+Qk+43TI1YXl21adgoin5Sx/mUW/fbWRWCgOsTlMwT8SclxjNZcMCcB1aUblMb4cuTEuQbVuSVVd7hE+aSHkQcJzyyI/2grxn5Wmd8q3rEAZTHIFYaFctgbNINmtQZW1lphPiU7u3C5tukN/O5Dn0U9qAOVebPngg+CQsQ+wMj1YS0X+/LFEHQaBz7HKPEiiF+D2iIbNUBwZNug7o+ZQ3w2HBOHu0PERHWnz+WWk51FYOo0L8cNUjfT+IvvRF6oJ+dSbgHERrgXXe0TS1BP3vKvmPGN6B8ik7GNT5IIGwmDHzcHvDlGHHeHrdUja1u+iUnUbuazfpeJLt8naHEKVtzUISJ9EMfNmE8mgoWT2GpaGahp88NcqHB5uYCKKamC3+luaAyu3Gq4r1Nx+puCoLoZlBq0/JLBNnS1IpPdAnLys9sIs8386DBhgdkOSUGCTyfSMfg==',X'53f275949fc9a1911e14f49b9c27c16130451647595e1d1f6d7c9c3130c512e925ce823ffca9b5956cfb38644acac27181e369be4657d42409e483364f2a80985a493c306fa19734c3038b91ac0a59c9768f9ed5e48eb85e6f2e49b76acca3760bd42cf80f35cadb4809175d02dd86c97457ded2325046cc37eb24250876ea0c8926104a83537cf470252f8e163d0ab3dfc8857c74e85cd56af992fe80458cebe7b8e58b1d1ab2c5a4a2c9b1aa7c34ab32eb6d54c7eb9b1bff08223b5d5213788d9c2eb8d0e19c9a7b8867ccc8349042be60ace2c984eb401eb79703fdbfbede5a35985d45bc754d0c1829e8d5375e682a527e51cf19baf2340530f42ed37a44',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('CD50E67D2BACA57C10BC482EB4AC428F','C52',1,1,'8f/Jto4aecLa7YoC6JiociyGJA4JgWunstW0UUkdfJ0cpNC07Ov87Rv975Efeu5uY/WS7LpagBsS0jHsmRZhUHVCDlKFD5x8q2xgAmMpG1T2HmRhg+/nPLydMwnpyTo3yrEI+gG8J3xMfL5V5VR/veEIbJCUFGoKreZ+3YaYMkMUoEtE9bTwdnLrMNG6cJZqqCBYeYbxfmvI88ul6kP74aVz+hAmaK1Pch1n9Xu8keuFQ4P/+uwCI2FoWye3rGQZiicKmWxRxcUuU7K7ONA7YFnxOEbU/zsRjj4l2gitJSY9aUUXbD+xtGTF1Cf/9jRiktgGrHZ9Z7yIzF3yAgqX8/eXrVsV4Nz7tGrJxkWhjECoQnwDRbuGEEA9y3Lvo61tINfjaWjnUJuV9u3sMWu8hgAxQu4BCvX+w2ZLghmJBG5xF9UL4DQ92iGOgoEKuLeWfxFtLiMitjycmtFmM84HB/TGg2uxb98z8AEs0ae9FJkZIaAfRIAdzsPDPF2cAkEoWdZF36Ogz4yMDz4G7HGNOPFmosVuGHEon/e19U8iXvbgJdHxeyn5Mk7cgOx8EcwolpAd+lnYL+Kd2ZAqdWd+D/cbI+Dv2RivIjqYVfLESdJ/DGm3FsFu2OzN43F24gp01HmDi0kaCqUyznJECqqVczvvQ5ByLDHjy3S71KgW1SuLgraGQ841UHcMut3qUCf3MhMuA2+gKFaHQgPQA7h8Wk2uIok53wStEuyXNwT7b//wD0hId6dwGO3da6I2GgZlvDaEl3Ym3TLHClybP8w5ltt3VX+YJUfWBOrRPs2Ge4O6gwWejlThiN+VxDaDHnHUpxqH/BQ+ItjeIg0tBsS+68JlzXvFUW9cUbJDCy/l6RkUDq9L+JCgrNKPX3hT85BgWvmJMNy8Rn8+rxOb96OiAhicxTlj1flOGWdoe0J8dytlfn3hUzcAmTfaS9ydJ4MvLwIVJjrLRK03rTLU0HLWokfdpOMsUb8j/9oGCYtGj71t6vO/i/RAYFl05pTbu8weUgETIs+6NpbP/Wf5PUq2AWX13KrJjyAz9pwdMntf6QzWJVxjdxhz1lyka2HJJgCnBIbHyHmTCrcqJtIkf3S2rTTHf1q9D+Q3Wmo3AvKvw0aan9E9ueqbGZTsm9ZOk4uD8sDFoAjmScUrIKE9hdxvqSYs53QfPaDUkOdfztzkQq12o/UT6GXaeOw00F2VvdMiYvXVancuOEWOFgLcXuFIKwvFXVSEzyQjyJKvaAaPnd0eywMM310fqJ6gvsD/cr2U7LbyO8706moDK12zLaI8IY5BBUO4C2jr/Pyy/BfrsA6b9axeCeAn8Lt5hJU9eEq8icNpEgMJAeQ0s4lNzS7fLSkrjCMj6dDS2t2MSKqq7RRTutynpNWUsINj9IGV7KTQNCOUTNL/vYfxeE0dzSUlUoThVfik6eAyf95cSqdJi1ayIG7PEIJyYDovxWbBo7BTKt5OntFi65VvozGwE/O9ow==',X'0e6e31934bb53109504c70c2de6cbb23dff71eb5f7dfc358061322d8694151686b7df12e5d466e0f31d20a8cdbf84c392e302bcbfb21492fd3d79b15b8b83d6b518f5508b806911b56a840da07cdf2a03a881754de769cb5933178572d0535de348ded5e7c3af5dbc0a46f2989d07fe437e83de1270aff7fdcb998e0ec1a07ead1eb0f5b8ff4cecdb82a63d34067b4146c1ef5443fb372806a19931f6da62f3951ee1a01beedcc6f102d14526f3e77d0552f7182bbf0e91ab935094a1790717655cba7a39618492d602d71e2e4ce7979f1a6de0d7bbb715890ec63ba43663fd233ed5bd847446cedc9f4e81681236ac8aeeb3fe1578bdeffb1a8844dc7386931',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('33F176B9859BEA1B3B24C9BAD82B0812','C52',1,1,'A+/F8idzzXFbRyUOcf3Qv+r+4zfsr0zDn0Nk40bia1kCYoqw9VtQTHfBEv++G++ev4sYrdfPLOxTCPPxqYlh3qOBgyV0W5GNoIWvT7fefzPOu/G8qjGznsItf9IOfeo75qDWcx0H6+hkGb8T6vL315sSq1ZodQQotGA18m/rlOjSwgQQxyPeSQhO2RbaxYTQdflHzMgGRRDjUjSbye/G+pOC6AeOkhWxjonj2ZBW9TU79oT3Jfp7vw2cHh+/0Xll2VLaApG0H1ffoSeEK6rXD4ZYF+v65Gr0GGRrvftsi8DCFAi5v+e7wD2yuXwlELqfXRclsh+/0L1UY/o9lqNLlqeEL6k4BFO3/xNzgOH6WHKEIFvoquJsIFIaBeloT2Gb2zEG4bWDf+lBL+ZJNFQRcVWIzC709faWzrwid/whUB9KyG5zXQMf0K2O4K8XYixmR0/O1C/4pA/RwXI31R98xNKZnaw/v9kGbcaNyw1/ki5zkntoDzR42ZLSf1aupnVryuHKS9b8vJysLtTvUYkI0PYbb5xhwqmvGis2Tpr8zjUH/tEd0oQkMJt+q83eKcanSLzENjZDMIViMr0e/PXfsQVw0NNbtO+MNCb02jjwodgl6sF4Mlo1pG4d0zGtb9fbOkbf1II+zuQsBBqbVLIgcvIAPvuCGlhCL/LWU5hF4BESGc1xHGKh4VA4P9195S1yX/McMZcARymyytS8OMtBmh6/c5McP7VWbwUne7xrmwgYcMyTLpRx6erlYKKG9QCdLDn0EPWPUaISBnuoWTfAonZ9z4MdfMkpPZCcGQpW1OSBkXLUPKoLu64JsTv5pwfROsiwj10vpaOyNEDW9h6JZqsolfEAYA8NCcZfeTYvi2W+N6iHj46LlAtVaAhbZjCJdJlq+aO3V9S2HaM1gZ2ElKe0op6xUT7W8qvUu3ayBNKSyfYPIruQWfrbLSxs7GmIKyyqqPHvkAzqDbDTnF/Om7CHLTYMRxtP1dyWttKDQ1z91caYHFm+OTh/8urW/iI6vdwL692ngfvRw+SzXBAVNxOCI4sMypxo+EJl/DxiW5E6rTyPwOSbz/RRX8y96rHOBDrapV0gXShcpDKY3BCM79HdXVshVk5Bmjou78wApYBL1mlN9MH42FsvT7qrITE0Kw9PW+h3h4Mdnx2RIgnwMDc2WoD854Ebb3RUa4y/88QzBW9v2fZpun3Kt54rdvx1Nsrh9IyoRR5kmIFiPUQMVO603FFbaqeZ0QV5JvC/MUNRiDm0XJ9Fg/KfsbT6AoS3McN+6MOsPdbUHUuibJi0+Fzs0ude/wXLPgcxjNUs2yjRbnB4/8O7H5t7oX9zntSsPKYh1Mnsx3cRl1dBBAlyPrpApohVYDOrh7/HgiYYbiDVoIqgadJC2XMOF8it42H2nI1xmm3OQ0wsj72AXqVioMVmIch5o8cNmI10oJgHCwM+BCINWejTgMO4a3RiMbwfdDQXGoiGygepACx91Yf7LA==',X'9a88c85947266fa5bfcb349844a4c6e48666b4c838179422ad6b50d486887d395daf944c03b8aa171b8d5e24d64d5bcb507aaff9f23dfcd42fd815edf590e05b3b8901b0fc3a8a7656976f6eda36b36346e2c1380868ee0ad6e8b07062f41dc7ada028a8d90bd21080756261c07635bbc8f3b655bfb974ce4b06a6ae30163a7638db5f61b7453be5dbe53db0f84468497c32a267fb9fa1cec47a82a40f7db30b8e0765f4413e82067ce5ad7edf12852db965743483bb88a1e319476e9cbe115c1d69495c0ea871bfd537e98105472cea6ee7552b2c1dcdf840df5d905032f425a0f7f0f6c5147a35a306fcc252568cd52def295ca9986c2719b76efff867c7aa',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('C467971E6EB4057E0AAF0839D0CA87AE','C52',1,1,'yc02QD3VcsuSIcUtDU4T9ko2sZW1brPP519igylIfWWWLVQtMhIRJX2eBdbWJKrfuxuY3r1fexT+QlV+NHnKVIn1bInwYWKqLuA/owfxpbqzUT4lss8S/4bMOU9m/EsrNilRDpqTMoTMQ+spsB5GDvm3o6mySWJIDUlWqKBlnWVDZad9WQlzQ0pr+Ai7xW2EtwJcsoCfSHCeb3P0KHBbIRss4l09oXNQ+m3vr4VK6p3Fm3HY2go4ksZLQk9fvpqtWiJTvThXoFp+bvBdSkSIzXn8gMM3QGQQmtVtqJSFjNkWUfvJHlzvirRAan511gqqq7N7g23nweRMd0uesEh90DKmnmicMfyuzk2wnxpyBZqnNKSp4RjnJZqRwPlU7jGLBI1EUD/mYF9YnIj14r8dR4KumHL3FMdZTf8Py1W/bIjhjI5okgDzUuXAnbYJ0/UL4hkcrNiCS1KsVFqn67HnysQuLovFL3IIQSiG81Ce++r1BI50tjQ3cSJnNwrcjC5OFR7LOH3gFLcDKixF4bFeeNB8fssw6sEsjQ/XsEGFEkrP7nxuLbRwc3t2YVoaOGf0BLWGcms2FJsxispIrXFu8hQy7hBhvTCSeqvANRn/2D9pai9z7rgL8pf1Q30kAEbxG7eYrNTq387l496dGBxToCEhaTRZZjch99mK6tJIkl7IoZMb+or5IjcJP/wUbMVLM4T7HqnsHH+jrrP13MBWIJB2VHKFvqFUgLE8XtSqkpdeAR71ul1oVoUq9lGmyeLc/Sc+MKF/Tsy2aoqYMx+k2+5SLFHoSBi8aRZWTzwYdu1GmtbIovJd9SYYgX/A6sU7xZ/Qk35BzyT2xyj+QqV9CqHLSAn8CDsKIZQsgLUrgng8BzDeSyZfz1eh2Zdflpw/+M4C0j79UhsyqknJFtNv9F57GSB5YOLBfWajKe4prO+2QETq7v0Fl5D2amyPxamtPnOLM70RU5bDATQd+5JB/5ice+CK4CsjC/eoYK6kfd8sk3OLVgYcljCF3G5lSViCwAk1oO5wJTDercqDuOM4hnBqdKCWwuJJiLiDCEFFfcLpMBCi4283cuyo7KETHKuTxDvT43QK5ZO1K2mInoiHrQjQ4TtKaR3fa8dW7NQk2NxpvhngPUpj9F3cjuqX7+FY0WKmUOYrTjvWxR1n3oizLhThMoUpJskapLrPdknEQ1zKB17ImSWe2iucziGqBJ9gnyN2A9zVF4CMEpHBUCsJ7Tkq+pMlSysMsHybUIEFkJ25jphadEZBH0e1zD6Bhq3aOEnPk3AW+bPg3weXvprTVCKO6CBoq1nEXqyMAHkOwWNcUZIWtKo6gEgeqvAT4Pmx5TbhmcotQpRHanEgRNvlTcaFH8uulC4AlYiOR7M1qSoiWEcnS3TE2lm7v2n4ZekZAjGAzO8erXSqlveLaD0xIUNcdn5GQTTWNxNAuHmha4TTu+I3l0UzanGaq2OMwKGg99MM/JGq1QaaSuWlrvaF2w==',X'1c7d858b8897decf8cfb1fff59d7d614631b1d43aaa8b23e7fa2a71367f8a9025f870da72614f6240d502cdf8aef08151f07f27065b616a29ae1e372d3c7dcc1fba7f216f3b42d73a3d21cb2ef20eeb0fb729d0788d0ca56a43a0a230d885b1bfe8a0322644e11aa6d54ffc4392023593dce67e6ccfea339bb7547c939dc56d2a0c0d89cfc7c0e106e63e39ec7b239f0d4c8f374c459cb533a51a730fbafb9c8355b5dfdb913beb94aaa2aa545ee55ab79e97afad8a89dd8f5abccde7efcd856dcbeb2223382adab7f5da57f5718b2635e7ef50abaa32227e1937918ced7b8c78496a1e39564b96e40841cd545fd9fe15e0d01205e4e69198e4c6159dbd6ff4a',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('FDAB1100255F643D625844BB129C70CE','C52',1,1,'7Lx+gwB0bKl7hzKfm////MFK2N2Jp5Y6kshu+y3zGNIFDq8w2c0hfAGavcGD+RR9Gc3IESWoGD/0nkFAemvTKxmQ8A2AfdeCVk2kRjJ0FunMznGFqlhXz2VvfVTEkrb1XzTjUj3QXfLHINbmQKTy/Lvj8WHz1lOGz6TwiDfo1BCfUkyA3xO1He/lmL3knebOg94qkuu584v8+jCh6PXwHRE6qDdSktfmvMvEF/nIYvA1I21zR6cHeixHkYV/MRbTHZ7lMd/ezF4v4saZN8iiuFjmmqSgvYbIF4hetcX/uioqnXtbIbahwB7BsTz/+jz8rtSRhYWVGvpkgiRAlth/YzTYIuiNNc7zK02mc12QetyTXo2wn79DoA/YDkbIsoPD/42XdDHcOIOc8vvoKa45beckUV8ryl3IVOtMSKncDEwXIJAg70tit+//sjhkGXb94amA73ChXIAga3kHjfdD+lNJek5pCILUdwSuFHolrUKiBNXSkLTf8K954Oz6DftXbfTvs6NDxTk+FnZBEzbOs8I5rLB1haxusHtxgRybg615d61Gfc9Ok9g93Cpk5wwoPujUi3P07I1S4iOVJIVQR5ktHxnH71nEV/isHa7n1EDvrGLxtNLxaNMFxDCsZpky2Y/I0O4IgurEBMrradWe009leTLQYbtgm4pHjWNXOgOL09SWJTfZnjbMU9zb3AAWFWd/gUvClxkN5GnnQyoh20IIml1yjID5Q6vsr8ujNC9xxoiKGfighKQPolE6v4oPVXjaSGcPehhKPKhgTPEN78YzI6fy2j15v0wBrvl4WEGPK4vfjJPSbBNAfazHnMwjXiFfd1AuoPGNsVTQfUpCIlFrlCTo9TU4rGTWcCYUw5/AcDalCBBszbeh2n8Z2ON5aoqZdu6/86Clu/ueUOVlXGuL2sgdOHscagttS8WbIx1rKIZka/92q7Ns0M/XZOJhgls5Z73LC40ljjhXSptvGOuMoBBSNDFawU4XicqS9qtBLb9GcpJ0TJGSP2kC4VWmTyz6VWpnCHHxrxPFXUOAefazYVdtMe1XylmCV6kXxgNozXfiavR+eh4cyuiH27s+2P9MEmMzXW0PqECE0x5Yi/PZ5eoEJVRMT4wVL+LSQ/+RuQceR0SjQxGKXsyi9qRJrPou/rdBK2ZVYT9n6/1X/EfooQVb8Rio0/yNAT4FT12rAks5PPWYdcdBAlJo8OjnPw8SHo7UxgaxXYLBlBiWSCRssLi/RqftXAqBiSNZSNezMWtrJcbxvLecPCFl2PDjdYzyI1+IbCc1rQpJ+H/pl4bpDOFMNVEsh9UIKUBuyPviyV/nvHxh74/KGEMkXIFME3KXQbcQrnc4N5KCh//2TYwlUZ4OelXj3o3ikIbLYHOjUCtMW+j49lD4KMrTKDClpMKWhATTdLoS9MPsTuURmblcc9uxFvACn2QnL+nWjYJx4ttXROXcDzF8h4ZL4fFM+FoHn+S9XkJPC2TEfO3A8rtKw3+ZXp/z7O6+1W8+DYbHKu1BtkPeIsh6sFRIe7UBRRGNVgum2zT5LRrovt6te7CpLJDoIL3rWOnib+iZmjJTIKTjVLBUMbMKLUMSbFEa7fRbUC6+/5fF8luI4aepaMk0FKgOQ/0QmOnkTiwNe7A=',X'4eb6d5cc5781eb616d73f65322ba584b2920584a277e85f0954a603c7c7f1cbba054a445d97b1d96c45f5e050804e9d3f0cc256e01e8b97d596bd6b3caf8a9320128a3e61abcf91ddd315cbaf6f7ae26ea0add5872c592776f47e7b4e62bb31ac0b02f5e1ac57ec5a1b8db9c27996a2f2ec08715be4345a681a63beaa8a3494048c627d3a1b5ecc6d3618d971dc31eb9b2462d6b00748bc2657fc5db87791c8192e5336073efebf153c8d82ba1a56196562578172fbcda3a69764b97904e29e8b8403296873254b888fa6438eda8718643e475feeab406a46118caada73e1ae95729a2e91658015f8b3072835b7122f45930a13b42949bb539269be49c23d9a6',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('8CEAE5F3709D886BDD33C8C47AED1027','C52',1,1,'MWYy5Q4vX3CMOy+ldupz85E5p6h+z0CENZGmMRB/kTceD530zRhYhHvgu/v1wCRh2ERh4IFcJ6Xor7fNxfI02xsnoGuBzZjnrMiBRcIs3MQyz+hMdhi2ITIkTTJdvw9dyEUds2i9cHNbVMoIWoZzJHgzT6/mQOLxDZkU88EBZDuosN4sYvPWiUHRBRKe6kJd7ZOJwozQbDT3Y4PmFUVr/m4FoVdPbA2dr5ZED4VcN8A2/bKJFkFxGOQzS/1nRys3V2MvsaC5nUMFylKl45K8ITIfwy6dmyCRus5ocITaVBikhqUgLuz5kU/W6a9fsK2ti00drDptaePiv6akSwMy+sivrLZpTB0s0IFSmVyM5uRUvm9k8MjumHdheJLwgCyOxZp9YGxCCnNhkZFVO2tDwhIIbMHgve0oTHKWSqNvWqNu4KLLO7l7fmVXFMh5dlJfbEUzyu6nnwL1o9LpXX3mN8KzFVcxmN5qosDt6VWmELzxSMOwXEAxz8V2L4XblWBg6oa7yNvpnJNi043BXl4dDm+CVLOLOC6z0GX/hIKSzY+/fUarUheblz04z1fPgmtm0Ou2RJPSSbe/RavBj+zy2aYoguDjOf7f2U3Sc97ESd/uKkWSO1TfsadPbaWQyu9vV9W9sByBkegMEjYnKZVMFMkpoRfoBm82AnbtF675NajnsswLVDPNmZDW9XmAOMqO/SQRgIw8fSTD1qYZLaI/t6zWvN+5xWhCZmuTLxvbl8aPSC+rXoVOAbAlLOwLzputGTdr3Pdwfj+c6mbU3NFa9TpfQ3TKfAi8boCzE+3gwDAcRHmh0s55WGcwh4qWg2zcYYREJx4A1Nn5zYX7MrKqGca0hO2xfJ16eV/nXtkbUedmMqJetppOGUNqWGrl+11+jDW0UreE6F6kTT+q7cbrHzYUUhkeqM3JEG9VRwlTuCKJxDl50d2IZUUaz9HnweZ9q/SEqQfQK84pi1Sz0jzujo1JZEuz4xS1Gr6dFz0BS23zPvEGvc/jARQIzeqyIDxIgbSl32sV/zxMyMZCRVYQvaWbnvHKAEV1i3QHV1XC5qOz2X9qFbI5hjuCN3TnXIOD8bcyzG3XM7EsDock4YbT7VqqxE2QOGXKT9vZ1w8ywRQDJtBnRBWLYhS5n0hudmy8klwxg7VBprsz8wNQ3NO18EOVdMQo/6ocvmrNQ8ZpJV5OdS0AvUMC1t44+8P34cCrg1f9jvEB25zGosxTinq1efhaimFmXNFLvTMnMKh4/Kh6W5GsZojQQA9vTCHtNsHBAhwMen/J2//enGTzjlgQ5Kc29dnjOA3rLBLOEvb+5cceIYfYP86NUWuPq62urAxYV768VB4q+pxa7jao5FKjHOuK64hVqyvgeyC8iG6D9j61tsFT+xNSi261Xm8Qrlsck3v2zn9vBc25/WBmWdlXBbs6k0Kn6I2m3hKVUdWGU9iT2DK25obtYMjnyFM4s1ugXjjoIrQIqbq8lWvKRoUuEJBaeEaU/MbKaNN+yqSE6mGgUbh16/ninl1yrmPj23wOQyRvNRpCYw0Kgs67AdVRwKYvSX+BrB1XcaLwAgYfbiCzyhDOJwsjQs0BxHH8OUDqoWgeg8dQg+prvi4YaApTM2uSobs+e8U9uxZ7xihQ5i4=',X'789c6b6d5b2d11d1ccf4e9f2ac2e5a89ee4cb02221d04c1c673a7548b22f26b57af00cccbb2ea1a28b941ef115e8a01c0dfbbaad278873e3b613a9da1c558febce3974bdf41f740cd96c77875bc868cb8f007bc3ceb93956f6a45f65f03527ac8b4ff3a603ec5d5a9c767034e8d747ec29b8a838d3064cd5510affb0a9fcef8453da8b3872002b12cfb3bfe8f78f78fc5039da16a867079efe9441c4f7158363be1c88d3ebce57425c5fa9bd1f87fde81fcb8a5f4c2dca1b50ebc70a29bc8c535f5e88a4f5c7097f305de4dff809674076f1791b3230b6fd6d61c8b6c301040523d41259e0aa9ebd5ec9db1df600c7b4dd26c3623ef31f22dfe20711b3db143d',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('81B486C23C99BE752F9780600A995D23','C52',1,1,'pVh4xLEMJdH5COUcwnOIhyM8fRfdr0hH1cpzDMLMLqTHYw5ieQW9rsYRm3zhLJkB7PC/eUcb3x2BfmapBZK/R4H7U4itWpA2dL1eGlrt1k1rxrSKpFICiREQfbH+N7EoH205LUSphTDmnSSWo09njZNkuWNlJRKrh0sABlIqCNNBz7ZEC0FWZWMSKgZkxcU0uww54ixf6dOkSKfrGMQNyJAP5YhWg3Okprn9KnKkVpBgKfysrtvfb1WG9ndCizvacq4Hs/+v9/ssfiu4rQAjSdDyHtaUWwjaSvmwqs1uxjTaYbdgnnU5FNzxFOA/CeGOcDI+/peJoQaVBfH4ogWoO6FC+xu4PuOnZ7g/WCBBdFw6+Yw9SeHETqRiKXi69onYI+Mgi6sSstOkjSAaKNuPidyEq5QVSR0EOU9eosH904H4XUtpM4hhkNo6pj311O7nlYLw5N7ihQ+ycBRMY0xPelCkDgdGgRk7Bz8dbCOL+DzVtAJrEXakh1dDqXxy3o45loTRy61zXvWm2XMv0iBa5xtkopfzl3Kn/9O/pUIyL8XxGbxJYpBbarRJaU1EdhWIhSvPyEnyINthnIrUhNv5QSkIirebDJ48Ag5+QGVb4s1VRwv6llHkSnow1XQmyN+x/H14kguis3HCz2Jg7XE5NoYcd+atLqzXju/PDCsjBJZmvb5bqXOQD1yLqHBSAhQ+PiLjhSPqOCnMXia/3sJrxsfDZ+8ATSDM9wAJrfJtTgh2TTfzBXn4ortTKEtsFQkwwsnLLV8p5RKo7Vaxzs9BnxZ9r/8MPBQkJopvwOKMG/GIgomdL12qo2gBGuXc4i7diZAbHJH5Y8ZCKaaUjpA7H+KRSglwLVXvAr5vxaFLeCFcUn1Qv2wMCjgIqFO89vNk5PV3j9nMl2BZQtg2YRahKSkNxhbm+oD6YT5+qkNzz88ncKj2F7Y07C2o+wIdOIU7aTIGe94jgfgK6rhHUgwSvyaX9B55TmwWlvVRCas2gf1Y9CqCwkjPCLlODA5YJadWEXIAYjngV9qM/kNLAYWNPjgW3Q29/kRniRp2Y/xGmgqpOD7jLl1JEdxRvIVjn9/DO5J+jZQf9UUp5T89b9OoH4UkhttEYKs84oTGwpbiagPosLsQpLMi+WXjaIDvbGmc+ahrZhNDFCs6mDsDwrBNVGeVMeY9fUXiBWn+nmNwC/vBWLom7T0vLXkowH/hSIV/wI49lCVKsQQ9on7JmB9AZKbh66MsbWL4Kr33/ggdGvvaHEzQFepKsTPTNU1wFitcCS/SlniTAaVthxAsQ3rpTQUCGPYAq4S9ubA5MzWfrVVvbaPkPS6nzgBU1+8umM5di+Ufm+eVhGtzBJTycBH49HUzBWfNdVXkhcrm5XhkHqS7ePfiaXCmHLYOi8kJUHVBpDiSF/ZNFDyp4b5xYu7ehUp3QavM6QHjTdHEuavwe45sV9HWiKBPKeHwpwghqoq4IzYAUT8w6YhsINAePaBVfx3zvc+WtdKRiGRgKyBNpASLHjb6J+4kIfvw9xpZlRdlmbk5tZrPf+sbupbpTHLeVEF7l6nZ/BjSaEruvIROxhd2mHTtxTa1xfhzjZf+RE38h3F5ezfm1FLsfUtnJZxxnoG0k8yAr7ohaadcg3ZG2pw=',X'20e7e0a2ca76f8646e062ace1818436b126773964d9bb6f99e497c739896b480adb5472ec26249d03bfb21e29c5ac7db69a8863f1f9cf0e0f8f6fdf68a6360178949fa358e76fb8f1c66670260b23b519bb22bff85be6b627063706cd8c93b891c0b8a9c4b0a587495a512d5ad80c24e0920b89d4c69de4433cfc9573e91767f9c980b59560f4f7b8e780e9bec4e40c13a2c5b9e6678a4704b1352be894788ee063169740071d8881fba38ccca15e3d3cb7c793ae89d15170e878c048a257bdc90935190fecb5eab177fd7a29b177d093cb2cf3c347197577eb01b0aaecdd72c3fbe1b6406b0c36f55b1eb43a4cc1f2e8e1242a6b34d5d6c54c4c07dab952960',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('A67B0E79132A502B7D5A02D0512AFC9D','C52',1,1,'gujftzDE7Sw3KNI8MOMV6GBbJGeDXIvsiSkS9P5729QLFNk34PBQ2PPK6fX0ek4AjqS2E1AI+FxOqSN3GKs5JOB2c5yZYB2R+LotuFE5Jbcp5BKBgwyyFiKiZCJv44FR0MzvwkwNO8qRrBdGWZ29kc284WWCAIavSqihvyCWz1pmYOxGTx26Upe66fJQx/bfeY42dWXOPM3dyCcoDcWNfkKe8cIdtWmPlvNRYf4NSEbfyhAW8coULfdZPaqIaAatTTlHZDbLfORJC+VajMIxGyRpKkJ9geztGZMlHTUaO12QwC4oBz0CG8tcCahxqro5qG7R4O6pTsCp0NWQaKPVGhsxCa/HwQhAYOkVC3R8Tb49siOgw/OEg+WicDdw0TAFqX7AFxUhDORgO2+uJfuRDQV56LnRc0j8TgnEkTqgR/HzyWeLUUuaX9741BWU8T/ZnTRx+fBYLOqpMC6UAsr+ajtKPOxcdTskhP1vtof5+ChWS9xwnM+2/5WSxxCsqjoEuAsmy5lRvJZqMwFET9duSz1kWvCLrzAOvwhbM7FaLRwUh0iFlA+3aOHaOJtwsZNbxxLhK9u7lB327amEYRwYI7ltwvjNfhMkmQ0MSzC++3g76YVz9+xUNkGqIJbVHKLbKyhuwAdY7PqMPkBAdSihyaa9jKI8tKe9piP2CUE2ZZwxMlapYtL/2rP4JpUeh8+xAn6Ae+jTI9A5+6+fet8gPfnWsjhFg8iJ6myllsAgvmDBYSel1p1Q9T6Lg9b8NDRCeii1LrRQ9YmsYvQrr2L3xGclpkjH0CIGQYOplU/fSJyDVGacEhc+zcsVPWthOSwuLXgMFAOnRkYvZiOQYg6nV7Ag3LOkqpXTI6r0vPryvwGLey0YdQ0IZH9kFdMdqhGZY1+iEeuHWTuK+1WrpArqckQEwkRvrSCr//hMrB1a+GBtcekd4oekDqXyAIHIhfpsOdq6JDjECiNJt+AgdvPLtQbLhmlEvJ5Oh2J9l8NegP5E0D4rEeSlgKS2J2ttfOjabyaxEVFfzftPrEPbcup6ggkYNDqKb02AgfQOuadan4BhS0lzV9tLzND2N7mzb9Vi2iOa/I4VkSpo51EJ+N10N0GjBlD8OPE5hUQbUXzj7wikUj7KpTxDe4X9IydXskJCRPvgan5XJbITgWmsqdmNcwvxiIAC/4oQ5E8WLRtfuV7YHqihuFo7uJv8maHkl+2BYmAIbgGH/8r4/YAGDRWYB3UI/4bsdcU1RE5epdAX3oAZH2T4Ob9LykazDsWyXa0az8z38cqMWQSjjXhoerE92I4A6vfH95En1CAObv/6fb0J8byTIc/rtWiOwFI0k1dLQbrHMQh2gxxWry8YbTGyGckTd2WdRVTqdHlR2O63W/1v0ZnnvSnDVW2DvJ3xTFyuD7M+GjNCHnyrw2ux1r+2/+cAYUt4TLkfF0tXq8KPZBvGwcwoZFFJp7AREJrxQw3Ob2BaLMgrpM0PY41XTHrrQyX37eY6fsu1u3YvwTUFKwe3XiprsEZShyjW5xrqRm4tRvqW/r1g1p7Ys3XK5lt5oPBIgaDa5iRN8mxTnmfOC2zV9i4WQ6WGg/7Gf0ImevvH5vWfC5+NYPaPvjC/LMyPmrOYcdGpJ93GmpeLsdJbuc4=',X'121a66b7283f589d0bdd746c17f627dae30c926c732f5f3ddded6a8beabd57604d3599a6daf536ca9f546093a579c0c57ffaae44ae92b87af8cb4e2948b6376e674ff5017d79671a4c333038f2e3ca46bcf28277a203d2face7f2c013f940fa2f83209602ae4e0a8f530e799b2bd239a59388ff8b29afe950f4c00a11d77ec0dadb65bf7a7235c58dc6b15cf717cd6d30d658a71531853c740f5290b9fa5f342d9cb5117a761134f006b95b42a6c73a2850b06972e387d7705afed2a72f336a5c37168de483584c320a5f43b230159152b81cc4ef7236f7bb6f02585a3731ac1aec9fd0f5e3bc655f82583b105af58320362622eede98d0dc72abd53104d95a7',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('C72035B87A123519E24B700210CC782D','C52',1,1,'OI3ju3Em1GnksisVfMTrTPlLvtbY7ZefNNKUPXHMA5RjFJiomC3X/POkoTn4hnWnsq1apwX+JX+sUvV5veKdjjgs2xvWurcsd5tjjVujaDiVxSkX1dl/Huz78cTEuKEd0uHWsNHFM+r9csrLJUqj+ICnadDjXxZ8U/oMv8IQr+oEWBb4x6TrcbGML38AUktDI7uyN55KoFBqMzSXBDPL/uMJF25ghNFVw6CE1ZsAd+uqrd49EZgOqHTk5cOBbHuTc5Qr+EFAvb5VTaUU685n+8CO3iGz0HsG/Urwcd8MWA+6pW5NkuzUcSz0V+w+jzRZ4FXRumIgzLtHTtuJnnRGlWpFNeD1BAym3YW5RSkCMvjmu6+w+/0LY1hdArK05uFTF2ONT6LZkkYSS6xR44cDg+6cZT1pZeskfIR+kNNHE++yazXBOSTe5Xs5pw46clC4FpdrDX3E2eGdaHfwSXy7LOOaW4cMIUk29Jyh2P0FKnXhuqQMylaYgRAmk1MiQnh8MossRTn73TJrpw4lxNv324FH4q+v9Qyk9xfqmBCLhMu5STyylp9wNwe7YvefJubTKtz86g70RDx2+9PkgpG348ZbjX5m46Rcl6TbuWyhQk2J4dmyffybtyOFs4ZMcX6zeOIorNwhg+Yxr6MZeEtHoB19HuHcBsC1aDz/wFC3xShlbq+z2RbG/UXIWClw86qTvivU1GfqjFbTgUjC4lMwqRg7gcp7gDtsv6IhLlZD4cLmp0BOPrasAIL5xOfX15mxNvwmXbimHEABU47PZV5at9U8ZqPbkYPFTf/2J9Spn8IH5KUVziKpuJEJ4T0mouxFZwJNasZ4mK64+gQ/tzVDd25m4yeHsScPW+isi34QDU8Ylp9DMisGXqTygnrbVdTicafdKMgCrP6iYxXpEhcY5oLB3HjywLLRkbP2J6Jv80DK2hDBwQ1F+OZ4RTPhbGJdIseMsX/Fk2laf9kGbpJHUnZkw1ERbH6mh9e+jT5r6mUtX4C8PGGDR9Vr/N3u9NY+iNLi6G5vS+OyAel0onS9M7oWqSdMz3caEUVv+ntqp4IhBW2qX9SXKrVyeItgESkc+SO1oDpXf7lU2yuFzyioyKdYcYDpzT/Gc0m5pU1QTo4j2WOKBPi7i5fBJHlOGqpiSRVBkYeM/q49Mcqv1EKEVrOWomg6kvS//jr8wC/PHoJzwk/e1qNdvIt8D2ee74CFygamFPwe6o6R/CyXmhMLzMjspMlai+Kh/G0/0ieFY0mK9J++7YmceD2TF4Cq5zKDe630aAguuNm/eVKD/iIYLrwWwsBJ1kSs6qAk/dDyS8NFcfWxM2LXLRxy92JfAarQuQvPOHn6ZTQFn1xNmCEn/IqbdzVAC+UDKrS9glpOohXphNpQjnthp2Od7hQH5FNLeRRtsYUNrOd9JFIEioiffcw3mOvzalnRXk3KNAe4ccnO7HaA5VTuG5JaIRyJ0qpyJLsbB3hqh/snIndyRh+mIi0MonxfhW/mxcD4C+Rns4hQvJbLAm5smqAWP4BqbG+dJluMnpoPLt5p9Dvq8QBQQ+c2nidZWuPr1OPl564L6rqEXIl7WbVvn27ekiugt+2iUgLXeB+74NETnhgAw7bMqLbSaggvhDpB3AUaQj1IWKE=',X'90bcd2cc6212e4b4fc20dc3b16c9588e7259b26ae06fd180a5aef72296ec04f8a2a7dd1a5adec400bc5b3b392d34ef9e71a3aff51cf32aadab725d9ba8e69b148da164ec862dbbbd6ec16f4b830c3e31ffdf2a08c1951d05c29f159744f602f2f1a6cd274e3223f3e05f3d9fadbea54342c6df0aa0f562c12f93a87627d02b91c9135ad007dc14e3a9e30a17576287b571dadd897360d4f9229c1f59a8d060e4e29576fff603ba8540609f599455bd421a8bb9be24e02b27ea6d7b999608a74324511cf32a0d8d99aa099380500a1691d7af7f54b3a872997cd20210b99981002df9947d69de7a51caf6820db1eb0f9005a24655cd2973ae7cbf9301c68c33c8',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('ADE46DBBD0C1F956E7A603DAAA722469','C52',1,1,'A0bgDmsjlAiAS9eGK/3BKG4aTZ8eiSfWSuZDRLPt60Hihi0cHYH+vPNAOtc9JF4Sw5ec98qBR48Mu5ptHNFlj94HOrSu1tRDjDezxOjywWjKf3K4LMgvyeoFrMxg3ee38PHwHoZ2fCdXJhM61vimkMDPUM9RxP6tUvLX4zogTJd09H/Smm/lqjEBfQtg6Ln2Yk9anred4OWoiSBo0GmZQr8+CuLTudSwYsV9ZIBgxE2XJ2iy3CLFuhZToX+rCW8dB9U+qh8SCMfj0XYp15mS79HOs6KZ4o8EUZUY2Z60uNfXSyixXqbyEliTsGWANu1k5tTdJhox7r+hPER9OBOMErkDtfz/M37Fu5slxIMmhFJQ/d7vnoOqM4Q+5/vKtYw55aACdi9eNj6aAr25P7eqlVOJYRYdtVDaJRp9PmSXklV5pFjOl3JXNeDpeK/CYlEI0gbkc5wlKMIrNktN1VqeIxJR2DEVoOIZ1TSgHSLbqjaT2GbOAfMO9Vv0DgPz39LeZfDHW+awU6uUTSDOjsx+XvxITfSsswgw76mnDzkAzPm4oR3XlYdo5Hrx28PxPzzhdEmtXkHrKJQE+exKCve50LJ4k/nCraqSn3AEAf0+NKJf9zd5XfvQ6GpNKNrLgWjHrVEq63D5x3ldEcvbAGBxq8kihDYLeIekStLd0O7siTjKN7Z6Kunyen/xC0F/UcXv/w2KWl2PLKFrwsG8lQUi7woQEC62IeHTBW8K2OInpMlelhUo9q8u/NzBtzmqWMxzVxikAQYnPHU5/re+ISPd4SOBY7vXMe5xqElj2wLtK8fri1PGetjQWpgYkJaspQPiE14jAMhj+6eVvQgGaEV3eSSf/vzraMR1+50G3RqqCIcaASzPl/bf9mfgvg7ZHOpal5eg9pKGzM8KY8A7UFBjnI2evWO71hNE1vtsR7yUXWBIIzU8buquas+yXvWS734xyWS3kXmomDPXMFJiIrndcGz2wzOeb4CK+7qs9ekHIBILd80NEXqDBKnOcrTIgLFznslew5Qz9ZU5IQy7/2yxKoocfrzQvsJeDZH2bV+yrWXqc/FsirlHh7jw3Xe5mP+30KnC4Fg7Rl0qJCpIxRBRd7/Y+W+E+Ornq5E2r+8f3tJJbBFaplO5wpZq4eVO73anqT/vlv4Lhxleueztz7hJLRYKiEibHwdgJpoDto58Kkp70oct/y1XwFzjtiJ6S34HyZEXBnuRltuHhasZ28jQWJQmIt6NgQ95gn2wKJxrxxa3KvDVEqFsevuCqfNGVoAIH4lNCihFXPf7OsbET+xeS7Wx3wBWFz2k5AmHLwq8inhv9wc1PhwBC6wCrKdZyI315L/3nRP3sZTPwZEck4lGsUXZk0bAJNn4amU15ruaoOO2NqdO7joUcXVmeReQUniF8mKe5+ex+mzFZal1m8UdZq2K6E/m8rx6/wiXt79nf4U9/tHa2OXZ+8axcnrANPD6KoJ11SgZdd+5GSx4C0ft9AExQ8nl42oGbT4IBdzDPLr55nnxv7L7i5neuF8pqwspTrZJVcYUUsuFBjms3/LzP3+7K1eM7ThFLSJ9MdNGZbqL+vFZu3+x9H9rI6J0Mxz9U8FyvL5ftB/mpDOCKUo4VB26Ghvwkg4p37mxxRaxKMI=',X'a6be7fdabf80de7e316961d59374a80e4fff0936b5ebbb9f315e747f6c8693e0dcbe6e95ffa1a6230c775bdc0d3fe5fe00d2b05b553124df0db3d4c6e9b659851951084e383297a7ea78d2bf490d984cc17da2d15ba23b4dc85e80440511204b59be46a4b9abff8dd00e023dbab0fccfd7ef0e2bbb02b1f219a5b40692657fc345be333b55742d8e5a504e372fc9facd79b6bf748a7bd0cc4f588cec9974d16a96b7d74458eb01d68bb85a5fb5d4854a0f51d5f90ac1928f28ceda59e92058d3fb908aa45a8c5c2425dbd278ce4da2a28704e92e90203400ded6f375532c1704aae68a23f20234380513e4c2fb32cb69bbbe23407d150af16f42f86f867a37be',1,4096,0);
CREATE TABLE EbicsUploadTransactions (transactionID TEXT NOT NULL, orderType TEXT NOT NULL, orderID TEXT NOT NULL, host INT NOT NULL, subscriber INT NOT NULL, numSegments INT NOT NULL, lastSeenSegment INT NOT NULL, transactionKeyEnc BLOB NOT NULL, CONSTRAINT fk_EbicsUploadTransactions_host_id FOREIGN KEY (host) REFERENCES EbicsHosts(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_EbicsUploadTransactions_subscriber_id FOREIGN KEY (subscriber) REFERENCES EbicsSubscribers(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
CREATE TABLE EbicsUploadTransactionChunks (transactionID TEXT NOT NULL, chunkIndex INT NOT NULL, chunkContent BLOB NOT NULL);
CREATE TABLE EbicsOrderSignatures (id INTEGER PRIMARY KEY AUTOINCREMENT, orderID TEXT NOT NULL, orderType TEXT NOT NULL, partnerID TEXT NOT NULL, userID TEXT NOT NULL, signatureAlgorithm TEXT NOT NULL, signatureValue BLOB NOT NULL);
CREATE TABLE BankAccountFreshTransactions (id INTEGER PRIMARY KEY AUTOINCREMENT, "transaction" BIGINT NOT NULL, CONSTRAINT fk_BankAccountFreshTransactions_transaction_id FOREIGN KEY ("transaction") REFERENCES BankAccountTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO BankAccountFreshTransactions VALUES(1,1);
INSERT INTO BankAccountFreshTransactions VALUES(2,2);
INSERT INTO BankAccountFreshTransactions VALUES(3,3);
INSERT INTO BankAccountFreshTransactions VALUES(4,4);
CREATE TABLE BankAccountReports (id INTEGER PRIMARY KEY AUTOINCREMENT, reportId TEXT NOT NULL, creationTime BIGINT NOT NULL, xmlMessage TEXT NOT NULL, bankAccount INT NOT NULL, CONSTRAINT fk_BankAccountReports_bankAccount_id FOREIGN KEY (bankAccount) REFERENCES BankAccounts(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
CREATE TABLE BankAccountStatements (id INTEGER PRIMARY KEY AUTOINCREMENT, statementId TEXT NOT NULL, creationTime BIGINT NOT NULL, xmlMessage TEXT NOT NULL, bankAccount INT NOT NULL, balanceClbd TEXT NOT NULL, CONSTRAINT fk_BankAccountStatements_bankAccount_id FOREIGN KEY (bankAccount) REFERENCES BankAccounts(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
CREATE TABLE TalerWithdrawals (id INTEGER PRIMARY KEY AUTOINCREMENT, wopid BINARY(16) NOT NULL, amount TEXT NOT NULL, selectionDone BOOLEAN DEFAULT 0 NOT NULL, aborted BOOLEAN DEFAULT 0 NOT NULL, confirmationDone BOOLEAN DEFAULT 0 NOT NULL, reservePub TEXT NULL, selectedExchangePayto TEXT NULL, walletBankAccount INT NOT NULL, CONSTRAINT fk_TalerWithdrawals_walletBankAccount_id FOREIGN KEY (walletBankAccount) REFERENCES BankAccounts(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO TalerWithdrawals VALUES(1,X'b40bd3048e9c434498fd978d3372cced','10',1,0,1,'FMQZEATC840WP331DVFWF05XGB5TZ02Z0RTSS19EBR92F8W6MFKG','payto://iban/SANDBOXX/DE989651?receiver-name=Exchange+Company',9);
INSERT INTO TalerWithdrawals VALUES(2,X'fb0013a5861b4c29b8534cf32fbc9f29','18',1,0,1,'BXCD619SVE1MCJGCBKD1CFAMPAEZ6BRJNW8FARPV56GMV3YM1BXG','payto://iban/SANDBOXX/DE989651?receiver-name=Exchange+Company',10);
CREATE TABLE DemobankCustomers (id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, passwordHash TEXT NOT NULL, "name" TEXT NULL);
INSERT INTO DemobankCustomers VALUES(1,'fortytwo','sha256-salted$DvU4uYLVRws=$ssRHyRy1bvlQWxhlUh2iCAnJOmbcDr+aYEL1PMUtiMI=','Forty Two');
INSERT INTO DemobankCustomers VALUES(2,'fortythree','sha256-salted$Nq+g9YLTUHE=$lDOgz5Q9kxOqEG9lvkJuvL47SoFp7ZT5ujNEtDzARTY=','Forty Three');
INSERT INTO DemobankCustomers VALUES(3,'exchange','sha256-salted$SBIl5I8Ekzo=$lcU1rB+k3PAXSLtuGC/gMj7KWd4NG5nZ+nuVV7mcVGE=','Exchange Company');
INSERT INTO DemobankCustomers VALUES(4,'tor','sha256-salted$FIeJJ0+C9fs=$RbtMvhpMAHFSuSnQjrTvhyyLzW3fyODHNiE5CCMvtlI=','Tor Project');
INSERT INTO DemobankCustomers VALUES(5,'gnunet','sha256-salted$E23sUCdsgLY=$TV2aRf5vkmweaGFuAGJE1dpq5PWg6Z1m5LjjA4FaTGM=','GNUnet');
INSERT INTO DemobankCustomers VALUES(6,'tutorial','sha256-salted$GUURsfEtq2k=$/RuUEJr5ugm9XpgcFKDKGNEmuUxk1UYLi6g6bo8oVlI=','Tutorial');
INSERT INTO DemobankCustomers VALUES(7,'survey','sha256-salted$zk1cUhozqFM=$id4xtGsSMPVbwyYLL8b8I1XE+mcqJVLeBOXS26kqbmg=','Survey');
INSERT INTO DemobankCustomers VALUES(8,'testuser-q75takwr','sha256-salted$DKPF6LUCyp4=$ZIvTSwpeRDiA5LoCSmx+P5e+T8aNtho6IEVEGuLgt34=',NULL);
INSERT INTO DemobankCustomers VALUES(9,'testuser-cyokoxmp','sha256-salted$FJCNgh0LwPA=$PpspUOdbHzFg2XSIreQLaFQhTc0Xce8cLCca9K25Ao8=',NULL);
CREATE TABLE NexusScheduledTasks (id INTEGER PRIMARY KEY AUTOINCREMENT, resourceType TEXT NOT NULL, resourceId TEXT NOT NULL, taskName TEXT NOT NULL, taskType TEXT NOT NULL, taskCronspec TEXT NOT NULL, taskParams TEXT NOT NULL, nextScheduledExecutionSec BIGINT NULL, lastScheduledExecutionSec BIGINT NULL);
INSERT INTO NexusScheduledTasks VALUES(1,'bank-account','exchange-nexus','exchange-payments','submit','* * *',replace('{\n "rangeType" : null,\n "level" : null\n}','\n',char(10)),NULL,1660992721);
INSERT INTO NexusScheduledTasks VALUES(2,'bank-account','exchange-nexus','exchange-history','fetch','* * *',replace('{\n "rangeType" : "latest",\n "level" : "report"\n}','\n',char(10)),NULL,1660992721);
CREATE TABLE NexusUsers (id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, password TEXT NOT NULL, superuser BOOLEAN NOT NULL);
INSERT INTO NexusUsers VALUES(1,'exchange','sha256-salted$u4KRdNjw2kM=$TRMnjnBXOxtr2ruAwGdOsFOmZ6J3bgTRBfqOfVxzpYY=',1);
CREATE TABLE NexusBankConnections (id INTEGER PRIMARY KEY AUTOINCREMENT, connectionId TEXT NOT NULL, "type" TEXT NOT NULL, "user" BIGINT NOT NULL, CONSTRAINT fk_NexusBankConnections_user_id FOREIGN KEY ("user") REFERENCES NexusUsers(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO NexusBankConnections VALUES(1,'talerconn','ebics',1);
CREATE TABLE NexusBankAccounts (id INTEGER PRIMARY KEY AUTOINCREMENT, bankAccountId TEXT NOT NULL, accountHolder TEXT NOT NULL, iban TEXT NOT NULL, bankCode TEXT NOT NULL, defaultBankConnection BIGINT NULL, lastStatementCreationTimestamp BIGINT NULL, lastReportCreationTimestamp BIGINT NULL, lastNotificationCreationTimestamp BIGINT NULL, highestSeenBankMessageSerialId BIGINT NOT NULL, pain001counter BIGINT DEFAULT 1 NOT NULL, CONSTRAINT fk_NexusBankAccounts_defaultBankConnection_id FOREIGN KEY (defaultBankConnection) REFERENCES NexusBankConnections(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO NexusBankAccounts VALUES(1,'exchange-nexus','Account Holder','DE989651','SANDBOXX',1,NULL,NULL,NULL,15,1);
CREATE TABLE NexusBankTransactions (id INTEGER PRIMARY KEY AUTOINCREMENT, accountTransactionId TEXT NOT NULL, bankAccount BIGINT NOT NULL, creditDebitIndicator TEXT NOT NULL, currency TEXT NOT NULL, amount TEXT NOT NULL, status VARCHAR(16) NOT NULL, updatedBy BIGINT NULL, transactionJson TEXT NOT NULL, CONSTRAINT fk_NexusBankTransactions_bankAccount_id FOREIGN KEY (bankAccount) REFERENCES NexusBankAccounts(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_NexusBankTransactions_updatedBy_id FOREIGN KEY (updatedBy) REFERENCES NexusBankTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO NexusBankTransactions VALUES(1,'AcctSvcrRef:8SB18L48',1,'CRDT','TESTKUDOS','10','BOOK',NULL,replace('{\n "amount" : "TESTKUDOS:10",\n "creditDebitIndicator" : "CRDT",\n "status" : "BOOK",\n "bankTransactionCode" : "PMNT-ICDT-ESCT",\n "valueDate" : "2022-08-20Z",\n "bookingDate" : "2022-08-20Z",\n "accountServicerRef" : "8SB18L48",\n "batches" : [ {\n "batchTransactions" : [ {\n "amount" : "TESTKUDOS:10",\n "creditDebitIndicator" : "CRDT",\n "details" : {\n "debtor" : {\n "name" : "Name unknown"\n },\n "debtorAccount" : {\n "iban" : "DE371825"\n },\n "debtorAgent" : {\n "bic" : "SANDBOXX"\n },\n "endToEndId" : "NOTPROVIDED",\n "paymentInformationId" : "NOTPROVIDED",\n "unstructuredRemittanceInformation" : "FMQZEATC840WP331DVFWF05XGB5TZ02Z0RTSS19EBR92F8W6MFKG"\n }\n } ]\n } ]\n}','\n',char(10)));
INSERT INTO NexusBankTransactions VALUES(2,'AcctSvcrRef:L8FTQHU4',1,'CRDT','TESTKUDOS','18','BOOK',NULL,replace('{\n "amount" : "TESTKUDOS:18",\n "creditDebitIndicator" : "CRDT",\n "status" : "BOOK",\n "bankTransactionCode" : "PMNT-ICDT-ESCT",\n "valueDate" : "2022-08-20Z",\n "bookingDate" : "2022-08-20Z",\n "accountServicerRef" : "L8FTQHU4",\n "batches" : [ {\n "batchTransactions" : [ {\n "amount" : "TESTKUDOS:18",\n "creditDebitIndicator" : "CRDT",\n "details" : {\n "debtor" : {\n "name" : "Name unknown"\n },\n "debtorAccount" : {\n "iban" : "DE328996"\n },\n "debtorAgent" : {\n "bic" : "SANDBOXX"\n },\n "endToEndId" : "NOTPROVIDED",\n "paymentInformationId" : "NOTPROVIDED",\n "unstructuredRemittanceInformation" : "BXCD619SVE1MCJGCBKD1CFAMPAEZ6BRJNW8FARPV56GMV3YM1BXG"\n }\n } ]\n } ]\n}','\n',char(10)));
CREATE TABLE PaymentInitiations (id INTEGER PRIMARY KEY AUTOINCREMENT, bankAccount BIGINT NOT NULL, preparationDate BIGINT NOT NULL, submissionDate BIGINT NULL, "sum" DECIMAL(20, 2) NOT NULL, currency TEXT NOT NULL, endToEndId TEXT NOT NULL, paymentInformationId TEXT NOT NULL, instructionId TEXT NOT NULL, subject TEXT NOT NULL, creditorIban TEXT NOT NULL, creditorBic TEXT NULL, creditorName TEXT NOT NULL, submitted BOOLEAN DEFAULT 0 NOT NULL, messageId TEXT NOT NULL, rawConfirmation BIGINT NULL, CONSTRAINT fk_PaymentInitiations_bankAccount_id FOREIGN KEY (bankAccount) REFERENCES NexusBankAccounts(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_PaymentInitiations_rawConfirmation_id FOREIGN KEY (rawConfirmation) REFERENCES NexusBankTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
CREATE TABLE NexusEbicsSubscribers (id INTEGER PRIMARY KEY AUTOINCREMENT, ebicsURL TEXT NOT NULL, hostID TEXT NOT NULL, partnerID TEXT NOT NULL, userID TEXT NOT NULL, systemID TEXT NULL, signaturePrivateKey BLOB NOT NULL, encryptionPrivateKey BLOB NOT NULL, authenticationPrivateKey BLOB NOT NULL, bankEncryptionPublicKey BLOB NULL, bankAuthenticationPublicKey BLOB NULL, nexusBankConnection BIGINT NOT NULL, ebicsIniState VARCHAR(16) NOT NULL, ebicsHiaState VARCHAR(16) NOT NULL, CONSTRAINT fk_NexusEbicsSubscribers_nexusBankConnection_id FOREIGN KEY (nexusBankConnection) REFERENCES NexusBankConnections(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO NexusEbicsSubscribers VALUES(1,'http://localhost:18082/ebicsweb','talerebics','talerpartner','exchangeebics',NULL,X'308204bd020100300d06092a864886f70d0101010500048204a7308204a30201000282010100b4a8cc3bea3b5665b907fb57e985671d835884ce3c67b90647b8c215334f0efcdb93e603401468008d124d401599344b753cd875365cacabd7056527ed8c5cd2326fb21c4745dbad244bc7e517ff8367f49df434b4ae73041f90d0ad0a52772f93e2f84d837a1269394acb482236e94404a525d771b3f24d2908212fe6c0f365f069a7d495742f2830f6a96a9fdb40eb4dcf53503207564b129a53a689278b9e832535d1d61fd5ffeac5f1fd9da9ff6b7257fc24c1c808d1e82ae4f94f11d8cb9f8deb98650f05291b6ed28d6b3d3fc2cb81a528a3efa58525b3e47148ee16a62c715d3a652bb540bd62b18c96848da311b3b9c9df1dfcd838a5f411a9d220ad020301000102820101009597ac3df48f9bd3f16a0d92d71812b15a8062bfcf3ee7f3ae51ebcbd8479f967b4fb5477db9280144cf21ce6dd4057c7220a6f02fca7f646f50d55941975788ea20993057481e45f96712a7bdbe63162274e4b0fbe7f3ef372017db214ff5c71cc2f56e61ef23eda3762e6b958138988cec1f308dc33e60ec18023b02ed44dcfe75728a935ab43a86d211b26b40ea080238e39406e1c8b1c6da70b26042cb13f1f795db964b290e1a7658cf6bca6661bc780120509caee8d37cf87191288a8152fb7a0fecf2a7d7be3112e4e426e1fe356075156e949aa277fc3000eec2751a1cb2fdb065ecb3d022f6197c5119b3942bd0464c3266e43a750508a8dd840ff502818100f2ce2519211b06397c0d7eaef39662768ca97340c11bd2442e632dccbb000d544312e1ca6be534e92537c1a2f36b9a5354c6345bee5a30b515d47dbc55e52a16c5021040c3afb109e8e19970935141c8c0572b71573c10a6e4b3ef8c7ab4e7c4f1959efa71493e5d0842d459fc6f11d3d622cb0fc3d26c21f60ffbe55c02286f02818100be7a17ae08afa43aff1a7fccc9b6aba9fd4465d9f184835110c66d655ffcd770e527b1b9b7e97212ede58a3c7616bd4f29ea8928c64f592dbdba63a416a735a00c2f14452a95c9956938ff79b709ad98a4321c5bdf7a9f572af3c6bbb9031469940cd10d3591c76aa1a2bdeef258c032cf8dd8c8b7c6b2404a5f387a0490bea30281804f8cfadaa0de19cbfbb8f028a1e6439c53b9b0e9265bd7283f8a7f16f4adafb04bc983f0ae290a8cd884cc0c777469bba3aaccbcd1fafaba59cca4e56fbf056b3060dcb25b6ad4b64a769faf22951cd8892c062fbc4511af9c7ed79d4f16b658f04df52858b58699347bb0d74abd9939ae8ef7b8d28fbe9de1e09ac72abe0a410281807fb09d7b3fbb6f5f5570d047dad9a88ed68829b7471f4c60e5dbffae3c00e5f47aca776c470c2a3ae25c44a56f8ca2f014eb7373702df55ca299f6fe2369889b784f7f4936d91f40183feb940ece601fb9c3161bc8df0d3e843ed3f5387c060d1900d68c02636dc9dffd97523e089d1ff2dfe679f8292d89c7d1b9aca2aeddfd0281802727e1c29822b75431fb83dcaae451cd8134fdc72d20927a17ab065dfaf7b64676c81bface29a52b1a3e450417e6dbd05f1ad19237a93c85f6e4c3d39267cc44a520c38efd7ba3ba1429cd310bc8ee92d01a3bf903538f14491369a1516a68fff3b70664c7f13c95aff5d4a936b9487632b33c8109f8573d700bffbeb98b976d',X'308204c0020100300d06092a864886f70d0101010500048204aa308204a60201000282010100b57cad0d7220494d675f05937b26c9f141f6f1352f54ceca6eed39a355d11925768acf8324956bb940cd36a1fb349621721a8ecbeeb62a02cf575735a0cdc7fbd2167334505985509baf9945385f50fd9ca714f87e2cf6b1a519983feb6443273e345e4d2856693ab44efc4ffae82905516ac28ac33035aa3a3a422f627c8217c4bf12b057978f5a507916a6c1dcbaf8d7250a980ded9e6f1739d8b2d86aaaf45522540713c55f2a22fafc0931826f420578203a72ff9927120671f0465fc9efba9631d322bb3c6498245457514cbeb40dd09b996dd35da0be90e74a7860605482f0f0cfaa332858a23efcc7f9324e354e03d4518f4c6ed2769f80ebc777bab9020301000102820101009f576b88d69eca3d0f793a28168423e1928d019234903d4f36bd4951c2d2e745212316b689b436f45b94d156be7b99249c4dfcf9c80860323f60ebccc5f666930e0d6ff08a6b4ec54b2b8d625cf032e7b85669ef12b8df8f70e95be72300d084eff482a733b74a84a432850ca3ba99e975664a9012778d667be112a30fd14955a1bfb4509e6c50d1ea94206ff052de5819d52ba265515ba3f8e94c6bd3eaa736bca6f5a8a86203de6c9a2789199d5ed7be2b65177cfb31a1401062fe6655be85fc1ff98675d7d9556ba69df7af093c416130900c137499fb38e54d9b574349bef0ebe90e4359040c01aa81ad7edbc355f47280d5a07998712dff3d8e011a279102818100e5beb0dd9a2524555885798ca4a7a586e7ebd2f2f9a90847d793883f076aaa4be507e1543233a4f378ed5e39dc1425e6ce1df54d591dc9372d61c8f98cb25e7c71bf2ae681f795a54dd01754726aea7af11189a936a63ab5b809ffd2f5ba899d7520de4a24168fb7d00d1135bc04d3e619c8726ff7e4334a4ceea6f8dfd54b4302818100ca3a2ce540f9b0f2f18dbbf156df6b1155d4d6f10c22d7284742c607145489f7d87d2bf5c943f046db58ae41cb643f5500348cafb1d0a9ac4b91df0d5b36c49352ebf749cff327443e038ae9ca897016e23016c6ae5f7e5b37ed5d3d6fe586fa46cd3be36a5a47ead89bb8e3280c3e068f78bd03fc630cbba78ff2ae20c71c5302818100b561c8c71bf4a8ebcc988c6f326bbd2e7619e410ba74ee39b204233407c9f9ab33a5f60b001b6fe65d19a223b212221e47aab5491ccb7c59d8b573f33956756c706d4a147495a08ac295406606734cae4576e0253d251e02ebcad1339f9767206e21c5fde8e1fb1356e98a25cf4c4c7344f5d10b7f3da614ca0a3cbf0e109a7b02818100a2c79b35da4c62abdbd63bcf731f19def55902bf3b069c6c1698603078a3e7feb1ab68044b42bd993b9cb17fd2895a1540ba0bf8acc80a9bdea4878807c119108171e136f00588b8fcb5fb4e5f32ac202f67881ddb6490a03a6f7d5b23c3fd175e807b517e5d3780896527b8e9969922ccbfe25ddffd96d54276b360888fdd7302818100cfe14d384efc37d9e04ee2b794c02e2cfd784d7bbc8244f9381659fcecbcd7fc1c0886ea6a16542861159aafc932da791df4fa1d607e933fd8afecd1d4c4af7d228235d5693ee5aa5c438780d25d68c15ccb1145431661263224c189201b6d6ddb32c510cb2368345ea62ce1286400a0b8654f6ce40931b35c50094c3595fbf5',X'308204be020100300d06092a864886f70d0101010500048204a8308204a402010002820101009b7fe49949f285635680bdb9161b8b7feda8ff74e8c227ac784440662085dfa3ab928db25e2ee07f09ab42e6129763505a8992c9dc2d9a8a813ed7a90cdd4712aee0767ac95264d6c0e325010a8236ecb4c217c09db759741439eafc072d450ac6a60684f1cc961c7f228ed1551ec40edcd3fa8a49a791cf6a905cb12f35c089d3f86dc6d73e5e01f7be1cd1948ba7a1995d22fb6da5e2b0c068e250dc222e97a927fbed12dd3f2945d903119a0639781c8e2bb1297426f602d285caf632c8804553cc83a8c2505d8598314a181eb1fc63d77f2acaec7ed24d89fbaeaf0347178f0a87f39d29244e59f9f1dca9c1d8c32034113a21880d61d6e998145896b00d02030100010282010100870113b4ae89fb9b126835cff2ccb961b932079035e11356df17ca9da050faa87bf6824541160bdcdfc52c10da454b7961119e3ad989526a3bea168cf3d94db27fd7eba5911292f00c8969002d627e5326607904c7297f659385f1691cc605f2642392f76b834734b8808564633591dca186fd3780d91673f13e22ebc66431a35d79215cb219d772bd623d7fd0b66d813467c9ed26641ed5ff73e52cd94e2ddfda2ccaf0d6d9a374fd685f18917af3a343f679a151a788b4b9b702c1869ede50e182df0d53516898f20ee8e43b791a9ed12d9e67d9414d25134d973b8ade213f9becdf46eae7a0fb994377cd6199aa9ef17d06f43045bfe3fd470ae0f3d5657502818100d06b5ce7a9b413ae61545e236f094d3443e237b0e98d70ff51aafacac517222891a48998ad453fb7fe0cad4235ace420882aee1ee6a8ea7af69add1fe2d21928403d04ba677a99ea35ec2df18f33c607820f9baeb65a868f008e0d327a5f559fecd86e1bc5dc275bf4e50eb0177725d813d0dd276d19df94029f892c2ae50b5702818100beffbe05116d4128b5ff5eeb458e4fa60e444f91ccc63bd400cde8e360f703484dd454052d05ece728fd93a120ed1502f5e1ca9610e28a5d7a2252500cf939e26399ad782d80ba190262a3ed18c7304a708d4e7004ff6efb49fc1192e75505b14109ade19a7cb18fcd81faadb9437ea3a2f785a5a81b7b9e6deeadc3c5b2a53b02818052d176d76f6de92c2fecd0839009c82dee93a3c19eecdf6bf54dd5de6136f211e0dddaf75a52dc2106c88ec8727fc31ed23d0ce6268e14aecbf379cec3d8ecba3bdc835676ec16e12490372977d800e6d6ddd0e539fcfadf343f3e2b42c943430b606d5087ed158ecadf8258a2da6ba5532a79d6c2d9b7281f6ab99d5d662a7d028181009945c1c76f64ad956df7b0c43cdd272daae546b54a0f0a93e6d156c2a15d9854bda0568c90c4e087e06d1dbb8020c16bcec5933d39ef91f9d1b9193504343c2f609e4286de7d1eda52ffb56cdf2579ab4307229ae267d937eef749630a2140a02e010678b4f0bbcd1aade3ece56f34813c9645b9da5db3a63fb1f9dfd116bb61028180689fbfc661c7ac77e826cfe50e9e9addb751426900331436594cf13e1b266929606d1eef76b3a4efeb4b7d4bc43c67ce7dd7347aaca25e5ef220bd5a075075f5debdb9ed4085d9824ece9b0916d3e8440e70fd572f2f40dbe8eb983d2f03068cd84a03edade631b10d1c583e934c98118aeb324c4fa2b14a5b907c6f4a0d94cc',X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100b65ae153acab4789c4c18cca8cac4a8393ebbb10e1553b34836d6fb8073870d64f2c6183a908a4b52f11a688d15a2f2faed5acc3563530a9c7a7ab21787877d79c3bbfd5195e5d4197c12fa9e505546b86b0a8aa91d3ca14ee26b0b266c29097a15984aafda5e4f44e9948e8f722546c394a864ab30c67baeeee9427e644eceb3706293bf6eef501278b90925b441e57c58c7842f53bd9c4337b80b505651a296a31a7a18668733b375d2d859800fba8c8de71b7b520c8c4cb4b20e5b86909bd8ba1777a90208c8cd1b9d305b0c11ff5f94763a7cd8a3b64d0ab2b15735dd663b9c017ad7d4823112e93d1fec324829e76a0e083fb5b866a665a6b6aabffd3ef0203010001',X'30820122300d06092a864886f70d01010105000382010f003082010a02820101008d9d5ae949959e7093cb4501aa9339911ae2f7eff547dcef6e3051e81c8939a0f9a73fcc04e4d3afae16eabf097d67d78e6ca66b7d99113fc46750e7c6d0331aa9ca119f6e4cda1f1076ac23229e57cbf2e69eeb9b7ba7ebbec78c3fe5f244204fc86943e6f0c39498f26f029dd996c56de91fed31794f52a69ac383c00560e868812bcaa3ae6a12e6dc9363c86fba1ee11c3cb8fb99330d911a488812e6d000e2584239c96d95a58512f41c7acb2de6d33bc5a9b1c5799e0d844ba0a30cbe21ec069ee72ae43f6d582e682c7afd0d2b2ec734d081f1711528cd1b0b12ee157d01198001cc89b1197b0291e21da5c4f4c88ece7fa72f93a3ad5bd42f04d60ad10203010001',1,'SENT','SENT');
CREATE TABLE NexusBankBalances (id INTEGER PRIMARY KEY AUTOINCREMENT, balance TEXT NOT NULL, creditDebitIndicator TEXT NOT NULL, bankAccount BIGINT NOT NULL, "date" TEXT NOT NULL, CONSTRAINT fk_NexusBankBalances_bankAccount_id FOREIGN KEY (bankAccount) REFERENCES NexusBankAccounts(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
CREATE TABLE AnastasisIncomingPayments (id INTEGER PRIMARY KEY AUTOINCREMENT, payment BIGINT NOT NULL, subject TEXT NOT NULL, timestampMs BIGINT NOT NULL, incomingPaytoUri TEXT NOT NULL, CONSTRAINT fk_AnastasisIncomingPayments_payment_id FOREIGN KEY (payment) REFERENCES NexusBankTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
CREATE TABLE TalerIncomingPayments (id INTEGER PRIMARY KEY AUTOINCREMENT, payment BIGINT NOT NULL, reservePublicKey TEXT NOT NULL, timestampMs BIGINT NOT NULL, incomingPaytoUri TEXT NOT NULL, CONSTRAINT fk_TalerIncomingPayments_payment_id FOREIGN KEY (payment) REFERENCES NexusBankTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO TalerIncomingPayments VALUES(1,1,'FMQZEATC840WP331DVFWF05XGB5TZ02Z0RTSS19EBR92F8W6MFKG',1660992702230,'payto://iban/SANDBOXX/DE371825?receiver-name=Name+unknown');
INSERT INTO TalerIncomingPayments VALUES(2,2,'BXCD619SVE1MCJGCBKD1CFAMPAEZ6BRJNW8FARPV56GMV3YM1BXG',1660992711007,'payto://iban/SANDBOXX/DE328996?receiver-name=Name+unknown');
CREATE TABLE Facades (id INTEGER PRIMARY KEY AUTOINCREMENT, facadeName TEXT NOT NULL, "type" TEXT NOT NULL, creator BIGINT NOT NULL, CONSTRAINT fk_Facades_creator_id FOREIGN KEY (creator) REFERENCES NexusUsers(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO Facades VALUES(1,'test-facade','taler-wire-gateway',1);
CREATE TABLE TalerRequestedPayments (id INTEGER PRIMARY KEY AUTOINCREMENT, facade BIGINT NOT NULL, payment BIGINT NOT NULL, requestUid TEXT NOT NULL, amount TEXT NOT NULL, exchangeBaseUrl TEXT NOT NULL, wtid TEXT NOT NULL, creditAccount TEXT NOT NULL, CONSTRAINT fk_TalerRequestedPayments_facade_id FOREIGN KEY (facade) REFERENCES Facades(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_TalerRequestedPayments_payment_id FOREIGN KEY (payment) REFERENCES PaymentInitiations(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
CREATE TABLE FacadeState (id INTEGER PRIMARY KEY AUTOINCREMENT, bankAccount TEXT NOT NULL, bankConnection TEXT NOT NULL, currency TEXT NOT NULL, reserveTransferLevel TEXT NOT NULL, facade BIGINT NOT NULL, highestSeenMessageSerialId BIGINT DEFAULT 0 NOT NULL, CONSTRAINT fk_FacadeState_facade_id FOREIGN KEY (facade) REFERENCES Facades(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO FacadeState VALUES(1,'exchange-nexus','talerconn','TESTKUDOS','UNUSED',1,2);
CREATE TABLE TalerInvalidIncomingPayments (id INTEGER PRIMARY KEY AUTOINCREMENT, payment BIGINT NOT NULL, timestampMs BIGINT NOT NULL, refunded BOOLEAN DEFAULT 0 NOT NULL, CONSTRAINT fk_TalerInvalidIncomingPayments_payment_id FOREIGN KEY (payment) REFERENCES NexusBankTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
CREATE TABLE NexusBankMessages (id INTEGER PRIMARY KEY AUTOINCREMENT, bankConnection BIGINT NOT NULL, messageId TEXT NOT NULL, code TEXT NOT NULL, message BLOB NOT NULL, errors BOOLEAN DEFAULT 0 NOT NULL, CONSTRAINT fk_NexusBankMessages_bankConnection_id FOREIGN KEY (bankConnection) REFERENCES NexusBankConnections(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO NexusBankMessages VALUES(1,1,'sandbox-1660992690711','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323639303731313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a33302e3731313633345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a33302e3731313633345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(2,1,'sandbox-1660992693091','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323639333039313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a33332e3039313735345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a33332e3039313735345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(3,1,'sandbox-1660992695340','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323639353334303c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a33352e3334303536315a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a33352e3334303536315a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(4,1,'sandbox-1660992697530','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323639373533303c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a33372e3533303332355a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a33372e3533303332355a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(5,1,'sandbox-1660992699728','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323639393732383c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a33392e3732383030325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a33392e3732383030325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(6,1,'sandbox-1660992701927','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323730313932373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a34312e3932373935365a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a34312e3932373935365a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e38534231384c34383c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453337313832353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e464d515a4541544338343057503333314456465746303558474235545a30325a305254535331394542523932463857364d464b473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(7,1,'sandbox-1660992704306','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323730343330363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a34342e3330363139335a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a34342e3330363139335a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e38534231384c34383c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453337313832353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e464d515a4541544338343057503333314456465746303558474235545a30325a305254535331394542523932463857364d464b473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(8,1,'sandbox-1660992706484','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323730363438343c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a34362e3438343038355a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a34362e3438343038355a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e38534231384c34383c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453337313832353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e464d515a4541544338343057503333314456465746303558474235545a30325a305254535331394542523932463857364d464b473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(9,1,'sandbox-1660992708657','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323730383635373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a34382e3635373636345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a34382e3635373636345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e38534231384c34383c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453337313832353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e464d515a4541544338343057503333314456465746303558474235545a30325a305254535331394542523932463857364d464b473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(10,1,'sandbox-1660992710846','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323731303834363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a35302e3834363833345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a35302e3834363833345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e38534231384c34383c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453337313832353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e464d515a4541544338343057503333314456465746303558474235545a30325a305254535331394542523932463857364d464b473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c384654514855343c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453332383939363c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e42584344363139535645314d434a4743424b44314346414d5041455a3642524a4e573846415250563536474d5633594d314258473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(11,1,'sandbox-1660992713071','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323731333037313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a35332e3037313931395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a35332e3037313931395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e38534231384c34383c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453337313832353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e464d515a4541544338343057503333314456465746303558474235545a30325a305254535331394542523932463857364d464b473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c384654514855343c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453332383939363c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e42584344363139535645314d434a4743424b44314346414d5041455a3642524a4e573846415250563536474d5633594d314258473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(12,1,'sandbox-1660992715236','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323731353233363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a35352e3233363339385a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a35352e3233363339385a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e38534231384c34383c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453337313832353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e464d515a4541544338343057503333314456465746303558474235545a30325a305254535331394542523932463857364d464b473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c384654514855343c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453332383939363c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e42584344363139535645314d434a4743424b44314346414d5041455a3642524a4e573846415250563536474d5633594d314258473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(13,1,'sandbox-1660992717406','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323731373430363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a35372e3430363737395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a35372e3430363737395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e38534231384c34383c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453337313832353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e464d515a4541544338343057503333314456465746303558474235545a30325a305254535331394542523932463857364d464b473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c384654514855343c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453332383939363c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e42584344363139535645314d434a4743424b44314346414d5041455a3642524a4e573846415250563536474d5633594d314258473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(14,1,'sandbox-1660992719559','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323731393535393c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a35392e3535393230365a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35313a35392e3535393230365a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e38534231384c34383c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453337313832353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e464d515a4541544338343057503333314456465746303558474235545a30325a305254535331394542523932463857364d464b473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c384654514855343c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453332383939363c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e42584344363139535645314d434a4743424b44314346414d5041455a3642524a4e573846415250563536474d5633594d314258473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(15,1,'sandbox-1660992721731','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303939323732313733313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35323a30312e37333133365a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d32305431303a35323a30312e37333133365a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453938393635313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e38534231384c34383c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453337313832353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e464d515a4541544338343057503333314456465746303558474235545a30325a305254535331394542523932463857364d464b473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d32305a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c384654514855343c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453332383939363c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e42584344363139535645314d434a4743424b44314346414d5041455a3642524a4e573846415250563536474d5633594d314258473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
CREATE TABLE OfferedBankAccounts (id INTEGER PRIMARY KEY AUTOINCREMENT, offeredAccountId TEXT NOT NULL, bankConnection BIGINT NOT NULL, iban TEXT NOT NULL, bankCode TEXT NOT NULL, holderName TEXT NOT NULL, imported BIGINT NULL, CONSTRAINT fk_OfferedBankAccounts_bankConnection_id FOREIGN KEY (bankConnection) REFERENCES NexusBankConnections(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_OfferedBankAccounts_imported_id FOREIGN KEY (imported) REFERENCES NexusBankAccounts(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO OfferedBankAccounts VALUES(1,'exchange',1,'DE989651','SANDBOXX','Account Holder',1);
CREATE TABLE NexusPermissions (id INTEGER PRIMARY KEY AUTOINCREMENT, resourceType TEXT NOT NULL, resourceId TEXT NOT NULL, subjectType TEXT NOT NULL, subjectName TEXT NOT NULL, permissionName TEXT NOT NULL);
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('DemobankConfigs',1);
INSERT INTO sqlite_sequence VALUES('BankAccounts',10);
INSERT INTO sqlite_sequence VALUES('DemobankCustomers',9);
INSERT INTO sqlite_sequence VALUES('EbicsHosts',1);
INSERT INTO sqlite_sequence VALUES('EbicsSubscribers',1);
INSERT INTO sqlite_sequence VALUES('NexusUsers',1);
INSERT INTO sqlite_sequence VALUES('NexusBankConnections',1);
INSERT INTO sqlite_sequence VALUES('NexusEbicsSubscribers',1);
INSERT INTO sqlite_sequence VALUES('EbicsSubscriberPublicKeys',3);
INSERT INTO sqlite_sequence VALUES('OfferedBankAccounts',1);
INSERT INTO sqlite_sequence VALUES('NexusBankAccounts',1);
INSERT INTO sqlite_sequence VALUES('NexusScheduledTasks',2);
INSERT INTO sqlite_sequence VALUES('Facades',1);
INSERT INTO sqlite_sequence VALUES('FacadeState',1);
INSERT INTO sqlite_sequence VALUES('NexusBankMessages',15);
INSERT INTO sqlite_sequence VALUES('TalerWithdrawals',2);
INSERT INTO sqlite_sequence VALUES('BankAccountTransactions',4);
INSERT INTO sqlite_sequence VALUES('BankAccountFreshTransactions',4);
INSERT INTO sqlite_sequence VALUES('NexusBankTransactions',2);
INSERT INTO sqlite_sequence VALUES('TalerIncomingPayments',2);
CREATE UNIQUE INDEX accountLabelIndex ON BankAccounts (label);
CREATE UNIQUE INDEX NexusBankAccounts_bankAccountId ON NexusBankAccounts (bankAccountId);
CREATE UNIQUE INDEX Facades_facadeName ON Facades (facadeName);
CREATE UNIQUE INDEX OfferedBankAccounts_offeredAccountId_bankConnection ON OfferedBankAccounts (offeredAccountId, bankConnection);
CREATE UNIQUE INDEX NexusPermissions_resourceType_resourceId_subjectType_subjectName_permissionName ON NexusPermissions (resourceType, resourceId, subjectType, subjectName, permissionName);
COMMIT;
|
