-- HostListing Production V2 host-management migration
ALTER TABLE hosts ADD COLUMN display_name VARCHAR(150) NULL;
ALTER TABLE hosts ADD COLUMN logo_url VARCHAR(500) NULL;
ALTER TABLE hosts ADD COLUMN website_url VARCHAR(500) NULL;
ALTER TABLE hosts ADD COLUMN api_endpoint VARCHAR(500) NULL;
ALTER TABLE hosts ADD COLUMN api_token TEXT NULL;
ALTER TABLE hosts ADD COLUMN upload_method VARCHAR(30) NOT NULL DEFAULT 'api';
ALTER TABLE hosts ADD COLUMN max_concurrent INT NOT NULL DEFAULT 2;
ALTER TABLE hosts ADD COLUMN retry_attempts INT NOT NULL DEFAULT 3;
ALTER TABLE hosts ADD COLUMN timeout_seconds INT NOT NULL DEFAULT 1800;
ALTER TABLE hosts ADD COLUMN updated_at DATETIME NULL;