-- phpMyAdmin SQL Dump
-- version 2.11.8.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 26, 2012 at 06:39 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `health`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(150) NOT NULL,
  `pwd` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `user`, `pwd`, `email`) VALUES
(1, 'admin', 'admin', 'ananth9948@gmail.com');

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

--
-- Table structure for table `ask_expert`
--

CREATE TABLE IF NOT EXISTS `ask_expert` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(300) NOT NULL,
  `speciality` int(11) NOT NULL,
  `doctor` int(11) NOT NULL,
  `mobile` varchar(300) NOT NULL,
  `email` varchar(300) NOT NULL,
  `file` varchar(300) NOT NULL,
  `address` text NOT NULL,
  `message` text NOT NULL,
  `created_date` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `ask_expert`
--

INSERT INTO `ask_expert` (`id`, `name`, `speciality`, `doctor`, `mobile`, `email`, `file`, `address`, `message`, `created_date`) VALUES
(3, 'admin', 1, 1, '8886100026', 'ananth9948@gmail.com', 'uploads/files/5475email-templates.rtf', 'test', 'testing', '2012-04-26 11:00:20');

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

--
-- Table structure for table `banners`
--

CREATE TABLE IF NOT EXISTS `banners` (
  `id` int(11) NOT NULL auto_increment,
  `image` varchar(250) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `image`, `status`) VALUES
(3, 'uploads/banners/8834image1.jpg', 1),
(2, 'uploads/banners/1446image2.jpg', 1),
(4, 'uploads/banners/8573image5.jpg', 1),
(5, 'uploads/banners/1589image6.jpg', 1),
(6, 'uploads/banners/5511image3.jpg', 1),
(7, 'uploads/banners/1516image4.jpg', 1);

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

--
-- Table structure for table `book_lab`
--

CREATE TABLE IF NOT EXISTS `book_lab` (
  `id` int(11) NOT NULL auto_increment,
  `city` int(11) NOT NULL,
  `area` int(11) NOT NULL,
  `test_type` int(11) NOT NULL,
  `diagnostic` int(11) NOT NULL,
  `name` varchar(300) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `email` varchar(250) NOT NULL,
  `book_time` time NOT NULL,
  `book_date` date NOT NULL,
  `address` text NOT NULL,
  `description` text NOT NULL,
  `created_date` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `book_lab`
--


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

--
-- Table structure for table `city`
--

CREATE TABLE IF NOT EXISTS `city` (
  `id` int(11) NOT NULL auto_increment,
  `state` int(11) NOT NULL,
  `name` varchar(300) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `city`
--


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

--
-- Table structure for table `content`
--

CREATE TABLE IF NOT EXISTS `content` (
  `id` int(11) NOT NULL auto_increment,
  `content` text NOT NULL,
  `status` int(11) NOT NULL,
  `title` varchar(300) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `content`
--

INSERT INTO `content` (`id`, `content`, `status`, `title`) VALUES
(1, '<p>\r\n	about us about us</p>\r\n', 1, 'About Us'),
(2, '<p>\r\n	careers careers</p>\r\n', 0, 'Careers'),
(3, '<p>\r\n	Corporate Plans</p>\r\n', 1, 'Corporate Plans'),
(4, '<p>\r\n	Terms &amp; Conditions</p>\r\n', 1, 'Terms & Conditions'),
(5, '<p>\r\n	24x7healthprotect is a Pro-Preventive healthcare and health management Organization which focuses on Pro-preventive health management and health care and works on Patient-centric healthcare Model. Healthcare reform means moving from a provider-centric to a patient-centric model of care.<br />\r\n	<br />\r\n	<b>&quot;The focus will now be on value, efficiency and safety. Put another way &ndash; it&#39;s about the patient.&quot;</b> Healthcare being the buzz around for past few years and has been one of the most concerned area around the world. With rising healthcare costs and rising number of health problems it becomes very important for an effective pro-preventive management.</p>\r\n', 1, 'Why Us');

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

--
-- Table structure for table `doctor_details`
--

CREATE TABLE IF NOT EXISTS `doctor_details` (
  `id` int(11) NOT NULL auto_increment,
  `usertype` varchar(50) NOT NULL,
  `name` varchar(300) NOT NULL,
  `email` varchar(250) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `pwd` varchar(25) NOT NULL,
  `registration_id` varchar(25) NOT NULL,
  `branch` varchar(150) NOT NULL,
  `city` int(11) NOT NULL,
  `area` int(11) NOT NULL,
  `photo` varchar(300) NOT NULL,
  `profile` varchar(300) NOT NULL,
  `membership` varchar(250) NOT NULL,
  `created_date` date NOT NULL,
  `created_time` time NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `registration_id` (`registration_id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `doctor_details`
--


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

--
-- Table structure for table `doctor_experience`
--

CREATE TABLE IF NOT EXISTS `doctor_experience` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `speciality` varchar(300) NOT NULL,
  `secondary_speciality` varchar(300) NOT NULL,
  `working` varchar(300) NOT NULL,
  `employment` varchar(300) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `doctor_experience`
--


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

--
-- Table structure for table `doctor_personal`
--

CREATE TABLE IF NOT EXISTS `doctor_personal` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `address1` varchar(300) NOT NULL,
  `address2` varchar(300) NOT NULL,
  `work` varchar(50) NOT NULL,
  `state` varchar(300) NOT NULL,
  `city` varchar(300) NOT NULL,
  `country` varchar(300) NOT NULL,
  `practice_year` int(11) NOT NULL,
  `fulltime` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `doctor_personal`
--


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

--
-- Table structure for table `doctor_qualifications`
--

CREATE TABLE IF NOT EXISTS `doctor_qualifications` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `qualification` varchar(300) NOT NULL,
  `college` varchar(250) NOT NULL,
  `passing_year` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `doctor_qualifications`
--


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

--
-- Table structure for table `doctor_timings`
--

CREATE TABLE IF NOT EXISTS `doctor_timings` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `sun` varchar(150) NOT NULL,
  `mon` varchar(150) NOT NULL,
  `tue` varchar(150) NOT NULL,
  `wed` varchar(150) NOT NULL,
  `thu` varchar(150) NOT NULL,
  `fri` varchar(150) NOT NULL,
  `sat` varchar(150) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `doctor_timings`
--


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

--
-- Table structure for table `dynamic_fields`
--

CREATE TABLE IF NOT EXISTS `dynamic_fields` (
  `id` int(11) NOT NULL auto_increment,
  `field_name` int(11) NOT NULL,
  `field_value` varchar(300) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `dynamic_fields`
--

INSERT INTO `dynamic_fields` (`id`, `field_name`, `field_value`, `status`) VALUES
(2, 1, 'Biochemistry', 1),
(3, 1, 'X-RAY', 1),
(4, 1, 'Blood', 1),
(5, 2, 'Cordiologist', 1);

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

--
-- Table structure for table `fields`
--

CREATE TABLE IF NOT EXISTS `fields` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(300) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `fields`
--

INSERT INTO `fields` (`id`, `name`, `status`) VALUES
(1, 'Types of Test', 1),
(2, 'Speciality', 1);

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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL auto_increment,
  `content` text NOT NULL,
  `date_created` datetime NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `content`, `date_created`, `status`) VALUES
(3, 'Accidents are a part of life, especially when children are growing up. Make sure you know what do when the unexpected happens. In this section you''ll find advice on nosebleeds, heart attacks, carbon monoxide poisoning and more. Accidents are a part of life, especially when children are growing up', '2012-04-12 14:19:41', 1);

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

--
-- Table structure for table `patient_allergy`
--

CREATE TABLE IF NOT EXISTS `patient_allergy` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `allery` varchar(300) NOT NULL,
  `allery_type` varchar(300) NOT NULL,
  `reaction` varchar(300) NOT NULL,
  `identify_date` date NOT NULL,
  `severity` varchar(300) NOT NULL,
  `reason` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `patient_allergy`
--


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

--
-- Table structure for table `patient_complication`
--

CREATE TABLE IF NOT EXISTS `patient_complication` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `complications` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `patient_complication`
--


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

--
-- Table structure for table `patient_demographics`
--

CREATE TABLE IF NOT EXISTS `patient_demographics` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(20) NOT NULL,
  `firstname` varchar(200) NOT NULL,
  `lastname` varchar(200) NOT NULL,
  `middlename` varchar(200) NOT NULL,
  `address1` varchar(300) NOT NULL,
  `address2` varchar(300) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `zip` varchar(50) NOT NULL,
  `dob` date NOT NULL,
  `state` varchar(300) NOT NULL,
  `city` varchar(300) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `patient_demographics`
--


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

--
-- Table structure for table `patient_details`
--

CREATE TABLE IF NOT EXISTS `patient_details` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(250) NOT NULL,
  `pwd` varchar(50) NOT NULL,
  `membership` varchar(300) NOT NULL,
  `created_date` datetime NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `patient_details`
--


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

--
-- Table structure for table `patient_family`
--

CREATE TABLE IF NOT EXISTS `patient_family` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `diagnosis` varchar(100) NOT NULL,
  `self` varchar(50) NOT NULL,
  `father` varchar(50) NOT NULL,
  `mother` varchar(50) NOT NULL,
  `sister` varchar(50) NOT NULL,
  `brother` varchar(50) NOT NULL,
  `other` varchar(50) NOT NULL,
  `comment` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `patient_family`
--


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

--
-- Table structure for table `patient_hospitalizations`
--

CREATE TABLE IF NOT EXISTS `patient_hospitalizations` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `admission_date` date NOT NULL,
  `dicharge_date` date NOT NULL,
  `reason` text NOT NULL,
  `summery` varchar(300) NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `patient_hospitalizations`
--


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

--
-- Table structure for table `patient_insurance`
--

CREATE TABLE IF NOT EXISTS `patient_insurance` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `policy_no` varchar(150) NOT NULL,
  `policy_holder` varchar(300) NOT NULL,
  `policy_start` date NOT NULL,
  `policy_end` date NOT NULL,
  `sum_insured` varchar(300) NOT NULL,
  `claims` varchar(300) NOT NULL,
  `alert` varchar(50) NOT NULL,
  `provider_id` varchar(150) NOT NULL,
  `primary_insurance` varchar(300) NOT NULL,
  `secondary_insurance` varchar(300) NOT NULL,
  `insurance_plan` varchar(300) NOT NULL,
  `insurance_agent` varchar(300) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `patient_insurance`
--


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

--
-- Table structure for table `patient_medical`
--

CREATE TABLE IF NOT EXISTS `patient_medical` (
  `id` int(11) NOT NULL auto_increment,
  `useid` int(11) NOT NULL,
  `medical_history` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `patient_medical`
--


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

--
-- Table structure for table `patient_social`
--

CREATE TABLE IF NOT EXISTS `patient_social` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `firstname` varchar(200) NOT NULL,
  `lastname` varchar(200) NOT NULL,
  `martial` varchar(200) NOT NULL,
  `occupation` varchar(300) NOT NULL,
  `alcohol_use` varchar(50) NOT NULL,
  `alcohol_amount` varchar(100) NOT NULL,
  `lastdrink` date NOT NULL,
  `exercise` varchar(50) NOT NULL,
  `exercise_type` varchar(200) NOT NULL,
  `exercise_time` varchar(100) NOT NULL,
  `smoke_use` varchar(50) NOT NULL,
  `smoke_type` varchar(200) NOT NULL,
  `smoke_pack` varchar(80) NOT NULL,
  `smoke_year` date NOT NULL,
  `smoke_quit` date NOT NULL,
  `drugs_use` varchar(50) NOT NULL,
  `sleep_patter` varchar(50) NOT NULL,
  `other_info` varchar(300) NOT NULL,
  `children` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `patient_social`
--


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

--
-- Table structure for table `patient_status`
--

CREATE TABLE IF NOT EXISTS `patient_status` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `desease` varchar(300) NOT NULL,
  `diabete_type` varchar(300) NOT NULL,
  `insulin` varchar(300) NOT NULL,
  `diagnose_year` int(11) NOT NULL,
  `physician` varchar(300) NOT NULL,
  `doctors` varchar(300) NOT NULL,
  `intensive` varchar(50) NOT NULL,
  `pregnant` varchar(50) NOT NULL,
  `month` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `patient_status`
--


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

--
-- Table structure for table `service_offers`
--

CREATE TABLE IF NOT EXISTS `service_offers` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(300) NOT NULL,
  `content` text NOT NULL,
  `image` varchar(250) NOT NULL,
  `status` int(11) NOT NULL,
  `date_created` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `service_offers`
--

INSERT INTO `service_offers` (`id`, `title`, `content`, `image`, `status`, `date_created`) VALUES
(5, 'Insane Art', 'Accidents are a part of life, especially when children are growing up. Make sure you know what do when the unexpected happens. In this section you''ll find advice on nosebleeds, heart attacks, carbon monoxide poisoning and more. Accidents are a part of life, especially when children are growing up', 'uploads/services/59391.jpg', 1, '2012-04-12 15:08:53'),
(4, 'Prime Time', 'Accidents are a part of life, especially when children are growing up. Make sure you know what do when the unexpected happens. In this section you''ll find advice on nosebleeds, heart attacks, carbon monoxide poisoning and more. Accidents are a part of life, especially when children are growing up', 'uploads/services/46476.jpg', 1, '2012-04-12 15:08:42');

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

--
-- Table structure for table `state`
--

CREATE TABLE IF NOT EXISTS `state` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(300) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `state`
--


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

--
-- Table structure for table `upload_resume`
--

CREATE TABLE IF NOT EXISTS `upload_resume` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(300) NOT NULL,
  `email` varchar(300) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `dob` date NOT NULL,
  `address` text NOT NULL,
  `experience` varchar(50) NOT NULL,
  `resume` varchar(300) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `upload_resume`
--

INSERT INTO `upload_resume` (`id`, `name`, `email`, `mobile`, `dob`, `address`, `experience`, `resume`, `status`) VALUES
(3, 'Anantha Reddy V', 'ananth9948@gmail.com', '8886100026', '2004-02-04', 'sr nagar', '3', 'uploads/resumes/1923email-templates.rtf', 1);