add gcrma data and affymetrix probe annotation loaders

[dbsnp.git] / schema / extra_schema / gcrma_indexes.sql

diff --git a/schema/extra_schema/gcrma_indexes.sql b/schema/extra_schema/gcrma_indexes.sql
new file mode 100644 (file)
index 0000000..a6735bd
--- /dev/null
+++ b/schema/extra_schema/gcrma_indexes.sql
@@ -0,0 +1,11 @@
+CREATE UNIQUE INDEX ON gcrma_samples(tissue);
+CREATE UNIQUE INDEX ON affy_probe(probe);
+CREATE UNIQUE INDEX on affy_annotation(probe);
+CREATE UNIQUE INDEX ON gcrma_expression(probe,sample);
+ALTER TABLE gcrma_samples ADD PRIMARY KEY (id);
+ALTER TABLE affy_probe ADD PRIMARY KEY (id);
+ALTER TABLE gcrma_expression ADD PRIMARY KEY (id);
+ALTER TABLE affy_annotation ADD PRIMARY KEY (id);
+ALTER TABLE affy_annotation ADD FOREIGN KEY (id) REFERENCES affy_probe;
+ALTER TABLE gcrma_expression ADD FOREIGN KEY (probe) REFERENCES affy_probe;
+ALTER TABLE gcrma_expression ADD FOREIGN KEY (sample) REFERENCES gcrma_samples;