aboutsummaryrefslogtreecommitdiff
path: root/planetwars-server/migrations/2022-01-02-105610_matches/up.sql
blob: 88c8c9ed80f3de0ff16edef8c48d4090d7096022 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
CREATE TABLE matches (
    id SERIAL PRIMARY KEY,
    log_path text NOT NULL,
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX match_created_at ON matches(created_at);

CREATE TABLE match_players (
    match_id integer REFERENCES matches(id) NOT NULL,
    bot_id integer REFERENCES bots(id) NOT NULL,
    player_id integer NOT NULL,
    PRIMARY KEY (match_id, player_id)
);