webui.db — adapter

• adapter
• alembic_version
• auth
• channel
• channel_member
• chat
• chatidtag
• config
• document
• feedback
• file
• folder
• function
• group
• knowledge
• memory
• message
• message_reaction
• migratehistory
• model
• note
• oauth_session
• prompt
• tag
• tool
• user
• user_backup

Toggle helper tables

• Structure
• Content
• Query
• Insert
• Drop
• Import
• Export

CREATE TABLE adapter  (
  id TEXT NOT NULL,
  user_id TEXT NOT NULL,
  job_id VARCHAR NOT NULL UNIQUE,
  base_model_name VARCHAR NOT NULL,
  base_model_path VARCHAR NOT NULL,
  model_name VARCHAR NOT NULL,
  model_desc VARCHAR NULL,
  model_path VARCHAR NOT NULL,
  source_model_name VARCHAR NULL,
  source_model_path VARCHAR NULL,
  source_job_id VARCHAR NULL,
  dataset_desc VARCHAR NULL,
  dataset_meta JSON DEFAULT '{}',
  dataset_path VARCHAR NOT NULL,
  training_output JSON NULL,
  status VARCHAR NOT NULL DEFAULT 'queued',
  created_at BIGINT NOT NULL,
  updated_at BIGINT NOT NULL,
  source_adapter_path VARCHAR NULL,
  adapter_path VARCHAR NULL,
  plugged_in BOOLEAN NOT NULL DEFAULT 0,
  PRIMARY KEY (id)
)

CREATE UNIQUE INDEX adapter_job_id_idx
ON adapter (job_id)

CREATE INDEX adapter_status_idx
ON adapter (status)

CREATE INDEX adapter_updated_at_user_id_idx
ON adapter (updated_at, user_id)

CREATE INDEX adapter_user_id_idx
ON adapter (user_id)

CREATE INDEX adapter_user_id_status_idx
ON adapter (user_id, status)