CREATE TABLE 'recipes' (
	'id'       integer PRIMARY KEY AUTOINCREMENT,
	'title'    text    DEFAULT '',
	'portions' text    DEFAULT '',  -- FIXME has to be integer
	'url'      text    DEFAULT '',
	'notes'    text    DEFAULT ''
);

CREATE TABLE 'recipe_steps' (
	'id'        integer PRIMARY KEY,
	'recipe_id' integer DEFAULT NULL,
	'index'     integer DEFAULT NULL,
	'text'      text    DEFAULT ''
);
