gURL/init.sql at main · 4dawit/gURL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
PRAGMA foreign_keys = ON;

CREATE TABLE IF NOT EXISTS request (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    user_email TEXT NOT NULL,
    command TEXT NOT NULL,
    status TEXT NOT NULL,
    method TEXT NOT NULL,
    date TEXT NOT NULL,
    hidden INTEGER NOT NULL
);

CREATE TABLE IF NOT EXISTS "user" (
    username TEXT NOT NULL,
    email TEXT NOT NULL UNIQUE,
    password TEXT NOT NULL,
    favorites TEXT,
    date TEXT NOT NULL,
    deleted INTEGER NOT NULL
);

DROP TABLE IF EXISTS request;

CREATE TABLE IF NOT EXISTS request (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    user_email TEXT NOT NULL,
    command TEXT NOT NULL,
    status TEXT NOT NULL,
    method TEXT NOT NULL,
    date TEXT NOT NULL,
    hidden INTEGER NOT NULL,
    FOREIGN KEY (user_email) REFERENCES "user"(email)
);

INSERT INTO "user" (username, email, password, favorites, date, deleted)
VALUES (
    'anon',
    'anon',
    'anon',
    NULL,
    strftime('%s', 'now'),
    0
);