X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;ds=sidebyside;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fdb_41_58.sql;h=b9b40b2ec9da4631ebda132b891a311247ef312d;hb=9861642afca239ebe3f49fc7c5c705b71833abc9;hp=0a4394a63794a79f00d5b4fbcbf9c793bef1a203;hpb=9ea5a330029c99e0eecf55aaa94d8689fa64fc92;p=mobile-ledger.git

diff --git a/app/src/main/res/raw/db_41_58.sql b/app/src/main/res/raw/db_41_58.sql
index 0a4394a6..b9b40b2e 100644
--- a/app/src/main/res/raw/db_41_58.sql
+++ b/app/src/main/res/raw/db_41_58.sql
@@ -43,9 +43,11 @@ insert into profiles_new(
  show_commodity_by_default, default_commodity, show_comments_by_default,
  detected_version_pre_1_19, detected_version_major, detected_version_minor)
 select uuid, name, url, use_authentication, auth_user, auth_password, order_no,
- permit_posting, theme, preferred_accounts_filter, future_dates, api_version,
+ permit_posting, theme, preferred_accounts_filter, coalesce(future_dates,-1),
+ coalesce(api_version,0),
  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