DEVELOPMENT ENVIRONMENT

~liljamo/deck-builder

ref: a69dd4f47395fb45e5008d5cd4ba6f8c6e5ddc9a deck-builder/api/migrations/2023-02-17-075706_create_users/up.sql -rw-r--r-- 406 bytes
a69dd4f4Jonni Liljamo feat(client): user cache, and PubUserDetails event 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 users (
    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,
    username VARCHAR NOT NULL,
    email VARCHAR NOT NULL,
    password VARCHAR NOT NULL,
    UNIQUE(username),
    UNIQUE(email)
);

SELECT diesel_manage_updated_at('users');