mirror of
https://github.com/scroll-tech/scroll.git
synced 2026-01-11 23:18:07 -05:00
2a0c7ae6b5
Co-authored-by: georgehao <haohongfan@gmail.com> Co-authored-by: HAOYUatHZ <37070449+HAOYUatHZ@users.noreply.github.com>
20 lines
567 B
SQL
20 lines
567 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
|
|
create table challenge
|
|
(
|
|
id BIGSERIAL PRIMARY KEY,
|
|
challenge VARCHAR NOT NULL ,
|
|
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_challenge UNIQUE (challenge)
|
|
);
|
|
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
drop table if exists challenge;
|
|
-- +goose StatementEnd
|