18 lines
576 B
SQL
18 lines
576 B
SQL
CREATE TABLE IF NOT EXISTS tournament_info (
|
|
id SERIAL PRIMARY KEY,
|
|
title TEXT NOT NULL,
|
|
game TEXT NOT NULL,
|
|
slug TEXT NOT NULL,
|
|
tagline TEXT,
|
|
start_at TIMESTAMPTZ,
|
|
location TEXT,
|
|
description TEXT,
|
|
contact TEXT,
|
|
signup_mode TEXT NOT NULL DEFAULT 'solo',
|
|
team_size_min INTEGER NOT NULL DEFAULT 1,
|
|
team_size_max INTEGER NOT NULL DEFAULT 1,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
|
|
);
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS tournament_info_slug_idx ON tournament_info(slug);
|