mirror of
https://github.com/scroll-tech/scroll.git
synced 2026-04-23 03:00:50 -04:00
37 lines
1.0 KiB
SQL
37 lines
1.0 KiB
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
create table l2_message
|
|
(
|
|
nonce BIGINT NOT NULL,
|
|
msg_hash VARCHAR NOT NULL,
|
|
height BIGINT NOT NULL,
|
|
sender VARCHAR NOT NULL,
|
|
target VARCHAR NOT NULL,
|
|
value VARCHAR NOT NULL,
|
|
calldata TEXT NOT NULL,
|
|
layer2_hash VARCHAR NOT NULL,
|
|
layer1_hash VARCHAR DEFAULT NULL,
|
|
proof TEXT DEFAULT NULL,
|
|
status INTEGER DEFAULT 1,
|
|
created_at TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
comment
|
|
on column l2_message.status is 'undefined, pending, submitted, confirmed, failed, expired, relay_failed';
|
|
|
|
create unique index l2_message_hash_uindex
|
|
on l2_message (msg_hash);
|
|
|
|
create unique index l2_message_nonce_uindex
|
|
on l2_message (nonce);
|
|
|
|
create index l2_message_height_index
|
|
on l2_message (height);
|
|
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
drop table if exists l2_message;
|
|
-- +goose StatementEnd |