[Gmod-schema-cmts] SF.net SVN: gmod:[25283] schema/trunk/chado/modules/organism/organism.sql

[<em...@us...>]

Revision: 25283
          http://gmod.svn.sourceforge.net/gmod/?rev=25283&view=rev
Author:   emmert
Date:     2013-02-27 19:43:09 +0000 (Wed, 27 Feb 2013)
Log Message:
-----------
Add strain_pub table to module

Modified Paths:
--------------
    schema/trunk/chado/modules/organism/organism.sql

Modified: schema/trunk/chado/modules/organism/organism.sql
===================================================================
--- schema/trunk/chado/modules/organism/organism.sql	2013-02-08 21:25:30 UTC (rev 25282)
+++ schema/trunk/chado/modules/organism/organism.sql	2013-02-27 19:43:09 UTC (rev 25283)
@@ -355,6 +355,23 @@
 create index strain_dbxref_idx2 on strain_dbxref (dbxref_id);
 
 
+-- ================================================                                                                               
+-- TABLE: strain_pub                                                                                                              
+-- ================================================                                                                               
+drop table strain_pub cascade;
+create table strain_pub (
+       strain_pub_id serial not null,
+       primary key (strain_pub_id),
+       strain_id int not null,
+       foreign key (strain_id) references strain (strain_id) on delete cascade INITIALLY DEFERRED,
+       pub_id int not null,
+       foreign key (pub_id) references pub (pub_id) on delete cascade INITIALLY DEFERRED,
+       unique(strain_id,pub_id)
+);
+create index strain_pub_idx1 on strain_pub (strain_id);
+create index strain_pub_idx2 on strain_pub (pub_id);
+
+
 -- ================================================
 -- TABLE: strain_synonym
 -- ================================================

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.