CREATE TABLE `test1` (
  `test1_id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`test1_id`)
) TYPE=MyISAM CHARSET=latin1 AUTO_INCREMENT=3 ;

INSERT INTO `test1` (`test1_id`, `name`) VALUES (1, 'data1');
INSERT INTO `test1` (`test1_id`, `name`) VALUES (2, 'data2');


CREATE TABLE `test2` (
  `test2_id` int(11) NOT NULL auto_increment,
  `test1_id` int(11) NOT NULL default '0',
  `name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`test2_id`)
) TYPE=MyISAM CHARSET=latin1 AUTO_INCREMENT=4 ;

INSERT INTO `test2` (`test2_id`, `test1_id`, `name`) VALUES (1, 1, 'xxfoo');
INSERT INTO `test2` (`test2_id`, `test1_id`, `name`) VALUES (2, 1, 'xxbar');
INSERT INTO `test2` (`test2_id`, `test1_id`, `name`) VALUES (3, 1, 'xxbuz');