Custom database auto increment

[hubert]

Hello,

I've just moved my shop to my local machine for debugging purpose and I've also studied how to sync two databases (remote and local).
As my hosting doesn't let me modify my my.cnf file I can't setup master to master replication, which is what I would have needed, so I was thinking about something else for running two identical shops on two locations (cause I'm wondering if I cannot use zen-cart as my POS system):

1) Making my IDs beginning at 1000000.

In this case, can an expert tell me for which ID's I have to modify my database auto increment. I'm quite sure for Orders, Customers, but I'm also quite sure I'm missing some key tables and IDs

2) Another solution I'm thinking of is : how to set mysql so that the auto increment step is negative beginning at 0. This way, and as far as my math knowledge goes, I'm sure that my IDs won't ever overlap (one for web one for POS) even if my store is very very very successful.

So my questions are :
- What are the key IDs in a store database ?
- How to change auto-increment beginning value ?
- How to change auto-incremeent step value ?
- Can the mysql auto increment step value ?

Thanks for helping

Regards

Hubert

[kobra]

There was ollacart POS that was available for ZenCart which seems to have vanished

All I could find was this

http://www.webcart-consulting.com/

[lhungil]

Does your host support remote MySQL access (with TLS)?

[hubert]

As I don't have access to my.cnf, no, no TLS support...