table for options stored in the database

[mobile-ledger.git] / app / src / main / java / net / ktnx / mobileledger / MobileLedgerDB.java

diff --git a/app/src/main/java/net/ktnx/mobileledger/MobileLedgerDB.java b/app/src/main/java/net/ktnx/mobileledger/MobileLedgerDB.java
index 2aee53316c9031a741a185644aa8a622aed3fd89..350f50183b6c6d149b61c04873d5b4e2abd52cf7 100644 (file)
--- a/app/src/main/java/net/ktnx/mobileledger/MobileLedgerDB.java
+++ b/app/src/main/java/net/ktnx/mobileledger/MobileLedgerDB.java
@@ -7,18 +7,20 @@ class MobileLedgerDB {
     private static String db_filename;
     static SQLiteDatabase db;
 
-    public static String getDb_filename() {
+    static String getDb_filename() {
         return db_filename;
     }
 
-    public static void setDb_filename(String db_filename) {
+    static void setDb_filename(String db_filename) {
         MobileLedgerDB.db_filename = db_filename;
     }
 
-    public static void initDB() {
-        db = SQLiteDatabase.openOrCreateDatabase( db_filename, null );
+    static void initDB() {
+        db = SQLiteDatabase.openOrCreateDatabase(db_filename, null);
 
         db.execSQL("create table if not exists accounts(name varchar);");
         db.execSQL("create index if not exists idx_accounts_name on accounts(name);");
+        db.execSQL("create table if not exists options(name varchar, value varchar);");
+        db.execSQL("create unique index if not exists idx_options_name on options(name);");
     }
 }