diff options
| author | tilpner | 2020-05-29 12:41:05 +0200 |
|---|---|---|
| committer | tilpner | 2020-05-29 12:41:05 +0200 |
| commit | 7fa98e20655493e74b3ba95160dacd71f430e467 (patch) | |
| tree | dd152c4b7351fc67b1ab81dd9c39c155abc7e318 /src/main.rs | |
| parent | 23e93564ca7de185aacab4c494312d8b732922dd (diff) | |
| download | github-label-feed-7fa98e20655493e74b3ba95160dacd71f430e467.tar.gz github-label-feed-7fa98e20655493e74b3ba95160dacd71f430e467.tar.xz github-label-feed-7fa98e20655493e74b3ba95160dacd71f430e467.zip | |
atom: optimise state filtering
Diffstat (limited to 'src/main.rs')
| -rw-r--r-- | src/main.rs | 1 |
1 files changed, 1 insertions, 0 deletions
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, |