src/hg/lib/refSeqStatus.sql 1.2

Index: src/hg/lib/refSeqStatus.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/refSeqStatus.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -b -B -U 1000000 -r1.1 -r1.2
--- src/hg/lib/refSeqStatus.sql	19 Jun 2002 21:24:22 -0000	1.1
+++ src/hg/lib/refSeqStatus.sql	4 Jul 2009 07:14:20 -0000	1.2
@@ -1,12 +1,13 @@
 # refSeqStatus.sql was originally generated by the autoSql program, which also 
 # generated refSeqStatus.c and refSeqStatus.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #RefSeq Gene Status.
 CREATE TABLE refSeqStatus (
     mrnaAcc varchar(255) not null,	# RefSeq gene accession name
-    status varchar(255) not null,	# Status (Reviewed, Provisional, Predicted)
+    status enum("Unknown", "Reviewed", "Validated", "Provisional", "Predicted", "Inferred")  not null,	# Status of RefSeq
+    mol enum("DNA", "RNA", "ds-RNA", "ds-mRNA", "ds-rRNA", "mRNA", "ms-DNA", "ms-RNA", "rRNA", "scRNA", "snRNA", "snoRNA", "ss-DNA", "ss-RNA", "ss-snoRNA", "tRNA")  not null,	# molecule type
               #Indices
     PRIMARY KEY(mrnaAcc)
 );