ALTER TABLE publications
    DROP COLUMN iam_role_id,
    ALTER COLUMN account_id SET NOT NULL,
    ADD CONSTRAINT publications_account_id_fkey FOREIGN KEY (account_id) REFERENCES accounts (id)
        ON UPDATE CASCADE;
