Project

General

Profile

1
-- phpMyAdmin SQL Dump
2
-- version 2.11.3deb1ubuntu1.3
3
-- http://www.phpmyadmin.net
4
--
5
-- Host: localhost
6
-- Generation Time: Oct 13, 2011 at 10:41 AM
7
-- Server version: 5.0.51
8
-- PHP Version: 5.2.4-2ubuntu5.17
9

    
10
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11

    
12
--
13
-- Database: `bien2`
14
--
15

    
16
-- --------------------------------------------------------
17

    
18
--
19
-- Table structure for table `bien_genus_family`
20
--
21

    
22
CREATE TABLE IF NOT EXISTS `bien_genus_family` (
23
  `family` varchar(250) character set utf8 NOT NULL,
24
  `genus` varchar(150) character set utf8 collate utf8_bin default NULL,
25
  `tot_families` int(1) default NULL,
26
  KEY `genus` (`genus`),
27
  KEY `family` (`family`),
28
  KEY `tot_families` (`tot_families`)
29
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
30

    
31
-- --------------------------------------------------------
32

    
33
--
34
-- Table structure for table `clade`
35
--
36

    
37
CREATE TABLE IF NOT EXISTS `clade` (
38
  `cladeID` int(11) unsigned NOT NULL,
39
  `parentCladeID` int(11) unsigned default NULL,
40
  `cladeNameStd` varchar(250) NOT NULL,
41
  `rank` varchar(50) default NULL,
42
  `isHybrid` int(1) unsigned NOT NULL,
43
  `family` varchar(100) default NULL,
44
  `leftIndex` int(11) unsigned default NULL,
45
  `rightIndex` int(11) unsigned default NULL,
46
  `source` varchar(25) default NULL,
47
  `majorPlantGroup` varchar(45) default NULL,
48
  `embryophytes` varchar(45) default NULL,
49
  `vascularPlants` varchar(45) default NULL,
50
  `seedPlants` varchar(45) default NULL,
51
  `floweringPlants` varchar(45) default NULL,
52
  PRIMARY KEY  USING BTREE (`cladeID`),
53
  KEY `nameStaging_isHybrid` (`isHybrid`),
54
  KEY `nameStaging_family` (`family`),
55
  KEY `nameStaging_leftIndex` (`leftIndex`),
56
  KEY `nameStaging_rightIndex` (`rightIndex`),
57
  KEY `idx_source` (`source`),
58
  KEY `nameStaging_rank` USING BTREE (`rank`),
59
  KEY `Index_majorPlantGroup` USING BTREE (`majorPlantGroup`),
60
  KEY `Index_embryophytes` USING BTREE (`embryophytes`),
61
  KEY `Index_seedPlants` USING BTREE (`seedPlants`),
62
  KEY `Index_vascularPlants` USING BTREE (`vascularPlants`),
63
  KEY `Index_floweringPlants` USING BTREE (`floweringPlants`),
64
  KEY `nameStaging_parentCladeID` USING BTREE (`parentCladeID`),
65
  KEY `nameStaging_cladeNameStd` USING BTREE (`cladeNameStd`)
66
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
67

    
68
-- --------------------------------------------------------
69

    
70
--
71
-- Table structure for table `cladeName`
72
--
73

    
74
CREATE TABLE IF NOT EXISTS `cladeName` (
75
  `cladeNameID` int(11) NOT NULL auto_increment,
76
  `cladeID` int(10) unsigned NOT NULL,
77
  `cladeName` varchar(250) NOT NULL,
78
  `cladeNameUnique` varchar(300) default NULL,
79
  `nameStatus` varchar(50) default NULL,
80
  `source` varchar(45) default NULL,
81
  PRIMARY KEY  USING BTREE (`cladeNameID`),
82
  KEY `idx_cladeID` USING BTREE (`cladeID`),
83
  KEY `Index_source` (`source`),
84
  KEY `idx_name` USING BTREE (`cladeName`),
85
  KEY `idx_nameStatus` USING BTREE (`nameStatus`)
86
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=89884 ;
87

    
88
-- --------------------------------------------------------
89

    
90
--
91
-- Table structure for table `DataSource`
92
--
93

    
94
CREATE TABLE IF NOT EXISTS `DataSource` (
95
  `DataSourceID` int(10) unsigned NOT NULL auto_increment,
96
  `DataSourceName` varchar(255) NOT NULL,
97
  `DataSourceType` varchar(255) NOT NULL,
98
  PRIMARY KEY  (`DataSourceID`),
99
  KEY `DataSourceName` (`DataSourceName`),
100
  KEY `DataSourceType` (`DataSourceType`)
101
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Data sources for plots or specimens' AUTO_INCREMENT=30 ;
102

    
103
-- --------------------------------------------------------
104

    
105
--
106
-- Table structure for table `geoIndividualObservation`
107
--
108

    
109
CREATE TABLE IF NOT EXISTS `geoIndividualObservation` (
110
  `ID` int(11) unsigned NOT NULL COMMENT 'Links 1:1 with DBPlotID',
111
  `countryISO` varchar(25) default NULL,
112
  `countryStd` varchar(150) default NULL,
113
  `isInCountry` int(1) default NULL,
114
  `countryDistError` double default NULL,
115
  `stateProvinceStd` varchar(150) default NULL,
116
  `isInStateProvince` int(1) default NULL,
117
  `stateProvinceDistError` double default NULL,
118
  `countyParishStd` varchar(150) default NULL,
119
  `isInCountyParish` int(1) default NULL,
120
  `countyParishDistError` double default NULL,
121
  `isValidLatLong` int(1) default NULL,
122
  `isCultivated` int(1) default '0',
123
  `isCultivatedReason` varchar(255) default NULL,
124
  PRIMARY KEY  (`ID`),
125
  KEY `geoI_countryISO_NDX` (`countryISO`),
126
  KEY `geoI_countryStd_NDX` (`countryStd`),
127
  KEY `geoI_isInCountry_NDX` (`isInCountry`),
128
  KEY `geoI_countryDistError_NDX` (`countryDistError`),
129
  KEY `geoI_stateProvinceStd_NDX` (`stateProvinceStd`),
130
  KEY `geoI_isInStateProvince_NDX` (`isInStateProvince`),
131
  KEY `geoI_stateProvinceDistError_NDX` (`stateProvinceDistError`),
132
  KEY `geoI_countyParishStd_NDX` (`countyParishStd`),
133
  KEY `geoI_isInCountyParish_NDX` (`isInCountyParish`),
134
  KEY `geoI_countyParishDistError_NDX` (`countyParishDistError`),
135
  KEY `geoI_isValidLatLong_NDX` (`isValidLatLong`),
136
  KEY `geoI_isCultivated` (`isCultivated`),
137
  KEY `geoI_isCultivatedReason` (`isCultivatedReason`)
138
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
139

    
140
-- --------------------------------------------------------
141

    
142
--
143
-- Table structure for table `geoPlotMetaDataDimension`
144
--
145

    
146
CREATE TABLE IF NOT EXISTS `geoPlotMetaDataDimension` (
147
  `ID` int(11) unsigned NOT NULL COMMENT 'Links 1:1 with DBPlotID',
148
  `countryISO` varchar(25) default NULL,
149
  `countryStd` varchar(150) default NULL,
150
  `isInCountry` int(1) default NULL,
151
  `countryDistError` double default NULL,
152
  `stateProvinceStd` varchar(150) default NULL,
153
  `isInStateProvince` int(1) default NULL,
154
  `stateProvinceDistError` double default NULL,
155
  `countyParishStd` varchar(150) default NULL,
156
  `isInCountyParish` int(1) default NULL,
157
  `countyParishDistError` double default NULL,
158
  `isValidLatLong` int(1) default NULL,
159
  `isCultivated` int(1) default '0',
160
  `isCultivatedReason` varchar(255) default NULL,
161
  PRIMARY KEY  (`ID`),
162
  KEY `geoP_countryISO_NDX` (`countryISO`),
163
  KEY `geoP_countryStd_NDX` (`countryStd`),
164
  KEY `geoP_isInCountry_NDX` (`isInCountry`),
165
  KEY `geoP_countryDistError_NDX` (`countryDistError`),
166
  KEY `geoP_stateProvinceStd_NDX` (`stateProvinceStd`),
167
  KEY `geoP_isInStateProvince_NDX` (`isInStateProvince`),
168
  KEY `geoP_stateProvinceDistError_NDX` (`stateProvinceDistError`),
169
  KEY `geoP_countyParishStd_NDX` (`countyParishStd`),
170
  KEY `geoP_isInCountyParish_NDX` (`isInCountyParish`),
171
  KEY `geoP_countyParishDistError_NDX` (`countyParishDistError`),
172
  KEY `geoP_isValidLatLong_NDX` (`isValidLatLong`),
173
  KEY `geoP_isCultivated` (`isCultivated`),
174
  KEY `geo_isCultivatedReason` (`isCultivatedReason`)
175
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
176

    
177
-- --------------------------------------------------------
178

    
179
--
180
-- Table structure for table `IndividualObservation`
181
--
182

    
183
CREATE TABLE IF NOT EXISTS `IndividualObservation` (
184
  `ObservationID` int(11) NOT NULL auto_increment,
185
  `ObservationType` int(11) default NULL,
186
  `PlotTreeTag` varchar(32) collate utf8_bin default NULL,
187
  `DBPlotID` int(11) default NULL,
188
  `SpecimenCatalogNO` varchar(64) collate utf8_bin default NULL,
189
  `ObservationSpecimenID` int(11) default NULL,
190
  `LatestDateCollected` date default NULL,
191
  `DecimalLatitude` decimal(10,5) default NULL,
192
  `DecimalLongitude` decimal(10,5) default NULL,
193
  `NumberOfStems` int(11) default NULL,
194
  `BasalDiameter` decimal(10,5) default NULL,
195
  `Height` decimal(10,5) default NULL,
196
  `TaxonomyID` int(11) NOT NULL,
197
  `RawTreeID` int(10) default NULL,
198
  `test` tinyint(3) unsigned NOT NULL default '0',
199
  PRIMARY KEY  (`ObservationID`),
200
  KEY `RefPlotMetaDataDimension411` (`DBPlotID`),
201
  KEY `RefTaxonDimension381` (`TaxonomyID`),
202
  KEY `ObservationSpecimenID` (`ObservationSpecimenID`)
203
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=22296066 ;
204

    
205
-- --------------------------------------------------------
206

    
207
--
208
-- Table structure for table `IndividualObservationMeasurement`
209
--
210

    
211
CREATE TABLE IF NOT EXISTS `IndividualObservationMeasurement` (
212
  `ObservationID` int(11) NOT NULL,
213
  `StemNO` int(11) NOT NULL auto_increment,
214
  `ObservationNO` int(11) NOT NULL,
215
  `PrimaryStem` int(11) default NULL,
216
  `DBH` decimal(10,5) default NULL,
217
  `HOM` decimal(10,5) default NULL,
218
  `test` tinyint(3) unsigned NOT NULL default '0',
219
  PRIMARY KEY  (`ObservationID`,`StemNO`,`ObservationNO`),
220
  KEY `RefIndividualObservation11` (`ObservationID`)
221
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
222

    
223
-- --------------------------------------------------------
224

    
225
--
226
-- Table structure for table `ObservationSpecimen`
227
--
228

    
229
CREATE TABLE IF NOT EXISTS `ObservationSpecimen` (
230
  `ObservationSpecimenID` int(11) NOT NULL auto_increment,
231
  `DBSourceID` int(11) NOT NULL,
232
  `Continent` varchar(64) collate utf8_bin default NULL,
233
  `Country` varchar(100) collate utf8_bin default NULL,
234
  `StateProvince` varchar(64) collate utf8_bin default NULL,
235
  `verbatimCountry` varchar(100) collate utf8_bin default NULL,
236
  `County` varchar(100) collate utf8_bin default NULL,
237
  `Locality` varchar(1024) collate utf8_bin default NULL,
238
  `Collector` varchar(256) collate utf8_bin default NULL,
239
  `IdentifiedBy` varchar(128) collate utf8_bin default NULL,
240
  `IdentifiedDate` date default NULL,
241
  `CoordinateUncertainty` decimal(10,5) default NULL,
242
  `CoordinateUncertaintyUnits` varchar(10) collate utf8_bin default NULL,
243
  `VegetationCategory` varchar(32) collate utf8_bin default NULL,
244
  `test` tinyint(3) unsigned NOT NULL,
245
  `Cultivated` int(1) NOT NULL,
246
  `CollectionNumber` varchar(24) collate utf8_bin default NULL,
247
  PRIMARY KEY  (`ObservationSpecimenID`),
248
  KEY `RefSpecimenSourceData421` (`DBSourceID`),
249
  KEY `DBSourceID` (`DBSourceID`,`Continent`,`Country`,`StateProvince`,`County`,`Locality`(255),`Collector`(255),`IdentifiedBy`,`IdentifiedDate`,`CoordinateUncertainty`,`CoordinateUncertaintyUnits`,`VegetationCategory`)
250
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=8578890 ;
251

    
252
-- --------------------------------------------------------
253

    
254
--
255
-- Table structure for table `PlotAggregateFact`
256
--
257

    
258
CREATE TABLE IF NOT EXISTS `PlotAggregateFact` (
259
  `DBPlotID` int(11) NOT NULL,
260
  `PlotTimeID` int(11) NOT NULL,
261
  `TotalIndividuals` int(11) default NULL,
262
  `TotalIndividualsAbove1cm` int(11) default NULL,
263
  `TotalIndividualsAbove2.5cm` int(11) default NULL,
264
  `TotalIndividualsAbove10cm` int(11) default NULL,
265
  `PercentCover` decimal(10,5) default NULL,
266
  `TaxonomyID` int(11) NOT NULL,
267
  `del` int(1) unsigned default NULL,
268
  `test` tinyint(3) unsigned NOT NULL default '0',
269
  PRIMARY KEY  (`DBPlotID`,`PlotTimeID`,`TaxonomyID`),
270
  KEY `RefPlotMetaDataDimension61` (`DBPlotID`),
271
  KEY `RefPlotTimeDimension371` (`PlotTimeID`),
272
  KEY `RefTaxonDimension181` (`TaxonomyID`),
273
  KEY `DBPlotID_2` (`DBPlotID`,`PlotTimeID`,`TaxonomyID`),
274
  KEY `DBPlotID_3` (`DBPlotID`,`PlotTimeID`,`TaxonomyID`),
275
  KEY `DBPlotID_4` (`DBPlotID`,`PlotTimeID`,`TaxonomyID`)
276
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
277

    
278
-- --------------------------------------------------------
279

    
280
--
281
-- Table structure for table `PlotMetaDataDimension`
282
--
283

    
284
CREATE TABLE IF NOT EXISTS `PlotMetaDataDimension` (
285
  `DBPlotID` int(11) NOT NULL auto_increment,
286
  `DBSourceName` varchar(64) collate utf8_bin default NULL,
287
  `ContactName` varchar(32) collate utf8_bin default NULL,
288
  `ContactEmail` varchar(32) collate utf8_bin default NULL,
289
  `ContactTelephone` varchar(32) collate utf8_bin default NULL,
290
  `Continent` varchar(64) collate utf8_bin default NULL,
291
  `Country` varchar(32) collate utf8_bin default NULL,
292
  `StateProvince` varchar(64) collate utf8_bin default NULL,
293
  `verbatimCountry` varchar(64) collate utf8_bin default NULL,
294
  `County` varchar(64) collate utf8_bin default NULL,
295
  `Locality` varchar(256) collate utf8_bin default NULL,
296
  `VegetationCategory` varchar(32) collate utf8_bin default NULL,
297
  `PlotCD` bigint(32) default NULL,
298
  `PlotName` varchar(32) collate utf8_bin default NULL,
299
  `PlotCensusMethod` varchar(32) collate utf8_bin default NULL,
300
  `PlotArea` varchar(10) collate utf8_bin default NULL,
301
  `PlotAreaUnits` varchar(10) collate utf8_bin default NULL,
302
  `PlotShape` varchar(32) collate utf8_bin default NULL,
303
  `PlotDecimalLatitude` decimal(10,5) default NULL,
304
  `PlotDecimalLongitude` decimal(10,5) default NULL,
305
  `CoordinateUncertainty` decimal(10,5) default NULL,
306
  `CoordinateUncertaintyUnits` varchar(10) collate utf8_bin default NULL,
307
  `PlotReferenceX` decimal(10,5) default NULL,
308
  `PlotReferenceY` decimal(10,5) default NULL,
309
  `PlotMaxDBH` decimal(10,5) default NULL,
310
  `PlotMinDBH` decimal(10,5) default NULL,
311
  `test` tinyint(3) unsigned NOT NULL default '0',
312
  PRIMARY KEY  (`DBPlotID`),
313
  KEY `DBSourceName` (`DBSourceName`),
314
  KEY `PlotName_2` (`PlotName`,`DBSourceName`)
315
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=342877 ;
316

    
317
-- --------------------------------------------------------
318

    
319
--
320
-- Table structure for table `PlotTimeDimension`
321
--
322

    
323
CREATE TABLE IF NOT EXISTS `PlotTimeDimension` (
324
  `PlotTimeID` int(11) NOT NULL auto_increment,
325
  `CensusID` int(11) default NULL,
326
  `CensusName` varchar(32) collate utf8_bin default NULL,
327
  `CensusStartDate` date default NULL,
328
  `CensusEndDate` date default NULL,
329
  `DBPlotID` int(11) NOT NULL,
330
  `test` tinyint(3) unsigned NOT NULL default '0',
331
  PRIMARY KEY  (`PlotTimeID`),
332
  KEY `Ref613` (`DBPlotID`),
333
  KEY `CensusName_2` (`CensusName`,`DBPlotID`,`CensusID`),
334
  KEY `CensusName_3` (`CensusName`,`DBPlotID`,`CensusID`),
335
  KEY `CensusName_4` (`CensusName`,`DBPlotID`,`CensusID`),
336
  KEY `CensusName_5` (`CensusName`,`CensusID`),
337
  KEY `CensusName_6` (`CensusName`,`CensusID`),
338
  KEY `CensusName_7` (`CensusName`,`DBPlotID`,`CensusID`),
339
  KEY `CensusName_8` (`CensusName`,`DBPlotID`,`CensusID`)
340
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=341814 ;
341

    
342
-- --------------------------------------------------------
343

    
344
--
345
-- Table structure for table `SpecimenSourceData`
346
--
347

    
348
CREATE TABLE IF NOT EXISTS `SpecimenSourceData` (
349
  `DBSourceID` int(11) NOT NULL auto_increment,
350
  `DBSourceName` varchar(64) collate utf8_bin default NULL,
351
  `ContactName` varchar(32) collate utf8_bin default NULL,
352
  `ContactEmail` varchar(32) collate utf8_bin default NULL,
353
  `ContactTelephone` varchar(32) collate utf8_bin default NULL,
354
  `SpecimenInstitutionCD` varchar(128) collate utf8_bin default NULL,
355
  `SpecimenCollectionCD` varchar(128) collate utf8_bin default NULL,
356
  `test` tinyint(3) unsigned NOT NULL default '0',
357
  PRIMARY KEY  (`DBSourceID`),
358
  KEY `DBSourceName` (`DBSourceName`),
359
  KEY `SpecimenInstitutionCD` (`SpecimenInstitutionCD`,`SpecimenCollectionCD`,`DBSourceName`)
360
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=131797 ;
361

    
362
-- --------------------------------------------------------
363

    
364
--
365
-- Table structure for table `TaxonDataSource`
366
--
367

    
368
CREATE TABLE IF NOT EXISTS `TaxonDataSource` (
369
  `TaxonDataSourceID` int(10) unsigned NOT NULL auto_increment,
370
  `DataSourceID` int(10) unsigned NOT NULL,
371
  `TaxonomyID` int(10) unsigned NOT NULL,
372
  `TotalObservations` int(10) unsigned default NULL,
373
  `GeoreferencedObservations` int(10) unsigned default NULL,
374
  PRIMARY KEY  (`TaxonDataSourceID`),
375
  KEY `DataSourceID` (`DataSourceID`),
376
  KEY `TaxonomyID` (`TaxonomyID`)
377
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Links taxa to data sources in which they are used' AUTO_INCREMENT=731596 ;
378

    
379
-- --------------------------------------------------------
380

    
381
--
382
-- Table structure for table `TaxonDimension`
383
--
384

    
385
CREATE TABLE IF NOT EXISTS `TaxonDimension` (
386
  `TaxonomyID` int(11) NOT NULL auto_increment,
387
  `FamilyName` varchar(64) collate utf8_bin default NULL,
388
  `GenusName` varchar(64) collate utf8_bin default NULL,
389
  `SpecificEpithet` varchar(64) collate utf8_bin default NULL,
390
  `InfraspecificEpithet` varchar(64) collate utf8_bin default NULL,
391
  `InfraspecificRank` varchar(64) collate utf8_bin default NULL,
392
  `Authority` varchar(128) collate utf8_bin default NULL,
393
  `is_plotName` int(1) unsigned default '0',
394
  `taxonAuthorityVerbatim` varchar(250) collate utf8_bin default NULL,
395
  `taxonMatched` varchar(250) collate utf8_bin default NULL,
396
  `taxonMatchedAuthority` varchar(250) collate utf8_bin default NULL,
397
  `unmatchedTerms` varchar(250) collate utf8_bin default NULL,
398
  `matchScore` decimal(3,2) default NULL,
399
  `taxonMatchedAcceptance` varchar(1) collate utf8_bin default NULL,
400
  `familyCorrected` varchar(50) collate utf8_bin default NULL,
401
  `genusCorrected` varchar(150) collate utf8_bin default NULL,
402
  `speciesCorrected` varchar(255) collate utf8_bin default NULL,
403
  `taxonCorrected` varchar(250) collate utf8_bin default NULL,
404
  `authorityCorrected` varchar(250) collate utf8_bin default NULL,
405
  `taxonCorrectedTnrsID` int(10) unsigned default NULL,
406
  `taxonCorrectedRank` varchar(25) collate utf8_bin default NULL,
407
  `taxonCorrectedAcceptance` varchar(1) collate utf8_bin default NULL,
408
  `morphospecies` varchar(250) collate utf8_bin default NULL,
409
  `taxonMorphospecies` varchar(250) collate utf8_bin default NULL,
410
  `is_scrubbed` int(1) unsigned NOT NULL default '0',
411
  PRIMARY KEY  (`TaxonomyID`),
412
  KEY `FamilyName` (`FamilyName`),
413
  KEY `GenusName` (`GenusName`),
414
  KEY `SpecificEpithet` (`SpecificEpithet`),
415
  KEY `InfraspecificRank` (`InfraspecificRank`),
416
  KEY `FamilyName_2` (`FamilyName`,`GenusName`,`SpecificEpithet`,`InfraspecificEpithet`,`InfraspecificRank`,`Authority`),
417
  KEY `InfraspecificEpithet` (`InfraspecificEpithet`),
418
  KEY `taxonAuthorityVerbatim` (`taxonAuthorityVerbatim`),
419
  KEY `taxonCorrected` (`taxonCorrected`),
420
  KEY `taxonMorphospecies` (`taxonMorphospecies`),
421
  KEY `is_scrubbed` (`is_scrubbed`),
422
  KEY `TD_familyCorrected` (`familyCorrected`),
423
  KEY `TD_taxonMatchedAcceptance` (`taxonMatchedAcceptance`),
424
  KEY `TD_taxonCorrectedAcceptance` (`taxonCorrectedAcceptance`),
425
  KEY `TD_taxonCorrectedRank` (`taxonCorrectedRank`),
426
  KEY `taxonCorrectedTnrsID` (`taxonCorrectedTnrsID`),
427
  KEY `TD_is_plotName` (`is_plotName`),
428
  KEY `genusCorrected_idx` (`genusCorrected`),
429
  KEY `speciesCorrected` (`speciesCorrected`)
430
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=FIXED AUTO_INCREMENT=987490 ;
431

    
432
-- --------------------------------------------------------
433

    
434
--
435
-- Table structure for table `TaxonDimension_bak`
436
--
437

    
438
CREATE TABLE IF NOT EXISTS `TaxonDimension_bak` (
439
  `TaxonomyID` int(11) NOT NULL auto_increment,
440
  `FamilyName` varchar(64) collate utf8_bin default NULL,
441
  `GenusName` varchar(64) collate utf8_bin default NULL,
442
  `SpecificEpithet` varchar(64) collate utf8_bin default NULL,
443
  `InfraspecificEpithet` varchar(64) collate utf8_bin default NULL,
444
  `InfraspecificRank` varchar(64) collate utf8_bin default NULL,
445
  `Authority` varchar(128) collate utf8_bin default NULL,
446
  `is_plotName` int(1) unsigned default '0',
447
  `taxonAuthorityVerbatim` varchar(250) collate utf8_bin default NULL,
448
  `taxonMatched` varchar(250) collate utf8_bin default NULL,
449
  `taxonMatchedAuthority` varchar(250) collate utf8_bin default NULL,
450
  `unmatchedTerms` varchar(250) collate utf8_bin default NULL,
451
  `matchScore` decimal(3,2) default NULL,
452
  `taxonMatchedAcceptance` varchar(1) collate utf8_bin default NULL,
453
  `familyCorrected` varchar(50) collate utf8_bin default NULL,
454
  `genusCorrected` varchar(150) collate utf8_bin default NULL,
455
  `speciesCorrected` varchar(255) collate utf8_bin default NULL,
456
  `taxonCorrected` varchar(250) collate utf8_bin default NULL,
457
  `authorityCorrected` varchar(250) collate utf8_bin default NULL,
458
  `taxonCorrectedTnrsID` int(10) unsigned default NULL,
459
  `taxonCorrectedRank` varchar(25) collate utf8_bin default NULL,
460
  `taxonCorrectedAcceptance` varchar(1) collate utf8_bin default NULL,
461
  `morphospecies` varchar(250) collate utf8_bin default NULL,
462
  `taxonMorphospecies` varchar(250) collate utf8_bin default NULL,
463
  `is_scrubbed` int(1) unsigned NOT NULL default '0',
464
  PRIMARY KEY  (`TaxonomyID`),
465
  KEY `FamilyName` (`FamilyName`),
466
  KEY `GenusName` (`GenusName`),
467
  KEY `SpecificEpithet` (`SpecificEpithet`),
468
  KEY `InfraspecificRank` (`InfraspecificRank`),
469
  KEY `FamilyName_2` (`FamilyName`,`GenusName`,`SpecificEpithet`,`InfraspecificEpithet`,`InfraspecificRank`,`Authority`),
470
  KEY `InfraspecificEpithet` (`InfraspecificEpithet`),
471
  KEY `taxonAuthorityVerbatim` (`taxonAuthorityVerbatim`),
472
  KEY `taxonCorrected` (`taxonCorrected`),
473
  KEY `taxonMorphospecies` (`taxonMorphospecies`),
474
  KEY `is_scrubbed` (`is_scrubbed`),
475
  KEY `TD_familyCorrected` (`familyCorrected`),
476
  KEY `TD_taxonMatchedAcceptance` (`taxonMatchedAcceptance`),
477
  KEY `TD_taxonCorrectedAcceptance` (`taxonCorrectedAcceptance`),
478
  KEY `TD_taxonCorrectedRank` (`taxonCorrectedRank`),
479
  KEY `taxonCorrectedTnrsID` (`taxonCorrectedTnrsID`),
480
  KEY `TD_is_plotName` (`is_plotName`),
481
  KEY `genusCorrected_idx` (`genusCorrected`),
482
  KEY `speciesCorrected` (`speciesCorrected`)
483
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=FIXED AUTO_INCREMENT=987490 ;
484

    
485
-- --------------------------------------------------------
486

    
487
--
488
-- Table structure for table `TaxonObservation`
489
--
490

    
491
CREATE TABLE IF NOT EXISTS `TaxonObservation` (
492
  `TaxonomyObservationID` int(11) NOT NULL auto_increment,
493
  `TaxonomyID` int(11) default NULL,
494
  `PlotOrSpecimenFlag` int(11) default NULL,
495
  `DBPlotID` int(11) NOT NULL,
496
  `DBSourceID` int(11) NOT NULL,
497
  `GBIFScientificNameOriginal` varchar(64) collate utf8_bin default NULL,
498
  `GBIFFamilyOriginal` varchar(64) collate utf8_bin default NULL,
499
  `GBIFGenusOriginal` varchar(64) collate utf8_bin default NULL,
500
  `test` tinyint(3) unsigned NOT NULL default '0',
501
  PRIMARY KEY  (`TaxonomyObservationID`),
502
  KEY `RefTaxonDimension301` (`TaxonomyID`),
503
  KEY `Ref614` (`DBPlotID`),
504
  KEY `TaxonomyID_2` (`TaxonomyID`,`DBPlotID`),
505
  KEY `TaxonomyID_3` (`TaxonomyID`,`DBPlotID`),
506
  KEY `TaxonomyID_4` (`TaxonomyID`,`DBPlotID`)
507
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1622693 ;
508

    
509
-- --------------------------------------------------------
510

    
511
--
512
-- Table structure for table `TraitObservation`
513
--
514

    
515
CREATE TABLE IF NOT EXISTS `TraitObservation` (
516
  `TraitObservationID` int(11) unsigned NOT NULL auto_increment,
517
  `TaxonomyID` int(11) unsigned NOT NULL,
518
  `Family` varchar(100) default NULL,
519
  `Genus` varchar(100) default NULL,
520
  `SpecificEpithet` varchar(100) default NULL,
521
  `InfraspecificRank` varchar(25) default NULL,
522
  `InfraspecificEpithet` varchar(100) default NULL,
523
  `Taxon` varchar(255) default NULL,
524
  `AuthorOfScientificName` varchar(255) default NULL,
525
  `TaxonAuthor` varchar(255) default NULL,
526
  `Habit` varchar(50) default NULL,
527
  `TraitName` varchar(200) default NULL,
528
  `TraitValue` varchar(100) default NULL,
529
  `Unit` varchar(100) default NULL,
530
  `Method` varchar(255) default NULL,
531
  `Region` varchar(100) default NULL,
532
  `Country` varchar(100) default NULL,
533
  `StateProvince` varchar(100) default NULL,
534
  `LowerPolitical` varchar(100) default NULL,
535
  `LocalityDescription` varchar(100) default NULL,
536
  `VerbatimLatitude` varchar(150) default NULL,
537
  `VerbatimLongitude` varchar(150) default NULL,
538
  `VerbatimElevation` varchar(150) default NULL,
539
  `Source` varchar(100) default NULL,
540
  `URLSource` varchar(100) default NULL,
541
  `SourceCitation` varchar(1000) default NULL,
542
  `SourceID` varchar(255) default NULL,
543
  `VisitingDate` varchar(100) default NULL,
544
  `ReferenceID` int(11) unsigned default NULL,
545
  `Access` varchar(100) default NULL,
546
  `Project_PI` varchar(255) default NULL,
547
  `Project_PI_contact` varchar(100) default NULL,
548
  `Observation` varchar(255) default NULL,
549
  `Authorship` varchar(255) default NULL,
550
  `AuthorshipContact` varchar(100) default NULL,
551
  PRIMARY KEY  (`TraitObservationID`),
552
  KEY `TaxonomyID` (`TaxonomyID`),
553
  KEY `Family` (`Family`),
554
  KEY `Taxon` (`Taxon`),
555
  KEY `TraitName` (`TraitName`),
556
  KEY `ReferenceID` (`ReferenceID`),
557
  KEY `TaxonAuthor` (`TaxonAuthor`)
558
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Species trait observations' AUTO_INCREMENT=140286 ;
559

    
560
-- --------------------------------------------------------
561

    
562
--
563
-- Table structure for table `viewFullOccurrence`
564
--
565

    
566
CREATE TABLE IF NOT EXISTS `viewFullOccurrence` (
567
  `OccurID` int(11) NOT NULL auto_increment,
568
  `DBPlotID` int(11) default NULL,
569
  `ObservationID` int(11) default NULL,
570
  `Family` varchar(64) default NULL,
571
  `TaxonomyID` int(11) default NULL,
572
  `OrigGenus` varchar(64) default NULL,
573
  `OrigSpecies` varchar(64) default NULL,
574
  `TaxonCorrected` varchar(250) default NULL,
575
  `Genus` varchar(64) default NULL,
576
  `Species` varchar(64) default NULL,
577
  `Latin` varchar(64) default NULL,
578
  `Rank` varchar(16) default NULL,
579
  `Accepted` varchar(2) default NULL,
580
  `TaxonMorphoSpecies` varchar(255) default NULL,
581
  `isCultivated` int(1) default '0',
582
  `isCultivatedReason` varchar(255) default NULL,
583
  `CountryOrig` varchar(100) default NULL,
584
  `CountryStd` varchar(150) default NULL,
585
  `CountryError` double default NULL,
586
  `ProvinceStd` varchar(64) default NULL,
587
  `ProvinceError` double default NULL,
588
  `County` varchar(64) default NULL,
589
  `Plot` varchar(32) default NULL,
590
  `PlotArea` varchar(10) default NULL,
591
  `Latitude` decimal(10,5) default NULL,
592
  `Longitude` decimal(10,5) default NULL,
593
  `isValidLatLong` int(1) default NULL,
594
  `Date` date default NULL,
595
  `SurveyType` varchar(10) default NULL,
596
  `Abund` int(11) default NULL,
597
  `Abund1` int(11) default NULL,
598
  `Abund2.5` int(11) default NULL,
599
  `Abund10` int(11) default NULL,
600
  `PctCover` decimal(10,5) default NULL,
601
  `DataSource` varchar(128) default NULL,
602
  PRIMARY KEY  (`OccurID`),
603
  KEY `DBPlotID` (`DBPlotID`),
604
  KEY `ObservationID` (`ObservationID`),
605
  KEY `Family` (`Family`(16)),
606
  KEY `TaxonCorrected` (`TaxonCorrected`(25)),
607
  KEY `Latin` (`Latin`(25)),
608
  KEY `TaxonomyID` (`TaxonomyID`),
609
  KEY `Genus` (`Genus`(16)),
610
  KEY `Species` (`Species`(20)),
611
  KEY `ORIGLATIN` (`OrigGenus`(16),`OrigSpecies`(20)),
612
  KEY `CountryStd` (`CountryStd`),
613
  KEY `SurveyType` (`SurveyType`),
614
  KEY `DataSource` (`DataSource`),
615
  KEY `Rank` (`Rank`),
616
  KEY `Accepted` (`Accepted`),
617
  KEY `isCultivated` (`isCultivated`),
618
  KEY `isCultivatedReason` (`isCultivatedReason`),
619
  KEY `isValidLatLong` (`isValidLatLong`),
620
  KEY `CountryError` (`CountryError`),
621
  KEY `ProvinceError` (`ProvinceError`)
622
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12050437 ;
623

    
624
-- --------------------------------------------------------
625

    
626
--
627
-- Table structure for table `viewFullOccurrence_bak20110825`
628
--
629

    
630
CREATE TABLE IF NOT EXISTS `viewFullOccurrence_bak20110825` (
631
  `OccurID` int(11) NOT NULL auto_increment,
632
  `DBPlotID` int(11) default NULL,
633
  `ObservationID` int(11) default NULL,
634
  `Family` varchar(64) default NULL,
635
  `TaxonomyID` int(11) default NULL,
636
  `OrigGenus` varchar(64) default NULL,
637
  `OrigSpecies` varchar(64) default NULL,
638
  `TaxonCorrected` varchar(250) default NULL,
639
  `Genus` varchar(64) default NULL,
640
  `Species` varchar(64) default NULL,
641
  `Latin` varchar(64) default NULL,
642
  `Rank` varchar(16) default NULL,
643
  `Accepted` varchar(2) default NULL,
644
  `TaxonMorphoSpecies` varchar(255) default NULL,
645
  `CountryOrig` varchar(100) default NULL,
646
  `CountryStd` varchar(150) default NULL,
647
  `CountryError` double default NULL,
648
  `ProvinceStd` varchar(64) default NULL,
649
  `ProvinceError` double default NULL,
650
  `County` varchar(64) default NULL,
651
  `Plot` varchar(32) default NULL,
652
  `PlotArea` varchar(10) default NULL,
653
  `Latitude` decimal(10,5) default NULL,
654
  `Longitude` decimal(10,5) default NULL,
655
  `Date` date default NULL,
656
  `SurveyType` varchar(10) default NULL,
657
  `Abund` int(11) default NULL,
658
  `Abund1` int(11) default NULL,
659
  `Abund2.5` int(11) default NULL,
660
  `Abund10` int(11) default NULL,
661
  `PctCover` decimal(10,5) default NULL,
662
  `DataSource` varchar(128) default NULL,
663
  PRIMARY KEY  (`OccurID`),
664
  KEY `DBPlotID` (`DBPlotID`),
665
  KEY `ObservationID` (`ObservationID`),
666
  KEY `Family` (`Family`(16)),
667
  KEY `TaxonCorrected` (`TaxonCorrected`(25)),
668
  KEY `ORIGLATIN` (`OrigGenus`(16),`OrigSpecies`(20)),
669
  KEY `CountryStd` (`CountryStd`),
670
  KEY `SurveyType` (`SurveyType`),
671
  KEY `DataSource` (`DataSource`),
672
  KEY `Family_2` (`Family`),
673
  KEY `Rank` (`Rank`),
674
  KEY `CountryError` (`CountryError`),
675
  KEY `ProvinceError` (`ProvinceError`),
676
  KEY `TaxonomyID` (`TaxonomyID`),
677
  KEY `Latin` (`Latin`(25)),
678
  KEY `Accepted` (`Accepted`)
679
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12050437 ;
(8-8/9)