-- Run this once in phpMyAdmin.
-- Adds a flag distinguishing "new" accounts (created after the
-- subscription-plan system) from old/legacy accounts. New accounts default
-- to requires_plan='Yes' and are blocked from connecting merchants /
-- creating transactions until they purchase a plan (see includes/subscription_lib.php).
-- Existing/legacy accounts are left as 'No' so their current access is
-- unaffected.

ALTER TABLE `users`
  ADD COLUMN `requires_plan` VARCHAR(5) NOT NULL DEFAULT 'No' AFTER `expiry`;