{"action":"created","issue":{"url":"https://api.github.com/repos/xcps/gostexplr/issues/5","repository_url":"https://api.github.com/repos/xcps/gostexplr","labels_url":"https://api.github.com/repos/xcps/gostexplr/issues/5/labels{/name}","comments_url":"https://api.github.com/repos/xcps/gostexplr/issues/5/comments","events_url":"https://api.github.com/repos/xcps/gostexplr/issues/5/events","html_url":"https://github.com/xcps/gostexplr/issues/5","id":464909650,"node_id":"MDU6SXNzdWU0NjQ5MDk2NTA=","number":5,"title":"Null?","user":{"login":"r4sas","id":7023612,"node_id":"MDQ6VXNlcjcwMjM2MTI=","avatar_url":"https://avatars2.githubusercontent.com/u/7023612?v=4","gravatar_id":"","url":"https://api.github.com/users/r4sas","html_url":"https://github.com/r4sas","followers_url":"https://api.github.com/users/r4sas/followers","following_url":"https://api.github.com/users/r4sas/following{/other_user}","gists_url":"https://api.github.com/users/r4sas/gists{/gist_id}","starred_url":"https://api.github.com/users/r4sas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/r4sas/subscriptions","organizations_url":"https://api.github.com/users/r4sas/orgs","repos_url":"https://api.github.com/users/r4sas/repos","events_url":"https://api.github.com/users/r4sas/events{/privacy}","received_events_url":"https://api.github.com/users/r4sas/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2019-07-07T03:03:38Z","updated_at":"2019-08-05T14:12:20Z","closed_at":null,"author_association":"COLLABORATOR","body":"<details>\r\n  <summary>Error</summary>\r\n\r\n```\r\nsyncedHeight is 397534\r\ncurrentHeight is 399996\r\n{ SequelizeDatabaseError: Column 'VoutId' cannot be null\r\n    at Query.formatError (/home/gst/gostexplr/node_modules/sequelize/lib/dialects/mysql/query.js:239:16)\r\n    at Query.handler [as onResult] (/home/gst/gostexplr/node_modules/sequelize/lib/dialects/mysql/query.js:46:23)\r\n    at Query.execute (/home/gst/gostexplr/node_modules/mysql2/lib/commands/command.js:30:14)\r\n    at Connection.handlePacket (/home/gst/gostexplr/node_modules/mysql2/lib/connection.js:449:32)\r\n    at PacketParser.Connection.packetParser.p [as onPacket] (/home/gst/gostexplr/node_modules/mysql2/lib/connection.js:72:12)\r\n    at PacketParser.executeStart (/home/gst/gostexplr/node_modules/mysql2/lib/packet_parser.js:75:16)\r\n    at Socket.Connection.stream.on.data (/home/gst/gostexplr/node_modules/mysql2/lib/connection.js:79:25)\r\n    at emitOne (events.js:116:13)\r\n    at Socket.emit (events.js:211:7)\r\n    at addChunk (_stream_readable.js:263:12)\r\n    at readableAddChunk (_stream_readable.js:250:11)\r\n    at Socket.Readable.push (_stream_readable.js:208:10)\r\n    at TCP.onread (net.js:594:20)\r\n  name: 'SequelizeDatabaseError',\r\n  parent:\r\n   { Error: Column 'VoutId' cannot be null\r\n    at Packet.asError (/home/gst/gostexplr/node_modules/mysql2/lib/packets/packet.js:684:17)\r\n    at Query.execute (/home/gst/gostexplr/node_modules/mysql2/lib/commands/command.js:28:26)\r\n    at Connection.handlePacket (/home/gst/gostexplr/node_modules/mysql2/lib/connection.js:449:32)\r\n    at PacketParser.Connection.packetParser.p [as onPacket] (/home/gst/gostexplr/node_modules/mysql2/lib/connection.js:72:12)\r\n    at PacketParser.executeStart (/home/gst/gostexplr/node_modules/mysql2/lib/packet_parser.js:75:16)\r\n    at Socket.Connection.stream.on.data (/home/gst/gostexplr/node_modules/mysql2/lib/connection.js:79:25)\r\n    at emitOne (events.js:116:13)\r\n    at Socket.emit (events.js:211:7)\r\n    at addChunk (_stream_readable.js:263:12)\r\n    at readableAddChunk (_stream_readable.js:250:11)\r\n    at Socket.Readable.push (_stream_readable.js:208:10)\r\n    at TCP.onread (net.js:594:20)\r\n     code: 'ER_BAD_NULL_ERROR',\r\n     errno: 1048,\r\n     sqlState: '23000',\r\n     sqlMessage: 'Column \\'VoutId\\' cannot be null',\r\n     sql: '...' },\r\n  sql: '...' }\r\n```\r\n</details>\r\n\r\n<details>\r\n  <summary>SQL</summary>\r\n\r\n```sql\r\nSET autocommit = 0;\r\nSTART TRANSACTION;\r\nINSERT INTO Block (\r\n  hash,\r\n  height,\r\n  size,\r\n  version,\r\n  merkleroot,\r\n  time,\r\n  nonce,\r\n  bits,\r\n  difficulty,\r\n  hashrate,\r\n  previousblockhash\r\n)\r\nVALUES (\r\n  \"000000000003449b3d6b192f1fd23cd6ceeb597d74f4fdcbb641f937dc9f0356\",\r\n  \"397535\",\r\n  \"4907\",\r\n  \"2\",\r\n  \"18657b68d85b8a1dcb0bfc2e275f90c3930746ccc36c8c385a29c8519bb75956\",\r\n  \"2019-07-01 18:25:34\",\r\n  \"36127207\",\r\n  \"1c00ff6b\",\r\n  \"256.5794424\",\r\n  \"5072821937\",\r\n  \"00000000004570e98f6efa068db0a6687ecdc7f6f4d77efb915fd965c339f116\"\r\n);\r\n\r\nINSERT INTO Transactions (\r\n  txid,\r\n  BlockHeight\r\n)\r\nVALUES (\r\n  \"70b0f2209e151e32ea37a4ff643c952be2e61dffc2ff61c023e5d9df8213826c\",\r\n  397535\r\n);\r\nSET @txid = LAST_INSERT_ID();\r\n\r\nINSERT INTO Vouts (n, value)\r\nVALUES (\"0\", \"2.45\");\r\nSET @voutid= LAST_INSERT_ID();\r\n\r\nINSERT IGNORE INTO Addresses (address) VALUES (\"GNEDYzvY1nTU36sPQN92e9tfKtUHAUvL1g\");\r\nSET @addrid = (\r\n  SELECT IF(\r\n    ROW_COUNT() > 0,\r\n    LAST_INSERT_ID(),\r\n    (\r\n      SELECT id\r\n      FROM Addresses\r\n      WHERE address='GNEDYzvY1nTU36sPQN92e9tfKtUHAUvL1g'\r\n    )\r\n  )\r\n);\r\n\r\nINSERT INTO AddressVouts (AddressId, VoutId)\r\nVALUES (@addrid, @voutid);\r\n\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @voutid, 1);\r\n\r\nINSERT INTO Vouts (n, value)\r\nVALUES (\"1\", \"0.05\");\r\nSET @voutid= LAST_INSERT_ID();\r\n\r\nINSERT IGNORE INTO Addresses (address) VALUES (\"GJTPVtheb3QpAAdFo9BEdjrW7M8PSZw5BN\");\r\nSET @addrid = (\r\n  SELECT IF(\r\n    ROW_COUNT() > 0,\r\n    LAST_INSERT_ID(),\r\n    (\r\n      SELECT id\r\n      FROM Addresses\r\n      WHERE address='GJTPVtheb3QpAAdFo9BEdjrW7M8PSZw5BN'\r\n    )\r\n  )\r\n);\r\n\r\nINSERT INTO AddressVouts (AddressId, VoutId)\r\nVALUES (@addrid, @voutid);\r\n\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @voutid, 1);\r\n\r\nINSERT INTO Transactions (\r\n  txid,\r\n  BlockHeight\r\n)\r\nVALUES (\r\n  \"7e3449bbf13afe6db0fa2b916034e093e51fcf59833417ae26ed35c0b0ce5aa5\",\r\n  397535\r\n);\r\nSET @txid = LAST_INSERT_ID();\r\n\r\nINSERT INTO Vouts (n, value)\r\nVALUES (\"0\", \"75.8323097\");\r\nSET @voutid= LAST_INSERT_ID();\r\n\r\nINSERT IGNORE INTO Addresses (address) VALUES (\"GXRXidc26PJDeG2r1grVNdZ32QfbvJGixS\");\r\nSET @addrid = (\r\n  SELECT IF(\r\n    ROW_COUNT() > 0,\r\n    LAST_INSERT_ID(),\r\n    (\r\n      SELECT id\r\n      FROM Addresses\r\n      WHERE address='GXRXidc26PJDeG2r1grVNdZ32QfbvJGixS'\r\n    )\r\n  )\r\n);\r\n\r\nINSERT INTO AddressVouts (AddressId, VoutId)\r\nVALUES (@addrid, @voutid);\r\n\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @voutid, 1);\r\n\r\nINSERT INTO Vouts (n, value)\r\nVALUES (\"1\", \"0.1176903\");\r\nSET @voutid= LAST_INSERT_ID();\r\n\r\nINSERT IGNORE INTO Addresses (address) VALUES (\"GHx12Qs8eD6SsoikV6whTpTGUGGgPPhfz3\");\r\nSET @addrid = (\r\n  SELECT IF(\r\n    ROW_COUNT() > 0,\r\n    LAST_INSERT_ID(),\r\n    (\r\n      SELECT id\r\n      FROM Addresses\r\n      WHERE address='GHx12Qs8eD6SsoikV6whTpTGUGGgPPhfz3'\r\n    )\r\n  )\r\n);\r\n\r\nINSERT INTO AddressVouts (AddressId, VoutId)\r\nVALUES (@addrid, @voutid);\r\n\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @voutid, 1);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"ac12e0c8f7e28ebe124471a5414485e4f5605bf4c174e5c8a0459b4f88109927\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"394d29d4544600633b4beeda234982d65f1a64c087e6d38177679aeae5c8b1ff\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"52836d77dc5ba878d74f8c4033c68380403a968582d52703af567fc75e053540\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"9b66a2129c47d9db91f0ca05fa40f5ee03380119921f499967bd5eb14e943eb2\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"538460c88aeb92cb3649d6427e28dd728e0aa8f80fd41129458ac3d26dddf5e4\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"470952816e67047424d11ec3f6e432cf9d6187e57cc0cf4e6c358d2cf35303cd\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"9729d71eed3cea6d8c9a18df40b77ebeeeb2ce8370250098aeb539e67d948840\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"fa0a5d103dfec5323aa0840f5d0d131a9f5270c1c0d6f1e96dbac18b4aece614\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"271687c502ac61db6b9f55c017b1698ae8ba32774ee670c5687d2ae5802d59ab\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"dcea539dce9a730d9d0ea6f129e975bc42061bb6dff2913ca7de63565f717282\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"11d896d0af256eb512db0106a9588d265534b0a2e9c84a96cbf7054445f411fc\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"9f9c8599c701a9d4f0e01b7eedf0855a5a77e3d7a90a193b71be229bb7bd111e\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"686277dc332f0932df9a09d69fa070992cdee6252f08d2f086be5ff9c723910e\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"74c10b38ca4f370d325cc8770131b9320cbe57cb7e9f4adf0ae1e6dda84986d6\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"3e9cbcee51fa8c33933a3fcf9f0a2c67d2db4018217390139b0ed69c0b077c8b\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"ee57ac892c564c054b06ff7d679228eff04b77a8785ba7929ae4f36796ffce4c\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"148260151933683183df9db3d0d75feba5522bd10f61222804c6a637e5fe7ec8\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"b8ad4ea8cef70ae092a4212ec928e0d41a292c0a4343975ac536506050234d99\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"f415fdc78cd506db0481ab710d351c6b8d7a219fdf47e5c646e9f05c8f860e1f\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"a4030f7b9a48ca1415dacc0d33e96d755a02fe93c6624dab96b11ec015fcc76a\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"276b7476ecb66c14930ba6d25a1365258eafcbbc768770038127817ee24f8174\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"f1375ece4242eae3b274fa488d5a1b5d647f697cfc5ceeae527021bebf6d776e\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"4bd05b8541b85495cd6b2e153ff8a1adec3f2603a0e7ef7a9f65e781c0acbf8b\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"7e9f5553664141589f2216ea77602948a9aa727d6232521f419db19e32ec4148\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"9d2e0dea1d8614b161f4aa97b89a3b4a01c2a1ca6f087e8ebaf5ceb8e09b48fe\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"74a56d681824e1e550f26f6af85c45b955da9e7bbe68ee942c3e53d81c85755b\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"dc6b1a1cfcd34ba3f1fa3242ec3aaf13fa0395c9bfac42291f0407f86aab36e2\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"f7e812806367d626601ec68f2d4224cd2ddc650a44693a7db105161a9d4f20ec\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"26dcb72361bdfe5621292f6a7ac9b98eade83f054b9c637e60e97e881eb7c1f4\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"10e1e537c0065c9a134bf9916e4f72410a4cc50214fd5b9f5a51f640291cdf0d\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nSET @vin = (\r\n  SELECT Vouts.id\r\n  FROM Vouts\r\n  INNER JOIN TransactionVouts\r\n  ON Vouts.id=TransactionVouts.VoutId\r\n  INNER JOIN Transactions\r\n  ON Transactions.id=TransactionVouts.TransactionId\r\n  WHERE\r\n    TransactionVouts.direction=1 AND\r\n    Transactions.txid=\"9de778edce8bbef58a46c9e753ff590298248667cc664b107a60ca2cba76d7ff\" AND\r\n    Vouts.n=0\r\n);\r\nINSERT INTO TransactionVouts (TransactionId, VoutId, direction)\r\nVALUES (@txid, @vin, 0);\r\n\r\nUPDATE Block\r\nSET nextblockhash=\"000000000003449b3d6b192f1fd23cd6ceeb597d74f4fdcbb641f937dc9f0356\"\r\nWHERE hash=\"00000000004570e98f6efa068db0a6687ecdc7f6f4d77efb915fd965c339f116\";\r\nCOMMIT;\r\n```\r\n\r\n</details>"},"comment":{"url":"https://api.github.com/repos/xcps/gostexplr/issues/comments/518251075","html_url":"https://github.com/xcps/gostexplr/issues/5#issuecomment-518251075","issue_url":"https://api.github.com/repos/xcps/gostexplr/issues/5","id":518251075,"node_id":"MDEyOklzc3VlQ29tbWVudDUxODI1MTA3NQ==","user":{"login":"r4sas","id":7023612,"node_id":"MDQ6VXNlcjcwMjM2MTI=","avatar_url":"https://avatars2.githubusercontent.com/u/7023612?v=4","gravatar_id":"","url":"https://api.github.com/users/r4sas","html_url":"https://github.com/r4sas","followers_url":"https://api.github.com/users/r4sas/followers","following_url":"https://api.github.com/users/r4sas/following{/other_user}","gists_url":"https://api.github.com/users/r4sas/gists{/gist_id}","starred_url":"https://api.github.com/users/r4sas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/r4sas/subscriptions","organizations_url":"https://api.github.com/users/r4sas/orgs","repos_url":"https://api.github.com/users/r4sas/repos","events_url":"https://api.github.com/users/r4sas/events{/privacy}","received_events_url":"https://api.github.com/users/r4sas/received_events","type":"User","site_admin":false},"created_at":"2019-08-05T14:12:20Z","updated_at":"2019-08-05T14:12:20Z","author_association":"COLLABORATOR","body":"Добавлен оффсет импорта блоков в БД - https://github.com/xcps/gostexplr/commit/12b6a3c91eb2f05889d95986cb5912687a84a71d."}}
{"actor":{"display_login":"r4sas"}}