Project

General

Profile

Statistics
| Revision:

root/trunk/inputs/.TNRS @ 14110

Name Size Revision Age Author Comment
  Source 14080 over 10 years Aaron Marcuse-Kubitza inputs/.TNRS/Source/test.xml.ref: updated
  _archive 7837 over 11 years Aaron Marcuse-Kubitza inputs/.TNRS/: Moved no longer needed public.un...
  logs 8801 over 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: SVN: add, %/add: */logs:...
  tnrs 9972 over 11 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: tnrs: added Is_homonym...
  verify 13401 over 10 years Aaron Marcuse-Kubitza inputs/input.Makefile: add: verify/: also svn:i...
.htaccess 575 Bytes 13621 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/.TNRS/.htaccess: qsappend does n...
Makefile 27 Bytes 10178 over 11 years Aaron Marcuse-Kubitza inputs/*/: added top-level Makefile which inclu...
data.sql 22.3 KB 13870 over 10 years Aaron Marcuse-Kubitza inputs/.TNRS/data.sql: refreshed
data.sql.run 369 Bytes 13572 over 10 years Aaron Marcuse-Kubitza inputs/.TNRS/data.sql.run: refresh(): documente...
import_order.txt 7 Bytes 7838 over 11 years Aaron Marcuse-Kubitza inputs/.TNRS/import_order.txt: Removed public.u...
run 87 Bytes 10294 over 11 years Aaron Marcuse-Kubitza inputs/.TNRS/: switched to new-style import. be...
schema.sql 30.1 KB 14110 over 10 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: MatchedTaxon: taxon_be...
schema.sql.run 134 Bytes 13372 over 10 years Aaron Marcuse-Kubitza fix: lib/runscripts/file.pg.sql.run: removed in...
table.run 81 Bytes 10179 over 11 years Aaron Marcuse-Kubitza inputs/*/: added table.run for use by the table...
  • svn:ignore: *

Latest revisions

# Date Author Comment
14110 07/17/2014 03:34 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: taxon_best_match: don't alias to `s` since this is no longer a nested select
14109 07/17/2014 03:32 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: nested select: use just taxon_best_match since this no longer performs renamings
14108 07/17/2014 03:27 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: renamed output columns to match input columns, so that the nested select would not be performing any renamings
14107 07/17/2014 03:05 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: MatchedTaxon: added all columns from taxon_match (some of them apparently hadn't been included in MatchedTaxon)
14106 07/17/2014 03:01 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: reordered columns to match taxon_match
14105 07/17/2014 02:38 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: MatchedTaxon: added all columns from taxon_match (some of them apparently hadn't been included in MatchedTaxon)
14104 07/17/2014 01:02 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: added back Family_matched, which had gotten merged with Name_matched_accepted_family when TNRS temporarily stopped populating Name_matched_accepted_family
14103 07/17/2014 12:32 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: taxonomicStatus: moved outside the inner SELECT so that the inner SELECT would consist solely of renamings
14102 07/17/2014 12:12 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: removed unneeded "Name_matched." prefix on source-specific names (only the * is needed because there is only one table)
14080 07/16/2014 11:37 AM Aaron Marcuse-Kubitza

inputs/.TNRS/Source/test.xml.ref: updated

View revisions

Also available in: Atom