RelationalDesign: dml.sql

-- Insert into User Table
INSERT INTO app_user (username , email, password, contact_details) VALUES
('user1', 'user1@example.com', 'password123', '123-456-7890'),
('user2', 'user2@example.com', 'securepassword', '987-654-3210'),
('user3', 'user3@example.com', 'mypassword', '111-222-3333'),
('user4', 'user4@example.com', 'pass1234', '444-555-6666'),
('user5', 'user5@example.com', 'password567', '777-888-9999');

-- Insert into Social Media Profile Table
INSERT INTO SocialMediaProfile (platform, user_name, account_type, followers_count, userid) VALUES
('Twitter', 'user1_twitter', 'public', 1500, 1),
('Instagram', 'user2_insta', 'private', 2000, 2),
('Facebook', 'user3_fb', 'public', 1800, 3),
('LinkedIn', 'user4_linkedin', 'private', 2500, 4),
('Snapchat', 'user5_snap', 'public', 1300, 5);

-- Insert into Post Table
INSERT INTO Post (content, post_date , url , likes_count, comments_count, profileid) VALUES
('Check out my new blog post!', '2023-01-14 10:00:00', 'http://example.com/post1', 100, 5, 1),
('Loved this view!', '2023-01-14 15:30:00', 'http://example.com/post2', 250, 20, 2),
('Excited for the weekend!', '2023-01-15 09:00:00', 'http://example.com/post3', 300, 15, 3),
('New product launch!', '2023-01-16 12:00:00', 'http://example.com/post4', 400, 25, 4),
('Throwback to last summer', '2023-01-17 18:00:00', 'http://example.com/post5', 150, 10, 5);

-- Insert into Service Provider Table
INSERT INTO ServiceProvider (name, availability_status, pricing, services_offered, contact_email) VALUES
('SocialBoost', true, 199.99, 'Social Media Promotion', 'contact@socialboost.com'),
('InstaGrowth', false, 149.99, 'Instagram Growth Services', 'support@instagrowth.com'),
('FaceGrow', true, 129.99, 'Facebook Engagement Services', 'help@facegrow.com'),
('LinkPromo', true, 159.99, 'LinkedIn Networking Services', 'info@linkpromo.com'),
('SnapBoost', false, 109.99, 'Snapchat Audience Expansion', 'sales@snapboost.com');

-- Insert into Profile Marketing Request Table
INSERT INTO ProfileMarketingRequest (target_followers , timeline , profileid , date_created, status, userid , providerid) VALUES
(3000, '2025-02-01 00:00:00', 1, '2025-01-10 12:00:00', 'pending', 1, 1),
(4000, '2025-02-15 00:00:00', 2, '2025-01-15 11:00:00', 'approved', 2, 2),
(3500, '2025-02-20 00:00:00', 3, '2025-01-18 09:30:00', 'pending', 3, 3);

-- Insert into Post Marketing Request Table
INSERT INTO PostMarketingRequest (target_likes , target_comments , timeline , postid , date_created , status , userid , providerid) VALUES
(500, 50, '2025-02-05 00:00:00', 2, '2025-01-12 14:00:00', 'approved', 2, 2),
(550, 55, '2025-02-12 00:00:00', 4, '2025-01-14 17:30:00', 'approved', 4, 4),
(700, 70, '2025-02-18 00:00:00', 5, '2025-01-15 11:15:00', 'pending', 5, 5);