RelayServer/init.sql at main · Superposition-Development/RelayServer · 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
CREATE TABLE IF NOT EXISTS user (
        id INTEGER PRIMARY KEY,
        pfp TEXT,
        username TEXT,
        userID TEXT UNIQUE,
        password TEXT,
        timestamp INTEGER
    );

CREATE TABLE IF NOT EXISTS message (
        id INTEGER PRIMARY KEY,
        senderID TEXT,
        channelID INTEGER,
        timestamp INTEGER,
        content TEXT,
        FOREIGN KEY (senderID) REFERENCES user(userID),
        FOREIGN KEY (channelID) REFERENCES channel(id)
        );

CREATE TABLE IF NOT EXISTS channel (
        id INTEGER PRIMARY KEY,
        name TEXT,
        serverID INTEGER,
        FOREIGN KEY (serverID) REFERENCES server(id)
    );

CREATE TABLE IF NOT EXISTS server (
        id INTEGER PRIMARY KEY,
        pfp TEXT,
        name TEXT,
        password TEXT,
        timestamp INTEGER
    );

CREATE TABLE IF NOT EXISTS serverUser (
    id INTEGER PRIMARY KEY,
    serverID INTEGER,
    userID TEXT,
    timestamp INTEGER,
    FOREIGN KEY (serverID) REFERENCES server(id),
    FOREIGN KEY (userID) REFERENCES user(userID)
    );