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,
	'rank' integer DEFAULT NULL,
	'text' text DEFAULT ''
);