X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_30.sql;h=79e142bc54922bc1b9b9f173da35504c900497d5;hb=d5218337e111a377a3661f0ae4a5049edc055705;hp=a559673e929cffc19f84716c74df3c358ec14fba;hpb=81277d1635a9b15fef1614a096d94f8772e40735;p=mobile-ledger.git diff --git a/app/src/main/res/raw/sql_30.sql b/app/src/main/res/raw/sql_30.sql index a559673e..79e142bc 100644 --- a/app/src/main/res/raw/sql_30.sql +++ b/app/src/main/res/raw/sql_30.sql @@ -12,4 +12,9 @@ -- -- You should have received a copy of the GNU General Public License -- along with MoLe. If not, see . + +BEGIN TRANSACTION; + delete from options where profile <> '-' and not exists (select 1 from profiles p where p.uuid=options.profile); + +COMMIT TRANSACTION; \ No newline at end of file