Project

General

Profile

Statistics
| Revision:

root @ 14371

Name Size Revision Age Author Comment
  branches 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 14371 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: added drop_derived_col(), whi...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
14371 07/27/2014 03:01 PM Aaron Marcuse-Kubitza

schemas/util.sql: added drop_derived_col(), which ensures that drop_column() only cascades to views
14370 07/27/2014 02:54 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: drop_column(): also need to recreate dependent views
14369 07/27/2014 02:26 PM Aaron Marcuse-Kubitza

schemas/util.sql: added drop_constraint()
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"
14363 07/26/2014 08:44 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: to add columns in the middle: renamed to "to move a column to the middle" for clarity
14362 07/26/2014 08:38 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: to populate a new column: updated to use util.derived_col_update()

View all revisions | View revisions

Also available in: Atom