-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `barber`
--

CREATE TABLE `barber` (
  `id_barber` int(11) NOT NULL,
  `b_name` varchar(100) NOT NULL,
  `b_phone` varchar(40) NOT NULL,
  `b_address` varchar(100) NOT NULL,
  `rate` varchar(10) NOT NULL,
  `photo` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `barber`
--

INSERT INTO `barber` (`id_barber`, `b_name`, `b_phone`, `b_address`, `rate`, `photo`) VALUES
(1, 'Abdul Rahman', '019789456', 'No1 Tingkat 2', '12.00', 'man1.jpg'),
(2, 'Kamaruddin Jani', '0197788444', 'No 25 Blok 3D, Pagar Biru', '10.00', 'man2.jpg');

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

--
-- Table structure for table `booking`
--

CREATE TABLE `booking` (
  `id_booking` int(11) NOT NULL,
  `id_customer` int(11) NOT NULL,
  `id_barber` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `amount` varchar(10) NOT NULL,
  `payment` varchar(40) NOT NULL,
  `status` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `booking`
--

INSERT INTO `booking` (`id_booking`, `id_customer`, `id_barber`, `date`, `time`, `amount`, `payment`, `status`) VALUES
(3, 1, 1, '2023-06-10', '00:29:00', '12.00', 'ONLINE BANKING', 'Pending');

--
-- Indexes for table `barber`
--
ALTER TABLE `barber`
  ADD PRIMARY KEY (`id_barber`);

--
-- Indexes for table `booking`
--
ALTER TABLE `booking`
  ADD PRIMARY KEY (`id_booking`);

--
-- AUTO_INCREMENT for table `barber`
--
ALTER TABLE `barber`
  MODIFY `id_barber` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `booking`
--
ALTER TABLE `booking`
  MODIFY `id_booking` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

