Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

How to set initial IDs


After finishing testing HostBill you may wish to set initial IDs of certain entities to higher values (ie set initial invoice id to 1000).

Initial Client ID

To set client ID starting from 1000 issue following SQL query:

 ALTER TABLE hb_client_details AUTO_INCREMENT=1000;

Initial Invoice ID

To set Invoice ID starting from 1000 issue following SQL query:

 ALTER TABLE hb_invoices AUTO_INCREMENT=1000;

Initial Account ID

To set Account ID starting from 1000 issue following SQL query:

 ALTER TABLE hb_accounts AUTO_INCREMENT=1000;
  • No labels