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

diff --git a/schema/human_9606_schema/dbSNP_sup_constraint_postgresql.sql b/schema/human_9606_schema/dbSNP_sup_constraint_postgresql.sql
index 11b5424..b2e235b 100644
--- a/schema/human_9606_schema/dbSNP_sup_constraint_postgresql.sql
+++ b/schema/human_9606_schema/dbSNP_sup_constraint_postgresql.sql
@@ -1,118 +1,12 @@
-ALTER TABLE SubSNPAcc_p1_human ADD 
-	CONSTRAINT pk_SubSNPAcc_p1_human PRIMARY KEY   
-	(
-		subsnp_id,
-		acc_type_ind,
-		acc_part
-	),
-	ADD CONSTRAINT ck_SubSNPAcc_p1_human CHECK (subsnp_id >= 1 and subsnp_id <= 10000000)
-;
-
-ALTER TABLE SubSNPAcc_p2_human ADD 
-	CONSTRAINT pk_SubSNPAcc_p2_human PRIMARY KEY   
-	(
-		subsnp_id,
-		acc_type_ind,
-		acc_part
-	), ADD
- 	CONSTRAINT ck_SubSNPAcc_p2_human CHECK (subsnp_id >= 10000001 and subsnp_id <= 20000000)
-;
-
-ALTER TABLE SubSNPAcc_p3_human ADD 
-	CONSTRAINT pk_SubSNPAcc_p3 PRIMARY KEY   
-	(
-		subsnp_id,
-		acc_type_ind,
-		acc_part
-	), ADD
-	CONSTRAINT ck_SubSNPAcc_p3 CHECK (subsnp_id >= 20000001 and subsnp_id <= 30000000)
-;
-
-ALTER TABLE SubSNPCommLine_p1_human ADD 
-	CONSTRAINT pk_SubSNPCommLine_p1_human PRIMARY KEY   
-	(
-		subsnp_id,
-		line_num
-	), ADD
-	CONSTRAINT ck_SubSNPCommLine_p1_human CHECK (subsnp_id >= 1 and subsnp_id <= 10000000)
-;
-
-ALTER TABLE SubSNPCommLine_p2_human ADD 
-	CONSTRAINT pk_SubSNPCommLine_p2_human PRIMARY KEY   
-	(
-		subsnp_id,
-		line_num
-	), ADD
-	CONSTRAINT ck_SubSNPCommLine_p2_human CHECK (subsnp_id >= 10000001 and subsnp_id <= 20000000)
-;
-
-ALTER TABLE SubSNPCommLine_p3_human ADD 
-	CONSTRAINT pk_SubSNPCommLine_p3 PRIMARY KEY   
-	(
-		subsnp_id,
-		line_num
-	), ADD
-	CONSTRAINT ck_SubSNPCommLine_p3 CHECK (subsnp_id >= 20000001 and subsnp_id <= 30000000)
-;
-
-ALTER TABLE SubSNPSeq3_p1_human ADD 
-	CONSTRAINT pk_SubSNPSeq3_p1_human PRIMARY KEY   
-	(
-		subsnp_id,
-		type,
-		line_num
-	), ADD
-	CONSTRAINT ck_SubSNPSeq3_p1_human CHECK (subsnp_id >= 1 and subsnp_id <= 10000000)
-;
-
-ALTER TABLE SubSNPSeq3_p2_human ADD 
-	CONSTRAINT pk_SubSNPSeq3_p2_human PRIMARY KEY   
-	(
-		subsnp_id,
-		type,
-		line_num
-	), ADD
-	CONSTRAINT ck_SubSNPSeq3_p2_human CHECK (subsnp_id >= 10000001 and subsnp_id <= 20000000)
-;
-
-ALTER TABLE SubSNPSeq3_p3_human ADD 
-	CONSTRAINT pk_SubSNPSeq3_p3 PRIMARY KEY   
-	(
-		subsnp_id,
-		type,
-		line_num
-	), ADD
-	CONSTRAINT ck_SubSNPSeq3_p3 CHECK (subsnp_id >= 20000001 and subsnp_id <= 30000000)
-;
-
-ALTER TABLE SubSNPSeq5_p1_human ADD 
-	CONSTRAINT pk_SubSNPSeq5_p1_human PRIMARY KEY   
-	(
-		subsnp_id,
-		type,
-		line_num
-	), ADD
-	CONSTRAINT ck_SubSNPSeq5_p1_human CHECK (subsnp_id >= 1 and subsnp_id <= 10000000)
-;
-
-ALTER TABLE SubSNPSeq5_p2_human ADD 
-	CONSTRAINT pk_SubSNPSeq5_p2_human PRIMARY KEY   
-	(
-		subsnp_id,
-		type,
-		line_num
-	), ADD
-	CONSTRAINT ck_SubSNPSeq5_p2_human CHECK (subsnp_id >= 10000001 and subsnp_id <= 20000000)
-;
-
-ALTER TABLE SubSNPSeq5_p3_human ADD 
-	CONSTRAINT pk_SubSNPSeq5_p3 PRIMARY KEY   
-	(
-		subsnp_id,
-		type,
-		line_num
-	), ADD
-	CONSTRAINT ck_SubSNPSeq5_p3 CHECK (subsnp_id >= 20000001 and subsnp_id <= 30000000)
-;
-
-
+ALTER TABLE SubSNPAcc_p1_human ADD CONSTRAINT pk_SubSNPAcc_p1_human  PRIMARY KEY  (subsnp_id,acc_type_ind,acc_part);
+ALTER TABLE SubSNPAcc_p2_human ADD CONSTRAINT pk_SubSNPAcc_p2_human  PRIMARY KEY  (subsnp_id,acc_type_ind,acc_part);
+ALTER TABLE SubSNPAcc_p3_human ADD CONSTRAINT pk_SubSNPAcc_p3  PRIMARY KEY  (subsnp_id,acc_type_ind,acc_part);
+ALTER TABLE SubSNPCommLine_p1_human ADD CONSTRAINT pk_SubSNPCommLine_p1_human  PRIMARY KEY  (subsnp_id,line_num);
+ALTER TABLE SubSNPCommLine_p2_human ADD CONSTRAINT pk_SubSNPCommLine_p2_human  PRIMARY KEY  (subsnp_id,line_num);
+ALTER TABLE SubSNPCommLine_p3_human ADD CONSTRAINT pk_SubSNPCommLine_p3  PRIMARY KEY  (subsnp_id,line_num);
+ALTER TABLE SubSNPSeq3_p1_human ADD CONSTRAINT pk_SubSNPSeq3_p1_human  PRIMARY KEY  (subsnp_id,type,line_num);
+ALTER TABLE SubSNPSeq3_p2_human ADD CONSTRAINT pk_SubSNPSeq3_p2_human  PRIMARY KEY  (subsnp_id,type,line_num);
+ALTER TABLE SubSNPSeq3_p3_human ADD CONSTRAINT pk_SubSNPSeq3_p3  PRIMARY KEY  (subsnp_id,type,line_num);
+ALTER TABLE SubSNPSeq5_p1_human ADD CONSTRAINT pk_SubSNPSeq5_p1_human  PRIMARY KEY  (subsnp_id,type,line_num);
+ALTER TABLE SubSNPSeq5_p2_human ADD CONSTRAINT pk_SubSNPSeq5_p2_human  PRIMARY KEY  (subsnp_id,type,line_num);
+ALTER TABLE SubSNPSeq5_p3_human ADD CONSTRAINT pk_SubSNPSeq5_p3  PRIMARY KEY  (subsnp_id,type,line_num);