add human 9606 schema

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

diff --git a/schema/human_9606_schema/dbSNP_sup_constraint_postgresql.sql b/schema/human_9606_schema/dbSNP_sup_constraint_postgresql.sql
new file mode 100644 (file)
index 0000000..11b5424
--- /dev/null
+++ b/schema/human_9606_schema/dbSNP_sup_constraint_postgresql.sql
@@ -0,0 +1,118 @@
+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)
+;
+
+