CREATE TABLE `CLIENT` (
  `ClientID` int(11) NOT NULL,
  `ClientName` varchar(100) NOT NULL,
  `Age` int(11) NOT NULL,
  `PostCode` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `CLIENT` (`ClientID`, `ClientName`, `Age`, `PostCode`) VALUES
(1, 'John Dlamini', 15, '0140'),
(2, 'Leo Sithole', 22, '1240'),
(3, 'Steve Jacobs', 21, '0125'),
(4, 'Pat Khumalo', 23, '1251'),
(5, 'Sipho Nkosi', 14, '1240'),
(6, 'Musi Mahlangu', 38, '0120'),
(7, 'Sibongile Ngcobo', 25, '1240'),
(8, 'Lindewe Khoza', 18, '1500'),
(9, 'Johannes Botha', 33, '1600'),
(10, 'Bongani Radebe', 32, '1500'),
(11, 'Caleb Pillay', 31, '1600'),
(12, 'Anna Mthembu', 45, '0180'),
(13, 'Thabo Baloyi', 37, '0158'),
(14, 'Mpho Sithole', 14, '1250'),
(15, 'Peter Zwane', 30, '1240'),
(16, 'Maria Nkosi', 21, '0152'),
(17, 'Samuel Naidoo', 16, '1600'),
(18, 'Patricia Williams', 17, '0120'),
(19, 'Joseph Mkhize', 31, '0140'),
(20, 'Zenele Ndlovu', 42, '0140'),
(21, 'Daniel Dlamini', 45, '1500'),
(22, 'Jabu Chauke', 35, '1600'),
(23, 'Willem du Plessis', 23, '1600'),
(24, 'Jan Venter', 31, '1250'),
(25, 'Linda Gumede', 13, '0180'),
(26, 'Zandile Methembu', 22, '1600'),
(27, 'Robert Maseko', 16, '1250'),
(28, 'Cynthia Fourie', 18, '1500'),
(29, 'Nomsa Baloyi', 14, '1240'),
(30, 'Bongiwe Mokoena', 25, '0160'),
(31, 'Al Naidoo', 23, '0127'),
(32, 'Phindile Ntuli', 15, '0180'),
(33, 'Bianca Abrahams', 22, '0160'),
(34, 'Freddy Chetty', 17, '0160'),
(35, 'Moses Sibisi', 31, '0121'),
(36, 'Vusi Khumalo', 13, '1240'),
(37, 'Hendrick van Zyl', 27, '0180'),
(38, 'Lucky Shabangu', 16, '0123');

CREATE TABLE `COUNSELLOR` (
  `CounsellorID` int(11) NOT NULL,
  `CounsellorName` varchar(100) NOT NULL,
  `Rate` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `COUNSELLOR` (`CounsellorID`, `CounsellorName`, `Rate`) VALUES
(1, 'Vernon Booysen', 150),
(2, 'Matthew Kunene', 180),
(3, 'Heather Modise', 150),
(4, 'Siyanda Mabuza', 120),
(5, 'Joshua Hendricks', 120),
(6, 'Thabo Matlala', 150),
(7, 'Michael Mabasa', 180),
(8, 'Sibu Ndou', 140),
(9, 'Xolani Nzimande', 150),
(10, 'Linda September', 120),
(11, 'Patrick Ntuli', 0);

CREATE TABLE `APPOINTMENT` (
  `AppointmentID` int(11) NOT NULL,
  `ClientID` int(11) NOT NULL,
  `CounsellorID` int(11) NOT NULL,
  `AppointmentDate` date NOT NULL,
  `Location` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `APPOINTMENT` (`AppointmentID`, `ClientID`, `CounsellorID`, `AppointmentDate`, `Location`) VALUES
(1, 1, 2, '2020-10-14', 'Bergsig'),
(2, 3, 2, '2020-10-14', 'Bergsig'),
(3, 11, 2, '2020-10-14', 'Bergsig'),
(4, 34, 2, '2020-10-14', 'Bergsig'),
(5, 2, 5, '2020-10-14', 'Greenside'),
(6, 5, 5, '2020-10-14', 'Greenside'),
(7, 24, 5, '2020-10-14', 'Greenside'),
(8, 29, 5, '2020-10-14', 'Greenside'),
(9, 36, 5, '2020-10-14', 'Greenside'),
(10, 19, 1, '2020-10-15', 'Bergsig'),
(11, 37, 1, '2020-10-15', 'Bergsig'),
(12, 38, 1, '2020-10-15', 'Bergsig'),
(13, 12, 2, '2020-10-15', 'Bergsig'),
(14, 18, 2, '2020-10-15', 'Bergsig'),
(15, 34, 2, '2020-10-15', 'Bergsig'),
(16, 4, 7, '2020-10-15', 'Greenside'),
(17, 15, 7, '2020-10-15', 'Greenside'),
(18, 27, 7, '2020-10-15', 'Greenside'),
(19, 20, 2, '2020-10-16', 'Bergsig'),
(20, 33, 2, '2020-10-16', 'Bergsig'),
(21, 35, 2, '2020-10-16', 'Bergsig'),
(22, 8, 4, '2020-10-16', 'Panorama'),
(23, 2, 5, '2020-10-16', 'Greenside'),
(24, 25, 2, '2020-10-19', 'Bergsig'),
(25, 30, 2, '2020-10-19', 'Bergsig'),
(26, 1, 2, '2020-10-20', 'Bergsig'),
(27, 12, 2, '2020-10-20', 'Bergsig'),
(28, 18, 2, '2020-10-20', 'Bergsig'),
(29, 8, 4, '2020-10-20', 'Panorama'),
(30, 17, 4, '2020-10-20', 'Panorama'),
(31, 23, 4, '2020-10-20', 'Panorama'),
(32, 24, 4, '2020-10-20', 'Panorama'),
(33, 24, 5, '2020-10-20', 'Greenside'),
(34, 29, 5, '2020-10-20', 'Greenside'),
(35, 14, 6, '2020-10-20', 'Greenside'),
(36, 4, 7, '2020-10-20', 'Greenside'),
(37, 1, 1, '2020-10-21', 'Bergsig'),
(38, 3, 1, '2020-10-21', 'Bergsig'),
(39, 6, 1, '2020-10-21', 'Bergsig'),
(40, 12, 1, '2020-10-21', 'Bergsig'),
(41, 19, 1, '2020-10-21', 'Bergsig'),
(42, 9, 8, '2020-10-22', 'Panorama'),
(43, 19, 1, '2020-10-23', 'Bergsig'),
(44, 25, 2, '2020-10-23', 'Bergsig'),
(45, 30, 2, '2020-10-23', 'Bergsig'),
(46, 8, 4, '2020-10-23', 'Panorama'),
(47, 22, 4, '2020-10-23', 'Panorama'),
(48, 9, 8, '2020-10-23', 'Panorama'),
(49, 21, 8, '2020-10-23', 'Panorama'),
(50, 28, 8, '2020-10-23', 'Panorama'),
(51, 18, 2, '2020-10-26', 'Bergsig'),
(52, 30, 2, '2020-10-26', 'Bergsig'),
(53, 8, 4, '2020-10-26', 'Panorama'),
(54, 17, 4, '2020-10-26', 'Panorama'),
(55, 2, 5, '2020-10-26', 'Greenside'),
(56, 24, 5, '2020-10-26', 'Greenside'),
(57, 29, 5, '2020-10-26', 'Greenside'),
(58, 4, 7, '2020-10-26', 'Greenside'),
(59, 15, 7, '2020-10-26', 'Greenside'),
(60, 27, 7, '2020-10-26', 'Greenside'),
(61, 10, 10, '2020-10-26', 'Panorama'),
(62, 22, 10, '2020-10-26', 'Panorama'),
(63, 6, 1, '2020-10-27', 'Bergsig'),
(64, 12, 1, '2020-10-27', 'Bergsig'),
(65, 19, 1, '2020-10-27', 'Bergsig'),
(66, 32, 1, '2020-10-27', 'Bergsig'),
(67, 1, 3, '2020-10-27', 'Bergsig'),
(68, 31, 3, '2020-10-27', 'Bergsig'),
(69, 14, 6, '2020-10-27', 'Greenside'),
(70, 29, 6, '2020-10-27', 'Greenside'),
(71, 4, 7, '2020-10-27', 'Greenside'),
(72, 15, 7, '2020-10-27', 'Greenside'),
(73, 21, 8, '2020-10-27', 'Panorama'),
(74, 10, 10, '2020-10-27', 'Panorama'),
(75, 22, 10, '2020-10-27', 'Panorama'),
(76, 31, 3, '2020-10-28', 'Bergsig');

ALTER TABLE `APPOINTMENT` ADD PRIMARY KEY (`AppointmentID`);
ALTER TABLE `CLIENT` ADD PRIMARY KEY (`ClientID`);
ALTER TABLE `COUNSELLOR` ADD PRIMARY KEY (`CounsellorID`);

ALTER TABLE `APPOINTMENT`
  MODIFY `AppointmentID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;
ALTER TABLE `CLIENT`
  MODIFY `ClientID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
ALTER TABLE `COUNSELLOR`
  MODIFY `CounsellorID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;