SQL

CREATE TABLE "pager_reading_materials"  (
  id            INTEGER PRIMARY KEY AUTOINCREMENT,
  material_id   TEXT NOT NULL UNIQUE,
  assignment_id TEXT NOT NULL,
  title         TEXT DEFAULT '',
  author        TEXT DEFAULT '',
  content       TEXT NOT NULL DEFAULT '',
  word_count    INTEGER DEFAULT 0,
  create_time   DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
material_id TEXT Rename | Drop
assignment_id TEXT Rename | Drop
title TEXT ✓ Rename | Drop
author TEXT ✓ Rename | Drop
content TEXT Rename | Drop
word_count INTEGER ✓ Rename | Drop
create_time DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_rm_asgn assignment_id SQL 
CREATE INDEX idx_rm_asgn
ON "pager_reading_materials"(assignment_id)
Drop
sqlite_autoindex_pager_reading_materials_1 material_id ✓ SQL
-- no sql found --
 Drop