diff options
| author | xengineering <me@xengineering.eu> | 2024-01-17 20:19:02 +0100 |
|---|---|---|
| committer | xengineering <me@xengineering.eu> | 2024-01-17 20:59:20 +0100 |
| commit | 644ddcde14c0545dd667eaf096dadab518ad90a7 (patch) | |
| tree | 86b5df5dfe09d4f7e698799c21d76093cc73f0f4 | |
| parent | ae1a31f226de5701683231afaabf0f66503ca17d (diff) | |
| download | ceres-644ddcde14c0545dd667eaf096dadab518ad90a7.tar ceres-644ddcde14c0545dd667eaf096dadab518ad90a7.tar.zst ceres-644ddcde14c0545dd667eaf096dadab518ad90a7.zip | |
model: Rename step rank to step index
This name reflects the purpose of the column better. It is used to order
the recipe steps of a recipe.
| -rw-r--r-- | model/sql/migrate.sql | 16 | ||||
| -rw-r--r-- | model/sql/testdata.sql | 2 |
2 files changed, 9 insertions, 9 deletions
diff --git a/model/sql/migrate.sql b/model/sql/migrate.sql index 6ca4d0f..4cbf75b 100644 --- a/model/sql/migrate.sql +++ b/model/sql/migrate.sql @@ -1,14 +1,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 '' + '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, + 'id' integer PRIMARY KEY, 'recipe_id' integer DEFAULT NULL, - 'rank' integer DEFAULT NULL, - 'text' text DEFAULT '' + 'index' integer DEFAULT NULL, + 'text' text DEFAULT '' ); diff --git a/model/sql/testdata.sql b/model/sql/testdata.sql index f2cd6e3..5452979 100644 --- a/model/sql/testdata.sql +++ b/model/sql/testdata.sql @@ -6,7 +6,7 @@ VALUES ; INSERT INTO 'recipe_steps' - ('id', 'recipe_id', 'rank', 'text') + ('id', 'recipe_id', 'index', 'text') VALUES (1, 1, 1, 'Stir the dough'), (2, 1, 2, 'Fry pancakes') |