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 33.9 KB 14323 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/.TNRS/schema.sql: derived column...
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 70.4 KB 14323 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/.TNRS/schema.sql: derived column...
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
14323 07/22/2014 05:30 AM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: derived columns: use "Accepted_family__@TNRS__@vegpath.org" instead of "*Accepted_name_family" because "*Accepted_name_family" is sometimes missing

14318 07/22/2014 04:12 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: added derived column "Accepted_family__@TNRS__@vegpath.org", which is needed because "*Accepted_name_family" isn't always populated

14317 07/22/2014 04:01 AM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match: to add columns in the middle: also need to run util.derived_cols_repopulate() since the dependency order has changed

14313 07/22/2014 03:25 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: COMMENT: to add columns in the middle: also need to run util.derived_cols_update()

14312 07/22/2014 03:23 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: COMMENT: updated util.derived_cols_sync() to util.derived_cols_update()

14311 07/22/2014 03:20 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: reordered derived columns in dependency order

14310 07/22/2014 03:12 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: reordered derived columns in dependency order

14309 07/22/2014 02:44 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: derived_cols_trigger_update(): need to clear derived cols first so old values won't be used in calculations

14308 07/22/2014 02:36 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: derived_cols_trigger_update(): put expr on same line as var, to save space

14307 07/22/2014 02:33 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: derived_cols_trigger_update(): removed lines between statements, which add too much space

View revisions

Also available in: Atom