model/sql/migrate.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

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