gistfile1.php

<?php

  // Add root term as parent for terms without it
  $sql = sprintf("UPDATE %s
    SET parent_id = ?
    WHERE parent_id IS NULL
    AND id != ?;", QubitTerm::TABLE_NAME);

  QubitPdo::modify($sql, array(QubitTerm::ROOT_ID, QubitTerm::ROOT_ID));

  // Update rgt value for root term
  $sql = sprintf("UPDATE %s
    SET rgt = (SELECT result.new_rgt
    FROM (SELECT MAX(rgt) + 1 AS new_rgt FROM %s) result)
    WHERE id = ?;", QubitTerm::TABLE_NAME, QubitTerm::TABLE_NAME);

  QubitPdo::modify($sql, array(QubitTerm::ROOT_ID));

?>