schema_0064-allow-multiple-moderations.sql « db - fixmystreet - This is mySociety's popular map-based reporting platform: easy to install in new countries and regions http://fixmystreet.org/

about summary refs log tree commit diff stats

path: root/db/schema_0064-allow-multiple-moderations.sql

blob: 5fee96282b2207aed69276c85028db41f53a9b66 (plain)

BEGIN;

ALTER TABLE moderation_original_data
    DROP CONSTRAINT moderation_original_data_comment_id_key;
CREATE INDEX moderation_original_data_problem_id_comment_id_idx
    ON moderation_original_data(problem_id, comment_id);

COMMIT;