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/DE546854?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'30820122300d06092a864886f70d01010105000382010f003082010a0282010100adebb8232ffe4ece51c1a65c374a20c6004219b8db8d1233341b41ec906ee63dad98eee2f8c38bae21ed04072b5019f2b000aca7ddb185b8a0635d9c54bd77dac31404a900609e4006af945d3016f027a8d5c05f9ed005142d4f23d4bae53fcce4e5915dd572bfcd0888c6bb4282906fd322c9114079ab00be9831a43d437be25773e0eaeb169aedc63d685f3fa5b0e20f2ff4f9a5190890749d44112488c44e8611c177743e4d6a8d8f3396af843bd3daf46a2d952070285172957514d60ec3020b93f6c462adb16cc198a797c687dc2702d659264ce4b0ae80f8f78fe1352cdd69ba4cff1ea36afa9ad9eee9478e240f2fa590410ff7118059db35077a6baf0203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(2,X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100937fbca30748f24ccfb1dde9cca6611f2c9df47546ab506176654fd858c8d0090a56c8be6af7b7681a1270172453435449c977099f881a0f0ffff68164166416cd15c7af6b977aebff6f7ca287eabed7d62c3c11089ce5315404c05c4eba61e3a354b1824bda85916db3f7a28f92767fddc2db43f02bdcd86d97aec3390263f774ed3ce828f40dddcbb5bc944b906c94ba8721f89853a8013cd06fce7f37666bdf88b759b38ba4842ed5cdd33b32964ced03149b4b6e13213a434946f4b4e4a444fd9681a61709ef013fa0f1b9d67f23278c709ac81bd9ad7a7ef410f7a1a9a818bd76119c1676cddef0296d7c069ea9cc4279cb24c7d2e3264ba7708ecef1dd0203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(3,X'30820122300d06092a864886f70d01010105000382010f003082010a028201010096f42ff3697c7a030140e705b1060365690cb42ca1763d2d6326ee7f0c8a04d8f0e0d651144df51f965864e7b32328756f92b599e3a97457f3b4c22f1e2332443c35f9145495cf581076054ff9f5e4214eef6756d410262164f67c09c502c6a98b3bc3ac36625d885a85f55c92fdb39272c5beb4e5c2ee9ede9dfcd42cf5fa1d67b5e7f3d5e7e50a4bb6d4e7242b6a5dba075ff8e90786fc06ee304cd20a728891df2e9cc006c22343dd53cc3992e6134bc566f9472451d54b595e49f737fb61a55e0269b3ecbf4789f990d8212de2774d1843047d873261ac8c1aadaf55bb6fedceb70cd35f8bd2504bd04d972b479b6bf092391d67099f8a23f070a3ebe5f10203010001',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,'DE546854','SANDBOXX','Exchange Company','DE687184','SANDBOXX','Name unknown','V1GYZXE262Q9CMW4MBYW24WJDFX4TZH9D5G9BZ0NV0YM73M80W50','10','TESTKUDOS',1660251773783,'0I6W616I',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(2,'DE546854','SANDBOXX','Exchange Company','DE687184','SANDBOXX','Name unknown','V1GYZXE262Q9CMW4MBYW24WJDFX4TZH9D5G9BZ0NV0YM73M80W50','10','TESTKUDOS',1660251773783,'0I6W616I',NULL,'DBIT',9,1);
INSERT INTO BankAccountTransactions VALUES(3,'DE546854','SANDBOXX','Exchange Company','DE871507','SANDBOXX','Name unknown','6DHWMK9VNR61HNFSWZZZKKBNN6FG9W1TA0QK4245CJWB9NVMKEB0','18','TESTKUDOS',1660251781133,'TKXY6UEK',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(4,'DE546854','SANDBOXX','Exchange Company','DE871507','SANDBOXX','Name unknown','6DHWMK9VNR61HNFSWZZZKKBNN6FG9W1TA0QK4245CJWB9NVMKEB0','18','TESTKUDOS',1660251781133,'TKXY6UEK',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,'DE048530','SANDBOXX','bank','bank',0,1,NULL);
INSERT INTO BankAccounts VALUES(2,'DE637274','SANDBOXX','fortytwo','fortytwo',0,1,NULL);
INSERT INTO BankAccounts VALUES(3,'DE899910','SANDBOXX','fortythree','fortythree',0,1,NULL);
INSERT INTO BankAccounts VALUES(4,'DE546854','SANDBOXX','exchange','exchange',0,1,3);
INSERT INTO BankAccounts VALUES(5,'DE476398','SANDBOXX','tor','tor',0,1,NULL);
INSERT INTO BankAccounts VALUES(6,'DE292745','SANDBOXX','gnunet','gnunet',0,1,NULL);
INSERT INTO BankAccounts VALUES(7,'DE274624','SANDBOXX','tutorial','tutorial',0,1,NULL);
INSERT INTO BankAccounts VALUES(8,'DE567303','SANDBOXX','survey','survey',0,1,NULL);
INSERT INTO BankAccounts VALUES(9,'DE687184','SANDBOXX','testuser-eql8x46y','testuser-eql8x46y',0,1,2);
INSERT INTO BankAccounts VALUES(10,'DE871507','SANDBOXX','testuser-qsgidrbb','testuser-qsgidrbb',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'308204be020100300d06092a864886f70d0101010500048204a8308204a402010002820101009274cc2b5c26f33cfa521bd4a9fd42df48c3e25a49583f9db525c31d5c77bfdeee727f14b5165fb4ae806f1aa0df51a02f73842e67fb22bff60552a3a9c64e1beeec561529b43f25e9755815473c2307eb4db833d6ed3494145e0accef34f642464beb9244a5d6b74779643931d1845e4929e8e69661778a9cf413d1bd3af92fca6c24f217a3a720337679f1aacb1a21fbbab1a8423a40e92ae30d579ff036f5b64da5d26d0152327ce0beac85a1d0b7384ca8b713db5c7b82332e68632d6319956cb0f84da386553efb0b1ac043e1ec77a70733be0b62d279c1f17c5a60e33ebbfb6a4ca97cadddd26e7425eae1768bb6a9466d96ee69af2c1ef3cfe34e6771020301000102820100716fa7c819db4d61389daa52c0cb9a2529ce171f4959e2043c0fa09db8464445deb8ae3792bf5ea7aad56db8d94bbf846bdc74502157c2259edfa68f7f6b4a8a963755c19488b8b49babb8eada3ef8ff244111608da332ab534f37dc5d96cefaac4a178f363ea11d5a6deab3e6235afc507cf698cb7778c8d322b5cb295f692b6756ef07b3a935576b0ddd6b15e4a2b07eea57701e56b5eea116c5fccb8a8ee1b4344da7ae152fbb0a93b1f53e84447df70ff40076c5d9aad5f10ae120e23d1b0b0059d5ba514a8ff21a96679b6c76a5e2de8291594aca34d137ffdd87add293fe446ae4622827aee945cdc4722473227a4f024ab07fc34271e3bd7a75d93b0502818100f64edef4348f0504c4bd48799d277632602552a2d4a76ff69a6902aa3bae1389dfe3fe4602673681641a8cf70d0a2955c164e1f5d63432bb181282aeb48ed5411d4bdc61184ba1e75f07a5ceeef18c072f7148abb6a65d86a37861b699c24ec7e764b7886e797848591d0bf9dcd71d25f5ca1032093f526ff56a9836ed055dcf028181009838176c9e35e6004c41a7eb79f44f2363822cc0bd7d54a3d58e98fac70b28ec0e76989d9473942896fcd9a24de9f5a167aa44c88a1f4023e11d0a62d7fe048590177c7313ebf2861bf905793ceb38966c5f7ebc2d3d07c262eb48672371ee4a5083a10680e6293a44601f7660a78011c567415c0b06c23a16c8effa8ff076bf02818100cdfc37c8d30ba88ecc59dffa94cb23b60d622931b3d6337470bdd154bc846022b5f2ddfb7e9702a64329512a6ae54c9c431833407cdb3a71ed37cdc27d8dd61a967d92d840913fdd5743f60e9115c09d61b7c3a697219aa5b6a03e578f4f48c33568ad7493af52406f0633b5ca52bc35bad039ab1ec0ae18a38d79aeb599ff51028180672ef6a9f9611de52bcc01d0fc9d609be3935554ddde3c66c697e019769d9902d3170f831a2372d644eb6777bf0b0e27784712534255c6bbcb984cf70de532197bc07feade213e082ca41452c7b9c76528575f689dddd609add642013024c5dbf85211f07fa605626b0121b2b3f8373754b216bb16fa60e4d1972a1d963ef1af02818100cd81d6bb39c32e5f52d0c14ef29dff47b94a4edcb9137f99f770460a36f82c08f7eb664d27df2ef3c69907989d744e9b6865f41733185d321ca36ef14a33cb22e04c0e293decd93b697e7837d5868314db6fe8996c45e33262cf1708e6e99235c6b106213e8fbec26d4244f41746c8d02624645a36e6f2c4ba282e0aeb98d6cd',X'308204bc020100300d06092a864886f70d0101010500048204a6308204a20201000282010100bf9f496026bdb5f879db509bbc5110a233b39b73f62646ec961226fb2375d25f89e744d7df6e259744fb8f36d70e22bad8e0a7203151813359759c028843328c5e87e8b480566ed95e56bd91b5d09503fe019b0f719db801d2cc4585f031461cc56ac9dd1dbd570fc87b8344dc578919343696a645f4ded449dbedec483b54ece29eac39fbef30aad2fd012151093fc958bdab1c34fb53acd62421cc13dfb828973f654500f43876dd1b3c622dd07d28ea7502a2f7b428a1a04cf6fd7905db893994a1af3ce6997010286cb1b04b9abe6145573913889ca15038176e7bad9ccc6eb285cd85d7f11092c39cec340f48e46287f251c9383adaeaa0f6db08096b75020301000102820100610527439599ec2e98942066199cf9cd065c63d2fcc83894c50effc99c14a5a555cf509df43472b7fa675c05aa3130086692a84bb66ccbfbd1c9a869e7d00e21e022f401a0112322cf8f1f804d0c04c6f6ae9d71de56bab9c19f477c1f36f386d1b5d5eb2c8997311892e0cdd6ba43620d7bae1f15c07baa0493640d842cf63bf0e3d6fa59f74ab787a98c71bd8520ba61d26b2d1c60059418415c1e775bae91f9a36996d80a3295ec60bb97a59f8452c10c7350254b466dd1fa17136c3a19e761d44773d0ac506061d6772bd1b9470bb435ecbbf547073241f551fa1062e2874447b8ba1d84945e0ef8b2b1f32d28242f7ee2d7ad9adb114d3769386f51750102818100f34e982fa9d4e04c6dd5649acce5de75f3ef05c480c1030ce3bd52856c42eb7392cb6d3bf15d387b28cdab9cd637e047c70cf103e0fad061ed8f7f22063409f03126c041a95d25b0a77df852b9291c0f8d961131dfb7a24f5ccf092c7c7672e0fdde6220263cb6effc5426fe1a56425c07c4852a886026580f87b98a0d281fe102818100c99e6ee024a217d794708481a0076f37721a0b7a4d39344f4b976d47f473f8e6c3246ed452e733556057cfb112b90c14ed291c86a0a0793ec8e2077fd48ab35bdec93f599bde3f635def77256b78087b2c3d97d2e106c75c33f12e1c34b836b1d195392839c439c086759ead047b82db8e62528c2d85823ba8ce7a4034108e1502818013ad2379974e73e53a6cab7a295fdda1c45c6c26fc129fe086fa64960daf4bc348f7d299aa67538e023abfca2b38d1967c6e7b7f48ce7fd3ab96933d792af432cc86c9bd85a8d6c776842574eb2c7bec7612d0c92bc27a09d903954657ba6c87ed7ff2878f1011eb4e88afae950aaccb2c85a40f50801619c107c4e57932e9810281801de1964b3002ba07e05f20b45974609e5611d81ba33054396059abff9b124914625d96f36eea0728a323c08b5cdc021763e2d0f07f03e9944d8f7a4f0ec013bf0cf0c4abd237092bfff30ab4880dfd2bcc2dc0bfa74c2ae5d668eb4d90deb074803c5e8140b67d5cb450e058822e90015c43e43a14511231275e9aadc349a4d5028180436738701be9d8cebfa486382c77e17d367ddce2313bf6e89f24b5ea070e647a0300b22ffc062ca3cb7e74a4fc4dadba68f69183cc6eb512cc8d9239135c3f91c8325d488eb12cfbbfb59f37bb5398c45cf4bfe725f161a28297d900d0295a829ac910569b146fd080321ff431375649eca535e9fe49aab3fd77511025c6e316',X'308204bc020100300d06092a864886f70d0101010500048204a6308204a202010002820101008c902f9333ebc3535389a793d6224f1c8882955ada65fd516e2fda399227a7f45f7bc50854939c0a00ad06774ad44f69fd4709d002655381607b69487a57763d5539a603f3a5c9577f1c1872e13f1e6c4305b4e1aa4b7fc77b97cea20f4e85771ba30f50a1b6a0fb50683360168d7fdca2900fe7cbe5f593ba14f63834a173ae2857255674934c5523eb361adc143c391c7ac7190627407a9f5ec1044db1fa29c921465a5a9e75f1852b89414e7972e8eeb5ff26ad1f5e6de7c9fe64acb98ee162c72bf85804a3847f0467083c99916ac4d0d7b78f4602be0325274f43f3dffc84e02fa76b99575bb1ddf4fb7d8c2123eb314086e690019e61770b8dff1c64ab02030100010282010027f51cf1158361c5202c336cfd2447a4eed1602fb181e89eeb59c3093698fb4fa68d0297b9a3346a4b82e421a92ded5d4dd891db85b2d428250b3004a07298741af406537d419598bfd376c7c16c35f3c4a1aca7b1c7408dae7e9b08ca9d21a7983da42ee1a98edda21fdceae5be57a89ab5a52fd970877cf51adc5b61eabb7d4c7049408887e27da997c5be2551f91cb52948583dc434b56da169e9e0e090087019bfbb92ec4be04e998636361f5a4b72b7547e272da3a6c8e84e2940bc00ef99ea5a8e9217b3093f18d5585d4a3dcb5183dfe3ed175d0de557a7e362155956e002c87d4bb2970b62e0c5d4f270bcacfe02b366d432056de9615f7172ffb28102818100cb8c5def3c765e0b19d089cdc5105b22cdb20bcaee46520cb81d5309e1df6afee654ad1b2cd53da8303337c82d9580dd16a7ef27843ba374ea494684509d34a9c16c58fb151b32cd00a2dca7c62841071e3b962def2f0f539c2970d365ca683df27b3a3baaf62faceba86217cbbd7e4324f5e8c6e49de7795e8fd114f2d3a98b02818100b0c8d4f7e3ed9e8a832c30460324c519bd439cea77ad3aeb14eb86809b8dbafd0b0effaeff1144a53316192336a29614213af3ce8526bfb8a559ecfa90dc285e8fb62b7164cb4dcd09c57d0f0cf4cd9b17af5150b914c00f982ee55ad58cc528e2203ed362fa74f6c794ca8499e6d541dc5c071155822bbbfd477604289a5561028180325163d34546199f72e53b7bb3b0846709246f87ddf9624524aa93218945dac4629a2224eaa35857a07ab8da727257e5cfb8fa04f1ca7070f18de5b1c5dfe6e9e417edb33c177a2a7572cd4b6850012b4a4cfea6224fa6e14b646f30c324133ae51b935cb6b99f3587181c0fb7dd033e83ff8a68c891446c9b74c00206b94e5b02818051caf9ce1fa4e73f8ae53d088797d1a1d111a15e5234d217c63c1aa5125386fa60cd75bb0fc47b903b8cb3e0b8fc8c978fb068f15a65cd3aaf366610a0495c5c33fdc327d9ccbe986936f85fa84cf37c187f430e2833d390e3867f1381ce79c22aad64a4051d8054558f200c2df0c12691bffa7d28a4eb7b34fa853df35344c10281802f0dc2ac1feabf84fc80ff064d4f5b216cfc642c35703068307f984c4682cf33885f8339973faa48a0ee75cd4601edf4aa4190ef0a78cab6802ffbbaa88e4eebd90f23bed7ec87d12043aee4150aa44309de4ecad900665781420bda250558feeb285f5cad6a2042e208b2de4592514cb82ca681e13001bba51940b41841e88e');
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('2231AFE5232A661E4105EC13CFA96265','HTD',1,1,'QSAzo5xnz/01iix0AmCJK+myzTETNW0ZBBbN5N9auIQecR5daQ20wn0gkqLhMnuTAZRr1GAP0/GM6qB84Oe+SlXdEy8J8UFmUHBOQEZcsIxffRblmHhdjxrQj9mMzRyTyliHPbO7+1K1sHTTtxSg4iI+zIp59HQL8Ug8oImxEZL2TCQjI77BH+yZ37rxztK5+vHmbVwM/8ExJco9oRmdRjWzv4JveVJktxGbH1FzuiTiby/OPZ0xs9AmRSp3vOt7unhOrGiYemZg3X4usYtGuXIUKsxAjgAOP0kw4nxr34JTRORFDDKnvVrxZX6hXWKi//cD0QQgfTffP064Nh0TB59qQR/hPi06zMdnng2uqO0947bZW4SLww1h/mrI02ZtiAzZJrRFuRu3GFq473q0JwntdwuQ8AV3Lu2p5jRBraw2G+OlbdkA0ZqCv8opH9H43fdTqe8AaRqdjOisOEnwQVcsC7/ClIRzH3kIvjGbaQifPin9DjKFy8+OyQrxkaYhZ7gf/AH9cU4iqdvqcZdEOgNYns3v39ZiQpppvvyyrInJcGzfROqxGA4cRLe82esHWyv3DP3ui1oHsZcfIc1nRAbZmXly8xiUsnEX4UKE687zhwgvGBWE2XfJ74qv3qCCHNt3kaa9Qhvn9fWHzgGbbpZS/v0NBq8nL/ps68UroWOgDkZ+LH0PJkKJKWf4CN+le3HidTyRqXOccCX0/zwgnA==',X'3c97d5504fe1459e6cc16eb97749a3ee1d117a2a4966a70f486cc5301305e4e50d8ae10bcb66daef611a15614953584cadc6421c612663adba88da68837e0e0d295d9f859cda6feff4673d139da15de7b712f2add2327aaf757fc64a2d7c51e5d8d8180106f6e632a8566b85a9938b987de10c29448ccaff248c15f9e487743760163717b56ec99650f6a5317cff2e14c3e0033ed584d03fa877316b125b83dabd4c164b2e4a605ba6617ec11e9a1722bbe64355852a6cb9ee3d816886fb525c8bfd789355e6a2a03b4303ab7752dac52f2dafac84d4266ae2aa66b63f055dc70cf0a98aa45a1924a32a4bb3e6adb14eb30ad2ebc04fc722d5eb8283ed5f07ce',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('1FEF0E8F67D82254AD05D1F7961149C8','C52',1,1,'TCoZrEfB6J61DkOIguRh5mnDKpUMVreNSfECcB/9y0qnlhf6vHCZZGSviqlYawcNe7kTsM0G9rEjlxisZwXDWBgC279OkpJ3vQlttEfl4MV1FOYpKm7V0gIDX10c4OCEPxLAmXPv7vtEWfunrViSJHGkbIYpB1Z+l+o7aXSfMgDVd/y8952/iVuzu/flb6WExS3CT+k3wT8l4hwPl4TkoNDsbJQgmsMXAgCYOq0Tpz45/YOmci22gazixkCBv57pq554+wCS+Rm/nR9zgpUd1ktSns+a1JhXHc8UvPJRxfLJ1hP2E/v7l4H2yjQ4ByPTdaepFcFw71AWu4C8zV+7zjJE6ykzwNPv4mc1rU5Y8opWbpRjl3HQSAngmgeWshP4+6dKMs89GNGjuTwsrKDZpqfa0pUweX6Q9uFTR9uSMUfhju2dFzwGxnOBn0JNQkK3i4WPl/puSkxq++UA8SBNTcsSoCZlRuWp+2kKqh3k6jaIlctnqKab40h7cvhedyiHu/bkw4hY+/HTlNb1ahUSF3VN9h9JxVwOjD5m3N72Rcu2w56p+uj3PznCkcxBKCfPQb6zL3UiFcJjn7lHuYyABSWSoCreUxebqKmm8uuX2dbI+FzyjtALshRYn0QxB06XyVLbusnQrOO8JF6aD9BzP5QcSoDSPEfY9ieVvXbSho2t/X/I8irY2tkyCklENCrztiVNLB/fE/r9InwCbwSV+jHfWPfqMliZkUWjHZq1aCqcf0N/YacyOQwmYipkfUsQd9mkghWEmgxlJIopDTc2YnFF5K9OVJJyH66/FladpJW++5Zb424iz9vDMZ/nDR24shCOVKcPFPtHPi+7b9I4bpArth6x6JsX0IAUBCZFrpA=',X'514ddca7663244eb0587c34eb83b828581b991eee3ba3674c19be46579265fdd49289f8e15045e7cf5b4e20f7c68f30f686b5684a166451edbe3d7a99c0d976d7132768718b3cb56b9a57b3e735dc78318dccbd5f798bb64c7bbf257ed4ec5a900b1e40f9f9f845f12a6273d9e7cff48a847a970c823a59edd029e4437ef1751b1dd6333775cf07d1b6ce6c9e73e7a7533e0521580a4ad2abe0ce53f4663487bdd6cf8c94342387035994e11cdd477e505625cfcae721beb82ece851959934570a7226d3e5771353a985e07db9aef72c1a5ec9a91e313727a713a79e7bee5c073bd3c8dc5c6840effee2905437120daa81ae5386b2e50e0fc9fdf4462019d3dd',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('C7FA37C207E423A85D26D60C2D817F95','C52',1,1,'ApRAAaTRVvKBm8oelMPn5ktIibp+Inyn96reIqB+QuQW5qieTU+8+abgAzEjZuVMbWdXldXNI5l16yez59cyBCUiNV4Uy5CMTI7w+ZM3WRF8b3xXdahXI/8LnoY0kuVSy9VVnS1i/bj7KhiLTYl7FjspiAeQuNHUUoQ7bpiMB2Q18vytdln2PixMMVCrv4i+YSheYKt3c+3llx5zgTUaJi2MUi532U7H/BZlxqNbXdFOFUabLk9DsIFpUmDxtlyH3WUHpgVnaElRVXEJ/C/a3Q1UaQDAThz4tvxsSOYXrYJK6XX1G/nEpQ4MWaLr9CmMDZyorg0+zMEDcJeVAX9H35JoSNeX/hL99tsedknH8ejS6JtY0LpZWEd0vXdwXxQxvFH3ovqzmdnIdrmXrliTHpbU7MgIm3Wc573V3THCqyqiSBfq47fMXTXcqapqHHfgdfail13A0KS2+GTXPXGRI6HMUr1phB4xgG19y0ieBshJVm0oRaiMJwCRWNwPLTY7lLRCH0/Lxu6qJRhU3Yuq1WxJ2E8Qd8OgViNHK5a4Fshk/ReH1RWBz7sGUn/Vh0iPGALkWAokg4JkkIm/FAmL0+227tWCIAlbF1ata9p3AsylIHfYctZAYI0LByf0qVMJz0A6ctcQyQ1YX1QIDbh7x5W+zO9J0fDrT0Kak1C55aLnPx02E9SrSIZhiP3L06+H1RmGA/ryCBXhVN598hOpqq7Aeo3GMk0MXzTXK1jE4DTnDzTwMjxW4KX3cdduSLkaCMI8sPLAwXJGhaxEJFRXSb66uiTuLksSAuVa9XZPqW+LXAxdDgIi+7DEOFyX82Qqd7v9Tn7wqAo14zLQEj6Xje+sEt98apj+O3sJZrQvo1A=',X'88575a1c4e833628cab5914a867a387b03b93e214fa2aab1b1b48b609753e28b1247256c8abed68fc113d20108eac9ca67ab3298f791dbe6b9730a3b299e296e96066f2b86afaf418e7e9a38f717d17713d94f8f8f51a225058d8066ad88f1bf9822ea9ee6b93d594c2770b1e975c6e097565d9f090076e5707a01f71a360ad5f9bef9811ba4a7f45925bdb741461357f2b68399bf9ae47b0d6487f21faa450f66eaaeefde5fe8101b74f88b94bb742ca000f1bd76e514430f56f2875520711418709e0d558efbc5d811fde1f43b9a458dcae34a9f7fe8db59c46047b8d54203757e69caebe4715f37e06c148958802e92566f81fdaad3f88a7f8fde5f813734',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('22D37DB11D4607CC231B264FB0EA48F3','C52',1,1,'a1vEL3TCa7q1NRMFeXCQisOPdBH6MPVsIEY6REOPA3di6oeof1iM8qw7QyQ4SRp14d9ZtsErC2Cm3i3Hm1iUqz1k1qfSZf5RqxHhGWMAS2HJLnG6dgxx/GslwxX1qjCUukeIeas2VRPaYsxrRXeblRowu8pAXtOo0hyHm3FQ33M2PoYeInd+x56lxIws9fS1z/SG7ThS6s49r/td2lUNRW8zcRFu10peQOkwmjg+6bU/xSvesh8tlzkLZ3zVZJU1ZYAHahOGu26wgGiKwiOH0h60L3Nr4s62EKiaS9Hvs4ZJJXDvv+1cmnHRw97VuNR3tw5aa03rpyeYy1fxAKHxTznEHoiMMScVp/3e9hzDSVdeFxuSPFu5hSWxuUguCp309m7HDNVesPeAWrMNWuUSdM+j+6FX6yPByc6DjQSIUhH9IhsMqNShi40IgmTm3er4pPf9ryVUZhmxRgn6Pajfhbf3eYcvvFKwx19/4dEOJLSa3iVVnNbwdhKi/UluGEhDjS7RYrHNFydpgv3qPw9/T0Vgb0QHuYKM/Ir+5lUAagXzu0ztdN5JF58RIsQAd3AeJsxAWOvAuE8Kr0Mwi/1rYvThLb7C//+S5hAa7qQN/M4UeA4DeSdpSU4pbjV65ZrPHnUh6TzJRK8Bnu4pFOEfoCyLEY24kjdBRKb4jFRN7bcyzv44nSHl1IUmQje8gLYuXXU/OsPMGPxurl/3Fx68rQ+/XSK92gUx9uteRuYrXQBsaX1+uOFTzhQyleAAJuIMS/+lmsdZE/pzLlC3RpZRDzMGlO5w4siIt7uby1TYyu1h0n3BM5WyFmkaltZMM3opGBqYHdn5JF6SGgBR+QePR7NUu82Rje6sthfIBjrO7SY=',X'1b3dde2e3f4310691c9513237eb1ed03991cff992bd0ac9e3097181d340d6c02dc64373411cd77d0ab724cc947f8199fc09aa7e1272d0e7babaa85d649f0e620703377f8f80ebbaa32f11eca12fe5816bdb6af25e755f15d391d913e360b1adcde17322c78458f48ef726ad58f997cf5fa29c9352ace5cf04a952c917b535e36204342801106cf37c79ca5778ea6f394d06b28080451b8898e286a3e12b5abddb02a0ee8e292a0348832e4d4b4719a2d44c04b15974463601cd27c0ca72391d4729d283f9483e7b5b54a99be1e252c1d217c4a5ceaac4a29ce80075ee3fc72d697fdb55715b8945ffbd707051bd41ab79b4915959173809fc853001fb0fc4791',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('B667F1E9438C075AE724B2098DFDD8A9','C52',1,1,'8h+i3ch3Z7bOo2iPDYNPmo0/a0iGpzE5S7eCs+/xAp6ouj4NAcV7fb+IAAYuvpyz1s9KFmYah2ch4Kpc7YjSkQ/noEO8B4LcAzVHAI2UTqL3/UYC70Yitwz9ran5h/aqc+wU1eXio+TOqo2S3o5ORJDHmcDOI8QKmbWPDu+5R7sJreHHbKYHvtzVWUnX3SHhcrMW13ERcUUZJ3qa4b3TfA6mp33PWO/KxvaRmZO7+9S6skVJ1gpLEXuMf/SEyOBAShT16j92u+bfL/aqOM7kBoC0isvX+IeCggD5+lu9G9sfsew5j7HHiro1PIqV3dxE+PbByXYl6RZQnX7vmX+ol98R35sy86qle/QtwcwIAxmL4+gvd5qoxF+htdotlwdDuCS+2EFh2TXHftxI9EPRqxLSi0hTq4UP57cRFAagtDzMg/5+V8H9gOYdAH4yBiNGooAZmslmBG9MjS6eEAVcVCTYB0R0boZFEaZ/nbLYItcKYgvQf7H96TBv/zg6OfSthp+bZlgRmrdJDauSAiTPLiYgmteikHu1wFioYUuSCHD3VnQZwGHBIFDTN3E2CBQrgWKBFVYNB8q9HwzWQM0NVkLKtWHxNOnGUHH39mJ50mF0iaBMyYPbRz7hkozuwGEfF+1+8BmlrWJ4JbMiTCWyktINZEg8gtQBVQIgh/hQTVCZh9ajMYKKurQZOKYMT4gMGhWyx1zKDQm6SImrxvWgqFiWJnYwuIdO5zfe8boehRgPTH9xPVR/Ue3IGDeEuHAyCjl2sUZij9PxOGQsqiw+3JjWNWfTD6MmJcfvolZx7XqWcfVhG3hhl2Ic605cPgWdDTOpGSYUPOQ+bSya0P+zZFli2sbOisKMNHkCBQPaTGE=',X'1842f4ca68ef1d70249d11a8b0e41d88cafac899ec23fd3868e04cbd9ba3b3cbdc2993043be4450af7006a6d2ba0d2eb47f2339ab8ca4000f5074a63bcb87f282b4c20f49e400ebb9401d53f6dac1266f8c8ec82ed01e8cc8cc72740d5ae454750538c4d403ccdab5cdfaf916908e1652d390c3c7df2cb193d779942c6b8b54c61cefde9d20421f542c3a8fb11704032d5a4a6f0cc2be134f0f54ffbc383752a6b55cf3beb29a318df40e4aed1c78c7232b83af39e79ac7acf5a84936507b5ad2d2efad392bb68c14586c2ef3a551320f36e260a7b709996801bb711ff3e068ead7976b02c0a14f7163e50ce161f5411e8faf79ba24f1bf94020c21d496ffb26',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('B7093B4BBBD758A85C9B046B36A4515B','C52',1,1,'fXRx1BdcCfqg7zGrCYsBNm8PUU3DM7VSE4fFIJZIjZsHbAz3oESsj0RMbmkXQWCI9Pssp7saDkgL7bV8oH+z7rzJoqxql7rqFlgqY9dDfNyhTL82VK0DNzAs+v/WhB22JRTuM5lfzu4lukPYv8ZRpy+9kwdBGQTISQ5rNNtmoCJqz6uWm89xEElAKlfypTJvXOE11fHLR1iQzL/3bYxP16DpXoLoxchReW7DFHVj6gWRRs3K1u/JsTGxuucMq8kwVeN+9ZyaNVJ//7cHxslD5GXlAyQd1tg8OkSRoDwdbYJWjIoI462OatL7tSVQXDqt7TMejFx5KsomTprjyn3h+WLNOAHpdf7isN/swa9J1uxFpNeSzUU5tgspAh+nP0Z2zy3zuDmT3VrfRo/uxYAknv9zb8BIY2EMppRZFRjehgS8LlwXPI8T+i11wk5Ytkd2NVeyQ//LgkvjO6hhxPrWAVjMd2QCyPrT1AZwUsx3sLDNQPqDJ1w23P2VLMT7A3XEeNkzkgCnNUs3foNU7e9zLQUc5J90s27cEyZ/HrlXNzrnbhW8WU8jY0yygyJXivf8MCH2L5AJfQgRQv/TgleZdTbwBpa1t5gA0ZafIJ0n6wJwxGUxbKf2QFIHZ6nT2A7yUSBLZ51/fLboAjqJaTfjO8oDzPQTOmMVbNKaSAJx1HLny7nVZgau8pJS1kiO//K02QaiVt7adi+NWRGY7jsUZ6GjCUxHo0ldE4cmOnyMio8L4z8gt0gOcnbjUXN2Cftbsn8KdePIeQ0xIxaAsUwvw9WOsVOFCMn+yRGp/Tg2NnqPZ9qdeORH/og4ape+rmpUiSzyYqqJh9P35h/ExRvLe4W6G0XnyxdIMuuQ+zyDehw=',X'73e4c9afc333cff55702dc9efa179db3ee92c616dd1bbd6133dbadf4b354dbbc5d9e03cdf3498a4e454f4a05b76efd12c578b33cabf658788ba5f8cbaa3db24af2cf3abdd491bfa1dbec8cba906510f5d183c5eae40c28677826f8858f54c740b8e3be0a3cfc78565cb053a851785be208d6dcaa5d453b8bee398cc449993640cfac5d63b1937acafadedddf455112f5d2fac5c1db1423269e778621b2058c5210a3dfee865753639ced2661d9783b05a630e69dca44d6e78e94c286d62fb5f14219aa01e1e4bdf8d7a44e73f75ae5cbdf63375bebafd75efd771c6b440df7cdd5bc718b9561a0a9d95679ca7ac2491d06bfec36b6024833007bee612c40a832',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('3203D0CCDB94928D46E48504A4A37260','C52',1,1,'j/9+7UkuAw0dJQUQBPpe+0SmPnhOrcEKe/Wk3KoO36lpFZgtUwBDnOfF2z5DnQQgEvzh6YLEQXC2XW3GLAm3+20fgFr0SdigMFI1ByQ4zSvJBmTb+xdEgHUZMV/HFxHVfNpG2UCO40S1nIwuQATNuFPIbFtFJcji3NXZ9z3+7vjsN8Y4T4vSmM1Yf5Q2E3xWse6n4Ks6E9usDn3AIQ0AHybSuj5BlZxh0QDaOGTbWlkICpKIsH+CMqFhOQD0LrOdTOlFkhJVEPKZOYwfOXKzwj9oGwUu5OWLlwQXjqVe2WRmnC7LAz1/HOevC48MGPcRWHnIoz3QJFIsOfiSDxMkc61ynD/8AZWto3JQHgsPHOV6tgfo5o2fXZUYnlVywKaStOTc0lcSYxsvWMTxC0Rdg2sCzmolMqU31z1apcYlek9bgfI3Onl+7xudv60AbmwCCtMU8WNCJvDNylorASwp8l9zZeQ71g6BqZGa/v4pzgAMp9UO7OimuOhAqMgauVhk8nzUMLk6eKBSRPeJCSEjezgmo9BUJtV/YUD5tzazUA+kW71AnluMzq4uQjj47lYA3jQUbMt2fpLAn8x6yOnAdDpu7cSodYinbkP/xY0L8FzCQxfpi4e/tx4O2KJAAZFFbGwVlMuSNmpIiQxld/oxUjd+QKUxDonqpxlU6mlOUtnX8bN3EalvpqQMtHFZG6cXEm7ie2+rXu/AFkSJnHB+qDnvDIOFDEJSP6N5lBmEXvwZFnq+868C6jvRVHS3eVW3qEDYnFJjWKGwWU1toI3ESOhuob/pFDYDAp0+DGX8uTDJwjGyYZu45Q7Cgwbh+oE7HofFt8vKnBVd6gj9+y1pAtaW7xQeYyQ/TDG97BNDY8AH6y+wuK3b9aRrYCjyRi+d4WEX64OAIJbHlJ86pMoUSY981xe7Z1sQObwXX/yM+s4iCjtkP5g9ZBR8S1xcUT+HgWXs9hFV5cmaTa2M8rsf+zhAjI1+qaHRfuUM1hW6W8/M1Qyqe/kn6V7MtToTOtCQojC+whAAbvxi6uuV5jw1j3ttYqXtTyLuRYrW6dhwH+wj9XJd4UN1X3sJaT+HXm0W+hD3wOjlyOAH8byPofawty1jlsDNH6viOXweBxypf/YVTEOY0JKtryqTjvGXXh5Uny67J7F2u5nZl1uhCNiopIMqmYlrIMhGijblye0VJDgK8BKZuxwSUrN19+Yu1XtwY9az1p/NYWlkJZ3I2cLL0X24wWIHrS/jqp7HBmBkAt/JU2hxJSkW45iTu+etD7ZObpJPeSFiF2gzmPD9v3BWktS4kdfN+9N8cqoCT57p6tDK1OtaRVoAksa+hE2xuw5PfwCzpufsuo9n68lNtgtvvGEgqC/EMRq51HnRz9rPGiN3npO9QQiUPOZ7Sgg3GQLBdXEJZT8R/kXrRNOxfd/Z2JKqsABPMcm/krRPGheJunFGUwLxbLpqlr5W4NrZ0qET3aaY1NRIjhbjq+nsVIHeZw==',X'40c15547dcd913134b1de7237565dfb85d0dac6d2bce715a881910e38d2de85ca78b3ded305f177feeb8f5f011b53f70f9572367b6a768f16659180e8a09ebb2aa52e574455b90bbeaffeacece1bad03e2d53ac70a52de0505b680acad99182f41ef6bf79b17ca1dd7cf8bb6ec366280945cc905e2f527699f71ad8c2b854478c7c3b08fabbb0a5a317d8ebec967c70eab5081b02d5a99d3e1ff7fe5778445131bf1026e16be1284aa23314848374397c61f900de67dc84b5087d71012941b5f734489bd2d03fdba7ef6f5c78aa2168936aef39c992441230de5255d20f8f801714672fcaebe07968bc03f99bf5beac71b0f60bd3dd77eb924a64b383126ed96',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('4EEC55CF111F83DD2F6AF2AFD38081CE','C52',1,1,'krjpmDvHvRBF/g/bSSiNdjWktYpnXsySWQNukRufP7WH4s1dYFux5jcDsoYK5EldC5JfQ7FirVWnqdArRtR5hBpMiRr4tk3JOA0KmEyCvwrIIsEbQXTEKaddy3+twSX9cBUJsMD9VyfTzgOGMuF3zQSMYBSIfAXGG7LH/bnc47j5hjGuGjI0KWP4G44YXVep+AoP8PHWn8Pr0QjoWRsack5zRSJVhRXHklLunM6sZ5r0/V3o0N2QRUtyAFgwE01VB4DRZ56PJ+Zw+TW1KjJXHVdJGa3ODaBtfNL5WE0dR3KLY/OOqB8K4kQy7bHwcVFilSzRV5L5kFjGGeGytRu+5isjC9oFYBFj0oXhKcJxDKJIdYdLUXmz8TNh3b9yxDKNZXvl8UDksxORiAurjqLQMf75g4CRFBKrd2n3fGhkgu1WNOiu0qd6PLb3ymrUfmR0kWpkrAwil39807JNX6ofBwpiPcxuG1qzD66IjGm0Rzc93wsg3dQIg5KRlH3kVq5wewEmohdWYyxTqlaDkmSb2/GYhiYCe9aLDoqgKgY67w3H1R4o2/uMdSUYagTluZcSRHvG9vRh+SNHcd3mbxpTWZ9T0nts+OPZ0sf6ry2aCOhdCckWzug9qyE9jwhd8Qk9JfohjpfTdVk+PKs3s/KCf7Fkt95FOQv/UXJ8xg+awzpORdsq0l+TdksB12Y6qpMjKyXCGrWY5H20YNte+bmNq7/DgaLr8snxIqTGTLiwOYeKInaMETjWdajy9CBt0foaQrppL04rKQzZ6W68cl2k2ktmuX7w+7G+J6jOr0IitLekzgtjgDtDXyvgIspNKmUqwxbQVVQ6hlv11U0JJYyZNTgmhC5mU/OjcwE3ZI2XHrc3FUcPtoWQrTxbtBqQ6vhZ1CvOUZzy4h+9/unYZ78IJtWK+BF4WKfHcqi9pDEsRacuhau2wIAk8yt9z7oIJF9DPx4nEtN3Tj7rcjf8568IlwXslagl/giW4oUhw0KSYBRRia5zV4EYeYN65OiNRGQAnqlcwZmI1FGnule10/jMhtj1pitWMDftI6T7WUZXPU2LeCXnP0PniiykRAlh3CJKyDDzTmBALKjTOJesyUxFJal+tGaU/b5gnw6sbNrZerKh1mV/4PyaeHXptIu74wz6Q84K2XRb6qRZpVmFrAoyeLIdpqVElfoD+0CepDU5/9Crr+smYYeAvMPIinZJjZFAPDqKhv2XJbwHpz0BYhzuH/bRYltKPMf+KAk6cbjT9Eqacjx1wG2Rb0syAW8rQ0RQM0vLOqsOCCCoaSOMMNa3tcEFpKhJdWBpcflOXplhF/9pE58pFW8oTR+yP9lDk2tsaTQGdxl2IkPXJBCUfAAWsDhIDvwV761LCNOxld73Ymuvlp8jZRYXKW6xIHnVwNNXrpyEFDWAzrStyeO8RUHI7MpqFdUooXGhebzIND3EMx4FFyD7z7YKuv11W4g0PKz9y3UG+PFTuJqb01DdBk/7GQ==',X'152248928391d339a6aff494c8a8e6b2c52cca89dc36ce5fc5e4bab38e7a6aea962bb6e62a108d8aa7837fd7b27505c74e1f246139c63a904fb0e46f7658fb8717bc6bcae662311c86769af3d2342855ab4c6f54533c6806c0a425cc7133891295c9a8b5e98f400cab68671e7327951c7b4dec552486aa17a3f59d54b1cabbcfcb0b771e6af60180dd4dcb346990427c42947897b23d3b9c4ab385ba8ef9e12bdf0676a0e9aa65853d738f792a9c234de0936129aab5c24df7b80f2c1c365b3ea27eac8809cedfd1f5a18535c2e3ac9e446b63205bff8da3c766945fa3e420d7da3e9616718a2a3c3140666672c0cf9afcbe7025ee34b50d84c6f2b48a631bc2',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('B966F48629C273B70B4E86083C6BDE57','C52',1,1,'lPKlp3J1PJBwpZgnULn62Mthkdo/rSDISfhAZm9yGTYdESbR0t/Dn8NMhidMRDLTead4TAlqTOJ7UMByXLhS10z+6qhe3E/oIk9Y1uFwSjKPWgZ91t9MMTnnPOKOPOR6jLFUhjOzwl9dcvmNqSqdiQvEkNNUMnJp1ya/Q4T4Z4gJB3gGdiRi6b3F2PHywu0KJeEfmORNcLlnX8sxK0VKf2Nlq7aYXbJzBuOHuPSXqh+tuoi1hF2kMTF3EkEd2++nf7xOiHl3G4Q96n7Vao61WVOvJcMEgKOFyf+CbNxo3mOzOPffWB7W71ObDPIrbFuJ2FklMbgBsL3vGM30G4uM2qs6AuP/f1lxwBotly6fUg6rLGjfDNFfQwD0h8UxYkD2PCaGBRZdS24bUMoMkMrJWjBSGSE9I/DczeE1DTTDe7LciABuQvTEulzM+Wc4UjixCqJA/wSg4r7p/iUIGF64YGuXLDD1hG3OdTdXBPQzY1L62JC/Od3g63Qf1m/teFr0gEnlgIeRfFf63w34aXCyKIxBqBzM+EZuLAVML1fKvaR2P7ULb9mxzvhBSfgejKiIEGCW2arGDX7vgT/flbSJpFJtHX0G7ihbAfAhIjOPeiOTEfZOh09V8ynkIz/OVdlP2yD7XUKjN81kxsXh9SceejhZtnp6M14xgbMLqmuBJyyeh5xblEse7PzV30adQNPgVWOYoUFVrIr9zRAgypV8i3cdtlTLobUGmRqSSrleUayQCmIxxl7sBTA4Zl+vgMfUkX6vdfxgt79vIHCmXp7r+W8PROQGT2IRw//FqQuf98m3N/wu8LFLT3Z/d82lgwcvCN6WCP/7FqUHpHsXWiztS2jAmvZz1vRwQUKZOUKO/gQ3sZBOBezsTkHzJIcCqFN+t29hhLcEzNnzj7QEYkKtjgWUdPO8owU8XIE2PTDwup2i6Jt/uSyqb7hnY98HRt/5FtGrDcJVsjgcOQI27DaxvSNXQLTevVL5KxqxMxHDzN0fTCUl2az+wN0CTR7QLquJ8dYoP4B4MAItLYp9By8zSZwjAjkDQvzXcBO1d2F8A4rkBZpx/55k/3/hSbf3dUa3kE7OvTG1yNvZ/a6KHnjhj56jhUStcqewByUuaGQ83DdVkkWUdOmMiTA8m8zApZ150k3D9oRdsCbzQKez9e/ix7PQtP0tlJ08m+89i4tMFWetnnUPMLEnzccI2cpHPFrJWMdg0a6Iqw4uxhodrBwUvLjzOaBgapV5Vo+m7gM7wuYhAke1tfoZco56JidcfTX32U/Rf0DOSRV57HbCB96TYWPxsvHVCnzPjHmdJ+cQ0A2g2JvGvifZbyXmCtxJwgj2SnxDH2rsEL/xxs0eBfLoMZNRg5roeIdOJvNtTxdu6Op08u3L6IzWl/WLonHpgjv/fDpv7Aqecp+swqnGXcC9mlQTeNWQe/nOw6h25cwrqhxDn8CBGiETsBq2ufAN20mHiKCvjXzdoSCH0X/7VAUwNw==',X'848a9f657f95940cb3020547d344f9a9a6b23fbf2f52fe49138e83c40fe4ef781101cb4ea9a206720b7669a70d58c2f1d2c1a941643cb3efc62f8d901c190e5ba378d5348df9d92794e1343e20a77bc1f129089d3d76c7bb66aa1f136b8444978284bd260ba51a9ac066eeaf9cc5cb3dfc82a3367a770ec7955bdcda7a38ec1e386509744f14f3563557d393f76c724d742037688c0289cc90255cb17331b04f5739f83e4a1d05156090797b9d90c5c260bc235c0fc1f9c9b7be20b03fe61b893f7fac1b0ad7e741b559f613a2c5d037a8f5d24fbd9adfba0c4403114cabffb1bd90c15b68e6079e7405fc10627e62561289074a652776189bf4c85330bc6c7e',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('BE8AA44861ABC2DA2C832DF350200610','C52',1,1,'IH4Hy3xXGKJSyMckB9mOY8JAHdXErG5EXiWV8vTdrRC/nCPbPCW6rZHyZRsOoRuAySDaAKDzqvGcb7U2cN44Fo6yq1A0QvWlnaoQrx5/MJc7FyyLzJEjY4UiLXHd1+x2HCMku+JSIvyzm/79A7fPk0xwChmroxWaOvV27IKfXvMesChf+nFpxyKfaC5iyCujBrjEfx9ornYf3zaQkyOXlYHOmqjRFlRsJdtXM17kFgAht6sfwZjH0O+z1iS4vYGn0+Sq1LEIS1pT/F9YtCFVarfA1k4xqWT7e9bAeNbOFfIuQECaZdviLT+8tDCm96xDAToa64fhTgUctU1+GsiyU36sP3xVBYp+i4D9ujhkfqqQuq8FvVaRxCJnF602HCXVoQkjgc/qyV8LTr9PbkFmYkKC/EltsXUdioRfY0J/CpVQch6aXHO/iB1RHk8nWzKdXhhhyGtqLOwSzR9uOrC5iMP+bO9deI52djlINd2A9Ods/8Q+oe1aGSDcaO5gbYX+jZu7stigKYHDFJsENwg92Inxq/iFnsCxvZ6qt/7NtvO1Y5/3qvGti8R8qJtoUSRrC1PDPiZ0V3Sx7GwYpwG3ePXSOY6cDj3M6L3OVdK6DSQxp89PuEYe8MllRLBMiOgSUaaNnCKyQSstOIahyWjvWliGyE+KrqalK23+sIOzdF/1fBazu6UQhlC3lUwxyAxP6UeqnTDdHwAyQ/9f/4/lXESxcirT3sSyn8zBJSk19j6NEE+QiOlh9zMQYNsDUaoqtv4T8X5t4CGUutKHDSVlMhXC8qBmelWZ6lcsGkXV3GfjGbzuD5Fd6eaV/lEjlBokP3zqPZZRTA1OgrObiJrkDLliCqYgCLIojlMzAXuxzaanpIRrP+D0QGrYEmaTbHOXLwOSdQ2LiG3Y+h1Wo+xpPF5ItIrqtGRmsEo56tzbY3XqqY+KibrOzM30025uNhm8n7NQ+0D3fTWRikuQFYwGE5HC5/AObSdcF7okU0zz3zdUagaOgur28I4cz4yGSnEsdw8bG4Y7FhaTAhesFLXTOqMLTwsDQ5MqnjPRFzCqpDbSerAIrAOOBZiyhsUVDWVl6gNQZKNEfssV9bZlICRHkSaBIeZ2V+P7/vQS8NINt1h++5s37MUSbBNzeGW4Qxqvx73MsMHIenQNZ6i60IcD+PbQZMpx+N1lpMiktGwGrsRepU/rLYUDkxspIwUWfXGv24s1RPqNu0tdz8rA4ZA3YeChCeeCKXwEDvcCVhpSat5qtexzLxkwzIIzlr8wnQMNsE09Mjt2RarGGj3IIKl7dOo3OV/mhhdcgEkN6jZtIMghUeS2wg+jwm+htlqqDSGD4Lm4AYi7IJ7AVBOiWzk40q5QqoY39r8kJky8ZwooCGO6MG+gsFzCbom0B63kG24MRF1t9rZ6Xi2gKBxVgMBnmfleqoFEy01imCcye1i0HD2rG3A+JNsSuOPZPziz5OUrjttqrLDwZ5kD2tJnNUWs0g==',X'23930f63b655a7d12f61a0e8a2216784415533c36bae407bf8634665005f1974b41053f84b205af61be4ababb6e063cd474d2d91bf6f5f0eeb6d38b6aefff07c51f200ebc00f600fdfbd8c21987f1b0d9af49d8555fd3d5d744bb5ee6549855dc21876b6901e7ab06ec08b96292d242f6a6d43b04f89d7a78c7079119aae4f867a59d05c7267e0a9e2c5cdcaf50738636c55a0073c1504f9b4cd165f7b236a6e21a8df85a9611f382f73eee392846602426546e81b25a214b1756a626bd121daf04ba5353363966d0d77e63afff0ce237bc15788c01834557eef7e649dae75da3ab07c5f4d89a77671e1fb4ba89e093682983b793c797896880794991cdadcaf',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('661BBE0989488602BCE5DA3E2D65B488','C52',1,1,'rpmzbruXrjRQ9dbrq5RG4gjYQjqPs2LRtMI+EaDv9WhQgW0a5RQQVRaj0JjaWQyGd6F1iU1CtyhGlPgmemeahiLG1Qf3zUzHo413L4K2yf06IdkD5Ods6L3RAQBjbRSuwjFjXtFxIDCniv5+OWx2vok5GGQG7A0TNPNu5iuHfByqRog1zAFALfUT9wdTbPr7YLC4lnbiFubiV9rFjL9X2USx9Xz2d7V+m0dV85sDmW7aPRj4Tq9J4ZTwF1kFqYiqelK97m+koQhWvsyW7Fq7jlfBO95vjDg4QHT++A5e+z6ScShMVQw58WVgD3VHOtBR0U7Pa4aMscRPXETSu/VP5Qug8HFqzKvzH1Blz14BNE/lNTuusXjBZGjTxqOvWAIrbvzp9rEMrsO4Mf5J9B2svk2GUhBkGofEfNGqXn9wbfTl/zVbQG6xgN8rMfWi3GrNp04/wgEjEkgoBsCF74eQ/kLnNJHTcWl16bTZL93M3baC8JQ2OS524WLb61VZcHRshWMOZ3vUk0qCqMybsQoP8rxbics3jwEmwMi6dSvVAXUBbEG8kNNwT1vUMZb+QnBG723Rf216VB0ROn0bhJurFUSGBkpnrktOv6fiuWlBhP+Qt3lAuynWFP1LlZOwwXdOgD0ENNNikqVj5rFX01YuHrDxKGiErp1iD1+of7MUXv4gooEfslSHOPC9dXbpnIQy4AMprLDQy9I4/s2v9U1z3L1c3poAzBc7syhCW8qVMo1r94K1SIfiyLY8irUzIROSkcTnN+Mcomm8qAaCbDV8blTtr25z8Yc9q0Rb5r8P81eQ6aVECRtFbOKemetlUlUsALVvbsUafBv4uEUccFNwP/ruqXiAgZdbBhdRQbdgAPGbTWnGkcwfipjnEGp9EZGF8JYf88hzjF+1mA1ySt4wK0cxKl4UjuH8PO/Y95nWdUWAfByR0d4JOtlfyIiaKC1a0kKcXdnbFDAas+rQvwy2hoVlT+F80Q+8ASkKP9+WkL+wjR2O+tEIWVUglsR6CRF4xXgceYm0nEAtxqISrqdFLHRnZBDP/uRTcPrMCtiRiRA2yQ2jXayu8crpnKVJvcIQWMSt+HLp7Hn1Gnc0DBXFaV/x8Rc3ElPZtu1Lvw3y43KdTbExf3X/vwWcXCsZiKlXmTmdsFOg+sGqKjb8LEugb6+GeHHI1hLeXVqWS86TZ8naW3qKx5qw8aiXy/A6urpUuYH01+bwuomfszT6KzfTwf0HuQ8eTkPpuQXfW2WNt4Y6irYv7zqy+Au80jAxFLGG0eBNLgrv0rJ+p8XWvATPlanheELsQ3qvnq98g7q0agA0cLXWIzBmyYFDFiwtCTDevFOFCVswojYOCI8VtaMCc+vycP8cftSXuh719bZ77bv6y5OH/WLzNk0k88i90MRGCXfwLJGfbNRdMhVGxQ3TvVjVxqQHhL+EalZF3QtkhbF3PVFmLpZ6wqKuz+bJRNCLctiTN3SlpgyNU8N5m/eEYML/vKkTbT3zU54LuV53P662jxMCWiEwFD/iDl1IIeTgG5b139xR32ZJDQqH+tE7GrSevXoAd+ME8Z/95PaDK8YgE7/sJtdS42wFIj8WuzxXkE0h1aZUc3xc5UO8xM67LbFHkntKvrvZIRuxklAMdTY=',X'92eaeb330b74fdcc05207c21e6b9c1001425654d9344c4ded5e37b3c458d840024f4d49cb1158d999fd1e3097650e2538851c0ec5f37b8d5313eed2dfc1bf354b545cbdb712ae1d3294ca626992e4c4e0f29247bbebe01a6fb571435c5778ccbdc89442c7c56234f340a7bfb5e47f34c373caafa3be1b715d3b62283260351f0daf38b2e5c63651749224351ec5a1697dcd4a4ec6976f561defe8625c738f41034d64b61794c0b57ab69e1b7b213c07471a138e17e2eebf4ae02fe249a74198530d9e9d3dfd412fdeee8dd858ba61728fb15767a6a468a9cca070ac00dc2266c1d92a92dfa04cbebc16a21aa6504c14189ef405b817954d91f6b6203058ab2ea',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('A45487E6E29A53BBC597A690A0779D22','C52',1,1,'HrredcEaoRQjyVq8qEVTvKd+zG3o6pxtS18JxxXYZBtthJTmiHBghLSndl/FBP6o8JUZnVVQNi2ElYs4AoQ6G3t7+Gpsl58mdyCyXAoGqfeDYebK9dv2NDYabe9IUHxfw1ZjYwakSMNBLdZWt2xrvRcNZ7SGCV+lutDigyKU9Z0bP65k9kcf7Dr0sIbFxAei2UTobADVhHDNRVqwi1cd3DJwJks6KD8RNhv97taVfItCitZHzTVeDtjzGMRtTzBpHvwcU7UVfnlplx3Ch6Y00QFcUh0p2zDMj3Z/HBbxBle+vUi29dKenIlOSTqm4ienySZDP5aweWBTqXCKSCCTFzAVUg+J76LQHlDYUKd+EG5Q4VmWPniKO+6o+SfyWmEMxHdxvAkO2QJEVA4PpP4NNC8HvPfvKvMXgKAWiAtpgzHmOJdgcV2bfFcVrLGwE5pqod1Tgrg4L6RTz2iDtLD0pbt2pR1FviELECKrZ7RsnW6podoONSvoT33MUYtoJMHcCbLhGbfTD8e8yjFjxh1EjaRNfp2n6tuc685ArdfPRr7dkkOu4RRWBZaZlMIaN7qiNaXWzo1yOJ+a4xoAtAUqvI7D8bZ+ZB997FZ4iUC1ALvc3UsYk4WN3i8+2znTu53aIxRVZlbsvaGlaQ6Jk/sagdX9Jrh5W5WmqZfxoZzLMKZtwIFZ5aoFOiGf/kX5jsLq1Jo4rNNVR/p6lJy1rlbp+/ii4uu17L2QDYd1q0E9JUCVYC6eaMxyfQNB9vAJN5GAGYDIuL2MDf8HI47zoeSftXDdcV2qF4wVCp3EI+QVOEb5WX43AO2DtGAVcPBVs0ImmFV50qgqiH8sVPvFA/BldpRdW8TSEK1pFDU6oGwl0jDU+lUzI31MoXZuDMtdzB4NUEQdHKLQMndaOl/hGr4nVYM/4ug2uKTIb5KE/sdPzFErBIU7rrvxQSno1DnQWIkXhWZxNn6XXb4n5Hl9ZCLAHiXEetATso6Eo3H2RMq7wflPSbV5kl41GlB49AGjVDzWG8XsH3fQOdqgYOQ2dwk8dsG4hMSimORX06ay+6JLQ9zuSbi5Xj1pOUcDsAu6DJr4UXSoIwHtJPawpofcxfcDjsjEvqiYLpMpxCT1cYF63On0sESr4Lr9+n99T6JJelJOQUQogylwM6c0RXS0di3PClp9XW30FgMDukQExJYvdj5+s1061f4GNBMDSkCooKBXbCZItCMQ6qihnP8xaDLEDYvdimW5d9SpH5P30X7v8f+EDQ4jb+YPjWMs7dxP3thMbYO4GwR2DQI9yD9VxoVnu/E/u8FV3AWvJMZHZ3bFQiSa0SHM5E4nhOuesGP4kHn12f3JYnV4GvXoZKcNxnhM/t5qLbHB/ke15Glxqn3dFagwsCuZc8qOUdnlOnhz+sQoxtY7tZLN+UHMVh0bj0wTxJ/ZNfVxBb5BZ3BI7k2NSzZKU3DM4PWU0GnAqUijI9jizUG0idVznnPfRtlSqI7nWQUOQQaot/J5l/n+vdG12Bbf7koURF697/e4sNWDN16Qvd1j37xhHhM10wvOImKw65sgvtxKgW23rcewu3/a45KDmQJp/kGbQ9BX2uwZyXkP3zGivjQRtjr9MjjTVfsCgOSEPHnY3kylsf07BR2Wq+M=',X'817ca74d9c23f82ec66c97057436f52c08122587886b5490950326fcbf20b48ff2c83870452ecc85f8dc4caa522342f5b42fa3be23a30fd91413a1b6785f2948aaf7288c2fb9f5d6ace12e6c35335b60e40ff13d29436059f938008d8ae172f1260bfce0abec81b0746c8c864191140fbc2408f6283fb72f3f343b9b97e0b36ac781c153794aee97f03231759c8edcc7a046b4bced7c00bcd2e4ca5066e1539be77cf2184c62c225c9b297cf05e127d9a9134d206a93221694b5ec3b01472a612dc421ae5820ba576b12027eb66bc0d479c6ae6cfaa1c3a6dcfc5b297a18496e6749803e6fa750293580f931d0957a783ac0b0fa432dd949159981ce3db734e0',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('D5769BEA0E406B1673A164D76F509159','C52',1,1,'VCwBFAHyvH4TbdbUZPrAz2RQvT0wZRrE62RWKO4aPiqUbwnVBO2qzKzZodEX8/erRFVZPWBx4tzvF/HWaE6SdQOs8vAF5u0FlhnQ5UWB2FPzgUELeftGqSMXvQr5SLofdTkCLzCYydtH2113T0Ixn2ZHxcGCMeVWIjEN3n6vyGhEe424JxZ6SDd3ZYUvJtJD5vH6gCrPqBtfcrP8sXJzs0daFNwCF2Wi9M1PpbqDLCxeluMQxfEDRuR6cjBCg8A8fF1k/gV3FlfoI5o7wc2NPKfIm/DL7Nqhcit6j2bM+MfQNF3ABw5gZKq4D/NsKImulv3v9QIQT/bP0LqtqxYOlMBQu2C75I5boxTSAW8Ngkif0+Y1xNKPpTk37Po1Cv3BpMC/5QZEmEB4Eo12j+ZS19nQy/2bc7Gcq4OgzHZfgaswvN7W2mAbpiyYt09euvLboCI6hq0jCbGwTRzQ4NhuCUgPGuJ4qJNZwNZAIBqUN2hv7YLC7ITqa/mzDVLdLzq4rOlcFtrrYn3zbsz58wH+/bJp4uoWRZJxy6hG9hbzswaEUsAuKN2rFV0LFvRlwXtUyrI6Jy+eUbP+0GiDRiF0R0RkjJ/rT/lVZFu0PjXRxoJYJ/skp6IIl14uiqiJxgay0vqozW00LFr4HCRUrGpCb4KdxAKKxD4VXi2VkAZqj1XR011U5Dw5TcTXYIfVWWjMiMaAX6pkeXMLWa+wL72s1B528EC0UhDSgTgo7Xuv5qSlmUs5o5ciQM/BFW0yILV2FDPJF81rCBPowjJUaKHs3TtSes8inbZY3FMltptyqkwI8pMl59G1/TlL/4oMEWpf8mbF+Z6wf9/1L8l+vDz+LkMoLyVSlsEs29nwle7fQkcCLw0cPVvr6QEF84C7Kg95ZHqKgSvFmTPy9ERCG5z2/iAyGICJmFvFpqMtGJOipkocB/0HbZF6ytnphljZSvx8hX1l8gUUmipSOMDBzXj4n54x8/DNER7SqE6QhIZtdCy1MVZG0OHtvjas5VvqjhMQAV2A43p9MF2Lm3Xn1vaDvlZLCnbCk9uTmXM+oRenwhtSNUETzH9PzzEOqPX0sLFlBXqpV8OTLLnky44haY/nYf3YcIsgMSqZ90R6aBq1WpLU+HRjkzUWfS/Pt8XKhWvO0Me9NF7E6alPL5pzN1Qu7/JPfeapES2/DAk/0Jec5rqLDHsbxDWIp80UGmaZrLUrug4RXfx3wem3GKzDOJ2MV4CG8Hesf8dpAhUKTdGz7eu6y2Lq9M55GNn8A/jylAUnY0/ASwF+sr/L93v2ME7cZpb6MdhftKHVEYXZ9uHFNTvZpx3ocQ1GXUPB8v60ScGIA6Tek1FZK5BfOEdPCQqHipyODRZKW0pB3WV1z6YDb2VOgnsbbclh7xf8scf8SIawsywKyopZLT0ZSVc7UkSY9Zwcgar+VpniF6bcn3T91OwZHB6w+bev2DggQKVut6Kst2Jh8VG2HRoVDDEcXgHleFsTPwWdHcByt0FdBy/703ioIk/j8IMBiTaCj2NElIuV42b8sGzO85v0kOCWYshNcXBXDJ0ERUwVz7Mgif8VQ4Apwr3TG2eL+YBdrL981A4a20XZNAUm38FPXT3bqHjL9GDYdzjXpGpPUJmbrh5lJuU=',X'87ad3fb2cf389ec42f8aba5c4c5c06ff91ae466b577c13a258e3f25b162c05560e62d67c6e3ab6a1538caecb2911742d75cfac08677ea5c96e8b394b5fc215ef4a0336b0ebacb774e576cbffc80cb27fdfadaf89f37aca86b88b3f5855984593336cac38a8affd8fe064eb65f1852bef9dbf47b8741826f173a661e51a655fca4314d6cf15aee43f0ffeec2421a78135d383ff542821893c2d23ab1091e17f902fa7a2220cc21f54f7668f7fa9556142a40c4339378cbd236f2cf7a9a0d98ba3fdd3f915f23eb4b2fd23a758865706d0f0d4c5adbb5b42e586d5ea0f1da624985c836a8842b21284bfae184efdc1d8d2046ca9be8e806b419efeb812e844fcb0',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('AA0D6A1AEF8A78F9365CFFD5863BB918','C52',1,1,'iZOYa0Dh9KH3iP6tzkE2hzPctOoNRl/h/l0pNX31WiDP//yQu6yw5pJbdCM7BRIK1C97WKjByqoaUWxVmRmmaE4cUJxfDr/d6SiUoMyJugJRH4FV31Nt33yOawQqtP7MfHBLUx3soD8OgB+2o/AxKLbBcjB7RaDebFelQUCE5JEKiIAcuLthr+PmHLc2Air0TlTVWywhTWAMwgDHMhn30Yurd8af+TvwFSZ1TaaI61d1FVbKEgM8rFR8g44GN4pe4N3Cxv12sYNUA+pWbNtgGbOTfvs4Cw5t+AvfVxEu5Up/tWnVA0DfpE26iRj0WxzluaSNcdtU6jvDSiYUE83dFLNGT9AguT/UrakfmH0ofzlITQEYUnBkmlnBA05oEYjChH2SDyTI+lk7dn2HsHg0fePAiCEF5RntV9ZMSIUqpCOvB1Nc7ceOuqnAVVtaCnqWzRJbzYpP5A8GG/gLOvkl6i07lkZQSCiPuqw+2qOZfs2t6TsEzOqPojzQDhMibeZE9E0j28r/Xp2q5+nPdgknhu8G5T3vUm8v7SiuP0hrsn6xSq9U6cuKXPNOJUpMm8Jwhcetll/QkQn4aeweGtuW7E3qZspSXjEGcIiX+dj2ae49Cstu6Elqz2NzlWN9UW/feT1NhQ02MAML02M7PtvOW6QI4faZlKyiVWw3D7xRmA1P2FN/zcGVyjAC65n6jDnwSCNRz8DPhan4FnAtuI9hZMquHs1pZ2FQ8BpoNFLRmJ5a4aRb+KX7MXY+rKrOzqtpKAaJa5W9jghunharSsV1V/VOYGqULbNTa4/vpuZ6TDpBrjsBL4XxjZxulHXTxZgxsd3Eam3eB6UqsSPg6Q8dofKyEvRrU0atobBhvRlX+F/TEbVeFZ0VLU/A0mWuuiLwmPQTC2zNqTs4NnMl4arNmSlv2ZwlP8cp+0bdmFirIKfgO3VQjrttUF1UUh5/68VF9nzlecq4nlCrN0umJb7l6OTDtFAfcf5I7KxCRu01liiOCQT/DRhzhpaT29cL6oUWMISbjWUN7DqHjpzsmfZ3PlLO5ggJUQauCxyWSxpJn/f0c4Vncih1uZzJG00anMzw0LDiyw6tSm5EDapelfjVGLQ3EoRiZswDM9SmGIzZpGIb/nJ39epu7zmbdVJOrySGvnxZBUlqL2+Wb1qwfSr59/1zyu5DkvYZl5prk2FuDhIzsmRbt6o805rG0RBhOqUYN58nS1cE1rjRlQkkwkKfa/tqWd0qZ32BmDg9FUqEIsye8ReT4kat/bMhq4ZDxmVZ16bMWQf/qvZXlswDuuTaQ47cGzgq2Op2xA6xT7jJlKf9q/ncTI+nVUkLjZfcBUqM0jyi5KBCPAf3owSh1Nc7/uXNLAREZIwAhlQaw4N6ETOJm9Nh9IGlomX+e9ZLpRow/HedAvywoICHwaV+0s5VUkHVI/TXiZ3gclnRwxDtkYXopqHgXu2pxD9MRQbEcyMWFxpVUyt4cvJpB2m57hpW6F9qkPMol20jWc3qnu/EdqH6DSwnxWopLfWO00oJlxrfxsqVUrClIFyXXWqMEUhZVNroBjc11JArasx0ZNngx1eWlQHOhwAUGibU3J4jBMDtz1pOuN6dcEUXHefGzcoq82jJsDsCyB6NGyXN5ROsqZY=',X'35c83d5dbd73f4bac3a2fedd655261b15759cb4fd37269fa145abf09069ecda895cd24d6249a7e1487915851b9a91b7d0d4a616c1bc2e815178a5a51cd2d22fb7085b468e502ee3b2dc2a54ec1ee02909951d8b95e2cb9792c02a3b65d9670c93a263d72af50ca3b7b7cdc1322431faacf6de02141faabc22f241fa1c9f2659a89bf23f3ecdf26a4272eb0743ef8eed3c2af933742b322a7b3f48d2916c4c9e5896b1d86194c8df29494e44d1005688334f16dd34705d2ca2edc682e8090906500ecea049e4517ca08428ac431d724367c3a84069d5685b79b3466a5473fcbc430defd15926617f10ec7db5ed8eb878b1267b2a5f48abd98c22bcd990b42ee8a',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('66F9FA2EF627824AE964700539D9C8A5','C52',1,1,'BWLl7PdXk1YTyVRga4Rc1LFsHvbi3uvzbrEKkXbGO1PZ1eIKcxH0TOFl2igGuZOQOUjNijGNQCj+2bhgP9HjzSz4el0m9xthhdM27ZlpNgBg/2rw+K5nOINC/xCNA6pQ9y8EZml6IhV7FlTdgFk+d6NDFxV6Oj6AUojllEB4CcSE19nhKMupkE3JMbVDSniiCFH8UZHpqdgIsg3UUunxV7Do1hKP5IBe1I1eSyHIxCMfTBvctmwfapPD7/qvgukU9SNBTW4fret8uiTAIADCziNoeA82rQjy/ersGOGlF6fxtESKa6zAXAegi87/RZBjKox0PM7v+qxaA5NsA9pKLg+hXdMi2mhuwJkP5bCxTjZhW+lAd6/P4LCUbpry4KGjp+Jm3ueEfQfYxEWi7a5pG7gAJ3ve8Xh20VMuAelEehhZKoINiDBCaTTUvFXwQbKRDfYxYwbyOwUia6erMDxj58YkaR59nEkk47YpEX8+LfCfSNzfVokis33p/iIX2jR0Rr5OQ2MICulbuwkUMkLnWMG2KhTWEE/0SkJ9jLWISdDP+l+jIVv5xuypl4DZFVzcHTjuwjUMOmlBF5q+mmSyaA9M8ybyZvhbMZ+/kbih8VJVzXibymxLJB0inbRvo+Y2MEuwRDKXWKzFensUrc6WbEXNL8ttjRvlm4dPvIw5jfbIXBbIKC5KWbPezI/mH7zp2auT1I25gCF/QLsb7NOGj2cFzZ1yxYUgOZ0tF4g08tDMd7rP2eD7RjurXBcsF9FPRaVrkFOnKz6z2AbZdn/QpWwXkN4YwrA6d/F23A7TI8dFAdNVqgNp3I3A3qFu2c+91bzqC9MkH3fFo7ke2IXS3A8PcNSxMLvwSSRjJjlDzcbs8I3Mri6SX6uPY5PgZXG8WyCN9bLO6Gcp7E3vKidXPMzk5NJAttPI2DwsTlO4rk/A/B6c9bjQ54KmTzEun+WY6ABnrab8Jb08edwbvKcMWDIE4FtlayTVHquP/3XOhNAH+/8UTeYMuzm5E2IoJmQYnpwjbgHCoggHE6zJDe4gcb2bSNJZQfY5m4tnC61kXtComlqTIz/YdwNc+GjSoTFTsHEzKl+Dmwa9eCVTKPMGt0TWKDVekN1+6MXkIgzCixcHki9AwEbQ4Zsmz2LwH/UttJMWPOghY3c75I8mPlvM753yPnHXoEsMHxRhLNP5dYdgYsBuQINFZqyljU+B4JHhWKAmlZFaOmeyzWPKC+PBlXcl8LQKomRXam85zPBXJtxXEOKCYyue5blrMu0f1erQibnCjjH6LDP4ueRDVWkKpUbsmk6OcQc1jHkWDwlS6Ket18K4S9pSDKFPVVpTNcWtky/ZjdcXRdT+P17GPXREImUT+vH2sN6oqS4+DK5S/0v6havGX2OYM4EBBgVPa31PiQe1NaVepOHfrpE9OW03RB9p2NgkNr+4IwaWoIfvCdXSvQknMb4lX/ZjOLt+3JqDTW9TBRsl0nC9cbU86JLhyW75IBjB8vf/I3+rU0mwnoe2HsseRfbMwm52e4vmOapJ/+GscUZX9tTyVyNKAYDeUOQpNFWomXsStfMalfeemLdtUeEGnd/eo+0hz8i1dawWP8xnd5zvtnTzvVGEmT8Fp4aPPQktPXOnRLYF3uqxjzA=',X'90711cde9ed8fc56dc855fb3741d03b5e8323035cd7db49bb7d3d47f58844eb3348bb40a283b4bde21d408623eb281efaed6c20bfa4174bfa9ef7fd0c612a56ddc8fd1de6109328a033e10ba5f46cd3f8d6231a0bf7331dbb3c68a1f2cc77baa8229eaf140369f54ea67ab8adf49b351b922fc05beea7cb8220bf0f648a7c0fe80b2221d38a2216fddb3ab564aa19ad6f63bbc9b22e57ceee10d84c2142296478e0ee0928ab480c2221d7b9ee6094f980144c65b80620530173b1dc212d929f09ad033a697c3b849d91f8418f82d649597c04e34adebc4ff7203b3c9c6b8eaa403a8a016a878ec343a45258913164d43371305fd5be1e0193b5fd7d376043a33',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('7585B1F6DEC878CC18B8D52AB0881052','C52',1,1,'aJrwLqIZE6BW9JoInlpqDd9/gxC3iFeYEqn233zJt5x72ORIKFxZGlp3PoFd/ZuvSVV7RTPnf+0b7hlhD6WGMRZhwjRkpPMl0bw73472QnrdgYYOUEeUHxNRaCxgWFX5h9QBfYVZzM7VToxPYBva2Zj2eIRM967FmDEA0Zh8vQ1sa1zP/b0ieCfijbGAjBikDl+NvTF1nQoylwYOCmfHBffDqQ7eO1x1gLcJ4w5xBa8PjqbP9cdGSW59bVoJ8mxaykqdDIx8SjxllMi5cYkSgE0HPxtEV2HP2pBbr1lxmb4ZPYz5wQSk4Amv/2tpxMFgpJJPOxDWmysIVHjqBsPmK1+41QsGYDVB4R+7G56I2ZC1WGRCR/JPyJuB6COv4OAKQyy0TNuWHLVZVUfEiQSK0NcI+gZqmBSQgGDustc1VIUxMoIs0equkGwemp+Iv5tX5/LTzfMiKSn/wOkmtpBOzIrNcxf7x8n8f+9gkCm/XSeqWW0eV+U8G4pf/zCWEQ87zxIpSMO3mr/n5hYQ7cQqMxHu4G73yOBrDI1zIRKAjGGBWJRTRV5+RUrik/X4gr3QONC3PA6+TP0xvmSFvTyascLvUGWKV+aEzy0mmwrRs9k9M2doud9904B2vibxp4pC3TA2LLn/27wL7NhxG+JtRSqa30EtG10DeDbNOnUIkp19pUP6sxOIuekXymtN/VyfsqvTlwxzsTvzCJCO+d18QhxrIF/aglAHyrJuOyUgJ//eJAJfkdI6agm0m9Dvz5NPsOq1QKGzyxApTCODGYNbA5vcDohYZY3/LYiKsc/hOJiHftfJ42FQVN91YsL/G1ecVjGf0H86hCxrCEtieEK3qmwRTFdV0ctS+X0cbQ1JW2brxBbYvwCh8hsG6OlokT1oqrzzNvji6j3GRdthVYeSGgV3vRSSSJ7Vr/BemdkVcv3mqWZwBbL3R/0hpOKsTVKtGabMvtmrw06BIBZ1wsbJLJRYbbwyFGsdPn3hbr5IXdNmbk/5/d20olVK4j23rTR+2y3mhdB6QdSyadtNXIn6WloZNViUpcE1EQPQVeasuSwJbYHbb1x3Mx+VPj6e3H94oRPYkNwDr2iTjhduSkeO2fVkhvaoC9xIK2C0kOGVCFWxfHkFk/E1frc2TrYLTUqn3uhZ09rXrN3p/v7800qZeytuKb1uGnTQKszysGw+V2oosS7/HDmDc7L04KRFfQz94kNvZuQG2ht0IEqUjC57/EqZhG7mQtc80pG2VY3hTOBRqM4po3OITXeCbG+YGthGDT1WvFICGeAa2N9E7ZJFiAEEdWdAhTKXK895Vt12+oPvCNw5YPIfOznmnfunoz0EtVpvrdGAH6S6ppMWjMnzBOHs5ZaENUZ3y0cclB1LP1xTem3da86Wttxd5GJ/jANHY0NpsRHHDa8FKMKo7/wB0JoOLJVEJqVVNrjaBI5AEUg5WsL0UYKXif2j5zBmsrPG5z5jCD4uytP+DA9mcYoF9bNr5PxjU3tKxWMYMpmTxF1H9CWt4LHWyhLeGaCDDbUpzOuIvk6cyKPJKcBPBOjfdj4puiwJ/cIJXaFmWMwhjTLijEHSduO1NBNdAJQB/FfyeeoiC2gDwwqAi5EY8m1gwDEl0HExm1MkJkhT4fNTfns=',X'38a18b429c29727703e0a564796a700410c308c1e9ac2e931f8a8830d2357146ae54ae0940d7ccf135e04f8f156d8e59aad72305c409afdef467645a38a0af2b39a3380591ca06a2d0e94d6a7e6d52b24342fe65fdc61382a3e10330e961b3255e3a6d09968d72cd82cc3acc5ee503dbc2e208b2f9b90dcef9fab0bea4bbfba13228b401ccd1ed3f3cb799101a9ed8bec90630faaa4899212b4ddf2945c512de4e6772d5d83dc343c6e2141a90b66f699d130695d480e831b86fe70f23b5ebdc5615472ee7ce11076967f33660408de7d1fb68e9fe3ee9cbd397e39143e1f303cc1ea0525c68463f9190079a80d01aa7377b30491292e2c2c1019008089e2acb',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'41453e8934144ef5bbd281c1a341fe52','10',1,0,1,'V1GYZXE262Q9CMW4MBYW24WJDFX4TZH9D5G9BZ0NV0YM73M80W50','payto://iban/SANDBOXX/DE546854?receiver-name=Exchange+Company',9);
INSERT INTO TalerWithdrawals VALUES(2,X'34ad38e870764c1bb14ea76b46439232','18',1,0,1,'6DHWMK9VNR61HNFSWZZZKKBNN6FG9W1TA0QK4245CJWB9NVMKEB0','payto://iban/SANDBOXX/DE546854?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$GSiOW2beQiU=$I2D+pyiMf9pZLHOT7CJJ2ijV8z7QhAXMOU0wVQbleOY=','Forty Two');
INSERT INTO DemobankCustomers VALUES(2,'fortythree','sha256-salted$qvzh+qEG3tE=$7wc7jUNKL6uBZp8s+Uj0Z95NwhZW0n7M+HjKCGR8YFc=','Forty Three');
INSERT INTO DemobankCustomers VALUES(3,'exchange','sha256-salted$as7tmR1r4Ww=$uWlrzhx0lg6lQlwYo1F905pr6kMH2BTdseExdtbyKsQ=','Exchange Company');
INSERT INTO DemobankCustomers VALUES(4,'tor','sha256-salted$SwCqqsrgrhU=$Dsoi8d9jVR7jvWH7I2VRc6uO6oFpGRwMEmgA3skoWm8=','Tor Project');
INSERT INTO DemobankCustomers VALUES(5,'gnunet','sha256-salted$0Q1o9z/PY4A=$1ZQah+7QyIHJ3qmNsEccJHHmAd/YIuOgq6tTm+ZF7sc=','GNUnet');
INSERT INTO DemobankCustomers VALUES(6,'tutorial','sha256-salted$/gd3nz/VNn0=$965qZ/B04oR5dZe43U+8fQhQZb57MHzhysHErXVMXaw=','Tutorial');
INSERT INTO DemobankCustomers VALUES(7,'survey','sha256-salted$JPxe+WHw7ms=$hv7VYQaNI4KFLSoMeQ3AWYkxKRAlFuvvcAJe4CUwDFg=','Survey');
INSERT INTO DemobankCustomers VALUES(8,'testuser-eql8x46y','sha256-salted$xPNqcKyTYDg=$e75X8rgvXRi1B+A0LM5AiSdrco92vkpJfmo0UlEWCwY=',NULL);
INSERT INTO DemobankCustomers VALUES(9,'testuser-qsgidrbb','sha256-salted$8TDMGgpMJ34=$HPkLCiAxBiFfA5z4ZQeTpk74T6U7N3iZFiuaja5lADw=',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)),1660251795,1660251793);
INSERT INTO NexusScheduledTasks VALUES(2,'bank-account','exchange-nexus','exchange-history','fetch','* * *',replace('{\n "rangeType" : "latest",\n "level" : "report"\n}','\n',char(10)),1660251795,1660251793);
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$4BgMZjUx4pQ=$RZs3vkmmpEhay+7SeM6iaUyLoqBpT7QZPTXA+4zyLak=',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','DE546854','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:0I6W616I',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-11Z",\n "bookingDate" : "2022-08-11Z",\n "accountServicerRef" : "0I6W616I",\n "batches" : [ {\n "batchTransactions" : [ {\n "amount" : "TESTKUDOS:10",\n "creditDebitIndicator" : "CRDT",\n "details" : {\n "debtor" : {\n "name" : "Name unknown"\n },\n "debtorAccount" : {\n "iban" : "DE687184"\n },\n "debtorAgent" : {\n "bic" : "SANDBOXX"\n },\n "endToEndId" : "NOTPROVIDED",\n "paymentInformationId" : "NOTPROVIDED",\n "unstructuredRemittanceInformation" : "V1GYZXE262Q9CMW4MBYW24WJDFX4TZH9D5G9BZ0NV0YM73M80W50"\n }\n } ]\n } ]\n}','\n',char(10)));
INSERT INTO NexusBankTransactions VALUES(2,'AcctSvcrRef:TKXY6UEK',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-11Z",\n "bookingDate" : "2022-08-11Z",\n "accountServicerRef" : "TKXY6UEK",\n "batches" : [ {\n "batchTransactions" : [ {\n "amount" : "TESTKUDOS:18",\n "creditDebitIndicator" : "CRDT",\n "details" : {\n "debtor" : {\n "name" : "Name unknown"\n },\n "debtorAccount" : {\n "iban" : "DE871507"\n },\n "debtorAgent" : {\n "bic" : "SANDBOXX"\n },\n "endToEndId" : "NOTPROVIDED",\n "paymentInformationId" : "NOTPROVIDED",\n "unstructuredRemittanceInformation" : "6DHWMK9VNR61HNFSWZZZKKBNN6FG9W1TA0QK4245CJWB9NVMKEB0"\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'308204be020100300d06092a864886f70d0101010500048204a8308204a40201000282010100adebb8232ffe4ece51c1a65c374a20c6004219b8db8d1233341b41ec906ee63dad98eee2f8c38bae21ed04072b5019f2b000aca7ddb185b8a0635d9c54bd77dac31404a900609e4006af945d3016f027a8d5c05f9ed005142d4f23d4bae53fcce4e5915dd572bfcd0888c6bb4282906fd322c9114079ab00be9831a43d437be25773e0eaeb169aedc63d685f3fa5b0e20f2ff4f9a5190890749d44112488c44e8611c177743e4d6a8d8f3396af843bd3daf46a2d952070285172957514d60ec3020b93f6c462adb16cc198a797c687dc2702d659264ce4b0ae80f8f78fe1352cdd69ba4cff1ea36afa9ad9eee9478e240f2fa590410ff7118059db35077a6baf020301000102820101008b338d4fec8bd8bb5dc866c48c2432930785e05c8aad209206f482113b90e78b1a34bb8ec2989065b115a911abe312c1a18908a7dad2c93a7a74cd69e0913d2ac4d472de6944eba44735a4c3e94792b3cb7839dece97a458ffe2c5c4f049a884eff7a61fba457baa39586fe75556771069a6ffd3650d7c86be05c645b41b1d3d37e5e1e459ca47caa1a4d4c62a5329864ca69fb2f58478371da2f7dfad3ba675086aedf5b0211f9096ef709d54d79b26f655fdc74a632193258810ac6c8f6eaf4b801498aba8b58387f99fd9263f4bae05e97e36a69c47090ec3730cbdb8ff3a891d352872bd9b28cd2d62c60d8b1cdbd236c4820daa7148d8b1c67b9df60af102818100f6b29e1b3c442701df89eef088338909b1aaeea913e8fc73accb78c94dabe16e61a59443fe8b32003d70ab1347302e3fb7ad203b04e388adf75a0ea1d9c8036fbe22cc837f025668262ea28ed87551e55448b7aa9d1f9828cbd290144b77c1c12896156da0bd2de51198721731e37ada0787a0ef5aed2161284c8240188016d302818100b47a95453ec0f418fd5bdbb0e16e54810b0b84d4057df35c582eeceee46c8f159940591f4892255a72f2360797be0c0b1dc7460e7099c5193c29b1f4cfe16942cc344a09c38a17aecd3872f46aab11ff99a83f395a10ef76ab0d1ef79ff1040cfe8d64ad32ae44b2689cf862a1e6c334b7702719a190270cb8b62d361368463502818024c7ceb0cad472686216a38c331253ed21131610194ad450bec37b57afffdf5560b39a1e651605b76971a1dff6ee250714f077ecb4b6e3cae4250627755bcfbf5a3ebff51efb8f3c69ecec0996162fc69c415738d5c23f225df91fc816d45d0bda6c3df7a14e734842ce52bc4890dce122dc42cf4ce42be4db6844c71fa0014702818100850ca1a2acc29eb11586748d0f83c0b4692a12c0235458e648f43f23562e59c5787721bc984975541acd48db8c1844d4a51d551e2c1090672c1d28ddebaaa768e115e347136a684f2b6764079fe3819f46edebbe2211be1763be8687d2d7613f1b21ad88a986238acae87d8c6902b001db01c9317213cd55e98e14027b8831c90281802acefc279660aaa8d727730ef5e34ba99e64ec063e748370eef59a1bccc407f14e30ab7ab908b7e449301e72a0ed51cf8ead87de232d544cb9a61fa67f6db2814e232e4a5e10dea2d09511d22a4bb03ac0eb5c76484628c88fc6d881c3f6999fe82de72be788327d194ca69f189506f17fb4a401a613aba6a210af80cccebfb2',X'308204be020100300d06092a864886f70d0101010500048204a8308204a4020100028201010096f42ff3697c7a030140e705b1060365690cb42ca1763d2d6326ee7f0c8a04d8f0e0d651144df51f965864e7b32328756f92b599e3a97457f3b4c22f1e2332443c35f9145495cf581076054ff9f5e4214eef6756d410262164f67c09c502c6a98b3bc3ac36625d885a85f55c92fdb39272c5beb4e5c2ee9ede9dfcd42cf5fa1d67b5e7f3d5e7e50a4bb6d4e7242b6a5dba075ff8e90786fc06ee304cd20a728891df2e9cc006c22343dd53cc3992e6134bc566f9472451d54b595e49f737fb61a55e0269b3ecbf4789f990d8212de2774d1843047d873261ac8c1aadaf55bb6fedceb70cd35f8bd2504bd04d972b479b6bf092391d67099f8a23f070a3ebe5f102030100010282010002150c3447583836a265caca014f1bece22e12ae2aebfe9c09aa17d018d42e8cef85aa6f23e08f690821e002722e21f8bcb941580613e84eee45a8080e5a5def23057b9214389ccb922e8e9433d678771d27a03d4a5f8ea717456f20935f1e6e684542c5b55a55fff37fb58ab95c5685c69f83a9eb216d3933c8ea1be322e17850da0aa623bd585287b514e45eecf8af66d2e760310b811753ce1ff117d03baa70738e802381601495339e458a7d319e9d2549ebdae8cc052a6adf21178ca13c6c952e1859887894a443381da1ba38fe698cb3f3b26cb1b803923dc9f67eec2f19399fb5d74e5792d48d9a780935380fc02eaa2d19112e6209dc7030f5c791a102818100ec3eb87d4f093dab81bbd853c2fa8464450448a7925be41fec807783e7281494a8eab5982df77f3f061db53e8fb2e995dfb668f4a2198d569d31394b4589e823a571d3e79e7981df77fec072460241d1d3f7f6b4b4e0e0e9a6733c30222c5fdb6beee820207e675593920444752a0c2e7fdfae360dca54d5d2b01ad268aa8e9302818100a393a5378cadeda2bec34ffcc6c1ffec00d1c29e3ef80ecd1fae5c1f1349981941e06151076fa96aacb34eeedd34e949aa6314595d7e9c4b043c188b8747e7e6436ed2529d259d5fe6f992fd1f2d1f5575fa7e0a037109e7ccd240fb348e8bb7392c91e87242e030ceba12ef2bd818092bf2c57ebe8abcf029287e0038d707eb0281805b3d72053b64274438cbb2a5cef4eff2c5d0fcba7345381ab83d796b20f892d24356baa1b68712c6e576cdcc06b5a38f35a27e7094b667a6def8e6d6d2598ba550bd6088e0e4aeaafeee0da754b0847924736cfda7a9fe535eecbc7f1e83a2d5dc9e9d59e312ce97f7717a627219b630b3445145211856a16a48876361f7152f028181008720c1fc68a789c6c6a5dc1eea267aff0012481ea7d00d922018ce9b1138db8009ee8d15fdf99d4fb5490eecbe2a2689a74ae0158ee9b7bd34cb5c4f6f3ad47460c25cd6c860b967ef0bbf04814baa35d41751257e8053f97c37385d0ca6b0fe7429c082f0591490dd45d3bc6650c652554ee11d79d46c8e4cc1d98cdf67ab6f028181008b3d68e7dad91fa85cd0844c7293ba8afebeefef2c83aad45464f1c3301e53fdbdbd8c05fe2380911b1b5bb910cce75689bc9a684c0e4b9c94c7c72ca293d97b6506ec1fef0c7ca16b0d42c390206319c302117f9026f99b636977d98bb36963cf49107c22b1a07aa5e7e8fa8558cd854f93425d6e19642354151c1d049997ba',X'308204be020100300d06092a864886f70d0101010500048204a8308204a40201000282010100937fbca30748f24ccfb1dde9cca6611f2c9df47546ab506176654fd858c8d0090a56c8be6af7b7681a1270172453435449c977099f881a0f0ffff68164166416cd15c7af6b977aebff6f7ca287eabed7d62c3c11089ce5315404c05c4eba61e3a354b1824bda85916db3f7a28f92767fddc2db43f02bdcd86d97aec3390263f774ed3ce828f40dddcbb5bc944b906c94ba8721f89853a8013cd06fce7f37666bdf88b759b38ba4842ed5cdd33b32964ced03149b4b6e13213a434946f4b4e4a444fd9681a61709ef013fa0f1b9d67f23278c709ac81bd9ad7a7ef410f7a1a9a818bd76119c1676cddef0296d7c069ea9cc4279cb24c7d2e3264ba7708ecef1dd02030100010282010100813423c9ab57fae7ce07c09c4ce871ab1d2a40397aee163b49baf5764e4f99ec516233f6993ce52c0baa9b05aa8c452e50746a11c3ed34e67cdd7ad15d1b4011b9149b16cee8a28497fcd0f08e9ed30dbe4e814f6a7c05487090b8f02306a1390699e9e4790db272f1e5f3c6327dd9cfa832485ffac27172248dfa488867cfa85fac7962a53d0ca4ee465e02491a1a0602e62417c6ec1b0d38d3725c6d39e5d2794ba9f70f97c20f27cd7edcf301c1bba19631ea61a0d0b6144d6493becd019bebe5ead479a43ede491e85c06842b986ee872c86ec6e73805099cba7fb083a8e3f87bb34124a4eede13126f7cd387e2a5485499cc0433c9bd70b1e20c8f6600102818100cc0c8c4fbbdcd4ad23253ec5bdb188297d9aa922d2d31146e02714e25d692af78a537f23e39dab3299552b9aa3e73fa5877c79eb9241a2aee596e671264582e2e73594cfa581b7a8dff6b86acacde9c2dcf712efe1317cc6059929ce51b2c9c386c2a8e209ee2b6c28e793431a87c9ebbeef8fb38ec2217e61dd8e78afa3f5bd02818100b90d629d6d3c1a373ec6605f5c5ee0d9d7b25ce023aa63f51099c04f4f157f09bdd0515018ecc0ec14f2558bb4448a096a4c4bea246eb644378c2b090515c408cc38a2f80c0815792e244fb3d231d0b205746cbb0eeb13a25f60625e4d3ed4f294bc52c50ee1f06011cae79b2a32dd6f3311b5b681e6e257d63c7ca936ae5ea10281805a59b80b5a38e7271ee7d00ac8fb023ab4f635ac48c3d2e39a3f53dd03d59c83ed891943eff691a69f047a8147d00e7ba22978e6d9651cbeeac44d978e85baf5f3c0e2faaae36c4a67991c8194f96667b565e5c9b7e22cc8961402d1eb950a07fcf4d6c8f7f2b0e17c9f45b2b1ddac88298c7409e2cd8cfd2422718278eb55d50281802a37528305938b8b84e7aebeb28cf690dbf355dad06823cb9990e9dd6df642780f7481c85b174fdfcbdb8906890685d3260be7d9af9c0e3abbcd5f57fc6ffdbbe0131fa2a4e4073a10fbb9af1549c60986d30ba714fd2e0a81e5b42b3d461340900bf27a002e2d2f4d7fd39c8360fd414c0e433d329f608d97534f412f37526102818100956c2744eff53e1ef0854b84bd9037b92bf4da13d594cca95517ebd15666386f828334bae001fee218ebbbda496fa3854a7cdf220498dbc52a2a4f7794e4e23c4b0502cd1b32bc2799a929560cdd15391056930dc3a6da693aabf5fe702725544762c6ecd0b1c204b15702233dbd91d3b56bb33fc81481abbf4c0ecff52d5030',X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100bf9f496026bdb5f879db509bbc5110a233b39b73f62646ec961226fb2375d25f89e744d7df6e259744fb8f36d70e22bad8e0a7203151813359759c028843328c5e87e8b480566ed95e56bd91b5d09503fe019b0f719db801d2cc4585f031461cc56ac9dd1dbd570fc87b8344dc578919343696a645f4ded449dbedec483b54ece29eac39fbef30aad2fd012151093fc958bdab1c34fb53acd62421cc13dfb828973f654500f43876dd1b3c622dd07d28ea7502a2f7b428a1a04cf6fd7905db893994a1af3ce6997010286cb1b04b9abe6145573913889ca15038176e7bad9ccc6eb285cd85d7f11092c39cec340f48e46287f251c9383adaeaa0f6db08096b750203010001',X'30820122300d06092a864886f70d01010105000382010f003082010a02820101008c902f9333ebc3535389a793d6224f1c8882955ada65fd516e2fda399227a7f45f7bc50854939c0a00ad06774ad44f69fd4709d002655381607b69487a57763d5539a603f3a5c9577f1c1872e13f1e6c4305b4e1aa4b7fc77b97cea20f4e85771ba30f50a1b6a0fb50683360168d7fdca2900fe7cbe5f593ba14f63834a173ae2857255674934c5523eb361adc143c391c7ac7190627407a9f5ec1044db1fa29c921465a5a9e75f1852b89414e7972e8eeb5ff26ad1f5e6de7c9fe64acb98ee162c72bf85804a3847f0467083c99916ac4d0d7b78f4602be0325274f43f3dffc84e02fa76b99575bb1ddf4fb7d8c2123eb314086e690019e61770b8dff1c64ab0203010001',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,'V1GYZXE262Q9CMW4MBYW24WJDFX4TZH9D5G9BZ0NV0YM73M80W50',1660251774341,'payto://iban/SANDBOXX/DE687184?receiver-name=Name+unknown');
INSERT INTO TalerIncomingPayments VALUES(2,2,'6DHWMK9VNR61HNFSWZZZKKBNN6FG9W1TA0QK4245CJWB9NVMKEB0',1660251783142,'payto://iban/SANDBOXX/DE871507?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-1660251762836','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313736323833363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a34322e3833363538345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a34322e3833363538345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(2,1,'sandbox-1660251765211','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313736353231313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a34352e32313131325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a34352e32313131325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(3,1,'sandbox-1660251767456','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313736373435363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a34372e3435363431375a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a34372e3435363431375a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(4,1,'sandbox-1660251769685','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313736393638353c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a34392e3638353338355a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a34392e3638353338355a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(5,1,'sandbox-1660251771886','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313737313838363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a35312e3838363637365a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a35312e3838363637365a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(6,1,'sandbox-1660251774087','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313737343038373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a35342e3038373235325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a35342e3038373235325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e30493657363136493c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453638373138343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e563147595a58453236325139434d57344d4259573234574a44465834545a483944354739425a304e5630594d37334d38305735303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(7,1,'sandbox-1660251776440','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313737363434303c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a35362e3434303736395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a35362e3434303736395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e30493657363136493c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453638373138343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e563147595a58453236325139434d57344d4259573234574a44465834545a483944354739425a304e5630594d37334d38305735303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(8,1,'sandbox-1660251778642','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313737383634323c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a35382e3634323832315a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30323a35382e3634323832315a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e30493657363136493c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453638373138343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e563147595a58453236325139434d57344d4259573234574a44465834545a483944354739425a304e5630594d37334d38305735303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(9,1,'sandbox-1660251780820','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313738303832303c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a30302e3832303337385a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a30302e3832303337385a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e30493657363136493c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453638373138343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e563147595a58453236325139434d57344d4259573234574a44465834545a483944354739425a304e5630594d37334d38305735303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(10,1,'sandbox-1660251782983','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313738323938333c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a30322e3938333237335a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a30322e3938333237335a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e30493657363136493c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453638373138343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e563147595a58453236325139434d57344d4259573234574a44465834545a483944354739425a304e5630594d37334d38305735303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e544b58593655454b3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453837313530373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e364448574d4b39564e523631484e4653575a5a5a4b4b424e4e364647395731544130514b34323435434a5742394e564d4b4542303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(11,1,'sandbox-1660251785229','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313738353232393c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a30352e3232393734335a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a30352e3232393734335a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e30493657363136493c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453638373138343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e563147595a58453236325139434d57344d4259573234574a44465834545a483944354739425a304e5630594d37334d38305735303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e544b58593655454b3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453837313530373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e364448574d4b39564e523631484e4653575a5a5a4b4b424e4e364647395731544130514b34323435434a5742394e564d4b4542303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(12,1,'sandbox-1660251787405','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313738373430353c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a30372e3430353134385a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a30372e3430353134385a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e30493657363136493c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453638373138343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e563147595a58453236325139434d57344d4259573234574a44465834545a483944354739425a304e5630594d37334d38305735303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e544b58593655454b3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453837313530373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e364448574d4b39564e523631484e4653575a5a5a4b4b424e4e364647395731544130514b34323435434a5742394e564d4b4542303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(13,1,'sandbox-1660251789573','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313738393537333c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a30392e3537333232315a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a30392e3537333232315a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e30493657363136493c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453638373138343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e563147595a58453236325139434d57344d4259573234574a44465834545a483944354739425a304e5630594d37334d38305735303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e544b58593655454b3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453837313530373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e364448574d4b39564e523631484e4653575a5a5a4b4b424e4e364647395731544130514b34323435434a5742394e564d4b4542303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(14,1,'sandbox-1660251791722','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313739313732323c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a31312e37323234345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a31312e37323234345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e30493657363136493c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453638373138343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e563147595a58453236325139434d57344d4259573234574a44465834545a483944354739425a304e5630594d37334d38305735303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e544b58593655454b3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453837313530373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e364448574d4b39564e523631484e4653575a5a5a4b4b424e4e364647395731544130514b34323435434a5742394e564d4b4542303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(15,1,'sandbox-1660251793886','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303235313739333838363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a31332e3838363733345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31315432313a30333a31332e3838363733345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453534363835343c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e30493657363136493c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453638373138343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e563147595a58453236325139434d57344d4259573234574a44465834545a483944354739425a304e5630594d37334d38305735303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31315a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e544b58593655454b3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453837313530373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e364448574d4b39564e523631484e4653575a5a5a4b4b424e4e364647395731544130514b34323435434a5742394e564d4b4542303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',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,'DE546854','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;
|
