Project

General

Profile

1
-- Dump File
2
--
3
-- Database is ported from MS Access
4
----------------------------------------------------------
5
-- Program Version 3.0.148
6

    
7
CREATE DATABASE "NY_DATA_20130212";
8

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

    
11
--
12
-- Table structure for table 'Ecatalog'
13
--
14

    
15
DROP TABLE IF EXISTS "Ecatalog";
16

    
17
CREATE TABLE "Ecatalog" (
18
  "key" INTEGER NOT NULL, 
19
  "DateLastModified" VARCHAR(255), 
20
  "InstitutionCode" VARCHAR(255), 
21
  "CollectionCode" VARCHAR(255), 
22
  "CatalogNumber" VARCHAR(255), 
23
  "ScientificName" VARCHAR(255), 
24
  "BasisOfRecord" VARCHAR(255), 
25
  "Kingdom" VARCHAR(255), 
26
  "Phylum" VARCHAR(255), 
27
  "Class" VARCHAR(255), 
28
  "Order" VARCHAR(255), 
29
  "Family" VARCHAR(255), 
30
  "Genus" VARCHAR(255), 
31
  "Species" VARCHAR(255), 
32
  "Subspecies" VARCHAR(255), 
33
  "ScientificNameAuthor" VARCHAR(255), 
34
  "IdentifiedBy" VARCHAR(255), 
35
  "YearIdentified" VARCHAR(255), 
36
  "MonthIdentified" VARCHAR(255), 
37
  "DayIdentified" VARCHAR(255), 
38
  "TypeStatus" VARCHAR(255), 
39
  "CollectorNumber" VARCHAR(255), 
40
  "FieldNumber" VARCHAR(255), 
41
  "Collector" VARCHAR(255), 
42
  "YearCollected" VARCHAR(255), 
43
  "MonthCollected" VARCHAR(255), 
44
  "DayCollected" VARCHAR(255), 
45
  "JulianDay" VARCHAR(255), 
46
  "TimeOfDay" VARCHAR(255), 
47
  "ContinentOcean" VARCHAR(255), 
48
  "Country" VARCHAR(255), 
49
  "StateProvince" VARCHAR(255), 
50
  "County" VARCHAR(255), 
51
  "Locality" TEXT, 
52
  "Longitude" VARCHAR(255), 
53
  "Latitude" VARCHAR(255), 
54
  "CoordinatePrecision" VARCHAR(255), 
55
  "BoundingBox" VARCHAR(255), 
56
  "MinimumElevation" VARCHAR(255), 
57
  "MaximumElevation" VARCHAR(255), 
58
  "MinimumDepth" VARCHAR(255), 
59
  "MaximumDepth" VARCHAR(255), 
60
  "Sex" VARCHAR(255), 
61
  "PreparationType" VARCHAR(255), 
62
  "IndividualCount" VARCHAR(255), 
63
  "PreviousCatalogNumber" VARCHAR(255), 
64
  "RelationshipType" VARCHAR(255), 
65
  "RelatedCatalogItem" VARCHAR(255), 
66
  "Notes" TEXT, 
67
  "Habitat" TEXT, 
68
  "PlantFungDescription" TEXT, 
69
  "Substrate" TEXT, 
70
  "Vegetation" TEXT, 
71
  "UniqueNYInternalRecordNumber" VARCHAR(255), 
72
  PRIMARY KEY ("key")
73
);
74

    
75
--
76
-- Table structure for table 'Ecatalog_LatLong'
77
--
78

    
79
DROP TABLE IF EXISTS "Ecatalog_LatLong";
80

    
81
CREATE TABLE "Ecatalog_LatLong" (
82
  "key" INTEGER, 
83
  "DateLastModified" VARCHAR(255), 
84
  "InstitutionCode" VARCHAR(255), 
85
  "CollectionCode" VARCHAR(255), 
86
  "CatalogNumber" VARCHAR(255), 
87
  "ScientificName" VARCHAR(255), 
88
  "BasisOfRecord" VARCHAR(255), 
89
  "Kingdom" VARCHAR(255), 
90
  "Phylum" VARCHAR(255), 
91
  "Class" VARCHAR(255), 
92
  "Order" VARCHAR(255), 
93
  "Family" VARCHAR(255), 
94
  "Genus" VARCHAR(255), 
95
  "Species" VARCHAR(255), 
96
  "Subspecies" VARCHAR(255), 
97
  "ScientificNameAuthor" VARCHAR(255), 
98
  "IdentifiedBy" VARCHAR(255), 
99
  "YearIdentified" VARCHAR(255), 
100
  "MonthIdentified" VARCHAR(255), 
101
  "DayIdentified" VARCHAR(255), 
102
  "TypeStatus" VARCHAR(255), 
103
  "CollectorNumber" VARCHAR(255), 
104
  "FieldNumber" VARCHAR(255), 
105
  "Collector" VARCHAR(255), 
106
  "YearCollected" VARCHAR(255), 
107
  "MonthCollected" VARCHAR(255), 
108
  "DayCollected" VARCHAR(255), 
109
  "JulianDay" VARCHAR(255), 
110
  "TimeOfDay" VARCHAR(255), 
111
  "ContinentOcean" VARCHAR(255), 
112
  "Country" VARCHAR(255), 
113
  "StateProvince" VARCHAR(255), 
114
  "County" VARCHAR(255), 
115
  "Locality" TEXT, 
116
  "Longitude" VARCHAR(255), 
117
  "Latitude" VARCHAR(255), 
118
  "CoordinatePrecision" VARCHAR(255), 
119
  "BoundingBox" VARCHAR(255), 
120
  "MinimumElevation" VARCHAR(255), 
121
  "MaximumElevation" VARCHAR(255), 
122
  "MinimumDepth" VARCHAR(255), 
123
  "MaximumDepth" VARCHAR(255), 
124
  "Sex" VARCHAR(255), 
125
  "PreparationType" VARCHAR(255), 
126
  "IndividualCount" VARCHAR(255), 
127
  "PreviousCatalogNumber" VARCHAR(255), 
128
  "RelationshipType" VARCHAR(255), 
129
  "RelatedCatalogItem" VARCHAR(255), 
130
  "Notes" TEXT, 
131
  "Habitat" TEXT, 
132
  "PlantFungDescription" TEXT, 
133
  "Substrate" TEXT, 
134
  "Vegetation" TEXT, 
135
  "UniqueNYInternalRecordNumber" VARCHAR(255)
136
);
137

    
(3-3/6)