From: Damyan Ivanov Date: Sun, 3 May 2020 10:50:14 +0000 (+0000) Subject: note create_db.sql reflects changes up to rev. 29 X-Git-Tag: v0.12.0~16 X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=commitdiff_plain;h=a5d463d415bba85c80e423cced1426efcc5dd610 note create_db.sql reflects changes up to rev. 29 --- 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