 SET IDENTITY_INSERT Item ON;
 MERGE INTO Item AS Target 
 USING (VALUES 
-        (1, NULL, 'Vomiting/Regurgitation', NULL, 1),
-		(2, 1, 'Little bit of mucus', NULL, 1),
-		(3, 1, 'Lot of mucus', NULL, 2),
-		(4, 1, 'Little bit of food', NULL, 3),
-		(5, 1, 'Lot of food', NULL, 4),
-		(6, 1, 'Dry heaving', NULL, 5),
-		(7, NULL, 'Quesy', NULL, 2),
-		(8, NULL, 'Potty Talk', NULL, 3),
-		(9, 8, 'shi shi', 'Urination', 1),
-		(10, 8, 'shit', 'poop', 2),
-		(11, 8, 'fart chart', 'flatulence', 3),
-		(12, 11, 'I think I farted', 'gassy', 1),
-		(13, 11, 'shart', 'flatulence with defecation', 1)
+		(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 

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')
) 
AS Source (Id, ControlId, Name, FunnyName) 
ON Target.Id = Source.Id 

SET IDENTITY_INSERT [Control] ON;
MERGE INTO [Control] AS Target 
USING (VALUES 
		(1, 1, 3, N'Type', NULL),
		(2, 1, 1, N'Detail', NULL),
		(3, 1, 2, N'Comments', NULL),
		(11, 7, 1, N'Detail', NULL),
		(12, 9, 3, N'Amount', NULL),
		(13, 9, 3, N'Hydration', NULL),
		(14, 9, 2, N'Comments', NULL),
		(15, 10, 3, N'Amount', NULL),
		(16, 10, 3, N'Type', NULL),
		(17, 10, 2, N'Comments', NULL),
		(18, 12, 3, N'Type', NULL),
		(19, 12, 2, N'Comments', NULL),
		(20, 13, 3, N'Amount', NULL),
		(21, 13, 2, N'Comments', NULL),
		(22, 16, 3, N'Quantity', NULL),
		(23, 17, 3, N'Quantity', NULL),
		(24, 18, 2, N'Dosage', NULL),
		(25, 19, 2, N'Dosage', NULL),
		(26, 20, 3, N'Quantity', NULL),
		(27, 21, 3, N'Quantity', NULL),
		(28, 21, 2, N'Dosage', NULL),
		(29, 23, 3, N'Dosage', NULL),
		(30, 23, 2, N'Comments', NULL),
		(31, 24, 3, N'Dosage', NULL),
		(32, 24, 2, N'Comments', NULL),
		(33, 25, 3, N'Dosage', NULL),
		(34, 25, 3, N'Prep', NULL),
		(35, 25, 2, N'Comments', NULL),
		(36, 26, 3, N'Dosage', NULL),
		(37, 26, 2, N'Comments', NULL),
		(38, 27, 3, N'Dosage', NULL),
		(39, 27, 2, N'Comments', NULL),
		(40, 28, 2, N'Dosage', NULL),
		(41, 28, 2, N'Prep', NULL),
		(42, 28, 2, N'Comments', NULL),
		(43, 29, 2, N'Comments', NULL)
) 
AS Source (Id, ItemId, ControlTypeId, Name, FunnyName) 
ON Target.Id = Source.Id 
