diff options
Diffstat (limited to 'migrations/0001_indices.sql')
| -rw-r--r-- | migrations/0001_indices.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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); |