src/database/sql/initialize.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

CREATE TABLE IF NOT EXISTS problem (
    id          INTEGER PRIMARY KEY,
    title       TEXT NOT NULL,
    description TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS user (
    id            INTEGER PRIMARY KEY,
    email         TEXT UNIQUE NOT NULL,
    username      TEXT UNIQUE NOT NULL,
    password_hash TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS submission (
    id         INTEGER PRIMARY KEY,
    user_id    INTEGER NOT NULL,
    problem_id INTEGER NOT NULL,
    code       TEXT NOT NULL,
    language   TEXT NOT NULL,
    validated  INTEGER NOT NULL
);