Project

General

Profile

Statistics
| Revision:

root @ 8526

Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 7564 almost 12 years Aaron Marcuse-Kubitza lib/common.Makefile: remote server: Use jupiter...
  bin 8320 over 11 years Aaron Marcuse-Kubitza bin/make_analytical_db: Commented out export_an...
  config 7801 almost 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  inputs 8513 over 11 years Aaron Marcuse-Kubitza added .htaccess files for inputs/, schemas/ bec...
  lib 8465 over 11 years Aaron Marcuse-Kubitza lib/util.run: run_cmd (): renamed to run_args_c...
  mappings 8235 almost 12 years Aaron Marcuse-Kubitza mappings/VegCore.htm: Renamed salvias_plots tab...
  planning 8457 over 11 years Aaron Marcuse-Kubitza Moved validation/ under planning/workflow/
  schemas 8526 over 11 years Aaron Marcuse-Kubitza schemas/VegCore/VegCore.ERD.mwb: renamed taxon_...
  web 8507 over 11 years Aaron Marcuse-Kubitza web/**/.htaccess: RewriteRules: ensured flags a...
Makefile 12.1 KB 8081 almost 12 years Aaron Marcuse-Kubitza root Makefile: Installation: Fixed bug where ne...
README.TXT 19.5 KB 8516 over 11 years Aaron Marcuse-Kubitza README.TXT: Maintenance: to backup the Ubuntu V...
fix_perms 97 Bytes 7560 almost 12 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 about 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 almost 12 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
unmapped_terms.csv 13.1 KB 7201 almost 12 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
8526 04/16/2013 05:24 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: renamed taxon_occurrence.*_taxon_determination to taxon_occurrence.*_determination because the column name does not need to be globally unique, and can therefore be shorter while still being unambiguous within the table
8525 04/16/2013 04:34 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: fixed lines
8524 04/16/2013 04:33 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: changed all fkeys to CASCADE to support cascading deletes. this allows datasources to be reloaded, because the corresponding source row can be deleted, and the delete will cascade to every record that's part of that datasource.
8523 04/16/2013 04:25 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: changed globally unique column names to locally unique column names, now that the SQL dotpath algorithm (http://vegpath.org/wiki/SQL_dotpaths#Algorithm) can be used to generate globally unique column names automatically according to the fkeys. in particular, this means that the pkeys have all been renamed to "id".
8522 04/16/2013 02:30 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.my.sql: removed default_schema qualifier from names because all objects are in the same schema
8521 04/16/2013 02:29 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.my.sql: regenerated from ERD
8520 04/16/2013 09:25 AM Aaron Marcuse-Kubitza

bugfix: schemas/VegCore/VegCore.ERD.mwb: fixed pkey names to match table names
8519 04/16/2013 09:18 AM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: renamed matched_taxon table to synonym_taxon because it can be used to store any taxon which has a corresponding accepted_taxon, not just the match results from TNRS
8518 04/16/2013 09:05 AM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: renamed qualified_taxon tables to *taxon_assertion because they are not just a taxon name plus an optional cf/aff qualifier, but an actual operator/value pair that is the right-hand side of a comparison with a taxon or taxon_occurrence
8517 04/16/2013 08:43 AM Aaron Marcuse-Kubitza

bugfix: schemas/VegCore/VegCore.ERD.mwb: qualified_taxon subclasses: changed HAS-A arrows to point in the other direction, because the many:1 relationship in fact narrows towards the accepted_taxon. the arrows used to be in the opposite direction because of the way the TNRS results are attached incrementally.

View all revisions | View revisions

Also available in: Atom