1 ALTER TABLE AlleleFreqBySsPop ADD CONSTRAINT pk_AlleleFreqBySsPop_b129 PRIMARY KEY (subsnp_id,pop_id,allele_id);
2 ALTER TABLE Batch ADD CONSTRAINT pk_Batch PRIMARY KEY (batch_id);
3 ALTER TABLE BatchCita ADD CONSTRAINT pk_BatchCita PRIMARY KEY (batch_id,position);
4 ALTER TABLE BatchCommLine ADD CONSTRAINT pk_BatchCommLine PRIMARY KEY (batch_id,line_num);
5 ALTER TABLE BatchCultivar ADD CONSTRAINT pk_BatchCultivar PRIMARY KEY (batch_id,line_num);
6 ALTER TABLE BatchMeExLine ADD CONSTRAINT pk_BatchMeExLine PRIMARY KEY (batch_id,line_num);
7 ALTER TABLE BatchStrain ADD CONSTRAINT pk_BatchStrain PRIMARY KEY (batch_id,line_num);
8 ALTER TABLE BatchValCode ADD CONSTRAINT pk_BatchValCode PRIMARY KEY (batch_id);
9 ALTER TABLE ClinSigCode ALTER COLUMN create_time SET DEFAULT NOW();
10 ALTER TABLE ClinSigCode ALTER COLUMN last_updated_time SET DEFAULT NOW();
11 ALTER TABLE ClinSigCode ADD CONSTRAINT PK__ClinSigC__357D4CF85DD3445E PRIMARY KEY (code);
12 ALTER TABLE Contact ADD CONSTRAINT pk_Contact PRIMARY KEY (batch_id,handle);
13 ALTER TABLE GeneIdToName ADD CONSTRAINT pk_GeneIdToName PRIMARY KEY (gene_id);
14 ALTER TABLE GtyFreqBySsPop ADD CONSTRAINT pk_GtyFreqBySsPop_b129 PRIMARY KEY (subsnp_id,pop_id,unigty_id);
15 ALTER TABLE IndGrpCode ADD CONSTRAINT pk_IndGrpCode PRIMARY KEY (code);
16 ALTER TABLE IndivBySource ADD CONSTRAINT pk_IndivBySource PRIMARY KEY (src_id,src_ind_id);
17 ALTER TABLE Individual ADD CONSTRAINT pk_Individual PRIMARY KEY (ind_id);
18 ALTER TABLE OmimVarLocusIdSNP ADD CONSTRAINT fk_OmimVarLocusIdSNP_snp_id FOREIGN KEY (snp_id) REFERENCES b134_SNP(snp_id);
19 ALTER TABLE Pedigree ADD CONSTRAINT p_ped_id PRIMARY KEY (ped_id);
20 ALTER TABLE PedigreeIndividual ADD CONSTRAINT pk_PedigreeIndividual PRIMARY KEY (ped_id,ind_id);
21 ALTER TABLE PopLine ADD CONSTRAINT pk_PopLine PRIMARY KEY (pop_id,line_num);
22 ALTER TABLE PopMandLine ADD CONSTRAINT pk_PopMandLine PRIMARY KEY (pop_id,line_num);
23 ALTER TABLE Population ADD CONSTRAINT pk_Population_pop_id PRIMARY KEY (pop_id);
24 ALTER TABLE SNPAlleleFreq ADD CONSTRAINT pk_SNPAlleleFreq PRIMARY KEY (snp_id,allele_id);
25 ALTER TABLE SNPAncestralAllele ALTER COLUMN batch_id SET DEFAULT (0);
26 ALTER TABLE SNPAncestralAllele ADD CONSTRAINT pk_SNPAncestralAllele PRIMARY KEY (snp_id,batch_id);
27 ALTER TABLE SNPClinSig ALTER COLUMN upd_time SET DEFAULT NOW();
28 ALTER TABLE SNPClinSig ADD CONSTRAINT PK__SNPClinS__430A13A119D3EB23 PRIMARY KEY (snp_id);
29 ALTER TABLE SNPGtyFreq ADD CONSTRAINT pk_SNPGtyFreq PRIMARY KEY (snp_id,unigty_id);
30 ALTER TABLE SNPHWProb ADD CONSTRAINT pk_SNPHWProb PRIMARY KEY (snp_id);
31 ALTER TABLE SNPHistory ADD CONSTRAINT pk_SNPHistory PRIMARY KEY (snp_id);
32 ALTER TABLE SNPSubSNPLink ADD CONSTRAINT fk_SNPSubSNPLink_ss FOREIGN KEY (subsnp_id) REFERENCES SubSNP(subsnp_id);
33 ALTER TABLE SNPSuspect ALTER COLUMN upd_time SET DEFAULT NOW();
34 ALTER TABLE SNPSuspect ADD CONSTRAINT PK__SNPSuspe__430A13A116D6B790 PRIMARY KEY (snp_id);
35 ALTER TABLE SNPVal ADD CONSTRAINT pk_SNPVal PRIMARY KEY (batch_id,snp_id);
36 ALTER TABLE SNP_bitfield ADD CONSTRAINT pk_SNP_bitfield PRIMARY KEY (snp_id);
37 ALTER TABLE SubPop ALTER COLUMN last_updated_time SET DEFAULT NOW();
38 ALTER TABLE SubPop ADD CONSTRAINT fk_SubPop_batch_id FOREIGN KEY (batch_id) REFERENCES Batch(batch_id);
39 ALTER TABLE SubPop ADD CONSTRAINT fk_SubPop_pop FOREIGN KEY (pop_id) REFERENCES Population(pop_id);
40 ALTER TABLE SubPop ADD CONSTRAINT PK__SubPop_new__180E3640 PRIMARY KEY (batch_id,subsnp_id,pop_id,type);
41 ALTER TABLE SubPopAllele ADD CONSTRAINT fk_SubPopAllele_bid_ss_pop_type FOREIGN KEY (batch_id,subsnp_id,pop_id,type) REFERENCES SubPop(batch_id,subsnp_id,pop_id,type);
42 ALTER TABLE SubPopGty ADD CONSTRAINT pk_SubPopGty PRIMARY KEY (subpop_id,gty_id);
43 ALTER TABLE SubSNP ADD CONSTRAINT pk_SubSNP PRIMARY KEY (subsnp_id);
44 ALTER TABLE SubSNPAcc_ins ADD CONSTRAINT pk_SubSNPAcc PRIMARY KEY (subsnp_id,acc_type_ind,acc_part);
45 ALTER TABLE SubSNPCommLine_ins ADD CONSTRAINT pk_SubSNPCommLine PRIMARY KEY (subsnp_id,line_num);
46 ALTER TABLE SubSNPHGVS ADD CONSTRAINT pk_SubSNPHGVS PRIMARY KEY (subsnp_id);
47 ALTER TABLE SubSNPLinkout ALTER COLUMN link_type SET DEFAULT 'NA';
48 ALTER TABLE SubSNPLinkout ADD CONSTRAINT pk_SubSNPLinkout PRIMARY KEY (subsnp_id,link_type);
49 ALTER TABLE SubSNPMdFailLn ADD CONSTRAINT pk_SubSNPMdFailLn PRIMARY KEY (subsnp_id,line_num);
50 ALTER TABLE SubSNPNoVariSeq ADD CONSTRAINT pk_SubSNPNoVariSeq PRIMARY KEY (subsnp_id,line_num);
51 ALTER TABLE SubSNPOmim ADD CONSTRAINT pk_SubSNPOmim PRIMARY KEY (subsnp_id);
52 ALTER TABLE SubSNPPubmed ADD CONSTRAINT pk_SubSNPPubmed PRIMARY KEY (subsnp_id,line_num);
53 ALTER TABLE SubSNPSeq3_ins ADD CONSTRAINT pk_SubSNPSeq3 PRIMARY KEY (subsnp_id,type,line_num);
54 ALTER TABLE SubSNPSeq5_ins ADD CONSTRAINT pk_SubSNPSeq5 PRIMARY KEY (subsnp_id,type,line_num);
55 ALTER TABLE SubSNPSeqPos ADD CONSTRAINT pk_SubSNPSeqPos PRIMARY KEY (subsnp_id);
56 ALTER TABLE SubSNP_top_or_bot ADD CONSTRAINT PK__t_ss_top_or_bot__0D5DFFA8 PRIMARY KEY (subsnp_id);
57 ALTER TABLE SubmittedIndividual ALTER COLUMN ploidy SET DEFAULT 2;
58 ALTER TABLE SubmittedIndividual ADD CONSTRAINT pk_SubmittedIndividual PRIMARY KEY (pop_id,loc_ind_id_upp);
59 ALTER TABLE Synonym ADD CONSTRAINT pk_Synonym PRIMARY KEY (subsnp_id,type);
60 ALTER TABLE b135_ContigInfo_37_3 ALTER COLUMN last_updated_time SET DEFAULT NOW();
61 ALTER TABLE b135_ContigInfo_37_3 ADD CONSTRAINT pk_b135_ContigInfo_37_3 PRIMARY KEY (contig_gi);
62 ALTER TABLE b135_MapLink_37_3 ADD CONSTRAINT fk_b135_MapLink_37_3_rs FOREIGN KEY (snp_id) REFERENCES SNP(snp_id);
63 ALTER TABLE b135_SNPChrPosOnRef_37_3 ADD CONSTRAINT fk_b135_SNPChrPosOnRef_37_3_rs FOREIGN KEY (snp_id) REFERENCES SNP(snp_id);
64 ALTER TABLE b135_SNPContigLoc_37_3 ADD CONSTRAINT fk_b135_SNPContigLoc_37_3_rs FOREIGN KEY (snp_id) REFERENCES SNP(snp_id);
65 ALTER TABLE b135_SNPContigLocusId_37_3 ADD CONSTRAINT fk_b135_SNPContigLocusId_37_3_rs FOREIGN KEY (snp_id) REFERENCES SNP(snp_id);
66 ALTER TABLE b135_SNPContigProtein_37_3 ADD CONSTRAINT fk_b135_SNPContigProtein_37_3_rs FOREIGN KEY (snp_id) REFERENCES SNP(snp_id);
67 ALTER TABLE b135_SNPMapInfo_37_3 ADD CONSTRAINT fk_b135_SNPMapInfo_37_3_rs FOREIGN KEY (snp_id) REFERENCES SNP(snp_id);
68 ALTER TABLE b135_SNPMapLinkProtein_37_3 ADD CONSTRAINT fk_b135_SNPMapLinkProtein_37_3_rs FOREIGN KEY (snp_id) REFERENCES SNP(snp_id);
69 ALTER TABLE dn_IND_batchCount ADD CONSTRAINT pk_dn_IND_batchCount PRIMARY KEY (batch_id,pop_id);
70 ALTER TABLE dn_PopulationIndGrp ADD CONSTRAINT pk_dn_PopulationIndGrp PRIMARY KEY (pop_id);
71 ALTER TABLE dn_batchCount ADD CONSTRAINT pk_dn_batchCount PRIMARY KEY (batch_id);
72 ALTER TABLE dn_handleCount ADD CONSTRAINT pk_dn_handleCount PRIMARY KEY (handle,batch_type);