dns-autoresolver/internal/store/migrations/0002_domains_unique.sql

-- +goose Up
ALTER TABLE domains ADD CONSTRAINT domains_project_zone_uniq UNIQUE (project_id, zone_id);

-- +goose Down
ALTER TABLE domains DROP CONSTRAINT domains_project_zone_uniq;