   KEY `module_id` (`module_id`),
   CONSTRAINT `student_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`course_id`),
   CONSTRAINT `student_ibfk_2` FOREIGN KEY (`module_id`) REFERENCES `module` (`module_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
 
 -- ----------------------------
 -- Records of student
 -- ----------------------------
-INSERT INTO `student` VALUES ('123456', 'Christopher', 'Wright', 'cxw518@student.bham.ac.uk', null, 'mage Analysis for Angiogenesis', '', null, 'cxw518', '123456', '2', '14', '26587');
-INSERT INTO `student` VALUES ('1488913', 'Chenxin', 'Zhao', 'cxz413@student.bham.ac.uk', null, 'Analysing Algorithms', 'Data structure', null, 'cxz413', '123456', '1', '14', '26587');
+INSERT INTO `student` VALUES ('1', 'Christopher', 'Wright', 'cxw518@student.bham.ac.uk', 'mage Analysis for Angiogenesis', '', null, 'cxw518', '123456', '2', '14', '26587');
+INSERT INTO `student` VALUES ('2', 'Chenxin', 'Zhao', 'cxz413@student.bham.ac.uk', 'Analysing Algorithms', 'Data structure', null, 'cxz413', '123456', '1', '14', '26587');
+INSERT INTO `student` VALUES ('3', null, null, null, null, null, null, 'gd', null, null, null, null);
+INSERT INTO `student` VALUES ('4', null, null, null, null, null, null, 'fgd', null, null, null, null);
+
+-- ----------------------------
+-- Table structure for student_keyword
+-- ----------------------------
+DROP TABLE IF EXISTS `student_keyword`;
+CREATE TABLE `student_keyword` (
+  `student_keyword_id` int(20) NOT NULL,
+  `keyword_id` int(20) DEFAULT NULL,
+  `student_id` int(20) DEFAULT NULL,
+  PRIMARY KEY (`student_keyword_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- ----------------------------
+-- Records of student_keyword
+-- ----------------------------
 
 -- ----------------------------
 -- Table structure for timetable
 -- ----------------------------
 DROP TABLE IF EXISTS `timetable`;
 CREATE TABLE `timetable` (
-  `timetable_id` int(20) NOT NULL,
+  `timetable_id` int(20) NOT NULL AUTO_INCREMENT,
   `slot_id` int(20) DEFAULT NULL,
   PRIMARY KEY (`timetable_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;

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

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