inputs/input.Makefile: verify/%.out: use a *.sql file in the verify/ directory itself to generate *.out, so that each datasource can have its own set of output queries. for datasources that should share the same set of queries, they can instead be symlinked to the same file.
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/vegbien.sql: Renamed reference -> source to make this table more broadly applicable, and because this now stores the datasource metadata
mappings/verify.specimens.sql: Updated for current schema
mappings/verify.specimens.sql: # species: Don't join at all on genus because DISTINCT is on the plantname_id rather than the plantname, which is already unique for a given genus because plantname_unique includes parent_id
mappings/verify.specimens.sql: # species: Fixed to join separately on plantname_ancestor for genus and species
mappings/verify.specimens.sql: Updated for schema changes
mappings/verify.specimens.sql: Use ORDER BY ... NULLS FIRST to match MySQL
specimens verification: Added duplicate catalog numbers test
specimens verification: Added # counties test
specimens verification: Added collection codes and # catalog numbers tests
specimens verification: Added # binomials test
mappings/verify.specimens.sql: # species test: Fixed to join separately on taxondeterminations for genus and species. # genera test: Removed no longer needed join on party.
mappings/verify.*: Use nested SELECT instead of JOIN on party to get datasource_id, so that party will not be joined on after other joins have already occurred (which slows things down)
Specimens verification: Added # genera and # species
Added mappings/verify.specimens.sql
