lab_2/populate.sql at master · TrishynaAnna/lab_2 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
insert into "User"(user_id,user_name) values (1,"Dima");
insert into "User"(user_id,user_name) values (2,"Anna");
insert into "User"(user_id,user_name) values (3,"Vlad");


insert into Group(group_id, group_name, group_topic) values (1, "5 countris", "Travel");
insert into Group(group_id, group_name, group_topic) values (2, "Nails room", "Nails");
insert into Group(group_id, group_name, group_topic) values (3, "I like to reed", "Book");


insert into Post(post_id, post_content, post_hashtag) values (1, "New_tour", "#tour");
insert into Post(post_id, post_content, post_hashtag) values (2, "New_nails", "#nails");
insert into Post(post_id, post_content, post_hashtag) values (3, "Old_book", "#book");


insert into Notification(notification_id, notification_text, notification_time) values (1, "Like", "10:50");
insert into Notification(notification_id, notification_text, notification_time) values (2, "Repost", "10:50");
insert into Notification(notification_id, notification_text, notification_time) values (3, "Comment", "10:50");