-
Notifications
You must be signed in to change notification settings - Fork 1
/
test-data.sql
193 lines (184 loc) ยท 11.8 KB
/
test-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
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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
DROP TABLE IF EXISTS Users;
DROP TABLE IF EXISTS Comments;
DROP TABLE IF EXISTS Posts;
CREATE TABLE Posts (
post_id SERIAL PRIMARY KEY,
post_author INTEGER,
post_content VARCHAR(255),
timestamp TIMESTAMP
);
CREATE TABLE Users (
user_id SERIAL PRIMARY KEY ,
name VARCHAR(20),
email VARCHAR(40)
);
CREATE TABLE Comments (
comment_id SERIAL PRIMARY KEY,
post_id INTEGER,
user_id INTEGER,
comment_text VARCHAR(120),
timestamp TIMESTAMP
);
INSERT INTO Users (name, email)
VALUES
('Alice Johnson', 'alice.johnson@example.com'),
('John Smith', 'john.smith@example.com'),
('Emily Davis', 'emily.davis@example.com'),
('Michael Wilson', 'michael.wilson@example.com'),
('Sarah Brown', 'sarah.brown@example.com'),
('David Lee', 'david.lee@example.com'),
('Jessica Miller', 'jessica.miller@example.com'),
('James Taylor', 'james.taylor@example.com'),
('Olivia Moore', 'olivia.moore@example.com'),
('Daniel Anderson', 'daniel.anderson@example.com');
INSERT INTO Posts (post_author, post_content, timestamp) VALUES
(1, 'Just had a great day! ๐', '2023-10-10 12:34:56'),
(2, 'Enjoying the sunshine today! โ๏ธ', '2023-10-09 15:45:23'),
(3, 'Work hard, play hard! ๐ช๐', '2023-10-08 09:21:37'),
(4, 'Exploring new places! ๐โค๏ธ', '2023-10-07 18:50:12'),
(5, 'Movie night with friends! ๐ฟ๐ฅ', '2023-10-06 14:27:59'),
(6, 'Coding all night! ๐ป๐', '2023-10-05 20:18:43'),
(7, 'Trying out new recipes! ๐ฝ๏ธ๐', '2023-10-04 11:56:28'),
(8, 'Ready for a weekend adventure! ๐๐๏ธ', '2023-10-03 17:39:14'),
(9, 'Chilling by the beach! ๐๏ธ๐', '2023-10-02 08:14:59'),
(10, 'Late-night gaming session! ๐ฎ๐', '2023-10-01 19:03:42'),
(1, 'Coffee and code! โ๐ป', '2023-09-30 22:44:35'),
(2, 'Hiking in the mountains! โฐ๏ธ๐ฒ', '2023-09-29 13:37:19'),
(3, 'Sushi night! ๐ฃ๐ฑ', '2023-09-28 07:20:04'),
(4, 'Family time! ๐จโ๐ฉโ๐งโ๐ฆโค๏ธ', '2023-09-27 16:11:51'),
(1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam eget leo eu tortor congue eleifend.', '2023-10-10 12:34:56'),
(2, 'Vivamus fringilla ex quis purus venenatis, nec pharetra ligula dapibus. Curabitur vel tortor nec justo ultrices.', '2023-10-09 15:45:23'),
(3, 'Suspendisse potenti. Maecenas eu justo nec elit euismod efficitur. Duis sit amet rhoncus turpis. Proin vehicula tortor in lectus tincidunt, nec fringilla justo hendrerit.', '2023-10-08 09:21:37'),
(4, 'Aenean vestibulum eleifend massa, sed varius quam euismod id. Nulla facilisi. Nam in urna semper, consectetur quam sit amet, feugiat turpis.', '2023-10-07 18:50:12'),
(5, 'Vestibulum facilisis augue ac elit blandit', '2023-10-06 14:27:59'),
(6, 'Integer volutpat eu velit ut sollicitudin. Pellentesque laoreet odio vel orci condimentum, eget bibendum dui semper.', '2023-10-05 20:18:43'),
(7, 'Fusce ultrices justo a turpis sodales, sit amet efficitur ipsum tincidunt.', '2023-10-04 11:56:28'),
(8, 'Vestibulum vel urna eget urna cursus eleifend id ac libero.', '2023-10-03 17:39:14'),
(9, 'Sed vestibulum euismod quam at varius.', '2023-10-02 08:14:59'),
(10, 'Quisque tincidunt arcu eu nulla vulputate, eget convallis odio eleifend.', '2023-10-01 19:03:42'),
(1, 'Cras malesuada massa in ipsum hendrerit, eget iaculis sapien finibus.', '2023-09-30 22:44:35'),
(2, 'Sed ac libero nec nisi pharetra vehicula. Donec convallis vehicula tortor, at sollicitudin velit. In sit amet tincidunt quam.', '2023-09-29 13:37:19'),
(3, 'Duis vestibulum leo vel dolor suscipit, non facilisis purus convallis.', '2023-09-28 07:20:04'),
(4, 'Phasellus bibendum est eget nunc tincidunt, at mattis neque tincidunt.', '2023-09-27 16:11:51'),
(5, 'Proin vel diam vitae est varius volutpat. Sed eget velit non odio rhoncus rhoncus.', '2023-09-26 10:59:37'),
(6, 'Vivamus sed orci at dui pellentesque fermentum. Integer quis tellus sit amet nisi dictum sodales.', '2023-09-25 21:45:24'),
(7, 'Fusce in orci eget turpis lacinia interdum. Sed eget ultrices orci, nec volutpat nulla.', '2023-09-24 12:32:12'),
(8, 'Nulla aliquam lacinia facilisis. Cras eu arcu a nisi efficitur condimentum ac non urna.', '2023-09-23 17:21:59'),
(9, 'Curabitur non nisl nec leo sollicitudin bibendum.', '2023-09-22 09:15:48'),
(10, 'Pellentesque vitae arcu efficitur, tincidunt velit ut, malesuada sapien.', '2023-09-21 20:09:37'),
(1, 'Maecenas in neque id nisl pellentesque tincidunt non a quam.', '2023-09-20 13:06:27'),
(2, 'Aenean vehicula urna eu libero sodales, eu fringilla est volutpat.', '2023-09-19 19:58:18'),
(3, 'Donec sollicitudin lorem eget lectus tempus, at volutpat arcu tristique.', '2023-09-18 11:55:10'),
(4, 'Mauris facilisis dolor id gravida lacinia.', '2023-09-17 16:47:03'),
(5, 'Praesent euismod urna eget vestibulum congue.', '2023-09-16 08:41:57'),
(6, 'Ut at tortor eget lorem consectetur lobortis eu in elit.', '2023-09-15 20:36:51'),
(7, 'Proin in libero sed ex condimentum facilisis nec vel felis.', '2023-09-14 12:32:46'),
(8, 'Aliquam erat volutpat. Sed sed velit pretium, sodales ligula ut, vehicula neque.', '2023-09-13 18:27:41'),
(9, 'Duis ullamcorper libero non libero tempus, vel bibendum metus fringilla.', '2023-09-12 10:23:36'),
(10, 'Sed non lectus eu dolor posuere cursus ac id orci.', '2023-09-11 21:19:31'),
(1, 'Quisque viverra velit ac hendrerit hendrerit.', '2023-09-10 13:15:28'),
(2, 'Sed ut eros in purus tristique dapibus.', '2023-09-09 19:11:25'),
(3, 'Praesent at nisl vel nulla laoreet facilisis ut a mi.', '2023-09-08 11:07:22'),
(1, 'Exploring new horizons.', '2023-10-10 12:34:56'),
(2, 'Chasing dreams and making memories.', '2023-10-09 15:45:23'),
(3, 'Embracing the beauty of the moment.', '2023-10-08 09:21:37'),
(4, 'Finding joy in the little things.', '2023-10-07 18:50:12'),
(5, 'Adventures await around every corner.', '2023-10-06 14:27:59'),
(6, 'Inspiration is everywhere.', '2023-10-05 20:18:43'),
(7, 'Connecting hearts and minds.', '2023-10-04 11:56:28'),
(8, 'Creating moments that matter.', '2023-10-03 17:39:14'),
(9, 'Dream big, live bold.', '2023-10-02 08:14:59'),
(10, 'Seeking adventure with a smile.', '2023-10-01 19:03:42'),
(1, 'Capturing the essence of life.', '2023-09-30 22:44:35'),
(2, 'Evolving, learning, and growing.', '2023-09-29 13:37:19'),
(3, 'Navigating the journey of life.', '2023-09-28 07:20:04'),
(4, 'Radiating positivity and kindness.', '2023-09-27 16:11:51'),
(5, 'Celebrating the gift of existence.', '2023-09-26 10:59:37'),
(6, 'Wandering with wonder in my heart.', '2023-09-25 21:45:24'),
(7, 'Embracing the unexpected with grace.', '2023-09-24 12:32:12'),
(8, 'Dancing through life adventures.', '2023-09-23 17:21:59'),
(9, 'Savoring the flavors of existence.', '2023-09-22 09:15:48'),
(10, 'Laughing, loving, and living fully.', '2023-09-21 20:09:37'),
(1, 'Writing my own story, one page at a time.', '2023-09-20 13:06:27'),
(2, 'Discovering beauty in every sunrise.', '2023-09-19 19:58:18'),
(3, 'Collecting moments, not things.', '2023-09-18 11:55:10'),
(4, 'Singing songs of joy and gratitude.', '2023-09-17 16:47:03'),
(5, 'Cherishing friendships that light the way.', '2023-09-16 08:41:57'),
(6, 'Embracing the art of being present.', '2023-09-15 20:36:51'),
(7, 'Creating ripples of kindness and love.', '2023-09-14 12:32:46'),
(8, 'Sailing on the sea of endless possibilities.', '2023-09-13 18:27:41'),
(9, 'Radiating positive vibes into the universe.', '2023-09-12 10:23:36'),
(10, 'Writing my own story, one chapter at a time.', '2023-09-11 21:19:31'),
(1, 'Embracing change with open arms and an open heart.', '2023-09-10 13:15:28'),
(2, 'Creating memories that will last a lifetime.', '2023-09-09 19:11:25'),
(3, 'Basking in the glow of precious moments.', '2023-09-08 11:07:22'),
(4, 'Navigating the twists and turns of destiny with a smile.', '2023-09-07 17:03:19'),
(5, 'Embracing the journey, not just the destination.', '2023-09-06 08:59:17'),
(6, 'Finding magic in the ordinary.', '2023-09-05 19:55:16'),
(7, 'Exploring the world, one step at a time.', '2023-09-04 11:51:14'),
(8, 'Dancing to the rhythm of my own heart.', '2023-09-03 17:47:13'),
(9, 'Chasing dreams with unwavering determination.', '2023-09-02 09:43:12'),
(10, 'Radiating love and positivity to all.', '2023-09-01 20:39:11'),
(1, 'Discovering the beauty in the everyday.', '2023-08-31 12:35:11'),
(2, 'Letting go of the past and embracing the present.', '2023-08-30 18:31:11'),
(3, 'Savoring the sweetness of life.', '2023-08-29 10:27:12'),
(4, 'Writing the story of my own destiny.', '2023-08-28 16:23:12'),
(5, 'Embracing the symphony of life with open arms.', '2023-08-27 08:19:13'),
(6, 'Exploring the unknown with boundless curiosity.', '2023-08-26 19:15:13'),
(7, 'Creating a world filled with love and laughter.', '2023-08-25 11:11:14'),
(8, 'Sailing towards a horizon filled with endless possibilities.', '2023-08-24 17:07:14'),
(9, 'Dancing through challenges with grace and resilience.', '2023-08-23 09:03:15'),
(7, 'Excited for the weekend! ๐๐ฅ', '2023-08-15 11:51:14'),
(8, 'Sunday brunch! ๐ฅโ', '2023-08-14 17:47:13'),
(9, 'Reading a good book! ๐๐', '2023-08-13 09:43:12'),
(10, 'Music and relaxation! ๐ถ๐งโโ๏ธ', '2023-08-12 20:39:11');
INSERT INTO Comments (post_id, user_id, comment_text, timestamp) VALUES
(10, 2, 'Great post bitch! :ghost:', '2023-10-10 12:34:56'),
(27, 5, 'I love this ash0le!', '2023-10-09 15:45:23'),
(42, 1, 'Amazing content!', '2023-10-08 09:21:37'),
(75, 9, 'You inspire me!', '2023-10-07 18:50:12'),
(5, 4, 'Well done!', '2023-10-06 14:27:59'),
(88, 6, 'Keep it up!', '2023-10-05 20:18:43'),
(14, 8, 'This is awesome!', '2023-10-04 11:56:28'),
(61, 7, 'I could not agree more!', '2023-10-03 17:39:14'),
(133, 3, 'Fantastic post! :tada:', '2023-10-02 08:14:59'),
(50, 10, 'You rock!', '2023-10-01 19:03:42'),
(12, 5, 'Interesting thoughts!', '2023-09-30 22:44:35'),
(78, 2, 'I learned a lot!', '2023-09-29 13:37:19'),
(128, 1, 'Thanks for sharing!', '2023-09-28 07:20:04'),
(57, 9, 'This made my day!', '2023-09-27 16:11:51'),
(36, 7, 'Great perspective!', '2023-09-26 10:59:37'),
(46, 4, 'I appreciate your insights!', '2023-09-25 21:45:24'),
(92, 8, 'You have a unique voice!', '2023-09-24 12:32:12'),
(17, 6, 'I love your style!', '2023-09-23 17:21:59'),
(82, 10, 'Keep it coming! :)', '2023-09-22 09:15:48'),
(19, 3, 'I could not agree more!', '2023-09-21 20:09:37'),
(71, 1, 'Well said!', '2023-09-20 13:06:27'),
(8, 4, 'You are awesome!', '2023-09-19 19:58:18'),
(38, 5, 'I enjoy your posts!', '2023-09-18 11:55:10'),
(85, 7, 'I am a fan!', '2023-09-17 16:47:03'),
(64, 6, 'Thanks for sharing your thoughts!', '2023-09-16 08:41:57'),
(15, 2, 'Keep up the good work!', '2023-09-15 20:36:51'),
(177, 8, 'Your positivity is contagious!', '2023-09-14 12:32:46'),
(48, 9, 'You inspire me!', '2023-09-13 18:27:41'),
(11, 10, 'Well done!', '2023-09-12 10:23:36'),
(96, 3, 'I could not agree more!', '2023-09-11 21:19:31'),
(18, 1, 'Thanks for sharing your insights!', '2023-09-10 13:15:28'),
(43, 2, 'I learned something new!', '2023-09-09 19:11:25'),
(25, 5, 'You have a unique perspective!', '2023-09-08 11:07:22'),
(54, 4, 'This is so insightful!', '2023-09-07 17:03:19'),
(37, 7, 'Well articulated!', '2023-09-06 08:59:17'),
(68, 3, 'I appreciate your perspective!', '2023-09-05 19:55:16'),
(114, 8, 'Your posts always make me think!', '2023-09-04 11:51:14'),
(83, 5, 'I am inspired by your positivity!', '2023-09-03 17:47:13'),
(66, 6, 'Keep sharing your thoughts!', '2023-09-02 09:43:12'),
(3, 2, 'I could not agree more!', '2023-09-01 20:39:11'),
(59, 1, 'Thanks for the inspiration!', '2023-08-31 12:35:11'),
(72, 9, 'You have a great way with words!', '2023-08-30 18:31:11'),
(31, 7, 'This resonates with me!', '2023-08-29 10:27:12'),
(94, 4, 'Your perspective is refreshing!', '2023-08-28 16:23:12'),
(22, 10, 'Well said!', '2023-08-27 08:19:13'),
(180, 8, 'You are making a difference!', '2023-08-26 19:15:13'),
(53, 6, 'Your posts brighten my day!', '2023-08-25 11:11:14'),
(100, 2, 'Keep up the great work!', '2023-08-24 17:07:14'),
(73, 9, 'Your insights are valuable!', '2023-08-23 09:03:15');