add human 9606 schema

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

diff --git a/schema/human_9606_schema/human_gty1_constraint.sql b/schema/human_9606_schema/human_gty1_constraint.sql
new file mode 100644 (file)
index 0000000..f2a495a
--- /dev/null
+++ b/schema/human_9606_schema/human_gty1_constraint.sql
@@ -0,0 +1,78 @@
+ALTER TABLE [SubInd_ch1] ADD 
+       CONSTRAINT [pk_ch_t_SubInd_ch1] PRIMARY KEY  CLUSTERED 
+       (
+               [subsnp_id],
+               [submitted_ind_id],
+               [batch_id],
+               [chr]
+       )
+GO
+
+
+ALTER TABLE [SubInd_ch2] ADD 
+       CONSTRAINT [pk_ch_t_SubInd_ch2] PRIMARY KEY  CLUSTERED 
+       (
+               [subsnp_id],
+               [submitted_ind_id],
+               [batch_id],
+               [chr]
+       )
+GO
+
+
+ALTER TABLE [SubInd_ch3] ADD 
+       CONSTRAINT [pk_ch_t_SubInd_ch3] PRIMARY KEY  CLUSTERED 
+       (
+               [subsnp_id],
+               [submitted_ind_id],
+               [batch_id],
+               [chr]
+       )
+GO
+
+
+ALTER TABLE [SubInd_ch4] ADD 
+       CONSTRAINT [pk_ch_t_SubInd_ch4] PRIMARY KEY  CLUSTERED 
+       (
+               [subsnp_id],
+               [submitted_ind_id],
+               [batch_id],
+               [chr]
+       )
+GO
+
+
+ALTER TABLE [SubInd_ch5] ADD 
+       CONSTRAINT [pk_ch_t_SubInd_ch5] PRIMARY KEY  CLUSTERED 
+       (
+               [subsnp_id],
+               [submitted_ind_id],
+               [batch_id],
+               [chr]
+       )
+GO
+
+
+ALTER TABLE [SubInd_ch6] ADD 
+       CONSTRAINT [pk_ch_t_SubInd_ch6] PRIMARY KEY  CLUSTERED 
+       (
+               [subsnp_id],
+               [submitted_ind_id],
+               [batch_id],
+               [chr]
+       )
+GO
+
+
+ALTER TABLE [SubInd_ch7] ADD 
+       CONSTRAINT [pk_ch_t_SubInd_ch7] PRIMARY KEY  CLUSTERED 
+       (
+               [subsnp_id],
+               [submitted_ind_id],
+               [batch_id],
+               [chr]
+       )
+GO
+
+
+