1 ALTER TABLE Allele ADD
\r
2 CONSTRAINT pk_Allele PRIMARY KEY
\r
8 ALTER TABLE AlleleFlagCode ADD
\r
9 CONSTRAINT pk_AlleleFlagCode PRIMARY KEY
\r
15 ALTER TABLE AlleleMotif ADD
\r
16 CONSTRAINT pk_AlleleMotif PRIMARY KEY
\r
23 ALTER TABLE AllocIds ADD
\r
24 CONSTRAINT pk_AllocIds PRIMARY KEY
\r
30 ALTER TABLE Author ADD
\r
31 CONSTRAINT pk_Author PRIMARY KEY
\r
40 ALTER TABLE CpGCode ADD
\r
41 CONSTRAINT pk_CpGCode PRIMARY KEY
\r
49 -- ALTER TABLE GenomeBuildInfo ADD
\r
50 -- CONSTRAINT DF__GenomeBui__inser__15E52B55 DEFAULT (getdate()) FOR insert_time,
\r
51 -- CONSTRAINT DF__GenomeBui__is_ma__18C19800 DEFAULT (1) FOR is_major,
\r
52 -- CONSTRAINT DF__GenomeBui__ncbi___23FE4082 DEFAULT (0) FOR ncbi_genome_tax_id
\r
55 ALTER TABLE GtyAllele ADD
\r
56 CONSTRAINT pk_GtyAllele PRIMARY KEY
\r
64 ALTER TABLE IUPACna ADD
\r
65 CONSTRAINT pk_IUPACna PRIMARY KEY
\r
71 ALTER TABLE LoadHistory ADD
\r
72 CONSTRAINT pk_LoadHistory PRIMARY KEY
\r
78 ALTER TABLE LocTypeCode ADD
\r
79 -- CONSTRAINT DF__LocTypeCo__creat__75CD617E DEFAULT (getdate()) FOR create_time,
\r
80 CONSTRAINT pk_LocTypeCode PRIMARY KEY
\r
86 ALTER TABLE MapLinkCode ADD
\r
87 CONSTRAINT pk_MapLinkCode PRIMARY KEY
\r
94 ALTER TABLE Method ADD
\r
95 CONSTRAINT pk_Method_mid PRIMARY KEY
\r
101 ALTER TABLE MethodClass ADD
\r
102 CONSTRAINT pk_MethodClass PRIMARY KEY
\r
108 ALTER TABLE MethodLine ADD
\r
109 CONSTRAINT pk_MethodLine PRIMARY KEY
\r
116 ALTER TABLE Moltype ADD
\r
117 CONSTRAINT pk_Moltype PRIMARY KEY
\r
123 ALTER TABLE Motif ADD
\r
124 CONSTRAINT pk_Motif PRIMARY KEY
\r
130 ALTER TABLE ObsGenotype ADD
\r
131 CONSTRAINT pk_ObsGenotype PRIMARY KEY
\r
137 ALTER TABLE ObsVariation ADD
\r
138 -- CONSTRAINT DF__ObsVariat__creat__3BB5CE82 DEFAULT (getdate()) FOR create_time,
\r
139 -- CONSTRAINT DF__ObsVariat__last___3CA9F2BB DEFAULT (getdate()) FOR last_updated_time,
\r
140 CONSTRAINT pk_ObsVariation PRIMARY KEY
\r
146 ALTER TABLE OrgDbStatus ADD
\r
147 CONSTRAINT pk_org_db_status PRIMARY KEY
\r
153 ALTER TABLE OrganismTax ADD
\r
154 CONSTRAINT pk_organism PRIMARY KEY
\r
160 ALTER TABLE PopClass ADD
\r
161 CONSTRAINT pk_PopClass PRIMARY KEY
\r
168 ALTER TABLE PopClassCode ADD
\r
169 CONSTRAINT PK__PopClassCode__270595B6 PRIMARY KEY
\r
175 ALTER TABLE Publication ADD
\r
176 CONSTRAINT pk_Publication PRIMARY KEY
\r
182 ALTER TABLE SNPGlossary ADD
\r
183 -- CONSTRAINT DF__SNPGlossa__last___4050666D DEFAULT (getdate()) FOR last_updated,
\r
184 CONSTRAINT pk_SNPGlossary PRIMARY KEY
\r
190 ALTER TABLE SNP_tax_id ADD
\r
191 -- CONSTRAINT DF__SNP_tax_i__statu__31583BA0 DEFAULT ('C') FOR status,
\r
192 CONSTRAINT pk_SNP_tax_id PRIMARY KEY
\r
198 ALTER TABLE SnpChrCode ADD
\r
199 CONSTRAINT pk_SnpChrCode PRIMARY KEY
\r
205 ALTER TABLE SnpClassCode ADD
\r
206 CONSTRAINT pk_SnpClassCode PRIMARY KEY
\r
212 ALTER TABLE SnpFunctionCode ADD
\r
213 CONSTRAINT pk_SnpFunctionCode PRIMARY KEY
\r
219 ALTER TABLE SnpValidationCode ADD
\r
220 CONSTRAINT pk_SnpValidationCode PRIMARY KEY
\r
226 ALTER TABLE StrandCode ADD
\r
227 CONSTRAINT pk_StrandCode PRIMARY KEY
\r
235 ALTER TABLE Submitter ADD
\r
236 -- CONSTRAINT DF_Submitter_create_time DEFAULT (getdate()) FOR create_time,
\r
237 CONSTRAINT pk_Submitter PRIMARY KEY
\r
243 ALTER TABLE TemplateType ADD
\r
244 CONSTRAINT pk_TemplateType PRIMARY KEY
\r
250 ALTER TABLE UniGty ADD
\r
251 CONSTRAINT pk_UniGty PRIMARY KEY
\r
257 ALTER TABLE UniVariAllele ADD
\r
258 CONSTRAINT pk_UniVariAllele PRIMARY KEY
\r
265 ALTER TABLE UniVariation ADD
\r
266 CONSTRAINT pk_UniVariation PRIMARY KEY
\r
272 ALTER TABLE UniVariationSrcCode ADD
\r
273 CONSTRAINT pk_UniVariationSrcCode PRIMARY KEY
\r
279 ALTER TABLE VariAllele ADD
\r
280 CONSTRAINT pk_VariAllele PRIMARY KEY
\r
287 ALTER TABLE db_ftp_table_list ADD
\r
288 -- CONSTRAINT DF__db_ftp_ta__creat__27F9B9EF DEFAULT (getdate()) FOR create_time,
\r
289 CONSTRAINT pk_db_ftp_table_list PRIMARY KEY
\r
295 -- ALTER TABLE db_map_table_name ADD
\r
296 -- CONSTRAINT DF__db_map_ta__inNon__206E7217 DEFAULT ('N') FOR inNonHuman
\r
299 ALTER TABLE dn_Allele_rev ADD
\r
300 CONSTRAINT pk_dn_Allele_rev PRIMARY KEY
\r
307 ALTER TABLE dn_Motif_rev ADD
\r
308 CONSTRAINT pk_dn_Motif_rev PRIMARY KEY
\r
315 ALTER TABLE dn_UniGty_allele ADD
\r
316 CONSTRAINT pk_dn_UniGty_allele PRIMARY KEY
\r
323 ALTER TABLE dn_UniGty_rev ADD
\r
324 CONSTRAINT pk_dn_Gty_rev PRIMARY KEY
\r
331 ALTER TABLE dn_UniVariation_rev ADD
\r
332 CONSTRAINT pk_dn_UniVariation_rev PRIMARY KEY
\r
341 ALTER TABLE dn_summary ADD
\r
342 -- CONSTRAINT DF__dn_summar__creat__383A4359 DEFAULT (getdate()) FOR create_time,
\r
343 -- CONSTRAINT DF__dn_summar__last___392E6792 DEFAULT (getdate()) FOR last_updated_time,
\r