CREATE TABLE IF NOT EXISTS ai_credit_packages (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    name VARCHAR(150) NOT NULL,
    description TEXT,
    credits INT NOT NULL,
    price_inr INT NOT NULL,
    is_active BOOLEAN NOT NULL DEFAULT TRUE,
    created_at TIMESTAMP NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);

CREATE INDEX IF NOT EXISTS idx_ai_credit_packages_active ON ai_credit_packages(is_active, price_inr);

-- name has no unique constraint to key an ON CONFLICT off of, so guard the
-- whole seed on the table being empty (this migration only ever ran once
-- successfully; a second run inserted zero extra rows before this fix).
INSERT INTO ai_credit_packages (name, description, credits, price_inr)
SELECT * FROM (VALUES
    ('Starter AI Credits', '50 AI credits for casual usage', 50, 99),
    ('Pro AI Credits', '200 AI credits for power users', 200, 349),
    ('Business AI Credits', '750 AI credits for teams', 750, 999),
    ('Enterprise AI Credits', '2500 AI credits for heavy usage', 2500, 2499)
) AS v(name, description, credits, price_inr)
WHERE NOT EXISTS (SELECT 1 FROM ai_credit_packages);
