Re: [Treebase-devel] Large accession numbers after switch to hibernate_sequence

[William P. <wil...@ya...>]

On Jan 27, 2010, at 11:48 AM, Hilmar Lapp wrote:

> The TB code *already used* a single sequence. I guess the change is  
> now that the study ID is drawn from that sequence too - apparently  
> previously even Hibernate used a separate sequence for that? I'm sure  
> if desired this can be restored.

All existing data (i.e. what was migrated up until Jan 09) have study_id, phylotree_id, matrix_id, etc, that are integers each one increasing one by one. So I believe that TB code previously used table-specific sequences rather than a single source of integers. 

While I'd prefer the study_id to increase one-by-one (mainly because a number like "160000022251" is so long that it's prone to people making typos in their manuscripts) I wouldn't want this to delay deployment. (and people can always use copy-paste to avoid typos..)

bp