Project

General

Profile

Statistics
| Revision:

root/trunk/schemas @ 14357

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 13756 over 10 years Aaron Marcuse-Kubitza schemas/VegBIEN/: moved Redmine/, TWiki/ to web...
  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.35 KB 13865 over 10 years Aaron Marcuse-Kubitza fix: schemas/Makefile: vegbien.sql: also need 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.6 KB 13274 over 10 years Aaron Marcuse-Kubitza schemas/postgresql.conf: wal_level: set to hot_...
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 692 KB 14351 over 10 years Aaron Marcuse-Kubitza schemas/public_.sql: *_view_modify(): added rep...
py_util.sql 6.42 KB 12235 almost 11 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 162 KB 14355 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: remove_prefix(), remove_suffi...
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 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.46 MB 13561 over 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.my.sql 398 KB 14356 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: remove_prefix(), remove_suffi...
vegbien.sql 773 KB 14357 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/.TNRS/schema.sql: taxon_match.__...
  • svn:ignore: *.bak *.log *.changes.sql

Latest revisions

# Date Author Comment
14357 07/26/2014 07:43 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match.__accepted_infraspecific_label: need to use case-insensitive matching of the removed prefix because TNRS lowercases part of the Accepted_name
14356 07/26/2014 07:40 PM Aaron Marcuse-Kubitza

schemas/util.sql: remove_prefix(), remove_suffix(): support case-insensitive matching
14355 07/26/2014 06:54 PM Aaron Marcuse-Kubitza

schemas/util.sql: remove_prefix(), remove_suffix(): support case-insensitive matching
14354 07/26/2014 06:52 PM Aaron Marcuse-Kubitza

schemas/util.sql: added case-sensitive-optional versions of starts_with(), ends_with()
14353 07/26/2014 06:50 PM Aaron Marcuse-Kubitza

schemas/util.sql: added canon_case(str text, case_sensitive boolean)
14352 07/26/2014 06:36 PM Aaron Marcuse-Kubitza

schemas/util.sql: check_constraint_disable(): documented that we can't use ADD CONSTRAINT NOT VALID for this because it does not disable the constraint completely, but instead causes new rows to be validated against it. the ADD CONSTRAINT NOT VALID behavior does not work for the derived columns use case of this function.
14351 07/26/2014 06:17 PM Aaron Marcuse-Kubitza

schemas/public_.sql: *_view_modify(): added repopulate param, which is passed to rematerialize_view()
14350 07/26/2014 06:14 PM Aaron Marcuse-Kubitza

schemas/util.sql: rematerialize_view(): support updating just the table's schema, without populating it
14349 07/26/2014 05:37 PM Aaron Marcuse-Kubitza

schemas/util.sql: rematerialize_view(): don't need extra eval() around table_mod_sql because recreate() performs eval()
14347 07/26/2014 05:16 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match: use wrapper for util.remove_prefix() so CHECK constraints that use it don't get dropped when the util schema is reinstalled

View revisions

Also available in: Atom