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/DE128580?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'30820122300d06092a864886f70d01010105000382010f003082010a0282010100a98f234b85e2320ecfc524a1fdf1f3a8e6cbff6b069257991cb796c0386b852aa33a4c955bbbe2e3421d3536a1b46e1ad9c1c46c5c014a1a83d7decee56eacb1e804d1d815d2fc6bfba3ab3b460e16c0e3b6594617741aebbd473c026a37d8f4b02df6b4d71aa75c6ece639a3eb0bb93bcfe484f1d9e8f9dbbb297d5aeb089bf3cbf80d5cca1c0e4c9d9ffaffe5729ec01d5ee6d791162ad5f323eb96a5a6d9161b0246951dbeaac266028ec6dc144a230800dc967d31113be554b557be387a7f5b1609b303be30a88d73761e5001fee3a1832d6498da922163bca7fe95c895b3b0708ff5e5737a88ceffcfab66edff1611e678738bb960ec4c8ee993853a0750203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(2,X'30820122300d06092a864886f70d01010105000382010f003082010a028201010090c82c95aae10562d7269f018edee306f3d8f3c4cd2c18f89bdfeb783bea6b14d50aeeebafd8506271321c02f523dace71bdf58906dd97abaa8f05bb9116894ff3e64e64df09503e91dab2df48dca92de0ea4f81e6fb53b6640d6a64525c70d2d88b8955d30e1427716e26e5c18a8e4826182132a434023b55d13923479e9839568de1a7f95ace5099ce7bd1b63b289cc7a3def9175be076d09bef2c651468f74fe4b19d1945bd409caa4eddb25c5aa641a8e453afdcec65141bb7e842f29b54fc09e4bc1d8e9529e82873758e3d6b204106abd0fbf7e8eac46a91aa4074d5fae692865f5e207952f117312dfdeed8c456c792ab1d3f14173abba748ff0118df0203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(3,X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100ae4f264677fc794dbe46de647d84568539d13db85d7ccfcec725a119a9070fe4a3c76977db90268b8c332e3479bf477cf3b9fb3845471834c16bfa87cdf634acfe37ca367954dc6bd33718aa4bb4f569878581ebd9bf27e50e6009deb000ac71d4b1dcb09aedb1b540d795d618cc97f7c95da1bc1b5bf2f0b3b1eae7ce12b1a1353eb7385e452d40ea9b4e31d31113a90fa711d6ff2db7e890999fcaf535d3dfdf48bc6b90bb6f21be639ae52e4c2f7642a148b69da432ea4e2d0237a635f85950b284246a599862ccdf170fec27537644eb3c1ba3cc4e67ed7c3d580ff9e96fd45743580ab908d62740f502ce925d9fa84706aa0375f7a44172fe09e38b0a2f0203010001',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,'DE128580','SANDBOXX','Exchange Company','DE540064','SANDBOXX','Name unknown','5NQK42ECTG8T6QPC8SGQ8RKA2SJRZH173F7FQH5MVNES0QCA0Z2G','10','TESTKUDOS',1660491054555,'YA3Z6HGA',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(2,'DE128580','SANDBOXX','Exchange Company','DE540064','SANDBOXX','Name unknown','5NQK42ECTG8T6QPC8SGQ8RKA2SJRZH173F7FQH5MVNES0QCA0Z2G','10','TESTKUDOS',1660491054555,'YA3Z6HGA',NULL,'DBIT',9,1);
INSERT INTO BankAccountTransactions VALUES(3,'DE128580','SANDBOXX','Exchange Company','DE960957','SANDBOXX','Name unknown','KQJQ0AB6CCX894AD76K0RPE9KDJSQFX8KA2G4R53HF59N3JKJWB0','18','TESTKUDOS',1660491061966,'9FJHVCIE',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(4,'DE128580','SANDBOXX','Exchange Company','DE960957','SANDBOXX','Name unknown','KQJQ0AB6CCX894AD76K0RPE9KDJSQFX8KA2G4R53HF59N3JKJWB0','18','TESTKUDOS',1660491061966,'9FJHVCIE',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,'DE618765','SANDBOXX','bank','bank',0,1,NULL);
INSERT INTO BankAccounts VALUES(2,'DE369215','SANDBOXX','fortytwo','fortytwo',0,1,NULL);
INSERT INTO BankAccounts VALUES(3,'DE145731','SANDBOXX','fortythree','fortythree',0,1,NULL);
INSERT INTO BankAccounts VALUES(4,'DE128580','SANDBOXX','exchange','exchange',0,1,3);
INSERT INTO BankAccounts VALUES(5,'DE242350','SANDBOXX','tor','tor',0,1,NULL);
INSERT INTO BankAccounts VALUES(6,'DE784482','SANDBOXX','gnunet','gnunet',0,1,NULL);
INSERT INTO BankAccounts VALUES(7,'DE035541','SANDBOXX','tutorial','tutorial',0,1,NULL);
INSERT INTO BankAccounts VALUES(8,'DE650933','SANDBOXX','survey','survey',0,1,NULL);
INSERT INTO BankAccounts VALUES(9,'DE540064','SANDBOXX','testuser-xiu50hyl','testuser-xiu50hyl',0,1,2);
INSERT INTO BankAccounts VALUES(10,'DE960957','SANDBOXX','testuser-3kgqcvv0','testuser-3kgqcvv0',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'308204bf020100300d06092a864886f70d0101010500048204a9308204a50201000282010100cdcbd9937b06c0447315e8026af679cf7627239b0b71bdbad87d27e7858254ad6309f0d365e6d254d2b4872bb3caec6144a495f7dd8eb5b64d59350db657c81cf589f7e728535cbac0f80ef355601ad13831cc5695a575f3cb514a6857355311207c54b9e0ebfb4f5c89d3544fbbafdfc420d746b1ea597ba9455c20e3de111b0992b42e63f57e60d38bc83aedc3d3f061dab3705a6570f87ce6977db237c07c999867897a2a66d6f657b5b94eb2cb7db6cddee97ffea5ef16058d8dddd402ee9da55a0e37014ab1a183a6b4f237418c33cd6c24c03f50e0c65061bf9c5d4285b05fef50f9231c6677ff67916497a7df51c3bea38c0fa0c05e41d0b248503ead020301000102820101008d7529c16e375dc1af39c798a1dd7a2d5891deaf9c563a8c4c72fb12f17a7caa1201ab4024335d3061052644abf9383243f4be00fa9235e57195781a4cd45a014de5e0394c46c0debdf5c4910e8658e8a72fd3bd506fc37c28ad5ff008c1e6af471d2f3ff5933fd3755067aaf4839688c14fb1aa2e715fc0d8c18c6a2f375d99741db197509c72fc8d5dccc4840f2aa2ad34074feff8aeb291a13f261f94ad90d69948ef7c1ffd67ad920c0c606fe2860a3e7b1186967d672d267540dc5d91ae3ad7a443fa5093aad71dba5414bbfc8a3254b2536c93ddd25240df0e625e959df966605c1b34fb072decc05eee151af3fbaf7df1e8028d0e95c52b317e91310102818100f2758e1390eceeabc106da3519b6f094a842c5ed102debef8eefd5f0b59b58ad56331f65479325df7bf2b8371574c951fd8dc47d3406f9f50a798794fa67415b33ee4c06ebafac7c083ee72e228ef2d99008f830bee5432c0d3fcb2dbcf543634feab744cf293de17a562955664edc5fb523fbba846443687903c8e959c60fd902818100d94a1fd912a8e33769628c43d5aa83b1c96058c8371e7a3240d210346328a0e11b3d758dde9432f7532683f35ac4f85cd775151a974c871eac683b07ed63db493cdb055316a5b09a3110a3c8bcbe9f5038358997b8ef10fd5387543e7c738b50a9cf50db228f395485b5588949dda2365574900797ab6d3fb17c0933ab0334f5028181008e3086abced844781171955282cc1876f5de82f8adfe605953382ffd4463e0337753efdb93882633d41ada11e3d163a763cd5a281af4e46de240b754952d2cd4f1b5947c9287a9ddeb70085fb400a54716034c9a39b976154587ddfdeacce34240c1e3ccc4b8e9036c9d4f0c383d935bc57d5ec9598efb412f871ab24ee5aab102818100a8d2bdb1e39c92854ffd006c080ba6acb0808a1a6d30e1d23fa8b66c6d8a788ccda44fbc7d6df9b74dc4840ac4c07b136f5789a11262a42d01d92ddc37e638cf4b5804680d1589041411109ffb7dc3bc0920179a69565d85e5ab249a340975f9a325ef7583017292a81c4100d202407124ae1ee5b742baec1cd2f9374aac802d0281804a0dcab0cec39be3ccb110a6d3d31c20db46e44a0802ded3123977a8c68da1aa81334c347fe580cacf01539c586c4c8c4a8f3c9503f5e5f9e0583ef900aca29e15fe1976476b4ecba0ca6b218cfaeff424fc0c6e28ed8e465e81c722c9d7e702e0f1871d9d9c0652cb74818eb9611263d99caf2eee3b28132700cf5ae44314f8',X'308204bd020100300d06092a864886f70d0101010500048204a7308204a3020100028201010085919c125c14de88e60286224002b448696bbfd9192169490f5a062a94e6a8cfe513f482631057a34c7872638c2b842ec0357f9964b2e34dd845b5d50ace627e57cbc115d2cd517ed8c5cdd4956e2092d24e7134b0928d5fccf43d38df49f2d3ffef1b0ef9dc98b68fd3c4e3fb025a8a1849bf8bc5e75c782393d4f840f6238f972a6a2b4276da780b47581bbc79300b6560ea6bd9b6247caad729fb906c78ff50bdb29ffcd357adf30833173620011c7534e7c14e434106403b996f381fc0f9c64a126dce7b6db7a9fadfdf614d97d15fed69a6e7a74163740a0e6012f96a5c343f02338fd38993d086e63e25f00076852ea4d0eefb405df240984a12c9e02b020301000102820100798f7cc864cf857c784121cc780f3dfe8d1b483e10160d5935c48bca233c0db52f5a4af483ae32e466cb53e7ef81074af9197768a671fc573396b6170f3fa7fa2e733ce65cb50a0f74c00945093e721ccd942089808dd066b9042bd7dfb7d06d4b0754cbfb70ddf780cc8deba2dd90830ff9c67f31fd0f763382ee97859fbdda33292a59c41ef33f6f5d5f2a517a82beb240525b725b5bf35e995c9bdf8e78bcbd55e60013f3352e56d5db0a431b8b017e10116472d93759daa5e17b97b6ed2dd59aaec8cd38ca67fb57f9a92c0f2032ccd071694ab67c8c76fd8af31ad4c8320473a4421837104c61c9216b2f6e69e32d65b7b665becb5f53b4f4070bf2697102818100d8f02d549abba57647eb57e6119b5ba3a91267c49269070d6edd8a2dea32eb8994d720e7c09a87bf454373b2c91155b7bc8d8f762de3aa27d18f87369771ab2a3c48b45101884e7d84a34fae8fc031a26acbee7dc699c9c73e79b2af98425e5d4efe19eca384c45de7a22ba15b7fac085cf7f429d61ba281eafe17fbe2be9563028181009d9e7f7d7e82f426f5b4c224ba6bf3a7a2c3b954bc1d63e600789a9e14668a6b9309997e2128c4983b785976c2d4a853103f7ab6ad07ac9737eb6200006bb9e14bd87208bf80082e03668e2e6ef1fb85900d3c068c25105902aa10466b4e985b047e1d05f822ccdeb86f1410f5d9b5065fb2935cfad986942dcd2098c4428899028181009716cfbb78f8efc86d568fa580e5bef14133bc69bfbebe56b0bc431caf5c3f8756ce6df07ac8257b2576510257df66dfccc69b0027fdc3e86f9f930086817840b633bcc21e5b1caf76cd771590b0bee0eb9894c5aca8374c394af11432eb2665be3a633bd8b7033c93b2f2c832bdbcc72658db08b8420ef08505eb1657597d190281803aa9eb398204ab6a74b8ba298158fc6ec01da8b4e8eee7678b7557d6ce30fc03ddce0cdaecec877f416321a91a0a9c3b8e28923bbb5ac7d9e06e33235d04bb4227407ff0d1958d75d2be30dd075df90754fe180137d7f3a5ad602e7e8721d182cec1417c1f469489b08b672488dc668be0c24e26a516a10835a3cb2610a5d2c102818036d0fc2fbd0d6bd9a4227e57ce4ee5d4d626b420206072db6d1bdd5bd1c35d3ad86d55363933d3a09796a5701a846fc18ce4fe785e84fb29d249aea4457b0ea1dc42206513221e4e54192c90c0765fb824a1f1041963768c2d5afe8330d64085f4c5e60a3dcf22a564b13c2f38f1df4c68998c5471cd6a86c2ffa308b1cb8163',X'308204bd020100300d06092a864886f70d0101010500048204a7308204a30201000282010100be91b409c2b3f590dd32368c0da9444d61dbbc92d99a64bfa1e427e964672eee4bdcdaf110395aef20f7a5b756bad1be016b24a7e764a7a2816cb84e9228224dd49e41a031812d4b7bedc9f5bb24e0cb0b7a13c3b29f05ab3e8ac382f866bb101600a9776a279c10492f9e7530b3aa4ba2ea352b1bfa113504685dac91ed5356ece317cc3c1539ae85f7afdf0d098bb7d5cbb8540fad57cb7fc34b789831b6d47842b72c5e3887dd9a281aa9123504ac9e5da4d742eb943a70a4e6f1387e642027b60aa8317df205f8afb7f7d5d3ff3ed7dd2a079138090998ca5b124caf956e4841fa53d4b5495c9348b76c4c8c252921f16c725076c1de60b6c09af4ddac0f0203010001028201007b419a04c61dc7328f1eaf111eb4e02c7ca2b6f0f4355bfc66253f7b41294bbd6cebc7e02af22dd284ac284ed095bc9afc27e46984cc217085ed5fb7d1e88b6773a17828b85c2883ae003aa3e90b0d29c69e8ab20491be04e84aaff1c1e010157365b2363e3ea83e1057f05133d2c0ce72ecb0bed53584739a0a36ac2b2628c3ee72a0c5f1d3f377369431db64013cffd8a4495c3720c7a5a532e991d76603f8127c615a44b95f9ed0410a6cbf24040ccc67bede9ceb8ee48a8c8542711d18331c652514649365edeb06d411bbef3cdb0fa596ce36b927e98686e71e790762bb163a6b1241c7e34510aa2d7d9b3a25ad9f85b5f15870b036ae1e55e9ddf0276102818100ddd2654fdf0bed0cb81848155ad81162048c567fa5eecd126cad9cacd6514414f35b982fa93c74d2af461f26c1e58a4ee07be9011e2ddeb6e22542bd77c0854ee735c71f7265bd1eb32452efbf73f1399e15d95da23f69b1117438edbb8e2b530c48cf42ecffe4efd301cead75b824449c3e2ba9167b9bbb5dbd875f79a941cd02818100dbee9125047034241f81617606c40fac0cfd2d803e917eb9dddc9afb64001f76b159b3cea652b3bd33e3709d7b54b372335b9707ab11c14d62dcfcfcff3d9bd9ccdb2f4e08768714899ddb4dffffce2e82209033305260789870054417887f471f87cfe3f76c1d8a45b479d07223d6e86787fa46722f15917ec6a9403163f94b028180652f5f4592e236ccd1814a086bbb1a1ad3264d22c7476a46584acda84dcf1e364c5860d084eb6e02d92f2c709a8c218e1f7a866c1b1f2373db2ed205e9856989f7902177e7d01ef7cd11e9bf315f2b0f745c551e102fcaff998da1965832def2702d1a565613d893c9760e983395befd892416f877a804fef020cf8aaecd95950281804b3f81cbaf8c105af7a895c703239bd51b1098bbd32c86b66351727966ca9ff9454ed2b576b4bf28921354599d73ea7dbd52ae0702a1ed8863b6069d2d5b4ff2a223b038bbae8a231dbeb3e5291cc5d7a5d02c6647373828aac75115ee1356b0e7f9d8c83fc46f0afb3477a539184814762fd112bf489ad19015ba9ceb0930a702818100813d272dda03fb89d7630e69dc811acc48994a5c0b2e53bbc35c432183d58ad25cf979f7e7196e426b44d42b36c089db0e9b3a2279dec6e8cbe4ec4363ff8881b44b6921c03ce795be821514eb59d9d8e8bd73fb4951e5c15a90536afec5a8a0a5ae5dfc7fc9df17584a8abad5ef3f7747815cf57cbb89373dd871726a49c24a');
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('944E4E6D470D9BC402925EB7F7C1DE7B','HTD',1,1,'TRQCF4hDYcc/v669Tgq2f6Xdq+oQxnwCpFdX3wsTZgy43U12eiu5VQRX1rsWV3xXxPV0/YGxAOa4lo0tMdtvOcBI0h0s6kNwcjSrZ5duJadiD135Jaw01qOYn//IN9BtDgoQ4x8yayd526WEZNghLgQ63gR8e9ejjo801idAKO2dgfNdlOfBLpSHyfrzJ31D1WJFs1yMl2mSiDkJJXYhPz3sAimDbCzIHUhcr+2Xoao0qaVXfhdxlAEss1tBTb0qTLnHka5ilajYDdnnRgk65VXUIgzHa3xey0tFdiNPQG/pw9tOoP9YCmK+5q68i+kfQyKtCXnLbIEDhzRugnK1N5jyAT41IikdkCXVDcOrfdVP5pvbJLqJJptlUlLr2npe1Htd13F6+gERShonRn04QNA5coaY7BzCfhxmBF5qtzm7HgZdmhwSWoLJOaq3h2uvabIEBT++euh8jGFMx8VUkcHVW1UfsQUYJ+aAbf8+1kgc2fP7jH0NO+QOS3HgjPe3fjKYJg3XxVJZ/RD6PNua86rcJuS7my8TvYaCGBwNf8aZwdN5SXkmyE6R6cbm+4f4yYt2a2xk4Q0n1E+HfgJ9Ttpx5EDGmENi+/x+e6dJOOlTGqMXY1Pfb615hHcXdWVsofFziBUM/kWsovh9AafcBLUvY82cZ/OG208dWuAm/l/SJZs+kBOsKQRb5w+5GusqzLFKeKBs74hcD4VbkXxTRA==',X'2115dbfc068f7a2c93e6ba304ac9bcdf104261bfa83e628ba62380399976afd013cf586231d41f20a5399ff9e311001113c04614d5d91db3980d78238a3602fdda060fc5dea01bd13fb76c6344d116602d35b0eb037876f6b3b6ee2d3d66cf3ce77efbd28dcfd596ef7db2cfff7bdbb68447a768f8d8f9c9c4beabc6c8a502f7ae7f455e9a3e8b6c954cc61f6123e2259d24d4583ba5b0f7d3c6d0b92709aaea33057bca27cb2454494b713bbf99599041e21fdd55823a181fa348a5a8d8ee510a2fc8dd33d45c671f13e82228f5e7895a64907c144b4281f365688de2dad737f772686c3c13b20b7eaa0dcdca0eb811ccac400e4460f7bc5f30622bdfae8f7b',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('EA01A54A9724B6169F1D9E3047A51FCD','C52',1,1,'b9RmBonVXZ0glRZ1JPKaMoDobeGKMjLPyqU5YhsCCgoX3OKyhBz5Csbs4ukQVbb39tb/yplyl0b3DQnIv9QcnRNIkVQuua9OnQ9cTolOqQstqayaGT5QTEUvtlVJ0F3uyGEhj9BNHfaallSoa3k48EKnZN/gi3H1UvkkBdOFX/xx39T8O2msJXSowV6TYgqPqJMi8/Z/gj3XS3LN8Z/oIW7ao8KB5P3R4QNNBxT0WSzZm06Oaz7Ho+oiWThIbW8ihwiHGwIb/N9xqwp9xAJTpv2weArW2Mvt1nMkCeTiGF/BxQCjhM0XDw4DDlSJzYBFBBTNLYjvb6Yi1+dK6l/odyyY0g638U70LJbM6LZ6FrMgr36brmXDmaL2OIfM8JUC5tepdfYBsm1jyD1xFalPslKi/8Obi6kgiy7C9/jkme8pALQSci1ucEl9tvb2GpJ7eFXbelb1tOEcUYAKPWyl5WejAlO5LmDiVWWapHK75PbrLyQ8BlOPTxi8Wb/pkHajmdUR8tIixq2170CH2jn6QiLuk0+Tci7Kbq+21uuSM/dPUzNJ+28vVD99noa+bkNLYM1ePyTLRrJ/S/BJhaHyC582letQCyAoGScyneLRNhm/az4dQbwTK8Y7COJqxc+mbgiwuuE7xFHkdVar0j3qY8AZo2QDgmGThNxeXV66yzDPLO/Hu2aLiXvRpj6BlyiRrRCo/jJaAOUMBIvAcRfEFlJh/0X3hAHu/0KkSNSttDv892KxJMMvP8+Bj3PToJnTWA6gGfJmNxJ85rrzV9+tagaiX0XsaioNqCw+5Z4+jiQ+glq0VirdWowb4inE5dyKW2qb+3kAke8dif1+gWxZiJ09X/8MJHiuNnNf34cgwi0=',X'80ee83305b61fd13bd3e3c917e01ee9f24299968f9f24effe0b3716ad4eea4761e2b8e6f3e9a31eff9b3a43b6d61692e567bb3a4a506babee7e8296e9fdad978022c43add1891dd2b209be5c0455e52a75e46de0a4c1050f4fb01703f84c0b0658bb164aa40f29ae0220d69938093aa70b8e847fb9d4f55490bfc91ef0ae5ca6325766e218d4e7f8a284656e5c154b2ed1a49f0ff69ffb2442d2a3c63b3354addfb6998595725edd8a3bcc008c2fe22dd192434638a5ef57ccc9a0fab496d6ef6b5ac266e391c49ba9aa9c0f22b9ab5d142cda10792e04fa1a326200a00acf34a5fa5a4a96cb96d8625b9fbc61300d8d8d68793552090b281f33a26d39fb1b6b',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('2E31018D569103520C7275BD736DA790','C52',1,1,'okNoHAautmER5bZLzf6fnakDe2anAH+OQhA0cwWNOa3QCPSVCVFkXKr/Xlkj02jKb0kjscgy67sItMrYklqNoNVNm/8NsSd63JORg9eXb/3GkzcmyfTJ2aOw5CycvSjtlws6vJcFyPU7KbFEZgo/nQiGn3rMuUcDLthTNX/izKD9WaFb822Dzbfiym+2bBz75OWihcxwiggIh4ilB7Kdf9Kuno+Nu33sapP9AMvIi0l4Eg7KuYKDTzM+Vx1Jmt4HKej4V9LCYGWn1D+u2eUMJ7fDLANeuRe+olYRf6f6kzM34zg7udISJr3WCv+39v29WTMLtBw8JWeiz8kA232tMiNXsW17iMi8skWeXiTRd5h7unONaWomJlQxYF+ndcDnDMZHWsitP5TRgeO7UHU0+EYMYWjNV4GB+gDUoDdWVnhopc26On8E2eZjSxdjNyJrPlMjSsBPw43HbLGVRQuGuRfpEuj5sFkKY1lwsu4jAMrfLEgsAUNafjiBDSyLvGedGKJVR9PT+T9Wxw4NDW3Sx+3E3yGLk13oYA5gIvJYqjg080S2bMSYErejCQKA2qnWP2flJy1NTsFBg1zFowtGXpAi0+sdYDG9tMXpafjjSEnQnYZdA9BbHcz2EwSXswpFrRsJRwtkHPBYjYDE2taGPR1drbI/4jRRk8oAwsZnfKEV/xcjorF85N+6rjOplGsfSU7RAW23lqgPih6cyiLYwYHH8jkPD1OROEvNIiDEW7fytdC+DiQ4ns22/hbm8igi3YLo3fkMrEJIRv4xhU75eDity2anK1o5rp8MFFjOrInC6HjGXZuc6QS5Y0FByRq0/AaIJzheB7JgSBflCRZETRaKdyffljzISe48y4YR884=',X'625bcfb6df41ddfb12567d0b719a96805e827ebebf41bea9161cf261ad398b5941ae4ad30c1aee10f38c42eba41ebd2c4b5063a3b3d7a89055f3129c91e92c4e4b68bfe7de950ae0f1af6b16b022283e84b2ece69a8670e1449031167874781e402f1d837f3d8ab2aa13298e68acca8bd4186958093b3da888b6a3a4d26f312d3e7f19081e3e2580aa4b9bde0328f33e90f98e3fa7ecbe5f977ef03da6bb07c954e377902f0e72d993e5cba2fd457494d1725cff5b9b9992dc6ca42a57d6ff7eff9fdf71d2afd61237102e22449eacfcfd8f904f418fb8a4bc892ac3675e552cfc5acffc9092178594fcef535e4caa2618c45276ade2b38557a968513e159b67',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('4439791E871467B4C346D7560DA51652','C52',1,1,'HZIFfzRULsfOm5V0rON6W7rq1EwdSMkge0dJAoYgwIQdV29cV20fcTbvh48HfPdgLbY8C0u/Ejdo5Km1l/4h5YPLgbUk3xLYLX/enGxUm4ImiIA0VLp9QtzTyjEFB8xXjzm2w5wHmcbd1iDeDDLjiahuq4EwddvBhL8s4hUsHoPa44u6vgeHr6FUtnpFNG8OP43zlAC4njY01Tp7/ZOEA4NM5c4LpxbVTEMeQAEzfM6kGXrhKujgTj7CWXLmUfByH0VZmJJoe50Hqr8nw972lscswmfoabGZcZMQjUGEgr3ZI+fBRjIdlbvuPZmSXEzKzUgSq/+K+V+GM/95KBMf3IaUlFrl1c/riZzOPpk+Zs9mGevnSV/ngYG0vcFsRz7EzciI/U/2NymuuE44n+aPuJtv7DlfoE+fIsfIpi3/GGcnmppqanKhr6sTIkwOuys9Ukoq9YrMQbKm4n9CHiQcnonen2fHd9q2Ax8GNcrDvM6rYHjMSyPFxQ1+7g4/2Fy4xRszcvKrRHKKrUrE196kZ6sX9er57fHX6yMTRk6MCSMOCYPJSTwjzkOUYfmPWpW1n4Xvco5O7ZBCK2BgzY/36T1LXRvXps9o4T9kCMXo4SDKnvnwulqVH+Z8vwMFI7RTVP++qsvjIClU0+DodL8jvTkFVt4jr2dYCBXAGaqdZ65rtNa1XZinqN95iuM7xiCid1b5B8aUk6X/+4wgbZlRDb2CIwXj+9uZ9Zm8K8cpzfCPnwSFn5ozwwzQmXXfkJYsv8Qy4JISaNcOcKCxshyHBNEKv3um1cLXuhCj4X/x+24bT7Bx2qUaLcZAV0yZnB+0KIMkV/uMEfKQm4TWFxj6AVanp9JCgcbmcgEBnWZ+iwI=',X'0f21db52dcf15bdca7a08565bb8d26a1404c5b74db30e1542d1952027c4204bc85b6d17d729af38377bf4bea965731244cd89798a322e71fdc7b19a3f846f4479886d77bc7a8a31a4a5936c2353d4a3ea59ebad49226486ea7713cc826e856ae889cb124c78bf2dcbf5902a2abff4fe751acb65acfdaf59a4b9b47428c80b17e6f8a1614f4d0a2a2ac08c933ea1d56a59230559e0d5bcf721deb4ca125d86905b3a3bb8b0664a0588e46a9a045c52b46c243afa86dd7343654d0e4f91934a61a4867f791cfbb87c878a33c51f09f8d0f08732747823ae5bbb5c6e1e45f072c78b82ea172a6288288c852c9583f316247023faba89820bd3db5819105e1e1fa75',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('85814C7B13834DA6C0F5B37623496298','C52',1,1,'8CUdSoSf4iwds8v42Oexf6ET71KUTn8lq0Do9iBAJN30WS9CzwPsF9m/gMZ58d9VEAzQmE/2bJv0R+IMmKDhvWY9VCp1YebYK3fkxHHgNboVCdsyPSJCH+8DO7qTJxmpsPYDsavSZgxULqI/fxikZ2B5ActEdFg2en7zyY7wJdHM4Xb6J+ZtJa5iLTok0VaRAFfs5pPxG6NdDAs3ugI0T0Nr51Aj0kfNhSWGVHVBP/3k9Obk4iCUzIcb5Mr9WjPOpYfcOF+myxliSFrmGLtAhE01byggPDjgjXZJiGe524iikTDxh1t7ru4I7pSL76fjDmspMkdUq5QZ4ol8Q4OuqgBjZoe+SFPD/TC7QeBOohJiz6wZY+Jq+fQ7cK/8Ap9fd8CL5FVAatrcFxQYk748D0C/tzc5FSkGWhcHjvpusZ7do0R4mntz3u6CTvRkUTOY+Fcn2pI7hxURhzrcZX0KI5L7pX/dVH+HybGiUbs4Cb7DJ69RA3+ecWphMiW3p4X53FI/3VTc+3n6QaYM13xGKOl0bj+ODEfONr0nzsOLd2apkfDAWghTVGWKr+aP7gO8++4Z9XA5CgOrcqPwz51sa4YcBmK3j5TbTWoUHxXgDezgrVFgqYxE9AmyezfN3CmGXAMKdgwSErEsBF3Ttn/udvyIErKUI8U64fZaBd9G3NYbWSVrokxOMBE9XCCDWKPU/10P1keFavqGwgxHORNwzAKIkWXU3Eq/x6tMwca9nvn+RpP0Kqu1cj+ey2Lugt1hFa2WPXKEDgaf45NkI06nVYf4wo/7mxh6pCyfnFnsih3RUbmuUNmupU4juUEmA5dXcfmhTvNFkjvFbyGIWUSscdc132X5m5R+MKwDN4e+C2k=',X'a6052e66520e5423a27a44b92bddfa2e3c902f0dd1bd2c429ee106a47bcf0b0b0befe5056ae96494af5391c6bf50d787f3df9268086aa6b3b3dc9d022bac38e5e88ab3c3e3fa53adc417e57f6443c6f7025e3b9ff308f391c5a2e297dc73b15918a1443cf6e6b7fed7b86752f261eedef25ea948fc1edd6caae0a9fe0732c36fd2dc949a9d140a0b774825a4f75d2afaf871a9c12ec2e7428584da7c349a5cae9080c2612916821573126ca51098aa820f31da6fe8b98ec89178b7e40659bd6727e098a6ed426bffd8bced41f75e3871c552a90fc8b1b7423d6ff9f7d83481f34ec5565e98c4cde030536270f63a7e072b697abccec7fc2594d9f4b294773706',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('39160CEF907C04949B8B3E87DD07FC1C','C52',1,1,'MQbX3XAX2MwLgotz4tfReCZ1UYrgYkwT/dO0YHlSuOsh1z2Rs6S8rkWUhdQNzVQcSceMSEVqxU/zItCdx4OqTCy8eaJdIvv8J11PefLh1pdLdNPKD8LraO6bppmLrlV55gZdXmi7e+BM+aCxDPAyXUfDYoQ2HoBxYVbD+tGz2Rou8SCvU+tU35uuKJPbE/omQpKWdvG44YjVZUgyuK/YObuH0xHi7fiDqHapSzDXhK1MKEwq/EFuumsI72CIjzZ4wPA2NjxMxxjxD8tzLegqKU8Qdhd2MMTeBXa1Kl99HiddvBrfOh0a9hng0FWOBXNQ2C5IALah4b9zWTnN5TK5KS2iAq1GgS2UtgYCB2yrUBIkmOjmctm/UsQvxqD337eWajqE5sM7dKUmo0RZ5pIeb+8nSpV31qCE/XfwOSQ+ilUJrLO9Ucum5U5Zh8HzUc0UoqBs2GInLUVtQYi2mC2a9me8QE67wg2DD0A9eA+zHjG+3kws+9ePNO+ZTZ6kPgt7Z4mh747A/AtrdUMgMKLnaDnZQoknOZQrIze890bjZSoamA2qzgU76viqOyUOu8bFrwGArj7DcZVOTXKCgc/zVf4wRm2YVSWBUOR41B3yh3CLZp8+dTUyZcK8g80a8QOVizQnMiG1mh/QNBn/XV59PWrVBbIrPAeuZDlbfYWzLneWtSzQ5IU5XWrJs/80Qed+NjQsut4vHzDe9AoKCk8L+1kd5tKxtwPK/xc6j8PDw+/D9nb54q8ZtesnNBwcbPkDFfCFbKRSLfJw0H8ZVPiybn5Unjulzp+u0l9X+nITdlavu/tMEw3tX98yfHlPwnv/sUPx8qz76E27hUWdm2/6VRJbraQlhT7Vb1XYbTo2NVA=',X'2052f99a5193a7bcfb6aa70c2199e97fea7e61c121bf54f50ef4bf932c6e49451d98b743b96c65d1ff6ab58cda064ef12dc70621d9e7466d9ee8469c226b4de687afc626dd00443233180d3a22763664261d88d0fa43697889b56ce0cbbef22e0ae9ee5337e61414f1bfeaffb4bac5657de9ea472182c9160d5e1d2c673c469906b139d300a187c3c1aaf457f777613c57a6c7833f4b684fbddb20f17aa91beb04c1978abd656cf1c795602d84725bf8c0ce29755f2eee9781075dbcc4abe5281d578a1efcecd503806d468b54b7998237e3123ceba13b746d25cc6b18975a954898bedeffe0f4ec0a77683b9283f5064b0874022921805c77950a14a096628f',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('4D376365269DE808FB7099729EDA154E','C52',1,1,'tUhwqnzi/dyOExfeBNaLDKhTPPMsD85a8uNJ2ge1kJkmG2faycgG27VeE/M49e+IBEuT2P7/DSh8xvY+1tlL5B1JSAn7W3FfioSvu44HTiXOC+wp7/eNat49DsIA5M91e3hzQouzfGRgS3BzKzv5vMUXyBGGwBCFPTpsckXZjBmvbKBqM8FQOWw2iSjjcv0f8o/9f4AwOJ0s2EPd70StEB0f9KuxDaDjpaQtTGXC1CraPJAy4NLXPfYIQV4M03e2/sr4C2umCYh9jxgkjGER3eQzL52CyzpbKuxrWTVtzpYGvdcuNVbbKr3csV7bDeCAbq2gJDrEHm4T0eqOSePmE7dnJ1tmNeiPtPchnStJI6nNMAW4am3ov1hKqtsyStgbFejgJcN2huAEyEttI+cGtHtfVkF9B11GzTk8lJBwToC/DUDlWzKYJBiDe32PLCAR1tt3mttk9c0AZvY45H3YfgdXOhyt2vq5ezNS3Et3TveIXhfF0ZmRaw0VaT+PSD1eoG1RLz+JeQav7zCgtor/8RuAxm9uFgL8kxiCRdciMLt14OWuVTd0HGjLp25zMFED2nHLPD62PSwLy5pmoEUQkCVui+a2dIkjGbYOE/geOGDKjMJGrdVdRcUyVnl//OkHvdlCirNkRCRgcgtw8g2aThKNQryzR/neJfvmGOKnuOPrXrkUA/LyE4Ybp0+jS6YDD1+OZQcUlV/cvd4pXJ6YP+lSPgoWw5OyoJJ4cT/zzyz+uSFzilEDjtEXtUFVxuKk9RHxiQMd1GNGmTg/WwxPAprPNCSrTGsLpGiah7qE6ez3l5oQqpdHOpXFY5hpbxjNT6VDg6G1KlIoEX+l8M8k2n9fE6I80/o+sAFWv8ztaTIx45ew0JWsd9dEOcUG3HgeLuoXoK06dDLCzvrzvcAjmrrwoLZLXmvyUV6wAaEEFDc8/kaTiVnZwo8CU0+eJG6kTD3HJwvhtYTcUOENrZHzxvt/07BTEbZxDE7EknKdIySjX40ZwiGVmwmAZMZ5Lt9g02iZh0UP1JkN3tnzYP4H91s+G/5HgW3LJZhvDTQM0wgr82Yh0yCsatfpPfURyjkZBg4FN7cCigSin/LP54ntuJ6RYL96i6nbXolDeCVakgnCGgSc1RO/PBSpiwGCQKyxsO6ykxxGvkOHsaTas9tA+Wv4tnHkdHvvaXz6MeeXTZ857dPT7KP/iXtmP/LU6gb8hKss/0nFX+OuF2c1aB9xq96I17d49boKve9S8MkF8OzmeYGMeAZC9PRAxN+cIyaLyHVf8gOtc5w3FuA7gS1ytXNxyl1hKsi5sdxYvLImFQ20LZWUf9aAr25LvAIqsgiMZhURx7b43z0U7GHFxWlM9GLnyTztPg751YU/Un5Z5LdYiyn8Rx+wTw3paLa8VnBJu/iNcTiBO5vjBNS8YBZLc745M5O6iGZD1WyOvStnfY+B68lAKj4AGZx/2QD5Ud8+ZzxTfpETJFBa/NV4nLGo6w==',X'1387f1c12d9f130fc3ba64b6ba6ceb9ed0e57798b0e555523d02421ed35171636f4a76a39c0eb0de9b2ed1cebdacf7757265e28b385cecf27ef8b8734381bc7e67500b1fc587457f13170b25183f56b58bdcca1820095ec3bfb6f038a13d5b335a2fc6f2fd064c06954c22db633778ebd49e8bdfc5e5463a3f959e686e24284e35240ebc66b5ac5c76cebc49e05e70225273308afa60ca16ef287e71c1c02c10de5031cc2253900dfafd1fcf9fcde2da8f4ca317d5680272c19918ec80be19eab64dcd0f0a24d5dccc1ef8d1336d497ff8731e4872cf77985aa31474ab4900237c2c9eef8263052b0b7b319af47ef36e7873ce7f3177c1a47e4ea22faf40d6c6',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('57A4C51395DA1FF3830D9FDBF2E31FEF','C52',1,1,'UZrsZ1GgQaWdPpqhrqKOtc+OI/qgyfDPwmKUs6dMIxIhv+WnClNWmdsijifHej/Qoaha16LynuT5oqKwydNHgB9QpKvnVcOG1Q8yI1RgzcrVLTvdjTDPrggpGeO5ETilXwKJ+SjbLaTXMej2hOfllOAwyQHDotSweLHQcRzyBPams6T+8E/L9oVtiD9TuyZPe8ayFZKxHa8wVHOT1SFhBP6TXQ1Fei0bbf9AbtMDQz+UxBbclXfB7Jk93ZGJyM/TXmExkqsbuyfFBE+MJd392Xgp5V8Azg5x6gprEM4pmP99Acc1gDA9/nirZk5LhTPUUF853ru8uNYcmjwod88BDouyXyRdTuzRDjgFxcqX6KyDRkHgkYUGSVxz2pNeqsM1BDyDArqum4BzqUoLqZ6vRFDdy+FJX270BsNpH7oiML7Ju4KNu98MMQIuu4SWas5rK88Xlip9lHaBuplcSlDsXglPtOZnOSUpga9JSp/8vrsGzMp/duhlZt3953e8djk8d4gRopzcOZt+p+XVpz5JB5GJe180LB/7ewBr4jF6Pfkmu/ki0gncs76s7zGhKwpVx4OSWXbNOtPeq96ZtZF0u5p4miBAi6s1DUPOnGTjPq8caqA3yaOtkotFVzSnSHgGqZCbmQnLhm35IqH9/d+pNbo5SwlRXeVdqIq8rDpVx6WaGrIMsd6VQZny7xE23v2rtPJ2fJBwIjeg5WSySv6jYh39o0G8xKrQczgrdryP6L4Tv5OqK3eVJjWgtmnTeIrEYQ4oNMxjF0CZOEwxCTYy5eIP3TCxdjRUBGFqhLEq4rFcjxL13mVMMieSfGDsNYTgLoIcSfWnqXCAwfdilVM29mPlGFMVzze427xfBG4EJVzd/tlVaj2iVorfhiSmA5vmOmFLknUaHxNMehDhghQbzd6BNWFrEJCnGNnVVzX8SrLwa+sWK0CdiuSupgs58KqED743/NWNE2sjQ2UWX4E9sszpfLNpgMMpZSPO7gAW9RSnk225iwpjWvExaVlWOIeoDWS0LBwXhPwrfJnlLRTxA6b4mXYKJSQdBqN6VawNfG4lhLhE7Pdp+ohnMVeNe/McIpUUbpda0TM0SC3R9wp1xegXzSBFrfTGF1LGiFKeKp5CFSl/tpYVmujSMogPsdErYZQJ4n2HybbDuV9fAX3j6HXxSSoVXKgoZt/tnrHu4rBUFQ0IW5GFkI1e71PtQiVRF0u8r2F2m+iZjTG3NGA1ROFbF9P73vlBdEpfeRyY8NAwye3Xyhe1RLNHREmN6r9YD1Z/pbuXBx02o4TtQr1UW596zqjoxYUqPWBfxGVFzCXwQKjbRL3mjZDmyyDou2cSsqawAaUGgSDIT7IAq9Oc/F/GYWi8okoNPRQL8HlQI+f9F/IhlR+pkq560gT8nw8sfVtWmYk6cydeeysjFEkjzO1sLPTRx8mvZN6xshPosYkE2Fyq1ZV/FLMvxylYsU76Hb+5Mso0+xPyXTPSXStqOw==',X'77186e2defe9c7952152533c06edd5535b6a443116c6cdd5b46542de56875a27ac2e75ff7db32be2a2c97114ba2e639effc786bb7eb89634ae89969309259dd7c833cc3c7a82937a8697619b3a2db35f6a318af2ef4cb204ecc73aff721f246fc284525e21cececc2197e1a01bdda53d39c4ddf5a9bd33bbdb379ac15e1b0d007ac48e0dd815dccabf987e6626530c990d8983af2e9ac736445ff04ddd317cd52c300e16835efda63fb7da6297aae11db983ae9e90c41f61acd57100a629dff50d2e33925501880d5e8665b9d6abb6d9d99d0af95081a7cb7997416e88da8d2b2fa14b186217b705f381b08c250d070848d9ee572ceed4228b8cbe84e77ffce6',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('860612D890F99102A83965B14CF0100E','C52',1,1,'yCMv3+OHKKQFlt+vifcxyxNfr1vScP0F1l0MxN0iKNTuCMpoB7IXi8Xn8sOSqEwZZmQv0zWsAWZCVSN1om20jFvU/dRyELs1ewNsNCf/1uxwGe3lcVewKQDdDNt/X0KBH8yX5c25b6SNwux5Ar/Bw/rgso1fLfqwHhxXDB/yezAVYme9JcyB9MM0RwxKFepoIPfBvJikj+xrdqIY5f/unljtuXh0esHin0vMoE2Q7m26KOiPqKYWTs+Ak6pwQZlaKRYuaMFI86W3WQCUgirjTtqwcVibUMShxsZAor6p64FkgoFGY43UsEqLi067r5rbvwt3tVueupLftQ0mT8lEcc8i/zLlMBUPEKkKHOjmDQp0qxQUqov9P+Q1C1f8ezfcy6IElU93021WSnEJsxx9zOXmBGV/1YPQ0piHfm+EowyS22z6eqCcm1ylwT6uCTM0BjqewgQopoSuJBF90xfnJ/3wB73zkk7H+3lBkEDDYZea0lrFGIllJJeqCEKme1umBF+y7fWyqF42IfOYB8urtyLLjVhX/wwQBD7cM7AsUV+AVBY084u5mU3GdW/AFsbfr25TmPSgzx2xcFcJBs85EDcq8a+S4P8BMX7NI9IU+V0yBOCiADETMcCaFoe6CknyvvP000XpXzPcogyWusurCZN4mFgM2zB/EQPNdYQ0jZaQLIWzl9HDMXyPSdeqtfzpTlLcsojDK1KLdFvhOvcGk5GrMRrP+lXSZL+inebnHwXUEUYB49Bs2xg0R19oSvokPmkL9ya7M5WgQwLpkgagYmegCnNUmWfzwfXwp7DNtiUVJWm3HvBbV6FWuG/F1E1Zf87lEJw7XnnvdWJ9n/fzIxr/WpI9w9YIk4cxzjfeaOz2gEh9LjefD1i5yOR5adlq+tzaEUo4Btu9DNPwHQBoQsdFZCoIy6+5b6VEFjNvVhxq9pCs44c8RCEOt6cukt+J3K4YD4wLBJ6lLAGAolKJ3B52q1a5Nb8Ggag3wyiYEql+8hV8DTo0OJ7wydn4GpXmWBMYmHlqGt8ljfr6j2nXc/p7eftRfHFZQC8tJ0FQaoHHtcL7l9Kl49mgwZ82sYVgv5JxNgIBw48Ru6imlvK9R6n4HXD7PzU1QdbO7Oqi/bUpwkkzI5L5Nl2vvqlKMO4bUMIgKO3QoncFydMasZPpZ0icxoRxfrkYsg9CraYRIC0WJE51NKNcVeVbu9IOw8ojnDggegA3MtxQF0s69JVhcPEXEHciuk/GFcwekku5J2H71Ew3DyS8BD1LS/RPDBhP5/HrX6vg50rYqphAlC/F6ytqhNPteKiw/TW7g5Vt2minO0hejE8d67brBLSXVVvXAb41ONhYdTjI9XmYsIJ15N16UnO3+m4yYmXptN0kQY85Lt8D+RT4S1XugFBB7tXuw9JcqHezy8audYLFIgfwA9C/O7pKF4QcM38MdaF3JUK7BloTyaP8DvElzgjfZXPKsX89uCNnKhPZ15c4KqKrSg==',X'31c52c3a0bb9e882744eef2edee30ff26b401c33f7318570696a66fc0678b6891af0780b808e3a494541ca848273778dd0d41abd83960d94551a8a6572953a175ebb5615c3da4e8a0903e49d5873deb9df4c2f287e323e335cc2f258ca53e3b2803ae25d71450a233ba990c6364f69230a3777e3bc81934df45faa981f89b8afe3041d73fec54a4c16ef87f6ed3bb2dbd5e5adb9be2ad3549d444333aed204083bb7c473031d6ff9740849b47a8980ea3a94829d2bb6ceb7750e9170ca6f08bfd37c656067b5b0fdb0f5d2791952707aed334893a93f99363f10d57785b474293d955f47c2e3319dbf5b2215f27ebadf5bcd739d7e7bc36190ebbef59bb5b444',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('5BB67D31BD1B5796485E03F694369C4A','C52',1,1,'nh8RVBiNazPrxgbXVz/XEdWpI9XmaMnhcFO/KKwisEJCUBTJset7Akdm1uVKGRfrAkhmOFpzqqO7y+4wIVJpE5c3aGElQOOK/f2ej5rUrDwEonfD3wiT9p3tV7KY+WScJd0Vx1evikEz3BUYR0RNcW/qaoG3Ckn/9VSFbEI/4piy1bBXQIUCEoUMAvrhRPgP58tXY2VB+owzTEr2a/hySRxjhuvTVfd8oAmg4PvIrLJ7XfLkaTYd5BKpRDfpEPTCjaS/YVQ3JjUS/d5BFWKLp7Ys6UVin9F2r/wcykJb30RjHhUKe3/OpEMjuiJB0OWApZ4QDgnW6bxu74VKYJa3TMuRlySbwywYLhmFJA1pIPm9e1UxN+yEyFaUAU3REksu2PeRFhn20ToLw1WsmE+o8Seq61vM4T2+nXzUXBcLnGdtz8+6xyO4xXS26n1gj1hRV8dc0cJDR0KwT+L58C5ofT9R/jxzkzrbYQUdrujErzqBCpJldK/kmQUIy1V+nFebQApAp6yxQoLyO5aQC/Y+iqT9MosTc6aH5wX3I64rHbG6XEkvz5skX/U+yX5M7mocoRp95BPsf+1cKqje08zZHjkvsizaCK+sCuGF24cq4G/exCLYNCyBQRTvetTyPHblFhFMdtPuItC91/DyEmVaW3YAPkHPPVNyA2QXts3+KZESRDlw6FBu1le0pLT0WQgPcUTpahIpS3uWCQ5ry3heLgvhhQ8byG7xiVs5qSDZFtFh9naRz9E1elaqrzaC9KdBqt7mwdDcA9iom3B7eXZxoBcXOxIJ3IDbm057UZSA4XO6lsQ81lpDYMIkRyW4x6MUKJJnYqIAlfC4JIfioE6OtZ2RUMPDKvUz+BeI0MPIhCqxU9YxIzvT4LDpPEUgRZ6QnsrV3Z6hkSbj3jvGuq953ykbDD5qviKpiSDlbJK1PBMo+bGHwMf7P8yYZBt0Da799HaVC+56LABk2Ej7jhDE+IM6mskEvvaU6EUnXWtbHnHpSIbchkc2b0l8APNu4kmDWpmlKULdE2tkGmN8ATVVAO/4RVz17X1lelUevWVWKpUbTT921gppuMZWVRfkKwXH3DXuSZ4zUMFtNJufhCNfZRCL3jSa7bJgnPpxzGqoljrFcxzfYBVq5UWIsdyp+1wPytAV6CY/s1BwXSBPhSVKxl/qX14zFHEgTYR2B5k0t0MIfM52011MKo1NC3QAG9gH482x9nlL+f0jCxHVfqhX8EHswBbqGSwlRy6pf7m7oy79P0GswecjfiQ4S090X31RYMX51YVVRp7Q4I57AxHH7W4wvvfl9yO3MDjksuBYkGCi2/9Gyo9kNAMejiuW14GcKVprtcIrv7o7Q8RBEnM8rq7lSeWmszyZVylTQRVYf5b8ILs0o/l+b1MPp6MGCnHZ2O2Z0Olo4n+R+8UrkPAWPtJqAn0t3rv/dZyrl5YgIE57e2tEEMvB1/Hb/eQDNoVlXdVYQ1LQ6M8w7WWvT5n+0g==',X'847d038e7089771d152070d5ec10fb24ea7d901616fcb98b9d4122221046143bc84cc071cc04e74f8825d9c8cb83d1f90c43051be481d223a40c543f39ce2c7dd302cd1000c3c5a8bf2f21cb96967467b416f163d428af896de9a3ef8ab3559cae61d67a5482ebef8e5a6f36082a1b777625b4790b639fa41080f3f54297902cfbe19741f886e61e2ece4640280222060bb6df78bb6e2b38bffaed2faa1920029b85c2ee002744d514f0ba7ac6618235640119317f2da65e35051fe8a6cd548024ad979f17ecfe502988ea69a1414abb3fa1498082c2ebbcc160155597ba96482151c7392eb143096290cfc8ea7dbc503c21670ff880716edbaacf1ad2d734a1',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('B15D55631903AAC814254E5794864DDE','C52',1,1,'l6k1dyDapj7oCTJa37776zzGNmddrR5DraqlJDsR3Dq2ot8B5tAyVurRPAx+zYPZuPy3sW05AwxtLYb/mAGvrBxMvDa+HD7t1OIyjfIWdsfkkpTmfQLW3Od5nx3svaaxAIPrnBuIph9yYEe2Tl+10OFKjJve10/Y9UwWfj5HEcc0LZqrFzk0kQ+8k8Xl99F7fqjObBaewjp6oMLM8GUAmjRZcBsfVLGGt+hU2jhZaZ4/IB2GKiOmFCNImMpGSaHT+9s7iGOmy+E/+rqaGIJ+et+9b7+8IOrE6TqvKx+JM+K0339qMU2+HSWyQEjK6u2PalV7IpvJAoOzY5LZqOvnhzMTGfwsDCZMcOy4cL8CWgoUt2d1IXN6+kytpQmNEPw68uiPslFJGDWSDBif4pWryR9V3NMgdBk+wsGNmy9kMaM2sSiy/hzJ/r4frhH3cBhk1mNDfMr5bBp0E/VL9escWW0+OyCEuO0cFX4X7YYeJo8Omj3mm27H5J0XBlWuTZSqI1cA3370LU4QiVesb/cHZl7emw3t3o8YiljildimdLwCU2buNoMr1saF+P8uRxppyrJBxRZ0jfSpWgpY33+xye6/G/1M6iGIOcq6IMyuQAywk3DpxFm6RJ17JVmRGz/SWvFPnbAtvSK+r4xkUrpbNedRcgWdmWUAqBOetjYNSH8U/0h7ZC91DteoPHCZ1Y0YBM4m+slzbjxGoFzeFOgFVXLdnOUvczQw+ejUWcBnZOcMTM/2m61pLG+vrKhquAgt8t4wk4SXHKH23HrrLOJ6cf6j2v8Zxq6KBTM2iHUGVMloCQVZZ71n4miDslJeYuubx/qM1yeHWvftVc/QNhNP1ibuQmbe3G7ds8NpoLMSXqUZ9gT0DWrn2eCGkNU7N9LumNgBFYXUXG7p6KexomK2GnZv8vfaVP7tnCqQV+4RFLKB8Z6/efXhJtmjATBjfjdhZ6tQc7VwgyT9MIRXRsAZvF2tFuoxXBcLHEPWTKEyhv2bxvXjOtiSwt1Krtl0UyYkRC30VU0sdOl/HAKXTVsUT39qJJCqfiDzy3wFGtbMcmtYa8sR3CTVyNsqSodzZfQORvcImTIIcKB7tqDEaUlHGe4usqVMUZD+FR9zuPq3edxDV+7z7IHVtmFIbX6NTWVfZl6eu5i1OsjpZzDlN0DkEvjnOdOmWv4oS8bnHra0bQuM2xL1gQLBMSCaLZsF5S5ZdbkzAWf4hYjqYYURGaz5PyYNM7PbVTXydDZNyREqvt7q5kH1jZ3mYTGHzuUGCxECl31CzlkRyeYWE3KBXkPkuRkthUE2I+5rqnvlPxWSw91IHkBwEq5fH1fKAag1cgXDxiGTq1rBet62VTh292N9lQu7ijSuKCYPStgABmqQutIr5JTWemWqq3yuj7hc30lCm7rSxztTg0cceG7RhVIcqOqU1jxeyNUudcvnal4IQDypqxkePj/6tw5NL/F1LmTn5YfOJqLHIip6+drYR87jNBNJYAH7AqJamODPiMlBVT2k6HbKNj+Zgus9sn9oYNuAjy6Ve1Tpw1iwc8Iu0RxOUa446RAnyP4SSFTiFmm9GW6wFx55q4DtINgRiuKCq5baFqd02yngWni8nNCMR9ARl6fmK1+34we0xcmDqHN3W6A=',X'a7ba980c9fd857d92225ddc0ddbd9aab04f5e0a9436b9324f5085051a8c3325b8c6c0a3dd27486607ff7f918087b4da4c2a434553741f6ae71feee6da5f70bd9d5a5d7571fa4f2df38c486b0b1112f6fc39a9093fe1ad216abc6332d16e9780c41e6c83497ef1adb615e872a602a0754188da71e7a562ee3a7638bf318b9c20d58a854e302d54644db754b1f0c8d3234e6ce800ccdd00e87b57846b7a0c03151f5f95c822e79b0d4a417c3aa8b38601d68ce740f16859a3515a0c8247d3e4ea9d72c1b170c27d888404e3dc0c80d9e24c32b7a2edb1bc4520f121ecfb81c68b88832efd7ca642bc12a5dc009eba1eaeb725fa33540f2f1df331df425eeab131a',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('A522850C83A9C77391478CD95DBC20C1','C52',1,1,'7Qkh/FvEcY8Kj0Kx+CYyaYKtT+NKU4XGE1vc7qR3dur/rAAkysstHCNdva8xrf2hQBK8LiqzL0sK5UYsmkDZ3zDLcmPorEutRrLHQ3YMYQf8Et7AxD9/8kfri9HI2IzBxf5wR3sP7ErqUHVTe8zoo+HlPQddVRUzPPSLcL8r8LCnSFj6N8L3t/+6+8fGjieSnnMUtsViCpJbbkWEmM3I7k91BtRzDlV54hSJYhgRcOtvmQLlE6PlG/vN4EXnkrfL994Qs/Qs+6O++OuZNLHnj+4KdEFcgOJYUElFSPbHsDijIKsiTvV89T9wxZKi7ZGYu7tXQeY5fYam9u2qjmk18JKV6pifRgcXO5nOL8a3WVEJ+rSkQdCuLopfzxexfwZAg84K6EmVzd946KPSZAYVMeSzEeMl8eRf+xiXocrmt3e/L5SelqJBgAHVkzUzXepB+TQ4dK2gVZyqRtmalegOVWKvGzYOeeeuP1qZjK+/OLSgcYXdnVL6bdF+3eHNeD3FlHADB/yg1yo3bGVmT+nTPJBFz3wwXNgeuZl4p9bUzhO1qoNg1w3jdE4Dtu8bc/epLAyafcrPJr4HD9dw5h7tOx0JubkpG3gNHFwYK01zX4pChfVBMQn/54I2bfa8LnfaFythSQy0kGZ3kpGkTNr4ESuK8uMGxKvHuNi/3FKc8m3t7NRUisk6CvNxN+IVc+Cp+zpwjI8KXFl/5OXmiAlYYZMAn3anP8hXyrR18PuVhkE/nY+B8iSmcrmY7oj0YMSvsYxGx6LENlRrWvCEVXyq9P39tzk3fPaP5iryLbM6dqiKak1oKHwqQFZZ5P8RZNllrzRgT14X3T4iakzB6z2+/l8HT2p+Bu8oKOUlpOMVMm/kckGEChOcVHPArwxO8wt5iODQd7DAP1049hxHiWHs+Fgt+Uog5APZcovT9lWcyckoquu8Jm8DtQF6/pjG5yvi+3vGVstL7TvLnTt9Svh7mMgDLVmjtJr68ft4wIGNhORaFoyvkPD/VljSYzYu1WGwmDRf/g2bpT4MhpKM4x9KXsA0bfjUdPrkKF4+/D2VZsbrOl1K1d+YZJrU/WxHbsFjcfDNb9mjfXchYT+PaNgm5ObhveWXJmitxOT41Ccvt5pzYjsnMCMcM7Evyy06yMofBITJt7FabgTdrvx2ltQpLRD09xt9SwSokKWUa+Vi4ezpreSaErwuvyYI42+pbET9BWm7NT/1QxNteF/WNJjr5eMNGkgpNHlwHRwMZZAdzhhw9/h+FvqlF62LKzZmYEFe6NURwXi+KuatN88/sR2bWYQdfwJ9nucis6zCuTzSqvG8XNBukpr7+A/KAbj+CsP6tOQlr6HEcUHau1lyglHc20C+c9SaSdVcFlWHGO13aCcOwlfnmw2cpHHnDGXVHzIdN+wOhxcV5KdgztAUaZhNu2dx/NLAgoTjQSbHSmKsD/E1fniy769betTmKE4BU+kbFSiHq/mrjY6A5TNd2nwOhhSCcgesZ+yjWIs3ir9KvyVh0sSctSR5rnwdQWygW40dmhlT0FgEtlnDmwIi/W0r8xCgWtd8XR+bHJuXZH04YyBf6j9b3/HknG3YjJWtB/nf0xBwkpdFFQmRjq4TXDrlrWe8pmvE0E3P7/Lts3FaOPg=',X'5181dd8402f4b41b319abfbe811ebd116050175765ea18bc3a3e81946b1145a1dd7f1951960a0bf6c785aa6fdc6f0994a7d3c9d647973345227cee4c9af1b09747754456b086a3d3727c3c4c881da24d75963ec3c141937bbe25ba3294dd913747357b788c75280559025c678e4c4cfc35e0d02ae0d41f61e2dc389ac104308dbbd4cac0ceda4334318df6b7b977d38f3a92af4dcfde9b49a69d2d48c490da853c863ac1bcde3538268ba9c917bab3bbef68a25816e53fdfc7059bae2885e4a0f31e56f360952f4f17f4761e5ed2bffdf0bbbb40037bd54569ce7d02c01512561f15ce890e1a38a89e2c628bf80ead241551898f03ad20a2ee1916b07a8bf9c6',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('8B99E8A0D77DE811F2A63674D3050095','C52',1,1,'9yt3/+EXL+6YkwafqoNKr0WDmk/UI6tYnah2JcptiRuu3tu0bAu6eqZLNMSDkfsw0NabsIN8lM6EawIz6o3nzrCkvic27wcHrHLe7See3kivGMVV56Gp+5uAsCFYlGuEzMNOMonsMSCrlzOKUwMgRwDULKOvJvctsjGYtaMrJfPDK1j7m3MIxtAmiOZpQwI+S3Wx+dJuU85kdH0bS7IfILiuM/M5wyHEPQWQObbGuAYp03Gd16mxfyi3tFHpHEp9OUc84apa7Kul2An9bxRVM+YyLIyzf4UmyEymuSMon1KQdY4wWK7pSSBQNnV7eHbpCHwUyVnFKuJXv6JUusHF3SEV8TnwEe0t/k2/dGJac2wPJTCaq2SHObrhJD7N26xnNwRCdHaNPzhri9oV+JJGUOEGbxEMUp5bDOKASIKusXTOVM4u0jccRdePdXCgManWzR8Jo8aW0BC4PWXiAkoACodAFa6wLrkEKDYZPFJ83vQUT+wDp6fcrPaxp0P11FPFg5lzwj27to4CWO5kSGT2gvq+v7w2i08ZTBQjoHerXow8DLov7q2mGNup8fcwDxM27+QbaaAwUFFWYSeFqLteGkJhLJC8x5en70Z+bz0r4MftoIAANo0pDdHQqg4fZ0XAzKfAqHAFYnXOu8t+rxpWznOGT76ynY1tL0VSRRdCXBPyjw7DBsTbh3CLlKyR3KSI2OZuFuowvQIrvWS6+62iP5sz1YtRTZF4gBA4Kd8fG2DwcpoltLtkce3KyZ4sNchj3VFdDT5xOdME8OpbUBPKc2asGI3lk2IiaQIQpcdMIHiZF20W/C3hoZqpBrhlpArPt2fB/RaITu96JbbONX4MiT0w96a6qRj+vSpzHRrLuhV79REeUMEQVuYxCIuMu550BYlNiHzd1lFjLUN0gRQHRVe2QmXFC7H+vK/ysZz9pg01RMEl4b7VWIjL4nt2D3G1/B4rl5a4aRfz4nQHp+F+vEMur+XW6eAC63Fo0SdvkfXSuXFeolxEeAq+ta/25IuH1ACwxfjYPE2i+Nm2jodTzdacfHupdaBMo/tjyoIuc9BkGfhnt/3J+qHe/o1CY1JmFxeLy9iQZABYnUZbDjbhM3XETYTQ7qaMxeTC95Rgp4OwRnfK4LKMnE5NivMLPzNtM10Pzl5dt3wW/aDwSIk4XYSNKKMq9QZoMPkVW9cJYUSlNIyHmX3+LIK3qCqV3gB6ojRA//TKakJDel0ttmWdF8yAcs7a+jWZzTwwfjZyE1TDYue2mw4vDycr+VNr1wqZGUtdqSrxbR/Mh4FEVus2RAMfr/BgQ5a+DYuR5GOCV/LEDAlqN9/DjuDzax2fAphe4smVpgMwRIBFSJP4khb0Jn/+oWylDAoO6P9WKx7NtIJivwURFbBtVodFSgk6Nui68ix1MqNXWBvrJGxz0xD+lJXJXVsF2sEhsGJicFSrl6Yk4I5IjYefniwOKnbQp88IxiSVysju1rtM0wXj7ZuPeofSx0JaIUNePEzXNkidKO2YD4/7GsJqeb8Ti0yrhlGzBdYnuFicq1E5Ggd7Uct/Bz3ksZ3UqcRjx9S/GvSO72OlWUR/yXUtwbDLUdqcBjgIRJJPlNn3BDaQC7PrXIZx6gskBx29kZ72fCoA5OHhEws=',X'05a071098343b78eb72d50c1ec888d569be5204070a6361bc977b1327a78cb057b6b0b191b44837f1540efeecb3b4aa9f0e747a06a56d4f50ec466f25d3bd0b607f97c16e55a62b47df8c3e1786b2cb898a450c6a084e668178ba48db320d634f9a888ae67a74318e715ceaa7d2348329cdb101c17bd818e7b203bb64659608406b420dee0a8e3ea5af2f7b2bac9c4995826dc1b736b4f5c67d94e1d224074501fb65cc2ea11c715d630f13dc2f80fea2c670f1ebdab24667af893edea6b814c2762b6cfb8b6ac8e13dacc030c9c3df68d861129cb0cf8543780f2c67d2cb2e1bcb2a942629abefd0918e96cc451c248d5432d1afc758011cf90dcd1ee817ebd',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('DDFE26B60C5FE380A04408D3CC44F1E2','C52',1,1,'9oaV0fUlw+YNJnNuQ4g+/ykZBn8nCtOZ6ZWrqZ4VWvI1zq48nTqwB3ZzIXjht7FYm32rgGl/HRyBr3QoDd9C/C0MqYkGjtSwzRkya5biLHWPZTQfssgM0MxAswUjz/J07pDsrqe7N64Lheop13dFqQiIgV4uQTt7uuG2EIUEVoo2kZlWXbefvBm8SHeqF6NAk3HOUyEI0yquNLXK2u8FwF1rnIno/oBuzTgO7ZCDVPi48P4x9evq2lleRMBmSHr4RszyyhfZQH20cgUZ9Aq6ke7QIvZAjPu0tY8ndZdK84sK7A/gtEKJqy+P0951T+eWDk8+JJw7ja5QDpl310SNS/9Xcdtj27tZgSwhCmvE73bdqehRRh23UdyMdiRXTLs7DhEtJacTOfe/kmQOOjcIyfmdcHyMU4oA+rDod6joJX3ByKZMiNa1XgIIuTj2UzWfKcDIXRWiquL5Oz97oYsv3DHhZuZapHjDcmgtvJphP2Kh4tUUhSmBioVYAH5rJhMOfoQz6Bk3ewBCsPr6xxC0vFjZAmAgJmy7dRusK4bHlpfeH7eRPkPRLTdEOTwGY/LhwmKhDmatKZuPzHjGlpWHcI0qRokDbeQcjzEE+0K0g6MDmHdTR6FdXkiHe5JLaiY5QlxYSm4EB5DvM/ba4niTav0WCjYmOJlVyGeeJCNl/67ZvTR3xrUHPVyX59QW4WvztE8BUty0hGBEMeu2kzjTqjIdCxSGcyAKScmv0SyOGU4kdtdYooKRjnQhq5/pxMOWSXOk4HhVEzCbzCpk2Sn6ScQHI2x7DE64maxJRdNh/quKLdFJaWOF+gKStEuGS9mdpjettsJh9ITUnG9DEBWEmtTDSFMDxBqYo7Mm5xYt6+lsNb0myF7wWg9WXFK9qv/lNSUZhZdM9TmptUSzVB0m9Rm5B1L5VsTY07NogubZk42Z+S4vheoroqtVYmLLyyym6ZHFMZPXHSKtAyXoEfYegD0fSrXegzyOGgVlyg/FKxeTl8iYoeF+69TJWPB0WBBRy9QHYDvSXoZtvLr2EG2VyKKbDgSOQIbUcmv5jKivuB3AS3ilNDlrLvVUutRrJrDKucnKOxxd9B608d/CFIbMdAflBqyyt6owEyXshg1yHahg3yzbqbFyczROciJOHMkjNyNNBjqx11ljejAPO8a68e3iUKAJ0cxJt3qfmcB7zK8LwuYoI/NSvJc11fvP1EgYYBHxaO5ghs/TMrD6K1ue28Tk/v0ESWmt+KhLq0VqLWzKEMR6QK1zDA9g4DHcYell1CgWitkTeT/ZfVC39ofehtgzoiOgXBxpsn7PvvEH3ViK+1vuzQz00uxM3QRo2UpUKGYjdRD87MAgsAMASvgSjJv+I4xiYdSGBThomqyEF3h8dkM0lAmFjQ3ybZhLvmVkEOmVbR3UZIL0mT45+viMGTQjdPLiwvROtrpdSZz+QJtrbYSUC/B0w2efV416Gaauei2m8Xk6vXnMCP1yOr0ALs8Q4cG+tBNv60pBVeUx7Q6yPKbF+9m/cfYkOgCVbQ7SJFQ2hhzhj8Ryp4plMQS2lXKfZyFIpyrOl5UMOii1u0+xeZvzy3C3y5ZJJ1/wJOH+BgV897nVT3XsjpkhJQQnCkVADAJzZKmpKgE9VYlSLtI=',X'591087cb30940e219f292040b86ac9231dd44cba88d922a5a701b3c01c1c4bc15bf6f328b385ee6d70d696951ff5b31f43dd3f4f00f5cce53dac27011d8991b59c7670dc44e914d0594fb455bf12824a95f1171b6c0c5de3309a1026de76ef841224a1932b5463e2988fd1bb6a01fef0e377bd98336aad3e0a64e6c948a6f777669588f1ec84f43efaaa2585a752903203622a10c16e5d28c60cc62cc544316521174f73f8c465c2c236ff6717ec7b978b0047bb7525a4ef4859dbbbf85fbb4e3ece039366f03276d9b5ce295209e676ecc90dbc54f93443df3d7cf2a521bac54e458bb82d7b922df06017d8aba36eddf373752f88a3a76e9bb146fd731b404f',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('4E30190B7DCCD71B69432D3C13E63AF7','C52',1,1,'e4WCVGn7Xx5E+fgjjfaIjYeosOltEO2pVvVIxeRUfoig8PecATWiOFvAICv8cpRZ3F7KTs3PquaIrUnN3suDlaIkrzuye+8F/5CcN0jPw7cJBRUADbnpKGvZcOHv9mSOI1LjujyGD6uBNT1Pi+okiUj9NtGt9j4OdnkGCFBC+fIzNEXzzCaA1ac8iD7UupHMhAxFmtcd6PDS0Qd4rPItT9RRFG7oDsbOu9RFXKFUtSBrF4+XpeZq8bTbyuKk2VTmLiEiDU0bsUG+B4Nvojo5N0TAdFG9V6uwA/bjrCz2FcuKDK/q//GyRwF5bJk2ct38R1g9gwntOaXPt6YCFaSJciVpj3nUNW/AnP2ROg76VZKJCa/s+El0Tphbz0/AX002XukPa6dslRZhJ4cdgcLk2ta4+quiA93KLzIIFJGcwXtIJjRwU4JzRYeqqff5KafSd2ObZg3pX2xODnG8f52ctbSGmuYiKZPyC2gOMcS2dttUxNqOStzxuza/InXjV3mHvSr5zY6AnGfOcA3K515HJZeTb1PO8gX1lgOQpATKyClOZyvArFckq0RfAAR5bzdusmNvcn+HM4EqAQY6CiUU/L10Qm9K+0+7qlwQ28ooKA9ztELE22i5V40HPPJHZv2Sgde+ht1vBa9ZsFhmDBwdPEAqEhVdc2x+URmMEv0AKuCR9T7ydhUIj83tZ2aRJ+Q+McRUmsTRHFSeqzWX6fWhjCZrW2xOCLaIq33bgys0JGwqJ5JEGPqzzT/ggkT8AaU7YIWwVcqBBzvhDeLmBKy2B/7c9npBiW4iHsH8UNXZEf4bNcyFikZ3Y414+av2bdmyDe48ijK56VB2OXAL3G65HamfPGqZm3E11/DsufswuS0QsQ59D5J8puDHNKbI0xP6TuU2QnBwiHhANyjRD/FQfVLEBilPjZ/ew5cRlW7M++BgB2Yd6Lvn+1ReA/i/+OIpGEX3ErnTO2yxt0hHptkk5sTYc1I7I24QYjLlwA4U4n9WIWXvq4+ajGP4hWhSc9JWJWwnnqy/zUQ7aBJhFGfRdeshTdZcQgOXUvIBV5GOB1vLZRKZjr2S8cXAWSWFMV3ST3E3Mxu4YLulPA5WW617qSBU+I0hoTq9Qa/Sx5Up0j8mFKZPLwpCCXpxkafWCUWCCY/N4p/VGHDsgVqF4ksv9OxW0xeJT0ZPlF7JF/+vW7V3fAMVeiBnzBpo+uUp6tQ6qhEHtALg5lsP5KTKJFKUE3GZ2XS+kzEl3xIQDV6S4S1ai3gNEtW2gxcDID3y+3yMfj1szMrWcUkq61VfqLy++w47djUce1DL9Jk31eghrm7K/x1O/H7wwvV4F1m4XiO8CgCL7Yvat3ZCJv1kPYmk//AGj4kT62Lx/t4vp68HO8SZm7fEh9/VBELAwR23VWx/1eN92FVfnwspeDjA6poHjJp1xPpCxd3Zlg4f3fyxvyVGeWizCY4UZjklMlgd/q7+Frld4fakXYQS3DCbrL3zRzmRA1ebsizcvjnSL/zPUoE8/W5XI5kMbWZMgTdhpnfrimTXgJE/AOeGUXX51qUIx7nESq9nV1gRxCE15+3XtZLeCgDlDJ690r0TQLU3rBe0YsxQiyAV5cN69Yy/M5uhS+/DXjR6yWcLzzfZmiTomvg=',X'a11cde2a7c3990319a994e239f438b9394fd0ddd6be2d8fa1337f40790d5dc2a14dc54fc6b00b9257497087824137fa9dd315b99224209b8edb7fcd7e5b14e06acbfef92d8d5916566c38a67b3e59d839f813e73f542fe05fbf89cc287401d690d8badc318334fa10fd919edc98adec48ba6d250a70687d5892ba676bbc1053a5908b18c2062f552b18d5a7bbf290b2dbf433080995fe7eea8fd3adde8d9d5e660bf8f31cf8d459654cf6ee2d83237ab5b87802eeaaab446febcd77062a1eb0033cad141718fef15e7b653b3961093412891fcdfcb16b63edd6a850244e713d893ece56ca6997694d8c6c23608cc31dbbba6a057b9234e24fbadcc44544683e0',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('83679B6B553C474A6B4B43AAA1B3EBED','C52',1,1,'/qtRhvxaJ8eqyMnS9M0VpO45d2Z3DoiM0awWSoeafu3y/ChVdcKe15/lracivt0xuOGGBIqPsHy1xQwOyyLhmgKrUg5ONVKpNxpQt1R3k28307fB1PpAHiybPKbhdZxv/hjGxL4dCQKyPUJYDH3GcCMB1PmjcTIElEFDTcIC7e+b6jgMCIwDtj/c3ujhqNm+ECK3cQkATMDiPBgL/l8jfMwBl62LXak4iBeputP0w2N+AxKZaZIC4Y1Z45qbQUog0QGJ9iiZmLwPZRdSxgf2LD0tTBg46rDNXD4razQ/Di7t9yCxp4JuNdYR1TRDfg32nq+m4bp0qHap5cF2J3N5PrkQbatimRlCPpxMGkr4dLDxPfMY7jWv6Lp5a5a6so6O5rYOtcuKZTEUYpnwUC4zg67q1ZN8/u0pFWRbS6rlkjElWrDZ9YjFc8gs6w1Z8m3w8QaSZrGimu8412ah0UYLv//nqMMg1LGy7FIHo0W5Fna9OXAFCYa4VrcwCBq1o3yiX2+X28oQK7oEkWv755+qGV6B5U5TjYdLF08Gr7OcY0jBdAmxLrLiCrlnVL25akFcSDdvHcGYxvzFvWO1BWMNpaTFwJsaeihAMDSVboavt7iuMSCmjRzFKegG6DH/fvASwGu18D/QJBhi7F8RRjLbidqXB+OVL54Ogbcr0quMIlo05H+aSrLkEU0ayZ0bZzsWWRj0GVEB43+V/HI8BQBmx3ncTeeU6MyDgTe0F04UxUsNsz1rqPqy6KvhY8Bq4nKb1LpOsQ+kDhepB98xqu3cpFhOeW8h3BBmZCKdRbKZBx5kAzu2BnJlN46DJnwO14nZYbq9VOQvHdJC7z0tLNFSkxslP6sFbw+7RaU5stDa6G4bl9ITq4826hQSY9YN+BlCRb8zExaUS7R/paiIwxJ0HjgAc5Dx1Qy56YJgzZvj3ubLEtbAvovpEn1HgG+bBexYdyFiSlIgCvMj0QFOI3I+TeAuNvBdEPRwwp7PThTqjLF7M+KIlXA8+n6GSbpb1xEWbvYYCW5NswNN68MZt4ijuEFgXbISzdX81k4vt5/nzjQRlOI8f9Jd2NX5wAiyCAAj2kVJujCn6wOIH+uYEfG9RpBPNb0FppblbJ5A1Q3iwp9vV8EflA7aa1GVeWVtodWEr1MAuP/PBvTqot6/udBXyR/J9cheMYFFVaae1V1fgeD0IMBtplDQl136EiE6v18nn9rmkx51SHvnRUpvKeVQeF50IQQQ3+Uf+hlOp/Wybpa5qPj1LqEY4K1/vxjBlCJUaNMIe3YHrLiT1qYuYxYRP428Xqn1jASxBT0cuIEAakhY6UmGkP2ooTASAJloTp2gazRbvrZJg0LeqnmXHwzXfN6ib8IO4rX0IxzaCKNmEH3SbCiQZUAjAZDpkLuYQkTKAkLE2iZECw35a+HoOUQ5S5Hq9+zJeCMAVmDiBjcZ6mxWMW2L+FM5Wc1RlUtJRGNHtQw+nuaErDlk8yjIYOHP5kjcjHQy6DIBNlkEbXqR2N26T11He3geOnTUisW7xrW54CtC5MndebLMnLd91E0WTDLac6HN8vwjIuUz02urnq38sIkO8EJuRh9aAGbUVPqt8nS1aRnueiO59jYeFaqMUde8G3Crpg6l8nBKbAUzgyo=',X'a9c3a28e11fd6cbfbcb74764d70237b9a964c2c8638655b17f8e8319c3e8bfab1a353d2d70918d5fd091e75d5782c8defcd391c6fa310c6cae3734a6d69e2b28bf2c35baf5b2a74f1f1e660e6b3dc4c4821ab5faaf9c5a3ed0ab85742e47fef180050df7658b990f54a1713bf7977bdf00af71c2e4c9b1553e8c65b3a908fd4c10001a67519ec0c97aab52cf2a2ca083e5b3aeed0ab23903684bef5b919221a1ebf7b9846bc7a9a2ef0515adebabdfd822bcf2ff377ac43baacb944a091dcbd1e1be100f7ac507f34dcc5c73be016673e6e619172e82ca6aaec36fe440922a6677d719a729e267deac9cee33cc77cf75fd14f2606376033a404dc28d7776fad5',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'98981bbf4289414ab4bc6ed9561fde9e','10',1,0,1,'5NQK42ECTG8T6QPC8SGQ8RKA2SJRZH173F7FQH5MVNES0QCA0Z2G','payto://iban/SANDBOXX/DE128580?receiver-name=Exchange+Company',9);
INSERT INTO TalerWithdrawals VALUES(2,X'a32069fca0ea4ac39ac5c2586e94ae94','18',1,0,1,'KQJQ0AB6CCX894AD76K0RPE9KDJSQFX8KA2G4R53HF59N3JKJWB0','payto://iban/SANDBOXX/DE128580?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$3A3XUjPOu7o=$DxowpimgBYV9bSCXAuDyZ6ChuEuf/eTHhxJsgXPrelQ=','Forty Two');
INSERT INTO DemobankCustomers VALUES(2,'fortythree','sha256-salted$6TcGyViZrL0=$7B5PJdGlKvacWtoh7iHR1Hv+OadUhYHgBCvsn+YmQqU=','Forty Three');
INSERT INTO DemobankCustomers VALUES(3,'exchange','sha256-salted$lc2lsI4CD98=$BdZ+sBANjsaN3bvVCNeEXIfnCi17Iz+HIg4TMcnnTtE=','Exchange Company');
INSERT INTO DemobankCustomers VALUES(4,'tor','sha256-salted$ZsCdbZ+Rv0A=$8euLlafGtoHvmIZArKd6t9+1qJE0CDQO32EZLZfmOg8=','Tor Project');
INSERT INTO DemobankCustomers VALUES(5,'gnunet','sha256-salted$IPx/O//9Wus=$0kgbwF9MFYFRm1gfaHhDSm27O4i5Pdk5eXHjSCt16X4=','GNUnet');
INSERT INTO DemobankCustomers VALUES(6,'tutorial','sha256-salted$fasCtjIlDnU=$fZiz3gRIJSZY6Fm6d4MMiv4Or4NdSZNRA3+7TQm1ixA=','Tutorial');
INSERT INTO DemobankCustomers VALUES(7,'survey','sha256-salted$Z4z+z+ZGpvg=$TWe2+g3KDGfzwsP9lcC2Vfqav3vWmGRbVowWXpYh54c=','Survey');
INSERT INTO DemobankCustomers VALUES(8,'testuser-xiu50hyl','sha256-salted$YPCuHuKCDEA=$8O8O3M8D+GrgQBuXGA8DnVPVJEC03WteiRM7LVZkxEo=',NULL);
INSERT INTO DemobankCustomers VALUES(9,'testuser-3kgqcvv0','sha256-salted$Bhs/2eVyBr0=$nzg9iw6PTz31eoJiZhyUCPiRtZGN0ArO4spZxqGsQes=',NULL);
CREATE TABLE NexusScheduledTasks (id INTEGER PRIMARY KEY AUTOINCREMENT, resourceType TEXT NOT NULL, resourceId TEXT NOT NULL, taskName TEXT NOT NULL, taskType TEXT NOT NULL, taskCronspec TEXT NOT NULL, taskParams TEXT NOT NULL, nextScheduledExecutionSec BIGINT NULL, lastScheduledExecutionSec BIGINT NULL);
INSERT INTO NexusScheduledTasks VALUES(1,'bank-account','exchange-nexus','exchange-payments','submit','* * *',replace('{\n "rangeType" : null,\n "level" : null\n}','\n',char(10)),NULL,1660491074);
INSERT INTO NexusScheduledTasks VALUES(2,'bank-account','exchange-nexus','exchange-history','fetch','* * *',replace('{\n "rangeType" : "latest",\n "level" : "report"\n}','\n',char(10)),NULL,1660491074);
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$2msSX4M/q/E=$KSb50ibIY5Fy7k+iknsahJ/jOYxi/xbr5fM30UK2Pnc=',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','DE128580','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:YA3Z6HGA',1,'CRDT','TESTKUDOS','10','BOOK',NULL,replace('{\n "amount" : "TESTKUDOS:10",\n "creditDebitIndicator" : "CRDT",\n "status" : "BOOK",\n "bankTransactionCode" : "PMNT-ICDT-ESCT",\n "valueDate" : "2022-08-14Z",\n "bookingDate" : "2022-08-14Z",\n "accountServicerRef" : "YA3Z6HGA",\n "batches" : [ {\n "batchTransactions" : [ {\n "amount" : "TESTKUDOS:10",\n "creditDebitIndicator" : "CRDT",\n "details" : {\n "debtor" : {\n "name" : "Name unknown"\n },\n "debtorAccount" : {\n "iban" : "DE540064"\n },\n "debtorAgent" : {\n "bic" : "SANDBOXX"\n },\n "endToEndId" : "NOTPROVIDED",\n "paymentInformationId" : "NOTPROVIDED",\n "unstructuredRemittanceInformation" : "5NQK42ECTG8T6QPC8SGQ8RKA2SJRZH173F7FQH5MVNES0QCA0Z2G"\n }\n } ]\n } ]\n}','\n',char(10)));
INSERT INTO NexusBankTransactions VALUES(2,'AcctSvcrRef:9FJHVCIE',1,'CRDT','TESTKUDOS','18','BOOK',NULL,replace('{\n "amount" : "TESTKUDOS:18",\n "creditDebitIndicator" : "CRDT",\n "status" : "BOOK",\n "bankTransactionCode" : "PMNT-ICDT-ESCT",\n "valueDate" : "2022-08-14Z",\n "bookingDate" : "2022-08-14Z",\n "accountServicerRef" : "9FJHVCIE",\n "batches" : [ {\n "batchTransactions" : [ {\n "amount" : "TESTKUDOS:18",\n "creditDebitIndicator" : "CRDT",\n "details" : {\n "debtor" : {\n "name" : "Name unknown"\n },\n "debtorAccount" : {\n "iban" : "DE960957"\n },\n "debtorAgent" : {\n "bic" : "SANDBOXX"\n },\n "endToEndId" : "NOTPROVIDED",\n "paymentInformationId" : "NOTPROVIDED",\n "unstructuredRemittanceInformation" : "KQJQ0AB6CCX894AD76K0RPE9KDJSQFX8KA2G4R53HF59N3JKJWB0"\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'308204bf020100300d06092a864886f70d0101010500048204a9308204a50201000282010100a98f234b85e2320ecfc524a1fdf1f3a8e6cbff6b069257991cb796c0386b852aa33a4c955bbbe2e3421d3536a1b46e1ad9c1c46c5c014a1a83d7decee56eacb1e804d1d815d2fc6bfba3ab3b460e16c0e3b6594617741aebbd473c026a37d8f4b02df6b4d71aa75c6ece639a3eb0bb93bcfe484f1d9e8f9dbbb297d5aeb089bf3cbf80d5cca1c0e4c9d9ffaffe5729ec01d5ee6d791162ad5f323eb96a5a6d9161b0246951dbeaac266028ec6dc144a230800dc967d31113be554b557be387a7f5b1609b303be30a88d73761e5001fee3a1832d6498da922163bca7fe95c895b3b0708ff5e5737a88ceffcfab66edff1611e678738bb960ec4c8ee993853a07502030100010282010100873b570e0be8bcbddd6dc16ac56bac46c0546110cdfbf78b7140e725c599d36a8f26971fe43af4990608df8103f5307f8fbf1fd6c08672c0b4f87d868babfa6625c37a4d9a125d2a0e5799e0bb5dcf3de61f70121bf088ec0d58fbfe7d12afa16fc628e6504cbcc056cb9adad1370953aa3f3012916ffde0f26b5cf79accc7fe86941719682c04c0966786f25891d68b9c4262e3e6b6cfac1dbd8a6987f888f1d3df93b0105f67115bae735f88aa5af6c58ee4df87a2da8543e74a1dc1a797e26b404c9bd2601072f7414a3c973c1d81176305680952490af74b1f3e7af1ea5b0344f651e3b09e344a31e7e1d8a50c228ccf3ee13b20cb69f6fe57d4e54fc09d02818100d5f7051f39b851014adef87a623c295760b678a7f0ddbc1b54ab7960bef6def30d3786634796ba3561b8042d340ef645f75f72c54711dd50b3e012e615a93a165aec9bcf4bc822ae5cfc5c2695f2c1dd85e179c04c738422d78a3b9720cfc6bb453643d84eedc710edaaacf1af9c97c1cad94497a2ed415666afb9f8d98629f302818100cadecf09378e9f9fbc299fa0b244506bddcf913f1c4f936067c7f6c62595119b555c4e3b3ab2645f11ba85045c97ec7cf2822bdadcab5903757100debc6317f9050a8aea13c6518122d13c1c0c925ca9da18e451664c93241f8c657db684f2671466ead26355094de4fe78a9c999a544f8864eacde3d10f2494813eb0ce4fdf702818100b891965c8238e9bf98ab506299dcd5b8a717a06b164edfd61faaaf50724a98b5c6dfefd0324fe61ee845896cc8ec632aa5a23369d3cda840d679633410d962df27ddd4e5f3b4179e9b5da1cc332b2e6a7df3ab47e36afe3fe3f83d4137afa3f9a5519322c3ab3f3dee167d8b1a76953e395244661dc855c5475d2caa6a51de5b028181008152fc04522857558aabb618c8cb87c0db8ba079ece04580e567b1c6aada9678c137b09f4d51bf6e636cd5b2ec1be523d9ac65ac8593ad90e8e2fabd02b6e0e75bf15690d5be4ce2d7812ea26ad93abd044d6deefe19be8afe998f714e52fdfbfc23877a4adc40ac2958972f15571ee612cffb8373c0d5f6be0476be16603c0d0281807a11d70ac918e12e37e6cccdeb476bd180b99f741a3275a94ff11a67874f6a0d1251770dc0eed93d03491cd0143506540b84ed7c3dbcee9b2b978fcd207b89d1cb4fe3eacca22330f7e9596bdda85b02693d9007be8a2cc2c242c8385804747423541d5e29134c8396c869df2fab78fc2800f694e9abc14d555194dfdf8c47c0',X'308204bc020100300d06092a864886f70d0101010500048204a6308204a20201000282010100ae4f264677fc794dbe46de647d84568539d13db85d7ccfcec725a119a9070fe4a3c76977db90268b8c332e3479bf477cf3b9fb3845471834c16bfa87cdf634acfe37ca367954dc6bd33718aa4bb4f569878581ebd9bf27e50e6009deb000ac71d4b1dcb09aedb1b540d795d618cc97f7c95da1bc1b5bf2f0b3b1eae7ce12b1a1353eb7385e452d40ea9b4e31d31113a90fa711d6ff2db7e890999fcaf535d3dfdf48bc6b90bb6f21be639ae52e4c2f7642a148b69da432ea4e2d0237a635f85950b284246a599862ccdf170fec27537644eb3c1ba3cc4e67ed7c3d580ff9e96fd45743580ab908d62740f502ce925d9fa84706aa0375f7a44172fe09e38b0a2f020301000102820100447c1a88b359c1fb3698378679fe45d4204c4298ae3a7c973c8d5f476aaeb8a2d76a60d8d3ae4646abb5ec2077f91c484ea632bb001517c09a822733b64b5694e568dc0d1d0ca771c1d1b2e22dce92617cfa8a7a34da32fd7ef162cf588d5b337a22cb97a3b7620bd9c71a3abd119d5fa081262b7700606a0be00a703afa0349b2554aef3b40e6dac425da2cbf7fc281771ba95a5460ad82b7594cc2a7c5d82bb146233174a09ad58bf0f0a8fa9593898baaaef898b99d20a1503ef4a84df43cde0a1b888952e8548d9226721dff7bd6397ca0dcd9ede7a13e359a25012c1aec7e74b17a2832d5ac475b01f99489ce63e9dc7a7321f3e4a7d2be6c6ba6b27fd102818100d5db5cabe401f7d4d52588da6881310944b80916abc5e4a505945f557795a7d7721fcaf8b6dfc90e338860331e7a81d4ff473e682c8b6a4074efe1facdf8e7e2470c241ed56e6b07ec5f00c8a9c448ae7cb1421a2af587efe7739e89c14f40a2fd1713cdcc33d1d3d6a5c11c74dfcffbb3a4c267312204b4a402f555d6a5641902818100d0a8afff04dfdb19e97d622205326b50fc39bea71351893da0fe128e7adde225c7f68fcd1155a2562ab895bc89d2ca61a1a400de58e543e2440c60812ca423935716e4fb4360f99a02af315407d25da6a6d79d96becb53894b6e6a11186bd811ad2764041e3d043194595f617f9ce8f3a8c0687961491dae17a4d5c4df0d6987028180691e7880ed84a22375da0b59004170af139e3aa97029c7e7edc42ed03e05cc08b4ca37e4e54f3eeec219e8df77bdd40fb4a37a638e71c0fa8a0057de065cb0eea2e9aedf911dc372939767353b6d86246e9a5ad9ae001e9fa7ef4720836ac764d66eff870b36f58ee1557c84d656254f9dd000d6e469ca5258c4337fcc1064110281804a174bff2ad4ee30e246e25ca029ca0f84b06071651bb3b6cd7eca4a0b78d43f842499e5403d7f1a47ab29883c0c3c4eb49dcead2535ab88218f9f88deb81de5c8abd97d1aecc95495956dd79fbb6403b404a5f18c2818ae8cb9553262d090759e5d795739018386b35d94cfc3078d744fbc9a9c571e264ad61c72c7a84853eb0281803122f5e79a619116d90378d4d6e41f74d31fddafc40bb6b0f00559bc31bc4f3983005a03fa42bb03e043aa07dd7137ac2eba64d9ab511bf893859cb7cd6835d187038250311e6b2e988594d7516e0406d9cb5e1a86d789002cc1b35a8e5165fe96a7b4a24f48a0a1b1f9dfac8198569e4b14cbb8420576f7aa36478bb73e2d60',X'308204be020100300d06092a864886f70d0101010500048204a8308204a4020100028201010090c82c95aae10562d7269f018edee306f3d8f3c4cd2c18f89bdfeb783bea6b14d50aeeebafd8506271321c02f523dace71bdf58906dd97abaa8f05bb9116894ff3e64e64df09503e91dab2df48dca92de0ea4f81e6fb53b6640d6a64525c70d2d88b8955d30e1427716e26e5c18a8e4826182132a434023b55d13923479e9839568de1a7f95ace5099ce7bd1b63b289cc7a3def9175be076d09bef2c651468f74fe4b19d1945bd409caa4eddb25c5aa641a8e453afdcec65141bb7e842f29b54fc09e4bc1d8e9529e82873758e3d6b204106abd0fbf7e8eac46a91aa4074d5fae692865f5e207952f117312dfdeed8c456c792ab1d3f14173abba748ff0118df02030100010282010100812c07133554f4003e62b7c4a51a58c53034253135b89d42d9974b3787855b2a47f52c3add358a6a7a01b21a356a5ae28b7a66a16d9db09f3959c74c9462ddf9966aa910b829500db305c3471173c60127c50550a9ab1c02037c30aaf70c80a0ad10b963f81c7c80c063fd92493dfc3984bb4c8b291339d68477599a0f6100fff6edb666e17fbd42b4781fafd0db578b0fb8490dfcdb4a3922817ba090a539f6674ffd9e8a1ef090f668d6ef4195c4a8b839067ce81a334effbe1aa71d422a7099b2fd034bdca46f51d4bc9726906f4ad1de797dba089fc75e12e1dd5c5e087ed42a587a7aed655995f80c4e328559cde4867cb921268d4701f15b827280bd6902818100cd2c467cc6e97a2b88907fd969793ea6baae39fab1496c4f28b4be4d0e2d89ef8eb8f0ba95d8207210d250986bf843845ebfcc9023174fefd8e0d5a5829d310ee3a28d7a10b84fb7572ee8500266adf666a5cfb1828a83c1307d88c579289407d3485128a0c0301479b38013bc61fe6663233c4365500371c528d5be44a62ccb02818100b4a6006419f851d168bdf2449c332e7bb1f94e4277b3b8af84a7d2f69f2a63c6967123dc80d22e9a440cdbe589c242c5c3ad6238723f821f387c0226a03a0fabeb5ef41277ce6ff39e3c78ca0937443e8244f6eab916fa727f80164027dcd2c2a74cc30e6fb06ed4ce10091ce35cf65f9f6de25fef3dbc58635f1f67c5a435bd0281807a112072b6294c6d4017b068da4eaf4ea4fc6934546bf98b730d6db70c7b5d78703269cea8bde837d4f83bc9235b9657d7c346e26e6e3d39d68f95ac9df405aef511ce18548043b531a28fc6a25712a2e9593723462640d31c95635d118369e6e9f6398af170c66a3829ea4653aafd9f4ed634d168225d9a3f91d6f11788c2570281810083efcdcf4e6c5f8d5b3b878af6ae26dfeebf4f9a1a04e7f94120b562ac22f09664e02339f3d80e735b0a2d3c7b1da758fb2e51d33a160a3a352dd50052fbb4e0725a7a5656ac2e75b677221d2517f93ed233fe46b68202cec7324c8df4cf421b2ac7549ae195f18c79279b103f3a7132aba53cb5a66ce77782b441a2afe5dbdd02818072eddbc2232b747a5e53a1975f52eaa314e6f37ad3e046c620aa4e490db099e7f8917f1e6ee68c187a5e2acd1e3ec04ee2a1b157ddd05a9daddc298f535bac76ab43b65c9f34ba47a01fa1aa5d1eecc941419c7107f8824c7ffede704369c4d9b6478acc63a81feb4b1ab0ce61cd6b9ee30d31147526ab5506b6e2e87e1615a9',X'30820122300d06092a864886f70d01010105000382010f003082010a028201010085919c125c14de88e60286224002b448696bbfd9192169490f5a062a94e6a8cfe513f482631057a34c7872638c2b842ec0357f9964b2e34dd845b5d50ace627e57cbc115d2cd517ed8c5cdd4956e2092d24e7134b0928d5fccf43d38df49f2d3ffef1b0ef9dc98b68fd3c4e3fb025a8a1849bf8bc5e75c782393d4f840f6238f972a6a2b4276da780b47581bbc79300b6560ea6bd9b6247caad729fb906c78ff50bdb29ffcd357adf30833173620011c7534e7c14e434106403b996f381fc0f9c64a126dce7b6db7a9fadfdf614d97d15fed69a6e7a74163740a0e6012f96a5c343f02338fd38993d086e63e25f00076852ea4d0eefb405df240984a12c9e02b0203010001',X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100be91b409c2b3f590dd32368c0da9444d61dbbc92d99a64bfa1e427e964672eee4bdcdaf110395aef20f7a5b756bad1be016b24a7e764a7a2816cb84e9228224dd49e41a031812d4b7bedc9f5bb24e0cb0b7a13c3b29f05ab3e8ac382f866bb101600a9776a279c10492f9e7530b3aa4ba2ea352b1bfa113504685dac91ed5356ece317cc3c1539ae85f7afdf0d098bb7d5cbb8540fad57cb7fc34b789831b6d47842b72c5e3887dd9a281aa9123504ac9e5da4d742eb943a70a4e6f1387e642027b60aa8317df205f8afb7f7d5d3ff3ed7dd2a079138090998ca5b124caf956e4841fa53d4b5495c9348b76c4c8c252921f16c725076c1de60b6c09af4ddac0f0203010001',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,'5NQK42ECTG8T6QPC8SGQ8RKA2SJRZH173F7FQH5MVNES0QCA0Z2G',1660491055041,'payto://iban/SANDBOXX/DE540064?receiver-name=Name+unknown');
INSERT INTO TalerIncomingPayments VALUES(2,2,'KQJQ0AB6CCX894AD76K0RPE9KDJSQFX8KA2G4R53HF59N3JKJWB0',1660491063841,'payto://iban/SANDBOXX/DE960957?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-1660491043521','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313034333532313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a34332e3532313539375a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a34332e3532313539375a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(2,1,'sandbox-1660491045859','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313034353835393c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a34352e3835393630345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a34352e3835393630345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(3,1,'sandbox-1660491048106','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313034383130363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a34382e31303633365a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a34382e31303633365a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(4,1,'sandbox-1660491050324','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313035303332343c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a35302e3332343036385a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a35302e3332343036385a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(5,1,'sandbox-1660491052531','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313035323533313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a35322e3533313539355a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a35322e3533313539355a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(6,1,'sandbox-1660491054737','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313035343733373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a35342e3733373330335a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a35342e3733373330335a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e5941335a364847413c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453534303036343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e354e514b3432454354473854365150433853475138524b4132534a525a483137334637465148354d564e455330514341305a32473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(7,1,'sandbox-1660491057119','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313035373131393c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a35372e3131393033395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a35372e3131393033395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e5941335a364847413c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453534303036343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e354e514b3432454354473854365150433853475138524b4132534a525a483137334637465148354d564e455330514341305a32473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(8,1,'sandbox-1660491059325','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313035393332353c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a35392e3332353739395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33303a35392e3332353739395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e5941335a364847413c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453534303036343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e354e514b3432454354473854365150433853475138524b4132534a525a483137334637465148354d564e455330514341305a32473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(9,1,'sandbox-1660491061521','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313036313532313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a30312e3532313838355a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a30312e3532313838355a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e5941335a364847413c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453534303036343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e354e514b3432454354473854365150433853475138524b4132534a525a483137334637465148354d564e455330514341305a32473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(10,1,'sandbox-1660491063697','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313036333639373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a30332e3639373239315a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a30332e3639373239315a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e5941335a364847413c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453534303036343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e354e514b3432454354473854365150433853475138524b4132534a525a483137334637465148354d564e455330514341305a32473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e39464a48564349453c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453936303935373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b514a5130414236434358383934414437364b30525045394b444a53514658384b41324734523533484635394e334a4b4a5742303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(11,1,'sandbox-1660491065903','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313036353930333c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a30352e3930333338325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a30352e3930333338325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e5941335a364847413c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453534303036343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e354e514b3432454354473854365150433853475138524b4132534a525a483137334637465148354d564e455330514341305a32473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e39464a48564349453c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453936303935373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b514a5130414236434358383934414437364b30525045394b444a53514658384b41324734523533484635394e334a4b4a5742303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(12,1,'sandbox-1660491068071','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313036383037313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a30382e3037313834315a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a30382e3037313834315a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e5941335a364847413c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453534303036343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e354e514b3432454354473854365150433853475138524b4132534a525a483137334637465148354d564e455330514341305a32473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e39464a48564349453c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453936303935373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b514a5130414236434358383934414437364b30525045394b444a53514658384b41324734523533484635394e334a4b4a5742303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(13,1,'sandbox-1660491070231','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313037303233313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a31302e3233313835325a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a31302e3233313835325a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e5941335a364847413c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453534303036343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e354e514b3432454354473854365150433853475138524b4132534a525a483137334637465148354d564e455330514341305a32473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e39464a48564349453c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453936303935373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b514a5130414236434358383934414437364b30525045394b444a53514658384b41324734523533484635394e334a4b4a5742303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(14,1,'sandbox-1660491072386','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313037323338363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a31322e33383639365a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a31322e33383639365a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e5941335a364847413c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453534303036343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e354e514b3432454354473854365150433853475138524b4132534a525a483137334637465148354d564e455330514341305a32473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e39464a48564349453c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453936303935373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b514a5130414236434358383934414437364b30525045394b444a53514658384b41324734523533484635394e334a4b4a5742303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(15,1,'sandbox-1660491074553','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303439313037343535333c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a31342e3535333232345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31345431353a33313a31342e3535333232345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453132383538303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e5941335a364847413c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453534303036343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e354e514b3432454354473854365150433853475138524b4132534a525a483137334637465148354d564e455330514341305a32473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31345a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e39464a48564349453c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453936303935373c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e4b514a5130414236434358383934414437364b30525045394b444a53514658384b41324734523533484635394e334a4b4a5742303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',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,'DE128580','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;
|
