-- Subscriber grants
ALTER TABLE authorized_field_subscriber_grants
    DROP CONSTRAINT authorized_field_subscriber_grants_lease_id_fkey;

ALTER TABLE authorized_field_subscriber_grants
    DROP COLUMN kms_grant_id,
    DROP COLUMN aws_lease_id;

-- Publisher grants
ALTER TABLE authorized_field_publisher_grants
    DROP CONSTRAINT authorized_field_publisher_grants_lease_id_fkey;

ALTER TABLE authorized_field_publisher_grants
    DROP COLUMN kms_grant_id,
    DROP COLUMN aws_lease_id;
