Translated-Chat/schema.sql at main · benevanoff/Translated-Chat · 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
CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(255) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    native_language VARCHAR(50) NOT NULL
);

CREATE TABLE chats (
    id INT PRIMARY KEY AUTO_INCREMENT,
    sender VARCHAR(255) NOT NULL,
    recipient VARCHAR(255) NOT NULL,
    original_message TEXT NOT NULL,
    translated_message TEXT NOT NULL,
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE contacts (
    id INT PRIMARY KEY AUTO_INCREMENT,
    contact_holder VARCHAR(255) NOT NULL,
    contact_username VARCHAR(255) NOT NULL
);

INSERT INTO users (username, password, native_language) VALUES ('benevanoff', 'secret', 'spanish');
INSERT INTO users (username, password, native_language) VALUES ('lily', 'secret', 'english');

INSERT INTO users (username, password, native_language) VALUES ('tigerwang', 'uiuc', 'english');
INSERT INTO users (username, password, native_language) VALUES ('isaaczhang', 'uiuc', 'english');

INSERT INTO contacts (contact_holder, contact_username) VALUES ('benevanoff', 'lily');
INSERT INTO contacts (contact_holder, contact_username) VALUES ('benevanoff', 'tigerwang');
INSERT INTO contacts (contact_holder, contact_username) VALUES ('benevanoff', 'isaaczhang');

INSERT INTO contacts (contact_holder, contact_username) VALUES ('lily', 'benevanoff');

INSERT INTO contacts (contact_holder, contact_username) VALUES ('tigerwang', 'benevanoff');
INSERT INTO contacts (contact_holder, contact_username) VALUES ('tigerwang', 'isaaczhang');
INSERT INTO contacts (contact_holder, contact_username) VALUES ('isaaczhang', 'benevanoff');
INSERT INTO contacts (contact_holder, contact_username) VALUES ('isaaczhang', 'tigerwang');