Project

General

Profile

Statistics
| Revision:

root/trunk/schemas @ 14360

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 almost 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 almost 11 years Aaron Marcuse-Kubitza schemas/VegX/.htaccess, TCS/.htaccess: prepend ...
  VegBIEN 13756 almost 10 years Aaron Marcuse-Kubitza schemas/VegBIEN/: moved Redmine/, TWiki/ to web...
  VegBank 9671 almost 11 years Aaron Marcuse-Kubitza *.url: mailto URLs: use the standard e-mail dot...
  VegCore 13847 almost 10 years Aaron Marcuse-Kubitza added schemas/VegCore/phpMyAdmin/libraries/plug...
  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 4.35 KB 13865 almost 10 years Aaron Marcuse-Kubitza fix: schemas/Makefile: vegbien.sql: also need t...
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 692 KB 14351 almost 10 years Aaron Marcuse-Kubitza schemas/public_.sql: *_view_modify(): added rep...
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 162 KB 14355 almost 10 years Aaron Marcuse-Kubitza schemas/util.sql: remove_prefix(), remove_suffi...
vegbien.ERD.1_pg.pdf 765 KB 13561 about 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.mwb 181 KB 14257 almost 10 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: taxon_match: added der...
vegbien.ERD.pdf 606 KB 13561 about 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.ERD.png 615 KB 13561 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.46 MB 13561 about 10 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: regenerated exports
vegbien.my.sql 398 KB 14356 almost 10 years Aaron Marcuse-Kubitza schemas/util.sql: remove_prefix(), remove_suffi...
vegbien.sql 775 KB 14360 almost 10 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: taxon_match: to remove...
  • svn:ignore: *.bak *.log *.changes.sql

Latest revisions

# Date Author Comment
14360 07/26/2014 08:19 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: to remove columns or add columns at the end: don't need to run `rm=1 inputs/.TNRS/data.sql.run` because this is now run by `make schemas/remake`
14359 07/26/2014 08:13 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added new derived columns to derived views
14358 07/26/2014 07:52 PM Aaron Marcuse-Kubitza

schemas/util.sql: remove_prefix(), remove_suffix(): support case-insensitive matching
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()

View revisions

Also available in: Atom