It's " WITHOUT ROWID" problem.
Why would you force database to order rows on the drive according to random id?
Why would you force database to order rows on the drive according to random id?
I never wished, gee, why didn't I use integer key. But so many times I wished I used uuid because eventually your data rows are going to need to have identity that is not local to this specific database instance.