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
|
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/DE514871?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'30820122300d06092a864886f70d01010105000382010f003082010a0282010100a03098ff00d2f1d4f9ef23e8c29e687c9d206404605896c548793a0fd6ad563bcd256524b3ca2816c1df50252b3a413c8ee1781cfcaf06cfea4adc64b4a895768b2ef25fe38011364e5b8198a4aa0a517a64bf01a798ddb1200439990e13e4cb3c82d79b8ece3f725e0d81053d5a31befdeb6e2841dc0a5404aaf31d7b9ce5398d97f362a531d2a4b199669072bed882bd10fb354b45416544d975a5cbde40c000ebcac8a6038ba921a46a69e3b9dc87c7ae8e5a4805b45f08e25b6e76f746ed82a86f5ae10ac5b4107722119e67db808508c73643b95b1855e45cfa9095ee7b07ffdd86486611eef5d581235fe5008a7e079f0897aa7103969926a9e76f239f0203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(2,X'30820122300d06092a864886f70d01010105000382010f003082010a028201010080f109291d50ac1d186bc40584f8a2115d736d7ad311bd4f62a0f83e6bd49b847a6d8875d5f9e1bf4055cabefd619fee55cf21723799d2415018ac98275716c67ec6fb51f88fa4ca09c1bd710f16c7c2a09c4d5bac2666bede0325655a409d4a08cee6221be791984c65985d434bb2ca10603c84237633ba5d32c4220d2f0ef7c25b94c18edbe30a55da170531b3b1edfac012dea78696981a3967e9dfae10006dc0f8ce1f8af3c6e99ba57e1c30118ca90b43aea96a49df16169163b21274a6ce568e306b15da4b95720ab58ebdd2bb618cc5330b5c969b4ab57cee55e1413012d305ce8c1a16aa938e5940d5daca716408f8a0ff0c2da516baed034cbbfde10203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(3,X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100b0ceebf64877cd9a8f331caa9c24ea334e4afc1b9744aff9ea02b14d973f86018e00955e8e9e109fd6b55021e15adff4f224cf0c0736ed203fbf914dda8555f66ddb921bf2560637f6b3457a46bc2b83bea579fdc0e8254de0320bf6686c2571581e38ee204b7c366ee3299b683251596548d8944f8110613ddf2004770722c76f8ff1000c76dca6560d7725e9fe5fa6bb053db0bd567fe0831966fe2f5020aecc35d40154bd91275e0ca72c83b67b26b7dd597e3bf0ed83434ec87d107ad2fbdc4a0df2ecf974b5f0446d517a8bfce43e855b848f212d99ffa7c7590d7d8dfc93657b3ade490696f1e55bb8681009dd4403e13f9abe1dce30f24895fa7e0c990203010001',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,'DE514871','SANDBOXX','Exchange Company','DE729925','SANDBOXX','Name unknown','HTW6DPCWEB0QCYAZ7ZTD89N17AMYR7BCRY06R727YNNJ47Q4GTHG','10','TESTKUDOS',1660496839825,'LWA21AG2',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(2,'DE514871','SANDBOXX','Exchange Company','DE729925','SANDBOXX','Name unknown','HTW6DPCWEB0QCYAZ7ZTD89N17AMYR7BCRY06R727YNNJ47Q4GTHG','10','TESTKUDOS',1660496839825,'LWA21AG2',NULL,'DBIT',9,1);
INSERT INTO BankAccountTransactions VALUES(3,'DE514871','SANDBOXX','Exchange Company','DE729731','SANDBOXX','Name unknown','K2V2B3YEMZFMWQ475KNV2HT7RSPA1YXFY210749MN9WBDCBT94AG','18','TESTKUDOS',1660496846987,'DLBB92WX',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(4,'DE514871','SANDBOXX','Exchange Company','DE729731','SANDBOXX','Name unknown','K2V2B3YEMZFMWQ475KNV2HT7RSPA1YXFY210749MN9WBDCBT94AG','18','TESTKUDOS',1660496846987,'DLBB92WX',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,'DE123633','SANDBOXX','bank','bank',0,1,NULL);
INSERT INTO BankAccounts VALUES(2,'DE402450','SANDBOXX','fortytwo','fortytwo',0,1,NULL);
INSERT INTO BankAccounts VALUES(3,'DE320557','SANDBOXX','fortythree','fortythree',0,1,NULL);
INSERT INTO BankAccounts VALUES(4,'DE514871','SANDBOXX','exchange','exchange',0,1,3);
INSERT INTO BankAccounts VALUES(5,'DE784482','SANDBOXX','tor','tor',0,1,NULL);
INSERT INTO BankAccounts VALUES(6,'DE822276','SANDBOXX','gnunet','gnunet',0,1,NULL);
INSERT INTO BankAccounts VALUES(7,'DE652970','SANDBOXX','tutorial','tutorial',0,1,NULL);
INSERT INTO BankAccounts VALUES(8,'DE064323','SANDBOXX','survey','survey',0,1,NULL);
INSERT INTO BankAccounts VALUES(9,'DE729925','SANDBOXX','testuser-hwi9z7th','testuser-hwi9z7th',0,1,2);
INSERT INTO BankAccounts VALUES(10,'DE729731','SANDBOXX','testuser-7wwue25w','testuser-7wwue25w',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'308204be020100300d06092a864886f70d0101010500048204a8308204a40201000282010100845de39a06645e17048233a6b50ff54823e026751ab484cf07a946b6088c8a73daa9b8b8277644079fe629b65d453ad4edb4794b7b56ee544bb0aae275859f77d9efe33facd83c1b14f86e32d7435207b4065b48e7d5d3483d92dc7c62fb2ba454062b532e745a9d2c7d2b417557754fd008cb011dc0f3612a8b1f4cc2f182e7c185cba1d76b86cab98125c6c15c18cd320da84e40b9ab01802b3a0ec63dac7f442c16aec2e0f33ccc8323391f9a48d84aaf1003c6584e406d8aeb48abc07e96c40d9f4242494324bd203330bface36777358d4921c4c2e33d42ea396d1dc3151756949d863722156b0fe7dd81b255ee007b901b964c0284ac9cb163d2fbc5c10203010001028201002d78574444e7db8e8aa4f37b53fd8c63e0b7125eedf28f20d35fea0384424b196b471c465e7ff8f4a990164a28162d14922789f74d025ad2a841a32231fed9fe00e6b028e28651777827b32b51d93567a20700fab57135a83e46a1e934d3557598cb99bc745bd1f8e61c856c7213be1fd1b6038e799b1bc0082e4c6d411657c224b9506fe4d1f9faf2ea2033fb9e3ee40b00760d26736a4d16a2cc6b4b1f712986b297948a035389d2f38c55a970280b8761fa45f20901d962f4a9c700cdb0184c410ce3d16dc14ad1a032848005c80771bde19d91e50b72d114e425c3df7e2aa7ee4196ebb065384795c8b4083f86256d9173b7572429212eb9134820a90bc102818100ec7e1e2f558008cf3b72a23fa7ce8da27063218de040802332d6b42fcde3b01975bf8ecd6592fbfac7b026cd698333a3948c881028304d245480ffb70186f94d6b0f54e6dc3037e09fb457d172910dfbc80cf9358d22f976bcb76cfc88856abea327bd522d2cd39a9767a8ea13d9b407e86dbbb3707d51a92c418ccc56a6db79028181008f4900d763d26019866414ae122b9ed02cb8660d63697a5ec07fc17195958e732861569e677015a6c31df9d3629ad5e50465abab6266af0a0dcdadb6a3336772d93bdd292b2782e84b1969fe4f5e4f25983de8209846702097e1c575d6f82e6052ac4b2a3866bb97190b2927856993a3cd95d94f67d2aaeddb2fb1891a0c62890281810094861460f7da842dda110172e6e9a32bfc5755b06bc1367864aa50d9a0fdb91014522cd6344f9e6efe5053de37c0cd82937dbaca22e34adf612eeeea394c526fdba7f25356bff5a7ddc4fe4e2d1c8a62b15dec79445d4dbcd38283310a7077fca82d020a85129d067ec5fc609dfce0c302a73ff5ced4f59f408b1e690a969a490281805ba9f255d8d04f16453965596eda6500fc7b031e71889af65ee3dc171400d75ea8688d074d591120dc16232aae1c2bd615180dd8d85ca482240e7ea1268ace15550fcd0e774311a615d52e4fb8eab66b7097ba1690140fcb6a1ecf39f1ca57b0db72c9ab3ae5ce007dcefc07027c662d166a54d94dac2219846d60803b1fcd3102818100da7322ec1e0b9f19aa9ca60f70f660559ddfe1fc34130b342e3de89cd73e682985c49d0c9ba8fb36d07d885f25e7a3316614b7438e036d66890d194dafeec9a1395dac762f874cc5a4cf21e267a1219968192a0837d29e6ae4f6c2f3bf38649e7879b23239bfca1051047fbcfcc0f271d8e9d36e785461f4ff0f0ae00476f6e1',X'308204be020100300d06092a864886f70d0101010500048204a8308204a40201000282010100a07146544ea9da3cad747f447799c166c54df89d908f65dbc5c9c509ce92427aa31a1f386d59adb8bbcc0e6272cc628c0b53e67efc853d93855bd058f1bc659e8c9cd67f52bb13b3008bc677763c9278ce6b1c76972e8ce2d3eecf0b408aa8fdc0615b680ba491f91ae9349072dbfa969cb007846e4282daebb0cbc9283cb6b4746a9da6824de3a09b486182d689cac024b6b5749f6d77b660f3aaa708c83a7534bc55e33298c0a59efa02db44438c4fa573f85921fa80e2e9bad798b3cbf8f965672d6a16219059e6bf6bfc78a7a6fb634922a7739aaf0a336466ddde78952639e54a0565ac71dee8d4fbef9a62be4c1ffe70df8da4e1b979bcc717d0826b010203010001028201002433eb2eb2e158c140527d3531d79bf058ad13605a724105aa47b112596e5f59d4dbdc179b7514e20e5e2910c5dea08e0130595e66149aa462ff28b0293bdda23d1056c63c20c27d2dae5c863043d2b937baab9d86d7962ac8afa6405fbbea0df80effd5266b6814d1a1b59eb28c38ab2b87fcea4106f907f50edbacf44b5ede55b8a306b7902fc0172b71924a4fd85cebf964b968be5bb1f773b633d71ecbae20fbbd239685fe1c041248f2faf2e09fbfa62ca3046ce29c7e39b246d512e0cf5d5980a8b8ca44518e1dfcdb3228bc6bf196f66ff978f110cb9940a7e0a9bad133f6873bf2f21f2906dde4c5bbb345ce3bd2253b7548d26ce41b086b3b3c5a5102818100cfeed83df59b45c8543d6b9df34b375bf8d253bd7d652dd607aa966327b59ba41aa47be8d377912360f1243ad9a34b6a08dc507e7bb3354ba9bb6eb0a4d2ddacd6a634d5120c934ec4f1b6c7ec53a72ec51d9dfae1ea27c250352415a9ae61a1e4f4b0261bea71af07bec0cc03f35a52c090e1233267fe04b2e5180ab66db7d302818100c58803bd89bd39168c3a1a90690f06f2cf9e042f8671300acf98c07c6e02b6f7a8fbb37d4049c09cb9bc796ff2508f3cb7b40a93cb0ca94182812ab70b46016e850b5fff01661ff23b16048a38c00be7cbe40e7d9f50a622584ff0b4eee4bb2fdfa49565cb47ad50aa9c04ed27123abf3f6e18e20d3189cbcaa6fec858e4c15b0281804e8de645ea1ee20b1fc0208308a216e4f928c49826e26da1993dda18d5aca78324c995424d79b36c513868be8ef041126b0c88a0702d30ea47d256ac0768de7468975c084f0c4f2e87fae559bc2f924e7a0b895e79b0d39a7660cd241df9924aee4b7eacb709282fbed652d200801454850976f4ac1b5b7cfcf4cdd3663e271f0281810096c708dbdfccc14bd5c3f04cf4f49480393c4bc39f22bce233ae4c976e3dc23def0e19e6ec709f86c23bfc9217eba83a579b254bc4fd28212a25c05e324bc082052a369f6708f62fa72c5a50cb9ac43bae25a96df872ce2d7f2d9df5ee38482df5cf227eae194b513cb995051502d436f18aef917532b0150fde42b2d92fdbeb028181008e6ed60bdeb541f51aad5c8d529230bfc5f235cf92a84c11061dad6278779b853fa883dc0d67527b01ec7875d43a7b8e363cb4e4bb1f7468d072daaae3236c26dc9c5f4d0bb96f11afa8dc74610ffedc41bd21e1edc4ff7aac2af9a4c0c31025c99cd39ee24433299b0e125ce89290b3f1dbaf77e768339ab36f46a92d56d444',X'308204bb020100300d06092a864886f70d0101010500048204a5308204a102010002820101009db344205a0a1da5925bce9ac63141e3df90bf37f9b48472d3ba9095ae5c471f6a4f3f2c662a2f76fb82e1c1c6f47c85db29df664cf629fb7c028b65a20b9632abda20a15fc1480cc40c0d35f252197b80cf3592f90891791fa9a9fd385043319f5bd904d4e14b4a3e1d4a21fa74e0f3b6a8d45a8016677a22dec34ae9c8659bfbfa65e04a30c4337699044f340995a6e6bc2003f1126e2c8cb1274bde543753cf7cc0fd643b4c3f9fa13e609b0ea0b6bda537209b1555eda704c98109aaaf4c9696b7ac5daefa8521ce5465bf791fab73012c053c9e3b11583cb7a3035f6c222a56e750425a7fca673e88fe893c53cfb907420e243a95fb858f84a4b8247d2102030100010281ff494e0b5cfe7db54a41be6b4b86d55ecb8e20bac24a509f40c12af80a9c02490d515d85001e7d7d92d157059a0de19800a0dfd5f8b7cdb5b630eefddd4076225b6b86f9a409dece9f208279a19a028fd5d90a78dcd8e622b92afeb30602274d14c3feede2511268ed19f2838347e90ca83d403d75d414960530305c977614b126148fddcd0b0f5cdc471282f1af91307761d8f86dfb3dcb185715defd02a031aa9cacb62cb7c59a3062afd289b85c9277dffb4b57bcba9a64900e463e0a9a6d40e4ef39d2a6a93c0b0e8d5414c3487fc6a4ae3a71f6cf7d21d75f85b2ac0463672ff9fbc07121fa17f941dfca46fc448d2c493ba5d8d9890a10ab4064cc459d02818100e5333484c6fb68268e3e57f96917deec4960e88dd5b2c5608eb0bba99aa98b84948754ba0d004d09eda6fb2d7b840d01bf3b4e9a882686b9ece61600e9b2ef88be0a751950f026d5883420a9dc6cef4e9d9698cf257122615a73e09ed152aa86357ce1f9bd2e587d569d05359e3d562b8b4958f530a518cd50e575f7b0f13e7f02818100b023cfc51e65f71cbd793e95e7f648f151631024766f33e7abdd8bbe7c6dff147ce9f86b4a7016f52f04925012d98b77cbf78704ee3511a115a8bb76d728388b38f34318b159f6be082ff622f37956f5444cbbd0913f7bc4cb37ec60482ce546d19d6b0828eab6f2d17d454bd1a9eb46b9ec5d68603a503e1fc77e6814d3b45f028180287bfaf2d912df3ab03562e4b3237c44d05145c287d4a3f8823bc56a17df8abd485eff203ddba7bff132657b8b2daffe7700cac990f2fd292a271a0bdf3bb403bb4dad91633288297f7d75a78b3fd2a55840998d3d57d672cbbf5c15b173a09b442762e2f1ff95b1cdf2be50d23a9355edac6f02202d894bfad60d184b30d191028181009ab359506f9a6ea73762bdad3bc5fbdab6f8a2bce3a857962a44b2efe2a95957cd3e51892a1fb88a2f797c6807a639f0459c6961d33598fe39dfb0867802436743e5a41093f3c7daafa630301257882072945280a491754b2a913b7274f1b98db19ce8dc89d35c4b77e2e671e8fbac40ba1af70f2d350a35060458e961216f510281805f354bc62c72a82628b2d91c56118edd8c0cad1dfec5432c0c599efc58245b527992a702fd0513e85dd81562efd5d78234ff4c56ef3a4cf28872e81aad86ee11b7925838f895a8afb426881ec4408637b2d6b4d6111dd8d4a065c2ae5e1cab59b23c493e107ab049ea5005117a9f149bfccb40de5c50f66968283cbd07533c04');
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('703DEA54DE1B8CE45A4AF81A27593992','HTD',1,1,'C6aVtscKHFxbLQsXpeMmREJ0z2Gg/S2cgtXdpou4yyRQiU6S4Pe9GDuS5qb0agkOAW9lvoB5KLwtwQB6jwWVaMr2x/goq6YCr5Qr/BKqR2ifzQ9svO+jicj6uy9yx6hPghoSdg2DiYJ/tDYvnym8r4NbxoswduZM7iD22jTz8AdbLOVIxyzIEXq80PF3pUqTzaiPMWbwfcJQPBeAg5k7NR77qND+egOkz6spSFASLssms+UfAC+XLdEkhNHeTsTIg+6q0ncnyKX2nhhLoFHYtslaZxb4koHiqyEJ1NOyUa1AUA0oW1wF5Nf+qnHwZUMWztZzVIRDfMC8moBmXT//TR+XVa+GWRKFeGyHi+NiXu0se4J+kw5B9RoNoDhB1e2nkvm7FQC3pSFZC1zkW4aLdHxMQI4IOhT+kVAN7yM3fMRLx+2BQP2N6eu9E1nSL5R9Lt+oNQV+Gxw49vwm6DHWsvlbJf2KohRhiiD8sF8p15GanLgqVdFWZUu+6ub0mE9TcgEBFVLna/EOv2CK2CmJryC54IUl2CCyM2X/MDgGladrf23njBX51xosrb1B8czghQYKqCRgYrkEjuKGt4hOG5O1IFDd7jZ8XnKBqSTRo8O/15OAcvhjQ1kc6h05mBLW7Fz9pLMI7InuXNkRIZDUj/mcJjihe+ZwAgF7+r70uWceIo28YUJzf+AcOXBGocyzGWzU289mdRFW02qjcmk27A==',X'4768f088251391c76108c17a6562e87db0549ee871847f4de9d1b6e29de5885113304f4f5c80d9a3294f384cfe696fa69ce38b2808c8a9127c2e210d7d456ec54083f23d284c4cdba79f63e99daddf470e994749c4ae183d789e74b83098631b053509ebc4aea8c5f524ddf2b2c37f8d657238b521b7d00a2faea02a17c9e1d768037f8ffb56f357cad1bdd615f7cf4fe60b91f9ee989c7a5f2a8c035a05f7087abaaaeee00682c28a7889e88333876f9d09545c8a3477d1d61883f5a4d52a5757dac9a87974f30838e07171f4634ef56bbeba53648288cbe811f8c098bc16c53473a343883b7d57d5f991d225e9fabc30c558d5cd76e6a8960f1bdcffb5a884',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('AA3A4C88BE37BE34E82AFE98D632602D','C52',1,1,'TuExSqrFjw+Gjnc89Pwm77gmleWSuAF7Q5i/8ioJpOvb/s3NS0ovMAoPn877ozkejOnGOgISjhbSvw8fSIEE6DR+q6gelQmz2svvdQOah3R/xhwCQtbzkAxl657QVHRNHgkCCqHXXT3AGzOZhKgYimxGcGiNJbp1XTtzmlKKlbgi1GQqO9CFClFYcpisVPMr0Go1AbLr0UG/QNJ+S+fsvy6x/gCaJ1HPhM+DovJHSqTbZk6WenMU1X/+3CE9XGrZKZvfxoPrFGYlwFMQv68C2zZnm/5r01yud1Wv9FYrHaZY32mFhfbpurFldsALS78yZnvZ7dON/7tSKovfxLYK47tsnztzkr7lWUSFiTcwPlJo5uSjEZIob3VFcvcs5vGwdYMdp6ibEJ+sTRm7gauUdJ7jI9JjD9oQA1KjM/TJw66Nb2v770t0P4GECicjCpSmxYFaSi/wceNa26k4sk+LjIScKdLkJsxJNDZhd3gfZkQ75kMyiQmmbOJAbw2YCnOMNPzu4zCEb8y7HdPi2/BxiYzrev/hJ+EOYBB4ck+GXj6FAF92HZ119fQlKDs5mtIH7lQ71qA53TSLBYFQCYyrfwkRUVI9KgzpARM7EkvFvPOaM6VPYMT8TT+UNLPsbT/bqoUyxzUV7J2cNxu0lkTd/1OY+VQUrtUJEEKl4DRNGWTU3B4lZPsceN6Dx1SiLfnEWe4q1kzyEw6lJfRTHGJz+w3PsmNZXImfp9anXqCfk8T5iEvcb88p9s0KW14wRSC8T1OGegRf8JzQZKU6sWlC6w60hYHHPwbjViVMd4M/++/CKq7dprJDmFkbr4XIU7/IqD5fZuYsV9U076dEyeKBNubPbfEeV1ueKBDy7CnGh1g=',X'15e037c1eafd1f9e2e8a775e004818341a16b462e71add887c2dd1f51593bf3c917893b16ad94436a3d3fcb15e32de51c8b25ee304fd28f64584d9025ab8cfe908bca00e551391d34b73806e21f2285e4e37fcd2af5ca685b747dc08d694b65820c3c61dbf47f00f60e94b0324807b7ea499f65f4ba8ba59e0c5440a8cd6412d67afc628a6765ebe46667db3499aa24139caf70c864b4325e5c19a5c6fad01e312487edc0359760126a161c9a94645d28d6cfd594a595d68131ed18e675b8954d1a5b2a7d939afb0ca07d84eedc9dd980406c33ae04d7cbbc28ca617989a58da0495bfa7fe2453e2493a00adf3affc78b096ce5f641a51791e526a7ec42fab8d',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('A2711F2886318EF5E1AA0CC88F04AB8C','C52',1,1,'36V7B89SVXgMESVQKpDQRIIydmgjL8nwKTd6zi5C78uY6iFZe2y6J4QiNZVfju+bEozSakKjpxPhSYgbO+/qeOqHBGgd0xOwM662VA+Seue+QDncPqMtpruei/KQmpSBI2FPYih2UUTgeHtTLAvJ4zj8m5x4U3M+uQ1LDn3RxbghANvYB+t0ZbAidM2Ww1xsGNpneDp1K3VW0wM2qkxJZOcl/IWG8E+y2EA+Z3VTVpqj6i1f0IDmydsBe+bJJIW8SHN9aE0aQBbRpKN/kLGaHa1oYGapgu/1vbul3Np37h0QnfVWlBeNGzTrfUnZSeKqX1OquD+g8HdRRc4b2dP9kn5dQXnyIXPJ1xPm6DG1KQQfTKcvTQGOzQbqabS70kePvcqGnxG0r2Oszl9tUL/QRkNBRPXsZLiE5LV7R9XH/5rn3cYKdE1dR0G8ZZonfoToDKiOIKBxqwafs77KnAu3YtqGXIYmHEeMY/4KaGIS6nRFmow+Hc8D2H4XrGBnbkfI32h8Zw9zseClE548OvM5plxkqwPE1BMVTGmKgTkk14hYEH6a/aA3sHhD6tzZuv/DKZWiy05Fka6Zc/Mng11SAotq9HR4M+AchF25MLOqyMEcGeIMlsFx7bVwlRWQ6XppFBeutKYhh5Ae/66MjB14T8bjaM+BiPxtuQ1gKfG3ekOcIA+ztEFycGXN0OFu57UXv2ITPyH4WjcyPixk64+u/+F1KJJXOQ7AVlHhZ6Rdpti/NaMwfhox8tV3hL7zEY70r88cSecTcwJ1qv6f9bajZOhhdqFaBGZtPGKBXHEr7RHvn2SCeQugMKaGzGwP7gHmTs7/OgcYsRclbtuA4KiaYo/YyyKmYflFIxd7y4VFDaA=',X'abd6417b1fac7b7d4423936831fc3f2b4ca0881e48e96ba1490dda1696339c62785be785e07d6fcf4b77b945bbd2ed06611a2a63f4f66beb2a80cc048f894949df8e5ca75a875e845710b2a7ee6289ffac867a8ee573882fc9a5776e56094156f84e1280cfd75ae31b89b0bfdd85cedd3f975e4dcaa2327b4de1fb82cda2d5de87fad03becabe14362b5241bcb765fa3d9ebf815d552547f118c6d1ff200082fd33403fd22a4ed40b0405f6389a2207966b5368d0153c2e1062c20bfa7620fd13af4bad91fae8d21597eeedd75e4baf131d8b88b101ce414fe4c5324b4f8259bbc0719fbd32ccdb5537b140ac89c874fd76ee262fae3dfbb7f318077e730f3c8',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('2F3BF32E9591B4DDABB5BB92B45B8C61','C52',1,1,'MJewVec3qTYR7WqN10EaoiplDJyE3bqPbcWx7e8hWmNTTqYmxAukHoaV5X1msZBCSKJv15zbhoIqlr8NVANcnTUm6obYLvZLZpP6tfDoVdhVwYelalh4GRRm/GfJ69346HKyJxOjYE12Amij0TNPZjOzmfQRhyODSqyHpLBwmNvcCt4wR8w4jFc1WPXOlJkdo/IDVGOrrTSHLOKYpwaegbaxp3IQ7qmnkcxtrUUjv12Deij6YnNab8Oru2vJHmQ68iVZeCDUtsQeQQuGdwhk+V+w1lr5mxEPDV8PU4ayfP7l9yXB4eiTek9HFtZC6t4MoWDfQZgEEBaL4U68OUH5bUsw2++8GP6uuTeE7wBj/VrHtkjdYFchI7+6edG5JIDkfQQuI4dgA6B08skk0Ovt7PFda3CK+h8PxWMh/kEwhB2tuBzoM8zcqzPliHUk7qLFQuDHwjrJAfnCUnyj/5oSihIdDt48WqXA5wrihPhvQJEJH77blDeXrgf0U/NVmjNlEFteEF5TvFG76eb83UNBzRk1xKMfbrwiewN7Xk+CFRQr3uqfPjPeo+qAYm5sfTTKa9y8OCeD7iIu2402OAb5hCuQflcSJQdlBVycAGl7DI/DeT8HtDCLpi7b7gbaZ8jD5eVmDiHUDxBFEUt0Cse0LdUVQGEgJnssNgPi0I8wQZb0KNSCXe7SeBiwnCc7l4OsgWROixmC1iEZNnpANLGl9V8PhDKrj490nXgWxvj69m1sfnh5VLIBNj6i2FrqOlcqwyHLJojXfrDTPBUr5k01X9FRYOY79wBsXHRS15zT+EJPj5Uskh0RqHr+KAH6SWNRw1UyOpDnpgHvJW6WUX1BEYEMVNMIvwoV34it3AGQeB8=',X'698348567dd0a168fa8a14ee072592913870c82df8b8c343292085cadf6e2c2f6941f65398ff218032ea8fe985f2839e4d8fc16f890e73b2d399b40233eaaaad9c1bf7caf54c5fde4deda0409a0bebc79117eb2baea0e69283d64fe7b04acaedb67043b451e32b852815181feed0051c40103c6b4c04ac9eb2f9abc2407f90b830965ee3d9d981962af90987db2d6cdc44b3adf53ace2022936344f68d38877ca7e0f50893f2cd3719091ec25e2630a3aa12cf64e90ad66b17e860d136bc82ba7883925e161c98fe2f85d4a0084b99f5989267cb638ae774166ee320459a95e9d9ce8685ea8d78637dc73ce6d11476464b687760707358a28b3b6e50e1a0d4aa',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('F049F3593A00B8FEB22457BDB6B40777','C52',1,1,'iSdT+peifVwyL2cbUHqzKsjlOgnaj1X5/6v+wNO9rSKOAwSVBK0C6YECE8Ux7PUkW/Vd/kuhQxn39wAhqtbohvEuTJbRt6pAUG+qaHuXy3NTOnD/3GNywyqNZfkuxhPNKK9LdSDp53wFrySZqjNpS2idprrYYGdFfVsYYbSt/lB2dPgRqOTV7atMwkIoAL7DG8f2CH/OXptC0eex+UzeRwMGPfRuD2g+qjhmsa23YlgBZ7ggMHgypGSR0hJp7KgaNYrBQPj0p8/cpZ6yKqvcYHpOcE9u8OoibpymrDhy+hRCKcnp5z16vgaUCyCyOqQL1dQxkF2leEgXYbK464GNoQF21BP6u+67TBTbMGUn02dwP0R7fk/z2fAQeMRSSXKstPO6qTuE7CWci+1JIsd4Utof5Ps5u0PCm/hIAPqgZf0FUMlrbNBz6yJN3V/LUdk2fbgIN5e8l5QAEoMUCM6RRJGRpXPadtU7LNgypiJLLcb23IKFAag0GqMZ72n4CZy39wgI0R1RfuVDLzjUMpAiA298xFnZSZJFHTEVbHisVQvIsBAXq5NXrtlwZEwkunYqJfDqKw+vQzTViGWFMqEgiEpTIEZxEmQvnhkLRPw2Gnjs+iRvj5CmNaUWkPa01eAsRaNQ/y7hBb6LHi4DaaY4hH9YcRR7KiUXkwvkbtcEE00MStyGr2FGeQimpqR1bjpk/ku0p3P+uQy52GdhH9wEIwvc/TAJkH9knX5bPZdrQ8qu6DL1fNTnsciSBUuReTLlG4gDarVy+7rqroVWAewKmtSnl462m7eV+trkUFkgSaK/mUBfjFZAdj/EbD4pS9nBxoMnt9ueKLiA5fPalkhJosmddii4KwhZqzO7LUb/vfQ=',X'908a6ff3c2b92cc47e35ee91065ae329d6107edf90abcf67e0c4444a0da3179ffdc8391b471c3805be70eaecaaad3f4831e83ba51bdf33a185f6ad87bb04b4e2a8b80e486e504774ec9114ec3f9da2988a3b588260d26b4d255dfa0010429362b662648274c1dc72e91d716de6c9b8fa8f522a3f70da4967f86abb5de638ba0eb44a8881319399d7062ac515bda493c88652a942a563198421f52b7a914997d08c9ba726385f9fc9ba2ceae88d9a0459b22e0d8a8ae8bcdaab2c8d2ba281dd83a8fbec0ace2b019a01f7c297d63afbc27aca4038ffe722e12772bc0b452d432eb98be82c0a3f8269567ce28770c4c953fdca76eb72b5393f24fac62578087dd4',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('6153951B34EE6086FF6324E1B932F894','C52',1,1,'dSpqmaMU2tdvg7WPW6TsGjW+lC1vypTxCyhOo9T1xHGiAPYGNew0ZCoD2pPw2P/8JWsgz0vF45UnkIy5hz/1D0kXeJbL4gV4ZvntXd6VjZXi2xETy1EnkDXs4PNoPyYExS5HWlm1uw3Y7DUf3VqWBrJNAXJBOvuiKnWEzRiwPN9QolHoAMHp05kR3Vj+MjcdKY6xzgUZKV/UYt1kdDMKS0J5KwHMG1irrHOAZALW+ZEJFh1Ur2E3+DA+nK9raLyvH9TfF+iYGOMquX0TPQEn2nIbo9OiBd5pWQQiZQakFe8EBKiMjeMvQFp4EcOK87tqpHSNb3YLufsjEA0iQ8ZsxpNaGkA1j6T7fBhgYW0QO8nrLKxKZhxzhq2z4cnc1DMhiAvRqaTy8mtLfIfiZRYiYv+m7oqbWMI4Ga4iZoZJ/ABnSi7TGVSViD2Yn+62auRM00jD2pfubC06aK//KTBwIycwmUbweIlAw+Adq1f1T/mX+1iuZrecwhRN05WT1T0yM9GpL1/EtWq1FjMTENH16g2mX+V6JbBtjrTNX7GkiNKrDwMMFJXbmogC/BFPwJfXF5BCApkO0DysH2Btdzl5wU0yMtGMWPS2U67okMvVexNoiQC06mRxLiY4uufTQ0emXN4KLbpc/K20qMxfwpltO1R51+yAE7wUav6hV7BuIUAdf5chVvm7YQqS3/pqysGyZ1A5gEJzCKh1yY2mIdI8zAvUiCbQibWWTnBIBuByg4JUCif+db+lHO+tmhA0xF9/FP23FRwiDLlFHUPRwUhY0B8R3GC+WW/o2DjkFyy1BzdfcfORmeDEpbVJzqPoEXCHqgm8vMO/vtsD6iIfwu9DpND3n2SQ4Ucs6pf79vN1+LM=',X'6012c09f966f96376c4bad17fface36241631ae4d4b9a1c9d14f19e50ab19b86bad919e9b60694fa1eea66fc78ecb628e50b24b311bac38f6de737e9e287cf9e12d102d47248900a4ceab16751bdfdce9512cde26a434df0fb326c34c11f80cff88e2a283096c0d51723b02e8bf4b47125800ce76cc6ca111aac789a95fbab89c18bb33e35c460a0aabd037ad8bc096cff3fdb0eef2370ad8597223dc9c3a664ffaf3e18e42d5de280b9434635dca47bfd133bfc5e84b3ff7b66bd1bb0128ec0e228825626219bd6e4a6a2288aa419f2bbe58aaff08a7506f43fa516b2fa46fe3ff839157a6e718d4b3aef649b67f06c3caeec0f49a76c8a6d29ec33123b2d41',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('C6E8E7702F05BE8FFB5A9058616387CD','C52',1,1,'kOF/k6tKwN2+Lm+EQHZPjhyGxpbZla5FlrLAVcHGbxW+2qmfx8bcgM/ahGP45DADSYyeRhBwQalW3FtIUtpSHuYaQiLDvHTHHHi76wjixqC8ydVeZGFt8sJqj1nfJWoMlOJMvYX/qIw6Pr9Tbv1ZrAyIlFN4R9qAFCVwsLG2jlKeB0E1czbz/rfx7Tv5NekrVsSEkfQeZj7J7mCXnmA5sXWv99E311j8rO6fX+i0NjJ06QfXLjpP6EnWoz5GEu50eHD+kYFd4NpBEo444+BFsX03abk28VMvzXihpyajM3XnGBncx9IhKKM+PkXQttx5X971AFOxqieh4dcvY3hMM3lktvNNL2p/dQ/YyOBFHLgttOj3wK7lut4S5d2jJa7CWWDWwRK7D1bwfaEIarwqi9gDty7GacTAlxSTPjc1kt9jL1XUIlru/z8YVRme6zDas1+BeXAvYn5UtcexZY8xeNpTUr+GpxU9BNaIuyQSPzGG5MbZKZ2KvIAaPizxGhLPDcUfmtlTSTo4Gagzn62xjKHUAM9icz/54/trUpq4YTGdrpYWhvO0Aw0Emume4o4n2tUUQFh6p6iQlIWj33ObOnTS0bfaw/MVQsl4vVVZDS6cj04l/kGtiknYMCo3N1mQELs2/iG9pUjPf33jxZt1avmkAK2MLicyO+qV1z/0d4XNToPsdQlp2agwF5Zk6Em1G7dKfbqgeG70ipyVaIdMnJWNNSXQY5JrOGCM7QqLSbT/CKWmZ3lIlovqnGQN7qoIPrVHucp4QQDk49vqoo8WJEGY5HmhME8MXExREr0kOyhFVxTw58UNKJbY6oBt01lhusT/0Aj7ZokvLVeIeEV4Ur3HJiHuaBsQXe/XVIe9UW6CCq4c+ME8iJdM3DVOlJ26wNyX2lSpzc/FSUETXaCMYtQRHOWELzkV8jOCsKEZ/+N9i5sFH6K8glgYC/TD0yJikGuLxCjMjo3L1mHSlu/1WZ83WKRGzL7sELnkNkUw6iVGis20eO+qNOCblFlKofYpI2ae//AGw0FRFrWUYQYoFH6PocaeYe/TEQK0TY7yvt1kq8TNh7WNIhQqqLJXKv170GkM+zPk4SABeTVaZGrv9X3K7D1pg6ODI/n6dh0wMNNe2CLHdwradnFHBATTI0dYNruWfHRHNcidhsjrOIjpPomZhd7Vg5rGXTMpK1CLu0J04Riox02WiS8fWVTP89KRFcww4NBLtYjSX0kU7wdQzd8TbSAFrgylkDE5Mav2IKmh6Iag/uGRoq8/QKGl8o+IfXtjnCt7P70bSRfZiqdSYTVU3rib0C3GerGTJ97u/ErlLLi0U3K6xds/rU9ckx0/smxpl52X9VYHcICK9FJ/v6Ix9ap4FtuJw6RX2APtYzFggsNs6kq+PlVazwfRZ4CKFcPN/sjHU8tU3NYHd2WL69YFHw6FfeYeVSRcnpGKMzY5EHlr3bJbkCflHoXnRP2lV3F3wa01FPKwBvlFtrPvOw==',X'14c789ad7283e71f2af23122e76ebb416234bca66a5989bd56aa8590a6e962959bba3be695f8d0a27314a389469b6237add1647ba2922d7e7850ac1a726064d784f6bbd35b94cc7fe0f64eec6efd3c270e4cdc72e00fde799537d935ea68592f3acf2d422b57340b40dbebd75f27e89d107cd411479d7486e4f0097caf524fc0afa5f714a02b0ac268ba1b826bd18336be456f2c6396df9c8fc525fd3d6396f37b0a8e3ca5b158c63b534f7b2adb7613f9518555426d72021aad0131f503621cf71d70561620e3c6054b6858071215774a036f354387c96e70d1965eaf882f4b04c7364ca5aad630bd28110e3f2b663cb5b8b34169ace4938e7aa6511008c560',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('B8AA73BE0B8D7822D959A7790A82607E','C52',1,1,'p4hzf74UZkce6ZaQ/inOiAAPJTjT49npCUQ5PW78p50cEoXJh6h5MM/G5YdJQdzmxh3+FbFxY3EWHFGPTws/AcCr7Q10XStJy5RI8VQsuGmqHqzitNsOpjd2PyAjHqPq//bxi/TUnRC9o+3Q4ZlsUd1eAjsx/uHqo0aleJeSofxggYkh+w/QbIf7qCfGK7nh6QXTJ7qhDhjlX60TrnElZrKFmLMqstMXgAT5FilAQdXPdLjbFnUrFQQjQaEDvyneoiS4iaC+blrHCwx0pI5XJTz6/PZt1iYj6IWluLPZ8j/jG65KyUntpQLCyP/lYxigYnB9nhU7DvsIJ7+SDE3AfBaF+bkHYdZrPIWeYNMay0IPI47lT4P5igVDTBw2cRiy0KJViieUfIAuhZg3DEcLKl5M6GT5jwesO950hMVZnHRpA6CUSB4je9uE0LIu/SgUv7kSPG5+CDejj+9fkSbYCFgL7BMf3TmLUilUUcCaBE9JpdoD6iL7On6zfBbN/Z9Ul1pnfpShYLN/px9k7j8l2gj5DoJyRTC4hEaf3w4XFvcUJ/eeKXfWPU9jrkunBwcjO6Y5vojjDssm9gxyURLTTi+O9XMGShICzSp5aYtLRdBp61OkfQTBHwI40ZViM73NoVppJo/D/ccDhf2bxpucpkDVHgzYB7Ho+0pujmbi7inqwI8Mu1XqR6dmDpw7THdiewUsq5rWBbNLIsh9lYHjD91GTzeQdDqIL6pnRm8HQPjzuoRl4ahHuIrPyNao0loEqtGejmORk7pANOzHst7JTOwXrV0j7FRV7WnKJkE76ZSt/F6rny3QfEbL0JZ/fYQBQa4UOI6HmnrDCBDXDcmgUchQKW2BSeDwyaIiELE6JwXEegWUlk+XmBcalkCg2HRqtIoJnSLyrZIVTy7A7J3tWPnq9qSYaXq2Hhckr5ovV7oDtAdLSNqo/f+SJBfmVenJ+aBD05JTj0auuctnCi/CBitgiVaB7gX6v0WRHycsA6Hf9ie/2mmkzt1nQKB1wjxus/sYxsc2RuZB5yL75dSeFPxW2T1GNlR0S5uPflIM5FjUsMrohuS0nlqgE8XM6xg6hIUqWE2AIZiPFG+plJ8OTvhBAKCqVCrj0DV1cd2LXsCLuXliygQu2JElGXJ75gEDK2qxR6B6lVvNSCAPXWJTSO/zu4zATWfHE6J5EFodWqgHVys0bHUDS9D+7qTlDiyWLI1FQCPkwyhIJ5AzMmSpi14KvibGmLleVtbZCj4S2Jnu0sdvZFSESLaRtUbftyDbAc5+ITlgmo+uZeIIt7N6xolioHuU7yHWHk9mWHWDK5C9tDuBSTquA9faCyYHQh+hRgOZZ1/cu52rJ0W3+JGRKQwD4+OV8NV5CYW7VScxga+lTZSKMBkMA+DrHI/0MtyzzGXkcrBcrP7rWQA3+pSoh0jek31WQoiK6Ki7V+D287ZRIDNiEABZdVr+XsaA2vuFuCVm/M5zttheiyIrGNgWBw==',X'4c684a8ff03b8831e90d396757b00284ee9f9c5a8abc475b08d1b3d922864b7a7bbb31da47193d8532c627583da5c5891e375b3f0740d6fbdf5709f37bcff3b2fa9f3489257b623625e6d569503467264800aaf7e7cad0a61a64146037942db5aad4d496ed75615b2914fdb0fb27d27fe2ed8eab922fbf683e05881224d4c232b5ef65ee5613702ab84d91905fcfc204a50ae8a1b89e48edccc083e81336a655c18a109eb9fd20b01cf55dc44e8f9c32371f7c1bc095b4b0a2496f9034aeccbff0bede4120af7a30c08427a5f96a26cfe9c5f18236fe5087a5616164fe58bda0eba60d3f02e40b5f9397e276cb8782daee360c546efc4e6505a2bc6d2fe74220',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('74FC29A02A40A36B7FDEE19410F296DD','C52',1,1,'AkFrU1APeExcg5ICD4Wa5rkAeqBTmFmJmAAz/EMqoTJ253s7+EWuEXJ/d7S20o6B0+Nk+U8onns2av1LKSYjZlPyp+XTi87Lpn8azKw0x7yY+pRa+AK2MUaDiOpwz8AN8dQi+DFS76DnFYzgolzwdJBrUh46Pm36K1JzSFLGlg/q2EiDK303y0AndEvIxLKvdpjJFInzKXh4XYaycdbQBrpV+xqzcbKqZEupf8HLEsTjqsPSsLJ5RyeOq+cbVi1sN4kM9S2SvxgYJyyIA6geyuywE7wWHDvfgFiAktpnQ1XXzpUYQDoc3TJ37t3qN78GQ06r8JU3ZNSnzCqVMddqDBdnJUmE7uOqolCM3b46MeAYn1CY9dyavnj/NHoxoLdb0tAC8u7GIIsqFXkZELCJVN3BC48jSTzcNmGSUYCxpOwpF9UTaydfR5LbuOuJYV8F5tZvotqGXkKMbONgIvyyR2swIDuSPLtlxCULXv3+AhRVsSdEi+zsNI2Uz0kFXq0+gNYTUjcW0EM//Hpi9qtsYzFCiIaSjseOqVQTsYkBcoL7x7UHlc/ydojdjixSmEOfpQVCbVQbFVftOl5FOKcIcWMt5kDu4pNbIWdlSVUUtkrGYhZtFEE3Jmq2nuO0TlhlZvkYITfZuBU0vg9RYWLcJO5mY+oA4Gxe/G/4xENhVAZrK0H1OmOFcDbnWPJzlCkvh1zIsHA5eCcxIOWIDejzgCnPz2xBahhcLuI7PsDodacDmIyPQpc4p6LvF2z8syw6+GsrooL2sWfM/RxDtkqX+NcoHib5B/qcjSsSNNLEHw+k4bKrv0ocC52zaWpy0WpMHR5JrcecFP0UzUwTQS0FNMF8hlqOvQk+twtUw2sU1a7o4u1kVvX55xSV5SuRAfvc3WzJWaF6GbYiNN6sR8X791CJ/9BwnOIBcSXiYoxKzT3dMwhgFr4GW6Z9242FZ1E5fYo/LlNlC8MMV6z1RvO2vTGFhP7VzQjQ+7gj8CPHPdljo9mKsjWUlV3eMRU5epzfJc/iGt8COA8MegXkWmEg77llQVI6x676yODOIKvKk1fOQ2Afdp3fyPWDQ3rNme1XeHBlc+H+PhRN/5kFXvy+Amn7GAMLJOJMYLNi2Va0u4BnwhC9TzBJYq403UbBM2uvMkZk3iMLoKZswbvRRRcyERxnhW6IUXgmDOif++uhxM5R7Ps/yvkQIVxXK9RG1cjLlZCkM/gy+aqXAHlaLfqZFD2V2O6cr/hFpTIhFDNoRK9bWxqwrQqYR+DHcRT8A3/EFU/uBqqzkUqf12u5pAu3YKCObxAtYtTlPyolR2wDMcpwjJQ6Tl1tFyKRvk94F8ypkQg9wIdJY3O3ebfJv6nmA+xyvAmv69fR2x/tMKiv45RD1hnTeGKr/WZC+dHNvGWaI6NaBkh1wn/A56+XuS7VbQ9xj0YkqOQOW+pdAAk9mRY+hyBzDCSJfqWaQ3UvISV8dQzkjXvc/EW+l8nmZrrivQ==',X'641839f19528e2af2fbf2e3e3bd94c755c5828a7890cfb4d9b13b53632a4426b499d7cc61b7abfd279a369cbdda2b785a36825401d0bc66f07d598d4f18068b5073802e237a86fbcbc99fd4068d68eb3609163bd93875f736fc187f59d32912ca09a8f5dcdba0593329b9ce3dc0b66120f40af9695434b71148ffcb92dcfbcd195e3f5a9f1621789c3340dbe9cda7e8ea558bea9ba1cfd143cb46a64f75a3ba109e0f7b98253b8594cb0fd0f9a0dfe4a7e3527c19b1ff9bfd6c1e1afcf23b9f638829950c43b3862211bdaaf447a065160393a723c8ee349e5016346ba2fdf38b39b12807cdef26fa6709854956fe75116d87ec0134aba23396226dcd8a60653',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('4F0DDCD6B21631E5B36B60C19B391B1B','C52',1,1,'Q1MQ1zNgGtX2z0CjJ3pzAbj1Z8CIU0krKNh4kCcD3Kte1HU9aErDc1+EpuNB6UqaHgmGcs2yUK999mBNDMQjKn3Xy4EOoeiJMHUMICcttD6dEoHRIKGCEFvR9QX+ZOj7Au5S+CRjaNApBct9nr8zEIUmkTpBFbQ9W74DgoWPhVMG+wDMsdTQAH9ATrYrecrmphWWPQ0aZGHQA8zfXPphB85bc74ARPj3z3gkV2iChjSKHPghI00Aia2KkL6hajAOC8qsaBnNdUWxI31HtvMT65Ej+qvHLCJ6dxXyfDcEZXr22yBM+nPJ8FD/ZLq8aJVcu4kN3fiiuok37zGh/AMXIlQL157KCmQkp8DtszMzWT0ka7VuYzgMMQJtAGjLYtyCuGqoX7laX+SVltkgbnB1cRKNekIdQU9YMQQIXgW+ZMDGP1NL4xWPVcWf7LR/nHOVAs2AI+8VkTmHLdT0NnAUw/954qJtQmkeDjJDMxBorqPEJAWi2IPcSUWQTFRqohuorlncOk+ijpqtnK/RaKBE7gOijJXkRTzImfM2rhtQ49NTIu+OSNT4b31EcNd60UgtQNh23+UYsGlk7j3EPskQl1SnFCjYVuqhNIj4WIs7RDJItLClwHw97RPyq0RVNBMTnXvP4sum22UxV/Mj3TRjjBbpZMcKdRx6iHy8Y5XcqfPgor9ojwUlpziPf/BR+dCbVtqTFaRJzl6E9dAHo4cnBmBa+bTKPCED1YNfZ6aUnICw6hYvpnmPsQ/lC1W7oRbGMQlfK5k/dc9BsRt0kOkma05mOYM3mkaxOl5bZFwf3jVkE/MB5pqxVWX2BsbHEEqd9gsae12tO5cKz+I0plMEKRS42AEoe3yJG2T5/z4dbf8nwBr+DiFGkV4Zx9cR2GBX4XVK0Ewy7XJ0dyjfHFAoZL6c3bchrf+gGnx45NK75s7h1BlvI6fP1BUvu28qSELVsJIWMq6P9wCL3qwA/6m9i0cAHilr8mxeN7ramN57xycBPXz+UMafOxNNs8Bib9RQlzYOUGgr4/lGTdFaa9UZSyQe5LvCoqwaglOR4btaIrN0tANz7tUMYRjT5Ed6QbJgzJwqEGdrQ6/K+dd+v920GJyEJUPi5wSzYNZQHcn4kpT7y2GlgBEOWgSQ4kRM8aWA5t11RrmKOKSNMiLCOEif2rxTxfSD9eaC3NjOrXh67VskaOy/e1kyAoaf/vbHfBKcmViowmfJ3GY0FV2uF0m/qY810HQCuu5OtWsIdRYZRM29yUQ+71m0zGW5iekX7wp2u1lKOye29NwzCAEq6v7ZyC4g8OmDlNT+yMpZz8qATJ6bHaTvckRMrunyvNha97eUjxe5Uha4gZxzh2EQcTUlYrCSQJKhyFCKJafdqAFfrj0cRWVqzPqq2piOt4lAqpXIVLoLZbxCWgiN2ohQtlDyIPEsLflXFe4CX7B1G8Dh99mtIJUB4AbDXlIAmcUqmBRstLjqi/WoYmCcUpmR/wcLuMRUM7yQ0L0sam5Pm8npetuu5LuGV7qnrJ11Nnc3X1hpS+Gx46gTH6QCyCN22/JeIizeUyrTW1FiEraONBvreHNYm4eq4oAIdx9Z1gg+v4P8j11a0iPFM3mO4US5qqNfDcJq4xd9lswN27Qex8XwUqA=',X'981a96283e83b2a85576dad342f3d7afce2c0165202549c4c2b87f40025b625a787eedfcf25c2bdb32366247048777708bdef222cd7f5528de59fa193326d50bf6639cfc93b24db7eb8abad34ce97bc9a6807f148a9e2a2e764102fe698762575422ebc947261df4a91de21b8ed32940ae1d40319d71b64b004a2bfc64f83d630549b9c45937d630e65ffb124d7a5f95c6412a85d76354fea19d8cb3d808ad79488a45fa53facd10e312b6d5b61b4846b12c77ef05594ce8ecd7ee42435f0b90e845ab11d0ab856b09b2ac81ce0fc1bbffe4a39b26c071de40213b5b06ce82406106af338212f51b72daaba830fe20ff495468d180cfbe4123372edae8dfacf6',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('C6B7A1D05CA9104E76C79C4F90110A5B','C52',1,1,'5oUFJDfg/kzP2qwKuuEwPVRVYi7CV21XlSt8ASX4bH2l3SX/h9O7sKgBpOv0tUFomVVjW6W2HBIppKMm0wRRGWU/zWFycGcJAtZJzOyw6HMs2Fjjw5imAScE9yvkwUsKguNLeG3jW2bzoa93gXvLCLBZEvPWQW4pbwOLkZ0IohoQaqqcw1IC7uKctuS6AgALV6G2YaZ5MUe7c9+dBA1xth/7DjECR3Z3MNIEYhLBBZG0NOfw0Geo2JK8+iRwbWoDxKK66PLdZba9ZDWFfMdnGXU3BZQU57/GE/Sm0AaiPm1zcBuT5koEB4QDCs1L26DislzlZ69MjhrNdnRv2kyTNx7v4X5JQsa0d+7Jcdoudt7IRduwtFoMq0xq52RHZwGIRuzoMb4u7JKESVKIxW4t5DjblEVTbbjKAw/sjm8rGbJNQQD8XVN7kF1u/G0NABK7MKtmGKNlgrlxEJc70xbQTrowC28D3mmz6RvhDToZuurNgcPFRnOGuGU5gC5JEgYtWmWiRVNDERqXgP2GNphmLyyU2R0dJCqH5Wlci19slohMYVctb27ggMPX4IiGP27NDPcT0jCyaWlXvGSa1z5MNFRcrImk1Za2IeYJsLhbIp9XrPoAm0F2FCH7GmDoTiD9VxWBi7Ip6wPAUkPxLo+U3KHpYm8bMM3tytm9Ayq5pn9Z0TROq4paQJp6jKaw6Q8fDX1Efd3zyh81V3Kt6kKBNrTHmh0HS5/6FVeRLvZBJ7BCzwSJf64wTFLnjJYBzOqLw4uHca1I9tN1P/ayv3GguGAL5+y2r5neRfwZY/SBMkpHMlqaT6t1VdO5RlyyMeNNn13zNlllm8tpOv6hWlkTfMqYRsp1AH8M5JR/iyPzaOjBb3wT9YDaaJjo615Golz8sa2iSX+DxDzdTjWwi6P2lynu5jWv8q3bEBgKzNmFpwdNh53Ht7xo2u4c7W5PsoheUYMTh5qDYdmgQUl0bLCvEptzbtlC4iGkGn9nXuKBuwNIvqKhIauMd/fwC3cBdcCbeStSdChDKxyZx5D/Ud4QmdjL0pkFiJDt1eRMeJXVVO962SDzOJM0dIobtz2VNRaGHQIa8/WzGChXP6HOCDi6HtLSf3E852PEUpYybMz53JZuUJSGIKKtQ8vW86U6/vzxIV0CbvjQcl/FJYpuXl5CgsZD8VfkQjQp0MvJlRWJgHTnvsl/4f0u2jEKy/MMCCe7Bkebf5XQKdOIBk+dn8Fwnt6f4qOADH04cvH1VsA5QbZjHjvExAt5HHtUzXiBylzhsuyW+NCXKGsJi46Dl3zhtPRVEHJXlHoXrZ/8mYpX/gQejCOprEHQBpBhHJJVKyabMjF1FT0Psk6WKvj6IXQRHJsg0KJkyfowgHN5EBLS5ezkwVcP+ZDupq09KskZrDMrQjJ64UOkS/dXzMS75787OpgFoqtOV4xKpI6puJTkOq8Ljy96GDrVsUTNE2qWCKXGOLqAsC3c+lKg24g4JUHYCP6bTYyhD7s7q7K7T96KMeZjSVMhT39rvT7zrdzw4JER/LoAdygB8p5MK9cfck8wKW6ju6nW15tMf5cgfgS0nD0pgqrBbQ4IvbKWJx9xoZyrJOrWkeLSSU2qhfvdsBXFFHk7fbkp7lmzS0nei0OfsYY=',X'4a2522e25e0566a4c77a7744a06c2304f325a4e781893b782cd133b00025e790e3d386041c7a6d85f5b7cbb46b54fbc9fcd0044a2395b9c40e2f19b867d0c212f76a89c79649b4038914fb97ae6b6e9da1ca8ac801d9c9d14638efed7de865f1272a71e58eed57aee5fe56586e56eb1be96eb195f7feff175576537f7b29e3ce1de0a35a0514d474d20a732e75573a37aa05c1a33031b3ff36c8ce8e08bd91e3fffac6bc1852c9354b6b909680298ea6737abee78f1654f51f5e6ae81b3c80e5f982c88ba83a482cde5f73ce85a6b76c5aa3ca6943ffb5cac3c92892560adad3e303d41ca7c7eb0788ec7a4e67954020285fda5d4304cdad6d5418b141467008',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('7E3487EF3E9F6ED90677E05B6D727106','C52',1,1,'ii4vegJRDL+1TBXNMijDWLMLQ6dGgGbk6VzI372UadlWJb8rC9I3m4vqgai1icUjxrsYbvcpZo0pY262e7pWdFhxzMxeAo/2kwhA1UIRW5Rf/4EuiLfMOFgHkbamjzMbdeO+ZNbPA1q8yriBp2fIer0QEgHRZ8XUCn9uKPSxZQtYPXxUOHcEY+MQdz/1sl6FIQwr+wg96DVzQXsECR2k+B8FmKLJWaxb145pDb4rwO0z5Eg2u/s1M+IlBhBYtU+J7xjb29MeyvqujlEwK/kibz1y4wtSOFc3dzLXv0gAnf03Qbrz0UuTo3Cc9uVHNLt2egfX2MKMEzJIixQPx/k/tNWU+12qX3/uxMSmExUmRC47m+quYFLfBZzV91KhKUmPAvlSL0PulRgSm77RFWqnbE0MtTkWweX3rkYFhU0NMqQHxTYkgB8uEplICzJ5dopMr8CYQQ2xwzwL87HDIi5ueOCVuk/Z6lOat4lyIq9gKfH3MLS3aN1xi9qsPXTUVVNVzOCM/WHp8BcKYct04Bet5u8EosgVD8VKI9ls5YhmeM6nBapw/2wYkd3ZcVRFcFOOvxmeaBdvwQyeTwu/vy4VMl3hqoAoon6hYLcA3Pe4W2PG4au591jtioUUPA3WIzgMiLRWJrosRY/NvTL3iiSXYXdPJbclUAX54KwPQRsXuRbnvLsRIAnj1jZOHVdylKpaqRhMaA+lvH7YvF4l7uFBrdSPUKbHQi1DU7JbRKrMRNHUSe8b3tDBeHEIx1O+t/AIMG/8mHKNpHZ0nNaSH6WYZM5eKU2v3coTzLHEYvPs0CtLhc6ALc3OqMQ/DE4BfXPHK97tPiY+ziWVn/bmeSoe65g4O9eOuPzvm4wV1D6Yn/k2DxqGdx+GXkiXTlUTl9esNGxptWS477pcdD4wLsWc40qHNMVfyHmEILKHsNzbeJbvuU+qehFFjQVIy3SohNqPI9gtcqhWbauXkUHQqbnKSjVkv0WvnHR9A7dLoUlcPZ6Ga8TpoXGu8cSaM/BSU1FGRiy2SzAgzFRIvMJSF2t3dafbCO7xF49aRkU8S2sXbbBABCw7XdxgcothyO4zXsiFHOejS2cS0Gjp4qN2VqWMAqgVPTC8NCsGj87HZwzIeQEp8HELC1FWbDOvOLsXmjlxQgOQSXh7CnUE5AYs9KFkMqZZjk4G+0WAejngV2f6TO5Yfb0/+7ssLzdgCQ5PfdNa1y2Rw7HhVleE8XizMJNq/2uf3kbpl5uMUASlezZngMlP/r6W/AWBALAKNzq56jZFb9wNizTaxWrfOL6Q7ihm4gSmLGXWxPdlF7P/jIEJ+W5yqWijsy/VfhR8bHgftG+gTOKpZBaVGsC54vbgZaAE8rlcjRbDPXdbxEnkBS9ytcqNdvYc4r4qD7v4ZUtR2UhXzBg/GjjC2DHbMXSMKvTufr0si1CbkRgo3lNEYqdwNlRgcZtQhB8gqB3DRGFUU+Lz4Qu3TkxiOr3jnTWgbPieT0WWHJQCRJoFy8pZixrUS0L7LLMePfw9klorGHiLpYw8rV+/58/o2Ua0oHboUeDsNGs/GggOs7jbTICqKgiYLArMmbfLrYKTAmXF61VmD3IKB6WgLSOoQkFgtmz6NMqbfIhq8kaoua+cyke7k76xQSI=',X'671b88221b1fb0ea2f408796c6554dccd04be83941e2fac3a454a93e98e9c95c56950bd8360666ffc6f3e7e7bdd34b7a182a7550624c7fed0d4962837c565b60fb7eba45a8567d328b1d3983f1d995e8a1607807f67e46b2e067b1cdeef70ee9a2d58b642332a6f9c647b0eb3b65d610426e456216bcb120c8116ccfdb2b0b85624acb588e3d7a8f1b560a5bd3e4f47f66806395661efe713723b444bc33bbd0a084c194a7a2498bbec44d3b125b1a47c5dd6faad609872ea35b1f9cdf679263c8cbc201a26d07c151f655b4da09116292d264c7aa3336ca425118a0122ee6e3fafdecae14df21d9c008fbaa89502fadeed6fa7182786b754036fbce5ef308ca',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('F640544C0C8F2B39DA4CB9A58B44538F','C52',1,1,'kp6gv2c4Hp/gP7F1u/UXOGDPd+wSctRxr6RCC8U+Mvaj/ZYXW354t7tnWvQH+1r7LvW3nDhhuWJMbhFjrVMR1GZlcnq+3WNlZxuj44q+zv/yKiWJPImt8/fXGyXYVe0+Ys9ol/n/grt/vEFrc8QXeNeiB3g1di1KXcxu9oRnOJhEh2RLRR4VljY+zC46pC+ijLUy88pnHfSs0Him/tehQ4lJ6C97WWFRYJquVd5FJx8grKhY6XEWxhjch+5tNKSX8OAMfDTmj/bXS1JYEwD8B2WqO1TcIY90U9KEg9abR3flxXQxL9ejJ9UoCjAd1aJ3Wx6kNwB5CWYCg+VSWxMpDjpdGKNTBhyX2ZKP5gIACL3M0pzR7kqGVbJU9ostGX2YszRfws1PNaroG1ZfK5Je/GMvpnx1D5lZfxpc93px5yQ9zp7KtHjaGsazvZ7xWkrm2QTS/2yyP3fhmW8CWEsJ3OboUdVHOtbZYkiaw6EjfybNpucoGspYgfs7aA+pC9S/OygfdebLZmP1fEuuJbYx8HsvwllW0mj6poWc/mCahzPJsbp3Kb5h55WsNpEf0gNLxrtGYE/6iskyG0RhB5YO/mt/7ewl1rtYw576iON2+PKnmSpqFVG5WrdmxZvoC0iH6f1cm2QRxiHLBk832LR3tC5utODUoIyn3DNBcow+aL18I+VCL7qDYzOf0mXLjJ4JrDkETjM6Yg0NATdJ5GAlxSQvcs75vJxylfitl+bTPBFhEs4wlttbNjCZeVIXC/6pqNq5YEU0kcQCSfhwKCWjepJpAwlG1yQoHPFaYxCmGOjxWgQCgJVGNLWgRBOhUKTa139Vf05ylToVYfQFMmloxhhg2CAAkTbIJ5Dlg8g49LhAa8Da/s+QZ0PzySUDT6NhEzp26gSg2CvYKWpCjFWKMNOtPTXPUYb5sI9nSCR0Inh7eJyejBET6wFE2zJlFFd9rNIp4noPi89so3IrKYT8DBdKvD0REtPpSDLpCCDypOOB38LjiJgZpw0AsDJ5UFIJW1HKSjCY9l0EqUia13LSHeNVXH8kTD1+dw+6WGQ6SRYBOMJWfOCMGTpBm8XDG5SSzUePqLBA4tiWm/bpTq1NGM9JhOTzRZt6DH65McQZGe5t+t8as74BCCdQCpjSs2jEpejjSO0H0dPKitCEyu02j877dyZ4MOel/NOshQg6bE8o0IXkBjc/fO+vXmfSNoql7V5Okoz5XFfa6BUSpBuBCOnJPDalErFWirhityHuDFz5ISI3ccg/qFP9Z73dt3CDeKcDFFwU8O7BE4BlmLJIF9SgIL3OTrsxP7pstEyHRluMr1ZVFLOFRJvX7ULWfg0TpOKSk+8AtTiJSkl/80xL6RTZ5XAiumUMm1O8jQnamVNw9koZQGyailuO55Gt2nE36Wj9YR1UVQQzaI31qp8RxP0RCVMJ7Wq7DgTmSF85p+1ZVFhPynredYyP3arJ6EEA1GaI4sp5FoxwFwg8XUcuN88RoLHBP/k5Ewiiewm1Uh7UY/smCsqWe9Ys+6lmH5P0NpgCtAtBgDbClikfzaB/iyqGxQ6RbTcbS2tr7L52RAp3VM5vLOpI+dc/B+9mLHyCwbkCK/UndteapD4bFn1uHQQ9qszHm5oaZ58UN+kTCFY=',X'5884751f3bdd78b65aaa46c9133fdd4cc82cd2c374e5db46a0d89d8ffcb958229558a7e026aa8ab8ed719a6099e1f45e127e56fead6aaef6203e395cffaa468bc4be638909e51c2a3c077e8eea53b0718a095c4efdff29b13fc4f8c653f69cff0cd38b3ea885e5337c1f06d4b49129fb6149265f160b01afe8d2646143ef7a1316f3c2708af7b51cfafe18a8e66afd2e99c086b82d9287981a25408f0bc8346ef01ecefd1176286d5e8e055ab69f5e6b1284163b6903a5120cc6e76a1574b52f37e44561f86c104298a7957b2c52a2be442958cfed49d7a9cf78f0487337cc02c467c984fba891414eb5a619662ff041436c8b446395dfb38d60bf9476eabaeb',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('40252EF44AB3332AB358FADB1C381C38','C52',1,1,'c1weJeiTVaUCFkNaF9Y4TWTpwjEUQh/Wfpmalwu4+t9aABurZPuu4JRKDNVOyO38IclQHoX2TP7kOoNtchAhOxt9/Ev05aTZdLUeBZoHAj3T3oBZBz/cwe+DRet88Y35QdN72EJYGuLsMgjCE0/dI9v+Nwwq7SX90hBNYPLX+Fuv6VAH0EYegO79jie2ppqZ/WClY1GxhTRtDgJ+GObIu9VTYdYvU3ZUBeK76wWPyYxgpWnGNzIBuJgUc780xZQCp33OnIRIzldPb5Hcr2ArXpZ5GxbH3uK3OOVB2krTPwPCcKDzcUtswyaga6vhDZVLiscjzPfvXHtytmZm7N1HqYuw8gUSmoqgCZhFfidzGOCZnZ1PCYiNXCA00V7ijRuLYhHUi2WT1+Lgyi7R+DEeVcA78DEAZm+4PyZG2YH3DVI11L0c1d+bKGiFag7O4ZPzFtY06XB3Z53ALofRoSLQPdyk0gbGHtp7ZxmDbgrHyghxvdO1kDNc5kOvKNRW0kftPROS6I1UWJSHMiraKkQgrAAFqmrEQcbjbw7WwJfedh0kdfV/MjlR3bOk4frsR7Mr5X82mieS/BOFQC1zna+YYNmWK8gn10Syh0bMbKZ6mMrvd430le8AqXazgal78yvwPFhz8/lxocb10quoGJLWW0wARpTBHBCUOiiqLlRnopeQmRpPexZvZ5tNRufIbyY4pT74I2AslWydr2Rr9K7e9kkzUMTKft127KOawHvMmWJFgxhy+u4uclGa776pfUF/yxuffKl9nO3pUYVh+704p5ufsYqGxj3suQtXNLRiNRb0pEnvdC7Uz93cQa6NRJvXj6Q+gFFN/CLdTCgA7S8BhZbP7cF7RpaQhcJ2L/n3ppUklAMcwQ6Zg8x5sM6djIi8YqamThZcD1srBrCZ1mnnWhm5z+IkdU4rTZLpG9+0TMJ7aDI0sDYAIzh7mTYPQAoRLSji4VUuiLf//EtEhcJrlXherYKRoly5zZf+78qrxQzNr32jO56vqYQ/PMG8KRFmP7AQcG0pDtSo+UVpviY1AASfN5V1w08ss3syf/jG95jpIHfVCQWf5z/5JNah03NVD7fAbQl533SvRHehO9HZrxDRRBdpiD+vAApRNzhhD4wnTf2bgptHfyhauRqZh1iG+kkPdPpUzdL+H7l6wKMJ3tqGUsqGTtHrMe9NscyI6w507MEhjPMUR5V3XCyeJ9HQ6/DsLfwCCNemz8oI8dHO57z2vvcWbVvLTWUpD7968y/yk0VrDqysWC/Io8ZysrY5SIYVm2Fh2LAuCGlV6kInSvG8MhV/BdtuMg7LsIT400EW/nUxF5ImgIqNgSU6f/3Bs8WItO9PP5MUSeu+5SrpnSuR3P0VRfXqzScLAqWuvZh4sDqABnHkk1jPG0WPFWj0uMxMkOdVF7/pF91XVopW+pTXhwikGD6StuvYKOLwhVwmwaeaQXoo+/+UT6vXT7fy0UCL4dpmYGTZfDuOkZzVGyN1VNGXeOEUeiFvOFlq1djfuFgyOYuJNA2JhA/HEZJvI5A0FcGeJLiG3Lkin1y497ZS3tERBFMJpTAmBDZDenRElCb3RthRhOOlbkUH1IXzLyzlQbsxHfukfvd1e4Uhi1G/LwJSR1KmGmFT1y8YM8Y=',X'8439ee47256c0c1269ef72fb7e482fe737eb05a2395486c7b44763f03ee53dc8d1229bccee28c23e2d64a1d852c628185266e571edf9b223c5c3311391452d7b0a61d08126bd94b7d0ea7d38101a005cd0643cc95f33a9e2fe02d316872f481d35cd40b019639b43bae5e5c4afd49efc3a3116b22e57ecc56189d6a97e7e16f0f8c761788c5afce631e75d9c78eb6d87ffefb0dfd36157d4f302c4ab7cf4c0ad6343b2a90c21c6666f871f3c008b57a99e09da7a0cd7ed3dfe08dc9c8b0434412f0079218fdabdbaa9415a856d341b0c3f18801dad90f859d7a831b7606b5eac294f1d4362aa57e22ea73cca4b7b0feeaeffcef1e779786764b62a8cadc183b9',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('A39E4AED69FA52311187E0D04D2E719D','C52',1,1,'XbvlXVhRVYGsJiaYAiFiWUoLpj/nFXVLqQJIJ6o7qHU+N7TWOOEli5tCsdYcHenNMate/hHjnDTdXkXrLWxBEUUdk2ZOwCm5fd7/TIuu0op7rpRudXAjYJY0gGgQ1qcAf1ILBxq0A01k/x4tC9uXcCClAYm9FEy9vbtQveYopryLJDK2u69Nx0nf4QKTaj0IFK3Ne7QwlJygP2zuBF+KCpM6QWGeNUEL+2LY/Nv742quC91Pgd2KXY8bCK7LE7yKSOxLjjpqqj56BPtasmlwIJeU+P+7VQTi/aD8D4bNjzCtM9jTHg+4Je2UQQPZe6pA3eTQnED01G1IUu0pU027IaxjZUOLp4EHyWPNgNZqDDiIRmllypzQCU67Gco6G01qkcCOOhwpkiL3KiT0Jg4XrOTm7Ij0hhldVOE7d07WhQO1FPoD73C0Av1l3ZaxIRHYrPvskv6JGzN4O9h9fPw6/VH6LlbxZKt/h+4UefSkbYnfcyqG3qOYeBgPyMl9hBtBN0Hl10BV1tc7LK8niFHQZfzxx39YmmoJMKXYdgvzrBjyNjeHFEkvajBEsUkLY15hUTseq0V2lMKu1+vMlnzM/lgwwjjDWU6/CfUIJxWOwhCPWO6s11at0JVk2jjIQM1Wxl3JV8zi73bBt8sdGVPdeXioXsUvlRFZ1nW9MkNdjar7JrRDMfTusmzir38UeAM9AL57RwR8MuzJye/kkBtH/Qbw++0baULjhTzQSz3VRcl39suOoBtTXeJx+qwVa11KmryISxyIeFHVrheTI5lZSuamvIS3ccJhtPgv7kMoSr24kholZ4qlq7ljXo0t9jd0MwFF0k7fBPhAGDHR1pO2VV3FNYXX2NOwreqnm4htOJlj68qGWX+SHzBtG8puE1UdOhnvnaKx80ZJqx8r/oKV9YQnCyFdvcY2ACeCnCLilxOn+BzlHDFBX6r5bZ2GFDMgixkyad0OEr0p1C6JWyvoBG97f540mVq7JU/rrkrSNYVJhZt3fIjNWaj/XSNxkifWWTIcNYgAGdTl9FZFyD+UEvb/hjfIfyCXJo7qf+RExl33+E55ChNSHoQyotXveYZiQ1Hos6bGus/fhxZjacoATtp2H897jM92/PSomJbztcwKsBAFq1v3hFr9A7F2yOgPIl4+TcPWuOcD/nNnLFCSY68BItlInW/0pPwjqXy9o8OtIynigdJgepv3Z2LR9vmPsXWUHNuMsNmayajK0jGLqaMO60UTXUklYx65dyTFiqz40Somz8Xkz5zSfeGfsvqdyxoWmzdwnn5k+NTd2HVnQsefa5/a0ywNpdMVQB7sWsTXKSXFCz3LslWOOHPPp1uQf9k/k2CSLla4AZsNpuqbtchEoyqgROdoGcab6G73ZLgKSLKwCW9/URBc5ECj8hDN0pn0DBdJiNbHb348LLoiFiRB3rOpB+1d8KF9qKBzk8X22NDOuFtyvlTlZKfLRbgtmVVCG/SmpZFgpXaDyz6cYYu4vBtLOmdoD7jmI5F/v23ovZS5KJyr+BEPpAJ4ZUKNT7HfJeJY/g3eN3dLAmics8ribx4DGuKEZIyH9m5EUdKyX3QgXYh6fHEdBLXwltzYbHKZsM3VRI62bihGcburP5ON2DmyYVjy8Fn5eU0Ey8Y=',X'49328ac8d80a8d4ca6844d1571e85e4a92a8035cb22198417cbb03efc4cf7fc1dbfe363edd64189941753fe2f885c479f5394f1eda5a8417baeed03c41ab4e053170e5fa3ccbd00a91e612dfc12c65c4624bb1b9c0800cb961fce70ad5cbad687aaf708a0bd9dff3f6f5f30d27b474c25e7e9707b10489d6e7b3bac832aa152d8e9c4220307dd33b0a5990b01669f06eaf51e16f76109455a57640476a3b4f08e02ad9d97e5256cf3441304308ce535d83bc25527329f673bcde5684879ddf5f1abefd195df262866fccd34061e3f53306af6787275e44bc21ec1ce1ce95b02c68c507e98eeaac876c1fb2d33877e54dfd6697337786006529c31c861ff3a913',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'e85c38b2920444c9aab20f4926d20a6c','10',1,0,1,'HTW6DPCWEB0QCYAZ7ZTD89N17AMYR7BCRY06R727YNNJ47Q4GTHG','payto://iban/SANDBOXX/DE514871?receiver-name=Exchange+Company',9);
INSERT INTO TalerWithdrawals VALUES(2,X'f383c7879f26482584e86aa90b10aff2','18',1,0,1,'K2V2B3YEMZFMWQ475KNV2HT7RSPA1YXFY210749MN9WBDCBT94AG','payto://iban/SANDBOXX/DE514871?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$UtJxNQYxLoI=$stx5iheOyEgzfK+m9P2r3JSy70D8JTWXJtCD7grFX9M=','Forty Two');
INSERT INTO DemobankCustomers VALUES(2,'fortythree','sha256-salted$i1FyvNRmgeE=$fezKwJxZA3gPSJygSi8dXyvMRxMkQHtXII9X5NClMAk=','Forty Three');
INSERT INTO DemobankCustomers VALUES(3,'exchange','sha256-salted$VDGQkn7Usqs=$9cnyVBjO+WVIgTIyeQ7pD+U1Yj1ZZXHk9nX81w0DoFY=','Exchange Company');
INSERT INTO DemobankCustomers VALUES(4,'tor','sha256-salted$FEsrX8Efm6k=$ZRickLniKTQ7tYUNKc8lDq3VCbE9KRsOfbrdK+GWk6g=','Tor Project');
INSERT INTO DemobankCustomers VALUES(5,'gnunet','sha256-salted$ufN49w1+i+I=$sns8F5C5a+roZ4u783zl/34OSUCOBqHdPFF8VuEA6FI=','GNUnet');
INSERT INTO DemobankCustomers VALUES(6,'tutorial','sha256-salted$xk/oqfFugxM=$adk5C9K4czaHBlMQn0qLeJfkmgLi1eVpMjcCuGeHiWA=','Tutorial');
INSERT INTO DemobankCustomers VALUES(7,'survey','sha256-salted$Ny4FhY94KyY=$gxN0i88OAuj6mAA7auEjXAyNjfmAyq7QuwAbXs+PDKU=','Survey');
INSERT INTO DemobankCustomers VALUES(8,'testuser-hwi9z7th','sha256-salted$DeOWXrnBY6A=$zH37tTKxrQEgpv17d1UW/sDpOYqfPvSM31o9zGkQaEE=',NULL);
INSERT INTO DemobankCustomers VALUES(9,'testuser-7wwue25w','sha256-salted$HwpnyLja5bE=$lGADKhJ+fKW7k4ec+uDMhWeCI3me0Y0YXcYFGXPa1OU=',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)),1660496860,1660496857);
INSERT INTO NexusScheduledTasks VALUES(2,'bank-account','exchange-nexus','exchange-history','fetch','* * *',replace('{\n "rangeType" : "latest",\n "level" : "report"\n}','\n',char(10)),1660496860,1660496857);
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$/p962JXzi/E=$cmuLHvEgTfLAXqctQ2FOIuKzVxgw50UT65CSslAPFqw=',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','DE514871','SANDBOXX',1,NULL,NULL,NULL,14,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:LWA21AG2',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-14Z",\n "bookingDate" : "2022-08-14Z",\n "accountServicerRef" : "LWA21AG2",\n "batches" : [ {\n "batchTransactions" : [ {\n "amount" : "TESTKUDOS:10",\n "creditDebitIndicator" : "CRDT",\n "details" : {\n "debtor" : {\n "name" : "Name unknown"\n },\n "debtorAccount" : {\n "iban" : "DE729925"\n },\n "debtorAgent" : {\n "bic" : "SANDBOXX"\n },\n "endToEndId" : "NOTPROVIDED",\n "paymentInformationId" : "NOTPROVIDED",\n "unstructuredRemittanceInformation" : "HTW6DPCWEB0QCYAZ7ZTD89N17AMYR7BCRY06R727YNNJ47Q4GTHG"\n }\n } ]\n } ]\n}','\n',char(10)));
INSERT INTO NexusBankTransactions VALUES(2,'AcctSvcrRef:DLBB92WX',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-14Z",\n "bookingDate" : "2022-08-14Z",\n "accountServicerRef" : "DLBB92WX",\n "batches" : [ {\n "batchTransactions" : [ {\n "amount" : "TESTKUDOS:18",\n "creditDebitIndicator" : "CRDT",\n "details" : {\n "debtor" : {\n "name" : "Name unknown"\n },\n "debtorAccount" : {\n "iban" : "DE729731"\n },\n "debtorAgent" : {\n "bic" : "SANDBOXX"\n },\n "endToEndId" : "NOTPROVIDED",\n "paymentInformationId" : "NOTPROVIDED",\n "unstructuredRemittanceInformation" : "K2V2B3YEMZFMWQ475KNV2HT7RSPA1YXFY210749MN9WBDCBT94AG"\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'308204bd020100300d06092a864886f70d0101010500048204a7308204a30201000282010100a03098ff00d2f1d4f9ef23e8c29e687c9d206404605896c548793a0fd6ad563bcd256524b3ca2816c1df50252b3a413c8ee1781cfcaf06cfea4adc64b4a895768b2ef25fe38011364e5b8198a4aa0a517a64bf01a798ddb1200439990e13e4cb3c82d79b8ece3f725e0d81053d5a31befdeb6e2841dc0a5404aaf31d7b9ce5398d97f362a531d2a4b199669072bed882bd10fb354b45416544d975a5cbde40c000ebcac8a6038ba921a46a69e3b9dc87c7ae8e5a4805b45f08e25b6e76f746ed82a86f5ae10ac5b4107722119e67db808508c73643b95b1855e45cfa9095ee7b07ffdd86486611eef5d581235fe5008a7e079f0897aa7103969926a9e76f239f020301000102820100401570ff82eae0c81cfca856f394bfa42a8fccb35b7fd541334f1c053e12b60ed27105577b7d8230287b17eae6b2356aee9610a1380d2522844e52810f2cea2e345c21a66eb2cb2ff884ef018bce62b659ca7807476f063157e798cb3c308535310dff0742480c65ca6e8890fa0c5d1e55229c3d0aabe68dda18318e37e77a63bb01c1768dbc9be48b9d805358862ae0035d74aade349aa9ce3856610f11e5ee3966f615ed159224629ab1c5a3cc1cb07cb6036e979b7b3fccf161e79619ddb5dfe6f6a50a930233a97cf2caa26ec676735a07e36b56f580e4c0400b3929fa51d7885b11530f060ecdf768a346b2c15c3e4476ee54869110cd061a9eee18dde102818100dffa28b59b6f7e0304d45389efd9981710afd8b742ce1e0756da8f1be3e2a9075ee651db9a3c47251155029b5de9090e4884772bb5de15421f442cc15d111c0bfae19eb16db8156625cb08da610b9bda781ccb388e531909bdb9f5f0735ed121d0e2df26b1f43ba7b9d78ca594a49bc59f694f77bd0d8d31907f60dc0910690902818100b717be36b3eb711cc9abf10e967cc79878344bfcc3d3deef4fad1bea89f681661c973315487064810c8cd6b4c9cc0e6ced1af95b1afda072a91f7e02e3de6f9fc30ea2c50d4e26861579114f8f71d6a6ad5d23e9ae08923e24db98d2ae2504468c2382a4bcb29f35998d21f27bcf1b9af205dbedeeb2f11123a878acfebb196702818100b62b89a0ec63aa625a33381f20ee223de05ca62fa82e6d4e1ade79377e0a84e071d7730ce24dd4afd9810335cb1417417ec9ff039650a389bc547ef266f7db9002e62f64b090e116cbf66fa4eef9ba31df2fcc3a9bc80abd598b3ef5eb605b48ddd5291b17f245f30dbcbbb0914db144f37b7c1f2fad2e01fa3d2052d72c79c1028180154635fce7350144a60e4b893565344ffc0f9f90b4346720097304de60bf7ad3a198d3ffb2161527858ccbd9dfe4ccfc4d24a83ab4cd299a891a36ab214d144d4cfde35de028e78306f5b5543847b2f855069088b3871d6f091b570b8bde933b9b46f9042944dc08ff598dcb3e2597808e84adc45ccb0005cccde38fbe5d811b02818005d64a2996a8decfed4e56984ca60b6852a8d5962d6f87a90b48c54989f9b07c549fa2eecb5954f6f40055404cf62c6cf5204ab55a3803ce5263068b25d46f4c3cd6c766eed9ffc03bf4b5f7fcaeff0647af27dd28896f63ebca820d53649c90fb0d19c7d88beaed67133e5e1dfaa09eb649b3bcff7fc0a88199e7a65ff402da',X'308204be020100300d06092a864886f70d0101010500048204a8308204a40201000282010100b0ceebf64877cd9a8f331caa9c24ea334e4afc1b9744aff9ea02b14d973f86018e00955e8e9e109fd6b55021e15adff4f224cf0c0736ed203fbf914dda8555f66ddb921bf2560637f6b3457a46bc2b83bea579fdc0e8254de0320bf6686c2571581e38ee204b7c366ee3299b683251596548d8944f8110613ddf2004770722c76f8ff1000c76dca6560d7725e9fe5fa6bb053db0bd567fe0831966fe2f5020aecc35d40154bd91275e0ca72c83b67b26b7dd597e3bf0ed83434ec87d107ad2fbdc4a0df2ecf974b5f0446d517a8bfce43e855b848f212d99ffa7c7590d7d8dfc93657b3ade490696f1e55bb8681009dd4403e13f9abe1dce30f24895fa7e0c99020301000102820100017e9e4c04acce9621e3c2b8467da16531a23ca357120392cf419a9217573820c73c8606b899e976107093eed562d945cece34d9db2dc1af661a8e75e405008706c2b6677a12f41681055eeefbae178813927e87809bf5c4c4c2678b7bb27e5688f228750adcd87df54e024a080574de9696990e17e5f5677d0867d2e1d6b39a8c5e49eb8e471a4ddcae02536a0b937d2f52b5eccf1c8e52af9946884b6b293fc40e7bdf5a40db014e3d75abf0e0b9cb02d5c37937da0873f7f7ba06a3eb3dcc1b6f616d0c87d6bf157e662d4320e4fcd317fffde0f7435cc45090b4e57f68dcc00c2af7b8ffd837fdcff124e80e5d684721b1dbc0a88d5add1e5f25a3ad7a0102818100edf52e9138afb895a59ecb0a98d208c8b04ded15132550bf46c86eb61139b87a8635bd0f4df060fa0194bd90e414dc7b9d972870394b16d00c93251f5cc64e8bbdee6d72d77b8c074fc8fe2845cadbc836b5f542d7028015c1df56c6e7a2ad27a7918cb5d95fc18b969b21d69684ec674cebc1b3253312e40f3303d3300b83b902818100be36d05e19b63c928b863c8be5828107414a9bb0712f98d6699e8a8083ffeb02b02aa292c6efb9ce84c76ef7c9d5fd0e9fec6720ce50ac2fc8e53ac3635b009484415a1046fcdb512c45fbcb428b790982589a11380de407a00e34bf56b20c31d7fee640a4fee327fdfa4dd27a1511263c6bc44f395482679a3eaf09927affe1028180595fd870b4f0d30c69db5d798a7280d817d7fcef0874e082272ccae05951eba7215777be12d0f12b95826f3cc75dca7e276f89c1b4d32e2b503dc818a278dd318151d70be6414213d0f4b5f91c5597fcf80799a9d425dd43cec07ad05459f65d4983d26ccecb375f9d5e80f41f2ea7b818dd07b0a88d29503d213513921d110902818100b9dd09c1c951fee21b1fb1ede8f79a68a26deaaf8009c8484ab03619d9e1a99bd8d3f04387cc1b3d271550e322ffcbe40c748d58cb009d1f9c28114176c6274cf7e67bc0c7fcafb9238fc6b8186ffc77443c9b5f13ecced27c9d25018a0f3447480db4a39a15cd94f8612ac5edb0c42f1e7f17356a899f5ae8a7339620e1bb4102818100c303637b559ae4d14e22edf46730a6af3fe48489fef315703684f985c4dbe4fa00162a47c06a91484966a99933676de2fdfb1db87bb83cfdf2c4468be2ebc32171132ea079f8b355b1f8256f4c29a1e509661e692031e330daa73141507181994a7887cf8cbc25a32b68ca001320d097f50a842e4707bb214e0133d72e1ebc29',X'308204bc020100300d06092a864886f70d0101010500048204a6308204a2020100028201010080f109291d50ac1d186bc40584f8a2115d736d7ad311bd4f62a0f83e6bd49b847a6d8875d5f9e1bf4055cabefd619fee55cf21723799d2415018ac98275716c67ec6fb51f88fa4ca09c1bd710f16c7c2a09c4d5bac2666bede0325655a409d4a08cee6221be791984c65985d434bb2ca10603c84237633ba5d32c4220d2f0ef7c25b94c18edbe30a55da170531b3b1edfac012dea78696981a3967e9dfae10006dc0f8ce1f8af3c6e99ba57e1c30118ca90b43aea96a49df16169163b21274a6ce568e306b15da4b95720ab58ebdd2bb618cc5330b5c969b4ab57cee55e1413012d305ce8c1a16aa938e5940d5daca716408f8a0ff0c2da516baed034cbbfde10203010001028201001135198ddd15a9027101e0b503dbd27512cd96acaf824c8b4d9441ccc2c32ac5f138b0df58e0f2197dd2752e2bce5d73870c0f6098bef46a36f034085227b328663ed3c74aae90c54dac074611476efd3045eba4f24265afcf1d085e903ed33ed0121c702cdd2876f4ab123c5000c829632a14a965ba1e891e6ae9f5c960a0548ba0f8c80fc0b44b2bcbfd7cb262faebcc48a1dd3087168e8ad688d81d1db2648a67827d7d6d19bbe2716cab80ee519f6df12a2717e1a72e1159a74ff99ab33bccf6457d00b311f4ce16c10dea334d6acdb49d17c3354c0bc09f76e0d67d889625b5bb88f54236e3f100a8175a0559b7313dca7c077137eb12a393f16b0a51e102818100b94d3e1b3c8fe822780894d402abc0bdb047e3ac6d61a472d1c97b29a1f5aedd285c13ef27bd96658a064f68d7834971912d9d44afcac8210b82d7be22959f1ec9bcdd35ca22b3be1fbf5e3a692083c34ad8fd4f9b3841ec6b7bdfe8a91c5d2029ec514e00d0a32795b4ea26f9f7e5bca01179384c27cfb87e5da67f14720b3502818100b222fdd00bac834f5d496bed29a79a956a20a9426e78cdaf75218c32a1a7c4a68e28bf063163aa0a5151ce4c99ea77bc80edfaf08f5966f05003cfd83aef41e04ac9f9795d55300a359bc0309663303b60c614aeeafd12534b5093789c03f772d5e0fd7b8b7c9c9a5a44a63019eb54bcdfebae30447276f8a368d97be0d6117d02818077010576e681213b29cd910f4b9bd44fbe6b9ceb3ae02f85d1f74c92e341ee8878081281500b71104b015c745f9c2049c04c04297da084c0bc2cceb37c708cdd70004c2ce4613f0046515789b9c438faee11c7351de1966ce86688d959ea2e609eabf7575a2ca3eba338a9fc5822fdb71331c5a1033fba26a9792999899ee85502818072abebcf9d74342346de18c7d6e4b9b22d5b511a1e9b4d6d016dd31e54c9f6e170e9f1ee3ea4f5b5269c0ebd68e772a4ba2a783b9b4be5e414de1f5206be361df887043d88436a65681517272fe832084747bbd0ce1c934b63543f5a88b454fa6b8c2620fdadfdf1aee23a4904a6652a20cb4a9a6fb56fb8a718bbc7eef85ed102818064df3f7c47baa50d894fefc0d712cb71579112d773bebfa89b01bee826800c0faf6307d5237adf7a2e12deff9968cc598e58e88298892d6b2051d9639377b36d765434136cea010e4b61a13eef486308e250f901c59ac9e6de8e14bcb34db3aa42918f98f24e8f5ecf882c7ba3814ae6fe5352ac009481239df40fde5e76db27',X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100a07146544ea9da3cad747f447799c166c54df89d908f65dbc5c9c509ce92427aa31a1f386d59adb8bbcc0e6272cc628c0b53e67efc853d93855bd058f1bc659e8c9cd67f52bb13b3008bc677763c9278ce6b1c76972e8ce2d3eecf0b408aa8fdc0615b680ba491f91ae9349072dbfa969cb007846e4282daebb0cbc9283cb6b4746a9da6824de3a09b486182d689cac024b6b5749f6d77b660f3aaa708c83a7534bc55e33298c0a59efa02db44438c4fa573f85921fa80e2e9bad798b3cbf8f965672d6a16219059e6bf6bfc78a7a6fb634922a7739aaf0a336466ddde78952639e54a0565ac71dee8d4fbef9a62be4c1ffe70df8da4e1b979bcc717d0826b010203010001',X'30820122300d06092a864886f70d01010105000382010f003082010a02820101009db344205a0a1da5925bce9ac63141e3df90bf37f9b48472d3ba9095ae5c471f6a4f3f2c662a2f76fb82e1c1c6f47c85db29df664cf629fb7c028b65a20b9632abda20a15fc1480cc40c0d35f252197b80cf3592f90891791fa9a9fd385043319f5bd904d4e14b4a3e1d4a21fa74e0f3b6a8d45a8016677a22dec34ae9c8659bfbfa65e04a30c4337699044f340995a6e6bc2003f1126e2c8cb1274bde543753cf7cc0fd643b4c3f9fa13e609b0ea0b6bda537209b1555eda704c98109aaaf4c9696b7ac5daefa8521ce5465bf791fab73012c053c9e3b11583cb7a3035f6c222a56e750425a7fca673e88fe893c53cfb907420e243a95fb858f84a4b8247d210203010001',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,'HTW6DPCWEB0QCYAZ7ZTD89N17AMYR7BCRY06R727YNNJ47Q4GTHG',1660496840600,'payto://iban/SANDBOXX/DE729925?receiver-name=Name+unknown');
INSERT INTO TalerIncomingPayments VALUES(2,2,'K2V2B3YEMZFMWQ475KNV2HT7RSPA1YXFY210749MN9WBDCBT94AG',1660496847228,'payto://iban/SANDBOXX/DE729731?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-1660496829108','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363832393130383c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a30392e3130383535345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a30392e3130383535345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(2,1,'sandbox-1660496831480','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363833313438303c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a31312e3438303730375a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a31312e3438303730375a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(3,1,'sandbox-1660496833707','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363833333730373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a31332e3730373839325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a31332e3730373839325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(4,1,'sandbox-1660496835920','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363833353932303c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a31352e3932303532395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a31352e3932303532395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(5,1,'sandbox-1660496838119','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363833383131393c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a31382e3131393832325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a31382e3131393832325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(6,1,'sandbox-1660496840341','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363834303334313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a32302e3334313936365a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a32302e3334313936365a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c574132314147323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393932353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4854573644504357454230514359415a375a544438394e3137414d59523742435259303652373237594e4e4a34375134475448473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(7,1,'sandbox-1660496842676','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363834323637363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a32322e3637363138325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a32322e3637363138325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c574132314147323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393932353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4854573644504357454230514359415a375a544438394e3137414d59523742435259303652373237594e4e4a34375134475448473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(8,1,'sandbox-1660496844874','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363834343837343c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a32342e3837343039335a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a32342e3837343039335a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c574132314147323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393932353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4854573644504357454230514359415a375a544438394e3137414d59523742435259303652373237594e4e4a34375134475448473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(9,1,'sandbox-1660496847050','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363834373035303c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a32372e3035303630345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a32372e3035303630345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c574132314147323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393932353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4854573644504357454230514359415a375a544438394e3137414d59523742435259303652373237594e4e4a34375134475448473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e444c4242393257583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393733313c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b325632423359454d5a464d57513437354b4e56324854375253504131595846593231303734394d4e39574244434254393441473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(10,1,'sandbox-1660496849291','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363834393239313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a32392e3239313633385a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a32392e3239313633385a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c574132314147323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393932353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4854573644504357454230514359415a375a544438394e3137414d59523742435259303652373237594e4e4a34375134475448473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e444c4242393257583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393733313c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b325632423359454d5a464d57513437354b4e56324854375253504131595846593231303734394d4e39574244434254393441473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(11,1,'sandbox-1660496851469','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363835313436393c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a33312e3436393236315a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a33312e3436393236315a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c574132314147323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393932353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4854573644504357454230514359415a375a544438394e3137414d59523742435259303652373237594e4e4a34375134475448473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e444c4242393257583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393733313c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b325632423359454d5a464d57513437354b4e56324854375253504131595846593231303734394d4e39574244434254393441473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(12,1,'sandbox-1660496853634','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363835333633343c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a33332e3633343034375a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a33332e3633343034375a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c574132314147323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393932353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4854573644504357454230514359415a375a544438394e3137414d59523742435259303652373237594e4e4a34375134475448473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e444c4242393257583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393733313c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b325632423359454d5a464d57513437354b4e56324854375253504131595846593231303734394d4e39574244434254393441473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(13,1,'sandbox-1660496855791','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363835353739313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a33352e3739313034345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a33352e3739313034345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c574132314147323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393932353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4854573644504357454230514359415a375a544438394e3137414d59523742435259303652373237594e4e4a34375134475448473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e444c4242393257583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393733313c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b325632423359454d5a464d57513437354b4e56324854375253504131595846593231303734394d4e39574244434254393441473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(14,1,'sandbox-1660496857946','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439363835373934363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a33372e3934363836335a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431373a30373a33372e3934363836335a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453531343837313c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4c574132314147323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393932353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4854573644504357454230514359415a375a544438394e3137414d59523742435259303652373237594e4e4a34375134475448473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e444c4242393257583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453732393733313c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b325632423359454d5a464d57513437354b4e56324854375253504131595846593231303734394d4e39574244434254393441473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',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,'DE514871','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',14);
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;
|
