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

diff --git a/schema/shared_schema/dbSNP_main_constraint.sql b/schema/shared_schema/dbSNP_main_constraint.sql
index 57326f7..01537c8 100644
--- 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)
+GO
 
 ALTER TABLE [GtyAllele] ADD CONSTRAINT [pk_GtyAllele]  PRIMARY KEY  CLUSTERED ([gty_id] ASC,[rev_flag] ASC,[chr_num] ASC)
 GO