{"id":40,"date":"2014-03-15T15:46:41","date_gmt":"2014-03-15T18:46:41","guid":{"rendered":"http:\/\/www.luppi.com.br\/?p=40"},"modified":"2014-03-21T18:35:50","modified_gmt":"2014-03-21T21:35:50","slug":"dump-mysql-teste","status":"publish","type":"post","link":"http:\/\/www.luppi.com.br\/?p=40","title":{"rendered":"Dump MySQL teste"},"content":{"rendered":"<p>&#8212; phpMyAdmin SQL Dump<br \/>\n&#8212; version 4.0.6deb1<br \/>\n&#8212; http:\/\/www.phpmyadmin.net<br \/>\n&#8212;<br \/>\n&#8212; M\u00e1quina: localhost<br \/>\n&#8212; Data de Cria\u00e7\u00e3o: 15-Mar-2014 \u00e0s 18:44<br \/>\n&#8212; Vers\u00e3o do servidor: 5.5.35-0ubuntu0.13.10.2<br \/>\n&#8212; vers\u00e3o do PHP: 5.5.3-1ubuntu2.2<\/p>\n<p>SET SQL_MODE = &#8220;NO_AUTO_VALUE_ON_ZERO&#8221;;<br \/>\nSET time_zone = &#8220;+00:00&#8243;;<\/p>\n<p>\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;<br \/>\n\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;<br \/>\n\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;<br \/>\n\/*!40101 SET NAMES utf8 *\/;<\/p>\n<p>&#8212;<br \/>\n&#8212; Base de Dados: `adega_univel`<br \/>\n&#8212;<\/p>\n<p>&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p>&#8212;<br \/>\n&#8212; Estrutura da tabela `vinho`<br \/>\n&#8212;<\/p>\n<p>CREATE TABLE IF NOT EXISTS `vinho` (<br \/>\n`id` int(11) NOT NULL AUTO_INCREMENT,<br \/>\n`name` varchar(50) NOT NULL,<br \/>\n`year` year(4) NOT NULL,<br \/>\n`grapes` varchar(50) NOT NULL,<br \/>\n`country` varchar(30) NOT NULL,<br \/>\n`region` varchar(30) NOT NULL,<br \/>\n`description` text NOT NULL,<br \/>\n`picture` blob NOT NULL,<br \/>\nPRIMARY KEY (`id`)<br \/>\n) ENGINE=InnoDB\u00a0 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;<\/p>\n<p>&#8212;<br \/>\n&#8212; Extraindo dados da tabela `vinho`<br \/>\n&#8212;<\/p>\n<p>INSERT INTO `vinho` (`id`, `name`, `year`, `grapes`, `country`, `region`, `description`, `picture`) VALUES<br \/>\n(1, &#8216;Concha y Toro Reserva&#8217;, 2009, &#8216;Cabernet Sauvignon&#8217;, &#8216;Chile&#8217;, &#8216;Vale Nevado&#8217;, &#8216;Descri\u00e7\u00e3o&#8217;, &#8221;),<br \/>\n(2, &#8216;Almalaya&#8217;, 2011, &#8216;Malbec&#8217;, &#8216;Argentina&#8217;, &#8216;Mendoza&#8217;, &#8216;Bom vinho&#8217;, &#8221;),<br \/>\n(3, &#8216;Alamos&#8217;, 2009, &#8216;Caberbet Sauvignon&#8217;, &#8216;Argentina&#8217;, &#8216;Mendoza&#8217;, &#8216;Belo custo beneficio&#8217;, &#8221;),<br \/>\n(4, &#8216;DV Catena&#8217;, 2008, &#8216;Caberbet Sauvignon&#8217;, &#8216;Argentina&#8217;, &#8216;Mendoza&#8217;, &#8216;Muito bom&#8217;, &#8221;),<br \/>\n(5, &#8216;Mosteiro&#8217;, 2013, &#8216;Caberbet Sauvignon&#8217;, &#8216;Brasil&#8217;, &#8216;Rio Grande do Sul&#8217;, &#8216;Dor de cabe\u00e7a intensa&#8217;, &#8221;),<br \/>\n(6, &#8216;Perini Reserva&#8217;, 2013, &#8216;Caberbet Sauvignon&#8217;, &#8216;Brasil&#8217;, &#8216;Rio Grande do Sul&#8217;, &#8216;Vale o teste&#8217;, &#8221;);<\/p>\n<p>\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;<br \/>\n\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;<br \/>\n\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8212; phpMyAdmin SQL Dump &#8212; version 4.0.6deb1 &#8212; http:\/\/www.phpmyadmin.net &#8212; &#8212; M\u00e1quina: localhost &#8212; Data de Cria\u00e7\u00e3o: 15-Mar-2014 \u00e0s 18:44 &#8212; Vers\u00e3o do servidor: 5.5.35-0ubuntu0.13.10.2 &#8212; vers\u00e3o do PHP: 5.5.3-1ubuntu2.2 SET SQL_MODE = &#8220;NO_AUTO_VALUE_ON_ZERO&#8221;; SET time_zone = &#8220;+00:00&#8243;; \/*!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 *\/; &#8212; &#8212; Base de Dados: `adega_univel` &#8212; &#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212; &#8212; Estrutura da tabela `vinho` &#8212; CREATE TABLE IF NOT EXISTS `vinho` ( `id` int(11)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[3],"tags":[],"_links":{"self":[{"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/posts\/40"}],"collection":[{"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=40"}],"version-history":[{"count":2,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/posts\/40\/revisions"}],"predecessor-version":[{"id":42,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/posts\/40\/revisions\/42"}],"wp:attachment":[{"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=40"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=40"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}