|
1 |
{\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 |
}
|
|
58 |
|
inputs/CTFS/: Added non-data files that weren't under version control