-- Add enabled column to intl_countries
ALTER TABLE intl_countries ADD COLUMN IF NOT EXISTS is_enabled TINYINT(1) DEFAULT 0;
ALTER TABLE intl_countries ADD COLUMN IF NOT EXISTS sort_order INT DEFAULT 0;

-- Enable popular countries by default
UPDATE intl_countries SET is_enabled=1 WHERE iso IN (
    'BD','IN','PK','SA','AE','MY','KW','QA','OM','BH',
    'GB','US','AU','CA','NG','GH','KE','ZA','EG','PH',
    'ID','NP','LK','SG','JP','TR','BR','MM','CN','IT'
);
