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

Target Server Version : 50621
File Encoding         : 65001

Date: 2014-11-21 03:56:18
*/

SET FOREIGN_KEY_CHECKS=0;

  `dissertation_deadline` datetime(6) DEFAULT NULL,
  `pc_id` int(20) DEFAULT NULL,
  PRIMARY KEY (`module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26588 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of module
