X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_gty2_constraint_postgresql.sql;h=2b2612278878239e64aa4a50f8b6b5f2170aefae;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=2c5b27e2b5194913b5e451dac4657c19122657e4;hpb=ea7460b34b8123c023d3f73296a9cb5f7703abbe;p=dbsnp.git

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