-
Notifications
You must be signed in to change notification settings - Fork 1
/
datiDatabase.txt
91 lines (69 loc) · 2.88 KB
/
datiDatabase.txt
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
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
INSERT INTO Users (Username, Password, Email, Bio) VALUES
('user1', 'password1', '[email protected]', 'Hello, I am user 1.'),
('user2', 'password2', '[email protected]', 'Nice to meet you! I am user 2.'),
('user3', 'password3', '[email protected]', 'Hello from user 3.'),
('user4', 'password4', '[email protected]', 'Greetings! User 4 here.'),
('user5', 'password5', '[email protected]', 'Hello from user 5.');
INSERT INTO Categories (CategoryName) VALUES
('Travel'),
('Nature'),
('Lifestyle'),
('Art'),
('Sculpture'),
('DigitalArt'),
('Tattoo'),
('Painting),
('Photograpy);
INSERT INTO Posts (UserID, MediaURL, Caption, CategoryID) VALUES
(1, 'post1.jpg', 'This is my first post!', 1),
(2, 'post2.png', 'Check out this amazing view.', 2),
(3, 'post3.jpg', 'Feeling happy today!', 3),
(4, 'post4.png', 'Just posted something cool.', 4);
INSERT INTO Followers (FollowerUserID, FollowingUserID) VALUES
(1, 2),
(2, 3),
(3, 1),
(4, 1);
INSERT INTO Comments (PostID, UserID, CommentText) VALUES
(1, 2, 'Great first post!'),
(2, 3, 'Amazing view!'),
(3, 1, 'Happy vibes!'),
(4, 2, 'Cool stuff!');
INSERT INTO ChatMessages (SenderID, ReceiverID, MessageText) VALUES
(1, 2, 'Hey, how are you?'),
(2, 3, 'I saw your latest post, it\'s awesome!'),
(3, 1, 'Thanks! Glad you liked it.'),
(4, 1, 'Hello there!');
INSERT INTO Notifications (fromUserID, toUserID, NotificationText, PostID) VALUES
(2, 1, 'You have a new follower.', NULL),
(3, 1, 'Your post got a new comment.', 1),
(4, 1, 'You have a new message.', NULL),
(5, 1, 'Someone liked your post.', 2),
(2, 1, 'Your post got a new comment.', 1),
(2, 1, 'Someone liked your post.', 1),
(3, 1, 'You have a new follower.', NULL),
(4, 1, 'Someone liked your post.', 1),
(4, 1, 'You have a new message.', NULL),
(5, 1, 'Someone liked your post.', 1),
(1, 2, 'Your post got a new comment.', 2),
(3, 2, 'Someone liked your post.', 2),
(5, 2, 'Your post got a new comment.', 2),
(3, 2, 'Someone liked your post.', 2),
(3, 2, 'Your post got a new comment.', 2);
INSERT INTO UserInfos (UserID, LogoURL, FullName) VALUES (1, 'post.jpg', 'User1');
INSERT INTO UserInfos (UserID, LogoURL, FullName) VALUES (2, 'post.jpg', 'User2');
INSERT INTO UserInfos (UserID, LogoURL, FullName) VALUES (3, 'post.jpg', 'User3');
INSERT INTO UserInfos (UserID, LogoURL, FullName) VALUES (4, 'post.jpg', 'User4');
INSERT INTO Likes (PostID, UserID) VALUES (1, 2);
INSERT INTO Likes (PostID, UserID) VALUES (1, 3);
INSERT INTO Likes (PostID, UserID) VALUES (2, 1);
INSERT INTO Likes (PostID, UserID) VALUES (3, 2);
INSERT INTO Likes (PostID, UserID) VALUES (3, 3);
INSERT INTO Tagged (PostID, UserID) VALUES
(1, 2),
(3, 1),
(2, 3);
INSERT INTO Saved (PostID, UserID) VALUES
(2, 1),
(3, 3),
(1, 2);