diff options
Diffstat (limited to 'util/updates/2020-10-15-reviews-anonymous-votes.sql')
| -rw-r--r-- | util/updates/2020-10-15-reviews-anonymous-votes.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/2020-10-15-reviews-anonymous-votes.sql b/util/updates/2020-10-15-reviews-anonymous-votes.sql new file mode 100644 index 00000000..721543f6 --- /dev/null +++ b/util/updates/2020-10-15-reviews-anonymous-votes.sql @@ -0,0 +1,4 @@ +ALTER TABLE reviews_votes ADD COLUMN ip inet; +CREATE UNIQUE INDEX reviews_votes_id_ip ON reviews_votes (id,ip); +\i sql/func.sql +SELECT update_reviews_votes_cache(id) FROM reviews; |