SQL

CREATE TABLE schema_migrations  (
  version INTEGER PRIMARY KEY,
  applied_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
version INTEGER Rename | Drop
applied_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?