CREATE TABLE "georeferencing" (

  "id" text NOT NULL,

  "input_place" text NOT NULL,

  "georeferenced_by" text DEFAULT NULL,

  "info" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_georef_place1_idx" ("input_place")*/CHECK (true),

CREATE TABLE "geovalidation" (

  "id" text NOT NULL,

  "input_geoplace" text NOT NULL,

  "geovalid" integer NOT NULL,

  "lat_long_domain_valid" integer NOT NULL,

  "lat_long_in_place_ranks" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_geovalidation_geoplace1_idx" ("input_geoplace")*/CHECK (true),

  /*KEY "fk_geovalidation_geoplace2_idx" ("corrected_geoplace")*/CHECK (true),

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "taxon_determination" (

  "id" text NOT NULL,

  "identified_by" text DEFAULT NULL,

  "fit_info" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "taxon_determination_unique" */UNIQUE ("taxon_assertion","identified_by"),

  /*KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion")*/CHECK (true),

  /*KEY "fk_taxon_determination_party_list1_idx" ("identified_by")*/CHECK (true),

  /*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

                      <value type="string" key="oldName">id</value>

                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>

                    </value>

                      <value type="int" key="autoIncrement">0</value>

                      <value type="string" key="characterSetName"></value>

                      <value type="string" key="collationName"></value>

                      <value type="string" key="datatypeExplicitParams"></value>

                      <value type="string" key="defaultValue"></value>

                      <value type="int" key="length">767</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

                      <value type="string" key="comment"></value>

                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>

                    </value>

                      <value type="int" key="autoIncrement">0</value>

                      <value type="string" key="characterSetName"></value>

                      <value type="string" key="collationName"></value>

                      <value type="string" key="datatypeExplicitParams"></value>

                      <value type="string" key="defaultValue"></value>

                      <value type="int" key="length">767</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

                      <value type="string" key="comment"></value>

                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="3d9b1d28-a7a1-11e2-b667-080027bcf912" struct-checksum="0x783b5183">

                  <value type="int" key="commentedOut">0</value>

                  <value type="string" key="createDate">2013-04-17 13:56</value>

                  <value _ptr_="0xafc5928" type="dict" key="customData"/>

                  <value type="int" key="modelOnly">0</value>

                  <value type="string" key="name">taxon_determination</value>

                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>

                      <value type="string" key="oldName">input_geoplace</value>

                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="a8348424-a78f-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">

                      <value type="int" key="autoIncrement">0</value>

                      <value type="string" key="characterSetName"></value>

                      <value type="string" key="oldName">lat_long_in_place_ranks</value>

                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>

                    </value>

                  </value>

                  <value type="string" key="connectionString"></value>

                  <value type="string" key="defaultCharacterSetName">utf8</value>

                  <value type="int" key="commentedOut">0</value>

                  <value type="string" key="createDate">2013-04-16 14:58</value>

                  <value _ptr_="0xb00bd80" type="dict" key="customData"/>

                  <value type="int" key="modelOnly">0</value>

                  <value type="string" key="name">geovalidation</value>

                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>

                      <value type="string" key="oldName">input_place</value>

                      <link type="object" struct-name="GrtObject" key="owner">83dbd4da-f6e8-11e2-9cf1-080027bcf912</link>

                    </value>

                      <value type="int" key="autoIncrement">0</value>

                      <value type="string" key="characterSetName"></value>

                      <value type="string" key="collationName"></value>

                      <value type="string" key="datatypeExplicitParams"></value>

                      <value type="string" key="defaultValue"></value>

                      <value type="int" key="defaultValueIsNull">1</value>

                      <value type="int" key="isNotNull">0</value>

                      <value type="int" key="length">767</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

                      <value type="string" key="comment"></value>

                      <link type="object" struct-name="GrtObject" key="owner">83dbd4da-f6e8-11e2-9cf1-080027bcf912</link>

                    </value>

                      <value type="int" key="autoIncrement">0</value>

                      <value type="string" key="characterSetName"></value>

                      <value type="string" key="collationName"></value>

                      <value type="string" key="datatypeExplicitParams"></value>

                      <value type="string" key="defaultValue"></value>

                      <value type="int" key="defaultValueIsNull">1</value>

                      <value type="int" key="isNotNull">0</value>

                      <value type="int" key="length">767</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

                      <value type="string" key="comment"></value>

                      <link type="object" struct-name="GrtObject" key="owner">83dbd4da-f6e8-11e2-9cf1-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="4f2d2f86-f986-11e2-8a2e-080027bcf912" struct-checksum="0x783b5183">

                  <value type="int" key="commentedOut">0</value>

                  <value type="string" key="createDate">2013-04-16 14:58</value>

                  <value _ptr_="0xb01fda0" type="dict" key="customData"/>

                  <value type="int" key="modelOnly">0</value>

                  <value type="string" key="name">georeferencing</value>

                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>

        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>

        <value _ptr_="0xaf95e80" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>

        <value _ptr_="0xa8c7ed8" type="dict" key="syncProfiles">

              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>

              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>

              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>

    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">

      <value type="string" key="author">Aaron Marcuse-Kubitza</value>

      <value type="string" key="caption">New Model</value>

      <value type="string" key="dateCreated">2012-01-19 14:06</value>

      <value type="string" key="description"></value>

      <value type="string" key="project">Name of the project</value>

CREATE TABLE `georeferencing` (

  `id` varbinary(767) NOT NULL,

  `input_place` varbinary(767) NOT NULL,

  `georeferenced_by` varbinary(767) DEFAULT NULL,

  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_georef_place1_idx` (`input_place`),

CREATE TABLE `geovalidation` (

  `id` varbinary(767) NOT NULL,

  `input_geoplace` varbinary(767) NOT NULL,

  `geovalid` tinyint(1) NOT NULL,

  `lat_long_domain_valid` tinyint(1) NOT NULL,

  `lat_long_in_place_ranks` set('hstore') COLLATE utf8_bin DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_geovalidation_geoplace1_idx` (`input_geoplace`),

  KEY `fk_geovalidation_geoplace2_idx` (`corrected_geoplace`),

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `taxon_determination` (

  `id` varbinary(767) NOT NULL,

  `identified_by` varbinary(767) DEFAULT NULL,

  `fit_info` set('hstore') COLLATE utf8_bin DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `taxon_determination_unique` (`taxon_assertion`,`identified_by`),

  KEY `fk_taxon_occurrence_has_qualified_taxon1_idx` (`taxon_assertion`),

  KEY `fk_taxon_determination_party_list1_idx` (`identified_by`),

  CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]';

/*!40101 SET character_set_client = @saved_cs_client */;