File: example.sql

#
# Table structure for table `tree`
#

CREATE TABLE `tree` (
  `id` int(11) NOT NULL auto_increment,
  `parent` int(11) NOT NULL default '1',
  `title` varchar(20) NOT NULL,
  `left` int(11) NOT NULL,
  `right` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `ParentId` (`parent`,`left`,`right`)
) ENGINE=MyISAM AUTO_INCREMENT=10 ;

#
# Dumping data for table `tree`
#

INSERT INTO `tree` VALUES (1, 1, 'Food', 1, 18);
INSERT INTO `tree` VALUES (2, 1, 'Meat', 2, 7);
INSERT INTO `tree` VALUES (3, 2, 'Beaf', 3, 4);
INSERT INTO `tree` VALUES (4, 2, 'Fish', 5, 6);
INSERT INTO `tree` VALUES (5, 1, 'Fruit', 8, 17);
INSERT INTO `tree` VALUES (6, 5, 'Red', 9, 12);
INSERT INTO `tree` VALUES (7, 6, 'Apple', 10, 11);
INSERT INTO `tree` VALUES (8, 5, 'Yellow', 13, 16);
INSERT INTO `tree` VALUES (9, 8, 'Banana', 14, 15);