From a5d463d415bba85c80e423cced1426efcc5dd610 Mon Sep 17 00:00:00 2001 From: Damyan Ivanov Date: Sun, 3 May 2020 10:50:14 +0000 Subject: [PATCH] note create_db.sql reflects changes up to rev. 29 --- app/src/main/res/raw/create_db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/app/src/main/res/raw/create_db.sql b/app/src/main/res/raw/create_db.sql index eb05f214..deeade8d 100644 --- a/app/src/main/res/raw/create_db.sql +++ b/app/src/main/res/raw/create_db.sql @@ -12,4 +12,4 @@ create unique index un_transactions_data_hash on transactions(profile,data_hash) create index idx_transaction_description on transactions(description); 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, comment varchar, 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)); create table currencies(id integer not null primary key, name varchar not null, position varchar not null, has_gap boolean not null); --- updated to revision 26 \ No newline at end of file +-- updated to revision 29 -- 2.39.2