CREATE TABLE IF NOT EXISTS `student_fee` ( `fee_id` int(2) NOT NULL AUTO_INCREMENT, `id` int(2) NOT NULL, `dt` date NOT NULL, `amount` int(5) NOT NULL, PRIMARY KEY (`fee_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- Dumping data for table `student_fee` -- INSERT INTO `student_fee` (`fee_id`, `id`, `dt`, `amount`) VALUES (1, 1, '2013-01-08', 200), (2, 1, '2013-01-10', 100), (3, 2, '2013-01-24', 120), (4, 3, '2013-02-02', 211), (5, 2, '2013-02-07', 150), (6, 3, '2013-02-06', 135), (7, 4, '2013-02-14', 100);