service/src/main/resources/db/mariadb/V2__drop_subject_resource_id_indexes_columns.sql

ALTER TABLE resource DROP INDEX unique_issuer_client_resource_id;
ALTER TABLE resource DROP COLUMN resource_id;
ALTER TABLE subject DROP INDEX unique_issuer_client_subject_id;
ALTER TABLE subject DROP COLUMN subject_id;