Project

General

Profile

Statistics
| Revision:

root @ 10747

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 10745 over 11 years Aaron Marcuse-Kubitza updated backups/TNRS.backup
  bin 10742 over 11 years Aaron Marcuse-Kubitza bin/tnrs_db: add entry to new batch table
  config 7801 almost 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  derived 10707 over 11 years Aaron Marcuse-Kubitza added derived/biengeo/ from https://projects.nc...
  exports 9928 over 11 years Aaron Marcuse-Kubitza added exports/_archive/
  inputs 10747 over 11 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: tnrs: util.set_col_typ...
  lib 10649 over 11 years Aaron Marcuse-Kubitza lib/sh/db.sh: mysqldump(): added create_db=1 fl...
  mappings 10722 over 11 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped datasetURL
  planning 10735 over 11 years Aaron Marcuse-Kubitza fix: planning/timeline/timeline.2013.xls: Switc...
  schemas 10715 over 11 years Aaron Marcuse-Kubitza bugfix: schemas/util.sql: set_col_names_with_me...
  web 10705 over 11 years Aaron Marcuse-Kubitza web/links/index.htm: updated to Firefox bookmar...
.htaccess 326 Bytes 8771 over 11 years Aaron Marcuse-Kubitza /.htaccess: use canonical URL without symlinks
.rsync_filter.upload 33 Bytes 10042 over 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
.rsync_ignore 12 Bytes 10042 over 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
Makefile 12.6 KB 10539 over 11 years Aaron Marcuse-Kubitza bugfix: /Makefile: postgres-Linux: phppgadmin.c...
README.TXT 23.8 KB 10744 over 11 years Aaron Marcuse-Kubitza /README.TXT: Full database import: To back up D...
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
run 433 Bytes 9916 over 11 years Aaron Marcuse-Kubitza /run: geoscrub_input/make(): documented runtime...
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
10747 08/27/2013 12:49 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs: util.set_col_types() runtime: updated for most recent ALTER COLUMN TYPE command (9 min)
10746 08/27/2013 12:25 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs.Time_submitted: renamed to batch and added fkey to batch.id. this requires including the batch table in inputs/.TNRS/data.sql, so that the fkey is satisfied (batch entries are already added by bin/tnrs_db.
10745 08/27/2013 11:42 AM Aaron Marcuse-Kubitza

updated backups/TNRS.backup
10744 08/27/2013 11:38 AM Aaron Marcuse-Kubitza

/README.TXT: Full database import: To back up DB (staging tables and last import) separately: added step to upload backups to jupiter
10743 08/27/2013 11:30 AM Aaron Marcuse-Kubitza

/README.TXT: Full database import: To back up DB (staging tables and last import) separately: added step to remake backups/TNRS.backup
10742 08/26/2013 08:45 PM Aaron Marcuse-Kubitza

bin/tnrs_db: add entry to new batch table
10741 08/26/2013 07:48 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: batch: reset name of id_by_time unique constraint since this field is now in the batch table
10740 08/26/2013 07:46 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: download_settings: renamed to batch_download_settings because this table is actually specific to the batch, and it does not make sense to have a download settings file without a batch
10739 08/26/2013 07:32 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: download_settings.id: added fkey to batch.id to create a 1:1 relationship with optional participation by download_settings. note that this relationship happens to be the same as SQL inheritance, as used in VegCore, but in this case, the 1:1 relationship is not related to inheritance.
10738 08/26/2013 06:30 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: client_version: added table, column comments with info on how to retrieve each value

View all revisions | View revisions

Also available in: Atom