SQLite Forum

Non primary key alias to rowid
Because if remove the it locally and but get it externally again as an import you have two different rowids. So after an import your changeset is not deleting it if it is not using the global text it. So your global id which is used everythere has to be the primary key. It's only working if your global key is a text id and this is a primary key.