CREATE TABLE voice_agent_configs (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
description TEXT,
user_id INTEGER NOT NULL,
-- Evolution API Configuration
evolution_api_url TEXT,
evolution_api_key TEXT,
evolution_instance_name TEXT,
-- Airtable CRM Configuration
airtable_api_key TEXT,
airtable_base_id TEXT,
airtable_table_name TEXT DEFAULT 'Leads',
-- Google Calendar Configuration
google_calendar_credentials_file TEXT,
google_calendar_credentials_json TEXT,
google_calendar_id TEXT,
-- Email Configuration
smtp_server TEXT,
smtp_port INTEGER DEFAULT 587,
smtp_user TEXT,
smtp_password TEXT,
-- Zoom Configuration
zoom_client_id TEXT,
zoom_client_secret TEXT,
zoom_account_id TEXT,
zoom_user_id TEXT,
-- LiveKit Configuration
livekit_url TEXT,
livekit_api_key TEXT,
livekit_api_secret TEXT,
sip_outbound_trunk_id TEXT,
-- Active flag
is_active INTEGER DEFAULT 1,
created_at TEXT NOT NULL,
updated_at TEXT,
is_default INTEGER DEFAULT 0,
system_prompt TEXT,
use_custom_prompt INTEGER DEFAULT 0,
silence_timeout REAL DEFAULT 8.0,
voice_name TEXT DEFAULT 'Puck',
temperature REAL DEFAULT 0.8,
initial_greeting TEXT,
notify_human_enabled INTEGER DEFAULT 0,
notify_human_phone_number TEXT,
enabled_tools TEXT,
agent_mode TEXT DEFAULT 'speech_to_speech',
stt_provider TEXT DEFAULT 'deepgram',
stt_model TEXT DEFAULT 'nova-3',
llm_provider TEXT DEFAULT 'openai',
llm_model TEXT DEFAULT 'gpt-4o-mini',
tts_provider TEXT DEFAULT 'openai',
tts_model TEXT DEFAULT 'gpt-4o-mini-tts',
tts_voice TEXT DEFAULT 'nova',
tts_instructions TEXT,
enable_affective_dialog INTEGER DEFAULT 0,
enable_thinking INTEGER DEFAULT 0,
include_thoughts INTEGER DEFAULT 1,
enable_proactivity INTEGER DEFAULT 0,
use_livekit_turn_detection INTEGER DEFAULT 0,
FOREIGN KEY (user_id) REFERENCES users(id),
UNIQUE(name, user_id)
)