Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 7772 over 11 years Aaron Marcuse-Kubitza Added schemas/BIEN2/ERD/
  DiGIR 7767 over 11 years Aaron Marcuse-Kubitza Added schemas/DiGIR/gbif-occurrencestore.digir....
  DwC 8507 over 11 years Aaron Marcuse-Kubitza web/**/.htaccess: RewriteRules: ensured flags a...
  TAPIR 7789 over 11 years Aaron Marcuse-Kubitza Added schemas/TAPIR/SpeciesLink.tapir_request.t...
  TCS 10656 over 11 years Aaron Marcuse-Kubitza schemas/VegX/.htaccess, TCS/.htaccess: prepend ...
  VegBIEN 11281 about 11 years Aaron Marcuse-Kubitza schemas/VegBIEN/attribution/BIEN 3 data use and...
  VegBank 9671 over 11 years Aaron Marcuse-Kubitza *.url: mailto URLs: use the standard e-mail dot...
  VegCore 11525 about 11 years Aaron Marcuse-Kubitza schemas/VegCore/ERD/VegCore.ERD.mwb: traceable....
  VegX 10656 over 11 years Aaron Marcuse-Kubitza schemas/VegX/.htaccess, TCS/.htaccess: prepend ...
.htaccess 349 Bytes 8514 over 11 years Aaron Marcuse-Kubitza bugfix: schemas/.htaccess: corrected $innermost...
BIEN_logo.png 165 KB 7740 over 11 years Aaron Marcuse-Kubitza Added schemas/BIEN_logo.png from the bien.nceas...
BIEN_logo.png.url 61 Bytes 7740 over 11 years Aaron Marcuse-Kubitza Added schemas/BIEN_logo.png from the bien.nceas...
BIEN_logo.small.png 9.84 KB 7739 over 11 years Aaron Marcuse-Kubitza Renamed schemas/BIEN_logo.png to BIEN_logo.smal...
Makefile 2.72 KB 11822 almost 11 years Aaron Marcuse-Kubitza bugfix: schemas/Makefile: %/uninstall: always c...
filter_ERD.csv 1.45 KB 7060 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: sync_analytical_*_to_view(...
my.cnf 3.48 KB 9619 over 11 years Aaron Marcuse-Kubitza schemas/my.cnf: added innodb_file_per_table so ...
pg_hba.Mac.conf 4.64 KB 11662 about 11 years Aaron Marcuse-Kubitza *Makefile, schemas/*.Mac.conf: upgraded to Post...
pg_hba.conf 4.26 KB 11451 about 11 years Aaron Marcuse-Kubitza bugfix: schemas/pg_hba.conf: don't allow ident ...
pg_ident.Mac.conf 1.65 KB 10122 over 11 years Aaron Marcuse-Kubitza schemas/pg_ident.Mac.conf: added postgres map m...
postgresql.Mac.conf 20.7 KB 11662 about 11 years Aaron Marcuse-Kubitza *Makefile, schemas/*.Mac.conf: upgraded to Post...
postgresql.Mac.conf.run 80 Bytes 10833 about 11 years Aaron Marcuse-Kubitza added schemas/postgresql*.conf.run, which insta...
postgresql.conf 21.2 KB 11797 almost 11 years Aaron Marcuse-Kubitza schemas/postgresql.conf: work_mem: documented t...
postgresql.conf.run 80 Bytes 10833 about 11 years Aaron Marcuse-Kubitza added schemas/postgresql*.conf.run, which insta...
postgresql.nimoy.conf 17.1 KB 2778 over 12 years Aaron Marcuse-Kubitza schemas/postgresql.nimoy.conf: shared_buffers: ...
py_util.sql 6.42 KB 11667 about 11 years Aaron Marcuse-Kubitza schemas/*.sql: updated for PostgreSQL 9.3. this...
temp.sql 357 Bytes 2980 over 12 years Aaron Marcuse-Kubitza Added temp schema to store intermediate tables ...
tree_cross-links.sql 4.69 KB 5829 about 12 years Aaron Marcuse-Kubitza schemas/tree_cross-links.sql: Updated for schem...
util.sql 60.5 KB 11836 almost 11 years Aaron Marcuse-Kubitza schemas/util.sql: explain2table(): documented u...
vegbien.ERD.1_pg.pdf 749 KB 11807 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.mwb 151 KB 11990 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: projectcontributor: added ...
vegbien.ERD.pdf 597 KB 11807 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.png 622 KB 11807 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.poster.core.pdf 315 KB 6323 about 12 years Aaron Marcuse-Kubitza Added schemas/vegbien.ERD.poster.core.pdf
vegbien.ERD.poster.core.print_options.png 74 KB 6324 about 12 years Aaron Marcuse-Kubitza Added schemas/vegbien.ERD.poster.core.print_opt...
vegbien.ERD.poster.pdf 776 KB 6328 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.poster.pdf: Updated to 33x5...
vegbien.ERD.svg 1.42 MB 11807 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.my.sql 267 KB 11990 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: projectcontributor: added ...
vegbien.sql 387 KB 11998 almost 11 years Aaron Marcuse-Kubitza bugfix: schemas/vegbien.sql: locationevent__com...
  • svn:ignore: *.bak *.log

Latest revisions

# Date Author Comment
11998 01/23/2014 12:15 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: locationevent__communities(): inner-join to commdetermination instead of left-joining, so that this does not produce community entries (which occur because there is one commclass per locationevent, but only some commclasses will then have a commdetermination)

11990 01/22/2014 12:24 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: projectcontributor: added missing unique constraint

11970 01/20/2014 11:33 AM Aaron Marcuse-Kubitza

moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).

11963 01/15/2014 11:23 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: plot.**, analytical_stem_view, analytical_plot: added project_contributors

11962 01/15/2014 11:14 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added project_contributors()

11921 12/19/2013 11:11 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: scientificName_verbatim: don't use taxonverbatim.taxonname+author as the scientificName_verbatim if only the author is provided. (this lead to weird scientificName_verbatims that contain just the author.)

11908 12/12/2013 08:35 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: location: use the place_id from the parent location when no place_id is specified. this fixes a bug in analytical_stem_view where the parent location's place_id was used because it was sometimes missing from the sublocation, but the parent place_id itself was sometimes missing instead if sublocations each had their own place information. this way, it is always available directly in the sublocation, populated from the parent location if needed.

11907 12/12/2013 08:27 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: location: added place_id which is autopopulated from the current locationplace. join on this in plot.**, to avoid a 1:many join when a location has multiple locationplaces.

11906 12/11/2013 11:10 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: locationevent_unique_within_parent_by_location unique index: need COALESCE around location_id since it's nullable

11889 12/10/2013 07:10 AM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: analytical_specimen: added specimens-related columns that are in analytical_plot

View revisions

Also available in: Atom