SET standard_conforming_strings = off;

SET escape_string_warning = off;

-- MySQL dump 10.13  Distrib 5.5.29, for debian-linux-gnu (x86_64)

--

-- Host: localhost    Database: BRIT

  "year_birth" integer DEFAULT NULL,

  "year_death" integer DEFAULT NULL,

  "notes" text,

  "added_by_signon" varchar(30) DEFAULT NULL,

  "updated_by_signon" varchar(30) DEFAULT NULL,

  PRIMARY KEY ("agent_id"),

  /*KEY "collector_abbrev_name" ("collector_abbrev_name")*/CHECK (true)

  "field_authority" varchar(100) DEFAULT NULL,

  "field_authority_uri" varchar(256) DEFAULT NULL,

  "added_by_signon" varchar(30) DEFAULT NULL,

  "updated_by_signon" varchar(30) DEFAULT NULL,

  PRIMARY KEY ("definition_id")

);

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

  "group_weight" integer DEFAULT NULL,

  "description" text,

  "added_by_signon" varchar(30) DEFAULT NULL,

  "updated_by_signon" varchar(30) DEFAULT NULL,

  PRIMARY KEY ("group_id")

);

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

  "key_flag" integer DEFAULT NULL,

  "filter_flag" integer DEFAULT NULL,

  "added_by_signon" varchar(30) DEFAULT NULL,

  "updated_by_signon" varchar(30) DEFAULT NULL,

  PRIMARY KEY ("structure_id")

);

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "custom_fields_datetime" (

  "id" integer NOT NULL,

  PRIMARY KEY ("id")

);

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "debug_output" (

  "debug_string" varchar(120) DEFAULT NULL,

);

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

  "veg_survey_id" integer DEFAULT NULL,

  "taxon_id" integer DEFAULT NULL,

  "added_by_signon" varchar(30) DEFAULT NULL,

  "updated_by_signon" varchar(30) DEFAULT NULL,

  PRIMARY KEY ("Image_ID"),

  /*CONSTRAINT "XPKImages" */UNIQUE ("Image_ID"),

  /*KEY "Collection_LSID" ("collection_lsid_object_id")*/CHECK (true),

  "EastBL" float DEFAULT NULL,

  "NorthBL" float DEFAULT NULL,

  "SouthBL" float DEFAULT NULL,

  "SpatRepTypeCd" varchar(20) DEFAULT NULL,

  "ContentType" integer DEFAULT NULL,

  "ImageType" varchar(20) DEFAULT NULL,

CREATE TABLE "meteo_data" (

  "Meteo_Data_ID" bigint NOT NULL,

  "Station_ID" integer NOT NULL DEFAULT '0',

  "Temperature" float DEFAULT NULL,

  "Precipitation" float DEFAULT NULL,

  "Humidity" float DEFAULT NULL,

  "credibility_rating" varchar(40) DEFAULT NULL,

  "taxon_authority" varchar(50) DEFAULT NULL,

  "taxon_lsid" varchar(50) DEFAULT NULL,

  "added_by_signon" varchar(30) DEFAULT NULL,

  "updated_by_signon" varchar(30) DEFAULT NULL,

  "author" varchar(255) DEFAULT NULL,

  "old_id" integer DEFAULT NULL,

  "language_id" integer DEFAULT NULL,

  "common_name" varchar(100) DEFAULT NULL,

  "notes" text,

  "added_by_signon" varchar(60) DEFAULT NULL,

  "updated_by_signon" varchar(60) DEFAULT NULL,

  PRIMARY KEY ("taxon_common_name_id"),

  /*CONSTRAINT "XPKLocal_Names" */UNIQUE ("taxon_common_name_id")

CREATE TABLE "taxon_synonym" (

  "taxon_id" integer DEFAULT NULL,

  "accepted_taxon_id" integer DEFAULT NULL,

  "added_by_signon" varchar(30) DEFAULT NULL,

  "updated_by_signon" varchar(30) DEFAULT NULL

);

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

  "filename" varchar(150) DEFAULT NULL,

  "records_processed" integer DEFAULT NULL,

  "status" varchar(50) DEFAULT NULL,

);

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

  "measurement" text,

  "pi" text,

  "lab" text,

  "x" float DEFAULT NULL,

  "y" float DEFAULT NULL,

  "ph_h20" float DEFAULT NULL,

  "project_id" integer DEFAULT NULL,

  "principal_investigator" text,

  "investigators" text,

  "notes" text,

  "veg_unit_id" integer DEFAULT NULL,

  /*CONSTRAINT "veg_survey_id" */UNIQUE ("veg_survey_id"),

  "veg_unit_id" integer NOT NULL,

  "veg_unit_name" varchar(60) DEFAULT NULL,

  "veg_unit_code" varchar(10) DEFAULT NULL,

  "description" text,

  "location_notes" text,

  "research_site_id" integer DEFAULT NULL,

  "minDistKm" integer DEFAULT NULL,

  "countryID" integer DEFAULT NULL,

  PRIMARY KEY ("objectID"),

);

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

  "isNewWorld" varchar(255) DEFAULT NULL,

  "countryNameStd" varchar(255) DEFAULT NULL,

  PRIMARY KEY ("countryID"),

);

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

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

CREATE TABLE "ipr" (

  "IPR_ID" integer NOT NULL DEFAULT '0',

  "ipr_general" text NOT NULL,

  "ipr_updated_by" varchar(50) NOT NULL DEFAULT '',

  "ipr_general_version" varchar(10) NOT NULL DEFAULT '',

  PRIMARY KEY ("IPR_ID")

  "id" integer NOT NULL,

  "version" varchar(5) NOT NULL DEFAULT '',

  "filename" varchar(30) NOT NULL DEFAULT '',

  "status" char(1) NOT NULL DEFAULT 'A',

  "ipr_brief_text" text,

  PRIMARY KEY ("id")

  "username" varchar(30) NOT NULL DEFAULT '',

  "licence_id" integer NOT NULL DEFAULT '0',

  "accepted" char(1) NOT NULL DEFAULT '',

);

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

  "dl_login_id" bigint NOT NULL DEFAULT '0',

  "dl_target" varchar(50) NOT NULL DEFAULT '',

  "dl_target_url" varchar(250) NOT NULL DEFAULT '',

  PRIMARY KEY ("dl_id")

);

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

  "institution" varchar(200) DEFAULT NULL,

  "email" varchar(200) NOT NULL DEFAULT '',

  "comments" bytea,

  PRIMARY KEY ("dl_login_id")

);

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

  "project_pi" varchar(30) NOT NULL DEFAULT '',

  "allow_download_all" integer NOT NULL DEFAULT '0',

  "ipr_specific" text,

  PRIMARY KEY ("project_id"),

  /*KEY "project_name" ("project_name")*/CHECK (true),

  /*KEY "on_project_list" ("allow_download_all")*/CHECK (true),

  "address" varchar(255) DEFAULT NULL,

  "email" varchar(255) DEFAULT NULL,

  "telephone" varchar(255) DEFAULT NULL,

  PRIMARY KEY ("id")

);

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

  "species_count" integer DEFAULT '0',

  "occurrence_count" integer DEFAULT '0',

  "occurrence_coordinate_count" integer DEFAULT '0',

  "iso_country_code" char(2) DEFAULT NULL,

  "stated_count_served" integer DEFAULT NULL,

  "gbif_approver" varchar(255) DEFAULT NULL,

  "occurrence_count" integer DEFAULT '0',

  "occurrence_coordinate_count" integer DEFAULT '0',

  "basis_of_record" integer NOT NULL DEFAULT '0',

  "citable_agent" varchar(255) DEFAULT NULL,

  "root_taxon_rank" integer DEFAULT NULL,

  "root_taxon_name" varchar(150) DEFAULT NULL,

  "species_count" integer DEFAULT '0',

  "occurrence_count" integer DEFAULT '0',

  "occurrence_coordinate_count" integer DEFAULT '0',

  "iso_country_code" char(2) DEFAULT NULL,

  "stated_count_served" integer DEFAULT NULL,

  "gbif_approver" varchar(255) DEFAULT NULL,

  "occurrence_count" integer DEFAULT '0',

  "occurrence_coordinate_count" integer DEFAULT '0',

  "basis_of_record" integer NOT NULL DEFAULT '0',

  "citable_agent" varchar(255) DEFAULT NULL,

  "root_taxon_rank" integer DEFAULT NULL,

  "root_taxon_name" varchar(150) DEFAULT NULL,

  "message" text,

  "restricted" integer DEFAULT NULL,

  "count" integer DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "log_group_id" ("log_group_id")*/CHECK (true),

  /*KEY "portal_instance_id" ("portal_instance_id")*/CHECK (true),

  "type" integer DEFAULT NULL,

  "lower_value" varchar(255) DEFAULT NULL,

  "upper_value" varchar(255) DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "IX_indexing_data_1" ("resource_access_point_id")*/CHECK (true),

  /*KEY "IX_indexing_data_2" ("started")*/CHECK (true)

  "mod360_cell_id" integer DEFAULT NULL,

  "year" integer DEFAULT NULL,

  "month" integer DEFAULT NULL,

  "basis_of_record" integer NOT NULL DEFAULT '0',

  "taxonomic_issue" integer NOT NULL DEFAULT '0',

  "geospatial_issue" integer DEFAULT NULL,

  "other_issue" integer NOT NULL DEFAULT '0',

  "altitude_metres" integer DEFAULT NULL,

  "depth_centimetres" integer DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "ix_or_data_provider_id" ("data_provider_id")*/CHECK (true),

  /*KEY "ix_or_data_resource_id" ("data_resource_id")*/CHECK (true),

  "day" varchar(50) DEFAULT NULL,

  "basis_of_record" varchar(100) DEFAULT NULL,

  "identifier_name" varchar(255) DEFAULT NULL,

  "unit_qualifier" varchar(255) DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "primarykey" ("id")*/CHECK (true),

  /*KEY "created" ("created","modified")*/CHECK (true),

  "taxon_concept_id" integer NOT NULL,

  "remote_id" varchar(255) DEFAULT NULL,

  "id_type" integer NOT NULL,

  PRIMARY KEY ("id"),

  /*KEY "ix_remote_concept_remote_id" ("remote_id")*/CHECK (true),

  /*KEY "ix_remote_concept_tc_id" ("taxon_concept_id")*/CHECK (true)

  "url" varchar(255) DEFAULT NULL,

  "remote_id_at_url" varchar(255) DEFAULT NULL,

  "uuid" char(50) DEFAULT NULL,

  "supports_date_last_modified" integer NOT NULL DEFAULT '0',

  "interval_metadata_days" integer DEFAULT NULL,

  "interval_harvest_days" integer DEFAULT NULL,

  "species_count" integer DEFAULT '0',

  "occurrence_count" integer DEFAULT '0',

  "occurrence_coordinate_count" integer DEFAULT '0',

  "data_resource_count" integer DEFAULT '0',

  PRIMARY KEY ("id"),

  /*KEY "IX_resource_network_name" ("name")*/CHECK (true)

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "rollover" (

  "id" integer NOT NULL,

  PRIMARY KEY ("id")

);

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

  "dataset_count" integer DEFAULT '0',

  "occurrence_count" integer DEFAULT '0',

  "occurrence_georeferenced_count" integer DEFAULT '0',

  PRIMARY KEY ("id")

);

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

  "dataset_count" integer DEFAULT '0',

  "occurrence_count" integer DEFAULT '0',

  "occurrence_georeferenced_count" integer DEFAULT '0',

  PRIMARY KEY ("id")

);

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

  "partner_concept_id" integer DEFAULT NULL,

  "priority" integer NOT NULL DEFAULT '100',

  "is_secondary" integer DEFAULT '0',

  PRIMARY KEY ("id"),

  /*KEY "ix_taxon_concept_dr_rank" ("data_resource_id","rank")*/CHECK (true),

  /*KEY "ix_taxon_concept_partner_dr" ("partner_concept_id","data_resource_id")*/CHECK (true),

  "id" integer NOT NULL,

  "tag_id" integer DEFAULT NULL,

  "entity_id" integer DEFAULT NULL,

  "is_system_generated" bit(1) DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "id" ("id")*/CHECK (true)

SET standard_conforming_strings = off;

SET escape_string_warning = off;

-- MySQL dump 10.13  Distrib 5.1.66, for debian-linux-gnu (x86_64)

--

-- Host: localhost    Database: ua_herbarium

  "collnumsuffix" varchar(10) DEFAULT NULL,

  "collnumber_full" varchar(100) DEFAULT NULL,

  "other_collectors" varchar(200) DEFAULT NULL,

  "month_collected" varchar(15) DEFAULT NULL,

  "day_collected" integer DEFAULT NULL,

  "year_collected" integer DEFAULT NULL,

  "project" varchar(50) DEFAULT NULL,

  "dups_to" varchar(180) DEFAULT NULL,

  "herb_acro" varchar(50) DEFAULT NULL,

  "entered_by" varchar(60) DEFAULT NULL,

  "download_source" varchar(50) DEFAULT NULL,

  "old_dbsn" integer DEFAULT NULL,

  "land_ownership" varchar(100) DEFAULT NULL,

  "coord_source" varchar(100) DEFAULT NULL,

  "georeferenceverificationstatus" varchar(150) DEFAULT NULL,

  "is_duplicate" integer DEFAULT NULL,

  "deleted" integer NOT NULL DEFAULT '0',

  "deleted_reason" varchar(250) DEFAULT NULL,

  "det_day" integer DEFAULT NULL,

  "det_mo" integer DEFAULT NULL,

  "det_yr" integer DEFAULT NULL,

  "parentid" integer NOT NULL,

  "tid" integer DEFAULT NULL,

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("stmtid"),

  /*KEY "FK_chotomouskey_taxa" ("tid")*/CHECK (true),

  /*CONSTRAINT "FK_chotomouskey_taxa" FOREIGN KEY ("tid") REFERENCES "taxa" ("TID")*/CHECK (true)

  "uid" integer DEFAULT NULL,

  "SortSequence" integer NOT NULL DEFAULT '50',

  "expiration" integer DEFAULT NULL,

  PRIMARY KEY ("CLID"),

  /*KEY "FK_checklists_uid" ("uid")*/CHECK (true),

  /*KEY "name" ("Name","Type")*/CHECK (true),

  "decimallatitude" double precision NOT NULL,

  "decimallongitude" double precision NOT NULL,

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("chklstcoordid"),

  /*CONSTRAINT "IndexUnique" */UNIQUE ("clid","tid","decimallatitude","decimallongitude"),

  /*KEY "FKchklsttaxalink" ("clid","tid")*/CHECK (true),

CREATE TABLE "fmchklstprojlink" (

  "pid" integer NOT NULL,

  "clid" integer NOT NULL,

  PRIMARY KEY ("pid","clid"),

  /*KEY "FK_chklst" ("clid")*/CHECK (true),

  /*CONSTRAINT "FK_chklstprojlink_clid" FOREIGN KEY ("clid") REFERENCES "fmchecklists" ("CLID")*/CHECK (true),

  "Nativity" varchar(50) DEFAULT NULL,

  "Endemic" varchar(25) DEFAULT NULL,

  "internalnotes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("TID","CLID","morphospecies"),

  /*KEY "FK_chklsttaxalink_cid" ("CLID")*/CHECK (true),

  /*CONSTRAINT "FK_chklsttaxalink_cid" FOREIGN KEY ("CLID") REFERENCES "fmchecklists" ("CLID")*/CHECK (true),

  "uid" integer NOT NULL,

  "ispublic" integer NOT NULL DEFAULT '1',

  "parentid" integer DEFAULT NULL,

  PRIMARY KEY ("cltaxacommentsid"),

  /*KEY "FK_clcomment_users" ("uid")*/CHECK (true),

  /*KEY "FK_clcomment_cltaxa" ("clid","tid")*/CHECK (true),

  "uid" varchar(45) DEFAULT NULL,

  "type" varchar(45) NOT NULL DEFAULT 'DynamicList',

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("dynclid")

);

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

CREATE TABLE "fmdyncltaxalink" (

  "dynclid" integer NOT NULL,

  "tid" integer NOT NULL,

  PRIMARY KEY ("dynclid","tid"),

  /*KEY "FK_dyncltaxalink_taxa" ("tid")*/CHECK (true),

  /*CONSTRAINT "FK_dyncltaxalink_dynclid" FOREIGN KEY ("dynclid") REFERENCES "fmdynamicchecklists" ("dynclid") ON DELETE CASCADE*/CHECK (true),

  "ispublic" integer NOT NULL DEFAULT '0',

  "parentpid" integer DEFAULT NULL,

  "SortSequence" integer NOT NULL DEFAULT '50',

  PRIMARY KEY ("pid"),

  /*KEY "FK_parentpid_proj" ("parentpid")*/CHECK (true),

  /*CONSTRAINT "FK_parentpid_proj" FOREIGN KEY ("parentpid") REFERENCES "fmprojects" ("pid") ON DELETE NO ACTION ON UPDATE NO ACTION*/CHECK (true)

  "Collector" varchar(100) NOT NULL,

  "editornotes" varchar(50) DEFAULT NULL,

  "Notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("occid","CLID","TID"),

  /*KEY "chklst_taxavouchers" ("TID","CLID")*/CHECK (true),

  /*CONSTRAINT "FK_fmvouchers_occ" FOREIGN KEY ("occid") REFERENCES "omoccurrences" ("occid")*/CHECK (true),

  "code" varchar(45) DEFAULT NULL,

  "lookupterm" integer NOT NULL DEFAULT '1',

  "acceptedid" integer DEFAULT NULL,

  PRIMARY KEY ("gtcid"),

  /*KEY "FK_geothescontinent_accepted_idx" ("acceptedid")*/CHECK (true),

  /*CONSTRAINT "FK_geothescontinent_accepted" FOREIGN KEY ("acceptedid") REFERENCES "geothescontinent" ("gtcid")*/CHECK (true)

  "lookupterm" integer NOT NULL DEFAULT '1',

  "acceptedid" integer DEFAULT NULL,

  "continentid" integer DEFAULT NULL,

  PRIMARY KEY ("gtcid"),

  /*KEY "FK_geothescountry__idx" ("continentid")*/CHECK (true),

  /*KEY "FK_geothescountry_parent_idx" ("acceptedid")*/CHECK (true),

  "lookupterm" integer NOT NULL DEFAULT '1',

  "acceptedid" integer DEFAULT NULL,

  "stateid" integer DEFAULT NULL,

  PRIMARY KEY ("gtcoid"),

  /*KEY "FK_geothescounty_state_idx" ("stateid")*/CHECK (true),

  /*KEY "FK_geothescounty_accepted_idx" ("acceptedid")*/CHECK (true),

  "lookupterm" integer NOT NULL DEFAULT '1',

  "acceptedid" integer DEFAULT NULL,

  "countyid" integer DEFAULT NULL,

  PRIMARY KEY ("gtmid"),

  /*KEY "FK_geothesmunicipality_county_idx" ("countyid")*/CHECK (true),

  /*KEY "FK_geothesmunicipality_accepted_idx" ("acceptedid")*/CHECK (true),

  "lookupterm" integer NOT NULL DEFAULT '1',

  "acceptedid" integer DEFAULT NULL,

  "countryid" integer DEFAULT NULL,

  PRIMARY KEY ("gtspid"),

  /*KEY "FK_geothesstate_country_idx" ("countryid")*/CHECK (true),

  /*KEY "FK_geothesstate_accepted_idx" ("acceptedid")*/CHECK (true),

  "source" varchar(45) DEFAULT NULL,

  "notes" varchar(250) DEFAULT NULL,

  "uid" integer DEFAULT NULL,

  PRIMARY KEY ("glossid"),

  /*CONSTRAINT "Index_term" */UNIQUE ("term")

);

  "catid" integer NOT NULL,

  "catagory" varchar(45) NOT NULL,

  "language" varchar(45) NOT NULL DEFAULT 'English',

  PRIMARY KEY ("catid")

);

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

CREATE TABLE "glossarycatlink" (

  "glossid" integer NOT NULL,

  "catid" integer NOT NULL,

  PRIMARY KEY ("glossid","catid"),

  /*KEY "FK_glossarycatlink_cat" ("catid")*/CHECK (true),

  /*CONSTRAINT "glossarycatlink_ibfk_1" FOREIGN KEY ("catid") REFERENCES "glossarycatagories" ("catid")*/CHECK (true),

  "structures" varchar(150) DEFAULT NULL,

  "notes" varchar(250) DEFAULT NULL,

  "uid" integer DEFAULT NULL,

  PRIMARY KEY ("glimgid"),

  /*KEY "FK_glossaryimages_gloss" ("glossid")*/CHECK (true),

  /*CONSTRAINT "glossaryimages_ibfk_1" FOREIGN KEY ("glossid") REFERENCES "glossary" ("glossid") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

CREATE TABLE "imageannotations" (

  "tid" integer DEFAULT NULL,

  "imgid" integer NOT NULL DEFAULT '0',

  "Annotator" varchar(100) DEFAULT NULL,

  PRIMARY KEY ("imgid","AnnDate"),

  /*KEY "TID" ("tid")*/CHECK (true),

  /*CONSTRAINT "FK_resourceannotations_imgid" FOREIGN KEY ("imgid") REFERENCES "images" ("imgid")*/CHECK (true),

  "anatomy" varchar(100) DEFAULT NULL,

  "username" varchar(45) DEFAULT NULL,

  "sortsequence" integer NOT NULL DEFAULT '50',

  PRIMARY KEY ("imgid"),

  /*KEY "Index_tid" ("tid")*/CHECK (true),

  /*KEY "FK_images_occ" ("occid")*/CHECK (true),

  "Email" varchar(45) DEFAULT NULL,

  "Url" varchar(250) DEFAULT NULL,

  "Notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("iid"),

  /*CONSTRAINT "Index_instcode" */UNIQUE ("InstitutionCode")

);

  "notes" varchar(255) DEFAULT NULL,

  "description" varchar(255) DEFAULT NULL,

  "helpurl" varchar(500) DEFAULT NULL,

  PRIMARY KEY ("cid","language"),

  /*CONSTRAINT "kmcharacterlang_ibfk_1" FOREIGN KEY ("cid") REFERENCES "kmcharacters" ("cid")*/CHECK (true)

);

  "helpurl" varchar(500) DEFAULT NULL,

  "enteredby" varchar(45) DEFAULT NULL,

  "sortsequence" integer DEFAULT NULL,

  PRIMARY KEY ("cid"),

  /*KEY "Index_charname" ("charname")*/CHECK (true),

  /*KEY "Index_sort" ("sortsequence")*/CHECK (true)

  "CID" integer NOT NULL,

  "CIDDependance" integer NOT NULL,

  "CSDependance" varchar(16) NOT NULL,

  PRIMARY KEY ("CSDependance","CIDDependance","CID"),

  /*KEY "FK_chardependance_cid" ("CID")*/CHECK (true),

  /*KEY "FK_chardependance_2" ("CIDDependance")*/CHECK (true),

  "language" varchar(45) NOT NULL DEFAULT 'English',

  "notes" text,

  "sortsequence" integer DEFAULT NULL,

  PRIMARY KEY ("hid","language"),

  /*KEY "HeadingName" ("headingname")*/CHECK (true)

);

  "HID" integer NOT NULL DEFAULT '0',

  "CID" integer NOT NULL DEFAULT '0',

  "Notes" varchar(255) DEFAULT NULL,

  PRIMARY KEY ("HID","CID"),

  /*KEY "CharactersCharHeadingLinker" ("CID")*/CHECK (true),

  /*KEY "CharHeadingCharHeadingLinker" ("HID")*/CHECK (true),

  "Notes" varchar(255) DEFAULT NULL,

  "Relation" varchar(45) NOT NULL DEFAULT 'include',

  "EditabilityInherited" bit(1) DEFAULT NULL,

  PRIMARY KEY ("CID","TID"),

  /*KEY "FK_CharTaxaLink-TID" ("TID")*/CHECK (true),

  /*CONSTRAINT "kmchartaxalink_ibfk_1" FOREIGN KEY ("CID") REFERENCES "kmcharacters" ("cid")*/CHECK (true),

  "StateID" integer DEFAULT NULL,

  "Language" varchar(45) NOT NULL DEFAULT 'English',

  "SortSequence" integer DEFAULT NULL,

  "EnteredBy" varchar(45) DEFAULT NULL,

  PRIMARY KEY ("cs","cid"),

  /*KEY "FK_cs_chars" ("cid")*/CHECK (true),

  "notes" varchar(250) DEFAULT NULL,

  "sortsequence" varchar(45) NOT NULL DEFAULT '50',

  "username" varchar(45) DEFAULT NULL,

  PRIMARY KEY ("csimgid")

);

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

  "language" varchar(45) NOT NULL,

  "description" varchar(255) DEFAULT NULL,

  "notes" varchar(255) DEFAULT NULL,

  PRIMARY KEY ("cid","cs","language"),

  /*CONSTRAINT "kmcslang_ibfk_1" FOREIGN KEY ("cid", "cs") REFERENCES "kmcs" ("cid", "cs")*/CHECK (true)

);

  "Source" varchar(100) DEFAULT NULL,

  "Seq" integer DEFAULT NULL,

  "Notes" text,

  PRIMARY KEY ("TID","CID","CS"),

  /*KEY "CSDescr" ("CID","CS")*/CHECK (true),

  /*CONSTRAINT "kmdescr_ibfk_1" FOREIGN KEY ("CID", "CS") REFERENCES "kmcs" ("cid", "cs")*/CHECK (true),

  "Source" varchar(100) DEFAULT NULL,

  "Seq" integer DEFAULT NULL,

  "Notes" text,

  "DeletedBy" varchar(100) NOT NULL,

  "PK" integer NOT NULL,

  PRIMARY KEY ("PK")

);

  "iso" varchar(2) DEFAULT NULL,

  "iso3" varchar(3) DEFAULT NULL,

  "numcode" integer DEFAULT NULL,

  PRIMARY KEY ("countryId"),

  /*CONSTRAINT "country_unique" */UNIQUE ("countryName")

);

  "countyId" integer NOT NULL,

  "stateId" integer NOT NULL,

  "countyName" varchar(100) NOT NULL,

  PRIMARY KEY ("countyId"),

  /*CONSTRAINT "unique_county" */UNIQUE ("stateId","countyName"),

  /*KEY "fk_stateprovince" ("stateId")*/CHECK (true),

  "countryId" integer NOT NULL,

  "stateName" varchar(100) NOT NULL,

  "abbrev" varchar(2) DEFAULT NULL,

  PRIMARY KEY ("stateId"),

  /*CONSTRAINT "state_index" */UNIQUE ("stateName","countryId"),

  /*KEY "fk_country" ("countryId")*/CHECK (true),

  "identifier" varchar(250) DEFAULT NULL,

  "resourceurl" varchar(250) DEFAULT NULL,

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("aoid")

);

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

CREATE TABLE "omcollcatagories" (

  "ccpk" integer NOT NULL,

  "catagory" varchar(45) NOT NULL,

  PRIMARY KEY ("ccpk")

);

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

  "ccpk" integer NOT NULL,

  "collid" integer NOT NULL,

  "sortsequence" integer DEFAULT NULL,

  PRIMARY KEY ("ccpk","collid"),

  /*KEY "FK_collcatlink_coll" ("collid")*/CHECK (true),

  /*CONSTRAINT "FK_collcatlink_cat" FOREIGN KEY ("ccpk") REFERENCES "omcollcatagories" ("ccpk") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  "bibliographicCitation" varchar(1000) DEFAULT NULL,

  "accessrights" varchar(250) DEFAULT NULL,

  "SortSeq" integer DEFAULT NULL,

  PRIMARY KEY ("CollID"),

  /*KEY "Index_inst" ("InstitutionCode")*/CHECK (true)

);

  "familycnt" integer DEFAULT NULL,

  "genuscnt" integer DEFAULT NULL,

  "speciescnt" integer DEFAULT NULL,

  "uploadedby" varchar(45) DEFAULT NULL,

  "dbtype" varchar(45) DEFAULT NULL,

  "dburl" varchar(250) DEFAULT NULL,

  "dbport" varchar(45) DEFAULT NULL,

  "dblogin" varchar(45) DEFAULT NULL,

  "dbpassword" varchar(45) DEFAULT NULL,

  PRIMARY KEY ("collid"),

  /*CONSTRAINT "omcollectionstats_ibfk_1" FOREIGN KEY ("collid") REFERENCES "omcollections" ("CollID")*/CHECK (true)

);

  "endyearactive" integer DEFAULT NULL,

  "notes" varchar(255) DEFAULT NULL,

  "rating" integer DEFAULT '10',

  PRIMARY KEY ("recordedById"),

  /*KEY "fullname" ("familyname","firstname")*/CHECK (true)

);

  "icon" varchar(250) DEFAULT NULL,

  "CollType" varchar(45) DEFAULT NULL,

  "SortSeq" integer DEFAULT NULL,

  PRIMARY KEY ("ocsid"),

  /*KEY "FK_omcollsecondary_coll" ("collid")*/CHECK (true),

  /*CONSTRAINT "FK_omcollsecondary_coll" FOREIGN KEY ("collid") REFERENCES "omcollections" ("CollID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

  "trainingurl" varchar(500) DEFAULT NULL,

  "editorlevel" integer NOT NULL DEFAULT '0',

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("omcsid"),

  /*CONSTRAINT "Index_omcrowdsourcecentral_collid" */UNIQUE ("collid"),

  /*KEY "FK_omcrowdsourcecentral_collid" ("collid")*/CHECK (true),

  "uidprocessor" integer DEFAULT NULL,

  "points" integer DEFAULT NULL,

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("idomcrowdsourcequeue"),

  /*CONSTRAINT "Index_omcrowdsource_occid" */UNIQUE ("occid"),

  /*KEY "FK_omcrowdsourcequeue_occid" ("occid")*/CHECK (true),

  "exsnumber" varchar(45) NOT NULL,

  "ometid" integer NOT NULL,

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("omenid"),

  /*CONSTRAINT "Index_omexsiccatinumbers_unique" */UNIQUE ("exsnumber","ometid"),

  /*KEY "FK_exsiccatiTitleNumber" ("ometid")*/CHECK (true),

  "occid" integer NOT NULL,

  "ranking" integer NOT NULL DEFAULT '50',

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("omenid","occid"),

  /*CONSTRAINT "UniqueOmexsiccatiOccLink" */UNIQUE ("occid"),

  /*KEY "FKExsiccatiNumOccLink1" ("omenid")*/CHECK (true),

  "source" varchar(45) DEFAULT NULL,

  "notes" varchar(2000) DEFAULT NULL,

  "lasteditedby" varchar(45) DEFAULT NULL,

  PRIMARY KEY ("ometid"),

  /*KEY "index_exsiccatiTitle" ("title")*/CHECK (true)

);

  "uid" integer NOT NULL,

  "reviewstatus" integer NOT NULL DEFAULT '0',

  "parentcomid" integer DEFAULT NULL,

  PRIMARY KEY ("comid"),

  /*KEY "fk_omoccurcomments_occid" ("occid")*/CHECK (true),

  /*KEY "fk_omoccurcomments_uid" ("uid")*/CHECK (true),

  "occid" integer NOT NULL,

  "datasetid" integer NOT NULL,

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("occid","datasetid"),

  /*KEY "FK_omoccurdatasetlink_datasetid" ("datasetid")*/CHECK (true),

  /*KEY "FK_omoccurdatasetlink_occid" ("occid")*/CHECK (true),

  "notes" varchar(250) DEFAULT NULL,

  "sortsequence" integer DEFAULT NULL,

  "uid" integer NOT NULL,

  PRIMARY KEY ("datasetid")

);

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

  "identificationReferences" varchar(255) DEFAULT NULL,

  "identificationRemarks" varchar(255) DEFAULT NULL,

  "sortsequence" integer DEFAULT '10',

  PRIMARY KEY ("detid"),

  /*CONSTRAINT "Index_unique" */UNIQUE ("occid","dateIdentified","identifiedBy"),

  /*KEY "FK_omoccurdets_tid" ("tidinterpreted")*/CHECK (true),

  "isExsiccata" integer NOT NULL DEFAULT '0',

  "exsiccataEditors" varchar(150) DEFAULT NULL,

  "notes" varchar(255) DEFAULT NULL,

  PRIMARY KEY ("duplicateid")

);

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

  "occid" integer NOT NULL,

  "uid" integer NOT NULL,

  "ts" integer NOT NULL,

  PRIMARY KEY ("occid")

);

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

  "ReviewStatus" integer NOT NULL DEFAULT '1',

  "AppliedStatus" integer NOT NULL DEFAULT '0',

  "uid" integer NOT NULL,

  PRIMARY KEY ("ocedid"),

  /*KEY "fk_omoccuredits_uid" ("uid")*/CHECK (true),

  /*KEY "fk_omoccuredits_occid" ("occid")*/CHECK (true),

  "iid" integer DEFAULT NULL,

  "transactionType" varchar(10) DEFAULT NULL,

  "in_out" varchar(3) DEFAULT NULL,

  "totalBoxes" integer DEFAULT NULL,

  "shippingMethod" varchar(50) DEFAULT NULL,

  "totalExMounted" integer DEFAULT NULL,

  "description" varchar(1000) DEFAULT NULL,

  "notes" varchar(500) DEFAULT NULL,

  "createdBy" varchar(20) DEFAULT NULL,

  PRIMARY KEY ("exchangeid"),

  /*KEY "FK_occexch_coll" ("collid")*/CHECK (true),

  /*CONSTRAINT "FK_occexch_coll" FOREIGN KEY ("collid") REFERENCES "omcollections" ("CollID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

  "tid" integer NOT NULL,

  "decimallatitude" double precision NOT NULL,

  "decimallongitude" double precision NOT NULL,

  PRIMARY KEY ("tid","decimallatitude","decimallongitude"),

  /*CONSTRAINT "FK_specgeoindex_taxa" FOREIGN KEY ("tid") REFERENCES "taxa" ("TID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

  "collidBorr" integer DEFAULT NULL,

  "iidOwner" integer DEFAULT NULL,

  "iidBorrower" integer DEFAULT NULL,

  "receivedStatus" varchar(250) DEFAULT NULL,

  "totalBoxes" integer DEFAULT NULL,

  "totalBoxesReturned" integer DEFAULT NULL,

  "numSpecimens" integer DEFAULT NULL,

  "shippingMethod" varchar(50) DEFAULT NULL,

  "shippingMethodReturn" varchar(50) DEFAULT NULL,

  "forWhom" varchar(50) DEFAULT NULL,

  "description" varchar(1000) DEFAULT NULL,

  "invoiceMessageOwn" varchar(500) DEFAULT NULL,

  "processedByBorr" varchar(30) DEFAULT NULL,

  "processedByReturnOwn" varchar(30) DEFAULT NULL,

  "processedByReturnBorr" varchar(30) DEFAULT NULL,

  PRIMARY KEY ("loanid"),

  /*KEY "FK_occurloans_owninst" ("iidOwner")*/CHECK (true),

  /*KEY "FK_occurloans_borrinst" ("iidBorrower")*/CHECK (true),

CREATE TABLE "omoccurloanslink" (

  "loanid" integer NOT NULL,

  "occid" integer NOT NULL,

  "notes" varchar(255) DEFAULT NULL,

  PRIMARY KEY ("loanid","occid"),

  /*KEY "FK_occurloanlink_occid" ("occid")*/CHECK (true),

  /*KEY "FK_occurloanlink_loanid" ("loanid")*/CHECK (true),

  "recordNumber" varchar(45) DEFAULT NULL,

  "recordedById" integer DEFAULT NULL,

  "associatedCollectors" varchar(255) DEFAULT NULL,

  "year" integer DEFAULT NULL,

  "month" integer DEFAULT NULL,

  "day" integer DEFAULT NULL,

  "disposition" varchar(100) DEFAULT NULL,

  "genericcolumn1" varchar(100) DEFAULT NULL,

  "genericcolumn2" varchar(100) DEFAULT NULL,

  "language" varchar(20) DEFAULT NULL,

  "duplicateid" integer DEFAULT NULL,

  "observeruid" integer DEFAULT NULL,

  "recordEnteredBy" varchar(250) DEFAULT NULL,

  "duplicateQuantity" integer DEFAULT NULL,

  "labelProject" varchar(50) DEFAULT NULL,

  PRIMARY KEY ("occid"),

  /*CONSTRAINT "Index_collid" */UNIQUE ("collid","dbpk"),

  /*KEY "Index_sciname" ("sciname")*/CHECK (true),

  "source" varchar(45) DEFAULT NULL,

  "uid" integer DEFAULT NULL,

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("ovsid"),

  /*KEY "FK_omoccurverification_occid_idx" ("occid")*/CHECK (true),

  /*KEY "FK_omoccurverification_uid_idx" ("uid")*/CHECK (true),

  "occid" integer NOT NULL,

  "surveyid" integer NOT NULL,

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("occid","surveyid"),

  /*KEY "FK_omsurveyoccurlink_sur" ("surveyid")*/CHECK (true),

  /*CONSTRAINT "FK_omsurveyoccurlink_occ" FOREIGN KEY ("occid") REFERENCES "omoccurrences" ("occid")*/CHECK (true),

CREATE TABLE "omsurveyprojlink" (

  "surveyid" integer NOT NULL,

  "pid" integer NOT NULL,

  PRIMARY KEY ("surveyid","pid"),

  /*KEY "FK_specprojcatlink_cat" ("pid")*/CHECK (true),

  /*CONSTRAINT "FK_omsurveyprojlink_proj" FOREIGN KEY ("pid") REFERENCES "fmprojects" ("pid")*/CHECK (true),

  "notes" varchar(250) DEFAULT NULL,

  "ispublic" integer NOT NULL DEFAULT '0',

  "sortsequence" integer NOT NULL DEFAULT '50',

  PRIMARY KEY ("surveyid")

);

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

  "jpgcompression" integer DEFAULT '70',

  "createTnImg" integer DEFAULT '1',

  "createLgImg" integer DEFAULT '1',

  PRIMARY KEY ("spprid"),

  /*KEY "FK_specprocessorprojects_coll" ("collid")*/CHECK (true),

  /*CONSTRAINT "FK_specprocessorprojects_coll" FOREIGN KEY ("collid") REFERENCES "omcollections" ("CollID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

  "notes" varchar(255) DEFAULT NULL,

  "source" varchar(150) DEFAULT NULL,

  "sortsequence" integer DEFAULT NULL,

  PRIMARY KEY ("prlid"),

  /*KEY "FK_specproc_images" ("imgid")*/CHECK (true),

  /*KEY "FK_specproc_occid" ("occid")*/CHECK (true),

  "patternmatch" varchar(250) DEFAULT NULL,

  "notes" varchar(250) DEFAULT NULL,

  "collid" integer NOT NULL,

  PRIMARY KEY ("spnlpid"),

  /*KEY "FK_specprocnlp_collid" ("collid")*/CHECK (true),

  /*CONSTRAINT "FK_specprocnlp_collid" FOREIGN KEY ("collid") REFERENCES "omcollections" ("CollID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

  "patternmatch" varchar(250) NOT NULL,

  "notes" varchar(250) DEFAULT NULL,

  "sortseq" integer DEFAULT '50',

  PRIMARY KEY ("spnlpfragid"),

  /*KEY "FK_specprocnlpfrag_spnlpid" ("spnlpid")*/CHECK (true),

  /*CONSTRAINT "FK_specprocnlpfrag_spnlpid" FOREIGN KEY ("spnlpid") REFERENCES "specprocnlp" ("spnlpid") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

  "UnitName3" varchar(35) DEFAULT NULL,

  "Author" varchar(100) DEFAULT NULL,

  "PhyloSortSequence" integer DEFAULT NULL,

  "Status" varchar(50) DEFAULT NULL,

  "Source" varchar(250) DEFAULT NULL,

  "Notes" varchar(250) DEFAULT NULL,

  "displaylevel" integer NOT NULL DEFAULT '1',

  "uid" integer NOT NULL,

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("tdbid"),

  /*CONSTRAINT "Index_unique" */UNIQUE ("tid","displaylevel","language"),

  /*CONSTRAINT "taxadescrblock_ibfk_1" FOREIGN KEY ("tid") REFERENCES "taxa" ("TID")*/CHECK (true)

  "displayheader" integer NOT NULL DEFAULT '1',

  "notes" varchar(250) DEFAULT NULL,

  "sortsequence" integer NOT NULL DEFAULT '89',

  PRIMARY KEY ("tdsid"),

  /*KEY "FK_taxadescrstmts_tblock" ("tdbid")*/CHECK (true),

  /*CONSTRAINT "taxadescrstmts_ibfk_1" FOREIGN KEY ("tdbid") REFERENCES "taxadescrblock" ("tdbid") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

  "tid" integer NOT NULL,

  "taxauthid" integer NOT NULL,

  "parenttid" integer NOT NULL,

  PRIMARY KEY ("tid","taxauthid","parenttid"),

  /*KEY "FK_tet_taxa" ("tid")*/CHECK (true),

  /*KEY "FK_tet_taxauth" ("taxauthid")*/CHECK (true),

  "icon" varchar(45) DEFAULT NULL,

  "notes" varchar(250) DEFAULT NULL,

  "sortsequence" integer NOT NULL DEFAULT '50',

  PRIMARY KEY ("tlid"),

  /*KEY "Index_unique" ("tid","url")*/CHECK (true),

  /*CONSTRAINT "taxalinks_ibfk_1" FOREIGN KEY ("tid") REFERENCES "taxa" ("TID")*/CHECK (true)

  "green" integer DEFAULT NULL,

  "blue" integer DEFAULT NULL,

  "latadjustfactor" double precision NOT NULL DEFAULT '0',

  PRIMARY KEY ("dmid")

);

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

  "url" varchar(255) NOT NULL,

  "title" varchar(100) DEFAULT NULL,

  "dmid" integer DEFAULT NULL,

  PRIMARY KEY ("mid"),

  /*CONSTRAINT "Index_unique" */UNIQUE ("tid","dmid"),

  /*KEY "FK_taxamaps_dmid" ("dmid")*/CHECK (true),

  "taxauthid" integer NOT NULL,

  "leftindex" integer NOT NULL,

  "rightindex" integer NOT NULL,

  PRIMARY KEY ("tid","taxauthid"),

  /*KEY "leftindex" ("leftindex")*/CHECK (true),

  /*KEY "rightindex" ("rightindex")*/CHECK (true),

  "email" varchar(100) DEFAULT NULL,

  "notes" varchar(250) DEFAULT NULL,

  "isactive" integer NOT NULL DEFAULT '1',

  PRIMARY KEY ("taxauthid")

);

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

  "isupperterm" integer DEFAULT '0',

  "SortSequence" integer DEFAULT '50',

  "VID" integer NOT NULL,

  PRIMARY KEY ("VID"),

  /*CONSTRAINT "unique-key" */UNIQUE ("Language","VernacularName","TID"),

  /*KEY "tid1" ("TID")*/CHECK (true),

  "suffix" varchar(45) DEFAULT NULL,

  "dirparentrankid" integer NOT NULL,

  "reqparentrankid" integer DEFAULT NULL,

  PRIMARY KEY ("kingdomid","rankid")

);

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

  "UnacceptabilityReason" varchar(45) DEFAULT NULL,

  "notes" varchar(250) DEFAULT NULL,

  "SortSequence" integer DEFAULT '50',

  PRIMARY KEY ("tid","tidaccepted","taxauthid"),

  /*KEY "FK_taxstatus_tidacc" ("tidaccepted")*/CHECK (true),

  /*KEY "FK_taxstatus_taid" ("taxauthid")*/CHECK (true),

  "AssocSpp" text,

  "FirstColl" varchar(255) DEFAULT NULL,

  "CollNum" varchar(45) DEFAULT NULL,

  "Country" varchar(64) DEFAULT NULL,

  "State" varchar(255) DEFAULT NULL,

  "County" varchar(255) DEFAULT NULL,

  "Elev" varchar(255) DEFAULT NULL,

  "Project" varchar(50) DEFAULT NULL,

  "Cataloger" varchar(250) DEFAULT NULL,

  "occid" integer NOT NULL DEFAULT '0'

);

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

  "old_taxa_id" integer DEFAULT NULL,

  "scientific_name" varchar(200) NOT NULL,

  "taxonomic_group" varchar(150) DEFAULT NULL,

  "rank" varchar(6) DEFAULT NULL,

  "is_accepted" integer DEFAULT NULL,

  "entered_by" varchar(60) DEFAULT NULL,

  "unkid" integer NOT NULL,

  "comment" varchar(500) NOT NULL,

  "username" varchar(45) NOT NULL,

  PRIMARY KEY ("unkcomid"),

  /*KEY "FK_unknowncomments" ("unkid")*/CHECK (true),

  /*CONSTRAINT "FK_unknowncomments" FOREIGN KEY ("unkid") REFERENCES "unknowns" ("unkid")*/CHECK (true)

  "unkid" integer NOT NULL,

  "url" varchar(255) NOT NULL,

  "notes" varchar(250) DEFAULT NULL,

  PRIMARY KEY ("unkimgid"),

  /*KEY "FK_unknowns" ("unkid")*/CHECK (true),

  /*CONSTRAINT "FK_unknowns" FOREIGN KEY ("unkid") REFERENCES "unknowns" ("unkid") ON DELETE CASCADE*/CHECK (true)

  "notes" varchar(250) DEFAULT NULL,

  "username" varchar(45) NOT NULL,

  "idstatus" varchar(45) NOT NULL DEFAULT 'ID pending',

  PRIMARY KEY ("unkid"),

  /*KEY "FK_unknowns_username" ("username")*/CHECK (true),

  /*KEY "FK_unknowns_tid" ("tid")*/CHECK (true),

  "notes" varchar(255) DEFAULT NULL,

  "username" varchar(45) DEFAULT NULL,

  "sortsequence" integer DEFAULT NULL,

);

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

  "sourcefield" varchar(45) NOT NULL,

  "symbdatatype" varchar(45) NOT NULL DEFAULT 'string',

  "symbspecfield" varchar(45) NOT NULL,

  PRIMARY KEY ("usmid"),

  /*CONSTRAINT "Index_unique" */UNIQUE ("uspid","symbspecfield"),

  /*CONSTRAINT "FK_uploadspecmap_usp" FOREIGN KEY ("uspid") REFERENCES "uploadspecparameters" ("uspid") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

  "QueryStr" varchar(2000) DEFAULT NULL,

  "cleanupsp" varchar(45) DEFAULT NULL,

  "dlmisvalid" integer DEFAULT '0',

  PRIMARY KEY ("uspid"),

  /*KEY "FK_uploadspecparameters_coll" ("CollID")*/CHECK (true),

  /*CONSTRAINT "FK_uploadspecparameters_coll" FOREIGN KEY ("CollID") REFERENCES "omcollections" ("CollID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

  "CollectorFamilyName" varchar(255) DEFAULT NULL,

  "CollectorInitials" varchar(255) DEFAULT NULL,

  "associatedCollectors" varchar(255) DEFAULT NULL,

  "year" integer DEFAULT NULL,

  "month" integer DEFAULT NULL,

  "day" integer DEFAULT NULL,

  "startDayOfYear" integer DEFAULT NULL,

  "endDayOfYear" integer DEFAULT NULL,

  "verbatimEventDate" varchar(255) DEFAULT NULL,

  "habitat" text,

  "substrate" varchar(500) DEFAULT NULL,

  "disposition" varchar(32) DEFAULT NULL,

  "genericcolumn1" varchar(100) DEFAULT NULL,

  "genericcolumn2" varchar(100) DEFAULT NULL,

  "language" varchar(2) DEFAULT NULL,

  "recordEnteredBy" varchar(250) DEFAULT NULL,

  "duplicateQuantity" integer DEFAULT NULL,

  "tempfield13" text,

  "tempfield14" text,

  "tempfield15" text,

  /*KEY "FK_uploadspectemp_coll" ("collid")*/CHECK (true),

  /*KEY "Index_uploadspectemp_occid" ("occid")*/CHECK (true),

  /*KEY "Index_uploadspectemp_dbpk" ("dbpk")*/CHECK (true),

  "vernacular" varchar(80) DEFAULT NULL,

  "vernlang" varchar(15) DEFAULT NULL,

  "Hybrid" varchar(50) DEFAULT NULL,

  PRIMARY KEY ("scinameinput"),

  /*CONSTRAINT "sciname_index" */UNIQUE ("SciName"),

  /*KEY "sourceID_index" ("SourceId")*/CHECK (true),

  "username" varchar(45) NOT NULL,

  "password" varchar(45) NOT NULL,

  "alias" varchar(45) DEFAULT NULL,

  PRIMARY KEY ("username"),

  /*CONSTRAINT "Index_userlogin_unique" */UNIQUE ("alias"),

  /*KEY "FK_login_user" ("uid")*/CHECK (true),

  "uid" integer NOT NULL,

  "pname" varchar(45) NOT NULL,

  "assignedby" varchar(45) DEFAULT NULL,

  PRIMARY KEY ("uid","pname"),

  /*CONSTRAINT "userpermissions_ibfk_1" FOREIGN KEY ("uid") REFERENCES "users" ("uid") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

  "rightsholder" varchar(250) DEFAULT NULL,

  "validated" varchar(45) NOT NULL DEFAULT '0',

  "usergroups" varchar(100) DEFAULT NULL,

  PRIMARY KEY ("uid"),

  /*CONSTRAINT "Index_email" */UNIQUE ("email","lastname")