Query

homilies.db — homilies

SQL

CREATE TABLE homilies  (
  id INTEGER PRIMARY KEY,
  title VARCHAR(200) NOT NULL,
  preacher VARCHAR(120),
  recorded_at DATE,
  audio_url VARCHAR(512) NOT NULL,
  duration_s INTEGER,
  transcript_text TEXT,
  transcript_vtt TEXT,
  transcription_status VARCHAR(20) DEFAULT 'pending',
  analysis TEXT,
  plays INTEGER DEFAULT 0,
  engage INTEGER DEFAULT 0,
  total_listening_time INTEGER DEFAULT 0,
  created_ts DATETIME DEFAULT CURRENT_TIMESTAMP,
  published INTEGER DEFAULT 1
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
title VARCHAR(200) Rename | Drop
preacher VARCHAR(120) ✓ Rename | Drop
recorded_at DATE ✓ Rename | Drop
audio_url VARCHAR(512) Rename | Drop
duration_s INTEGER ✓ Rename | Drop
transcript_text TEXT ✓ Rename | Drop
transcript_vtt TEXT ✓ Rename | Drop
transcription_status VARCHAR(20) ✓ Rename | Drop
analysis TEXT ✓ Rename | Drop
plays INTEGER ✓ Rename | Drop
engage INTEGER ✓ Rename | Drop
total_listening_time INTEGER ✓ Rename | Drop
created_ts DATETIME ✓ Rename | Drop
published INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_homilies_recorded_at recorded_at SQL 
CREATE INDEX idx_homilies_recorded_at
ON homilies(recorded_at DESC)
Drop