Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 12779 almost 11 years Aaron Marcuse-Kubitza *{.sh,run}: use new begin_target instead of `ec...
  _archive 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  _license 14301 over 10 years Aaron Marcuse-Kubitza added derived/TNRS/Morphospecies and scope.eml*...
  backups 14374 over 10 years Aaron Marcuse-Kubitza backups/README.TXT: added backup retention policy
  bin 14099 over 10 years Aaron Marcuse-Kubitza bin/import_all: hidden_srcs(): removed `by_col=...
  config 14064 over 10 years Aaron Marcuse-Kubitza fix: config/VirtualBox_VMs/vegbiendev/README.TX...
  derived 14298 over 10 years Aaron Marcuse-Kubitza added derived/TNRS/Morphospecies and scope.eml*...
  downloads 13537 over 10 years Aaron Marcuse-Kubitza added downloads/
  exports 13929 over 10 years Aaron Marcuse-Kubitza exports/2014-6-4.Iara_Lacher.reserve_prioritiza...
  inputs 14379 over 10 years Aaron Marcuse-Kubitza fix: schemas/util.sql: derived_col_update(): al...
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 14348 over 10 years Aaron Marcuse-Kubitza lib/sh/sync.sh: db_snapshot(): before backing u...
  mappings 13947 over 10 years Aaron Marcuse-Kubitza fix: mappings/VegCore-VegBIEN.csv: mapped DwC y...
  planning 13880 over 10 years Aaron Marcuse-Kubitza planning/meetings/BIEN conference call availabi...
  schemas 14380 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: added col_re()
  validation 13963 over 10 years Aaron Marcuse-Kubitza validation/completeness/BIENDatesPopulated.xlsx...
  web 14336 over 10 years Aaron Marcuse-Kubitza web/username_prefix.php: substitutions: also su...
  wiki 13787 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: use lowercase when there is a s...
.htaccess 326 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_filter.upload 33 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_ignore 12 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
LICENSE.TXT 6.17 KB 13787 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: use lowercase when there is a s...
Makefile 12.9 KB 14068 over 10 years Aaron Marcuse-Kubitza bugfix: /Makefile: postgres_restart-*: argument...
README.TXT 34.4 KB 14197 over 10 years Aaron Marcuse-Kubitza bugfix: /README.TXT: Full database import: adde...
fix_perms 97 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
map 1001 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
new_terms.csv 80.2 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
run 518 Bytes 12968 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
unmapped_terms.csv 33 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
14380 07/28/2014 05:20 PM Aaron Marcuse-Kubitza

schemas/util.sql: added col_re()

14379 07/28/2014 04:45 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: derived_col_update(): also need steps to drop column, because DROP __ CASCADE doesn't work when there are dependent views

14378 07/28/2014 04:33 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: _accepted_infraspecific{rank,epithet}: use array slice of new _accepted{genus,specific_epithet,infra_{rank,epithet}}, which is simpler than using remove_prefix() in __accepted_infraspecific_label

14377 07/28/2014 04:21 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: "[accepted_]genus__@DwC__@vegpath.org": don't need to use *Accepted_name anymore because _accepted{genus,specific_epithet,infra_{rank,epithet}} is now generated from *Accepted_name

14376 07/28/2014 04:02 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match."__accepted_{genus,specific_epithet}": renamed to "__accepted_{genus,specific_epithet,infra_{rank,epithet}}" since this now includes these other ranks as well

14375 07/28/2014 03:48 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match."__accepted_{genus,specific_epithet}": use "*Accepted_name" instead of "Accepted_species[_binomial]__@TNRS__@vegpath.org" (from "*Accepted_name_species") because Accepted_name_species apparently sometimes does not match the Accepted_name and uses malformed Unicode characters

14374 07/28/2014 03:20 PM Aaron Marcuse-Kubitza

backups/README.TXT: added backup retention policy

14373 07/27/2014 03:19 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: derived_cols_export(): also need to first run util.derived_cols_remove() if changing the derived column order

14372 07/27/2014 03:15 PM Aaron Marcuse-Kubitza

schemas/util.sql: added derived_cols_remove(), which allows derived columns to be re-created in a different order

14371 07/27/2014 03:01 PM Aaron Marcuse-Kubitza

schemas/util.sql: added drop_derived_col(), which ensures that drop_column() only cascades to views

View revisions

Also available in: Atom