-- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Oct 04, 2018 at 12:14 PM -- Server version: 5.7.23-0ubuntu0.16.04.1 -- PHP Version: 7.2.0RC4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `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_clientes` -- CREATE TABLE `cp_clientes` ( `id` int(10) NOT NULL, `nome` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `login` varchar(255) DEFAULT NULL, `senha` varchar(255) DEFAULT NULL, `imagem` varchar(155) DEFAULT NULL, `office` varchar(255) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `token` char(30) DEFAULT NULL, `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_clientes` -- INSERT INTO `cp_clientes` (`id`, `nome`, `email`, `login`, `senha`, `imagem`, `office`, `phone`, `address`, `token`, `ativo`, `excluido`, `criado_em`) VALUES (1, 'Teste', 'asd@asd.com', NULL, '$2a$08$/MkiNanOgqg5wN6XcQVQuep6DzZuY/EEZj3YxcaaScsqeCEv8HVGy', 'users-20180518161347.png', NULL, NULL, NULL, NULL, 1, 1, '2018-05-18 17:38:16'), (2, 'Amanda Bayners', 'dev@cappen.com', NULL, '$2a$08$xBrfRuLTBsbccpH1YZ55zOhw8OE2.s2Fq2Z1ixbXRVVaMM1eSZbZa', 'user-20180607101602.jpg', 'Manager', '(261) 967-9396', 'ESTRADA DAS UBAIAS', NULL, 1, 0, '2018-05-18 19:41:54'); -- -------------------------------------------------------- -- -- 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, '

Small Text here

', '

pequeno texto

', 'Array', 'unidadeespinheiro-20180522095141.jpg', '

Description here

', '

descricion

', '

Selling Points here

', '

puntos de venda

', 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, '

Small Text here

', '

pequeno texto

', 'unidadebv-20180522095352.jpg', 'unidadeespinheiro-20180522095352.jpg', '

Description here

', '

descricion

', '

Selling Points here

', '

puntos de venda

', 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, '

Small Text here

', '

pequeno texto

', 'unidadebv-20180522095647.jpg', 'unidadeespinheiro-20180522095647.jpg', '

Description here

', '

descricion

', '

Selling Points here

', '

puntos de venda

', 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, '

Small Text here

', '

pequeno texto

', '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.
\r\nThe perfect fruit juice to satisfield yourcraving', '

descricion

', '', '

puntos de venda

', 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, '

Small Text here

', '

pequeno texto

', 'protein-20180607102454.jpg', 'protein-20180607102525.jpg', '

Is the perfect mix between your favorite fruit and a tourche of fajín a beverege ready to drink and share at anytime. The perfect fruit juice to satysfield your craving

', '

descricion

', '', '

puntos de venda

', 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ño', 'petit-20180607113741.jpg', 'petit-20180607113741.jpg', 'Description', 'Descripció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ño', 'petit_light_front-20180910173924.jpg', 'petit_light_front-20180910173924.jpg', 'Description', 'Descripció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ño', 'petit_light_front-20180910174242.jpg', 'petit_light_front-20180910174243.jpg', 'Description', 'Descripció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ño', 'petit_light_front-20180910175827.jpg', 'petit_light_front-20180910175827.jpg', 'Description', 'Descripció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ño', 'petit_light_front-20180921152140.jpg', 'petit_light_front-20180921152321.jpg', 'Description', 'Descripció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ño', 'bg_hora-20180910180117.png', 'bg_local-20180910180118.png', 'Description', 'Descripció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ño', 'petit_light_front-20180921152239.jpg', 'petit_light_front-20180921152239.jpg', 'Description', 'Descripció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ño', 'petit_light_front-20180914112807.jpg', 'petit_light_front-20180914112807.jpg', 'Description', 'Descripció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ó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ño', 'petit_light_front-20180921104105.jpg', 'petit_light_front-20180921152344.jpg', 'Description', 'Descripció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ño', 'petit_light_front-20180921152124.jpg', 'petit_light_front-20180921152429.jpg', 'Description', 'Descripció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ó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ño', 'petit_light_front-20180921152104.jpg', 'petit_light_front-20180921152358.jpg', 'Description', 'Descripció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ño', 'petit_light_front-20180921152200.jpg', 'petit_light_front-20180921152257.jpg', 'Description', 'Descripció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ó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ó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ño', 'petit_light_front-20180921152104-20180925170737.jpg', 'petit_light_front-20180921152104-20180925170737.jpg', 'Description', 'Descripció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ó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ó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ó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ó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ó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ó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ó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ó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ó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ó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ón', 'petit_light-20180913165821.jpg', '', '20180913045821.jpg', 0, '2018-09-13 19:58:21', NULL), (44, 13, 'Tripack Petit Tba Mid Pera', 'Descripción', 'untitled-1-20180914115255.png', '', '20180914115255.png', 0, '2018-09-14 14:52:55', NULL), (45, 13, 'Tripack Petit Tba Mid Fresa Banano', 'Descripció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ó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ó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ó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ó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ón', 'untitled-1-20180921152826.png', '4, ', '20180921032826.png', 0, '2018-09-21 18:28:26', NULL), (69, 19, 'Product 001 Various', 'Descripció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ó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ó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ón', 'untitled-1-20180921153305.png', '8, ', '20180921033305.png', 0, '2018-09-21 18:33:05', NULL), (74, 16, 'Coctel de Tomate Preparado 237ML', 'Descripció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ó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ó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ó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ó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ó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ó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_usuarios` -- CREATE TABLE `cp_usuarios` ( `id` int(10) NOT NULL, `perfil_id` int(10) NOT NULL DEFAULT '0', `nome` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `login` varchar(255) DEFAULT NULL, `senha` varchar(255) DEFAULT NULL, `token` char(30) DEFAULT NULL, `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_usuarios` -- INSERT INTO `cp_usuarios` (`id`, `perfil_id`, `nome`, `email`, `login`, `senha`, `token`, `ativo`, `excluido`, `criado_em`) VALUES (1, 1, 'Cappen', 'suporte@cappen.com', 'suporte', '$2a$08$fVfEYTcP16BUOJNLjOn6y.60rlAkmZZHSIBP5lR6fW/tGPr3TeiM6', NULL, 1, 0, '2013-10-11 15:47:28'), (2, 1, 'Felipe', 'angeiras@cappen.com', 'diego', '$2a$08$KOpHnCeqJDWDfLLdlq2dZOsvEw49RtovFNqaf45SzyNtiFstDUD5u', 'kzhKIT9pk0S8bj3obIx7gfMn1TQLqW', 1, 0, '2013-10-11 15:47:28'), (3, 3, 'Ruan', 'ruan@cappen.com', 'ruan', '$2a$08$lwentmDwseUgd3XNYzsUze5sbWGXWGszKQ1Aw.1PsACKmpjP1btE.', NULL, 1, 1, '2015-12-17 20:21:19'), (4, 1, 'Gabriela', 'gabriela@cappen.com', 'gabi', '$2a$08$.EkupbqCMc9khPyvWQjg1.inYjnW2ujnfECEb4LoTrLtmTXXQuE/a', NULL, 0, 1, '2018-05-10 20:38:56'), (5, 1, 'teste', 'teste@cappen.com', NULL, '$2a$08$4DbJ2twpyeycybmAkRjtReNmJX2VeLkkvM5WZ/iXQmutP0CqtM/Cu', NULL, 1, 1, '2018-05-18 14:30:24'), (6, 1, 'teste', 'teste@cappen.com', NULL, '$2a$08$UP5WXNMatA.9gJapwrKSNemI.QDZ75jL5s4jIarBzWJavMMIp7uF2', NULL, 1, 1, '2018-05-18 14:56:17'), (7, 1, 'asdsad', 'teste@cappen.com', NULL, '$2a$08$8BqQTi.BrEcSb6efuR4ukeXhrTPklzwYcwkkMHlk2ByIlSF2MBaaq', NULL, 1, 1, '2018-05-18 14:57:12'), (8, 1, 'qqq', 'cappenteste01@cappen.com', NULL, '$2a$08$5aXlEhAg1HdsFpZx8gtH5uEsdUVIi2CMRXUvMksRLUUm0f4EpaRE6', NULL, 1, 1, '2018-05-18 15:00:00'), (9, 1, 'teste', 'teste@email.com', NULL, '$2a$08$L7K0MtFvJJugrAKtS/vurOp7Qu8kNyqh8KFbG/E0vB4OpMPZMHXvm', NULL, 1, 1, '2018-05-18 16:30:36'), (10, 1, '', '', NULL, '$2a$08$t2koYqEvU5Mkb0naRZuITu0083tXpLUkav6x.oyhnOx4XW8NGuoa6', NULL, 1, 1, '2018-05-23 13:15:30'), (11, 1, 'sdsad', 'asd@asd.com', NULL, '$2a$08$K5qZ/NPQFKIgKP0ZVyW.FeBDSbd443SGk3BSRkZs6fS4sk.T/Jmg6', NULL, 1, 1, '2018-05-23 13:25:31'), (12, 1, '', '', NULL, '$2a$08$HLqT66trKW7ubnYCnZnFBu1PX4KqoeaSrFQcUu.8fhn1C2X1XdVLm', NULL, 1, 1, '2018-05-23 13:27:51'), (13, 1, 'Nobox', 'email@nobox.com.br', NULL, '$2a$08$Cxy5kNfU1PMp3QGj0ork7eGMv3JuUD58YQz28PVF8k6.mb1cNtIpG', NULL, 1, 1, '2018-09-17 14:40:33'), (14, 1, 'nobox', 'email@nobox.com', NULL, '$2a$08$mo50mPqgDnPQKLtgazlIP.R/ZBs9ylTh9QWmu7RhSDMRLXnHFkWdC', NULL, 1, 0, '2018-09-17 14:42:05'); -- -------------------------------------------------------- -- -- 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, '

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.
\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.
\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.
\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.

', 'Beliv inicia desde el 2009 bajo el nombre de Livsmart Américas, como una unidad de negocios de CBC (Central American Bottling Corporation), enfocada en el desarrollo, producción y comercialización de jugos, néctares y bebidas refrescantes, exportando sus productos alrededor del mundo.
\r\nEs en el 2016 que la compañía hace un giro de negocio, enfocándose directamente en la innovación, sana indulgencia y fun enjoyment, desarrollando bebidas que hacen bien.
\r\nSe agranda el portafolio de categorías (agua embotellada, bebidas carbonatadas, energizantes, Premium, jugos, néctares y bebidas refrescantes) y derivado de esto, evolucionamos la forma de saciar la sed en más de 24 nacionalidades.
\r\nContamos con presencia en varios países y ciudades de América del Norte, Centroamérica, el Caribe y Suramérica, así como Londré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_clientes` -- ALTER TABLE `cp_clientes` 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_usuarios` -- ALTER TABLE `cp_usuarios` ADD PRIMARY KEY (`id`), ADD KEY `usuarios_perfil` (`perfil_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_clientes` -- ALTER TABLE `cp_clientes` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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_usuarios` -- ALTER TABLE `cp_usuarios` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `cp_welcome` -- ALTER TABLE `cp_welcome` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;