[Gmod-schema-cmts] schema/chado/modules/sequence sequence.sql,1.36.2.1,1.36.2.2

[<all...@us...>]

Update of /cvsroot/gmod/schema/chado/modules/sequence
In directory sc8-pr-cvs1:/tmp/cvs-serv12638/sequence

Modified Files:
      Tag: allenday
	sequence.sql 
Log Message:
shunted linktable rank and bool fields off into prop tables.
made pk from serial for assay_project table.


Index: sequence.sql
===================================================================
RCS file: /cvsroot/gmod/schema/chado/modules/sequence/sequence.sql,v
retrieving revision 1.36.2.1
retrieving revision 1.36.2.2
diff -C2 -d -r1.36.2.1 -r1.36.2.2
*** sequence.sql	16 Jun 2003 19:55:19 -0000	1.36.2.1
--- sequence.sql	9 Jul 2003 02:59:47 -0000	1.36.2.2
***************
*** 212,216 ****
         dbxref_id int not null,
         foreign key (dbxref_id) references dbxref (dbxref_id),
-        is_current boolean not null default 'true',
  
         unique(feature_id, dbxref_id)
--- 212,215 ----
***************
*** 220,223 ****
--- 219,239 ----
  create index feature_dbxref_idx2 on feature_dbxref (dbxref_id);
  
+ -- ================================================
+ -- TABLE: feature_dbxrefprop
+ -- ================================================
+ create table feature_dbxrefprop (
+        feature_dbxrefprop_id serial not null,
+        primary key (feature_dbxrefprop_id),
+        feature_dbxref_id int not null,
+        foreign key (feature_dbxref_id) references feature_dbxref (feature_dbxref_id),
+        type_id int not null,
+        foreign key (type_id) references cvterm (cvterm_id),
+        value text not null default '',
+ 
+        unique(feature_dbxref_id, type_id, value)
+ );
+ insert into tableinfo (name,primary_key_column) values('feature_dbxrefprop','feature_dbxrefprop_id');
+ create index feature_dbxrefprop_idx1 on feature_dbxrefprop (feature_dbxref_id);
+ create index feature_dbxrefprop_idx2 on feature_dbxrefprop (type_id);
  
  -- ================================================
***************
*** 310,315 ****
         pub_id int not null,
         foreign key (pub_id) references pub (pub_id),
-        is_current boolean not null,
-        is_internal boolean not null default 'false',
  
         unique(synonym_id, feature_id, pub_id)
--- 326,329 ----
***************
*** 331,332 ****
--- 345,365 ----
  create index feature_synonym_idx2 on feature_synonym (feature_id);
  create index feature_synonym_idx3 on feature_synonym (pub_id);
+ 
+ -- ================================================
+ -- TABLE: feature_synonymprop
+ -- ================================================
+ create table feature_synonymprop (
+        feature_synonymprop_id serial not null,
+        primary key (feature_synonymprop_id),
+        feature_synonym_id int not null,
+        foreign key (feature_synonym_id) references feature_synonym (feature_synonym_id),
+        type_id int not null,
+        foreign key (type_id) references cvterm (cvterm_id),
+        value text not null default '',
+ 
+        unique(feature_synonym_id, type_id, value)
+ );
+ insert into tableinfo (name,primary_key_column) values('feature_synonymprop','feature_synonymprop_id');
+ create index feature_synonymprop_idx1 on feature_synonymprop (feature_synonym_id);
+ create index feature_synonymprop_idx2 on feature_synonymprop (type_id);
+