-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);