filite/migrations/2019-10-07-174502_create_texts/up.sql

CREATE TABLE texts (
  id INTEGER NOT NULL PRIMARY KEY,
  contents TEXT NOT NULL,
  created INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
);