DiscordAIChatBot/init.sql at main · ZeldaFan0225/DiscordAIChatBot · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
CREATE TABLE IF NOT EXISTS hey_messages (
    index SERIAL,
    message_id VARCHAR(50) PRIMARY KEY,
    trigger_name VARCHAR(1000) NOT NULL,
    user_content text NOT NULL,
    assistant_content text NOT NULL,
    user_id VARCHAR(50),
    timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    parent_message_id VARCHAR(50) REFERENCES hey_messages(message_id)
);

CREATE TABLE IF NOT EXISTS chat_messages (
    index SERIAL,
    message_id VARCHAR(50) PRIMARY KEY,
    model_name VARCHAR(1000) NOT NULL,
    system_instruction_name VARCHAR(1000),
    user_content text NOT NULL,
    assistant_content text NOT NULL,
    user_id VARCHAR(50),
    timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    parent_message_id VARCHAR(50) REFERENCES chat_messages(message_id)
);