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=630e207cc2c0dc5b3864afabcbd50667adfdee6e;hp=0a4394a63794a79f00d5b4fbcbf9c793bef1a203;hb=2e87583c406f6095aa31cacf0aa62a1254e0e2f6;hpb=77f385dcd426ab1abd6a07b566de0b1dd5c34069 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