-- Add Company Intel for LFCS and RateRight

-- Delete existing if any
DELETE FROM company_intel WHERE company_name_normalized IN ('lfcs', 'rateright');

-- LFCS - Formwork & Steelfixing
INSERT INTO company_intel (
  company_name,
  company_name_normalized,
  summary,
  size,
  industry,
  location,
  website_url,
  ai_sales_angle,
  searched_at
) VALUES (
  'LFCS',
  'lfcs',
  'LFCS is a Sydney-based formwork and steel fixing contractor specialising in commercial and residential concrete construction. Known for quality formwork installation and reinforcement placement across major building projects.',
  'medium',
  'Construction - Formwork & Steelfixing',
  'Sydney, NSW, Australia',
  'https://lfcs.com.au',
  'As a formwork and steelfixing contractor, LFCS needs reliable skilled labour on demand. RateRight gives direct access to qualified formworkers and steelfixers without agency markups - post a job, get workers applying within hours.',
  NOW()
);

-- RateRight - The Platform
INSERT INTO company_intel (
  company_name,
  company_name_normalized,
  summary,
  size,
  industry,
  location,
  website_url,
  ai_sales_angle,
  recent_projects,
  searched_at
) VALUES (
  'RateRight',
  'rateright',
  'RateRight is an Australian construction workforce marketplace connecting contractors directly with skilled tradespeople. Contractors post jobs, workers apply direct - cutting out the middleman. $50 flat fee vs 30-40% agency margins. Founded to solve the chronic skilled labour shortage in Australian construction.',
  'small',
  'Construction Tech / Workforce Marketplace',
  'Sydney, NSW, Australia',
  'https://rateright.com.au',
  'This IS RateRight - the platform itself. Used by contractors to find formworkers, steelfixers, concreters, labourers and more. Workers sign up free, contractors pay a flat $50 per hire.',
  '["Workforce marketplace for construction", "Direct contractor-to-worker connections", "Disrupting traditional labour hire"]'::jsonb,
  NOW()
);
