update to build 135 schema

[dbsnp.git] / schema / human_9606_schema / dbSNP_sup_constraint.sql

diff --git a/schema/human_9606_schema/dbSNP_sup_constraint.sql b/schema/human_9606_schema/dbSNP_sup_constraint.sql
index 3525ab57748a1bcb12e4526f7856f6f66bbbfdf5..10af6bd3da2b7df9f93b0815164857f238fe260f 100644 (file)
--- 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)\r
 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)\r
 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)\r
 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)\r
 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)\r
 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)\r
 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)\r
 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)\r
 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)\r
 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)\r
 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)\r
 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)\r
 GO
 
 
-