From b6bc5c5794b4df182175da34e6b08298084c0324 Mon Sep 17 00:00:00 2001
From: Jan T <jan@jantuomi.fi>
Date: Wed, 28 Feb 2024 17:32:01 +0200
Subject: Initial commit

---
 migrations/0001_indices.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 migrations/0001_indices.sql

(limited to 'migrations/0001_indices.sql')

diff --git a/migrations/0001_indices.sql b/migrations/0001_indices.sql
new file mode 100644
index 0000000..42007ee
--- /dev/null
+++ b/migrations/0001_indices.sql
@@ -0,0 +1,3 @@
+CREATE INDEX IF NOT EXISTS idx_votes_poll_id_voter_name ON votes (poll_id, voter_name);
+CREATE INDEX IF NOT EXISTS idx_choices_poll_id_start_datetime ON choices (poll_id, start_datetime);
+CREATE INDEX IF NOT EXISTS idx_votes_choice_id ON votes (choice_id);
-- 
cgit v1.3