X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fcreate_db.sql;h=14a0311ad831a1d49e046ae6d208eafab2446f02;hp=da3e8d8b2eb73866df59419ad6a7c8eba3aa2715;hb=29fa90b17cbb87f0b16f3607f0628fe0057d6560;hpb=7bcb2131b85a0ac047d8f8b4d3199ebe78f16768 diff --git a/app/src/main/res/raw/create_db.sql b/app/src/main/res/raw/create_db.sql index da3e8d8b..14a0311a 100644 --- a/app/src/main/res/raw/create_db.sql +++ b/app/src/main/res/raw/create_db.sql @@ -12,7 +12,7 @@ -- -- You should have received a copy of the GNU General Public License -- along with MoLe. If not, see . -create table accounts(profile varchar not null, name varchar not null, name_upper varchar not null, hidden boolean not null default 0, keep boolean not null default 0, level integer not null, parent_name varchar, expanded default 1, amounts_expanded boolean default 0); +create table accounts(profile varchar not null, name varchar not null, name_upper varchar not null, keep boolean not null default 0, level integer not null, parent_name varchar, expanded default 1, amounts_expanded boolean default 0); create unique index un_accounts on accounts(profile, name); create table options(profile varchar not null, name varchar not null, value varchar); create unique index un_options on options(profile,name); @@ -26,4 +26,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 34 \ No newline at end of file +-- updated to revision 35 \ No newline at end of file