BancoPhpMyAdmin

-- phpMyAdmin SQL Dump
-- version 4.5.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 07-Jul-2016 às 00:38
-- Versão do servidor: 5.7.9
-- PHP Version: 5.6.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `treego1`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `Cadastro`
--

DROP TABLE IF EXISTS `Cadastro`;
CREATE TABLE IF NOT EXISTS `cadastro` (
  `Altura` float NOT NULL,
  `Altura1aRam` float NOT NULL,
  `CopaDiametro1` float NOT NULL,
  `CopaDiametro2` float NOT NULL,
  `CAP1` float NOT NULL,
  `CAP2` float NOT NULL,
  `CAP3` float NOT NULL,
  `CAbase` float NOT NULL,
  `CondicaoGeral` int(11) NOT NULL,
  `FiacaoPrimaria` int(11) NOT NULL,
  `DistanciaPrimaria` float NOT NULL,
  `FiacaoSecundaria` int(11) NOT NULL,
  `DistanciaSecundaria` float NOT NULL,
  `FiacaoDerivacao` int(11) NOT NULL,
  `DistanciaDerivacao` float NOT NULL,
  `OutroConflito` int(11) NOT NULL,
  `OutraPlanta` int(11) NOT NULL,
  `DistanciaOutroConflito` float NOT NULL,
  `RedeCompacta` int(11) NOT NULL,
  `RaizErguendoCalcada` int(11) NOT NULL,
  `AdequacaoCanteiro` int(11) NOT NULL,
  `QualidadePoda` int(11) NOT NULL,
  `Localizacao` text NOT NULL,
  `Cupim` int(11) NOT NULL,
  `FormigaCarpinteira` int(11) NOT NULL,
  `PodridaoNegra` int(11) NOT NULL,
  `PodridaoBranca` int(11) NOT NULL,
  `OcoBase` int(11) NOT NULL,
  `V` int(11) NOT NULL,
  `Oco1aRam` int(11) NOT NULL,
  `OutraPragaDoenca` int(11) NOT NULL,
  `GravidadeAlvo` int(11) NOT NULL,
  `CorpoFrutiBase` int(11) NOT NULL,
  `CorpoFruti1a|Ram` int(11) NOT NULL,
  `Anelamento` int(11) NOT NULL,
  `ColoSoterrado` int(11) NOT NULL,
  `InjuriasRaizes` int(11) NOT NULL,
  `TipoCalcada` text NOT NULL,
  `SecaBase` int(11) NOT NULL,
  `Via` text NOT NULL,
  `DAP` float NOT NULL,
  `Tempo` time NOT NULL,
  `NomeComum` text NOT NULL,
  `Genero` text NOT NULL,
  `IRQ` double NOT NULL,
  `Especie` text NOT NULL,
  `VolumeCopa` float NOT NULL,
  `AnguloInclinacao` int(11) NOT NULL,
  `Comprimento` float NOT NULL,
  `AreaCopa` float NOT NULL,
  `DiametroBase` float NOT NULL,
  `OutrasRecomendacoes` text NOT NULL,
  `Recomendacoes` text NOT NULL,
  `Bairro` text NOT NULL,
  `NrImovel` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;