DEVELOPMENT ENVIRONMENT

~liljamo/deck-builder

ref: 0cc6737453188e1baa069e7c6546b5e3fd7ccdd3 deck-builder/api/migrations/2023-02-17-095727_create_games/up.sql -rw-r--r-- 500 bytes
0cc67374Jonni Liljamo feat(client): graceful exit with disconnect 1 year, 9 months ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- Your SQL goes here

CREATE TABLE games (
    id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
    created_at TIMESTAMPTZ NOT NULL DEFAULT current_timestamp,
    updated_at TIMESTAMPTZ NOT NULL DEFAULT current_timestamp,
    host_id uuid REFERENCES users(id) NOT NULL,
    guest_id uuid REFERENCES users(id) DEFAULT NULL,
    state SMALLINT NOT NULL,
    ended_at TIMESTAMPTZ DEFAULT NULL,
    game_data_id uuid REFERENCES gamedata(id) NOT NULL
);

SELECT diesel_manage_updated_at('games');