describe options to Room

[mobile-ledger.git] / app / src / main / res / raw / create_db.sql

diff --git a/app/src/main/res/raw/create_db.sql b/app/src/main/res/raw/create_db.sql
index a4a42eafc8fe418e37f7e4658375a8897a48cb54..96a5bf433cb2b625c8683b197de91efbe5c5aa60 100644 (file)
--- 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);