X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2FdbSNP_sup_constraint.sql;h=10af6bd3da2b7df9f93b0815164857f238fe260f;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=3525ab57748a1bcb12e4526f7856f6f66bbbfdf5;hpb=ea7460b34b8123c023d3f73296a9cb5f7703abbe;p=dbsnp.git

diff --git a/schema/human_9606_schema/dbSNP_sup_constraint.sql b/schema/human_9606_schema/dbSNP_sup_constraint.sql
index 3525ab5..10af6bd 100644
--- a/schema/human_9606_schema/dbSNP_sup_constraint.sql
+++ b/schema/human_9606_schema/dbSNP_sup_constraint.sql
@@ -1,130 +1,37 @@
-ALTER TABLE [SubSNPAcc_p1_human] ADD 
-	CONSTRAINT [pk_SubSNPAcc_p1_human] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[acc_type_ind],
-		[acc_part]
-	),
-	CONSTRAINT [ck_SubSNPAcc_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
+ALTER TABLE [SubSNPAcc_p1_human] ADD CONSTRAINT [pk_SubSNPAcc_p1_human]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[acc_type_ind] ASC,[acc_part] ASC)
 GO
 
-
-ALTER TABLE [SubSNPAcc_p2_human] ADD 
-	CONSTRAINT [pk_SubSNPAcc_p2_human] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[acc_type_ind],
-		[acc_part]
-	),
-	CONSTRAINT [ck_SubSNPAcc_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
+ALTER TABLE [SubSNPAcc_p2_human] ADD CONSTRAINT [pk_SubSNPAcc_p2_human]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[acc_type_ind] ASC,[acc_part] ASC)
 GO
 
-
-ALTER TABLE [SubSNPAcc_p3_human] ADD 
-	CONSTRAINT [pk_SubSNPAcc_p3] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[acc_type_ind],
-		[acc_part]
-	),
-	CONSTRAINT [ck_SubSNPAcc_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
+ALTER TABLE [SubSNPAcc_p3_human] ADD CONSTRAINT [pk_SubSNPAcc_p3]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[acc_type_ind] ASC,[acc_part] ASC)
 GO
 
-
-ALTER TABLE [SubSNPCommLine_p1_human] ADD 
-	CONSTRAINT [pk_SubSNPCommLine_p1_human] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPCommLine_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
+ALTER TABLE [SubSNPCommLine_p1_human] ADD CONSTRAINT [pk_SubSNPCommLine_p1_human]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPCommLine_p2_human] ADD 
-	CONSTRAINT [pk_SubSNPCommLine_p2_human] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPCommLine_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
+ALTER TABLE [SubSNPCommLine_p2_human] ADD CONSTRAINT [pk_SubSNPCommLine_p2_human]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPCommLine_p3_human] ADD 
-	CONSTRAINT [pk_SubSNPCommLine_p3] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPCommLine_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
+ALTER TABLE [SubSNPCommLine_p3_human] ADD CONSTRAINT [pk_SubSNPCommLine_p3]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPSeq3_p1_human] ADD 
-	CONSTRAINT [pk_SubSNPSeq3_p1_human] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[type],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPSeq3_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
+ALTER TABLE [SubSNPSeq3_p1_human] ADD CONSTRAINT [pk_SubSNPSeq3_p1_human]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[type] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPSeq3_p2_human] ADD 
-	CONSTRAINT [pk_SubSNPSeq3_p2_human] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[type],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPSeq3_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
+ALTER TABLE [SubSNPSeq3_p2_human] ADD CONSTRAINT [pk_SubSNPSeq3_p2_human]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[type] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPSeq3_p3_human] ADD 
-	CONSTRAINT [pk_SubSNPSeq3_p3] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[type],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPSeq3_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
+ALTER TABLE [SubSNPSeq3_p3_human] ADD CONSTRAINT [pk_SubSNPSeq3_p3]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[type] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPSeq5_p1_human] ADD 
-	CONSTRAINT [pk_SubSNPSeq5_p1_human] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[type],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPSeq5_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
+ALTER TABLE [SubSNPSeq5_p1_human] ADD CONSTRAINT [pk_SubSNPSeq5_p1_human]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[type] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPSeq5_p2_human] ADD 
-	CONSTRAINT [pk_SubSNPSeq5_p2_human] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[type],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPSeq5_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
+ALTER TABLE [SubSNPSeq5_p2_human] ADD CONSTRAINT [pk_SubSNPSeq5_p2_human]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[type] ASC,[line_num] ASC)
 GO
 
-
-ALTER TABLE [SubSNPSeq5_p3_human] ADD 
-	CONSTRAINT [pk_SubSNPSeq5_p3] PRIMARY KEY  CLUSTERED 
-	(
-		[subsnp_id],
-		[type],
-		[line_num]
-	),
-	CONSTRAINT [ck_SubSNPSeq5_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
+ALTER TABLE [SubSNPSeq5_p3_human] ADD CONSTRAINT [pk_SubSNPSeq5_p3]  PRIMARY KEY  CLUSTERED ([subsnp_id] ASC,[type] ASC,[line_num] ASC)
 GO
 
 
-