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 4 -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
@@ -5,8 +5,9 @@
 
 #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)
 );