+end//
+
+create function get_fix_vector (node INT) returns varchar(80)
+BEGIN
+ declare np,mynode int;
+
+ set mynode=node;
+ REPEAT
+ select node_parent into np from nodes where node_id = mynode;
+ /* XXX padding */
+ vector=concat(node_parent,vector);
+ set mynode=node_parent;
+ UNTIL node_parent != NULL and node_parent > 0
+ END REPEAT;
+
+ return vector;
+
+END//
+
+create procedure fix_all_vectors ()
+begin
+