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 );