30 July 2010:
	* Implemented the dynamically stored technical catalogs
	* Added foreign keys to technical catalogs where appropriate

30 June 2010
	* Moved each SQL script inside the product (WSPortal, WSWebsite).
	* Clean up of PWS related tables, added indexes etc.

14 June 2010
	* views are separated from tables. They are dynamic for each country depending on the levels of administrative regions.

03 June 2010
	* added documentation on t_adcountry table
	* national_rank data type changed to smallint from character varying
	* added indexes on some tables

01 June 2010
	* adlohhnbr is of type integer and not double (Estimated number of households)

31 May 2010
	* updated software library code to reflect changes below
	* removed adopid, adopcode as primary key integer suffice for internal management

27 May 2010

	* t_adreglev.codex -> Added as required by the ToR

	* t_adloc.adlocodex2 removed - Not in ToR
	* t_adloc.adlotype removed - Not in ToR
	* t_adloc.adloxtxt/adloytxt removed - Not in ToR
	* t_adloc.adlopopupc moved to t_adloc_stat.population - Part of calculated fields (used by statistics library)
	* t_adloc.adlopopupe moved to t_adloc_stat.adlopopupe - Data is calculated by statistics library
	* t_adloc.adlohhnbr moved to t_adloc_stat.adlohhnbr - Data is calculated by statistics library
	
	* t_adloc_stat.sf_access moved to t_adloc.sf_access - Data is provided by country according to mail from Luc

	* t_upis.isadlocode renamed to t_upis.upisadlocode - To homogenize with other fields
	* t_upis.upisadrcode added - Uganda does not have localities and only subdivisions
	* t_upis.upiscodex2 removed - Not in ToR
	* t_upis.upiscodex3 moved to t_upwp.upwpcodex - Specific only to water points and specified in ToR as WP003
	
	* t_upis.upismainuse moved to t_upwp.upwpmainuse - Specific only to water points and specified in ToR as WP009
	* t_upis.upisowntype moved to t_uppws.uppwsowntype - Specified in ToR as PWS005, available only for PWS
	* added foreign key to upisprogram to t_adope
	* removed t_upis.upisxtxt and t_upis.upisytxt - Not in ToR
	
	* removed t_uppwsen.enuppwscodex - Redundant, duplicated by t_uppws. Changed FK to single key
	* removed t_uppwspi.piuppwscodex - Redundant, duplicated by t_uppws. Changed FK to single key
	* removed t_uppwspp.ppuppwscodex - Redundant, duplicated by t_uppws. Changed FK to single key

	* [???] removed temporarily t_uppwspp.hyehyecode - WHY FOREIGN KEY TO t_hyentity ???
	* added t_uppwspp.uppphyi - Hydraulic inventory code of the water source as specified by ToR
	
	* removed t_uppwsst.stuppwscodex - Redundant, duplicated by t_uppws. Changed FK to single key
	* removed t_uppwstt.ttuppwscodex - Redundant, duplicated by t_uppws. Changed FK to single key

	* removed table t_adoractiv - Not specified in ToR
	
	* removed t_adope.opadcncodex - Not specified in ToR
	* added t_upwp.upwputype - Imported from latest delivery
	* added t_upwp.upwpuyelm - Imported from latest delivery
	* added t_upwp.upwpudepin - Imported from latest delivery
	* added t_upwp.ishyecode - Imported from latest delivery
	* added t_upwp.upwpudraw - Imported from latest delivery

	* removed t_hyentity.hyedesc2 - Description is provided in country language. Who translates into english?
	* removed t_hyentity.hyename - Name is provided in country language. Who translates into english?
	* removed t_hyetype.hyetname2 - Name is provided in country language. Who translates into english?
	* removed t_hybtype.hybtname2 - Name is provided in country language. Who translates into english?
	* removed t_hybtype.hybtclass - Not specified by the ToR

    * removed t_uppws.uppwscodex - Not specified by the ToR
	* added table tl_aulocpws - Link between localities and piped water scheme
	* removed tl_aulocpws.pwsuppwscodex - Redundant, duplicated by t_uppws. Changed FK to single key
	* removed tl_aulocpws.pwsuppwscodex - Redundant, duplicated by t_uppws. Changed FK to single key
	* added table tl_uppwswp
	* removed tl_uppwswp.pwsuppwscodex - Redundant, duplicated by t_uppws. Changed FK to single key

	* added table tl_uhisbas - Imported from latest delivery
	* added table t_mostation - Imported from latest delivery
	* changed t_mostation.moscode type to serial
	* removed t_mostation.mosxtxtprov, t_mostation.mosytxtprov, t_mostation.mosxtxt, t_mostation.mosytxt - Because I removed from all project. Not specified in ToR
	* added t_mostation.moswho
	* added table t_mosample
	* changed t_mosample.seadorcode to integer (ID of the organization is integer)
	* changed t_adopmo.opmadopcode to integer (ID of the organization is integer)
	* removed t_mosample.mosahour - mosadate keeps the hour also.
	
	* added table t_moanal - Imported from latest delivery
	* changed t_moanal.moancode to serial
	* changed t_moanal.anadorcode to integer - Organizations are identified by integers
	* removed t_moanal.moanhour - moandate keeps the hour also.
	* added DROP TABLE IF EXISTS to all tables

	* t_upis.upistype - is now decoded through a dictionary
	* t_upwp.upwphpiwho - points to t_adorga
	* t_upwp.upwphpcraf - points to t_adorga
	* t_adopfund.adopfcat - points to lexicon lex_opb002 Grant/Soft load/Commercial load
	* t_adopfund.opfadopcode changed to integer
	
	* t_upwp.ishyecode - added FK to the t_hyentity
	* t_upwp.upwputype - added FK to lexicon UWS005


TODO:

	* Create new data sets according to these changes
	* create SQLA mappings for new tables

	* t_uppwsen.uppensrc - pointer to lexicon (PWE003)
	* t_uppwsen.uppenet - pointer to energy source catalog (PWE004)

	* t_uppwspp.uppppws - pointer to lexicon (PWP004)
	* t_uppwspp.upppppump - pointer to lexicon (PWP005)
	* t_uppwspp.uppppbtp - pointer on the "Pumps" catalog (PWP006)
	* t_uppwspp.uppppenr - pointer to lexicon (PWP007)
	
	* t_uppwspi.upppimdp - pointer on the "Pipes" catalog (PWI004)
	
	* t_uppwstt.upptttype - pointer to lexicon (PWT002)
	* t_uppwstt.uppttequip - pointer to catalog of "water treatment equipment"
	

	* [PAUL] tl_hyhyebas - Not documented, not added
	* [PAUL] tl_aulocis - Not added, Must be clearly documented (i.e. Not available for infrastructures of type WP/SF). We already have this link in tl_aulocpws.
	* [PAUL] tl_adorgact and t_adoractiv - Not added, not specified in ToR.
	* [PAUL] t_mostation.smoncode - No FK created
	* [PAUL] mopastatus.t_moparam - Decoded??
	* [PAUL] t_mosample.mosarep - char(1)? How is decoded?
	* [PAUL] t_mosample.mosalawconf - char(1)? How is decoded?
	* [PAUL] t_moanarep.moarupwho - Link to organization??
	
	* t_moparam.mopadcrea - Add date at creation time as default
	* t_moparam.mopadupdate - Timestamp as automatic update
