add shared schema changes for b137

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

diff --git a/schema/shared_schema/dbSNP_main_constraint_postgresql.sql b/schema/shared_schema/dbSNP_main_constraint_postgresql.sql
index e01f634b7b4d8d3d3cf263afa3795cac3604e1a1..e51fe4b5403a528bcb6a625ad50223765520d01e 100644 (file)
--- 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);