From 644ddcde14c0545dd667eaf096dadab518ad90a7 Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
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

