ALTER TABLE reporting_events ADD COLUMN IF NOT EXISTS channel VARCHAR(32) NOT NULL DEFAULT 'voice';
ALTER TABLE reporting_events ADD COLUMN IF NOT EXISTS agent_id VARCHAR(128) NULL;

CREATE INDEX IF NOT EXISTS ix_reporting_events_channel ON reporting_events (channel);
CREATE INDEX IF NOT EXISTS ix_reporting_events_agent_id ON reporting_events (agent_id);