X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_gty1_constraint.sql;h=4eca20f4e486f8efda8f25b84bc44ff442471dcc;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=f2a495a13dcc1c0e2f1058b8525f094a702260dd;hpb=6e51d2d339036d36e6294b1bbed27e5c18a6a2f5;p=dbsnp.git

diff --git a/schema/human_9606_schema/human_gty1_constraint.sql b/schema/human_9606_schema/human_gty1_constraint.sql
index f2a495a..4eca20f 100644
--- a/schema/human_9606_schema/human_gty1_constraint.sql
+++ b/schema/human_9606_schema/human_gty1_constraint.sql
@@ -1,78 +1,22 @@
-ALTER TABLE [SubInd_ch1] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch1] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch1] ADD CONSTRAINT [pk_ch_t_SubInd_ch1]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch2] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch2] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch2] ADD CONSTRAINT [pk_ch_t_SubInd_ch2]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch3] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch3] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch3] ADD CONSTRAINT [pk_ch_t_SubInd_ch3]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch4] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch4] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch4] ADD CONSTRAINT [pk_ch_t_SubInd_ch4]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch5] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch5] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch5] ADD CONSTRAINT [pk_ch_t_SubInd_ch5]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch6] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch6] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch6] ADD CONSTRAINT [pk_ch_t_SubInd_ch6]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch7] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch7] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch7] ADD CONSTRAINT [pk_ch_t_SubInd_ch7]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
 
-