SQL

CREATE TABLE conversations  (
  id VARCHAR NOT NULL,
  created_at DATETIME NOT NULL,
  title VARCHAR NOT NULL,
  user_id VARCHAR NOT NULL,
  system_prompt TEXT,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR ✓ Rename | Drop
created_at DATETIME Rename | Drop
title VARCHAR Rename | Drop
user_id VARCHAR Rename | Drop
system_prompt TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_conversations_1 id ✓ SQL
-- no sql found --
 Drop