DO $$
DECLARE
   tenantIds text[] := ARRAY['cs00000int','cs00000int_0001','cs00000int_0002','cs00000int_0003','cs00000int_0004','cs00000int_0005'];
   tenantId text;
BEGIN
   FOREACH tenantId IN ARRAY tenantIds
   LOOP
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_quick_marc.status) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_data_export_spring.jobstatus) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_data_export_spring.identifiertype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_data_export_spring.exporttype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_data_export_spring.entitytype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_data_export_spring.batchstatus) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_consortia.setup_status) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_bulk_operations.updateoptiontype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_bulk_operations.updateactiontype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_bulk_operations.statustype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_bulk_operations.statetype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_bulk_operations.operationtype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_bulk_operations.operationstatustype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_bulk_operations.identifiertype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_bulk_operations.entitytype) WITH INOUT AS IMPLICIT;';
      EXECUTE 'CREATE CAST (character varying AS ' || tenantId || '_mod_bulk_operations.approachtype) WITH INOUT AS IMPLICIT;';
   END LOOP;
END $$;