diff options
| author | Jan T <jan@jantuomi.fi> | 2024-02-28 17:32:01 +0200 |
|---|---|---|
| committer | Jan Tuomi <jan@jantuomi.fi> | 2024-12-21 19:43:13 +0200 |
| commit | b6bc5c5794b4df182175da34e6b08298084c0324 (patch) | |
| tree | 501362805ac744eb71e0e9d7b70addb9f0c9ae99 /migrations/0001_indices.sql | |
Initial commit
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); |