1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
|
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE DemobankConfigs (id INTEGER PRIMARY KEY AUTOINCREMENT, currency TEXT NOT NULL, allowRegistrations BOOLEAN NOT NULL, withSignupBonus BOOLEAN NOT NULL, bankDebtLimit INT NOT NULL, usersDebtLimit INT NOT NULL, hostname TEXT NOT NULL, suggestedExchangeBaseUrl TEXT NULL, suggestedExchangePayto TEXT NULL, uiTitle TEXT NOT NULL);
INSERT INTO DemobankConfigs VALUES(1,'TESTKUDOS',1,0,1000000,1000,'default','http://localhost:8081/','payto://iban/SANDBOXX/DE220640?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'30820122300d06092a864886f70d01010105000382010f003082010a0282010100cf308ea640782ffb4f742da3e19db493cf11ef1ccab2f42ea9bda101c5a3d67e2d2c289a3153cb0201d867da61bfab494366a5ef7172c72beb9c97a1300f0730b5a8b931e9ac1df85033eb87ce68c41756e94528f48b7e7d2eb6b685340bd1d053665871f31f032cc786cc1323d5e952c3a7e9037678bf19cd36d8dbbd88bd2de1982ae3a14b13595c20fff56c937c6fd00e2e484b7fb6b7747313bf1faa5e4aa2e4b905b08b4cc1e61cfaea82309c48d205236c356644b009b52808de55738286f70d2cd8e8fab1c6c730a43d4900a0f84f79225c3fd4fb8bb4c23a3fdec3d93c54f7c2e5dfe5e9b56595694411b4f2016660fa2ead5376f4cb8e6f0fbc665b0203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(2,X'30820122300d06092a864886f70d01010105000382010f003082010a02820101008d239e0a3e7955253ba93d26948aea160851f26aec85846e8184143cb4b79214a84bddd3b9fc5874b90c201efe1f6f812168e860e42139863113377bbb54a755cb4940ce2daa93b81021c0f31410fecb25ce9ebd4b265e72849ec33243718fd448e647c8ecf36664b9edb349095420da2bf889e9c2c65f9b2c27d2badb6d56b0a74ad4eeaf8c41ba9f63a2070c491b7ed2706969b95340438577888786781e53ac00cade46322625a4a3be688c6d5551aae259233ba7fd7ed64bfe8eddd7f96ccfd7e2d0a0fc0cd88e6f63bf42ba3a5836c2abd71d7bdb6e9a4d1d9b8a8a8f048782e482f75b67541554e7811f84cc5302896ed6a78aec9c967c57b3aa22745d0203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(3,X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100a785b43f454fc1ca3a49dd07e45ede0bdf633381683a798285367b5d6a5aca1572cdca85d2e0c4030504cbfdec216db0322e9c72010c4773dab7741e48ae1b79eb423ba25a55d29bccbc07af0de7979bd83c1e43249bc9128a330c4966b4a38ac46f227542c51be4a66526eb2269b47e272237e6e6636b8898f21c1d0c20d7d79603549f67d572e9a1c8f7eb297a2ab904f33eb74ca9c37e79f96fcb5f9fd40fd0e413d97aaf3370cc19c63c330fc6bbd066ae5fa3d17c7f64676e7bc440f52cb0e8994503c71a0a719e694b8133535572656d4cdb2b742b278beb1db43b0c58c6334d2fb48df28b5510364775bdf86137547337a68e25770fffd27f46af86f90203010001',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,'DE220640','SANDBOXX','Exchange Company','DE885272','SANDBOXX','Name unknown','Z55SCM9WE71DE68B50D6BG9ZVZ2YRS0XMKD85BQJGT96BPJP4FVG','10','TESTKUDOS',1660512338938,'8JC9LI1U',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(2,'DE220640','SANDBOXX','Exchange Company','DE885272','SANDBOXX','Name unknown','Z55SCM9WE71DE68B50D6BG9ZVZ2YRS0XMKD85BQJGT96BPJP4FVG','10','TESTKUDOS',1660512338938,'8JC9LI1U',NULL,'DBIT',9,1);
INSERT INTO BankAccountTransactions VALUES(3,'DE220640','SANDBOXX','Exchange Company','DE531343','SANDBOXX','Name unknown','A8F8T8CG5GAKY26V9S5SFV7PPC8W6E94HNR9QHX3CQPYPFQ8T71G','18','TESTKUDOS',1660512346925,'GWIOE002',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(4,'DE220640','SANDBOXX','Exchange Company','DE531343','SANDBOXX','Name unknown','A8F8T8CG5GAKY26V9S5SFV7PPC8W6E94HNR9QHX3CQPYPFQ8T71G','18','TESTKUDOS',1660512346925,'GWIOE002',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,'DE583581','SANDBOXX','bank','bank',0,1,NULL);
INSERT INTO BankAccounts VALUES(2,'DE887212','SANDBOXX','fortytwo','fortytwo',0,1,NULL);
INSERT INTO BankAccounts VALUES(3,'DE940799','SANDBOXX','fortythree','fortythree',0,1,NULL);
INSERT INTO BankAccounts VALUES(4,'DE220640','SANDBOXX','exchange','exchange',0,1,3);
INSERT INTO BankAccounts VALUES(5,'DE816271','SANDBOXX','tor','tor',0,1,NULL);
INSERT INTO BankAccounts VALUES(6,'DE867248','SANDBOXX','gnunet','gnunet',0,1,NULL);
INSERT INTO BankAccounts VALUES(7,'DE192634','SANDBOXX','tutorial','tutorial',0,1,NULL);
INSERT INTO BankAccounts VALUES(8,'DE025462','SANDBOXX','survey','survey',0,1,NULL);
INSERT INTO BankAccounts VALUES(9,'DE885272','SANDBOXX','testuser-3xq98ypb','testuser-3xq98ypb',0,1,2);
INSERT INTO BankAccounts VALUES(10,'DE531343','SANDBOXX','testuser-jigtus9f','testuser-jigtus9f',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'308204bf020100300d06092a864886f70d0101010500048204a9308204a50201000282010100dc5fb170751ea3406c5f7976a390edabfdf1ea44f1061d2d3c388fc9e2ae2ca8947284ee2e588019ce61883970400126a90ad0052df6c3fcec04b3176fcd4a3b1227b09048c24fc67cb4e46829b90d6284c0b2f13c9d9c86c4032c1a63c1422a1006c701159cc9bd70a8a18963f67335ebeaf3b357421f83d0857a9fe7b25c0336b346fdf4e1c1f304e21fdf5118de848d306f375cb37aa116c6275d4f9f3d0ecd17504259bda72999d47f28bc2bd89d9a841e0d50d0b306cd9f178112609ecd499f16bfda81154b72e7ff9b186807732ac562d7303eb30274cf751e1d620a3d150697d77c1038fae9fdfcb7c2545a5e80feb74e674136daf25d81424ca87dd7020301000102820101008479ce2c216bf28d96d86a2724bac9f59baa22bfa0f8a0ef81852b031d0ec16ff21549cdf8f460c5a2a84500ea76bf7a632249dce33db5a1c4ac2a910b37a8c90be7ea1f426df5110804a24defcefbb9debe0c9432713918569ae59753a268c8ea6b7894314ed883d646b91ce387d2c87672fe5f303462c795c1b7ee8a9550f3cb44768087b9e72a549d29943074c30855fa465d351ccad1d362cf33a7c48e4574e736433a31e652901b194a87f8e679d5cdbb7a58edbe694197cf6abb40a79abf28aa671be0c6b0024a8328e60c2fda270c7953238e4646f3f34ed4591a5efeb6269f4471f2b22f65e734e8b497a9e03a89abee3b4087c6597a504acac627e902818100ffb1b1fdc5ff30d13e88d0bec972c385915a66b434e42682460064456a172bcb32ef10a082aa8198d0ad6e75d38701d76b51cca33e3d39e6b6a0dbdb6ccb9f837ed760d517f3e2489a73578179be6ae2ac631436fc6a692f80357b571ef5eb02f2e38f7de609f5fb8238ac730ad72dbbeea6a1097dc60cf053dd9a09fda4679b02818100dca32e643b0f33bc3b8ff2fbd7999b5129cfc7add80f7a13d1d3da32728c7e06dbaf4d0f8423fac6054e6f0b8bb1bf5b741f897f68c2040b9010063af72af892c0b14efa55704942f2b0e8c5859970564e1cf560fdb97dec55c383167f2cb885146fde44cc3418f139ead08194716df40556cdc8fd024edd59427419f9cbac7502818100d7a31e7eecca487b4f07c733ff645fec77270c5292008f517283c60c9c6a2a2ed627b3980a5a8dad38dfeab647cc260b6ca0b1ba4235146db43b78ef56936b555455837e7312e51561dc40421b50318834e5e218754bb0a5b4b465ee9557c3f8daaa7b4b2c03de855bcf3bf051862335c91091e315453f8836d23ea48a5a6a5d02818051ff432a74d87d7da31528547817da251bc8e088b71769631c44037f641ada6b6a11882e1009df14e0bbf980ecf5ae0c2ae7dd8dc03cfa8be18a53066efd454c24d8c06540836e76b703103ef81bc22810f7aa29d5a1ae2ebae0e242e61894aac0a1a29526dee5b620b427b1409db7234d28a969dcbd92d9a8668e0769524c5102818100d96c23370727a5643faf9b0670a8fa1de6f5daa77edb664b41c452a3d9075ff40b0d6da81cca733ba65ef4c55c372b0303b79bd8c281ed278b8a6bda10d981b07066d0512e76eff92304302ce5d7f17afbaa441c80193db0e0d26b5ab684c341ce681f73fbc1ddb9ab76346f947c06a8b701d67488e256655c070730809ca24b',X'308204be020100300d06092a864886f70d0101010500048204a8308204a4020100028201010090d77df92dc97cc97f3019fdb89723808e1d14f8a06a8245184d6d7f6d2e642b55d77fcb43222266bfb8bd4ca5a876b63d54508b9b55539758249ce10ab07a491375cb03b0d78b07377490366cec7025eeef0cb9d222a4561d3631fc84c42ef233280e2e9e86a6e7246db9b8734729bd9e20921fa20975b4ae65929fccb3161b5618dd44b7a7c9357654b4955dffcd304df50adbb32d97e4a9d11e1ff8d9ce5983a41073770d7ad72ee7b2e27b33784c47b559d427a673f7eb2a04731ad397e6d3d686de1af792942b12cc424fae7ee721fce150f68aa5e5b3cb624c494644abcc5878af2b4e57c43d51f328c60b67ce0deaaf13760a5198e64620632a95056b02030100010282010031fd5dea1166781e273a97cddcd6b5171a756916826f2034eeb55274675f5a8d265c712bdb28bdcccea0d91cca14019cd63ff268ac9cdf73dda50d4c125f64653245366338b6bbb22aee9d135bb6a2e244bbd69d8fac0b21f98509ed88791966d8471bd5f53aae021aad902adc06949e7023f7aad947008bf2a0f5e1174a3bf77e631cde24e95db4dca192c8b8c28fc47223882ca5af476bed152d82b8cffb7136d3d4859e03e3aa86b9fd6e5a6e2b5b9e65be1769ca824ba3c0b82d1b96a56fe294b0062f92acb9ceac058cc73ee369d1aad661408617f584836393fff070261ccf8850f8bd1f861f954fc02e8bb8079124c29767b7bd3cd0eaa8540960782902818100e55f8cc205e999be33afb5d76f79491385b31b596ca308c0849a48b401da68302d7a3ac79a1c23df14a6a536ead11d9335ba74398cdb4f050a8c179f959a0d0a1d83548480c12f7f0dd0b27985e19299c94d62fcde8f331ec8fcbb8646c3267edadb12078469f5fcda06f7956317b435bbd6fc7e0f95bb247f183c4b88b06d4f02818100a1a7dc003f1912975d8db882ca19e741df4463559ddc1d67b52780a3eda41dff06f2e4bde2ec96fd6ae370eca7a8c3fb627af7053b6b1692c3dd8573496c76220e90770d1bf0a4846902cef3d80db3096a5583f6bbb6f264157446df5277e3b657e3174f81e1a6bf59d667853c5be62bea66aefe731b72c3551c49f21b02f72502818100e3c616c93585dc1e7cc528165fa459650187f2c8c290c3c829e5ebfc953a85ec11bd2751bf3fe27f4cca8f961168c7adbfd500458612e24d6743e6d19a85f81ceb61d7341d87b9dab9a55d164054d877cee7023d89e53a2680003958063d14a53440078f5f76b9c7f5daa551bbad764f45d11fbb2f4ec9205cf57c2aa5fa4d110281804c2caf2ca68f0805af9df28e1ef1e9d94e7e0958f4d41e3f1a4c0d0032211dc968dad812ea759608c06f806ce3ec50bd8a806b1a5a0f7249a26626565708f6f9c1672dd24d922dd3ff2fc5997dfba69c0f3150c7d958b20b9b5879750e8554163e7fd222330fc3e5734de6e60fb5365707536fae934b21df0da210ee36f044c9028181009d8eab376880e397d20b2922362e49bd2bcca33b63cb1efab8d813336581c93cf2efd7775be60107855f56c52a4a42a30eca631dd4729101a58c0abbb1ec9348dc13d246c2bedd1d57b07f9bedabd8a9c6f297425340c12f72b67140a59a3538691e84c0e79cbcbd4a10c6c3b3304c2dbe6915ac234922df397f5aa9c31df371',X'308204bd020100300d06092a864886f70d0101010500048204a7308204a30201000282010100dc12ce72628575fbb898a049683327be70599672cadd81f89b91fb739d78081e5697f0ed4f3a75418849066a2394f670861d7f457268ac8bb5f9b67ae980f1a1bee7db4c26eb8cc6db44036decec64f49524abf6bd7892f804366312e9ac220c354caf92067137dc05357f3805d0a7b3839fd2b6df7871417501b14aa23c2f7a93014745ad3c7064777d3ce0acdd96d5b4cfdb50ed4f17414322de9192fab73f47311fdf9bb11bc0b0c53f987399d40a0b17f45d9a9b52250cd9a608a54f7ed6c7ab5a3a80c899822548dfab58157a58c28d16b6d6bf9fdde455107ca9b20fd18cb3c3bdbcf577b43bf61cb6dac0f0fcb1c87afb9f6d3ead472a8d09cdfb35490203010001028201003b604f970901dd2d4746d6a83796e5b839f3d1e5b2da44c0e0a868616f30fd6fc20948959e74b542331510c7fe45a89fff6f61f148c6f916d0c848f5ac9e7f931640d4281db01bd163435c718224ddb027b53738613270e4bdae36d8d976f9d0b568b54dfeb2f951418e877e840321dc0b3d49cad14c5bb23f716f7625837b836477eb2044ba7f9c284cba549e9296c5537baedf9fbaeea3dd2df23eca8ad1c236ace635a6f2932b7c0724552d0a9fee67ef859f0c2e51bf34301cdbded15c4d62383d535de9cc52a002c560316003717b95e73b64bb652540b46c6f0fc1c525ab0db92bff168032670b4034dbf0ec4421a693e7314eb063b9faa47f6b2e226902818100fa35943bad925619e0be2c212c7e3d7b4393d439c0b3b2957f50cee66b3f76a0dca4a0f38648791962942a7d301caaf740157cc2f3eb47f9b0523ff86cee681bf65d24a58331d9ef8bdf8d664ea51b72334e0f2458f240cb2ca417db8111db6153299515e6430bb67fbd646764f98ae2da938d65b6eda997077f37023b765bff02818100e12aae5107a52cdf226ad2c340ae437e243268bd7d2026b18f0958b6c151d924e1afc7c47be8e13a021617199074f3a9e328f4c5cc65c4c4ccdbef5f7a3c804ae525547bd6bdf38ae4632237bc35d6ba542f52d6cc9480e9ce0ccd9bbdbcb6a1f7e05a1f64ebf056010e1420d6ba0c0fbc785816cd8359dda9d10f0ebaa88eb70281810091a09da61e600dbd0211ad9da147d880e5d424b178771e79e4a023cbf89ff76ba90028ad947a9a012c5f105bcca4e2dd056f7c2dfbc9f51a5e8580b616b0abe79a7c9bd7b9844a542214fb37908e886aef717f5ea866574fe9ab983729e83ac76a9fc925f5df0ff2286713091abc2319e61dfb2e384a1b6acbf23f120d89d60102818004a3626fdcde742c2c8352d01ed6f820f311eec2687f6f0c9d4badfe25c14fddc8a05c5719ce544563a19cdc33f394c95d1a8ce03e33a27803584c7805069605f4ee6ded17215690f7df6ae707037ce6ddb113ddc4dd1242beb1d8d26a7826b2f36e35ad0be128543d355308d22386f81403ce9cb9a30908dde4a690c11b93c502818021313bd31d8872692d488e9650c6e01d5e5e61cd0cffe0dec777ce814e8b4504b129d26a58e9fa14f4e662c1e64152bb553d88024ce0bdd9dc914d81b80c176f0444af63088c0b68f0daa865c83971e90825b8f5ca006e95bec6da58e1293c64257e2c909519b106dbea265129b7230fdfa61fa5e7137b5dbbd87b9ae093b34c');
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('93CC55FEDDAD85ACDF202E2FCAB5AE31','HTD',1,1,'yeD/Y8e8kD6SRj0+pv5I/IR44zQOPXE8b4WzZEUN4iQAU81igCk40kYM3urXzayLrNErLs18pMchO2ImqXAnULEEAB3iqcv2udGaaXQe6GHhmizgMxcl4bMt27zy6zrBOQFjKOgRgR7yCWrsaQkrvuG6XDSPpHq8cUAXCnF2S+NI+JsV9G2iXpXHdbelBDvVoytd0m0DTy3vqGUxmWJZRhHUDpYPP3EOk9J972paGbtsPih+7+TQ37ir7ElYk2H6lrv1uaTd2u97wH7LXWCsBx8sEpBpqhIQF3wbPcTsFB8UVVZIRUSUrdSuFwVDvDqQUzVsvQStLCrB/rp3p/1lrBwRBNzM3l6M2Tr7WFeYeyNikZCdsNFCyVyOGGChIQZmaTnAWJEZAvNi1r5b7kK7aykGsHQYNQsSbBNNIfEMZI1oDQkrzDUliKYmvxQO9X+2Nju/Ajd2PoZj5Cql00jg/HOjgG/NI4hHX/VnsIyP2jfw2GOQ60S1A/Lu21Ntt06q5jfiftVzEWEJID1a3BYvhqzAlVSsA7HsbDwMiyMGL5PVuyCqGuYpoK6z8gpwkciJ+RlQuCFsxSgC1wboRm9za9ZgdWvAk3rJCO0bxTjmF+N/8o5bhH9TEvhbG+0qBvlX9zIIBFXGwveBx1l7TfcGEW+l0W37AAlrE7t6QaRbkW/GHmon8fVdykU8+NmdOC1xV/01ZAFHLedacHFglYRD6g==',X'249b04d3af22f52826ab419cfed76694fd470212e6f1010568140e1ffe30ba2d4f05ba9c9fe6150d668487b69b29dfd52bee4fdf2cda1d7599102a45d704e93785d3f2cbe4a4b61974b8316bb4fa6b935985ee0bd860e3191784fb743bfb0bf1acdc81789a9e04649354dc133caaa5cbac5c07cbe2491611daacab7a537c54054bc4e324a4cd0b03c93c9c038747ccb6a565d72f04cbe093a3a1093ba0a5b33c2829d879a52f11098434e2dc647e2680100ee488aa60bb11cc81ea8c5e84ef9b94eb10c8985defd00e441fae9110f9c21d54de6b6d7f2c254d7475bb817bd55f0cbda6647642c97f2964fe39200154b37c546198f406cecef5ad9d30eabc24a2',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('50C9CE3625318051F62AD09268C582DE','C52',1,1,'rwsSV3tOj+NCBk1v01UjzP0Tc5RZ0JgQMjdjYq6Y9RqSV61Q9UJeVpb0+NFOJKjG492lZ6WCUMMxVGeLtgSLgir3S8VWZINxIZP1PeFkOjN9+TagHSEKvgpcnFGRMBOSUtLlAYWi+5vqpp1fNwQtaOkcpfk+xn6kfmD7jMX+ZR0j0pIJmAG+kjo4GgeoSAjVj8j6+5Yus9Tue8ab77JxClvqsKIT1Ulv/ZRZGkW/AL7KxMLpMcTL7jmot5nMYxJ9/ZYHysltCf62XF3USPoAd8viGSbEmQJlBW9wo/yxVs2PaY0/Rle4jhJ7K4F+swbYhA5qvuwNQ8aR4Yaw676o5VcanCDwEkTDonOZYbxeEcyQoM5g75kDWLf2T1/4+TiJjkmeUOGPqbyjHI43IICE3sLpLFHXZD7A9UO/HP0q6Gx56fzs5DOvTZ/HqiqpJSTmgSOE5fclvIiWqqlJ3UVSATbPQXXM7it5DDkDWIttLkBHYxDzw/YSNMQeQbuKq0r/7sisVMa5y9+bXzIzNezwbboDQKQtFBKV7vRmaARVGAMjLRchORH/9gFlYemqRE+SigEFJVkmuGwkGdpgsueVNfQP6fvsQp1yd71RnbFAnOGd3Fg0JecYwaVCmJtEM8NesTJkMSIUVAKL7uvMIgTvuKkHAU8/x9+/EncaGvBJiOxYTxS04fJ+FqU8/+vaDtDGW75MipIIUI5vMsRMDIEH86N5qR4PYwCT6oGD4DYZF9j1lKhBVHTLmoNpZQZmf4DApuUOeGcJ5qjqlBapIEhD3GOpdePh/Xxyy+Y2UxO78R0iGwBsN6RADlwD2BWjGZ2k4GmdmZ0jhaDkEf8YFKuBuLGaw9qgcdq4MvJZ0UYfkK0=',X'a07c395bf2a317c715d222c8a477c3d732c75089a3bf6ed01dd7df722c4bd4b654d6fac29e41057d9cc737c5358ff0f7a7ba8ffcf639fda0622853e0ec814d3c6214bc33ea98ad0af0aca4c8e419150a9cc13e694907abb5b40997322c831f28f94c730f319c676336d4f592e16e871410f4f703ee0c8daa72f293aa067e315b629d675b7cdc60e5a4de24ef84875704111c8719f61eb6b6b7fe721f59b8bde517bccf21f9f576a367bfa448c6f42cf1874f0d43be2cf77680b22f93b8388467267f1e3b3e056973293fc830f3ff5b206d603488677ae9bb818e67349637ce34dfab5dc08d77a952c121bf4e7b676e24bd2a3bec64a952ddb20df40626cb62ca',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('C641307F43EEB31FA7B705D583B63BBA','C52',1,1,'h45vi4mfdC5lqo2DKDfxA9MsIIwrkYcZWi2bHmbBzwlYuH9LAd11Veone1o8XOFoy54G80j5Q1NpOLD2T48wtA4igtQdFmBWAp1dQP+FnWv+VYOAM5apsKJtOheDk8cSD6M8mQBKVVg1FK8bDXxEifPhV+qxGlItj8N6FTsxofbcd16B/JSqVV7Af4NGmGobO9m5VSeKIBaJk8GDcUa2qXmMAz0fy1kk7rfBV2Lyg1+GlpAa297zIe4erwICzesn/Ot0744YIAvpp0X0KTAt63uNH/aCcI2ZOZF+UXlPyIs5xpyPNi0NL7wI/amy3hm8PFby5BldqLhD0OUoMGIzyWv56V55nrqkxEZqNXBonPQDofeCSwbrKY6t3olWASRFdkvY65FG+QyL0l37L435z7B2ruCuXt3jgrtpfSynaHjOi2T9vnCWF/+j4H1/ueUfHqTsDc2yAz6RDT8rUfuqqg08RdaYQEULlpNga6DNikpupLZlJaoUFEci3+IAW3zkSPJHeGaKyb2zjPccSA8dMvjjG038KjNfX3C76TGrg5y/yp5gQT51WskbQ0uRHWoQ6TLFxI+AWM/MpfRpzxKIs/mNlsc03zyMqSDdHkXT1o3AscxwEE2RO1V/uPSF8ZIEu+ggoqVmX8h7Yl5tZ3+AT++QrlyaucCi9hrnOWLrBUHHID0xyAexBcWvzzQwiDTicVINLFaIKcAkqrPhdhXEf4QM9wLoVs2EP8ZCLSsG4Uht9/McIqgkLSwBfICXAvhfP8eDn4kQbw5SClEobBEvBnHX9jA59zp+7kOTUvLcE7xL4wqIs6aoiARNigRnl+GB5pDXR3BBo6M2BaPMAvCUzs2zPcEIWfIATINkNI3ZTAk=',X'5cbad4188f25f0c01dc040683eafb983ad1728ca883fc4b06d3aa6359d6ec01da133d867129b0446b6d098ea47dc011339cf365f82cda869e3f80e02a6349c7e29e36c326f0cea0800a2b42f309da66a2672be9c42784de6c0e3613dffe6f71f9f83ae7e666f38cfa355788682232ad632a077da08e52a511d1d95164b90c20a4d5b5d3f9fee59c575eef3b02aa306fb1504a4d38951f466a3bcb997f54697f36b59addd7056dcfd2045b9b305179903fd6bfa07cda98900dc1281a2fc36a30727f607bb7a008c31087f69b9727996816f85f9ca5f4ccb44bf70d1c574c0d562a3ff8cf34298e66217469c0746d5b3ddcf55c9cf5daac3ac98ec8f21c2662d62',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('5A7BC3C07643172380ACBF5A271BB58E','C52',1,1,'SEfWshiZQPgVpe/ByFd29vGi5/I4O1W3B/rU0Ik2kH6WQTzagobiEI8EQMl6OFzNPIi5TRT9GV8K0c46+5wwNP1a/ikntTVKTVrql0a00Z0vchxaVFpNL35OaIamTwNKJfNYwRtcoInRktpdRYRUsjY/ayA3HAmFLqJtoMIsLVWQWbkz3iMqUYWO9wxJsUaRIGgqc/GZZGfe7kFxbRdqKacsda3XfHTe8FgmogHOGBxP2+7XmUOGfKgZoEMdRalkXzlDZtZ7/15EUF6KGuCFKqbysBwvTmD6iY6EiqIeYRCdisr1HWNp8s5gc/Nc6SSFxQpa87rh1DHwf1Ye3cj9Ty7/uBRtASJl0ZFTODll8vLHe1p3H6/qOfDXqo/Oug2XRivAFnOnZxcKIaENhSj+sb96VBZlOk/uq8TGCgQNVY8aa4yqTBme5Xx50kpWJT7fgqCzpwlrewsYknGlOWnZ0QFimppoA2YLtxOaX40pF9ths8jxvb8zY5nyDRzK52yr50wpqfCv+auipmpeiJR2VXfb8PA1vQc/+lD3Kd2sAvTCbh88bbnKAsw1ziDR+IpyIeDDB22SxQThspfu5or2/gs+f4076UH+bHA1Yyp1w/nuRp9mTfMmFSktBdOFabnESN+RKrL2JdwkMxCn+5NwqULoZio4qcJbuT+UZHimOvz+fZvp7udrDfnKJz7PoMGlZGwFwCH1Z/6heYGPRaD5QgUBShtz+AURsmpykbJ5ZG97KvinfIXWQJqDDchdEN+xv/GV6P1NmOWAVfh9cnvs5DTFCvy285xwVzziG60iLHeh/YTGRSzibMeWmKoo3w0zVkH/yn6Qp/BeHfGt4NWtIz6p+Pqagz/44bW7JnsvRDo=',X'22a674cd3699c3838a3614dcbe1fd40f25dbcd7e85457a81d84e65ab79e05a8226d7b974ea47b0af320eab07f677948ce968e6f351b09533b3c9759d98c7d9039218c18320c43e392d5d3313394e006947f64a20c02ca742452e1f3f0adff38f6c03f644b291fd1f7c28f3103608d1aae41dd69ea02a1c53bddcbf2590db07d76e38ce935dc028fcfaf8a361c8b62bb90c0681d545e7421a1fe1058f889584b9cfffc02b8389bbceaebf63fa37180be16780d2599c7783e9c223a192a296ee4a7d366d7c10cd04b934459c9fb81885449e4d27d1e2940446d78d523b28c1ae204c9b14355793ac80f8fd4b3d51d8834baf3511cdf1b5d65fab132b135c0e2c99',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('7DA01EE0E973FA3FC5F2CE5C60C19BA2','C52',1,1,'gOGqHTnZJW100Qohf3iYlsAV7r3sLlOQcENg5T3YwoM48P6IAdombnUGoJ5phgBl25/cOBnsBSw0ADNQ8RDCZdzZ8AqJVgcPs9NzylneaNzEmJE/5ZWdTcDVsfUk8CwI2T3JtPzWk2aeUY0ZOwxOghxhg+zuGoQj1ggsTcTwwAf11ACQvNLu6IQRir3U7ezzheZbpSRHo3TxbIWUUK3TkDBOb2ce5R8oQ17fw5CgD7FVSJE8HBQzfTbBM5TW6CMxu1H1I7oCT57L9D+Zh0UnWAPxp74vZJ0bZ+df+Hhfk+eqZmcYVxyb/oUH9lW4QTu8DKNVjt6F8A3LQQc6Dak7qmP8iHu7soBpj1vc9SNfYboJp/i/ShqUmJwcutj/ElS6X6t+3QltJIdRaz4v0U7ocG9SzvVsvFtORcmet8V5Lm2vnb76gn0/D9l9zq98ZepFKOhqbGZzQ+PFFBDkS1RzKjukv0Q52iAcDkYUrMO6J/nuQ6vlKJTBpJjypE9pngcN8e+gMdElUVW3gMtmIorsi1OulmNmFZV+MsaVjtYbqf55K1YdOZURq5lYPzGRR0iE7YqL5vom6MGIwnXj0wLa2IYD7u0A7ZsuOcrNfmSWtu5H3bmdvZGBlqVUZ9IAFFX1O0t2N8R+Vn52Om54S15UC7MybbVh95Wgd/+aJRLdGaMQ00HbuFJTZzVOo8hcPEFcHVuS8MMVkleW4UeL3q64oGbN2hXNg/ZeXVYP1evhPcb71QfbOjvfeaaWWuLL677FKDlPL2Z7yPrvtWi1GkfpiezRT2sW1bleWN9sYEfH7Gj8OxXXt0sm4PVhXusGk7BQZA9n6b1bEefXKjhlTF2wPMgavyR+/I1ErxCodxeZAt0=',X'20b81d569d5b0ddde60f05deb383763c48f82a4a919eea9fedeb47220a582ed7bba07f30ba0f77552385dfade9614e5ed7257980b25f2ef1c0119dcf48307e14786f4a2f7571b2d91f681a9fb4a4633c8db9f9728190619a35896d0a9bcff634918f2ef5defc04f4fa98b7cbd91abd38a81efde019a59aa5bbefd055b12c6b356c5c48dee9a4817f4f4be3883af38f77fd7fbd8b6d260c2639fb4f6a944812f6e0057b7522ff2b9410d8f7538ccd72f8d6f728c46fad512bce218cb5034def542e015c4d4e0315612a074aa865ecfea8fa3186504d1dedf694d83fc110c981dcb4c82946a7cc2d9fec6ea29feaaed1ccf82384d7796d89b53b1a54eee33d1c18',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('4899E7EDC1F38AE38471AB91C578DD78','C52',1,1,'WE+PsrhBklvq9EGloMvzt7ZaJo2KwvMHuvNL/fvfTMyo76+7VhII9djZAYHz58mKafQkTBoTOAoACXgGuIMpWF3WkGYDbuYbMF18cHx85lgJPaMUkjvQVVfvKf39j5Ikh8Wir4K8gW42s4dn2oXD4dKAT7IqH3cbkpnxgv7hp2Tyvow4FAsNQ9t/ROulbbtiG4bWxI6+dcJMthB8DYxv35GKpVrxPB9/nh8Yt98W57WwKdX3GJGQx8fHot+3LqnlQLYs1e15YWsOkj0oH2cDZ1gJA6apZX4Rwxp/T5xk9erJmPT433IgO4dSzbwxMmPkD35Jkyt4bUFNm2vpvxm61ZEoHnZSHRORbxCbwq9t9KhmjeOGtaybqYqw4MP3fd+Cu8MSISO+tg3lJGVxLucsjSAOL3pPSySR+AdFe9Yat/YBFLu2w+pczzONwgJMu7MxZ70lOw0biBH7SpolXOKUAHxUuzKPrU7eeRp/sYxkCKtAQaf+qI93xIZYB/DXu5cPcUjCyhq4btxSru5opz8DlpOqPBfFUNtFYf6ZNjCLDyA2trcJJCGrnE7uELFNMPQEhzhnZs6JOD/OtxqPjrMU/zYmbxG4+Hk1afu+FN1cn41ANbngdGbyr+HVq/nMt0IHc1VoFUUK6M7FpGatP9pDNmspoViUJyZaLGmquYPv3gJUARe/ArygsuTX6a4oL+PZ1LyUjWjMT+LLZA3X8g0A47NfPYCtIPwwiw9hW4GT5vp6EKJ0Jmy36KyDi5yVKfj9pvZN2GD2cUwku3TtKw3HYTtMLXcdcBWYCGUuzGeNT4L9Y396iQOtcK3u7wLv1i9izmcw6goGWtBIiq2CKNj5DR4ywBOhDCey+ObrYgbtDCk=',X'84e6a2bad10bd2ee55460cae92c16cb5ecfd02cb483c4e0108f94e5ad4276bce4fc4bf58da8a6caf3b5aeff1162ee121cce57cb94f29ca74c52bbe2213616faa30249f75a9cc4a722d436d406de586c28331aaaf92827b348088ae0a251ee83c4c78f0a4d9d02ccfc7d5bb2787078603d14070a3ca3b2f4cc7f4835934c8a3526a1b541aaafa3e35bd8624a178f935ca3a78bf21e7f2112703a1db68b23e0e12f1fa93bcc7cb344f427655b3b21e794c885b3fb6f3dd8b86a29135d5e7e486a789a594a1e6495d48d8080ad8ad51d40caba84269818a79ead12afe201e95350b7e860e5527dc48a250e13d914b4acab36f807e82aac8267509cb72f5c182a91c',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('D25DA315E36C8EFE54839AA25A001B84','C52',1,1,'guYWeJHqwzfCWSeih2xFltueKPUknF/74XQ62ty1zwfLO2Hnlp3/7WVmDnfH8pRdVYjz+i3oo5lgvbDd1CCYTfQbaNRUd+OWe7jlDBb3o1W9mzQsyn7Whu8YXYQXoilrZPRXDS/p3qfTMCsedeePUzlpletjIoL78xbSvKKuQpNxZYvMWmNMqXpsxmF8JQFIPOFpHznyW4DXcbnS3GVcbTq5BYCrS1wTxyGPWjttHpv76N9uxVxUsNJMiw5JkWI88uxurqGTDDEvR9VRIbNT8/edtJqDYkPFJnxe8StIdnC2VGVE6vsaoNnnCRlp8j1y19HlGgL2QN6xhLDnUZcqpigVpCUQQQN+lKUK8fNweszMRyTBSJtyuLtAebHksk+AtKd9PG9UlIUFfKLpSgRQIWoUwaKG9KP5ClFa5Ab1RfwZIe6wQpwIBBor/4i8pJ3Y0gZvYj5zHh1t6HyC+Jf1sW/fJAAuaGTiXchdjiGfAJ2LTXcZQK/3qjNKevj34xDTqjFC4Nbr1K/MMDYsDbR1As7f9VRoHzVpINlsYFxJPWHrIMDkhVJTU5+kcvF0X6is27b45pfO3N3tG3W4EKZPUQr0FPqwss5W4xFV6G3KQZ3AHTWiPH9d96I3NP4DPl6gKEEh7Y4uYdQ5TSysBMGrP5q4huFVDlOk03U1uedK/dvEmmfiRl1yO73GV2cl7mChBDEAieYQYOHsKSEV69hz1MLj3NW1VPsdTRdiCSdyzYC6TnCxLRo+V22TUmegA/omOvWP+AYqAj7V7lHoXrGDZWQrXj2bjFefbxUbsMP5Ix17QKxGzIzIMsRPqsLpOCrtFXqUx6dzuyWUT5sXr4lioDxzooeVXpI4TvAG6OG2ptY=',X'0c19c8f5dd1df2e99c0f9cb6fe554606efdaa58f49ee1134a94881ab2f59642daaafa2fa6f70c00d73d86f3c820ac5c550e6cdded0ac41b52d060af709e6b8528903aac3b65a59d1494c56d14ebe5d076fdaebcb3cbc0cd08ab59dbd2000aa43bac42c9b56230b19d35b9c9ae82c137466dff54b9c5e61e70723dde68d3a2ec0573bd5467dd910e4867a8cb3e08f463406eca1891446c670d46dfad5115ffc86aed5bb5700603c2bef7d12ce1b3da0dc51ceb2dc0a4744d6005f1f372a9ecf6ebd1fe503832f8af4dbe4f1e29d6026859bb63e82ff3a5c4b39959f96d748a488b66d82b3bcd00c62092593b087da21b4395c48c4510670210638a438114ca11b',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('CEFD0E534D768A75FEC2FA16AB5B706E','C52',1,1,'Zb7tuH/5yCmVejPWdUTazJg3aZRWGwuuW81DfCA6KP0D1uocz3nJqpp1gKzh3exh1r1ql4CQ/GCj3Y3JZu63TENushAkJFcJKdERx8ERU5VBnJmQEGUUVAGxhdKWMra4C9AJdfPNdgFWzuaKZsklhITYzngLXMAOsm2h01rETWxaDuLrqMv/agnFn/6amIWT3y2KeOhnz5kEImrSaI1UlBpr18Qvn/PC0qMfEX9M7UENz35pCV4Bq2+Lf3utgUKfW2CWJwwyxC8xDx7RuEkxjnJ3oRcLdk141YMqguqXoI5a/6a5tdqeTCiZf/Gjl3FCDx3qFvHF0WO17sVLTNOvbAYfVYxaNWlMMJ3jjmauYsMCX1izaTwi4y7LZpvJ1JALIu4s2MhV+7uapEVwEkm1nho4yWGIbZJg/0E3pbypPo5E911dQF5fJheML8npxF7aDXoxVMmwRz7EPGRsTixLXPIn1Ko8hhrR+n4qykcGNjGq6zmYCImmz+M+JkC6FS0A+y6vibJeVqzyoCYade91DlEIOFZJNXgyZcrNo78nqhEM8QzJ7OXi7kL5NZCfjGl1Sl/SDogRQK/fCHLYMUDJMGmrSwnIfHrp64SpODccplxg0BxGVk45xPjzEh8QNd2jJyGjhCEWjLLpjk0K30CKKePwARZ/c+ad0feSPsnuKq3W59/YHR4NNFw6zHg0jDYMCSXpNpSB75j7A9YTrzLHfMS7yZLcIkhUh5MqHqGfbNIqX6XqIWqAMTeqGd7aCJ1/W/GAzsC/t1XYUAxChIUHfYumQmFJKoGAzS+8Hvi2PwoEuE2YEdrsfHRPs69ze6dO3SCCNU9zNe5ENUzEY90VOwAprA1lgz99YW0CRU1Aj9opsP6GQ7ubgiV2ABQ7S2jwZDPkyiccpYdbAoTTFFnOMFIlnmch5AmhAHI/fT3L5L7R3e9kyqsiHJvzmUPw5zXATbO9e1QUXYVm9WIHe9NvEZ04JR0cixvV1FvT6YO30ui8VGhzJE576KIosoCZHxzgcEgofYtd6k4haWiOHsFMtbZoIBZsTnAa4/Q5gn3ozCoyg8L0sEZtW0l1XiXyCSgCsf7rBrB68LwRZ42IW9TglJH0h6JSpMR9bqAKraS7e3NfSkTQ/cYqfuC2Q6avlQ4e7OL5//RXT2T8NBMvx2Jh+mXMox9nIqRAqPkt7v1pHD03Bg8JtzudFUH6BqGjR1LOXIycjwpxvllVl6LLp9mrlNppnBMxBKn+mmkYB7xvwypFFD+uu781Hr5E62jMKZ8lyFy7/oOJ45zw+r0RmbaFKNwclwnKkxJWgn3kBR+XtKRYYdydudNqOK8brJR3Tk9aLzlByNrbEwVdHMKxxkN6/hPXdlyXAvR1uE8NcdVShLwoSggjQJYKU8voZfenXaKCZaKX9dCD4ImAGzeGzOPJ6jdJ/Tra/HIxx7DaxmS7TJoavlzFS1TzipYUp1iemPxTe2CdMO3ZND6VlvI85q7zRw==',X'0c60a12e2a6d87fb4a5904aa98a3a8738deb84dc27d96cd3612fd60aa130c2d8a327774241e442b940464e31f2c5788d928d511ff6b14eac49411b58fc445b2703707c07b9b8def5e18095524fd9420e60bb956b02f6880e3c80439456f56421252e2c3cc81a96f35777b9d3a1cf3d9cdd2311a64ef5517821439e3b8fd80180bbca4694827e2f951be3060d37e57c8ef35ca10c88803a0b6f1542e5164975f21217b61398db93b3a5c26d9d2ad074c667c23488b6b1ac2dd6111799835f81a1a8d5d1c198cfa23ca16c4dd14fe3613e78538e4b3725e4af3c46fe2afd2505ca19a782367620a79552dd960f77509897986390131a13315043326781d9284eda',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('23E44FABA36AE90BCB97B01AB3D13A29','C52',1,1,'n2uxgGGA4Q379SSrLQC3rwx0OCnMuWDhp/tVMOq8Owk2sthuceLHJASyrM7CagyxMw1XiGwUn1AYZDkK9CB7CzMgWl5YtZ2nQqL+61gvTOiwUwK4xCu/42HPYfLpJOFkrmusAhnVz8JfibUPgFlIrCHMKW9n/q1NRyl6BwDv31ju1BbMr+ntzXQKfIRDfZ5Bpk0CV9PXONgBs+zBlZ+5okLkeJA6mYpTgH/yULdqXqZdYJUyI1+U9XQkectmCUe5I+tj4kbPnj06JZuBkxzyHEvNUdO+f2dV2VOPACqT9OV251s3zkbfgb72uVg+97bqbVqJyX5jD62bOIT+sNurJcGpL4bgVH7DM51gvHGfIXxAUv4AgmAc0kKOByi9X0n8Gk2nBptcR/zqrv6eqorGNRiwZViochyBLQtNGUv6+f7I3+Jkp9asrkOtoSqANhPEHzjvNh6CWS70I4IGHqcY4Qh3V7vwCCPQKwtxbSrzp4x3d79AOE8PtdyE2BYUFjK9WOrRVKvDijIO2iqVPeV/COTYu6K0aSFFl7JbuO/XWUPWPiqNF96QwFPqKDAjjnq07iVNKPxSab7GeElJwPcNAcBOlpo7XrSqTLl7S9jSjuApSO4dhtu141fhy0h+JhyOZ5ysRWiypZ2i1ET1uxwHTsVzo1JUiEgU+iY4c+5NI3gypkq0SRt7Ug67FrbQC7amme0lDKAujQaxo7YxuPwnlRmAyAG6kf8sYJ9kh4eMbjGbWkjTlku/qOhQJITWRzBowRg2h7RnVl9gtKvFsTCxhaRqOT0kEFTLSpuWROOiI/b8YiazUl9lmla4b+y/1KIB8UU1juG/akUQBiYXcXWhxbNbLNtUztU5npOtDyY8KBTaeIiwyckvpifTmQFTJ6BWikZ+L0SQKGKvHyHRwr0u7aRcRKV5kOvG+/hJwIWAx1ilgO6a4ViTuamVMjM7sVOSNaJyb0XuCUeucWdcT0bpqy5sj0o2efQF0mK0GS3nBuyzekLGpjliV4Yk/HPV47Hpk48VwcBBXsYLgkMccuvoifIAD+aMupHWezgv08G1xUe7Y2gN+I9QqPk8lNm0YiJGy3njO6O0pQjrQxd/bHlrSn5UxSweZuBs5ue9x+x6yjP5OHZftyJ1XbngyknClIKkgqhiBjmpLsh6qC7ev1OwgicoiOvTjfMUs78RxXQ9iubOyWTp2GNTUW756tYAuMlWRyThIGnzk68JGh51aEcqqOi0iNjDvPmJiFDRXhXzhxtpLnh9yV6OEl2cwDt37uVaL7JvQ8X9IEGxBqDrsg38/CD6KcfHE1A+GG7sjMkKBfOrK+LNWUW2yaHZ3J0YWrsmWbg4ULR/qMuuzc7+TSkH18YvO8keQnE3/ni0LPMzPK4HMJ+UyM1PSNnKko563HMX+xk0Ie8yD+zJLCYvhOrO4or07GTdcy/32Qm6E5zqA/YjHNkIHPWpisg2zEa8EUQGR0GiAr6geV4rPLcPSHQuJw==',X'05774c6bd5d5a6189da48079bee204ac2afd071960b4e41c9922b97f27e5b56ecbf57121eb7711700f0a6dc1a905df0a514fd1a4474d82e1bbdfacf5f97da49e9f7a8710b974931396a0b64a7ca480168058938caffaf9f7f89c91a3564706313f5c80e3c7090a5975dc7cd0bfeb0ab8584c6160b5fc1429cfbad71ccadd95085b5f553f998b3cc19382453f839c2bc70521756836fe2a7456e53000792fee7dbf28a6fa501e7f9f2c9df8791b6d0b1e711aabde181d2f4311018c6b5a672092c75dba6f9ebad277da689de494343f99c41972d72d54a5a2b75b02bf6bcf2150dbf6b9890732cc9d93680c43df4dada2533590f97fc493316eedf1cb3dde1aa6',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('812ECD0BBA65F2EF11C95BF99139B603','C52',1,1,'U8MfWlTydUwNFAgwSt1w84hAf4H1QNTDkfqfeJNC3xXBwODyViS17hxOMTej/DyglLD4nWwaBwrdn03L8usCgvpZwhS346mbvgb6acxocFZr5sEk6S1lVI6LaaObcP5acpZ9CqobaGx8Nr5/hKPkrM+hVnL+Cpp2DOWik6g7cKES2IHirZOfEonKm6DgiSeZGASvNZ0KSckN8hBKAHd14UhhAFJEOYnF75AqIbUZLoHqYBrmR9Aj5kUlc7X3gKQYNeCPljfU9Y7LH8cOCl+vTkWU2o9fTM00cA6y2uCiCSjLbu3UT6bWZRQcvKX45D5xmAvWLd3gtqzfTyIBczQ0TSaxCuJjHLndOSv3QYwY0ogs/OopMuSqcyMsbMxg3E/2tnK+sCcZWOHfhUB44uynOcWCJcnSCFE3ycgcD9+GvghrXfAq0TKWfV9RTCvm12SSTDu0sXiHX8khjP/KSuymRquKEfvdkOBIWbHuhdTjo48IgtmKHBAG6ejlriLB5ueS8ftHUxx5kkXkPr6q0cEqd+CxaXIWf0h7twx41JiGfZIMMAtt2Pz7UUeSsmLOTOomuu0/vtJB0PD5dTVlkKIBh6m4YmOzoaCifuWNireqR39PBiiZCZZj5gywu9N6rBoNkchxSQ4UoXglDigw0CIfIERx6si4KMVPes9bwVVzDNJxR30cNejrbn6ecZ5+MctUPWVzpLWa4fZuJaPEGw8YZ09DrYD1bJDfZTVXNbvqfmwEknkdicB9alCh0u8isBEEaM8O8GPbq6FQ52vtZ3OGsg3d1gYgof5B0Lo9d/Mbqi/ByS7mf1DNkf2OHC01qNvXFu4oype1AP6wFCMaoDv+TYBqBPfSIkh6pqvVSFo6prhZ9WXdk3uKAVUh7sUJX3zY4AdtUGmikU6//nM0pc1WX5bvdsMN4/5LZy/u9Sty+wy2iehM8Am6SrekUtSCqqpVHVvfPh75HGJqUYB49CBrwduCyno4b1lCgb5aq4WJHRacq6MTd3Lzj4glDt22TyEGGootjZRSGYtOR08PDVIfMnsDmrR/V9oHSl9k8Uj6dLQw6x4MQazJe3ekBYz10gF2tNclyh/V4y2UDlCZMEhzuUK1xAa8d1EOrnZzd0kjDR7M6ZEZmZGPmROCNPCXpcGeFiLzysY43H2xM/lTOylHGP9BYUkBxfY4s2o7bayXuia2z2a/qlp1t+mseMAEtV0ZUzfHV//luvJfUZgOlSf7EZkLQ0fA3bNo+yBD3ceIug+SjJ0E9xNCW2s3EGTH+NqBOQGNWGod+p2n+BgksGCqErKMyTFXJPnd+mBvkd7k5vOZlD03uoBwFEptSddpcN2QGnBQaAYBohxBwz7c9gSglSevOhRbLjAOJGRAkVUIGt8YE6mXjp8Cg7EYs+KDv7GI0fh+ZOG+2/VQe4DLv/xVN3mZwU1dVU1OG0jyk9GWgCqPN/9wo6JhP2zXgGzteCiAg/nKTYiMa4Oi6zcEAomojQ==',X'071b94413860089de63703d657cc311507306713f6c5a1d75ae3692161cf2a02f94dae83085911224b9d357c98d7f987e3dd20f2d29d0c844ccf040257b712fa98d2157dd7a6ff7a14f1b4998827cb6fd5b49a12c4b4d39d49bf7e584af859931549fda88bc35198292239de9ea5dda741f942c39479796572dbb54a09d84ac471c64861b6a2b5920c1a05a75c012adf909e3acfb6ae63a1a4c437577910117aec597e01465c6ac4929952bbe801d9fad8de9bc6cc5bb9b7c7b07ea35d8b4da466587a721cce77b1ac0f7189df231bc825b13bd239410e7ce665a00e5ba68ff15f7e7eb67f13f96608390cfbe14418b24278522bd0831d740c7745fd595fb208',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('F747CCCB48C7329802598AE252D67195','C52',1,1,'jJTREZ+S78DfiZ+xzyTURhDM7ztMcv/74g9+RYFxobBeARGSFCPM5r6Bu/at4aa+816lpG18yIIZ/HoL+ptEEYsk57bZjhi6LP9hVB8G4qBeCXCqbR5Xn3s6VD9ot/LANJaDtReDNd+open2hCdYKUB6gXLbzEBtvmXRs3WVucD17XCRwCSuwuJrwuzfnFh3ZePqaZz9rK51Lw16OaBTMebvW89/7HRGY5L5kI84bn5MPbQlGfXXE+WZvorwLUlCorvKTQsYy808Bj/pAXuwmWYCZr/7T2qLfbgm5Y+fCXlJkJv87lj1xKfjKwaeHNnz7/7SgWxuv2Ck6vv04d8rAielVDkEZWDhRzBQY6Rd9HRfVKrtf5YmNZ6daaPsJeXzq2yzL/ps+UwCLaPUX0+aTAlLr4kjLXF34LAoOAYSouEttXdjF3j24SbLnCC83XTrfolBpPELNNYKWGV0yiJPpfBV5jNdbdotVT050chfqVYA37djjlrICoGC9nL1sGSivzaoP9ZqD75GHpY6+ucarEHRjYok+brPTc7u9hDAOHm7fIHnwYq9tzCadIlA1QWzSHI7J8T2sbxDcXylJgU5j7mKRaAuggcKpIdBKffxbFmqWb4p9knTCXm6BzszQrGEOV6NYPgMUgpbOhWKVYBOAAUAdJgfooq4MQloHG1D582gLYbtiZ97AqT17oz4hdA6uuLGLKD3Hf8QnxiA+z2AHXkkTd+Z7OfJ0Kk3WX52SN7zVXfOHtxRzG36gq5t6zDxu95ISKCert/m5zwB4L3AWelRF8YO+H2sQi7VvT5o3A1l66ROsPCstkiV/hdOHSNTfR04/kd4DacajAoo1XP+XGfiWblHFQuEgp2yeO+LenBK1SA8JMSY8PLHnqBKiuySans+3SGctEGDiaLdlV3S0iZ2zRb3F/NP7CMeZmgaTeBrhhujXm5j+rr4Hwc4DWNpqvVUbg6JFBwkGc+KPX1CimV2M6FCyNZEr/HczDa2IQX79WHCBUHdYynwLyLUYQ5VE0nzLudku2w2nEJiNvuRMgZVwjFUS2oOZT31AH6PNNNY1GvrgM1OLMXbNUio7cJHXnMG+Dvav85qrc7H+y88Y4frIuW+k09AHoEVsncYWWQSnmhILJpRcb3/0MBk8FXYAVMOuPV7A0FK1gAG9lCoOdBaiZ4x/5rEVktpkBeZLOgScfBUHZy/GbR/4eVTlpm/Auk4cjaxWt4FEYHs219NrXp2/LSuABYf30UzPxhRJQZ0WvSoSZRh9S1NEnU8QZjRGBwD4Jqf6mQgZCrGCD8SK7oALldVsuvdUeinQkiR3aCaPU/smvZtZ8KAWbqkDG8LqNfH2VUkkvZkfmYTUiQ2+aABFyvBnnvNCF1yZYmNiOrkzsFrEna+mibbxTp20R/M1TuplRn7Xi67E1ZrQ5RjeBCcRK/RMi8mNts5yQtMI4QTCtNYuJRNG3N82goJje/tSn+SIBxBNXHMwuGrFG9Mj1NMRI/1S+HalQZIWvOi0Vt8cEp9Cn+a1+ILOap6Jx3Ydj6GEsH33/0zcACx9gaasXf7F2RjvXeMkPiHeJ8JO6xpYk/1/iUHh81jv8HxLJSvvIXDm4CtozMOeyJwe9j5ANzkF7fdsWbcxJKDoGD14jg=',X'1103e7ed14c8555235bf4275f3ecfe2b667721c63d271b1f4aa00b8a61f2c501a9ce6b7147e7d1c5676c5b13dfa0fa4e1c0a5186712ea89f7aa81173711a214c56bcad4cb7af14154377e51c8a1da29d014a0979c8525ccd3904c34ee1993ac9a29ddcfa2809e126a9847607365b755e73c9782d6869c516a1e719fce6d948c94f6c66296089589b66fe5ec4579c89d384057192689273eb1c27434b0ca25aeef514f3694b5e63f55166b7da915c57acf71dd6fe360a5796c62b562f374c09141cd71146d390188de76eb18051c73a4560354ac329bb8ba15c133bc0df6b2a7e9938a613a1b8f14cb32ce9915596c3798877dde04f27977c1bfe3fedb4192d73',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('5FFF7DF1A293CCB2AE3E1B086BA39010','C52',1,1,'HvwOnSEumUcIhbnunnu7oB5sSJz5XSojgianxtJ5bREVk7HDwPN5fYBvukBCtwNO4ezqyFFYeSOhggCqFEdUYvJNrftzFA2gOVu5NmHPmmEQtfqdq9H4bfvIhsAPR1auloUIt11inh0cct06DZua3mcPQ/rLTT+bqeHHHNe7YTjQ7VBs6pXa1sKdz4MyjF3nx55EZYujGrcXCbeRCZ1KIM/69B81JpHiL2Xu4H/NLxZJ8qDDW9Mx54OqtNAY4sOB1Herl57kb3Eo8g/0fzpc3i1uNEHqwF+G08rTz+eD2aKHWt/gpTszGrB57COgbv3/QcnI2+uQUuXHNKeQX+rjaivMFYL4XoU1tEUvmz5cLEu7DKCGyY79nPpmW1ubQWvRF+cV1w8rLBnJKT4XlqUoR0sa4tC/SMXcL3NuIBgsT+gJng+n4eLX89e7E6vvypYXq6U0CFcouFy3V8pU/4SOq/vegA7HJCMyZhkIrznX0CpR1F0HN4fwx5igtKKJB2Lj9SpYp9+J+cGztPN7T8xNVWMInH9fitA1qGzSd77XVXGT0ZYFiAF1sdN9BzauKTl/zoFaEj1sCNvXjwX7633OZTRF/0yQhu/LobnJ9a+hysEDXK3/mLwekVwx2uyE+OMADstWX6Sq9jMU6qNk5/L2C5LqkK0nlYt3lgjPrK6J/hY4qWc8WVrJVN4+BAoOLO8D1zQKJTdGC6Q1Lu+6/Tm7OXAorknjOjMhBPpWcrbb5LTWQ/inqd75uCruFYiELXAy88ViSRLGzA5NzarIi2bKM7AAR5VmgmOEvxE7m2jF8Wp3f+fHabuw56sl1rrDfgkQgukQ/wHrOJUMiW4h2xloqTpa8LSFaFVTFgODbfK1rz+sK0ToQfmZLFTtAQz3sjwR06BlAvc1zRQMP2uVzJ1hssR8AJ5g9bDQ20b5YSdz3qMX0j5Y8o88l4oTXz83cWGFfZvXCPe7VxdPVfKB0P/3rwHQZFdpVtlFXC23R1dTIrW4JxPtqNVQPbKav2/Hpw9kLFdJX0j8aKmO72Fx9gWMztfVaanYW9eoQAtpMfYgNsVYfCHFG7XyI5lyNP7zr6pcVGetKvGJqHUMQJwy2Rf7ju4Uupj8Wv4bfDb1ZAkaLpqe1Lijk/GfrvZMHs766J1L+TEbh3fHZ6z5fpGhUHqnuoTmk+mAAohMiuJmYiM+MRdW3jiUcIOlk33iJjerH3rW9Nt/ut0NSEV4BGg0LnV8U+aG7zMMijTiFWC2UOv32xNj2a9E5V0WqSzo9bFdUdQFp05pNp2xwCeR5PsrY0+CcdOm+nHS8sis3CtdkFY91XRhXwGcI5aC+nfcIfRcjNoF+5XLd4gD7ZBMuZP5OvTazQ3bjKxTaLT97QKhbrpIvg62oLSd3zspEbND18P7mrUwELdBJgRvybNQhpFZElpVKMGU1H6nDDL3T5EBc01hSn1qEiG4SyMsyz+HkoJ48F2Grw0mat+njoKSMn5bTKlhO+aS72Al5TVe1Ux8NGhvvOvgrunerRDbQ0JViSG0/rMnV3AL4Yese1Eg+qyKCqHXS7yg0Uv/2yyx4jrY85yUOGFMIQOrGjUSYPhNbBhOzw1/YBB1Xtg3tdDeXURmcMTam1OpvPA6Loygz6jPgJyS+jo=',X'0aaf8bd4850101648c87922dca61f97967f107637812b794c7f07189b35a4e73d5f21523104f5b65fe891ccb4dff5c3434bc3d36b1bdfb6a5e52f94f91a5ac47d1b09de718071a905aecb67c5faf5ff2e967acbaee125c18d8d085491afa8df5d44b83a41f075d1cabbe493bcf792c3926daaa60c1b1dccc25201f0f5f06cce071f58af352c010fbaa70961cf0d78423de3a4b26983e33895c003f64a74cbcc25825b1d8fae2e008e159b38765fece3af0f0414cd1b09a1ca938def221a2c65e124cd908211e512993e327916057735dbc6258490b870120896b3d5422c5af84f5603ed4f3dd1b10f87af80271ab3d26b69fe5ef41af15622f53451c9c135ae6',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('CD105963E170605A47F3842385E75CDC','C52',1,1,'OZhqfTaaLHTV9iVF40BTqzQLVW5Iav9flAzcBvKPar19F0L5T0MUcNYHfXOZZ6f9tEqh8bNBycbpSSlGQgqo+9YpTdPJBr3hkKDYLdQDwDfhJiY6t2guklhuv03zieVwxBOK8Z+uDYywOLpT+zqmTE8rYkgcceK2XNRZPzuS3lbdWFpHPs9k/KCjw9YvrGmy8jLiG3ADeMMaQlbhwYv0LrprcjRJdLqt1lh2nWwldefsqWVzYtJLq+2BvQQjakrM4BtA+y4uaaKw71mxH+xWqB/24emkJZrT7ztRAj40g+O0p5PeVIbo0sC1O7HWogHHnDFhpfUd7ww7Q1770MGc59qOCoJulLMfHoMk4W4YVeUXUPF5g1A/+bVTl4bmHbZZi50gIsm0GTXkCx/pqw6Y+PMAGtfQTd6rUn1cF4d1zssg0DhrkL790VfyvfrwFww6Z1TChX/lUsCVp53vPLLgX+C7VgEMuA8xNUlpvsarrbEcGplJWO7nkQb9xOoJk/GE4yFNwxfGAkjwB5kqgp+wCfbHgn3eh4/veD3usomtP7Q027vpjpgIjkEff/BQA+iQlnVzQh56CZYUO4jUm73rZkYLDayxBbhjuVED69bqYIPMNYWUmePdc5m8kKzA2TtNVtHpIcqu4W34KfXTG6mvr10gYmcsW1k8WP3r7LQ0PSMlbMnLr8yCGn1HZPEdVYLg6d2AKcy6+0XBREWAqLYloT/xjaHzlKbB1wVIBD7Sdn6rm1Foc7RMSI4m3JlCWLV4PbWULIszEJbI3lHBRLKT4ifRgaSn3BQ0WscsgjfnMBDX0B/w+JrCJ+udjsAVttPCJTOsXjxMDjsgqc2cnCaEPXxzfnD4bpTcuXfQA/h9tu+5IdFjQBReoy3ChtCWxf892cFmtamxz0PghGkSMXne/Tm1tIAtymFwrkCBWO6BPenTl9qx2T0MLktrDUBUY0+IFVQWr9Yc4QBobmlY1FQdNWyCYVbsXImEHTquh31zPqxiMgJVf17u5LYCKj8vKa2dABwe49WK9GBagJ4JPVxp59Q7DSO8NMGUf6fCleJaULRglPqdjrM4q+gqwJk3BmO8YkVI0FwdPB8/7ChPlX7CV6QME5bmtzLysJLOJE5q4oHsAnv0Qg4Wpwqx/qINZ+8K4niJZGn0ZypK7JCpVm40Ohs413K0VYC/23iZW9W/uaCqSkcnQUZ34tbbPJwfuvHQMVHWFvfZvRQiCteMknuWP8jmYN5N5QR8Z88/yG1XpArcjlt2dYXjN0+Xl/rBkJr1FZK7i4xgcWbBesoTcKNBs+cZsjgLR1o2yuh6+0PJelVpb9Su6jNWnFODc96s5Wze5bZ1Et78a+/t1zRdVwzidNE6e6rV4mKvM+Ej6AxJzTQT80UHsEHIO0Qy3Tcq8q5xOmEhb1Gl95UXENemxbTYaDq7mOwTLl9f1FkBrtYBfAIWFgHgpumRi42rKP+G9MiY3ihFIrblbI+QKEPWKywDxOpIdJH67iXk/6ZUbCrXeAZgLmdq5Lb33fVX7VqPNONY37A/w9ICiAwLSThfM6bNI+IfHNz2OetDuG8+Vdb+Y5ss4N9acVrQ871qlCkMhCVT+6Ju4ryl+v1BXKgWRfieCq1UWXXuFhuaC629wpPjecA=',X'115099701d7774ac90a0f879f985a373b0edd1ff98aa4c3a6ac0f0c00b1e8c85664276c98bbdb8e2dc06683c8ef6e11fe57f1342223562e891de24bf31a25a690cc5657770eaf375d162dcbbfc11e82e7f26d32b2dae2434348d0a4ed5c2a0bb35ceeb98c6c83dd3d293b0cd88e94f539d5c4d63016792b1239da15ce92eed02fde449c72f7a8954498991cbc9b8ac103bde086fa1f06ee026cb1ac872d2840da9dd2ae7bbccda2ca8d4da907bbf548cb831c5ecbbf5f9948a5e221b684112b5c20c629d1bfb8cd064ecc703982bd4b1018bf3a787d8137bb014977a9cfa461e7ef392ac8da267205274246c677cf4b9cd77af1011f12ca8206df22025200bc8',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('1478DA304AA64BEF505A28234B958E9A','C52',1,1,'JF7CXLKUi/iH3yBGExTDuX0EJsH3U3V4PtEpboWOsgFNJkofcDRRWDjKllAJJ3KPvCFlCAmkof9r3v1IU9HJ0yEKDfhGBjRkqxfWPGk05gr+R1YKNAsPQu1eDE+ThETIGAT3YIyV/P7ObmNMfcoF85XF+YTaSxXGGaJbi6aN09ikkFqBHSSJ3oqrX41RAB1B4jTLyG4mNOfLCMgIA55g/IvjXmClMB3Cu51VBNYgNsc0V2t58C8ZibEwsBO+o753NE6Q3A+KKe19K5W6TlZu8Ypiv/euxY2FAiVmiWHsKaKYzYpj+E+goZmlMVZj5fzxs7jOnTe1SOPF9ZZKi1ZqaOql/LBj8G7KcvWcbhbkMgRa2igoHpnHzmaNGsnO9swWx3W1mX0KhZzlJAV8YBK0X+K9Ec8r8GXH5bFsQVZxYR6m6x1xvnOmdqg0KyyDZmlRT5F/K+G6hw+6nWNafetA9P2c1V7ujMjFKxRf2YpHgieWnf1IeBMwY0lHiWytQNkVd0ozWs5NR0KJhO1TDWYelAc4aYScBmpQiqjOj62EHCnE6knnPKHQwIReqLOZ5AS8DTrO4z8reYTDbVU1wgz3JD9ADBYn+ZPifu5tG6J46EL01sqc+b+N4vVLRAmzvYYJUedVszKg28AaA1L6V/5ZqqTqbeenKPBCmu4P+e2bTn4EsSu6+DwecwjzNeOErZpWmeMDE8MrgpapsPXGPU/wZOYkHOImRMQ8vHCek/Ic7yKlovsMXyU2259Nw+6x9TdPQ53WUe8RY2BCDGB4wRKYLMCTNH54w6ifCHu8xFOdHR/cN6mhmvL91Yx1f6dn624Ms59SZnrD0eHcz+SE/z56lPXn9DYWlk7EsidSYj2EcBvTdFl8BXp6dLX5FVG8p3iLjfvpu9nFL088YL1eHBzKTdBzKFqm+pQBgSuL6rmhCj74Bnqp48JXEfmlQWy7Rb3f5FKcO2BS6rHKSgJSYqwXFLu1p2HATAlRBDDF8XbZYhoir6ItqOShe5E7d3J4QdSZRLgbEgEj9383WjeuGJjOSb34ayAF1t3wsBPa9cE/tmZWLJUeXKfUQ45iL3rlB/yJuIUVqYwzHnputcPYQXFQEV007uT5dVtbkT+yh2xPgplfK4huU5//ty8QEDmZ9iwDydwcvj/tSCdJKGrF/zlJ3I/ihNuQLW9lYWGK5bvrxnlmrXrzRkwodVnhB8nbc2AoXd1aIRFbA9eBJG5RBjLPYQ/AcO7BEGslZxy/8hkTfRnTpCC6ZSshEJuLlbmMBeh7qjnH7BXdNmJBuos+q1K2VFPTRzNm5IljSZL5O+VgzjgXE2vvBppXmAGcgiZvWAMsJEZYpVmjIjASRNTqJPVA/xj6zE+kXiGgU4B7UcCboqXBrjgWo25IBICYpo8IUtOcE/thmPZxoAmlFXB7K7y2mo46CEfqXSfPeHR2S5uzSG9IfKKI4kHhgvzNczDIDeO1Rt9ld+VrostfA/7EZCodUwESe1w1kKFWUcrSRQWzXg3h7HWwPXNYbRA5m1m2Dtox15sBWQSwMNhDDtO6Ul2slsPwhk1twOEFxArXHKoT08twhKjZkAyj1NnqxXAJpMCRkpn3o7MXrGA9nKO4aUeB7I+4McwbikumQKYOECF/YtA=',X'0ad71c654bcd83076f8c690f7800458f7e45b99c4ad3e8e868861025f5a2587905161f7a7bde38dcf0f33f0724effed844cf954098dab1f5957df0d3096d167c1d0da9b2701e596ec82441524ff930d698669a1041859033d70a60999321b8052663e6bd62d1f35df0fd3d74a6f05c5dd9c41edb8b63d2388a1595c1b494c423108662b76c97385cc745e030ee212def98020c6aa27be260c322c7806a5a21eb609c00b0b7531d64bd2c7af67f75ea53c051025ee89d6afd0ca78c1267b0400d7783f0930ae51fa8bf4bf78372ae4a4b60a80d0839229dd5107db03efb60201549807d5261cc6eff3e4c7939a5a5d6d753fa67eedbf3bb4b5598a525167f8cf8',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('97097B2FA0C90D15CA8DD32BB2612658','C52',1,1,'g9QhpCBuv5dcn5i0WZbvWoY7wUd6EdjrVKs5Y2jAE9WUSVTW/CKxod+xK2kzWveoAE+ajggB61SofkgRWC3AmM2LZPBuwAB9UF6g4WJMJR4oh+cixnZt7cCGaqaOkEx2RhoxLrl7psnN3W1XzgKF1ClgDBBqSkpsYqFGT04BHMT660qr+TZyDy9St1TEBM/qUesKCiSpJ5LflQTP1qG0AWkdnvr7NmrRctaVruZonkouuwNGWZ618zrx4sMHp0QAhuiUxAeviWczLM1pgl9ZVz4yJY20baFWvJEiGmtLFn5SW4vWxw5MBql0hP7Dgj2DBVXvwkVl7aqrpYNxOSVwRYG+rvfZ33eqn21sQfWTe4wG/y+yHn5CvyxhWiGzSIlMPHrAS/4YdzRHdaE56njSjqB2r/lgXZzjJuPaB9YTavczUcbF2UKcyFVib/kELHokR9nyMjf9WaExWYpe505AmqUt8hpp+cw+LgDC8PtP5jg6XAdtinLNVyExlFW6rBy/M9HRKF0c2Kl43EQGR8r9/CUTxUrFIdUJfnaIrnZP/IJSTAiicRMd+3erDchiHYHxLC4+ufHwktTE8osKidhT9pbBQ56BAs93tM+OxZaJIuxMCmqC1Rv1e5vKwzTzL2dEMyQhw2rkbzXlUMckTLPPLjXxb9VljZ7EnD2vO7ktFoVuvw1EKMu4Hd2HBDMHW90nL24J6gAISHglWkXwHMaZQvJ4kIbaoPIKw8bcFEGRrISHveTuj34rpb7GLI6uM75KQxJYaam+5BcYs/aomd/S606rzOhQPPXqDpjCkTkMrtrPar6vyPaS4qQ5qWiCAs+UE/N+Wf6/5NwG2Lt8247zrLBOJb5xATgfzI1RvEPIreMhA5FKoJnFa1X+6ivSIvZv/BuNY+Us+cCgif8h7tAp29pixODv14ybC7P6Xs1asYIG9pKO//hIPsB50JbdHzUp6kG92OYB2uerXlQUuafTbXUHyE9qy97iyvhcc7W5kREp7Evw7eiORhs5+bOD7WTCOHeyfQw2hbk0QBK+0orsliTLP26ebo+ZKh7ZCLjjS1J+9kPcV0gUvOD5gE6KPMMYED04yXS/ACYi9ZZs9TkwTo6YQU7/DB4uGt3En4MVEPTIYK6+bdgT94aOVu4H45SNeBVOC5bIC3xdTJYmMZ+JG99HSiOUcP2LvXKIGuvgg/A+JrDmx78X2LFz6ulxKlfMM7V5uamhYPB4DLSF1Krn/bCB+7+i9tVfkIpkaGFWnqIE7IhYiawkzgj8+/H/MTyqaqE6CrliXmvqmHG7y15IW6Qa6/VU3buvAmTHWZ8F3iI4+BDbNvyXhBkqjRtbLxX4NQGuUsZAtUj6DsOFvWf8VD9S2HRoG6bX2LSzWIYmEwHfk0ch0lFnWVgeO08PiqbRS0+p/dNPtE5+7ecYL71L5Jw1ATU2yAWW9xDqXSVNXnJgBzYKaxGkIxJcQAxxE9KvLkkK73Ae3z6h8f3v20EwDpcZbI1lTdQFyCpyJEv2zKBq8n2wZH3cMNMDXlDc2k8FbusmBI8ixb8E6ePQUqabyw4Hgh4G9aa4wabuVR6ucRt8Yxp7aszzhcWObpIGSTfm5FBT+B9UntsrOVD+IIJBh9kCiHKxpEKtfFr/aTgBQoU=',X'30c0ebd40a2f9e76debaebb1d37267f58daaf445d790db8444b3dbf957c9cfd36dc0b953fabc728fdfb3c97fa0f0f34c56f490ec2dd7062eea3ab4297919f3b7227a1c63aaa515ea6b7efd336c54ed0fcc1383b9be0e8f2e7b70c101309dab47f2063ccf0fa1f8fd05ebb8764f89bdbbb6d4def3d57f9b494b9fd4031b5b23bbade8d53e04986af2bdcde5ff43baa4d5f8d173ca7f7a3a65fde1f4de5aab41ac559db33846fc1615abf6138a6e45d456f01d002b9ef8680c4d3c6ca8f992b392eda8cb19060e745954ca0c89e94ac3dfef67a437801a35583eeeea3cc645d9e682aed8372c7ad786483ba0e593ce474abaf35f47f5274f8404d8e3cbaae2220d',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('5C87BFA7DBD88076A01ACB2C4ABA12EE','C52',1,1,'1RrNrwJcHXJ13Zl+7vrFOF8R/7TyFZkF3cPM4umIDEv7LqJv9zSb3ydCMjvra2CuCW974E++DsvXoO0Y1OyuOfsp2buxGEC2zCumNYhniKuL/EidQjLeLTIaOaWYfxr3bZIyIAuRGOCUutQ+jwhmcWMLO3ld9ntreVUtviXcLqsxxiBioIrttvnPT7RdBsp1+sSiljzkKoFkMTG/hBdzqU6UVtlCxq1MFjRH0RPgevo6nyVv8xEg42Y9eoaW4G/sxt/w4WJcUxiUj2sPiZqhjmewQmBfUH290GBIMAg4LU+2QMQMFvZtB/6+a/fhv1qc+8GyqsqZpH6kamDQ0kO8uLmLRrepBVthRh7pc/VDojTAnJ9dbS18DU5deXtwa5e5przlvQZ0dJdpBWwISAYvQ//h+u7NIanm8QNyPev1KJTWTwrM+lNiyVfrQk9sOTdC/6I/mMVOCm5mo7VSRnYNkNLaz2V0D3UCUo5/3FtPXlKt9xOmamyShHExvhwWTMbq2nyTkOgZFkIvVCNe7X5tb4h7rl1riB7QbyRoegjn3cZdRSmrbO4sqU5vn+QA+l/2MolDm3DTT99w+Hs1Qg48fJDubawkSUgq8V0XEykU+ERH7xNuysPvmYo4sdD3lF7q3pmu/HWNDDaL8dq/NOOP8ADPg5pJjLHcl2WtG/60yzE4373qgnetTphF6wifVM/4pGcbbB2EWq/kE0oIZOInnBtNxXrCoBa9R6j3ieBWbqD2M2eKQHMW8MxOqG92C8MsVw1uAIl6yyYgtaECNiqYsqyVQKDBxNBOft/2v/9ewn0RPcR5YCf+QDM+eAg8dzpZOY+OK/dIcQxqa7d5dLEq0DEBGfGihliGWqKrMGx3R7sILZGxMdz5uJfdfcTuFC2dORJAv48wPhwF70Ausvq587cRqHIwbnoL5C442Z/3iqc8DIy1uaOTeqm8RaZf10GUmQFL5AZyWKJR//c9oaZFzBq5yBy67hETZNMWiWr9Lg5lT3X0AqdNuhJd80qoWCSNEN/tpp6TX1MsJyCulkQCTpJ3FAjSIds5284QbG8EBzByqkO7W2JSTZGNgGnrGz+ZTxp5hdJmAfsJ9lQ4He6DygD6Umaqkh5cZAcbArfyofn0q3xHSHXzoQkLByAeLb68F052eF/2XBuFn7vJTcJsUj9+4wjf46SzFyPA88o5fB42XjdfYaQrIAe7u/aLD8bZF09/6XARfsbFPD/Mtow6yx6fbl2F7I2qwmPNIOxQKNV2j3/1YpSsFpq9FAR8ZDfyzQZQjmZzA3M/8of4kKpTS5LZJaeqD2TQ429PoXdFK3Z6mKDCMET1zo/mp7Bj53LlR27K6CFxssacziEoPOxR6c7JzWTge3O8rXebgsZ2exu7oNP2OivLJiJZc/YB8AXwwgc1sVRbBg4hfECtWrsX4jEqG1R4gMw2OcWTzUpJ0daRLRdrAhGrdsz6Y69974VTZ5iBXNv/4+4KOqbtpdi0QVOn3GskmBQMVpUw9+qdNzXIwJPTZSNcIvU5X40ODVvPdD7SBi2/8hH3lYXbvKz74s0p4mJqv5xp76+1Q8S42noPG9qUXEDyYGLCBiYXLJeuVgfbrf+z9mufkR5ZhWHu+pomLJPtvbdCxg2gfH+qYQ4=',X'49b590a11cb561e564aca4520464981f56be6dd7f3b30f026c745994ef220745ec85ff92c01b7f7e032484149a24db084d14d6cde153148ba61be617c9f0f71a679fa300bf4eacd4c15fabf077716f2ec509dc7ccc2a5cf4881386040adee8833a054a0ebc6e4bdaed7a97a49b1c847e94e62a91a56c7a65a25e45312cdace955fa7f6dd8424f88ce3903a151529d7c0b77147b9ffdef15dd36ff816128444cbc933c9c235bbc76a11f9674cfe83fd100b4c3d188cd81877feca5aeca48c3095312214caa4b2ce8f001ef7849161f9b270a60ae6de10d780ef359454e10b9abaee9c0f22f63747cd8b44bd704092dae68133d966495621d0183e88d2e70c2cea',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'f06dd8e6f12547ac8f008d0fd3497ac0','10',1,0,1,'Z55SCM9WE71DE68B50D6BG9ZVZ2YRS0XMKD85BQJGT96BPJP4FVG','payto://iban/SANDBOXX/DE220640?receiver-name=Exchange+Company',9);
INSERT INTO TalerWithdrawals VALUES(2,X'13508bc5433641c6aed9950fd7b0ebb3','18',1,0,1,'A8F8T8CG5GAKY26V9S5SFV7PPC8W6E94HNR9QHX3CQPYPFQ8T71G','payto://iban/SANDBOXX/DE220640?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$hgP+OW9QXCs=$vN+H8wPB53ArqAguT0AjXa7WPxSrFmpEE2Pz6+3Tf7w=','Forty Two');
INSERT INTO DemobankCustomers VALUES(2,'fortythree','sha256-salted$8kjzrYPir28=$NIB68WjWq3YiBJk8tlcv0xgniSWZeS8zInKmuIMRn9A=','Forty Three');
INSERT INTO DemobankCustomers VALUES(3,'exchange','sha256-salted$V43kW6rWqiU=$O2/2DtBHm2ub6Qj/EPdhwWrQyNhsf7doRxYh9WupFEg=','Exchange Company');
INSERT INTO DemobankCustomers VALUES(4,'tor','sha256-salted$PBIT4WRsSnw=$JnMR40ebU5Meg3N1YcaLPx8XH6sRdtwy4wq764oA+YY=','Tor Project');
INSERT INTO DemobankCustomers VALUES(5,'gnunet','sha256-salted$YmkvcdK04MI=$ncZ99KOoalDMjFYlEbnVBH4w3qYQEt5krcLcJR2YUns=','GNUnet');
INSERT INTO DemobankCustomers VALUES(6,'tutorial','sha256-salted$G0AE8VzZAy4=$Sjv1wX02Dvf89SitcYDF+3zpQGfCSLMbQ+XptBfDOyc=','Tutorial');
INSERT INTO DemobankCustomers VALUES(7,'survey','sha256-salted$ck5+TR3vSdo=$vmDwZz1mtxFxuQuS76Rd2gejmW2uG1ZORCABGWGMh/k=','Survey');
INSERT INTO DemobankCustomers VALUES(8,'testuser-3xq98ypb','sha256-salted$yfTafvLHH4w=$CPkNJ2/1uhvp3opvxUgSG8HX/oTDIWcBJRGpm/GwmP4=',NULL);
INSERT INTO DemobankCustomers VALUES(9,'testuser-jigtus9f','sha256-salted$mJIlr0zi7fw=$5eHwZ36UZz5u6matGEO0KWwIR3EF4Zb+J5qV+SCAX84=',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)),1660512360,1660512358);
INSERT INTO NexusScheduledTasks VALUES(2,'bank-account','exchange-nexus','exchange-history','fetch','* * *',replace('{\n "rangeType" : "latest",\n "level" : "report"\n}','\n',char(10)),1660512360,1660512358);
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$sQSnqaGP/fU=$j8jBFCN8auseMAYK8QzLD5MOyhoKwduZYg9SuQnB4e4=',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','DE220640','SANDBOXX',1,NULL,NULL,NULL,15,1);
CREATE TABLE NexusBankTransactions (id INTEGER PRIMARY KEY AUTOINCREMENT, accountTransactionId TEXT NOT NULL, bankAccount BIGINT NOT NULL, creditDebitIndicator TEXT NOT NULL, currency TEXT NOT NULL, amount TEXT NOT NULL, status VARCHAR(16) NOT NULL, updatedBy BIGINT NULL, transactionJson TEXT NOT NULL, CONSTRAINT fk_NexusBankTransactions_bankAccount_id FOREIGN KEY (bankAccount) REFERENCES NexusBankAccounts(id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_NexusBankTransactions_updatedBy_id FOREIGN KEY (updatedBy) REFERENCES NexusBankTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT);
INSERT INTO NexusBankTransactions VALUES(1,'AcctSvcrRef:8JC9LI1U',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" : "8JC9LI1U",\n "batches" : [ {\n "batchTransactions" : [ {\n "amount" : "TESTKUDOS:10",\n "creditDebitIndicator" : "CRDT",\n "details" : {\n "debtor" : {\n "name" : "Name unknown"\n },\n "debtorAccount" : {\n "iban" : "DE885272"\n },\n "debtorAgent" : {\n "bic" : "SANDBOXX"\n },\n "endToEndId" : "NOTPROVIDED",\n "paymentInformationId" : "NOTPROVIDED",\n "unstructuredRemittanceInformation" : "Z55SCM9WE71DE68B50D6BG9ZVZ2YRS0XMKD85BQJGT96BPJP4FVG"\n }\n } ]\n } ]\n}','\n',char(10)));
INSERT INTO NexusBankTransactions VALUES(2,'AcctSvcrRef:GWIOE002',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" : "GWIOE002",\n "batches" : [ {\n "batchTransactions" : [ {\n "amount" : "TESTKUDOS:18",\n "creditDebitIndicator" : "CRDT",\n "details" : {\n "debtor" : {\n "name" : "Name unknown"\n },\n "debtorAccount" : {\n "iban" : "DE531343"\n },\n "debtorAgent" : {\n "bic" : "SANDBOXX"\n },\n "endToEndId" : "NOTPROVIDED",\n "paymentInformationId" : "NOTPROVIDED",\n "unstructuredRemittanceInformation" : "A8F8T8CG5GAKY26V9S5SFV7PPC8W6E94HNR9QHX3CQPYPFQ8T71G"\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'308204be020100300d06092a864886f70d0101010500048204a8308204a40201000282010100cf308ea640782ffb4f742da3e19db493cf11ef1ccab2f42ea9bda101c5a3d67e2d2c289a3153cb0201d867da61bfab494366a5ef7172c72beb9c97a1300f0730b5a8b931e9ac1df85033eb87ce68c41756e94528f48b7e7d2eb6b685340bd1d053665871f31f032cc786cc1323d5e952c3a7e9037678bf19cd36d8dbbd88bd2de1982ae3a14b13595c20fff56c937c6fd00e2e484b7fb6b7747313bf1faa5e4aa2e4b905b08b4cc1e61cfaea82309c48d205236c356644b009b52808de55738286f70d2cd8e8fab1c6c730a43d4900a0f84f79225c3fd4fb8bb4c23a3fdec3d93c54f7c2e5dfe5e9b56595694411b4f2016660fa2ead5376f4cb8e6f0fbc665b0203010001028201004cc4c6264dbefab0587948abef5dfad9c5a0f4832b8bf134150ac14ca1c99a213865a349b6bb407e26e6e35c2459db8292e9c6d418aa19a8696da5354154602aa934b2220f5e09e0c6fee5e77510968fbb5145a1ee327d94aea95ea9ae662ec0cd161ff160cefde32aaf049096f79cb360f1a741f434bb42392a7861bb319e3e65991b796272aae2f5f55a04ee89c50d6113833f6e148aea4de7017835672b5020bd92e6a3b6aee789a0d349ecf34d8c5feb85f7bf02451d14c55bc56ffac6a8b3e8e2ea750e710816ac7aae07ecfbd58c7cab66a1898e486581ed1e2125913cc310d417ba0452497bec27ef9d2c87766e1e3e0f383ac31f70f105eb31e0aa3902818100f9fb6e9a06b41a2b41f8bb628b34bbd0099c01949b163965af0a3b746298a32c3d27876f1daafeac39a86df1d5591f2554a30d78b7c615faa8136a7adb54bfd303a5b26672603eb1050b7374c25f8da846ae691aa80bf814a1ecffcab46edcab86261abc280288d48096ad812b531ffcfc954059c02baaf60f453b5f5244fa7d02818100d42d684ffe4c7cf3f10f55deea9e71705d673255069e004482c1ec828a635fb953c9de909c5f17662e148ad57b757e0c75d8b03c53fe68a2933536341ea47de206a33fdb53cfdcdb9e815f6ffe32195864db8004b332f7fc5e7dc6f7e58e6dfd9ff1690b461248741886e1cb637fb0a44a35cb65bd44c30955c65982d7fb63b702818100c24fbcb3214ed1a09a513b66e809ff8b404cf1b58faf80c217837e9f831c5e89bea78150cfe0e0c102b8776da986f2fcd38342af793a124f9a622d3c7e4cac26dc08ea5953c298388551575784d73d877619903d562ea791722484d80dd4b6d6e519ad62603f4818d633497ec42c830ae55326881d2654679b8b17118b236f0902818070c274f656323611ba61a9041ff1f65d7df61304a6d09f59c997dfe67c3f55a6fb4584379c32d90f9f9ba130d53cdab12a8bef15109a5ae7538e6af105fbeb3e8cc283743f356fad73ae5397042381debd32fdf5017b2bd97e2a1fecac9da60cacccb243a088a4e2b60a30c3536c8fe6afdda8ebb7cb6c4f70bb49e4c47dc03f02818100ada476716b5c37ab7f55e8e25ea674ab235c8dac60f83d13fcbbfa71dbb6c694b06746286976f0c36d32d14a122cdd7e3dc0993eb905d679ab8f23c34f364165ce715e714284f2039aca476efce636337b8d56d634af3be9ce7e8592592fc0eef9a27fc123923c5355a2e3fe644de809ece28bbeb912068a461db2cac82eb318',X'308204be020100300d06092a864886f70d0101010500048204a8308204a40201000282010100a785b43f454fc1ca3a49dd07e45ede0bdf633381683a798285367b5d6a5aca1572cdca85d2e0c4030504cbfdec216db0322e9c72010c4773dab7741e48ae1b79eb423ba25a55d29bccbc07af0de7979bd83c1e43249bc9128a330c4966b4a38ac46f227542c51be4a66526eb2269b47e272237e6e6636b8898f21c1d0c20d7d79603549f67d572e9a1c8f7eb297a2ab904f33eb74ca9c37e79f96fcb5f9fd40fd0e413d97aaf3370cc19c63c330fc6bbd066ae5fa3d17c7f64676e7bc440f52cb0e8994503c71a0a719e694b8133535572656d4cdb2b742b278beb1db43b0c58c6334d2fb48df28b5510364775bdf86137547337a68e25770fffd27f46af86f90203010001028201010087729ebb6d924030ff920b49bf474927b655e226269ce8f4343b49e1cd055d519c42721663dbe20043058ede5f16e4364b4ccea78adb5fc677b84f05d1641cc92603a66dedb668941a2489ddeb532e8d0e78054bea849f3e0349a50c90234bfbfe399155d847c0f6cde70961a2b06f047525c0a74bee64dacc372dadfac96f5a07236219e029db487fd16f415359db0e6c7dacb4fff8d362264ea4df02ad62856f744ee1045a014e3d106069c45307502f39b8e475892fa0ac5e9897fd032c8d26c3cade3473920a59112f093a31a416e5359b7f6b5e645e7eebbe20e8f124b1dd7c621f2a0cf6b2bfe82fb791814a8b37e4be3bb624bad322652f091001ae0102818100f7c590d605f47b57bf866a64d2102907e52dee26bc32bf5d34de7b6c27f0df56b63c1792fff2dc1e6a55742a2c13695f6f26e8d34318f65c6f12b9ad6ee13726a70614bb9e43e0c5d3f36d932c2754f578352abb081d40623085414e71648a97823b293b68e09e23d498e0c54cd2d9aa865730426c94a5e210afa8130aa803b902818100ad15e58a7a9c66909433e643e7a249bbb75d0850d8e796047f325001beed06b0ee0bd47fa06157a9e46ee22cac2e01c6621e82234ae17536aca76a9c4db73cbd4509c857ad5cf7cbce7d465ea0238175004ea51299b9820812ca2bf6adadf0ebad7b37a73a4509001dc16c123fc19389fef34f0627340afb5c0a9f9b62ffbd410281800b6cd2c6ebb36054a5823f39b2ee07d6535d10d43c6d62a19ba47eb0780f055d6c3dcd207c28e8b98651b66f9364b9c12ad0f27f7b629549a1dd8d2e5024967473d335f588d0bc76a2d560c21e9119bbcff533a93830911d75fb4f0d9cf0f3eb149841c87987920338f46bb8ed57f3ad875051eb5e32648bce152b7ce54ae6110281807532295d6d8deee8a060cfde54be0f3cda7854c4214a15caefb14a791424fbeddb11098e6d32dc1fbdfbd28b3afe5fd74ae2ab6d682b66a961986e586d4ad006bbf356c2ff30bedc31f1a32f3931315bde9c61ab49895161540fae5af5d89c138840b13b3afa3990e994e92f261a55630fcd014a024b7bd01ccf58a8e70c90c1028181009c45f1bd801a612832b4db36d18e8454e7b401483ffe16a5b0f493abbbbbb7be70a56e6631bd619479c50bd3d69f6fbb0aa0c03e183b875aafdd0f3197caac50afe4b57d5d182a759f431bb058205bb872df3b6c6ad74d6360e4c614825db69494c73b2426d98eb72b8238ecd58f33709bd8f087ebe7f458bc39765cedb168ce',X'308204bd020100300d06092a864886f70d0101010500048204a7308204a302010002820101008d239e0a3e7955253ba93d26948aea160851f26aec85846e8184143cb4b79214a84bddd3b9fc5874b90c201efe1f6f812168e860e42139863113377bbb54a755cb4940ce2daa93b81021c0f31410fecb25ce9ebd4b265e72849ec33243718fd448e647c8ecf36664b9edb349095420da2bf889e9c2c65f9b2c27d2badb6d56b0a74ad4eeaf8c41ba9f63a2070c491b7ed2706969b95340438577888786781e53ac00cade46322625a4a3be688c6d5551aae259233ba7fd7ed64bfe8eddd7f96ccfd7e2d0a0fc0cd88e6f63bf42ba3a5836c2abd71d7bdb6e9a4d1d9b8a8a8f048782e482f75b67541554e7811f84cc5302896ed6a78aec9c967c57b3aa22745d0203010001028201005bb7758ffaa1262f97e1969767980e1e5b31c572ae58e5825a2fd666cc992e18b674f6a60c0a6c010def4f4054ab60ee6d239b3ebb80cbbce44f3492f75d3f9085160942f27212a45df75147a516963cb548dbe6eedaf42d3ef95ca761247eeed8a0acad692d92b08a12699b60b086d8c01236aceda1b3a746be6a367b394647763b96d2a561a34c4e23dba9d936b92dce9c6552b79c605a6550c110a2c42599aecaa4fc5dbeb46b85f7b9b87ebb0c37ac54ebe2c13de74d1c86f800cee6cc26259621a1495203013f54ab7d6425555148f48da09beb531d2bf7753eaa0c3d1a859118740aadc15faafdbdd57d848a6eab2daea507c3b2a821113430708d630102818100c943ea125c1dedf8ead3e44f441e8eeea39486895ef6cb1ba869adca473a85775868c044afa9a3a0ea1ca08c7adebbea4ff262a55ed95c6ada141c403abf3e1e5f5cce4aef82b4d5b74bbaefa5fb678aa1a12b34e1d3395950bd74f524775e83965622493df64c4a887962c32dd5fc28f08638eb605189c3ddcf5caba924b1f102818100b385b88be5797acb0077ed25a8c2c88cf65d94ee13a0d0de40f6a32a18c3d59c13e604bd348ee482808fb9f44124bd05653361c15f4ab1d7c77d1495d09d69fb98a215b43388b4c7510e7bc378dad9b0237c7ea7b4b2c2f90a70e618346e15074927c4f5af17d9d20dc02cd72ba43be34008022ef2d2fda51fb8c1380414fd2d0281801249b484349097a60d98715f6e7e2458b4ce73271a54ec81b7dcda68cdee18608eccfde37fdeb73a90eb46ff5ccece5e6d23462966a3f38cd6020bcb1e4b70568c2dbfa4f97c73f8136eb32ec17345a648277fe88f388536836aa3acfec245f948f8cca6c115973b12898d1ad518639048c2b97b51c636f1703f3e596ec621d10281806b6c28f20d6e93bbc59bfd9bfb501311c69a58f3dd6aed9110ee84d43bdd7384e1a35252a5909bcc3b81c594132718b491ca1d44c8f0b95a9554936cd2585f82dde29f7a251c3890cc400e6ef9727bb09a8b747e85f2321933d63ad961063e2f0de76e445571c035a164cd7033fd2298e947e18696670ac0342b29f38afdc44102818100a65ef84709c0637b614ca18890ebca912e656d5bdd21e2438ba6b463b38072cc234c3777d7043c44e9d1facbd09f95cebe70409f3b0c741a1b22ef700da5665c1f73bc3dc4cd6e95b165fe189d32b1f157aff866da72ba63b13846c4feb927af27ef6b7a924cc5904ceef309eed2f64122999edb37d10278524023d06445d2d7',X'30820122300d06092a864886f70d01010105000382010f003082010a028201010090d77df92dc97cc97f3019fdb89723808e1d14f8a06a8245184d6d7f6d2e642b55d77fcb43222266bfb8bd4ca5a876b63d54508b9b55539758249ce10ab07a491375cb03b0d78b07377490366cec7025eeef0cb9d222a4561d3631fc84c42ef233280e2e9e86a6e7246db9b8734729bd9e20921fa20975b4ae65929fccb3161b5618dd44b7a7c9357654b4955dffcd304df50adbb32d97e4a9d11e1ff8d9ce5983a41073770d7ad72ee7b2e27b33784c47b559d427a673f7eb2a04731ad397e6d3d686de1af792942b12cc424fae7ee721fce150f68aa5e5b3cb624c494644abcc5878af2b4e57c43d51f328c60b67ce0deaaf13760a5198e64620632a95056b0203010001',X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100dc12ce72628575fbb898a049683327be70599672cadd81f89b91fb739d78081e5697f0ed4f3a75418849066a2394f670861d7f457268ac8bb5f9b67ae980f1a1bee7db4c26eb8cc6db44036decec64f49524abf6bd7892f804366312e9ac220c354caf92067137dc05357f3805d0a7b3839fd2b6df7871417501b14aa23c2f7a93014745ad3c7064777d3ce0acdd96d5b4cfdb50ed4f17414322de9192fab73f47311fdf9bb11bc0b0c53f987399d40a0b17f45d9a9b52250cd9a608a54f7ed6c7ab5a3a80c899822548dfab58157a58c28d16b6d6bf9fdde455107ca9b20fd18cb3c3bdbcf577b43bf61cb6dac0f0fcb1c87afb9f6d3ead472a8d09cdfb35490203010001',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,'Z55SCM9WE71DE68B50D6BG9ZVZ2YRS0XMKD85BQJGT96BPJP4FVG',1660512341223,'payto://iban/SANDBOXX/DE885272?receiver-name=Name+unknown');
INSERT INTO TalerIncomingPayments VALUES(2,2,'A8F8T8CG5GAKY26V9S5SFV7PPC8W6E94HNR9QHX3CQPYPFQ8T71G',1660512347822,'payto://iban/SANDBOXX/DE531343?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-1660512327478','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323332373437383c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a32372e3437383432395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a32372e3437383432395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(2,1,'sandbox-1660512329824','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323332393832343c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a32392e38323439345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a32392e38323439345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(3,1,'sandbox-1660512332053','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323333323035333c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a33322e3035333930325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a33322e3035333930325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(4,1,'sandbox-1660512334280','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323333343238303c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a33342e3238303339355a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a33342e3238303339355a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(5,1,'sandbox-1660512336538','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323333363533383c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a33362e3533383232325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a33362e3533383232325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(6,1,'sandbox-1660512338740','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323333383734303c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a33382e3734303432335a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a33382e3734303432335a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(7,1,'sandbox-1660512340937','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323334303933373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a34302e3933373135365a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a34302e3933373135365a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e384a43394c4931553c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453838353237323c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e5a353553434d39574537314445363842353044364247395a565a3259525330584d4b44383542514a4754393642504a50344656473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(8,1,'sandbox-1660512343295','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323334333239353c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a34332e3239353139325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a34332e3239353139325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e384a43394c4931553c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453838353237323c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e5a353553434d39574537314445363842353044364247395a565a3259525330584d4b44383542514a4754393642504a50344656473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(9,1,'sandbox-1660512345475','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323334353437353c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a34352e3437353533355a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a34352e3437353533355a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e384a43394c4931553c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453838353237323c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e5a353553434d39574537314445363842353044364247395a565a3259525330584d4b44383542514a4754393642504a50344656473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(10,1,'sandbox-1660512347672','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323334373637323c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a34372e3637323237395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a34372e3637323237395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e384a43394c4931553c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453838353237323c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e5a353553434d39574537314445363842353044364247395a565a3259525330584d4b44383542514a4754393642504a50344656473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4757494f453030323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453533313334333c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e41384638543843473547414b5932365639533553465637505043385736453934484e5239514858334351505950465138543731473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(11,1,'sandbox-1660512349887','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323334393838373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a34392e3838373432385a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a34392e3838373432385a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e384a43394c4931553c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453838353237323c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e5a353553434d39574537314445363842353044364247395a565a3259525330584d4b44383542514a4754393642504a50344656473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4757494f453030323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453533313334333c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e41384638543843473547414b5932365639533553465637505043385736453934484e5239514858334351505950465138543731473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(12,1,'sandbox-1660512352058','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323335323035383c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a35322e3035383338325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a35322e3035383338325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e384a43394c4931553c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453838353237323c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e5a353553434d39574537314445363842353044364247395a565a3259525330584d4b44383542514a4754393642504a50344656473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4757494f453030323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453533313334333c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e41384638543843473547414b5932365639533553465637505043385736453934484e5239514858334351505950465138543731473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(13,1,'sandbox-1660512354227','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323335343232373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a35342e3232373330345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a35342e3232373330345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e384a43394c4931553c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453838353237323c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e5a353553434d39574537314445363842353044364247395a565a3259525330584d4b44383542514a4754393642504a50344656473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4757494f453030323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453533313334333c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e41384638543843473547414b5932365639533553465637505043385736453934484e5239514858334351505950465138543731473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(14,1,'sandbox-1660512356397','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323335363339373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a35362e3339373431335a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a35362e3339373431335a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e384a43394c4931553c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453838353237323c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e5a353553434d39574537314445363842353044364247395a565a3259525330584d4b44383542514a4754393642504a50344656473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4757494f453030323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453533313334333c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e41384638543843473547414b5932365639533553465637505043385736453934484e5239514858334351505950465138543731473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(15,1,'sandbox-1660512358558','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303531323335383535383c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a35382e3535383539395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345432313a32353a35382e3535383539395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453232303634303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e384a43394c4931553c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453838353237323c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e5a353553434d39574537314445363842353044364247395a565a3259525330584d4b44383542514a4754393642504a50344656473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e4757494f453030323c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453533313334333c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e41384638543843473547414b5932365639533553465637505043385736453934484e5239514858334351505950465138543731473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',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,'DE220640','SANDBOXX','Account Holder',1);
CREATE TABLE NexusPermissions (id INTEGER PRIMARY KEY AUTOINCREMENT, resourceType TEXT NOT NULL, resourceId TEXT NOT NULL, subjectType TEXT NOT NULL, subjectName TEXT NOT NULL, permissionName TEXT NOT NULL);
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('DemobankConfigs',1);
INSERT INTO sqlite_sequence VALUES('BankAccounts',10);
INSERT INTO sqlite_sequence VALUES('DemobankCustomers',9);
INSERT INTO sqlite_sequence VALUES('EbicsHosts',1);
INSERT INTO sqlite_sequence VALUES('EbicsSubscribers',1);
INSERT INTO sqlite_sequence VALUES('NexusUsers',1);
INSERT INTO sqlite_sequence VALUES('NexusBankConnections',1);
INSERT INTO sqlite_sequence VALUES('NexusEbicsSubscribers',1);
INSERT INTO sqlite_sequence VALUES('EbicsSubscriberPublicKeys',3);
INSERT INTO sqlite_sequence VALUES('OfferedBankAccounts',1);
INSERT INTO sqlite_sequence VALUES('NexusBankAccounts',1);
INSERT INTO sqlite_sequence VALUES('NexusScheduledTasks',2);
INSERT INTO sqlite_sequence VALUES('Facades',1);
INSERT INTO sqlite_sequence VALUES('FacadeState',1);
INSERT INTO sqlite_sequence VALUES('NexusBankMessages',15);
INSERT INTO sqlite_sequence VALUES('TalerWithdrawals',2);
INSERT INTO sqlite_sequence VALUES('BankAccountTransactions',4);
INSERT INTO sqlite_sequence VALUES('BankAccountFreshTransactions',4);
INSERT INTO sqlite_sequence VALUES('NexusBankTransactions',2);
INSERT INTO sqlite_sequence VALUES('TalerIncomingPayments',2);
CREATE UNIQUE INDEX accountLabelIndex ON BankAccounts (label);
CREATE UNIQUE INDEX NexusBankAccounts_bankAccountId ON NexusBankAccounts (bankAccountId);
CREATE UNIQUE INDEX Facades_facadeName ON Facades (facadeName);
CREATE UNIQUE INDEX OfferedBankAccounts_offeredAccountId_bankConnection ON OfferedBankAccounts (offeredAccountId, bankConnection);
CREATE UNIQUE INDEX NexusPermissions_resourceType_resourceId_subjectType_subjectName_permissionName ON NexusPermissions (resourceType, resourceId, subjectType, subjectName, permissionName);
COMMIT;
|
