X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_0.sql;h=cf9cca97b0c45fe0b684412aa3533820fe79537c;hb=390a653a4424bd146f73bca3e421a0be252ee443;hp=3d05c510c869050326ffe012e2c54679196925b2;hpb=d6418fb0d2e9e8abd843997a7aa2257f1a5d6cae;p=mobile-ledger.git diff --git a/app/src/main/res/raw/sql_0.sql b/app/src/main/res/raw/sql_0.sql index 3d05c510..cf9cca97 100644 --- a/app/src/main/res/raw/sql_0.sql +++ b/app/src/main/res/raw/sql_0.sql @@ -1,3 +1,20 @@ +-- 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 . + +BEGIN TRANSACTION; + 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); @@ -5,3 +22,5 @@ create unique index if not exists idx_options_name on options(name); create table if not exists account_values(account varchar not null, currency varchar not null, value decimal(18,2) not null); create index if not exists idx_account_values_account on account_values(account); create unique index if not exists un_account_values on account_values(account,currency); + +COMMIT TRANSACTION; \ No newline at end of file