-- Dump File
--
-- Database is ported from MS Access
----------------------------------------------------------
-- Program Version 3.0.148

CREATE DATABASE "NY_DATA_20130212";

-- NOTICE: At this place you need to connect to the new database and run the rest of the statements.

--
-- Table structure for table 'Ecatalog'
--

DROP TABLE IF EXISTS "Ecatalog";

CREATE TABLE "Ecatalog" (
  "key" INTEGER NOT NULL, 
  "DateLastModified" VARCHAR(255), 
  "InstitutionCode" VARCHAR(255), 
  "CollectionCode" VARCHAR(255), 
  "CatalogNumber" VARCHAR(255), 
  "ScientificName" VARCHAR(255), 
  "BasisOfRecord" VARCHAR(255), 
  "Kingdom" VARCHAR(255), 
  "Phylum" VARCHAR(255), 
  "Class" VARCHAR(255), 
  "Order" VARCHAR(255), 
  "Family" VARCHAR(255), 
  "Genus" VARCHAR(255), 
  "Species" VARCHAR(255), 
  "Subspecies" VARCHAR(255), 
  "ScientificNameAuthor" VARCHAR(255), 
  "IdentifiedBy" VARCHAR(255), 
  "YearIdentified" VARCHAR(255), 
  "MonthIdentified" VARCHAR(255), 
  "DayIdentified" VARCHAR(255), 
  "TypeStatus" VARCHAR(255), 
  "CollectorNumber" VARCHAR(255), 
  "FieldNumber" VARCHAR(255), 
  "Collector" VARCHAR(255), 
  "YearCollected" VARCHAR(255), 
  "MonthCollected" VARCHAR(255), 
  "DayCollected" VARCHAR(255), 
  "JulianDay" VARCHAR(255), 
  "TimeOfDay" VARCHAR(255), 
  "ContinentOcean" VARCHAR(255), 
  "Country" VARCHAR(255), 
  "StateProvince" VARCHAR(255), 
  "County" VARCHAR(255), 
  "Locality" TEXT, 
  "Longitude" VARCHAR(255), 
  "Latitude" VARCHAR(255), 
  "CoordinatePrecision" VARCHAR(255), 
  "BoundingBox" VARCHAR(255), 
  "MinimumElevation" VARCHAR(255), 
  "MaximumElevation" VARCHAR(255), 
  "MinimumDepth" VARCHAR(255), 
  "MaximumDepth" VARCHAR(255), 
  "Sex" VARCHAR(255), 
  "PreparationType" VARCHAR(255), 
  "IndividualCount" VARCHAR(255), 
  "PreviousCatalogNumber" VARCHAR(255), 
  "RelationshipType" VARCHAR(255), 
  "RelatedCatalogItem" VARCHAR(255), 
  "Notes" TEXT, 
  "Habitat" TEXT, 
  "PlantFungDescription" TEXT, 
  "Substrate" TEXT, 
  "Vegetation" TEXT, 
  "UniqueNYInternalRecordNumber" VARCHAR(255), 
  PRIMARY KEY ("key")
);

--
-- Table structure for table 'Ecatalog_LatLong'
--

DROP TABLE IF EXISTS "Ecatalog_LatLong";

CREATE TABLE "Ecatalog_LatLong" (
  "key" INTEGER, 
  "DateLastModified" VARCHAR(255), 
  "InstitutionCode" VARCHAR(255), 
  "CollectionCode" VARCHAR(255), 
  "CatalogNumber" VARCHAR(255), 
  "ScientificName" VARCHAR(255), 
  "BasisOfRecord" VARCHAR(255), 
  "Kingdom" VARCHAR(255), 
  "Phylum" VARCHAR(255), 
  "Class" VARCHAR(255), 
  "Order" VARCHAR(255), 
  "Family" VARCHAR(255), 
  "Genus" VARCHAR(255), 
  "Species" VARCHAR(255), 
  "Subspecies" VARCHAR(255), 
  "ScientificNameAuthor" VARCHAR(255), 
  "IdentifiedBy" VARCHAR(255), 
  "YearIdentified" VARCHAR(255), 
  "MonthIdentified" VARCHAR(255), 
  "DayIdentified" VARCHAR(255), 
  "TypeStatus" VARCHAR(255), 
  "CollectorNumber" VARCHAR(255), 
  "FieldNumber" VARCHAR(255), 
  "Collector" VARCHAR(255), 
  "YearCollected" VARCHAR(255), 
  "MonthCollected" VARCHAR(255), 
  "DayCollected" VARCHAR(255), 
  "JulianDay" VARCHAR(255), 
  "TimeOfDay" VARCHAR(255), 
  "ContinentOcean" VARCHAR(255), 
  "Country" VARCHAR(255), 
  "StateProvince" VARCHAR(255), 
  "County" VARCHAR(255), 
  "Locality" TEXT, 
  "Longitude" VARCHAR(255), 
  "Latitude" VARCHAR(255), 
  "CoordinatePrecision" VARCHAR(255), 
  "BoundingBox" VARCHAR(255), 
  "MinimumElevation" VARCHAR(255), 
  "MaximumElevation" VARCHAR(255), 
  "MinimumDepth" VARCHAR(255), 
  "MaximumDepth" VARCHAR(255), 
  "Sex" VARCHAR(255), 
  "PreparationType" VARCHAR(255), 
  "IndividualCount" VARCHAR(255), 
  "PreviousCatalogNumber" VARCHAR(255), 
  "RelationshipType" VARCHAR(255), 
  "RelatedCatalogItem" VARCHAR(255), 
  "Notes" TEXT, 
  "Habitat" TEXT, 
  "PlantFungDescription" TEXT, 
  "Substrate" TEXT, 
  "Vegetation" TEXT, 
  "UniqueNYInternalRecordNumber" VARCHAR(255)
);