X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_7.sql;h=299a9e7f92c6af341d0995624baa64741da2fd2e;hb=390a653a4424bd146f73bca3e421a0be252ee443;hp=5217e5ddf457f78a67cdf2b31d7d9e5363c496a9;hpb=674b18d882411b94513d77c0aea39fd929a7a62b;p=mobile-ledger.git diff --git a/app/src/main/res/raw/sql_7.sql b/app/src/main/res/raw/sql_7.sql index 5217e5dd..299a9e7f 100644 --- a/app/src/main/res/raw/sql_7.sql +++ b/app/src/main/res/raw/sql_7.sql @@ -1,2 +1,21 @@ +-- 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 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)); + +COMMIT TRANSACTION; \ No newline at end of file