CREATE TABLE "chatbots" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
system_prompt TEXT,
description TEXT,
user_id INTEGER NOT NULL,
is_active INTEGER DEFAULT 1,
created_at TEXT NOT NULL,
updated_at TEXT,
use_custom_prompt INTEGER DEFAULT 0,
icon TEXT,
use_triaged_planner INTEGER DEFAULT 0,
max_responses_enabled INTEGER DEFAULT 0,
max_responses_per_client_per_day INTEGER,
notification_method TEXT DEFAULT 'platform',
notification_phone_number TEXT,
is_ecommerce INTEGER DEFAULT 0,
follow_up_enabled INTEGER DEFAULT 0,
follow_up_delay_hours INTEGER DEFAULT 24,
follow_up_prompt TEXT,
humanization_enabled INTEGER DEFAULT 0,
humanization_prompt TEXT,
human_intervention_pause_minutes INTEGER,
human_intervention_pause_seconds INTEGER,
human_intervention_pause_enabled INTEGER DEFAULT 1,
google_sheets_enabled INTEGER DEFAULT 0,
google_sheets_spreadsheet_id TEXT,
google_sheets_worksheet_name TEXT DEFAULT 'Contacts',
google_sheets_credentials_json TEXT,
lead_collection_enabled INTEGER DEFAULT 0,
pretool_ack_prompt TEXT,
pretool_ack_mode TEXT DEFAULT 'default',
pre_tool_ack_enabled INTEGER DEFAULT 1,
pre_tool_ack_prompt_mode TEXT DEFAULT 'default',
pre_tool_ack_custom_prompt TEXT,
intelligent_ack_enabled INTEGER DEFAULT 1,
intelligent_ack_prompt_mode TEXT DEFAULT 'default',
intelligent_ack_custom_prompt TEXT,
tool_ack_config TEXT,
max_follow_ups INTEGER,
openai_api_key TEXT,
rag_top_k INTEGER DEFAULT 5,
max_chunk_tokens INTEGER DEFAULT 800,
rag_quality_evaluator_prompt TEXT,
rag_query_reformulation_prompt TEXT,
rag_synthesis_prompt TEXT,
rag_evaluator_model TEXT DEFAULT 'gpt-4o-mini',
max_rag_retry_attempts INTEGER DEFAULT 2,
rag_quality_threshold TEXT DEFAULT 'PARTIAL',
notification_message_template TEXT,
onboarding_token TEXT,
pause_on_notify_human_enabled INTEGER DEFAULT 1,
blocked_phone_numbers TEXT DEFAULT '[]',
ignore_group_messages INTEGER DEFAULT 0,
timezone TEXT DEFAULT 'UTC',
llm_provider TEXT DEFAULT 'OPENAI',
llm_model TEXT,
transcription_prompt TEXT,
transcription_language TEXT,
human_intervention_ignore_message_prefix TEXT,
transcription_provider TEXT,
image_analysis_prompt TEXT,
specialized_agents_config TEXT,
owner_client_context_window_messages INTEGER DEFAULT 10,
customer_work_items_api_url TEXT,
customer_work_items_bearer_token TEXT,
chatbot_type TEXT DEFAULT 'website_integrated',
notify_human_tool_config TEXT,
pause_tool_default_mode TEXT DEFAULT 'skip_once',
pause_tool_cooldown_seconds INTEGER DEFAULT 1800,
specialist_router_timeline_max_events INTEGER DEFAULT 12,
orchestrator_examples_enabled INTEGER DEFAULT 0,
FOREIGN KEY (user_id) REFERENCES users(id),
UNIQUE(name, user_id)
)