app.db — chatbots

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)
)