ALTER TABLE tenants
    ADD COLUMN preferred_channel VARCHAR(16) NOT NULL DEFAULT 'web' AFTER locale;