If you want to make it auto-increment define id as the primary key in the keys section. The XMLDB marks all primary keys as auto-increment.
add
KEY NAME="primary" TYPE="primary" FIELDS="id"
in the keys section
General developer forum
XMLDB auto increment?
This discussion has been locked so you can no longer reply to it.