-- ============================================================================
-- STRIPE PRODUCTS SEED DATA
-- ============================================================================
-- Date: April 10, 2026
-- Purpose: Populate stripe_products table with actual Stripe price/product IDs
-- Run: PGPASSWORD='FireFrost2026!Arbiter' psql -U arbiter -h 127.0.0.1 -d arbiter_db -f seed-stripe-products.sql
-- ============================================================================

-- Clear existing data (if re-running)
TRUNCATE TABLE stripe_products;

-- Insert all tiers with actual Stripe IDs
INSERT INTO stripe_products (tier_level, tier_name, fire_or_frost, price_monthly, stripe_product_id, stripe_price_id, billing_type) VALUES
-- Tier 1: Awakened (one-time $1)
(1, 'Awakened', 'both', 1.00, 'prod_UGp8bRpm0C72tV', 'price_1TIHUDHaQd1A6XDNju7L7kTQ', 'one-time'),

-- Tier 2-3: Elemental ($5/mo)
(2, 'Elemental (Fire)', 'fire', 5.00, 'prod_UGp85wvlABvjOM', 'price_1TIHUEHaQd1A6XDNJmNgSvfE', 'recurring'),
(3, 'Elemental (Frost)', 'frost', 5.00, 'prod_UGp838XQJUHKjL', 'price_1TIHUEHaQd1A6XDNmEszQSZ7', 'recurring'),

-- Tier 4-5: Knight ($10/mo)
(4, 'Knight (Fire)', 'fire', 10.00, 'prod_UGp8H8Yo4aUszs', 'price_1TIHUEHaQd1A6XDN8lWTR999', 'recurring'),
(5, 'Knight (Frost)', 'frost', 10.00, 'prod_UGp8lGymToNpFC', 'price_1TIHUFHaQd1A6XDNukxZq8UI', 'recurring'),

-- Tier 6-7: Master ($15/mo)
(6, 'Master (Fire)', 'fire', 15.00, 'prod_UGp8zI5Rl6Z5Fq', 'price_1TIHUFHaQd1A6XDNvBVFQg5y', 'recurring'),
(7, 'Master (Frost)', 'frost', 15.00, 'prod_UGp8Wt7t0f9iXW', 'price_1TIHUFHaQd1A6XDNR89F1ZHf', 'recurring'),

-- Tier 8-9: Legend ($20/mo)
(8, 'Legend (Fire)', 'fire', 20.00, 'prod_UGp8AKGcicXLAP', 'price_1TIHUGHaQd1A6XDNzpsgORld', 'recurring'),
(9, 'Legend (Frost)', 'frost', 20.00, 'prod_UGp8gWzTLWCkis', 'price_1TIHUGHaQd1A6XDN8nm1pUrB', 'recurring'),

-- Tier 10: Sovereign (one-time $499)
(10, 'Sovereign', 'both', 499.00, 'prod_UGp8KSzb72RaCr', 'price_1TIHUHHaQd1A6XDNKEaFSDrE', 'one-time');

-- Verify
SELECT tier_level, tier_name, fire_or_frost, price_monthly, billing_type FROM stripe_products ORDER BY tier_level;

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