Rael Bauer wrote: > Now I have restructured the normal table (i.e. delete column) using the > algorithm mentioned here a couple of times (insert into normal select > (columns) from normal_OLD, etc..) > > This "resets" the rowid's of the normal table.
If you rely on the rowid values, you should declare this column as INTEGER PRIMARY KEY to prevent such changes. Regards, Clemens