6 lines
357 B
SQL
6 lines
357 B
SQL
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);
|