INSERTS

-- Insert Users
INSERT INTO Users (name, email, date_of_birth)
VALUES
('Alice', 'alice@example.com', '1995-06-15'),
('Bob', 'bob@example.com', '1992-04-23'),
('Charlie', 'charlie@example.com', '1990-12-01'),
('Diana', 'diana@example.com', '1985-09-12'),
('Eve', 'eve@example.com', '2000-01-05');

INSERT INTO Users (name, email, date_of_birth)
VALUES
('Frank', 'frank@example.com', '1993-03-21'),
('Grace', 'grace@example.com', '1997-07-30'),
('Hank', 'hank@example.com', '1989-11-15'),
('Ivy', 'ivy@example.com', '1998-02-10'),
('Jack', 'jack@example.com', '1994-05-25');


-- Insert Friendships
INSERT INTO Friendships (user_id, friend_id, status)
VALUES
(1, 2, 'accepted'),
(1, 3, 'accepted'),
(2, 3, 'accepted'),
(4, 5, 'pending');

INSERT INTO Friendships (user_id, friend_id, status)
VALUES
(1, 6, 'accepted'),
(2, 7, 'accepted'),
(3, 8, 'accepted'),
(4, 9, 'accepted'),
(5, 10, 'pending');


-- Insert Posts
INSERT INTO Posts (user_id, content)
VALUES
(1, 'Alice’s first post!'),
(2, 'Bob’s exciting announcement'),
(3, 'Charlie’s thoughts on life'),
(1, 'Alice’s second post.'),
(5, 'Eve is new here!');

INSERT INTO Posts (user_id, content)
VALUES
(6, 'Frank’s journey into SQL development.'),
(7, 'Grace shares her SQL project tips.'),
(8, 'Hank is learning about database optimization!'),
(9, 'Ivy: SQL is the backbone of modern apps!'),
(10, 'Jack’s first post about normalization.');


-- Insert Comments
INSERT INTO Comments (post_id, user_id, content)
VALUES
(1, 2, 'Great post, Alice!'),
(2, 3, 'Congratulations, Bob!'),
(3, 1, 'Nice one, Charlie!'),
(4, 5, 'Thanks for sharing, Alice.');

INSERT INTO Comments (post_id, user_id, content)
VALUES
(6, 7, 'This is inspiring, Frank!'),
(7, 8, 'Thanks for the tips, Grace.'),
(8, 9, 'I agree, database optimization is key!'),
(9, 10, 'Well said, Ivy.'),
(10, 6, 'Normalization is crucial, Jack!');


-- Insert Likes
INSERT INTO Likes (post_id, user_id)
VALUES
(1, 2),
(1, 3),
(2, 1),
(3, 4),
(5, 1);

INSERT INTO Likes (post_id, user_id)
VALUES
(6, 7),
(7, 8),
(8, 9),
(9, 10),
(10, 6);

INSERT INTO Likes (comment_id, user_id)
VALUES
(6, 3),
(7, 5),
(8, 6),
(9, 2),
(9, 9);