Files
call-center/migrations/sql/0030_ai_operator_config_postgres.sql

13 lines
403 B
SQL

CREATE TABLE IF NOT EXISTS ai_operator_settings (
id SERIAL PRIMARY KEY,
settings_key VARCHAR(64) NOT NULL UNIQUE,
config_json TEXT NOT NULL DEFAULT '{}',
updated_at VARCHAR(64) NOT NULL
);
CREATE INDEX IF NOT EXISTS idx_ai_operator_settings_key
ON ai_operator_settings(settings_key);
CREATE INDEX IF NOT EXISTS idx_ai_operator_settings_updated_at
ON ai_operator_settings(updated_at);