mirror of
https://github.com/scroll-tech/scroll.git
synced 2026-01-13 16:08:04 -05:00
47 lines
1.4 KiB
SQL
47 lines
1.4 KiB
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
|
|
create table prover_task
|
|
(
|
|
id BIGSERIAL PRIMARY KEY,
|
|
|
|
-- prover
|
|
prover_public_key VARCHAR NOT NULL,
|
|
prover_name VARCHAR NOT NULL,
|
|
prover_version VARCHAR NOT NULL,
|
|
|
|
-- task
|
|
task_id VARCHAR NOT NULL,
|
|
task_type SMALLINT NOT NULL DEFAULT 0,
|
|
|
|
-- status
|
|
proving_status SMALLINT NOT NULL DEFAULT 0,
|
|
failure_type SMALLINT NOT NULL DEFAULT 0,
|
|
reward DECIMAL(78, 0) NOT NULL DEFAULT 0,
|
|
proof BYTEA DEFAULT NULL,
|
|
assigned_at TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
-- 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,
|
|
|
|
CONSTRAINT uk_tasktype_taskid_publickey_version UNIQUE (task_type, task_id, prover_public_key, prover_version)
|
|
);
|
|
|
|
comment
|
|
on column prover_task.task_type is 'undefined, chunk, batch';
|
|
|
|
comment
|
|
on column prover_task.proving_status is 'undefined, prover assigned, prover proof valid, prover proof invalid';
|
|
|
|
comment
|
|
on column prover_task.failure_type is 'undefined';
|
|
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
drop table if exists prover_task;
|
|
-- +goose StatementEnd
|