CREATE TABLE `appointments_doctors` (
  `docid` int(11) NOT NULL,
  `name` varchar(35) NOT NULL,
  `regid` varchar(15) NOT NULL,
  `photo` varchar(35) NOT NULL,
  `email` varchar(254) NOT NULL,
  `phone` int(11) NOT NULL,
  `qualifications` varchar(50) NOT NULL,
  `about` varchar(35) NOT NULL,
  `specialities` varchar(50) NOT NULL,
  `department` varchar(50) NOT NULL,
  `fees` double NOT NULL,
  `displayfee` int(11) NOT NULL,
  `slotrange` varchar(50) NOT NULL,
  `slotdurn` int(11) NOT NULL,
  `breakrange` varchar(50) NOT NULL,
  `slotsleft` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;