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 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 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 8529 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 almost 12 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
8529 04/16/2013 05:34 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: fixed lines

8528 04/16/2013 05:31 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: fixed lines

8527 04/16/2013 05:28 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: removed redundant "DEFAULT NULL" clauses on nullable fields

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

View all revisions | View revisions

Also available in: Atom