[EHPweb] Database Discrepencies

[Eric M Martinez]

- All -

I looked at the DB in an attempt to merge the EHPDevel and EHPMaster  
and noticed several discrepencies (table-level only) between the two:

Tables on EHPDevel but NOT on EHPMaster:

 > EQ
 > EQcategory
 > HazardMap
 > HazardRegion
 > SpectralAcceleration
 > TimeHorizon
 > eq_history
 > lossPager
 > lossPagerCity
 > lossPagerMMI
 > #mysql50#nca_cptdata-old
 > photoCategory
 > photoLink
 > photoSubCategory
 > #mysql50#teaminfo_members-old

Tables on EHPMaster but NOT on EHPDevel:

< nca_cptdata-20090818
< nca_cptdata-old
< research_heatflow
< teaminfo_members-old

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).

Thanks,
	~Eric.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://geohazards.usgs.gov/pipermail/ehpweb/attachments/20091022/899846be/attachment.html>