-- ============================================================
-- ONLY the newest columns (Test Mode / sandbox support).
-- Safe to run: ONLY adds new columns - does not delete or touch
-- any existing data, rows, or other tables.
-- ============================================================
ALTER TABLE `users`
  ADD COLUMN IF NOT EXISTS `api_mode` ENUM('live','test') NOT NULL DEFAULT 'live';

ALTER TABLE `orders`
  ADD COLUMN IF NOT EXISTS `is_test` TINYINT(1) NOT NULL DEFAULT 0 AFTER `status`;