-
Notifications
You must be signed in to change notification settings - Fork 0
/
data.sql
54 lines (49 loc) · 1.6 KB
/
data.sql
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
44
45
46
47
48
49
50
51
52
53
54
CREATE TABLE users (
username text PRIMARY KEY,
password text NOT NULL,
first_name text NOT NULL,
last_name text NOT NULL,
phone text NOT NULL,
join_at timestamp without time zone NOT NULL,
last_login_at timestamp with time zone
);
CREATE TABLE messages (
id SERIAL PRIMARY KEY,
from_username text NOT NULL REFERENCES users,
to_username text NOT NULL REFERENCES users,
body text NOT NULL,
sent_at timestamp with time zone NOT NULL,
read_at timestamp with time zone
);
INSERT INTO messages( from_username, to_username, body, sent_at, read_at)
VALUES ("Fayceloo",
"mgreene",
"hello how are you?",
current_timestamp,
current_timestamp
)
INSERT INTO messages( from_username, to_username, body, sent_at, read_at)
VALUES ("mgreene",
"Fayceloo",
"I am fine, thank you.",
current_timestamp,
current_timestamp
)
INSERT INTO users(username, password, first_name, last_name,phone, join_at, last_login_at)
VALUES ('mgreene',
'$2b$12$pC1el05dLIBw/FN3F18nte62uG7sAzROHMCGsoSe9AzIj5kinOxwG',
'Mara',
'greene',
'18008000',
current_timestamp,
current_timestamp
)
INSERT INTO users(username, password, first_name, last_name,phone, join_at, last_login_at)
VALUES ('Fayceloo',
'$2b$12$pC1el05dLIBw/FN3F18nte62uG7sAzROHMCGsoSe9AzIj5kinOxwG',
'Faycel',
'Touili',
'23421353453',
current_timestamp,
current_timestamp
)