2BFHHUTG

1CREATE DATABASE IF NOT EXISTS `comp6210_assn2`;
2USE `comp6210_assn2`;
3
4DROP TABLE IF EXISTS `appointments`;
5CREATE TABLE `appointments` (
6  `ID` int(11) NOT NULL AUTO_INCREMENT,
7  `FNAME` varchar(255) NOT NULL,
8  `LNAME` varchar(255) NOT NULL,
9  `TIME` double NOT NULL,
10  `DATE` date(11) NOT NULL,
11  PRIMARY KEY (`ID`)
12);
13
14INSERT INTO `appointments` (`ID` `FNAME`, `LNAME`, `TIME`, `DATE`) VALUES
15(1, `LeBron` `James`, 12:45, `13th April`),
16(2, `Damian` `Lillard`, 2:30, `16th April`),
17(3, `Kyrie` `Irving`, 10:45, `17th April`),
18(4, `Kevin` `Durant`, 4:20, `18th April`);
19(5, `Kawhi` `Leonard`, 5:15, `18th April`);
20(6, `Russell` `Westbrook`, 10:30, `19th April`);
21(7, `James` `Harden`, 11:15, `19th April`);
22(8, `Giannis` `Antetokounmpo`, 1:00, `19th April`);
23(9, `Anthony` `Davis`, 2:30, `19th April`);
24(10, `Chris` `Paul`, 3:30, `20th April`);