alter table tbl_PRD_NutritionChild alter column VitaminA_Type char(3)

  alter table tbl_PRD_Allergens add LevelofContainment_almonds varchar(20)
  alter table tbl_PRD_Allergens add almonds char(1)

  alter table tbl_PRD_Allergens add LevelofContainment_barley varchar(20)
  alter table tbl_PRD_Allergens add barley char(1)

  alter table tbl_PRD_Allergens add LevelofContainment_brazilNut varchar(20)
  alter table tbl_PRD_Allergens add brazilNut char(1)

  alter table tbl_PRD_Allergens add LevelofContainment_cashew varchar(20)
  alter table tbl_PRD_Allergens add cashew char(1)

  alter table tbl_PRD_Allergens add LevelofContainment_coconut varchar(20)
  alter table tbl_PRD_Allergens add coconut char(1)

  alter table tbl_PRD_Allergens add LevelofContainment_hazelnut varchar(20)
  alter table tbl_PRD_Allergens add hazelnut char(1)

  alter table tbl_PRD_Allergens add LevelofContainment_pecan varchar(20)
  alter table tbl_PRD_Allergens add pecan char(1)

  alter table tbl_PRD_Allergens add LevelofContainment_pistachio varchar(20)
  alter table tbl_PRD_Allergens add pistachio char(1)

  alter table tbl_PRD_Allergens add LevelofContainment_queenslandNut varchar(20)
  alter table tbl_PRD_Allergens add queenslandNut char(1)
      
  alter table tbl_PRD_Allergens add LevelofContainment_walnut varchar(20)
  alter table tbl_PRD_Allergens add walnut  char(1)


CREATE TABLE [dbo].[tbl_PRD_AllergenInfo](
	[allergenInfoId] [int] IDENTITY(1,1) NOT NULL,
	[ownerType] [varchar](3) NOT NULL,
	[ownerId] [int] NOT NULL,
	[linkType] [varchar](3) NOT NULL,
	[linkId] [int] NOT NULL,
	[allergenId] [int] NOT NULL,
	[levelOfContainment] [varchar](30) NOT NULL
) ON [PRIMARY]
GO

TRANFER TABLE [tbl_PRD_AllergenTypes] to production