 Target Server Version : 50621
 File Encoding         : 65001
 
-Date: 2014-11-21 03:56:18
+Date: 2014-11-26 13:32:59
 */
 
 SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
DROP TABLE IF EXISTS `project_coordinator`;
CREATE TABLE `project_coordinator` (
  `username` char(20) NOT NULL,
  `password` varchar(45) DEFAULT NULL,
  `pc_id` int(20) NOT NULL,
  `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;

-- ----------------------------
-- Records of project_coordinator

-- ----------------------------
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;

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