Improve validation

1 files changed, 7 insertions, 0 deletions

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);