add human 9606 schema

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

diff --git a/schema/human_9606_schema/human_gty2_constraint_postgresql.sql b/schema/human_9606_schema/human_gty2_constraint_postgresql.sql
new file mode 100644 (file)
index 0000000..2c5b27e
--- /dev/null
+++ b/schema/human_9606_schema/human_gty2_constraint_postgresql.sql
@@ -0,0 +1,241 @@
+ALTER TABLE SubInd_ch10 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch10 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch11 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch11 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch12 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch12 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch13 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch13 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch14 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch14 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch15 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch15 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch16 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch16 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch17 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch17 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch18 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch18 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch19 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch19 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch20 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch20 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch21 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch21 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch22 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch22 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch8 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch8 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_ch9 ADD 
+       CONSTRAINT pk_ch_t_SubInd_ch9 PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_chAltOnly ADD 
+       CONSTRAINT pk_SubInd_chAltOnly PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_chMT ADD 
+       CONSTRAINT pk_ch_t_SubInd_chMT PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_chMulti ADD 
+       CONSTRAINT pk_SubInd_chMulti PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_chNewSs ADD 
+       CONSTRAINT pk_SubInd_chNewSs PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_chNotOn ADD 
+       CONSTRAINT pk_SubInd_chNotOn PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_chPAR ADD 
+       CONSTRAINT pk_SubInd_chPAR PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_chUn ADD 
+       CONSTRAINT pk_SubInd_chUn PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_chX ADD 
+       CONSTRAINT pk_ch_t_SubInd_chX PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+ALTER TABLE SubInd_chY ADD 
+       CONSTRAINT pk_ch_t_SubInd_chY PRIMARY KEY   
+       (
+               subsnp_id,
+               submitted_ind_id,
+               batch_id,
+               chr
+       )
+;
+
+