Project

General

Profile

« Previous | Next » 

Revision 8619

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: changed the type of TEXT columns used in indexes to VARCHAR BINARY to satisfy prefix length limits ("a prefix can be up to [...] 767 bytes for InnoDB tables" <http://dev.mysql.com/doc/refman/5.5/en/create-index.html&gt;). the BINARY flag was added to allow storing Unicode values (from UTF-8), which are not representable in the latin1 encoding.

View differences:

schemas/VegCore/VegCore.my.sql
7 7 
-- Table `party`
8 8 
-- -----------------------------------------------------
9 9 
CREATE  TABLE IF NOT EXISTS `party` (
10 
  `id` TEXT NOT NULL ,
10 
  `id` VARCHAR(767) BINARY NOT NULL ,
11 11 
  `info` SET('hstore') NULL ,
12 12 
  PRIMARY KEY (`id`) ,
13 13 
  CONSTRAINT `fk_collection_source10`
......
24 24 
-- Table `source`
25 25 
-- -----------------------------------------------------
26 26 
CREATE  TABLE IF NOT EXISTS `source` (
27 
  `id` TEXT NOT NULL ,
28 
  `parent` TEXT NOT NULL ,
29 
  `name` TEXT NOT NULL ,
30 
  `first_publisher` TEXT NULL ,
31 
  `contact` TEXT NULL ,
27 
  `id` VARCHAR(767) BINARY NOT NULL ,
28 
  `parent` VARCHAR(767) BINARY NOT NULL ,
29 
  `name` VARCHAR(767) BINARY NOT NULL ,
30 
  `first_publisher` VARCHAR(767) BINARY NULL ,
31 
  `contact` VARCHAR(767) BINARY NULL ,
32 32 
  `info` SET('hstore') NULL ,
33 33 
  PRIMARY KEY (`id`) ,
34 34 
  INDEX `fk_source1_idx` (`parent` ASC) ,
......
59 59 
-- Table `record`
60 60 
-- -----------------------------------------------------
61 61 
CREATE  TABLE IF NOT EXISTS `record` (
62 
  `id` TEXT NOT NULL ,
63 
  `source` TEXT NOT NULL ,
64 
  `source_record_id` TEXT NULL ,
62 
  `id` VARCHAR(767) BINARY NOT NULL ,
63 
  `source` VARCHAR(767) BINARY NOT NULL ,
64 
  `source_record_id` VARCHAR(767) BINARY NULL ,
65 65 
  PRIMARY KEY (`id`) ,
66 66 
  INDEX `fk_record_source1_idx` (`source` ASC) ,
67 67 
  UNIQUE INDEX `record_unique` (`source` ASC, `source_record_id` ASC) ,
......
79 79 
-- Table `relationship`
80 80 
-- -----------------------------------------------------
81 81 
CREATE  TABLE IF NOT EXISTS `relationship` (
82 
  `id` TEXT NOT NULL ,
83 
  `record` TEXT NOT NULL ,
84 
  `related_record` TEXT NOT NULL ,
82 
  `id` VARCHAR(767) BINARY NOT NULL ,
83 
  `record` VARCHAR(767) BINARY NOT NULL ,
84 
  `related_record` VARCHAR(767) BINARY NOT NULL ,
85 85 
  `info` SET('hstore') NULL ,
86 86 
  PRIMARY KEY (`id`) ,
87 87 
  INDEX `fk_relationship_record1_idx` (`record` ASC) ,
......
110 110 
-- Table `taxon_name`
111 111 
-- -----------------------------------------------------
112 112 
CREATE  TABLE IF NOT EXISTS `taxon_name` (
113 
  `id` TEXT NOT NULL ,
114 
  `unique_name` TEXT NOT NULL ,
115 
  `formal_name` TEXT NULL ,
116 
  `taxon_name` TEXT NULL ,
117 
  `author` TEXT NULL ,
118 
  `common_name` TEXT NULL ,
119 
  `rank` TEXT NULL ,
113 
  `id` VARCHAR(767) BINARY NOT NULL ,
114 
  `unique_name` VARCHAR(767) BINARY NOT NULL ,
115 
  `formal_name` VARCHAR(767) BINARY NULL ,
116 
  `taxon_name` VARCHAR(767) BINARY NULL ,
117 
  `author` VARCHAR(767) BINARY NULL ,
118 
  `common_name` VARCHAR(767) BINARY NULL ,
119 
  `rank` VARCHAR(767) BINARY NULL ,
120 120 
  PRIMARY KEY (`id`) ,
121 121 
  INDEX `fk_taxon_concept_taxon_string10_idx` (`unique_name` ASC) ,
122 122 
  CONSTRAINT `fk_taxon_record10`
......
138 138 
-- Table `parsed_taxon_assertion`
139 139 
-- -----------------------------------------------------
140 140 
CREATE  TABLE IF NOT EXISTS `parsed_taxon_assertion` (
141 
  `id` TEXT NOT NULL ,
142 
  `matched_taxon` TEXT NULL ,
141 
  `id` VARCHAR(767) BINARY NOT NULL ,
142 
  `matched_taxon` VARCHAR(767) BINARY NULL ,
143 143 
  `match_score` FLOAT NULL ,
144 144 
  `match_info` SET('hstore') NULL ,
145 145 
  PRIMARY KEY (`id`) ,
......
163 163 
-- Table `taxon_string`
164 164 
-- -----------------------------------------------------
165 165 
CREATE  TABLE IF NOT EXISTS `taxon_string` (
166 
  `string` TEXT NOT NULL ,
167 
  `parsed_taxon_assertion` TEXT NULL ,
166 
  `string` VARCHAR(767) BINARY NOT NULL ,
167 
  `parsed_taxon_assertion` VARCHAR(767) BINARY NULL ,
168 168 
  PRIMARY KEY (`string`) ,
169 169 
  INDEX `fk_taxon_string_parsed_taxon_assertion1_idx` (`parsed_taxon_assertion` ASC) ,
170 170 
  CONSTRAINT `fk_taxon_string_parsed_taxon_assertion1`
......
181 181 
-- Table `taxon_assertion`
182 182 
-- -----------------------------------------------------
183 183 
CREATE  TABLE IF NOT EXISTS `taxon_assertion` (
184 
  `id` TEXT NOT NULL ,
185 
  `string` TEXT NOT NULL ,
186 
  `taxon` TEXT NULL ,
187 
  `cf_aff` TEXT NULL ,
184 
  `id` VARCHAR(767) BINARY NOT NULL ,
185 
  `string` VARCHAR(767) BINARY NOT NULL ,
186 
  `taxon` VARCHAR(767) BINARY NULL ,
187 
  `cf_aff` VARCHAR(767) BINARY NULL ,
188 188 
  `annotations` SET('hstore') NULL ,
189 189 
  PRIMARY KEY (`id`) ,
190 190 
  INDEX `fk_taxon_assertion_taxon_string1_idx` (`string` ASC) ,
......
213 213 
-- Table `coordinates`
214 214 
-- -----------------------------------------------------
215 215 
CREATE  TABLE IF NOT EXISTS `coordinates` (
216 
  `id` TEXT NOT NULL ,
217 
  `latitude_deg` TEXT NULL ,
218 
  `longitude_deg` TEXT NULL ,
216 
  `id` VARCHAR(767) BINARY NOT NULL ,
217 
  `latitude_deg` VARCHAR(767) BINARY NULL ,
218 
  `longitude_deg` VARCHAR(767) BINARY NULL ,
219 219 
  PRIMARY KEY (`id`) )
220 220 
ENGINE = InnoDB
221 221 
DEFAULT CHARACTER SET = latin1
......
226 226 
-- Table `place_path`
227 227 
-- -----------------------------------------------------
228 228 
CREATE  TABLE IF NOT EXISTS `place_path` (
229 
  `id` TEXT NOT NULL ,
230 
  `continent` TEXT NULL ,
231 
  `country` TEXT NULL ,
232 
  `state_province` TEXT NULL ,
233 
  `county` TEXT NULL ,
234 
  `municipality` TEXT NULL ,
229 
  `id` VARCHAR(767) BINARY NOT NULL ,
230 
  `continent` VARCHAR(767) BINARY NULL ,
231 
  `country` VARCHAR(767) BINARY NULL ,
232 
  `state_province` VARCHAR(767) BINARY NULL ,
233 
  `county` VARCHAR(767) BINARY NULL ,
234 
  `municipality` VARCHAR(767) BINARY NULL ,
235 235 
  `ranks` SET('hstore') NULL ,
236 236 
  PRIMARY KEY (`id`) )
237 237 
ENGINE = InnoDB
......
243 243 
-- Table `place`
244 244 
-- -----------------------------------------------------
245 245 
CREATE  TABLE IF NOT EXISTS `place` (
246 
  `id` TEXT NOT NULL ,
247 
  `parent` TEXT NOT NULL ,
248 
  `coordinates` TEXT NULL ,
249 
  `path` TEXT NULL ,
250 
  `locality` TEXT NULL ,
246 
  `id` VARCHAR(767) BINARY NOT NULL ,
247 
  `parent` VARCHAR(767) BINARY NOT NULL ,
248 
  `coordinates` VARCHAR(767) BINARY NULL ,
249 
  `path` VARCHAR(767) BINARY NULL ,
250 
  `locality` VARCHAR(767) BINARY NULL ,
251 251 
  PRIMARY KEY (`id`) ,
252 252 
  INDEX `fk_place_coordinates1_idx` (`coordinates` ASC) ,
253 253 
  INDEX `fk_place1_idx` (`parent` ASC) ,
......
281 281 
-- Table `method`
282 282 
-- -----------------------------------------------------
283 283 
CREATE  TABLE IF NOT EXISTS `method` (
284 
  `id` TEXT NOT NULL ,
284 
  `id` VARCHAR(767) BINARY NOT NULL ,
285 285 
  `info` SET('hstore') NULL ,
286 286 
  PRIMARY KEY (`id`) ,
287 287 
  CONSTRAINT `fk_method_record1`
......
298 298 
-- Table `event`
299 299 
-- -----------------------------------------------------
300 300 
CREATE  TABLE IF NOT EXISTS `event` (
301 
  `id` TEXT NOT NULL ,
302 
  `parent` TEXT NOT NULL ,
303 
  `name` TEXT NULL ,
304 
  `date_range` TEXT NULL ,
305 
  `place` TEXT NULL ,
306 
  `method` TEXT NULL ,
301 
  `id` VARCHAR(767) BINARY NOT NULL ,
302 
  `parent` VARCHAR(767) BINARY NOT NULL ,
303 
  `name` VARCHAR(767) BINARY NULL ,
304 
  `date_range` VARCHAR(767) BINARY NULL ,
305 
  `place` VARCHAR(767) BINARY NULL ,
306 
  `method` VARCHAR(767) BINARY NULL ,
307 307 
  PRIMARY KEY (`id`) ,
308 308 
  INDEX `fk_event_place1_idx` (`place` ASC) ,
309 309 
  INDEX `fk_event1_idx` (`parent` ASC) ,
......
337 337 
-- Table `taxon_observation`
338 338 
-- -----------------------------------------------------
339 339 
CREATE  TABLE IF NOT EXISTS `taxon_observation` (
340 
  `id` TEXT NOT NULL ,
341 
  `taxon_occurrence` TEXT NOT NULL ,
342 
  `voucher` TEXT NULL ,
343 
  `growth_form` TEXT NULL ,
340 
  `id` VARCHAR(767) BINARY NOT NULL ,
341 
  `taxon_occurrence` VARCHAR(767) BINARY NOT NULL ,
342 
  `voucher` VARCHAR(767) BINARY NULL ,
343 
  `growth_form` VARCHAR(767) BINARY NULL ,
344 344 
  `cultivated` TINYINT(1) NULL ,
345 345 
  `traits` SET('hstore') NULL ,
346 346 
  PRIMARY KEY (`id`) ,
......
370 370 
-- Table `taxon_determination`
371 371 
-- -----------------------------------------------------
372 372 
CREATE  TABLE IF NOT EXISTS `taxon_determination` (
373 
  `id` TEXT NOT NULL ,
374 
  `taxon_assertion` TEXT NOT NULL ,
375 
  `identified_by` TEXT NULL ,
373 
  `id` VARCHAR(767) BINARY NOT NULL ,
374 
  `taxon_assertion` VARCHAR(767) BINARY NOT NULL ,
375 
  `identified_by` VARCHAR(767) BINARY NULL ,
376 376 
  `fit_info` SET('hstore') NULL ,
377 377 
  INDEX `fk_taxon_occurrence_has_qualified_taxon1_idx` (`taxon_assertion` ASC) ,
378 378 
  PRIMARY KEY (`id`) ,
......
402 402 
-- Table `taxon_occurrence`
403 403 
-- -----------------------------------------------------
404 404 
CREATE  TABLE IF NOT EXISTS `taxon_occurrence` (
405 
  `id` TEXT NOT NULL ,
406 
  `collector` TEXT NULL ,
407 
  `collection_event` TEXT NULL ,
408 
  `collector_number` TEXT NULL ,
409 
  `current_determination` TEXT NULL ,
410 
  `original_determination` TEXT NULL ,
405 
  `id` VARCHAR(767) BINARY NOT NULL ,
406 
  `collector` VARCHAR(767) BINARY NULL ,
407 
  `collection_event` VARCHAR(767) BINARY NULL ,
408 
  `collector_number` VARCHAR(767) BINARY NULL ,
409 
  `current_determination` VARCHAR(767) BINARY NULL ,
410 
  `original_determination` VARCHAR(767) BINARY NULL ,
411 411 
  PRIMARY KEY (`id`) ,
412 412 
  INDEX `fk_taxon_occurrence_taxon_determination1_idx` (`original_determination` ASC) ,
413 413 
  INDEX `fk_taxon_occurrence_taxon_determination2_idx` (`current_determination` ASC) ,
......
447 447 
-- Table `collection`
448 448 
-- -----------------------------------------------------
449 449 
CREATE  TABLE IF NOT EXISTS `collection` (
450 
  `id` TEXT NOT NULL ,
450 
  `id` VARCHAR(767) BINARY NOT NULL ,
451 451 
  PRIMARY KEY (`id`) ,
452 452 
  CONSTRAINT `fk_collection_source1`
453 453 
    FOREIGN KEY (`id` )
......
463 463 
-- Table `organization`
464 464 
-- -----------------------------------------------------
465 465 
CREATE  TABLE IF NOT EXISTS `organization` (
466 
  `id` TEXT NOT NULL ,
466 
  `id` VARCHAR(767) BINARY NOT NULL ,
467 467 
  `info` SET('hstore') NULL ,
468 468 
  PRIMARY KEY (`id`) ,
469 469 
  CONSTRAINT `fk_organization_party1`
......
480 480 
-- Table `specimen`
481 481 
-- -----------------------------------------------------
482 482 
CREATE  TABLE IF NOT EXISTS `specimen` (
483 
  `id` TEXT NOT NULL ,
484 
  `collection` TEXT NULL ,
485 
  `stamping_institution` TEXT NULL ,
486 
  `donor_institution` TEXT NULL ,
487 
  `owner` TEXT NULL ,
488 
  `barcode` TEXT NULL ,
489 
  `accession_number` TEXT NULL ,
483 
  `id` VARCHAR(767) BINARY NOT NULL ,
484 
  `collection` VARCHAR(767) BINARY NULL ,
485 
  `stamping_institution` VARCHAR(767) BINARY NULL ,
486 
  `donor_institution` VARCHAR(767) BINARY NULL ,
487 
  `owner` VARCHAR(767) BINARY NULL ,
488 
  `barcode` VARCHAR(767) BINARY NULL ,
489 
  `accession_number` VARCHAR(767) BINARY NULL ,
490 490 
  PRIMARY KEY (`id`) ,
491 491 
  INDEX `fk_specimen_collection1_idx` (`collection` ASC) ,
492 492 
  INDEX `fk_specimen_organization1_idx` (`stamping_institution` ASC) ,
......
526 526 
-- Table `individual`
527 527 
-- -----------------------------------------------------
528 528 
CREATE  TABLE IF NOT EXISTS `individual` (
529 
  `id` TEXT NOT NULL ,
530 
  `tag` TEXT NULL ,
531 
  `code` TEXT NULL ,
529 
  `id` VARCHAR(767) BINARY NOT NULL ,
530 
  `tag` VARCHAR(767) BINARY NULL ,
531 
  `code` VARCHAR(767) BINARY NULL ,
532 532 
  PRIMARY KEY (`id`) ,
533 533 
  CONSTRAINT `fk_individual_record1`
534 534 
    FOREIGN KEY (`id` )
......
544 544 
-- Table `individual_observation`
545 545 
-- -----------------------------------------------------
546 546 
CREATE  TABLE IF NOT EXISTS `individual_observation` (
547 
  `id` TEXT NOT NULL ,
548 
  `individual` TEXT NOT NULL ,
547 
  `id` VARCHAR(767) BINARY NOT NULL ,
548 
  `individual` VARCHAR(767) BINARY NOT NULL ,
549 549 
  `traits` SET('hstore') NULL ,
550 550 
  PRIMARY KEY (`id`) ,
551 551 
  INDEX `fk_individual_observation_individual1_idx` (`individual` ASC) ,
......
568 568 
-- Table `stem`
569 569 
-- -----------------------------------------------------
570 570 
CREATE  TABLE IF NOT EXISTS `stem` (
571 
  `id` TEXT NOT NULL ,
572 
  `individual` TEXT NOT NULL ,
571 
  `id` VARCHAR(767) BINARY NOT NULL ,
572 
  `individual` VARCHAR(767) BINARY NOT NULL ,
573 573 
  PRIMARY KEY (`id`) ,
574 574 
  INDEX `fk_stem_individual1_idx` (`individual` ASC) ,
575 575 
  CONSTRAINT `fk_stem_individual1`
......
591 591 
-- Table `stem_observation`
592 592 
-- -----------------------------------------------------
593 593 
CREATE  TABLE IF NOT EXISTS `stem_observation` (
594 
  `id` TEXT NOT NULL ,
595 
  `individual_observation` TEXT NOT NULL ,
596 
  `stem` TEXT NOT NULL ,
594 
  `id` VARCHAR(767) BINARY NOT NULL ,
595 
  `individual_observation` VARCHAR(767) BINARY NOT NULL ,
596 
  `stem` VARCHAR(767) BINARY NOT NULL ,
597 597 
  `traits` SET('hstore') NULL ,
598 598 
  PRIMARY KEY (`id`) ,
599 599 
  INDEX `fk_stem_observation_individual_observation1_idx` (`individual_observation` ASC) ,
......
623 623 
-- Table `aggregate_observation`
624 624 
-- -----------------------------------------------------
625 625 
CREATE  TABLE IF NOT EXISTS `aggregate_observation` (
626 
  `id` TEXT NOT NULL ,
627 
  `taxon` TEXT NOT NULL ,
626 
  `id` VARCHAR(767) BINARY NOT NULL ,
627 
  `taxon` VARCHAR(767) BINARY NOT NULL ,
628 628 
  PRIMARY KEY (`id`) ,
629 629 
  INDEX `fk_aggregate_observation_taxon_name1_idx` (`taxon` ASC) ,
630 630 
  CONSTRAINT `fk_aggregate_observation_taxon_occurrence1`
......
646 646 
-- Table `taxon_presence`
647 647 
-- -----------------------------------------------------
648 648 
CREATE  TABLE IF NOT EXISTS `taxon_presence` (
649 
  `id` TEXT NOT NULL ,
650 
  `taxon` TEXT NOT NULL ,
649 
  `id` VARCHAR(767) BINARY NOT NULL ,
650 
  `taxon` VARCHAR(767) BINARY NOT NULL ,
651 651 
  PRIMARY KEY (`id`) ,
652 652 
  INDEX `fk_taxon_presence_taxon_name1_idx` (`taxon` ASC) ,
653 653 
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1`
......
669 669 
-- Table `taxon_concept`
670 670 
-- -----------------------------------------------------
671 671 
CREATE  TABLE IF NOT EXISTS `taxon_concept` (
672 
  `id` TEXT NOT NULL ,
673 
  `according_to` TEXT NOT NULL ,
674 
  `parent` TEXT NOT NULL ,
675 
  `accepted_taxon` TEXT NULL ,
672 
  `id` VARCHAR(767) BINARY NOT NULL ,
673 
  `according_to` VARCHAR(767) BINARY NOT NULL ,
674 
  `parent` VARCHAR(767) BINARY NOT NULL ,
675 
  `accepted_taxon` VARCHAR(767) BINARY NULL ,
676 676 
  PRIMARY KEY (`id`) ,
677 677 
  INDEX `fk_taxon_taxon1_idx` (`parent` ASC) ,
678 678 
  INDEX `fk_taxon_concept_source1_idx` (`according_to` ASC) ,
......
707 707 
-- Table `community`
708 708 
-- -----------------------------------------------------
709 709 
CREATE  TABLE IF NOT EXISTS `community` (
710 
  `id` TEXT NOT NULL ,
711 
  `name` TEXT NOT NULL ,
710 
  `id` VARCHAR(767) BINARY NOT NULL ,
711 
  `name` VARCHAR(767) BINARY NOT NULL ,
712 712 
  `info` SET('hstore') NULL ,
713 713 
  PRIMARY KEY (`id`) ,
714 714 
  CONSTRAINT `fk_community_record1`
......
725 725 
-- Table `geological_context`
726 726 
-- -----------------------------------------------------
727 727 
CREATE  TABLE IF NOT EXISTS `geological_context` (
728 
  `id` TEXT NOT NULL ,
729 
  `name` TEXT NOT NULL ,
728 
  `id` VARCHAR(767) BINARY NOT NULL ,
729 
  `name` VARCHAR(767) BINARY NOT NULL ,
730 730 
  `info` SET('hstore') NULL ,
731 731 
  PRIMARY KEY (`id`) ,
732 732 
  CONSTRAINT `fk_geological_context_record1`
......
743 743 
-- Table `place_observation`
744 744 
-- -----------------------------------------------------
745 745 
CREATE  TABLE IF NOT EXISTS `place_observation` (
746 
  `id` TEXT NOT NULL ,
747 
  `place` TEXT NOT NULL ,
746 
  `id` VARCHAR(767) BINARY NOT NULL ,
747 
  `place` VARCHAR(767) BINARY NOT NULL ,
748 748 
  `elevation_m` DOUBLE NULL ,
749 749 
  `slope_incline_deg` DOUBLE NULL ,
750 750 
  `slope_direction_deg_N` DOUBLE NULL ,
751 
  `geological_context` TEXT NULL ,
752 
  `community` TEXT NULL ,
751 
  `geological_context` VARCHAR(767) BINARY NULL ,
752 
  `community` VARCHAR(767) BINARY NULL ,
753 753 
  `observations` SET('hstore') NULL ,
754 754 
  INDEX `fk_place_observation_place1_idx` (`place` ASC) ,
755 755 
  INDEX `fk_place_observation_geological_context1_idx` (`geological_context` ASC) ,
......
785 785 
-- Table `soil_observation`
786 786 
-- -----------------------------------------------------
787 787 
CREATE  TABLE IF NOT EXISTS `soil_observation` (
788 
  `id` TEXT NOT NULL ,
788 
  `id` VARCHAR(767) BINARY NOT NULL ,
789 789 
  `observations` SET('hstore') NULL ,
790 790 
  PRIMARY KEY (`id`) ,
791 791 
  CONSTRAINT `fk_soil_observation_place_observation1`
......
802 802 
-- Table `plot`
803 803 
-- -----------------------------------------------------
804 804 
CREATE  TABLE IF NOT EXISTS `plot` (
805 
  `id` TEXT NOT NULL ,
806 
  `name` TEXT NULL ,
805 
  `id` VARCHAR(767) BINARY NOT NULL ,
806 
  `name` VARCHAR(767) BINARY NULL ,
807 807 
  `area_m2` DOUBLE NULL ,
808 
  `bounding_box` TEXT NULL ,
808 
  `bounding_box` VARCHAR(767) BINARY NULL ,
809 809 
  PRIMARY KEY (`id`) ,
810 810 
  CONSTRAINT `fk_subplot_place1`
811 811 
    FOREIGN KEY (`id` )
......
821 821 
-- Table `subplot`
822 822 
-- -----------------------------------------------------
823 823 
CREATE  TABLE IF NOT EXISTS `subplot` (
824 
  `id` TEXT NOT NULL ,
824 
  `id` VARCHAR(767) BINARY NOT NULL ,
825 825 
  `x_m` DOUBLE NULL ,
826 826 
  `y_m` DOUBLE NULL ,
827 827 
  PRIMARY KEY (`id`) ,
......
839 839 
-- Table `validatable_place`
840 840 
-- -----------------------------------------------------
841 841 
CREATE  TABLE IF NOT EXISTS `validatable_place` (
842 
  `id` TEXT NOT NULL ,
843 
  `coordinates` TEXT NOT NULL ,
844 
  `path` TEXT NOT NULL ,
842 
  `id` VARCHAR(767) BINARY NOT NULL ,
843 
  `coordinates` VARCHAR(767) BINARY NOT NULL ,
844 
  `path` VARCHAR(767) BINARY NOT NULL ,
845 845 
  PRIMARY KEY (`id`) ,
846 846 
  INDEX `fk_geovalidation_place_path1_idx` (`path` ASC) ,
847 847 
  INDEX `fk_geovalidation_coordinates1_idx` (`coordinates` ASC) ,
......
865 865 
-- Table `project`
866 866 
-- -----------------------------------------------------
867 867 
CREATE  TABLE IF NOT EXISTS `project` (
868 
  `id` TEXT NOT NULL ,
869 
  `name` TEXT NOT NULL ,
868 
  `id` VARCHAR(767) BINARY NOT NULL ,
869 
  `name` VARCHAR(767) BINARY NOT NULL ,
870 870 
  `info` SET('hstore') NULL ,
871 871 
  PRIMARY KEY (`id`) ,
872 872 
  CONSTRAINT `fk_project_event1`
......
883 883 
-- Table `referenced_class`
884 884 
-- -----------------------------------------------------
885 885 
CREATE  TABLE IF NOT EXISTS `referenced_class` (
886 
  `id` TEXT NOT NULL ,
886 
  `id` VARCHAR(767) BINARY NOT NULL ,
887 887 
  PRIMARY KEY (`id`) ,
888 888 
  CONSTRAINT `fk_example_record10`
889 889 
    FOREIGN KEY (`id` )
......
899 899 
-- Table `base_class`
900 900 
-- -----------------------------------------------------
901 901 
CREATE  TABLE IF NOT EXISTS `base_class` (
902 
  `id` TEXT NOT NULL ,
903 
  `referenced_class` TEXT NOT NULL ,
902 
  `id` VARCHAR(767) BINARY NOT NULL ,
903 
  `referenced_class` VARCHAR(767) BINARY NOT NULL ,
904 904 
  PRIMARY KEY (`id`) ,
905 905 
  INDEX `fk_base_class_referenced_class1_idx` (`referenced_class` ASC) ,
906 906 
  CONSTRAINT `fk_example_record1`
......
922 922 
-- Table `derived_class`
923 923 
-- -----------------------------------------------------
924 924 
CREATE  TABLE IF NOT EXISTS `derived_class` (
925 
  `id` TEXT NOT NULL ,
925 
  `id` VARCHAR(767) BINARY NOT NULL ,
926 926 
  PRIMARY KEY (`id`) ,
927 927 
  CONSTRAINT `fk_derived_class_base_class1`
928 928 
    FOREIGN KEY (`id` )
......
938 938 
-- Table `stratum`
939 939 
-- -----------------------------------------------------
940 940 
CREATE  TABLE IF NOT EXISTS `stratum` (
941 
  `id` TEXT NOT NULL ,
942 
  `name` TEXT NOT NULL ,
941 
  `id` VARCHAR(767) BINARY NOT NULL ,
942 
  `name` VARCHAR(767) BINARY NOT NULL ,
943 943 
  `info` SET('hstore') NULL ,
944 944 
  PRIMARY KEY (`id`) ,
945 945 
  CONSTRAINT `fk_place_path_record10`
......
956 956 
-- Table `plot_stratum`
957 957 
-- -----------------------------------------------------
958 958 
CREATE  TABLE IF NOT EXISTS `plot_stratum` (
959 
  `id` TEXT NOT NULL ,
960 
  `stratum` TEXT NOT NULL ,
959 
  `id` VARCHAR(767) BINARY NOT NULL ,
960 
  `stratum` VARCHAR(767) BINARY NOT NULL ,
961 961 
  PRIMARY KEY (`id`) ,
962 962 
  INDEX `fk_plot_stratum_stratum1_idx` (`stratum` ASC) ,
963 963 
  CONSTRAINT `fk_subplot_place10`
......
979 979 
-- Table `1. verbatim`
980 980 
-- -----------------------------------------------------
981 981 
CREATE  TABLE IF NOT EXISTS `1. verbatim` (
982 
  `id` TEXT NOT NULL ,
982 
  `id` VARCHAR(767) BINARY NOT NULL ,
983 983 
  PRIMARY KEY (`id`) )
984 984 
ENGINE = InnoDB
985 985 
DEFAULT CHARACTER SET = latin1
......
990 990 
-- Table `2. concatenated`
991 991 
-- -----------------------------------------------------
992 992 
CREATE  TABLE IF NOT EXISTS `2. concatenated` (
993 
  `id` TEXT NOT NULL ,
993 
  `id` VARCHAR(767) BINARY NOT NULL ,
994 994 
  PRIMARY KEY (`id`) )
995 995 
ENGINE = InnoDB
996 996 
DEFAULT CHARACTER SET = latin1
......
1001 1001 
-- Table `3. parsed`
1002 1002 
-- -----------------------------------------------------
1003 1003 
CREATE  TABLE IF NOT EXISTS `3. parsed` (
1004 
  `id` TEXT NOT NULL ,
1004 
  `id` VARCHAR(767) BINARY NOT NULL ,
1005 1005 
  PRIMARY KEY (`id`) )
1006 1006 
ENGINE = InnoDB
1007 1007 
DEFAULT CHARACTER SET = latin1
......
1012 1012 
-- Table `4. matched`
1013 1013 
-- -----------------------------------------------------
1014 1014 
CREATE  TABLE IF NOT EXISTS `4. matched` (
1015 
  `id` TEXT NOT NULL ,
1015 
  `id` VARCHAR(767) BINARY NOT NULL ,
1016 1016 
  PRIMARY KEY (`id`) )
1017 1017 
ENGINE = InnoDB
1018 1018 
DEFAULT CHARACTER SET = latin1
......
1023 1023 
-- Table `5. accepted`
1024 1024 
-- -----------------------------------------------------
1025 1025 
CREATE  TABLE IF NOT EXISTS `5. accepted` (
1026 
  `id` TEXT NOT NULL ,
1026 
  `id` VARCHAR(767) BINARY NOT NULL ,
1027 1027 
  PRIMARY KEY (`id`) )
1028 1028 
ENGINE = InnoDB
1029 1029 
DEFAULT CHARACTER SET = latin1
......
1034 1034 
-- Table `TNRS taxonomic scrubbing steps`
1035 1035 
-- -----------------------------------------------------
1036 1036 
CREATE  TABLE IF NOT EXISTS `TNRS taxonomic scrubbing steps` (
1037 
  `id` TEXT NOT NULL ,
1037 
  `id` VARCHAR(767) BINARY NOT NULL ,
1038 1038 
  PRIMARY KEY (`id`) )
1039 1039 
ENGINE = InnoDB
1040 1040 
DEFAULT CHARACTER SET = latin1
......
1045 1045 
-- Table `geovalidation`
1046 1046 
-- -----------------------------------------------------
1047 1047 
CREATE  TABLE IF NOT EXISTS `geovalidation` (
1048 
  `id` TEXT NOT NULL ,
1048 
  `id` VARCHAR(767) BINARY NOT NULL ,
1049 1049 
  `geovalid` TINYINT(1) NOT NULL ,
1050 1050 
  `lat_long_domain_valid` TINYINT(1) NOT NULL ,
1051 1051 
  `lat_long_in_ranks` SET('hstore') NULL ,
......
1064 1064 
-- Table `taxon_path`
1065 1065 
-- -----------------------------------------------------
1066 1066 
CREATE  TABLE IF NOT EXISTS `taxon_path` (
1067 
  `id` TEXT NOT NULL ,
1068 
  `family` TEXT NULL ,
1069 
  `genus` TEXT NULL ,
1070 
  `specific_epithet` TEXT NULL ,
1067 
  `id` VARCHAR(767) BINARY NOT NULL ,
1068 
  `family` VARCHAR(767) BINARY NULL ,
1069 
  `genus` VARCHAR(767) BINARY NULL ,
1070 
  `specific_epithet` VARCHAR(767) BINARY NULL ,
1071 1071 
  `ranks` SET('hstore') NULL ,
1072 1072 
  PRIMARY KEY (`id`) ,
1073 1073 
  CONSTRAINT `fk_taxon_path_taxon_name1`
......
1084 1084 
-- Table `specimen_observation`
1085 1085 
-- -----------------------------------------------------
1086 1086 
CREATE  TABLE IF NOT EXISTS `specimen_observation` (
1087 
  `id` TEXT NOT NULL ,
1088 
  `specimen` TEXT NOT NULL ,
1087 
  `id` VARCHAR(767) BINARY NOT NULL ,
1088 
  `specimen` VARCHAR(767) BINARY NOT NULL ,
1089 1089 
  PRIMARY KEY (`id`) ,
1090 1090 
  INDEX `fk_specimen_observation_specimen1_idx` (`specimen` ASC) ,
1091 1091 
  CONSTRAINT `fk_specimen_taxon_occurrence10`
......
1107 1107 
-- Table `event_participant`
1108 1108 
-- -----------------------------------------------------
1109 1109 
CREATE  TABLE IF NOT EXISTS `event_participant` (
1110 
  `event` TEXT NOT NULL ,
1111 
  `party` TEXT NOT NULL ,
1110 
  `event` VARCHAR(767) BINARY NOT NULL ,
1111 
  `party` VARCHAR(767) BINARY NOT NULL ,
1112 1112 
  `sort_order` INT NULL ,
1113 1113 
  PRIMARY KEY (`event`, `party`) ,
1114 1114 
  INDEX `fk_event_has_party_party1_idx` (`party` ASC) ,
......
1132 1132 
-- Table `specimen_holder_institution`
1133 1133 
-- -----------------------------------------------------
1134 1134 
CREATE  TABLE IF NOT EXISTS `specimen_holder_institution` (
1135 
  `specimen` TEXT NOT NULL ,
1136 
  `institution` TEXT NOT NULL ,
1135 
  `specimen` VARCHAR(767) BINARY NOT NULL ,
1136 
  `institution` VARCHAR(767) BINARY NOT NULL ,
1137 1137 
  `sort_order` INT NULL ,
1138 1138 
  PRIMARY KEY (`specimen`, `institution`) ,
1139 1139 
  INDEX `fk_specimen_has_organization_organization1_idx` (`institution` ASC) ,

Also available in: Unified diff