From 2e87583c406f6095aa31cacf0aa62a1254e0e2f6 Mon Sep 17 00:00:00 2001 From: Damyan Ivanov Date: Wed, 24 Mar 2021 21:09:20 +0200 Subject: [PATCH] fix db migration from v0.16.0 (profile data) --- app/src/main/res/raw/db_41_58.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/app/src/main/res/raw/db_41_58.sql b/app/src/main/res/raw/db_41_58.sql index 0a4394a6..630e207c 100644 --- a/app/src/main/res/raw/db_41_58.sql +++ b/app/src/main/res/raw/db_41_58.sql @@ -45,7 +45,8 @@ insert into profiles_new( select uuid, name, url, use_authentication, auth_user, auth_password, order_no, permit_posting, theme, preferred_accounts_filter, future_dates, api_version, show_commodity_by_default, default_commodity, show_comments_by_default, - detected_version_pre_1_19, detected_version_major, detected_version_minor + coalesce(detected_version_pre_1_19,0), coalesce(detected_version_major,0), + coalesce(detected_version_minor,0) from profiles; -- options -- 2.39.2