major rework of the async stuff, view model, pull-to-refresh account list

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

diff --git a/app/src/main/res/raw/sql_6.sql b/app/src/main/res/raw/sql_6.sql
new file mode 100644 (file)
index 0000000..c8e8634
--- /dev/null
+++ b/app/src/main/res/raw/sql_6.sql
@@ -0,0 +1,7 @@
+drop index idx_accounts_name;
+create table accounts_tmp(name varchar not null, name_upper varchar not null primary key, hidden boolean not null default 0, level integer not null default 0, parent_name varchar);
+insert or replace into accounts_tmp(name, name_upper, hidden, level, parent_name) select name, name_upper, hidden, level, parent from accounts;
+drop table accounts;
+create table accounts(name varchar not null, name_upper varchar not null primary key, hidden boolean not null default 0, level integer not null default 0, parent_name varchar, keep boolean default 1);
+insert into accounts(name, name_upper, hidden, level, parent_name) select name, name_upper, hidden, level, parent_name from accounts_tmp;
+drop table accounts_tmp;