-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `l2j`
--

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL,
  `title` varchar(255) NOT NULL,
  `info1` text,
  `info2` text,
  `info3` text,
  `link1` text,
  `link2` text,
  `link3` text,
  `path` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `order` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `categories_has_contents`
--

CREATE TABLE `categories_has_contents` (
  `categories_id` int(11) NOT NULL,
  `contents_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `contents`
--

CREATE TABLE `contents` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text,
  `short_description` varchar(255) DEFAULT NULL,
  `content` longtext,
  `image` varchar(255) DEFAULT NULL,
  `type` varchar(45) NOT NULL COMMENT 'post,news,page,page-name',
  `url` varchar(45) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contents`
--

INSERT INTO `contents` (`id`, `title`, `description`, `short_description`, `content`, `image`, `type`, `url`, `created_at`, `updated_at`) VALUES
(1, 'AQUÁRIOS CLEAN', NULL, NULL, '<p><b>Descrição:</b> Aquário produzido sem travas superiores, ideais para ambientes onde se quer algo inovador e estético\r\n<br><b>Vidros:</b> Fabricado sob medida, Vidros Lapidados, Extra Clear e Comum <br><b>Sistemas:</b> Sistema de botas, Sump Traseiro, Canister. <br><b>Travamento:</b> Travas francesas inferiores.&nbsp;</p><p><br></p>', '15749155145ddf4dbae2f77.jpeg', 'produtos', 'aquarios-clean', '2019-11-28 04:03:05', '2019-11-28 04:31:54'),
(2, 'AQUÁRIOS COM BOTAS', NULL, NULL, '<p><b>Descrição:</b> Aquário produzido com sistema de botas, ideal para aquários que necessitam de uma filtragem maior, onde se obtêm uma qualidade maior aos animais.\r\n<br><b>Vidros:</b>Fabricado sob medida, Vidros Lapidados, Extra Clear e  Comum&nbsp;<br><b>Sistemas:</b> Sistema de botas centrais, laterais, sexto vidro e personalizados&nbsp;<br><b>Travamento: </b>Travas francesas inferiores e superiores, travas simples&nbsp;</p><p><br></p>', '15749174115ddf5523a3f93.jpeg', 'produtos', 'aquarios-com-botas', '2019-11-28 05:03:31', '2019-11-28 05:03:31'),
(3, 'AQUÁRIOS SIMPLES', NULL, NULL, '<p><b>Descrição:</b> Aquário padrão de mercado, ideal para iniciantes ou sistemas que necessitam de uma filtragem mais simples.\r\n<br><b>Vidros:</b>Fabricado sob medida, Vidros Lapidados, Extra Clear e Comum. <br><b>Sistemas:</b> Sistema para filtros internos, externos, canister. <br><b>Travamento:</b> Travas francesas inferiores e superiores, travas simples.&nbsp;</p><p><br></p>', '15749182825ddf588aeaada.jpeg', 'produtos', 'aquarios-simples', '2019-11-28 05:18:02', '2019-11-28 05:18:02'),
(4, 'AQUÁRIOS SUMP TRASEIRO', NULL, NULL, '<p><b>Descrição:</b> Aquário produzido com filtro acoplado na caixa de vidro, tanto lateral como traseiro, utilizados em balcões, mesas de escritórios ou locais onde não consegue um filtro inferior. Sistemas que necessitam de uma filtragem mediana.\r\n<br><b>Vidros:</b>Fabricado sob medida, Vidros Lapidados, Extra Clear e Comum. <br><b>Sistemas: </b>Sistema de filtro acoplado na lateral, traseiro ou personalizado. <br><b>Travamento: </b>Travas francesas inferiores e superiores, travas simples ou sem travas superiores.&nbsp;</p><p><br></p>', '15749185075ddf596b5fa46.jpeg', 'produtos', 'aquarios-sump-traseiro', '2019-11-28 05:21:47', '2019-11-28 05:21:47'),
(5, 'BASE METALON COM MADEIRAS DE APOIO', NULL, NULL, '<p><b>Descrição:</b> Móvel fabricado com metalon galvanizado, pintura sintética, sem revestimento, com madeiras de apoio superior e inferior. Custo beneficio x Resistência.\r\n<br><b>Dimensões:</b>Fabricado sob medida, conforme o projeto a ser executado. <br><b>Pintura: </b>Pode ser sintético ou eletrostático. Cores preto ou branco.&nbsp;</p><p><br></p>', '15749185935ddf59c1803e6.jpeg', 'produtos', 'base-metalon-com-madeiras-de-apoio', '2019-11-28 05:23:13', '2019-11-28 05:23:13'),
(6, 'BASE METALON SIMPLES', NULL, NULL, '<p><b>Descrição:</b> Móvel fabricado com metalon galvanizado, pintura sintética e sem revestimento. Custo beneficio x Resistência.\r\n<br><b>Dimensões:</b>Fabricado sob medida, conforme o projeto a ser executado.&nbsp;<br><b>Pintura: </b>Pode ser sintético ou eletrostático. Cores preto ou branco.&nbsp;</p><p><br></p>', '15749202285ddf60244ab2a.jpeg', 'produtos', 'base-metalon-simples', '2019-11-28 05:50:28', '2019-11-28 05:50:28'),
(7, 'BATERIA CORAL E PLANTAS', NULL, NULL, '<p><b>Descrição:</b> Bateria fabricada conforme o projeto estipulado. Ideal para lojas onde se tem o interesse de venda de corais e plantas, melhorando a qualidade na venda e exposição dos mesmos. \r\n<br><b>Dimensões:</b>Fabricado sob medida, conforme o projeto a ser executado. <br><b>Sistemas:</b> Fabricado no sistema de sump inferior, sump lateral, sump traseiro, filtro externo e/ou interno. <br><b>Encanamento:</b> Fabricado com encanamento completo subida e descida. <br><b>Acabamento:</b> Fabricado com acabamento externo em alumínio com Poliestireno. Atrativo nas vendas e melhorando a visibilidade do ambiente.&nbsp;</p><p><br></p>', '15749204125ddf60dcd4fa6.jpeg', 'produtos', 'bateria-coral-e-plantas', '2019-11-28 05:53:32', '2019-11-28 05:53:32'),
(8, 'BATERIAS EXPOSITORAS', NULL, NULL, '<p>Descrição: Bateria expositora fabricada conforme o projeto estipulado. Ideal para lojas onde se tem o interesse de venda de animais, melhorando a qualidade na venda e exposição dos mesmos. \r\n<br>Dimensões:Fabricado sob medida, conforme o projeto a ser executado. <br>Sistemas: Fabricado no sistema de sump inferior, sump lateral, sump traseiro, filtro externo e/ou interno. <br>Encanamento: Fabricado com encanamento completo subida e descida. <br>Acabamento: Fabricado com acabamento externo em alumínio com Poliestireno. Atrativo nas vendas e melhorando a visibilidade do ambiente.&nbsp;</p><p><br></p>', '15749205115ddf613f0feae.jpeg', 'produtos', 'baterias-expositoras', '2019-11-28 05:55:11', '2019-11-28 05:55:11'),
(9, 'MÓVEL PERSONALIZADO', NULL, NULL, '<p><b>Descrição:</b> Móvel fabricado em metalon galvanizado revestido em MDF Laminado, pintura sintética, totalmente personalizado, algo fora do padrão ou conforme o projeto do cliente, algo que não se vê no mercado. Ideal para projetos onde o cliente transforma sua ideia em realidade.<br><b>Dimensões:</b>Fabricado sob medida, conforme o projeto a ser executado.<br><b>Pintura:</b> Pode ser sintético ou eletrostático. Cores preto ou branco.<br><b>Revestimento:</b> Revestimento em MDF e outros materiais conforme o projeto exigir na montagem.</p><p><br></p>', '15749205745ddf617e75b5c.jpeg', 'produtos', 'movel-personalizado', '2019-11-28 05:56:14', '2019-11-28 05:56:14'),
(10, 'MÓVEL REVESTIDO COM TAMPA', NULL, NULL, '<p><b>Descrição:</b> Móvel fabricado em metalon galvanizado revestido em MDF Laminado, pintura sintética, com madeiras de apoio superior e inferior. Móvel ideal para Aquários grandes, onde os mesmo necessitam de resistencia, além do acabamento externo combinando a Estética x Residência.\r\n<br><b>Dimensões:</b>Fabricado sob medida, conforme o projeto a ser executado. <br><b>Pintura:</b> Pode ser sintético ou eletrostático. Cores preto ou branco. <br><b>Revestimento:</b> Revestimento em MDF e outros materiais conforme o projeto exigir na montagem.&nbsp;</p><p><br></p>', '15749207425ddf6226aa2e1.jpeg', 'produtos', 'movel-revestido-com-tampa', '2019-11-28 05:59:02', '2019-11-28 05:59:02');

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

--
-- Table structure for table `contents_has_contents`
--

CREATE TABLE `contents_has_contents` (
  `contents_id` int(11) NOT NULL,
  `contents_child_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `contents_images`
--

CREATE TABLE `contents_images` (
  `id` int(11) NOT NULL,
  `description` text,
  `type` varchar(45) DEFAULT NULL,
  `order` varchar(45) DEFAULT NULL,
  `image` text,
  `contents_id` int(11) NOT NULL,
  `path` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contents_images`
--

INSERT INTO `contents_images` (`id`, `description`, `type`, `order`, `image`, `contents_id`, `path`) VALUES
(1, '', 'gallery', '0', '15749155145ddf4dbaeb3b9.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(2, '', 'gallery', '0', '15749155155ddf4dbb0b342.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(3, '', 'gallery', '0', '15749155155ddf4dbb1fec7.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(4, '', 'gallery', '0', '15749155155ddf4dbb39ad6.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(5, '', 'gallery', '0', '15749155155ddf4dbb3fc86.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(6, '', 'gallery', '0', '15749155155ddf4dbb59f87.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(7, '', 'gallery', '0', '15749155155ddf4dbb6e532.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(8, '', 'gallery', '0', '15749155155ddf4dbb847ee.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(9, '', 'gallery', '0', '15749155155ddf4dbb96a4d.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(10, '', 'gallery', '0', '15749155155ddf4dbbacf3f.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(11, '', 'gallery', '0', '15749155155ddf4dbbc12da.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(12, '', 'gallery', '0', '15749155155ddf4dbbebb13.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(13, '', 'gallery', '0', '15749155165ddf4dbc27fa1.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(14, '', 'gallery', '0', '15749155165ddf4dbc38186.jpeg', 1, 'D:\\www\\l2j.com.br\\public_html\\public/content//1/'),
(15, '', 'gallery', '0', '15749178615ddf56e5f0767.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(16, '', 'gallery', '0', '15749178625ddf56e6132b5.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(17, '', 'gallery', '0', '15749178625ddf56e6254bf.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(18, '', 'gallery', '0', '15749178625ddf56e637df9.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(19, '', 'gallery', '0', '15749178625ddf56e65dedf.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(20, '', 'gallery', '0', '15749178625ddf56e6731c0.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(21, '', 'gallery', '0', '15749178625ddf56e68244d.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(22, '', 'gallery', '0', '15749178625ddf56e69072d.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(23, '', 'gallery', '0', '15749178625ddf56e69e9cc.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(24, '', 'gallery', '0', '15749178625ddf56e6aed21.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(25, '', 'gallery', '0', '15749178625ddf56e6b6ec4.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(26, '', 'gallery', '0', '15749178625ddf56e6c70a6.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(27, '', 'gallery', '0', '15749178625ddf56e6cf1cf.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(28, '', 'gallery', '0', '15749178625ddf56e6da5e0.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(29, '', 'gallery', '0', '15749178625ddf56e6e95a0.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(30, '', 'gallery', '0', '15749178625ddf56e6ef74f.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(31, '', 'gallery', '0', '15749178635ddf56e709730.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(32, '', 'gallery', '0', '15749178635ddf56e71187f.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(33, '', 'gallery', '0', '15749178635ddf56e721bdd.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(34, '', 'gallery', '0', '15749178635ddf56e729cfe.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(35, '', 'gallery', '0', '15749178635ddf56e72fe80.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(36, '', 'gallery', '0', '15749178635ddf56e748fcb.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(37, '', 'gallery', '0', '15749178635ddf56e7646a1.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(38, '', 'gallery', '0', '15749178635ddf56e7708cf.jpeg', 2, 'D:\\www\\l2j.com.br\\public_html\\public/content//2/'),
(39, '', 'gallery', '0', '15749184145ddf590e6fa2e.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(40, '', 'gallery', '0', '15749184145ddf590e7fda2.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(41, '', 'gallery', '0', '15749184145ddf590e8e0e9.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(42, '', 'gallery', '0', '15749184145ddf590e9c38c.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(43, '', 'gallery', '0', '15749184145ddf590ea664e.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(44, '', 'gallery', '0', '15749184145ddf590eb87ca.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(45, '', 'gallery', '0', '15749184145ddf590ee3697.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(46, '', 'gallery', '0', '15749184155ddf590f0b378.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(47, '', 'gallery', '0', '15749184155ddf590f18a36.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(48, '', 'gallery', '0', '15749184155ddf590f2bac4.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(49, '', 'gallery', '0', '15749184155ddf590f41608.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(50, '', 'gallery', '0', '15749184155ddf590f580a4.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(51, '', 'gallery', '0', '15749184155ddf590f681b0.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(52, '', 'gallery', '0', '15749184155ddf590f7646a.jpeg', 3, 'D:\\www\\l2j.com.br\\public_html\\public/content//3/'),
(53, '', 'gallery', '0', '15749185075ddf596b7ef83.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(54, '', 'gallery', '0', '15749185075ddf596b92172.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(55, '', 'gallery', '0', '15749185075ddf596ba1536.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(56, '', 'gallery', '0', '15749185075ddf596baf7de.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(57, '', 'gallery', '0', '15749185075ddf596bbd804.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(58, '', 'gallery', '0', '15749185075ddf596bd1e21.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(59, '', 'gallery', '0', '15749185075ddf596be204e.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(60, '', 'gallery', '0', '15749185075ddf596bf02bd.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(61, '', 'gallery', '0', '15749185085ddf596c16515.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(62, '', 'gallery', '0', '15749185085ddf596c2056c.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(63, '', 'gallery', '0', '15749185085ddf596c34a7a.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(64, '', 'gallery', '0', '15749185085ddf596c44c7f.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(65, '', 'gallery', '0', '15749185085ddf596c54ded.jpeg', 4, 'D:\\www\\l2j.com.br\\public_html\\public/content//4/'),
(66, '', 'gallery', '0', '15749185935ddf59c1af689.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(67, '', 'gallery', '0', '15749185935ddf59c1d3f13.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(68, '', 'gallery', '0', '15749185935ddf59c1e637f.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(69, '', 'gallery', '0', '15749185945ddf59c214c12.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(70, '', 'gallery', '0', '15749185945ddf59c224c56.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(71, '', 'gallery', '0', '15749185945ddf59c23a776.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(72, '', 'gallery', '0', '15749185945ddf59c244f92.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(73, '', 'gallery', '0', '15749185945ddf59c250cb8.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(74, '', 'gallery', '0', '15749185945ddf59c26109c.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(75, '', 'gallery', '0', '15749185945ddf59c26b33c.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(76, '', 'gallery', '0', '15749185945ddf59c27de19.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(77, '', 'gallery', '0', '15749185945ddf59c2a59cb.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(78, '', 'gallery', '0', '15749185945ddf59c2adebb.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(79, '', 'gallery', '0', '15749185945ddf59c2be7b3.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(80, '', 'gallery', '0', '15749185945ddf59c2ca0cc.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(81, '', 'gallery', '0', '15749185945ddf59c2d8461.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(82, '', 'gallery', '0', '15749185945ddf59c2e0671.jpeg', 5, 'D:\\www\\l2j.com.br\\public_html\\public/content//5/'),
(83, '', 'gallery', '0', '15749202655ddf604984ec1.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(84, '', 'gallery', '0', '15749202655ddf60499117c.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(85, '', 'gallery', '0', '15749202655ddf60499b1f7.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(86, '', 'gallery', '0', '15749202655ddf6049a33d4.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(87, '', 'gallery', '0', '15749202655ddf6049ad59b.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(88, '', 'gallery', '0', '15749202655ddf6049c00b7.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(89, '', 'gallery', '0', '15749202655ddf6049d3d20.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(90, '', 'gallery', '0', '15749202655ddf6049dbdcf.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(91, '', 'gallery', '0', '15749202655ddf6049e5e6a.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(92, '', 'gallery', '0', '15749202655ddf6049ee0ac.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(93, '', 'gallery', '0', '15749202665ddf604a01edd.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(94, '', 'gallery', '0', '15749202665ddf604a080f5.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(95, '', 'gallery', '0', '15749202665ddf604a2d068.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(96, '', 'gallery', '0', '15749202665ddf604a42c1d.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(97, '', 'gallery', '0', '15749202665ddf604a4cc6c.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(98, '', 'gallery', '0', '15749202665ddf604a5b148.jpeg', 6, 'D:\\www\\l2j.com.br\\public_html\\public/content//6/'),
(99, '', 'gallery', '0', '15749204135ddf60dd06d8f.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(100, '', 'gallery', '0', '15749204135ddf60dd17245.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(101, '', 'gallery', '0', '15749204135ddf60dd2a24e.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(102, '', 'gallery', '0', '15749204135ddf60dd3d832.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(103, '', 'gallery', '0', '15749204135ddf60dd497f7.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(104, '', 'gallery', '0', '15749204135ddf60dd5a270.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(105, '', 'gallery', '0', '15749204135ddf60dd61c05.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(106, '', 'gallery', '0', '15749204135ddf60dd6dd8a.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(107, '', 'gallery', '0', '15749204135ddf60dd86376.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(108, '', 'gallery', '0', '15749204135ddf60dd906e0.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(109, '', 'gallery', '0', '15749204135ddf60dda0907.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(110, '', 'gallery', '0', '15749204135ddf60ddaab29.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(111, '', 'gallery', '0', '15749204135ddf60ddb4aa3.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(112, '', 'gallery', '0', '15749204135ddf60ddbad85.jpeg', 7, 'D:\\www\\l2j.com.br\\public_html\\public/content//7/'),
(113, '', 'gallery', '0', '15749205115ddf613f367aa.jpeg', 8, 'D:\\www\\l2j.com.br\\public_html\\public/content//8/'),
(114, '', 'gallery', '0', '15749205115ddf613f3cb83.jpeg', 8, 'D:\\www\\l2j.com.br\\public_html\\public/content//8/'),
(115, '', 'gallery', '0', '15749205115ddf613f449ce.jpeg', 8, 'D:\\www\\l2j.com.br\\public_html\\public/content//8/'),
(116, '', 'gallery', '0', '15749205115ddf613f4ae51.jpeg', 8, 'D:\\www\\l2j.com.br\\public_html\\public/content//8/'),
(117, '', 'gallery', '0', '15749205115ddf613f52cc8.jpeg', 8, 'D:\\www\\l2j.com.br\\public_html\\public/content//8/'),
(118, '', 'gallery', '0', '15749205115ddf613f5f0c6.jpeg', 8, 'D:\\www\\l2j.com.br\\public_html\\public/content//8/'),
(119, '', 'gallery', '0', '15749205745ddf617e958fa.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(120, '', 'gallery', '0', '15749205745ddf617ea167e.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(121, '', 'gallery', '0', '15749205745ddf617ea9b3b.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(122, '', 'gallery', '0', '15749205745ddf617eb81b9.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(123, '', 'gallery', '0', '15749205745ddf617ec60f7.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(124, '', 'gallery', '0', '15749205745ddf617ed6263.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(125, '', 'gallery', '0', '15749205755ddf617f0ccba.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(126, '', 'gallery', '0', '15749205755ddf617f20c1f.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(127, '', 'gallery', '0', '15749205755ddf617f34f3f.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(128, '', 'gallery', '0', '15749205755ddf617f4aff4.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(129, '', 'gallery', '0', '15749205755ddf617f55434.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(130, '', 'gallery', '0', '15749205755ddf617f5f38b.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(131, '', 'gallery', '0', '15749205755ddf617f698ae.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(132, '', 'gallery', '0', '15749205755ddf617f7dceb.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(133, '', 'gallery', '0', '15749205755ddf617f87aa8.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(134, '', 'gallery', '0', '15749205755ddf617fa045c.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(135, '', 'gallery', '0', '15749205755ddf617fbc19c.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(136, '', 'gallery', '0', '15749205755ddf617fc6896.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(137, '', 'gallery', '0', '15749205755ddf617fd055f.jpeg', 9, 'D:\\www\\l2j.com.br\\public_html\\public/content//9/'),
(138, '', 'gallery', '0', '15749207425ddf6226b1dc9.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(139, '', 'gallery', '0', '15749207425ddf6226ba089.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(140, '', 'gallery', '0', '15749207425ddf6226d012f.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(141, '', 'gallery', '0', '15749207425ddf6226dc645.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(142, '', 'gallery', '0', '15749207425ddf6226e451a.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(143, '', 'gallery', '0', '15749207425ddf6226f30b9.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(144, '', 'gallery', '0', '15749207435ddf622708a16.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(145, '', 'gallery', '0', '15749207435ddf622710b10.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(146, '', 'gallery', '0', '15749207435ddf62271bb00.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(147, '', 'gallery', '0', '15749207435ddf622726eaf.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(148, '', 'gallery', '0', '15749207435ddf6227310b9.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(149, '', 'gallery', '0', '15749207435ddf62273ae02.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(150, '', 'gallery', '0', '15749207435ddf6227494f1.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(151, '', 'gallery', '0', '15749207435ddf622759377.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(152, '', 'gallery', '0', '15749207435ddf62275f886.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(153, '', 'gallery', '0', '15749207435ddf62276fbbf.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(154, '', 'gallery', '0', '15749207435ddf62277ed0c.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(155, '', 'gallery', '0', '15749207435ddf622787f7b.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(156, '', 'gallery', '0', '15749207435ddf62279213f.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(157, '', 'gallery', '0', '15749207435ddf62279bf16.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(158, '', 'gallery', '0', '15749207435ddf6227a6540.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(159, '', 'gallery', '0', '15749207435ddf6227b020c.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(160, '', 'gallery', '0', '15749207435ddf6227b66ef.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(161, '', 'gallery', '0', '15749207435ddf6227c0774.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(162, '', 'gallery', '0', '15749207435ddf6227d6844.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(163, '', 'gallery', '0', '15749207435ddf6227e0e50.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(164, '', 'gallery', '0', '15749207435ddf6227e8b84.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(165, '', 'gallery', '0', '15749207435ddf6227f1103.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(166, '', 'gallery', '0', '15749207445ddf622811377.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(167, '', 'gallery', '0', '15749207445ddf622820adf.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(168, '', 'gallery', '0', '15749207445ddf62282b306.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(169, '', 'gallery', '0', '15749207445ddf622833805.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(170, '', 'gallery', '0', '15749207445ddf622841a8d.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(171, '', 'gallery', '0', '15749207445ddf622851a80.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(172, '', 'gallery', '0', '15749207445ddf622857e72.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(173, '', 'gallery', '0', '15749207445ddf62285fd0a.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(174, '', 'gallery', '0', '15749207445ddf6228660c9.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(175, '', 'gallery', '0', '15749207445ddf62286dfaf.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(176, '', 'gallery', '0', '15749207445ddf62287436b.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(177, '', 'gallery', '0', '15749207445ddf62287d7a4.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(178, '', 'gallery', '0', '15749207445ddf62288c7d3.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(179, '', 'gallery', '0', '15749207445ddf622894623.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(180, '', 'gallery', '0', '15749207445ddf62289e654.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(181, '', 'gallery', '0', '15749207445ddf6228a4b8d.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(182, '', 'gallery', '0', '15749207445ddf6228ac909.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(183, '', 'gallery', '0', '15749207445ddf6228b2dfc.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(184, '', 'gallery', '0', '15749207445ddf6228c5193.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(185, '', 'gallery', '0', '15749207445ddf6228e7ab8.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(186, '', 'gallery', '0', '15749207455ddf622927b11.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(187, '', 'gallery', '0', '15749207455ddf622933a41.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(188, '', 'gallery', '0', '15749207455ddf62293e144.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(189, '', 'gallery', '0', '15749207455ddf62294c3e5.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(190, '', 'gallery', '0', '15749207455ddf62295a676.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(191, '', 'gallery', '0', '15749207455ddf622968909.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/'),
(192, '', 'gallery', '0', '15749207455ddf622976c28.jpeg', 10, 'D:\\www\\l2j.com.br\\public_html\\public/content//10/');

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

--
-- Table structure for table `informations`
--

CREATE TABLE `informations` (
  `id` int(11) NOT NULL,
  `address` text,
  `number` varchar(45) DEFAULT NULL,
  `complement` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `zipcode` varchar(45) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(45) DEFAULT NULL,
  `instagram` text,
  `facebook` text,
  `linkedin` text,
  `twitter` text,
  `pinterest` text,
  `phone1` varchar(45) DEFAULT NULL,
  `phone2` varchar(45) DEFAULT NULL,
  `email` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories_has_contents`
--
ALTER TABLE `categories_has_contents`
  ADD PRIMARY KEY (`categories_id`,`contents_id`),
  ADD KEY `fk_categories_has_contents_contents1_idx` (`contents_id`),
  ADD KEY `fk_categories_has_contents_categories1_idx` (`categories_id`);

--
-- Indexes for table `contents`
--
ALTER TABLE `contents`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `url_UNIQUE` (`url`);

--
-- Indexes for table `contents_has_contents`
--
ALTER TABLE `contents_has_contents`
  ADD PRIMARY KEY (`contents_id`,`contents_child_id`),
  ADD KEY `fk_contents_has_contents_contents2_idx` (`contents_child_id`),
  ADD KEY `fk_contents_has_contents_contents1_idx` (`contents_id`);

--
-- Indexes for table `contents_images`
--
ALTER TABLE `contents_images`
  ADD PRIMARY KEY (`id`,`contents_id`),
  ADD KEY `fk_contents_images_contents_idx` (`contents_id`);

--
-- Indexes for table `informations`
--
ALTER TABLE `informations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contents`
--
ALTER TABLE `contents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `contents_images`
--
ALTER TABLE `contents_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=193;

--
-- AUTO_INCREMENT for table `informations`
--
ALTER TABLE `informations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `categories_has_contents`
--
ALTER TABLE `categories_has_contents`
  ADD CONSTRAINT `fk_categories_has_contents_categories1` FOREIGN KEY (`categories_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_categories_has_contents_contents1` FOREIGN KEY (`contents_id`) REFERENCES `contents` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `contents_has_contents`
--
ALTER TABLE `contents_has_contents`
  ADD CONSTRAINT `fk_contents_has_contents_contents1` FOREIGN KEY (`contents_id`) REFERENCES `contents` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_contents_has_contents_contents2` FOREIGN KEY (`contents_child_id`) REFERENCES `contents` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `contents_images`
--
ALTER TABLE `contents_images`
  ADD CONSTRAINT `fk_contents_images_contents` FOREIGN KEY (`contents_id`) REFERENCES `contents` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
COMMIT;

