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 13724 over 10 years Aaron Marcuse-Kubitza added schemas/DwC/hist symlink to history/ to h...
  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 14673 about 10 years Aaron Marcuse-Kubitza schemas/VegBIEN/data_dictionary/VegBIEN data di...
  VegBank 9671 over 11 years Aaron Marcuse-Kubitza *.url: mailto URLs: use the standard e-mail dot...
  VegCore 13847 over 10 years Aaron Marcuse-Kubitza added schemas/VegCore/phpMyAdmin/libraries/plug...
  VegX 12090 almost 11 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 4.22 KB 14817 about 10 years Aaron Marcuse-Kubitza fix: *Makefile: changed line endings to \n so t...
VegCore.ERD.pdf 32 Bytes 12819 over 10 years Aaron Marcuse-Kubitza added schemas/VegCore.ERD.pdf symlink for easy ...
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.7 KB 14796 about 10 years Aaron Marcuse-Kubitza bugfix: schemas/postgresql.conf: need to set ex...
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: ...
public_.sql 716 KB 14870 about 10 years Aaron Marcuse-Kubitza bugfix: schemas/public_.sql: geoscrub_input_new...
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 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 169 KB 14783 about 10 years Aaron Marcuse-Kubitza bugfix: schemas/util.sql: col_rename(): also ne...
vegbien.ERD.1_pg.pdf 765 KB 13561 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.mwb 181 KB 14257 over 10 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: taxon_match: added der...
vegbien.ERD.pdf 606 KB 13561 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.png 615 KB 13561 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.46 MB 13561 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.my.sql 393 KB 14672 about 10 years Aaron Marcuse-Kubitza bugfix: schemas/public_.sql: view_full_occurren...
vegbien.sql 793 KB 14870 about 10 years Aaron Marcuse-Kubitza bugfix: schemas/public_.sql: geoscrub_input_new...
  • svn:ignore: *.bak *.log *.changes.sql

Latest revisions

# Date Author Comment
14870 10/24/2014 03:50 PM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: geoscrub_input_new: need to join on the ARRAY[] of each column, to compare NULLs properly

14861 10/23/2014 03:43 PM Aaron Marcuse-Kubitza

schemas/public_.sql: view_full_occurrence_individual_view: join to taxonoccurrence: can use a USING join for this because plot.** only exports one locationevent_id column

14817 10/14/2014 09:39 AM Aaron Marcuse-Kubitza

fix: *Makefile: changed line endings to \n so that `patch` can work with pasted input. use `svn di --extensions --ignore-eol-style` to verify no diff.

14797 10/03/2014 05:06 PM Aaron Marcuse-Kubitza

schemas/public_.sql: geoscrub_input_view_modify(): add unique constraint on the same columns as geoscrub.geoscrub_output, as a sanity check to assist future debugging

14796 10/03/2014 04:57 PM Aaron Marcuse-Kubitza

bugfix: schemas/postgresql.conf: need to set extra_float_digits = 3 (the maximum) to enable verbatim export. this should fix issue #955.

14783 09/30/2014 03:25 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: col_rename(): also need to run util.name_truncate() on the names used in the "don't try to rename to itself" comparison

14782 09/30/2014 01:54 AM Aaron Marcuse-Kubitza

fix: schemas/util.sql: col_rename(): don't try to rename a column to itself (this will cause an error)

14781 09/30/2014 01:22 AM Aaron Marcuse-Kubitza

schemas/util.sql: set_col_names(): use util.col_rename() so that all renames uses this function

14780 09/30/2014 12:54 AM Aaron Marcuse-Kubitza

schemas/util.sql: added col_rename()

14779 09/30/2014 12:02 AM Aaron Marcuse-Kubitza

schemas/util.sql: added quote_ident() wrapper

View revisions

Also available in: Atom