X-Git-Url: https://git.donarmstrong.com/?p=dbsnp.git;a=blobdiff_plain;f=schema%2Fshared_schema%2FdbSNP_main_constraint_postgresql.sql;h=e51fe4b5403a528bcb6a625ad50223765520d01e;hp=e01f634b7b4d8d3d3cf263afa3795cac3604e1a1;hb=71dd006316add35b0740e9ecc8f81b67c0c3f736;hpb=9612a14433017a940cb34f070609ea96870a4351

diff --git a/schema/shared_schema/dbSNP_main_constraint_postgresql.sql b/schema/shared_schema/dbSNP_main_constraint_postgresql.sql
index e01f634..e51fe4b 100644
--- a/schema/shared_schema/dbSNP_main_constraint_postgresql.sql
+++ b/schema/shared_schema/dbSNP_main_constraint_postgresql.sql
@@ -8,9 +8,7 @@ ALTER TABLE Author ADD CONSTRAINT pk_Author  PRIMARY KEY   (pub_id,position);
 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 GenomeBuildInfo ADD CONSTRAINT PK_GneomeBuildInfo PRIMARY KEY (snp_build_id,tax_id,is_major);
 
 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);