1 files changed, 30 insertions, 0 deletions
diff --git a/model/sql/migration002.sql b/model/sql/migration002.sql
new file mode 100644
index 0000000..89837b3
--- /dev/null
+++ b/model/sql/migration002.sql
@@ -0,0 +1,30 @@
+-- Database schema 2 adds the ability to save recipes as favorites.
+
+CREATE TABLE recipes_new (
+	id           INTEGER PRIMARY KEY,
+	title        TEXT    NOT NULL,
+	portions     INTEGER NOT NULL,
+	url          TEXT    NOT NULL,
+	notes        TEXT    NOT NULL,
+	created      INTEGER NOT NULL,               -- Unix time stamp
+	last_changed INTEGER NOT NULL,               -- Unix time stamp
+	is_favorite  BOOLEAN NOT NULL DEFAULT FALSE
+);
+
+INSERT INTO
+	recipes_new
+	(id, title, portions, url, notes, created, last_changed, is_favorite)
+SELECT
+	id, title, portions, url, notes, created, last_changed, FALSE
+FROM recipes;
+
+DROP TABLE recipes;
+
+ALTER TABLE recipes_new RENAME TO recipes;
+
+UPDATE
+	metadata
+SET
+	value = '3'
+WHERE
+	key = 'schema_version';