From c02d685c996b8155781b5df658ee13653893eb8a Mon Sep 17 00:00:00 2001 From: Jan Tuomi Date: Fri, 1 Mar 2024 17:13:49 +0200 Subject: Improve validation --- migrations/0005_indices.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 migrations/0005_indices.sql (limited to 'migrations') 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); -- cgit v1.3