add shared schema changes for b137

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

diff --git a/schema/shared_schema/dbSNP_main_constraint.sql b/schema/shared_schema/dbSNP_main_constraint.sql
index 57326f775b2a1d1a74d96eb4bb188c2f9785ff3c..01537c83bad7d33a4e6976e87e178f22464cec18 100644 (file)
--- a/schema/shared_schema/dbSNP_main_constraint.sql
+++ b/schema/shared_schema/dbSNP_main_constraint.sql
@@ -20,9 +20,8 @@ GO
 
 
 
-ALTER TABLE [GenomeBuildInfo] ADD CONSTRAINT [df_GenomeBuildInfo_insert_time] DEFAULT (GETDATE()) FOR [insert_time]
-ALTER TABLE [GenomeBuildInfo] ADD CONSTRAINT [df_GenomeBuildInfo_is_major] DEFAULT ((1)) FOR [is_major]
-ALTER TABLE [GenomeBuildInfo] ADD CONSTRAINT [df_GenomeBuildInfo_ncbi_genome_tax_id] DEFAULT ((0)) FOR [ncbi_genome_tax_id]
+ALTER TABLE [GenomeBuildInfo] ADD CONSTRAINT [PK_GenomeBuildInfo]  PRIMARY KEY  CLUSTERED ([snp_build_id] ASC,[tax_id] ASC,[is_major] ASC)\r
+GO
 
 ALTER TABLE [GtyAllele] ADD CONSTRAINT [pk_GtyAllele]  PRIMARY KEY  CLUSTERED ([gty_id] ASC,[rev_flag] ASC,[chr_num] ASC)\r
 GO