-- B-connex baseline seed data

INSERT INTO plans (slug, name, tier, price_aud_cents, integrations_max, seats, ai_provider, features, active, created_at)
VALUES
('starter',    'Starter',    'starter',    2900,  1,   1,   'local',     '["campaigns_basic","leads_csv","sites_builder"]', 1, NOW()),
('growth',     'Growth',     'growth',     4900,  3,   3,   'openai',    '["campaigns_basic","leads_csv","ai_drafts","sequences","sites_builder"]', 1, NOW()),
('scale',      'Scale',      'scale',      14900, 8,   10,  'anthropic', '["campaigns_basic","leads_csv","ai_drafts","sequences","webhooks","enrichment","invoice_ato","geo_map","geo_country_drill","sites_builder"]', 1, NOW()),
('enterprise', 'Enterprise', 'enterprise', 49900, 999, 100, 'anthropic', '["campaigns_basic","leads_csv","ai_drafts","sequences","webhooks","enrichment","invoice_ato","sso","sla","geo_map","geo_country_drill","geo_city_zoom","sites_builder"]', 1, NOW())
ON DUPLICATE KEY UPDATE name = VALUES(name), price_aud_cents = VALUES(price_aud_cents), features = VALUES(features);

INSERT INTO organizations (name, country, currency, created_at)
VALUES ('B-connex Internal', 'AU', 'AUD', NOW())
ON DUPLICATE KEY UPDATE name = VALUES(name);
