-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdata.sql
More file actions
53 lines (48 loc) · 3.57 KB
/
data.sql
File metadata and controls
53 lines (48 loc) · 3.57 KB
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
INSERT INTO company (id, name)
VALUES (1, 'Google'),
(2, 'Meta'),
(3, 'Amazon');
SELECT SETVAL('company_id_seq', (SELECT MAX(id) FROM company));
INSERT INTO company_locales (company_id, lang, description)
VALUES ((SELECT id FROM company WHERE name = 'Google'), 'en', 'Google description'),
((SELECT id FROM company WHERE name = 'Google'), 'ru', 'Google описание'),
((SELECT id FROM company WHERE name = 'Meta'), 'en', 'Meta description'),
((SELECT id FROM company WHERE name = 'Meta'), 'ru', 'Meta описание'),
((SELECT id FROM company WHERE name = 'Amazon'), 'en', 'Amazon description'),
((SELECT id FROM company WHERE name = 'Amazon'), 'ru', 'Amazon описание');
INSERT INTO users (id, birth_date, firstname, lastname, role, username, company_id)
VALUES (1, '1990-01-10', 'Ivan', 'Ivanov', 'ADMIN', 'ivan@gmail.com', (SELECT id FROM company WHERE name = 'Google')),
(2, '1995-10-19', 'Petr', 'Petrov', 'USER', 'petr@gmail.com', (SELECT id FROM company WHERE name = 'Google')),
(3, '2001-12-23', 'Sveta', 'Svetikova', 'USER', 'sveta@gmail.com', (SELECT id FROM company WHERE name = 'Meta')),
(4, '1984-03-14', 'Vlad', 'Vladikov', 'USER', 'vlad@gmail.com', (SELECT id FROM company WHERE name = 'Amazon')),
(5, '1984-03-14', 'Kate', 'Smith', 'ADMIN', 'kate@gmail.com', (SELECT id FROM company WHERE name = 'Amazon'));
SELECT SETVAL('users_id_seq', (SELECT MAX(id) FROM users));
INSERT INTO payment (amount, receiver_id)
VALUES (100, (SELECT id FROM users WHERE username = 'ivan@gmail.com')),
(300, (SELECT id FROM users WHERE username = 'ivan@gmail.com')),
(500, (SELECT id FROM users WHERE username = 'ivan@gmail.com')),
(250, (SELECT id FROM users WHERE username = 'petr@gmail.com')),
(600, (SELECT id FROM users WHERE username = 'petr@gmail.com')),
(500, (SELECT id FROM users WHERE username = 'petr@gmail.com')),
(400, (SELECT id FROM users WHERE username = 'sveta@gmail.com')),
(300, (SELECT id FROM users WHERE username = 'sveta@gmail.com')),
(500, (SELECT id FROM users WHERE username = 'vlad@gmail.com')),
(700, (SELECT id FROM users WHERE username = 'vlad@gmail.com')),
(340, (SELECT id FROM users WHERE username = 'vlad@gmail.com')),
(440, (SELECT id FROM users WHERE username = 'kate@gmail.com')),
(510, (SELECT id FROM users WHERE username = 'kate@gmail.com')),
(630, (SELECT id FROM users WHERE username = 'kate@gmail.com'));
INSERT INTO chat (name)
VALUES ('dmdev'),
('java'),
('database');
INSERT INTO users_chat(user_id, chat_id)
VALUES ((SELECT id FROM users WHERE username = 'ivan@gmail.com'), (SELECT id FROM chat WHERE name = 'dmdev')),
((SELECT id FROM users WHERE username = 'petr@gmail.com'), (SELECT id FROM chat WHERE name = 'dmdev')),
((SELECT id FROM users WHERE username = 'sveta@gmail.com'), (SELECT id FROM chat WHERE name = 'dmdev')),
((SELECT id FROM users WHERE username = 'petr@gmail.com'), (SELECT id FROM chat WHERE name = 'java')),
((SELECT id FROM users WHERE username = 'sveta@gmail.com'), (SELECT id FROM chat WHERE name = 'java')),
((SELECT id FROM users WHERE username = 'vlad@gmail.com'), (SELECT id FROM chat WHERE name = 'java')),
((SELECT id FROM users WHERE username = 'kate@gmail.com'), (SELECT id FROM chat WHERE name = 'java')),
((SELECT id FROM users WHERE username = 'petr@gmail.com'), (SELECT id FROM chat WHERE name = 'database')),
((SELECT id FROM users WHERE username = 'kate@gmail.com'), (SELECT id FROM chat WHERE name = 'database'));