-- Add subdomain and custom_domain columns to tenants
ALTER TABLE tenants
    ADD COLUMN subdomain VARCHAR(100) NOT NULL,
    ADD COLUMN custom_domain VARCHAR(255);

CREATE UNIQUE INDEX subdomain_unique ON tenants(subdomain);
CREATE UNIQUE INDEX custom_domain_unique ON tenants(custom_domain);
