From 7fa98e20655493e74b3ba95160dacd71f430e467 Mon Sep 17 00:00:00 2001
From: tilpner
Date: Fri, 29 May 2020 12:41:05 +0200
Subject: atom: optimise state filtering

---
 src/main.rs | 1 +
 1 file changed, 1 insertion(+)

(limited to 'src/main.rs')

diff --git a/src/main.rs b/src/main.rs
index e544da1..7b352bd 100644
--- a/src/main.rs
+++ b/src/main.rs
@@ -61,6 +61,7 @@ async fn init_db(conn: &mut Conn) {
             updated_at integer,
             PRIMARY KEY (repo, number)
         );
+        CREATE INDEX IF NOT EXISTS issues_state ON issues (repo, number, state);
 
         CREATE TABLE IF NOT EXISTS labels(
             id integer PRIMARY KEY,
-- 
cgit v1.2.3