mirror of
https://github.com/scroll-tech/scroll.git
synced 2026-01-12 15:38:18 -05:00
64 lines
2.2 KiB
SQL
64 lines
2.2 KiB
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
|
|
create table batch
|
|
(
|
|
-- batch
|
|
index BIGINT NOT NULL,
|
|
hash VARCHAR NOT NULL,
|
|
start_chunk_index BIGINT NOT NULL,
|
|
start_chunk_hash VARCHAR NOT NULL,
|
|
end_chunk_index BIGINT NOT NULL,
|
|
end_chunk_hash VARCHAR NOT NULL,
|
|
state_root VARCHAR NOT NULL,
|
|
withdraw_root VARCHAR NOT NULL,
|
|
parent_batch_hash VARCHAR NOT NULL,
|
|
batch_header BYTEA NOT NULL,
|
|
|
|
-- proof
|
|
chunk_proofs_status SMALLINT NOT NULL DEFAULT 1,
|
|
proving_status SMALLINT NOT NULL DEFAULT 1,
|
|
proof BYTEA DEFAULT NULL,
|
|
prover_assigned_at TIMESTAMP(0) DEFAULT NULL,
|
|
proved_at TIMESTAMP(0) DEFAULT NULL,
|
|
proof_time_sec INTEGER DEFAULT NULL,
|
|
|
|
-- rollup
|
|
rollup_status SMALLINT NOT NULL DEFAULT 1,
|
|
commit_tx_hash VARCHAR DEFAULT NULL,
|
|
committed_at TIMESTAMP(0) DEFAULT NULL,
|
|
finalize_tx_hash VARCHAR DEFAULT NULL,
|
|
finalized_at TIMESTAMP(0) DEFAULT NULL,
|
|
|
|
-- gas oracle
|
|
oracle_status SMALLINT NOT NULL DEFAULT 1,
|
|
oracle_tx_hash VARCHAR DEFAULT NULL,
|
|
|
|
-- metadata
|
|
created_at TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
deleted_at TIMESTAMP(0) DEFAULT NULL
|
|
);
|
|
|
|
create unique index batch_index_uindex
|
|
on batch (index) where deleted_at IS NULL;
|
|
|
|
create unique index batch_hash_uindex
|
|
on batch (hash) where deleted_at IS NULL;
|
|
|
|
comment
|
|
on column batch.chunk_proofs_status is 'undefined, pending, ready';
|
|
|
|
comment
|
|
on column batch.proving_status is 'undefined, unassigned, assigned, proved (deprecated), verified, failed';
|
|
|
|
comment
|
|
on column batch.rollup_status is 'undefined, pending, committing, committed, finalizing, finalized, commit_failed, finalize_failed';
|
|
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
drop table if exists batch;
|
|
-- +goose StatementEnd
|