X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_15.sql;h=d134676c3f16a932a2a2fe6fd647693ae8b78bc6;hb=390a653a4424bd146f73bca3e421a0be252ee443;hp=56eb75e2785bc8a7c5546ab71c9d6491a57ed554;hpb=3b365016042215dd73cb4600840aa8199b8322b9;p=mobile-ledger.git diff --git a/app/src/main/res/raw/sql_15.sql b/app/src/main/res/raw/sql_15.sql index 56eb75e2..d134676c 100644 --- a/app/src/main/res/raw/sql_15.sql +++ b/app/src/main/res/raw/sql_15.sql @@ -1,3 +1,20 @@ +-- Copyright © 2019 Damyan Ivanov. +-- This file is part of MoLe. +-- MoLe is free software: you can distribute it and/or modify it +-- under the term of the GNU General Public License as published by +-- the Free Software Foundation, either version 3 of the License, or +-- (at your opinion), any later version. +-- +-- MoLe is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License terms for details. +-- +-- 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 is null and name='last_scrape'; create table new_options(profile varchar not null, name varchar not null, value varchar); @@ -7,4 +24,6 @@ drop table options; create table options(profile varchar not null, name varchar not null, value varchar); create unique index un_options on options(profile,name); insert into options(profile,name,value) select profile,name,value from new_options; -drop table new_options; \ No newline at end of file +drop table new_options; + +COMMIT TRANSACTION; \ No newline at end of file