diff options
| author | Jan Tuomi <jans.tuomi@gmail.com> | 2024-03-01 17:19:56 +0200 |
|---|---|---|
| committer | Jan Tuomi <jan@jantuomi.fi> | 2024-12-21 19:43:13 +0200 |
| commit | ab6895846454407312ffc842f2f05ccc500a8d1f (patch) | |
| tree | a10e46f977a42cf0b305993b02a55e4c0a112ee1 /migrations | |
| parent | 6d628b23c1bbee75e57273e1f7e7a430f9ab1098 (diff) | |
Fix the migration some more
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/0005_indices.sql | 2 |
1 files changed, 0 insertions, 2 deletions
diff --git a/migrations/0005_indices.sql b/migrations/0005_indices.sql index 0402807..9f28ffb 100644 --- a/migrations/0005_indices.sql +++ b/migrations/0005_indices.sql @@ -1,6 +1,4 @@ ALTER TABLE votes ADD CONSTRAINT idx_votes_unique_voter_name UNIQUE (poll_id, choice_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); |