/ - Repository - BIEN 3 - NCEAS Projects

Name	Size	Revision	Age	Author	Comment
_archive		1598	over 12 years	Aaron Marcuse-Kubitza	Moved _archive/tapir2flatClient/trunk/client/ t...
bin		2824	about 12 years	Aaron Marcuse-Kubitza	csv2db: Errors table: Removed no longer needed ...
config		272	over 12 years	Aaron Marcuse-Kubitza	Moved bien_password to new config dir
inputs		2775	about 12 years	Aaron Marcuse-Kubitza	inputs/SALVIAS: Switched to using CSV exports o...
lib		2872	about 12 years	Aaron Marcuse-Kubitza	sql.py: create_table(): has_pkey: Use new Typed...
mappings		2529	about 12 years	Aaron Marcuse-Kubitza	mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
schemas		2869	about 12 years	Aaron Marcuse-Kubitza	schemas/vegbien.sql: namedplace: Fixed bug wher...
to_do		2547	about 12 years	Aaron Marcuse-Kubitza	to_do/timeline.doc: Updated to reflect the mont...
Makefile	10.1 KB	2633	about 12 years	Aaron Marcuse-Kubitza	main Makefile: schemas/%/uninstall: Removed del...
README.TXT	2.7 KB	1967	about 12 years	Aaron Marcuse-Kubitza	main Makefile: VegBIEN DB: Install public schem...
map	978 Bytes	1979	about 12 years	Aaron Marcuse-Kubitza	root map: Fill in defaults for inputs from VegB...

#	Date	Author	Comment
2872	06/14/2012 11:00 PM	Aaron Marcuse-Kubitza	sql.py: create_table(): has_pkey: Use new TypedCol.constraints to store 'PRIMARY KEY'
2871	06/14/2012 10:59 PM	Aaron Marcuse-Kubitza	sql_gen.py: TypedCol: Added constraints instance var
2870	06/14/2012 10:38 PM	Aaron Marcuse-Kubitza	sql_gen.py: EnsureNotNull: Made coalesce() all uppercase to match how pg_dump spells it
2869	06/14/2012 10:36 PM	Aaron Marcuse-Kubitza	schemas/vegbien.sql: namedplace: Fixed bug where parent_id needed to be included in UNIQUE CONSTRAINT (now UNIQUE INDEX), since there can be more than one e.g. city of the same name if they are in different states
2868	06/14/2012 10:32 PM	Aaron Marcuse-Kubitza	schemas/vegbien.sql: plantname: Changed indexes to use `COALESCE` to match what sql_gen now does
2867	06/14/2012 10:22 PM	Aaron Marcuse-Kubitza	schemas/py_functions.sql: _dateRangeStart, _dateRangeEnd: Changed indexes to use `COALESCE` to match what sql_gen now does
2866	06/14/2012 10:19 PM	Aaron Marcuse-Kubitza	schemas/py_functions.sql: _namePart: Changed indexes to use `COALESCE` to match what sql_gen now does
2865	06/14/2012 10:16 PM	Aaron Marcuse-Kubitza	schemas/functions.sql: _nullIf: Changed indexes to use `COALESCE` to match what sql_gen now does
2864	06/14/2012 10:15 PM	Aaron Marcuse-Kubitza	schemas/functions.sql: _nullIf: Require a non-NULL null-equivalent value
2863	06/14/2012 10:12 PM	Aaron Marcuse-Kubitza	schemas/functions.sql: _label: Changed indexes to use `COALESCE` to match what sql_gen now does

root @ 2872