BEGIN;

DROP INDEX IF EXISTS idx_ai_credit_orders_txnid;
DROP INDEX IF EXISTS idx_ai_credit_orders_user_id;
DROP TABLE IF EXISTS ai_credit_orders;

UPDATE ai_credit_packages SET price_inr = 99   WHERE name = 'Starter AI Credits'    AND price_inr = 9900;
UPDATE ai_credit_packages SET price_inr = 349  WHERE name = 'Pro AI Credits'        AND price_inr = 34900;
UPDATE ai_credit_packages SET price_inr = 999  WHERE name = 'Business AI Credits'   AND price_inr = 99900;
UPDATE ai_credit_packages SET price_inr = 2499 WHERE name = 'Enterprise AI Credits' AND price_inr = 249900;

COMMIT;
