   `lifeguard` tinyint(1) DEFAULT NULL,
   `lts` tinyint(1) DEFAULT NULL,
   `gym` tinyint(1) DEFAULT NULL,
+  `isc` tinyint(1) DEFAULT NULL,
   PRIMARY KEY (ID)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+ALTER TABLE `location`
+  ADD KEY `Location` (`Location`);
 
 INSERT INTO `location` (`ID`, `Location`, `lifeguard`, `lts`, `gym`) VALUES (1, 'None', 1, 1, 1);
 

  PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/* create availability table */
CREATE TABLE `availability` (
  `ID` int(5) NOT NULL,
  `username` varchar(65) NOT NULL,
  `monday` varchar(9) DEFAULT NULL,
  `tuesday` varchar(9) DEFAULT NULL,
  `wednesday` varchar(9) DEFAULT NULL,
  `thursday` varchar(9) DEFAULT NULL,
  `friday` varchar(9) DEFAULT NULL,
  `saturday` varchar(9) DEFAULT NULL,
  `sunday` varchar(9) DEFAULT NULL,
  `department` varchar(9) DEFAULT NULL,
  `location` varchar(65) NOT NULL,
  `weekStarting` date NOT NULL,


ALTER TABLE `lifeguard`
  ADD KEY `staff1` (`staff1`),
  ADD CONSTRAINT `lifeguard_ibfk_1` FOREIGN KEY (`staff1`) REFERENCES `users` (`username`) ON UPDATE CASCADE;
  
/* create table LTS_Shift */
 
