STEEMSQL 系列之 STEEMIT真的可以恢复删除的文章或评论么？

MSSQL Database

@nationalpark 兄在这篇帖子里列出了被删除评论或者文章所存的STEEMSQL 语句. 老实说, 我很久之前也注意过这个表, 但是当时还在纳闷说怎么没有列出我比较关心的, 被删除内容的原文. 这个 TxDeleteComments 意思就是被删除的评论表, 结构如下:

steemsql-txdeletecomments-table

我把我的ID代了进去, 发现我曾经删除过5个评论, 评论的 permlink 以re- 开始.

steemsql-txdeletecomments-linqpad

我们还注意到, tx_id 就是 Transactions 表的外键.

transactions-table-steemsql

这个Transactions 表应该存着STEEM 区块链上所有发生的动作, 包括转帐, 帐户更新, 投票等. 同时Transactions 这个表可以通过 block_num 这个外键联结到 Blocks块表.

steemsql-blocks-table

然后我们很容易的把这三个表串起来:

select 
    TxDeleteComments.tx_id, 
    TxDeleteComments.permlink,
    TxDeleteComments.timestamp,
    Transactions.block_num,
    Transactions.transaction_num,
    Transactions.ref_block_num,
    Transactions.ref_block_prefix,
    Transactions.expiration,
    Transactions.type,
    Blocks.previous,
    Blocks.witness,
    Blocks.witness_signature,
    Blocks.transaction_merkle_root
    
from 
    TxDeleteComments, 
    Transactions, 
    Blocks 
    
where 
    TxDeleteComments.author = 'justyy' and
    TxDeleteComments.tx_id = Transactions.tx_id and
    Transactions.block_num = Blocks.block_num

select 
    TxDeleteComments.tx_id, 
    TxDeleteComments.permlink,
    TxDeleteComments.timestamp,
    Transactions.block_num,
    Transactions.transaction_num,
    Transactions.ref_block_num,
    Transactions.ref_block_prefix,
    Transactions.expiration,
    Transactions.type,
    Blocks.previous,
    Blocks.witness,
    Blocks.witness_signature,
    Blocks.transaction_merkle_root
    
from 
    TxDeleteComments, 
    Transactions, 
    Blocks 
    
where 
    TxDeleteComments.author = 'justyy' and
    TxDeleteComments.tx_id = Transactions.tx_id and
    Transactions.block_num = Blocks.block_num

得到的信息是不是有点多? 就问你怕不怕.