From c3781203726b66d4e7f63b0e85e87de1c9dccecf Mon Sep 17 00:00:00 2001
From: Don Armstrong <don@donarmstrong.com>
Date: Fri, 5 Oct 2012 15:16:29 -0700
Subject: [PATCH] add ideogram table

---
 schema/extra_schema/ideogram_table.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 schema/extra_schema/ideogram_table.sql

diff --git a/schema/extra_schema/ideogram_table.sql b/schema/extra_schema/ideogram_table.sql
new file mode 100644
index 0000000..afecb0a
--- /dev/null
+++ b/schema/extra_schema/ideogram_table.sql
@@ -0,0 +1,16 @@
+CREATE TABLE ideogram (
+       chr TEXT NOT NULL,
+       pq  TEXT NOT NULL,
+       ideogram TEXT NOT NULL,
+       rstart INT NOT NULL, -- I think these are recombination rates,
+			    -- but I'm not sure
+       rstop INT NOT NULL,
+       start INT NOT NULL,
+       stop INT NOT NULL,
+       posneg TEXT NOT NULL -- I believe this indicates whether the
+			    -- band is black or white
+       );
+       
+CREATE UNIQUE INDEX ON ideogram(chr,pq,ideogram);
+CREATE UNIQUE INDEX ON ideogram(chr,start);
+CREATE UNIQUE INDEX ON ideogram(chr,stop);
-- 
2.39.2