SQL

CREATE TABLE messages  (
  id VARCHAR NOT NULL,
  conversation_id VARCHAR NOT NULL,
  user_id VARCHAR NOT NULL,
  role VARCHAR NOT NULL,
  content TEXT NOT NULL,
  provider VARCHAR,
  model VARCHAR,
  raw TEXT,
  response_id VARCHAR,
  prompt_tokens INTEGER,
  completion_tokens INTEGER,
  total_tokens INTEGER,
  created_at DATETIME NOT NULL,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR ✓ Rename | Drop
conversation_id VARCHAR Rename | Drop
user_id VARCHAR Rename | Drop
role VARCHAR Rename | Drop
content TEXT Rename | Drop
provider VARCHAR ✓ Rename | Drop
model VARCHAR ✓ Rename | Drop
raw TEXT ✓ Rename | Drop
response_id VARCHAR ✓ Rename | Drop
prompt_tokens INTEGER ✓ Rename | Drop
completion_tokens INTEGER ✓ Rename | Drop
total_tokens INTEGER ✓ Rename | Drop
created_at DATETIME Rename | Drop

+ Add index

Indexes

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