I'm taking over maintenance of a Drupal site but the old admin is staying on as a user.
I need to adjust the ownership of the posts currently under uid 1.
Is this query sufficient or is uid associated with a blog post in other ways?
Is there an admin module for this process?
UPDATE `drupal_node_revisions` r, `drupal_node` n SET n.uid = 13392, r.uid = 13392 WHERE r.uid = 1 AND n.uid = 1 AND n.type = 'blog' AND r.nid = n.nid