CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT NOT NULL UNIQUE,
    password TEXT NOT NULL,
    score INTEGER NOT NULL DEFAULT 0,
    challanges TEXT
);

CREATE TABLE IF NOT EXISTS challenges (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT NOT NULL,
    word TEXT NOT NULL,
    hint TEXT NOT NULL,
    player TEXT NOT NULL,
    accepted INTEGER,
    seen INTEGER,
    won INTEGER
);
