From c02d685c996b8155781b5df658ee13653893eb8a Mon Sep 17 00:00:00 2001
From: Jan Tuomi <jans.tuomi@gmail.com>
Date: Fri, 1 Mar 2024 17:13:49 +0200
Subject: Improve validation

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

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

diff --git a/migrations/0005_indices.sql b/migrations/0005_indices.sql
new file mode 100644
index 0000000..83d0d09
--- /dev/null
+++ b/migrations/0005_indices.sql
@@ -0,0 +1,7 @@
+ALTER TABLE votes ADD CONSTRAINT idx_votes_unique_voter_name UNIQUE (poll_id, choice_id, voter_name);
+
+CREATE INDEX idx_votes_poll_id_voter_name ON votes (poll_id, voter_name);
+CREATE INDEX idx_choices_poll_id_start_datetime ON choices (poll_id, start_datetime);
+CREATE INDEX idx_votes_choice_id ON votes (choice_id);
+CREATE INDEX idx_votes_manage_code ON votes (manage_code);
+CREATE INDEX idx_polls_manage_code_pub_date ON polls (manage_code, pub_date);
-- 
cgit v1.3

