INSERT INTO membership_plans (
  membership_type,
  organization_type,
  tier,
  name,
  description,
  price_monthly,
  price_annual,
  currency,
  features,
  entitlements,
  is_active,
  sort_order
)
SELECT
  'INDIVIDUAL',
  NULL,
  'ENTREPRENEUR',
  'Entrepreneur',
  'Growth-focused membership for founders and business owners building with WWN.',
  99.99,
  999.00,
  'CAD',
  '["Everything in Elite","Founder growth circles and business clinics","Priority access to MSME lending opportunities","Business visibility and marketplace spotlight options","Quarterly strategy advisory session","Expanded partner and funding introductions"]'::json,
  '{}'::json,
  true,
  4
WHERE NOT EXISTS (
  SELECT 1
  FROM membership_plans
  WHERE membership_type = 'INDIVIDUAL'
    AND tier = 'ENTREPRENEUR'
);

INSERT INTO membership_plans (
  membership_type,
  organization_type,
  tier,
  name,
  description,
  price_monthly,
  price_annual,
  currency,
  features,
  entitlements,
  is_active,
  sort_order
)
SELECT
  'ORGANIZATION',
  NULL,
  'ENTREPRENEUR',
  'Enterprise Catalyst',
  'Premium growth tier for organizations scaling programs, capital access, and member impact.',
  799.99,
  7999.00,
  'CAD',
  '["Everything in Strategic Alliance","Executive partnership planning with WWN leadership","Priority access to custom capital and program structuring","Premium partner visibility across WWN campaigns","Quarterly executive performance and impact review","Tailored strategic introductions and collaboration support"]'::json,
  '{"tenant_access":true,"member_management":true,"seat_limit":null,"programs_access":true,"resources_access":true,"workshops_access":true,"white_label_resources_access":true,"org_susu_operate":true,"org_susu_education":true,"investment_club_access":true,"p2p_capital_access":true,"quote_managed_only":false}'::json,
  true,
  4
WHERE NOT EXISTS (
  SELECT 1
  FROM membership_plans
  WHERE membership_type = 'ORGANIZATION'
    AND organization_type IS NULL
    AND tier = 'ENTREPRENEUR'
);

INSERT INTO membership_plans (
  membership_type,
  organization_type,
  tier,
  name,
  description,
  price_monthly,
  price_annual,
  currency,
  features,
  entitlements,
  is_active,
  sort_order
)
SELECT
  'INVESTOR',
  NULL,
  'ENTREPRENEUR',
  'Strategic Capital Partner',
  'Top-tier investor membership for mission-aligned partners backing high-growth opportunities.',
  499.99,
  4999.00,
  'CAD',
  '["Everything in Impact Investor","Priority access to curated founder and MSME deal flow","Direct co-investment and syndication introductions","Executive-level impact and performance briefings","Strategic capital roundtables with WWN leadership","Concierge support for major investment participation"]'::json,
  '{}'::json,
  true,
  4
WHERE NOT EXISTS (
  SELECT 1
  FROM membership_plans
  WHERE membership_type = 'INVESTOR'
    AND tier = 'ENTREPRENEUR'
);
