summaryrefslogtreecommitdiff
path: root/util/updates/2020-10-15-reviews-anonymous-votes.sql
blob: 721543f676e20786cc72ef294b302cf4ef34f9f9 (plain)
1
2
3
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;