another db migration fix v0.16.0
authorDamyan Ivanov <dam+mobileledger@ktnx.net>
Wed, 29 Sep 2021 19:57:43 +0000 (19:57 +0000)
committerDamyan Ivanov <dam+mobileledger@ktnx.net>
Wed, 29 Sep 2021 19:57:43 +0000 (19:57 +0000)
app/src/main/res/raw/db_41_58.sql

index 630e207cc2c0dc5b3864afabcbd50667adfdee6e..b9b40b2ec9da4631ebda132b891a311247ef312d 100644 (file)
@@ -43,7 +43,8 @@ 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,
  coalesce(detected_version_pre_1_19,0), coalesce(detected_version_major,0),
  coalesce(detected_version_minor,0)