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 about 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 almost 11 years Aaron Marcuse-Kubitza schemas/VegX/.htaccess, TCS/.htaccess: prepend ...
  VegBIEN 11281 over 10 years Aaron Marcuse-Kubitza schemas/VegBIEN/attribution/BIEN 3 data use and...
  VegBank 9671 about 11 years Aaron Marcuse-Kubitza *.url: mailto URLs: use the standard e-mail dot...
  VegCore 12968 about 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
  VegX 12090 over 10 years Aaron Marcuse-Kubitza removed schemas/VegX/run.py, which is a duplica...
.htaccess 349 Bytes 8514 about 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.9 KB 13438 about 10 years Aaron Marcuse-Kubitza schemas/Makefile: vegbien.sql: exclude the same...
VegCore.ERD.pdf 32 Bytes 12819 about 10 years Aaron Marcuse-Kubitza added schemas/VegCore.ERD.pdf symlink for easy ...
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 about 11 years Aaron Marcuse-Kubitza schemas/my.cnf: added innodb_file_per_table so ...
pg_hba.Mac.conf 4.64 KB 11662 over 10 years Aaron Marcuse-Kubitza *Makefile, schemas/*.Mac.conf: upgraded to Post...
pg_hba.conf 4.26 KB 11451 over 10 years Aaron Marcuse-Kubitza bugfix: schemas/pg_hba.conf: don't allow ident ...
pg_ident.Mac.conf 1.65 KB 10122 almost 11 years Aaron Marcuse-Kubitza schemas/pg_ident.Mac.conf: added postgres map m...
postgresql.Mac.conf 20.7 KB 11662 over 10 years Aaron Marcuse-Kubitza *Makefile, schemas/*.Mac.conf: upgraded to Post...
postgresql.Mac.conf.run 80 Bytes 10833 almost 11 years Aaron Marcuse-Kubitza added schemas/postgresql*.conf.run, which insta...
postgresql.conf 21.6 KB 13274 about 10 years Aaron Marcuse-Kubitza schemas/postgresql.conf: wal_level: set to hot_...
postgresql.conf.run 80 Bytes 10833 almost 11 years Aaron Marcuse-Kubitza added schemas/postgresql*.conf.run, which insta...
postgresql.nimoy.conf 17.1 KB 2778 almost 12 years Aaron Marcuse-Kubitza schemas/postgresql.nimoy.conf: shared_buffers: ...
public_.sql 554 KB 13442 about 10 years Aaron Marcuse-Kubitza bugfix: schemas/public_.sql: _plots_20_tnrs_nam...
py_util.sql 6.42 KB 12235 over 10 years Aaron Marcuse-Kubitza schemas/*.sql: make sure every COMMENT starts a...
temp.sql 357 Bytes 2980 almost 12 years Aaron Marcuse-Kubitza Added temp schema to store intermediate tables ...
tree_cross-links.sql 4.69 KB 5829 over 11 years Aaron Marcuse-Kubitza schemas/tree_cross-links.sql: Updated for schem...
util.sql 108 KB 13471 about 10 years Aaron Marcuse-Kubitza bugfix: schemas/util.sql: force_recreate(): rec...
vegbien.ERD.1_pg.pdf 775 KB 13158 about 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.mwb 174 KB 13157 about 10 years Aaron Marcuse-Kubitza fix: lib/PostgreSQL-MySQL.csv: preserve schema ...
vegbien.ERD.pdf 613 KB 13158 about 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.png 638 KB 13158 about 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.poster.core.pdf 315 KB 6323 over 11 years Aaron Marcuse-Kubitza Added schemas/vegbien.ERD.poster.core.pdf
vegbien.ERD.poster.core.print_options.png 74 KB 6324 over 11 years Aaron Marcuse-Kubitza Added schemas/vegbien.ERD.poster.core.print_opt...
vegbien.ERD.poster.pdf 776 KB 6328 over 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.poster.pdf: Updated to 33x5...
vegbien.ERD.svg 1.48 MB 13158 about 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.my.sql 340 KB 13438 about 10 years Aaron Marcuse-Kubitza schemas/Makefile: vegbien.sql: exclude the same...
vegbien.sql 577 KB 13444 about 10 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: MatchedTaxon.Accepted_...
  • svn:ignore: *.bak *.log

Latest revisions

# Date Author Comment
13471 05/17/2014 05:36 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: force_recreate(): recreate_users_cmds: use create_if_not_exists() rather than eval(), because cmd might manually re-create a deleted dependent view, causing it to already exist

13470 05/17/2014 05:27 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: save_drop_view(): util.show_create_view(): don't include `OR REPLACE` because that causes nonuniform errors (eg. invalid_table_definition), instead of the standard duplicate_table exception caught by util.create_if_not_exists()

13469 05/17/2014 05:25 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: show_create_view(): removed extra trailing ; because pg_get_viewdef() now includes one

13468 05/17/2014 05:24 PM Aaron Marcuse-Kubitza

schemas/util.sql: show_create_view(): made inclusion of `OR REPLACE` configurable

13467 05/17/2014 05:10 PM Aaron Marcuse-Kubitza

schemas/util.sql: save_drop_view(): use util.drop_view()

13456 05/13/2014 11:19 AM Aaron Marcuse-Kubitza

schemas/util.sql: save_drop_views(): return text[] instead of concatenated text so that the queries will be run individually and be easier to debug

13455 05/13/2014 11:00 AM Aaron Marcuse-Kubitza

schemas/util.sql: added eval(queries text[])

13454 05/13/2014 09:43 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: force_recreate(): need to drop users in reverse to avoid dependencies that block the drop

13453 05/13/2014 09:25 AM Aaron Marcuse-Kubitza

schemas/util.sql: added array_reverse()

13452 05/13/2014 09:25 AM Aaron Marcuse-Kubitza

schemas/util.sql: added in_reverse()

View revisions

Also available in: Atom