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/DE471160?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'30820122300d06092a864886f70d01010105000382010f003082010a02820101008f361aea2e49a8e0cb4d171cd620687ea7f6ba16948c9c19708995f328ea3590eaffbab67c01619b79eff54dd3e2d5db235e9ddbe773ce38a01bf06ecf4727fc0e218e357c812c897ab43743f39a42b9a879924e23eebdf0104a90b04c0c840ac79903f4fb74a01062d94bf2022733b985f1c9e608707e59c1c28e6fb62221f34fe8b47f6e038c2b7435360e376b86520f51047800287aaa5bde8b39d4634ed36f81b7f7c221cebbd2984c279796f3556b46d631b6f74e40c700ae299ceb9a7fc7b76a9a0670380d34328335b4699af88433033ed149e1061d6b65f88e070cd22d305a757956450bc4ac5c1e33d52f150152b93cf38f645e2644c9049cdd5e210203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(2,X'30820122300d06092a864886f70d01010105000382010f003082010a028201010098de1ce451c26f798e3878c22f0babe20f455c058f0220bf417fbbb139a452853bb01630e09d7dfbc1f0d43e34e70d8b4f44b91d63d350c0195b20e8d835bd4fdf3d0c19ad696e5c5a0c042474c65c9a56a88e8e8b90d24448a58078c512f0bad5c0e580855064734db6aaf9bad048cd114edc831ac546d4e302f8bc18e839060b62d118d1980bb33e50bbf5074e0b717abd862ddcd0ff5f285fd5ce68f8e708e2231c61290d731dea24fdb6d91ee53b4d501c3fe7e23bb5b6395264a8371593e854ed9a8cda83fda172721b3da6353c40df4ee674ac35952f28b2ba4d51964b0cac4234920601c58f66fb5ee2f4a655486a798d1b1cdfdf6ee425053faa14430203010001',1);
INSERT INTO EbicsSubscriberPublicKeys VALUES(3,X'30820122300d06092a864886f70d01010105000382010f003082010a02820101009eda7985dc8cf6137e3fa652617f38d831a2f2322e551a01eb41a5cae37a326b99be1e5febe0f5bdff4f3cf4a0872440bbf45e7d94c20be2d71d209f3c3fbae1dff3788fa5db17667f076af85e42268d43eb3fbdb5b9b59c0d5adb5f7c351f3b17c81929a10d7d60dff1276eea8f11082142f1ea274e21e227564a7cea5c4df3147b0a6cb60d01d9a2b7f938e117a441269c078b6c9504cfc4c37f0783d282009664803cd6dbd2827345b2a43e34d33bdba79fb388a638c54c2f0e040055bb3afcabf2c516be88b6da6409a4d4a80c288e68ee820f919c08c0a4690e1806cc957ada81d87c89fbde078ea6b73c642f41e0c8b8aa5e6e3d50828e8c2ed73bced50203010001',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,'DE471160','SANDBOXX','Exchange Company','DE236345','SANDBOXX','Name unknown','QMGEMFDMCHXBTH3V1NZVBFWE1JAV69FSBPTQ9ZQ47D1VT15A1PVG','10','TESTKUDOS',1660654404619,'EUNCGUQX',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(2,'DE471160','SANDBOXX','Exchange Company','DE236345','SANDBOXX','Name unknown','QMGEMFDMCHXBTH3V1NZVBFWE1JAV69FSBPTQ9ZQ47D1VT15A1PVG','10','TESTKUDOS',1660654404619,'EUNCGUQX',NULL,'DBIT',9,1);
INSERT INTO BankAccountTransactions VALUES(3,'DE471160','SANDBOXX','Exchange Company','DE209794','SANDBOXX','Name unknown','3T6WV8QNVR1J7GQXSFX54Y71K91ZHH6K22840EM1GNSA4EBYC900','18','TESTKUDOS',1660654412000,'F52CKZKJ',NULL,'CRDT',4,1);
INSERT INTO BankAccountTransactions VALUES(4,'DE471160','SANDBOXX','Exchange Company','DE209794','SANDBOXX','Name unknown','3T6WV8QNVR1J7GQXSFX54Y71K91ZHH6K22840EM1GNSA4EBYC900','18','TESTKUDOS',1660654412000,'F52CKZKJ',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,'DE722747','SANDBOXX','bank','bank',0,1,NULL);
INSERT INTO BankAccounts VALUES(2,'DE846799','SANDBOXX','fortytwo','fortytwo',0,1,NULL);
INSERT INTO BankAccounts VALUES(3,'DE539394','SANDBOXX','fortythree','fortythree',0,1,NULL);
INSERT INTO BankAccounts VALUES(4,'DE471160','SANDBOXX','exchange','exchange',0,1,3);
INSERT INTO BankAccounts VALUES(5,'DE738355','SANDBOXX','tor','tor',0,1,NULL);
INSERT INTO BankAccounts VALUES(6,'DE740674','SANDBOXX','gnunet','gnunet',0,1,NULL);
INSERT INTO BankAccounts VALUES(7,'DE507411','SANDBOXX','tutorial','tutorial',0,1,NULL);
INSERT INTO BankAccounts VALUES(8,'DE889443','SANDBOXX','survey','survey',0,1,NULL);
INSERT INTO BankAccounts VALUES(9,'DE236345','SANDBOXX','testuser-05kjxdzp','testuser-05kjxdzp',0,1,2);
INSERT INTO BankAccounts VALUES(10,'DE209794','SANDBOXX','testuser-nsqdub8m','testuser-nsqdub8m',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'308204bd020100300d06092a864886f70d0101010500048204a7308204a30201000282010100858ce8c54e7620ca6a7f8f647735ec2fa2371c10cd0b82deb97e17dd482c598f563f2370c19c68dc7f2db6544e9bc466b0df5110d7e8c2542d3b0c42831cfad1d916036beb19b6e1782d973d399cc4c4c90d5b684112a55afff1a06b0a423a33306354316833d4fb83029196c886c14052ea106871c676df39719b65ad28e3f668c3061f28f7edb265d39ed30a649f6e8fe8a4b79feea9ef3d2d1db15931943863a49a5043aafa941da6bce039a3728de73d535758426f08777b0d5ebc77842c0b4ef7e80a4205f9e0956bcae4ff7dc4a6d07ecaaeae1c8cbb49e8dd175217d9a1e0fb969bc0e7acddd04b99ab70ef3a09da170959a79cf80cd2276b52777ab3020301000102820100299b8701c1ba27e92858e991c15a396575c279a9fa57f5c3f24288a8d64d8af18f4b487d5eb49e2ee42897bf98660b407b267819294b490ff4af8ad846050757cdac80106544b3a7774bacecd4403545a1e5d96e97a77980ea709b2bfe1c3809aeafa39169078cf9770d9bd240534b6e00e70f899ab8dc5c1b877b84a7f82f5d2856e4eafe61b33b3541a3f326eb0b3dc685faa1652b0a1be37c4157daf2829dc7b712401a2ce8a732cba607a499f6216fd31f475b1feda44b597bce76fc248713c0ad805a86dcc3bd249383cb7d1645b45c6e90b9388873b3886767099948e5aab71c4261c0a3ed616fba54076db1af6c2296208f8fff7b7a372a600d100fe102818100c25bcba147ad4b64f6dccdcfcdbe34da6c6269d3832950393b063e181faf0c8166f7d6a025e33aa113dde881d8185452606d03fe54bfb4bf1b2e60d943569687f5a08febdf3efa0bceeb777dc19c682a9298d68572b2c84e04a515e66359f4508495cb92f6552b1d0fba693cfb774ab596b2c100acc0c90e7ca31c5ce79121ab02818100afe807166689474a64a5b4b1270ea7a73fe365cdc5b3ae549e5f7c054c565a12af7b03a4534793904bd2e654f83ac40455c885c811e35c530704e464232928c79d1e8e1665a6330a74c28ba7a652898b001ad55e1653b9ccab1b8bfb14280d7b60b02186d7dc5b4455a1c923847264ef99f8975e09a6852162d03947f2e293190281805004c7138195216352179a4ca1e25b9449e742b6a85b8c01e4012ff372a7f938159298349b24b070bce331e4b37960ce01912081c7969dedc85d11d6a158b6e50705b1fb64906316157cf057402d0addec392ca9088dfed5d027bf9a78f1021b5c5ae7d37bc398da802d3942b82d66fed82a8437a8e83e5ece85c119a6e523bd02818100a896edac076bcc9abd299fab25aec2f9e59e70a4adb58f0064a548fcdef3e7f1fea31c937289a820e4bae5ac4c182e63a53fc110462cad009a3a93167228718016d30104f03940b3e5c1cb0d4bb7d1411a419d7b4654ca3f21430e7efe0b81185d4b9166661e388e9eafa751d60fb93376532de79fc22bd81a974c3eebc7418902818027592e34cdc06cbb02523b8ecf7ddb93c6a9941419fd119165929e20370fd790d3ba4123941f17f774beb9ba78011dae6bb6fe5fff61a3edf05b693684de5c25b88fda5b04f98d0b548e98dcca49509f18091a0a24a30209ccd7c2259a43ab81934e1f0e4d57cdcb0117d997aaaa2392e53ce0a3b5ee24e5da9f6b68f2f661da',X'308204bc020100300d06092a864886f70d0101010500048204a6308204a20201000282010100827428aae70a10161398e747b8e0bfff43480914d0bddbe3699f31931551eab603d5c2f6b647f8406939086915f94b80f9836393045c475e3d7ead1896254bb1a952a696e57d232cfef6687b0f091dc6275eea88caecee2bb3a5154192d160cc9ec965e5645f439ad6a90ab6a4cafc31f8fa50f31dacee2bb09a630a7d294679552522fe42f6399b7ee0bb6a7052ed671bea616d0a2d57a0b9e1d5058c6d813fb35ea6cd01446b90697193951b8be230b4bdbede531960e1d4650e38df40afa7c3018e63615c731967df6299327e7a0d59ef0d0e07212387b7194d7cb0bf48c6350ce0c4006e2ad14dbf303479ca012cd375913e2fc9430ea53c1cb709aa6b5102030100010282010009428d90740df6ce5a5dc42d07268cfa65a03b64cadc6f3b5947ff90dd368f5e942f1c43bef4a4de8d998acb4ad00358085e17375c5be085040075f104d768e4178cd25e6bb3d2476361c250d9e45fc4ad0ec3bf2a085f6fa2b4d9296a6e8a5c7bf8f7ceacad46733b418c8d226d763165e6fed0030f3f68c28472fb4f9f1a6d7072f9d548dc00db225c6e0235415d80348b13fffe5e6589aabe52e07405d0842a6ab30349c4ebdc1fc570c334f6f9d24f57174e35a80f5a286ac8ec8f9a817f26fdf0e0a83ef196ca93fa370135bfdf0a36caeac84d640340789762a214dcd271a93f8cbc0a52692ab47fdd318f3116d3332436040811c9eb1d8346f08b214102818100be15e72c8d3fdc2594e50217fbb09c6ab3bdbda1da479ba5dcf0e781005db56b1c584cad1b9e7f61e09c57d6122a3667ad2e9e332c865b6f3b9ddb8d8403d68cfc91cae909c733f844652fab5216503f2c0cf76ae56b4aa145b10b3da4e264a0601a65631411061c8b82ef4e30a70da7f977c5b6bb28b0c771870012056dcf6d02818100afb0ad2ab5dc9256427ee5337589bb37ba193d44c8878725c5638577d737d416063f8132581965691b58d603d6da957b7bb49f62e5f4424c875633ce5395b755bd925464edba203794e8372ae1afa496d0738597821d10fed988677d427aff7b1a14f96602352aad6ef02bacc1856b5fa2a2098a156ba470509314ea5d4588f5028180102295d3ef4d7b67694323315bf8fade07d1d455f7cc5a46f30133f57c4d7807d6891c41197613c40027e540d39be7b0573ffcc7c540c66423c05b91a0a21ec52aef49350cd26ef3e5025dd0821048d183f0b9d3c6139c6b221a4c24f8690b379dd0bfc8703c9db3309875adc26d7bb84571c843a1916ba81257ee4699555fe50281805c680acc9a16c7894334470d47d707778a14585b63359569d26643ff025dc4d948b4021a1ea84ce47993c20d06e6b514dbbde6cf37afbf674d0f93f403968d75355e4fb13e30555da69e74d5c31a84f125f67cdf717a244446da2dc47e40ff3b1a3ec9e65366ef69851e217a9dd6b4e0fa434bcd2af310ec5a14e23d5a8d86390281803c82302edd6b9347e6736cfb676ea278db4cf80feb0cecca6a3353a33925adb31bc962d752043b7ae1eb864bd6d2c9871c24e976af0d747ec3cacb0bb8fb71ddecf2728995b17b967b582d77b620f0fa9eaf80f21bfdbf396a15458febae680d600e8679021b610b93d9ca3ef70e9eae4faefa1c3ed4ba950c48059e002337b7',X'308204bd020100300d06092a864886f70d0101010500048204a7308204a3020100028201010096ce919bd54c4d0cb54623238d010d1899858f251cd73d7bef09d1ce4ad19b1bcf1bf8018b493d162837eed7010ff56f4b99062f92827ec261fcc7baafd8e18912a882443c0f34a20c41af878252740af2099f517386c4d23b0344a457d520cc7568eec9e7a840ea748f3c95e03a380a68087b885d59e3e3ce553e922effdd1a20970ad08b4162d1869222995a5fcefff95e559fe98e86e74bcac6c4a56cdf4bfdcafc6a38a4e09a00155bcbc3865f24e3f6c1df71d87cba296ea9e45d8701b72b439748330c884898d41ca5ef2d41c9151413dfc5a2dbfa1db9dfadf1cdd47052dc05bb173e2975ff863d72b4654e8fc5d338cf18585276f3ae2f3da3a18a5502030100010282010033fd1883715ff17bfd0e25d4feaa2b1a9cea4733d3227ca6b9fc57a0d7783511bc2f772b091a817d9ef5d157bb9d05ce8d703e8aade660cea03b259bbd3d765aebdcbdb3ca44afaf61ac4f57d6dc97f6a2042131523356ace6fd346fb77bd8e7c35e1e5bea89bd7f56197f1868098a02446510392d7d6cabbf18f20e3137b1bfe5773975eac6f71b22b398aa20bc1f892a66beafcb2e1c325966fd365a86db13457f9b4346e802cfbc8b2e7c3a8f0fff2fcb8e187391c4793dbc144c6e1401478763ddbb2f9befa434fb2ffc393537c8596b8d92fb95ec9c588eca9aed05ded3ea346972934125cb19aca512182e14292f7be4dcd59a5221ea81d815101d8fad02818100cde1927276207582ca4ed73dd6e3dde5b1068fe3b868afdb014d257864f3edd22b2f3ec94f391c52b2914a1d46429fa9d0b7ccebcc10e756e1bb26336482d9bbfe62dbadd2b236a22a53ccb7f65df678f11bd4a476ce6eb2fcb48de24041faf5424d61b019a4093fafb89b5c56d736b4889878d1f77a39b49def210f1d92a9ab02818100bb84cb14f0481f3dec26855d1b53c829235efa56adf877775f78c8e82e0ea9dce4da4199f3e332b390e1188555b762a1d737af0179a1bcda77c93f2dbbc47eb0d91a8da1ff8d19f4f87f0e0bfc42bbe4104ce0bca33377f5b9bfbee4a8ea1736d16adf794fe3f8133cb6a829e8928ad9e512e80bf77669065bd289b675709bff02818100bfb8fe4dc51f790ef122f6624a092d0cc70bdb572ed59e5e0e1a2f78ac5a53efd1f34f3edc9dcc785e7dda4ce4af0a4c736796574753be7b33feba1645d56cba1aad28f1f831a99ade5be75ab0fcd397d0c020077ff3c136c109cacf1513dc8624d636d06d304ac499f90a04b581f919a9d28340d47b67dd80edbd157c6ea5bd02818052e4ca0d9086a160f342b813c79fcaccfcb8e0bb6e9e76d94b580ea02cb408bd0061c73c32470e43b8d8f8c9007257e4a94a114ffa9fd7e74faaa406288a1d633a25f5d4562edef99edc33ae72ae6176d909d31330a5f0f2ac512a26d4d0dec039e51fb2f5f115da132dbfbafef7c0efbfc712d32f6aa5d4ccc48e621d1a51ab02818037a498582bdd58c499ae940fe73d70e619da0fa459d0990cb28037c9ccc9cb5663d6a0e5ec7570351f00aa5fe4eb3470cf2e288c100c938bb0d3f35709b3b361f2cfc56eb756d06b6c4724d13c5d5b05d6d8e15b2fa7e3c74006109101adcde2e4a56fa6731c9eae29724827d79633ea00462acc7e54af46dcdea3e125ee38e5');
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('9D85400B26E51F1BB01ED0A2B6B437C4','HTD',1,1,'f7E6QnoF6DgeAO2vqv00GMH+D93Whi3CXF1nQIKRmRcKJ4CLd5afnLPP3OXZ4ooefQDl9SzKgJ09wpbBWsqtvD2QKfoafkVbIqF7gFkFY3jJzSz1zXAt47Zl+7fsuFin9IwB2WjyLGNTUuR61oSiCuryJvDZElA6eCzKh5D/7DHR2OO0Wu3G/XbedgyFKgUvHjob3jus5e5kJH6/hBVAKlkrg5CRoOeYOqCwEpyjaB9NM3oKtEkjjOaiEGi+x797H3/Px+2dnuNaEIuuFubkW9EFN+YS1sFbsJ8Xc8VipZ7MqN8AoxX+Ol1RnTu5YlO5rThfPHfIncQ6++d2l4WCWIkjhm8wpZGsLjSJhb+zj16pnKeZSGo1IM0nL7v9AjnfgTmedTJr2qMPreN5MLpJiY2NwyiND2hwTojlOor5Uv8+qg5QF9t7o1ULIKBhQGrk7OnWJ46wZExTe1mYFrYGdK5FhpHvooeJqxOvHA5WlxsKyburKVnvDHaGAKBBJnsgnsooXMFXArR17n7/Tqhbqv3x/mcRQpBq/KinXhL8VQCIjVJxLdmD2a7lqSQDIcAsAESPpOzHXqmMeaHQvRg52Z+4tmBWSAYEsBUpi/Ovx8Ru2KYFEfTq4tFQ0rpLUCb1O5RNn2aH1jniZVhWg06RCqIhZRkMlNw56S5bj2BVF+vnfODVyKTIE058eL8bsPHvvHZvDtchnmZ6BWSow4HUWw==',X'4b752aab6d45eeadfbee59989bbfcc2fb6e42ed770443178af5a316e8d0e531635bae91dd0cc2bc40fcf59d84e96880f2c04f6c1ea956bf1bb1bf1b512cdda0c5db317137be9418fa96c2796d56a098e2cbc7ae0f31dcd9930b7e54ec136d3262fc969d798aba4897105039326b6241063092435c14239c8b7231609e9638a170e4c37b978b83c32b5d1ac395f611b80f8ebba7af20561ffccfc1ed19a2527aafe9da5b8063e5bbe7ae82d4a85fb603c1dca754ea91980a4384dd881c2ae25ae1653e587ddc8c480afee27ed5228705fee69c68e3d4116958808b0129ef500cf685e2fa3c96090810e503a7544d60861660784815a4a3ac65c1051c0d27c3afe',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('017283C647830FE03B9A1B1BD1D61296','C52',1,1,'cyh5LC/vFUygRtSNOPbMHdZxKfa4oaZ4Qjp5l2UvjgzkzcITe8UY+tesPuMVajNAMDmBoqatfyYPsHQvYxEhLZ914EigXsReZta9PyFQprQ+s+APB0zpTC/00SoVqgZIA1gyJ1rSwvN1k2VmYbxmGK4uUWkfmIurmc+YZoFsu4dZ6bJSrkeXwBNLKWznCm5SJiw+mc/zJBCcBT5MrkRSpHOh9Ll1wPRNOLHG47blvdOxObwb5QK3WfL8epko67pSJpaf+Z1cDT14JArnb6edlG/f6+rmhi8vx0uFSwk/EDVXPHKLAu5lAjp/fgw8hex/BFaPq/3fJVggG/IYY/yRubdl8aHXz4g4ngIcqq1hgCYkeakHgOiErx2ugCkBeXQz1hZ2jXn5T+H9BhgomObVUPHuYLDlUo9sMbEJ6D5Wf2oGRcE2SU1y7unaWV4KJ2kIN4vruCI2ewrRqxGkI42IYXJfhtBReduCQYFokfEK2u6s87X0OYv2KKjhxGg90wt5xwr9rU8jJvl14TBU5KKF3w70UkmxD+2Z+IiY6yuJUg1KDHJYHOeLG7pMNX1p5o+MiT2jEvsQnHlvBFlp8Iby4H/uD1AxnCbfxCdwjikyQ+yOdqw4lR1xJR7Wg3R65wXZLblEmjSx2FnSWX+KGgpXn9LZucC4lXHeMeldbCYe45vpdyqlP1tW2vO4nVr0sTusyPzIbXVbcnA5p1vCZ0qfRytqqtKUkvDct7Ot0iewWoLI+bNIChRhYSagFDBEbZq9cMVGAKCMRGFLGQft/6Kh7aoEAGpt8C8Rl+uru/fMowh2hDca6TyrxfhouMPFQRkK8LtRtkOYD93DhcZ7LnrU+dfosrdkh2qtOAIbeK89uaM=',X'11c120c9d71f3b588dc76646077eeb5890a063b39c694b469aca807b4f4c148d5089a447a4714b45cc3fcf405e4aff09a778af235ace80ec8ca83bef48fea9d1c133afbcdd25544a0d47f8421d758b0eb88c60690ad030de63e1a3d49fef7e14cba54f68d2f595282349b9b2563be5752c8905e1a3505185a88b54035128ad43c57cb40533f4a1ac18a9dd960d60a8b8c355a765fa976225090703aca0c0d21e3e7b04b55d939720216253746c916b1110514907a119a85550ccdcf25aa5f27b8334834482ded818b900aa05c8af824a6938053d861dfd44e031db3e2a049513d02a11b9a89cad6ae4cda17021c07565c1f0f2755f112a4bdd8502690ed6ccc2',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('032766A47D3CAF2236DDA082C3109CA9','C52',1,1,'GlKlvqb9EQz5oM3Dw6GR9LgmS+6jojp23uXgsCheGIM2e9Z70VQBYa2MZZKjdMrs5DHD7OoT1iWggKCzG8MikFarvrdJix1+KZBjyejOaKeWC2aPhe8v8hkvmWwK+bqRu+MBRMgphQmuj9GzGL/DF1voRGDr6oWQHre06qrVm2C+Mk+Sj+qIvNo+1pz354cUx6G0n4b4X3TOiWFV2t75aqYHDyw3yPUqMeMPgCXaxHNfdj5zrB3/as4AwXRBRH3J570O8Z4TY+x96mLa1iLRKG7QCb/m1+cgkTY0084NxDYTY7A3Xm0bjVkn0D3hSyCuOMOB17B3LxjqLaa4N9Z33h3TLkz9JITrrHo22/ccj/dtynA1UruisE8/GIFxcpgNiMDq8GyckYkXeIX+lMWAGBY5LqnUgozgG0jxwUEdcuQjHiVM/UVJhmwNH7v8Qat6hZakMMW9JgVoJkQavx55lvFLL1PRHsy5NC8x3hSMwwjOPTjyQG5zo5VVIcybipvCGrJhySuDa/tekWnRz/1jS4V4j7/mVWX2ux3QS8Tk1KdFvWSzv4U5lmD3yTdzqmWy0jLT1sD/uks/uTNZ+c2YmcjZ+9zILKfgs/LmUuFDJSIHX/Wqe1jeW/MHrbEp8qfAOf48kHGUbhN5zcXVif+Zp9zzE/Q1SzQlbwo0WMCl8RHZC7Syn2/00b3dAr4dDrHYGGyDYKuzQGMZ0JXlbcYBXeZDy2ucURi73WizP4Mfwt+go8o+4IZmxfGkiIKDk8RfjfApIUG/IGDBzM9avy4zWi1zIdx+nMZfUzJLOxcG+SIFeMXinhSfnq58jxs5aa8KleEz6bhUlYUd3fiUne8ITqHkz5yY5KKMWGzbOxx2V4Y=',X'444f6d4e24750aacbb4c75ecf556928c1f46b0878cceb6c9ee75d2df4e3535bf6863c5d687c81668ddd1c036d332fc3af1926faec0ca8aaddbe4507f1d42b308ec1ce1a1ff234fb367541bfc1f149f69bf83420ea8154a8618d25b45da462817acc5b6a89d4b87246db6bc61f8d2895c124163b3cf2f30dbf64aab133798c55b55ba62c03e00700880fd08ae2b8c5e8e40c3508019f1d476a1b272ce6b93c713ae4015de168ca4a9acec060dade3efccc03b91bf83833f29ca3a8b3d66bac8084a1fb3b49009a87e53d998b19d9ffed1d33d6ad25a3102449b9020d419a8323b18bd88fd6b6b587e904656c9dc68176cf531d28d8ef5b346bbe1dd6a58663f1c',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('64687E9EEF749A75C825040D13A61A81','C52',1,1,'qp9v1/3eqInEfxd4rguDb32ZrfplxkoHhSCrI8MlBizMJhKZcpJVxqA4teMhyjE1YmNb2mgbq4RSR0ObL3pWkuD4ScKOKJjjiEsYFURv6Zf+P/NIOVIGnIEuT3b7WcbsN88MT4DPH64GaH0unxrzVDMUdBNri/544xXGUk0gXtH4+T8isOHHXL/h022al84IRaLXVP7tnkPdyNd1b8g15nbOfJtm8FRv7CH0aOyw8wCV6wBUPxjOCmUzysvDfINJu5nIc6dOJez2CvkMFqwI7kSimL8Ns+SZJMnzVCsHV+ppBvxzwvQhbaZWmBqioS4EGcHMNxDjOc6UizU24FZjt8md2Lc8ciLE8RK946puSqL4ZjGOZ5BDRP7J4itr/WpF3gWzThG2KAQLmuZxyIIpEKBpkINmg/p5YRGqlYRKLirGV6jsTZk1Wi2gWsyXrxpD/GWqu3M60ZnuA8Gc+i0RB1ZIlTCOi6xhmO5UKyXQ8HGMujWr+/thwSY9TyFNRJdVckv8zem1gQL86wPAPVQxNOIumu2C3Qmoz/bZ1S4a26LJ4tEJQGeIMExSLAf/7LFkPtAJEOvjOVtcAcBbyF7ZfscL906ttMzOJiQ+zE5Az3Thia3DzXnhuX3bTGZit74sTxsYqsHXBzR1PtDSV3+0Q+00P66XAnEZoHT7O9cvAuNM3ZzS5Md7J1CncfEFQonLc0o6C5lQCAHCMcq3RVXcEoscUfPF8jXt5fIxQTpjR4jY6jTGoSHAHfaWG8Fmm0YpGH9ss5My0kq5r5DfYii56dU01NaVEP8HH7V9GWGeYX+7W6RRNegYW5UCyKRc+szJwwWb67JpzLJKYrgMn6r2cWb3s7Ydv0b+eBIE1JM96zQ=',X'5669a0253eec03e45ede03ec9cf9c3ddfc7721c627628d5b7f8491f0c4b30a8a1e0803c111a9674939163276d26c9ca89dcd3ac7b41467733530720048cfeecb0c23667f7a5d39a4945f097eab67e51de356039eb4130d2863e7506a3c22a4e112f64210a22c965edeb4ee7c331a544b01f6de2aa9b97bdd1f32c0c4392700f4c4deda795cd5380f78014cda41fee3e99545e15b030fdaa8267353b06eae2f633e9e0f2adfdf6793af2806c2f94ed31c8ce2074667fdc71fe4f237661c97a4ec1c3b5e1c57794c14307c82b7580ebdf777c9c434bce0f7161083c0bf1ad32df57e85c8b82b27cb2370dfe8f15e566564a572c138c7d3cb06b2eb20ef5219ab98',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('54F60EB72467867368A646182D0FE1A9','C52',1,1,'X1i8LvJmW3CX2Vho18NBfagyIjc5jaOwLK0dDH6F4tpyIrzkL3JN+vd20J+Pijr366TFD5MKL9LkfUJm+eGOu3w9QSalUuVnK1QUZwo1Hvs0Bv/dmAWKnHPhygXRLqLev9qFtiEu1LZ6wnN/BFZnmxTO7CUm7dxbgUv6xHhTOm1/6u7jCcTAanCFixRFEEF2whiPcGHnYGoU/gj5ffW5Ax5lmUILJnkvEm6q4ipnGk1Q93067ao+LYDeR2yxz6aWLJbbhu/+EwMBCGv+rskaHjV8OLXwEUfXurahOoQGPfFOmBHLLu34W9i7btbhDOC41aI8lLxjdYyG5G2ktQsokOLkxSI9/JcShf44H7m/HDhAAIsavvQl4AlQsNnVPWddySS6pe2vgfqqvT3ukOZ22V9h193BnONNEU7j7lC5o9Au+g3xoNBKQ8fjuA55dVuQdTFvZ/4BczqPHJq+Ck4RIL/N7vA25cdAty4rUmUXLrc8b1JpxB86XiT2cJD+PgppRvrw8c7jx3puUhWNutmMq3oFU3/dzw/1e7OK+y6/s2Zgqkdairyutyc4v9VmxaUD+YI0GSUx+ZgefMH5/rrZGO99lv4oU+uPUygM0ExPQE7b0ppLs6k7xmvtuU4HUTNuegmIOB2X5iShv0LWWM6HZclzs/4Bg4T6hhnF9FBMhSsWLA3Cj0FvtWJywxr3ueurFK7LODtErQDlmEw1UkAqZJzdu2zkM8HYkCYuyzWxh5zMVgmfK2HPVU0NAVrcn0q5MAc/EqKtquye8c/rFAFJrpDVYj2/sfxiiRmzL4FOOYPu4akPE6XBBLI6tX1tyEej3GOeFclvtfQUGHNLjMVGrR1kxRnOpSyC+jKzhdzEbEo=',X'495c010d744e3edc36a63242307d8153de13afc0c78dd29432c9d1266a4930e3690a9ba3df5ca774d3f0636dd274e7a3050b401efa656d66300f5fec28f346a461c94c9c0526bb4d38f45e2319d7d5332e3cb4727b46642f906a256f0cf3ff29dee5d0f3fa1030250760263224bc26034754932b3b696b9ae63681a3767be0bba5e69add3cbd311ae2d2df18f1063148cdd511f051bad0c6ebfb1a7998f84c4818e807757d7452f6ac22cb514fc6478909be2904e3151ebede4807eac0f40b09113da5bbd02bdd1a58cd0bdfa6d3c3c559f42be3361d7cd03956125a9c8f96cac370a3665d9af64c1d6d4933af579ac4344fc84c19a4503cdcfbb14f35774311',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('456EE4EFB76CC5B74AD49DDA834A12BF','C52',1,1,'Liy67YujaTTT39PGBZXxj8xcQNKZgDX7Om9Hv8sEOEGqJKpI5ZnIrNuQMFEINF8sQLs2fDwIM6TFPAye++X6SOIjZL9+OGKp5U8JSAHpaaJq5Na6rCaaWDA3BZbKc0iYCM+fMh9fDWlCGxvY9UfEVWzH4oFrJTDnzMvCSmlTa0YufANZlzuNQSCykObftU/Ewzw0vU4m1qgISyyrQY3Smu5TTpDZAM+Xy8K9gRHEkqKTj1ikjeaLOvoRos/5uLv2urjoh8+0VOjIN1D7GjsdDjW2uCj+IbIkm5oEHOoS0EPysBulFIeZLGpKpEncjsrbJmCX72OjPZ2fhZEkvaWKHNFG126DpOgc8vTopZjSI6YqjNkmdfJlOUKOUcXoi/kgbdOZWItPA1Z2tgyGA5WZD9+QwfhFdACAFamLVF+7P4h52AG6PYz6ohD4YgjQdRC7E7gwTjbpO5NVSfPf4pHbEaXd9QAfrb5DC8p1Ne4ZNXQgwxpgpAf3QyunTkqWlwhhFtnqjARPlMr022xu285Jwn/Q7dTpMQFIHNfNPgmvPcQxcp9GLX15A+klvV3q0kp7H3JVAhMeLVuskJ9QO1mtxafzCoGCo8SjLecnxKlitJEP1Whdq/RZy70z1hl6xzokUojPTiyP319zOzXANGm6jdoKWGv8Eh/0jlf14bL7skLTSCEmIqg9+X04x+C2JxqKBT29VsYwz8l6Oao+0TmMl9dvwCfER+bWP1qCYjoUfNUcaEUVtwxJZaFm9iGmTwnRsAhMUiH6WPdDgXZrEgsISn04EG20fGCq0hEeFDjsIoI8RVgKNdrg0MsRDtnouaEjGfBMx2PHfAdIpJDM1LvOPamIWX2UeUH8qaaHH8zkxlg=',X'61485c2f68e8daf3f97b1dae499df4e7be7359c71f5eef51f987ff17af7ffacf1599be19fa2dcfc8794c193a408bbce528c1807d2b01cf673e457844130bc3d46d4068e3ad39f2c932b41231cbbe0630260da9baa7e8672f36292b3b60d6cdb2c797cec38a33023ea4eeb9c9737c957666a275cf05b310921a2711fcf270848ee88ead5d1316e299c238e312685e56a7a60e4713a3ff49219a614b69c0aea872d2f3b397c8a354a84abb56999526e338727e12ad58c35c487e5992015ae17acc3c38704aec371f8e3fa08b32849bd0848b44dfb4be46a5cdcafadfc4bc602ad5e2cb711086e15f7b2fbeeba3ca53169359b4f14faf7d89766db4e4f28c09369c',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('DD15754D999087DE11227F0ECFAC9E53','C52',1,1,'3w7El8y20EEOLkoZKwfw4aYsTQEeo7mLXL+7uv24L1nkCXVMu2p/rcEdjB7M9Y1DBw1X5l2yDfCFJf0rpEzI+5cEZI4khR76lM99QFzWoA5khPj2C6nYD4UMsu3Ew21CDkpv7PeKsy0Fnp5Z2kGmAzcXiO8OuU0xfJQN1SdhVz9Hw7mXM4lcz/4GJFQgcI0BbKsjxMUfORkPAZRQG1qTuePXqWaYYgDiZM0YWG6bp//CmbktOTp/39uzy/o9JMk/CfL2rBEd3CWDxwuBi0Z9HqRAI2nCzDp79priczVrVgo1uvHabrvI7HiM2uKJrr+m7uscatv9v7QJQ4iFAeNBH2xpA/ZczZIrWC7gvL+G41aEpX59iU5DO5xte/1lwOYp5K+rDj2jdEWh9pecxqzfuAiB5XTyqdVr6QTrOFE4jxlUsJEUSa5BqKsyrHelmqXN+0iCPNn47oszPCz8/3DKLDq9fMJMklL7MLF0iYhYCy94T40bc1RvtVIdVyZUUbHTA36EPnd2PF0UID4yEhQ+TJ7dL0WhQo1nj3Afk3e6OukNcKCvqsEjWfWwhtmrQIxHWIb9NN60vfnhJKxqlmiaxueZPmpNwZHM5rGjJBx9kbehKKZ4O0whJeLXP7X85B9712FDjgHVf0aMxD5ZoBtn0ZwypyQktIAqaTx3KFgfy3cMJo8tBl1FO4AHtxvPJbX2p+KyFHdoU2Rg66ZDMWXvAQqyOmUtJtRaZqbSL/vQorCwAoXkLYHt5Ad8O9tJ2xGBForrNDiyAUsAwmSxHEQU6CeyRKTHZ+HZZILu5xQljZa+krmDPylBTano3zJeL7CAvjcBrwr5c2/GGyShc4SY6rQ0TA2GST8kgiyUDTRikRKEXOWzABTqaQ7PRdGDn4gIZY92vqw8TsefrymWKdlM6Chk1nJcYgGLMSGw+5iibC7uS1ghzVNV/OKI+HRWPQuuexGQS3wt7YentYcr6PWhcLKnvW9QpVFmwYOa5N15E1T+I+QrOoWWHSgBAxsxBZVDoKMbnNJ19X5WYR1vIXZC4x2IIo2g5YEwnc694PCEOZgRIQCEjWEABBveDQQdcrxa2lLcMY6KXElULHDo1i/d1MkqRObq6oYkaPwDHq3IuYFS9dlxvAp0YzQz4CWOIdBcZZ5vaF/0YQjlmR3F7PRE/c3Y3LYYPn6haHszgTdBLWBJhU6WrwGUORNecd5S3xxad4g2alrfM5XjXkSC/qVtHv/9z+USpPtMqNbGAVdoBLGJnaumI1jyK6BofOxnbfkpiZIKB8WrnA9ds+Ch9+Xp+3y1XjuwNyQsmZ+zNCxUmHS7jkqSyWoXK8A6nbGfYRO1Br+9zIm3jCz5vr3yEGUP7HPrT3etaQrfy/b+8vmeRwINQXauhB3CxAjI15MsmJf4vzJ8AmQK95Nv+k2rHnwvtjBN9tloRchYeKbTPXyV5GFz4ixXlt7XsuXsAMmkLBnjUw6yt/HYNlHUNRPzcGSO2g==',X'6e66b907c28935ec0682096ca9fcad087e2730736867719dea0a33fd414497b7ea00493ed51e16786914bda17c1ff4ef75ba2145db1e63cf4ce9723176e5fdd74580a8011975a50475d06830d4244f1335c92e0fbde6e07ee58abc34aecbc7da4d0cb5fe62d4b60c3850be07fb1214634458cac5ab2b99ccf76f582b5492bd550d7d332fda430976451aa3024027c063ccdb2d28211205bee4d152fe67fe811927e241f838fbb9fd12add0d441f065679071af4546610b4a0a4a87c7181e41d4cc0120f73d3b96a158db4bade7500f4eba9bc8539c23c0802ff3d6d4ebc10c8c1f434a19b58e87136a964ad2d4e4c2f2d2eb0f0974f6eecef87ea9811e485fce',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('E12EEA4FFD73AEE5F4D2D371821F99F9','C52',1,1,'7DBZiRDwBwzHXgLhKw01pQbi4BXKMP8qUSgnBxYSLeFbTIlKaQ/w8glsszNctukg82YY6vr+hbf/+PAG0JnaFFYEyggncr0i4kQmv3I/VmEuAAPBeoqDGbyd/glMQ/1Wz0pLm0J2ee+PVJCE1j+g2+E6FgOokioc+SiveNfTfVNUYn8+ZIXoIrfkX6/ECLF3T/ZDcY/5DEX6R3KPwas5DA8MxUYbdINmkyQXWSAJu2ERrdqSgFlbr3Lcb84sEqr250bw1xklFnfsRRyyn2RCTAnstgCwcCo4NZ8B34fL6IH1R3IeDoCgQ02Zt2uLsMbjKd2ocHxedtXmDcuJhalHL96X2oAtO7f1l2KDPgCnDriBJiZn4Ma784pVTfmunaVv/YHT93c/w9VAN57G5tGiRwEy+FxdFlcHFSg/UP1gR3uIE7CYk4aOjm2CM4runyC2QZrJU1pj1Y6Hb6Cc8o0UghBwXkSpwktWLTGjTJgcpMWDbbUQqMbBl+Q2CTUmL0Bz/MMzb05hOZf4IK1nT0oPShHeDPGo8KL+r6wfeUmUOdUVdhQqiTWf1c3xLViM2fH3fapo8j26wlEfIoBtFIU4ycJZLPQlSxD+9Iqja5e1ZHbyH+gmaEt+hQ7lSybumHrLlpE9Uq1u9esId2XuL+UZ16dKYMB2307/XcLLMLn0xv90Tod1W4PQ5TutcTye86c7pA6n2K0kFe4MFxezwp6BnI16BMe1QOnX/d2yvWOYBQTNYQgaYdcDJJUGhQSRBU08BzA91Ix/Mgav8/3kd8rEtAZRGUyveT8OKwQ+ByiboEdvSBwfOeoqAeSP5fUfJKwI99xSjJuVaVjQvhivw5GpY+qjSCTu7bRa0+6aYPd5K6PiO7eOoohIZgo7FE2NuPpedp5xfBH8Ir9D/xqh5b7OVQef7Imc320gTIK7fKSQD0YT86IR36fRWZ/l/pUfM1nw881LuWIEhImErdndwvlZEbHWRPfqYGm9B+56T2sai6qvce5Ba6sPjvTvtxkHcrL4lFt4YRvVODVyyNMEIjLCyAAIkDfaCDwROCPGK8Nlj5k9dwteoMDQBsCwRZsr6fwF1/ZDbTsjTiGTNm3wwyHysWU1tnWXm1MA12113r7bCeg/VI5qMAnGCQaUwfBUsRO82UXGrx0lg5g+3GV0e322siUX6BJTBJI7iHPsJ9zEiZOo+MKKRRXV3CkKva7oaf1hIXkSuvCf0eoA9NUcfDryI3uIZowriesFZC5xUiFqkNZiup2IYU7CxI5opQK8rmmwZfxecKK8+EbqnfDnazAsvVK2n9JboOZ1WKWxQEDAQ9PWIDCUPkT3hb8v6fC3pgJr9/lQsTM6x1lWmY33JjuJPET89jiK0h/bqqSuQtqk3ovK1luIDVhH8RGBMCao4eIdjk2VHH7mPErs0415aOS5M/jEmYEnCjc8BpDgn/bjA1Cy808TP/pwVBNJ3ByPfSz3hwRjtyjOgCQueTPC20XGaQ==',X'0f3ec5accd2b185e149012aa8a2a84d9c2642cf22053f4f0e8ab857c08955bf3d2e909f41224a0b49df4100dce09787053f52f6c1a1b091d4cd118bbb5475c256df9f7d709abc2a28688a2c47568d26422b6e6d51eea321c5ede8748343ebf53f3d3368f4232f0a95e7c8a50211c4d87593461c42a8271026d6e896545cd47910e633d9e0b684dbe4e436f7a580b9f1927e1e73e3893e06d76c4425db9660506a59f7e90903603e5ab863a962e20762c76b40d5eab5ce456e7a1721328b9c6d276ec1cd0a010888d02da716241c85a143326759ef19b800b5c097ad5532db4e73be001664f3538412895828de34b0906c7ae139b39293a9713da04df82de182c',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('D4AF6513CEAA1C61BE159E7EB95D5798','C52',1,1,'ti7UdoGvl8W8NEqjTQI16O+u1C1llucxyTxRyHSbTJTDj5EYI7bj/Dzt701Q97t3pSM8iUEew284davWj3aKiIdLDxQrb+lKUlgJKgnCC7v3gf0q0gVqL3XQ4rzyNuPzPt3cMi6F0Zmve7L/c5BZuQPNQRziml+eptPQHc1U1U39yKabon20MII1mHePGDRDiC4sXmFAOu0BH0C7AuiiJDrei60z+trKqiXzN9IjAHXNypkV0mTdmBTHBkQlrHX3xnnrRsaZcwrdnni1HeV3Per7dIO25FrLvg3UNA1OQIVlmd6ryXj5KHXbmf0UeKOd4PVaMr/HRb5K6pB1tZ168iDbc2+EaevKhOXw7VeGUXEe1AqSEWIqc/nQiLCD8jrw768RyBJdV0NEyeQyjHFOF+CkJH90NpZFDxhuqFGpNH1XDMf+or2oTc2kaQvlVVNAAJO+0aRknX/ksLSRrEKzdkg+w6amlTLZvMp+ts/4P7F06Eo1SvQ2fl0eKbaeo4gTqcOxqGVKZOO4r4vGgXIkFubJJdyvET2RZidXDACBk6+AvcrZto8/P/zUT1nyGMKJCwjV5dIdIbVd19mTzHI2KJkScP05LVUumWcKW49qjJyBx4UY3xVCugRtcvfZ0nqslXtOjs4ZpRl6Rq6CsWeFZ2T7IS9hwA9I+xSjakKWpikBggP/bxeKBW6djC9Ok5XhS1iA17tmlpxc+N1iyUxUUDK5SdfKUlkEcxh2yGGXYIYUCp1Pr5i9yR668SoS1zJZfdCJm528r4gyLbrD6YtwtyzkXlwtgf0kAQVNzyK0cDahhB6D4viyNfg5qdPbDOSNZMbN4IBc4TXVpr0BT68gUqLxCP8e2bk1v+zvrswrbkTlsXYiVZEkSsDal+YH5hHn/LA/FCOcGNvTW42fr2+RtQcTpVeBpJ+fho6r33MoBHz0c++/rVyO6H5EYEivmU91yw9i53T6CG3er9qMw2jzUUk5VIcy0QuFjSCTB3nNzjam+s1uvvYcqh4isECGb8T4Sarly8Y7ydHz35qTs0iLMIGsUNNasc2t6iMsAFH16ZIxJAWdHiyuH55GmyK9fbrcryz7RhVY9snoNHWmZpH/EE4a2YFktPVn9f8gzWGstKO5Uv9FjAhkr4Pj4TuPhqFU5d2nd3FvYEisR01LSnpQoofmYa8uuihRTrIGXwC9+wac4kzaM+aq4m0gvK8AFHSCKmtlL6HiBu0sIHc9qLlE3cHaaRsfVMBdskNvwT9vKpz2169u7W8IxpJ39W1vQrXxh8kSDTdUCy0hpqCY+HZsOegLQekwCbwgSbcvOzKDX2evF5CP9Ej+T/1Qa76KhYySHci4g4AE0/98tLPCIqOY4C2PVboWFKgq5grQpUN/p7CcgcsmsBHoLmSIDNG9rIb9aLA41Oky+RgilxY4Y0R80nFrDaAJgNLu4oSBsB4tYeQBFCyLjS2X4yx3DlZ95wz30xtQAv30+52ogCMVSBJKew==',X'72b172b57108bb13afec70a02b5cdb7f90fb7b74e64f94cbc14f55a6e2ec7db56a5b54c66a6aa0c2fcacdcda689d880c27de789b78a85b191bba097ccf17624e81c48ad1dcb83c6b2831153a7fe5b692ccd637e1ef29c88b6b0c747de611355b0f50ad1f8fd1027cfdfc96125eefea3c333ef0d7e966d6c73c2884b0972b0988aa2a71150761d19365cfb66cb2d3e7a2048baecea35346263de2021cf7adb5aa9d81d22e4fb4eb17ecb95d2e093689e32dd974df91d30467947418b2186cbf7f5e575e64ae87f9836e70cbaf7d862d5c55e5421b4b6600ae77ed7a3cd2ee365266c256263b20d0ef5a8da3eb41bbd18e2e6227cf01dbc13a380021b2245be71e',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('88039702B99B98A548973EE31CD3054D','C52',1,1,'q0Z4lgqjaxhgjH3tifcCD0A3aT+rBIVzGpg+Cogm3hNOmcGqCoFJTOfm5OkUl1dOUmTJEvM+gbzBXP+5hKZL4d/Aif3SjKKQneGxcnPJeMo5/Y/7gm4u1Qj+P+nFt7DgOebd45rnMpNvM8KHnthxpk4+AiIsbHf+6DuTYCYJDDwoju9w5CAJypBoloLJh23lSY4Rav3aOzS+6ySVuGxb9deW/C/FjS3QRfQzeMLKsUs1ikRuEz4vtBj7s0LXOAY4jAaEALn2u593Bs6uL+wWsTzInDYHbBaNoCvLiAFdP1TSSEPCOqU9hviYcoYmSA9iuTQ14KJ9zbowEgciDudD2iDC2laiSAqSwJCybIZ2sqsaBVdpZzWFTyMmxpk6qrq6utpvD6zcMmVxij7P9Mkyy5g4OGDsRn+agaYskFjMyeOOLcnVnXvqhy5+M41jkS0M/VKaSyWO/g4Rg1V1M8LQBoSwWaSq6A3nRcQAEy7o5wYLGMFkQG7lzhS0/qXn2/dxYx8EVAECd9Rz2BoOn82MmTO2aZBkJBPTvu5hp3kwnCZrIatUhE/P6qiF7B5IWlkq2zXrBUdJn6MtdY7uBf0N5zwS9sxN5TQuvpg4B6edwRKlkT6ZlltMDO05y1jkkY3fEmC/ll/TtWlBbcFEH+1gggXpmbiRXABHEfxJEsdMBSWuVcSDb37PUdY6UfXxFDhNSbg8Y2nLSlRg3dJLfjZtb7Q0Y4g8mXWxTPU7UZyCb/DLXb+lgZjW6mTqUk4uo/m6HwICLgeh42najBoM73msE0Y/Lw3DZ7Tgc7Q6BQPFjz+inQGfWh+JZUmbYgG2lnbsqgOaRqWyub7PKaoPFVJ6135pIELiEi+6R1dJ7YKJ2Tpx8kj0k1li/32GhjwuyFTdtk6RyI8zVEmVQrLpp5pZVYtrNx9zEgmmU8qEMLemrgKjEho5/dtOKkJ6nIriwg4TMSVA53ZAPuo1BozXK8yJY9x5lrorNHAA0UnKWCARFBbp7i+yMFrqWiW794v7jzr1Q/t6gyJl1L1CmigB1LGeykWvkWUgGzXexfX7EpMnk7XVx6136CMAoCSDQzdTbM8aHpJpEfmNJH+i86uEfcUYsXZ+tV/F5yCBTW6cEOV6E6AGVbefC5oKGu/Y/AJmFOK7fPsreDyrJuUW4qRbKrocwQF71WAqH/DxTx3B6sdk2fzQeBmlgZv5AfgRHMSZmqmt4uiYigVV1OZA6tDNkkVkEgxB+A46MpvcIGGXGF+SsgrnXcULpL9Ao7fQjzMcvET8KftSoOMn3PIUUUfEB8ynh6czwpabizytRsk8m8Opv7KPgXhhXwROvFqkefIo3jEWJLy/EO/3FYB+OPaaxq2sDgd6a7QKlKxKSOajCXy1vPiXOdJ3Ol+cs5jDCsHG38wJHS+6TvF8hYQciZpBP9IDVFcOD++TJmfSLqR1IVRO3hAXtBcfwPYHuFHDVKULVDxYdlXMCAk8mKJoukDUOWjWxQ==',X'07b9fb8e04af93dd5552fd5ca152d7e1dc0435373e9f9f9cf24bcfcba8ca14d84b800c69fc4eb6a86722ac975b0cd8e303cd28e8fccb7e04aafd7d2718237abd78b9655bc7c7829998979c295748994e0cee8e6fe106de80aa280c80726c0a5e1e4a9698ed471e3e4cbbb98a067033fcbdc942b40c4d0b1b5651e11073bd422a9352c8aa7c28ebea8c26d54362b00cf7089f3f2ca28aa10fc83194c9eca478a953173460c44216decb59b9bd02f81990ebd3be3b475789c6f798894da584b8c9fb5ed2ca56a47f8f8e59d0b49463f4f2877d93aebb8a253a51037d5b3fae421f0db3aa5ca10e4b74ac7ff1e8fa7653f5e46ad3d04ab02771821cc37c58aa9252',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('9F9C936C72230C787CDA15FAAC270E9B','C52',1,1,'alfzL7iY9xdKB1ceIMMXq0d+ZVYK54YX6wdUTgoGWAfGpKZRnAvR+n2juKKVWsvkJYAkZ9uCQ1NpQm+i5HA8u7HnjLWyhY5wIu1Fy+YyvTshOG0p5CKM0JFkzLLzGj0SQ6/rApt5yvoLr4P8hLWJ1LMCPir5ySXt4Qo3Vb+4YPd/UuqY1N8otzX2Wy8QxtQmOW+D/6iPhb17/6RTaJfoW6lJ2y6dP+WZx/y73fOnaiCoWi8GPtlX0hHBUw0VLvtLu1MhG/QNkTnUwOpDhmr9PZK6D9QwzdBYPN+KGbEgtVOjYCBMgj34NSJzRyZQGG35Wd5dO+I/aKRXs2qynLIApjF/sXqAdHqqU64Vq2h8QXoUcA7OxNpc3JJZQDPab/2Y1vCBXfdRA9UHKb9+6jk2Mcfndgw5ERZ0tD86MhjHR4yk0p5Xq8ErhpPbSlAvAmVj+mS3ugf6XIan1eUcSfTLIbSPBDsu68LgnQfrQj/4NeMNHTOXbVYkMxLY6r2YiMcUh8B2c8iZVEuXNPIcYQbQnLRBapMIl96AL57rf+Q9n8AOBV6E1EzBeovA6MTYAS5AzSqxBD7zIV/g9u21rBtuGKKJRZkuHzWXIcBitKlApRmmTvqh5rFPDccl1paCE57SuoLbesgzr7VpbOEWK7tve/fUf2MwUiOzjIEWrZSEQXTfJtjQAmF6OkU09m2CaRx3TlaIs+30IpYM84+j+eeHxVV4gdJUG0J7WG5kBTgaCdYNoYcjcTecdf8SW+NdGovu3itf5ZKPGdpkgUlbS8HE/JsaZYtAkHqazzU3OYRdLv0qRh2arDRNu5NE89uBiYpYTfH6ipD/h7Ptywd9NfqAsZ5LpsFd9CJDncUGmmitIsy+SWsxC+mGpInLCmaahY/NMDINxiQ/V4B8qh/NyEsPHMvbb/mxr/XJMBx1zXOkP+EUd99Y0mFOX1/XNR+cUgF8+C5x6JWHQUJU1eim+5L8MV3kX04uAZAZR1J+X8XfsdQCzrN/cG5dvFDNv3/s5cnopPeIRHIIUBihks4eZ2let57ISwXodl4jzwDxr7qk1FKrjVINVHmanN9Om72NCdYQoq908BM2wgu7M1pBjqJKDXmEUeVHOejXvBK7CZ8CwDpS4aFh4lKBj4MtdzVZs2XX0g7SMfUqWEKs0JwN9Q4UbH/e4Kr9oHbRRdQcx/WvhZ25PX6qjRc8Y69S07F2fZmA397uyyf0PA1yZ/pV1obFrlB1Xk9mXVrbFeUq7rYbEUhlfGF0UUTTTgJw0OMVSOiac1u1ues+TyBYziJvwhOCrQos8FLPSxralxvoQHNOugQw31MWBdl78CugtjAj2VV4x4tpSXyVAz6ILJOAVsjx61cjf8RGnUC2yEQXrXPzHDUX+9Ex1e46AAb+aPmxC04yLEmiOjMsn1Qy4Um3gszciuk1FBs29Hfd8AZCOJKkg9ftY0vjJ4xZRDv2uOT6fN3i4TSlLEbsMRmTm7DpMID69k4z88JVHseDOQuriUJV9zbH871EdyL6IszMar2siiMuH4oFvLQp2tsKTBuBa+kUlMZn1+iNzkMWSoNPyk1kJY7cuySThWSsg5yBu3odznBNoliFNvfVBdh99S7Jio13oJzhSrQ153K+dXS3CIdHJmk=',X'93bf78c909eb118d5c89d5790bf7d021a251f7afedddfb384ec61edd0eee2cdf60c2511b11eed6ced1e4348ddfe21c55dec1305e651170e4158c6b8f67a5303568c8595b5181ed306c173ae2ba6a589d71257f6381af68af4ef4e348c1a384391da5ed3a838ad0c7e5bea0e001ab47b69d8deb2eeaae96fc397b571d8a3f0443bf4665b69c1e69c8ac314df9cf8148ac08eb0cd14856b0d03b34c49c168b008dd5f99cdc5b8f9d1f6f2f82556dc8d9905f909ce1c2553b70705a9cacbca6c259e307c8a0047fb63a9358ee4aa0f0ea7ae9dff1ff99dfb7511e5fbfcbeabde0ea845361cf5fe59a17c24b656b27a2ce08dcce16928ab3a4e40d302f354508e8eb',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('DA4D111ACA589C697AC9914BF8B04FAF','C52',1,1,'9sniFixjoope2b4MemA80A2JCDUi8XS44ek7J4MJ34UcM65oajBrjGwLFcZ8FEi4kIGLm0NJHdTG63V2esQshEi/UhCNLhCEyfF36FYAVgFnfTOwmBKkMmYVHiFKdikdUFzor6OJI0z+7GLF8rwxEDYzZK4SaRKr8VexqcA3x2d0WOmF3yvJGOqOhkb45zy91u3fzAmnX8OMSzl3GsaOrL7MpvrizpkGHllSJA3gm4XhDR4+xyqgRpBUDG+SmRKgtreqYWByrCL4e9hDLjW0bAvBIZQMAf6wVzQE1rElEbXmwtA2eRS0FIS/xUO7B8Z4l62VcJfH6NKpPmnEI+YuHwVLl+PjiocHngbJqnAAdyw9BbzYdKMkno7Rcm5LDQbXtQ39+Iy4V7LaD4SKLGQVuN3y7OSGvuBvtF3AHR2pREmlzeYq+1mX+O7wJIROBRJA0pCeYSJrWpU4z8de6IggQyX8+FeVu83bN82d57YHJiI6z0CTp5rpcspK4tF8EAM0MUbh9wj1g/AOeCaTJ9yglk0775bFzPKBQYx6R4XFCu00SdHplGvtlkClyEspYkqzRCYWxq/R5UQ561FKUfDV1qrSkilJBB3gNp0x2M69m5YMgt+y2IiYUsZt3soOvUxgiu01v8cdwZcLdjQOlvty1SmFEgnAYzA20TdRbgLhe+ySFTKmksqcBcJWt/wUfUYHEQ4a4o+mfLoX2+nGjmAx4YBjRkpiOXE580HzzogJfU+XhnnwBwtfb3XH90A2+y8yLsL83I6rCo0qJJHpv3A6uNxqN2dzr7D9CTwZY9Wc0BLM/rMpEb/mq3Igw6+7zA1Dg70MBFoJBwshdZS3KF9wRoFKMBXUNZgZRlqSXBKUbBlXeimaa9f4oI4QOwCpdrpw7wb5ok23GNtTYD2R+qWirrD99zuoDJJn1rd/7L46XgBus1+GRscj4AES+TRDEVByWTTW+/yOLME3dSNbEUK0jt6Hc27oIJt6GKPODs/q/Ww7El5+m7+AIBXAIXRa1o2+j+zDHDKYp8hf00gWJG29vEgHsAtfpcYQl0ePZFffgy9Kg7i2DtukI6hRC6jXCPfZIUfEGXOdaNglHmPqGQ+29cKPaFEYkQpIqAWX9rsVP+vnApu+jwQA5hHmVWtWObhm5pRCAGcp6zfxz24Ylfk3JoTqMJR6+6YuNVe/6IwrpG2bSvJszQ9r1oQujwZw+wUd7UZ1Zqxfdczt+G32k1oHD9TJis6cgY3Eaa101w5yk8HcepypugxsbPYO4abBrWjwn0fcaPXH/Fr/3lRJ1vzxJ0tg8CRdqrQoCUB9gwdi5oQkdlm3WW81knHaQaMANapk4JNUImc4b5uuaL6RfkHdOhJSuBIlMkathlrhtpaCrkbuLeDc/hoO/XxtHa3unxU/A+vodMPamOE71kkjlF0TyFiYBSZGYGYK8gXpwqxvjv4DVA5YuO2Wfi8Wgv3pda7hcRzKcRenFFqyaSKnpgJW2pkTZ8WKyFV+CxbCFnhcgfeBGN9yVgpyZ4SBX5PDnkJ/pHqHgajOWIiveCTiIC22DcDKn8Vw6g4Cjh5K1O3UJCh+/dooDJxiBWJu/MFWo6NL+drAImM9O/s1889StE/j84cnJ5j+OPPpkxqohgDEzN8=',X'1dfe3055918ac0b98541128757dee76a4d4ba62e6af1414db056a78a3fe905054e260ab332697be218af0745b87884890c87874f5d1814e7cc81bce52759e3675ea91762c388c48e44c2292b3a0dabf217016537a13b172d6747ac01d6cdc82d47c3df4ba4162124803355129a6271c94e6c7df4aba94e220262ba2609fc87d8c144e0188117ec5f2052651da049fe55bc00f36790b6c90ec1f0595d59bea4c93d8633a6063ec2d4e5c4ecc9c99eec724974bbb262d1eb8b12d159ac72353ce211f66df67382bf20a4434bd7676a4069454ce27ca92b8e43ee896167e86a294b6389e1a1d2387a92cceb09a706a64f4ce774f34eaacc306da0d88bddce03ae71',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('967DEC80124FF4A12E19A5EDF363955C','C52',1,1,'D/a0e1SQAazMdiZCdslGwKUAlOqjxhnEtCX0iep0ku6Mn5HSr5Gr9aTY1MAQCtfofSV79gN4yDZHYnN1mcHcvEezP+E7ZU8xCIOLlGmeCfQmXJdcvM7pHubBjCDahSUh3fubrDbfjaO8Hapucr7DDKlQ4nsnC4/iovKmKnvv/nb2act9E/aPaDfK9CMD+ZX/aYhSeAULHs/gPgsOi4AaasA9njSA9VRgRSXF+IUHEAGQuXi3fweZdR3+YFEG1QFzwgNjT/daH2giVo/hDf9Q3LFI4NcRYlwod5J2W7W9XnmiNdimr8q9xjb6DHYCTdGvJC2a3sUc7lDal5ldUJ6SuuFJLC4/stL5kdA+YYuLX0RMXv9AOeceq+NxzLlZHa4Av00yz/eEGoUppfuWSYu4CrLIY+UidQoEhgAJHZzyVuw5ABS3JdzHGmoj9jSlhelr945JNHrKWXHfP/Z2XmQ7vFVVhvw++7tULXnoFBWVMJhz4qFAA5MOlpRALQNR/RNRQSESv08JX6Vhsrd+6zFDNumTn3lci02Uj60dlCo1VA0IPEppExJ+zNUQFDbvT1srJ2aRnhhpI2jJgo9bSxxnt4O3VaSb0YArf1RWySJh/5cJ/Yoq82xA1MECCFJF+uaMgP1FGU8gxpQFnjZ+Zi1mTdTpDepGea4VjkJnwbSKwbQUM8WIBkFSftohWyfY2OzQ07rNw9A+Bl1NPwunS0qFfN/gtMscqS+FCDFxoAgIfzEnxvbEO7BUpjQQ1wCsffvhBF/7X0nWxdY+UpsxhbxXNqvlXaXdLl36uvnM0KfAeuMhFu8vaCrSprnWUSYVQgmQ4DoAMrLI+eyPsHoMn0i6saTOxZJHUGg2pdWT9m/a5oaVBDQZC9uco3ftFJ+yG5KwQMB2QVJ4YNPvY7bXR7TttTl83nAHsmyoE3x780NwIme2oWtm489FMkU1KCp9ojaw6vcnRY5NUyTAuu6/fapDi42jvckoIEB6+dVGbCFW5JBcYQYPOfe46QsVs5/9i5J7gZHe1Gv2SvjX1qvSCf8KVcDd1vTSyFO6+HmPVc0sPzgpLpW0hELMWMgOjdfHLUL14cbrg/7tXXJSjn2NvRqa28DWqBgWbIP6P5cplcRFHgOLrTEnkldXwLIYVDA1XnbSowlt+g2QI6k1mF9dOCjGZEOCAU2v9M3rV6wMgshYibnXJG2ZOFRdAZss1vtr6UTc7L+AwwQUXsR3G571aRVnknSTG0UP5UDLKp2u3nA6ciShHIfHqqwu385+UhZQokRKXBxgR5R29hJaBLsdpeKal/HGs7oqLLROI9eDlqC3hP/dJ1qQmvp7bb1EJRohlUBMQZhTy3vOg+TbUwMJS607Qf2pa4Z/ux7+5Szle69GpcPc+tOFeYs7hUlOJeKXfbKeiVki7X0n1n6F5BLr9xgKP1PLxgMwEVGSf8zAbs+w3IvbU4huBT58/IGj75pPp8zsZmNaEX0YkULJmQY4CNU3T9Z+fAaP3nSjSTOX/pG8V4Z9WEMMCTXk1+DD3TImZtEhs55H6QCRZ8qQReLCG4ePdvPm/S7VWtOxX0iSqCA76iZci8TOkNXLowa4I1ErMnTGJTzm+JbftmQ1MEMYVfYt8ycdty+j5a7yhbgA2vG6k6A=',X'4b67871f77e6041f8fe6f2ebe3eda4af11b63c997182202f75bd11ed1bd52817cf620f51c4eab9a4c06c0b18ec759dca482dc3dcf08fb3891f737f903246602f09c5a4ed15522b218dce2a61b15708f71a6199aa92a9bfe21ddb6b031cbcdc38871a2f8b353dbcb4c9e02d3f69fada4d33f337cf0c303a88ed5e2db23ce321e749727aaff25bd1a30c6c4b2df5caa0693721b619f3ad3132dd0aa4597765ae2ce4b1d297eb1c0011fdce6fcb19ef13375aec2bb1f7e6b83dc6da6770c9b32b226eee73684ef26645753d9ab005e96394290e05f2e9bb6b27df1671e4b5f1cdfd16b939f65494214c9efd6e1d77b42e2d97e7abe1d96b54f8ded8d97e8bd5cc59',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('337D5A9403B79B1FA548D8BE0646E7CE','C52',1,1,'O4xgg42QITyRvA5uq0KlrMeyT84f2z8xoxwt2g81j9KhVXw53zjr1DFxkO7Hc6BO6uSAGQoTac2i5UHJwzXPp9t9foLoA9Um98Pq9ai0GOnMiQ6gYUopXAod+sJsNxM6vPIqqRwvbGTi60Q7df9b4O2/kJTG5kH/HxSXtW05CcyecvNud0hTkADUHhtKNrRTazsWFMGkfAffTfAlIKN2bg1g1U0kY9X2sOErX16nwFGIm1BE28Td/Oto8ad6o2xNy4Vd/ZOk1k7cTmoos/Yt9aVbwH8QtSynY/5y4052awqKGXi3NNhuQd/Smb2PVebzBxm9zBj6JKLpXeAGKtZjAxjn+dzjje5uNFG+QpRb+8dnmGn9f/gaGAKTQKF4k9yQUHPuXEA7eQIU3o1dI6O260FCHQtedhHmYzlxJoS5DB92m41aG4oMyr4KqNyLClAW2jgcekKcZYoH2lD7jcw5k6daCGcXh+Bqbql41J+lYtRoZLA/gHh4HiDkAlKTeCAGUo2arUAJS633XYYEmEyeuBF6w0t+e66scUOyd+sUj+b6iup2YmXAN3jG1jJxX+f9XmehppilbnFB2Pl92Aqp6uspSiHP1w8VdPZ00x1nCVvtijtd/J5NkPMCpOwFGDP4CEOKzGBGlP3rLQEOoM5JVwzwjRAf/VPT8YXSKcReTbDDyd208HzD6huPfIEOEAKTarHkg9vx3xA8zHHvnAJ2gM6NesCdh5awxF2T8zD0PBoyna/LbMOEAaW3xqFYXeOSC3SaAMM/F444h64xZrZ7L9cUGZUnGfRwjnqIdSO1gFnMrkAlcGTH9iDiYejPjPpYDYm1rgQz5NOGirVveFckQ8P6dT4ePMkLmsflCmKTPnZX5tT0CFNbomv2y0ktituBoBWtLNEnsgbecjV/kwNiX73TxDT4yTmEdhLaa/P8vjcogO6CHbwnOlzAunX6upSE8ywcFNXP5rdtyqBwL5FSRQu4xvhdIdoJvsWOqUueHwPgBs1ZTlUeOl7OsMCCX6n2tHgb+wlxXn8VS/fZxUMTgnKkzXghNjjSskBp9Uoz3YDJfHTYFAchB9RBkYzy8yRUZi1SI7DG/OKyZq0dQWG52eoLsvWic4whGoC/2KgV8mP20XbiwOD8ToMcc9NFp4JcuAFCldN1+XliKrw/Hp4DFqoMl9XpjUw+OLBZA8pjzkVCV7XYoLsE9jkbiU8TXLX0KjqGhvLVvI9IoJD0Dih+XWcnkCm/uYlk/ZToKzpvPgANDvtgyHWLdgnPbheZplZ0ArxRqylCnWlh13/Q+pM40iKIN7CfVoR+mnLc/wuxXIhQa5b9VsGwAwdNqvkRdkLzwbKnt5PTO3fXmgAIzg9Kb7r2W1SOEFiWDtjTvS+0i1le0S9EfX7VN6dCSPl1O4qqzLQJAAE/DXMGgNGYrLfiPePadLFDfobYRlVcZXpEHeM/sxzU3XNQgZ9/CFvbr63NbtkRbTHrQrT2c2HtvUSnMwXrdDiKE0Fw1spgSUFaKqt20v8yow3oY4K1fbIcaZZKflpQeAaN/aWBRwMHykIcWHvKPFQoN+TO9Ny8UDkWKu+RMizjuRNTRvunVbOocxLJ1KcHHlVm9y8KJpsPfuqL36gqQ8ix2BpacuD1s31dN7c=',X'4a12807439e461e6b902d141b3bdb954d9bd536e2f299cd58ca4584395f5847bceb67bfc300bd00c82058056705ca08db4e4fe8a7feac5cdb64c34c03475503e2f49672022a39045a6a1ba6ba8a29aad1f230c0523869e3a46d3950a6fac5d2fee5fa58d4fbc35121a45aa3aae33de75e0a6990b1b54cb7719b24242c98d66f56d8309e24177bdfc7740de22967c93574edc1c4f3efb2668156ef513e2937c3bf27ceffc4523e42994b0c2662d0813ddbd488f28f25abd9969c69f7e4df45618e3da532ce07dd962f20cfbb9b0de75759014b3b7be531953f59e8abb19f2e7dd4a24cccf41a4920ed681b0c4142a5ac680aa173743826652c0549f8e3353c2f9',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('0CA0FA2EC9FEB912A35E8DD40A6067CB','C52',1,1,'sZlgE5KXVxkG5eNZtyE//ia0lJ/grZpIEZBa6K46HZGE0qjhla59dLIgg23k2rynpb4mJ37VS8d+y4NW0POIW+DCAH4hKykL7QgrS2YKSNbTm8WIayfSRmS7ny0wAJdBOZ7Pdj8xLkNSJzfeooNsyxU6154hTDsIpu2wLkGEfOmvO0l21a57Vi3KNwKUBEterejLo5EANRJIJg9DXUotDjDPA+UVWPdJOPXas65BLO/licloBaauoxYI1nQ14DAORayQujBBxdJBPx35FlWtPtfHEl0NY/9OrKN2CjGX/YWREk5x/eLZ7sfI866ug/+5rkz4SDxitnu9gQMxc1iITRv95g8UmXFnOdb+E8WFmaY0ssWZw5DFMgXAhRNyLbSZuAr+i+gy862o7OfUJ74cTvvUpXl+2IFF0DcQq2LG/w0SauWhZPx0qJ4zyAbEeAcn39AOTYn7r8hFG0jYioYFqcTCQOM/Dic8kjMqWmuObKYifycFPB7+gA4dznHP/9IjJ6PtQXUerQPmlwEALLmU+PVeYaV4T3Ho8JcSQ4c2Y5Q8ifJS08iBIAZtKJOibZ3Ww21HQDLtJ3/B9Il0QFqGCfyzfxzLDXx4tcwH2NpNJKvJQPzVo7N2xMnmwAGg5+lrn86tVMQGoBLG2CO/K0H9zhQwYk2FE2C5AbyE4Em7vqqAj8oneEJt762S1Lkg5Ed2/g6xClmYxnIrZsEv6qw98b6M6lQwW/oCpz1iSqpxAbKOYx3fJv4j20xLc2tiY+wjIMgmEVZawR2dOr1YCoaClEsJyNoEqqzAnAUd2gAClbA9w6ABxnEKJVNPUrT0Pw3/fiSWadMSApbvxMciNPDcT2b2jeFIwuFSAEgRADJeDEEur2dWnax2YvwhBAvbFadEXkh1E+D9zgJmtriJC7egCfS3hCVH4KcyD7vKXCW/X5VYwRc4PC63vcEHV2ILs4B6liHwlctheAHiCDjkbSsi5jG9dKYAsMPppeZCWkaCt1fImW8jA6EsLO3xaYTv7+ZxwNRbiBh8DitKuNE75abe8XbOQ+v9iBhDJEJAJg9loFDRDLW6QV0PnJpG7sTJCwSiHFZciUpaZ/FCmN+22f37mj87n2VU/q9vuP1+66vMkWyDs6hXzxKOYsin/mH2MIP2RIiFnBnW2AzeOq7BFxO6CfulXEzHXT7l5u7digj8zFPjPwxAwdrobls+kbExeJgcLjfrwsTYl5f+jWa95CAlh/GrGt+Ptwi0+8+c1eH4Fc5ckCOyFfKc0BVUcGJaeKXQBxVWeVcYZh7RKl2Amht0cVcOjNHBszAOdgJb7fDnJAkLvf8WreEUlLssSUvx+xelQ8gFXmzEj/B3U6JMtGX7u7kpfGWQW0ELIgR31DrPA+BzNe5KTNBukFVR3qE4qgkzrgYuunY0Jl+Aco9OTHPUXmz9X5Okmh709KoGy5VNxSpFbSMGwgzNlX9hogmMHrVteVIGQmOoi8eaO3Y4dntI8cDNv5xkzqW2IQx+oIhQ0HC/FqS1baGCQPBVc8jRx2qNbX1o1KX03e0hZf4NVfDv99lP3wm4uni2a/4uASgDGtB1yCPU3i+FF3+m48m0plmp+5Q+MV0IcppIRqB/Xajc0Sr5XayAIwLELCZ+vVwuTpQ=',X'6379dcd93b9beec5fb4a7ebf1cf4ac7e3c5c8162256294e4ba9204b6e3716ae61e396ebef22415e1568a900e87effd9452fd7b2bf920950c465b9242ea8fd93ae1017a45b70774b020e5d4442416fec262a3551dd77fcc68f046d3d941d6da86ff1781ecd6f56d37c42cebb5464f710de1ad4d1041a42029deb72953e8b9e024d4c494059fca23078d13f1571a0d16fe2e89fabe72c2d7966269e3459f373b7c71f734cb747262eae77fb07564c23f72c88ce5c477e3cdc9171713d9b8d1f846d3395cb550d9e943e777aa3688fd6816fa5454fbe47a0707766b6529a1aafcf0c482814b28b55999b3e10ee49f11a2ffdb7e408311214e1e750c5caf85b1f311',1,4096,0);
INSERT INTO EbicsDownloadTransactions VALUES('751AF9580AC97C9C5247FB7CA6DAB871','C52',1,1,'IRegaN/dA0ullHQc/qChsejBQmz47bLgY7vc6PT0HRw4AbNred+jY2fxrDmRx0QRrmNSuEcl+1un50cE7722XGdD8iUPX1I8rmB//mdlQN7hYwFtm7TYq97sWmRtMp+Nm5i9lKHTismrLeWbFBUAqt4gEDSBl+uLjCwhF0k0GZpUl/8A3jpqfdI/af09nKV86eUdgSHY8ovYlbZr1to0QUNyk3vX2Tc5kUfUKmYUmPIS9CrRMZXD8N53VUewWOx0oKx3Qa6X46kz4OOGOQGNIeTZiguuMR2+dDgVRYZp0DG3b1cGgw6YJmftUTf4qndFZF4n6lG/fB4B1c7AK7FF2xoU5TlD/+S7kkf2demHSUI7Hy211OAe5KNbn6ZXqSpEWSql13rpNzNJHa+jzEyfp6zDLKg+/ocLXLuGhD9MStzErg3sl2ukh3hF53piKYXHE9dCqeCCnaeg9c0CUp9pJXIK+FpmeX+bYqmEvDQPVBAWPejiMxcQxsKbP6VspNGm3+vhxAuMUbn7X+JL/je3+T9dtZ0sLfh42zx7DzBXZilJMLtePDtesnGh/zvsIHFv/L+28Jh5Wk1QVFn6jVBjiJfmXeGUjIw3iha+hAaCUSRJuiD47QwCSRTsVbghleuFxXa5U23y/knGElps3O5ZX9YUM/CqN+i4D5WvDS7ufgUettkyP1vTrm+VMt1Mc+ITnT1ZKRF6PHXzLcRiDBoTRbe6W4PqufTjvXLNBAwmp+Mz8JAU9wvUcQ+9TG/1ris+bUGZKjNKugff+lKdQ0+B9NG+mjX0qPpTkUcDxU2sMNMopGl4J0PINy+93UFCb9NXn9sNYzCe4wA6p6UVVxnbaQmdDSZ9zzpS2WsFA4b0JsNylJlS3UYnz50eiuc2WdqrSE6f+EV06m/5mXuaIZaI5e7Wz2tMli9S6Br6Et8KRTbjwpx8TRIuM+pPrTt+g8iVDEvDosy7I4zPvisQ4NnUjf9j71zV9vfLdi6homDQle1R39kemuGnVANJaQagFCQDlh6fzMFl+xndzMSGp1QjtsJtZsMJhT+xASCRH3YQlnBr21He+lGWU54gtjDRMTRHC4vWvXeG1L3FovSO49exITmqTWOF8r+Fwh49a494Iw2aXRGI/kIPM4YhPCx7iUZVsJVlz+HdgxZD5PpiOZ624y2s9cK/IFtFs+86GvYvq5eqbJQGYIQQ7HKFhqSHqEL4+BrEjr8O2gM4nNht2sQPzq8CMMHhCjjaIX8aRHH+i5MSFQ5FL6cDpijvPedwnGa/V728eXeHQ0YxaW7a7ZBviZqobzZwCLDHQ3MPJNBA2kcEhOcearpkrkRvnZLDGQupM3/36tF//ShRVNQk8n3KkT6Pxc+a8JhdNX3VCkRk6OcGPKHIAQZwS5kjlSWz2GAQqjaVU32SHBSOcBNG3KCRLgISJy6DjbW4Ih8rLephjcKOnHhOc/pNJI+Bzwm0DXLTY/vmuSy3o0KXnBE7Zm/y7usMm8Aso3KjbugDMB72i9TpKfs8IDI/unWwI/AErC5p5Mc0wfSOZS7/xQVQdm03SnkwOyF7HVWEELjJw/ClotjgQ4s0FfwmoG+ADq3hFMPneqzuIdPwEvv7lrOCc/3ypXcgSZJK3xUpj0iEhFMpJ3I=',X'4ed40f558010072dc9ea08d99c4a5a36451be125af13e8f36483c4772b002115e4c15e41475ed7d16a5af30f18a733559c7a9f64cb9b19f92c0cb377b909f67fe9cde508a2913853fbb83b009ce2b1b98277de81dee1e156f102e88636c8f66411e60838ab4653561df5dabc2130508a624a8372e54d3cba519a3fd90f16599be35a9b07c8ecfe63cc13ccd411075cef963499d4cd15df2648cce30794d6c3f7526c5c7989a61b4600d45d4c1a8c535a4a92291669a4d21fc1158025a2f4380d2c055e0a61f0afed10e5c150b21b6b8def9bf57b396b302bd5a9186810f8da4a34928d170ac612e39fbfe12ad785fba8851646dbf747c247506e0db58776987b',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'79214bbf10fa4265a972d565e12534e1','10',1,0,1,'QMGEMFDMCHXBTH3V1NZVBFWE1JAV69FSBPTQ9ZQ47D1VT15A1PVG','payto://iban/SANDBOXX/DE471160?receiver-name=Exchange+Company',9);
INSERT INTO TalerWithdrawals VALUES(2,X'fe8e4ea1f83e4ca1b107616cc256c1d1','18',1,0,1,'3T6WV8QNVR1J7GQXSFX54Y71K91ZHH6K22840EM1GNSA4EBYC900','payto://iban/SANDBOXX/DE471160?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$w2YJDwQzx7k=$HwtctDe1xBIDUN18wKb02HSRW9T1a01X/EjlBXhnuz0=','Forty Two');
INSERT INTO DemobankCustomers VALUES(2,'fortythree','sha256-salted$FN/tM2NFehw=$10WGlVUGmH99n6HWSQMw5flCPqVIYqG6QksLvBty/48=','Forty Three');
INSERT INTO DemobankCustomers VALUES(3,'exchange','sha256-salted$ihjHrbgp+fE=$GHVzx8c9JbdLRGDsCLIK9uYUH3axQl/+hTphsdFUX5g=','Exchange Company');
INSERT INTO DemobankCustomers VALUES(4,'tor','sha256-salted$1wNXSIK8Ru4=$QyraBwUeZul0iGig2NAhU6EK5LISmLgORkY2wPCIM5E=','Tor Project');
INSERT INTO DemobankCustomers VALUES(5,'gnunet','sha256-salted$o8HTQe823bA=$BLrqJ1gmBHWfwuwsD71ftoYnMHKCRL/+FZoOnSUnGzM=','GNUnet');
INSERT INTO DemobankCustomers VALUES(6,'tutorial','sha256-salted$2wFyeDqeZ9k=$gOr2dZ1/mNiqAgt9o0Et7YVJyCtJz2PQrGn1o/DU7bg=','Tutorial');
INSERT INTO DemobankCustomers VALUES(7,'survey','sha256-salted$ag1ujsDylhg=$b9qHTZXjTyONPdxGVyJYLD4V7uyVnOrNOHrlmEa8KDw=','Survey');
INSERT INTO DemobankCustomers VALUES(8,'testuser-05kjxdzp','sha256-salted$jSnyNDDR5WQ=$MyCHnUqttikHqLDVjg2pR3iKjYrXBmlhzl3pggkctnE=',NULL);
INSERT INTO DemobankCustomers VALUES(9,'testuser-nsqdub8m','sha256-salted$WZ4YZLdsJHs=$rK7TtQrmw60hn4OiZHGjVV95/97uQF7lqDH2FkOKyEk=',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)),1660654426,1660654424);
INSERT INTO NexusScheduledTasks VALUES(2,'bank-account','exchange-nexus','exchange-history','fetch','* * *',replace('{\n  "rangeType" : "latest",\n  "level" : "report"\n}','\n',char(10)),1660654426,1660654424);
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$fMxHi58kwPQ=$BbH6wyk+BBABXse+tYLjMCi3LuQCVEDYL2OQh3982mQ=',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','DE471160','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:EUNCGUQX',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-16Z",\n  "bookingDate" : "2022-08-16Z",\n  "accountServicerRef" : "EUNCGUQX",\n  "batches" : [ {\n    "batchTransactions" : [ {\n      "amount" : "TESTKUDOS:10",\n      "creditDebitIndicator" : "CRDT",\n      "details" : {\n        "debtor" : {\n          "name" : "Name unknown"\n        },\n        "debtorAccount" : {\n          "iban" : "DE236345"\n        },\n        "debtorAgent" : {\n          "bic" : "SANDBOXX"\n        },\n        "endToEndId" : "NOTPROVIDED",\n        "paymentInformationId" : "NOTPROVIDED",\n        "unstructuredRemittanceInformation" : "QMGEMFDMCHXBTH3V1NZVBFWE1JAV69FSBPTQ9ZQ47D1VT15A1PVG"\n      }\n    } ]\n  } ]\n}','\n',char(10)));
INSERT INTO NexusBankTransactions VALUES(2,'AcctSvcrRef:F52CKZKJ',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-16Z",\n  "bookingDate" : "2022-08-16Z",\n  "accountServicerRef" : "F52CKZKJ",\n  "batches" : [ {\n    "batchTransactions" : [ {\n      "amount" : "TESTKUDOS:18",\n      "creditDebitIndicator" : "CRDT",\n      "details" : {\n        "debtor" : {\n          "name" : "Name unknown"\n        },\n        "debtorAccount" : {\n          "iban" : "DE209794"\n        },\n        "debtorAgent" : {\n          "bic" : "SANDBOXX"\n        },\n        "endToEndId" : "NOTPROVIDED",\n        "paymentInformationId" : "NOTPROVIDED",\n        "unstructuredRemittanceInformation" : "3T6WV8QNVR1J7GQXSFX54Y71K91ZHH6K22840EM1GNSA4EBYC900"\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'308204be020100300d06092a864886f70d0101010500048204a8308204a402010002820101008f361aea2e49a8e0cb4d171cd620687ea7f6ba16948c9c19708995f328ea3590eaffbab67c01619b79eff54dd3e2d5db235e9ddbe773ce38a01bf06ecf4727fc0e218e357c812c897ab43743f39a42b9a879924e23eebdf0104a90b04c0c840ac79903f4fb74a01062d94bf2022733b985f1c9e608707e59c1c28e6fb62221f34fe8b47f6e038c2b7435360e376b86520f51047800287aaa5bde8b39d4634ed36f81b7f7c221cebbd2984c279796f3556b46d631b6f74e40c700ae299ceb9a7fc7b76a9a0670380d34328335b4699af88433033ed149e1061d6b65f88e070cd22d305a757956450bc4ac5c1e33d52f150152b93cf38f645e2644c9049cdd5e210203010001028201001074ec34daead60036fc7dda6f74bbed4a09dd2a79198b5a95070a772dcd74285a08d700df511d514b7ada9a7dedc41b717e0eefd5320691953c80ad8b1e27271ccc9855e71fc4e96b73482283dcc72c24830bdff4db1b7279bcc7d1aa7b89b4df68e2fe84e2cafdf70df75f310626387c7ee36f8eaab6aa43ccc2a76dab90710366803491ca8f7cf4ddeb10f03bcf9f4e03abcbfe2ababf7669d361015658cdb9c145481370ffeb4905e0aaf0a87fd41262cdbf05c2d7f1fc264b3b0fa142b86d21d5cc98e46d1db328a2da6802a183d2a08e3a8c9ee1ff7efdb153b51616f8c8c4f35a55f540f28bf284b5494b285132c7e15bc889d421bd8f1c3907a9046d02818100ea58467a8aa4a86594b08713133232cb08d1e27132aa6f6b6eb0d545f313db4739350ab326294b8a24bc6564957ee35a9ef97e12eefa4e7a2660b24a798a8375f1587dd66f35c9c9c2979231315e0ff6e00e94785db39eeb8a089a7120c4eab1404186214a69266a7428572dbac23466d14da113f14224f0e7d6d27ec9aa92df028181009c71f39bc84ed5eb97d4e8abf6462e330a9c4e206f3d5bc4aecabb0ead15dcdae2f300a400a7aa4f640e15d917aa1cf20dfb025407dd882080528054625b66ba6f65cb32cab14da8f8944ffdfd6b02d0d298ffc0451aa3a67d9710b0d999b26601fbc6ca3ad6731bee2363af1acc03f2c822986d33bd923f774dfbaf558f2eff028181009de175322fdff917ded2035ea58b274f4494eac32ac84aa28d83935c3a0501b17d682fda3c768bcef92af80088fb60bef7e5ccbb82c79e418b43903abea1c4299cbceaa2a270118fdd8af2523419541616239c816f578954d4bd3117d064fa5d0a965a80693a68484613bb9032878e784ac0cb29bd5bbbb995e8540e595d92ef0281802fdacf88d49200efcb06ee9143891e32b0c93540c8a63d3f01b4b3d97e6a949f4412cf1c5bb2edeed10d59f38940991015e4b5469d0d4fc9995723382cca06b77ac1e99144dd4d83255ec0c551d27d0f018c9996e7cc8948b15c1757f188094118d43a6fbbe5c35a44d300781cbb516ddf786da5e1d0d83e9fb0f40f231de46302818100b238969b46809f2b51dfbb0db0ce8a044c8a8fc3d4d7071e49ad75c379684f7cf1dbbb84d4572968d35a752d5f4bb348f3854c7758882034f14a429abe8a26152b3963411d68aa9c403934ba7e14c42c9e7a8d4d19efab91461d16e320498c664a762d8dff0fd034a0388055521cd4468765fefc952ddf6d89017d45dfeff30f',X'308204bd020100300d06092a864886f70d0101010500048204a7308204a302010002820101009eda7985dc8cf6137e3fa652617f38d831a2f2322e551a01eb41a5cae37a326b99be1e5febe0f5bdff4f3cf4a0872440bbf45e7d94c20be2d71d209f3c3fbae1dff3788fa5db17667f076af85e42268d43eb3fbdb5b9b59c0d5adb5f7c351f3b17c81929a10d7d60dff1276eea8f11082142f1ea274e21e227564a7cea5c4df3147b0a6cb60d01d9a2b7f938e117a441269c078b6c9504cfc4c37f0783d282009664803cd6dbd2827345b2a43e34d33bdba79fb388a638c54c2f0e040055bb3afcabf2c516be88b6da6409a4d4a80c288e68ee820f919c08c0a4690e1806cc957ada81d87c89fbde078ea6b73c642f41e0c8b8aa5e6e3d50828e8c2ed73bced502030100010282010051ef281d165c12948d5ab123eeabdb1b0fc7171b30f0ae206d42880c34f69349129c90383386edd998f53ae086680e17e19a329e9d7ad4fca4ad9e64e3838f95ef983a0805a912d1c815806428e1ffd67f40b8b8d621ba7d8a19e1eac73af327dca555ed35e7aa52ac4f4b629753419aaae547b7d99c2037f0c83e555de04c47935795516dc9ee95c21d889b2d78503a64d9153595d1f555510b3ccbddeda9770a1a4081691f9dfd6bc30cbe42ae35cdb6492671c2dde5f78c244190c1a0bf809536771b429882e6f2e6c82ce9647630ebd1648b2973dd97296712341173ea16906f1f078fd19b18db7d26e99a09a90aa1aafb30deae3ee89642b348fe65842102818100d5c85437dda87cc59ef370f084d1020a3f5863832cd4a2a40a8092bc6fe5ac703da3302bf66d1f51b66239a5dc70b40634768cf36ab3788ef96809bb1674b4a152724c0ff668dab5ec79d8d60a547eea2b90bf4f9a3467ead859f97c64a607667175646475f0060f4365bdeaefc8e6b34ae41b21bee3e70734e3d96e6294852d02818100be393b2bae484c85ef381a57e67839d1a00a9738817dbad25a30a46df4763024876d57d2d2edd4fb6c7ab70c00c769a206b6f4b9181c9ff444ad6bd597f6639907ebee81215dcb646030b47ab704ebe06c98b3c93e23b111809c523c9a2aa99d0318ac9f0350364c5f581492d36e91f29200d793971e356d55f8f6cec5884949028181009cc0b52ff971af7b601f7472879091845e0a3b7d5583dc7597d5cac22cf2254c6f8596aec59421e0d27097808c707f30058bdfb2244cd05b5578f9999acf9c1aa5cf750247557ef8e21a3dea43ccccfa7b533953eee7fa4272bd1678257caff467c10209bf886d89078c34836daacbae2f7dae7f41eeedd994e874e7c194d14902818051d9404b883f15a61f8b6d525b196a0f77a476f2da4ce620f2abb1649a666c4a9b7701edf5d25ded1cfd245be6cde6f6cf9ad36bfd22fbf457c4a2fc91d9737b7a3c1b30b6d1abdd71c22336161fe8fa74dfb3a428b7a4cdda1fe906a87328ee2551ed9cb2094683d0168f2baa0c0e82682e32940fd6f0b82de0e5198d4719f90281802649d753bd95819194e02c5396dc09b603dbb31d7a7679b3142674697faa2635948278cfbc9d34823ffde5df917aacc70b2cfeba63e18532ec4c05bb6ea693851d03c0eb9c02e24e25a1acbb5ab16c1873e3bd7e83d290bba5f34f7bd4a6b53423758c4baade25edbc3b17d78a3c7ffe4b6c51cf145a1cb3ebe025df23c2d0f1',X'308204bd020100300d06092a864886f70d0101010500048204a7308204a3020100028201010098de1ce451c26f798e3878c22f0babe20f455c058f0220bf417fbbb139a452853bb01630e09d7dfbc1f0d43e34e70d8b4f44b91d63d350c0195b20e8d835bd4fdf3d0c19ad696e5c5a0c042474c65c9a56a88e8e8b90d24448a58078c512f0bad5c0e580855064734db6aaf9bad048cd114edc831ac546d4e302f8bc18e839060b62d118d1980bb33e50bbf5074e0b717abd862ddcd0ff5f285fd5ce68f8e708e2231c61290d731dea24fdb6d91ee53b4d501c3fe7e23bb5b6395264a8371593e854ed9a8cda83fda172721b3da6353c40df4ee674ac35952f28b2ba4d51964b0cac4234920601c58f66fb5ee2f4a655486a798d1b1cdfdf6ee425053faa14430203010001028201007df7696f6b400183f501ebe077cbf25351aa21ee22adea362fcf05e7404c7c0375efe0195ebde8b6b055b74f9b6059f4d5d917817465094182a36936f6133270c2d0174c816d4397ae4c008dd9fc2b0ab3262a72a3e72e9d3e0fc311c1b39dd31798e0854b55b7b09bf54e6682de675f3447fbc5bd259afc8a2444bb1afb2120e7a38157878a5914297f5ebdc6586a3f4f0c12f0491d07b909f138062d028fbefe9f6f5c2b6972fdd163425fd491e4fa2689d8e7369bbe621e7469272bbbb2450533fa1b65c0141f9b9e3f097e8e438544601192a825514db3d422c4ae30d565d81e96dbb80013d8981d79dd724703c57d4b57db1f90ac257d55ae6a94ed7f2102818100ce983cd6d7a5b35b5d274a9e080564cf6928fcac905cd716eec1d7e8b06cc432fcb3d2c4d21c1e59470478bd3489670301af272a8a0b540b00e7009491de2d88c64da468e5debb5e8e783c13245fec88709400260d2f947e326deac2db68cd0d3cf4ab16d1c555f58a9d99daf6f7947d791c0ee0004af0e68f7f179abdeb9bef02818100bd6cb22072b90f2d7cfd7d1c0a6287d73fecd9c48462545ba2415af1d03ef0a30c8f52bbab80ea65b1e49a1f228993ee40b9d1903d61d9bd7ec6b04329299b5730b331d6166c4fc7e64b900165d2d1357928d386c59cb49165ce4c994bd8a6d9f8ba9c2b02b1e42e9e3b93b63030eb7b3c024cafafb02eeb53ba52def8c8c8ed0281804c74eedf1bc3c912e0f0af9eb89d3667c425550d9007abda62d5fe4fb12b2f9927086dd24567fe9b4fbb09ec0bcb660228d7678948b9548b15f467b4941f437ec0d4ef299b18c902ff7ae3d0b9bf7e4c284dbd98577cea59a1d427f3a13bb1d75a5dba0ba1ea841b71074e6f48c2eb835c14d434762745ec2de2fd1b597a1ea50281802163a78250b68e165691d81bb938e4f8ec2bb3b7101ec4ffe1f9e32dfca71b83a21321623338e61846e324c7982ee804772449ec42e59c9bea5cdb74fb2c7a55442052088aab4ce4cf93422efce3cc3cc0be918a900aaf4971c88b77fa06966295954f31c5a7d5b0e1f35e761ec880b9983a4f8a284dc5f7752ac2b0cae9998102818100a240138ccc66b411e73d7d5235c8b708a8d126b08074731edef1a9ff091af1f56fddba66ff147c732fa6dce070aeb692d2a58382f932ef8a61c2307ceecb860ee707e453aa37556d1d9b3a66a5e901c28e11bff9a009e6828b84d4652eadb28d61f9fa3a8bd7ecef6af037c15a6c5f03ae7ffdbd2ee426a6820f87f9aa67c6cd',X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100827428aae70a10161398e747b8e0bfff43480914d0bddbe3699f31931551eab603d5c2f6b647f8406939086915f94b80f9836393045c475e3d7ead1896254bb1a952a696e57d232cfef6687b0f091dc6275eea88caecee2bb3a5154192d160cc9ec965e5645f439ad6a90ab6a4cafc31f8fa50f31dacee2bb09a630a7d294679552522fe42f6399b7ee0bb6a7052ed671bea616d0a2d57a0b9e1d5058c6d813fb35ea6cd01446b90697193951b8be230b4bdbede531960e1d4650e38df40afa7c3018e63615c731967df6299327e7a0d59ef0d0e07212387b7194d7cb0bf48c6350ce0c4006e2ad14dbf303479ca012cd375913e2fc9430ea53c1cb709aa6b510203010001',X'30820122300d06092a864886f70d01010105000382010f003082010a028201010096ce919bd54c4d0cb54623238d010d1899858f251cd73d7bef09d1ce4ad19b1bcf1bf8018b493d162837eed7010ff56f4b99062f92827ec261fcc7baafd8e18912a882443c0f34a20c41af878252740af2099f517386c4d23b0344a457d520cc7568eec9e7a840ea748f3c95e03a380a68087b885d59e3e3ce553e922effdd1a20970ad08b4162d1869222995a5fcefff95e559fe98e86e74bcac6c4a56cdf4bfdcafc6a38a4e09a00155bcbc3865f24e3f6c1df71d87cba296ea9e45d8701b72b439748330c884898d41ca5ef2d41c9151413dfc5a2dbfa1db9dfadf1cdd47052dc05bb173e2975ff863d72b4654e8fc5d338cf18585276f3ae2f3da3a18a550203010001',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,'QMGEMFDMCHXBTH3V1NZVBFWE1JAV69FSBPTQ9ZQ47D1VT15A1PVG',1660654404940,'payto://iban/SANDBOXX/DE236345?receiver-name=Name+unknown');
INSERT INTO TalerIncomingPayments VALUES(2,2,'3T6WV8QNVR1J7GQXSFX54Y71K91ZHH6K22840EM1GNSA4EBYC900',1660654413731,'payto://iban/SANDBOXX/DE209794?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-1660654393506','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343339333530363c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a31332e35303635385a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a31332e35303635385a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(2,1,'sandbox-1660654395844','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343339353834343c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a31352e3834343731335a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a31352e3834343731335a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(3,1,'sandbox-1660654398068','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343339383036383c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a31382e3036383431355a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a31382e3036383431355a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(4,1,'sandbox-1660654400272','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343430303237323c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a32302e3237323833395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a32302e3237323833395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(5,1,'sandbox-1660654402454','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343430323435343c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a32322e3435343431335a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a32322e3435343431335a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(6,1,'sandbox-1660654404657','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343430343635373c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a32342e3635373230395a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a32342e3635373230395a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e45554e43475551583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453233363334353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e514d47454d46444d4348584254483356314e5a5642465745314a41563639465342505451395a51343744315654313541315056473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(7,1,'sandbox-1660654407039','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343430373033393c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a32372e3033393835345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a32372e3033393835345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e45554e43475551583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453233363334353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e514d47454d46444d4348584254483356314e5a5642465745314a41563639465342505451395a51343744315654313541315056473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(8,1,'sandbox-1660654409241','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343430393234313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a32392e3234313930355a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a32392e3234313930355a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e45554e43475551583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453233363334353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e514d47454d46444d4348584254483356314e5a5642465745314a41563639465342505451395a51343744315654313541315056473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(9,1,'sandbox-1660654411421','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343431313432313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a33312e3432313436385a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a33312e3432313436385a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e45554e43475551583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453233363334353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e514d47454d46444d4348584254483356314e5a5642465745314a41563639465342505451395a51343744315654313541315056473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(10,1,'sandbox-1660654413591','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343431333539313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a33332e3539313435385a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a33332e3539313435385a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e45554e43475551583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453233363334353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e514d47454d46444d4348584254483356314e5a5642465745314a41563639465342505451395a51343744315654313541315056473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e463532434b5a4b4a3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453230393739343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e335436575638514e5652314a3747515853465835345937314b39315a4848364b3232383430454d31474e534134454259433930303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(11,1,'sandbox-1660654415794','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343431353739343c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a33352e3739343336365a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a33352e3739343336365a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e45554e43475551583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453233363334353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e514d47454d46444d4348584254483356314e5a5642465745314a41563639465342505451395a51343744315654313541315056473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e463532434b5a4b4a3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453230393739343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e335436575638514e5652314a3747515853465835345937314b39315a4848364b3232383430454d31474e534134454259433930303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(12,1,'sandbox-1660654417968','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343431373936383c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a33372e3936383137385a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a33372e3936383137385a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e45554e43475551583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453233363334353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e514d47454d46444d4348584254483356314e5a5642465745314a41563639465342505451395a51343744315654313541315056473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e463532434b5a4b4a3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453230393739343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e335436575638514e5652314a3747515853465835345937314b39315a4848364b3232383430454d31474e534134454259433930303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(13,1,'sandbox-1660654420140','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343432303134303c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a34302e3134303134345a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a34302e3134303134345a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e45554e43475551583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453233363334353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e514d47454d46444d4348584254483356314e5a5642465745314a41563639465342505451395a51343744315654313541315056473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e463532434b5a4b4a3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453230393739343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e335436575638514e5652314a3747515853465835345937314b39315a4848364b3232383430454d31474e534134454259433930303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(14,1,'sandbox-1660654422308','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343432323330383c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a34322e3330383237375a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a34322e3330383237375a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e45554e43475551583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453233363334353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e514d47454d46444d4348584254483356314e5a5642465745314a41563639465342505451395a51343744315654313541315056473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e463532434b5a4b4a3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453230393739343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e335436575638514e5652314a3747515853465835345937314b39315a4848364b3232383430454d31474e534134454259433930303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',0);
INSERT INTO NexusBankMessages VALUES(15,1,'sandbox-1660654424501','C52',X'3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c446f63756d656e7420786d6c6e733d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322220786d6c6e733a7873693d22687474703a2f2f7777772e77332e6f72672f323030312f584d4c536368656d612d696e7374616e636522207873693a736368656d614c6f636174696f6e3d2275726e3a69736f3a7374643a69736f3a32303032323a746563683a7873643a63616d742e3035322e3030312e30322063616d742e3035322e3030312e30322e787364223e0a20203c426b546f4373746d72416363745270743e0a202020203c4772704864723e0a2020202020203c4d736749643e73616e64626f782d313636303635343432343530313c2f4d736749643e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a34342e3530313933355a3c2f4372654474546d3e0a202020203c2f4772704864723e0a202020203c5270743e0a2020202020203c49643e303c2f49643e0a2020202020203c456c6374726e635365714e623e303c2f456c6374726e635365714e623e0a2020202020203c4c676c5365714e623e303c2f4c676c5365714e623e0a2020202020203c4372654474546d3e323032322d30382d31365431323a35333a34342e3530313933355a3c2f4372654474546d3e0a2020202020203c416363743e0a20202020202020203c49643e0a202020202020202020203c4942414e3e44453437313136303c2f4942414e3e0a20202020202020203c2f49643e0a20202020202020203c4363793e544553544b55444f533c2f4363793e0a20202020202020203c4f776e723e0a202020202020202020203c4e6d3e44656269746f722f4f776e6572204e616d653c2f4e6d3e0a20202020202020203c2f4f776e723e0a20202020202020203c537663723e0a202020202020202020203c46696e496e73746e49643e0a2020202020202020202020203c4e6d3e4c6962657566696e2042616e6b3c2f4e6d3e0a2020202020202020202020203c4f7468723e0a20202020202020202020202020203c49643e303c2f49643e0a20202020202020202020202020203c497373723e58593c2f497373723e0a2020202020202020202020203c2f4f7468723e0a202020202020202020203c2f46696e496e73746e49643e0a20202020202020203c2f537663723e0a2020202020203c2f416363743e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e505243443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c42616c3e0a20202020202020203c54703e0a202020202020202020203c43644f7250727472793e0a2020202020202020202020203c43643e434c42443c2f43643e0a202020202020202020203c2f43644f7250727472793e0a20202020202020203c2f54703e0a20202020202020203c416d74204363793d22544553544b55444f53223e32383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f44743e0a2020202020203c2f42616c3e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e45554e43475551583c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31303c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453233363334353c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e514d47454d46444d4348584254483356314e5a5642465745314a41563639465342505451395a51343744315654313541315056473c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a2020202020203c4e7472793e0a20202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020203c436474446274496e643e435244543c2f436474446274496e643e0a20202020202020203c5374733e424f4f4b3c2f5374733e0a20202020202020203c426f6f6b6744743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f426f6f6b6744743e0a20202020202020203c56616c44743e0a202020202020202020203c44743e323032322d30382d31365a3c2f44743e0a20202020202020203c2f56616c44743e0a20202020202020203c41636374537663725265663e463532434b5a4b4a3c2f41636374537663725265663e0a20202020202020203c426b547843643e0a202020202020202020203c446f6d6e3e0a2020202020202020202020203c43643e504d4e543c2f43643e0a2020202020202020202020203c466d6c793e0a20202020202020202020202020203c43643e494344543c2f43643e0a20202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a2020202020202020202020203c2f466d6c793e0a202020202020202020203c2f446f6d6e3e0a202020202020202020203c50727472793e0a2020202020202020202020203c43643e303c2f43643e0a2020202020202020202020203c497373723e58593c2f497373723e0a202020202020202020203c2f50727472793e0a20202020202020203c2f426b547843643e0a20202020202020203c4e74727944746c733e0a202020202020202020203c547844746c733e0a2020202020202020202020203c526566733e0a20202020202020202020202020203c4d736749643e4e4f5450524f56494445443c2f4d736749643e0a20202020202020202020202020203c506d74496e6649643e4e4f5450524f56494445443c2f506d74496e6649643e0a20202020202020202020202020203c456e64546f456e6449643e4e4f5450524f56494445443c2f456e64546f456e6449643e0a2020202020202020202020203c2f526566733e0a2020202020202020202020203c416d7444746c733e0a20202020202020202020202020203c5478416d743e0a202020202020202020202020202020203c416d74204363793d22544553544b55444f53223e31383c2f416d743e0a20202020202020202020202020203c2f5478416d743e0a2020202020202020202020203c2f416d7444746c733e0a2020202020202020202020203c426b547843643e0a20202020202020202020202020203c446f6d6e3e0a202020202020202020202020202020203c43643e504d4e543c2f43643e0a202020202020202020202020202020203c466d6c793e0a2020202020202020202020202020202020203c43643e494344543c2f43643e0a2020202020202020202020202020202020203c537562466d6c7943643e455343543c2f537562466d6c7943643e0a202020202020202020202020202020203c2f466d6c793e0a20202020202020202020202020203c2f446f6d6e3e0a20202020202020202020202020203c50727472793e0a202020202020202020202020202020203c43643e303c2f43643e0a202020202020202020202020202020203c497373723e58593c2f497373723e0a20202020202020202020202020203c2f50727472793e0a2020202020202020202020203c2f426b547843643e0a2020202020202020202020203c526c746450746965733e0a20202020202020202020202020203c446274723e0a202020202020202020202020202020203c4e6d3e4e616d6520756e6b6e6f776e3c2f4e6d3e0a20202020202020202020202020203c2f446274723e0a20202020202020202020202020203c44627472416363743e0a202020202020202020202020202020203c49643e0a2020202020202020202020202020202020203c4942414e3e44453230393739343c2f4942414e3e0a202020202020202020202020202020203c2f49643e0a20202020202020202020202020203c2f44627472416363743e0a2020202020202020202020203c2f526c746450746965733e0a2020202020202020202020203c526c7464416774733e0a20202020202020202020202020203c446274724167743e0a202020202020202020202020202020203c46696e496e73746e49643e0a2020202020202020202020202020202020203c4249433e53414e44424f58583c2f4249433e0a202020202020202020202020202020203c2f46696e496e73746e49643e0a20202020202020202020202020203c2f446274724167743e0a2020202020202020202020203c2f526c7464416774733e0a2020202020202020202020203c526d74496e663e0a20202020202020202020202020203c55737472643e335436575638514e5652314a3747515853465835345937314b39315a4848364b3232383430454d31474e534134454259433930303c2f55737472643e0a2020202020202020202020203c2f526d74496e663e0a202020202020202020203c2f547844746c733e0a20202020202020203c2f4e74727944746c733e0a2020202020203c2f4e7472793e0a202020203c2f5270743e0a20203c2f426b546f4373746d72416363745270743e0a3c2f446f63756d656e743e',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,'DE471160','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;
