DB Structure

-- --------------------------------------------------------

--
-- Table structure for table `table1`
--

CREATE TABLE IF NOT EXISTS `table1` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `label` VARCHAR(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `table1`
--

INSERT INTO `table1` (`id`, `label`) VALUES
(1, 'Main 1'),
(2, 'Main 2');

-- --------------------------------------------------------

--
-- Table structure for table `table2`
--

CREATE TABLE IF NOT EXISTS `table2` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `table1_id` INT(10) UNSIGNED NOT NULL,
  `label` VARCHAR(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `table1_id` (`table1_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `table2`
--

INSERT INTO `table2` (`id`, `table1_id`, `label`) VALUES
(1, 1, 'Sub 1-1'),
(2, 2, 'Sub 2-1'),
(3, 2, 'Sub 2-2');