Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 over 12 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 over 11 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 over 11 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 over 11 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 8525 over 11 years Aaron Marcuse-Kubitza schemas/VegCore/VegCore.ERD.mwb: fixed lines
  web 8507 over 11 years Aaron Marcuse-Kubitza web/**/.htaccess: RewriteRules: ensured flags a...
Makefile 12.1 KB 8081 over 11 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 over 11 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 almost 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
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.

8516 04/16/2013 08:28 AM Aaron Marcuse-Kubitza

README.TXT: Maintenance: to backup the Ubuntu VM: removed invisible U+FEFF Unicode character

View all revisions | View revisions

Also available in: Atom