From 2463fb6da871eef907dccadc3423931b9180a9a1 Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Mon, 12 Dec 2011 14:58:19 -0800 Subject: [PATCH] ditch ASC missed --- .../dbSNP_main_constraint_postgresql.sql | 90 +++++++++---------- .../dbSNP_main_index_postgresql.sql | 14 +-- 2 files changed, 52 insertions(+), 52 deletions(-) diff --git a/schema/shared_schema/dbSNP_main_constraint_postgresql.sql b/schema/shared_schema/dbSNP_main_constraint_postgresql.sql index 66edbcf..e01f634 100644 --- a/schema/shared_schema/dbSNP_main_constraint_postgresql.sql +++ b/schema/shared_schema/dbSNP_main_constraint_postgresql.sql @@ -1,67 +1,67 @@ -ALTER TABLE Allele ADD CONSTRAINT pk_Allele PRIMARY KEY (allele_id ASC); -ALTER TABLE AlleleFlagCode ADD CONSTRAINT pk_AlleleFlagCode PRIMARY KEY (code ASC); -ALTER TABLE AlleleMotif ADD CONSTRAINT pk_AlleleMotif PRIMARY KEY (allele_id ASC,motif_order ASC); -ALTER TABLE AllocIds ADD CONSTRAINT pk_AllocIds PRIMARY KEY (name ASC); -ALTER TABLE Author ADD CONSTRAINT pk_Author PRIMARY KEY (pub_id ASC,position ASC); +ALTER TABLE Allele ADD CONSTRAINT pk_Allele PRIMARY KEY (allele_id); +ALTER TABLE AlleleFlagCode ADD CONSTRAINT pk_AlleleFlagCode PRIMARY KEY (code); +ALTER TABLE AlleleMotif ADD CONSTRAINT pk_AlleleMotif PRIMARY KEY (allele_id,motif_order); +ALTER TABLE AllocIds ADD CONSTRAINT pk_AllocIds PRIMARY KEY (name); +ALTER TABLE Author ADD CONSTRAINT pk_Author PRIMARY KEY (pub_id,position); -ALTER TABLE CpGCode ADD CONSTRAINT pk_CpGCode PRIMARY KEY (code ASC); +ALTER TABLE CpGCode ADD CONSTRAINT pk_CpGCode PRIMARY KEY (code); ALTER TABLE GenomeBuildInfo ALTER COLUMN insert_time SET DEFAULT NOW(); ALTER TABLE GenomeBuildInfo ALTER COLUMN is_major SET DEFAULT (1); ALTER TABLE GenomeBuildInfo ALTER COLUMN ncbi_genome_tax_id SET DEFAULT (0); -ALTER TABLE GtyAllele ADD CONSTRAINT pk_GtyAllele PRIMARY KEY (gty_id ASC,rev_flag ASC,chr_num ASC); -ALTER TABLE IUPACna ADD CONSTRAINT pk_IUPACna PRIMARY KEY (allele ASC); -ALTER TABLE LoadHistory ADD CONSTRAINT pk_LoadHistory PRIMARY KEY (build_id ASC); +ALTER TABLE GtyAllele ADD CONSTRAINT pk_GtyAllele PRIMARY KEY (gty_id,rev_flag,chr_num); +ALTER TABLE IUPACna ADD CONSTRAINT pk_IUPACna PRIMARY KEY (allele); +ALTER TABLE LoadHistory ADD CONSTRAINT pk_LoadHistory PRIMARY KEY (build_id); ALTER TABLE LocTypeCode ALTER COLUMN create_time SET DEFAULT NOW(); -ALTER TABLE LocTypeCode ADD CONSTRAINT pk_LocTypeCode PRIMARY KEY (code ASC); -ALTER TABLE MapLinkCode ADD CONSTRAINT pk_MapLinkCode PRIMARY KEY (which_code ASC,code ASC); -ALTER TABLE Method ADD CONSTRAINT pk_Method_mid PRIMARY KEY (method_id ASC); -ALTER TABLE MethodClass ADD CONSTRAINT pk_MethodClass PRIMARY KEY (meth_class_id ASC); -ALTER TABLE MethodLine ADD CONSTRAINT pk_MethodLine PRIMARY KEY (method_id ASC,line_num ASC); -ALTER TABLE Moltype ADD CONSTRAINT pk_Moltype PRIMARY KEY (code ASC); -ALTER TABLE Motif ADD CONSTRAINT pk_Motif PRIMARY KEY (motif_id ASC); -ALTER TABLE ObsGenotype ADD CONSTRAINT pk_ObsGenotype PRIMARY KEY (gty_id ASC); +ALTER TABLE LocTypeCode ADD CONSTRAINT pk_LocTypeCode PRIMARY KEY (code); +ALTER TABLE MapLinkCode ADD CONSTRAINT pk_MapLinkCode PRIMARY KEY (which_code,code); +ALTER TABLE Method ADD CONSTRAINT pk_Method_mid PRIMARY KEY (method_id); +ALTER TABLE MethodClass ADD CONSTRAINT pk_MethodClass PRIMARY KEY (meth_class_id); +ALTER TABLE MethodLine ADD CONSTRAINT pk_MethodLine PRIMARY KEY (method_id,line_num); +ALTER TABLE Moltype ADD CONSTRAINT pk_Moltype PRIMARY KEY (code); +ALTER TABLE Motif ADD CONSTRAINT pk_Motif PRIMARY KEY (motif_id); +ALTER TABLE ObsGenotype ADD CONSTRAINT pk_ObsGenotype PRIMARY KEY (gty_id); ALTER TABLE ObsVariation ALTER COLUMN create_time SET DEFAULT NOW(); ALTER TABLE ObsVariation ALTER COLUMN last_updated_time SET DEFAULT NOW(); -ALTER TABLE ObsVariation ADD CONSTRAINT pk_ObsVariation PRIMARY KEY (var_id ASC); -ALTER TABLE OrgDbStatus ADD CONSTRAINT pk_org_db_status PRIMARY KEY (database_name ASC); -ALTER TABLE OrganismTax ADD CONSTRAINT pk_organism PRIMARY KEY (tax_id ASC); -ALTER TABLE PopClass ADD CONSTRAINT pk_PopClass PRIMARY KEY (pop_id ASC,pop_class_id ASC); -ALTER TABLE PopClassCode ADD CONSTRAINT PK__PopClassCode__270595B6 PRIMARY KEY (pop_class_id ASC); -ALTER TABLE Publication ADD CONSTRAINT pk_Publication PRIMARY KEY (pub_id ASC); +ALTER TABLE ObsVariation ADD CONSTRAINT pk_ObsVariation PRIMARY KEY (var_id); +ALTER TABLE OrgDbStatus ADD CONSTRAINT pk_org_db_status PRIMARY KEY (database_name); +ALTER TABLE OrganismTax ADD CONSTRAINT pk_organism PRIMARY KEY (tax_id); +ALTER TABLE PopClass ADD CONSTRAINT pk_PopClass PRIMARY KEY (pop_id,pop_class_id); +ALTER TABLE PopClassCode ADD CONSTRAINT PK__PopClassCode__270595B6 PRIMARY KEY (pop_class_id); +ALTER TABLE Publication ADD CONSTRAINT pk_Publication PRIMARY KEY (pub_id); ALTER TABLE SNPGlossary ALTER COLUMN last_updated SET DEFAULT NOW(); -ALTER TABLE SNPGlossary ADD CONSTRAINT pk_SNPGlossary PRIMARY KEY (term ASC); +ALTER TABLE SNPGlossary ADD CONSTRAINT pk_SNPGlossary PRIMARY KEY (term); ALTER TABLE SNP_tax_id ALTER COLUMN status SET DEFAULT 'C'; -ALTER TABLE SNP_tax_id ADD CONSTRAINT pk_SNP_tax_id PRIMARY KEY (snp_id ASC); -ALTER TABLE SnpChrCode ADD CONSTRAINT pk_SnpChrCode PRIMARY KEY (code ASC); -ALTER TABLE SnpClassCode ADD CONSTRAINT pk_SnpClassCode PRIMARY KEY (code ASC); -ALTER TABLE SnpFunctionCode ADD CONSTRAINT pk_SnpFunctionCode PRIMARY KEY (code ASC); -ALTER TABLE SnpValidationCode ADD CONSTRAINT pk_SnpValidationCode PRIMARY KEY (code ASC); -ALTER TABLE StrandCode ADD CONSTRAINT pk_StrandCode PRIMARY KEY (code ASC); +ALTER TABLE SNP_tax_id ADD CONSTRAINT pk_SNP_tax_id PRIMARY KEY (snp_id); +ALTER TABLE SnpChrCode ADD CONSTRAINT pk_SnpChrCode PRIMARY KEY (code); +ALTER TABLE SnpClassCode ADD CONSTRAINT pk_SnpClassCode PRIMARY KEY (code); +ALTER TABLE SnpFunctionCode ADD CONSTRAINT pk_SnpFunctionCode PRIMARY KEY (code); +ALTER TABLE SnpValidationCode ADD CONSTRAINT pk_SnpValidationCode PRIMARY KEY (code); +ALTER TABLE StrandCode ADD CONSTRAINT pk_StrandCode PRIMARY KEY (code); ALTER TABLE Submitter ALTER COLUMN create_time SET DEFAULT NOW(); -ALTER TABLE Submitter ADD CONSTRAINT pk_Submitter PRIMARY KEY (handle ASC); -ALTER TABLE TemplateType ADD CONSTRAINT pk_TemplateType PRIMARY KEY (temp_type_id ASC); -ALTER TABLE UniGty ADD CONSTRAINT pk_UniGty PRIMARY KEY (unigty_id ASC); -ALTER TABLE UniVariAllele ADD CONSTRAINT pk_UniVariAllele PRIMARY KEY (univar_id ASC,allele_id ASC); -ALTER TABLE UniVariation ADD CONSTRAINT pk_UniVariation PRIMARY KEY (univar_id ASC); -ALTER TABLE UniVariationSrcCode ADD CONSTRAINT pk_UniVariationSrcCode PRIMARY KEY (code ASC); -ALTER TABLE VariAllele ADD CONSTRAINT pk_VariAllele PRIMARY KEY (var_id ASC,allele_id ASC); +ALTER TABLE Submitter ADD CONSTRAINT pk_Submitter PRIMARY KEY (handle); +ALTER TABLE TemplateType ADD CONSTRAINT pk_TemplateType PRIMARY KEY (temp_type_id); +ALTER TABLE UniGty ADD CONSTRAINT pk_UniGty PRIMARY KEY (unigty_id); +ALTER TABLE UniVariAllele ADD CONSTRAINT pk_UniVariAllele PRIMARY KEY (univar_id,allele_id); +ALTER TABLE UniVariation ADD CONSTRAINT pk_UniVariation PRIMARY KEY (univar_id); +ALTER TABLE UniVariationSrcCode ADD CONSTRAINT pk_UniVariationSrcCode PRIMARY KEY (code); +ALTER TABLE VariAllele ADD CONSTRAINT pk_VariAllele PRIMARY KEY (var_id,allele_id); ALTER TABLE db_ftp_table_list ALTER COLUMN create_time SET DEFAULT NOW(); -ALTER TABLE db_ftp_table_list ADD CONSTRAINT pk_db_ftp_table_list PRIMARY KEY (table_name ASC); +ALTER TABLE db_ftp_table_list ADD CONSTRAINT pk_db_ftp_table_list PRIMARY KEY (table_name); ALTER TABLE db_map_table_name ALTER COLUMN inNonHuman SET DEFAULT 'N'; -ALTER TABLE db_map_table_name ADD CONSTRAINT pk_db_map_table_name PRIMARY KEY (table_name ASC); -ALTER TABLE dn_Allele_rev ADD CONSTRAINT pk_dn_Allele_rev PRIMARY KEY (allele_id ASC,rev_flag ASC); -ALTER TABLE dn_Motif_rev ADD CONSTRAINT pk_dn_Motif_rev PRIMARY KEY (motif_id ASC,rev_flag ASC); -ALTER TABLE dn_UniGty_allele ADD CONSTRAINT pk_dn_UniGty_allele PRIMARY KEY (unigty_id ASC,chr_num ASC); -ALTER TABLE dn_UniGty_rev ADD CONSTRAINT pk_dn_Gty_rev PRIMARY KEY (unigty_id ASC,rev_flag ASC); -ALTER TABLE dn_UniVariation_rev ADD CONSTRAINT pk_dn_UniVariation_rev PRIMARY KEY (univar_id ASC,rev_flag ASC); +ALTER TABLE db_map_table_name ADD CONSTRAINT pk_db_map_table_name PRIMARY KEY (table_name); +ALTER TABLE dn_Allele_rev ADD CONSTRAINT pk_dn_Allele_rev PRIMARY KEY (allele_id,rev_flag); +ALTER TABLE dn_Motif_rev ADD CONSTRAINT pk_dn_Motif_rev PRIMARY KEY (motif_id,rev_flag); +ALTER TABLE dn_UniGty_allele ADD CONSTRAINT pk_dn_UniGty_allele PRIMARY KEY (unigty_id,chr_num); +ALTER TABLE dn_UniGty_rev ADD CONSTRAINT pk_dn_Gty_rev PRIMARY KEY (unigty_id,rev_flag); +ALTER TABLE dn_UniVariation_rev ADD CONSTRAINT pk_dn_UniVariation_rev PRIMARY KEY (univar_id,rev_flag); ALTER TABLE dn_summary ALTER COLUMN create_time SET DEFAULT NOW(); ALTER TABLE dn_summary ALTER COLUMN last_updated_time SET DEFAULT NOW(); -ALTER TABLE dn_summary ADD CONSTRAINT PK__dn_summary__3651FAE7 PRIMARY KEY (tax_id ASC,build_id ASC,type ASC); +ALTER TABLE dn_summary ADD CONSTRAINT PK__dn_summary__3651FAE7 PRIMARY KEY (tax_id,build_id,type); diff --git a/schema/shared_schema/dbSNP_main_index_postgresql.sql b/schema/shared_schema/dbSNP_main_index_postgresql.sql index 4162f20..311c7fd 100644 --- a/schema/shared_schema/dbSNP_main_index_postgresql.sql +++ b/schema/shared_schema/dbSNP_main_index_postgresql.sql @@ -8,7 +8,7 @@ CREATE INDEX ON GtyAllele (unigty_id); CREATE INDEX ON GtyAllele (gty_id); CREATE INDEX ON GtyAllele (gty_id); CREATE INDEX ON LoadHistory (loaddate); -CREATE INDEX ON Method (handle ASC,loc_method_id); +CREATE INDEX ON Method (handle,loc_method_id); CREATE INDEX ON Motif (motif); CREATE INDEX ON ObsGenotype (obs); CREATE INDEX ON ObsGenotype (obs_upp_fix); @@ -19,18 +19,18 @@ CREATE INDEX ON OrganismTax (organism); CREATE INDEX ON OrganismTax (tax_id); CREATE INDEX ON OrganismTax (species_tax_id); CREATE INDEX ON OrganismTax (database_name); -CREATE INDEX ON Publication (handle ASC,title); -CREATE INDEX ON SNP_tax_id (tax_id ASC,snp_id); +CREATE INDEX ON Publication (handle,title); +CREATE INDEX ON SNP_tax_id (tax_id,snp_id); CREATE INDEX ON SnpValidationCode (code); -CREATE INDEX ON StrandCode (abbrev ASC,rs_to_ss_orien ASC,code); +CREATE INDEX ON StrandCode (abbrev,rs_to_ss_orien,code); CREATE INDEX ON SubSNPDelComm (comment_id); CREATE INDEX ON Submitter (handle); CREATE INDEX ON Submitter (name); CREATE INDEX ON UniGty (gty_str); -CREATE INDEX ON UniGty (allele_id_1 ASC,allele_id_2); +CREATE INDEX ON UniGty (allele_id_1,allele_id_2); CREATE INDEX ON UniGty (allele_id_2); CREATE INDEX ON UniVariAllele (allele_id); CREATE INDEX ON UniVariation (var_str); -CREATE INDEX ON UniVariation (univar_id ASC,subsnp_class); +CREATE INDEX ON UniVariation (univar_id,subsnp_class); CREATE INDEX ON VariAllele (allele_id); -CREATE INDEX ON dn_gty2unigty_trueSNP (gty_id ASC,rev_flag); +CREATE INDEX ON dn_gty2unigty_trueSNP (gty_id,rev_flag); -- 2.39.2