Re: [GMOD-devel] [Gmod-schema] Upcoming release of chado/gmod-1.1

[Robert B. <rm...@co...>]

Lol, and here some people were under the impression that it's impossible 
to get a Chado schema change through!

R

Scott Cain wrote:
> Hi Stephen,
> 
> I'll be happy to add this in; would you mind writing COMMENT ON TABLE
> and COMMENT ON COLUMN commands for this table?
> 
> Thanks,
> Scott
> 
> 
> On Thu, Dec 10, 2009 at 12:45 PM, Stephen Ficklin <FI...@cl...> wrote:
>> Hi Scott,
>>
>> We would like to see an anlysisfeatureprop table for associating properties of analysis results with features.  We've been using such a table with the following structure:
>>
>> CREATE TABLE analysisfeatureprop
>>  analysisfeatureprop_id SERIAL PRIMARY KEY,
>>  analysisfeature_id INTEGER NOT NULL REFERENCES analysisfeature(analysisfeature_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
>>  type_id INTEGER NOT NULL REFERENCES cvterm(cvterm_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
>>  value TEXT,
>>  rank INTEGER NOT NULL,
>>  CONSTRAINT analysisfeature_id_type_id_rank UNIQUE(analysisfeature_id, type_id, rank)
>>
>> We had a brief discussion on this a while back on the mailing list.
>>
>> Thanks,
>> Stephen
>>
>> -----Original Message-----
>> From: Scott Cain [mailto:sc...@sc...]
>> Sent: Wednesday, December 09, 2009 2:40 PM
>> To: GMOD Schema/Chado List; gmod-devel
>> Subject: [Gmod-schema] Upcoming release of chado/gmod-1.1
>>
>> Hi all,
>>
>> I am preparing for the 1.1 release of gmod/chado and would like to
>> know if there is anything on anybody's wish list for fixes or (minor)
>> additions before the release.  We've made lots of improvements and
>> fixes over the past year, so you may want to take a look at the
>> Changes file to see what has been done:
>>
>>  http://gmod.svn.sourceforge.net/viewvc/gmod/schema/trunk/chado/Changes
>>
>> I will be checking with the bug and feature request trackers over the
>> next few days in case you post there instead of replying to this
>> email:
>>
>>  https://sourceforge.net/tracker/?group_id=27707&atid=391294
>>  https://sourceforge.net/tracker/?group_id=27707&atid=391291
>>
>> Thanks,
>> Scott
>>
>> --
>> ------------------------------------------------------------------------
>> Scott Cain, Ph. D.                                   scott at scottcain dot net
>> GMOD Coordinator (http://gmod.org/)                     216-392-3087
>> Ontario Institute for Cancer Research
>>
>> ------------------------------------------------------------------------------
>> Return on Information:
>> Google Enterprise Search pays you back
>> Get the facts.
>> http://p.sf.net/sfu/google-dev2dev
>> _______________________________________________
>> Gmod-schema mailing list
>> Gmo...@li...
>> https://lists.sourceforge.net/lists/listinfo/gmod-schema
>>
> 
> 
> 


-- 
Robert Buels
Bioinformatics Analyst, Sol Genomics Network
Boyce Thompson Institute for Plant Research
Tower Rd
Ithaca, NY  14853
Tel: 503-889-8539
rm...@co...
http://www.sgn.cornell.edu