seed-data.sql

-- The Entourage — Pre-loaded Seed Data for Demo Mode
-- Run this in Supabase SQL Editor AFTER the schema migration

-- ==========================================
-- Taylor Swift
-- ==========================================
INSERT INTO celebrities (id, name, wikipedia_summary, image_url, category, is_preloaded) VALUES
  ('a1000000-0000-0000-0000-000000000001',
   'Taylor Swift',
   'Taylor Alison Swift is an American singer-songwriter. Recognized for her songwriting, musical versatility, artistic reinventions, and influence on the music industry, she is a prominent cultural figure of the 21st century. She has sold over 200 million records worldwide, making her one of the best-selling music artists in history.',
   'https://upload.wikimedia.org/wikipedia/commons/thumb/d/d7/Taylor_Swift_at_the_2023_MTV_Video_Music_Awards_%283%29.png/220px-Taylor_Swift_at_the_2023_MTV_Video_Music_Awards_%283%29.png',
   'music',
   true);

INSERT INTO contacts (celebrity_id, name, role, platform, handle_or_email, source_url, reachability_score, reachability_reasoning) VALUES
  ('a1000000-0000-0000-0000-000000000001', 'Tree Paine', 'Publicist', 'twitter', '@treepaine', 'https://www.billboard.com', 6, 'Active on Twitter and known in the industry, but handles one of the biggest artists in the world.'),
  ('a1000000-0000-0000-0000-000000000001', 'Andrea Swift', 'Manager', 'email', null, 'https://en.wikipedia.org', 2, 'Taylor''s mother who helps manage her career; extremely private and not publicly reachable.'),
  ('a1000000-0000-0000-0000-000000000001', 'Robert Allen', 'Agent', 'email', null, 'https://www.caa.com', 3, 'Senior agent at CAA, one of the largest talent agencies; contact goes through official channels.'),
  ('a1000000-0000-0000-0000-000000000001', 'Jack Antonoff', 'Collaborator', 'instagram', '@jackantonoff', 'https://www.rollingstone.com', 7, 'Prolific producer and artist with active social media presence; engages publicly with fans and collaborators.'),
  ('a1000000-0000-0000-0000-000000000001', 'Republic Records', 'Label', 'email', 'info@republicrecords.com', 'https://www.republicrecords.com', 4, 'Major label under Universal Music Group; all contact goes through official department channels.');

-- ==========================================
-- Drake
-- ==========================================
INSERT INTO celebrities (id, name, wikipedia_summary, image_url, category, is_preloaded) VALUES
  ('a2000000-0000-0000-0000-000000000002',
   'Drake',
   'Aubrey Drake Graham is a Canadian rapper, singer, and songwriter. An influential figure in contemporary popular music, Drake has been credited for popularizing singing and R&B sensibilities in hip hop. He has sold over 170 million records, making him one of the best-selling music artists.',
   'https://upload.wikimedia.org/wikipedia/commons/thumb/2/28/Drake_July_2016.jpg/220px-Drake_July_2016.jpg',
   'music',
   true);

INSERT INTO contacts (celebrity_id, name, role, platform, handle_or_email, source_url, reachability_score, reachability_reasoning) VALUES
  ('a2000000-0000-0000-0000-000000000002', 'Adel Nur', 'Manager', 'instagram', '@adabornnur', 'https://www.complex.com', 5, 'Drake''s long-time manager who is somewhat public but maintains a low profile on social media.'),
  ('a2000000-0000-0000-0000-000000000002', 'Noah "40" Shebib', 'Collaborator', 'instagram', '@ovo40', 'https://www.rollingstone.com', 7, 'Frequent producer and co-founder of OVO Sound; relatively active on social media for a producer.'),
  ('a2000000-0000-0000-0000-000000000002', 'Oliver El-Khatib', 'Collaborator', 'instagram', '@oliverelkhatib', 'https://www.thefader.com', 7, 'Co-founder of OVO and Drake''s long-time creative director; active on Instagram.'),
  ('a2000000-0000-0000-0000-000000000002', 'Future the Prince', 'Assistant', 'twitter', '@futuretheprince', 'https://www.complex.com', 8, 'Drake''s DJ and right-hand man; very active on social media and engages with fans.'),
  ('a2000000-0000-0000-0000-000000000002', 'Nadia Navejas', 'Publicist', 'email', null, 'https://variety.com', 4, 'Handles Drake''s press relations through a major PR firm; contact goes through official channels.');

-- ==========================================
-- Elon Musk
-- ==========================================
INSERT INTO celebrities (id, name, wikipedia_summary, image_url, category, is_preloaded) VALUES
  ('a3000000-0000-0000-0000-000000000003',
   'Elon Musk',
   'Elon Reeve Musk is a businessman known for his key roles in the space company SpaceX and the automotive company Tesla, Inc. He is also the owner of X Corp, the company that operates the social media platform X (formerly Twitter). He is one of the wealthiest people in the world.',
   'https://upload.wikimedia.org/wikipedia/commons/thumb/3/34/Elon_Musk_Royal_Society_%28crop2%29.jpg/220px-Elon_Musk_Royal_Society_%28crop2%29.jpg',
   'media',
   true);

INSERT INTO contacts (celebrity_id, name, role, platform, handle_or_email, source_url, reachability_score, reachability_reasoning) VALUES
  ('a3000000-0000-0000-0000-000000000003', 'Jared Birchall', 'Manager', 'linkedin', null, 'https://www.wsj.com', 2, 'Manages Musk''s personal finances and family office; extremely private with no social media presence.'),
  ('a3000000-0000-0000-0000-000000000003', 'Alex Spiro', 'Agent', 'email', null, 'https://www.nytimes.com', 3, 'High-profile attorney who represents Musk; reachable only through his law firm Quinn Emanuel.'),
  ('a3000000-0000-0000-0000-000000000003', 'Gwynne Shotwell', 'Collaborator', 'twitter', '@gwaborny', 'https://www.spacex.com', 5, 'President of SpaceX who occasionally appears publicly but heavily gated through SpaceX communications.'),
  ('a3000000-0000-0000-0000-000000000003', 'Franz von Holzhausen', 'Collaborator', 'instagram', '@franzvonholzhausen', 'https://www.tesla.com', 6, 'Tesla Chief Designer with a modest social media presence; engages with design community.'),
  ('a3000000-0000-0000-0000-000000000003', 'James Musk', 'Assistant', 'twitter', null, 'https://www.businessinsider.com', 4, 'Elon''s cousin who works closely on various ventures; limited public presence.');

-- ==========================================
-- LeBron James
-- ==========================================
INSERT INTO celebrities (id, name, wikipedia_summary, image_url, category, is_preloaded) VALUES
  ('a4000000-0000-0000-0000-000000000004',
   'LeBron James',
   'LeBron Raymone James Sr. is an American professional basketball player for the Los Angeles Lakers of the National Basketball Association. Nicknamed "King James", he is widely regarded as one of the greatest basketball players in history and is often compared to Michael Jordan in debates over the greatest basketball player of all time.',
   'https://upload.wikimedia.org/wikipedia/commons/thumb/7/7a/LeBron_James_%2851959977424%29_%28cropped2%29.jpg/220px-LeBron_James_%2851959977424%29_%28cropped2%29.jpg',
   'sport',
   true);

INSERT INTO contacts (celebrity_id, name, role, platform, handle_or_email, source_url, reachability_score, reachability_reasoning) VALUES
  ('a4000000-0000-0000-0000-000000000004', 'Rich Paul', 'Agent', 'instagram', '@richpaul', 'https://www.klutchsports.com', 6, 'Founder of Klutch Sports Group and one of the most powerful agents in sports; active on social media.'),
  ('a4000000-0000-0000-0000-000000000004', 'Maverick Carter', 'Manager', 'instagram', '@maverickcarter', 'https://www.springhillent.com', 5, 'CEO of SpringHill Company and LeBron''s business partner since childhood; moderate social media presence.'),
  ('a4000000-0000-0000-0000-000000000004', 'Randy Mims', 'Assistant', 'instagram', null, 'https://www.espn.com', 7, 'LeBron''s long-time friend and personal aide; part of the inner circle and relatively accessible.'),
  ('a4000000-0000-0000-0000-000000000004', 'Adam Mendelsohn', 'Publicist', 'twitter', '@adammendelsohn', 'https://www.si.com', 6, 'LeBron''s longtime strategic advisor and communications lead; has a public profile.'),
  ('a4000000-0000-0000-0000-000000000004', 'Jamal Crawford', 'Collaborator', 'twitter', '@JCrossover', 'https://www.nba.com', 8, 'NBA veteran and close friend of LeBron; very active on Twitter and engages with basketball community.');

-- ==========================================
-- Cristiano Ronaldo
-- ==========================================
INSERT INTO celebrities (id, name, wikipedia_summary, image_url, category, is_preloaded) VALUES
  ('a5000000-0000-0000-0000-000000000005',
   'Cristiano Ronaldo',
   'Cristiano Ronaldo dos Santos Aveiro is a Portuguese professional footballer who plays as a forward for Al Nassr and the Portugal national team. Widely regarded as one of the greatest players of all time, Ronaldo has won numerous individual awards and holds the records for most appearances, goals, and assists in the history of international football.',
   'https://upload.wikimedia.org/wikipedia/commons/thumb/d/d7/Cristiano_Ronaldo_playing_for_Al_Nassr_FC_against_Persepolis%2C_September_2023_%28cropped%29.jpg/220px-Cristiano_Ronaldo_playing_for_Al_Nassr_FC_against_Persepolis%2C_September_2023_%28cropped%29.jpg',
   'sport',
   true);

INSERT INTO contacts (celebrity_id, name, role, platform, handle_or_email, source_url, reachability_score, reachability_reasoning) VALUES
  ('a5000000-0000-0000-0000-000000000005', 'Jorge Mendes', 'Agent', 'instagram', '@jaborgehmendes', 'https://www.gestifute.com', 3, 'One of the most powerful football agents in the world through Gestifute; extremely high-profile and gated.'),
  ('a5000000-0000-0000-0000-000000000005', 'Ricardo Regufe', 'Manager', 'instagram', '@ricardoregufe', 'https://www.marca.com', 6, 'Ronaldo''s long-time friend and personal brand manager at Nike; active on Instagram.'),
  ('a5000000-0000-0000-0000-000000000005', 'Georgina Rodriguez', 'Collaborator', 'instagram', '@georginagio', 'https://www.hellomagazine.com', 5, 'Ronaldo''s partner and public figure with massive social following; reachable through her own management.'),
  ('a5000000-0000-0000-0000-000000000005', 'Miguel Paixao', 'Publicist', 'instagram', '@miguelpaixao', 'https://www.reuters.com', 6, 'Handles Ronaldo''s media relations; has his own social media presence and is relatively accessible for a publicist.'),
  ('a5000000-0000-0000-0000-000000000005', 'Jose Semedo', 'Collaborator', 'instagram', '@josesemedo', 'https://www.goal.com', 8, 'Former footballer and close childhood friend of Ronaldo; active on social media and responsive.');