X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fcreate_db.sql;h=fd2e43e143da5ea97b444b85e19e032d21496bf6;hp=7095b1783311657c93a402e3c9f7ac82b99720db;hb=99c9595cb7bff9a8af5bc5370bda873286bde29b;hpb=faf89b750ab446c4f6d3d213264b80b66f384171 diff --git a/app/src/main/res/raw/create_db.sql b/app/src/main/res/raw/create_db.sql index 7095b178..fd2e43e1 100644 --- a/app/src/main/res/raw/create_db.sql +++ b/app/src/main/res/raw/create_db.sql @@ -1,4 +1,4 @@ -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); +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 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);