DRONES AGRÍCOLAS

— phpMyAdmin SQL Dump
— version 4.0.6deb1
— http://www.phpmyadmin.net
—
— Máquina: localhost
— Data de Criação: 15-Mar-2014 às 18:44
— Versão do servidor: 5.5.35-0ubuntu0.13.10.2
— versão do PHP: 5.5.3-1ubuntu2.2

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 utf8 */;

—
— Base de Dados: `adega_univel`
—

— ——————————————————–

—
— Estrutura da tabela `vinho`
—

CREATE TABLE IF NOT EXISTS `vinho` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`year` year(4) NOT NULL,
`grapes` varchar(50) NOT NULL,
`country` varchar(30) NOT NULL,
`region` varchar(30) NOT NULL,
`description` text NOT NULL,
`picture` blob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

—
— Extraindo dados da tabela `vinho`
—

INSERT INTO `vinho` (`id`, `name`, `year`, `grapes`, `country`, `region`, `description`, `picture`) VALUES
(1, ‘Concha y Toro Reserva’, 2009, ‘Cabernet Sauvignon’, ‘Chile’, ‘Vale Nevado’, ‘Descrição’, ”),
(2, ‘Almalaya’, 2011, ‘Malbec’, ‘Argentina’, ‘Mendoza’, ‘Bom vinho’, ”),
(3, ‘Alamos’, 2009, ‘Caberbet Sauvignon’, ‘Argentina’, ‘Mendoza’, ‘Belo custo beneficio’, ”),
(4, ‘DV Catena’, 2008, ‘Caberbet Sauvignon’, ‘Argentina’, ‘Mendoza’, ‘Muito bom’, ”),
(5, ‘Mosteiro’, 2013, ‘Caberbet Sauvignon’, ‘Brasil’, ‘Rio Grande do Sul’, ‘Dor de cabeça intensa’, ”),
(6, ‘Perini Reserva’, 2013, ‘Caberbet Sauvignon’, ‘Brasil’, ‘Rio Grande do Sul’, ‘Vale o teste’, ”);

/*!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 */;