cd53a755e4e7dfbbfdeeef59b03c8261146d2a82
baertsch
  Sun May 15 03:16:54 2011 -0700
add ucscRetroOrtho table and code for ucscRetro child table
diff --git src/hg/lib/ucscRetroOrtho.sql src/hg/lib/ucscRetroOrtho.sql
new file mode 100644
index 0000000..78ae933
--- /dev/null
+++ src/hg/lib/ucscRetroOrtho.sql
@@ -0,0 +1,13 @@
+# ucscRetroOrtho.sql was originally generated by the autoSql program, which also 
+# generated ucscRetroOrtho.c and ucscRetroOrtho.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#Orthlogy of retrogenes based on chains/nets with other species.
+CREATE TABLE ucscRetroOrtho (
+    name varchar(255) not null,	# Unique name of retrogene 
+    db varchar(255) not null,	# database of other species
+    overlap int not null,	# percent of retro that breaks net relative to other species
+              #Indices
+    PRIMARY KEY(name,db)
+);