create or replace table procedure_instance_importer
(
	procedure_instance_importer_id bigint auto_increment
		primary key,
	tenant_id bigint not null,
	procedure_id bigint not null,
	name varchar(512) not null,
	type varchar(32) not null,
	configuration longtext not null,
	mappers_configuration longtext not null,
	created_at timestamp default current_timestamp() not null,
	updated_at timestamp default current_timestamp() not null,
	constraint procedure_instance_importer_procedure_FK
		foreign key (procedure_id) references `procedure` (procedure_id)
			on delete cascade,
	constraint procedure_instance_importer_tenant_FK
		foreign key (tenant_id) references tenant (tenant_id)
			on delete cascade
);

create or replace index procedure_instance_importer_procedure_IDX
	on procedure_instance_importer (procedure_id);

create or replace index procedure_instance_importer_tenant_IDX
	on procedure_instance_importer (tenant_id);