X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fdb_59.sql;h=5ba11afffaf9281705dc969abc16fed7e96fe8de;hb=2de3d8a8c96e78f4ab89880be9fab05735acc910;hp=27ad83b26f62c70ba52a8fee5d38400fa2e989be;hpb=479ae397be60069ac6cb11e4507136dff01d65da;p=mobile-ledger.git

diff --git a/app/src/main/res/raw/db_59.sql b/app/src/main/res/raw/db_59.sql
index 27ad83b2..5ba11aff 100644
--- a/app/src/main/res/raw/db_59.sql
+++ b/app/src/main/res/raw/db_59.sql
@@ -94,6 +94,16 @@ select o.name, p.id, o.value
 from options o
 join profiles p on p.deprecated_uuid = o.profile;
 
+insert into options_new(name, profile_id, value)
+select o.name, 0, o.value
+from options o
+where o.profile='-';
+
+update options_new
+set name='profile_id'
+  , value=(select p.id from profiles p where p.deprecated_uuid=value)
+where name='profile_uuid';
+
 drop table options;
 alter table options_new rename to options;