 SET IDENTITY_INSERT ControlOption ON;
 MERGE INTO ControlOption AS Target 
 USING (VALUES 
-        (1, 1, 'Dry heaving', NULL),
-		(2, 1, 'Cramping', NULL),
-		(3, 1, 'Chest pain', NULL),
-		(4, 1, 'Close together, hard to breathe', NULL),
-
-		(6, 3, 'Dry heaving', NULL),
-		(7, 3, 'Cramping', NULL),
-		(8, 3, 'Chest pain', NULL),
-		(9, 3, 'Close together, hard to breathe', NULL),
-
-		(11, 5, 'Dry heaving', NULL),
-		(12, 5, 'Cramping', NULL),
-		(13, 5, 'Chest pain', NULL),
-		(14, 5, 'Close together, to breathe', NULL),
-
-		(16, 7, 'Dry heaving', NULL),
-		(17, 7, 'Cramping', NULL),
-		(18, 7, 'Chest pain', NULL),
-		(19, 7, 'Close together, hard to breathe', NULL),
-
-		(21, 9, 'Dry heaving', NULL),
-		(22, 9, 'Cramping', NULL),
-		(23, 9, 'Chest pain', NULL),
-		(24, 9, 'Close together, hard to breathe', NULL),
-
-		(25, 11, 'With cramping', NULL),
-		(26, 11, 'Empty stomach?', NULL),
-
-		(27, 12, 'a little', NULL),
-		(28, 12, 'normal aount', NULL),
-		(29, 12, 'a lot', NULL),
-		(30, 12, 'Austin Powers', 'a lot'),
-
-		(31, 13, '1) hydrated', NULL),
-		(32, 13, '2) hydrated', NULL),
-		(33, 13, '3) hydrated', NULL),
-		(34, 13, '4) dehydrated', NULL),
-		(35, 13, '5) dehydrated', NULL),
-		(36, 13, '6) dehydrated', NULL),
-		(37, 13, '7) dehydrated', NULL),
-		(38, 13, '8) dehydrated', NULL),
-
-		(39, 15, 'a little', NULL),
-		(40, 15, 'normal amount', NULL),
-		(41, 15, 'a lot', NULL),
-		(42, 15, 'I don''t remember eating that!', 'a lot'),
-		(43, 15, 'holy s*** I filled the bowl', 'a lot'),
-
-		(44, 16, 'Type 1) Separate hard lumps like nuts (hard to pass)', NULL),
-		(45, 16, 'Type 2) Sausage-shaped but lumpy', NULL),
-		(46, 16, 'Type 3) Like a sausage but with cracks on teh surface', NULL),
-		(47, 16, 'Type 4) Like a sausage or snake, smooth and soft', NULL),
-		(48, 16, 'Type 5) Soft blobs with clear-cut edges', NULL),
-		(49, 16, 'Type 6) Fluffy pieces with ragged edges, a mushy stool', NULL),
-		(50, 16, 'Type 7) Watery, no solid pieces (entirely liquid)', NULL),
-
-		(51, 18, 'church hous creeper', 'mild flatulence'),
-		(52, 18, 'farticles', 'mild flatulence'),
-		(53, 18, 'wasn''t me!', 'mild flatulence'),
-		(54, 18, 'scared the animals', 'mild flatulence'),
-		(55, 18, 'made daddy proud', 'mild flatulence'),
-		(57, 18, 'holy s***, what was that!!', 'mild flatulence'),
-		(58, 18, 'horrendASS', 'mild flatulence'),
-		(59, 18, 'bloated and painful', NULL),
-
-		(60, 20, 'a little', NULL),
-		(61, 20, 'a lot', NULL),
-		(62, 20, 'wardrobe change', 'a lot'),
-		(63, 20, 'bad grandpa', 'a lot')
+		(1, 1, N'Little Bit Of Mucus', NULL),
+		(3, 1, N'Lot Of Mucus', NULL),
+		(4, 1, N'Little Bit Of Food', NULL),
+		(5, 1, N'Lot Of Food', NULL),
+		(6, 1, N'Dry Heaving', NULL),
+		(7, 2, N'Dry Heaving', NULL),
+		(8, 2, N'Cramping', NULL),
+		(9, 2, N'Chest Pain', NULL),
+		(10, 2, N'Close Together And Hard To Breathe', NULL),
+		(25, 11, N'With Cramping', NULL),
+		(26, 11, N'Empty Stomach?', NULL),
+		(27, 12, N'A Little', NULL),
+		(28, 12, N'Normal Amount', NULL),
+		(29, 12, N'A Lot', NULL),
+		(30, 12, N'Austin Powers', N'A Lot'),
+		(31, 13, N'1) Hydrated', NULL),
+		(32, 13, N'2) Hydrated', NULL),
+		(33, 13, N'3) Hydrated', NULL),
+		(34, 13, N'4) Dehydrated', NULL),
+		(35, 13, N'5) Dehydrated', NULL),
+		(36, 13, N'6) Dehydrated', NULL),
+		(37, 13, N'7) Dehydrated', NULL),
+		(38, 13, N'8) Dehydrated', NULL),
+		(39, 15, N'A Little', NULL),
+		(40, 15, N'Normal Amount', NULL),
+		(41, 15, N'A Lot', NULL),
+		(42, 15, N'I Don''t Remember Eating That!', N'A Lot'),
+		(43, 15, N'Holy S*** I Filled The Bowl', N'A Lot'),
+		(44, 16, N'Type 1) Separate Hard Lumps Like Nuts (Hard To Pass)', NULL),
+		(45, 16, N'Type 2) Sausage-Shaped But Lumpy', NULL),
+		(46, 16, N'Type 3) Like A Sausage But With Cracks On The Surface', NULL),
+		(47, 16, N'Type 4) Like A Sausage Or Snake, Smooth And Soft', NULL),
+		(48, 16, N'Type 5) Soft Blobs With Clear-Cut Edges', NULL),
+		(49, 16, N'Type 6) Fluffy Pieces With Ragged Edges, A Mushy Stool', NULL),
+		(50, 16, N'Type 7) Watery, No Solid Pieces (Entirely Liquid)', NULL),
+		(51, 18, N'Church House Creeper', N'Mild Flatulence'),
+		(52, 18, N'Farticles', N'Mild Flatulence'),
+		(53, 18, N'Wasn''t Me!', N'Mild Flatulence'),
+		(54, 18, N'Scared The Animals', N'Mild Flatulence'),
+		(55, 18, N'Made Daddy Proud', N'Mild Flatulence'),
+		(57, 18, N'Holy S***, What Was That!!', N'Mild Flatulence'),
+		(58, 18, N'HorrendASS', N'Mild Flatulence'),
+		(59, 18, N'Bloated And Painful', NULL),
+		(60, 20, N'A Little', NULL),
+		(61, 20, N'A Lot', NULL),
+		(62, 20, N'Wardrobe Change', N'A Lot'),
+		(63, 20, N'Bad Grandpa', N'A Lot'),
+		(64, 22, N'1', NULL),
+		(65, 22, N'2', NULL),
+		(66, 22, N'3', NULL),
+		(67, 23, N'1', NULL),
+		(68, 23, N'2', NULL),
+		(69, 23, N'3', NULL),
+		(70, 26, N'1', NULL),
+		(71, 26, N'2', NULL),
+		(72, 26, N'3', NULL),
+		(73, 27, N'1', NULL),
+		(74, 27, N'2', NULL),
+		(75, 27, N'3', NULL),
+		(76, 29, N'10mg Famotidine', NULL),
+		(77, 29, N'Other', NULL),
+		(78, 31, N'4mg/10ml Liquid', NULL),
+		(80, 31, N'Other', NULL),
+		(81, 33, N'20mg', NULL),
+		(82, 33, N'Other', NULL),
+		(83, 34, N'Crushed And Mixed With Applesauce', NULL),
+		(84, 34, N'Other', NULL),
+		(85, 36, N'Ondansetron 4mg ODT', NULL),
+		(86, 36, N'Other', NULL),
+		(87, 38, N'.125mg ODT', NULL),
+		(88, 38, N'Other', NULL)
 ) 
 AS Source (Id, ControlId, Name, FunnyName) 
 ON Target.Id = Source.Id 

SET IDENTITY_INSERT [Control] ON;
MERGE INTO [Control] AS Target 
USING (VALUES 
        (1, 2, 1, 'Detail', null),
		(2, 2, 2, 'Comments', null),
		(3, 3, 1, 'Detail', null),
		(4, 3, 2, 'Comments', null),
		(5, 4, 1, 'Detail', null),
		(6, 4, 2, 'Comments', null),
		(7, 5, 1, 'Detail', null),
		(8, 5, 2, 'Comments', null),
		(9, 6, 1, 'Detail', null),
		(10, 6, 2, 'Comments', null),
		(11, 7, 1, 'Detail', null),
		(12, 9, 3, 'Amount', null),
		(13, 9, 3, 'Hydration', null),
		(14, 9, 2, 'Comments', null),
		(15, 10, 3, 'Amount', null),
		(16, 10, 3, 'Type', null),
		(17, 10, 2, 'Comments', null),
		(18, 12, 3, 'Type', null),
		(19, 12, 2, 'Comments', null),
		(20, 13, 3, 'Amount', null),
		(21, 13, 2, 'Comments', null)
) 
AS Source (Id, ItemId, ControlTypeId, Name, FunnyName) 
ON Target.Id = Source.Id 

SET IDENTITY_INSERT Item ON;
MERGE INTO Item AS Target 
USING (VALUES 
		(1, NULL, N'Vomiting/Regurgitation', NULL, 1),
		(7, NULL, N'Queasy', NULL, 2),
		(8, NULL, N'Potty Talk', NULL, 3),
		(9, 8, N'Shi Shi', N'Urination', 1),
		(10, 8, N'Shit', N'Poop', 2),
		(11, 8, N'Fart Chart', N'Flatulence', 3),
		(12, 11, N'I Think I Farted', N'Gassy', 1),
		(13, 11, N'Shart (Poop Fart)', N'Flatulence With Defecation', 1),
		(14, NULL, N'Medication', NULL, 4),
		(15, 14, N'Over-The-Counter Meds', NULL, 1),
		(16, 15, N'Tums', NULL, 1),
		(17, 15, N'Gas-X', NULL, 2),
		(18, 15, N'Ibuprofen', NULL, 3),
		(19, 15, N'Acetaminophen', NULL, 4),
		(20, 15, N'Lactaid', NULL, 5),
		(21, 15, N'Other', NULL, 6),
		(22, 14, N'Prescription Meds', NULL, 2),
		(23, 22, N'Pepcid Complete', NULL, 1),
		(24, 22, N'Cyproheptadine Hcl', NULL, 2),
		(25, 22, N'Amitriptyline', NULL, 3),
		(26, 22, N'Zofran', NULL, 4),
		(27, 22, N'Hyoscyamine', NULL, 5),
		(28, 22, N'Miralax', NULL, 6),
		(29, 22, N'Other', NULL, 7)
) 
AS Source (Id, ParentId, Name, FunnyName, SortOrder) 
ON Target.Id = Source.Id 
