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
22
23

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,
    is_admin      INTEGER NOT NULL
);

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