CREATE TABLE  `new`.`test2` (
  `id` int(11) NOT NULL auto_increment,
  `brand` varchar(32) NOT NULL,
  `date` date NOT NULL,
  `weight` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO `new`.`test2` VALUES  (1,'C','2008-02-06',15),
 (2,'C','2008-02-05',20),
 (3,'A','2008-02-04',140),
 (4,'C','2008-02-03',10),
 (5,'B','2008-02-01',190),
 (6,'A','2008-02-01',150),
 (7,'B','2008-01-03',200),
 (8,'A','2008-01-01',110),
 (9,'A','2007-01-01',100);