go run *.go databases index find-contracts --chain b3
Will fill from last block to first all contracts.
Column | Type | Collation | Nullable | Default
-----------------------------+--------------------------+-----------+----------+----------------------------------------------
address | bytea | | not null |
deployed_bytecode | text | | not null |
deployed_bytecode_hash | character varying(32) | | not null |
bytecode_storage_id | uuid | | |
abi | jsonb | | |
deployed_at_block_number | bigint | | not null |
deployed_at_block_hash | character varying(256) | | not null |
deployed_at_block_timestamp | bigint | | not null |
transaction_hash | character varying(256) | | not null |
transaction_index | bigint | | not null |
name | character varying(256) | | |
statistics | jsonb | | |
supported_standards | jsonb | | |
created_at | timestamp with time zone | | not null | timezone('utc'::text, statement_timestamp())
updated_at | timestamp with time zone | | not null | timezone('utc'::text, statement_timestamp())
deployed_by | bytea | | not null |
And bytestorage table.
Column | Type | Collation | Nullable | Default
-------------+--------------------------+-----------+----------+----------------------------------------------
id | uuid | | not null |
hash | character varying(32) | | not null |
bytecode | text | | not null |
title | character varying(256) | | |
description | text | | |
abi | jsonb | | |
code | text | | |
data | jsonb | | |
created_at | timestamp with time zone | | not null | timezone('utc'::text, statement_timestamp())
updated_at | timestamp with time zone | | not null | timezone('utc'::text, statement_timestamp())
go run *.go databases index find-contracts --chain b3
Will fill from last block to first all contracts.
And bytestorage table.