CREATE TABLE IF NOT EXISTS `form_ped_GI` (

`id` bigint(20) NOT NULL auto_increment,
`date` datetime default NULL,
`pid` bigint(20) default NULL,
`user` varchar(255) default NULL,
`groupname` varchar(255) default NULL,
`authorized` tinyint(4) default NULL,
`activity` tinyint(4) default NULL,
`diarrhea` VARCHAR (255) default NULL,
`with_every_bowel_movement` VARCHAR (255) default NULL,
`after_every_meal` VARCHAR (255) default NULL,
`blood_or_mucus_in_stool` VARCHAR (255) default NULL,
`diarrhea_onset` VARCHAR (255) default NULL,
`worms` VARCHAR (255) default NULL,
`vomits` VARCHAR (255) default NULL,
`duration` VARCHAR (255) default NULL,
`projectile` VARCHAR (255) default NULL,
`more_often_than_2_hours` VARCHAR (255) default NULL,
`vomit_after_every_meal` VARCHAR (255) default NULL,
`blood_in_vomitus` VARCHAR (255) default NULL,
`taking_medication` VARCHAR (255) default NULL,
`oral_rehydration` VARCHAR (255) default NULL,
`eating_solid_food` VARCHAR (255) default NULL,
`fever` VARCHAR (255) default NULL,
`pain` VARCHAR (255) default NULL,
`lethargy` VARCHAR (255) default NULL,
`oral_hydration_capable` VARCHAR (255) default NULL,
`urine_output_last_6_hours` VARCHAR (255) default NULL,
`pain_with_urination` VARCHAR (255) default NULL,
`cough_or_breathing_difficulty` VARCHAR (255) default NULL,
`able_to_sleep` VARCHAR (255) default NULL,
`nasal_discharge` VARCHAR (255) default NULL,
`previous_hospitalization` VARCHAR (255) default NULL,
`siblings_affected` VARCHAR (255) default NULL,
`immunization_up_to_date` VARCHAR (255) default NULL,
`notes` VARCHAR (255) default NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB;
