]> git.ktnx.net Git - mobile-ledger.git/blobdiff - app/src/main/res/raw/sql_3.sql
better ordering of auto-completion results
[mobile-ledger.git] / app / src / main / res / raw / sql_3.sql
diff --git a/app/src/main/res/raw/sql_3.sql b/app/src/main/res/raw/sql_3.sql
new file mode 100644 (file)
index 0000000..ceb373e
--- /dev/null
@@ -0,0 +1,4 @@
+alter table description_history add description_upper varchar;
+update description_history set description_upper = upper(description);
+alter table accounts add name_upper varchar;
+update accounts set name_upper = upper(name);
\ No newline at end of file