 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 ALTER TABLE `medical_procedure_types` ADD UNIQUE (`name`);
+
 --
 -- Dumping data for table `medical_procedure_types`
 --
 
 INSERT INTO `medical_procedure_types` (`id`, `name`, `description`, `date_modified`, `date_created`, `slug`, `status`) VALUES
-(1, 'testtype', 'sdf sdf sdf sdfsd f', '2012-08-07 02:05:43', '2012-08-06 16:00:00', '', 1);
+(1, 'testtype', 'sdf sdf sdf sdfsd f', '2012-08-07 02:05:43', '2012-08-06 16:00:00', '', 1),
+(2, 'testType2', 'sfd dff sdaf sadf sdfsd fsdaf sdf', '2012-08-09 00:56:01', '2012-08-08 16:00:00', '', 1),
+(3, 'testInactiveType1', 'sdf sdf sdaf sadfsa fsd sdf sdf', '2012-08-09 00:56:01', '2012-08-08 16:00:00', '', 0);
 
 -- --------------------------------------------------------
 

--

INSERT INTO `medical_centers` (`id`, `name`, `description`, `date_created`, `slug`, `status`) VALUES
(1, 'AddedFromTest Center', 'the quick brown fox jump over the lazy dog. hahaha asdflk jsdlfj ksald;kfj asldkfjsa;l kads fjdl;fj lkdsf', '2012-08-07 07:32:23', '', 1);

-- --------------------------------------------------------


  KEY `medical_procedure_id` (`medical_procedure_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `institution_medical_procedures`
--

INSERT INTO `institution_medical_procedures` (`id`, `institution_id`, `medical_procedure_id`, `description`, `date_modified`, `date_created`, `slug`, `status`) VALUES
(1, 1, 1, 'test for active procedureType1', '2012-08-09 01:28:55', '2012-08-08 16:00:00', '', 1);

-- --------------------------------------------------------

--
