Revision 8260
Added by Aaron Marcuse-Kubitza over 11 years ago
| MySQL.schema.sql | ||
|---|---|---|
| 508 | 508 |
"species_count" integer DEFAULT '0', |
| 509 | 509 |
"occurrence_count" integer DEFAULT '0', |
| 510 | 510 |
"occurrence_coordinate_count" integer DEFAULT '0', |
| 511 |
"continent_code" enum('AF','AS','EU','NA','OC','SA','AN') DEFAULT NULL,
|
|
| 511 |
"continent_code" text CHECK ("continent_code" in ('AF','AS','EU','NA','OC','SA','AN')) DEFAULT NULL,
|
|
| 512 | 512 |
"region" char(3) DEFAULT NULL, |
| 513 | 513 |
"min_latitude" float DEFAULT NULL, |
| 514 | 514 |
"max_latitude" float DEFAULT NULL, |
Also available in: Unified diff
inputs/GBIF/MySQL.schema.sql: Regenerated with inline enum type translated to CHECK constraint