-- PricePilot Subscription Upgrade Script
-- Upgrades jimbooti69@gmail.com from free to premium subscription

-- First, let's check the current status
SELECT 
    id,
    email,
    extension_id,
    subscription_type,
    subscription_status,
    created_at,
    updated_at
FROM users 
WHERE email = 'jimbooti69@gmail.com' 
   OR extension_id = 'pmhdjgenmanjfpkjgcblogcbidpabfcn';

-- Now upgrade to premium
UPDATE users 
SET 
    subscription_type = 'premium',
    subscription_status = 'active',
    updated_at = CURRENT_TIMESTAMP
WHERE email = 'jimbooti69@gmail.com' 
   OR extension_id = 'pmhdjgenmanjfpkjgcblogcbidpabfcn';

-- Verify the update
SELECT 
    id,
    email,
    extension_id,
    subscription_type,
    subscription_status,
    created_at,
    updated_at
FROM users 
WHERE email = 'jimbooti69@gmail.com' 
   OR extension_id = 'pmhdjgenmanjfpkjgcblogcbidpabfcn';

-- Show all users for reference
SELECT 
    id,
    email,
    extension_id,
    subscription_type,
    subscription_status,
    created_at,
    updated_at
FROM users 
ORDER BY id; 