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
|
|