mirror of
https://github.com/scroll-tech/scroll.git
synced 2026-01-14 08:28:02 -05:00
33 lines
944 B
SQL
33 lines
944 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
|
|
create table l1_block
|
|
(
|
|
number BIGINT NOT NULL,
|
|
hash VARCHAR NOT NULL,
|
|
header_rlp TEXT NOT NULL,
|
|
base_fee BIGINT NOT NULL,
|
|
block_status INTEGER DEFAULT 1,
|
|
import_tx_hash VARCHAR DEFAULT NULL,
|
|
oracle_status INTEGER DEFAULT 1,
|
|
oracle_tx_hash VARCHAR DEFAULT NULL
|
|
);
|
|
|
|
comment
|
|
on column l1_block.block_status is 'undefined, pending, importing, imported, failed';
|
|
|
|
comment
|
|
on column l1_block.oracle_status is 'undefined, pending, importing, imported, failed';
|
|
|
|
create unique index l1_block_hash_uindex
|
|
on l1_block (hash);
|
|
|
|
create unique index l1_block_number_uindex
|
|
on l1_block (number);
|
|
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
drop table if exists l1_block;
|
|
-- +goose StatementEnd |