model/sql/migrate.sql


1
2
3
4
5
6
7
8
9

CREATE TABLE recipes (
	id           INTEGER PRIMARY KEY,
	title        TEXT    NOT NULL,
	portions     INTEGER NOT NULL,
	url          TEXT    NOT NULL,
	notes        TEXT    NOT NULL,
	created      INTEGER NOT NULL, -- unix timestamp
	last_changed INTEGER NOT NULL  -- unix timestamp
);