By cybershan on

Hi everyone?

how can I set the node id start from 1000 instead of 1?

thanks in advance

⋅ Categories: Drupal 5.x

Comments

shawnp’s picture

shawnp commented

The sequences table is the one that controls the increment of items within Drupal. Although I have not tried it myself, I would guess that you could change, in the sequences table, the vales for node_nid to equal 999 and possibly the values for node_revisions_vid to equal 999. Then the next node would be node number 1000.

cybershan’s picture

cybershan commented

It works, thank you very much.

cybershan’s picture

cybershan commented

One more question, how to set this for Drupal 6? seems there are no sequences table in drupal 6.

cybershan’s picture

cybershan commented

Got it now, just re-set the node table's option -- auto_increment .. :)