From bdf063853bd06449accc77570a129d118782bb1b Mon Sep 17 00:00:00 2001 From: Damyan Ivanov Date: Sun, 3 May 2020 11:12:58 +0300 Subject: [PATCH] add an index on transactions(description) to help finding the right previous transaction faster --- .../java/net/ktnx/mobileledger/utils/MobileLedgerDatabase.java | 2 +- app/src/main/res/raw/create_db.sql | 1 + app/src/main/res/raw/sql_29.sql | 1 + 3 files changed, 3 insertions(+), 1 deletion(-) create mode 100644 app/src/main/res/raw/sql_29.sql diff --git a/app/src/main/java/net/ktnx/mobileledger/utils/MobileLedgerDatabase.java b/app/src/main/java/net/ktnx/mobileledger/utils/MobileLedgerDatabase.java index 4097cdfd..cd0fcc41 100644 --- a/app/src/main/java/net/ktnx/mobileledger/utils/MobileLedgerDatabase.java +++ b/app/src/main/java/net/ktnx/mobileledger/utils/MobileLedgerDatabase.java @@ -34,7 +34,7 @@ import static net.ktnx.mobileledger.utils.Logger.debug; public class MobileLedgerDatabase extends SQLiteOpenHelper { private static final String DB_NAME = "MoLe.db"; - private static final int LATEST_REVISION = 28; + private static final int LATEST_REVISION = 29; private static final String CREATE_DB_SQL = "create_db"; private final Application mContext; diff --git a/app/src/main/res/raw/create_db.sql b/app/src/main/res/raw/create_db.sql index f903162a..eb05f214 100644 --- a/app/src/main/res/raw/create_db.sql +++ b/app/src/main/res/raw/create_db.sql @@ -9,6 +9,7 @@ create table profiles(uuid varchar not null primary key, name not null, url not create table transactions(profile varchar not null, id integer not null, data_hash varchar not null, date varchar not null, description varchar not null, keep boolean not null default 0); create unique index un_transactions_id on transactions(profile,id); create unique index un_transactions_data_hash on transactions(profile,data_hash); +create index idx_transaction_description on transactions(description); create table transaction_accounts(profile varchar not null, transaction_id integer not null, account_name varchar not null, currency varchar not null default '', amount decimal not null, comment varchar, constraint fk_transaction_accounts_acc foreign key(profile,account_name) references accounts(profile,account_name), constraint fk_transaction_accounts_trn foreign key(profile, transaction_id) references transactions(profile,id)); create table currencies(id integer not null primary key, name varchar not null, position varchar not null, has_gap boolean not null); -- updated to revision 26 \ No newline at end of file diff --git a/app/src/main/res/raw/sql_29.sql b/app/src/main/res/raw/sql_29.sql new file mode 100644 index 00000000..0301ba35 --- /dev/null +++ b/app/src/main/res/raw/sql_29.sql @@ -0,0 +1 @@ +create index idx_transaction_description on transactions(description); \ No newline at end of file -- 2.39.2