How to set initial IDs
After finishing testing When you start using HostBill you may wish to set initial IDs of certain entities to higher values (ie for example set initial invoice id ID to 1000).
Initial Client ID
To set client ID starting from 1000 issue following SQL query:
| Code Block | ||
|---|---|---|
| ||
ALTER TABLE hb_client_details AUTO_INCREMENT=1000; |
Initial Invoice ID
To set Invoice ID starting from 1000 issue following SQL query:
| Code Block | ||
|---|---|---|
| ||
ALTER TABLE hb_invoices AUTO_INCREMENT=1000; |
Initial Account ID
To set Account ID starting from 1000 issue following SQL query:
...