From cccc00fef4cbece5fd2c5cf05a7a1182263fd53b Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Tue, 13 Dec 2011 13:44:16 -0800 Subject: [PATCH] add mrna_cds table schema --- schema/extra_schema/mrna_cds_table.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 schema/extra_schema/mrna_cds_table.sql 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 -- 2.39.2