moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).

schemas/*functions.sql: Renamed to *util.sql because now that these schemas are used by the new-style import scripts, there can be more than just functions in them

vegbien_dest: Schema override for referring to a table in the $public schema: Only process the override when $!schemaVar and $!tableVar are non-*empty*, to allow setting $schema=""

vegbien_dest: Added schema override support for referring to a table in the $public schema

vegbien_dest: Changed default $prefix to "", so that the majority of callers don't need to manually set $prefix to "" to avoid it defaulting to out_

vegbien_dest: Also export $version

vegbien_dest: Use $version as $public when $public not provided. When neither is provided, continue to use "public" and also set $version to that.

vegbien_dest: $schemas: Removed analytical_db because views that will be added to it were shadowing public schema tables with the same names during population of those tables in make_analytical_db

vegbien_dest: Export $public, to make sure it's available to any invoked scripts as an env var

vegbien_dest: $schemas: Added analytical_db

vegbien_dest: $schemas: Don't include the , before $public if it has been set to the empty string (deleted)

vegbien_dest: Allow user to specify a custom public schema in the $public env var. This makes custom public schema functionality available to all VegBIEN-accessing scripts, not just map.

Moved tnrs table from public (schemas/vegbien.sql) to its own TNRS schema, which is created by a new .TNRS datasource. Note that .TNRS is included in the automated testing, but not yet in the import.

vegbien_dest: schemas: Added public explicitly, even though it's already in the default search_path, in order to shadow any datasource's tables of the same name as a VegBIEN table (such as in VegBank). (VegBIEN tables are referenced without a schema, while datasource tables are referenced with a schema, so collisions are not a problem after this fix.)

vegbien_dest: Added temp to schemas list so the intermediate tables will be created there, where they are easy to remove with `make schemas/temp/reinstall`

vegbien_dest: $schemas: Added py_functions

vegbien_dest: Fixed bug where there was a missing line continuation char before schemas var

vegbien_dest: Added "functions" to schemas

vegbien_dest: Fixed bug where it would give a usage error if run from a makefile rule, because the BASH_LINENO would be 0, by also checking if ${BASH_ARGV⁰} is ${BASH_SOURCE⁰}

vegbien_dest: Changed interpreter to /bin/bash. Removed comment that it requires var bien_password.

vegbien_dest: Get bien_password by searching relative to $self, which we now have a way to get in a bash script (${BASH_SOURCE⁰}), rather than requiring the caller to set it. Provide usage error if run without initial ".".

vegbien_dest: Added option to override the prefix of the created vars

Renamed util to bin

Moved everything in scripts to root. inputs_Makefile: Don't run "all" when installing.

Changed vegbien_dest and users of it to use separate bien_password file

Renamed vegbien_dest.sh to vegbien_dest to reflect that it is also includable by Makefiles

scripts/Makefile includes vegbien_dest.sh directly

Added vegbien DB admin scripts