Improved database schema

- Some queries are faster due to better index ordering
- Database is smaller thanks to splitting message_channel table and
  adding WITHOUT ROWID where helpful

1 files changed, 1 insertions, 1 deletions

diff --git a/scripts/save-event-types-to-db.js b/scripts/save-event-types-to-db.js

index 547e85c..290aa4a 100644
--- a/scripts/save-event-types-to-db.js
+++ b/scripts/save-event-types-to-db.js
@@ -13,7 +13,7 @@ Object.assign(passthrough, {sync, db})
 const api = require("../matrix/api")
 
 /** @type {{event_id: string, room_id: string, event_type: string}[]} */ // @ts-ignore
-const rows = db.prepare("SELECT event_id, room_id, event_type FROM event_message INNER JOIN channel_room USING (channel_id)").all()
+const rows = db.prepare("SELECT event_id, room_id, event_type FROM event_message INNER JOIN message_channel USING (message_id) INNER JOIN channel_room USING (channel_id)").all()
 
 const preparedUpdate = db.prepare("UPDATE event_message SET event_type = ?, event_subtype = ? WHERE event_id = ?")