health_guide.sql

-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 28, 2015 at 01:12 PM
-- Server version: 5.6.20
-- PHP Version: 5.5.15

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `health_guide`
--

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

--
-- Table structure for table `about`
--

CREATE TABLE IF NOT EXISTS `about` (
  `disease_name` varchar(40) NOT NULL,
  `about_disease` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`disease_name`, `about_disease`) VALUES
('asthma', 'Asthma is a disease affecting the airways that carry air to and from your lungs. People who suffer from this chronic condition [long-lasting or recurrent] are said to be asthmatic.\r\nThe inside walls of an asthmatic''s airways are swollen or inflamed. This swelling or inflammation makes the airways extremely sensitive to irritations and increases your susceptibility to an allergic reaction.\r\nAs inflammation causes the airways to become narrower, less air can pass through them, both to and from the lungs. Symptoms of the narrowing include wheezing [a hissing sound while breathing], chest tightness, breathing problems, and coughing. Asthmatics usually experience these symptoms most frequently during the night and the early morning.'),
('cholera', 'Cholera is an acute intestinal infection caused by ingestion of food or water contaminated with the bacterium Vibrio cholerae. It has a short incubation period, from less than one day to five days, and produces an enterotoxin that causes a copious, painless, watery diarrhoea that can quickly lead to severe dehydration and death if treatment is not promptly given. Vomiting also occurs in most patients.'),
('diabetes', 'Diabetes, often referred to by doctors as diabetes mellitus, describes a group of metabolic diseases in which the person has high blood glucose [blood sugar], either because insulin production is inadequate, or because the body''s cells do not respond properly to insulin, or both. Patients with high blood sugar will typically experience polyuria [frequent urination], they will become increasingly thirsty [polydipsia] and hungry [polyphagia].'),
('epilepsy', 'Epilepsy is a group of related disorders characterized by a tendency for recurrent seizures. There are different types of epilepsy and seizures. Epilepsy drugs are prescribed to control seizures, and rarely surgery is necessary if medications are ineffective.'),
('flu', 'The common cold, including chest cold and head cold, and seasonal flu are caused by viruses. Use over-the-counter cold medications to relieve symptoms including sore throat, runny nose, congestion, and cough. Flu symptoms are similar, but include fever, headache and muscle soreness. See a doctor who may prescribe antiviral medications Relenza or Tamiflu.'),
('jaundice', 'Jaundice, also known as icterus, is a term used to describe a yellowish tinge to the skin and sclerae [the white part of the eye] that is caused by hyperbilirubinemia [an excess of bilirubin in the blood]. Body fluids may also be yellow. The color of the skin and sclerae varies depending on levels of bilirubin; mildly elevated levels display yellow skin and sclerae, while highly elevated levels display brown'),
('malaria', 'Malaria is caused by a parasite called Plasmodium, which is transmitted via the bites of infected mosquitoes. In the human body, the parasites multiply in the liver, and then infect red blood cells.\r\n\r\nSymptoms of malaria include fever, headache, and vomiting, and usually appear between 10 and 15 days after the mosquito bite. If not treated, malaria can quickly become life-threatening by disrupting the blood supply to vital organs. In many parts of the world, the parasites have developed resistance to a number of malaria medicines.\r\n\r\nKey interventions to control malaria include: prompt and effective treatment with artemisinin-based combination therapies; use of insecticidal nets by people at risk; and indoor residual spraying with insecticide to control the vector mosquitoes.'),
('pnuemonia', 'Pneumonia is an infection of the lung that can be caused by nearly any class of organism known to cause human infections. These include bacteria, amoebae, viruses, fungi, and parasites. In the United States, pneumonia is the sixth most common disease leading to death; 2 million Americans develop pneumonia each year, and 40,000-70,000 die from it. Pneumonia is also the most common fatal infection acquired by already hospitalized patients. In developing countries, pneumonia ties with diarrhea as the most common cause of death. Even in nonfatal cases, pneumonia is a significant economic burden on the health care system. One study estimates that people in the American workforce who develop pneumonia cost employers five times as much in health care as the average worker.'),
('smallpox', 'Smallpox is a contagious, disfiguring and often deadly disease that has affected humans for thousands of years. Naturally occurring smallpox was eradicated worldwide by 1980 the result of an unprecedented global immunization campaign.\r\n\r\nSamples of smallpox virus have been kept for research purposes. This has led to concerns that smallpox could someday be used as a biological warfare agent.\r\n\r\nNo cure or treatment for smallpox exists. A vaccine can prevent smallpox, but the risk of the vaccine''s side effects is too high to justify routine vaccination for people at low risk of exposure to the smallpox virus.'),
('tubeculosis', 'Tuberculosis, or TB, is an infectious bacterial disease caused by Mycobacterium tuberculosis, which most commonly affects the lungs. It is transmitted from person to person via droplets from the throat and lungs of people with the active respiratory disease.\r\n\r\nIn healthy people, infection with Mycobacterium tuberculosis often causes no symptoms, since the person''s immune system acts to ?wall off? the bacteria. The symptoms of active TB of the lung are coughing, sometimes with sputum or blood, chest pains, weakness, weight loss, fever and night sweats. Tuberculosis is treatable with a six-month course of antibiotics.'),
('typhoid', 'Fever, \r\nHeadache,\r\nWeakness,\r\nfatigue,\r\nDry cough,\r\nLoss of appetite,\r\nAbdominal pain,\r\nDiarrhoea,\r\nconstipation,\r\nRash,\r\nContinuing high fever,\r\nEither diarrhoea,\r\nsevere constipation,\r\nConsiderable weight loss,\r\nExtreme distended abdomen,\r\nBecome delirious,\r\nLie motionless,\r\nexhausted with your eyes half closed');

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

--
-- Table structure for table `asthma`
--

CREATE TABLE IF NOT EXISTS `asthma` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `asthma`
--

INSERT INTO `asthma` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 1),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 1),
('breathingshallow', 0),
('breathingtrouble', 1),
('breathingwheezingsevere', 0),
('breathshort', 2),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 3),
('chestpressure', 2),
('chestspotspink', 0),
('chills', 0),
('cold', 2),
('coma', 0),
('concentrationlack', 0),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 3),
('coughdry', 0),
('coughexercise', 2),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 1),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 0),
('fingernailsblue', 1),
('flu', 1),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 1),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 1),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 1),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 1),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 1),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 1),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 0),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 1),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 1),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 2),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 1),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 1),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `cholera`
--

CREATE TABLE IF NOT EXISTS `cholera` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cholera`
--

INSERT INTO `cholera` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 1),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 0),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 0),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 0),
('cold', 0),
('coma', 1),
('concentrationlack', 0),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 1),
('cough', 0),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 1),
('dehydrationsevere', 1),
('delirium', 0),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 1),
('diarrhoeasudden', 1),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 1),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 1),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 1),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 0),
('heartbeatfast', 0),
('heartbeatrapid', 1),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 1),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 1),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 1),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 1),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 1),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 1),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 1),
('throatsore', 0),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `diabetes`
--

CREATE TABLE IF NOT EXISTS `diabetes` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `diabetes`
--

INSERT INTO `diabetes` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 1),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 0),
('browpain', 0),
('bruiseshealslow', 1),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 0),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 0),
('cold', 0),
('coma', 0),
('concentrationlack', 1),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 0),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 1),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 1),
('erectionsustained', 0),
('erectiontrouble', 1),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 1),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 3),
('fever', 0),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 1),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 0),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 2),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 1),
('irritability', 1),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 1),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 1),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 1),
('skinitchy', 1),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 1),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 1),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 1),
('thirstexcessive', 2),
('thirstunusual', 1),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 0),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 3),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 1),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 2),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 2),
('weightloss', 2),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 2);

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

--
-- Table structure for table `diseases`
--

CREATE TABLE IF NOT EXISTS `diseases` (
  `disease_name` varchar(40) NOT NULL,
  `doc_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `diseases`
--

INSERT INTO `diseases` (`disease_name`, `doc_count`) VALUES
('asthma', 3),
('cholera', 3),
('diabetes', 3),
('epilepsy', 2),
('flu', 2),
('jaundice', 3),
('malaria', 3),
('pnuemonia', 2),
('smallpox', 1),
('tubeculosis', 3),
('typhoid', 3);

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

--
-- Table structure for table `epilepsy`
--

CREATE TABLE IF NOT EXISTS `epilepsy` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `epilepsy`
--

INSERT INTO `epilepsy` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 1),
('armsstiff', 0),
('awarenessloss', 1),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 1),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 0),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 0),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 0),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 1),
('consciousnessloss', 2),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 0),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 0),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 0),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 1),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 0),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 1),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 0),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `flu`
--

CREATE TABLE IF NOT EXISTS `flu` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `flu`
--

INSERT INTO `flu` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 1),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 2),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 1),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 1),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 2),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 1),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 2),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 2),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 0),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 1),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 1),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 2),
('nosestuffy', 2),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 1),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 2),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 1),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `jaundice`
--

CREATE TABLE IF NOT EXISTS `jaundice` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jaundice`
--

INSERT INTO `jaundice` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 0),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 0),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 1),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 0),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 1),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 1),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 0),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 2),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 0),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 1),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 1),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 0),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `malaria`
--

CREATE TABLE IF NOT EXISTS `malaria` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `malaria`
--

INSERT INTO `malaria` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 0),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 0),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 2),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 0),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 2),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 2),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 1),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 1),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 1),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 0),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 1),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `pnuemonia`
--

CREATE TABLE IF NOT EXISTS `pnuemonia` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pnuemonia`
--

INSERT INTO `pnuemonia` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 1),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 1),
('breathingrapid', 0),
('breathingshallow', 1),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 2),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 1),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 2),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 1),
('confusionmental', 1),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 0),
('coughdry', 1),
('coughexercise', 0),
('coughgreen', 2),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 1),
('coughsticky', 1),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 1),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 2),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 2),
('heartbeatfast', 1),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 1),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 1),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 1),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 1),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 1),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 1),
('sick', 0),
('skinclammy', 1),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 1),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 1),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 1),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `rabies`
--

CREATE TABLE IF NOT EXISTS `rabies` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rabies`
--

INSERT INTO `rabies` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 1),
('agitation', 2),
('anxiety', 3),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 1),
('behaviourerratic', 1),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 1),
('biting', 1),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 0),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 0),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 1),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 2),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 0),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 1),
('dentalpain', 0),
('depression', 1),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 1),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 1),
('feetnumb', 0),
('fever', 3),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 1),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 3),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 3),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 1),
('hyperactivity', 1),
('hyperalertness', 1),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 2),
('interestlack', 0),
('irritability', 2),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 1),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 2),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 1),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 1),
('roam', 0),
('salivaexcessive', 1),
('salivaproductionexcessive', 1),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 1),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 1),
('throatmucousdry', 0),
('throatsore', 1),
('tired', 0),
('trembling', 1),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 1),
('vomitingpersistent', 0),
('waterfear', 1),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `sinus`
--

CREATE TABLE IF NOT EXISTS `sinus` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sinus`
--

INSERT INTO `sinus` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 2),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 0),
('browpain', 1),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 1),
('chestfeeltight', 0),
('chestpain', 0),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 0),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 2),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 1),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 0),
('dentalpain', 1),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 1),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 1),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 2),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 1),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 1),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 1),
('nasalblockage', 0),
('nasalcavitypus', 1),
('nasalcongestion', 0),
('nasaldischarge', 1),
('nasalobstruction', 0),
('nasalstuffiness', 1),
('nausea', 0),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 1),
('nosestuffy', 1),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 1),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 1),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 1),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `smallpox`
--

CREATE TABLE IF NOT EXISTS `smallpox` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `smallpox`
--

INSERT INTO `smallpox` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 0),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 0),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 1),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 0),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 1),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 1),
('fingernailsblue', 0),
('flu', 1),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 1),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 1),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 1),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 0),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 1),
('rashpink', 1),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 1),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 0),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `tetanus`
--

CREATE TABLE IF NOT EXISTS `tetanus` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tetanus`
--

INSERT INTO `tetanus` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 1),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 0),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 0),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 1),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 0),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 1),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 1),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 2),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 2),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 2),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 0),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 1),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 1),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 1),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 0),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `tubeculosis`
--

CREATE TABLE IF NOT EXISTS `tubeculosis` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tubeculosis`
--

INSERT INTO `tubeculosis` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 0),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 1),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 2),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 2),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 0),
('convulseviolent', 0),
('convulsions', 0),
('cough', 2),
('coughdry', 0),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 0),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 2),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 0),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 0),
('liemotionless', 0),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 0),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 0),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 0),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 3),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

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

--
-- Table structure for table `typhoid`
--

CREATE TABLE IF NOT EXISTS `typhoid` (
  `SYMPTOM` varchar(50) NOT NULL DEFAULT '',
  `IN_DOCS` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `typhoid`
--

INSERT INTO `typhoid` (`SYMPTOM`, `IN_DOCS`) VALUES
('abdomendistendedextreme', 0),
('abdomenpain', 0),
('abdominalmusclestiff', 0),
('aggressionepisodes', 0),
('agitation', 0),
('anxiety', 0),
('appetiteexcessive', 0),
('appetitepoor', 1),
('armsmovementsuncontrollable', 0),
('armsstiff', 0),
('awarenessloss', 0),
('barkconstant', 0),
('behaviouraggressive', 0),
('behaviourerratic', 0),
('behaviourstrange', 0),
('bite', 0),
('bitepainsite', 0),
('biting', 0),
('blind', 0),
('bloodcoughtinged', 0),
('bloodnasaldischargeblood', 0),
('bloodpressurelow', 0),
('bodyaches', 0),
('bodyspasmspainful', 0),
('bodytemperaturelow', 0),
('breathbad', 0),
('breathingdifficult', 0),
('breathingincrease', 0),
('breathingrapid', 0),
('breathingshallow', 0),
('breathingtrouble', 0),
('breathingwheezingsevere', 0),
('breathshort', 0),
('browpain', 0),
('bruiseshealslow', 0),
('bruisesnotheal', 0),
('cheekspressurebehind', 0),
('chestfeeltight', 0),
('chestpain', 0),
('chestpressure', 0),
('chestspotspink', 0),
('chills', 0),
('cold', 0),
('coma', 0),
('concentrationlack', 0),
('confusion', 0),
('confusionmental', 0),
('confusiontemporary', 0),
('consciousnessloss', 0),
('constipation', 2),
('convulseviolent', 0),
('convulsions', 0),
('cough', 1),
('coughdry', 1),
('coughexercise', 0),
('coughgreen', 0),
('coughlaugh', 0),
('coughnight', 0),
('coughnon-stop', 0),
('coughrusty', 0),
('coughsticky', 0),
('coughthick', 0),
('cutshealslow', 0),
('cutsnotheal', 0),
('dehydrationmild', 0),
('dehydrationsevere', 0),
('delirium', 1),
('delusions', 0),
('dentalpain', 0),
('depression', 0),
('diarrhoeasevere', 0),
('diarrhoeasudden', 0),
('disorientation', 0),
('dizzinesspositionshift', 0),
('drowsinesssevere', 0),
('eatcravinganything', 0),
('energylack', 0),
('erectionsustained', 0),
('erectiontrouble', 0),
('excitementhigh', 0),
('exercisecoughwheezing', 0),
('exerciseweak', 0),
('exercisingtired', 0),
('exhalewheezing', 0),
('exhalewhistling', 0),
('exhaustion', 0),
('eyelidsmucousdry', 0),
('eyesclosedhalf', 0),
('eyespressurebehind', 0),
('eyeswhitesyellow', 0),
('facesweatpale', 0),
('facialcongestion', 0),
('facialpain', 0),
('fatigueextreme', 0),
('fatigueincreased', 0),
('fearno', 0),
('feetnumb', 0),
('fever', 2),
('fingernailsblue', 0),
('flu', 0),
('grinning', 0),
('groinitch', 0),
('grotesque', 0),
('grouchy', 0),
('growlingconstant', 0),
('guminfectionfrequent', 0),
('gumred', 0),
('gumspullaway', 0),
('gumswollen', 0),
('hairstandup', 0),
('hallucinations', 0),
('handnumb', 0),
('handtingle', 0),
('handtingling', 0),
('headache', 2),
('heartbeatfast', 0),
('heartbeatrapid', 0),
('hungerincrease', 0),
('hungerintense', 0),
('hydrophobia', 0),
('hyperactivity', 0),
('hyperalertness', 0),
('ill', 0),
('infectionsfrequent', 0),
('infectionsrecurring', 0),
('insomnia', 0),
('interestlack', 0),
('irritability', 0),
('jawcramp', 0),
('jointpain', 0),
('legsmovementsuncontrollable', 0),
('legsparalysislower', 0),
('legsstiff', 0),
('lethargy', 1),
('liemotionless', 1),
('lightpainbright', 0),
('lipsblue', 0),
('lipscolorblue', 0),
('lipscolorpurple', 0),
('lipsdiscolorationblue', 0),
('lipsdiscolorationpurple', 0),
('lockjaw', 0),
('lungfunctiondecrease', 0),
('malaise', 0),
('mendysfunctionsexual', 0),
('mood', 0),
('mouthblisters', 0),
('mouthdry', 0),
('mouthmucousdry', 0),
('mouthyellowcolor', 0),
('mucousyellow', 0),
('mucuscoughlittle', 0),
('mucusthickgreen', 0),
('mucusthickyellow', 0),
('musclecramps', 0),
('muscleincoordination', 0),
('musclescontractionpainful', 0),
('nailbedsblue', 0),
('nasal', 0),
('nasalblockage', 0),
('nasalcavitypus', 0),
('nasalcongestion', 0),
('nasaldischarge', 0),
('nasalobstruction', 0),
('nasalstuffiness', 0),
('nausea', 0),
('neckstiff', 0),
('necktight', 0),
('nosemucousdry', 0),
('noserunny', 0),
('nosestuffy', 0),
('not', 0),
('nothingstare', 0),
('panic', 0),
('paralysispartial', 0),
('pulserateincrease', 0),
('pupilsdilated', 0),
('rash', 1),
('rashpink', 0),
('rectumbleeding', 0),
('restlessness', 0),
('roam', 0),
('salivaexcessive', 0),
('salivaproductionexcessive', 0),
('sclerabrown', 0),
('sclerayellow', 0),
('seizures', 0),
('sensationtingling', 0),
('sensetingle', 0),
('severewatery', 0),
('shiver', 0),
('sick', 0),
('skinclammy', 0),
('skincoloryellow', 0),
('skindiscolorationyellow', 0),
('skinelasticitylost', 0),
('skininfections', 0),
('skinitchy', 0),
('skinrash', 0),
('skintingeyellow', 0),
('sleepproblems', 0),
('sleeptrouble', 0),
('smelldecrease', 0),
('smellloss', 0),
('sneezingallergies', 0),
('soreshealslow', 0),
('staringspell', 0),
('stomachcramps', 0),
('stomachmuscletight', 0),
('stomachpain', 0),
('stoolscolorclay', 0),
('stoolscolorlight', 0),
('stoolscolorpale', 0),
('swallowproblem', 0),
('sweats', 0),
('symptomspsychic', 0),
('talkdifficult', 0),
('tastedecrease', 0),
('teethachy', 0),
('teethchatter', 0),
('thirst', 0),
('thirstdisproportionate', 0),
('thirstexcessive', 0),
('thirstunusual', 0),
('thrashout', 0),
('throatmucousdry', 0),
('throatsore', 1),
('tired', 0),
('trembling', 0),
('unexplainedpain', 0),
('upseteasily', 0),
('urinationfrequent', 0),
('urinecolordark', 0),
('urinefrequent', 0),
('vaginalinfectionsfrequent', 0),
('vaginalitch', 0),
('visionblurred', 0),
('vomit', 0),
('vomiting', 0),
('vomitingpersistent', 0),
('waterfear', 0),
('weight', 0),
('weightgain', 0),
('weightloss', 1),
('well', 0),
('wheezing', 0),
('woundhealslow', 0),
('yeastinfections', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about`
--
ALTER TABLE `about`
 ADD PRIMARY KEY (`disease_name`);

--
-- Indexes for table `asthma`
--
ALTER TABLE `asthma`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `cholera`
--
ALTER TABLE `cholera`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `diabetes`
--
ALTER TABLE `diabetes`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `diseases`
--
ALTER TABLE `diseases`
 ADD PRIMARY KEY (`disease_name`);

--
-- Indexes for table `epilepsy`
--
ALTER TABLE `epilepsy`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `flu`
--
ALTER TABLE `flu`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `jaundice`
--
ALTER TABLE `jaundice`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `malaria`
--
ALTER TABLE `malaria`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `pnuemonia`
--
ALTER TABLE `pnuemonia`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `rabies`
--
ALTER TABLE `rabies`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `sinus`
--
ALTER TABLE `sinus`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `smallpox`
--
ALTER TABLE `smallpox`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `tetanus`
--
ALTER TABLE `tetanus`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `tubeculosis`
--
ALTER TABLE `tubeculosis`
 ADD PRIMARY KEY (`SYMPTOM`);

--
-- Indexes for table `typhoid`
--
ALTER TABLE `typhoid`
 ADD PRIMARY KEY (`SYMPTOM`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;