Project

General

Profile

« Previous | Next » 

Revision 9628

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/GBIF/raw_occurrence_record/run: tables: set ENGINE to MyISAM and DEFAULT CHARSET to utf8 to match the other GBIF tables. (note that MyISAM is not the default, but is needed to avoid row sort order problems and other issues with InnoDB.)

View differences:

inputs/GBIF/raw_occurrence_record/run
22 22 
CREATE TABLE `plant_fraction` (
23 23 
 `institution_code` varchar(255) NOT NULL PRIMARY KEY,
24 24 
 `plant_fraction` float NOT NULL
25 
)
25 
) ENGINE=MyISAM DEFAULT CHARSET=utf8
26 26 
EOF
27 27 
) || table=plant_fraction skip_table || return 0
28 28 
	mysql_ANSI <<EOF
......
59 59 
	mysql <<'EOF'
60 60 
CREATE TABLE IF NOT EXISTS `herbaria_filter` (
61 61 
 `acronym` varchar(255) NOT NULL PRIMARY KEY
62 
) COMMENT='from IH.vegpath.org?&Index+Herbariorum'
62 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='from IH.vegpath.org?&Index+Herbariorum'
63 63 
EOF
64 64 
	mysql_truncate
65 65 
	for part in "${parts[@]}"; do

Also available in: Unified diff