Date index for Apr 2002

Scott Toderash wrote:

> I tried again, and it created the low id's in the db_sequence table. 
> There are only 2 rows in that table, one for hours and one for profile. 
> I changed them both to be max(id) + 1 for the respective tables.  All 
> seems to be well now...

All tables used to use the same sequence, named 'node' in Achievo 0.4. 
This was impractical, so now they each use their own sequence. In the 
upgrade method you used, there was no update to the db_sequence table.

You might encounter the problem for other tables as well. The sequences 
are created if they don't exist, so if you add, for example, a new 
activity, you should have a record 'activity' in db_sequence. It will 
start at 1 though, that's why you get the low values in there.

Greetings,
Ivo