CREATE TABLE `slave` ( `id` bigint(20) unsigned NOT NULL auto_increment, `master_id` bigint(20) unsigned NOT NULL, `date` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; INSERT INTO `slave` (`id`, `master_id`, `date`) VALUES (1, 1, '2006-03-30'); INSERT INTO `slave` (`id`, `master_id`, `date`) VALUES (2, 2, '2006-04-06'); INSERT INTO `slave` (`id`, `master_id`, `date`) VALUES (3, 3, '2006-04-13'); INSERT INTO `slave` (`id`, `master_id`, `date`) VALUES (4, 2, '2006-04-20'); INSERT INTO `slave` (`id`, `master_id`, `date`) VALUES (5, 1, '2006-05-01');