-- =====================================================================
-- 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.
-- =====================================================================

SET NAMES utf8mb4;

-- ---------------------------------------------------------------------
-- 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());

-- ---------------------------------------------------------------------
-- ADMIN USER — placeholder hash. REPLACE before go-live.
-- The placeholder hash below is for the literal string "CHANGE_ME_NOW".
-- Generate a real one with:  php tools/generate-admin-password.php
-- ---------------------------------------------------------------------
INSERT INTO users
    (email, password_hash, is_admin, email_verified_at, created_at, updated_at)
VALUES
    ('bill@claudeaiplugin.com',
     '$argon2id$v=19$m=65536,t=4,p=1$Y2hhbmdlbWVwbGFjZWhvbGRlcg$placeholder0000000000000000000000000000000000',
     1,
     UTC_TIMESTAMP(),
     UTC_TIMESTAMP(),
     UTC_TIMESTAMP());

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