CREATE TABLE users(
    uuid TEXT PRIMARY KEY,
    name TEXT,
    password TEXT,
    admin BOOLEAN,
    enabled BOOLEAN
);

CREATE TABLE games(
    uuid TEXT PRIMARY KEY,
    name TEXT
);

CREATE TABLE characters(
    uuid TEXT PRIMARY KEY,
    game TEXT,
    data TEXT,

    FOREIGN KEY(game) REFERENCES games(uuid)
);

CREATE TABLE roles(
    user_id TEXT,
    game_id TEXT,
    role TEXT,

    FOREIGN KEY(user_id) REFERENCES users(uuid),
    FOREIGN KEY(game_id) REFERENCES games(uuid)
);

INSERT INTO users VALUES ("admin", "admin", "", true, true);