src/hg/lib/tRNAs.sql 1.3

Index: src/hg/lib/tRNAs.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/tRNAs.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 4 -r1.2 -r1.3
--- src/hg/lib/tRNAs.sql	1 Dec 2005 01:25:52 -0000	1.2
+++ src/hg/lib/tRNAs.sql	7 Jan 2010 02:54:51 -0000	1.3
@@ -4,9 +4,8 @@
 # automatic way.
 
 #transfer RNA genes
 CREATE TABLE tRNAs (
-    bin int unsigned not null, 
     chrom varchar(255) not null,	# chromosome
     chromStart int unsigned not null,	# Start position in chromosome
     chromEnd int unsigned not null,	# End position in chromosome
     name varchar(255) not null,	# transfer RNA gene name
@@ -15,7 +14,9 @@
     aa varchar(255) not null,	# Amino acid for the tRNA
     ac varchar(255) not null,	# Anticodon for the tRNA
     intron varchar(255) not null,	# Coordinates for intron
     trnaScore float not null,	# tRNAScanSE score
+    genomeUrl varchar(255) not null,	# GtRNAdb genome summary URL
+    trnaUrl varchar(255) not null,	# GtRNAdb tRNA alignment URL
               #Indices
-    PRIMARY KEY(name)
+    PRIMARY KEY(chrom, chromStart, chromEnd)
 );