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 32.7 KB 14303 over 10 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: taxon_match: added der...
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 64.9 KB 14303 over 10 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: taxon_match: added der...
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
14303 07/22/2014 01:37 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org"

14284 07/21/2014 05:44 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added new derived columns to derived views

14283 07/21/2014 05:30 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: derived_col_update(): column comment: formula: put on own line to support multiline exprs

14282 07/21/2014 05:26 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: derived_col_update(): column comment: need to use expr from DB, not as provided by user, to avoid this changing when derived_col_update() is rerun

14281 07/21/2014 05:13 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived columns scrubbed_*

14279 07/21/2014 04:34 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: put matched-taxon derived columns before accepted-taxon derived columns

14278 07/21/2014 04:25 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column "[matched_]species[_binomial]~(Accepted_)__@TNRS__@vegpath.org"

14277 07/21/2014 04:08 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: _matched_has_accepted: renamed to matched_has_accepted because the leading _ did not create vertical alignment anyway, due to different quoting syntaxes

14275 07/21/2014 03:48 PM Aaron Marcuse-Kubitza

schemas/util.sql: derived_col_update(): add steps to rename column

14273 07/21/2014 03:34 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: derived_col_update(): don't set_comment() until CHECK constraint exists so that we can use its canon-ed formula

View revisions

Also available in: Atom