From 644ddcde14c0545dd667eaf096dadab518ad90a7 Mon Sep 17 00:00:00 2001 From: xengineering Date: Wed, 17 Jan 2024 20:19:02 +0100 Subject: 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. --- model/sql/migrate.sql | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'model/sql/migrate.sql') 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 '' ); -- cgit v1.2.3-70-g09d2