Project

General

Profile

Statistics
| Revision:

root @ 12404

Name Size Revision Age Author Comment
  branches 11969 over 10 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 over 10 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 12404 over 10 years Aaron Marcuse-Kubitza fix: validation/aggregating/plots/SALVIAS/bien3...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
12404 02/24/2014 08:37 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: renamed truncated views to match the output queries
12403 02/24/2014 12:30 AM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: can't double-JOIN like in MySQL (`JOIN a JOIN b ON a_conds AND b_conds`), so split double-JOIN into two JOINs w/ own ON clauses
12402 02/24/2014 12:28 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: removed `LIMIT 10` to match output queries
12401 02/24/2014 12:26 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: updated table names to match our renamings
12400 02/24/2014 12:25 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: public_validations.remake_diff_table(): put the type table in the public_validations schema to avoid cluttering up the datasource schema with internal tables
12399 02/24/2014 12:24 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: synced to DB, which changes the sort order (due to system update?)
12398 02/24/2014 12:21 AM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: can't double-JOIN like in MySQL (`JOIN a JOIN b ON a_conds AND b_conds`), so split double-JOIN into two JOINs w/ own ON clauses
12397 02/24/2014 12:16 AM Aaron Marcuse-Kubitza

added validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql, modified from bien3_validations_salvias_db_original.sql using the steps at http://wiki.vegpath.org/Aggregating_validations_refactoring
12396 02/23/2014 11:57 PM Aaron Marcuse-Kubitza

fix: /README.TXT: use exact ssh command needed to connect to vegbiendev/jupiter (eg. `ssh -t vegbiendev.nceas.ucsb.edu exec sudo su - aaronmk`) instead of vaguely referring to "on vegbiendev"/"on jupiter"
12395 02/23/2014 11:28 PM Aaron Marcuse-Kubitza

/README.TXT: Full database import: screen: run `unset TMOUT` first because it is most important, now that the remote servers have a TMOUT set for extra security

View all revisions | View revisions

Also available in: Atom