Project

General

Profile

Statistics
| Revision:
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 36.6 KB 14375 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/.TNRS/schema.sql: taxon_match."_...
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 86.3 KB 14379 over 10 years Aaron Marcuse-Kubitza fix: schemas/util.sql: derived_col_update(): al...
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
14379 07/28/2014 04:45 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: derived_col_update(): also need steps to drop column, because DROP __ CASCADE doesn't work when there are dependent views

14378 07/28/2014 04:33 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: _accepted_infraspecific{rank,epithet}: use array slice of new _accepted{genus,specific_epithet,infra_{rank,epithet}}, which is simpler than using remove_prefix() in __accepted_infraspecific_label

14377 07/28/2014 04:21 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: "[accepted_]genus__@DwC__@vegpath.org": don't need to use *Accepted_name anymore because _accepted{genus,specific_epithet,infra_{rank,epithet}} is now generated from *Accepted_name

14376 07/28/2014 04:02 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match."__accepted_{genus,specific_epithet}": renamed to "__accepted_{genus,specific_epithet,infra_{rank,epithet}}" since this now includes these other ranks as well

14375 07/28/2014 03:48 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match."__accepted_{genus,specific_epithet}": use "*Accepted_name" instead of "Accepted_species[_binomial]__@TNRS__@vegpath.org" (from "*Accepted_name_species") because Accepted_name_species apparently sometimes does not match the Accepted_name and uses malformed Unicode characters

14368 07/26/2014 10:16 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: `inputs/.TNRS/data.sql.run refresh`: documented runtime (1 min)

14367 07/26/2014 10:15 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match: use "Accepted_species[_binomial]__@TNRS__@vegpath.org" instead of "*Accepted_name_species". this fixes a bug in __accepted_infraspecific_label where Accepted_name_species with trailing whitespace could not be prefix-removed from names that contained just a species binomial.

14366 07/26/2014 09:57 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: added derived column "Accepted_species[_binomial]__@TNRS__@vegpath.org", which removes trailing whitespace

14365 07/26/2014 08:58 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added steps to remove a column and to add a non-derived column

14364 07/26/2014 08:48 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: to remove columns or add columns at the end: merged into "to add a new derived column"

View revisions

Also available in: Atom