1 ALTER TABLE Allele ADD CONSTRAINT pk_Allele PRIMARY KEY (allele_id ASC);
2 ALTER TABLE AlleleFlagCode ADD CONSTRAINT pk_AlleleFlagCode PRIMARY KEY (code ASC);
3 ALTER TABLE AlleleMotif ADD CONSTRAINT pk_AlleleMotif PRIMARY KEY (allele_id ASC,motif_order ASC);
4 ALTER TABLE AllocIds ADD CONSTRAINT pk_AllocIds PRIMARY KEY (name ASC);
5 ALTER TABLE Author ADD CONSTRAINT pk_Author PRIMARY KEY (pub_id ASC,position ASC);
8 ALTER TABLE CpGCode ADD CONSTRAINT pk_CpGCode PRIMARY KEY (code ASC);
11 ALTER TABLE GenomeBuildInfo ALTER COLUMN insert_time SET DEFAULT NOW();
12 ALTER TABLE GenomeBuildInfo ALTER COLUMN is_major SET DEFAULT (1);
13 ALTER TABLE GenomeBuildInfo ALTER COLUMN ncbi_genome_tax_id SET DEFAULT (0);
15 ALTER TABLE GtyAllele ADD CONSTRAINT pk_GtyAllele PRIMARY KEY (gty_id ASC,rev_flag ASC,chr_num ASC);
16 ALTER TABLE IUPACna ADD CONSTRAINT pk_IUPACna PRIMARY KEY (allele ASC);
17 ALTER TABLE LoadHistory ADD CONSTRAINT pk_LoadHistory PRIMARY KEY (build_id ASC);
18 ALTER TABLE LocTypeCode ALTER COLUMN create_time SET DEFAULT NOW();
19 ALTER TABLE LocTypeCode ADD CONSTRAINT pk_LocTypeCode PRIMARY KEY (code ASC);
20 ALTER TABLE MapLinkCode ADD CONSTRAINT pk_MapLinkCode PRIMARY KEY (which_code ASC,code ASC);
21 ALTER TABLE Method ADD CONSTRAINT pk_Method_mid PRIMARY KEY (method_id ASC);
22 ALTER TABLE MethodClass ADD CONSTRAINT pk_MethodClass PRIMARY KEY (meth_class_id ASC);
23 ALTER TABLE MethodLine ADD CONSTRAINT pk_MethodLine PRIMARY KEY (method_id ASC,line_num ASC);
24 ALTER TABLE Moltype ADD CONSTRAINT pk_Moltype PRIMARY KEY (code ASC);
25 ALTER TABLE Motif ADD CONSTRAINT pk_Motif PRIMARY KEY (motif_id ASC);
26 ALTER TABLE ObsGenotype ADD CONSTRAINT pk_ObsGenotype PRIMARY KEY (gty_id ASC);
27 ALTER TABLE ObsVariation ALTER COLUMN create_time SET DEFAULT NOW();
28 ALTER TABLE ObsVariation ALTER COLUMN last_updated_time SET DEFAULT NOW();
29 ALTER TABLE ObsVariation ADD CONSTRAINT pk_ObsVariation PRIMARY KEY (var_id ASC);
30 ALTER TABLE OrgDbStatus ADD CONSTRAINT pk_org_db_status PRIMARY KEY (database_name ASC);
31 ALTER TABLE OrganismTax ADD CONSTRAINT pk_organism PRIMARY KEY (tax_id ASC);
32 ALTER TABLE PopClass ADD CONSTRAINT pk_PopClass PRIMARY KEY (pop_id ASC,pop_class_id ASC);
33 ALTER TABLE PopClassCode ADD CONSTRAINT PK__PopClassCode__270595B6 PRIMARY KEY (pop_class_id ASC);
34 ALTER TABLE Publication ADD CONSTRAINT pk_Publication PRIMARY KEY (pub_id ASC);
35 ALTER TABLE SNPGlossary ALTER COLUMN last_updated SET DEFAULT NOW();
36 ALTER TABLE SNPGlossary ADD CONSTRAINT pk_SNPGlossary PRIMARY KEY (term ASC);
37 ALTER TABLE SNP_tax_id ALTER COLUMN status SET DEFAULT 'C';
38 ALTER TABLE SNP_tax_id ADD CONSTRAINT pk_SNP_tax_id PRIMARY KEY (snp_id ASC);
39 ALTER TABLE SnpChrCode ADD CONSTRAINT pk_SnpChrCode PRIMARY KEY (code ASC);
40 ALTER TABLE SnpClassCode ADD CONSTRAINT pk_SnpClassCode PRIMARY KEY (code ASC);
41 ALTER TABLE SnpFunctionCode ADD CONSTRAINT pk_SnpFunctionCode PRIMARY KEY (code ASC);
42 ALTER TABLE SnpValidationCode ADD CONSTRAINT pk_SnpValidationCode PRIMARY KEY (code ASC);
43 ALTER TABLE StrandCode ADD CONSTRAINT pk_StrandCode PRIMARY KEY (code ASC);
46 ALTER TABLE Submitter ALTER COLUMN create_time SET DEFAULT NOW();
47 ALTER TABLE Submitter ADD CONSTRAINT pk_Submitter PRIMARY KEY (handle ASC);
48 ALTER TABLE TemplateType ADD CONSTRAINT pk_TemplateType PRIMARY KEY (temp_type_id ASC);
49 ALTER TABLE UniGty ADD CONSTRAINT pk_UniGty PRIMARY KEY (unigty_id ASC);
50 ALTER TABLE UniVariAllele ADD CONSTRAINT pk_UniVariAllele PRIMARY KEY (univar_id ASC,allele_id ASC);
51 ALTER TABLE UniVariation ADD CONSTRAINT pk_UniVariation PRIMARY KEY (univar_id ASC);
52 ALTER TABLE UniVariationSrcCode ADD CONSTRAINT pk_UniVariationSrcCode PRIMARY KEY (code ASC);
53 ALTER TABLE VariAllele ADD CONSTRAINT pk_VariAllele PRIMARY KEY (var_id ASC,allele_id ASC);
54 ALTER TABLE db_ftp_table_list ALTER COLUMN create_time SET DEFAULT NOW();
55 ALTER TABLE db_ftp_table_list ADD CONSTRAINT pk_db_ftp_table_list PRIMARY KEY (table_name ASC);
56 ALTER TABLE db_map_table_name ALTER COLUMN inNonHuman SET DEFAULT 'N';
57 ALTER TABLE db_map_table_name ADD CONSTRAINT pk_db_map_table_name PRIMARY KEY (table_name ASC);
58 ALTER TABLE dn_Allele_rev ADD CONSTRAINT pk_dn_Allele_rev PRIMARY KEY (allele_id ASC,rev_flag ASC);
59 ALTER TABLE dn_Motif_rev ADD CONSTRAINT pk_dn_Motif_rev PRIMARY KEY (motif_id ASC,rev_flag ASC);
60 ALTER TABLE dn_UniGty_allele ADD CONSTRAINT pk_dn_UniGty_allele PRIMARY KEY (unigty_id ASC,chr_num ASC);
61 ALTER TABLE dn_UniGty_rev ADD CONSTRAINT pk_dn_Gty_rev PRIMARY KEY (unigty_id ASC,rev_flag ASC);
62 ALTER TABLE dn_UniVariation_rev ADD CONSTRAINT pk_dn_UniVariation_rev PRIMARY KEY (univar_id ASC,rev_flag ASC);
65 ALTER TABLE dn_summary ALTER COLUMN create_time SET DEFAULT NOW();
66 ALTER TABLE dn_summary ALTER COLUMN last_updated_time SET DEFAULT NOW();
67 ALTER TABLE dn_summary ADD CONSTRAINT PK__dn_summary__3651FAE7 PRIMARY KEY (tax_id ASC,build_id ASC,type ASC);