-- Migration for existing databases
-- Add ussd_code to users
ALTER TABLE users ADD COLUMN IF NOT EXISTS ussd_code VARCHAR(4) NULL UNIQUE AFTER phone;

-- Add on_hold if not already (already handled earlier)
-- Packages and providers tables are in schema.sql for new installs
-- Run the CREATE TABLE statements from schema.sql if missing