<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">- All -<div><br></div><div>I looked at the DB in an attempt to merge the EHPDevel and EHPMaster and noticed several discrepencies (table-level only) between the two:</div><div><br></div><div><b>Tables on EHPDevel but NOT on EHPMaster:</b></div><div><b><br></b></div><div><b><div><div><span class="Apple-style-span" style="font-weight: normal;">> EQ</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> EQcategory</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> HazardMap</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> HazardRegion</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> SpectralAcceleration</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> TimeHorizon</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> eq_history</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> lossPager</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> lossPagerCity</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> lossPagerMMI</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> #mysql50#nca_cptdata-old</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> photoCategory</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> photoLink</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> photoSubCategory</span></div><div><span class="Apple-style-span" style="font-weight: normal;">> #mysql50#teaminfo_members-old</span></div><div><br></div><div>Tables on EHPMaster but NOT on EHPDevel:</div><div><br></div><div><div><span class="Apple-style-span" style="font-weight: normal;">< nca_cptdata-20090818</span></div><div><span class="Apple-style-span" style="font-weight: normal;">< nca_cptdata-old</span></div><div><span class="Apple-style-span" style="font-weight: normal;">< research_heatflow</span></div><div><span class="Apple-style-span" style="font-weight: normal;">< teaminfo_members-old</span></div><div><span class="Apple-style-span" style="font-weight: normal;"><br></span></div><div><span class="Apple-style-span" style="font-weight: normal;">Please, if you know what any of these tables is/are/were used for let me know. I'll make a backup of both original databases, but if I don't here back by 3:30 today I will be removing any unexplained tables (in both directions).</span></div><div><span class="Apple-style-span" style="font-weight: normal;"><br></span></div><div><span class="Apple-style-span" style="font-weight: normal;">Thanks,</span></div><div><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-tab-span" style="white-space:pre">        </span>~Eric.</span></div></div></div></b></div></body></html>