pdF35Up9

1CREATE DATABASE IF NOT EXISTS `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */;
2USE `test`;
3
4-- Dumping structure for table test.booking
5CREATE TABLE IF NOT EXISTS `booking` (
6  `booking_id` int(11) NOT NULL AUTO_INCREMENT,
7  `date` date NOT NULL,
8  `time` time NOT NULL,
9  `doctor_id` int(11) NOT NULL,
10  PRIMARY KEY (`booking_id`)
11) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
12
13-- Dumping data for table test.booking: ~3 rows (approximately)
14DELETE FROM `booking`;
15/*!40000 ALTER TABLE `booking` DISABLE KEYS */;
16INSERT INTO `booking` (`booking_id`, `date`, `time`, `doctor_id`) VALUES
17	(1, '2020-04-27', '18:46:28', 1),
18	(2, '2020-04-27', '18:46:28', 1),
19	(3, '2020-04-26', '10:46:52', 2);
20/*!40000 ALTER TABLE `booking` ENABLE KEYS */;
21
22-- Dumping structure for table test.doctor
23CREATE TABLE IF NOT EXISTS `doctor` (
24  `doctor_id` int(11) NOT NULL,
25  `doctor_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
26  PRIMARY KEY (`doctor_id`)
27) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
28
29-- Dumping data for table test.doctor: ~2 rows (approximately)
30DELETE FROM `doctor`;
31/*!40000 ALTER TABLE `doctor` DISABLE KEYS */;
32INSERT INTO `doctor` (`doctor_id`, `doctor_name`) VALUES
33	(1, 'Sam'),
34	(2, 'Jackson');