add intron/exon schema and mrna cds loader

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

diff --git a/schema/extra_schema/intron_exon_schema_indexes.sql b/schema/extra_schema/intron_exon_schema_indexes.sql
new file mode 100644 (file)
index 0000000..dd2ba09
--- /dev/null
+++ b/schema/extra_schema/intron_exon_schema_indexes.sql
@@ -0,0 +1,30 @@
+CREATE UNIQUE INDEX ON contigs(gi);
+CREATE INDEX ON contigs(feature_name);
+CREATE INDEX ON contigs(chr);
+
+CREATE UNIQUE INDEX ON exons(gi,number);
+CREATE UNIQUE INDEX ON exons(accession,accession_ver,number);
+CREATE INDEX ON exons(accession);
+
+CREATE UNIQUE INDEX ON cds(gi,number);
+CREATE UNIQUE INDEX ON cds(accession,accession_ver,number);
+CREATE INDEX ON cds(accession);
+
+CREATE INDEX ON cds(accession);
+CREATE INDEX ON cds(gene);
+CREATE INDEX ON cds(start);
+CREATE INDEX ON cds(stop);
+CREATE INDEX ON cds(gi);
+CREATE INDEX ON cds(start,stop);
+CREATE INDEX ON cds(chr);
+
+-- CREATE UNIQUE INDEX ON mrna(accession,ctg_gi,number);
+-- CREATE INDEX ON mrna(gi,number);
+-- CREATE INDEX ON mrna(accession,accession_ver,number);
+CREATE INDEX ON mrna(accession);
+CREATE INDEX ON mrna(gene);
+CREATE INDEX ON mrna(start);
+CREATE INDEX ON mrna(stop);
+CREATE INDEX ON mrna(gi);
+CREATE INDEX ON mrna(start,stop);
+CREATE INDEX ON mrna(chr);
\ No newline at end of file