-- http://www.phpmyadmin.net
--




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

--
-- Table structure for table `assign_appointment`
--

CREATE TABLE IF NOT EXISTS `assign_appointment` (
  `cg_id` int(11) NOT NULL,
  `telecaller` varchar(255) NOT NULL,
  `ass_phlabotomist` varchar(255) NOT NULL,
  `cus_name` varchar(255) NOT NULL,
  `cus_mobile` varchar(25) NOT NULL,
  `date` varchar(30) NOT NULL,
  `time` varchar(50) NOT NULL,
  `cg_status` int(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `assign_appointment`
--

INSERT INTO `assign_appointment` (`cg_id`, `telecaller`, `ass_phlabotomist`, `cus_name`, `cus_mobile`, `date`, `time`, `cg_status`) VALUES
(1, 'Roopa', 'mist', 'rmr', '89364897323', '15/12/2017', '3:00PM', 1);

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

--
-- Table structure for table `beneficery`
--

CREATE TABLE IF NOT EXISTS `beneficery` (
  `ben_id` int(15) NOT NULL,
  `c_id` int(15) NOT NULL,
  `ben_name` varchar(150) NOT NULL,
  `ben_type` varchar(150) NOT NULL,
  `ben_age` int(3) NOT NULL,
  `ben_mail` varchar(150) NOT NULL,
  `ben_ph1` varchar(150) NOT NULL,
  `ben_gen` varchar(150) NOT NULL,
  `ben_package` int(1) DEFAULT NULL,
  `ben_add_package` int(11) NOT NULL,
  `ben_cardicpac` int(1) DEFAULT NULL,
  `ben_test_doc` varchar(150) NOT NULL,
  `doc_id` int(15) NOT NULL,
  `nut_id` int(1) NOT NULL,
  `fit_id` int(1) NOT NULL,
  `ecg_doc` varchar(150) NOT NULL,
  `xray_doc` varchar(150) NOT NULL,
  `echo_doc` varchar(150) NOT NULL,
  `ccscan_doc` varchar(150) NOT NULL,
  `psa_doc` varchar(150) NOT NULL,
  `usa_doc` varchar(150) NOT NULL,
  `mamo_doc` varchar(150) NOT NULL,
  `pap_doc` varchar(150) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `beneficery`
--

INSERT INTO `beneficery` (`ben_id`, `c_id`, `ben_name`, `ben_type`, `ben_age`, `ben_mail`, `ben_ph1`, `ben_gen`, `ben_package`, `ben_add_package`, `ben_cardicpac`, `ben_test_doc`, `doc_id`, `nut_id`, `fit_id`, `ecg_doc`, `xray_doc`, `echo_doc`, `ccscan_doc`, `psa_doc`, `usa_doc`, `mamo_doc`, `pap_doc`) VALUES
(1, 1, 'Niranjan', 'Self', 25, 'niru@gmail.com', '8978979454', 'male', 10, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(2, 2, 'Manoj', 'Self', 27, 'manoj@gmail.com', '9899887232', 'male', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(3, 3, 'hari', 'Self', 25, 'hari@gmail.com', '9874953434', 'male', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(4, 4, 'vinny', 'Self', 26, 'vinny@gmail.com', '9734985734', 'female', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(5, 5, 'manu', 'Self', 0, 'manu@a.com', '8987675645', '0', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(6, 6, 'ajayan', 'Self', 0, 'b@gmail.com', '76765654', '0', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(7, 7, 'Check', 'Self', 26, 'check@gmail.com', '8979217912', 'male', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(8, 7, 'Ramu', 'frnd', 25, 'ramu@gmail.com', '9797998782', 'Male', 4, 0, NULL, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(9, 8, 'krishna', 'Self', 27, 'manoj@techvegas.in', '9182737493', 'male', 10, 0, 0, '4ec2a0a9b898f63d2002974ee4fec9d0.pdf', 15, 62, 64, '', '', '', '', '', '', '', ''),
(10, 9, 'siva', 'Self', 24, 'siva@gmail.com', '9739749332', 'male', 10, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(11, 10, 'Rajesh', 'Self', 34, 'rajesh@gmail.com', '9874953343', 'male', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(12, 11, 'Ravi', 'Self', 26, 'ravi@gmail.com', '9898546954', 'male', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(13, 12, 'kiran', 'Self', 25, 'kiran@gmail.com', '9998822833', 'male', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(14, 13, 'santhosh', 'Self', 26, 'san@gmail.com', '9793729232', 'male', 10, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(15, 14, 'Hari Krishna', 'Self', 26, 'hari@gmail.com', '9879873923', 'male', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', ''),
(16, 15, 'Jan', 'Self', 25, 'jan@gmail.com', '9384793434', 'male', 4, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `doctor`
--

CREATE TABLE IF NOT EXISTS `doctor` (
  `dc_id` int(15) NOT NULL,
  `e_id` int(15) NOT NULL,
  `c_id` int(15) NOT NULL,
  `b_id` int(15) NOT NULL,
  `d_desc` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `doctor`
--

INSERT INTO `doctor` (`dc_id`, `e_id`, `c_id`, `b_id`, `d_desc`) VALUES
(2, 0, 141, 179, '<p>I am done.</p>\n'),
(3, 15, 140, 178, ''),
(4, 15, 8, 9, '<p>good</p>\r\n');

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

--
-- Table structure for table `employees`
--

CREATE TABLE IF NOT EXISTS `employees` (
  `e_id` int(15) NOT NULL,
  `e_type` varchar(150) NOT NULL,
  `e_name` varchar(150) NOT NULL,
  `e_email` varchar(150) NOT NULL,
  `e_mobile` varchar(150) NOT NULL,
  `e_street` varchar(150) NOT NULL,
  `e_city` varchar(150) NOT NULL,
  `e_district` varchar(150) NOT NULL,
  `e_state` varchar(150) NOT NULL,
  `e_pincode` int(6) NOT NULL,
  `e_gender` varchar(150) NOT NULL,
  `e_dob` date NOT NULL,
  `e_photo` varchar(150) NOT NULL,
  `e_status` int(11) NOT NULL,
  `e_delete` int(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`e_id`, `e_type`, `e_name`, `e_email`, `e_mobile`, `e_street`, `e_city`, `e_district`, `e_state`, `e_pincode`, `e_gender`, `e_dob`, `e_photo`, `e_status`, `e_delete`) VALUES
(1, 'Admin', 'Admin', 'admin', '9962163080', '15th, main', 'Bangalore', 'Bangalore', 'Karnataka', 560008, 'male', '2015-07-20', 'APPLE_CRM11.png', 1, 0),
(2, 'Tele Caller', 'karthik', 'karthik', '9962163080', '15th, main', 'Bangalore', 'Bangalore', 'Karnataka', 560008, 'male', '2015-07-15', 'APPLE_CRM2.png', 1, 1),
(3, 'Phlebotomist', 'Phlebotomist1', 'Phlebotomist@gmail.com', '9962163080', '15th, main', 'Bangalore', 'Bangalore', 'Karnataka', 560008, 'male', '2015-07-15', 'APPLE_CRM3.png', 1, 1),
(4, 'Tele Caller', 'Telecaller', 'karthik', '9962163080', '15th, main', 'Bangalore', 'Bangalore', 'Karnataka', 560008, 'male', '2015-07-15', '', 1, 1),
(5, 'Phlebotomist', 'Phlebotomist2', 'sivaanusri2006@gmail.com', '9962163080', '15th, main', 'Bangalore', 'Bangalore', 'Karnataka', 560008, 'female', '2015-07-14', '', 1, 1),
(6, 'Finance', 'Roopa Vinay', 'accounts@appleaday.in', '9008026671', '15th, main', 'Bangalore', 'Bangalore', 'Karnataka', 560008, 'female', '2015-07-22', '', 1, 0),
(7, 'Back Office', 'Narasimha', 'narasimha@appleaday.in', '9008026671', '15th, main', 'Bangalore', 'Bangalore', 'Karnataka', 560038, 'male', '2015-07-15', '', 1, 0),
(10, 'Doctor', 'jinto', 'jintojamesmtm@gmail.com', '8050587717`', 'Indiranagar', 'Bangalore', 'Bangalore', 'karnataka', 560038, 'male', '2015-07-03', '', 1, 1),
(11, 'Phlebotomist', 'Phlebotomist 3', 'plbot3@example.com', '1234567890', 'Indreanagar', 'Bangalore', 'Bangalore', 'Karnataka', 580006, 'male', '2015-08-08', '', 1, 1),
(12, 'Nutrition', 'FARAH', 'nutrition1@gmail.com', '1324567878', '15th, Main', 'Bangalore', 'Bangalore', 'Karnataka', 580006, 'female', '2015-08-18', '', 1, 0),
(13, 'Fitness', 'FARA', 'fitness@appleaday.in', '1324567878', '15th, Main, Indiranagar', 'Bangalore', 'Bangalore', 'Karnataka', 580006, 'male', '2015-08-18', '', 1, 0),
(14, 'Tele Caller', 'jinto james', 'jintojamesmtm@gmail.com', '8050587717', 'Indiranagara', 'Bangalore', 'Bangalore', 'Karnataka', 560038, 'male', '2015-08-13', '', 1, 1),
(15, 'Doctor', 'Sandhya', 'doctor@appleaday.in', '9731207578', '15th, main', 'Bangalore', 'Bangalore', 'Karnataka', 560008, 'male', '2015-08-19', '', 1, 0),
(16, 'Tele Caller', 'kannanA', 'NA', '9008026675', '9TH A MAIN ROAD', 'BANGALORE', 'NA', 'KARNATAKA', 560038, 'male', '2015-08-14', '', 1, 1),
(17, 'Tele Caller', 'Maria Reena', 'reena@appleaday.in', '9008026673', 'R M NAGAR', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'female', '0000-00-00', '', 1, 1),
(18, 'Phlebotomist', 'SHIVAKUMAR', 'siva@gmail.com', '9986890703', 'R T NAGAR', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560032, 'male', '0000-00-00', '', 1, 0),
(19, 'Phlebotomist', 'Madhu', 'gowdamadhu413@gmail.com', '9480889990', 'No.S/O Krishnappa,Biniganavile,Nagamangala', 'Mandya', 'Mysore', 'KARNATAKA', 571802, 'male', '1991-05-22', '', 1, 0),
(20, 'Phlebotomist', 'Raghu Kumara', 'raghukumarr22@gmail.com', '7795996477', 'No.41/3,Thanisandra Main Road,Nr Vidyasagara Bustop,Nagavara', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560077, 'male', '1985-06-24', '', 1, 0),
(21, 'Phlebotomist', 'GURUDEV', 'guru@gmail.com', '9035413345', 'K R PURAM', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560036, 'male', '0000-00-00', '', 1, 1),
(22, 'Phlebotomist', 'RAGHAAVENDRA', 'ragha@gmail.com', '7795141326', 'RAJAJINAGAR', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560010, 'male', '0000-00-00', '', 1, 1),
(23, 'Phlebotomist', 'PANDU', 'pandu@yahoo.com', '9916095969', 'yeshwanthapura', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560022, 'male', '1985-08-05', '', 1, 0),
(24, 'Phlebotomist', 'JEEVAN', 'jeevan@gmail.com', '9481410725', 'KAMAKSHIPALYA', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560040, 'male', '1991-08-29', '', 1, 0),
(25, 'Phlebotomist', 'Prakash', 'prakashgowda75@gmail.com', '9036890130', 'No.303,Gurukrupa,10th Main,7th Cross,NGEF LYT,Nagarabhavi', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560072, 'male', '0000-00-00', '', 1, 0),
(26, 'Phlebotomist', 'NIZAM', 'nizam@gmail.com', '9886072868', 'Shivajinagar', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'male', '0000-00-00', '', 1, 0),
(27, 'Phlebotomist', 'BASAVEGOWDA', 'basava@gmail.com', '9739877839', 'Kumaraswamy LYT', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'male', '1980-02-25', '', 1, 1),
(28, 'Phlebotomist', 'MANJUNATH', 'manju@gmail.com', '8892528933', 'Lingarajapura', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'male', '1990-07-07', '', 1, 0),
(29, 'Phlebotomist', 'Prashanth Kumar', 'prashanthakumara1989@gmail.com', '9844576752', 'S/O Obaiah,Giddapura,Mahadevapura Post,Challakere Taluk,', 'Chithradurga', 'CHITRADURGA', 'KARNATAKA', 577536, 'male', '0000-00-00', '', 1, 0),
(30, 'Phlebotomist', 'Abdul', 'abdul@gmail.com', '9480866470', 'Kudlu Gate', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'male', '1975-09-02', '', 1, 1),
(31, 'Phlebotomist', 'GIRISH', 'girish@gmail.com', '9481774031', 'Bommanalli', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'male', '1975-08-10', '', 1, 1),
(32, 'Phlebotomist', 'jinto vegas', 'mahendran@gmail.com', '9066365867', 'Koramangala', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'male', '1980-04-14', '', 1, 1),
(33, 'Tele Caller', 'Teena', 'teena@gmail.com', '8050587717', 'mattom', 'bangalore', 'karnataka', 'bangalore', 560038, 'female', '2016-01-01', '', 1, 1),
(34, 'Tele Caller', 'manoj', 'manoj@vegasvisualmedia.com', '80505587711', 'indiranagar', 'bangalore', 'bangalore', 'karnataka', 560038, 'male', '2016-01-05', '', 1, 1),
(35, 'Tele Caller', 'teena', 'teena@vegas.com', '8050587717', 'karnataka', 'bangalore', 'mattom', 'thrissur', 560038, 'female', '2016-02-01', '', 1, 1),
(36, 'Finance', 'Roopa', 'accounts@appleaday.in', '9008026673', 'No.449,9th Street,Jogupalya,Ulsoor', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560008, 'female', '0000-00-00', '', 1, 0),
(37, 'Tele Caller', 'Praveen Kumar', 'praveen.sati84@gmail.com', '9036239738', 'No.B25/12,C V Ramana Nagar,DRDO Complex Phase-1', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560093, 'male', '0000-00-00', '', 1, 0),
(38, 'Tele Caller', 'Maria Reena', 'reena@appleaday.in', '9538210513', 'No.22,2nd D Cross,Coconut groove LYT,Sir M V Nagar,R M Nagar', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'female', '0000-00-00', '', 1, 1),
(39, 'Tele Caller', 'Angel', 'thoney08@gmail.com', '9901165487', 'No.760,7th A Main,HRBR LYT,1st Block,Kalyan Nagar', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560043, 'female', '0000-00-00', '', 1, 0),
(40, 'Tele Caller', 'Supriya', 'grincy22@gmail.com', '9945780464', 'No.43,4th Cross,2nd Main,2nd Stage,Gowthamapuram,Ulsoor', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560008, 'female', '0000-00-00', '', 1, 0),
(41, 'Tele Caller', 'Grace Evangeline R', 'graceevangeline21@gmail.com', '9945624835', 'No.457,Ramanna Building,Near Maruthi Bar,Hennur Village,Kalyananagar', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560043, 'female', '0000-00-00', '', 1, 1),
(42, 'Tele Caller', 'Varsha', 'varshaaad@gmail.com', '8553870038', 'No.12/1,Dhoopanahalli,HAL 2nd Stage,Indiaranagar', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560008, 'female', '0000-00-00', '', 1, 0),
(43, 'Tele Caller', 'Jeevitha', 'priyachinu12@gmail.com', '7353470378', 'No.21,E Street,Jayaraj Nagar,Ulsoor', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560008, 'female', '0000-00-00', '', 1, 1),
(44, 'Tele Caller', 'Asha', 'asha33533@gmail.com', '8123340857', 'No.27,LSR Building Transport,2nd Floor,8th Main,Hoysala Nagar,T C Palya Main Road,R M Nagar', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'female', '0000-00-00', '', 1, 1),
(45, 'Tele Caller', 'manu', 'test@gmail.com', '123456789', 'dvcnsduivc', 'nj bmjhb', 'bjb knkj', 'jkb kbnkj', 560008, 'male', '2016-03-01', '', 1, 1),
(46, 'Admin', 'Kannan', 'kannan@appleaday.in', '9008026675', 'Indiranagar 1st Stage', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560038, 'male', '2015-07-11', '', 1, 1),
(47, 'Back Office', 'Maria Reena', 'reena@appleaday.in', '9008026673', 'R M NAGAR', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'female', '2016-05-11', '', 1, 0),
(48, 'Tele Caller', 'Revathi', 'revathi@appleaday.in', '9742953750', 'vivek nagar', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'female', '2016-05-02', '', 1, 1),
(49, 'Tele Caller', 'Rekha', 'rekha@appleaday.in', '9743886976', 'Ejipura', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'female', '2016-05-01', '', 1, 1),
(50, 'Tele Caller', 'Jancy', 'jancy@appleaday.in', '9739466807', 'Koramangala', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560095, 'female', '2016-05-10', '', 1, 1),
(51, 'Back Office', 'Kannan', 'kannan@appleaday.in', '9008026675', 'Indiranagar 1st Stage', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560038, 'male', '2016-05-01', '', 1, 1),
(52, 'Back Office', 'KANNAN', 'kannan@appleaday.in', '9008026675', 'Indiranagar 1st Stage', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560038, 'male', '2016-05-07', '', 1, 0),
(53, 'Tele Caller', 'Geethanjali S', 'geetha.anjali2011@gmail.com', '9632125230', '77,5th Cross,Near Venus Bekary,opp Kalamandir,Marathalkli,', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560037, 'female', '0000-00-00', '', 1, 1),
(54, 'Tele Caller', 'Sharline Sargunaraj', 'sharline.raj@gmail.com', '9741126532', '385,5th Main,NGEF Layout,Sadananda Naga,', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560038, 'female', '0000-00-00', '', 1, 1),
(55, 'Tele Caller', 'Ramya P', 'ramsomnee94@gmail.com', '8722083179', '1/7,Basaveshwara Lane,Kodige Halli,Kadugodi Post,Sadaramangala,', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560066, 'female', '0000-00-00', '', 1, 1),
(56, 'Tele Caller', 'Bhagyalakshmi M V', 'mvb589@gmail.com', '8762412039', '48,Sri Sai Nivas,BEML Layout,8th Main,Basaveshwara Nagar,', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560079, 'female', '0000-00-00', '', 1, 1),
(57, 'Tele Caller', 'Reena', 'reena@appleaday.in', '9008026673', 'R M NAGAR', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'female', '0000-00-00', '', 1, 0),
(58, 'Tele Caller', 'Lavanya', 'lavanya@appleaday.in', '7090006283', 'domlur', 'BANGALORE', 'BANGALORE', 'KARNATAKA', 560016, 'female', '0000-00-00', '', 1, 0),
(59, 'Phlebotomist', 'rakesh', 'rakesh@wayol.fit', '8095450411', 'Indiranagar', 'bengaluru', 'Bengaluru', 'karnataka', 560038, 'male', '1981-10-29', '', 1, 1),
(60, 'Tele Caller', 'Sushma', 'sushma.wayol@gmail.com', '9900060180', '1st cross', 'Bangalore', 'Bangalore', 'Karnataka', 560042, 'female', '1989-04-17', '', 1, 0),
(61, '0', '0', '0', '0', '0', '0', '0', '0', 0, '0', '0000-00-00', '', 1, 1),
(62, 'Nutrition', 'Supraja Reddy', 'supraja@wayol.fit', '9663048978', '26/1, 1st Floor Jalaparamount, 1st Cross, Ulsoor Road', 'BENGALURU', 'BENGALURU', 'Karnataka', 560042, 'female', '1993-09-01', '', 1, 0),
(63, '0', '0', '0', '0', '0', '0', '0', '0', 0, '0', '0000-00-00', '', 1, 1),
(64, 'Fitness', 'Rushita', 'rushita@wayol.fit', '7046862680', '26/1, 1st Floor Jalaparamount, 1st Cross, Ulsoor Road', 'BENGALURU', 'BENGALURU', 'Karnataka', 560042, 'female', '1993-07-08', '', 1, 0),
(65, 'Back Office', 'kunj', 'kunj@wayol.fit', '7736848881', '26/1, 1st Floor Jalaparamount, 1st Cross, Ulsoor Road', 'BENGALURU', 'BENGALURU', 'Karnataka', 560042, 'female', '1991-09-03', '', 1, 0),
(66, 'Finance', 'Pranab', 'pranab@wayol.fit', '9986462292', '26/1, 1st Floor Jalaparamount, 1st Cross, Ulsoor Road', 'BENGALURU', 'BENGALURU', 'Karnataka', 560042, 'male', '1989-06-12', '', 1, 0),
(67, 'Phlebotomist', 'PranabPhlebo', 'pranab.ps@mihtra.com', '9986462292', '26/1, 1st Floor Jalaparamount, 1st Cross, Ulsoor Road', 'Bangalore', 'Bangalore', 'Karnataka', 560042, 'male', '1989-06-12', '', 1, 1),
(68, 'Phlebotomist', 'Phlebo', 'aquib@wayol.fit', '9986462292', '26/1, 1st Floor Jalaparamount, 1st Cross, Ulsoor Road', 'BENGALURU', 'BENGALURU', 'Karnataka', 560042, 'male', '1989-04-17', '', 1, 0),
(69, 'Admin', 'jinto', 'jintojamesmtm@gmail.com', '9986717717', 'kk', 'kk', 'kk', 'kk', 560038, 'male', '2017-11-01', '', 1, 0),
(70, 'Admin', 'Anjan', 'niranjan.edu123@gmail.com', '9182737497', 'Jainagar', 'Bangalore', 'Karnataka', 'Andhra pradesh', 560038, 'male', '1992-07-05', '', 1, 0),
(71, 'Doctor', 'Arun', 'babu.edu123@gmail.com', '9182737493', 'Jai Bheem Nagar', 'bangalore', 'chittoor', 'karnataka', 560038, 'male', '2017-12-01', '', 1, 0),
(72, 'Phlebotomist', 'Vegas', 'babu.edu123@gmail.com', '9834739434', 'Indranagar', 'Bangalore', 'Karnataka', 'Bangalore', 560039, 'male', '2017-12-05', '', 1, 0),
(73, 'Fitness', 'asd', 'niranjan.edu123@gmail.com', '9823749832', 'Hall 2nd stage', 'bangalore', 'Karnataka', 'Karnataka', 560036, 'male', '2017-12-10', '', 1, 1),
(74, 'Nutrition', 'when', 'babu.edu123@gmail.com', '9837498333', 'Indranagar', 'Bangalore', 'karnataka', 'karnataka', 560039, 'male', '2017-12-14', '', 1, 1),
(75, 'Phlebotomist', 'what', 'niranjan.edu123@gmail.com', '8934759834', 'jai', 'bang', 'ksr', 'ksr', 560036, 'male', '2017-12-20', '', 1, 1),
(76, 'Nutrition', 'Employee', 'niru.edu123@gmail.com', '8748954353', 'Indra', 'Bang', 'KSR', 'KSR', 560036, 'male', '2017-12-21', '', 1, 0),
(77, 'Nutrition', 'Emp', 'niru.edu123@gmail.com', '9867856756', 'tin', 'Bang', 'ksr', 'ksr', 560036, 'male', '2017-12-08', '', 1, 1),
(78, 'Phlebotomist', 'user', 'niru.edu123@gmail.com', '7834983324', 'kr puram', 'bang', 'ksr', 'ksr', 560039, 'male', '2017-12-18', '', 1, 0),
(79, 'Phlebotomist', 'Jinto', 'babu.edu123@gmail.com', '8974389574', 'Jai', 'Bang', 'ksr', 'ksr', 560030, 'male', '2017-12-15', '', 1, 0),
(80, 'Phlebotomist', 'vegas', 'vegas@gmail.com', '8979837232', 'hall 2nd stage', 'Bangalore', 'ksr', 'ksr', 560026, 'male', '2017-12-26', '', 1, 0),
(83, 'Phlebotomist', 'techvegas', 'techvegas@gmail.com', '8979873943', 'hall 2nd stage', 'Bangalore', 'karnataka', 'karnataka', 560037, 'male', '2017-12-27', '', 1, 0),
(84, 'Phlebotomist', 'Manoj', 'manoj@gmail.com', '9872893471', 'Indranagar', 'Bangalore', 'Karnataka', 'karnataka', 560008, 'male', '2017-12-29', '', 1, 0),
(85, 'Tele Caller', 'Manoj', 'manoj1@gmail.com', '9732894793', 'Indra', 'Bang', 'Bang', 'karnataka', 560026, 'male', '2018-01-02', '', 1, 1),
(86, 'Tele Caller', 'New Customer', 'customer@gmail.com', '9879837489', 'Indra', 'Bang', 'Bang', 'Karnataka', 560068, 'male', '2018-01-02', '', 1, 0),
(87, 'Phlebotomist', 'Tarak', 'tarak@gmail.com', '9879879433', 'Indra', 'Bang', 'Bang', 'karnataka', 560068, 'male', '2018-01-09', '', 1, 0),
(88, 'Tele Caller', 'Varsha', 'varsha@gmail.com', '9879348534', 'hall', 'Bangalore', 'karnataka', 'karnataka', 560001, 'male', '2018-01-20', '', 1, 0);

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

--
-- Table structure for table `emp_cat`
--

CREATE TABLE IF NOT EXISTS `emp_cat` (
  `e_cat_id` int(15) NOT NULL,
  `cat_name` varchar(150) NOT NULL,
  `cat_type` varchar(150) NOT NULL,
  `cat_status` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `feedback`
--

CREATE TABLE IF NOT EXISTS `feedback` (
  `fb_id` int(15) NOT NULL,
  `time` varchar(150) NOT NULL,
  `date1` date NOT NULL,
  `c_id` int(15) NOT NULL,
  `b_id` varchar(150) NOT NULL,
  `c_fb` text NOT NULL,
  `report_sts` varchar(150) NOT NULL,
  `date2` date NOT NULL,
  `mail_rec` varchar(150) NOT NULL,
  `hard_copy` varchar(150) NOT NULL,
  `del_sts` int(1) NOT NULL,
  `date3` date NOT NULL,
  `tele_cons` varchar(150) NOT NULL,
  `date4` date NOT NULL,
  `followup_calls` varchar(250) NOT NULL,
  `feed_back` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `finance`
--

CREATE TABLE IF NOT EXISTS `finance` (
  `f_id` int(15) NOT NULL,
  `c_id` int(15) NOT NULL,
  `b_id` int(15) NOT NULL,
  `amount` varchar(150) NOT NULL,
  `pay_type` varchar(150) NOT NULL,
  `pay_field1` varchar(150) NOT NULL,
  `pay_field2` varchar(150) NOT NULL,
  `pay_field3` varchar(150) NOT NULL,
  `pay_status` int(1) NOT NULL,
  `f_desc` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `finance`
--

INSERT INTO `finance` (`f_id`, `c_id`, `b_id`, `amount`, `pay_type`, `pay_field1`, `pay_field2`, `pay_field3`, `pay_status`, `f_desc`) VALUES
(4, 1, 1, '1000', 'CASH', '', '', '', 1, 'paid'),
(13, 141, 179, '3990', 'CASH', '', '', '', 1, 'RS 4000 Cash received by Harshita '),
(14, 140, 178, '3990', 'CREDIT/DEBIT CARD', '', '', '', 1, 'paid by card, BD is vinutha '),
(15, 142, 180, '3990', 'CASH', '', '', '', 1, 'Good'),
(16, 8, 9, '9990', 'CASH', '', '', '', 1, 'very good');

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

--
-- Table structure for table `fitness`
--

CREATE TABLE IF NOT EXISTS `fitness` (
  `ft_id` int(15) NOT NULL,
  `e_id` int(15) NOT NULL,
  `c_id` int(15) NOT NULL,
  `b_id` int(15) NOT NULL,
  `ft_desc` text NOT NULL,
  `f_doc` varchar(150) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fitness`
--

INSERT INTO `fitness` (`ft_id`, `e_id`, `c_id`, `b_id`, `ft_desc`, `f_doc`) VALUES
(1, 64, 140, 178, '', ''),
(2, 64, 8, 9, '<p>Normal</p>\r\n', 'License premium.txt');

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

--
-- Table structure for table `lsa`
--

CREATE TABLE IF NOT EXISTS `lsa` (
  `lsa_id` int(15) NOT NULL,
  `cus_id` int(15) NOT NULL,
  `b_id` int(15) NOT NULL,
  `lsa_score` text NOT NULL,
  `bmi` text NOT NULL,
  `bmr` varchar(150) NOT NULL,
  `body_type` text NOT NULL,
  `health_his` text NOT NULL,
  `food_recall` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lsa`
--

INSERT INTO `lsa` (`lsa_id`, `cus_id`, `b_id`, `lsa_score`, `bmi`, `bmr`, `body_type`, `health_his`, `food_recall`) VALUES
(1, 140, 178, '', '', '', '', 'a:32:{i:0;s:3:"yes";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:1:"0";i:5;s:2:"  ";i:6;s:2:"  ";i:7;s:2:"  ";i:8;s:1:"1";i:9;s:2:"  ";i:10;s:2:"  ";i:11;s:2:"  ";i:12;s:1:"0";i:13;s:0:"";i:14;s:0:"";i:15;s:0:"";i:16;s:1:"1";i:17;s:0:"";i:18;s:0:"";i:19;s:0:"";i:20;s:4:"None";i:21;s:4:"None";i:22;s:1:"0";i:23;s:1:"5";i:24;s:2:"10";i:25;s:1:"3";i:26;s:1:"1";i:27;s:1:"2";i:28;s:1:"2";i:29;s:1:"2";i:30;s:3:"Veg";i:31;s:3:"178";}', ''),
(2, 8, 9, 'a:26:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"3";i:4;s:1:"3";i:5;s:1:"2";i:6;s:1:"1";i:7;s:1:"2";i:8;s:1:"3";i:9;s:1:"3";i:10;s:1:"3";i:11;s:1:"3";i:12;s:1:"3";i:13;s:1:"3";i:14;s:1:"3";i:15;s:1:"3";i:16;s:1:"3";i:17;s:1:"3";i:18;s:1:"3";i:19;s:1:"3";i:20;s:1:"3";i:21;s:1:"3";i:22;s:1:"3";i:23;s:1:"3";i:24;s:1:"3";i:25;s:1:"9";}', '', '', '', 'a:32:{i:0;s:2:"no";i:1;s:2:"No";i:2;s:3:"yes";i:3;s:6:"normal";i:4;s:1:"1";i:5;s:5:"  yes";i:6;s:4:"no  ";i:7;s:8:"normal  ";i:8;s:1:"0";i:9;s:4:"no  ";i:10;s:5:"yes  ";i:11;s:8:"normal  ";i:12;s:1:"1";i:13;s:3:"yes";i:14;s:2:"no";i:15;s:6:"normal";i:16;s:1:"0";i:17;s:2:"no";i:18;s:3:"yes";i:19;s:6:"normal";i:20;s:6:"normal";i:21;s:6:"normal";i:22;s:1:"1";i:23;s:3:"5.8";i:24;s:2:"90";i:25;s:2:"no";i:26;s:3:"yes";i:27;s:3:"yes";i:28;s:3:"yes";i:29;s:3:"yes";i:30;s:7:"non-veg";i:31;s:1:"9";}', '');

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

--
-- Table structure for table `not_conv_cust`
--

CREATE TABLE IF NOT EXISTS `not_conv_cust` (
  `c_id` int(11) NOT NULL,
  `c_name` varchar(255) NOT NULL,
  `c_email` varchar(255) NOT NULL,
  `c_mobile` varchar(255) NOT NULL,
  `feedback` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `not_conv_cust`
--

INSERT INTO `not_conv_cust` (`c_id`, `c_name`, `c_email`, `c_mobile`, `feedback`, `status`) VALUES
(1, 'Niranjan', 'niru@gmail.com', '8978979454', 'good', 'Accepted'),
(2, 'Anjan', 'anjan@gmail.com', '9347589734', 'good', 'Declined'),
(3, 'Manoj', 'manoj@gmail.com', '9899887232', 'good', 'Accepted'),
(4, 'teena', 'teena@gmail.com', '9798749534', 'good', 'Declined'),
(5, 'hari', 'hari@gmail.com', '9874953434', 'good', 'Accepted'),
(6, 'vinny', 'vinny@gmail.com', '9734985734', 'good', 'Accepted'),
(7, 'teena', 'teena@tv.in', '87676765', 'hello', 'Declined'),
(8, 'manu', 'manu@a.com', '8987675645', 'good', 'Accepted'),
(9, 'rakesh', 'a@gmail.com', '9080898980', 'next week', 'Declined'),
(10, 'ajayan', 'b@gmail.com', '76765654', 'next month', 'Accepted'),
(11, 'sd', 'ed@gmail.com', '435', 'fb', 'Accepted'),
(12, 'sd', 'sd@gmail.com', '98345435434', 'gud', 'Accepted'),
(13, 'Check', 'check@gmail.com', '8979217912', 'good', 'Accepted'),
(14, 'krishna', 'manoj@techvegas.in', '9182737493', 'good', 'Accepted'),
(15, 'fg', 'er@gmail.com', '5654654654', 'good', 'Accepted'),
(16, 'siva', 'siva@gmail.com', '9739749332', 'good', 'Accepted'),
(17, 'Rajesh', 'rajesh@gmail.com', '9874953343', 'good', 'Accepted'),
(18, 'Ravi', 'ravi@gmail.com', '9898546954', 'good', 'Accepted'),
(19, 'kiran', 'kiran@gmail.com', '9998822833', 'good', 'Accepted'),
(20, 'santhosh', 'san@gmail.com', '9793729232', 'good', 'Accepted'),
(21, 'Hari Krishna', 'hari@gmail.com', '9879873923', 'good', 'Accepted'),
(22, 'Prabhu', 'prabhu@gmail.com', '7983454343', 'not good', 'Declined'),
(23, 'jiya', 'jiya@tv.in', '7878787890', 'vvvv', 'Accepted'),
(24, 'Anj', 'anj@gmail.com', '89738945433', 'good', 'Declined'),
(25, 'Jan', 'jan@gmail.com', '9384793434', 'good', 'Accepted'),
(26, 'df', 'd@gmail.com', 'd', 'cdv', 'Accepted');

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

--
-- Table structure for table `nutrition`
--

CREATE TABLE IF NOT EXISTS `nutrition` (
  `n_id` int(15) NOT NULL,
  `e_id` int(15) NOT NULL,
  `c_id` int(15) NOT NULL,
  `b_id` int(15) NOT NULL,
  `n_desc` text NOT NULL,
  `n_doc` varchar(150) NOT NULL,
  `meal_plan` varchar(255) NOT NULL DEFAULT '0',
  `n_goal` varchar(255) NOT NULL,
  `n_goal_doc` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nutrition`
--

INSERT INTO `nutrition` (`n_id`, `e_id`, `c_id`, `b_id`, `n_desc`, `n_doc`, `meal_plan`, `n_goal`, `n_goal_doc`) VALUES
(1, 60, 1, 1, '', '', '', '', ''),
(2, 62, 8, 9, '<p>good</p>\r\n', 'License premium.txt', 'In Process', 'SET & SHARED', 'License premium.txt');

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

--
-- Table structure for table `packages`
--

CREATE TABLE IF NOT EXISTS `packages` (
  `pac_id` int(15) NOT NULL,
  `pac_name` varchar(150) NOT NULL,
  `pac_tests` text NOT NULL,
  `pac_amount` varchar(150) NOT NULL,
  `pac_status` int(1) NOT NULL,
  `pac_cat` int(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`pac_id`, `pac_name`, `pac_tests`, `pac_amount`, `pac_status`, `pac_cat`) VALUES
(4, 'KYH', '108-Parameters, Doctor Consult', '3990', 1, 1),
(10, 'Mission90', '108, Doctor, Nutrition, Fitness, Food', '9990', 1, 1),
(11, 'Additional Package', 'simple', '3999', 1, 1);

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

--
-- Table structure for table `transaction`
--

CREATE TABLE IF NOT EXISTS `transaction` (
  `t_id` int(15) NOT NULL,
  `c_id` int(15) NOT NULL,
  `b_id` int(15) NOT NULL,
  `plob_id` int(15) NOT NULL,
  `tel_id` int(150) NOT NULL,
  `pay_met` varchar(150) NOT NULL,
  `t_amu` varchar(150) NOT NULL,
  `t_date` varchar(30) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`t_id`, `c_id`, `b_id`, `plob_id`, `tel_id`, `pay_met`, `t_amu`, `t_date`) VALUES
(8, 141, 179, 0, 66, 'CASH', '3990', '30-10-2017'),
(9, 140, 178, 19, 66, 'CREDIT/DEBIT CARD', '3990', '30-10-2017'),
(10, 140, 178, 19, 66, 'CREDIT/DEBIT CARD', '3990', '30-10-2017'),
(11, 142, 180, 19, 6, 'CASH', '3990', '15-12-2017'),
(12, 8, 9, 84, 6, 'CASH', '9990', '09-01-2018');

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

--
-- Table structure for table `zone`
--

CREATE TABLE IF NOT EXISTS `zone` (
  `z_id` int(15) NOT NULL,
  `z_name` varchar(150) NOT NULL,
  `z_areas` text NOT NULL,
  `z_emp` text NOT NULL,
  `z_sts` int(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zone`
--

INSERT INTO `zone` (`z_id`, `z_name`, `z_areas`, `z_emp`, `z_sts`) VALUES
(13, 'NORTH', 'a:12:{i:0;s:1:"1";i:1;s:1:"6";i:2;s:2:"20";i:3;s:2:"57";i:4;s:3:"115";i:5;s:3:"212";i:6;s:3:"220";i:7;s:3:"221";i:8;s:3:"235";i:9;s:3:"236";i:10;s:3:"242";i:11;s:3:"283";}', 'a:2:{i:0;s:2:"18";i:1;s:2:"23";}', 1),
(14, 'EAST', 'a:18:{i:0;s:2:"71";i:1;s:2:"73";i:2;s:2:"81";i:3;s:3:"116";i:4;s:3:"135";i:5;s:3:"143";i:6;s:3:"144";i:7;s:3:"148";i:8;s:3:"149";i:9;s:3:"160";i:10;s:3:"161";i:11;s:3:"162";i:12;s:3:"189";i:13;s:3:"199";i:14;s:3:"229";i:15;s:3:"231";i:16;s:3:"238";i:17;s:3:"285";}', 'a:2:{i:0;s:2:"20";i:1;s:2:"28";}', 1),
(15, 'WEST', 'a:26:{i:0;s:2:"16";i:1;s:2:"17";i:2;s:2:"38";i:3;s:2:"42";i:4;s:2:"47";i:5;s:2:"54";i:6;s:2:"61";i:7;s:2:"70";i:8;s:2:"91";i:9;s:2:"92";i:10;s:3:"120";i:11;s:3:"173";i:12;s:3:"175";i:13;s:3:"178";i:14;s:3:"179";i:15;s:3:"200";i:16;s:3:"201";i:17;s:3:"203";i:18;s:3:"207";i:19;s:3:"211";i:20;s:3:"222";i:21;s:3:"223";i:22;s:3:"224";i:23;s:3:"274";i:24;s:3:"275";i:25;s:3:"280";}', 'a:2:{i:0;s:2:"24";i:1;s:2:"25";}', 1),
(16, 'SOUTH ', 'a:39:{i:0;s:2:"12";i:1;s:2:"19";i:2;s:2:"24";i:3;s:2:"25";i:4;s:2:"37";i:5;s:2:"39";i:6;s:2:"59";i:7;s:2:"60";i:8;s:2:"65";i:9;s:2:"69";i:10;s:2:"77";i:11;s:2:"89";i:12;s:3:"109";i:13;s:3:"112";i:14;s:3:"121";i:15;s:3:"122";i:16;s:3:"131";i:17;s:3:"133";i:18;s:3:"137";i:19;s:3:"151";i:20;s:3:"152";i:21;s:3:"156";i:22;s:3:"164";i:23;s:3:"167";i:24;s:3:"171";i:25;s:3:"186";i:26;s:3:"190";i:27;s:3:"192";i:28;s:3:"213";i:29;s:3:"216";i:30;s:3:"226";i:31;s:3:"243";i:32;s:3:"253";i:33;s:3:"255";i:34;s:3:"276";i:35;s:3:"279";i:36;s:3:"281";i:37;s:3:"288";i:38;s:3:"289";}', 'a:3:{i:0;s:2:"19";i:1;s:2:"27";i:2;s:2:"29";}', 1),
(18, 'CENTRAL 1', 'a:23:{i:0;s:2:"29";i:1;s:2:"35";i:2;s:2:"53";i:3;s:2:"68";i:4;s:2:"82";i:5;s:2:"84";i:6;s:2:"97";i:7;s:3:"105";i:8;s:3:"113";i:9;s:3:"118";i:10;s:3:"119";i:11;s:3:"134";i:12;s:3:"168";i:13;s:3:"176";i:14;s:3:"206";i:15;s:3:"227";i:16;s:3:"239";i:17;s:3:"244";i:18;s:3:"247";i:19;s:3:"248";i:20;s:3:"268";i:21;s:3:"271";i:22;s:3:"286";}', 'a:1:{i:0;s:2:"84";}', 1),
(19, 'E-CITY', 'a:11:{i:0;s:2:"43";i:1;s:2:"52";i:2;s:2:"80";i:3;s:2:"83";i:4;s:2:"99";i:5;s:3:"101";i:6;s:3:"106";i:7;s:3:"159";i:8;s:3:"163";i:9;s:3:"172";i:10;s:3:"240";}', 'a:1:{i:0;s:2:"79";}', 1),
(20, 'CENTRAL 2', 'a:12:{i:0;s:2:"28";i:1;s:2:"79";i:2;s:3:"118";i:3;s:3:"119";i:4;s:3:"159";i:5;s:3:"166";i:6;s:3:"182";i:7;s:3:"198";i:8;s:3:"210";i:9;s:3:"232";i:10;s:3:"277";i:11;s:3:"292";}', 'a:1:{i:0;s:2:"83";}', 1);

--
-- Indexes for table `assign_appointment`
--
ALTER TABLE `assign_appointment`
  ADD PRIMARY KEY (`cg_id`);

--
-- Indexes for table `beneficery`
--
ALTER TABLE `beneficery`
  ADD PRIMARY KEY (`ben_id`);

--
-- Indexes for table `doctor`
--
ALTER TABLE `doctor`
  ADD PRIMARY KEY (`dc_id`);

--
-- Indexes for table `employees`
--
ALTER TABLE `employees`
  ADD PRIMARY KEY (`e_id`);

--
-- Indexes for table `emp_cat`
--
ALTER TABLE `emp_cat`
  ADD PRIMARY KEY (`e_cat_id`);

--
-- Indexes for table `feedback`
--
ALTER TABLE `feedback`
  ADD PRIMARY KEY (`fb_id`);

--
-- Indexes for table `finance`
--
ALTER TABLE `finance`
  ADD PRIMARY KEY (`f_id`);

--
-- Indexes for table `fitness`
--
ALTER TABLE `fitness`
  ADD PRIMARY KEY (`ft_id`);

--
-- Indexes for table `lsa`
--
ALTER TABLE `lsa`
  ADD PRIMARY KEY (`lsa_id`);

--
-- Indexes for table `not_conv_cust`
--
ALTER TABLE `not_conv_cust`
  ADD PRIMARY KEY (`c_id`);

--
-- Indexes for table `nutrition`
--
ALTER TABLE `nutrition`
  ADD PRIMARY KEY (`n_id`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`pac_id`);

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`t_id`);

--
-- Indexes for table `zone`
--
ALTER TABLE `zone`
  ADD PRIMARY KEY (`z_id`);
--
-- AUTO_INCREMENT for table `assign_appointment`
--
ALTER TABLE `assign_appointment`
  MODIFY `cg_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `beneficery`
--
ALTER TABLE `beneficery`
  MODIFY `ben_id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `doctor`
--
ALTER TABLE `doctor`
  MODIFY `dc_id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `e_id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=89;
--
-- AUTO_INCREMENT for table `emp_cat`
--
ALTER TABLE `emp_cat`
  MODIFY `e_cat_id` int(15) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `feedback`
--
ALTER TABLE `feedback`
  MODIFY `fb_id` int(15) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `finance`
--
ALTER TABLE `finance`
  MODIFY `f_id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `fitness`
--
ALTER TABLE `fitness`
  MODIFY `ft_id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `lsa`
--
ALTER TABLE `lsa`
  MODIFY `lsa_id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `not_conv_cust`
--
ALTER TABLE `not_conv_cust`
  MODIFY `c_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `nutrition`
--
ALTER TABLE `nutrition`
  MODIFY `n_id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `pac_id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `t_id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `zone`
--
ALTER TABLE `zone`
  MODIFY `z_id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
