update to build 135 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
index f2a495a13dcc1c0e2f1058b8525f094a702260dd..4eca20f4e486f8efda8f25b84bc44ff442471dcc 100644 (file)
--- a/schema/human_9606_schema/human_gty1_constraint.sql
+++ b/schema/human_9606_schema/human_gty1_constraint.sql
@@ -1,78 +1,22 @@
-ALTER TABLE [SubInd_ch1] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch1] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch1] ADD CONSTRAINT [pk_ch_t_SubInd_ch1]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch2] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch2] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch2] ADD CONSTRAINT [pk_ch_t_SubInd_ch2]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch3] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch3] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch3] ADD CONSTRAINT [pk_ch_t_SubInd_ch3]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch4] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch4] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch4] ADD CONSTRAINT [pk_ch_t_SubInd_ch4]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch5] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch5] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch5] ADD CONSTRAINT [pk_ch_t_SubInd_ch5]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch6] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch6] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch6] ADD CONSTRAINT [pk_ch_t_SubInd_ch6]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
-
-ALTER TABLE [SubInd_ch7] ADD 
-       CONSTRAINT [pk_ch_t_SubInd_ch7] PRIMARY KEY  CLUSTERED 
-       (
-               [subsnp_id],
-               [submitted_ind_id],
-               [batch_id],
-               [chr]
-       )
+ALTER TABLE [SubInd_ch7] ADD CONSTRAINT [pk_ch_t_SubInd_ch7]  PRIMARY KEY  CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
 GO
 
 
-