-- https://www.phpmyadmin.net/
--
-- Tempo de geração: 20/02/2024 às 20:41
-- Versão do servidor: 10.6.16-MariaDB-cll-lve
-- Versão do PHP: 7.2.34

START TRANSACTION;



--
-- Banco de dados: `u280989637_cardapio`
--

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

--
-- Estrutura para tabela `adm`
--

CREATE TABLE `adm` (
  `Id` int(11) NOT NULL,
  `dias` varchar(3) DEFAULT '7',
  `novocliente` varchar(1) DEFAULT '1',
  `nome` varchar(150) NOT NULL,
  `login` varchar(50) NOT NULL,
  `senha` varchar(60) NOT NULL,
  `linkpgmto` text NOT NULL,
  `statuslink` int(2) NOT NULL DEFAULT 1,
  `bloquear` int(2) NOT NULL DEFAULT 1,
  `celular` varchar(11) NOT NULL,
  `nomedosite` varchar(120) NOT NULL,
  `urlsite` varchar(160) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `adm`
--

INSERT INTO `adm` (`Id`, `dias`, `novocliente`, `nome`, `login`, `senha`, `linkpgmto`, `statuslink`, `bloquear`, `celular`, `nomedosite`, `urlsite`) VALUES
(1, '7', '1', 'Seu Delivery®', 'super_admin', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', '<script src=\"https://www.mercadopago.com.br/integrations/v1/web-payment-checkout.js\"\r\ndata-preference-id=\"666738441-c1885f4d-d035-4ece-bef6-3ec12c1297cb\">\r\n</script>\r\n\r\n', 1, 1, '6782085883', 'CardaZAP®', 'https://cardazap.com.br/');

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

--
-- Estrutura para tabela `bairros`
--

CREATE TABLE `bairros` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `bairro` varchar(30) NOT NULL,
  `taxa` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `bairros`
--

INSERT INTO `bairros` (`id`, `idu`, `bairro`, `taxa`) VALUES
(135, 41, 'Bairro 1', '0.00'),
(136, 41, 'Bairro 2', '5.00'),
(137, 41, 'Bairro 3', '7.00'),
(138, 41, 'Bairro 4', '10.00');

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

--
-- Estrutura para tabela `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `img` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `banner`
--

INSERT INTO `banner` (`id`, `idu`, `img`) VALUES
(46, 41, '16163390934284.JPG');

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

--
-- Estrutura para tabela `categorias`
--

CREATE TABLE `categorias` (
  `id` int(11) NOT NULL,
  `nome` varchar(100) NOT NULL,
  `url` varchar(100) NOT NULL,
  `idu` int(11) NOT NULL,
  `posicao` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `categorias`
--

INSERT INTO `categorias` (`id`, `nome`, `url`, `idu`, `posicao`) VALUES
(99, 'Exclusivos Delivery', '16163302943990.jpg', 41, 1),
(100, 'Combos', '16163304792576.jpg', 41, 2),
(101, 'Hambúrgueres', '16163305401431.jpg', 41, 3),
(103, 'Pizzas', '16163306443504.jpg', 41, 5),
(104, 'Porções', '16163310034537.jpg', 41, 6),
(105, 'Bebidas', '16163311503223.jpg', 41, 7),
(106, 'Sobremesas', '16163312244490.jpg', 41, 8);

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

--
-- Estrutura para tabela `config`
--

CREATE TABLE `config` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `nomeempresa` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `nomeadmin` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `email` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `senha` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cpf` varchar(18) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `url` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `telefone` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `celular` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cep` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `rua` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `bairro` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cidade` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `uf` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `complemento` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `numero` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `fuso` varchar(60) NOT NULL DEFAULT 'America/Sao_Paulo',
  `mesa` int(2) NOT NULL DEFAULT 2,
  `balcao` int(2) NOT NULL DEFAULT 1,
  `delivery` int(2) NOT NULL DEFAULT 1,
  `cupon` int(2) NOT NULL DEFAULT 1,
  `dom` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '08:00:00,12:00:00,14:00:00,23:00:00',
  `seg` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '08:00:00,12:00:00,14:00:00,23:00:00',
  `ter` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '08:00:00,12:00:00,14:00:00,23:00:00',
  `qua` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '08:00:00,12:00:00,14:00:00,23:00:00',
  `qui` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '08:00:00,12:00:00,14:00:00,23:00:00',
  `sex` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '08:00:00,12:00:00,14:00:00,23:00:00',
  `sab` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '08:00:00,12:00:00,14:00:00,23:00:00',
  `funcionamento` int(2) DEFAULT 1,
  `cormenu` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '#FFFFFF',
  `corfundo` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '#F0F2F7',
  `corrodape` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '#E3E7EB',
  `corcarrinho` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '#FFFFE6',
  `timerdelivery` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '40 a 50min',
  `timerbalcao` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '20min',
  `modelo` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '1',
  `modelo2` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '0',
  `modelo3` int(2) NOT NULL DEFAULT 1,
  `datacad` date NOT NULL,
  `dfree` varchar(9) NOT NULL DEFAULT '100.00',
  `insta` varchar(60) NOT NULL DEFAULT 'https://www.instagram.com',
  `expiracao` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `config`
--

INSERT INTO `config` (`id`, `idu`, `nomeempresa`, `nomeadmin`, `email`, `senha`, `cpf`, `url`, `telefone`, `celular`, `cep`, `rua`, `bairro`, `cidade`, `uf`, `complemento`, `numero`, `status`, `fuso`, `mesa`, `balcao`, `delivery`, `cupon`, `dom`, `seg`, `ter`, `qua`, `qui`, `sex`, `sab`, `funcionamento`, `cormenu`, `corfundo`, `corrodape`, `corcarrinho`, `timerdelivery`, `timerbalcao`, `modelo`, `modelo2`, `modelo3`, `datacad`, `dfree`, `insta`, `expiracao`) VALUES
(41, 1, 'CardaZAP® Lanches', 'CardaZAP®', 'seudeliverydigital@gmail.com', '779a923d69b2e072747b11975ba86949de167037', '111111111', 'clientedemo', '00000000', '22999235594', '85000000', 'Rua Padre Anchieta', 'Centro', 'São Paulo', 'SP', 'Em Frente ao Shopping', '123', 1, 'America/Sao_Paulo', 1, 1, 1, 1, '00:01:00,12:00:00,12:01:00,23:59:00', '00:01:00,12:00:00,12:01:00,23:59:00', '00:01:00,12:00:00,12:01:00,23:59:00', '00:01:00,12:00:00,12:01:00,23:59:00', '00:01:00,12:00:00,12:01:00,23:59:00', '00:01:00,12:00:00,12:01:00,23:59:00', '00:01:00,12:00:00,12:01:00,23:59:00', 1, '#FFFFFF', '#F0F2F7', '#FFFFFF', '#FFFFE6', '40 a 50min', '20min', '1', '1', 1, '2020-10-18', '100.00', 'https://www.instagram.com', '2021-04-19');

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

--
-- Estrutura para tabela `funcionarios`
--

CREATE TABLE `funcionarios` (
  `id` int(11) NOT NULL,
  `idu` int(9) NOT NULL,
  `nome` varchar(60) NOT NULL,
  `login` varchar(30) NOT NULL,
  `senha` varchar(60) NOT NULL,
  `acesso` varchar(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Despejando dados para a tabela `funcionarios`
--

INSERT INTO `funcionarios` (`id`, `idu`, `nome`, `login`, `senha`, `acesso`) VALUES
(15, 42, 'Lucas', '123456', '7c4a8d09ca3762af61e59520943dc26494f8941b', '1'),
(16, 42, 'Lucas', '12345', '8cb2237d0679ca88db6464eac60da96345513964', '2'),
(17, 41, 'Maycon', 'PDV', '779a923d69b2e072747b11975ba86949de167037', '1'),
(18, 41, 'Cyntia', 'COZINHA', '779a923d69b2e072747b11975ba86949de167037', '2');

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

--
-- Estrutura para tabela `fundotopo`
--

CREATE TABLE `fundotopo` (
  `id` int(11) NOT NULL,
  `idu` int(9) NOT NULL,
  `foto` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `fundotopo`
--

INSERT INTO `fundotopo` (`id`, `idu`, `foto`) VALUES
(42, 41, '16162649352812.JPG');

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

--
-- Estrutura para tabela `grupos`
--

CREATE TABLE `grupos` (
  `Id` int(11) NOT NULL,
  `idu` int(9) DEFAULT 0,
  `nomegrupo` varchar(160) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '0',
  `nomeinterno` varchar(160) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '0',
  `obrigatorio` int(2) DEFAULT 0,
  `posicao` int(11) DEFAULT 0,
  `status` int(11) DEFAULT 0,
  `quantidade` int(11) DEFAULT 0,
  `quantidade_minima` varchar(2) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `grupos`
--

INSERT INTO `grupos` (`Id`, `idu`, `nomegrupo`, `nomeinterno`, `obrigatorio`, `posicao`, `status`, `quantidade`, `quantidade_minima`) VALUES
(84, 43, 'teste', 'TEste', 2, 1, 1, 4, '0'),
(87, 41, 'Molhos', 'Molhos', 1, 1, 1, 1, '0');

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

--
-- Estrutura para tabela `limite_op`
--

CREATE TABLE `limite_op` (
  `Id` int(11) NOT NULL,
  `idp` varchar(9) DEFAULT NULL,
  `limite` varchar(3) DEFAULT '0',
  `idgrupo` int(11) DEFAULT 0,
  `meioameio` int(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `limite_op`
--

INSERT INTO `limite_op` (`Id`, `idp`, `limite`, `idgrupo`, `meioameio`) VALUES
(127, '379', '0', 76, 1),
(128, '379', '0', 77, 2),
(129, '380', '0', 78, 3),
(130, '380', '0', 79, 1),
(131, '384', '0', 80, 2),
(132, '384', '0', 81, 2),
(133, '384', '0', 82, 2),
(134, '384', '0', 83, 2),
(135, '387', '0', 87, 1),
(136, '386', '0', 87, 1),
(137, '388', '0', 87, 1),
(138, '389', '0', 87, 1),
(139, '390', '0', 87, 1),
(140, '392', '0', 87, 1);

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

--
-- Estrutura para tabela `logo`
--

CREATE TABLE `logo` (
  `id` int(11) NOT NULL,
  `idu` varchar(9) NOT NULL,
  `foto` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `logo`
--

INSERT INTO `logo` (`id`, `idu`, `foto`) VALUES
(41, '41', '16163382803721.jpg');

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

--
-- Estrutura para tabela `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `data` varchar(10) NOT NULL,
  `status` int(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

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

--
-- Estrutura para tabela `mesas`
--

CREATE TABLE `mesas` (
  `id` int(11) NOT NULL,
  `idu` varchar(9) NOT NULL,
  `numero` int(9) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Despejando dados para a tabela `mesas`
--

INSERT INTO `mesas` (`id`, `idu`, `numero`) VALUES
(7, '41', 1),
(8, '42', 1),
(9, '41', 170);

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

--
-- Estrutura para tabela `opcionais`
--

CREATE TABLE `opcionais` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `idp` int(11) NOT NULL,
  `idg` int(11) DEFAULT 0,
  `opnome` varchar(30) NOT NULL,
  `opdescricao` varchar(160) NOT NULL DEFAULT 'N',
  `valor` varchar(10) NOT NULL,
  `status` int(2) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `opcionais`
--

INSERT INTO `opcionais` (`id`, `idu`, `idp`, `idg`, `opnome`, `opdescricao`, `valor`, `status`) VALUES
(380, 41, 0, 87, 'Maionese Temperada', 'Maionese temperada especial da casa.', '1', 1),
(381, 41, 0, 87, 'Molho Barbecue', 'Molho Barbecue defumado', '2', 1);

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

--
-- Estrutura para tabela `pedidos`
--

CREATE TABLE `pedidos` (
  `id` int(11) NOT NULL,
  `idu` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `idpedido` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `entrada` timestamp NOT NULL DEFAULT current_timestamp(),
  `fpagamento` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cidade` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `numero` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `complemento` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `rua` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `bairro` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `troco` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `nome` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `data` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `hora` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `celular` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `taxa` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `mesa` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `pessoas` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `obs` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `vsubtotal` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `vadcionais` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `vtotal` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `pedidos`
--

INSERT INTO `pedidos` (`id`, `idu`, `idpedido`, `entrada`, `fpagamento`, `cidade`, `numero`, `complemento`, `rua`, `bairro`, `troco`, `nome`, `data`, `hora`, `celular`, `taxa`, `mesa`, `pessoas`, `obs`, `status`, `vsubtotal`, `vadcionais`, `vtotal`) VALUES
(254, '41', '833896PW', '2021-03-22 19:15:32', 'CARTAO', 'São Paulo', '31', 'Casa', 'Alameda dos Flamboyants', 'Bairro 2', '0.00', 'MAYCON', '22-03-2021', '16:15:32', '27997489073', '5.00', '0', '0', '0', '1', '30.00', '1.00', '36'),
(255, '41', '274424PW', '2021-03-22 20:02:58', 'BALCAO', '0', '0', '0', '0', '0', '0.00', 'EDUARDO', '22-03-2021', '17:02:58', '31986730220', '0', '0', '0', '0', '1', '48.00', '1.00', '49.00'),
(256, '41', '473761PW', '2021-03-22 20:16:38', 'BALCAO', '0', '0', '0', '0', '0', '0.00', 'EDUARDO COLAZELLI GUERREIRORF', '22-03-2021', '17:16:38', '14997273425', '0', '0', '0', '0', '1', '22.00', '2.00', '24.00'),
(257, '41', '454215', '0000-00-00 00:00:00', 'BALCAO', 'cidade', '0', '0', '0', '0', '0.00', 'Eduardo', '22-03-2021', '18:07:26', '31986730220', '0.00', '0', '0', '0', '1', '30', '1', '31'),
(258, '41', '306540PW', '2021-03-23 02:01:06', 'CARTAO', 'São Paulo', '170', '', 'Rua Desembargador Paulo Mota', 'Bairro 1', '0.00', 'EDUARDO FERNANDES GUIMARAES', '22-03-2021', '23:01:06', '31986730220', '0.00', '0', '0', '0', '1', '35.00', '1.00', '36');

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

--
-- Estrutura para tabela `produtos`
--

CREATE TABLE `produtos` (
  `id` int(11) NOT NULL,
  `idu` int(11) NOT NULL,
  `nome` varchar(200) NOT NULL,
  `valor` varchar(100) NOT NULL,
  `valorde` varchar(10) DEFAULT '0.00',
  `ingredientes` text NOT NULL,
  `categoria` varchar(100) NOT NULL,
  `foto` varchar(100) NOT NULL,
  `fotos2` varchar(255) DEFAULT 'off.jpg',
  `destaques` int(1) NOT NULL DEFAULT 0,
  `visivel` varchar(2) NOT NULL DEFAULT 'G',
  `status` int(2) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `produtos`
--

INSERT INTO `produtos` (`id`, `idu`, `nome`, `valor`, `valorde`, `ingredientes`, `categoria`, `foto`, `fotos2`, `destaques`, `visivel`, `status`) VALUES
(386, 41, 'Hambúrguer California ', '30.00', '0.00', 'PÃO ESPECIAL, BATATA CHIPS, ALFACE, TOMATE, 2 CARNES 140G, BARBECUE, CHEDDAR CREMOSO, CALABRESA E OVO', '99', '16163410253152.jpg', 'off.jpg', 0, 'G', 1),
(387, 41, 'Massa Molho Mix', '0.00', '0.00', 'MACARRÃO COM MOLHO À BASE DE TOMATE, CEBOLA, BACON, CALABRESA, PARMESÃO RALADO, FILÉ DE FRANGO, FILÉ DE BOI, MILHO, SHOYO E TEMPERO VERDE.', '99', '16163411723091.jpg', 'off.jpg', 0, 'G', 1),
(388, 41, 'Combo Big Cheddar', '65.00', '0.00', '2 BIG CHEDDAR + 1 PORÇAO DE BATATA FRITA + 1 COCA 1,5L + 2 COOKIES MEIO AMARGO', '100', '16163414403205.jpg', 'off.jpg', 0, 'G', 1),
(389, 41, 'Bacon Crispy', '20.00', '0.00', 'PÃO DO ESPECIAL, CARNE ARTESANAL 140G, BACON, MOLHO BARBECUE, MUÇARELA, MAIONESE DE BACON E CEBOLA CRISPY.', '101', '16163415642182.jpg', 'off.jpg', 0, 'G', 1),
(390, 41, 'X-Burger Artesanal', '16.00', '0.00', 'PÃO DO ESPECIAL, CARNE ARTESANAL 140G,MUÇARELA,ALFACE ,TOMATE', '101', '16163416451685.jpg', 'off.jpg', 0, 'G', 1),
(391, 41, 'X-Especial da Casa', '19.00', '0.00', 'PÃO, CARNE DE HAMBÚRGUER TRADICIONAL, MUÇARELA, 2 OVOS, BACON, BANANA, TOMATE, ALFACE, MILHO E BATATA PALHA.', '101', '16163417321837.jpg', 'off.jpg', 0, 'G', 1),
(392, 41, 'Frango com Catupiry', '0.00', '0.00', 'PIZZA COM MASSA ESPECIAL DA CASA, FRANGO DE ALTA QUALIDADE E CATUPIRY ORIGINAL, PRESERVANDO O SABOR.', '103', '16163419564476.jpg', 'off.jpg', 0, 'G', 1),
(393, 41, 'Coca Cola 1,5l', '9.00', '0.00', 'Deliciosa Coca Cola 1,5l', '105', '16163422351512.jpg', 'off.jpg', 0, 'G', 1),
(394, 41, 'Sprite 350ml', '5.00', '0.00', 'Deliciosa Sprite 350ml', '105', '16163422751396.jpg', 'off.jpg', 0, 'G', 1),
(395, 41, 'Bolo de Pote', '9.00', '0.00', 'BOLO DE CHOCOLATE MOLHADINHO COM BRIGADEIRO CREMOSO E RASPAS DE CHOCOLATE MEIO AMARGO', '106', '16163423602539.jpg', 'off.jpg', 0, 'G', 1),
(396, 41, 'Bolo de pote', '9.00', '0.00', 'BOLO DE BAUNILHA COM CREME DE NUTELLA E NINHO EXTREMAMENTE CREMOSO E SABOROSO', '106', '16163424022997.jpg', 'off.jpg', 0, 'G', 1);

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

--
-- Estrutura para tabela `store`
--

CREATE TABLE `store` (
  `id` int(11) NOT NULL,
  `idu` int(10) NOT NULL,
  `idpedido` varchar(32) NOT NULL,
  `idsecao` int(20) NOT NULL,
  `produto_id` varchar(100) NOT NULL,
  `data` varchar(100) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `valor` varchar(100) NOT NULL,
  `quantidade` int(11) NOT NULL,
  `tamanho` varchar(19) NOT NULL DEFAULT 'N',
  `obs` varchar(255) DEFAULT 'Não'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `store`
--

INSERT INTO `store` (`id`, `idu`, `idpedido`, `idsecao`, `produto_id`, `data`, `status`, `valor`, `quantidade`, `tamanho`, `obs`) VALUES
(806, 41, 'df15ec8eabb40fb2f1ac0b5eb06459a5', 993117, '379', '18-10-2020', 1, '29.90', 1, 'N', 'Sem cebola'),
(807, 41, '7c40f075bea3515691048d93f31cc761', 486728, '379', '18-10-2020', 1, '29.90', 1, 'N', ''),
(808, 41, '423881df32fc82bf5f5544717e8db43e', 480017, '379', '18-10-2020', 1, '29.90', 1, 'N', ''),
(809, 41, 'd4706cbb6bc909da23dd35854cc4e288', 486728, '379', '18-10-2020', 1, '29.90', 1, 'N', ''),
(810, 41, '75f87e31b6ec1098fd155bbee5a6831e', 717972, '380', '18-10-2020', 1, '32.00', 1, 'N', 'Sem orégano'),
(811, 41, 'fa4b974b5b55b76d2ae968aa591fab8b', 122916, '381', '18-10-2020', 1, '25.90', 1, '50cm', 'Sem molho'),
(812, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, '384', '18-10-2020', 1, '19.90', 1, 'Copo 700ml', ''),
(813, 41, '02d5c1b3a31199de03fbeb4ebc3a7249', 339492, '379', '18-10-2020', 1, '29.90', 1, 'N', ''),
(814, 41, '137356ad075d9d728572809cecb6c5ed', 339492, '380', '18-10-2020', 1, '29.90', 1, 'N', ''),
(815, 41, '8a2b25307878860228eed216e5f1821a', 392173, '379', '18-10-2020', 1, '29.90', 1, 'N', ''),
(816, 41, '81b4c96ff6e4ad54198401fe454128a0', 392173, '380', '18-10-2020', 1, '29.90', 1, 'N', ''),
(817, 41, 'fc0c4a7cee7c3a7092236066cfa01b44', 265465, '379', '19-10-2020', 1, '29.90', 1, 'N', ''),
(818, 41, 'ba9cdd30cfd146a2db312b49737602de', 144402, '379', '19-10-2020', 0, '29.90', 1, 'N', ''),
(819, 41, 'f7eeab60635b27696a4870b54bdfdd80', 144402, '379', '19-10-2020', 0, '29.90', 1, 'N', ''),
(820, 42, '11155649940215563ad58f679c1786a4', 875296, '385', '19-10-2020', 1, '10.00', 1, 'N', ''),
(821, 42, 'b2cd99cbf8bb606090d6e7f503c5452b', 535287, '385', '19-10-2020', 1, '10.00', 1, 'N', ''),
(822, 41, '3113837a6f2138eb0627181a7e40c779', 321449, '384', '19-10-2020', 0, '9.00', 1, 'Copo 300ml', ''),
(823, 41, 'dbf95dac5399c0136055c0ec7bc9b04b', 690740, '382', '19-10-2020', 0, '15.00', 3, '500ml', ''),
(824, 41, 'b6de703b2833470456021c63a3aec597', 186534, '379', '19-10-2020', 0, '29.90', 1, 'N', ''),
(825, 41, 'd017f24c720a6a7390dd2198f7549f2f', 190860, '384', '19-10-2020', 0, '9.00', 1, 'Copo 300ml', ''),
(826, 41, '87549d24378621c6c6efb2e472fc7edd', 704402, '379', '19-10-2020', 1, '29.90', 1, 'N', ''),
(827, 41, '93eca260a232b76f73e4383ff19fce20', 190860, '383', '19-10-2020', 0, '5.00', 1, 'N', ''),
(828, 41, 'e8f958e8ec0d5c081ace3db40a123304', 268741, '379', '19-10-2020', 1, '29.90', 1, 'N', ''),
(829, 41, 'b7fb2ee8f052d3590f847efe66a8819e', 268741, '380', '19-10-2020', 1, '29.90', 1, 'N', ''),
(830, 41, '11bc53388d17ae2fad8c8d97d5f0cc49', 268741, '381', '19-10-2020', 1, '19.90', 1, '30cm', ''),
(831, 41, 'f2d06aacc81bdf6a58b06b1833e5dbd9', 268741, '383', '19-10-2020', 1, '5.00', 1, 'N', ''),
(832, 41, 'd1c0adf940508880ca76c330f8b00389', 268741, '384', '19-10-2020', 1, '13.00', 1, 'Copo 500ml', ''),
(833, 41, 'eb58820276a8722dec2a75fe5b1161a7', 427729, '380', '19-10-2020', 0, '27.00', 1, 'N', ''),
(834, 41, '0e032fbbdd38c93c65e2801eabe4905d', 236406, '384', '19-10-2020', 0, '9.00', 1, 'Copo 300ml', ''),
(835, 41, 'f080478899ab13b5f25da9c4dbd6b79b', 984135, '379', '20-10-2020', 1, '29.90', 1, 'N', ''),
(836, 41, '9d82f5f5b7c3d7fc4c1a25f91740c051', 689902, '387', '21-03-2021', 1, '18.00', 1, 'Porção Média', 'Destaque sem cebola'),
(837, 41, '1b978014d6d76d983346306b974d3cfe', 689902, '388', '21-03-2021', 1, '65.00', 1, 'N', ''),
(838, 41, '9e3139783abddeb03e6c8c905ab7e1e2', 993299, '392', '22-03-2021', 1, '22.00', 1, 'Grande', ''),
(839, 41, '0c86ea02798faec69324c843029dcada', 238136, '389', '22-03-2021', 1, '20.00', 1, 'N', ''),
(840, 41, '5cfd2397970751f3d0257d98da549373', 833896, '386', '22-03-2021', 1, '30.00', 1, 'N', ''),
(841, 41, '073db227e1370a3233c178b0f29847c0', 274424, '395', '22-03-2021', 1, '9.00', 2, 'N', ''),
(842, 41, 'e27bb4f8037c36fa8710799db346d2b4', 274424, '386', '22-03-2021', 1, '30.00', 1, 'N', ''),
(843, 41, '13bb01649e7aaa21ddbc68a59017d4fb', 473761, '392', '22-03-2021', 1, '22.00', 1, 'Grande', ''),
(844, 41, '3a023fd6d7b41ff12d9eceb3a0bdd28f', 454215, '386', '22-03-2021', 1, '30.00', 1, 'N', ''),
(845, 41, '8bd267370f557751fc71d481050c9bff', 303815, '387', '23-03-2021', 0, '22.00', 3, 'Porção Grande', ''),
(846, 41, 'ef1199814d5cfcb653e67c26497bdc37', 306540, '391', '23-03-2021', 1, '19.00', 1, 'N', ''),
(847, 41, '67f06278ef4999d8f21eae6a8ce4df63', 306540, '390', '23-03-2021', 1, '16.00', 1, 'N', '');

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

--
-- Estrutura para tabela `store_o`
--

CREATE TABLE `store_o` (
  `id` int(11) NOT NULL,
  `idu` int(10) NOT NULL,
  `idp` varchar(32) NOT NULL DEFAULT '0',
  `ids` int(30) NOT NULL,
  `nome` varchar(200) NOT NULL DEFAULT '',
  `status` int(11) NOT NULL DEFAULT 0,
  `valor` varchar(10) NOT NULL,
  `quantidade` varchar(5) NOT NULL,
  `meioameio` varchar(2) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `store_o`
--

INSERT INTO `store_o` (`id`, `idu`, `idp`, `ids`, `nome`, `status`, `valor`, `quantidade`, `meioameio`) VALUES
(1231, 41, 'df15ec8eabb40fb2f1ac0b5eb06459a5', 993117, 'Ao ponto para bem', 1, '0.00', '1', '0'),
(1232, 41, 'df15ec8eabb40fb2f1ac0b5eb06459a5', 993117, 'Molho chimichurri', 1, '3.50', '1', '0'),
(1233, 41, 'df15ec8eabb40fb2f1ac0b5eb06459a5', 993117, 'Molho escabeche', 1, '1.99', '1', '0'),
(1234, 41, '7c40f075bea3515691048d93f31cc761', 486728, 'Ponto Bleu (Selada)', 1, '1.00', '1', '0'),
(1235, 41, '7c40f075bea3515691048d93f31cc761', 486728, 'Molho barbecue', 1, '0.00', '1', '0'),
(1236, 41, '7c40f075bea3515691048d93f31cc761', 486728, 'Molho de Porto', 1, '0.00', '1', '0'),
(1237, 41, '423881df32fc82bf5f5544717e8db43e', 480017, 'Ponto Bleu (Selada)', 1, '1.00', '1', '0'),
(1238, 41, '423881df32fc82bf5f5544717e8db43e', 480017, 'Molho chimichurri', 1, '3.50', '1', '0'),
(1239, 41, '423881df32fc82bf5f5544717e8db43e', 480017, 'Molho escabeche', 1, '1.99', '1', '0'),
(1240, 41, 'd4706cbb6bc909da23dd35854cc4e288', 486728, 'Mal Passada', 1, '0.00', '1', '0'),
(1241, 41, 'd4706cbb6bc909da23dd35854cc4e288', 486728, 'Molho escabeche', 1, '1.99', '1', '0'),
(1242, 41, 'd4706cbb6bc909da23dd35854cc4e288', 486728, 'Molho agridoce', 1, '0.00', '1', '0'),
(1243, 41, '75f87e31b6ec1098fd155bbee5a6831e', 717972, 'Filé com Fritas', 1, '29.90', '1', '1'),
(1244, 41, '75f87e31b6ec1098fd155bbee5a6831e', 717972, 'Escarola', 1, '32.00', '1', '1'),
(1245, 41, '75f87e31b6ec1098fd155bbee5a6831e', 717972, 'Borda Doce com Nutela', 1, '2.50', '1', '0'),
(1246, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, 'Banana', 1, '0.00', '1', '0'),
(1247, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, 'Morango', 1, '0.00', '1', '0'),
(1248, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, 'Amendoim', 1, '0.00', '1', '0'),
(1249, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, 'Chocoball', 1, '0.00', '1', '0'),
(1250, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, 'Confete', 1, '0.00', '1', '0'),
(1251, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, 'Granola', 1, '0.00', '1', '0'),
(1252, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, 'Cobertura de Chocolate', 1, '0.00', '1', '0'),
(1253, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, 'Nutella', 1, '2.00', '1', '0'),
(1254, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, 'KitKat', 1, '2.00', '1', '0'),
(1255, 41, '0f4c8c012ae7137dd5cfeab634e115b6', 324784, 'Ouro Branco', 1, '2.00', '1', '0'),
(1256, 41, '02d5c1b3a31199de03fbeb4ebc3a7249', 339492, 'Ponto Bleu (Selada)', 1, '1.00', '1', '0'),
(1257, 41, '02d5c1b3a31199de03fbeb4ebc3a7249', 339492, 'Molho chimichurri', 1, '3.50', '1', '0'),
(1258, 41, '02d5c1b3a31199de03fbeb4ebc3a7249', 339492, 'Molho escabeche', 1, '1.99', '1', '0'),
(1259, 41, '137356ad075d9d728572809cecb6c5ed', 339492, 'Filé com Fritas', 1, '29.90', '1', '1'),
(1260, 41, '137356ad075d9d728572809cecb6c5ed', 339492, 'Calabresa', 1, '28.00', '1', '1'),
(1261, 41, '137356ad075d9d728572809cecb6c5ed', 339492, 'Borda com Catupiry', 1, '5.00', '1', '0'),
(1262, 41, '8a2b25307878860228eed216e5f1821a', 392173, 'Mal Passada', 1, '0.00', '1', '0'),
(1263, 41, '8a2b25307878860228eed216e5f1821a', 392173, 'Molho chimichurri', 1, '3.50', '1', '0'),
(1264, 41, '8a2b25307878860228eed216e5f1821a', 392173, 'Molho escabeche', 1, '1.99', '1', '0'),
(1265, 41, '81b4c96ff6e4ad54198401fe454128a0', 392173, 'Filé com Fritas', 1, '29.90', '1', '1'),
(1266, 41, '81b4c96ff6e4ad54198401fe454128a0', 392173, 'Calabresa', 1, '28.00', '1', '1'),
(1267, 41, '81b4c96ff6e4ad54198401fe454128a0', 392173, 'Borda Simples', 1, '0.00', '1', '0'),
(1268, 41, 'fc0c4a7cee7c3a7092236066cfa01b44', 265465, 'Ponto Bleu (Selada)', 1, '1.00', '1', '0'),
(1269, 41, 'fc0c4a7cee7c3a7092236066cfa01b44', 265465, 'Molho chimichurri', 1, '3.50', '1', '0'),
(1270, 41, 'fc0c4a7cee7c3a7092236066cfa01b44', 265465, 'Molho romesco', 1, '0.00', '1', '0'),
(1271, 41, 'ba9cdd30cfd146a2db312b49737602de', 144402, 'Ao ponto', 0, '0.00', '1', '0'),
(1272, 41, 'ba9cdd30cfd146a2db312b49737602de', 144402, 'Molho romesco', 0, '0.00', '1', '0'),
(1273, 41, 'f7eeab60635b27696a4870b54bdfdd80', 144402, 'Bem passada', 0, '0.00', '1', '0'),
(1274, 41, 'f7eeab60635b27696a4870b54bdfdd80', 144402, 'Molho agridoce', 0, '0.00', '1', '0'),
(1275, 41, '3113837a6f2138eb0627181a7e40c779', 321449, 'Banana', 0, '0.00', '1', '0'),
(1276, 41, '3113837a6f2138eb0627181a7e40c779', 321449, 'Manga', 0, '0.00', '1', '0'),
(1277, 41, '3113837a6f2138eb0627181a7e40c779', 321449, 'Confete', 0, '0.00', '1', '0'),
(1278, 41, '3113837a6f2138eb0627181a7e40c779', 321449, 'Granola', 0, '0.00', '1', '0'),
(1279, 41, '3113837a6f2138eb0627181a7e40c779', 321449, 'Leite em Pó', 0, '0.00', '1', '0'),
(1280, 41, '3113837a6f2138eb0627181a7e40c779', 321449, 'Cobertura de Morango', 0, '0.00', '1', '0'),
(1281, 41, '3113837a6f2138eb0627181a7e40c779', 321449, 'Nutella', 0, '2.00', '1', '0'),
(1282, 41, '3113837a6f2138eb0627181a7e40c779', 321449, 'KitKat', 0, '2.00', '1', '0'),
(1283, 41, '3113837a6f2138eb0627181a7e40c779', 321449, 'Sonho de Valsa', 0, '2.00', '1', '0'),
(1284, 41, '3113837a6f2138eb0627181a7e40c779', 321449, 'Ouro Branco', 0, '2.00', '1', '0'),
(1285, 41, 'b6de703b2833470456021c63a3aec597', 186534, 'Ponto Bleu (Selada)', 0, '1.00', '1', '0'),
(1286, 41, 'b6de703b2833470456021c63a3aec597', 186534, 'Molho chimichurri', 0, '3.50', '1', '0'),
(1287, 41, 'b6de703b2833470456021c63a3aec597', 186534, 'Molho escabeche', 0, '1.99', '1', '0'),
(1288, 41, 'd017f24c720a6a7390dd2198f7549f2f', 190860, 'Cobertura de Chocolate', 0, '0.00', '1', '0'),
(1289, 41, '87549d24378621c6c6efb2e472fc7edd', 704402, 'Ao Ponto Para Mal', 1, '0.00', '1', '0'),
(1290, 41, '87549d24378621c6c6efb2e472fc7edd', 704402, 'Molho chimichurri', 1, '3.50', '1', '0'),
(1291, 41, '87549d24378621c6c6efb2e472fc7edd', 704402, 'Molho escabeche', 1, '1.99', '1', '0'),
(1292, 41, 'e8f958e8ec0d5c081ace3db40a123304', 268741, 'Ao Ponto Para Mal', 1, '0.00', '1', '0'),
(1293, 41, 'e8f958e8ec0d5c081ace3db40a123304', 268741, 'Molho barbecue', 1, '0.00', '1', '0'),
(1294, 41, 'e8f958e8ec0d5c081ace3db40a123304', 268741, 'Molho de nozes', 1, '2.80', '1', '0'),
(1295, 41, 'b7fb2ee8f052d3590f847efe66a8819e', 268741, 'Filé com Fritas', 1, '29.90', '1', '1'),
(1296, 41, 'b7fb2ee8f052d3590f847efe66a8819e', 268741, 'Cinco Queijos', 1, '27.00', '1', '1'),
(1297, 41, 'b7fb2ee8f052d3590f847efe66a8819e', 268741, 'Borda com Catupiry', 1, '5.00', '1', '0'),
(1298, 41, 'd1c0adf940508880ca76c330f8b00389', 268741, 'Banana', 1, '0.00', '1', '0'),
(1299, 41, 'd1c0adf940508880ca76c330f8b00389', 268741, 'Morango', 1, '0.00', '1', '0'),
(1300, 41, 'd1c0adf940508880ca76c330f8b00389', 268741, 'Amendoim', 1, '0.00', '1', '0'),
(1301, 41, 'd1c0adf940508880ca76c330f8b00389', 268741, 'Confete', 1, '0.00', '1', '0'),
(1302, 41, 'd1c0adf940508880ca76c330f8b00389', 268741, 'Leite em Pó', 1, '0.00', '1', '0'),
(1303, 41, 'd1c0adf940508880ca76c330f8b00389', 268741, 'Paçoca', 1, '0.00', '1', '0'),
(1304, 41, 'd1c0adf940508880ca76c330f8b00389', 268741, 'Mel', 1, '0.00', '1', '0'),
(1305, 41, 'd1c0adf940508880ca76c330f8b00389', 268741, 'Nutella', 1, '2.00', '1', '0'),
(1306, 41, 'eb58820276a8722dec2a75fe5b1161a7', 427729, 'Alho e Óleo', 0, '25.00', '1', '1'),
(1307, 41, 'eb58820276a8722dec2a75fe5b1161a7', 427729, 'Cinco Queijos', 0, '27.00', '1', '1'),
(1308, 41, 'eb58820276a8722dec2a75fe5b1161a7', 427729, 'Borda Simples', 0, '0.00', '1', '0'),
(1309, 41, '0e032fbbdd38c93c65e2801eabe4905d', 236406, 'Maçã', 0, '0.00', '1', '0'),
(1310, 41, '0e032fbbdd38c93c65e2801eabe4905d', 236406, 'Leite em Pó', 0, '0.00', '1', '0'),
(1311, 41, '0e032fbbdd38c93c65e2801eabe4905d', 236406, 'Leite Condensado', 0, '0.00', '1', '0'),
(1312, 41, '0e032fbbdd38c93c65e2801eabe4905d', 236406, 'Nutella', 0, '2.00', '1', '0'),
(1313, 41, '0e032fbbdd38c93c65e2801eabe4905d', 236406, 'Sonho de Valsa', 0, '2.00', '1', '0'),
(1314, 41, 'f080478899ab13b5f25da9c4dbd6b79b', 984135, 'Ponto Bleu (Selada)', 1, '1.00', '1', '0'),
(1315, 41, 'f080478899ab13b5f25da9c4dbd6b79b', 984135, 'Molho chimichurri', 1, '3.50', '1', '0'),
(1316, 41, 'f080478899ab13b5f25da9c4dbd6b79b', 984135, 'Molho barbecue', 1, '0.00', '1', '0'),
(1317, 41, '9d82f5f5b7c3d7fc4c1a25f91740c051', 689902, 'Maionese Temperada', 1, '1', '1', '0'),
(1318, 41, '1b978014d6d76d983346306b974d3cfe', 689902, 'Molho Barbecue', 1, '2', '1', '0'),
(1319, 41, '9e3139783abddeb03e6c8c905ab7e1e2', 993299, 'Maionese Temperada', 1, '1', '1', '0'),
(1320, 41, '0c86ea02798faec69324c843029dcada', 238136, 'Molho Barbecue', 1, '2', '1', '0'),
(1321, 41, '5cfd2397970751f3d0257d98da549373', 833896, 'Maionese Temperada', 1, '1', '1', '0'),
(1322, 41, 'e27bb4f8037c36fa8710799db346d2b4', 274424, 'Maionese Temperada', 1, '1', '1', '0'),
(1323, 41, '13bb01649e7aaa21ddbc68a59017d4fb', 473761, 'Molho Barbecue', 1, '2', '1', '0'),
(1324, 41, '3a023fd6d7b41ff12d9eceb3a0bdd28f', 454215, 'Maionese Temperada', 1, '1', '1', '0'),
(1325, 41, '8bd267370f557751fc71d481050c9bff', 303815, 'Molho Barbecue', 0, '2', '3', '0'),
(1326, 41, '67f06278ef4999d8f21eae6a8ce4df63', 306540, 'Maionese Temperada', 1, '1', '1', '0');

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

--
-- Estrutura para tabela `tamanhos`
--

CREATE TABLE `tamanhos` (
  `id` int(11) NOT NULL,
  `idu` int(9) NOT NULL,
  `idp` int(9) NOT NULL,
  `descricao` varchar(30) NOT NULL,
  `valor` varchar(30) NOT NULL,
  `status` int(2) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `tamanhos`
--

INSERT INTO `tamanhos` (`id`, `idu`, `idp`, `descricao`, `valor`, `status`) VALUES
(64, 41, 387, 'Porção Pequena', '12.00', 1),
(65, 41, 387, 'Porção Média', '18.00', 1),
(66, 41, 387, 'Porção Grande', '22.00', 1),
(67, 41, 392, 'Brotinho', '14.00', 1),
(68, 41, 392, 'Grande', '22.00', 1),
(69, 41, 392, 'Família', '32.00', 1);

--
-- Índices para tabelas despejadas
--

--
-- Índices de tabela `adm`
--
ALTER TABLE `adm`
  ADD PRIMARY KEY (`Id`);

--
-- Índices de tabela `bairros`
--
ALTER TABLE `bairros`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `categorias`
--
ALTER TABLE `categorias`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `config`
--
ALTER TABLE `config`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `funcionarios`
--
ALTER TABLE `funcionarios`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `fundotopo`
--
ALTER TABLE `fundotopo`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `grupos`
--
ALTER TABLE `grupos`
  ADD PRIMARY KEY (`Id`);

--
-- Índices de tabela `limite_op`
--
ALTER TABLE `limite_op`
  ADD PRIMARY KEY (`Id`);

--
-- Índices de tabela `logo`
--
ALTER TABLE `logo`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `mesas`
--
ALTER TABLE `mesas`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `opcionais`
--
ALTER TABLE `opcionais`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `pedidos`
--
ALTER TABLE `pedidos`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `produtos`
--
ALTER TABLE `produtos`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `store`
--
ALTER TABLE `store`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `store_o`
--
ALTER TABLE `store_o`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `tamanhos`
--
ALTER TABLE `tamanhos`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT para tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `adm`
--
ALTER TABLE `adm`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `bairros`
--
ALTER TABLE `bairros`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=139;

--
-- AUTO_INCREMENT de tabela `banner`
--
ALTER TABLE `banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT de tabela `categorias`
--
ALTER TABLE `categorias`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;

--
-- AUTO_INCREMENT de tabela `config`
--
ALTER TABLE `config`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT de tabela `funcionarios`
--
ALTER TABLE `funcionarios`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT de tabela `fundotopo`
--
ALTER TABLE `fundotopo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT de tabela `grupos`
--
ALTER TABLE `grupos`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- AUTO_INCREMENT de tabela `limite_op`
--
ALTER TABLE `limite_op`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;

--
-- AUTO_INCREMENT de tabela `logo`
--
ALTER TABLE `logo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT de tabela `logs`
--
ALTER TABLE `logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT de tabela `mesas`
--
ALTER TABLE `mesas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT de tabela `opcionais`
--
ALTER TABLE `opcionais`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=382;

--
-- AUTO_INCREMENT de tabela `pedidos`
--
ALTER TABLE `pedidos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=259;

--
-- AUTO_INCREMENT de tabela `produtos`
--
ALTER TABLE `produtos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=397;

--
-- AUTO_INCREMENT de tabela `store`
--
ALTER TABLE `store`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=848;

--
-- AUTO_INCREMENT de tabela `store_o`
--
ALTER TABLE `store_o`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1327;

--
-- AUTO_INCREMENT de tabela `tamanhos`
--
ALTER TABLE `tamanhos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;
COMMIT;

