ipld-eth-db/db/migrations/00002_create_nodes_table.sql

12 lines
250 B
MySQL
Raw Permalink Normal View History

2021-08-29 18:55:44 +00:00
-- +goose Up
2022-03-22 00:53:48 +00:00
CREATE TABLE IF NOT EXISTS nodes (
genesis_block VARCHAR(66),
network_id VARCHAR,
node_id VARCHAR(128) PRIMARY KEY,
client_name VARCHAR,
chain_id INTEGER DEFAULT 1
2021-08-29 18:55:44 +00:00
);
-- +goose Down
DROP TABLE nodes;