Project

General

Profile

Statistics
| Revision:

root/trunk/inputs/.TNRS @ 14361

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 35.8 KB 14330 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/.TNRS/schema.sql: taxon_match: d...
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 79.3 KB 14361 over 10 years Aaron Marcuse-Kubitza fix: inputs/.TNRS/schema.sql: taxon_match: to r...
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
14361 07/26/2014 08:24 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: to remove columns or add columns: also need to run util.recreate_view()
14360 07/26/2014 08:19 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: to remove columns or add columns at the end: don't need to run `rm=1 inputs/.TNRS/data.sql.run` because this is now run by `make schemas/remake`
14359 07/26/2014 08:13 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added new derived columns to derived views
14358 07/26/2014 07:52 PM Aaron Marcuse-Kubitza

schemas/util.sql: remove_prefix(), remove_suffix(): support case-insensitive matching
14357 07/26/2014 07:43 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match.__accepted_infraspecific_label: need to use case-insensitive matching of the removed prefix because TNRS lowercases part of the Accepted_name
14356 07/26/2014 07:40 PM Aaron Marcuse-Kubitza

schemas/util.sql: remove_prefix(), remove_suffix(): support case-insensitive matching
14347 07/26/2014 05:16 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match: use wrapper for util.remove_prefix() so CHECK constraints that use it don't get dropped when the util schema is reinstalled
14332 07/25/2014 02:21 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: COMMENT: added steps to port derived column changes to vegbiendev
14330 07/25/2014 12:41 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match: derived columns: use new "matched~Name[_no_author]___@TNRS__@vegpath.org" instead of "*Name_matched" so that "No suitable matches found." is removed before concatenating with other fields
14329 07/25/2014 12:14 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column "matched~Name[_no_author]___@TNRS__@vegpath.org", which removes the "No suitable matches found." string

View revisions

Also available in: Atom