Re: [Fwd: [Fwd: Re: [Gusdev-gusdev] GUSdev schema]]

[<cra...@SN...>]

Pjm wrote:
> 
> Jonathan,
> 
> thanks for putting the file gusdev-sql-jul-25-2002.tar.gz on the download site.
> Since we have to put bootstrap/dictinary data into the rows of our schema I was
> wondering how we could share some of these things. For example, the taxon table
> could easily be shared (does this relate to NCBI Ids at all?).
> 
> Another reason for doing this is so when we (and others..) install GUS we can
> run our parsers straight away and populate the schema with our favourite data.
> Could the bootstrap data be added to the install script please?
> 
> Paul.
> 

Hi Paul-

Angel discovered some problems with the CREATE VIEW statements in that file.  I'm
just ironing out the last of the problems with it and will have an updated version
on the site in a couple of hours.  The new version has two files with actual data: 
1) the 4 or 5 "bootstrap" rows needed for those common tables, and 2) the contents of 
the TableInfo table.  I had the Taxon table on my list of things to add, and I think
it would be straightforward to just dump that as well.  I *believe* that the current
gusdev Taxon table is essentially a copy of a similar table from GSDB.  However,
we have a new set of taxon tables for GUS 3.0 ("Taxon3" in GUSdev) that Debbie 
populated using NCBI's flat files.

Jonathan