X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2FMobileLedgerDB.java;h=a4a078e7eb5b501c1a33dc8853847dfafa0d5ab3;hb=d6418fb0d2e9e8abd843997a7aa2257f1a5d6cae;hp=141b4a321f5cf9d304513c99bf90bb9ba290e03a;hpb=102232aaa4e22cd942ed305952c618f460b410fe;p=mobile-ledger.git diff --git a/app/src/main/java/net/ktnx/mobileledger/MobileLedgerDB.java b/app/src/main/java/net/ktnx/mobileledger/MobileLedgerDB.java index 141b4a32..a4a078e7 100644 --- a/app/src/main/java/net/ktnx/mobileledger/MobileLedgerDB.java +++ b/app/src/main/java/net/ktnx/mobileledger/MobileLedgerDB.java @@ -25,20 +25,9 @@ class MobileLedgerDB { MobileLedgerDB.db_filename = db_filename; } - static void initDB() { + static void initDB(Resources rm, String pkg_name) { 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);"); - db.execSQL("create table if not exists account_values(account varchar not null, currency varchar not null, value decimal(18,2) not null);"); - db.execSQL("create index if not exists idx_account_values_account on account_values(account);"); - db.execSQL("create unique index if not exists un_account_values on account_values(account,currency);"); - } - - static void applyRevisions(Resources rm, String pkg_name) { - int cur_ver = Integer.parseInt(get_option_value(OPT_DB_REVISION, "0")); + int cur_ver = Integer.parseInt(get_option_value(OPT_DB_REVISION, "-1")); Log.d("db", "Current DB revision is "+String.valueOf(cur_ver));