X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_9.sql;h=16a78a833d272d8ac064bd4706467df5c96086aa;hp=936cec6761ec694d4dca4a817db330f536f17da3;hb=81277d1635a9b15fef1614a096d94f8772e40735;hpb=3ed17d6ccfa6aba1795d77ef24167fb9ef6a9ca1 diff --git a/app/src/main/res/raw/sql_9.sql b/app/src/main/res/raw/sql_9.sql index 936cec67..16a78a83 100644 --- a/app/src/main/res/raw/sql_9.sql +++ b/app/src/main/res/raw/sql_9.sql @@ -1,3 +1,18 @@ +-- Copyright © 2018 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 . + alter table transactions add keep boolean default 1 not null; update transactions set keep = 1; create table transactions_new(id integer, date varchar, description varchar, data_hash varchar, keep boolean); @@ -6,4 +21,4 @@ drop table transactions; create table transactions(id integer primary key, date varchar, description varchar, data_hash varchar, keep boolean); create unique index un_transactions_data_hash on transactions(data_hash); insert into transactions(id, date, description, data_hash, keep) select id, date, description, data_hash, keep from transactions_new; -drop table transactions_new; \ No newline at end of file +drop table transactions_new;