扫描区块技术Block scan

最新推荐文章于 2025-06-28 09:02:41 发布

江西师范大学-20届-吴悠

最新推荐文章于 2025-06-28 09:02:41 发布

阅读量567

点赞数

CC 4.0 BY-SA版权

分类专栏：区块链

本文链接：https://blog.youkuaiyun.com/qq_39905917/article/details/86382623

扫描区块技术Block scan

笔记码住
在这里插入图片描述

     def init_table(conn):
tables = []
tb_block = '''
create table if not EXISTS block (
  number bigint primary KEY ,
  hash char(64) not null,
  bits bigint,
  transaction_count INTEGER ,
  mixhash  VARCHAR (128),
  version char(8) ,
  merkle_tree_hash char(64),
  previous_block_hash CHAR (64),
  nonce varchar(128) ,
  time_stamp bigint
) DEFAULT charset=utf8;
'''

tb_tx = '''
  create table if not EXISTS tx (
    id bigint PRIMARY KEY ,
    block_height bigint REFERENCES block(id),
    hash char(64) not null
  )DEFAULT charset=utf8 ;'''

tb_address = '''
    create table if not EXISTS address(
        id int PRIMARY KEY ,
        address VARCHAR (64) UNIQUE
    )DEFAULT charset=utf8;
'''

tb_output = '''
    create table if not EXISTS tx_output(
      id bigint PRIMARY key,
      hash char(64) NOT NULL