aboutsummaryrefslogtreecommitdiff
path: root/libdino/src/service/database.vala
diff options
context:
space:
mode:
Diffstat (limited to 'libdino/src/service/database.vala')
-rw-r--r--libdino/src/service/database.vala12
1 files changed, 10 insertions, 2 deletions
diff --git a/libdino/src/service/database.vala b/libdino/src/service/database.vala
index 6384fa78..40967025 100644
--- a/libdino/src/service/database.vala
+++ b/libdino/src/service/database.vala
@@ -7,7 +7,7 @@ using Dino.Entities;
namespace Dino {
public class Database : Qlite.Database {
- private const int VERSION = 16;
+ private const int VERSION = 17;
public class AccountTable : Table {
public Column<int> id = new Column.Integer("id") { primary_key = true, auto_increment = true };
@@ -62,7 +62,7 @@ public class Database : Qlite.Database {
internal ContentItemTable(Database db) {
base(db, "content_item");
init({id, conversation_id, time, local_time, content_type, foreign_id, hide});
- index("contentitem_localtime_counterpart_idx", {local_time, conversation_id});
+ index("contentitem_conversation_hide_localtime_time_idx", {conversation_id, hide, local_time, time});
unique({content_type, foreign_id}, "IGNORE");
}
}
@@ -390,6 +390,14 @@ public class Database : Qlite.Database {
error("Failed to upgrade to database version 16: %s", e.message);
}
}
+ if (oldVersion < 17) {
+ try {
+ exec("DROP INDEX contentitem_localtime_counterpart_idx");
+ exec("CREATE INDEX contentitem_conversation_hide_localtime_time_idx ON content_item (conversation_id, hide, local_time, time)");
+ } catch (Error e) {
+ error("Failed to upgrade to database version 17: %s", e.message);
+ }
+ }
}
public ArrayList<Account> get_accounts() {