drop table node;

create table node(NODE_ID integer, NODE_NODE_ID integer, NODE_Type integer, NODE_Name varchar(50), NODE_Weight integer);

insert into tree values(1, NULL, "Projekt XYZ", 1, 0);

insert into tree values(2, 1, "A", 1, 0.4);
insert into tree values(3, 1, "B", 1, 0.4);
insert into tree values(31, 1, "C", 1, 0.2);

insert into tree values(4, 2, "A1", 2, 0.4);
insert into tree values(5, 2, "A2", 2, 0.4);
insert into tree values(6, 3, "B1", 2, 0.5);

insert into tree values(8, 4, "TF-A1", 3, 0.5);
insert into tree values(9, 4, "TF-A2", 3, 0.3);
insert into tree values(10, 6, "TF-B1", 3, 0.5);