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

START TRANSACTION;



--
-- Database: `beliv`
--

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

--
-- Table structure for table `cp_atributes`
--

CREATE TABLE `cp_atributes` (
  `id` int(10) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `nomeesp` varchar(255) NOT NULL,
  `slugeng` varchar(255) NOT NULL,
  `slugesp` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `descriptionesp` varchar(255) DEFAULT NULL,
  `tipo` char(3) NOT NULL COMMENT 'FLV: Falvor; BST: Best',
  `ativo` tinyint(1) NOT NULL DEFAULT '1',
  `excluido` tinyint(1) NOT NULL DEFAULT '0',
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_atributes`
--

INSERT INTO `cp_atributes` (`id`, `nome`, `nomeesp`, `slugeng`, `slugesp`, `icon`, `description`, `descriptionesp`, `tipo`, `ativo`, `excluido`, `criado_em`) VALUES
(1, 'icon', 'icone', 'icon', 'icone', 'icon-share-20180911114926.png', NULL, NULL, 'BST', 1, 1, '2018-09-11 14:38:44'),
(2, 'Pear', 'Pear', 'pear', 'pear', '20180921110235.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 19:18:53'),
(3, 'Peach', 'Peach', 'peach', 'peach', '20180921110231.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 19:58:22'),
(4, 'Guava', 'Guava', 'guava', 'guava', '20180921110212.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 19:58:58'),
(5, 'Pineapple', 'Abacaxi', 'pineapple', 'abacaxi', '20180921110240.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 20:34:51'),
(6, 'Strawberry Banana', 'Strawberry Banana', 'strawberry-banana', 'strawberry-banana', '20180921110244.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 20:38:57'),
(7, 'Orange', 'Orange', 'orange', 'orange', '20180921110226.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 20:39:16'),
(8, 'Mango', 'Mango', 'mango', 'mango', '20180921110221.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 20:39:26'),
(9, 'Jugo de Vegetales', 'Jugo de Vegetales', 'jugo-de-vegetales', 'jugo-de-vegetales', '20180921110217.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 20:39:46'),
(10, 'Fruit Punch', 'Fruit Punch', 'fruit-punch', 'fruit-punch', '20180921110208.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 20:40:10'),
(11, 'Fruit Cocktail', 'Fruit Cocktail', 'fruit-cocktail', 'fruit-cocktail', '20180921110202.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 20:40:26'),
(12, 'Coctel de Tomate Preparado', 'Coctel de Tomate Preparado', 'coctel-de-tomate-preparado', 'coctel-de-tomate-preparado', '20180921110156.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 20:41:43'),
(13, 'Apple', 'Apple', 'apple', 'apple', '20180921110152.svg', NULL, NULL, 'FLV', 1, 0, '2018-09-20 20:41:54'),
(14, 'Real Fruits Veggies Juice', 'Real Fruits Veggies Juice', 'real-fruits-veggies-juice', 'real-fruits-veggies-juice', '20180921135004.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:50:04'),
(15, 'Real Fruit Juice and Pulp', 'Real Fruit Juice and Pulp', 'real-fruit-juice-and-pulp', 'real-fruit-juice-and-pulp', '20180921135046.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:50:46'),
(16, 'Real Fruit Juice', 'Real Fruit Juice', 'real-fruit-juice', 'real-fruit-juice', '20180921135118.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:51:18'),
(17, 'No Sugar Added', 'No Sugar Added', 'no-sugar-added', 'no-sugar-added', '20180921135143.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:51:43'),
(18, 'No Preservatives Artifitial Colors Artifitial Flavors', 'No Preservatives Artifitial Colors Artifitial Flavors', 'no-preservatives-artifitial-colors-artifitial-flavors', 'no-preservatives-artifitial-colors-artifitial-flavors', '20180921135221.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:52:21'),
(19, 'Natural Sparkling Volcanic Water', 'Natural Sparkling Volcanic Water', 'natural-sparkling-volcanic-water', 'natural-sparkling-volcanic-water', '20180921135309.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:53:09'),
(20, 'From the Andees', 'From the Andees', 'from-the-andees', 'from-the-andees', '20180921135336.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:53:36'),
(21, 'Est 1976 Jamaican Brand', 'Est 1976 Jamaican Brand', 'est-1976-jamaican-brand', 'est-1976-jamaican-brand', '20180921135407.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:54:07'),
(22, 'Bottled at Source', 'Bottled at Source', 'bottled-at-source', 'bottled-at-source', '20180921135445.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:54:45'),
(23, 'Authentic Root Ginger From Jamaica', 'Authentic Root Ginger From Jamaica', 'authentic-root-ginger-from-jamaica', 'authentic-root-ginger-from-jamaica', '20180921135517.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:55:17'),
(24, '6 Real Grapefruit Juice', '6 Real Grapefruit Juice', '6-real-grapefruit-juice', '6-real-grapefruit-juice', '20180921135541.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 16:55:41'),
(25, 'HCFSFREE', 'HCFSFREE', 'hcfsfree', 'hcfsfree', '20180921161248.svg', 'Description EN', 'Description ES', 'BST', 1, 0, '2018-09-21 19:12:48'),
(26, 'teste', 'teste es', 'teste', 'teste-es', '20180921161719.svg', 'descrip', '', 'BST', 1, 1, '2018-09-21 19:17:19');

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

--
-- Table structure for table `cp_brands`
--

CREATE TABLE `cp_brands` (
  `id` int(10) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `nomeesp` varchar(255) NOT NULL,
  `cor` varchar(50) NOT NULL,
  `slugeng` varchar(255) NOT NULL,
  `slugesp` varchar(255) NOT NULL,
  `ativo` tinyint(1) NOT NULL DEFAULT '1',
  `excluido` tinyint(1) NOT NULL DEFAULT '0',
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `slogan` varchar(255) DEFAULT NULL,
  `sloganesp` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `ordem` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_brands`
--

INSERT INTO `cp_brands` (`id`, `nome`, `nomeesp`, `cor`, `slugeng`, `slugesp`, `ativo`, `excluido`, `criado_em`, `slogan`, `sloganesp`, `icon`, `ordem`) VALUES
(1, 'Juice e Nectars', 'Juice e Nectars', '--blue', 'juice-e-nectars', 'juice-e-nectars', 1, 1, '2018-05-18 20:32:37', '', '', '20180913165507.svg', NULL),
(3, 'Andes Sparkling Nature', 'Andes Sparkling Nature', '--purple', 'andes-sparkling-nature', 'andes-sparkling-nature', 1, 0, '2018-05-22 19:55:30', 'Güitig', 'Güitig', '20180921102901.svg', 4),
(4, 'Jamaican Swag', 'Jamaican Swag', '--cyan', 'jamaican-swag', 'jamaican-swag', 1, 0, '2018-05-30 20:24:44', 'Authentic Soft Drinks', 'Authentic Soft Drinks', '20180921102837.svg', 1),
(5, 'Mexican Brands', 'Mexican Brands', '--yellow', 'mexican-brands', 'mexican-brands', 1, 1, '2018-05-30 20:25:01', '', '', '20180913165516.svg', NULL),
(6, 'Sparkling by nature', 'Sparkling by nature', '--pink', 'sparkling-by-nature', 'sparkling-by-nature', 1, 1, '2018-05-30 20:25:16', '', '', '20180913165520.svg', NULL),
(7, 'Latin American Flavors', 'Latin American Flavors', '--blue', 'latin-american-flavors-2', 'latin-american-flavors-2', 1, 0, '2018-09-14 13:49:45', 'Juice & Nectars', 'Juice & Nectars', '20180921152003.svg', 2),
(8, 'Mexican Taste', 'Mexican Taste', '--green', 'mexican-taste', 'mexican-taste', 1, 0, '2018-09-14 13:50:10', 'Cocktail Juices', 'Cocktail Juices', '20180921152022.svg', 3);

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

--
-- Table structure for table `cp_favorites`
--

CREATE TABLE `cp_favorites` (
  `id` int(11) NOT NULL,
  `typeproduct_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cp_favorites`
--

INSERT INTO `cp_favorites` (`id`, `typeproduct_id`, `user_id`, `criado_em`) VALUES
(43, 4, 2, '2018-06-07 13:29:54'),
(42, 6, 2, '2018-06-07 13:29:26');

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

--
-- Table structure for table `cp_imagens`
--

CREATE TABLE `cp_imagens` (
  `id` int(11) NOT NULL,
  `relacao_id` int(11) DEFAULT '0',
  `tipo` tinyint(1) DEFAULT '1' COMMENT '1 = Notícia / 2 = Páginas',
  `titulo` varchar(255) DEFAULT NULL,
  `legenda` varchar(255) DEFAULT NULL,
  `imagem` varchar(255) DEFAULT NULL,
  `ordem` int(10) DEFAULT '0',
  `datacriacao` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_imagens`
--

INSERT INTO `cp_imagens` (`id`, `relacao_id`, `tipo`, `titulo`, `legenda`, `imagem`, `ordem`, `datacriacao`) VALUES
(1, 1, 1, 'Teste', 'Teste 2 !!!!!!!!!', 'wallpapershd10-20160113162553.jpg', 1, '2016-01-13 22:25:55'),
(2, 1, 1, NULL, NULL, 'wallpapershd11-20160113162553.jpg', 3, '2016-01-13 22:25:55'),
(3, 1, 1, NULL, NULL, 'wallpapershd17-20160113162553.jpg', 4, '2016-01-13 22:25:55'),
(4, 1, 1, NULL, NULL, 'wallpapershd18-20160113162554.jpg', 5, '2016-01-13 22:25:55'),
(6, 1, 1, NULL, 'Texto qualquer', 'wallpapershd20-20160113162555.jpg', 2, '2016-01-13 22:25:55'),
(7, 1, 1, NULL, NULL, 'wallpapershd10-20160113162553.jpg', 7, '2016-09-12 21:40:23'),
(8, 1, 1, NULL, NULL, 'wallpapershd11-20160113162553.jpg', 9, '2016-09-12 21:40:26'),
(9, 1, 1, NULL, NULL, 'wallpapershd17-20160113162553.jpg', 8, '2016-09-12 21:40:31'),
(10, 1, 1, NULL, NULL, 'wallpapershd18-20160113162554.jpg', 10, '2016-09-12 21:40:36'),
(12, 1, 1, NULL, NULL, 'wallpapershd20-20160113162555.jpg', 11, '2016-09-12 21:40:49');

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

--
-- Table structure for table `cp_log`
--

CREATE TABLE `cp_log` (
  `id` int(11) NOT NULL,
  `usuario_id` int(11) NOT NULL,
  `acao` varchar(255) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_log`
--

INSERT INTO `cp_log` (`id`, `usuario_id`, `acao`, `ip`, `criado_em`) VALUES
(1, 1, 'Logout', '177.158.109.223', '2018-09-19 14:33:55'),
(2, 1, 'Login', '177.158.109.223', '2018-09-19 14:33:57'),
(3, 1, 'Brand Deactivated - Jamaican Swag', '177.158.109.223', '2018-09-19 14:34:02'),
(4, 1, 'Brand Activated - Jamaican Swag', '177.158.109.223', '2018-09-19 14:34:06'),
(5, 1, 'Login', '191.177.185.136', '2018-09-19 18:11:58'),
(6, 1, 'Edit Brand - Jamaican Swag', '191.177.185.136', '2018-09-19 18:12:48'),
(7, 1, 'Edit Brand - Latin American Flavors', '191.177.185.136', '2018-09-19 18:12:53'),
(8, 1, 'Edit Brand - Latin American Flavors', '191.177.185.136', '2018-09-19 18:12:57'),
(9, 1, 'Edit Brand - Mexican Taste', '191.177.185.136', '2018-09-19 18:13:03'),
(10, 1, 'Edit Type Of Product - Nectar Petit 24/330 ML Lata CH', '191.177.185.136', '2018-09-19 18:14:45'),
(11, 1, 'Edit Type Of Product - Old Jamaica NRGB 24/355ML', '191.177.185.136', '2018-09-19 18:15:02'),
(12, 1, 'Edit Type Of Product - Bebida BIT 24/233ML E.E.U.U.', '191.177.185.136', '2018-09-19 18:15:20'),
(13, 1, 'Edit Type Of Product - Coctel Preparado 237ML', '191.177.185.136', '2018-09-19 18:15:33'),
(14, 1, 'Edit Type Of Product - Nectar Petit 24/200 ML 3PK', '191.177.185.136', '2018-09-19 18:15:54'),
(15, 1, 'Edit Type Of Product - Tripack Petit Tba Mid', '191.177.185.136', '2018-09-19 18:16:02'),
(16, 1, 'Edit Type Of Product - Nectar Petit Light  24/200ML 3PK', '191.177.185.136', '2018-09-19 18:16:11'),
(17, 1, 'Edit Type Of Product - Type of Product 001', '191.177.185.136', '2018-09-19 18:16:21'),
(18, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-19 18:18:56'),
(19, 1, 'Login', '191.177.185.136', '2018-09-20 19:18:31'),
(20, 1, 'Insert Atribute - Pear', '191.177.185.136', '2018-09-20 19:18:53'),
(21, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-20 19:20:59'),
(22, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-20 19:21:03'),
(23, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-20 19:22:19'),
(24, 1, 'Login', '177.98.92.194', '2018-09-20 19:22:23'),
(25, 1, 'Editou Atribute - Pear', '191.177.185.136', '2018-09-20 19:57:29'),
(26, 1, 'Editou Atribute - Pear', '191.177.185.136', '2018-09-20 19:57:34'),
(27, 1, 'Insert Atribute - Peach', '191.177.185.136', '2018-09-20 19:58:22'),
(28, 1, 'Insert Atribute - Guava', '191.177.185.136', '2018-09-20 19:58:58'),
(29, 1, 'Insert Atribute - Peneapple', '191.177.185.136', '2018-09-20 20:34:51'),
(30, 1, 'Insert Atribute - Strawberry Banana', '191.177.185.136', '2018-09-20 20:38:57'),
(31, 1, 'Insert Atribute - Orange', '191.177.185.136', '2018-09-20 20:39:16'),
(32, 1, 'Insert Atribute - Mango', '191.177.185.136', '2018-09-20 20:39:26'),
(33, 1, 'Insert Atribute - Jugo de Vegetales', '191.177.185.136', '2018-09-20 20:39:46'),
(34, 1, 'Insert Atribute - Fruit Punch', '191.177.185.136', '2018-09-20 20:40:10'),
(35, 1, 'Insert Atribute - Fruit Cocktail', '191.177.185.136', '2018-09-20 20:40:26'),
(36, 1, 'Login', '177.98.92.194', '2018-09-20 20:41:35'),
(37, 1, 'Insert Atribute - Coctel de Tomate Preparado', '191.177.185.136', '2018-09-20 20:41:43'),
(38, 1, 'Insert Atribute - Apple', '191.177.185.136', '2018-09-20 20:41:54'),
(39, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-20 21:03:26'),
(40, 1, 'Remove Admin - Ruan', '191.177.185.136', '2018-09-20 21:11:08'),
(41, 1, 'Remove Admin - sdsad', '191.177.185.136', '2018-09-20 21:11:11'),
(42, 1, 'Remove Admin - teste', '191.177.185.136', '2018-09-20 21:11:12'),
(43, 1, 'Edit Admin - Felipe', '191.177.185.136', '2018-09-20 21:11:34'),
(44, 1, 'Logout', '191.177.185.136', '2018-09-20 21:11:37'),
(45, 2, 'Login', '191.177.185.136', '2018-09-20 21:11:45'),
(46, 1, 'Login', '191.177.185.136', '2018-09-21 11:49:02'),
(47, 1, 'Login', '191.177.185.136', '2018-09-21 12:54:12'),
(48, 1, 'Login', '177.98.92.194', '2018-09-21 13:12:35'),
(49, 1, 'Edit Brand - Jamaican Swag', '191.177.185.136', '2018-09-21 13:18:18'),
(50, 1, 'Edit Brand - Latin American Flavors', '191.177.185.136', '2018-09-21 13:18:24'),
(51, 1, 'Edit Brand - Latin American Flavors', '191.177.185.136', '2018-09-21 13:18:27'),
(52, 1, 'Edit Brand - Mexican Taste', '191.177.185.136', '2018-09-21 13:18:31'),
(53, 1, 'Logout', '191.177.185.136', '2018-09-21 13:20:04'),
(54, 1, 'Login', '191.177.185.136', '2018-09-21 13:21:40'),
(55, 1, 'Edit Brand - Jamaican Swag', '191.177.185.136', '2018-09-21 13:28:37'),
(56, 1, 'Edit Brand - Latin American Flavors', '191.177.185.136', '2018-09-21 13:29:01'),
(57, 1, 'Edit Type Of Product - Nectar Petit 24/330 ML Lata CH', '191.177.185.136', '2018-09-21 13:41:05'),
(58, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-21 14:00:14'),
(59, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-21 14:00:41'),
(60, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-21 14:01:09'),
(61, 1, 'Editou Atribute - Apple', '191.177.185.136', '2018-09-21 14:01:52'),
(62, 1, 'Editou Atribute - Coctel de Tomate Preparado', '191.177.185.136', '2018-09-21 14:01:56'),
(63, 1, 'Editou Atribute - Fruit Cocktail', '191.177.185.136', '2018-09-21 14:02:02'),
(64, 1, 'Editou Atribute - Fruit Punch', '191.177.185.136', '2018-09-21 14:02:08'),
(65, 1, 'Editou Atribute - Guava', '191.177.185.136', '2018-09-21 14:02:12'),
(66, 1, 'Editou Atribute - Jugo de Vegetales', '191.177.185.136', '2018-09-21 14:02:17'),
(67, 1, 'Editou Atribute - Mango', '191.177.185.136', '2018-09-21 14:02:21'),
(68, 1, 'Editou Atribute - Orange', '191.177.185.136', '2018-09-21 14:02:26'),
(69, 1, 'Editou Atribute - Peach', '191.177.185.136', '2018-09-21 14:02:31'),
(70, 1, 'Editou Atribute - Pear', '191.177.185.136', '2018-09-21 14:02:35'),
(71, 1, 'Editou Atribute - Peneapple', '191.177.185.136', '2018-09-21 14:02:40'),
(72, 1, 'Editou Atribute - Strawberry Banana', '191.177.185.136', '2018-09-21 14:02:44'),
(73, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-21 14:03:42'),
(74, 1, 'Insert Support from Type Of Product - ', '191.177.185.136', '2018-09-21 14:07:10'),
(75, 1, 'Insert Support from Type Of Product - ', '191.177.185.136', '2018-09-21 14:07:28'),
(76, 1, 'Login', '191.177.185.136', '2018-09-21 16:28:25'),
(77, 1, 'Remove Atribute - icon', '191.177.185.136', '2018-09-21 16:28:30'),
(78, 1, 'Insert Atribute - Real Fruits Veggies Juice', '191.177.185.136', '2018-09-21 16:30:01'),
(79, 1, 'Login', '177.98.92.194', '2018-09-21 16:32:59'),
(80, 1, 'Insert Atribute - Real Fruits Veggies Juice', '191.177.185.136', '2018-09-21 16:50:04'),
(81, 1, 'Insert Atribute - Real Fruit Juice and Pulp', '191.177.185.136', '2018-09-21 16:50:46'),
(82, 1, 'Insert Atribute - Real Fruit Juice', '191.177.185.136', '2018-09-21 16:51:18'),
(83, 1, 'Insert Atribute - No Sugar Added', '191.177.185.136', '2018-09-21 16:51:43'),
(84, 1, 'Insert Atribute - No Preservatives Artifitial Colors Artifitial Flavors', '191.177.185.136', '2018-09-21 16:52:21'),
(85, 1, 'Insert Atribute - Natural Sparkling Volcanic Water', '191.177.185.136', '2018-09-21 16:53:09'),
(86, 1, 'Insert Atribute - From the Andees', '191.177.185.136', '2018-09-21 16:53:36'),
(87, 1, 'Insert Atribute - Est 1976 Jamaican Brand', '191.177.185.136', '2018-09-21 16:54:07'),
(88, 1, 'Insert Atribute - Bottled at Source', '191.177.185.136', '2018-09-21 16:54:45'),
(89, 1, 'Insert Atribute - Authentic Root Ginger From Jamaica', '191.177.185.136', '2018-09-21 16:55:17'),
(90, 1, 'Insert Atribute - 6 Real Grapefruit Juice', '191.177.185.136', '2018-09-21 16:55:41'),
(91, 1, 'Edit Type Of Product - Nectar Petit 24/330 ML Lata CH', '191.177.185.136', '2018-09-21 16:56:12'),
(92, 1, 'Insert Support from Type Of Product - ', '191.177.185.136', '2018-09-21 16:57:23'),
(93, 1, 'Insert Support from Type Of Product - ', '191.177.185.136', '2018-09-21 16:57:37'),
(94, 1, 'Edit Type Of Product - Nectar Petit 24/330 ML Lata CH', '191.177.185.136', '2018-09-21 17:11:29'),
(95, 1, 'Edit Brand - Latin American Flavors', '191.177.185.136', '2018-09-21 18:20:03'),
(96, 1, 'Edit Brand - Mexican Taste', '191.177.185.136', '2018-09-21 18:20:22'),
(97, 1, 'Edit Type Of Product - Old Jamaica NRGB 24/355ML', '191.177.185.136', '2018-09-21 18:21:04'),
(98, 1, 'Edit Type Of Product - Bebida BIT 24/233ML E.E.U.U.', '191.177.185.136', '2018-09-21 18:21:16'),
(99, 1, 'Edit Type Of Product - Coctel Preparado 237ML', '191.177.185.136', '2018-09-21 18:21:24'),
(100, 1, 'Edit Type Of Product - Nectar Petit Light  24/200ML 3PK', '191.177.185.136', '2018-09-21 18:21:40'),
(101, 1, 'Edit Type Of Product - Type of Product 001', '191.177.185.136', '2018-09-21 18:22:00'),
(102, 1, 'Edit Type Of Product - Nectar Petit 24/200 ML 3PK', '191.177.185.136', '2018-09-21 18:22:22'),
(103, 1, 'Edit Type Of Product - Tripack Petit Tba Mid', '191.177.185.136', '2018-09-21 18:22:40'),
(104, 1, 'Edit Type Of Product - Type of Product 001', '191.177.185.136', '2018-09-21 18:22:57'),
(105, 1, 'Edit Type Of Product - Nectar Petit Light  24/200ML 3PK', '191.177.185.136', '2018-09-21 18:23:21'),
(106, 1, 'Edit Type Of Product - Nectar Petit 24/330 ML Lata CH', '191.177.185.136', '2018-09-21 18:23:44'),
(107, 1, 'Edit Type Of Product - Old Jamaica NRGB 24/355ML', '191.177.185.136', '2018-09-21 18:23:58'),
(108, 1, 'Edit Type Of Product - Bebida BIT 24/233ML E.E.U.U.', '191.177.185.136', '2018-09-21 18:24:10'),
(109, 1, 'Edit Type Of Product - Coctel Preparado 237ML', '191.177.185.136', '2018-09-21 18:24:29'),
(110, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-21 18:25:36'),
(111, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-21 18:26:12'),
(112, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-21 18:26:49'),
(113, 1, 'Insert Flavor From Type Of Product - 18', '191.177.185.136', '2018-09-21 18:27:19'),
(114, 1, 'Insert Flavor From Type Of Product - 17', '191.177.185.136', '2018-09-21 18:28:06'),
(115, 1, 'Insert Flavor From Type Of Product - 17', '191.177.185.136', '2018-09-21 18:28:26'),
(116, 1, 'Insert Flavor From Type Of Product - 19', '191.177.185.136', '2018-09-21 18:29:34'),
(117, 1, 'Insert Flavor From Type Of Product - 10', '191.177.185.136', '2018-09-21 18:30:49'),
(118, 1, 'Insert Flavor From Type Of Product - 10', '191.177.185.136', '2018-09-21 18:31:12'),
(119, 1, 'Insert Flavor From Type Of Product - 10', '191.177.185.136', '2018-09-21 18:31:53'),
(120, 1, 'Insert Flavor From Type Of Product - 10', '191.177.185.136', '2018-09-21 18:32:37'),
(121, 1, 'Insert Flavor From Type Of Product - 10', '191.177.185.136', '2018-09-21 18:33:05'),
(122, 1, 'Insert Flavor From Type Of Product - 16', '191.177.185.136', '2018-09-21 18:33:42'),
(123, 1, 'Insert Flavor From Type Of Product - 12', '191.177.185.136', '2018-09-21 18:34:29'),
(124, 1, 'Insert Flavor From Type Of Product - 12', '191.177.185.136', '2018-09-21 18:34:47'),
(125, 1, 'Insert Flavor From Type Of Product - 12', '191.177.185.136', '2018-09-21 18:35:23'),
(126, 1, 'Insert Flavor From Type Of Product - 14', '191.177.185.136', '2018-09-21 18:35:45'),
(127, 1, 'Insert Flavor From Type Of Product - 14', '191.177.185.136', '2018-09-21 18:36:31'),
(128, 1, 'Insert Flavor From Type Of Product - 12', '191.177.185.136', '2018-09-21 18:38:25'),
(129, 1, 'Insert Flavor From Type Of Product - 15', '191.177.185.136', '2018-09-21 18:39:28'),
(130, 1, 'Insert Atribute - HCFSFREE', '191.177.185.136', '2018-09-21 19:12:48'),
(131, 1, 'Login', '177.98.92.194', '2018-09-21 19:13:41'),
(132, 1, 'Edit Atribute - HCFSFREE', '177.98.92.194', '2018-09-21 19:16:47'),
(133, 1, 'Insert Atribute - teste', '177.98.92.194', '2018-09-21 19:17:19'),
(134, 1, 'Remove Atribute - teste', '177.98.92.194', '2018-09-21 19:19:41'),
(135, 1, 'Edit Atribute - 6 Real Grapefruit Juice', '191.177.185.136', '2018-09-21 19:29:15'),
(136, 1, 'Edit Atribute - Authentic Root Ginger From Jamaica', '191.177.185.136', '2018-09-21 19:29:17'),
(137, 1, 'Edit Atribute - Bottled at Source', '191.177.185.136', '2018-09-21 19:29:19'),
(138, 1, 'Edit Atribute - Est 1976 Jamaican Brand', '191.177.185.136', '2018-09-21 19:29:21'),
(139, 1, 'Edit Atribute - From the Andees', '191.177.185.136', '2018-09-21 19:29:22'),
(140, 1, 'Edit Atribute - HCFSFREE', '191.177.185.136', '2018-09-21 19:29:24'),
(141, 1, 'Edit Atribute - Natural Sparkling Volcanic Water', '191.177.185.136', '2018-09-21 19:29:26'),
(142, 1, 'Edit Atribute - No Preservatives Artifitial Colors Artifitial Flavors', '191.177.185.136', '2018-09-21 19:29:30'),
(143, 1, 'Edit Atribute - No Sugar Added', '191.177.185.136', '2018-09-21 19:29:32'),
(144, 1, 'Edit Atribute - Real Fruit Juice and Pulp', '191.177.185.136', '2018-09-21 19:29:34'),
(145, 1, 'Edit Atribute - Real Fruits Veggies Juice', '191.177.185.136', '2018-09-21 19:29:35'),
(146, 1, 'Edit Atribute - Real Fruit Juice', '191.177.185.136', '2018-09-21 19:29:37'),
(147, 14, 'Login', '104.7.47.117', '2018-09-25 16:29:06'),
(148, 14, 'Edit Brand - Jamaican Swag', '104.7.47.117', '2018-09-25 16:40:07'),
(149, 14, 'Edit Brand - Jamaican Swag', '104.7.47.117', '2018-09-25 16:40:16'),
(150, 14, 'Edit Brand - Jamaican Swag', '104.7.47.117', '2018-09-25 16:40:20'),
(151, 14, 'Edit Type Of Product - Nectar Petit 24/330 ML Lata CH', '104.7.47.117', '2018-09-25 16:42:47'),
(152, 14, 'Edit Type Of Product - Nectar Petit 24/330 ML Lata CH', '104.7.47.117', '2018-09-25 16:42:53'),
(153, 14, 'Editou Atribute - Apple', '104.7.47.117', '2018-09-25 16:46:04'),
(154, 14, 'Editou Atribute - Pineapple', '104.7.47.117', '2018-09-25 16:47:08'),
(155, 14, 'Editou Atribute - Orange', '104.7.47.117', '2018-09-25 16:47:18'),
(156, 14, 'Editou Atribute - Mango', '104.7.47.117', '2018-09-25 16:47:27'),
(157, 14, 'Editou Atribute - Strawberry Banana', '104.7.47.117', '2018-09-25 16:47:36'),
(158, 14, 'Edit Brand - Latin American Flavors', '104.7.47.117', '2018-09-25 16:49:05'),
(159, 14, 'Edit Brand - Latin American Flavors', '104.7.47.117', '2018-09-25 16:49:09'),
(160, 14, 'Edit Brand - Jamaican Swag', '104.7.47.117', '2018-09-25 16:49:20'),
(161, 14, 'Edit Product - Glass - Old Jamaica', '104.7.47.117', '2018-09-25 16:49:43'),
(162, 14, 'Edit Product - Can - Petit', '104.7.47.117', '2018-09-25 16:54:05'),
(163, 14, 'Edit Product - Can - Petit', '104.7.47.117', '2018-09-25 16:54:06'),
(164, 14, 'Edit Product - Mini Can - Petit Coctel', '104.7.47.117', '2018-09-25 17:00:46'),
(165, 14, 'Edit Type Of Product - Nectar Petit 24/330 ML Lata CH', '104.7.47.117', '2018-09-25 17:02:10'),
(166, 14, 'Login', '96.66.212.201', '2018-09-25 18:20:10'),
(167, 14, 'Login', '96.66.212.201', '2018-09-25 19:42:26'),
(168, 14, 'Edit Brand - Jamaican Swag', '96.66.212.201', '2018-09-25 19:45:56'),
(169, 14, 'Edit Brand - Latin American Flavors', '96.66.212.201', '2018-09-25 19:46:32'),
(170, 14, 'Edit Brand - Latin American Flavors', '96.66.212.201', '2018-09-25 19:46:34'),
(171, 14, 'Edit Brand - Andes Sparkling Nature', '96.66.212.201', '2018-09-25 19:47:16'),
(172, 14, 'Edit Brand - Mexican Taste', '96.66.212.201', '2018-09-25 19:47:42'),
(173, 14, 'Insert Product - Kids', '96.66.212.201', '2018-09-25 19:54:44'),
(174, 14, 'Insert Product - Family', '96.66.212.201', '2018-09-25 19:55:00'),
(175, 14, 'Insert Product - Mixers', '96.66.212.201', '2018-09-25 19:55:12'),
(176, 14, 'Remove Product - Can - Petit', '96.66.212.201', '2018-09-25 19:55:33'),
(177, 14, 'Remove Product - Litro Prisma - Petit', '96.66.212.201', '2018-09-25 19:55:39'),
(178, 14, 'Remove Product - Mini Can - Petit Coctel', '96.66.212.201', '2018-09-25 19:55:46'),
(179, 14, 'Insert Type Of Product - Petit Light - 200 ML', '96.66.212.201', '2018-09-25 20:05:54'),
(180, 14, 'Insert Type Of Product - Petit - 200 ML', '96.66.212.201', '2018-09-25 20:07:06'),
(181, 14, 'Insert Type Of Product - Fruggie', '96.66.212.201', '2018-09-25 20:07:37'),
(182, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:08:59'),
(183, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:09:08'),
(184, 14, 'Insert Flavor From Type Of Product - 21', '96.66.212.201', '2018-09-25 20:10:28'),
(185, 14, 'Insert Flavor From Type Of Product - 21', '96.66.212.201', '2018-09-25 20:10:58'),
(186, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:12:15'),
(187, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:12:26'),
(188, 14, 'Edit Product - Glass - Old Jamaica', '96.66.212.201', '2018-09-25 20:12:41'),
(189, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:13:24'),
(190, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:14:49'),
(191, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:15:11'),
(192, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:16:36'),
(193, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:18:05'),
(194, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:19:08'),
(195, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:19:23'),
(196, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:27:33'),
(197, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:28:12'),
(198, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:28:50'),
(199, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:29:13'),
(200, 14, 'Insert Flavor From Type Of Product - 20', '96.66.212.201', '2018-09-25 20:29:55'),
(201, 14, 'Insert Flavor From Type Of Product - 21', '96.66.212.201', '2018-09-25 20:32:46'),
(202, 14, 'Insert Flavor From Type Of Product - 21', '96.66.212.201', '2018-09-25 20:33:28'),
(203, 14, 'Insert Type Of Product - Petit', '96.66.212.201', '2018-09-25 20:42:18'),
(204, 14, 'Edit Type Of Product - Petit', '96.66.212.201', '2018-09-25 20:43:09'),
(205, 14, 'Edit Type Of Product - Petit', '96.66.212.201', '2018-09-25 20:43:31'),
(206, 14, 'Edit Type Of Product - Petit', '96.66.212.201', '2018-09-25 20:43:47'),
(207, 14, 'Edit Type Of Product - Petit Light', '96.66.212.201', '2018-09-25 20:44:43'),
(208, 14, 'Edit Type Of Product - Petit Light', '96.66.212.201', '2018-09-25 20:44:53'),
(209, 14, 'Edit Type Of Product - Petit Light', '96.66.212.201', '2018-09-25 20:44:59'),
(210, 14, 'Edit Type Of Product - Petit Light', '96.66.212.201', '2018-09-25 20:45:11'),
(211, 14, 'Edit Type Of Product - Petit', '96.66.212.201', '2018-09-25 20:46:28'),
(212, 14, 'Edit Type Of Product - Petit', '96.66.212.201', '2018-09-25 20:46:35'),
(213, 14, 'Insert Type Of Product - Petit', '96.66.212.201', '2018-09-25 20:48:35'),
(214, 14, 'Insert Type Of Product - Petit Light', '96.66.212.201', '2018-09-25 20:49:34'),
(215, 14, 'Insert Type Of Product - Vegetable Juice', '96.66.212.201', '2018-09-25 20:55:00'),
(216, 14, 'Insert Type Of Product - Tomato Cocktail', '96.66.212.201', '2018-09-25 20:56:22'),
(217, 14, 'Insert Product - Ginger Beer', '96.66.212.201', '2018-09-25 21:00:01'),
(218, 14, 'Insert Product - Grapefruit', '96.66.212.201', '2018-09-25 21:00:18'),
(219, 14, 'Remove Product - Glass - Old Jamaica', '96.66.212.201', '2018-09-25 21:00:22'),
(220, 14, 'Remove Product - Product 001', '96.66.212.201', '2018-09-25 21:00:45'),
(221, 14, 'Remove Product - Nobox', '96.66.212.201', '2018-09-25 21:00:51'),
(222, 14, 'Insert Type Of Product - Old Jamaica', '96.66.212.201', '2018-09-25 21:02:03'),
(223, 14, 'Insert Type Of Product - Old Jamaica', '96.66.212.201', '2018-09-25 21:03:15'),
(224, 14, 'Insert Type Of Product - Ting', '96.66.212.201', '2018-09-25 21:06:20'),
(225, 14, 'Insert Type Of Product - Ting', '96.66.212.201', '2018-09-25 21:07:15'),
(226, 14, 'Edit Product - BiT Tajín', '96.66.212.201', '2018-09-25 21:08:40'),
(227, 14, 'Edit Product - Bit Tajín', '96.66.212.201', '2018-09-25 21:08:50'),
(228, 14, 'Edit Product - Bit Tajín', '96.66.212.201', '2018-09-25 21:08:52'),
(229, 14, 'Edit Product - Bit Tajín', '96.66.212.201', '2018-09-25 21:08:52'),
(230, 14, 'Edit Type Of Product - Bit Tajin', '96.66.212.201', '2018-09-25 21:09:54'),
(231, 14, 'Remove Product - Petit Light', '96.66.212.201', '2018-09-25 21:11:15'),
(232, 14, 'Edit Product - Güitig', '96.66.212.201', '2018-09-25 21:11:59'),
(233, 14, 'Remove Type Of Product - Tripack Petit Tba Mid', '96.66.212.201', '2018-09-25 21:12:19'),
(234, 14, 'Edit Type Of Product - Güitig', '96.66.212.201', '2018-09-25 21:12:49'),
(235, 14, 'Insert Type Of Product - Güitig', '96.66.212.201', '2018-09-25 21:13:49'),
(236, 14, 'Logout', '96.66.212.201', '2018-09-25 21:32:07'),
(237, 14, 'Login', '96.66.212.201', '2018-09-25 21:32:09'),
(238, 14, 'Type Product Deactivated - Petit Light', '96.66.212.201', '2018-09-25 21:32:32'),
(239, 14, 'Type Product Activated - Petit Light', '96.66.212.201', '2018-09-25 21:32:36'),
(240, 14, 'Edit Product - Mixers', '96.66.212.201', '2018-09-25 21:33:03'),
(241, 14, 'Edit Product - Kids', '96.66.212.201', '2018-09-25 21:33:50'),
(242, 14, 'Login', '96.66.212.201', '2018-09-25 22:20:11'),
(243, 14, 'Insert Flavor From Type Of Product - 24', '96.66.212.201', '2018-09-25 22:22:24'),
(244, 14, 'Insert Flavor From Type Of Product - 24', '96.66.212.201', '2018-09-25 22:24:17'),
(245, 14, 'Login', '104.7.47.117', '2018-09-27 14:38:39'),
(246, 1, 'Login', '179.154.232.252', '2018-09-28 17:39:33'),
(247, 1, 'Login', '191.177.184.88', '2018-10-01 12:14:27'),
(248, 1, 'Insert Flavor From Type Of Product - 17', '191.177.184.88', '2018-10-01 12:37:37'),
(249, 1, 'Edit Flavor From Type Of Product - 101', '191.177.184.88', '2018-10-01 12:40:23'),
(250, 1, 'Login', '179.154.232.252', '2018-10-01 12:44:33'),
(251, 1, 'Login', '191.177.184.88', '2018-10-01 13:09:24'),
(252, 1, 'Edit Flavor From Type Of Product - 101', '191.177.184.88', '2018-10-01 13:09:42'),
(253, 1, 'Edit Flavor From Type Of Product - 82', '191.177.184.88', '2018-10-01 13:10:23'),
(254, 1, 'Edit Flavor From Type Of Product - 82', '191.177.184.88', '2018-10-01 13:10:43'),
(255, 1, 'Login', '179.154.232.252', '2018-10-01 13:11:28'),
(256, 1, 'Edit Flavor From Type Of Product - 101', '179.154.232.252', '2018-10-01 13:11:52'),
(257, 1, 'Edit Flavor From Type Of Product - 101', '179.154.232.252', '2018-10-01 13:12:55'),
(258, 1, 'Edit Flavor From Type Of Product - 82', '179.154.232.252', '2018-10-01 13:15:55'),
(259, 1, 'Edit Flavor From Type Of Product - 82', '179.154.232.252', '2018-10-01 13:17:35'),
(260, 1, 'Edit Flavor From Type Of Product - 82', '179.154.232.252', '2018-10-01 13:20:20'),
(261, 1, 'Edit Flavor From Type Of Product - 82', '179.154.232.252', '2018-10-01 13:22:42'),
(262, 1, 'Edit Flavor From Type Of Product - 82', '179.154.232.252', '2018-10-01 13:23:07'),
(263, 1, 'Edit Flavor From Type Of Product - 82', '179.154.232.252', '2018-10-01 13:23:53'),
(264, 1, 'Edit Flavor From Type Of Product - 82', '179.154.232.252', '2018-10-01 13:24:02'),
(265, 1, 'Edit Flavor From Type Of Product - 101', '179.154.232.252', '2018-10-01 13:24:11'),
(266, 1, 'Edit Flavor From Type Of Product - 101', '179.154.232.252', '2018-10-01 13:24:17'),
(267, 1, 'Edit Flavor From Type Of Product - 82', '191.177.184.88', '2018-10-01 13:25:53'),
(268, 1, 'Edit Flavor From Type Of Product - 82', '191.177.184.88', '2018-10-01 13:26:04'),
(269, 1, 'Edit Flavor From Type Of Product - 101', '191.177.184.88', '2018-10-01 13:26:18'),
(270, 1, 'Login', '191.177.184.88', '2018-10-01 16:22:52'),
(271, 1, 'Login', '177.79.38.218', '2018-10-01 16:26:47'),
(272, 1, 'Login', '191.177.184.88', '2018-10-02 14:19:34'),
(273, 1, 'Edit Flavor From Type Of Product - 93', '191.177.184.88', '2018-10-02 14:20:08'),
(274, 1, 'Edit Flavor From Type Of Product - 94', '191.177.184.88', '2018-10-02 14:20:16'),
(275, 1, 'Edit Flavor From Type Of Product - 95', '191.177.184.88', '2018-10-02 14:20:19'),
(276, 1, 'Edit Flavor From Type Of Product - 97', '191.177.184.88', '2018-10-02 14:20:24'),
(277, 1, 'Login', '191.177.184.88', '2018-10-02 16:37:25'),
(278, 1, 'Login', '179.154.232.252', '2018-10-02 16:38:29'),
(279, 1, 'Insert Support from Type Of Product - ', '191.177.184.88', '2018-10-02 16:40:19'),
(280, 1, 'Insert Support from Type Of Product - ', '191.177.184.88', '2018-10-02 16:40:28'),
(281, 1, 'Login', '177.34.100.30', '2018-10-03 12:39:18'),
(282, 1, 'Login', '191.177.184.88', '2018-10-03 12:40:25');

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

--
-- Table structure for table `cp_perfil`
--

CREATE TABLE `cp_perfil` (
  `id` int(11) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `ativo` tinyint(1) DEFAULT '1',
  `excluido` tinyint(1) DEFAULT '0',
  `criado_em` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_perfil`
--

INSERT INTO `cp_perfil` (`id`, `nome`, `slug`, `ativo`, `excluido`, `criado_em`) VALUES
(1, 'Admin', 'admin', 1, 0, '2013-10-11 15:47:07'),
(2, 'Estagiário', 'estagiario', 1, 0, '2013-10-15 16:42:34'),
(3, 'RH', 'teste', 1, 0, '2018-05-02 22:26:24');

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

--
-- Table structure for table `cp_permissoes`
--

CREATE TABLE `cp_permissoes` (
  `id` int(10) NOT NULL,
  `perfil_id` int(11) NOT NULL,
  `tela_id` int(11) NOT NULL,
  `consultar` tinyint(1) NOT NULL DEFAULT '0',
  `inserir` tinyint(1) NOT NULL DEFAULT '0',
  `editar` tinyint(1) NOT NULL DEFAULT '0',
  `excluir` tinyint(1) NOT NULL DEFAULT '0',
  `datacriacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_permissoes`
--

INSERT INTO `cp_permissoes` (`id`, `perfil_id`, `tela_id`, `consultar`, `inserir`, `editar`, `excluir`, `datacriacao`) VALUES
(1, 2, 1, 1, 0, 0, 0, '2013-10-11 16:13:03'),
(2, 2, 2, 1, 1, 1, 0, '2013-10-11 16:58:53'),
(3, 2, 3, 1, 1, 1, 0, '2013-10-11 20:25:36'),
(4, 2, 4, 1, 0, 0, 0, '2013-10-11 20:25:36'),
(5, 2, 5, 1, 0, 0, 0, '2016-09-05 17:02:26'),
(6, 2, 6, 1, 0, 0, 0, '2016-09-26 23:24:21'),
(7, 2, 7, 1, 0, 0, 0, '2017-03-10 17:24:21'),
(8, 2, 8, 1, 0, 0, 0, '2017-03-10 17:24:46'),
(9, 3, 1, 0, 0, 0, 0, '2018-05-02 22:26:24'),
(10, 3, 2, 0, 0, 0, 0, '2018-05-02 22:26:24'),
(11, 3, 3, 0, 0, 0, 0, '2018-05-02 22:26:24'),
(12, 3, 4, 0, 0, 0, 0, '2018-05-02 22:26:24'),
(13, 3, 5, 0, 0, 0, 0, '2018-05-02 22:26:24'),
(14, 3, 6, 0, 0, 0, 0, '2018-05-02 22:26:24'),
(15, 2, 7, 0, 0, 0, 0, '2018-05-02 22:55:10'),
(16, 3, 7, 1, 1, 1, 1, '2018-05-02 22:55:10'),
(17, 2, 8, 0, 0, 0, 0, '2018-05-02 22:55:27'),
(18, 3, 8, 1, 1, 1, 1, '2018-05-02 22:55:27'),
(19, 2, 9, 0, 0, 0, 0, '2018-05-02 22:55:41'),
(20, 3, 9, 0, 0, 0, 0, '2018-05-02 22:55:41'),
(21, 2, 10, 0, 0, 0, 0, '2018-05-02 22:56:08'),
(22, 3, 10, 0, 0, 0, 0, '2018-05-02 22:56:08'),
(23, 2, 11, 0, 0, 0, 0, '2018-05-02 23:07:35'),
(24, 3, 11, 1, 1, 1, 1, '2018-05-02 23:07:35');

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

--
-- Table structure for table `cp_products`
--

CREATE TABLE `cp_products` (
  `id` int(10) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `brand_id` int(11) NOT NULL,
  `nomeesp` varchar(255) NOT NULL,
  `slugeng` varchar(255) NOT NULL,
  `slugesp` varchar(255) NOT NULL,
  `ativo` tinyint(1) NOT NULL DEFAULT '1',
  `excluido` tinyint(1) NOT NULL DEFAULT '0',
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ordem` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_products`
--

INSERT INTO `cp_products` (`id`, `nome`, `brand_id`, `nomeesp`, `slugeng`, `slugesp`, `ativo`, `excluido`, `criado_em`, `ordem`) VALUES
(1, 'Coka colla', 0, '', '', '', 1, 1, '2018-05-21 13:12:09', NULL),
(2, 'Petit Light', 3, 'Petite Light', 'petit-light', 'petite-light', 1, 1, '2018-05-21 13:12:35', NULL),
(3, 'Petit Vegetable', 3, 'Petite Vegetable', 'petit-vegetable', 'petite-vegetable', 1, 1, '2018-05-22 20:02:01', NULL),
(4, 'adasd', 3, 'asdsd', 'adasd', 'asdsd', 1, 1, '2018-05-31 13:59:31', NULL),
(5, 'Petit Jamaica', 4, 'Petite Jamaica', 'petit-jamaica', 'petite-jamaica', 1, 1, '2018-06-04 19:43:17', NULL),
(6, 'Petit 200 ML', 3, 'Petit 200 ML', 'petit-200-ml', 'petit-200-ml', 1, 1, '2018-09-10 19:42:12', NULL),
(7, 'Güitig', 3, 'Güitig', 'gitig', 'gitig', 1, 0, '2018-09-13 20:22:07', 4),
(8, 'Can - Petit', 7, 'Can - Petit', 'can-petit', 'can-petit', 1, 1, '2018-09-14 15:18:04', NULL),
(9, 'Litro Prisma - Petit', 7, 'Litro Prisma - Petit', 'litro-prisma-petit', 'litro-prisma-petit', 1, 1, '2018-09-14 15:20:20', NULL),
(10, 'Mini Can - Petit Coctel', 7, 'Mini Can - Petit Coctel', 'mini-can-petit-coctel', 'mini-can-petit-coctel', 1, 1, '2018-09-14 17:43:58', NULL),
(11, 'Bit Tajín', 8, 'Bit Tajín', 'bit-tajn', 'bit-tajn', 1, 0, '2018-09-14 18:02:25', 1),
(12, 'Glass - Old Jamaica', 4, 'Glass - Old Jamaica', 'glass-old-jamaica', 'glass-old-jamaica', 1, 1, '2018-09-14 18:29:43', NULL),
(13, 'Nobox', 4, 'Nobox ES', 'nobox', 'nobox-es', 1, 1, '2018-09-18 19:46:24', NULL),
(14, 'Product 001', 4, 'Product 001', 'product-001', 'product-001', 1, 1, '2018-09-19 12:16:47', NULL),
(15, 'Kids', 7, 'Kids', 'kids', 'kids', 1, 0, '2018-09-25 19:54:44', 5),
(16, 'Family', 7, 'Family', 'family', 'family', 1, 0, '2018-09-25 19:55:00', 7),
(17, 'Mixers', 7, 'Mixers', 'mixers', 'mixers', 1, 0, '2018-09-25 19:55:12', 6),
(18, 'Ginger Beer', 4, 'Ginger Beer', 'ginger-beer', 'ginger-beer', 1, 0, '2018-09-25 21:00:01', 3),
(19, 'Grapefruit', 4, 'Grapefruit', 'grapefruit', 'grapefruit', 1, 0, '2018-09-25 21:00:18', 2);

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

--
-- Table structure for table `cp_tela`
--

CREATE TABLE `cp_tela` (
  `id` int(11) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `ordem` int(2) DEFAULT NULL,
  `exibir_menu` tinyint(1) DEFAULT '1',
  `excluido` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_tela`
--

INSERT INTO `cp_tela` (`id`, `nome`, `slug`, `ordem`, `exibir_menu`, `excluido`) VALUES
(1, 'Admins', 'cms-user', 1, 1, 0),
(2, 'Clients', 'cms-clients', 4, 1, 0),
(3, 'Tela', 'cms-tela', 3, 1, 0),
(4, 'Perfil', 'cms-perfil', 2, 1, 0),
(5, 'Products', 'cms-products', 2, 1, 1);

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

--
-- Table structure for table `cp_typeproducts`
--

CREATE TABLE `cp_typeproducts` (
  `id` int(10) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `nomeesp` varchar(255) NOT NULL,
  `product` int(11) NOT NULL,
  `smalltext` varchar(255) DEFAULT NULL,
  `smalltextesp` varchar(255) DEFAULT NULL,
  `image` varchar(155) DEFAULT NULL,
  `imageesp` varchar(155) DEFAULT NULL,
  `description` text,
  `descriptionesp` text,
  `sellingpoints` text,
  `sellingpointsesp` text,
  `amounthori` int(11) DEFAULT NULL,
  `amountvert` int(11) DEFAULT NULL,
  `amountdept` int(11) DEFAULT NULL,
  `amountweig` int(11) DEFAULT NULL,
  `boxhori` int(11) DEFAULT NULL,
  `boxvert` int(11) DEFAULT NULL,
  `boxdept` int(11) DEFAULT NULL,
  `boxweig` int(11) DEFAULT NULL,
  `palletshori` int(11) DEFAULT NULL,
  `palletsvert` int(11) DEFAULT NULL,
  `palletsdept` int(11) DEFAULT NULL,
  `palletsweig` int(11) DEFAULT NULL,
  `validity` int(11) DEFAULT NULL,
  `ativo` tinyint(1) NOT NULL DEFAULT '1',
  `excluido` tinyint(1) NOT NULL DEFAULT '0',
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `slugeng` varchar(255) NOT NULL,
  `slugesp` varchar(255) NOT NULL,
  `generalspec` varchar(255) DEFAULT NULL,
  `ordem` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_typeproducts`
--

INSERT INTO `cp_typeproducts` (`id`, `nome`, `nomeesp`, `product`, `smalltext`, `smalltextesp`, `image`, `imageesp`, `description`, `descriptionesp`, `sellingpoints`, `sellingpointsesp`, `amounthori`, `amountvert`, `amountdept`, `amountweig`, `boxhori`, `boxvert`, `boxdept`, `boxweig`, `palletshori`, `palletsvert`, `palletsdept`, `palletsweig`, `validity`, `ativo`, `excluido`, `criado_em`, `slugeng`, `slugesp`, `generalspec`, `ordem`) VALUES
(1, 'name english', 'nombre', 2, '<p>Small Text here</p>', '<p>pequeno texto</p>', 'Array', 'unidadeespinheiro-20180522095141.jpg', '<p>Description here</p>', '<p>descricion</p>', '<p>Selling Points here</p>', '<p>puntos de venda</p>', 4, 4, 4, NULL, 5, 5, 5, NULL, 7, 7, 7, NULL, 9, 1, 1, '2018-05-22 12:51:41', '', '', '', NULL),
(2, 'name english', 'nombre', 2, '<p>Small Text here</p>', '<p>pequeno texto</p>', 'unidadebv-20180522095352.jpg', 'unidadeespinheiro-20180522095352.jpg', '<p>Description here</p>', '<p>descricion</p>', '<p>Selling Points here</p>', '<p>puntos de venda</p>', 4, 4, 4, NULL, 5, 5, 5, NULL, 7, 7, 7, NULL, 9, 1, 1, '2018-05-22 12:53:52', '', '', '', NULL),
(3, 'name english', 'nombre', 2, '<p>Small Text here</p>', '<p>pequeno texto</p>', 'unidadebv-20180522095647.jpg', 'unidadeespinheiro-20180522095647.jpg', '<p>Description here</p>', '<p>descricion</p>', '<p>Selling Points here</p>', '<p>puntos de venda</p>', 4, 4, 4, NULL, 5, 5, 5, NULL, 7, 7, 7, NULL, 9, 1, 1, '2018-05-22 12:56:47', '', '', '', NULL),
(4, 'Lata', 'nombre', 2, '<p>Small Text here</p>', '<p>pequeno texto</p>', 'protein-20180607113804.jpg', 'protein-20180607113804.jpg', 'Is the perfect mix between your favorite fruit and a tourche of fajin a beverege ready to drink and share at anytime.<br />\r\nThe perfect fruit juice to satisfield yourcraving', '<p>descricion</p>', '<ul>\r\n	<li>With real fruit juice and pulp</li>\r\n	<li>All nature colors and flavors</li>\r\n	<li>No presevatives</li>\r\n</ul>', '<p>puntos de venda</p>', 4, 4, 4, NULL, 5, 5, 5, NULL, 7, 7, 7, NULL, 9, 1, 1, '2018-05-22 12:56:55', 'lata', 'nombre-2', '', NULL),
(5, 'Dream Cap', 'nombre', 2, '<p>Small Text here</p>', '<p>pequeno texto</p>', 'protein-20180607102454.jpg', 'protein-20180607102525.jpg', '<p>Is the perfect mix between your favorite fruit and a tourche of faj&iacute;n a beverege ready to drink and share at anytime. The perfect fruit juice to satysfield your craving</p>', '<p>descricion</p>', '<ul>\r\n	<li>With real fruit juice and pulp</li>\r\n	<li>All nature colors and flavors</li>\r\n	<li>No presevatives</li>\r\n</ul>', '<p>puntos de venda</p>', 4, 4, 4, NULL, 5, 5, 5, NULL, 7, 7, 7, NULL, 9, 1, 1, '2018-05-22 12:57:06', 'dream-cap', 'nombre', '', NULL),
(6, 'Tin', 'Lata', 5, 'Small Text', 'Texto peque&ntilde;o', 'petit-20180607113741.jpg', 'petit-20180607113741.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 10, 9, 8, 0, 7, 6, 5, 0, 4, 3, 2, 0, 12, 1, 0, '2018-06-04 20:00:18', 'tin', 'lata', '', NULL),
(7, 'NECTAR PETIT LIGHT PERA', 'NECTAR PETIT LIGHT PERA', 2, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180910173924.jpg', 'petit_light_front-20180910173924.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, NULL, 4, 9, 5, NULL, 2, 5, 2, NULL, 30, 1, 1, '2018-09-10 20:39:25', 'nectar-petit-light-pera', 'nectar-petit-light-pera', 'petit_light-20180910173924.jpg', NULL),
(8, 'NECTAR PETIT LIGHT PERA', 'NECTAR PETIT LIGHT PERA', 2, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180910174242.jpg', 'petit_light_front-20180910174243.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, NULL, 4, 9, 5, NULL, 2, 5, 2, NULL, 30, 1, 1, '2018-09-10 20:42:44', 'nectar-petit-light-pera-2', 'nectar-petit-light-pera-2', 'petit_light-20180910174242.jpg', NULL),
(9, 'NECTAR PETIT LIGHT PERA', 'NECTAR PETIT LIGHT PERA', 2, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180910175827.jpg', 'petit_light_front-20180910175827.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, NULL, 4, 9, 5, NULL, 2, 5, 2, NULL, 30, 1, 1, '2018-09-10 20:58:30', 'nectar-petit-light-pera-3', 'nectar-petit-light-pera-3', 'petit_light-20180910175826.jpg', NULL),
(10, 'Nectar Petit Light  24/200ML 3PK', 'Nectar Petit Light  24/200ML 3PK', 2, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180921152140.jpg', 'petit_light_front-20180921152321.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, 0, 4, 9, 5, 0, 2, 5, 2, 0, 30, 1, 0, '2018-09-10 20:58:58', 'nectar-petit-light-24-200ml-3pk', 'nectar-petit-light-24-200ml-3pk', '', NULL),
(11, 'petit gatot', 'petit gatô', 2, 'Small Text', 'Texto peque&ntilde;o', 'bg_hora-20180910180117.png', 'bg_local-20180910180118.png', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, '2018-09-10 21:01:18', 'petit-gatot', 'petit-gat', '', NULL),
(12, 'Tripack Petit Tba Mid', 'Tripack Petit Tba Mid', 7, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180921152239.jpg', 'petit_light_front-20180921152239.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, 4, 4, 9, 5, 3, 2, 5, 2, 5, 30, 1, 1, '2018-09-13 20:27:22', 'tripack-petit-tba-mid', 'tripack-petit-tba-mid', '', NULL),
(13, 'Tripack Petit Tba Mid', 'Tripack Petit Tba Mid', 2, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180914112807.jpg', 'petit_light_front-20180914112807.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, 4, 4, 9, 5, 3, 2, 5, 2, 5, 30, 1, 1, '2018-09-14 14:28:07', 'tripack-petit-tba-mid-2', 'tripack-petit-tba-mid-2', '20180914112807.xlsx', NULL),
(14, 'Güitig', 'Güitig', 7, 'Glass Bottle', 'Glass Bottle', 'petit_light_front-20180921152222.jpg', 'petit_light_front-20180921152222.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, 4, 4, 9, 5, 3, 2, 5, 2, 5, 30, 1, 0, '2018-09-14 15:15:03', 'gitig', 'gitig', '', NULL),
(15, 'Nectar Petit 24/330 ML Lata CH', 'Nectar Petit 24/330 ML Lata CH', 8, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180921104105.jpg', 'petit_light_front-20180921152344.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, 4, 4, 9, 5, 3, 2, 5, 2, 5, 30, 1, 0, '2018-09-14 15:21:28', 'nectar-petit-24-330-ml-lata-ch', 'nectar-petit-24-330-ml-lata-ch', '', NULL),
(16, 'Coctel Preparado 237ML', 'Coctel Preparado 237ML', 10, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180921152124.jpg', 'petit_light_front-20180921152429.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, 5, 4, 9, 5, 3, 2, 5, 2, 5, 30, 1, 0, '2018-09-14 17:45:43', 'coctel-preparado-237ml', 'coctel-preparado-237ml', '', NULL),
(17, 'Bit Tajin', 'Bit Tajin', 11, 'Mini Can', 'Mini Can', 'petit_light_front-20180921152115.jpg', 'petit_light_front-20180921152410.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, 4, 4, 9, 5, 3, 2, 5, 2, 5, 30, 1, 0, '2018-09-14 18:09:14', 'bit-tajin', 'bit-tajin', '', NULL),
(18, 'Old Jamaica NRGB 24/355ML', 'Old Jamaica NRGB 24/355ML', 12, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180921152104.jpg', 'petit_light_front-20180921152358.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, 4, 4, 9, 5, 3, 2, 5, 2, 5, 30, 1, 0, '2018-09-14 18:32:03', 'old-jamaica-nrgb-24-355ml', 'old-jamaica-nrgb-24-355ml', '', NULL),
(19, 'Type of Product 001', 'Type of Product 001', 14, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180921152200.jpg', 'petit_light_front-20180921152257.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 4, 2, 3, 4, 4, 9, 5, 3, 2, 5, 2, 5, 30, 1, 0, '2018-09-19 12:17:57', 'type-of-product-001', 'type-of-product-001', '', NULL),
(20, 'Petit Light', 'Petit Light', 15, '200 ML', '200 ML', 'petit_light_front-20180921152104-20180925170554.jpg', 'petit_light_front-20180921152104-20180925170554.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 20:05:54', 'petit-light', 'petit-light', '', 1),
(21, 'Petit', 'Petit', 15, '200 ML', '200 ML', 'petit_light_front-20180921152104-20180925170706.jpg', 'petit_light_front-20180921152104-20180925170706.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 20:07:06', 'petit-2', 'petit-2', '', 2),
(22, 'Fruggie', 'Fruggie', 15, 'Small Text', 'Texto peque&ntilde;o', 'petit_light_front-20180921152104-20180925170737.jpg', 'petit_light_front-20180921152104-20180925170737.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 20:07:37', 'fruggie', 'fruggie', NULL, 3),
(23, 'Petit', 'Petit', 16, 'Can', 'Can', 'petit_light_front-20180921152104-20180925174218.jpg', 'petit_light_front-20180921152104-20180925174218.jpg', '', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 20:42:18', 'petit', 'petit', '', 2),
(24, 'Petit', 'Petit', 16, 'Liter', 'Liter', 'petit_light_front-20180921152104-20180925174835.jpg', 'petit_light_front-20180921152104-20180925174835.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 20:48:35', 'petit-3', 'petit-3', NULL, 1),
(25, 'Petit Light', 'Petit Light', 16, 'Liter', 'Liter', 'petit_light_front-20180921152104-20180925174934.jpg', 'petit_light_front-20180921152104-20180925174934.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 20:49:34', 'petit-light-2', 'petit-light-2', NULL, 3),
(26, 'Vegetable Juice', 'Vegetable Juice', 17, 'Can', 'Can', 'petit_light_front-20180921152104-20180925175500.jpg', 'petit_light_front-20180921152104-20180925175500.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 20:55:00', 'vegetable-juice', 'vegetable-juice', NULL, NULL),
(27, 'Tomato Cocktail', 'Tomato Cocktail', 17, 'Mini Can', 'Mini Can', 'petit_light_front-20180921152104-20180925175622.jpg', 'petit_light_front-20180921152104-20180925175622.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 20:56:22', 'tomato-cocktail', 'tomato-cocktail', NULL, NULL),
(28, 'Old Jamaica', 'Old Jamaica', 18, 'Can', 'Can', 'petit_light_front-20180921152104-20180925180203.jpg', 'petit_light_front-20180921152104-20180925180203.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 21:02:03', 'old-jamaica', 'old-jamaica', NULL, NULL),
(29, 'Old Jamaica', 'Old Jamaica', 18, 'Glass Bottle', 'Glass Bottle', 'petit_light_front-20180921152104-20180925180315.jpg', 'petit_light_front-20180921152104-20180925180315.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 21:03:15', 'old-jamaica-2', 'old-jamaica-2', NULL, NULL),
(30, 'Ting', 'Ting', 19, 'Can', 'Can', 'petit_light_front-20180921152104-20180925180620.jpg', 'petit_light_front-20180921152104-20180925180620.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 21:06:20', 'ting', 'ting', NULL, NULL),
(31, 'Ting', 'Ting', 19, 'Glass Bottle', 'Glass Bottle', 'petit_light_front-20180921152104-20180925180715.jpg', 'petit_light_front-20180921152104-20180925180715.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 21:07:15', 'ting-2', 'ting-2', NULL, NULL),
(32, 'Güitig', 'Güitig', 7, 'PET Bottle', 'PET Bottle', 'petit_light_front-20180921152104-20180925181349.jpg', 'petit_light_front-20180921152104-20180925181349.jpg', 'Description', 'Descripci&oacute;n', 'Selling Points', 'Punto de venda', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '2018-09-25 21:13:49', 'gitig-2', 'gitig-2', NULL, NULL);

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

--
-- Table structure for table `cp_typeproducts_atributes`
--

CREATE TABLE `cp_typeproducts_atributes` (
  `id` int(10) NOT NULL,
  `typeproduct` int(10) NOT NULL,
  `atribute` int(11) NOT NULL,
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_typeproducts_atributes`
--

INSERT INTO `cp_typeproducts_atributes` (`id`, `typeproduct`, `atribute`, `criado_em`) VALUES
(10, 12, 16, '2018-09-21 18:22:40'),
(11, 12, 17, '2018-09-21 18:22:40'),
(12, 12, 19, '2018-09-21 18:22:40'),
(13, 19, 14, '2018-09-21 18:22:57'),
(14, 19, 17, '2018-09-21 18:22:57'),
(15, 19, 23, '2018-09-21 18:22:57'),
(16, 10, 18, '2018-09-21 18:23:21'),
(17, 10, 21, '2018-09-21 18:23:21'),
(18, 10, 22, '2018-09-21 18:23:21'),
(22, 18, 18, '2018-09-21 18:23:58'),
(23, 18, 19, '2018-09-21 18:23:58'),
(24, 18, 23, '2018-09-21 18:23:58'),
(28, 16, 18, '2018-09-21 18:24:29'),
(29, 16, 20, '2018-09-21 18:24:29'),
(30, 16, 23, '2018-09-21 18:24:29'),
(37, 15, 14, '2018-09-25 17:02:10'),
(38, 15, 15, '2018-09-25 17:02:10'),
(39, 15, 16, '2018-09-25 17:02:10'),
(40, 17, 16, '2018-09-25 21:09:54'),
(41, 17, 18, '2018-09-25 21:09:54'),
(42, 17, 23, '2018-09-25 21:09:54'),
(43, 14, 14, '2018-09-25 21:12:49'),
(44, 14, 23, '2018-09-25 21:12:49'),
(45, 14, 24, '2018-09-25 21:12:49');

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

--
-- Table structure for table `cp_typeproducts_flavors`
--

CREATE TABLE `cp_typeproducts_flavors` (
  `id` int(10) NOT NULL,
  `typeproduct` int(10) NOT NULL,
  `name` varchar(155) NOT NULL,
  `description` text,
  `image` varchar(155) NOT NULL,
  `atributes` varchar(255) DEFAULT NULL,
  `arquivo` varchar(155) NOT NULL,
  `excluido` tinyint(1) NOT NULL DEFAULT '0',
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `zoomimage` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_typeproducts_flavors`
--

INSERT INTO `cp_typeproducts_flavors` (`id`, `typeproduct`, `name`, `description`, `image`, `atributes`, `arquivo`, `excluido`, `criado_em`, `zoomimage`) VALUES
(7, 1, 'flavor english', NULL, 'unidadeespinheiro-20180522095141.jpg', NULL, '20180522095141.png', 0, '2018-05-22 12:51:41', NULL),
(8, 2, 'flavor english', NULL, 'unidadeespinheiro-20180522095352.jpg', NULL, '20180522095352.png', 0, '2018-05-22 12:53:52', NULL),
(9, 3, 'flavor english', NULL, 'unidadeespinheiro-20180522095647.jpg', NULL, '20180522095647.png', 0, '2018-05-22 12:56:47', NULL),
(29, 5, 'fruit passion', NULL, 'flavor1-20180607101814.png', NULL, '20180607101814.png', 0, '2018-06-07 13:18:15', NULL),
(30, 4, 'flavor one', NULL, 'flavor1-20180607102726.png', NULL, '20180607102726.png', 0, '2018-06-07 13:27:26', NULL),
(31, 6, 'mango', NULL, 'flavor1-20180607102852.png', NULL, '20180607102852.png', 0, '2018-06-07 13:28:53', NULL),
(32, 7, 'NECTAR PETIT LIGHT', NULL, 'petit_light-20180910173925.jpg', NULL, '20180910053925.jpg', 0, '2018-09-10 20:39:25', NULL),
(33, 8, 'NECTAR PETIT LIGHT', NULL, 'petit_light-20180910174243.jpg', NULL, '20180910054243.jpg', 0, '2018-09-10 20:42:44', NULL),
(34, 9, 'NECTAR PETIT LIGHT', NULL, 'petit_light-20180910175828.jpg', NULL, '20180910055829.jpg', 0, '2018-09-10 20:58:30', NULL),
(36, 11, '', NULL, '', NULL, '', 0, '2018-09-10 21:01:18', NULL),
(37, 6, 'Pera', 'Description', 'petit_light-20180913165802.jpg', '', '20180913045803.jpg', 0, '2018-09-13 19:58:03', NULL),
(49, 13, 'Tripack Petit Tba Mid Pera', 'Description', 'untitled-1-20180914115254.png', '', '20180914115255.png', 0, '2018-09-14 14:52:55', NULL),
(50, 13, 'Tripack Petit Tba Mid Fresa Banano', 'Description', '', '', '20180914120544.png', 0, '2018-09-14 15:05:44', NULL),
(71, 15, 'Nectar Pettt Light Mango 24/200ML 3PK', 'Description', 'untitled-1-20180921152612.png', '8, ', '20180921032612.png', 0, '2018-09-21 18:26:12', NULL),
(72, 15, 'Nectar Pettt Light Peneapple/Orange 24/200ML 3PK', 'Description', 'untitled-1-20180921152649.png', '5, 7, ', '20180921032649.png', 0, '2018-09-21 18:26:49', NULL),
(73, 18, 'Old Jamaica NRGB 24/355ML Regular', 'Description', 'untitled-1-20180921152719.png', '9, 10, 11, ', '20180921032719.png', 0, '2018-09-21 18:27:19', NULL),
(74, 17, 'Bebida BIT Piña 24/233ML E.E.U.U.', 'Description', 'untitled-1-20180921152806.png', '3, ', '20180921032806.png', 0, '2018-09-21 18:28:06', NULL),
(75, 17, 'Bebida BIT Guava 24/233ML E.E.U.U.', 'Description', 'untitled-1-20180921152826.png', '4, ', '20180921032826.png', 0, '2018-09-21 18:28:26', NULL),
(76, 19, 'Product 001 Various', 'Description', 'untitled-1-20180921152934.png', '4, 5, 6, ', '20180921032934.png', 0, '2018-09-21 18:29:34', NULL),
(77, 10, 'Nectar Pettt Light Pera 24/200ML 3PK', 'Description', 'untitled-1-20180921153048.png', '2, ', '20180921033049.png', 0, '2018-09-21 18:30:49', NULL),
(79, 10, 'Nectar Pettt Light Random 24/200ML 3PK', 'Description', 'untitled-1-20180921153153.png', '4, 6, 10, 11, ', '20180921033153.png', 0, '2018-09-21 18:31:53', NULL),
(80, 10, 'Nectar Pettt Light Mango 24/200ML 3PK', 'Description', 'untitled-1-20180921153305.png', '8, ', '20180921033305.png', 0, '2018-09-21 18:33:05', NULL),
(81, 16, 'Coctel de Tomate Preparado 237ML', 'Description', 'untitled-1-20180921153342.png', '12, ', '20180921033342.png', 0, '2018-09-21 18:33:42', NULL),
(84, 12, 'Tripack Petit Tba Mid Fresa Banano', 'Description', 'untitled-1-20180921153523.png', '6, ', '20180921033523.png', 0, '2018-09-21 18:35:23', NULL),
(85, 14, 'Nectar Petit Mango 24/200 ML 3PK', 'Description', 'untitled-1-20180921153545.png', '8, ', '20180921033545.png', 0, '2018-09-21 18:35:45', NULL),
(86, 14, 'Nectar Petit Fruit Cocktail 24/200 ML 3PK', 'Description', 'untitled-1-20180921153631.png', '11, ', '20180921033631.png', 0, '2018-09-21 18:36:31', NULL),
(87, 12, '3Pk Nectar Petit Naranja 24/200Ml', 'Description', 'untitled-1-20180921153825.png', '7, ', '20180921033825.png', 0, '2018-09-21 18:38:25', NULL),
(88, 15, 'Nectar Pettt Light Pera 24/200ML 3PK', 'Description', 'untitled-1-20180921153928.png', '2, ', '20180921033928.png', 0, '2018-09-21 18:39:28', NULL),
(93, 20, 'Pineapple', 'Description', 'petit_light_front-20180921152104-20180925172733.jpg', '5, ', '20180925052733.jpg', 0, '2018-09-25 20:27:33', '20181002112008.jpg'),
(94, 20, 'Pear', 'Description', 'petit_light_front-20180921152104-20180925172812.jpg', '2, ', '20180925052812.jpg', 0, '2018-09-25 20:28:12', '20181002112016.jpg'),
(95, 20, 'Peach', 'Description', 'petit_light_front-20180921152104-20180925172849.jpg', '3, ', '20180925052850.jpg', 0, '2018-09-25 20:28:50', '20181002112019.jpg'),
(97, 20, 'Mango', 'Description', 'petit_light_front-20180921152104-20180925172955.jpg', '8, ', '', 0, '2018-09-25 20:29:55', '20181002112024.jpg'),
(98, 21, 'Apple', 'Description', 'petit_light_front-20180921152104-20180925173246.jpg', '13, ', '', 0, '2018-09-25 20:32:46', NULL),
(99, 21, 'Pear', 'Description', 'petit_light_front-20180921152104-20180925173328.jpg', '2, ', '', 0, '2018-09-25 20:33:28', NULL),
(100, 24, 'Fruit', 'Description', 'petit_light_front-20180921152104-20180925192223.jpg', '2, 3, 4, 5, ', '', 0, '2018-09-25 22:22:24', NULL),
(101, 17, 'Bebida BIT Apple 24/233ML E.E.U.U.', 'Description', 'untitled-1-20181001102618.png', '13, ', '20181001102618.png', 0, '2018-10-01 12:37:37', NULL);

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

--
-- Table structure for table `cp_typeproducts_flavorsesp`
--

CREATE TABLE `cp_typeproducts_flavorsesp` (
  `id` int(10) NOT NULL,
  `typeproduct` int(10) NOT NULL,
  `name` varchar(155) NOT NULL,
  `description` text,
  `image` varchar(155) NOT NULL,
  `atributes` varchar(255) DEFAULT NULL,
  `arquivo` varchar(155) NOT NULL,
  `excluido` tinyint(1) NOT NULL DEFAULT '0',
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `zoomimage` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_typeproducts_flavorsesp`
--

INSERT INTO `cp_typeproducts_flavorsesp` (`id`, `typeproduct`, `name`, `description`, `image`, `atributes`, `arquivo`, `excluido`, `criado_em`, `zoomimage`) VALUES
(1, 1, 'sabor', NULL, 'dados-20180522095141.png', NULL, '20180522095141.png', 0, '2018-05-22 12:51:41', NULL),
(2, 2, 'sabor', NULL, 'dados-20180522095352.png', NULL, '20180522095352.png', 0, '2018-05-22 12:53:52', NULL),
(3, 3, 'sabor', NULL, 'dados-20180522095647.png', NULL, '20180522095647.png', 0, '2018-05-22 12:56:47', NULL),
(22, 5, 'pasión de la fruta', NULL, 'flavor1-20180607101814.png', NULL, '20180607101814.png', 0, '2018-06-07 13:18:15', NULL),
(23, 4, 'sabor uno', NULL, 'flavor1-20180607102726.png', NULL, '20180607102726.png', 0, '2018-06-07 13:27:26', NULL),
(24, 6, 'mango', NULL, 'flavor1-20180607102852.png', NULL, '20180607102853.png', 0, '2018-06-07 13:28:53', NULL),
(25, 7, 'NECTAR PETIT LIGHT', NULL, 'petit_light-20180910173925.jpg', NULL, '20180910053925.jpg', 0, '2018-09-10 20:39:25', NULL),
(26, 8, 'NECTAR PETIT LIGHT', NULL, 'petit_light-20180910174243.jpg', NULL, '20180910054244.jpg', 0, '2018-09-10 20:42:44', NULL),
(27, 9, 'NECTAR PETIT LIGHT', NULL, 'petit_light-20180910175829.jpg', NULL, '20180910055830.jpg', 0, '2018-09-10 20:58:30', NULL),
(29, 6, 'Pera', 'Descripci&oacute;n', 'petit_light-20180913165821.jpg', '', '20180913045821.jpg', 0, '2018-09-13 19:58:21', NULL),
(44, 13, 'Tripack Petit Tba Mid Pera', 'Descripci&oacute;n', 'untitled-1-20180914115255.png', '', '20180914115255.png', 0, '2018-09-14 14:52:55', NULL),
(45, 13, 'Tripack Petit Tba Mid Fresa Banano', 'Descripci&oacute;n', 'untitled-1-20180914120544.png', '', '20180914120544.png', 0, '2018-09-14 15:05:44', NULL),
(64, 15, 'Nectar Pettt Light Mango 24/200ML 3PK', 'Descripci&oacute;n', 'untitled-1-20180921152612.png', '8, ', '20180921032612.png', 0, '2018-09-21 18:26:12', NULL),
(65, 15, 'Nectar Pettt Light Peneapple/Orange 24/200ML 3PK', 'Descripci&oacute;n', 'untitled-1-20180921152649.png', '5, 7, ', '20180921032649.png', 0, '2018-09-21 18:26:49', NULL),
(66, 18, 'Old Jamaica NRGB 24/355ML Regular', 'Descripci&oacute;n', 'untitled-1-20180921152719.png', '9, 10, 11, ', '20180921032719.png', 0, '2018-09-21 18:27:19', NULL),
(67, 17, 'Bebida BIT Piña 24/233ML E.E.U.U.', 'Descripci&oacute;n', 'untitled-1-20180921152806.png', '3, ', '20180921032806.png', 0, '2018-09-21 18:28:06', NULL),
(68, 17, 'Bebida BIT Guava 24/233ML E.E.U.U.', 'Descripci&oacute;n', 'untitled-1-20180921152826.png', '4, ', '20180921032826.png', 0, '2018-09-21 18:28:26', NULL),
(69, 19, 'Product 001 Various', 'Descripci&oacute;n', 'untitled-1-20180921152934.png', '4, 5, 6, ', '20180921032934.png', 0, '2018-09-21 18:29:34', NULL),
(70, 10, 'Nectar Pettt Light Pera 24/200ML 3PK', 'Descripci&oacute;n', 'untitled-1-20180921153049.png', '2, ', '20180921033049.png', 0, '2018-09-21 18:30:49', NULL),
(72, 10, 'Nectar Pettt Light Random 24/200ML 3PK', 'Descripci&oacute;n', 'untitled-1-20180921153153.png', '4, 6, 10, 11, ', '20180921033153.png', 0, '2018-09-21 18:31:53', NULL),
(73, 10, 'Nectar Pettt Light Mango 24/200ML 3PK', 'Descripci&oacute;n', 'untitled-1-20180921153305.png', '8, ', '20180921033305.png', 0, '2018-09-21 18:33:05', NULL),
(74, 16, 'Coctel de Tomate Preparado 237ML', 'Descripci&oacute;n', 'untitled-1-20180921153342.png', '12, ', '20180921033342.png', 0, '2018-09-21 18:33:42', NULL),
(77, 12, 'Tripack Petit Tba Mid Fresa Banano', 'Descripci&oacute;n', 'untitled-1-20180921153523.png', '6, ', '20180921033523.png', 0, '2018-09-21 18:35:23', NULL),
(78, 14, 'Nectar Petit Mango 24/200 ML 3PK', 'Descripci&oacute;n', 'untitled-1-20180921153545.png', '8, ', '20180921033545.png', 0, '2018-09-21 18:35:45', NULL),
(79, 14, 'Nectar Petit Fruit Cocktail 24/200 ML 3PK', 'Descripci&oacute;n', 'untitled-1-20180921153631.png', '11, ', '20180921033631.png', 0, '2018-09-21 18:36:31', NULL),
(80, 12, '3Pk Nectar Petit Naranja 24/200Ml', 'Descripci&oacute;n', 'untitled-1-20180921153825.png', '7, ', '20180921033825.png', 0, '2018-09-21 18:38:25', NULL),
(81, 15, 'Nectar Pettt Light Pera 24/200ML 3PK', 'Descripci&oacute;n', 'untitled-1-20180921153928.png', '2, ', '20180921033928.png', 0, '2018-09-21 18:39:28', NULL),
(82, 17, 'Bebida BIT Apple 24/233ML E.E.U.U.', 'Descripci&oacute;n', 'untitled-1-20181001093737.png', '13, ', '20181001093737.png', 0, '2018-10-01 12:37:37', NULL);

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

--
-- Table structure for table `cp_typeproducts_support`
--

CREATE TABLE `cp_typeproducts_support` (
  `id` int(10) NOT NULL,
  `typeproduct` int(10) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `size` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `arquivo` varchar(155) NOT NULL,
  `excluido` tinyint(1) NOT NULL DEFAULT '0',
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tipo_arquivo` char(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_typeproducts_support`
--

INSERT INTO `cp_typeproducts_support` (`id`, `typeproduct`, `nome`, `size`, `type`, `arquivo`, `excluido`, `criado_em`, `tipo_arquivo`) VALUES
(3, 11, '', '1198560', 'pdf', '20180521055842.pdf', 0, '2018-05-21 20:58:42', ''),
(4, 11, '', '33172', 'pdf', '20180521055842.pdf', 0, '2018-05-21 20:58:42', ''),
(11, 1, '', '33172', 'pdf', '20180522095141.pdf', 0, '2018-05-22 12:51:41', ''),
(12, 2, '', '33172', 'pdf', '20180522095352.pdf', 0, '2018-05-22 12:53:52', ''),
(13, 3, '', '33172', 'pdf', '20180522095647.pdf', 0, '2018-05-22 12:56:47', ''),
(30, 4, 'description file ', '1198560', 'pdf', '20180607102726.pdf', 0, '2018-06-07 13:27:26', 'bb'),
(31, 6, 'support mango', '1198560', 'pdf', '20180607102853.pdf', 0, '2018-06-07 13:28:53', 'bb'),
(32, 5, 'support fruit passion', '196657', 'png', '20180619030309.png', 0, '2018-06-19 18:03:10', 'bb'),
(33, 7, 'Labels', '230350', 'jpg', '20180910053925.jpg', 0, '2018-09-10 20:39:25', 'ms'),
(34, 8, 'Labels', '230350', 'jpg', '20180910054244.jpg', 0, '2018-09-10 20:42:44', 'ms'),
(35, 9, 'Labels', '230350', 'jpg', '20180910055830.jpg', 0, '2018-09-10 20:58:30', 'ms'),
(40, 13, 'Brand Basics', '3021', 'zip', '20180914113232.zip', 0, '2018-09-14 14:32:32', 'bb'),
(41, 13, 'Product Shots', '3021', 'zip', '20180914113246.zip', 0, '2018-09-14 14:32:46', 'ps'),
(42, 13, 'Product Video', '3021', 'zip', '20180914113303.zip', 0, '2018-09-14 14:33:03', 'pv'),
(43, 13, 'Marketing Support', '3021', 'zip', '20180914113615.zip', 0, '2018-09-14 14:36:15', 'ms'),
(44, 10, 'Brand Basics', '3021', 'zip', '20180914113847.zip', 0, '2018-09-14 14:38:47', 'bb'),
(45, 10, 'Product Shots', '3021', 'zip', '20180914113858.zip', 0, '2018-09-14 14:38:58', 'ps'),
(46, 10, 'Product Video', '3021', 'zip', '20180914113925.zip', 0, '2018-09-14 14:39:25', 'pv'),
(47, 10, 'Marketing Support', '3021', 'zip', '20180914113947.zip', 0, '2018-09-14 14:39:47', 'ms'),
(48, 12, 'Brand Basics', '3021', 'zip', '20180914120614.zip', 0, '2018-09-14 15:06:14', 'bb'),
(50, 12, 'Product Shots', '3021', 'zip', '20180914120702.zip', 0, '2018-09-14 15:07:02', 'ps'),
(51, 16, 'Brand Basics', '3021', 'zip', '20180914024603.zip', 0, '2018-09-14 17:46:03', 'bb'),
(52, 16, 'Product Shots', '3021', 'zip', '20180914024616.zip', 0, '2018-09-14 17:46:16', 'ps'),
(53, 16, 'Product Video', '3021', 'zip', '20180914024647.zip', 0, '2018-09-14 17:46:47', 'pv'),
(54, 16, 'Marketing Support', '3021', 'zip', '20180914024700.zip', 0, '2018-09-14 17:47:00', 'ms'),
(55, 17, 'Brand Basics', '3021', 'zip', '20180914031004.zip', 0, '2018-09-14 18:10:04', 'bb'),
(56, 17, 'Product Shots', '3021', 'zip', '20180914031029.zip', 0, '2018-09-14 18:10:29', 'ps'),
(57, 17, 'Product Video', '3021', 'zip', '20180914031619.zip', 0, '2018-09-14 18:16:19', 'pv'),
(58, 17, 'Marketing Support', '3021', 'zip', '20180914031632.zip', 0, '2018-09-14 18:16:32', 'ms'),
(59, 18, 'Brand Basics', '3021', 'zip', '20180914033219.zip', 0, '2018-09-14 18:32:19', 'bb'),
(60, 18, 'Product Video', '3021', 'zip', '20180914033232.zip', 0, '2018-09-14 18:32:32', 'pv'),
(61, 15, 'Brand Basics', '3021', 'zip', '20180921110710.zip', 0, '2018-09-21 14:07:10', 'bb'),
(62, 15, 'Product Shots', '3021', 'zip', '20180921110728.zip', 0, '2018-09-21 14:07:28', 'ps'),
(63, 15, 'Product Video', '', '', '', 0, '2018-09-21 16:57:23', 'pv'),
(64, 15, 'Marketing Support', '', '', '', 0, '2018-09-21 16:57:37', 'ms'),
(65, 14, 'Product Shots', '3021', 'zip', '20181002014019.zip', 0, '2018-10-02 16:40:19', 'ps'),
(66, 14, 'Brand Basics', '3021', 'zip', '20181002014028.zip', 0, '2018-10-02 16:40:28', 'bb');

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

--
-- Table structure for table `cp_typeproducts_supportesp`
--

CREATE TABLE `cp_typeproducts_supportesp` (
  `id` int(10) NOT NULL,
  `typeproduct` int(10) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `size` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `arquivo` varchar(155) NOT NULL,
  `excluido` tinyint(1) NOT NULL DEFAULT '0',
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tipo_arquivo` char(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_typeproducts_supportesp`
--

INSERT INTO `cp_typeproducts_supportesp` (`id`, `typeproduct`, `nome`, `size`, `type`, `arquivo`, `excluido`, `criado_em`, `tipo_arquivo`) VALUES
(1, 1, '', '33172', 'pdf', '20180522095141.pdf', 0, '2018-05-22 12:51:41', ''),
(2, 2, '', '33172', 'pdf', '20180522095352.pdf', 0, '2018-05-22 12:53:52', ''),
(3, 3, '', '33172', 'pdf', '20180522095647.pdf', 0, '2018-05-22 12:56:47', ''),
(14, 5, 'soporte  pasión de la fruta', '1198560', 'pdf', '20180607101814.pdf', 0, '2018-06-07 13:18:15', ''),
(15, 4, 'descrision spporte arquivo', '1198560', 'pdf', '20180607102726.pdf', 0, '2018-06-07 13:27:26', ''),
(16, 6, 'soporte mango', '1198560', 'pdf', '20180607102853.pdf', 0, '2018-06-07 13:28:53', ''),
(21, 13, 'Brand Basics', '3021', 'zip', '20180914113232.zip', 0, '2018-09-14 14:32:32', 'bb'),
(22, 13, 'Product Shots', '3021', 'zip', '20180914113246.zip', 0, '2018-09-14 14:32:46', 'ps'),
(23, 13, 'Product Video', '3021', 'zip', '20180914113303.zip', 0, '2018-09-14 14:33:03', 'pv'),
(24, 13, 'Marketing Support', '3021', 'zip', '20180914113615.zip', 0, '2018-09-14 14:36:15', 'ms'),
(25, 10, 'Brand Basics', '3021', 'zip', '20180914113847.zip', 0, '2018-09-14 14:38:47', 'bb'),
(26, 10, 'Product Shots', '', '', '', 0, '2018-09-14 14:38:58', 'ps'),
(27, 10, 'Product Video', '3021', 'zip', '20180914113925.zip', 0, '2018-09-14 14:39:25', 'pv'),
(28, 10, 'Marketing Support', '3021', 'zip', '20180914113947.zip', 0, '2018-09-14 14:39:47', 'ms'),
(29, 12, 'Brand Basics', '3021', 'zip', '20180914120614.zip', 0, '2018-09-14 15:06:14', 'bb'),
(31, 12, 'Product Shots', '3021', 'zip', '20180914120702.zip', 0, '2018-09-14 15:07:02', 'ps'),
(32, 16, 'Brand Basics', '3021', 'zip', '20180914024603.zip', 0, '2018-09-14 17:46:03', 'bb'),
(33, 16, 'Product Shots', '3021', 'zip', '20180914024616.zip', 0, '2018-09-14 17:46:16', 'ps'),
(34, 16, 'Product Video', '', '', '', 0, '2018-09-14 17:46:47', 'pv'),
(35, 16, 'Marketing Support', '3021', 'zip', '20180914024700.zip', 0, '2018-09-14 17:47:00', 'ms'),
(36, 17, 'Brand Basics', '3021', 'zip', '20180914031004.zip', 0, '2018-09-14 18:10:04', 'bb'),
(37, 17, 'Product Shots', '3021', 'zip', '20180914031029.zip', 0, '2018-09-14 18:10:29', 'ps'),
(38, 17, 'Product Video', '3021', 'zip', '20180914031619.zip', 0, '2018-09-14 18:16:19', 'pv'),
(39, 17, 'Marketing Support', '3021', 'zip', '20180914031632.zip', 0, '2018-09-14 18:16:32', 'ms'),
(40, 18, 'Brand Basics', '3021', 'zip', '20180914033219.zip', 0, '2018-09-14 18:32:19', 'bb'),
(41, 18, 'Product Video', '3021', 'zip', '20180914033232.zip', 0, '2018-09-14 18:32:32', 'pv'),
(42, 15, 'Brand Basics', '3021', 'zip', '20180921110710.zip', 0, '2018-09-21 14:07:10', 'bb'),
(43, 15, 'Product Shots', '3021', 'zip', '20180921110728.zip', 0, '2018-09-21 14:07:28', 'ps'),
(44, 15, 'Product Video', '3021', 'zip', '20180921015723.zip', 0, '2018-09-21 16:57:23', 'pv'),
(45, 15, 'Marketing Support', '3021', 'zip', '20180921015737.zip', 0, '2018-09-21 16:57:37', 'ms');

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

--
-- Table structure for table `cp_welcome`
--

CREATE TABLE `cp_welcome` (
  `id` int(10) NOT NULL,
  `description` text,
  `descriptionesp` text,
  `criado_em` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_welcome`
--

INSERT INTO `cp_welcome` (`id`, `description`, `descriptionesp`, `criado_em`) VALUES
(1, '<p>Beliv started in 2009 under the name of Livsmart Americas, as a business unit of CBC (Central American Bottling Corporation), focused on the development, production and commercialization of juices, nectars and soft drinks, exporting their products around the world.<br />\r\nIt is in 2016 that the company makes a business turn, focusing directly on innovation, healthy indulgence and fun enjoyment, developing beverages that do well.<br />\r\nThe category portfolio is enlarged (bottled water, carbonated beverages, energizers, premium, juices, nectars and soft drinks) and as a result of this, we evolved the way to quench thirst in more than 24 nationalities.<br />\r\nWe have presence in several countries and cities of North America, Central America, the Caribbean and South America, as well as London and Senegal.</p>', 'Beliv inicia desde el 2009 bajo el nombre de Livsmart Am&eacute;ricas, como una unidad de negocios de CBC (Central American Bottling Corporation), enfocada en el desarrollo, producci&oacute;n y comercializaci&oacute;n de jugos, n&eacute;ctares y bebidas refrescantes, exportando sus productos alrededor del mundo.<br />\r\nEs en el 2016 que la compa&ntilde;&iacute;a hace un giro de negocio, enfoc&aacute;ndose directamente en la innovaci&oacute;n, sana indulgencia y fun enjoyment, desarrollando bebidas que hacen bien.<br />\r\nSe agranda el portafolio de categor&iacute;as (agua embotellada, bebidas carbonatadas, energizantes, Premium, jugos, n&eacute;ctares y bebidas refrescantes) y derivado de esto, evolucionamos la forma de saciar la sed en m&aacute;s de 24 nacionalidades.<br />\r\nContamos con presencia en varios pa&iacute;ses y ciudades de Am&eacute;rica del Norte, Centroam&eacute;rica, el Caribe y Suram&eacute;rica, as&iacute; como Londr&eacute;s y Senegal.', '2018-05-18 03:00:00');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `cp_log`
--
ALTER TABLE `cp_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_logs_usuarios1_idx` (`usuario_id`);

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cp_atributes`
--
ALTER TABLE `cp_atributes`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `cp_brands`
--
ALTER TABLE `cp_brands`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

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

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

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

--
-- AUTO_INCREMENT for table `cp_permissoes`
--
ALTER TABLE `cp_permissoes`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `cp_products`
--
ALTER TABLE `cp_products`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

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

--
-- AUTO_INCREMENT for table `cp_typeproducts`
--
ALTER TABLE `cp_typeproducts`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `cp_typeproducts_atributes`
--
ALTER TABLE `cp_typeproducts_atributes`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `cp_typeproducts_flavors`
--
ALTER TABLE `cp_typeproducts_flavors`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102;

--
-- AUTO_INCREMENT for table `cp_typeproducts_flavorsesp`
--
ALTER TABLE `cp_typeproducts_flavorsesp`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `cp_typeproducts_support`
--
ALTER TABLE `cp_typeproducts_support`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT for table `cp_typeproducts_supportesp`
--
ALTER TABLE `cp_typeproducts_supportesp`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `cp_welcome`
--
ALTER TABLE `cp_welcome`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

