1 ALTER TABLE SubSNPAcc_p1_human ADD
2 CONSTRAINT pk_SubSNPAcc_p1_human PRIMARY KEY
8 ADD CONSTRAINT ck_SubSNPAcc_p1_human CHECK (subsnp_id >= 1 and subsnp_id <= 10000000)
11 ALTER TABLE SubSNPAcc_p2_human ADD
12 CONSTRAINT pk_SubSNPAcc_p2_human PRIMARY KEY
18 CONSTRAINT ck_SubSNPAcc_p2_human CHECK (subsnp_id >= 10000001 and subsnp_id <= 20000000)
21 ALTER TABLE SubSNPAcc_p3_human ADD
22 CONSTRAINT pk_SubSNPAcc_p3 PRIMARY KEY
28 CONSTRAINT ck_SubSNPAcc_p3 CHECK (subsnp_id >= 20000001 and subsnp_id <= 30000000)
31 ALTER TABLE SubSNPCommLine_p1_human ADD
32 CONSTRAINT pk_SubSNPCommLine_p1_human PRIMARY KEY
37 CONSTRAINT ck_SubSNPCommLine_p1_human CHECK (subsnp_id >= 1 and subsnp_id <= 10000000)
40 ALTER TABLE SubSNPCommLine_p2_human ADD
41 CONSTRAINT pk_SubSNPCommLine_p2_human PRIMARY KEY
46 CONSTRAINT ck_SubSNPCommLine_p2_human CHECK (subsnp_id >= 10000001 and subsnp_id <= 20000000)
49 ALTER TABLE SubSNPCommLine_p3_human ADD
50 CONSTRAINT pk_SubSNPCommLine_p3 PRIMARY KEY
55 CONSTRAINT ck_SubSNPCommLine_p3 CHECK (subsnp_id >= 20000001 and subsnp_id <= 30000000)
58 ALTER TABLE SubSNPSeq3_p1_human ADD
59 CONSTRAINT pk_SubSNPSeq3_p1_human PRIMARY KEY
65 CONSTRAINT ck_SubSNPSeq3_p1_human CHECK (subsnp_id >= 1 and subsnp_id <= 10000000)
68 ALTER TABLE SubSNPSeq3_p2_human ADD
69 CONSTRAINT pk_SubSNPSeq3_p2_human PRIMARY KEY
75 CONSTRAINT ck_SubSNPSeq3_p2_human CHECK (subsnp_id >= 10000001 and subsnp_id <= 20000000)
78 ALTER TABLE SubSNPSeq3_p3_human ADD
79 CONSTRAINT pk_SubSNPSeq3_p3 PRIMARY KEY
85 CONSTRAINT ck_SubSNPSeq3_p3 CHECK (subsnp_id >= 20000001 and subsnp_id <= 30000000)
88 ALTER TABLE SubSNPSeq5_p1_human ADD
89 CONSTRAINT pk_SubSNPSeq5_p1_human PRIMARY KEY
95 CONSTRAINT ck_SubSNPSeq5_p1_human CHECK (subsnp_id >= 1 and subsnp_id <= 10000000)
98 ALTER TABLE SubSNPSeq5_p2_human ADD
99 CONSTRAINT pk_SubSNPSeq5_p2_human PRIMARY KEY
105 CONSTRAINT ck_SubSNPSeq5_p2_human CHECK (subsnp_id >= 10000001 and subsnp_id <= 20000000)
108 ALTER TABLE SubSNPSeq5_p3_human ADD
109 CONSTRAINT pk_SubSNPSeq5_p3 PRIMARY KEY
115 CONSTRAINT ck_SubSNPSeq5_p3 CHECK (subsnp_id >= 20000001 and subsnp_id <= 30000000)