дамп базы:
Спойлер (Отобразить)
CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- -- phpMyAdmin SQL Dump
- -- version 3.2.3
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Jun 21, 2011 at 02:12 PM
- -- Server version: 5.1.40
- -- PHP Version: 5.3.1
- 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: `voyager`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `linkLevels`
- --
- CREATE TABLE IF NOT EXISTS `linkLevels` (
- `ID` int(11) NOT NULL AUTO_INCREMENT,
- `IdPage` int(11) NOT NULL,
- `IdParent` int(11) NOT NULL,
- `Level` int(10) NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
- --
- -- Dumping data for table `linkLevels`
- --
- INSERT INTO `linkLevels` (`ID`, `IdPage`, `IdParent`, `Level`) VALUES
- (1, 2, 1, 1),
- (2, 3, 2, 2),
- (3, 4, 2, 2),
- (4, 1, 0, 0),
- (5, 5, 0, 0),
- (6, 6, 5, 1),
- (7, 7, 5, 2);
- -- --------------------------------------------------------
- --
- -- Table structure for table `pages`
- --
- CREATE TABLE IF NOT EXISTS `pages` (
- `ID` int(11) NOT NULL AUTO_INCREMENT,
- `Name` varchar(30) NOT NULL,
- `URL` text NOT NULL,
- `IdUser` int(11) NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
- --
- -- Dumping data for table `pages`
- --
- INSERT INTO `pages` (`ID`, `Name`, `URL`, `IdUser`) VALUES
- (1, 'index', 'index.html', 1),
- (2, 'page1', 'page1.html', 1),
- (3, 'page2', 'page2.html', 1),
- (4, 'page3', 'page3.html', 1),
- (5, 'index1', 'index1.html', 1),
- (6, 'page6', 'page6.html', 1),
- (7, 'page7', 'page7.html', 1);