create table RecipeMaterial
(
	Id int,
	MaterialName nvarchar(500) null,
	Type int null,
	Amount nvarchar(300) null,
	DetailId int null
);

create unique index RecipeMaterial_Id_uindex
	on RecipeMaterial (Id);

alter table RecipeMaterial
	add constraint RecipeMaterial_pk
		primary key (Id);

alter table RecipeMaterial modify Id int auto_increment;