1 ALTER TABLE [SubSNPAcc_p1_human] ADD
2 CONSTRAINT [pk_SubSNPAcc_p1_human] PRIMARY KEY CLUSTERED
8 CONSTRAINT [ck_SubSNPAcc_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
12 ALTER TABLE [SubSNPAcc_p2_human] ADD
13 CONSTRAINT [pk_SubSNPAcc_p2_human] PRIMARY KEY CLUSTERED
19 CONSTRAINT [ck_SubSNPAcc_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
23 ALTER TABLE [SubSNPAcc_p3_human] ADD
24 CONSTRAINT [pk_SubSNPAcc_p3] PRIMARY KEY CLUSTERED
30 CONSTRAINT [ck_SubSNPAcc_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
34 ALTER TABLE [SubSNPCommLine_p1_human] ADD
35 CONSTRAINT [pk_SubSNPCommLine_p1_human] PRIMARY KEY CLUSTERED
40 CONSTRAINT [ck_SubSNPCommLine_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
44 ALTER TABLE [SubSNPCommLine_p2_human] ADD
45 CONSTRAINT [pk_SubSNPCommLine_p2_human] PRIMARY KEY CLUSTERED
50 CONSTRAINT [ck_SubSNPCommLine_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
54 ALTER TABLE [SubSNPCommLine_p3_human] ADD
55 CONSTRAINT [pk_SubSNPCommLine_p3] PRIMARY KEY CLUSTERED
60 CONSTRAINT [ck_SubSNPCommLine_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
64 ALTER TABLE [SubSNPSeq3_p1_human] ADD
65 CONSTRAINT [pk_SubSNPSeq3_p1_human] PRIMARY KEY CLUSTERED
71 CONSTRAINT [ck_SubSNPSeq3_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
75 ALTER TABLE [SubSNPSeq3_p2_human] ADD
76 CONSTRAINT [pk_SubSNPSeq3_p2_human] PRIMARY KEY CLUSTERED
82 CONSTRAINT [ck_SubSNPSeq3_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
86 ALTER TABLE [SubSNPSeq3_p3_human] ADD
87 CONSTRAINT [pk_SubSNPSeq3_p3] PRIMARY KEY CLUSTERED
93 CONSTRAINT [ck_SubSNPSeq3_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
97 ALTER TABLE [SubSNPSeq5_p1_human] ADD
98 CONSTRAINT [pk_SubSNPSeq5_p1_human] PRIMARY KEY CLUSTERED
104 CONSTRAINT [ck_SubSNPSeq5_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
108 ALTER TABLE [SubSNPSeq5_p2_human] ADD
109 CONSTRAINT [pk_SubSNPSeq5_p2_human] PRIMARY KEY CLUSTERED
115 CONSTRAINT [ck_SubSNPSeq5_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
119 ALTER TABLE [SubSNPSeq5_p3_human] ADD
120 CONSTRAINT [pk_SubSNPSeq5_p3] PRIMARY KEY CLUSTERED
126 CONSTRAINT [ck_SubSNPSeq5_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)