add actual version of tables used

[dbsnp.git] / schema / shared_schema / dbSNP_main_index_postgresql.sql

diff --git a/schema/shared_schema/dbSNP_main_index_postgresql.sql b/schema/shared_schema/dbSNP_main_index_postgresql.sql
index e503a6a76175037719140db36941edd83aa27265..0bca28e74faed1e13abb5a730a38eb5039a23d66 100644 (file)
--- a/schema/shared_schema/dbSNP_main_index_postgresql.sql
+++ b/schema/shared_schema/dbSNP_main_index_postgresql.sql
@@ -1,129 +1,126 @@
- CREATE  UNIQUE  INDEX ON "Allele"("allele")
-;
- CREATE  INDEX ON "Allele"("rev_allele_id")
-;
-
-
- CREATE  INDEX ON "AlleleMotif"("motif_id")
-;
-
- CREATE  UNIQUE    INDEX ON "AllocIds"("name")
-;
-
- CREATE  INDEX ON "Author"("author")
-;
-
- CREATE  UNIQUE    INDEX ON "Batch_tax_id"("batch_id")
-;
-
-
-
-
-
-
- CREATE  INDEX ON "GtyAllele"("unigty_id")
-;
- CREATE  INDEX ON "GtyAllele"("gty_id")
-;
- CREATE  INDEX ON "GtyAllele"("gty_id")
-;
-
-
- CREATE  INDEX ON "LoadHistory"("loaddate")
-;
-
-
-
- CREATE  UNIQUE  INDEX ON "Method"("handle", "loc_method_id")
-;
-
-
-
-
- CREATE  UNIQUE  INDEX ON "Motif"("motif")
-;
-
- CREATE  INDEX ON "ObsGenotype"("obs")
-;
- CREATE  INDEX ON "ObsGenotype"("obs_upp_fix")
-;
- CREATE  INDEX ON "ObsGenotype"("gty_id")
-;
-
- CREATE  UNIQUE  INDEX ON "ObsVariation"("pattern")
-;
- CREATE  INDEX ON "ObsVariation"("univar_id")
-;
-
-
- CREATE  UNIQUE    INDEX ON "OrganismTax"("organism")
-;
- CREATE  INDEX ON "OrganismTax"("tax_id")
-;
- CREATE  INDEX ON "OrganismTax"("species_tax_id")
-;
- CREATE  INDEX ON "OrganismTax"("database_name")
-;
-
-
-
- CREATE  UNIQUE    INDEX ON "Publication"("handle", "title")
-;
-
-
- CREATE  INDEX ON "SNP_tax_id"("tax_id", "snp_id")
-;
-
-
-
-
- CREATE  UNIQUE    INDEX ON "SnpValidationCode"("code")
-;
-
- CREATE  INDEX ON "StrandCode"("abbrev", "rs_to_ss_orien", "code")
-;
-
- CREATE  UNIQUE    INDEX ON "SubSNPDelComm"("comment_id")
-;
-
-
- CREATE  UNIQUE    INDEX ON "Submitter"("handle")
-;
- CREATE  INDEX ON "Submitter"("name")
-;
-
-
- CREATE  UNIQUE  INDEX ON "UniGty"("gty_str")
-;
- CREATE  UNIQUE  INDEX ON "UniGty"("allele_id_1", "allele_id_2")
-;
- CREATE  INDEX ON "UniGty"("allele_id_2")
-;
-
- CREATE  INDEX ON "UniVariAllele"("allele_id")
-;
-
- CREATE  UNIQUE  INDEX ON "UniVariation"("var_str")
-;
- CREATE  INDEX ON "UniVariation"("univar_id", "subsnp_class")
-;
-
-
- CREATE  INDEX ON "VariAllele"("allele_id")
-;
-
- CREATE  UNIQUE  INDEX ON "db_DataDictionaryNew"("tab", "col_order")
-;
-
-
-
-
-
-
-
-
-
- CREATE  UNIQUE    INDEX ON "dn_gty2unigty_trueSNP"("gty_id", "rev_flag")
-;
-
-
+ CREATE  UNIQUE  INDEX ON Allele(allele)\r
+;\r
+ CREATE  INDEX ON Allele(rev_allele_id)\r
+;\r
+\r
+\r
+ CREATE  INDEX ON AlleleMotif(motif_id)\r
+;\r
+\r
+ CREATE  UNIQUE    INDEX ON AllocIds(name)\r
+;\r
+\r
+ CREATE  INDEX ON Author(author)\r
+;\r
+\r
+ CREATE  UNIQUE    INDEX ON Batch_tax_id(batch_id)\r
+;\r
+\r
+\r
+\r
+\r
+\r
+\r
+ CREATE  INDEX ON GtyAllele(unigty_id)\r
+;\r
+ CREATE  INDEX ON GtyAllele(gty_id)\r
+;\r
+ CREATE  INDEX ON GtyAllele(gty_id)\r
+;\r
+\r
+\r
+ CREATE  INDEX ON LoadHistory(loaddate)\r
+;\r
+\r
+\r
+\r
+ CREATE  UNIQUE  INDEX ON Method(handle, loc_method_id)\r
+;\r
+\r
+\r
+\r
+\r
+ CREATE  UNIQUE  INDEX ON Motif(motif)\r
+;\r
+\r
+ CREATE  INDEX ON ObsGenotype(obs)\r
+;\r
+ CREATE  INDEX ON ObsGenotype(obs_upp_fix)\r
+;\r
+ CREATE  INDEX ON ObsGenotype(gty_id)\r
+;\r
+\r
+ CREATE  UNIQUE  INDEX ON ObsVariation(pattern)\r
+;\r
+ CREATE  INDEX ON ObsVariation(univar_id)\r
+;\r
+\r
+\r
+ CREATE  UNIQUE    INDEX ON OrganismTax(organism)\r
+;\r
+ CREATE  INDEX ON OrganismTax(tax_id)\r
+;\r
+ CREATE  INDEX ON OrganismTax(species_tax_id)\r
+;\r
+ CREATE  INDEX ON OrganismTax(database_name)\r
+;\r
+\r
+\r
+\r
+ CREATE  UNIQUE    INDEX ON Publication(handle, title)\r
+;\r
+\r
+\r
+ CREATE  INDEX ON SNP_tax_id(tax_id, snp_id)\r
+;\r
+\r
+\r
+\r
+\r
+ CREATE  UNIQUE    INDEX ON SnpValidationCode(code)\r
+;\r
+\r
+ CREATE  INDEX ON StrandCode(abbrev, rs_to_ss_orien, code)\r
+;\r
+\r
+ CREATE  UNIQUE    INDEX ON SubSNPDelComm(comment_id)\r
+;\r
+\r
+\r
+ CREATE  UNIQUE    INDEX ON Submitter(handle)\r
+;\r
+ CREATE  INDEX ON Submitter(name)\r
+;\r
+\r
+\r
+ CREATE  UNIQUE  INDEX ON UniGty(gty_str)\r
+;\r
+ CREATE  UNIQUE  INDEX ON UniGty(allele_id_1, allele_id_2)\r
+;\r
+ CREATE  INDEX ON UniGty(allele_id_2)\r
+;\r
+\r
+ CREATE  INDEX ON UniVariAllele(allele_id)\r
+;\r
+\r
+ CREATE  UNIQUE  INDEX ON UniVariation(var_str)\r
+;\r
+ CREATE  INDEX ON UniVariation(univar_id, subsnp_class)\r
+;\r
+\r
+\r
+ CREATE  INDEX ON VariAllele(allele_id)\r
+;\r
+\r
+\r
+\r
+\r
+\r
+\r
+\r
+\r
+\r
+ CREATE  UNIQUE    INDEX ON dn_gty2unigty_trueSNP(gty_id, rev_flag)\r
+;\r
+\r
+\r