title: Avoiding conflicts in two versions of an SQLite database
body: <p>I have got an SQLite database that is modified by users on a server, and a copy of it is edited online. At regular intervals (e.g., once a month), I am going to sync the two versions of the database. However, if the tables have row ids that are assigned automatically using autoincrement, this will cause a conflict between the two versions during sync. What is the best way to avoid such a situation and to keep row ids unique in two versions of the same database?</p>