update to build 135 schema

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

diff --git a/schema/human_9606_schema/human_gty2_constraint.sql b/schema/human_9606_schema/human_gty2_constraint.sql
index def01ceb892e55100d1d866fe138457cbc0f615d..84802ffaead62374e379a37c473516c7896d93a9 100644 (file)
--- a/schema/human_9606_schema/human_gty2_constraint.sql
+++ b/schema/human_9606_schema/human_gty2_constraint.sql
@@ -1,265 +1,73 @@
-ALTER TABLE [SubInd_ch10] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch10] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch10] ADD CONSTRAINT [pk_ch_t_SubInd_ch10]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch11] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch11] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch11] ADD CONSTRAINT [pk_ch_t_SubInd_ch11]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch12] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch12] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch12] ADD CONSTRAINT [pk_ch_t_SubInd_ch12]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch13] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch13] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch13] ADD CONSTRAINT [pk_ch_t_SubInd_ch13]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch14] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch14] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch14] ADD CONSTRAINT [pk_ch_t_SubInd_ch14]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch15] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch15] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch15] ADD CONSTRAINT [pk_ch_t_SubInd_ch15]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch16] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch16] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch16] ADD CONSTRAINT [pk_ch_t_SubInd_ch16]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch17] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch17] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch17] ADD CONSTRAINT [pk_ch_t_SubInd_ch17]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch18] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch18] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch18] ADD CONSTRAINT [pk_ch_t_SubInd_ch18]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch19] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch19] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch19] ADD CONSTRAINT [pk_ch_t_SubInd_ch19]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch20] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch20] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch20] ADD CONSTRAINT [pk_ch_t_SubInd_ch20]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch21] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch21] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch21] ADD CONSTRAINT [pk_ch_t_SubInd_ch21]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch22] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch22] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch22] ADD CONSTRAINT [pk_ch_t_SubInd_ch22]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch8] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch8] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch8] ADD CONSTRAINT [pk_ch_t_SubInd_ch8]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch9] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch9] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch9] ADD CONSTRAINT [pk_ch_t_SubInd_ch9]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_chAltOnly] ADD 
-       CONSTRAINT [pk_SubInd_chAltOnly] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_chAltOnly] ADD CONSTRAINT [pk_SubInd_chAltOnly]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_chMT] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_chMT] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_chMT] ADD CONSTRAINT [pk_ch_t_SubInd_chMT]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_chMulti] ADD 
-       CONSTRAINT [pk_SubInd_chMulti] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_chMulti] ADD CONSTRAINT [pk_SubInd_chMulti]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_chNewSs] ADD 
-       CONSTRAINT [pk_SubInd_chNewSs] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_chNewSs] ADD CONSTRAINT [pk_SubInd_chNewSs]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_chNotOn] ADD 
-       CONSTRAINT [pk_SubInd_chNotOn] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_chNotOn] ADD CONSTRAINT [pk_SubInd_chNotOn]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_chPAR] ADD 
-       CONSTRAINT [pk_SubInd_chPAR] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_chPAR] ADD CONSTRAINT [pk_SubInd_chPAR]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_chUn] ADD 
-       CONSTRAINT [pk_SubInd_chUn] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_chUn] ADD CONSTRAINT [pk_SubInd_chUn]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_chX] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_chX] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_chX] ADD CONSTRAINT [pk_ch_t_SubInd_chX]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_chY] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_chY] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_chY] ADD CONSTRAINT [pk_ch_t_SubInd_chY]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
 
-