Query

app.db — media_files

SQL

CREATE TABLE media_files (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  collection_type TEXT NOT NULL,
  file_path TEXT NOT NULL,
  filename TEXT NOT NULL,
  mime_type TEXT NOT NULL,
  file_size INTEGER NOT NULL,
  description TEXT,
  created_at TEXT NOT NULL,
  product_id INTEGER,
  variant_id INTEGER
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
collection_type TEXT Rename | Drop
file_path TEXT Rename | Drop
filename TEXT Rename | Drop
mime_type TEXT Rename | Drop
file_size INTEGER Rename | Drop
description TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
product_id INTEGER ✓ Rename | Drop
variant_id INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_media_files_chatbot_id chatbot_id SQL 
CREATE INDEX idx_media_files_chatbot_id
ON media_files(chatbot_id)
Drop
idx_media_files_collection_type collection_type SQL 
CREATE INDEX idx_media_files_collection_type
ON media_files(collection_type)
Drop