[Gmod-schema-cmts] schema/chado/modules/genetic genetic.sql,1.9,1.10

[<cmu...@us...>]

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

Modified Files:
	genetic.sql 
Log Message:
fixed problems

group now cgroup

put back the PK declarations



Index: genetic.sql
===================================================================
RCS file: /cvsroot/gmod/schema/chado/modules/genetic/genetic.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** genetic.sql	2 Dec 2003 17:46:57 -0000	1.9
--- genetic.sql	3 Dec 2003 16:53:39 -0000	1.10
***************
*** 193,197 ****
  --
  CREATE TABLE gcontext (
!     gcontext_id          SERIAL       NOT NULL,
      uniquename           VARCHAR(255) NOT NULL,
      description          TEXT,
--- 193,197 ----
  --
  CREATE TABLE gcontext (
!     gcontext_id          SERIAL PRIMARY KEY NOT NULL,
      uniquename           VARCHAR(255) NOT NULL,
      description          TEXT,
***************
*** 210,214 ****
  --
  CREATE TABLE gcontext_relationship (
!     gcontext_relationship_id SERIAL       NOT NULL,
      subjectgc_id         INTEGER      NOT NULL REFERENCES gcontext(gcontext_id),
      objectgc_id          INTEGER      NOT NULL REFERENCES gcontext(gcontext_id),
--- 210,214 ----
  --
  CREATE TABLE gcontext_relationship (
!     gcontext_relationship_id SERIAL PRIMARY KEY NOT NULL,
      subjectgc_id         INTEGER      NOT NULL REFERENCES gcontext(gcontext_id),
      objectgc_id          INTEGER      NOT NULL REFERENCES gcontext(gcontext_id),
***************
*** 243,247 ****
      chromosome_id        INTEGER      REFERENCES feature(feature_id),
      rank                 INTEGER      NOT NULL,
!     group                INTEGER      NOT NULL,
      cvterm_id            INTEGER      NOT NULL REFERENCES cvterm(cvterm_id)
  );
--- 243,247 ----
      chromosome_id        INTEGER      REFERENCES feature(feature_id),
      rank                 INTEGER      NOT NULL,
!     cgroup               INTEGER      NOT NULL,
      cvterm_id            INTEGER      NOT NULL REFERENCES cvterm(cvterm_id)
  );
***************
*** 282,286 ****
  --
  CREATE TABLE phenstatement (
!     phenstatement_id     SERIAL       NOT NULL,
      gcontext_id          INTEGER      NOT NULL REFERENCES gcontext(gcontext_id),
      dbxref_id            INTEGER      NOT NULL REFERENCES dbxref(dbxref_id),
--- 282,286 ----
  --
  CREATE TABLE phenstatement (
!     phenstatement_id     SERIAL PRIMARY KEY NOT NULL,
      gcontext_id          INTEGER      NOT NULL REFERENCES gcontext(gcontext_id),
      dbxref_id            INTEGER      NOT NULL REFERENCES dbxref(dbxref_id),
***************
*** 315,319 ****
  --
  CREATE TABLE phenstatement_relationship (
!     phenstatement_relationship_id SERIAL       NOT NULL,
      subject_id           INTEGER      NOT NULL REFERENCES phenstatement(phenstatement_id),
      object_id            INTEGER      NOT NULL REFERENCES phenstatement(phenstatement_id),
--- 315,319 ----
  --
  CREATE TABLE phenstatement_relationship (
!     phenstatement_relationship_id SERIAL PRIMARY KEY NOT NULL,
      subject_id           INTEGER      NOT NULL REFERENCES phenstatement(phenstatement_id),
      object_id            INTEGER      NOT NULL REFERENCES phenstatement(phenstatement_id),