Project

General

Profile

« Previous | Next » 

Revision 10807

schemas/VegCore/VegCore.ERD.mwb: specimen: added individual_observation, which stores observations about the plant the specimen was collected from. (some specimens may not be traceable to a reobservable individual, but will still have these plant observations.) specimen_observation: adjusted position to fully display the HAS-A connector to specimen.

View differences:

schemas/VegCore/VegCore.pg.sql
36 36
  "occurrence_status" text DEFAULT NULL,
37 37
  "traits" hstore DEFAULT NULL,
38 38
  PRIMARY KEY ("id"),
39
  /*CONSTRAINT "fk_taxon_presence_taxon_determination10" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
40
  /*CONSTRAINT "fk_taxon_presence_taxa_sampling_event10" FOREIGN KEY ("id") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
39
  /*CONSTRAINT "fk_taxon_presence_taxa_sampling_event10" FOREIGN KEY ("id") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
40
  /*CONSTRAINT "fk_taxon_presence_taxon_determination10" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
41 41
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
42 42
/*!40101 SET character_set_client = @saved_cs_client */;
43 43

  
......
84 84
  /*CONSTRAINT "collection_unique" */UNIQUE ("institution","name"),
85 85
  /*KEY "fk_collection_organization1_idx" ("institution")*/CHECK (true),
86 86
  /*KEY "fk_collection_source1_idx" ("id")*/CHECK (true),
87
  /*CONSTRAINT "fk_collection_source1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
88
  /*CONSTRAINT "fk_collection_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
87
  /*CONSTRAINT "fk_collection_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
88
  /*CONSTRAINT "fk_collection_source1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
89 89
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"the collection within the institution where a specimen is held" ("Brad Boyle":https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/collectionCode)'*/;
90 90
/*!40101 SET character_set_client = @saved_cs_client */;
91 91

  
......
155 155
  /*KEY "fk_event_place1_idx" ("place")*/CHECK (true),
156 156
  /*KEY "fk_event1_idx" ("parent")*/CHECK (true),
157 157
  /*KEY "fk_event_party_list1_idx" ("participants")*/CHECK (true),
158
  /*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
158 159
  /*CONSTRAINT "fk_event_party_list1" FOREIGN KEY ("participants") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
159
  /*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
160 160
  /*CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
161 161
  /*CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
162 162
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of text/*time*/" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)'*/;
......
281 281
  "parent_geoplace" text NOT NULL,
282 282
  PRIMARY KEY ("id"),
283 283
  /*KEY "fk_geovalidatable_place_geoplace1_idx" ("parent_geoplace")*/CHECK (true),
284
  /*CONSTRAINT "fk_nested_geoplace_geoplace1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
285
  /*CONSTRAINT "fk_geovalidatable_place_geoplace1" FOREIGN KEY ("parent_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
284
  /*CONSTRAINT "fk_geovalidatable_place_geoplace1" FOREIGN KEY ("parent_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
285
  /*CONSTRAINT "fk_nested_geoplace_geoplace1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
286 286
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores only scrubbed geoplaces (GADM places, and distinct point coordinates that GNRS says should be located within them)'*/;
287 287
/*!40101 SET character_set_client = @saved_cs_client */;
288 288

  
......
338 338
  /*KEY "fk_individual_place1_idx" ("within_place")*/CHECK (true),
339 339
  /*KEY "fk_individual_subplace1_idx" ("identifying_place")*/CHECK (true),
340 340
  /*CONSTRAINT "fk_individual_place1" FOREIGN KEY ("within_place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
341
  /*CONSTRAINT "fk_individual_subplace1" FOREIGN KEY ("identifying_place") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
342
  /*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
341
  /*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
342
  /*CONSTRAINT "fk_individual_subplace1" FOREIGN KEY ("identifying_place") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
343 343
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism'*/;
344 344
/*!40101 SET character_set_client = @saved_cs_client */;
345 345

  
......
365 365
  PRIMARY KEY ("id"),
366 366
  /*KEY "fk_aggregate_observation_taxon_presence1_idx" ("taxon")*/CHECK (true),
367 367
  /*KEY "fk_aggregate_observation_size_class1_idx" ("size_class")*/CHECK (true),
368
  /*CONSTRAINT "fk_aggregate_observation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
368 369
  /*CONSTRAINT "fk_aggregate_observation_size_class1" FOREIGN KEY ("size_class") REFERENCES "size_class" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
369
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("taxon") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
370
  /*CONSTRAINT "fk_aggregate_observation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
370
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("taxon") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
371 371
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= stemCount.VegBank.vegpath.org'*/;
372 372
/*!40101 SET character_set_client = @saved_cs_client */;
373 373

  
......
394 394
  /*KEY "fk_individual_observation_individual1_idx" ("individual")*/CHECK (true),
395 395
  /*KEY "fk_individual_observation_place1_idx" ("place_observed_at")*/CHECK (true),
396 396
  /*CONSTRAINT "fk_individual_observation_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
397
  /*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
398
  /*CONSTRAINT "fk_individual_observation_place1" FOREIGN KEY ("place_observed_at") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
397
  /*CONSTRAINT "fk_individual_observation_place1" FOREIGN KEY ("place_observed_at") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
398
  /*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
399 399
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]'*/;
400 400
/*!40101 SET character_set_client = @saved_cs_client */;
401 401

  
......
487 487
  "info" hstore DEFAULT NULL,
488 488
  PRIMARY KEY ("id"),
489 489
  /*KEY "fk_party_organization1_idx" ("organization")*/CHECK (true),
490
  /*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
491
  /*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
490
  /*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
491
  /*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
492 492
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
493 493
/*!40101 SET character_set_client = @saved_cs_client */;
494 494

  
......
533 533
  PRIMARY KEY ("id","entry"),
534 534
  /*KEY "fk_party_list_has_party_party1_idx" ("entry")*/CHECK (true),
535 535
  /*KEY "fk_party_list_has_party_party_list1_idx" ("id")*/CHECK (true),
536
  /*CONSTRAINT "fk_party_list_has_party_party_list1" FOREIGN KEY ("id") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
537
  /*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("entry") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
536
  /*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("entry") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
537
  /*CONSTRAINT "fk_party_list_has_party_party_list1" FOREIGN KEY ("id") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
538 538
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
539 539
/*!40101 SET character_set_client = @saved_cs_client */;
540 540

  
......
594 594
  /*KEY "fk_place_observation_place1_idx" ("place")*/CHECK (true),
595 595
  /*KEY "fk_place_observation_geological_context1_idx" ("geological_context")*/CHECK (true),
596 596
  /*KEY "fk_place_observation_community1_idx" ("community")*/CHECK (true),
597
  /*CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
597
  /*CONSTRAINT "fk_place_observation_community1" FOREIGN KEY ("community") REFERENCES "community" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
598
  /*CONSTRAINT "fk_place_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
598 599
  /*CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
599
  /*CONSTRAINT "fk_place_observation_community1" FOREIGN KEY ("community") REFERENCES "community" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
600
  /*CONSTRAINT "fk_place_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
600
  /*CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
601 601
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]'*/;
602 602
/*!40101 SET character_set_client = @saved_cs_client */;
603 603

  
......
744 744
  PRIMARY KEY ("id"),
745 745
  /*KEY "fk_taxon_occurrence_taxon_determination1_idx" ("original_determination")*/CHECK (true),
746 746
  /*KEY "fk_taxon_occurrence_taxon_determination2_idx" ("current_determination")*/CHECK (true),
747
  /*CONSTRAINT "fk_taxon_occurrence_event1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
747 748
  /*CONSTRAINT "fk_taxon_occurrence_taxon_determination1" FOREIGN KEY ("original_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
748
  /*CONSTRAINT "fk_taxon_occurrence_taxon_determination2" FOREIGN KEY ("current_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
749
  /*CONSTRAINT "fk_taxon_occurrence_event1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
749
  /*CONSTRAINT "fk_taxon_occurrence_taxon_determination2" FOREIGN KEY ("current_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
750 750
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Any entity on which [[VegCore#TaxonDetermination|TaxonDetermination]]s can be made'*/;
751 751
/*!40101 SET character_set_client = @saved_cs_client */;
752 752

  
......
768 768
  "voucher" text NOT NULL,
769 769
  PRIMARY KEY ("id"),
770 770
  /*KEY "fk_reobservable_presence_specimen1_idx" ("voucher")*/CHECK (true),
771
  /*CONSTRAINT "fk_reobservable_presence_taxon_presence1" FOREIGN KEY ("id") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
771
  /*CONSTRAINT "fk_reobservable_presence_reobservable1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
772 772
  /*CONSTRAINT "fk_reobservable_presence_specimen1" FOREIGN KEY ("voucher") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
773
  /*CONSTRAINT "fk_reobservable_presence_reobservable1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
773
  /*CONSTRAINT "fk_reobservable_presence_taxon_presence1" FOREIGN KEY ("id") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
774 774
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
775 775
/*!40101 SET character_set_client = @saved_cs_client */;
776 776

  
......
818 818
  PRIMARY KEY ("id"),
819 819
  /*KEY "fk_soil_observation_place_observation1_idx" ("place_observation")*/CHECK (true),
820 820
  /*KEY "fk_soil_observation_subplace1_idx" ("measurement_spot")*/CHECK (true),
821
  /*CONSTRAINT "fk_soil_observation_subplace1" FOREIGN KEY ("measurement_spot") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
822 821
  /*CONSTRAINT "fk_soil_observation_place_observation1" FOREIGN KEY ("place_observation") REFERENCES "place_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
823
  /*CONSTRAINT "fk_soil_observation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
822
  /*CONSTRAINT "fk_soil_observation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
823
  /*CONSTRAINT "fk_soil_observation_subplace1" FOREIGN KEY ("measurement_spot") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
824 824
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]''s soil'*/;
825 825
/*!40101 SET character_set_client = @saved_cs_client */;
826 826

  
......
871 871
CREATE TABLE "specimen" (
872 872
  "id" text NOT NULL,
873 873
  "individual" text DEFAULT NULL,
874
  "code_in_individual" text DEFAULT NULL,
874
  "individual_observation" text DEFAULT NULL /*COMMENT 'stores observations about the plant the specimen was collected from. some specimens may not be traceable to a reobservable individual, but will still have these plant observations. the collection_event should be set to this field when provided.'*/,
875
  "code_in_individual" text DEFAULT NULL /*COMMENT 'can also be within the individual_observation if no reobservable individual is available'*/,
875 876
  "collection_event" text DEFAULT NULL,
876 877
  "orig_collection" text DEFAULT NULL,
877 878
  "barcode" text DEFAULT NULL,
......
890 891
  /*KEY "fk_specimen_collection2_idx" ("current_collection")*/CHECK (true),
891 892
  /*KEY "fk_specimen_organization3_idx" ("owner_collection")*/CHECK (true),
892 893
  /*KEY "fk_specimen_party_list1_idx" ("specimenholder_institutions")*/CHECK (true),
894
  /*KEY "fk_specimen_individual_observation1_idx" ("individual_observation")*/CHECK (true),
895
  /*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
896
  /*CONSTRAINT "fk_specimen_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
897
  /*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
898
  /*CONSTRAINT "fk_specimen_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
893 899
  /*CONSTRAINT "fk_specimen_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
900
  /*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
894 901
  /*CONSTRAINT "fk_specimen_taxon_observation1" FOREIGN KEY ("collection_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
895
  /*CONSTRAINT "fk_specimen_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
896
  /*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
897
  /*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
898
  /*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
899 902
  /*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
900 903
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen) which was collected from it. when there are multiple specimen replicates (copies) of a specimen, each gets its own specimen_observation pointing to the same specimen.'*/;
901 904
/*!40101 SET character_set_client = @saved_cs_client */;
......
920 923
  "traits" hstore DEFAULT NULL,
921 924
  PRIMARY KEY ("id"),
922 925
  /*KEY "fk_specimen_observation_specimen1_idx" ("specimen")*/CHECK (true),
923
  /*CONSTRAINT "fk_specimen_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
924
  /*CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
926
  /*CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
927
  /*CONSTRAINT "fk_specimen_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
925 928
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
926 929
/*!40101 SET character_set_client = @saved_cs_client */;
927 930

  
......
970 973
  /*CONSTRAINT "stem_observation_unique" */UNIQUE ("individual_observation","stem"),
971 974
  /*KEY "fk_stem_observation_individual_observation1_idx" ("individual_observation")*/CHECK (true),
972 975
  /*KEY "fk_stem_observation_stem1_idx" ("stem")*/CHECK (true),
973
  /*CONSTRAINT "fk_stem_observation_stem1" FOREIGN KEY ("stem") REFERENCES "stem" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
974 976
  /*CONSTRAINT "fk_stem_observation_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
975
  /*CONSTRAINT "fk_stem_observation_individual_observation2" FOREIGN KEY ("id") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
977
  /*CONSTRAINT "fk_stem_observation_individual_observation2" FOREIGN KEY ("id") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
978
  /*CONSTRAINT "fk_stem_observation_stem1" FOREIGN KEY ("stem") REFERENCES "stem" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
976 979
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]'*/;
977 980
/*!40101 SET character_set_client = @saved_cs_client */;
978 981

  
......
1017 1020
  PRIMARY KEY ("id"),
1018 1021
  /*KEY "fk_stratum_event_stratum1_idx" ("stratum")*/CHECK (true),
1019 1022
  /*KEY "fk_stratum_event_sampling_event2_idx" ("parent_event")*/CHECK (true),
1020
  /*CONSTRAINT "fk_stratum_event_stratum1" FOREIGN KEY ("stratum") REFERENCES "stratum" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1021 1023
  /*CONSTRAINT "fk_stratum_event_sampling_event1" FOREIGN KEY ("id") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1022
  /*CONSTRAINT "fk_stratum_event_sampling_event2" FOREIGN KEY ("parent_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1024
  /*CONSTRAINT "fk_stratum_event_sampling_event2" FOREIGN KEY ("parent_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1025
  /*CONSTRAINT "fk_stratum_event_stratum1" FOREIGN KEY ("stratum") REFERENCES "stratum" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1023 1026
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= stratum.VegBank.vegpath.org (which was confusingly named)'*/;
1024 1027
/*!40101 SET character_set_client = @saved_cs_client */;
1025 1028

  
......
1044 1047
  "coords" hstore DEFAULT NULL,
1045 1048
  PRIMARY KEY ("id"),
1046 1049
  /*KEY "fk_rel_place_place1_idx" ("parent")*/CHECK (true),
1047
  /*CONSTRAINT "fk_subplot_place2" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1048
  /*CONSTRAINT "fk_rel_place_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1050
  /*CONSTRAINT "fk_rel_place_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1051
  /*CONSTRAINT "fk_subplot_place2" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1049 1052
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))'*/;
1050 1053
/*!40101 SET character_set_client = @saved_cs_client */;
1051 1054

  
......
1093 1096
  PRIMARY KEY ("id"),
1094 1097
  /*KEY "fk_sampling_event_method1_idx" ("method")*/CHECK (true),
1095 1098
  /*KEY "fk_taxa_sampling_event_place1_idx" ("within_place")*/CHECK (true),
1099
  /*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1096 1100
  /*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1097
  /*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1098 1101
  /*CONSTRAINT "fk_taxa_sampling_event_place1" FOREIGN KEY ("within_place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1099 1102
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='for plots and aggregate_observations within them'*/;
1100 1103
/*!40101 SET character_set_client = @saved_cs_client */;
......
1142 1145
  /*KEY "fk_taxon_assertion_taxon_string1_idx" ("string")*/CHECK (true),
1143 1146
  /*KEY "fk_taxon_assertion_taxon_name1_idx" ("taxon")*/CHECK (true),
1144 1147
  /*CONSTRAINT "fk_qualified_taxon_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1145
  /*CONSTRAINT "fk_taxon_assertion_taxon_string1" FOREIGN KEY ("string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1146
  /*CONSTRAINT "fk_taxon_assertion_taxon_name1" FOREIGN KEY ("taxon") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1148
  /*CONSTRAINT "fk_taxon_assertion_taxon_name1" FOREIGN KEY ("taxon") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1149
  /*CONSTRAINT "fk_taxon_assertion_taxon_string1" FOREIGN KEY ("string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1147 1150
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
1148 1151
/*!40101 SET character_set_client = @saved_cs_client */;
1149 1152

  
......
1170 1173
  /*KEY "fk_taxon_taxon1_idx" ("parent")*/CHECK (true),
1171 1174
  /*KEY "fk_taxon_concept_source1_idx" ("according_to")*/CHECK (true),
1172 1175
  /*KEY "fk_taxon_concept_taxon_concept1_idx" ("accepted_taxon_concept")*/CHECK (true),
1173
  /*CONSTRAINT "fk_taxon_taxon1" FOREIGN KEY ("parent") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1174 1176
  /*CONSTRAINT "fk_taxon_concept_source1" FOREIGN KEY ("according_to") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1175 1177
  /*CONSTRAINT "fk_taxon_concept_taxon_concept1" FOREIGN KEY ("accepted_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1176
  /*CONSTRAINT "fk_taxon_concept_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1178
  /*CONSTRAINT "fk_taxon_concept_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1179
  /*CONSTRAINT "fk_taxon_taxon1" FOREIGN KEY ("parent") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1177 1180
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A [[VegCore#Taxon|Taxon]] described by a specific [[VegCore#Reference|Reference]]'*/;
1178 1181
/*!40101 SET character_set_client = @saved_cs_client */;
1179 1182

  
......
1230 1233
  PRIMARY KEY ("id"),
1231 1234
  /*KEY "fk_taxon_concept_taxon_string10_idx" ("unique_name")*/CHECK (true),
1232 1235
  /*KEY "fk_taxon_name_taxon_path1_idx" ("taxon_path")*/CHECK (true),
1233
  /*CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1234 1236
  /*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1235
  /*CONSTRAINT "fk_taxon_name_taxon_path1" FOREIGN KEY ("taxon_path") REFERENCES "taxon_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1237
  /*CONSTRAINT "fk_taxon_name_taxon_path1" FOREIGN KEY ("taxon_path") REFERENCES "taxon_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1238
  /*CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1236 1239
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
1237 1240
/*!40101 SET character_set_client = @saved_cs_client */;
1238 1241

  
......
1260 1263
  PRIMARY KEY ("id"),
1261 1264
  /*KEY "fk_taxon_observation_party_list1_idx" ("collectors")*/CHECK (true),
1262 1265
  /*KEY "fk_taxon_observation_taxon_observation1_idx" ("observation_in_parent_place")*/CHECK (true),
1263
  /*CONSTRAINT "fk_taxon_observation_taxon_observation1" FOREIGN KEY ("observation_in_parent_place") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1264 1266
  /*CONSTRAINT "fk_taxon_observation_party_list1" FOREIGN KEY ("collectors") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1265
  /*CONSTRAINT "fk_taxon_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1267
  /*CONSTRAINT "fk_taxon_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1268
  /*CONSTRAINT "fk_taxon_observation_taxon_observation1" FOREIGN KEY ("observation_in_parent_place") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1266 1269
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
1267 1270
/*!40101 SET character_set_client = @saved_cs_client */;
1268 1271

  
......
1336 1339
  /*KEY "fk_taxon_scrub_taxon_assertion1_idx" ("parsed_taxon_assertion")*/CHECK (true),
1337 1340
  /*KEY "fk_taxon_scrub_taxon_string1_idx" ("input_string")*/CHECK (true),
1338 1341
  /*CONSTRAINT "fk_parsed_taxon_assertion_taxon_name1" FOREIGN KEY ("matched_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1342
  /*CONSTRAINT "fk_taxon_scrub_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1339 1343
  /*CONSTRAINT "fk_taxon_scrub_taxon_assertion1" FOREIGN KEY ("parsed_taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1340
  /*CONSTRAINT "fk_taxon_scrub_taxon_string1" FOREIGN KEY ("input_string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1341
  /*CONSTRAINT "fk_taxon_scrub_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1344
  /*CONSTRAINT "fk_taxon_scrub_taxon_string1" FOREIGN KEY ("input_string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1342 1345
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
1343 1346
/*!40101 SET character_set_client = @saved_cs_client */;
1344 1347

  
schemas/VegCore/document.mwb.xml
2 2
<data grt_format="2.0" document_type="MySQL Workbench Model" version="1.4.4">
3 3
  <value type="object" struct-name="workbench.Document" id="DD51DD12-152C-46FD-90D9-84EB5F9F500F" struct-checksum="0x7131bf99">
4 4
    <value type="object" struct-name="workbench.logical.Model" id="9FB30CD5-3D20-4492-935C-7986A48D7820" struct-checksum="0xf4220370" key="logicalModel">
5
      <value _ptr_="0xc033fe0" type="list" content-type="object" content-struct-name="workbench.logical.Diagram" key="diagrams"/>
6
      <value _ptr_="0xc02d878" type="dict" key="customData"/>
7
      <value _ptr_="0xc0342b0" type="list" content-type="object" content-struct-name="model.Marker" key="markers"/>
8
      <value _ptr_="0xc030fe8" type="dict" key="options"/>
5
      <value _ptr_="0xad4b6b8" type="list" content-type="object" content-struct-name="workbench.logical.Diagram" key="diagrams"/>
6
      <value _ptr_="0xad44f18" type="dict" key="customData"/>
7
      <value _ptr_="0xad4b988" type="list" content-type="object" content-struct-name="model.Marker" key="markers"/>
8
      <value _ptr_="0xad48648" type="dict" key="options"/>
9 9
      <value type="string" key="name"></value>
10 10
      <link type="object" struct-name="GrtObject" key="owner">DD51DD12-152C-46FD-90D9-84EB5F9F500F</link>
11 11
    </value>
12
    <value _ptr_="0xb227528" type="list" content-type="object" content-struct-name="workbench.OverviewPanel" key="overviewPanels"/>
13
    <value _ptr_="0xc033f58" type="list" content-type="object" content-struct-name="workbench.physical.Model" key="physicalModels">
12
    <value _ptr_="0x9f20760" type="list" content-type="object" content-struct-name="workbench.OverviewPanel" key="overviewPanels"/>
13
    <value _ptr_="0xad4b630" type="list" content-type="object" content-struct-name="workbench.physical.Model" key="physicalModels">
14 14
      <value type="object" struct-name="workbench.physical.Model" id="257B05AA-CE39-49DE-9522-6B703F985F32" struct-checksum="0x5f896d18">
15 15
        <value type="object" struct-name="db.mysql.Catalog" id="42266085-54CC-4441-8553-68BBE0286A05" struct-checksum="0x82ad3466" key="catalog">
16
          <value _ptr_="0xc0350a8" type="list" content-type="object" content-struct-name="db.mysql.LogFileGroup" key="logFileGroups"/>
17
          <value _ptr_="0xc035120" type="list" content-type="object" content-struct-name="db.mysql.Schema" key="schemata">
16
          <value _ptr_="0xad4c7b0" type="list" content-type="object" content-struct-name="db.mysql.LogFileGroup" key="logFileGroups"/>
17
          <value _ptr_="0xad4c828" type="list" content-type="object" content-struct-name="db.mysql.Schema" key="schemata">
18 18
            <value type="object" struct-name="db.mysql.Schema" id="be8cb246-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x20b94c22">
19
              <value _ptr_="0xc035340" type="list" content-type="object" content-struct-name="db.mysql.RoutineGroup" key="routineGroups"/>
20
              <value _ptr_="0xc035728" type="list" content-type="object" content-struct-name="db.mysql.Routine" key="routines"/>
21
              <value _ptr_="0xc035758" type="list" content-type="object" content-struct-name="db.mysql.Sequence" key="sequences"/>
22
              <value _ptr_="0xc0357b0" type="list" content-type="object" content-struct-name="db.mysql.StructuredDatatype" key="structuredTypes"/>
23
              <value _ptr_="0xc0357e0" type="list" content-type="object" content-struct-name="db.mysql.Synonym" key="synonyms"/>
24
              <value _ptr_="0xc035810" type="list" content-type="object" content-struct-name="db.mysql.Table" key="tables">
19
              <value _ptr_="0xad4ca48" type="list" content-type="object" content-struct-name="db.mysql.RoutineGroup" key="routineGroups"/>
20
              <value _ptr_="0xad4ce30" type="list" content-type="object" content-struct-name="db.mysql.Routine" key="routines"/>
21
              <value _ptr_="0xad4ce60" type="list" content-type="object" content-struct-name="db.mysql.Sequence" key="sequences"/>
22
              <value _ptr_="0xad4ceb8" type="list" content-type="object" content-struct-name="db.mysql.StructuredDatatype" key="structuredTypes"/>
23
              <value _ptr_="0xad4cee8" type="list" content-type="object" content-struct-name="db.mysql.Synonym" key="synonyms"/>
24
              <value _ptr_="0xad4cf18" type="list" content-type="object" content-struct-name="db.mysql.Table" key="tables">
25 25
                <value type="object" struct-name="db.mysql.Table" id="be8fe70e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
26 26
                  <value type="string" key="avgRowLength"></value>
27 27
                  <value type="int" key="checksum">0</value>
28
                  <value _ptr_="0xc035988" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
28
                  <value _ptr_="0xad4d090" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
29 29
                    <value type="object" struct-name="db.mysql.Column" id="be8fe97a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
30 30
                      <value type="int" key="autoIncrement">0</value>
31 31
                      <value type="string" key="characterSetName"></value>
32
                      <value _ptr_="0xc036120" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
32
                      <value _ptr_="0xad4d828" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
33 33
                      <value type="string" key="collationName"></value>
34 34
                      <value type="string" key="datatypeExplicitParams"></value>
35 35
                      <value type="string" key="defaultValue"></value>
36 36
                      <value type="int" key="defaultValueIsNull">0</value>
37
                      <value _ptr_="0xc036448" type="list" content-type="string" key="flags"/>
37
                      <value _ptr_="0xad4db50" type="list" content-type="string" key="flags"/>
38 38
                      <value type="int" key="isNotNull">1</value>
39 39
                      <value type="int" key="length">767</value>
40 40
                      <value type="int" key="precision">-1</value>
......
48 48
                    <value type="object" struct-name="db.mysql.Column" id="e5502346-f676-11e2-9716-080027bcf912" struct-checksum="0x783b5183">
49 49
                      <value type="int" key="autoIncrement">0</value>
50 50
                      <value type="string" key="characterSetName"></value>
51
                      <value _ptr_="0xc036598" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
51
                      <value _ptr_="0xad4dca0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
52 52
                      <value type="string" key="collationName"></value>
53 53
                      <value type="string" key="datatypeExplicitParams"></value>
54 54
                      <value type="string" key="defaultValue"></value>
55 55
                      <value type="int" key="defaultValueIsNull">1</value>
56
                      <value _ptr_="0xc0368c0" type="list" content-type="string" key="flags"/>
56
                      <value _ptr_="0xad4dfc8" type="list" content-type="string" key="flags"/>
57 57
                      <value type="int" key="isNotNull">0</value>
58 58
                      <value type="int" key="length">767</value>
59 59
                      <value type="int" key="precision">-1</value>
......
67 67
                    <value type="object" struct-name="db.mysql.Column" id="c8868c00-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
68 68
                      <value type="int" key="autoIncrement">0</value>
69 69
                      <value type="string" key="characterSetName"></value>
70
                      <value _ptr_="0xc036a10" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
70
                      <value _ptr_="0xad4e118" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
71 71
                      <value type="string" key="collationName"></value>
72 72
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
73 73
                      <value type="string" key="defaultValue"></value>
74 74
                      <value type="int" key="defaultValueIsNull">0</value>
75
                      <value _ptr_="0xc036d38" type="list" content-type="string" key="flags"/>
75
                      <value _ptr_="0xad4e440" type="list" content-type="string" key="flags"/>
76 76
                      <value type="int" key="isNotNull">0</value>
77 77
                      <value type="int" key="length">-1</value>
78 78
                      <value type="int" key="precision">-1</value>
......
88 88
                  <value type="string" key="defaultCharacterSetName">utf8</value>
89 89
                  <value type="string" key="defaultCollationName">utf8_bin</value>
90 90
                  <value type="int" key="delayKeyWrite">0</value>
91
                  <value _ptr_="0xc035ec0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
91
                  <value _ptr_="0xad4d5c8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
92 92
                    <value type="object" struct-name="db.mysql.ForeignKey" id="e550209e-f676-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">
93 93
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
94
                      <value _ptr_="0xb1d7868" type="list" content-type="object" content-struct-name="db.Column" key="columns">
94
                      <value _ptr_="0xad4e5b8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
95 95
                        <link type="object">e5502346-f676-11e2-9716-080027bcf912</link>
96 96
                      </value>
97 97
                      <value type="int" key="deferability">0</value>
......
101 101
                      <value type="int" key="many">1</value>
102 102
                      <value type="int" key="modelOnly">0</value>
103 103
                      <link type="object" struct-name="db.Table" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
104
                      <value _ptr_="0xb210c48" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
104
                      <value _ptr_="0xad4e8a8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
105 105
                        <link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
106 106
                      </value>
107 107
                      <value type="int" key="referencedMandatory">0</value>
......
112 112
                    </value>
113 113
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8fee8e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
114 114
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
115
                      <value _ptr_="0xb213598" type="list" content-type="object" content-struct-name="db.Column" key="columns">
115
                      <value _ptr_="0xad4e918" type="list" content-type="object" content-struct-name="db.Column" key="columns">
116 116
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
117 117
                      </value>
118 118
                      <value type="int" key="deferability">0</value>
......
122 122
                      <value type="int" key="many">0</value>
123 123
                      <value type="int" key="modelOnly">0</value>
124 124
                      <link type="object" struct-name="db.Table" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
125
                      <value _ptr_="0xc033c80" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
125
                      <value _ptr_="0xad4ec08" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
126 126
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
127 127
                      </value>
128 128
                      <value type="int" key="referencedMandatory">1</value>
......
132 132
                      <value type="string" key="oldName">fk_collection_source10</value>
133 133
                    </value>
134 134
                  </value>
135
                  <value _ptr_="0xc035ef0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
135
                  <value _ptr_="0xad4d5f8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
136 136
                    <value type="object" struct-name="db.mysql.Index" id="be8feb50-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
137
                      <value _ptr_="0xc030f70" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
137
                      <value _ptr_="0xad4ec78" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
138 138
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c37e8388-ac44-11e2-820d-080027bcf912" struct-checksum="0x62630b3c">
139 139
                          <value type="int" key="columnLength">0</value>
140 140
                          <value type="string" key="comment"></value>
......
157 157
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
158 158
                    </value>
159 159
                    <value type="object" struct-name="db.mysql.Index" id="e550389a-f676-11e2-9716-080027bcf912" struct-checksum="0x309b847a">
160
                      <value _ptr_="0xc02be68" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
160
                      <value _ptr_="0xad4efe0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
161 161
                        <value type="object" struct-name="db.mysql.IndexColumn" id="e5503a2a-f676-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">
162 162
                          <value type="int" key="columnLength">0</value>
163 163
                          <value type="string" key="comment"></value>
......
187 187
                  <value type="string" key="nextAutoInc"></value>
188 188
                  <value type="string" key="packKeys"></value>
189 189
                  <value type="int" key="partitionCount">0</value>
190
                  <value _ptr_="0xc035f80" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
190
                  <value _ptr_="0xad4d688" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
191 191
                  <value type="string" key="partitionExpression"></value>
192 192
                  <value type="string" key="partitionType"></value>
193 193
                  <value type="string" key="password"></value>
......
202 202
                  <value type="string" key="tableDataDir"></value>
203 203
                  <value type="string" key="tableEngine">InnoDB</value>
204 204
                  <value type="string" key="tableIndexDir"></value>
205
                  <value _ptr_="0xc035f20" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
205
                  <value _ptr_="0xad4d628" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
206 206
                  <value type="int" key="isStub">0</value>
207 207
                  <value type="int" key="isSystem">0</value>
208 208
                  <value type="int" key="isTemporary">0</value>
209 209
                  <value type="string" key="temporaryScope"></value>
210 210
                  <value type="int" key="commentedOut">0</value>
211 211
                  <value type="string" key="createDate">2013-04-16 14:58</value>
212
                  <value _ptr_="0xc02bfb8" type="dict" key="customData"/>
212
                  <value _ptr_="0xad43658" type="dict" key="customData"/>
213 213
                  <value type="string" key="lastChangeDate">2013-07-26 21:43</value>
214 214
                  <value type="int" key="modelOnly">0</value>
215 215
                  <value type="string" key="name">party</value>
......
221 221
                <value type="object" struct-name="db.mysql.Table" id="be8ce932-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
222 222
                  <value type="string" key="avgRowLength"></value>
223 223
                  <value type="int" key="checksum">0</value>
224
                  <value _ptr_="0xb23d880" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
224
                  <value _ptr_="0xad4f610" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
225 225
                    <value type="object" struct-name="db.mysql.Column" id="be8cebb2-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
226 226
                      <value type="int" key="autoIncrement">0</value>
227 227
                      <value type="string" key="characterSetName"></value>
228
                      <value _ptr_="0xb6db390" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
228
                      <value _ptr_="0xad50018" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
229 229
                      <value type="string" key="collationName"></value>
230 230
                      <value type="string" key="datatypeExplicitParams"></value>
231 231
                      <value type="string" key="defaultValue"></value>
232 232
                      <value type="int" key="defaultValueIsNull">0</value>
233
                      <value _ptr_="0xb1eedd0" type="list" content-type="string" key="flags"/>
233
                      <value _ptr_="0xad50340" type="list" content-type="string" key="flags"/>
234 234
                      <value type="int" key="isNotNull">1</value>
235 235
                      <value type="int" key="length">767</value>
236 236
                      <value type="int" key="precision">-1</value>
......
244 244
                    <value type="object" struct-name="db.mysql.Column" id="be8ced88-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
245 245
                      <value type="int" key="autoIncrement">0</value>
246 246
                      <value type="string" key="characterSetName"></value>
247
                      <value _ptr_="0xb1eef20" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
247
                      <value _ptr_="0xad50490" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
248 248
                      <value type="string" key="collationName"></value>
249 249
                      <value type="string" key="datatypeExplicitParams"></value>
250 250
                      <value type="string" key="defaultValue"></value>
251 251
                      <value type="int" key="defaultValueIsNull">0</value>
252
                      <value _ptr_="0xb1ef280" type="list" content-type="string" key="flags"/>
252
                      <value _ptr_="0xad507b8" type="list" content-type="string" key="flags"/>
253 253
                      <value type="int" key="isNotNull">1</value>
254 254
                      <value type="int" key="length">767</value>
255 255
                      <value type="int" key="precision">-1</value>
......
263 263
                    <value type="object" struct-name="db.mysql.Column" id="be8cef2c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
264 264
                      <value type="int" key="autoIncrement">0</value>
265 265
                      <value type="string" key="characterSetName"></value>
266
                      <value _ptr_="0xb1ef3d0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
266
                      <value _ptr_="0xad50908" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
267 267
                      <value type="string" key="collationName"></value>
268 268
                      <value type="string" key="datatypeExplicitParams"></value>
269 269
                      <value type="string" key="defaultValue"></value>
270 270
                      <value type="int" key="defaultValueIsNull">0</value>
271
                      <value _ptr_="0xc033228" type="list" content-type="string" key="flags"/>
271
                      <value _ptr_="0xad50c30" type="list" content-type="string" key="flags"/>
272 272
                      <value type="int" key="isNotNull">1</value>
273 273
                      <value type="int" key="length">767</value>
274 274
                      <value type="int" key="precision">-1</value>
......
282 282
                    <value type="object" struct-name="db.mysql.Column" id="95e0feca-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
283 283
                      <value type="int" key="autoIncrement">0</value>
284 284
                      <value type="string" key="characterSetName"></value>
285
                      <value _ptr_="0xc033378" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
285
                      <value _ptr_="0xad50d80" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
286 286
                      <value type="string" key="collationName"></value>
287 287
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
288 288
                      <value type="string" key="defaultValue"></value>
289 289
                      <value type="int" key="defaultValueIsNull">0</value>
290
                      <value _ptr_="0xc0336f8" type="list" content-type="string" key="flags"/>
290
                      <value _ptr_="0xad510a8" type="list" content-type="string" key="flags"/>
291 291
                      <value type="int" key="isNotNull">0</value>
292 292
                      <value type="int" key="length">-1</value>
293 293
                      <value type="int" key="precision">-1</value>
......
303 303
                  <value type="string" key="defaultCharacterSetName">utf8</value>
304 304
                  <value type="string" key="defaultCollationName">utf8_bin</value>
305 305
                  <value type="int" key="delayKeyWrite">0</value>
306
                  <value _ptr_="0xb6db0f0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
306
                  <value _ptr_="0xad4fdb8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
307 307
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8cf9fe-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
308 308
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
309
                      <value _ptr_="0xc033870" type="list" content-type="object" content-struct-name="db.Column" key="columns">
309
                      <value _ptr_="0xad51220" type="list" content-type="object" content-struct-name="db.Column" key="columns">
310 310
                        <link type="object">be8cebb2-a6e0-11e2-95e9-080027bcf912</link>
311 311
                      </value>
312 312
                      <value type="int" key="deferability">0</value>
......
316 316
                      <value type="int" key="many">0</value>
317 317
                      <value type="int" key="modelOnly">0</value>
318 318
                      <link type="object" struct-name="db.Table" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link>
319
                      <value _ptr_="0xc033b60" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
319
                      <value _ptr_="0xad51510" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
320 320
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
321 321
                      </value>
322 322
                      <value type="int" key="referencedMandatory">1</value>
......
327 327
                    </value>
328 328
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8cfb66-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
329 329
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
330
                      <value _ptr_="0xb6d4468" type="list" content-type="object" content-struct-name="db.Column" key="columns">
330
                      <value _ptr_="0xad51580" type="list" content-type="object" content-struct-name="db.Column" key="columns">
331 331
                        <link type="object">be8ced88-a6e0-11e2-95e9-080027bcf912</link>
332 332
                      </value>
333 333
                      <value type="int" key="deferability">0</value>
......
337 337
                      <value type="int" key="many">0</value>
338 338
                      <value type="int" key="modelOnly">0</value>
339 339
                      <link type="object" struct-name="db.Table" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link>
340
                      <value _ptr_="0xb6d47f0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
340
                      <value _ptr_="0xad51870" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
341 341
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
342 342
                      </value>
343 343
                      <value type="int" key="referencedMandatory">1</value>
......
348 348
                    </value>
349 349
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8cfcb0-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
350 350
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
351
                      <value _ptr_="0xb6d4860" type="list" content-type="object" content-struct-name="db.Column" key="columns">
351
                      <value _ptr_="0xad518e0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
352 352
                        <link type="object">be8cef2c-a6e0-11e2-95e9-080027bcf912</link>
353 353
                      </value>
354 354
                      <value type="int" key="deferability">0</value>
......
358 358
                      <value type="int" key="many">0</value>
359 359
                      <value type="int" key="modelOnly">0</value>
360 360
                      <link type="object" struct-name="db.Table" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link>
361
                      <value _ptr_="0xb6d4be8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
361
                      <value _ptr_="0xad51bd0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
362 362
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
363 363
                      </value>
364 364
                      <value type="int" key="referencedMandatory">1</value>
......
368 368
                      <value type="string" key="oldName">fk_relationship_related_record</value>
369 369
                    </value>
370 370
                  </value>
371
                  <value _ptr_="0xb6db140" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
371
                  <value _ptr_="0xad4fde8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
372 372
                    <value type="object" struct-name="db.mysql.Index" id="be8cf0d0-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
373
                      <value _ptr_="0xb6d4c78" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
373
                      <value _ptr_="0xad51c40" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
374 374
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cf2ec-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
375 375
                          <value type="int" key="columnLength">0</value>
376 376
                          <value type="string" key="comment"></value>
......
393 393
                      <link type="object" struct-name="GrtObject" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link>
394 394
                    </value>
395 395
                    <value type="object" struct-name="db.mysql.Index" id="be8cf42c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
396
                      <value _ptr_="0xb6d5058" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
396
                      <value _ptr_="0xad51fa8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
397 397
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cf5e4-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
398 398
                          <value type="int" key="columnLength">0</value>
399 399
                          <value type="string" key="comment"></value>
......
416 416
                      <link type="object" struct-name="GrtObject" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link>
417 417
                    </value>
418 418
                    <value type="object" struct-name="db.mysql.Index" id="be8cf71a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
419
                      <value _ptr_="0xc02c420" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
419
                      <value _ptr_="0xad525d8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
420 420
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cf8c8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
421 421
                          <value type="int" key="columnLength">0</value>
422 422
                          <value type="string" key="comment"></value>
......
446 446
                  <value type="string" key="nextAutoInc"></value>
447 447
                  <value type="string" key="packKeys"></value>
448 448
                  <value type="int" key="partitionCount">0</value>
449
                  <value _ptr_="0xb6db1f0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
449
                  <value _ptr_="0xad4fe78" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
450 450
                  <value type="string" key="partitionExpression"></value>
451 451
                  <value type="string" key="partitionType"></value>
452 452
                  <value type="string" key="password"></value>
......
461 461
                  <value type="string" key="tableDataDir"></value>
462 462
                  <value type="string" key="tableEngine">InnoDB</value>
463 463
                  <value type="string" key="tableIndexDir"></value>
464
                  <value _ptr_="0xb6db190" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
464
                  <value _ptr_="0xad4fe18" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
465 465
                  <value type="int" key="isStub">0</value>
466 466
                  <value type="int" key="isSystem">0</value>
467 467
                  <value type="int" key="isTemporary">0</value>
468 468
                  <value type="string" key="temporaryScope"></value>
469 469
                  <value type="int" key="commentedOut">0</value>
470 470
                  <value type="string" key="createDate">2013-04-16 14:58</value>
471
                  <value _ptr_="0xb6daec8" type="dict" key="customData"/>
471
                  <value _ptr_="0xa3dad88" type="dict" key="customData"/>
472 472
                  <value type="string" key="lastChangeDate">2013-04-24 14:35</value>
473 473
                  <value type="int" key="modelOnly">0</value>
474 474
                  <value type="string" key="name">relationship</value>
......
480 480
                <value type="object" struct-name="db.mysql.Table" id="be8cc04c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
481 481
                  <value type="string" key="avgRowLength"></value>
482 482
                  <value type="int" key="checksum">0</value>
483
                  <value _ptr_="0xc02cb00" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
483
                  <value _ptr_="0xad52c08" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
484 484
                    <value type="object" struct-name="db.mysql.Column" id="be8cc362-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
485 485
                      <value type="int" key="autoIncrement">0</value>
486 486
                      <value type="string" key="characterSetName"></value>
487
                      <value _ptr_="0xc02da70" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
487
                      <value _ptr_="0xad53610" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
488 488
                      <value type="string" key="collationName"></value>
489 489
                      <value type="string" key="datatypeExplicitParams"></value>
490 490
                      <value type="string" key="defaultValue"></value>
491 491
                      <value type="int" key="defaultValueIsNull">0</value>
492
                      <value _ptr_="0xc02ddd0" type="list" content-type="string" key="flags"/>
492
                      <value _ptr_="0xad53938" type="list" content-type="string" key="flags"/>
493 493
                      <value type="int" key="isNotNull">1</value>
494 494
                      <value type="int" key="length">767</value>
495 495
                      <value type="int" key="precision">-1</value>
......
503 503
                    <value type="object" struct-name="db.mysql.Column" id="be8cc59c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
504 504
                      <value type="int" key="autoIncrement">0</value>
505 505
                      <value type="string" key="characterSetName"></value>
506
                      <value _ptr_="0xc02df20" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
506
                      <value _ptr_="0xad53a88" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
507 507
                      <value type="string" key="collationName"></value>
508 508
                      <value type="string" key="datatypeExplicitParams"></value>
509 509
                      <value type="string" key="defaultValue"></value>
510 510
                      <value type="int" key="defaultValueIsNull">1</value>
511
                      <value _ptr_="0xc02e280" type="list" content-type="string" key="flags"/>
511
                      <value _ptr_="0xad53db0" type="list" content-type="string" key="flags"/>
512 512
                      <value type="int" key="isNotNull">0</value>
513 513
                      <value type="int" key="length">767</value>
514 514
                      <value type="int" key="precision">-1</value>
......
522 522
                    <value type="object" struct-name="db.mysql.Column" id="d9b5781e-a90b-11e2-8576-080027bcf912" struct-checksum="0x783b5183">
523 523
                      <value type="int" key="autoIncrement">0</value>
524 524
                      <value type="string" key="characterSetName"></value>
525
                      <value _ptr_="0xc02e3d0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
525
                      <value _ptr_="0xad53f00" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
526 526
                      <value type="string" key="collationName"></value>
527 527
                      <value type="string" key="datatypeExplicitParams"></value>
528 528
                      <value type="string" key="defaultValue"></value>
529 529
                      <value type="int" key="defaultValueIsNull">0</value>
530
                      <value _ptr_="0xc02e750" type="list" content-type="string" key="flags"/>
530
                      <value _ptr_="0xad54228" type="list" content-type="string" key="flags"/>
531 531
                      <value type="int" key="isNotNull">1</value>
532 532
                      <value type="int" key="length">767</value>
533 533
                      <value type="int" key="precision">-1</value>
......
541 541
                    <value type="object" struct-name="db.mysql.Column" id="c7c1e862-a91b-11e2-bdec-080027bcf912" struct-checksum="0x783b5183">
542 542
                      <value type="int" key="autoIncrement">0</value>
543 543
                      <value type="string" key="characterSetName"></value>
544
                      <value _ptr_="0xc02e8a0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
544
                      <value _ptr_="0xad54378" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
545 545
                      <value type="string" key="collationName"></value>
546 546
                      <value type="string" key="datatypeExplicitParams"></value>
547 547
                      <value type="string" key="defaultValue"></value>
548 548
                      <value type="int" key="defaultValueIsNull">1</value>
549
                      <value _ptr_="0xc02ec20" type="list" content-type="string" key="flags"/>
549
                      <value _ptr_="0xad546a0" type="list" content-type="string" key="flags"/>
550 550
                      <value type="int" key="isNotNull">0</value>
551 551
                      <value type="int" key="length">767</value>
552 552
                      <value type="int" key="precision">-1</value>
......
560 560
                    <value type="object" struct-name="db.mysql.Column" id="c8552b14-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x783b5183">
561 561
                      <value type="int" key="autoIncrement">0</value>
562 562
                      <value type="string" key="characterSetName"></value>
563
                      <value _ptr_="0xc02ed70" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
563
                      <value _ptr_="0xad547f0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
564 564
                      <value type="string" key="collationName"></value>
565 565
                      <value type="string" key="datatypeExplicitParams"></value>
566 566
                      <value type="string" key="defaultValue"></value>
567 567
                      <value type="int" key="defaultValueIsNull">1</value>
568
                      <value _ptr_="0xc02f0f0" type="list" content-type="string" key="flags"/>
568
                      <value _ptr_="0xad54b18" type="list" content-type="string" key="flags"/>
569 569
                      <value type="int" key="isNotNull">0</value>
570 570
                      <value type="int" key="length">767</value>
571 571
                      <value type="int" key="precision">-1</value>
......
579 579
                    <value type="object" struct-name="db.mysql.Column" id="e5155806-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
580 580
                      <value type="int" key="autoIncrement">0</value>
581 581
                      <value type="string" key="characterSetName"></value>
582
                      <value _ptr_="0xb6d91f8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
582
                      <value _ptr_="0xad54c68" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
583 583
                      <value type="string" key="collationName"></value>
584 584
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
585 585
                      <value type="string" key="defaultValue"></value>
586 586
                      <value type="int" key="defaultValueIsNull">0</value>
587
                      <value _ptr_="0xb6d9578" type="list" content-type="string" key="flags"/>
587
                      <value _ptr_="0xad54f90" type="list" content-type="string" key="flags"/>
588 588
                      <value type="int" key="isNotNull">0</value>
589 589
                      <value type="int" key="length">-1</value>
590 590
                      <value type="int" key="precision">-1</value>
......
600 600
                  <value type="string" key="defaultCharacterSetName">utf8</value>
601 601
                  <value type="string" key="defaultCollationName">utf8_bin</value>
602 602
                  <value type="int" key="delayKeyWrite">0</value>
603
                  <value _ptr_="0xc02d3b0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
603
                  <value _ptr_="0xad533b0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
604 604
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8cce5c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
605 605
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
606
                      <value _ptr_="0xb6d96f0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
606
                      <value _ptr_="0xad55108" type="list" content-type="object" content-struct-name="db.Column" key="columns">
607 607
                        <link type="object">be8cc59c-a6e0-11e2-95e9-080027bcf912</link>
608 608
                      </value>
609 609
                      <value type="int" key="deferability">0</value>
......
613 613
                      <value type="int" key="many">1</value>
614 614
                      <value type="int" key="modelOnly">0</value>
615 615
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
616
                      <value _ptr_="0xb6d9a58" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
616
                      <value _ptr_="0xad553f8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
617 617
                        <link type="object">be8cc362-a6e0-11e2-95e9-080027bcf912</link>
618 618
                      </value>
619 619
                      <value type="int" key="referencedMandatory">0</value>
......
624 624
                    </value>
625 625
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c8552934-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x70a8fc40">
626 626
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
627
                      <value _ptr_="0xb6d9ac8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
627
                      <value _ptr_="0xad55468" type="list" content-type="object" content-struct-name="db.Column" key="columns">
628 628
                        <link type="object">c8552b14-a7bc-11e2-8af2-080027bcf912</link>
629 629
                      </value>
630 630
                      <value type="int" key="deferability">0</value>
......
634 634
                      <value type="int" key="many">1</value>
635 635
                      <value type="int" key="modelOnly">0</value>
636 636
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
637
                      <value _ptr_="0xb6d9e50" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
637
                      <value _ptr_="0xad55758" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
638 638
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
639 639
                      </value>
640 640
                      <value type="int" key="referencedMandatory">0</value>
......
645 645
                    </value>
646 646
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c7c1e6aa-a91b-11e2-bdec-080027bcf912" struct-checksum="0x70a8fc40">
647 647
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
648
                      <value _ptr_="0xb6d9ec0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
648
                      <value _ptr_="0xad557c8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
649 649
                        <link type="object">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
650 650
                      </value>
651 651
                      <value type="int" key="deferability">0</value>
......
655 655
                      <value type="int" key="many">1</value>
656 656
                      <value type="int" key="modelOnly">0</value>
657 657
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
658
                      <value _ptr_="0xb6da248" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
658
                      <value _ptr_="0xad55ab8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
659 659
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
660 660
                      </value>
661 661
                      <value type="int" key="referencedMandatory">0</value>
......
665 665
                      <value type="string" key="oldName">fk_source_party2</value>
666 666
                    </value>
667 667
                  </value>
668
                  <value _ptr_="0xc02d400" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
668
                  <value _ptr_="0xad533e0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
669 669
                    <value type="object" struct-name="db.mysql.Index" id="be8cc75e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
670
                      <value _ptr_="0xb6da2d8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
670
                      <value _ptr_="0xad55b28" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
671 671
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cc970-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
672 672
                          <value type="int" key="columnLength">0</value>
673 673
                          <value type="string" key="comment"></value>
......
690 690
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
691 691
                    </value>
692 692
                    <value type="object" struct-name="db.mysql.Index" id="11c10cc8-a90c-11e2-8576-080027bcf912" struct-checksum="0x309b847a">
693
                      <value _ptr_="0xb6da6b8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
693
                      <value _ptr_="0xad55e90" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
694 694
                        <value type="object" struct-name="db.mysql.IndexColumn" id="151fbf2c-a90c-11e2-8576-080027bcf912" struct-checksum="0x62630b3c">
695 695
                          <value type="int" key="columnLength">0</value>
696 696
                          <value type="string" key="comment"></value>
......
721 721
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
722 722
                    </value>
723 723
                    <value type="object" struct-name="db.mysql.Index" id="be8ccb14-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
724
                      <value _ptr_="0xc02f468" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
724
                      <value _ptr_="0xad564c0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
725 725
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cccfe-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
726 726
                          <value type="int" key="columnLength">0</value>
727 727
                          <value type="string" key="comment"></value>
......
744 744
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
745 745
                    </value>
746 746
                    <value type="object" struct-name="db.mysql.Index" id="c8554edc-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x309b847a">
747
                      <value _ptr_="0xc02fe80" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
747
                      <value _ptr_="0xad56dd0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
748 748
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c85550b2-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x62630b3c">
749 749
                          <value type="int" key="columnLength">0</value>
750 750
                          <value type="string" key="comment"></value>
......
767 767
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
768 768
                    </value>
769 769
                    <value type="object" struct-name="db.mysql.Index" id="c7c2089c-a91b-11e2-bdec-080027bcf912" struct-checksum="0x309b847a">
770
                      <value _ptr_="0xc030560" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
770
                      <value _ptr_="0xad57400" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
771 771
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c7c20a4a-a91b-11e2-bdec-080027bcf912" struct-checksum="0x62630b3c">
772 772
                          <value type="int" key="columnLength">0</value>
773 773
                          <value type="string" key="comment"></value>
......
797 797
                  <value type="string" key="nextAutoInc"></value>
798 798
                  <value type="string" key="packKeys"></value>
799 799
                  <value type="int" key="partitionCount">0</value>
800
                  <value _ptr_="0xc02d8d0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
800
                  <value _ptr_="0xad53470" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
801 801
                  <value type="string" key="partitionExpression"></value>
802 802
                  <value type="string" key="partitionType"></value>
803 803
                  <value type="string" key="password"></value>
......
812 812
                  <value type="string" key="tableDataDir"></value>
813 813
                  <value type="string" key="tableEngine">InnoDB</value>
814 814
                  <value type="string" key="tableIndexDir"></value>
815
                  <value _ptr_="0xc02d450" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
815
                  <value _ptr_="0xad53410" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
816 816
                  <value type="int" key="isStub">0</value>
817 817
                  <value type="int" key="isSystem">0</value>
818 818
                  <value type="int" key="isTemporary">0</value>
819 819
                  <value type="string" key="temporaryScope"></value>
820 820
                  <value type="int" key="commentedOut">0</value>
821 821
                  <value type="string" key="createDate">2013-04-16 14:58</value>
822
                  <value _ptr_="0xc02d188" type="dict" key="customData"/>
822
                  <value _ptr_="0xa3d9050" type="dict" key="customData"/>
823 823
                  <value type="string" key="lastChangeDate">2013-07-30 18:38</value>
824 824
                  <value type="int" key="modelOnly">0</value>
825 825
                  <value type="string" key="name">source</value>
......
831 831
                <value type="object" struct-name="db.mysql.Table" id="be8df962-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
832 832
                  <value type="string" key="avgRowLength"></value>
833 833
                  <value type="int" key="checksum">0</value>
834
                  <value _ptr_="0xc030c40" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
834
                  <value _ptr_="0xad57a30" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
835 835
                    <value type="object" struct-name="db.mysql.Column" id="be8dfbf6-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
836 836
                      <value type="int" key="autoIncrement">0</value>
837 837
                      <value type="string" key="characterSetName"></value>
838
                      <value _ptr_="0xc0318f0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
838
                      <value _ptr_="0xad58438" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
839 839
                      <value type="string" key="collationName"></value>
840 840
                      <value type="string" key="datatypeExplicitParams"></value>
841 841
                      <value type="string" key="defaultValue"></value>
842 842
                      <value type="int" key="defaultValueIsNull">0</value>
843
                      <value _ptr_="0xc031c50" type="list" content-type="string" key="flags"/>
843
                      <value _ptr_="0xad58760" type="list" content-type="string" key="flags"/>
844 844
                      <value type="int" key="isNotNull">1</value>
845 845
                      <value type="int" key="length">767</value>
846 846
                      <value type="int" key="precision">-1</value>
......
854 854
                    <value type="object" struct-name="db.mysql.Column" id="ed1eb468-ad0e-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
855 855
                      <value type="int" key="autoIncrement">0</value>
856 856
                      <value type="string" key="characterSetName"></value>
857
                      <value _ptr_="0xc031da0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
857
                      <value _ptr_="0xad588b0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
858 858
                      <value type="string" key="collationName"></value>
859 859
                      <value type="string" key="datatypeExplicitParams"></value>
860 860
                      <value type="string" key="defaultValue"></value>
861 861
                      <value type="int" key="defaultValueIsNull">0</value>
862
                      <value _ptr_="0xc032100" type="list" content-type="string" key="flags"/>
862
                      <value _ptr_="0xad58bd8" type="list" content-type="string" key="flags"/>
863 863
                      <value type="int" key="isNotNull">1</value>
864 864
                      <value type="int" key="length">767</value>
865 865
                      <value type="int" key="precision">-1</value>
......
873 873
                    <value type="object" struct-name="db.mysql.Column" id="45a3f404-ad0f-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
874 874
                      <value type="int" key="autoIncrement">0</value>
875 875
                      <value type="string" key="characterSetName"></value>
876
                      <value _ptr_="0xc032250" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
876
                      <value _ptr_="0xad58d28" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
877 877
                      <value type="string" key="collationName"></value>
878 878
                      <value type="string" key="datatypeExplicitParams"></value>
879 879
                      <value type="string" key="defaultValue"></value>
880 880
                      <value type="int" key="defaultValueIsNull">0</value>
881
                      <value _ptr_="0xc0325d0" type="list" content-type="string" key="flags"/>
881
                      <value _ptr_="0xad59050" type="list" content-type="string" key="flags"/>
882 882
                      <value type="int" key="isNotNull">1</value>
883 883
                      <value type="int" key="length">767</value>
884 884
                      <value type="int" key="precision">-1</value>
......
894 894
                  <value type="string" key="defaultCharacterSetName">utf8</value>
895 895
                  <value type="string" key="defaultCollationName">utf8_bin</value>
896 896
                  <value type="int" key="delayKeyWrite">0</value>
897
                  <value _ptr_="0xc031650" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
897
                  <value _ptr_="0xad581d8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
898 898
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8e0240-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
899 899
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
900
                      <value _ptr_="0xc032748" type="list" content-type="object" content-struct-name="db.Column" key="columns">
900
                      <value _ptr_="0xad591c8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
901 901
                        <link type="object">be8dfbf6-a6e0-11e2-95e9-080027bcf912</link>
902 902
                      </value>
903 903
                      <value type="int" key="deferability">0</value>
......
907 907
                      <value type="int" key="many">0</value>
908 908
                      <value type="int" key="modelOnly">0</value>
909 909
                      <link type="object" struct-name="db.Table" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
910
                      <value _ptr_="0xc032ab0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
910
                      <value _ptr_="0xad594b8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
911 911
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
912 912
                      </value>
913 913
                      <value type="int" key="referencedMandatory">1</value>
......
918 918
                    </value>
919 919
                    <value type="object" struct-name="db.mysql.ForeignKey" id="ed1eb2a6-ad0e-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40">
920 920
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
921
                      <value _ptr_="0xc032b20" type="list" content-type="object" content-struct-name="db.Column" key="columns">
921
                      <value _ptr_="0xad59528" type="list" content-type="object" content-struct-name="db.Column" key="columns">
922 922
                        <link type="object">ed1eb468-ad0e-11e2-b309-080027bcf912</link>
923 923
                      </value>
924 924
                      <value type="int" key="deferability">0</value>
......
928 928
                      <value type="int" key="many">1</value>
929 929
                      <value type="int" key="modelOnly">0</value>
930 930
                      <link type="object" struct-name="db.Table" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
931
                      <value _ptr_="0xc032ea8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
931
                      <value _ptr_="0xad59818" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
932 932
                        <link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
933 933
                      </value>
934 934
                      <value type="int" key="referencedMandatory">1</value>
......
938 938
                      <value type="string" key="oldName">fk_collection_organization1</value>
939 939
                    </value>
940 940
                  </value>
941
                  <value _ptr_="0xc0316a0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
941
                  <value _ptr_="0xad58208" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
942 942
                    <value type="object" struct-name="db.mysql.Index" id="ed1ec98a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
943
                      <value _ptr_="0xb6d1970" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
943
                      <value _ptr_="0xad59888" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
944 944
                        <value type="object" struct-name="db.mysql.IndexColumn" id="ed1ecb1a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
945 945
                          <value type="int" key="columnLength">0</value>
946 946
                          <value type="string" key="comment"></value>
......
963 963
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
964 964
                    </value>
965 965
                    <value type="object" struct-name="db.mysql.Index" id="6b54505e-ad0f-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
966
                      <value _ptr_="0xb6d1d50" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
966
                      <value _ptr_="0xa3d5a00" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
967 967
                        <value type="object" struct-name="db.mysql.IndexColumn" id="6dd2beb0-ad0f-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
968 968
                          <value type="int" key="columnLength">0</value>
969 969
                          <value type="string" key="comment"></value>
......
994 994
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
995 995
                    </value>
996 996
                    <value type="object" struct-name="db.mysql.Index" id="81937b1c-ad12-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
997
                      <value _ptr_="0xb6d2430" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
997
                      <value _ptr_="0xa3d6348" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
998 998
                        <value type="object" struct-name="db.mysql.IndexColumn" id="8194729c-ad12-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
999 999
                          <value type="int" key="columnLength">0</value>
1000 1000
                          <value type="string" key="comment"></value>
......
1017 1017
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
1018 1018
                    </value>
1019 1019
                    <value type="object" struct-name="db.mysql.Index" id="8ed70288-ad14-11e2-9617-080027bcf912" struct-checksum="0x309b847a">
1020
                      <value _ptr_="0xb6d2e48" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1020
                      <value _ptr_="0xad44c28" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1021 1021
                        <value type="object" struct-name="db.mysql.IndexColumn" id="8ed7a80a-ad14-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
1022 1022
                          <value type="int" key="columnLength">0</value>
1023 1023
                          <value type="string" key="comment"></value>
......
1047 1047
                  <value type="string" key="nextAutoInc"></value>
1048 1048
                  <value type="string" key="packKeys"></value>
1049 1049
                  <value type="int" key="partitionCount">0</value>
1050
                  <value _ptr_="0xc031750" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
1050
                  <value _ptr_="0xad58298" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
1051 1051
                  <value type="string" key="partitionExpression"></value>
1052 1052
                  <value type="string" key="partitionType"></value>
1053 1053
                  <value type="string" key="password"></value>
......
1062 1062
                  <value type="string" key="tableDataDir"></value>
1063 1063
                  <value type="string" key="tableEngine">InnoDB</value>
1064 1064
                  <value type="string" key="tableIndexDir"></value>
1065
                  <value _ptr_="0xc0316f0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
1065
                  <value _ptr_="0xad58238" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
1066 1066
                  <value type="int" key="isStub">0</value>
1067 1067
                  <value type="int" key="isSystem">0</value>
1068 1068
                  <value type="int" key="isTemporary">0</value>
1069 1069
                  <value type="string" key="temporaryScope"></value>
1070 1070
                  <value type="int" key="commentedOut">0</value>
1071 1071
                  <value type="string" key="createDate">2013-04-16 14:58</value>
1072
                  <value _ptr_="0xc031428" type="dict" key="customData"/>
1072
                  <value _ptr_="0xa3d66b8" type="dict" key="customData"/>
1073 1073
                  <value type="string" key="lastChangeDate">2013-04-24 14:34</value>
1074 1074
                  <value type="int" key="modelOnly">0</value>
1075 1075
                  <value type="string" key="name">collection</value>
......
1081 1081
                <value type="object" struct-name="db.mysql.Table" id="687f12b8-a780-11e2-afd5-080027bcf912" struct-checksum="0x1a403946">
1082 1082
                  <value type="string" key="avgRowLength"></value>
1083 1083
                  <value type="int" key="checksum">0</value>
1084
                  <value _ptr_="0xb6d3528" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
1084
                  <value _ptr_="0xa3d5fa8" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
1085 1085
                    <value type="object" struct-name="db.mysql.Column" id="687f1542-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
1086 1086
                      <value type="int" key="autoIncrement">0</value>
1087 1087
                      <value type="string" key="characterSetName"></value>
1088
                      <value _ptr_="0xb6d4078" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1088
                      <value _ptr_="0xa3d6670" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1089 1089
                      <value type="string" key="collationName"></value>
1090 1090
                      <value type="string" key="datatypeExplicitParams"></value>
1091 1091
                      <value type="string" key="defaultValue"></value>
1092 1092
                      <value type="int" key="defaultValueIsNull">0</value>
1093
                      <value _ptr_="0xb6d55c8" type="list" content-type="string" key="flags"/>
1093
                      <value _ptr_="0xad44e18" type="list" content-type="string" key="flags"/>
1094 1094
                      <value type="int" key="isNotNull">1</value>
1095 1095
                      <value type="int" key="length">767</value>
1096 1096
                      <value type="int" key="precision">-1</value>
......
1104 1104
                    <value type="object" struct-name="db.mysql.Column" id="687f1718-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
1105 1105
                      <value type="int" key="autoIncrement">0</value>
1106 1106
                      <value type="string" key="characterSetName"></value>
1107
                      <value _ptr_="0xb6d5708" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1107
                      <value _ptr_="0xad479d0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1108 1108
                      <value type="string" key="collationName"></value>
1109 1109
                      <value type="string" key="datatypeExplicitParams"></value>
1110 1110
                      <value type="string" key="defaultValue"></value>
1111 1111
                      <value type="int" key="defaultValueIsNull">0</value>
1112
                      <value _ptr_="0xb6d5a68" type="list" content-type="string" key="flags"/>
1112
                      <value _ptr_="0xad43360" type="list" content-type="string" key="flags"/>
1113 1113
                      <value type="int" key="isNotNull">1</value>
1114 1114
                      <value type="int" key="length">767</value>
1115 1115
                      <value type="int" key="precision">-1</value>
......
1123 1123
                    <value type="object" struct-name="db.mysql.Column" id="687f18b2-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
1124 1124
                      <value type="int" key="autoIncrement">0</value>
1125 1125
                      <value type="string" key="characterSetName"></value>
1126
                      <value _ptr_="0xb6d5bb8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1126
                      <value _ptr_="0xad433c0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1127 1127
                      <value type="string" key="collationName"></value>
1128 1128
                      <value type="string" key="datatypeExplicitParams"></value>
1129 1129
                      <value type="string" key="defaultValue"></value>
1130 1130
                      <value type="int" key="defaultValueIsNull">1</value>
1131
                      <value _ptr_="0xb6d5f38" type="list" content-type="string" key="flags"/>
1131
                      <value _ptr_="0xad4a500" type="list" content-type="string" key="flags"/>
1132 1132
                      <value type="int" key="isNotNull">0</value>
1133 1133
                      <value type="int" key="length">767</value>
1134 1134
                      <value type="int" key="precision">-1</value>
......
1142 1142
                    <value type="object" struct-name="db.mysql.Column" id="687f1a6a-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
1143 1143
                      <value type="int" key="autoIncrement">0</value>
1144 1144
                      <value type="string" key="characterSetName"></value>
1145
                      <value _ptr_="0xb6d6088" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1145
                      <value _ptr_="0xad48b28" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1146 1146
                      <value type="string" key="collationName"></value>
1147 1147
                      <value type="string" key="datatypeExplicitParams"></value>
1148 1148
                      <value type="string" key="defaultValue"></value>
1149 1149
                      <value type="int" key="defaultValueIsNull">1</value>
1150
                      <value _ptr_="0xb6d6408" type="list" content-type="string" key="flags"/>
1150
                      <value _ptr_="0x9eeca48" type="list" content-type="string" key="flags"/>
1151 1151
                      <value type="int" key="isNotNull">0</value>
1152 1152
                      <value type="int" key="length">767</value>
1153 1153
                      <value type="int" key="precision">-1</value>
......
1161 1161
                    <value type="object" struct-name="db.mysql.Column" id="687f1c2c-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
1162 1162
                      <value type="int" key="autoIncrement">0</value>
1163 1163
                      <value type="string" key="characterSetName"></value>
1164
                      <value _ptr_="0xb6d6558" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1164
                      <value _ptr_="0x9eecb98" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1165 1165
                      <value type="string" key="collationName"></value>
1166 1166
                      <value type="string" key="datatypeExplicitParams"></value>
1167 1167
                      <value type="string" key="defaultValue"></value>
1168 1168
                      <value type="int" key="defaultValueIsNull">1</value>
1169
                      <value _ptr_="0xb6d68d8" type="list" content-type="string" key="flags"/>
1169
                      <value _ptr_="0x9f3ad28" type="list" content-type="string" key="flags"/>
1170 1170
                      <value type="int" key="isNotNull">0</value>
1171 1171
                      <value type="int" key="length">767</value>
1172 1172
                      <value type="int" key="precision">-1</value>
......
1180 1180
                    <value type="object" struct-name="db.mysql.Column" id="29c29602-a7a4-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">
1181 1181
                      <value type="int" key="autoIncrement">0</value>
1182 1182
                      <value type="string" key="characterSetName"></value>
1183
                      <value _ptr_="0xb6d6a28" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1183
                      <value _ptr_="0x9f3ae78" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1184 1184
                      <value type="string" key="collationName"></value>
1185 1185
                      <value type="string" key="datatypeExplicitParams"></value>
1186 1186
                      <value type="string" key="defaultValue"></value>
1187 1187
                      <value type="int" key="defaultValueIsNull">1</value>
1188
                      <value _ptr_="0xb6d6da8" type="list" content-type="string" key="flags"/>
1188
                      <value _ptr_="0xad490a0" type="list" content-type="string" key="flags"/>
1189 1189
                      <value type="int" key="isNotNull">0</value>
1190 1190
                      <value type="int" key="length">767</value>
1191 1191
                      <value type="int" key="precision">-1</value>
......
1199 1199
                    <value type="object" struct-name="db.mysql.Column" id="687f1dda-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
1200 1200
                      <value type="int" key="autoIncrement">0</value>
1201 1201
                      <value type="string" key="characterSetName"></value>
1202
                      <value _ptr_="0xb6d6ef8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1202
                      <value _ptr_="0xad491f0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1203 1203
                      <value type="string" key="collationName"></value>
1204 1204
                      <value type="string" key="datatypeExplicitParams"></value>
1205 1205
                      <value type="string" key="defaultValue"></value>
1206 1206
                      <value type="int" key="defaultValueIsNull">1</value>
1207
                      <value _ptr_="0xb6d7278" type="list" content-type="string" key="flags"/>
1207
                      <value _ptr_="0xa3d54f0" type="list" content-type="string" key="flags"/>
1208 1208
                      <value type="int" key="isNotNull">0</value>
1209 1209
                      <value type="int" key="length">767</value>
1210 1210
                      <value type="int" key="precision">-1</value>
......
1218 1218
                    <value type="object" struct-name="db.mysql.Column" id="11b489bc-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x783b5183">
1219 1219
                      <value type="int" key="autoIncrement">0</value>
1220 1220
                      <value type="string" key="characterSetName"></value>
1221
                      <value _ptr_="0xb6d73c8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1221
                      <value _ptr_="0xad49258" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1222 1222
                      <value type="string" key="collationName"></value>
1223 1223
                      <value type="string" key="datatypeExplicitParams"></value>
1224 1224
                      <value type="string" key="defaultValue"></value>
1225 1225
                      <value type="int" key="defaultValueIsNull">1</value>
1226
                      <value _ptr_="0xb6d7748" type="list" content-type="string" key="flags"/>
1226
                      <value _ptr_="0xad4ab70" type="list" content-type="string" key="flags"/>
1227 1227
                      <value type="int" key="isNotNull">0</value>
1228 1228
                      <value type="int" key="length">767</value>
1229 1229
                      <value type="int" key="precision">-1</value>
......
1239 1239
                  <value type="string" key="defaultCharacterSetName">utf8</value>
1240 1240
                  <value type="string" key="defaultCollationName">utf8_bin</value>
1241 1241
                  <value type="int" key="delayKeyWrite">0</value>
1242
                  <value _ptr_="0xb6d3dd8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
1242
                  <value _ptr_="0xa3d5d48" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
1243 1243
                    <value type="object" struct-name="db.mysql.ForeignKey" id="687f25a0-a780-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40">
1244 1244
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1245
                      <value _ptr_="0xb6d78c0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1245
                      <value _ptr_="0xa3d3710" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1246 1246
                        <link type="object">687f1542-a780-11e2-afd5-080027bcf912</link>
1247 1247
                      </value>
1248 1248
                      <value type="int" key="deferability">0</value>
......
1252 1252
                      <value type="int" key="many">0</value>
1253 1253
                      <value type="int" key="modelOnly">0</value>
1254 1254
                      <link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
1255
                      <value _ptr_="0xb6d7c28" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1255
                      <value _ptr_="0xa3d3760" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1256 1256
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
1257 1257
                      </value>
1258 1258
                      <value type="int" key="referencedMandatory">1</value>
......
1263 1263
                    </value>
1264 1264
                    <value type="object" struct-name="db.mysql.ForeignKey" id="687f26f4-a780-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40">
1265 1265
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4c3ffc96-a741-11e2-9fbf-080027bcf912</link>
1266
                      <value _ptr_="0xb6d7c98" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1266
                      <value _ptr_="0xa3d37d0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1267 1267
                        <link type="object">687f1718-a780-11e2-afd5-080027bcf912</link>
1268 1268
                      </value>
1269 1269
                      <value type="int" key="deferability">0</value>
......
1273 1273
                      <value type="int" key="many">1</value>
1274 1274
                      <value type="int" key="modelOnly">0</value>
1275 1275
                      <link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
1276
                      <value _ptr_="0xb6d8020" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1276
                      <value _ptr_="0xad4afd0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1277 1277
                        <link type="object">4c40001a-a741-11e2-9fbf-080027bcf912</link>
1278 1278
                      </value>
1279 1279
                      <value type="int" key="referencedMandatory">1</value>
......
1284 1284
                    </value>
1285 1285
                    <value type="object" struct-name="db.mysql.ForeignKey" id="11b487b4-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x70a8fc40">
1286 1286
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">687f2f28-a780-11e2-afd5-080027bcf912</link>
1287
                      <value _ptr_="0xb6d8090" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1287
                      <value _ptr_="0xad4b040" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1288 1288
                        <link type="object">11b489bc-f97f-11e2-8a2e-080027bcf912</link>
1289 1289
                      </value>
1290 1290
                      <value type="int" key="deferability">0</value>
......
1294 1294
                      <value type="int" key="many">1</value>
1295 1295
                      <value type="int" key="modelOnly">0</value>
1296 1296
                      <link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
1297
                      <value _ptr_="0xb6d8418" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1297
                      <value _ptr_="0x9eecfe0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1298 1298
                        <link type="object">687f31c6-a780-11e2-afd5-080027bcf912</link>
1299 1299
                      </value>
1300 1300
                      <value type="int" key="referencedMandatory">0</value>
......
1304 1304
                      <value type="string" key="oldName">fk_taxon_name_taxon_path1</value>
1305 1305
                    </value>
1306 1306
                  </value>
1307
                  <value _ptr_="0xb6d3e28" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
1307
                  <value _ptr_="0xa3d5d98" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
1308 1308
                    <value type="object" struct-name="db.mysql.Index" id="687f1f92-a780-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">
1309
                      <value _ptr_="0xb6d84a8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1309
                      <value _ptr_="0x9eed070" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1310 1310
                        <value type="object" struct-name="db.mysql.IndexColumn" id="687f217c-a780-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c">
1311 1311
                          <value type="int" key="columnLength">0</value>
1312 1312
                          <value type="string" key="comment"></value>
......
1329 1329
                      <link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
1330 1330
                    </value>
1331 1331
                    <value type="object" struct-name="db.mysql.Index" id="687f22b2-a780-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">
1332
                      <value _ptr_="0xc0370b8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1332
                      <value _ptr_="0xad494d0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1333 1333
                        <value type="object" struct-name="db.mysql.IndexColumn" id="687f246a-a780-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c">
1334 1334
                          <value type="int" key="columnLength">0</value>
1335 1335
                          <value type="string" key="comment"></value>
......
1352 1352
                      <link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
1353 1353
                    </value>
1354 1354
                    <value type="object" struct-name="db.mysql.Index" id="11b49e5c-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x309b847a">
1355
                      <value _ptr_="0xc037190" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1355
                      <value _ptr_="0xa3db978" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1356 1356
                        <value type="object" struct-name="db.mysql.IndexColumn" id="11b4a000-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x62630b3c">
1357 1357
                          <value type="int" key="columnLength">0</value>
1358 1358
                          <value type="string" key="comment"></value>
......
1382 1382
                  <value type="string" key="nextAutoInc"></value>
1383 1383
                  <value type="string" key="packKeys"></value>
1384 1384
                  <value type="int" key="partitionCount">0</value>
1385
                  <value _ptr_="0xb6d3ed8" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
1385
                  <value _ptr_="0xa3d5e48" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
1386 1386
                  <value type="string" key="partitionExpression"></value>
1387 1387
                  <value type="string" key="partitionType"></value>
1388 1388
                  <value type="string" key="password"></value>
......
1397 1397
                  <value type="string" key="tableDataDir"></value>
1398 1398
                  <value type="string" key="tableEngine">InnoDB</value>
1399 1399
                  <value type="string" key="tableIndexDir"></value>
1400
                  <value _ptr_="0xb6d3e78" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
1400
                  <value _ptr_="0xa3d5de8" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
1401 1401
                  <value type="int" key="isStub">0</value>
1402 1402
                  <value type="int" key="isSystem">0</value>
1403 1403
                  <value type="int" key="isTemporary">0</value>
1404 1404
                  <value type="string" key="temporaryScope"></value>
1405 1405
                  <value type="int" key="commentedOut">0</value>
1406 1406
                  <value type="string" key="createDate">2013-04-17 10:01</value>
1407
                  <value _ptr_="0xb6d3bb0" type="dict" key="customData"/>
1407
                  <value _ptr_="0xad486d8" type="dict" key="customData"/>
1408 1408
                  <value type="string" key="lastChangeDate">2013-07-30 18:20</value>
1409 1409
                  <value type="int" key="modelOnly">0</value>
1410 1410
                  <value type="string" key="name">taxon_name</value>
......
1416 1416
                <value type="object" struct-name="db.mysql.Table" id="be8cd56e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
1417 1417
                  <value type="string" key="avgRowLength"></value>
1418 1418
                  <value type="int" key="checksum">0</value>
1419
                  <value _ptr_="0xc037870" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
1419
                  <value _ptr_="0xa3dca78" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
1420 1420
                    <value type="object" struct-name="db.mysql.Column" id="be8cd7b2-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
1421 1421
                      <value type="int" key="autoIncrement">0</value>
1422 1422
                      <value type="string" key="characterSetName"></value>
1423
                      <value _ptr_="0xc0383c0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1423
                      <value _ptr_="0xa3db5b0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1424 1424
                      <value type="string" key="collationName"></value>
1425 1425
                      <value type="string" key="datatypeExplicitParams"></value>
1426 1426
                      <value type="string" key="defaultValue"></value>
1427 1427
                      <value type="int" key="defaultValueIsNull">0</value>
1428
                      <value _ptr_="0xc038720" type="list" content-type="string" key="flags"/>
1428
                      <value _ptr_="0xa3d73a0" type="list" content-type="string" key="flags"/>
1429 1429
                      <value type="int" key="isNotNull">1</value>
1430 1430
                      <value type="int" key="length">767</value>
1431 1431
                      <value type="int" key="precision">-1</value>
......
1439 1439
                    <value type="object" struct-name="db.mysql.Column" id="be8cd956-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
1440 1440
                      <value type="int" key="autoIncrement">0</value>
1441 1441
                      <value type="string" key="characterSetName"></value>
1442
                      <value _ptr_="0xc038870" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1442
                      <value _ptr_="0xa3d74f0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1443 1443
                      <value type="string" key="collationName"></value>
1444 1444
                      <value type="string" key="datatypeExplicitParams"></value>
1445 1445
                      <value type="string" key="defaultValue"></value>
1446 1446
                      <value type="int" key="defaultValueIsNull">0</value>
1447
                      <value _ptr_="0xc038bd0" type="list" content-type="string" key="flags"/>
1447
                      <value _ptr_="0xa3d7850" type="list" content-type="string" key="flags"/>
1448 1448
                      <value type="int" key="isNotNull">1</value>
1449 1449
                      <value type="int" key="length">767</value>
1450 1450
                      <value type="int" key="precision">-1</value>
......
1458 1458
                    <value type="object" struct-name="db.mysql.Column" id="ea3bec44-acef-11e2-bdae-080027bcf912" struct-checksum="0x783b5183">
1459 1459
                      <value type="int" key="autoIncrement">0</value>
1460 1460
                      <value type="string" key="characterSetName"></value>
1461
                      <value _ptr_="0xc038d20" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1461
                      <value _ptr_="0xad47c38" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1462 1462
                      <value type="string" key="collationName"></value>
1463 1463
                      <value type="string" key="datatypeExplicitParams"></value>
1464 1464
                      <value type="string" key="defaultValue"></value>
1465 1465
                      <value type="int" key="defaultValueIsNull">1</value>
1466
                      <value _ptr_="0xc0390a0" type="list" content-type="string" key="flags"/>
1466
                      <value _ptr_="0xad47fb8" type="list" content-type="string" key="flags"/>
1467 1467
                      <value type="int" key="isNotNull">0</value>
1468 1468
                      <value type="int" key="length">767</value>
1469 1469
                      <value type="int" key="precision">-1</value>
......
1477 1477
                    <value type="object" struct-name="db.mysql.Column" id="a09e45d4-a79d-11e2-a346-080027bcf912" struct-checksum="0x783b5183">
1478 1478
                      <value type="int" key="autoIncrement">0</value>
1479 1479
                      <value type="string" key="characterSetName"></value>
1480
                      <value _ptr_="0xc0391f0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1480
                      <value _ptr_="0xad48108" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1481 1481
                      <value type="string" key="collationName"></value>
1482 1482
                      <value type="string" key="datatypeExplicitParams"></value>
1483 1483
                      <value type="string" key="defaultValue"></value>
1484 1484
                      <value type="int" key="defaultValueIsNull">1</value>
1485
                      <value _ptr_="0xc039570" type="list" content-type="string" key="flags"/>
1485
                      <value _ptr_="0xa3d3e00" type="list" content-type="string" key="flags"/>
1486 1486
                      <value type="int" key="isNotNull">0</value>
1487 1487
                      <value type="int" key="length">767</value>
1488 1488
                      <value type="int" key="precision">-1</value>
......
1496 1496
                    <value type="object" struct-name="db.mysql.Column" id="43f62c16-ad1a-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">
1497 1497
                      <value type="int" key="autoIncrement">0</value>
1498 1498
                      <value type="string" key="characterSetName"></value>
1499
                      <value _ptr_="0xc0396c0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1499
                      <value _ptr_="0xa3d3f50" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1500 1500
                      <value type="string" key="collationName"></value>
1501 1501
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
1502 1502
                      <value type="string" key="defaultValue"></value>
1503 1503
                      <value type="int" key="defaultValueIsNull">0</value>
1504
                      <value _ptr_="0xc039a40" type="list" content-type="string" key="flags"/>
1504
                      <value _ptr_="0xa3d42d0" type="list" content-type="string" key="flags"/>
1505 1505
                      <value type="int" key="isNotNull">0</value>
1506 1506
                      <value type="int" key="length">-1</value>
1507 1507
                      <value type="int" key="precision">-1</value>
......
1517 1517
                  <value type="string" key="defaultCharacterSetName">utf8</value>
1518 1518
                  <value type="string" key="defaultCollationName">utf8_bin</value>
1519 1519
                  <value type="int" key="delayKeyWrite">0</value>
1520
                  <value _ptr_="0xc038120" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
1520
                  <value _ptr_="0xa3db310" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
1521 1521
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8ce0b8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
1522 1522
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
1523
                      <value _ptr_="0xc039bb8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1523
                      <value _ptr_="0xad49ae8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1524 1524
                        <link type="object">be8cd956-a6e0-11e2-95e9-080027bcf912</link>
1525 1525
                      </value>
1526 1526
                      <value type="int" key="deferability">0</value>
......
1530 1530
                      <value type="int" key="many">1</value>
1531 1531
                      <value type="int" key="modelOnly">0</value>
1532 1532
                      <link type="object" struct-name="db.Table" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1533
                      <value _ptr_="0xc039f20" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1533
                      <value _ptr_="0xad49e40" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1534 1534
                        <link type="object">be8cc362-a6e0-11e2-95e9-080027bcf912</link>
1535 1535
                      </value>
1536 1536
                      <value type="int" key="referencedMandatory">1</value>
......
1540 1540
                      <value type="string" key="oldName">fk_record_source1</value>
1541 1541
                    </value>
1542 1542
                  </value>
1543
                  <value _ptr_="0xc038170" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
1543
                  <value _ptr_="0xa3db360" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
1544 1544
                    <value type="object" struct-name="db.mysql.Index" id="be8cdac8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
1545
                      <value _ptr_="0xc039fb0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1545
                      <value _ptr_="0xad49ed0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1546 1546
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cdc94-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
1547 1547
                          <value type="int" key="columnLength">0</value>
1548 1548
                          <value type="string" key="comment"></value>
......
1565 1565
                      <link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1566 1566
                    </value>
1567 1567
                    <value type="object" struct-name="db.mysql.Index" id="fbf69d1e-a79d-11e2-a346-080027bcf912" struct-checksum="0x309b847a">
1568
                      <value _ptr_="0xc03a390" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1568
                      <value _ptr_="0xa3d6710" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1569 1569
                        <value type="object" struct-name="db.mysql.IndexColumn" id="fecdc3c8-a79d-11e2-a346-080027bcf912" struct-checksum="0x62630b3c">
1570 1570
                          <value type="int" key="columnLength">0</value>
1571 1571
                          <value type="string" key="comment"></value>
......
1604 1604
                      <link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1605 1605
                    </value>
1606 1606
                    <value type="object" struct-name="db.mysql.Index" id="be8cddca-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
1607
                      <value _ptr_="0xc03aa70" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1607
                      <value _ptr_="0xa3d6dd0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1608 1608
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cdf82-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
1609 1609
                          <value type="int" key="columnLength">0</value>
1610 1610
                          <value type="string" key="comment"></value>
......
1634 1634
                  <value type="string" key="nextAutoInc"></value>
1635 1635
                  <value type="string" key="packKeys"></value>
1636 1636
                  <value type="int" key="partitionCount">0</value>
1637
                  <value _ptr_="0xc038220" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
1637
                  <value _ptr_="0xa3db410" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
1638 1638
                  <value type="string" key="partitionExpression"></value>
1639 1639
                  <value type="string" key="partitionType"></value>
1640 1640
                  <value type="string" key="password"></value>
......
1649 1649
                  <value type="string" key="tableDataDir"></value>
1650 1650
                  <value type="string" key="tableEngine">InnoDB</value>
1651 1651
                  <value type="string" key="tableIndexDir"></value>
1652
                  <value _ptr_="0xc0381c0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
1652
                  <value _ptr_="0xa3db3b0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
1653 1653
                  <value type="int" key="isStub">0</value>
1654 1654
                  <value type="int" key="isSystem">0</value>
1655 1655
                  <value type="int" key="isTemporary">0</value>
1656 1656
                  <value type="string" key="temporaryScope"></value>
1657 1657
                  <value type="int" key="commentedOut">0</value>
1658 1658
                  <value type="string" key="createDate">2013-04-16 14:58</value>
1659
                  <value _ptr_="0xc037ef8" type="dict" key="customData"/>
1659
                  <value _ptr_="0xa3db0e8" type="dict" key="customData"/>
1660 1660
                  <value type="string" key="lastChangeDate">2013-04-24 13:05</value>
1661 1661
                  <value type="int" key="modelOnly">0</value>
1662 1662
                  <value type="string" key="name">record</value>
......
1668 1668
                <value type="object" struct-name="db.mysql.Table" id="be8e3ecc-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
1669 1669
                  <value type="string" key="avgRowLength"></value>
1670 1670
                  <value type="int" key="checksum">0</value>
1671
                  <value _ptr_="0xc03b7c0" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
1671
                  <value _ptr_="0xad45148" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
1672 1672
                    <value type="object" struct-name="db.mysql.Column" id="be8e4142-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
1673 1673
                      <value type="int" key="autoIncrement">0</value>
1674 1674
                      <value type="string" key="characterSetName"></value>
1675
                      <value _ptr_="0xc03c310" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1675
                      <value _ptr_="0xa3d49a0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1676 1676
                      <value type="string" key="collationName"></value>
1677 1677
                      <value type="string" key="datatypeExplicitParams"></value>
1678 1678
                      <value type="string" key="defaultValue"></value>
1679 1679
                      <value type="int" key="defaultValueIsNull">0</value>
1680
                      <value _ptr_="0xc03c670" type="list" content-type="string" key="flags"/>
1680
                      <value _ptr_="0xa3d4d00" type="list" content-type="string" key="flags"/>
1681 1681
                      <value type="int" key="isNotNull">1</value>
1682 1682
                      <value type="int" key="length">767</value>
1683 1683
                      <value type="int" key="precision">-1</value>
......
1691 1691
                    <value type="object" struct-name="db.mysql.Column" id="978ed2dc-f9c4-11e2-9af4-080027bcf912" struct-checksum="0x783b5183">
1692 1692
                      <value type="int" key="autoIncrement">0</value>
1693 1693
                      <value type="string" key="characterSetName"></value>
1694
                      <value _ptr_="0xc03c7c0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1694
                      <value _ptr_="0xa3d4e50" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1695 1695
                      <value type="string" key="collationName"></value>
1696 1696
                      <value type="string" key="datatypeExplicitParams"></value>
1697 1697
                      <value type="string" key="defaultValue"></value>
1698 1698
                      <value type="int" key="defaultValueIsNull">0</value>
1699
                      <value _ptr_="0xc03cb20" type="list" content-type="string" key="flags"/>
1699
                      <value _ptr_="0xad459e8" type="list" content-type="string" key="flags"/>
1700 1700
                      <value type="int" key="isNotNull">1</value>
1701 1701
                      <value type="int" key="length">767</value>
1702 1702
                      <value type="int" key="precision">-1</value>
......
1710 1710
                    <value type="object" struct-name="db.mysql.Column" id="2f07bade-0127-11e3-9f3a-080027bcf912" struct-checksum="0x783b5183">
1711 1711
                      <value type="int" key="autoIncrement">0</value>
1712 1712
                      <value type="string" key="characterSetName"></value>
1713
                      <value _ptr_="0xc03cc70" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1713
                      <value _ptr_="0xad45b20" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1714 1714
                      <value type="string" key="collationName"></value>
1715 1715
                      <value type="string" key="datatypeExplicitParams"></value>
1716 1716
                      <value type="string" key="defaultValue"></value>
1717 1717
                      <value type="int" key="defaultValueIsNull">1</value>
1718
                      <value _ptr_="0xc03cff0" type="list" content-type="string" key="flags"/>
1718
                      <value _ptr_="0xad45ea0" type="list" content-type="string" key="flags"/>
1719 1719
                      <value type="int" key="isNotNull">0</value>
1720 1720
                      <value type="int" key="length">767</value>
1721 1721
                      <value type="int" key="precision">-1</value>
......
1729 1729
                    <value type="object" struct-name="db.mysql.Column" id="273737e8-a796-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
1730 1730
                      <value type="int" key="autoIncrement">0</value>
1731 1731
                      <value type="string" key="characterSetName"></value>
1732
                      <value _ptr_="0xc03d140" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1732
                      <value _ptr_="0xad45ff0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1733 1733
                      <value type="string" key="collationName"></value>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff