add missing/fix copyright statements to all SQL revision files

diff --git a/app/src/main/res/raw/create_db.sql b/app/src/main/res/raw/create_db.sql
index af9ee1acdf0969ff77f806aad8b46b0823906e97..6b56953f3865b4a74b396082f0776b4f1afd249d 100644 (file)
--- a/app/src/main/res/raw/create_db.sql
+++ b/app/src/main/res/raw/create_db.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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

diff --git a/app/src/main/res/raw/sql_0.sql b/app/src/main/res/raw/sql_0.sql
index 3d05c510c869050326ffe012e2c54679196925b2..3e4feca22896e39cb872604ba342f270e4118b45 100644 (file)
--- a/app/src/main/res/raw/sql_0.sql
+++ b/app/src/main/res/raw/sql_0.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 <https://www.gnu.org/licenses/>.
+

 create table if not exists accounts(name varchar);
 create index if not exists idx_accounts_name on accounts(name);
 create table if not exists options(name varchar, value varchar);
 create table if not exists accounts(name varchar);
 create index if not exists idx_accounts_name on accounts(name);
 create table if not exists options(name varchar, value varchar);

diff --git a/app/src/main/res/raw/sql_1.sql b/app/src/main/res/raw/sql_1.sql
index 2dfa14171b76478b184576a2471ed7b02bfca7eb..b5d79f9a6d3665e635a2dea26faba024f6617c87 100644 (file)
--- a/app/src/main/res/raw/sql_1.sql
+++ b/app/src/main/res/raw/sql_1.sql
@@ -1,2 +1,17 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 alter table accounts add keep boolean;
 alter table accounts add keep boolean;

-alter table account_values add keep boolean;
\ No newline at end of file
+alter table account_values add keep boolean;

diff --git a/app/src/main/res/raw/sql_10.sql b/app/src/main/res/raw/sql_10.sql
index 48e7b790c7777528ac9b52f06c5640a8701dd4df..30962d41af4e87bcae33376303d56203e079b7f6 100644 (file)
--- a/app/src/main/res/raw/sql_10.sql
+++ b/app/src/main/res/raw/sql_10.sql
@@ -1,2 +1,17 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 delete from transaction_accounts;
 delete from transaction_accounts;

-delete from transactions;
\ No newline at end of file
+delete from transactions;

diff --git a/app/src/main/res/raw/sql_11.sql b/app/src/main/res/raw/sql_11.sql
index 356aa16c0f8339ca67468e6ea5c575d758bc52ea..eec8c3f5f91e615908cd487e207105c55693b7be 100644 (file)
--- a/app/src/main/res/raw/sql_11.sql
+++ b/app/src/main/res/raw/sql_11.sql
@@ -1,2 +1,17 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 create table profiles(uuid varchar not null primary key, name not null, url not null, use_authentication boolean not null, auth_user varchar, auth_password varchar);
 create table profiles(uuid varchar not null primary key, name not null, url not null, use_authentication boolean not null, auth_user varchar, auth_password varchar);

-create unique index un_profile_name on profiles(name);
\ No newline at end of file
+create unique index un_profile_name on profiles(name);

diff --git a/app/src/main/res/raw/sql_12.sql b/app/src/main/res/raw/sql_12.sql
index f64bc5ad99588ad2fb588c6d89432377fc882211..4ddd98dc394367c132b26df51e9eece339bd8225 100644 (file)
--- a/app/src/main/res/raw/sql_12.sql
+++ b/app/src/main/res/raw/sql_12.sql
@@ -1 +1,16 @@
-drop index un_profile_name;
\ No newline at end of file
+-- 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 <https://www.gnu.org/licenses/>.
+
+drop index un_profile_name;

diff --git a/app/src/main/res/raw/sql_13.sql b/app/src/main/res/raw/sql_13.sql
index e8038e9e1d3433ad31fa28701040404e43056244..9b08d7174312787979b34e5579385cffffa2625c 100644 (file)
--- a/app/src/main/res/raw/sql_13.sql
+++ b/app/src/main/res/raw/sql_13.sql
@@ -1,3 +1,18 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 delete from options where name='transaction_list_last_update';
 delete from options where name='last_refresh';
 alter table options add profile varchar;
 delete from options where name='transaction_list_last_update';
 delete from options where name='last_refresh';
 alter table options add profile varchar;


@@ -19,4 +34,4 @@ create table transactions(id integer not null, data_hash varchar not null, date
 create unique index un_transactions_id on transactions(id);
 create unique index un_transactions_data_hash on transactions(data_hash);
 --
 create unique index un_transactions_id on transactions(id);
 create unique index un_transactions_data_hash on transactions(data_hash);
 --

-create table transaction_accounts(profile varchar not null, transaction_id integer not null, account_name varchar not null, currency varchar not null default '', amount decimal not null, constraint fk_transaction_accounts_acc foreign key(profile,account_name) references accounts(profile,account_name), constraint fk_transaction_accounts_trn foreign key(transaction_id) references transactions(id));
\ No newline at end of file
+create table transaction_accounts(profile varchar not null, transaction_id integer not null, account_name varchar not null, currency varchar not null default '', amount decimal not null, constraint fk_transaction_accounts_acc foreign key(profile,account_name) references accounts(profile,account_name), constraint fk_transaction_accounts_trn foreign key(transaction_id) references transactions(id));

diff --git a/app/src/main/res/raw/sql_14.sql b/app/src/main/res/raw/sql_14.sql
index ddc634e6557efdd229cc6bd2ee678240baaeccad..4f5ec4c860a7030380243ba40dc1c9998639ec17 100644 (file)
--- a/app/src/main/res/raw/sql_14.sql
+++ b/app/src/main/res/raw/sql_14.sql
@@ -1,3 +1,18 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 drop table transaction_accounts;
 drop table transactions;
 --
 drop table transaction_accounts;
 drop table transactions;
 --


@@ -5,4 +20,4 @@ create table transactions(profile varchar not null, id integer not null, data_ha
 create unique index un_transactions_id on transactions(profile,id);
 create unique index un_transactions_data_hash on transactions(profile,data_hash);
 --
 create unique index un_transactions_id on transactions(profile,id);
 create unique index un_transactions_data_hash on transactions(profile,data_hash);
 --

-create table transaction_accounts(profile varchar not null, transaction_id integer not null, account_name varchar not null, currency varchar not null default '', amount decimal not null, constraint fk_transaction_accounts_acc foreign key(profile,account_name) references accounts(profile,account_name), constraint fk_transaction_accounts_trn foreign key(profile, transaction_id) references transactions(profile,id));
\ No newline at end of file
+create table transaction_accounts(profile varchar not null, transaction_id integer not null, account_name varchar not null, currency varchar not null default '', amount decimal not null, constraint fk_transaction_accounts_acc foreign key(profile,account_name) references accounts(profile,account_name), constraint fk_transaction_accounts_trn foreign key(profile, transaction_id) references transactions(profile,id));

diff --git a/app/src/main/res/raw/sql_15.sql b/app/src/main/res/raw/sql_15.sql
index 56eb75e2785bc8a7c5546ab71c9d6491a57ed554..8ce967c55d07c6ec3877c587493db6cca1c809fe 100644 (file)
--- a/app/src/main/res/raw/sql_15.sql
+++ b/app/src/main/res/raw/sql_15.sql
@@ -1,3 +1,18 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 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);
 
 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 +22,4 @@ 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;
 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;

diff --git a/app/src/main/res/raw/sql_16.sql b/app/src/main/res/raw/sql_16.sql
index 235f65596fa4b9af3251245810782cc9a707bc75..0c71dd883fa17870e4515452d59ca096c5290c3c 100644 (file)
--- a/app/src/main/res/raw/sql_16.sql
+++ b/app/src/main/res/raw/sql_16.sql
@@ -1 +1,17 @@
-alter table profiles add order_no integer;
\ No newline at end of file
+-- 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 <https://www.gnu.org/licenses/>.
+
+
+alter table profiles add order_no integer;

diff --git a/app/src/main/res/raw/sql_17.sql b/app/src/main/res/raw/sql_17.sql
index f6f7eebed1f0c675fcc6d385d13f4d96c36e0b4f..cfe1bb22a3b4ae6b7a70383e6ed6bff63c10d6c4 100644 (file)
--- a/app/src/main/res/raw/sql_17.sql
+++ b/app/src/main/res/raw/sql_17.sql
@@ -1,2 +1,17 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 alter table profiles add permit_posting boolean default 0;
 alter table profiles add permit_posting boolean default 0;

-update profiles set permit_posting = 1;
\ No newline at end of file
+update profiles set permit_posting = 1;

diff --git a/app/src/main/res/raw/sql_18.sql b/app/src/main/res/raw/sql_18.sql
index bea40aa930db1722a018c72a6f65400a5d26ac99..e74471eafb446f5a3f778a0732b40352013bb011 100644 (file)
--- a/app/src/main/res/raw/sql_18.sql
+++ b/app/src/main/res/raw/sql_18.sql
@@ -1,2 +1,17 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 alter table profiles add theme integer default -1;
 alter table profiles add theme integer default -1;

-update profiles set theme = -1;
\ No newline at end of file
+update profiles set theme = -1;

diff --git a/app/src/main/res/raw/sql_19.sql b/app/src/main/res/raw/sql_19.sql
index c2bdbaf7e7f44e5c68f19ba96ae051cbd431ed80..7221d57fe935e4aeec0d1956a8c9dbfcf12e4c21 100644 (file)
--- a/app/src/main/res/raw/sql_19.sql
+++ b/app/src/main/res/raw/sql_19.sql
@@ -1,2 +1,17 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 alter table accounts add expanded default 1;
 alter table accounts add expanded default 1;

-update accounts set expanded = 1;
\ No newline at end of file
+update accounts set expanded = 1;

diff --git a/app/src/main/res/raw/sql_2.sql b/app/src/main/res/raw/sql_2.sql
index bd27382f256d2f56a43d1d384ce7e702c0b4a49c..e7f8041c211f15be1c9a18ac7e1d72b9c5dbe6a2 100644 (file)
--- a/app/src/main/res/raw/sql_2.sql
+++ b/app/src/main/res/raw/sql_2.sql
@@ -1 +1,16 @@
-create table description_history(description varchar not null primary key, keep boolean);
\ No newline at end of file
+-- 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 <https://www.gnu.org/licenses/>.
+
+create table description_history(description varchar not null primary key, keep boolean);

diff --git a/app/src/main/res/raw/sql_20.sql b/app/src/main/res/raw/sql_20.sql
index 0485520252f4d6b928bd4499b2a001de46127142..8e2c1ecab389a9a8a4d812d2d147331ed584021a 100644 (file)
--- a/app/src/main/res/raw/sql_20.sql
+++ b/app/src/main/res/raw/sql_20.sql
@@ -1,4 +1,19 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 delete from accounts where not exists (select 1 from profiles where uuid = profile);
 delete from account_values where not exists (select 1 from profiles where uuid = profile);
 delete from transactions where not exists (select 1 from profiles where uuid = profile);
 delete from accounts where not exists (select 1 from profiles where uuid = profile);
 delete from account_values where not exists (select 1 from profiles where uuid = profile);
 delete from transactions where not exists (select 1 from profiles where uuid = profile);

-delete from transaction_accounts where not exists (select 1 from profiles where uuid = profile);
\ No newline at end of file
+delete from transaction_accounts where not exists (select 1 from profiles where uuid = profile);

diff --git a/app/src/main/res/raw/sql_21.sql b/app/src/main/res/raw/sql_21.sql
index 19d37d8adf19b2984b608f9167a6c94c5d93190c..70602319d506e653fad05fcdc093845bcd6f7bfc 100644 (file)
--- a/app/src/main/res/raw/sql_21.sql
+++ b/app/src/main/res/raw/sql_21.sql
@@ -1 +1,16 @@
-alter table accounts add amounts_expanded boolean default 0;
\ No newline at end of file
+-- 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 <https://www.gnu.org/licenses/>.
+
+alter table accounts add amounts_expanded boolean default 0;

diff --git a/app/src/main/res/raw/sql_22.sql b/app/src/main/res/raw/sql_22.sql
index 552397cc5595b0aa5e9b88769b6ca132837639ec..7b32f531d2a088ac1bfe2e3e073fc90617cc74c7 100644 (file)
--- a/app/src/main/res/raw/sql_22.sql
+++ b/app/src/main/res/raw/sql_22.sql
@@ -1 +1,16 @@
-alter table profiles add preferred_accounts_filter varchar;
\ No newline at end of file
+-- 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 <https://www.gnu.org/licenses/>.
+
+alter table profiles add preferred_accounts_filter varchar;

diff --git a/app/src/main/res/raw/sql_23.sql b/app/src/main/res/raw/sql_23.sql
index ff3b8f71633ec17e2c07bcfb7ddfc32c1cbd4c37..5ceef0d58738a131361c8da9fc8d353fddc7299f 100644 (file)
--- a/app/src/main/res/raw/sql_23.sql
+++ b/app/src/main/res/raw/sql_23.sql
@@ -1 +1,16 @@
-alter table profiles add future_dates integer;
\ No newline at end of file
+-- 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 <https://www.gnu.org/licenses/>.
+
+alter table profiles add future_dates integer;

diff --git a/app/src/main/res/raw/sql_24.sql b/app/src/main/res/raw/sql_24.sql
index 84ed1aef17ecb18efe56434a215ffa41ad81e2c6..2ee781720da364260f8bdbd5baf5e7ccd0e0c653 100644 (file)
--- a/app/src/main/res/raw/sql_24.sql
+++ b/app/src/main/res/raw/sql_24.sql
@@ -1 +1,16 @@
-alter table profiles add api_version integer;
\ No newline at end of file
+-- 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 <https://www.gnu.org/licenses/>.
+
+alter table profiles add api_version integer;

diff --git a/app/src/main/res/raw/sql_25.sql b/app/src/main/res/raw/sql_25.sql
index d797a3692d161ce714fe4c130b9278b14f165609..ae9bb47f8904ac783ff4f536698fa41dcb984a00 100644 (file)
--- a/app/src/main/res/raw/sql_25.sql
+++ b/app/src/main/res/raw/sql_25.sql
@@ -1 +1,16 @@
-create table currencies(id integer not null primary key, name varchar not null, position varchar not null, has_gap boolean not null);
\ No newline at end of file
+-- Copyright © 2020 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 <https://www.gnu.org/licenses/>.
+
+create table currencies(id integer not null primary key, name varchar not null, position varchar not null, has_gap boolean not null);

diff --git a/app/src/main/res/raw/sql_26.sql b/app/src/main/res/raw/sql_26.sql
index 5ef11025cb36350e685d961f4daf41140abb199e..767498367b288f137fa61a978b443ce9f0026a5a 100644 (file)
--- a/app/src/main/res/raw/sql_26.sql
+++ b/app/src/main/res/raw/sql_26.sql
@@ -1 +1,16 @@
-alter table transaction_accounts add comment varchar;
\ No newline at end of file
+-- Copyright © 2020 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 <https://www.gnu.org/licenses/>.
+
+alter table transaction_accounts add comment varchar;

diff --git a/app/src/main/res/raw/sql_27.sql b/app/src/main/res/raw/sql_27.sql
index 0d1e41c15936f71a0b5e0eca2df1d5b8f92d7afb..86d993f8288df882f95a1dbde7e3b573cbd68ae4 100644 (file)
--- a/app/src/main/res/raw/sql_27.sql
+++ b/app/src/main/res/raw/sql_27.sql
@@ -1 +1,16 @@
-alter table profiles add show_commodity_by_default boolean default 0;
\ No newline at end of file
+-- Copyright © 2020 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 <https://www.gnu.org/licenses/>.
+
+alter table profiles add show_commodity_by_default boolean default 0;

diff --git a/app/src/main/res/raw/sql_28.sql b/app/src/main/res/raw/sql_28.sql
index fa509c1f3950046df038bdc04a31e17f13baa3e2..8ec5fb6b44905f010368a0c2b5cf3b68b4795101 100644 (file)
--- a/app/src/main/res/raw/sql_28.sql
+++ b/app/src/main/res/raw/sql_28.sql
@@ -1 +1,17 @@
-alter table profiles add default_commodity varchar;
\ No newline at end of file
+-- Copyright © 2020 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 <https://www.gnu.org/licenses/>.
+
+
+alter table profiles add default_commodity varchar;

diff --git a/app/src/main/res/raw/sql_29.sql b/app/src/main/res/raw/sql_29.sql
index 0301ba351600634c7143fbdd3ce5718a0851b529..16164b87dd47551589bac26ef0f2ebe8741d8346 100644 (file)
--- a/app/src/main/res/raw/sql_29.sql
+++ b/app/src/main/res/raw/sql_29.sql
@@ -1 +1,15 @@
-create index idx_transaction_description on transactions(description);
\ No newline at end of file
+-- Copyright © 2020 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 <https://www.gnu.org/licenses/>.
+create index idx_transaction_description on transactions(description);

diff --git a/app/src/main/res/raw/sql_3.sql b/app/src/main/res/raw/sql_3.sql
index ceb373eceadc7addd249400e2e5e295b3bbaaff7..17ed3dbd40a9cf2de01a7b0f67a3ef7035e3dffc 100644 (file)
--- a/app/src/main/res/raw/sql_3.sql
+++ b/app/src/main/res/raw/sql_3.sql
@@ -1,4 +1,19 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 alter table description_history add description_upper varchar;
 update description_history set description_upper = upper(description);
 alter table accounts add name_upper varchar;
 alter table description_history add description_upper varchar;
 update description_history set description_upper = upper(description);
 alter table accounts add name_upper varchar;

-update accounts set name_upper = upper(name);
\ No newline at end of file
+update accounts set name_upper = upper(name);

diff --git a/app/src/main/res/raw/sql_30.sql b/app/src/main/res/raw/sql_30.sql
index c82adf841cd6a3a6005c981256915dbf35fd0481..a559673e929cffc19f84716c74df3c358ec14fba 100644 (file)
--- a/app/src/main/res/raw/sql_30.sql
+++ b/app/src/main/res/raw/sql_30.sql
@@ -1 +1,15 @@
-delete from options where profile <> '-' and not exists (select 1 from profiles p where p.uuid=options.profile);
\ No newline at end of file
+-- Copyright © 2020 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 <https://www.gnu.org/licenses/>.
+delete from options where profile <> '-' and not exists (select 1 from profiles p where p.uuid=options.profile);

diff --git a/app/src/main/res/raw/sql_31.sql b/app/src/main/res/raw/sql_31.sql
index 0f907e7553c77ec6b86b1c27d0b688a9323a7256..49b98ba4f903643aa6b54917b9f7c5dc52b8d92f 100644 (file)
--- a/app/src/main/res/raw/sql_31.sql
+++ b/app/src/main/res/raw/sql_31.sql
@@ -1 +1,15 @@
-alter table profiles add show_comments_by_default boolean default 0;
\ No newline at end of file
+-- Copyright © 2020 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 <https://www.gnu.org/licenses/>.
+alter table profiles add show_comments_by_default boolean default 0;

diff --git a/app/src/main/res/raw/sql_32.sql b/app/src/main/res/raw/sql_32.sql
index b85864405e732b2dacbde11e834736949b177315..fecf2ad0fc288effc0eb606660a10be4a29fcc0b 100644 (file)
--- a/app/src/main/res/raw/sql_32.sql
+++ b/app/src/main/res/raw/sql_32.sql
@@ -1 +1,15 @@
-update profiles set show_comments_by_default = 1;
\ No newline at end of file
+-- Copyright © 2020 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 <https://www.gnu.org/licenses/>.
+update profiles set show_comments_by_default = 1;

diff --git a/app/src/main/res/raw/sql_33.sql b/app/src/main/res/raw/sql_33.sql
index e6f5249303dcc4c694c9cd80f78073b8c9976170..da442f8a481fb876eef60769a7cb52bbaaee61fa 100644 (file)
--- a/app/src/main/res/raw/sql_33.sql
+++ b/app/src/main/res/raw/sql_33.sql
@@ -1 +1,15 @@
-alter table transactions add comment varchar;
\ No newline at end of file
+-- Copyright © 2020 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 <https://www.gnu.org/licenses/>.
+alter table transactions add comment varchar;

diff --git a/app/src/main/res/raw/sql_38.sql b/app/src/main/res/raw/sql_38.sql
index 60c8611e0534c799df1bdfab40cd81ec471df568..299907f9d01291ba2fa47159765f505bcd3b7ce8 100644 (file)
--- a/app/src/main/res/raw/sql_38.sql
+++ b/app/src/main/res/raw/sql_38.sql
@@ -16,4 +16,4 @@ CREATE TABLE transaction_accounts_new(profile varchar not null, transaction_id i
 insert into transaction_accounts_new(profile, transaction_id, account_name, currency, amount, comment, generation, order_no) select profile, transaction_id, account_name, currency, amount, comment, generation, order_no from transaction_accounts;
 drop table transaction_accounts;
 alter table transaction_accounts_new rename to transaction_accounts;
 insert into transaction_accounts_new(profile, transaction_id, account_name, currency, amount, comment, generation, order_no) select profile, transaction_id, account_name, currency, amount, comment, generation, order_no from transaction_accounts;
 drop table transaction_accounts;
 alter table transaction_accounts_new rename to transaction_accounts;

-create unique index un_transaction_accounts_order on transaction_accounts(profile, transaction_id, order_no);
\ No newline at end of file
+create unique index un_transaction_accounts_order on transaction_accounts(profile, transaction_id, order_no);

diff --git a/app/src/main/res/raw/sql_39.sql b/app/src/main/res/raw/sql_39.sql
index 0312574cd61bfac5204d4586a91e09a492494dfb..92582fac99bbbe8c1938a7244926807be941c469 100644 (file)
--- a/app/src/main/res/raw/sql_39.sql
+++ b/app/src/main/res/raw/sql_39.sql
@@ -16,4 +16,4 @@ create table description_history_new(description varchar not null primary key, d
 insert into description_history_new(description, description_upper) select description, description_upper from description_history;
 drop table description_history;
 alter table description_history_new rename to description_history;
 insert into description_history_new(description, description_upper) select description, description_upper from description_history;
 drop table description_history;
 alter table description_history_new rename to description_history;

-create unique index un_description_history on description_history(description_upper);
\ No newline at end of file
+create unique index un_description_history on description_history(description_upper);

diff --git a/app/src/main/res/raw/sql_4.sql b/app/src/main/res/raw/sql_4.sql
index d1a14d756b449a7a4a1a7f3ef4bc5df3889ca307..e2fce1102b1b19a329eec5effa675488719a64eb 100644 (file)
--- a/app/src/main/res/raw/sql_4.sql
+++ b/app/src/main/res/raw/sql_4.sql
@@ -1,2 +1,17 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 alter table accounts add hidden boolean default 0;
 alter table accounts add hidden boolean default 0;

-update accounts set hidden = 0;
\ No newline at end of file
+update accounts set hidden = 0;

diff --git a/app/src/main/res/raw/sql_40.sql b/app/src/main/res/raw/sql_40.sql
index 18a350a0f084ec0b683f2314f8591de62019c7e9..b2168179ef98e2ddc5fed401e7a03975294b9e64 100644 (file)
--- a/app/src/main/res/raw/sql_40.sql
+++ b/app/src/main/res/raw/sql_40.sql
@@ -14,4 +14,4 @@
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 pragma foreign_keys=off;
 delete from transaction_accounts where not exists (select 1 from accounts a where a.profile=transaction_accounts.profile and a.name=transaction_accounts.account_name);
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 pragma foreign_keys=off;
 delete from transaction_accounts where not exists (select 1 from accounts a where a.profile=transaction_accounts.profile and a.name=transaction_accounts.account_name);

-delete from transaction_accounts where not exists (select 1 from transactions t where t.profile=transaction_accounts.profile and t.id=transaction_accounts.transaction_id);
\ No newline at end of file
+delete from transaction_accounts where not exists (select 1 from transactions t where t.profile=transaction_accounts.profile and t.id=transaction_accounts.transaction_id);

diff --git a/app/src/main/res/raw/sql_41.sql b/app/src/main/res/raw/sql_41.sql
index 5026276a897a096e96d85bfda2151dae7e41affb..dea27a7790395b8ecb7155462b4f23d472255ab8 100644 (file)
--- a/app/src/main/res/raw/sql_41.sql
+++ b/app/src/main/res/raw/sql_41.sql
@@ -14,4 +14,4 @@
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 alter table profiles add detected_version_pre_1_19 boolean;
 alter table profiles add detected_version_major integer;
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 alter table profiles add detected_version_pre_1_19 boolean;
 alter table profiles add detected_version_major integer;

-alter table profiles add detected_version_minor integer;
\ No newline at end of file
+alter table profiles add detected_version_minor integer;

diff --git a/app/src/main/res/raw/sql_42.sql b/app/src/main/res/raw/sql_42.sql
index d2e297f867f5eef8a90193196312d11354b11914..729595035af8c298e45a179685f34f9214e644f0 100644 (file)
--- a/app/src/main/res/raw/sql_42.sql
+++ b/app/src/main/res/raw/sql_42.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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

diff --git a/app/src/main/res/raw/sql_43.sql b/app/src/main/res/raw/sql_43.sql
index 1d6f410fca0ba84da35fea4eda908e93538e8acc..60e3147b05500ad6586007b8b4868d3cab643744 100644 (file)
--- a/app/src/main/res/raw/sql_43.sql
+++ b/app/src/main/res/raw/sql_43.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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


@@ -13,4 +13,5 @@
 -- You should have received a copy of the GNU General Public License
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 
 -- You should have received a copy of the GNU General Public License
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 

-alter table pattern_accounts add position integer not null default 0;
\ No newline at end of file
+
+alter table pattern_accounts add position integer not null default 0;

diff --git a/app/src/main/res/raw/sql_44.sql b/app/src/main/res/raw/sql_44.sql
index a73c2c513b2a0f2002a15a78d8d9f22346059a7e..b6d1cc08d5611051c93b32a7b8f1676e97e724c7 100644 (file)
--- a/app/src/main/res/raw/sql_44.sql
+++ b/app/src/main/res/raw/sql_44.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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


@@ -17,4 +17,4 @@ alter table patterns add transaction_description_match_group short;
 alter table patterns add transaction_comment_match_group short;
 alter table patterns add date_year short;
 alter table patterns add date_month short;
 alter table patterns add transaction_comment_match_group short;
 alter table patterns add date_year short;
 alter table patterns add date_month short;

-alter table patterns add date_day short;
\ No newline at end of file
+alter table patterns add date_day short;

diff --git a/app/src/main/res/raw/sql_45.sql b/app/src/main/res/raw/sql_45.sql
index c3d09a0d9b8cf7336eb4d517455c79a70197c24f..3220e4eada0c368402dcc63d869111550e92f445 100644 (file)
--- a/app/src/main/res/raw/sql_45.sql
+++ b/app/src/main/res/raw/sql_45.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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

diff --git a/app/src/main/res/raw/sql_46.sql b/app/src/main/res/raw/sql_46.sql
index a16c34dfbf149e4a2ac1477ff3b92475ddabfc5f..c4f045979e88706512448d6be0565c2b8efe6bb6 100644 (file)
--- a/app/src/main/res/raw/sql_46.sql
+++ b/app/src/main/res/raw/sql_46.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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

diff --git a/app/src/main/res/raw/sql_47.sql b/app/src/main/res/raw/sql_47.sql
index b78934867a26c04b02482a8630c5ebb5396dba71..e754a54f5c523b3e130e3e317209dc0bf6e95ed8 100644 (file)
--- a/app/src/main/res/raw/sql_47.sql
+++ b/app/src/main/res/raw/sql_47.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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

diff --git a/app/src/main/res/raw/sql_48.sql b/app/src/main/res/raw/sql_48.sql
index 2c725c4662971510a1afb8e28d73cae017348181..fe36bb4aa7d1752db9dcf114b799cb1fb47f1fcf 100644 (file)
--- a/app/src/main/res/raw/sql_48.sql
+++ b/app/src/main/res/raw/sql_48.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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

diff --git a/app/src/main/res/raw/sql_49.sql b/app/src/main/res/raw/sql_49.sql
index 3d7ba4972acddbbef17cc8da4bd1e28e0e31e26e..2852a8b892df1ed4ca865e6426be696774a9fa2c 100644 (file)
--- a/app/src/main/res/raw/sql_49.sql
+++ b/app/src/main/res/raw/sql_49.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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

diff --git a/app/src/main/res/raw/sql_5.sql b/app/src/main/res/raw/sql_5.sql
index 309f82efa9434f001d4d84bbe5b79d44684e6d96..84db5529963063ab9c7ffb57b7211db44953751e 100644 (file)
--- a/app/src/main/res/raw/sql_5.sql
+++ b/app/src/main/res/raw/sql_5.sql
@@ -1,2 +1,17 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 alter table accounts add level integer;
 alter table accounts add level integer;

-alter table accounts add parent varchar;
\ No newline at end of file
+alter table accounts add parent varchar;

diff --git a/app/src/main/res/raw/sql_50.sql b/app/src/main/res/raw/sql_50.sql
index 3f32e650bb7bb05e4ad034e975dd266e6c680a81..33395f2fd7d58329672d03febfc755d322973d9b 100644 (file)
--- a/app/src/main/res/raw/sql_50.sql
+++ b/app/src/main/res/raw/sql_50.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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


@@ -13,4 +13,5 @@
 -- You should have received a copy of the GNU General Public License
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 
 -- You should have received a copy of the GNU General Public License
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 

-alter table patterns add test_text text;
\ No newline at end of file
+
+alter table patterns add test_text text;

diff --git a/app/src/main/res/raw/sql_51.sql b/app/src/main/res/raw/sql_51.sql
index c686ed841f690eeafdd9f28821ae261d69218551..1e84c56bdf870882402bfd578a028017e74ef237 100644 (file)
--- a/app/src/main/res/raw/sql_51.sql
+++ b/app/src/main/res/raw/sql_51.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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


@@ -21,4 +21,4 @@ insert into patterns_new(id, name, regular_expression, transaction_description,
 drop table patterns;
 
 alter table patterns_new rename to patterns;
 drop table patterns;
 
 alter table patterns_new rename to patterns;

-create unique index un_patterns_id on patterns(id);
\ No newline at end of file
+create unique index un_patterns_id on patterns(id);

diff --git a/app/src/main/res/raw/sql_52.sql b/app/src/main/res/raw/sql_52.sql
index 69fb8035f5640bb87586b259c99d16772a65acae..86e3cb2f7a56767d3c963e687373b7439c51eb11 100644 (file)
--- a/app/src/main/res/raw/sql_52.sql
+++ b/app/src/main/res/raw/sql_52.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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


@@ -14,4 +14,4 @@
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 
 create index if not exists fk_pattern_accounts_pattern on pattern_accounts(pattern_id);
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 
 create index if not exists fk_pattern_accounts_pattern on pattern_accounts(pattern_id);

-create index if not exists fk_pattern_accounts_currency on pattern_accounts(currency);
\ No newline at end of file
+create index if not exists fk_pattern_accounts_currency on pattern_accounts(currency);

diff --git a/app/src/main/res/raw/sql_53.sql b/app/src/main/res/raw/sql_53.sql
index c6d0bd122aa3f5ba05e4888a9499a01c69c166e1..572156d30f32f06ddab488d8be7509b8f9cb3013 100644 (file)
--- a/app/src/main/res/raw/sql_53.sql
+++ b/app/src/main/res/raw/sql_53.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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


@@ -13,4 +13,5 @@
 -- You should have received a copy of the GNU General Public License
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 
 -- You should have received a copy of the GNU General Public License
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 

-alter table pattern_accounts add negate_amount INTEGER;
\ No newline at end of file
+
+alter table pattern_accounts add negate_amount INTEGER;

diff --git a/app/src/main/res/raw/sql_54.sql b/app/src/main/res/raw/sql_54.sql
index 50991462be3ba7bcfc486103e62609cd3291f7c2..df6b44fcd01f3ef46ecc47ab538aa1d30ae42330 100644 (file)
--- a/app/src/main/res/raw/sql_54.sql
+++ b/app/src/main/res/raw/sql_54.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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


@@ -22,4 +22,4 @@ insert into template_accounts(id, template_id, acc, position, acc_match_group, c
 create index fk_template_accounts_template on template_accounts(template_id);
 create index fk_template_accounts_currency on template_accounts(currency);
 drop table pattern_accounts;
 create index fk_template_accounts_template on template_accounts(template_id);
 create index fk_template_accounts_currency on template_accounts(currency);
 drop table pattern_accounts;

-drop table patterns;
\ No newline at end of file
+drop table patterns;

diff --git a/app/src/main/res/raw/sql_55.sql b/app/src/main/res/raw/sql_55.sql
index 9ae20151c7ec56b5c1fc79d3649f4273314b136e..fb77862a04f59b181af76a12a4dfc512b47dbadc 100644 (file)
--- a/app/src/main/res/raw/sql_55.sql
+++ b/app/src/main/res/raw/sql_55.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 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
 -- 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

diff --git a/app/src/main/res/raw/sql_6.sql b/app/src/main/res/raw/sql_6.sql
index c8e86348e7bb2cc4cb3b793ce3174fd6555b74dd..4d2a54cd5f03f25a869d03418a057fc385adcf48 100644 (file)
--- a/app/src/main/res/raw/sql_6.sql
+++ b/app/src/main/res/raw/sql_6.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 <https://www.gnu.org/licenses/>.
+

 drop index idx_accounts_name;
 create table accounts_tmp(name varchar not null, name_upper varchar not null primary key, hidden boolean not null default 0, level integer not null default 0, parent_name varchar);
 insert or replace into accounts_tmp(name, name_upper, hidden, level, parent_name) select name, name_upper, hidden, level, parent from accounts;
 drop index idx_accounts_name;
 create table accounts_tmp(name varchar not null, name_upper varchar not null primary key, hidden boolean not null default 0, level integer not null default 0, parent_name varchar);
 insert or replace into accounts_tmp(name, name_upper, hidden, level, parent_name) select name, name_upper, hidden, level, parent from accounts;

diff --git a/app/src/main/res/raw/sql_7.sql b/app/src/main/res/raw/sql_7.sql
index 5217e5ddf457f78a67cdf2b31d7d9e5363c496a9..780e4d4d91ea5907ba5a7440f4b52ebe8a1ccaaa 100644 (file)
--- a/app/src/main/res/raw/sql_7.sql
+++ b/app/src/main/res/raw/sql_7.sql
@@ -1,2 +1,17 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 create table transactions(id varchar primary key, date varchar, description varchar);
 create table transactions(id varchar primary key, date varchar, description varchar);

-create table transaction_accounts(transaction_id integer not null, account_name varchar not null, amount float, currency varchar, foreign key (transaction_id) references transactions(id), foreign key(account_name) references accounts(name));
\ No newline at end of file
+create table transaction_accounts(transaction_id integer not null, account_name varchar not null, amount float, currency varchar, foreign key (transaction_id) references transactions(id), foreign key(account_name) references accounts(name));

diff --git a/app/src/main/res/raw/sql_8.sql b/app/src/main/res/raw/sql_8.sql
index 0f065390561ccc9842e242ccd81c11c64be34667..b4a85e5207169a5857706b8ad55460f060de9c00 100644 (file)
--- a/app/src/main/res/raw/sql_8.sql
+++ b/app/src/main/res/raw/sql_8.sql
@@ -1,2 +1,17 @@
+-- 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 <https://www.gnu.org/licenses/>.
+

 alter table transactions add data_hash varchar;
 alter table transactions add data_hash varchar;

-delete from transactions;
\ No newline at end of file
+delete from transactions;

diff --git a/app/src/main/res/raw/sql_9.sql b/app/src/main/res/raw/sql_9.sql
index 936cec6761ec694d4dca4a817db330f536f17da3..16a78a833d272d8ac064bd4706467df5c96086aa 100644 (file)
--- 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 <https://www.gnu.org/licenses/>.
+

 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);
 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;
 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;