diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/0005_indices.sql | 7 |
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); |