SQL

CREATE TABLE report_templates  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  name        TEXT NOT NULL,
  type        TEXT NOT NULL CHECK(type IN ('daily','weekly','monthly')),
  config_json TEXT NOT NULL DEFAULT '{}',
  enabled     INTEGER DEFAULT 1,
  created_at  DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
name TEXT Rename | Drop
type TEXT Rename | Drop
config_json TEXT Rename | Drop
enabled INTEGER ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?