VegCore.my.sql/make ()

{

	echo_func; set_make_vars

}

export_mysql ()

-- Table structure for table "aggregate_observation"

--

CREATE TABLE "aggregate_observation" (

  "id" varbinary(767) NOT NULL,

  "taxon_concept" varbinary(767) NOT NULL,

-- Table structure for table "base_class"

--

CREATE TABLE "base_class" (

  "id" varbinary(767) NOT NULL,

  "referenced_class" varbinary(767) NOT NULL,

-- Table structure for table "collection"

--

CREATE TABLE "collection" (

  "id" varbinary(767) NOT NULL,

  "institution" varbinary(767) NOT NULL,

-- Table structure for table "community"

--

CREATE TABLE "community" (

  "id" varbinary(767) NOT NULL,

  "name" varbinary(767) NOT NULL,

-- Table structure for table "coordinates"

--

CREATE TABLE "coordinates" (

  "id" varbinary(767) NOT NULL,

  "latitude_deg" varbinary(767) DEFAULT NULL,

-- Table structure for table "derived_class"

--

CREATE TABLE "derived_class" (

  "id" varbinary(767) NOT NULL,

  PRIMARY KEY ("id"),

-- Table structure for table "event"

--

CREATE TABLE "event" (

  "id" varbinary(767) NOT NULL,

  "parent" varbinary(767) NOT NULL,

-- Table structure for table "event_participant"

--

CREATE TABLE "event_participant" (

  "event" varbinary(767) NOT NULL,

  "party" varbinary(767) NOT NULL,

-- Table structure for table "geological_context"

--

CREATE TABLE "geological_context" (

  "id" varbinary(767) NOT NULL,

  "name" varbinary(767) NOT NULL,

-- Table structure for table "geovalidation"

--

CREATE TABLE "geovalidation" (

  "id" varbinary(767) NOT NULL,

  "geovalid" tinyint(1) NOT NULL,

-- Table structure for table "individual"

--

CREATE TABLE "individual" (

  "id" varbinary(767) NOT NULL,

  "tag" varbinary(767) DEFAULT NULL,

-- Table structure for table "individual_observation"

--

CREATE TABLE "individual_observation" (

  "id" varbinary(767) NOT NULL,

  "individual" varbinary(767) DEFAULT NULL,

-- Table structure for table "method"

--

CREATE TABLE "method" (

  "id" varbinary(767) NOT NULL,

  "parent" varbinary(767) NOT NULL,

-- Table structure for table "organization"

--

CREATE TABLE "organization" (

  "id" varbinary(767) NOT NULL,

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

-- Table structure for table "parsed_taxon_assertion"

--

CREATE TABLE "parsed_taxon_assertion" (

  "id" varbinary(767) NOT NULL,

  "matched_taxon_concept" varbinary(767) DEFAULT NULL,

-- Table structure for table "party"

--

CREATE TABLE "party" (

  "id" varbinary(767) NOT NULL,

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

-- Table structure for table "place"

--

CREATE TABLE "place" (

  "id" varbinary(767) NOT NULL,

  "parent" varbinary(767) NOT NULL,

-- Table structure for table "place_observation"

--

CREATE TABLE "place_observation" (

  "id" varbinary(767) NOT NULL,

  "place" varbinary(767) NOT NULL,

-- Table structure for table "place_path"

--

CREATE TABLE "place_path" (

  "id" varbinary(767) NOT NULL,

  "continent" varbinary(767) DEFAULT NULL,

-- Table structure for table "plot"

--

CREATE TABLE "plot" (

  "id" varbinary(767) NOT NULL,

  "name" varbinary(767) DEFAULT NULL,

-- Table structure for table "project"

--

CREATE TABLE "project" (

  "id" varbinary(767) NOT NULL,

  "name" varbinary(767) NOT NULL,

-- Table structure for table "record"

--

CREATE TABLE "record" (

  "id" varbinary(767) NOT NULL,

  "source" varbinary(767) NOT NULL,

-- Table structure for table "referenced_class"

--

CREATE TABLE "referenced_class" (

  "id" varbinary(767) NOT NULL,

  PRIMARY KEY ("id"),

-- Table structure for table "relationship"

--

CREATE TABLE "relationship" (

  "id" varbinary(767) NOT NULL,

  "record" varbinary(767) NOT NULL,

-- Table structure for table "soil_observation"

--

CREATE TABLE "soil_observation" (

  "id" varbinary(767) NOT NULL,

  "observations" set('hstore') COLLATE utf8_bin DEFAULT NULL,

-- Table structure for table "source"

--

CREATE TABLE "source" (

  "id" varbinary(767) NOT NULL,

  "parent" varbinary(767) NOT NULL,

-- Table structure for table "specimen"

--

CREATE TABLE "specimen" (

  "id" varbinary(767) NOT NULL,

  "individual" varbinary(767) DEFAULT NULL,

-- Table structure for table "specimen_observation"

--

CREATE TABLE "specimen_observation" (

  "id" varbinary(767) NOT NULL,

  "specimen" varbinary(767) NOT NULL,

-- Table structure for table "stem"

--

CREATE TABLE "stem" (

  "id" varbinary(767) NOT NULL,

  "individual" varbinary(767) NOT NULL,

-- Table structure for table "stem_observation"

--

CREATE TABLE "stem_observation" (

  "id" varbinary(767) NOT NULL,

  "individual_observation" varbinary(767) NOT NULL,

-- Table structure for table "stratum"

--

CREATE TABLE "stratum" (

  "id" varbinary(767) NOT NULL,

  "name" varbinary(767) NOT NULL,

-- Table structure for table "subplot"

--

CREATE TABLE "subplot" (

  "id" varbinary(767) NOT NULL,

  "x_m" double DEFAULT NULL,

-- Table structure for table "taxon_assertion"

--

CREATE TABLE "taxon_assertion" (

  "id" varbinary(767) NOT NULL,

  "string" varbinary(767) NOT NULL,

-- Table structure for table "taxon_concept"

--

CREATE TABLE "taxon_concept" (

  "id" varbinary(767) NOT NULL,

  "according_to" varbinary(767) NOT NULL,

-- Table structure for table "taxon_determination"

--

CREATE TABLE "taxon_determination" (

  "id" varbinary(767) NOT NULL,

  "taxon_assertion" varbinary(767) NOT NULL,

-- Table structure for table "taxon_name"

--

CREATE TABLE "taxon_name" (

  "id" varbinary(767) NOT NULL,

  "unique_name" varbinary(767) NOT NULL,

-- Table structure for table "taxon_observation"

--

CREATE TABLE "taxon_observation" (

  "id" varbinary(767) NOT NULL,

  "taxon_occurrence" varbinary(767) NOT NULL,

-- Table structure for table "taxon_occurrence"

--

CREATE TABLE "taxon_occurrence" (

  "id" varbinary(767) NOT NULL,

  "current_determination" varbinary(767) DEFAULT NULL,

-- Table structure for table "taxon_path"

--

CREATE TABLE "taxon_path" (

  "id" varbinary(767) NOT NULL,

  "family" varbinary(767) DEFAULT NULL,

-- Table structure for table "taxon_presence"

--

CREATE TABLE "taxon_presence" (

  "id" varbinary(767) NOT NULL,

  "taxon_concept" varbinary(767) NOT NULL,

-- Table structure for table "taxon_string"

--

CREATE TABLE "taxon_string" (

  "string" varbinary(767) NOT NULL,

  "parsed_taxon_assertion" varbinary(767) DEFAULT NULL,

-- Table structure for table "validatable_place"

--

CREATE TABLE "validatable_place" (

  "id" varbinary(767) NOT NULL,

  "coordinates" varbinary(767) NOT NULL,

-- Table structure for table "aggregate_observation"

--

CREATE TABLE "aggregate_observation" (

  "id" bytea NOT NULL,

  "taxon_concept" bytea NOT NULL,

-- Table structure for table "base_class"

--

CREATE TABLE "base_class" (

  "id" bytea NOT NULL,

  "referenced_class" bytea NOT NULL,

-- Table structure for table "collection"

--

CREATE TABLE "collection" (

  "id" bytea NOT NULL,

  "institution" bytea NOT NULL,

-- Table structure for table "community"

--

CREATE TABLE "community" (

  "id" bytea NOT NULL,

  "name" bytea NOT NULL,

-- Table structure for table "coordinates"

--

CREATE TABLE "coordinates" (

  "id" bytea NOT NULL,

  "latitude_deg" bytea DEFAULT NULL,

-- Table structure for table "derived_class"

--

CREATE TABLE "derived_class" (

  "id" bytea NOT NULL,

  PRIMARY KEY ("id"),

-- Table structure for table "event"

--

CREATE TABLE "event" (

  "id" bytea NOT NULL,

  "parent" bytea NOT NULL,

-- Table structure for table "event_participant"

--

CREATE TABLE "event_participant" (

  "event" bytea NOT NULL,

  "party" bytea NOT NULL,

-- Table structure for table "geological_context"

--

CREATE TABLE "geological_context" (

  "id" bytea NOT NULL,

  "name" bytea NOT NULL,

-- Table structure for table "geovalidation"

--

CREATE TABLE "geovalidation" (

  "id" bytea NOT NULL,

  "geovalid" integer NOT NULL,

-- Table structure for table "individual"

--

CREATE TABLE "individual" (

  "id" bytea NOT NULL,

  "tag" bytea DEFAULT NULL,

-- Table structure for table "individual_observation"

--

CREATE TABLE "individual_observation" (

  "id" bytea NOT NULL,

  "individual" bytea DEFAULT NULL,

-- Table structure for table "method"

--

CREATE TABLE "method" (

  "id" bytea NOT NULL,

  "parent" bytea NOT NULL,

-- Table structure for table "organization"

--

CREATE TABLE "organization" (

  "id" bytea NOT NULL,

  "info" hstore DEFAULT NULL,

-- Table structure for table "parsed_taxon_assertion"

--

CREATE TABLE "parsed_taxon_assertion" (

  "id" bytea NOT NULL,

  "matched_taxon_concept" bytea DEFAULT NULL,

-- Table structure for table "party"

--

CREATE TABLE "party" (

  "id" bytea NOT NULL,

  "info" hstore DEFAULT NULL,

-- Table structure for table "place"

--

CREATE TABLE "place" (

  "id" bytea NOT NULL,

  "parent" bytea NOT NULL,

-- Table structure for table "place_observation"

--

CREATE TABLE "place_observation" (

  "id" bytea NOT NULL,

  "place" bytea NOT NULL,

-- Table structure for table "place_path"

--

CREATE TABLE "place_path" (

  "id" bytea NOT NULL,

  "continent" bytea DEFAULT NULL,

-- Table structure for table "plot"

--

CREATE TABLE "plot" (

  "id" bytea NOT NULL,

  "name" bytea DEFAULT NULL,

-- Table structure for table "project"

--

CREATE TABLE "project" (

  "id" bytea NOT NULL,

  "name" bytea NOT NULL,

-- Table structure for table "record"

--

CREATE TABLE "record" (

  "id" bytea NOT NULL,

  "source" bytea NOT NULL,

-- Table structure for table "referenced_class"

--

CREATE TABLE "referenced_class" (

  "id" bytea NOT NULL,

  PRIMARY KEY ("id"),

-- Table structure for table "relationship"

--

CREATE TABLE "relationship" (

  "id" bytea NOT NULL,

  "record" bytea NOT NULL,

-- Table structure for table "soil_observation"

--

CREATE TABLE "soil_observation" (

  "id" bytea NOT NULL,

  "observations" hstore DEFAULT NULL,

-- Table structure for table "source"

--

CREATE TABLE "source" (

  "id" bytea NOT NULL,

  "parent" bytea NOT NULL,

-- Table structure for table "specimen"

--

CREATE TABLE "specimen" (

  "id" bytea NOT NULL,

  "individual" bytea DEFAULT NULL,

-- Table structure for table "specimen_observation"

--

CREATE TABLE "specimen_observation" (

  "id" bytea NOT NULL,

  "specimen" bytea NOT NULL,

-- Table structure for table "stem"

--

CREATE TABLE "stem" (

  "id" bytea NOT NULL,

  "individual" bytea NOT NULL,

-- Table structure for table "stem_observation"

--

CREATE TABLE "stem_observation" (

  "id" bytea NOT NULL,

  "individual_observation" bytea NOT NULL,

-- Table structure for table "stratum"

--

CREATE TABLE "stratum" (

  "id" bytea NOT NULL,

  "name" bytea NOT NULL,

-- Table structure for table "subplot"

--

CREATE TABLE "subplot" (

  "id" bytea NOT NULL,

  "x_m" double precision DEFAULT NULL,

-- Table structure for table "taxon_assertion"

--

CREATE TABLE "taxon_assertion" (

  "id" bytea NOT NULL,

  "string" bytea NOT NULL,

-- Table structure for table "taxon_concept"

--

CREATE TABLE "taxon_concept" (

  "id" bytea NOT NULL,

  "according_to" bytea NOT NULL,

-- Table structure for table "taxon_determination"

--

CREATE TABLE "taxon_determination" (

  "id" bytea NOT NULL,

  "taxon_assertion" bytea NOT NULL,

-- Table structure for table "taxon_name"

--

CREATE TABLE "taxon_name" (

  "id" bytea NOT NULL,

  "unique_name" bytea NOT NULL,

-- Table structure for table "taxon_observation"

--

CREATE TABLE "taxon_observation" (

  "id" bytea NOT NULL,

  "taxon_occurrence" bytea NOT NULL,

-- Table structure for table "taxon_occurrence"

--

CREATE TABLE "taxon_occurrence" (

  "id" bytea NOT NULL,

  "current_determination" bytea DEFAULT NULL,

-- Table structure for table "taxon_path"

--

CREATE TABLE "taxon_path" (

  "id" bytea NOT NULL,

  "family" bytea DEFAULT NULL,

-- Table structure for table "taxon_presence"

--

CREATE TABLE "taxon_presence" (

  "id" bytea NOT NULL,

  "taxon_concept" bytea NOT NULL,

-- Table structure for table "taxon_string"

--

CREATE TABLE "taxon_string" (

  "string" bytea NOT NULL,

  "parsed_taxon_assertion" bytea DEFAULT NULL,

-- Table structure for table "validatable_place"

--

CREATE TABLE "validatable_place" (

  "id" bytea NOT NULL,

  "coordinates" bytea NOT NULL,