aboutsummaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
authorJan Tuomi <jans.tuomi@gmail.com>2024-03-01 17:18:42 +0200
committerJan Tuomi <jan@jantuomi.fi>2024-12-21 19:43:13 +0200
commit6d628b23c1bbee75e57273e1f7e7a430f9ab1098 (patch)
tree63c09baf1d736b9db838c949b57dbd024babcff4 /migrations
parentc02d685c996b8155781b5df658ee13653893eb8a (diff)
Fix migration
Diffstat (limited to 'migrations')
-rw-r--r--migrations/0005_indices.sql1
1 files changed, 0 insertions, 1 deletions
diff --git a/migrations/0005_indices.sql b/migrations/0005_indices.sql
index 83d0d09..0402807 100644
--- a/migrations/0005_indices.sql
+++ b/migrations/0005_indices.sql
@@ -1,6 +1,5 @@
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);