Project

General

Profile

Statistics
| Revision:

root @ 7542

Name Size Revision Age Author Comment
  _archive 1598 almost 13 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 7326 almost 12 years Aaron Marcuse-Kubitza backups/Makefile: %.md5/test: Added comment to ...
  bin 7542 almost 12 years Aaron Marcuse-Kubitza my2pg: Use my2pg.data to perform data-only repl...
  config 7390 almost 12 years Aaron Marcuse-Kubitza config/: Set svn:ignore to exclude *password files
  inputs 7528 almost 12 years Aaron Marcuse-Kubitza inputs/NY/: Added SQL export for refresh
  lib 7533 almost 12 years Aaron Marcuse-Kubitza lib/MySQL.*.sql.make: Documented that $server u...
  mappings 7527 almost 12 years Aaron Marcuse-Kubitza mappings/VegCore.htm: Regenerated from wiki. Br...
  schemas 7466 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added _mm_to_m()
  to_do 7355 almost 12 years Aaron Marcuse-Kubitza to_do/timeline.2013.xls: Updated with changes d...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 11.9 KB 7423 almost 12 years Aaron Marcuse-Kubitza root Makefile: misc-Linux: Added command to cop...
README.TXT 18.4 KB 7530 almost 12 years Aaron Marcuse-Kubitza README.TXT: Datasource setup: Added instruction...
map 1001 Bytes 6949 about 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
7542 02/14/2013 02:23 AM Aaron Marcuse-Kubitza

my2pg: Use my2pg.data to perform data-only replacements, instead of duplicating them in both my2pg and my2pg.data
7541 02/14/2013 02:01 AM Aaron Marcuse-Kubitza

my2pg: named UNIQUE KEYs: Comment out the name because PostgreSQL requires it to be globally unique, but MySQL only requires it to be unique within the table
7540 02/14/2013 01:53 AM Aaron Marcuse-Kubitza

my2pg: Translate UNIQUE KEYs instead of removing them
7539 02/14/2013 01:49 AM Aaron Marcuse-Kubitza

my2pg*: Removed KEYs: Comment out the definition rather than removing it
7538 02/14/2013 01:45 AM Aaron Marcuse-Kubitza

my2pg*: Remove FOREIGN KEYs because MySQL does not dump tables in dependency order, which prevents PostgreSQL from creating tables whose fkeys refer to a later table
7537 02/14/2013 01:33 AM Aaron Marcuse-Kubitza

my2pg*: Replacing invalid table elements to remove them: Use a dummy CHECK constraint instead of a boolean field to avoid adding fields to the table. The elements can't always simply be removed because sed can't remove the trailing comma of the previous element, and removing the following comma doesn't work for the last element in the table.
7536 02/14/2013 12:11 AM Aaron Marcuse-Kubitza

my2pg*: Replace '0000-00-00 00:00:00' with '-infinity'
7535 02/14/2013 12:04 AM Aaron Marcuse-Kubitza

my2pg: Replace datetime with timestamp
7534 02/13/2013 11:59 PM Aaron Marcuse-Kubitza

my2pg: Remove COLLATE field attribute
7533 02/13/2013 11:56 PM Aaron Marcuse-Kubitza

lib/MySQL.*.sql.make: Documented that $server user/host are for ssh, not the DB

View all revisions | View revisions

Also available in: Atom