text: -- phpMyAdmin SQL Dump
  -- version 5.1.0
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Jun 24, 2021 at 02:48 PM
  -- Server version: 10.4.19-MariaDB
  -- PHP Version: 7.3.28
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  START TRANSACTION;
  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 utf8mb4 */;
  
  --
  -- Database: `myhmsdb`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admintb`
  --
  
  CREATE TABLE `admintb` (
    `username` varchar(50) NOT NULL,
    `password` varchar(30) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `admintb`
  --
  
  INSERT INTO `admintb` (`username`, `password`) VALUES
  ('admin', 'admin123');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `appointmenttb`
  --
  
  CREATE TABLE `appointmenttb` (
    `pid` int(11) NOT NULL,
    `ID` int(11) NOT NULL,
    `fname` varchar(20) NOT NULL,
    `lname` varchar(20) NOT NULL,
    `gender` varchar(10) NOT NULL,
    `email` varchar(30) NOT NULL,
    `contact` varchar(10) NOT NULL,
    `doctor` varchar(30) NOT NULL,
    `docFees` int(5) NOT NULL,
    `appdate` date NOT NULL,
    `apptime` time NOT NULL,
    `userStatus` int(5) NOT NULL,
    `doctorStatus` int(5) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `appointmenttb`
  --
  
  INSERT INTO `appointmenttb` (`pid`, `ID`, `fname`, `lname`, `gender`, `email`, `contact`, `doctor`, `docFees`, `appdate`, `apptime`, `userStatus`, `doctorStatus`) VALUES
  (4, 1, 'Kishan', 'Lal', 'Male', 'kishansmart0@gmail.com', '8838489464', 'Ganesh', 550, '2020-02-14', '10:00:00', 1, 0),
  (4, 2, 'Kishan', 'Lal', 'Male', 'kishansmart0@gmail.com', '8838489464', 'Dinesh', 700, '2020-02-28', '10:00:00', 0, 1),
  (4, 3, 'Kishan', 'Lal', 'Male', 'kishansmart0@gmail.com', '8838489464', 'Amit', 1000, '2020-02-19', '03:00:00', 0, 1),
  (11, 4, 'Shraddha', 'Kapoor', 'Female', 'shraddha@gmail.com', '9768946252', 'ashok', 500, '2020-02-29', '20:00:00', 1, 1),
  (4, 5, 'Kishan', 'Lal', 'Male', 'kishansmart0@gmail.com', '8838489464', 'Dinesh', 700, '2020-02-28', '12:00:00', 1, 1),
  (4, 6, 'Kishan', 'Lal', 'Male', 'kishansmart0@gmail.com', '8838489464', 'Ganesh', 550, '2020-02-26', '15:00:00', 0, 1),
  (2, 8, 'Alia', 'Bhatt', 'Female', 'alia@gmail.com', '8976897689', 'Ganesh', 550, '2020-03-21', '10:00:00', 1, 1),
  (5, 9, 'Gautam', 'Shankararam', 'Male', 'gautam@gmail.com', '9070897653', 'Ganesh', 550, '2020-03-19', '20:00:00', 1, 0),
  (4, 10, 'Kishan', 'Lal', 'Male', 'kishansmart0@gmail.com', '8838489464', 'Ganesh', 550, '0000-00-00', '14:00:00', 1, 0),
  (4, 11, 'Kishan', 'Lal', 'Male', 'kishansmart0@gmail.com', '8838489464', 'Dinesh', 700, '2020-03-27', '15:00:00', 1, 1),
  (9, 12, 'William', 'Blake', 'Male', 'william@gmail.com', '8683619153', 'Kumar', 800, '2020-03-26', '12:00:00', 1, 1),
  (9, 13, 'William', 'Blake', 'Male', 'william@gmail.com', '8683619153', 'Tiwary', 450, '2020-03-26', '14:00:00', 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `contact`
  --
  
  CREATE TABLE `contact` (
    `name` varchar(30) NOT NULL,
    `email` text NOT NULL,
    `contact` varchar(10) NOT NULL,
    `message` varchar(200) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `contact`
  --
  
  INSERT INTO `contact` (`name`, `email`, `contact`, `message`) VALUES
  ('Anu', 'anu@gmail.com', '7896677554', 'Hey Admin'),
  (' Viki', 'viki@gmail.com', '9899778865', 'Good Job, Pal'),
  ('Ananya', 'ananya@gmail.com', '9997888879', 'How can I reach you?'),
  ('Aakash', 'aakash@gmail.com', '8788979967', 'Love your site'),
  ('Mani', 'mani@gmail.com', '8977768978', 'Want some coffee?'),
  ('Karthick', 'karthi@gmail.com', '9898989898', 'Good service'),
  ('Abbis', 'abbis@gmail.com', '8979776868', 'Love your service'),
  ('Asiq', 'asiq@gmail.com', '9087897564', 'Love your service. Thank you!'),
  ('Jane', 'jane@gmail.com', '7869869757', 'I love your service!');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `doctb`
  --
  
  CREATE TABLE `doctb` (
    `username` varchar(50) NOT NULL,
    `gender` varchar(10) NOT NULL,
    `password` varchar(50) NOT NULL,
    `email` varchar(50) NOT NULL,
    `spec` varchar(50) NOT NULL,
    `docFees` bigint(10) NOT NULL,
    `lat` float NOT NULL,
    `lng` float NOT NULL,
    `docContact` bigint(20) NOT NULL,
    `docAddress` varchar(100) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `doctb`
  --
  
  INSERT INTO `doctb` (`username`, `gender`, `password`, `email`, `spec`, `docFees`, `lat`, `lng`, `docContact`, `docAddress`) VALUES
  ('ashok', 'Male', 'ashok123', 'ashok@gmail.com', 'General', 500, 15.5645, 120.423, 9123456789, 'Manila'),
  ('arun', 'Male', 'arun123', 'arun@gmail.com', 'Cardiologist', 600, 13.9833, 120.857, 8123456789, 'Tondo'),
  ('Dinesh', 'Male', 'dinesh123', 'dinesh@gmail.com', 'General', 700, 14.6012, 121.011, 2882223223, 'Zambales'),
  ('Ganesh', 'Male', 'ganesh123', 'ganesh@gmail.com', 'Pediatrician', 550, 14.3601, 120.961, 7123456789, 'Clark'),
  ('Kumar', 'Male', 'kumar123', 'kumar@gmail.com', 'Pediatrician', 800, 14.9323, 120.107, 19123456789, 'Pampanga'),
  ('Amit', 'Female', 'amit123', 'amit@gmail.com', 'Cardiologist', 1000, 14.0516, 121.514, 39123456789, 'Clark City'),
  ('Abbis', 'Female', 'abbis123', 'abbis@gmail.com', 'Neurologist', 1500, 14.6249, 120.541, 19123456789, 'Clark Avenue'),
  ('Tiwary', 'Female', 'tiwary123', 'tiwary@gmail.com', 'Pediatrician', 450, 13.135, 123.668, 33123456789, 'Clark New York');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `patreg`
  --
  
  CREATE TABLE `patreg` (
    `pid` int(11) NOT NULL,
    `fname` varchar(20) NOT NULL,
    `lname` varchar(20) NOT NULL,
    `gender` varchar(10) NOT NULL,
    `email` varchar(30) NOT NULL,
    `contact` varchar(30) NOT NULL,
    `password` varchar(30) NOT NULL,
    `cpassword` varchar(30) NOT NULL,
    `lat` float NOT NULL,
    `lng` float NOT NULL,
    `patAddress` varchar(100) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `patreg`
  --
  
  INSERT INTO `patreg` (`pid`, `fname`, `lname`, `gender`, `email`, `contact`, `password`, `cpassword`, `lat`, `lng`, `patAddress`) VALUES
  (1, 'Ram', 'Kumar', 'Male', 'ram@gmail.com', '9876543210', 'ram123', 'ram123', 14.0008, 120.857, 'Germany'),
  (2, 'Alia', 'Bhatt', 'Female', 'alia@gmail.com', '8976897689', 'alia123', 'alia123', 14.0886, 121.148, 'Germany'),
  (3, 'Shahrukh', 'khan', 'Male', 'shahrukh@gmail.com', '8976898463', 'shahrukh123', 'shahrukh123', 14.232, 120.769, 'Germany'),
  (4, 'Kishan', 'Lal', 'Male', 'kishansmart0@gmail.com', '8838489464', 'kishan123', 'kishan123', 14.2872, 120.978, 'Germany'),
  (5, 'Gautam', 'Shankararam', 'Male', 'gautam@gmail.com', '9070897653', 'gautam123', 'gautam123', 14.0831, 121.651, 'Germany'),
  (6, 'Sushant', 'Singh', 'Male', 'sushant@gmail.com', '9059986865', 'sushant123', 'sushant123', 14.4668, 120.543, 'Germany'),
  (7, 'Nancy', 'Deborah', 'Female', 'nancy@gmail.com', '9128972454', 'nancy123', 'nancy123', 14.7659, 121.013, 'Germany'),
  (8, 'Kenny', 'Sebastian', 'Male', 'kenny@gmail.com', '9809879868', 'kenny123', 'kenny123', 14.5173, 121.252, 'Germany'),
  (9, 'William', 'Blake', 'Male', 'william@gmail.com', '8683619153', 'william123', 'william123', 14.8513, 120.361, 'Germany'),
  (10, 'Peter', 'Norvig', 'Male', 'peter@gmail.com', '9609362815', 'peter123', 'peter123', 14.0333, 120.889, 'Germany'),
  (11, 'Shraddha', 'Kapoor', 'Female', 'shraddha@gmail.com', '9768946252', 'shraddha123', 'shraddha123', 15.4185, 120.579, 'Germany');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `prestb`
  --
  
  CREATE TABLE `prestb` (
    `doctor` varchar(50) NOT NULL,
    `pid` int(11) NOT NULL,
    `ID` int(11) NOT NULL,
    `fname` varchar(50) NOT NULL,
    `lname` varchar(50) NOT NULL,
    `appdate` date NOT NULL,
    `apptime` time NOT NULL,
    `disease` varchar(250) NOT NULL,
    `allergy` varchar(250) NOT NULL,
    `prescription` varchar(1000) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `prestb`
  --
  
  INSERT INTO `prestb` (`doctor`, `pid`, `ID`, `fname`, `lname`, `appdate`, `apptime`, `disease`, `allergy`, `prescription`) VALUES
  ('Dinesh', 4, 11, 'Kishan', 'Lal', '2020-03-27', '15:00:00', 'Cough', 'Nothing', 'Just take a teaspoon of Benadryl every night'),
  ('Ganesh', 2, 8, 'Alia', 'Bhatt', '2020-03-21', '10:00:00', 'Severe Fever', 'Nothing', 'Take bed rest'),
  ('Kumar', 9, 12, 'William', 'Blake', '2020-03-26', '12:00:00', 'Sever fever', 'nothing', 'Paracetamol -> 1 every morning and night'),
  ('Tiwary', 9, 13, 'William', 'Blake', '2020-03-26', '14:00:00', 'Cough', 'Skin dryness', 'Intake fruits with more water content');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `appointmenttb`
  --
  ALTER TABLE `appointmenttb`
    ADD PRIMARY KEY (`ID`);
  
  --
  -- Indexes for table `patreg`
  --
  ALTER TABLE `patreg`
    ADD PRIMARY KEY (`pid`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `appointmenttb`
  --
  ALTER TABLE `appointmenttb`
    MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  
  --
  -- AUTO_INCREMENT for table `patreg`
  --
  ALTER TABLE `patreg`
    MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  COMMIT;
   
  /*!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 */;
  