On Jun 27, 2009, at 9:30 PM, gharris999 wrote: > > Andy: FYI: on a clear and rescan, I don't think the starting id column > values in the db tables are getting reset to 1. E.G: my genres table, > which has 39 records, starts at id==138; tracks, which has 47395 > records: 1st id == 189507. > > I don't what the largest value that a INTEGER PRIMARY KEY field can > hold. If it's 64 bits, I suppose that this isn't really a problem. > I'd > have to rescan, what...389 trillion times before the field overflowed? > > Anyway, this does seem to be different from how the mysql wipe and > rescan worked.
http://www.sqlite.org/autoinc.html It may be fixable, but probably not worth worrying about. _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
