-- =============================================
-- Test Data: Fake Female Users (Blonde Gym Girls)
-- =============================================
-- Run this AFTER schema.sql
-- Make sure NOT to run if users already exist (will create duplicates)
-- =============================================

-- Insert fake users with photos (without profile details first)
INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Emma', 'emma1@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '1998-05-15', 'Fitness enthusiast 💪 Love weights & protein shakes 🥤', 'https://images.unsplash.com/photo-1518611012118-696072aa579a?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Sophia', 'sophia2@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '1999-03-22', 'Gym rat 🏋️‍♀️ #gains #fitness', 'https://images.unsplash.com/photo-1571019613454-1cb2f99b2d8b?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Olivia', 'olivia3@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '2000-01-10', 'Blonde & beautiful 💛 Working on my abs!', 'https://images.unsplash.com/photo-1594381898411-846e7d193883?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Ava', 'ava4@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '1997-08-30', 'Leg day every day 🦵💪', 'https://images.unsplash.com/photo-1548690312-e3b507d8c110?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Isabella', 'isabella5@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '1996-12-05', 'Fitness model in training 📸', 'https://images.unsplash.com/photo-1609899517237-7a4d0d5c8299?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Mia', 'mia6@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '2001-04-18', 'Gym is my happy place 🏋️‍♀️', 'https://images.unsplash.com/photo-1518310383802-640c2de311b2?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Charlotte', 'charlotte7@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '1995-09-25', 'No pain no gain 💪 blonde & strong', 'https://images.unsplash.com/photo-1583454110551-21f2fa2afe61?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Amelia', 'amelia8@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '1998-07-12', 'CrossFit addict 🔥', 'https://images.unsplash.com/photo-1581009137042-c552e485697a?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Harper', 'harper9@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '2000-02-28', 'Blonde gym girl looking for a gym buddy 💪', 'https://images.unsplash.com/photo-1597347343908-2937e7dcc560?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Evelyn', 'evelyn10@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '1999-11-03', 'Fitness first always 💯', 'https://images.unsplash.com/photo-1550345332-09e3ac987658?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Abigail', 'abigail11@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '1997-06-14', 'Gym life is the best life 🏋️‍♀️', 'https://images.unsplash.com/photo-1552196563-55cd4e45efb3?w=400', 1, NOW(), NOW());

INSERT INTO users (name, email, password, gender, birth_date, bio, profile_image, is_active, created_at, updated_at) VALUES
('Ella', 'ella12@test.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'female', '2001-08-20', 'Blonde & lifting 💛', 'https://images.unsplash.com/photo-1574680096145-d05b474e2155?w=400', 1, NOW(), NOW());

-- Now insert profile details using the actual user IDs (get them by email)
INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'athletic', 'blonde', 'blue', 'Fitness Instructor', 'bachelors', 170 FROM users WHERE email = 'emma1@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'athletic', 'blonde', 'green', 'Personal Trainer', 'bachelors', 168 FROM users WHERE email = 'sophia2@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'slim', 'blonde', 'blue', 'Model', 'some_college', 175 FROM users WHERE email = 'olivia3@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'muscular', 'blonde', 'brown', 'Gym Owner', 'masters', 165 FROM users WHERE email = 'ava4@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'athletic', 'blonde', 'hazel', 'Nurse', 'bachelors', 172 FROM users WHERE email = 'isabella5@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'athletic', 'blonde', 'blue', 'Student', 'some_college', 169 FROM users WHERE email = 'mia6@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'curvy', 'blonde', 'green', 'Influencer', 'high_school', 167 FROM users WHERE email = 'charlotte7@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'athletic', 'blonde', 'blue', 'CrossFit Coach', 'bachelors', 171 FROM users WHERE email = 'amelia8@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'muscular', 'blonde', 'hazel', 'Fitness Model', 'some_college', 173 FROM users WHERE email = 'harper9@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'athletic', 'blonde', 'blue', 'Physical Therapist', 'phd', 168 FROM users WHERE email = 'evelyn10@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'slim', 'blonde', 'brown', 'Dancer', 'some_college', 166 FROM users WHERE email = 'abigail11@test.com';

INSERT INTO user_profile_details (user_id, body_type, hair_color, eye_color, occupation, education, height)
SELECT id, 'athletic', 'blonde', 'green', 'Bartender', 'high_school', 170 FROM users WHERE email = 'ella12@test.com';

-- Insert sample interests for fake users
INSERT INTO user_interests (user_id, interest_id)
SELECT u.id, 5 FROM users u WHERE u.email LIKE '%@test.com' AND u.email != 'test@test.com';

INSERT INTO user_interests (user_id, interest_id)
SELECT u.id, 10 FROM users u WHERE u.email LIKE '%@test.com' AND u.email != 'test@test.com';

-- Add photos
INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1518611012118-696072aa579a?w=400', 1, 1 FROM users WHERE email = 'emma1@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1571019613454-1cb2f99b2d8b?w=400', 1, 1 FROM users WHERE email = 'sophia2@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1594381898411-846e7d193883?w=400', 1, 1 FROM users WHERE email = 'olivia3@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1548690312-e3b507d8c110?w=400', 1, 1 FROM users WHERE email = 'ava4@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1609899517237-7a4d0d5c8299?w=400', 1, 1 FROM users WHERE email = 'isabella5@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1518310383802-640c2de311b2?w=400', 1, 1 FROM users WHERE email = 'mia6@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1583454110551-21f2fa2afe61?w=400', 1, 1 FROM users WHERE email = 'charlotte7@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1581009137042-c552e485697a?w=400', 1, 1 FROM users WHERE email = 'amelia8@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1597347343908-2937e7dcc560?w=400', 1, 1 FROM users WHERE email = 'harper9@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1550345332-09e3ac987658?w=400', 1, 1 FROM users WHERE email = 'evelyn10@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1552196563-55cd4e45efb3?w=400', 1, 1 FROM users WHERE email = 'abigail11@test.com';

INSERT INTO user_photos (user_id, photo_url, is_primary, sort_order)
SELECT id, 'https://images.unsplash.com/photo-1574680096145-d05b474e2155?w=400', 1, 1 FROM users WHERE email = 'ella12@test.com';

-- Test credentials:
-- test@test.com / password123
-- All fake users also use password123
