diff options
| author | Jan Tuomi <jans.tuomi@gmail.com> | 2024-08-19 16:35:50 +0300 |
|---|---|---|
| committer | Jan Tuomi <jan@jantuomi.fi> | 2024-12-21 19:43:13 +0200 |
| commit | 6cabb205ea995a95f2211896f738f226fd27f7bb (patch) | |
| tree | f46a70cc331fc738d59acbc19a5ad9b0f8e6a031 /migrations/0005_indices.sql | |
| parent | 8c25a6f240d92f85a370df684da1d485829a894b (diff) | |
Migrate to SQLite3
Diffstat (limited to 'migrations/0005_indices.sql')
| -rw-r--r-- | migrations/0005_indices.sql | 4 |
1 files changed, 0 insertions, 4 deletions
diff --git a/migrations/0005_indices.sql b/migrations/0005_indices.sql deleted file mode 100644 index 9f28ffb..0000000 --- a/migrations/0005_indices.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE votes ADD CONSTRAINT idx_votes_unique_voter_name UNIQUE (poll_id, choice_id, voter_name); - -CREATE INDEX idx_votes_manage_code ON votes (manage_code); -CREATE INDEX idx_polls_manage_code_pub_date ON polls (manage_code, pub_date); |