Change parent with sql tool

[baresi]

I am looking at changing parents of a bunch of pages and trying not to use listcontent. I logged in to the database with a tool (heidisql) and I guess the main thing is to change parent_id, but what should be done with hierarchy, id_hierarchy and item_order (and any other fields)? Will appreciate any help

[alby]

I am looking at changing parents of a bunch of pages and trying not to use listcontent. I logged in to the database with a tool (heidisql) and I guess the main thing is to change parent_id, but what should be done with hierarchy, id_hierarchy and item_order (and any other fields)? Will appreciate any help

It's not simple!!!
You must modify:
parent_id
item_order
hierarchy ("hierarchy of parent_id"."0000""item_order") [last item must be 5 numbers]
id_hierarchy ("id of parent_id"."id of content_id")
hierarchy_path ("hierarchy_path of parent_id"/"content_alias")

Alby