X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fcreate_db.sql;h=96a5bf433cb2b625c8683b197de91efbe5c5aa60;hp=a4a42eafc8fe418e37f7e4658375a8897a48cb54;hb=e28b8296d155c404cc5a702b3b477c41915d73dc;hpb=1c7d5db534b9c31c30f5a98074b0bcaeb1c0b4a9

diff --git a/app/src/main/res/raw/create_db.sql b/app/src/main/res/raw/create_db.sql
index a4a42eaf..96a5bf43 100644
--- a/app/src/main/res/raw/create_db.sql
+++ b/app/src/main/res/raw/create_db.sql
@@ -37,8 +37,8 @@ create table profiles(
  primary key(uuid));
 
 create table accounts(profile varchar not null, name varchar not null, name_upper varchar not null, level integer not null, parent_name varchar, expanded integer not null default 1, amounts_expanded integer not null default 0, generation integer not null default 0, primary key(profile, name));
-create table options(profile varchar not null, name varchar not null, value varchar);
-create unique index un_options on options(profile,name);
+create table options(profile varchar not null, name varchar not null, value varchar, primary key(profile, name));
+
 create table account_values(profile varchar not null, account varchar not null, currency varchar not null default '', value decimal not null, generation integer default 0 );
 create unique index un_account_values on account_values(profile,account,currency);
 create table description_history(description varchar not null primary key, description_upper varchar, generation integer default 0);