| 9 |
lars |
1 |
-- phpMyAdmin SQL Dump
|
|
|
2 |
-- version 4.0.1
|
|
|
3 |
-- http://www.phpmyadmin.net
|
|
|
4 |
--
|
|
|
5 |
-- Host: 127.0.0.1
|
|
|
6 |
-- Generation Time: Apr 15, 2014 at 05:14 PM
|
|
|
7 |
-- Server version: 5.5.27
|
|
|
8 |
-- PHP Version: 5.4.7
|
|
|
9 |
|
|
|
10 |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
|
11 |
SET time_zone = "+00:00";
|
|
|
12 |
|
|
|
13 |
--
|
|
|
14 |
-- Database: `test`
|
|
|
15 |
--
|
|
|
16 |
|
|
|
17 |
-- --------------------------------------------------------
|
|
|
18 |
|
|
|
19 |
--
|
|
|
20 |
-- Table structure for table `tree_data`
|
|
|
21 |
--
|
|
|
22 |
|
|
|
23 |
CREATE TABLE IF NOT EXISTS `tree_data` (
|
|
|
24 |
`id` int(10) unsigned NOT NULL,
|
|
|
25 |
`nm` varchar(255) CHARACTER SET utf8 NOT NULL,
|
|
|
26 |
PRIMARY KEY (`id`)
|
|
|
27 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
28 |
|
|
|
29 |
--
|
|
|
30 |
-- Dumping data for table `tree_data`
|
|
|
31 |
--
|
|
|
32 |
|
|
|
33 |
INSERT INTO `tree_data` (`id`, `nm`) VALUES
|
|
|
34 |
(1, 'root'),
|
|
|
35 |
(1063, 'Node 12'),
|
|
|
36 |
(1064, 'Node 2'),
|
|
|
37 |
(1065, 'Node 3'),
|
|
|
38 |
(1066, 'Node 4'),
|
|
|
39 |
(1067, 'Node 5'),
|
|
|
40 |
(1068, 'Node 6'),
|
|
|
41 |
(1069, 'Node 7'),
|
|
|
42 |
(1070, 'Node 8'),
|
|
|
43 |
(1071, 'Node 9'),
|
|
|
44 |
(1072, 'Node 9'),
|
|
|
45 |
(1073, 'Node 9'),
|
|
|
46 |
(1074, 'Node 9'),
|
|
|
47 |
(1075, 'Node 7'),
|
|
|
48 |
(1076, 'Node 8'),
|
|
|
49 |
(1077, 'Node 9'),
|
|
|
50 |
(1078, 'Node 9'),
|
|
|
51 |
(1079, 'Node 9');
|
|
|
52 |
|
|
|
53 |
-- --------------------------------------------------------
|
|
|
54 |
|
|
|
55 |
--
|
|
|
56 |
-- Table structure for table `tree_struct`
|
|
|
57 |
--
|
|
|
58 |
|
|
|
59 |
CREATE TABLE IF NOT EXISTS `tree_struct` (
|
|
|
60 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
61 |
`lft` int(10) unsigned NOT NULL,
|
|
|
62 |
`rgt` int(10) unsigned NOT NULL,
|
|
|
63 |
`lvl` int(10) unsigned NOT NULL,
|
|
|
64 |
`pid` int(10) unsigned NOT NULL,
|
|
|
65 |
`pos` int(10) unsigned NOT NULL,
|
|
|
66 |
PRIMARY KEY (`id`)
|
|
|
67 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1083 ;
|
|
|
68 |
|
|
|
69 |
--
|
|
|
70 |
-- Dumping data for table `tree_struct`
|
|
|
71 |
--
|
|
|
72 |
|
|
|
73 |
INSERT INTO `tree_struct` (`id`, `lft`, `rgt`, `lvl`, `pid`, `pos`) VALUES
|
|
|
74 |
(1, 1, 36, 0, 0, 0),
|
|
|
75 |
(1063, 2, 31, 1, 1, 0),
|
|
|
76 |
(1064, 3, 30, 2, 1063, 0),
|
|
|
77 |
(1065, 4, 29, 3, 1064, 0),
|
|
|
78 |
(1066, 5, 28, 4, 1065, 0),
|
|
|
79 |
(1067, 6, 19, 5, 1066, 0),
|
|
|
80 |
(1068, 7, 18, 6, 1067, 0),
|
|
|
81 |
(1069, 8, 17, 7, 1068, 0),
|
|
|
82 |
(1070, 9, 16, 8, 1069, 0),
|
|
|
83 |
(1071, 12, 13, 9, 1070, 1),
|
|
|
84 |
(1072, 14, 15, 9, 1070, 2),
|
|
|
85 |
(1073, 10, 11, 9, 1070, 0),
|
|
|
86 |
(1074, 32, 35, 1, 1, 1),
|
|
|
87 |
(1075, 20, 27, 5, 1066, 1),
|
|
|
88 |
(1076, 21, 26, 6, 1075, 0),
|
|
|
89 |
(1077, 24, 25, 7, 1076, 1),
|
|
|
90 |
(1078, 33, 34, 2, 1074, 0),
|
|
|
91 |
(1079, 22, 23, 7, 1076, 0);
|