Project

General

Profile

Statistics
| Revision:

root @ 8618

Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 7564 almost 12 years Aaron Marcuse-Kubitza lib/common.Makefile: remote server: Use jupiter...
  bin 8320 over 11 years Aaron Marcuse-Kubitza bin/make_analytical_db: Commented out export_an...
  config 7801 almost 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  inputs 8607 over 11 years Aaron Marcuse-Kubitza inputs/VegBIEN/TWiki/templates/login.tmpl: incr...
  lib 8465 over 11 years Aaron Marcuse-Kubitza lib/util.run: run_cmd (): renamed to run_args_c...
  mappings 8235 over 11 years Aaron Marcuse-Kubitza mappings/VegCore.htm: Renamed salvias_plots tab...
  planning 8457 over 11 years Aaron Marcuse-Kubitza Moved validation/ under planning/workflow/
  schemas 8618 over 11 years Aaron Marcuse-Kubitza schemas/VegCore/VegCore.ERD.mwb: changed encodi...
  web 8602 over 11 years Aaron Marcuse-Kubitza added web/.twiki symlink to datasources/VegBIEN...
Makefile 12.1 KB 8081 over 11 years Aaron Marcuse-Kubitza root Makefile: Installation: Fixed bug where ne...
README.TXT 19.5 KB 8608 over 11 years Aaron Marcuse-Kubitza README.TXT: Maintenance: to synchronize vegbien...
fix_perms 97 Bytes 7560 almost 12 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 almost 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 almost 12 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
unmapped_terms.csv 13.1 KB 7201 almost 12 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
8618 04/23/2013 01:15 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: changed encoding to latin1 to fit more characters in length-limited indexes (indexes treat utf8 as having 3 bytes/character (http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes#comment-18031137), which significantly reduces the max length of an indexed column)
8617 04/23/2013 01:08 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: changed collation to utf8_bin to avoid case-*in*sensitive comparison of case-sensitive strings. (utf8_bin is also much faster than encoding-aware collations because it uses the raw bytes.)
8616 04/23/2013 12:47 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: set DefaultPkColumnType to TEXT to match the type of current pkey columns
8615 04/23/2013 12:16 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: set all tables to use utf8/utf8_unicode_ci rather than latin1/latin1_swedish_ci because our DB is in UTF-8. utf8_unicode_ci is better than utf8_general_ci because it supports international characters better (http://forums.mysql.com/read.php?103,187048,188748)
8614 04/23/2013 12:10 PM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: TNRS taxonomic scrubbing steps labels: removed fkey columns to the next step since these are not needed and were causing problems with round-trip sync to the .my.sql file
8613 04/23/2013 11:42 AM Aaron Marcuse-Kubitza

bugfix: schemas/VegCore/VegCore.ERD.mwb: fixed foreign keys without a referenced columns list
8612 04/23/2013 11:36 AM Aaron Marcuse-Kubitza

schemas/VegCore/VegCore.ERD.mwb: upgraded for MySQL Workbench 5.2.47 (MySQL 5.5), which requires indexes to have different names than fkeys
8611 04/23/2013 10:25 AM Aaron Marcuse-Kubitza

schemas/postgresql.conf: shared_buffers: reduced again for Ubuntu VM
8610 04/23/2013 10:22 AM Aaron Marcuse-Kubitza

bugfix: schemas/postgresql.conf: shared_buffers: removed invalid Unicode character U+FEFF
8609 04/23/2013 02:40 AM Aaron Marcuse-Kubitza

schemas/postgresql.conf: shared_buffers: reduced to work in Ubuntu VM

View all revisions | View revisions

Also available in: Atom