blob: 6ca4d0fc642d4381628d1bb7ea23cc2efe840b83 (
plain)
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,
'rank' integer DEFAULT NULL,
'text' text DEFAULT ''
);
|
