-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 28, 2007 at 03:41 PM
-- Server version: 4.1.9
-- PHP Version: 4.3.10
-- 
-- Database: `menu`
-- 

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

-- 
-- Table structure for table `menu`
-- 

CREATE TABLE `menu` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL default '0',
  `title` varchar(64) NOT NULL default '',
  `is_link` tinyint(1) NOT NULL default '0',
  `link` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

-- 
-- Dumping data for table `menu`
-- 

INSERT INTO `menu` VALUES (1, 0, 'Menu1', 0, '');
INSERT INTO `menu` VALUES (2, 0, 'Menu2', 0, '');
INSERT INTO `menu` VALUES (3, 1, 'Link 1', 1, '');
INSERT INTO `menu` VALUES (4, 3, 'Link1 child', 1, '#');
INSERT INTO `menu` VALUES (5, 4, 'Link 1 child child', 1, '#');
INSERT INTO `menu` VALUES (6, 5, 'Link 1 child child child', 1, '#');
INSERT INTO `menu` VALUES (7, 1, 'Menu link 2', 1, '#');
INSERT INTO `menu` VALUES (8, 7, 'menu link 2 child', 1, '#');
INSERT INTO `menu` VALUES (10, 9, 'Menu 2 link child', 1, '#');
INSERT INTO `menu` VALUES (9, 2, 'Menu 2 link', 1, '#');
INSERT INTO `menu` VALUES (13, 2, 'Menu inside a menu!', 0, '');
INSERT INTO `menu` VALUES (14, 13, 'Link inside a menu inside a menu', 1, 'http://www.google.com');