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');