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

diff --git a/schema/human_9606_schema/human_gty2_constraint.sql b/schema/human_9606_schema/human_gty2_constraint.sql
index def01ce..84802ff 100644
--- a/schema/human_9606_schema/human_gty2_constraint.sql
+++ b/schema/human_9606_schema/human_gty2_constraint.sql
@@ -1,265 +1,73 @@
-ALTER TABLE [SubInd_ch10] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch10] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch10] ADD CONSTRAINT [pk_ch_t_SubInd_ch10]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch11] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch11] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch11] ADD CONSTRAINT [pk_ch_t_SubInd_ch11]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch12] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch12] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch12] ADD CONSTRAINT [pk_ch_t_SubInd_ch12]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch13] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch13] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch13] ADD CONSTRAINT [pk_ch_t_SubInd_ch13]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch14] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch14] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch14] ADD CONSTRAINT [pk_ch_t_SubInd_ch14]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch15] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch15] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch15] ADD CONSTRAINT [pk_ch_t_SubInd_ch15]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch16] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch16] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch16] ADD CONSTRAINT [pk_ch_t_SubInd_ch16]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch17] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch17] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch17] ADD CONSTRAINT [pk_ch_t_SubInd_ch17]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch18] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch18] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch18] ADD CONSTRAINT [pk_ch_t_SubInd_ch18]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch19] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch19] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch19] ADD CONSTRAINT [pk_ch_t_SubInd_ch19]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch20] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch20] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch20] ADD CONSTRAINT [pk_ch_t_SubInd_ch20]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch21] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch21] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch21] ADD CONSTRAINT [pk_ch_t_SubInd_ch21]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch22] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch22] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch22] ADD CONSTRAINT [pk_ch_t_SubInd_ch22]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch8] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch8] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch8] ADD CONSTRAINT [pk_ch_t_SubInd_ch8]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_ch9] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_ch9] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_ch9] ADD CONSTRAINT [pk_ch_t_SubInd_ch9]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_chAltOnly] ADD 
-	CONSTRAINT [pk_SubInd_chAltOnly] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_chAltOnly] ADD CONSTRAINT [pk_SubInd_chAltOnly]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_chMT] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_chMT] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_chMT] ADD CONSTRAINT [pk_ch_t_SubInd_chMT]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_chMulti] ADD 
-	CONSTRAINT [pk_SubInd_chMulti] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_chMulti] ADD CONSTRAINT [pk_SubInd_chMulti]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_chNewSs] ADD 
-	CONSTRAINT [pk_SubInd_chNewSs] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_chNewSs] ADD CONSTRAINT [pk_SubInd_chNewSs]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_chNotOn] ADD 
-	CONSTRAINT [pk_SubInd_chNotOn] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_chNotOn] ADD CONSTRAINT [pk_SubInd_chNotOn]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_chPAR] ADD 
-	CONSTRAINT [pk_SubInd_chPAR] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_chPAR] ADD CONSTRAINT [pk_SubInd_chPAR]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_chUn] ADD 
-	CONSTRAINT [pk_SubInd_chUn] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_chUn] ADD CONSTRAINT [pk_SubInd_chUn]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_chX] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_chX] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_chX] ADD CONSTRAINT [pk_ch_t_SubInd_chX]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
-
-ALTER TABLE [SubInd_chY] ADD 
-	CONSTRAINT [pk_ch_t_SubInd_chY] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[submitted_ind_id],
-		[batch_id],
-		[chr]
-	)
+ALTER TABLE [SubInd_chY] ADD CONSTRAINT [pk_ch_t_SubInd_chY]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)
 GO
 
 
-