X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fdb_41_58.sql;h=b9b40b2ec9da4631ebda132b891a311247ef312d;hp=630e207cc2c0dc5b3864afabcbd50667adfdee6e;hb=9861642afca239ebe3f49fc7c5c705b71833abc9;hpb=0a26b3a2165061e549cd195bd604ee525c93c54a diff --git a/app/src/main/res/raw/db_41_58.sql b/app/src/main/res/raw/db_41_58.sql index 630e207c..b9b40b2e 100644 --- a/app/src/main/res/raw/db_41_58.sql +++ b/app/src/main/res/raw/db_41_58.sql @@ -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)