scufpong/src/auth-server/sql/schema.sql

CREATE TABLE IF NOT EXISTS users (
    id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    email text UNIQUE NOT NULL,
    password text NOT NULL
);

CREATE TABLE IF NOT EXISTS matches (
    id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    player1_id uuid NOT NULL REFERENCES users,
    player2_id uuid NOT NULL REFERENCES users,
    player1_score int NOT NULL,
    player2_score int NOT NULL,
    player1_won bool NOT NULL
);