schema/human_9606_schema/dbSNP_sup_constraint.sql

   1 ALTER TABLE [SubSNPAcc_p1_human] ADD
   2         CONSTRAINT [pk_SubSNPAcc_p1_human] PRIMARY KEY  CLUSTERED
   3         (
   4                 [subsnp_id],
   5                 [acc_type_ind],
   6                 [acc_part]
   7         ),
   8         CONSTRAINT [ck_SubSNPAcc_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
   9 GO
  10
  11
  12 ALTER TABLE [SubSNPAcc_p2_human] ADD
  13         CONSTRAINT [pk_SubSNPAcc_p2_human] PRIMARY KEY  CLUSTERED
  14         (
  15                 [subsnp_id],
  16                 [acc_type_ind],
  17                 [acc_part]
  18         ),
  19         CONSTRAINT [ck_SubSNPAcc_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
  20 GO
  21
  22
  23 ALTER TABLE [SubSNPAcc_p3_human] ADD
  24         CONSTRAINT [pk_SubSNPAcc_p3] PRIMARY KEY  CLUSTERED
  25         (
  26                 [subsnp_id],
  27                 [acc_type_ind],
  28                 [acc_part]
  29         ),
  30         CONSTRAINT [ck_SubSNPAcc_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
  31 GO
  32
  33
  34 ALTER TABLE [SubSNPCommLine_p1_human] ADD
  35         CONSTRAINT [pk_SubSNPCommLine_p1_human] PRIMARY KEY  CLUSTERED
  36         (
  37                 [subsnp_id],
  38                 [line_num]
  39         ),
  40         CONSTRAINT [ck_SubSNPCommLine_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
  41 GO
  42
  43
  44 ALTER TABLE [SubSNPCommLine_p2_human] ADD
  45         CONSTRAINT [pk_SubSNPCommLine_p2_human] PRIMARY KEY  CLUSTERED
  46         (
  47                 [subsnp_id],
  48                 [line_num]
  49         ),
  50         CONSTRAINT [ck_SubSNPCommLine_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
  51 GO
  52
  53
  54 ALTER TABLE [SubSNPCommLine_p3_human] ADD
  55         CONSTRAINT [pk_SubSNPCommLine_p3] PRIMARY KEY  CLUSTERED
  56         (
  57                 [subsnp_id],
  58                 [line_num]
  59         ),
  60         CONSTRAINT [ck_SubSNPCommLine_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
  61 GO
  62
  63
  64 ALTER TABLE [SubSNPSeq3_p1_human] ADD
  65         CONSTRAINT [pk_SubSNPSeq3_p1_human] PRIMARY KEY  CLUSTERED
  66         (
  67                 [subsnp_id],
  68                 [type],
  69                 [line_num]
  70         ),
  71         CONSTRAINT [ck_SubSNPSeq3_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
  72 GO
  73
  74
  75 ALTER TABLE [SubSNPSeq3_p2_human] ADD
  76         CONSTRAINT [pk_SubSNPSeq3_p2_human] PRIMARY KEY  CLUSTERED
  77         (
  78                 [subsnp_id],
  79                 [type],
  80                 [line_num]
  81         ),
  82         CONSTRAINT [ck_SubSNPSeq3_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
  83 GO
  84
  85
  86 ALTER TABLE [SubSNPSeq3_p3_human] ADD
  87         CONSTRAINT [pk_SubSNPSeq3_p3] PRIMARY KEY  CLUSTERED
  88         (
  89                 [subsnp_id],
  90                 [type],
  91                 [line_num]
  92         ),
  93         CONSTRAINT [ck_SubSNPSeq3_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
  94 GO
  95
  96
  97 ALTER TABLE [SubSNPSeq5_p1_human] ADD
  98         CONSTRAINT [pk_SubSNPSeq5_p1_human] PRIMARY KEY  CLUSTERED
  99         (
 100                 [subsnp_id],
 101                 [type],
 102                 [line_num]
 103         ),
 104         CONSTRAINT [ck_SubSNPSeq5_p1_human] CHECK ([subsnp_id] >= 1 and [subsnp_id] <= 10000000)
 105 GO
 106
 107
 108 ALTER TABLE [SubSNPSeq5_p2_human] ADD
 109         CONSTRAINT [pk_SubSNPSeq5_p2_human] PRIMARY KEY  CLUSTERED
 110         (
 111                 [subsnp_id],
 112                 [type],
 113                 [line_num]
 114         ),
 115         CONSTRAINT [ck_SubSNPSeq5_p2_human] CHECK ([subsnp_id] >= 10000001 and [subsnp_id] <= 20000000)
 116 GO
 117
 118
 119 ALTER TABLE [SubSNPSeq5_p3_human] ADD
 120         CONSTRAINT [pk_SubSNPSeq5_p3] PRIMARY KEY  CLUSTERED
 121         (
 122                 [subsnp_id],
 123                 [type],
 124                 [line_num]
 125         ),
 126         CONSTRAINT [ck_SubSNPSeq5_p3] CHECK ([subsnp_id] >= 20000001 and [subsnp_id] <= 30000000)
 127 GO
 128
 129
 130