-- =====================================================================
-- ReviewsEmbed SaaS — Seed Data
-- Version: 1.0.0.0
-- Run AFTER schema.sql against a fresh database.
-- =====================================================================
-- IMPORTANT: The admin password hash below corresponds to a placeholder.
-- Run tools/generate-admin-password.php once on the host to generate a
-- real Argon2id hash and UPDATE the row before going live.
-- =====================================================================


-- ---------------------------------------------------------------------
-- PLANS
-- ---------------------------------------------------------------------
INSERT INTO plans
    (tier, display_name, monthly_price_cents, stripe_price_id,
     max_locations, sync_interval_minutes, max_widgets,
     allows_custom_css, allows_ai_draft_reply, ai_draft_monthly_quota,
     allows_custom_font, allows_white_label, allows_api_access,
     is_active, sort_order, created_at, updated_at)
VALUES
    ('BASIC',      'Basic',      2900,  NULL,
     1,  60, 1,
     0, 0, 0,
     0, 0, 0,
     1, 10, UTC_TIMESTAMP(), UTC_TIMESTAMP()),

    ('PRO',        'Pro',        7900,  NULL,
     5,  30, 3,
     0, 1, 50,
     1, 1, 0,
     1, 20, UTC_TIMESTAMP(), UTC_TIMESTAMP()),

    ('ENTERPRISE', 'Enterprise', 19900, NULL,
     999, 15, 999,
     1, 1, 9999,
     1, 1, 1,
     1, 30, UTC_TIMESTAMP(), UTC_TIMESTAMP());

-- =====================================================================
-- END OF SEED
-- =====================================================================
