 -- ----------------------------
 DROP TABLE IF EXISTS `first_inspection`;
 CREATE TABLE `first_inspection` (
-  `student_id` int(20) NOT NULL,
+  `first_inspection_id` int(20) NOT NULL AUTO_INCREMENT,
+  `student_id` int(20) DEFAULT '0',
   `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`)
+  PRIMARY KEY (`first_inspection_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- ----------------------------

-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `course_id` int(20) NOT NULL,
  `course_name` varchar(45) DEFAULT NULL,
  `course_description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of course

-- ----------------------------
DROP TABLE IF EXISTS `second_inspection`;
CREATE TABLE `second_inspection` (
  `second_inspection_id` int(20) NOT NULL AUTO_INCREMENT,
  `student_id` int(20) DEFAULT NULL,
  `inspector_id` int(20) DEFAULT NULL,
  `modeule_id` int(20) DEFAULT NULL,
  `date` datetime(6) DEFAULT NULL,
  `second_inspectioncol` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`second_inspection_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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