DEVELOPMENT ENVIRONMENT

~liljamo/deck-builder

ref: b73c71ffa578fc06d915a1c0a578d2c9ee2ee371 deck-builder/api/migrations/2023-02-17-085421_create_actions/up.sql -rw-r--r-- 469 bytes
b73c71ffJonni Liljamo chore(api): argon2 dep, uuid dep absolute fuckery 1 year, 9 months ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
-- Your SQL goes here

CREATE TABLE actions (
    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,
    game_data_id uuid REFERENCES gamedata(id) NOT NULL,
    invoker uuid REFERENCES users(id) NOT NULL,
    data json NOT NULL,
    timestamp TIMESTAMPTZ NOT NULL DEFAULT current_timestamp
);

SELECT diesel_manage_updated_at('actions');