 -- ----------------------------
 DROP TABLE IF EXISTS `project_coordinator`;
 CREATE TABLE `project_coordinator` (
-  `username` char(20) NOT NULL,
+  `username` char(20) DEFAULT NULL,
   `password` varchar(45) DEFAULT NULL,
-  `pc_id` int(20) NOT NULL,
+  `pc_id` int(20) NOT NULL AUTO_INCREMENT,
   `title` varchar(45) DEFAULT NULL,
   `first_name` varchar(45) DEFAULT NULL,
   `last_name` varchar(45) DEFAULT NULL,
   `email` varchar(45) DEFAULT NULL,
   PRIMARY KEY (`pc_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
 
 -- ----------------------------
 -- Records of project_coordinator

-- ----------------------------
DROP TABLE IF EXISTS `first_inspection`;
CREATE TABLE `first_inspection` (
  `student_id` int(20) NOT NULL,
  `inspector_id` int(20) DEFAULT NULL,
  `module_id` int(20) DEFAULT NULL,
  `date` datetime(6) DEFAULT NULL,
  `first_inspectioncol` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `student_id` int(20) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `project_title` varchar(45) DEFAULT NULL,
  `project_description` varchar(255) DEFAULT NULL,
  `supervisor` varchar(45) DEFAULT NULL,
