
--
-- Table structure for table `team_group_tbl`
--

CREATE TABLE `team_group_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(200) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `team_group_tbl`
--


--
-- Table structure for table `team_tbl`
--

CREATE TABLE `team_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(300) DEFAULT NULL,
  `team_group_id` varchar(20) DEFAULT NULL,
  `image` varchar(400) DEFAULT NULL,
  `short_description` text,
  `description` text,
  `designation` varchar(300) DEFAULT NULL,
  `facebook_link` varchar(500) DEFAULT NULL,
  `experience` varchar(200) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT '1',
  `twitter_link` varchar(500) DEFAULT NULL,
  `instagram_link` varchar(500) DEFAULT NULL,
  `linkedin_link` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `team_tbl`
--


--
-- Table structure for table `technology_tbl`
--

CREATE TABLE `technology_tbl` (
  `technology_id` int(200) NOT NULL AUTO_INCREMENT,
  `technology_name` varchar(500) NOT NULL,
  `technology_detail` varchar(200) NOT NULL,
  `technology_images` varchar(200) NOT NULL,
  PRIMARY KEY (`technology_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `technology_tbl`
--


--
-- Table structure for table `testimonial_tbl`
--

CREATE TABLE `testimonial_tbl` (
  `slno` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '',
  `image` varchar(60) NOT NULL,
  `email` varchar(80) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `addedBy` varchar(10) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  `replyStatus` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial_tbl`
--


--
-- Table structure for table `transplant_result_tbl`
--

CREATE TABLE `transplant_result_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(400) DEFAULT NULL,
  `gallery_order` varchar(300) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transplant_result_tbl`
--


--
-- Table structure for table `video_tbl`
--

CREATE TABLE `video_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slink_title` varchar(700) NOT NULL,
  `slink_url` varchar(800) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `video_tbl`
--

INSERT INTO `video_tbl` VALUES (1,'Online Cream Separator ','');

--
-- Table structure for table `whatsapp_enquiry`
--

CREATE TABLE `whatsapp_enquiry` (
  `en_id` int(11) NOT NULL AUTO_INCREMENT,
  `en_name` varchar(800) DEFAULT NULL,
  `en_mobile` varchar(100) DEFAULT NULL,
  `en_email` varchar(100) DEFAULT NULL,
  `en_country` varchar(100) DEFAULT NULL,
  `en_comment` varchar(900) DEFAULT NULL,
  `en_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `en_url` varchar(500) DEFAULT NULL,
  `locationID` varchar(100) DEFAULT NULL,
  `en_product_name` varchar(300) DEFAULT NULL,
  `en_ip` varchar(300) DEFAULT NULL,
  `en_doc_name` varchar(300) DEFAULT NULL,
  `en_doc_id` varchar(300) DEFAULT NULL,
  `booking_date` varchar(300) DEFAULT NULL,
  `en_time` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`en_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `whatsapp_enquiry`
--



