SQL

CREATE TABLE "pager_reading_material_paragraphs"  (
  id               INTEGER PRIMARY KEY AUTOINCREMENT,
  material_id      TEXT NOT NULL,
  paragraph_index  INTEGER NOT NULL,
  paragraph_text   TEXT NOT NULL,
  create_time      DATETIME DEFAULT (datetime('now')),
  UNIQUE(material_id, paragraph_index)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
material_id TEXT Rename | Drop
paragraph_index INTEGER Rename | Drop
paragraph_text TEXT Rename | Drop
create_time DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_rmp_material material_id SQL 
CREATE INDEX idx_rmp_material
ON "pager_reading_material_paragraphs"(material_id)
Drop
sqlite_autoindex_pager_reading_material_paragraphs_1
  • material_id
  • paragraph_index
 ✓ SQL
-- no sql found --
 Drop