DEVELOPMENT ENVIRONMENT

~liljamo/deck-builder

ref: 4eab707e2d2a94f8ab14a66f5b3ec18e3495b2e6 deck-builder/api/migrations/2023-02-17-085226_create_gamedata/up.sql -rw-r--r-- 391 bytes
4eab707eJonni Liljamo feat(server, client): handle tick events, sorta 1 year, 7 months ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- Your SQL goes here

CREATE TABLE gamedata (
    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,
    turn SMALLINT NOT NULL,
    host_hand json,
    host_deck json,
    guest_hand json,
    guest_deck json
);

SELECT diesel_manage_updated_at('gamedata');