SQL

CREATE TABLE video_chunks  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  file_path TEXT NOT NULL,
  device_name TEXT NOT NULL DEFAULT '',
  sync_id TEXT,
  machine_id TEXT,
  synced_at DATETIME,
  fps REAL NOT NULL DEFAULT 0.5,
  cloud_blob_id TEXT DEFAULT NULL
)

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ read-only
file_path TEXT read-only
device_name TEXT read-only
sync_id TEXT ✓ read-only
machine_id TEXT ✓ read-only
synced_at DATETIME ✓ read-only
fps REAL read-only
cloud_blob_id TEXT ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_video_chunks_cloud_blob_id cloud_blob_id SQL 
CREATE INDEX idx_video_chunks_cloud_blob_id
ON video_chunks(cloud_blob_id) WHERE cloud_blob_id IS NULL
read-only
idx_video_chunks_device_name device_name SQL 
CREATE INDEX idx_video_chunks_device_name
ON video_chunks(device_name)
read-only
idx_video_chunks_device_name_id
  • device_name
  • id
 SQL 
CREATE INDEX idx_video_chunks_device_name_id
ON video_chunks(device_name, id DESC)
read-only