LvdNhV8v

1DROP TABLE IF EXISTS `xtree`;
2
3CREATE TABLE IF NOT EXISTS `xtree` (
4gid BIGINT,
5line BIGINT, 
6id VARCHAR(3),
7comments VARCHAR(10),
8level BIGINT );
9
10insert into `xtree` values ( 1, 1,  'A',   'A', 1);
11insert into `xtree` values ( 1, 2,  'B',   'B', 2);
12insert into `xtree` values ( 1, 3,  'E',   'E', 3);
13insert into `xtree` values ( 1, 4,  'F',   'F', 3);
14insert into `xtree` values ( 1, 5,  'C',   'C', 2);
15insert into `xtree` values ( 1, 6,  'G',   'G', 3);
16insert into `xtree` values ( 1, 7,  'D',   'D', 2);
17insert into `xtree` values ( 1, 8,  'H',   'H', 3);
18insert into `xtree` values ( 1, 9,  'J',   'J', 4);
19insert into `xtree` values ( 1, 10, 'K',   'K', 4);
20insert into `xtree` values ( 1, 11, 'L',   'L', 4);
21insert into `xtree` values ( 1, 12, 'I',   'I', 3);
22insert into `xtree` values ( 1, 13, 'END', 'END', 0);
23
24insert into `xtree` values ( 2, 1,  'A',   'A', 1);
25insert into `xtree` values ( 2, 2,  'B',   'B', 2);
26insert into `xtree` values ( 2, 3,  'E',   'E', 3);
27insert into `xtree` values ( 2, 4,  'F',   'F', 3);
28insert into `xtree` values ( 2, 5,  'C',   'C', 2);
29insert into `xtree` values ( 2, 6,  'G',   'G', 3);
30insert into `xtree` values ( 2, 7,  'D',   'D', 2);
31insert into `xtree` values ( 2, 8,  'H',   'H', 3);
32insert into `xtree` values ( 2, 9,  'J',   'J', 4);
33insert into `xtree` values ( 2, 10, 'K',   'K', 4);
34insert into `xtree` values ( 2, 11, 'L',   'L', 4);
35insert into `xtree` values ( 2, 12, 'I',   'I', 3);
36insert into `xtree` values ( 2, 13, 'END', 'END', 0);