| 1 |
4313
|
aaronmk
|
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}
|
| 2 |
|
|
{\*\generator Msftedit 5.41.15.1515;}\viewkind4\uc1\pard\f0\fs20 --\par
|
| 3 |
|
|
-- Table structure for table `DFtemp`\par
|
| 4 |
|
|
--\par
|
| 5 |
|
|
\par
|
| 6 |
|
|
CREATE TABLE IF NOT EXISTS `DFtemp` (\par
|
| 7 |
|
|
`MeasureID` int(11) NOT NULL,\par
|
| 8 |
|
|
`PlotID` int(11) NOT NULL,\par
|
| 9 |
|
|
`Plot` varchar(35) default NULL,\par
|
| 10 |
|
|
`Family` char(32) default NULL,\par
|
| 11 |
|
|
`GenusSpecies` char(64) default NULL,\par
|
| 12 |
|
|
`Genus` char(32) default NULL,\par
|
| 13 |
|
|
`SpeciesName` char(64) default NULL,\par
|
| 14 |
|
|
`SpeciesID` int(10) unsigned default NULL,\par
|
| 15 |
|
|
`Mnemonic` char(10) default NULL,\par
|
| 16 |
|
|
`QuadratID` int(11) NOT NULL,\par
|
| 17 |
|
|
`QuadratName` varchar(12) default NULL,\par
|
| 18 |
|
|
`x` float default NULL,\par
|
| 19 |
|
|
`y` float default NULL,\par
|
| 20 |
|
|
`gx` float default NULL,\par
|
| 21 |
|
|
`gy` float default NULL,\par
|
| 22 |
|
|
`TreeID` int(11) NOT NULL,\par
|
| 23 |
|
|
`Tag` char(10) default NULL,\par
|
| 24 |
|
|
`StemID` int(11) NOT NULL,\par
|
| 25 |
|
|
`StemTag` varchar(32) default NULL,\par
|
| 26 |
|
|
`PrimaryStem` char(20) default NULL,\par
|
| 27 |
|
|
`CensusID` int(11) NOT NULL,\par
|
| 28 |
|
|
`PlotCensusNumber` int(11) default NULL,\par
|
| 29 |
|
|
`DBH` float default NULL,\par
|
| 30 |
|
|
`HOM` float default NULL,\par
|
| 31 |
|
|
`ExactDate` date default NULL,\par
|
| 32 |
|
|
`ListOfTSM` varchar(256) default NULL,\par
|
| 33 |
|
|
`Status` varchar(15) default NULL,\par
|
| 34 |
|
|
PRIMARY KEY (`MeasureID`,`CensusID`),\par
|
| 35 |
|
|
KEY `PlotID` (`PlotID`),\par
|
| 36 |
|
|
KEY `Genus` (`Genus`(5)),\par
|
| 37 |
|
|
KEY `SpeciesName` (`SpeciesName`(5)),\par
|
| 38 |
|
|
KEY `SpeciesID` (`SpeciesID`),\par
|
| 39 |
|
|
KEY `QuadratName` (`QuadratName`(4)),\par
|
| 40 |
|
|
KEY `PlotCensusNumber` (`PlotCensusNumber`),\par
|
| 41 |
|
|
KEY `DBH` (`DBH`),\par
|
| 42 |
|
|
KEY `PrimaryStem` (`PrimaryStem`),\par
|
| 43 |
|
|
KEY `ListOfTSM` (`ListOfTSM`),\par
|
| 44 |
|
|
KEY `Status` (`Status`),\par
|
| 45 |
|
|
KEY `ForDataEntry` (`TreeID`,`StemID`,`CensusID`),\par
|
| 46 |
|
|
KEY `ForDataScreening` (`Tag`,`StemTag`,`PlotID`),\par
|
| 47 |
|
|
KEY `CensusID` (`CensusID`),\par
|
| 48 |
|
|
KEY `QuadratID` (`QuadratID`)\par
|
| 49 |
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;\par
|
| 50 |
|
|
\par
|
| 51 |
|
|
--\par
|
| 52 |
|
|
-- Dumping data for table `DFtemp`\par
|
| 53 |
|
|
--\par
|
| 54 |
|
|
\par
|
| 55 |
|
|
INSERT INTO `DFtemp` (`MeasureID`, `PlotID`, `Plot`, `Family`, `GenusSpecies`, `Genus`, `SpeciesName`, `SpeciesID`, `Mnemonic`, `QuadratID`, `QuadratName`, `x`, `y`, `gx`, `gy`, `TreeID`, `Tag`, `StemID`, `StemTag`, `PrimaryStem`, `CensusID`, `PlotCensusNumber`, `DBH`, `HOM`, `ExactDate`, `ListOfTSM`, `Status`) VALUES\par
|
| 56 |
|
|
(1, 1, 'bci', 'Fabaceae-papilionoideae', 'Swartzia simplex', 'Swartzia', 'simplex', 980, 'swars1', 1008, '4007', 0.2, 12.2, 800.2, 152.2, 1, '-05599', 1, 'a', 'main', 1, 1, 90, 1.3, '1981-06-12', NULL, 'alive'),\par
|
| 57 |
|
|
}
|
