-- phpMyAdmin SQL Dump
-- version 3.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 16, 2009 at 10:58 AM
-- Server version: 5.1.30
-- PHP Version: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `horsepower`
--

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

--
-- Table structure for table `main_menu`
--

CREATE TABLE IF NOT EXISTS `main_menu` (
  `id_menu` int(11) NOT NULL AUTO_INCREMENT,
  `parentID_menu` int(11) NOT NULL,
  `label_menu` varchar(100) NOT NULL,
  `target_menu` varchar(10) NOT NULL,
  `highlight_menu` varchar(10) NOT NULL,
  PRIMARY KEY (`id_menu`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `main_menu`
--

INSERT INTO `main_menu` (`id_menu`, `parentID_menu`, `label_menu`, `target_menu`, `highlight_menu`) VALUES
(1, 0, 'Home', '_self', '1'),
(2, 0, 'accessories', '_self', '2'),
(3, 0, 'lighting', '_self', '3'),
(4, 0, 'performance', '_self', '4'),
(5, 0, 'styling', '_self', ''),
(6, 2, 'Accessory1', '_self', ''),
(7, 2, 'Accessory2', '_self', '');

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

--
-- Table structure for table `secondary_submenu`
--

CREATE TABLE IF NOT EXISTS `secondary_submenu` (
  `id_secondary` int(11) NOT NULL AUTO_INCREMENT,
  `parentid_secondary` int(11) NOT NULL,
  `label_secondary` varchar(100) NOT NULL,
  `target_secondary` varchar(10) NOT NULL,
  `highlight_secondary` varchar(10) NOT NULL,
  `mainmenuID_secondary` int(11) NOT NULL,
  PRIMARY KEY (`id_secondary`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `secondary_submenu`
--

INSERT INTO `secondary_submenu` (`id_secondary`, `parentid_secondary`, `label_secondary`, `target_secondary`, `highlight_secondary`, `mainmenuID_secondary`) VALUES
(1, 0, 'secondary menu1', '_self', '1', 1),
(2, 0, 'secondary menu2', '_self', '2', 1);