Project

General

Profile

Statistics
| Revision:

root/trunk/schemas @ 12196

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 about 11 years Aaron Marcuse-Kubitza schemas/VegX/.htaccess, TCS/.htaccess: prepend ...
  VegBIEN 11281 almost 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 12088 over 10 years Aaron Marcuse-Kubitza schemas/VegCore/vegbien_identifier_examples.xls...
  VegX 12090 over 10 years Aaron Marcuse-Kubitza removed schemas/VegX/run.py, which is a duplica...
.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 3.46 KB 12146 over 10 years Aaron Marcuse-Kubitza schemas/Makefile: vegbien.sql: support auxiliar...
filter_ERD.csv 1.45 KB 7060 over 11 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 almost 11 years Aaron Marcuse-Kubitza *Makefile, schemas/*.Mac.conf: upgraded to Post...
pg_hba.conf 4.26 KB 11451 almost 11 years Aaron Marcuse-Kubitza bugfix: schemas/pg_hba.conf: don't allow ident ...
pg_ident.Mac.conf 1.65 KB 10122 about 11 years Aaron Marcuse-Kubitza schemas/pg_ident.Mac.conf: added postgres map m...
postgresql.Mac.conf 20.7 KB 11662 almost 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 almost 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 almost 12 years Aaron Marcuse-Kubitza schemas/tree_cross-links.sql: Updated for schem...
util.sql 65.6 KB 12185 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: diff_cols(): documented how t...
vegbien.ERD.1_pg.pdf 749 KB 12051 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.mwb 152 KB 12186 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: public_validations_*: merg...
vegbien.ERD.pdf 596 KB 12051 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.png 623 KB 12051 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.poster.core.pdf 315 KB 6323 almost 12 years Aaron Marcuse-Kubitza Added schemas/vegbien.ERD.poster.core.pdf
vegbien.ERD.poster.core.print_options.png 74 KB 6324 almost 12 years Aaron Marcuse-Kubitza Added schemas/vegbien.ERD.poster.core.print_opt...
vegbien.ERD.poster.pdf 776 KB 6328 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.poster.pdf: Updated to 33x5...
vegbien.ERD.svg 1.42 MB 12051 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.my.sql 273 KB 12186 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: public_validations_*: merg...
vegbien.sql 412 KB 12186 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.sql: public_validations_*: merg...
  • svn:ignore: *.bak *.log

Latest revisions

# Date Author Comment
12186 02/13/2014 04:06 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: public_validations_*: merged into single public_validations schema, with type-specific prefixes for each query, so that datasources can use validations queries from multiple type categories, and so that each datasource doesn't have to indicate which validations output schema it's using
12185 02/13/2014 02:23 PM Aaron Marcuse-Kubitza

schemas/util.sql: diff_cols(): documented how to run EXPLAIN on the FULL JOIN query
12184 02/13/2014 02:14 PM Aaron Marcuse-Kubitza

schemas/util.sql: diff_cols(): embed left_query/right_query directly in the main SQL statement, so that the query planner can take the sort order of the queries into account in planning the FULL JOIN (and where possible, use a fast merge join)
12183 02/13/2014 02:09 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: regenerated from DB, which adds an autogenerated column alias
12182 02/13/2014 02:06 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql, validation/aggregating/*/*.sql: renamed public_validation_* to plural public_validations_* since we refer to them as aggregating validation*s*
12181 02/13/2014 02:05 PM Aaron Marcuse-Kubitza

schemas/util.sql: added eval2col_pair()
12172 02/13/2014 10:41 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql, validation/aggregating/*/*.sql: renamed public_validation_* to plural public_validations_* since we refer to them as aggregating validation*s*
12169 02/13/2014 08:34 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: public_validation_plots: added Brad's notes as comments
12168 02/13/2014 08:29 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: public_validation_plots: populated queries from validation/aggregating/plots/bien3_validations_salvias_vegbien.sql
12165 02/13/2014 08:20 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: public_validation_traits: added Brad's notes as comments

View revisions

Also available in: Atom