Revision 9629
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/GBIF/raw_occurrence_record/run | ||
|---|---|---|
| 21 | 21 |
(benign_error=1 mysql <<'EOF' |
| 22 | 22 |
CREATE TABLE `plant_fraction` ( |
| 23 | 23 |
`institution_code` varchar(255) NOT NULL PRIMARY KEY, |
| 24 |
`plant_fraction` float NOT NULL |
|
| 24 |
`plant_fraction` float NOT NULL, |
|
| 25 |
KEY `plant_fraction` (`plant_fraction`) |
|
| 25 | 26 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
| 26 | 27 |
EOF |
| 27 | 28 |
) || table=plant_fraction skip_table || return 0 |
Also available in: Unified diff
inputs/GBIF/raw_occurrence_record/run: plant_fraction: added index on plant_fraction for fast extraction of herbaria by fraction threshold