-- Add plan tier to subscriptions and purchase history
ALTER TABLE subscriptions
  ADD COLUMN plan_tier ENUM('tier1','tier5','tier20','enterprise') NOT NULL DEFAULT 'tier20'
  AFTER status;

ALTER TABLE billing_purchases
  ADD COLUMN plan_tier ENUM('tier1','tier5','tier20','enterprise') NULL
  AFTER user_count;
