CREATE TABLE `tracker` (
`PkEcode` int(4) NOT NULL DEFAULT '0',
`Date_txt` date NOT NULL DEFAULT '0000-00-00',
`Team` varchar(30) NOT NULL DEFAULT '',
`CourseCode` varchar(30) NOT NULL DEFAULT '',
`Activity` varchar(100) NOT NULL DEFAULT '',
`Slides` int(5) NOT NULL DEFAULT '0',
`Time` decimal(5,2) DEFAULT NULL,
`Recordcount` int(12) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`Recordcount`)) TYPE=MyISAM AUTO_INCREMENT=165 ;
INSERT INTO `tracker` VALUES (4001, '2004-06-22', 'Audio', 'Project-1', 'Audio Editing', 12, '7.00', 145);
INSERT INTO `tracker` VALUES (4002, '2004-06-22', 'Audio', 'Project-1', 'Audio Editing', 12, '8.00', 146);
INSERT INTO `tracker` VALUES (4002, '2004-06-24', 'Audio', 'Project-1', 'Audio Cutting', 34, '10.00', 147);
INSERT INTO `tracker` VALUES (4003, '2004-06-22', 'Development', 'Project-1', 'Animation', 15, '8.00', 148);
INSERT INTO `tracker` VALUES (4004, '2004-06-24', 'Development', 'Project-1', 'Animation', 15, '8.00', 149);
INSERT INTO `tracker` VALUES (4005, '2004-06-22', 'QC', 'Project-1','QC-Level1', 24, '4.00', 154);
INSERT INTO `tracker` VALUES (4006, '2004-06-24', 'QC', 'Project-1','QC-Level2', 24, '4.00', 155);