Query

app.db — smile_preview_embed_v...

SQL

CREATE TABLE smile_preview_embed_visitors  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  visitor_key TEXT NOT NULL,
  ip_hash TEXT NOT NULL,
  fingerprint_visitor_id TEXT NOT NULL,
  last_job_id INTEGER,
  has_completed INTEGER NOT NULL DEFAULT 0,
  first_seen_at TEXT NOT NULL,
  last_seen_at TEXT NOT NULL,
  UNIQUE(chatbot_id, visitor_key),
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
  FOREIGN KEY (last_job_id) REFERENCES smile_preview_jobs(id) ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
visitor_key TEXT Rename | Drop
ip_hash TEXT Rename | Drop
fingerprint_visitor_id TEXT Rename | Drop
last_job_id INTEGER ✓ Rename | Drop
has_completed INTEGER Rename | Drop
first_seen_at TEXT Rename | Drop
last_seen_at TEXT Rename | Drop

Foreign Keys

Column Destination
last_job_id smile_preview_jobs.id
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_smile_embed_visitors_chatbot
  • chatbot_id
  • visitor_key
 SQL 
CREATE INDEX idx_smile_embed_visitors_chatbot
ON smile_preview_embed_visitors(chatbot_id, visitor_key)
Drop
sqlite_autoindex_smile_preview_embed_visitors_1
  • chatbot_id
  • visitor_key
 ✓ SQL
-- no sql found --
 Drop