X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fextra_schema%2Fmrna_cds_table.sql;fp=schema%2Fextra_schema%2Fmrna_cds_table.sql;h=1506732f885d38a6d17ba6ec36592139d62c8275;hb=cccc00fef4cbece5fd2c5cf05a7a1182263fd53b;hp=0000000000000000000000000000000000000000;hpb=10730e8c59ad9fb254c1f9de5deb9978ffdfc813;p=dbsnp.git

diff --git a/schema/extra_schema/mrna_cds_table.sql b/schema/extra_schema/mrna_cds_table.sql
new file mode 100644
index 0000000..1506732
--- /dev/null
+++ b/schema/extra_schema/mrna_cds_table.sql
@@ -0,0 +1,17 @@
+CREATE TABLE mrna_cds_table (
+       gi int NOT NULL,
+       cds_gi INT,
+       accession TEXT NOT NULL,
+       accession_ver INT NOT NULL,
+       gene TEXT NOT NULL,
+       start INT NOT NULL,
+       stop INT NOT NULL,
+       length INT NOT NULL,
+       sequence TEXT NOT NULL,
+       prot_seq TEXT NOT NULL
+);
+
+CREATE UNIQUE INDEX ON mrna_cds_table(gi);
+CREATE INDEX ON mrna_cds_table(cds_gi);
+CREATE UNIQUE INDEX ON mrna_cds_table(accession,accession_ver);
+CREATE INDEX ON mrna_cds_table(gene);
\ No newline at end of file