

CREATE TABLE `categoria` (
  `categoria_id` int(11) NOT NULL AUTO_INCREMENT,
  `categoria_nome` varchar(200) DEFAULT NULL,
  `categoria_pos` int(11) DEFAULT NULL,
  `categoria_meia` int(1) DEFAULT 0,
  `categoria_ordem` int(11) DEFAULT NULL,
  `categoria_ref` int(5) NOT NULL DEFAULT 0,
  `categoria_ativa` int(2) DEFAULT 1,
  PRIMARY KEY (`categoria_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categoria`
--

INSERT INTO `categoria` VALUES (1,'PIZZAS',1,3,1,255,1),(2,'ESFIHAS',4,0,4,0,1),(3,'REFRIGERANTES',6,0,6,0,1),(5,'CERVEJAS',7,0,7,0,1),(7,'BROTOS',4,1,3,0,1),(11,'PIZZA DOCE',3,1,2,0,1),(13,'ESFIHA DOCE',5,0,5,0,1),(16,'Pastéis',2,0,NULL,0,1),(17,'COMBOS',0,0,NULL,0,1),(18,'Lanches',0,1,NULL,0,1),(19,'Mexicano',0,1,NULL,0,1);

--
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `config_id` int(11) NOT NULL AUTO_INCREMENT,
  `config_nome` varchar(200) DEFAULT NULL,
  `config_foto` varchar(200) DEFAULT NULL,
  `config_desc` longtext DEFAULT NULL,
  `config_horario` varchar(200) DEFAULT NULL,
  `config_aberto` int(1) DEFAULT 1,
  `config_entrega` varchar(200) DEFAULT NULL,
  `config_taxa_entrega` double(10,2) DEFAULT NULL,
  `config_fone1` varchar(200) DEFAULT NULL,
  `config_fone2` varchar(200) DEFAULT NULL,
  `config_fone3` varchar(200) DEFAULT NULL,
  `config_endereco` varchar(255) DEFAULT NULL,
  `config_retirada` int(2) DEFAULT 1,
  `config_chat` text DEFAULT NULL,
  `config_color_bd` varchar(20) DEFAULT NULL,
  `config_color_bh` varchar(20) DEFAULT NULL,
  `config_color_cd` varchar(20) DEFAULT NULL,
  `config_color_ch` varchar(20) DEFAULT NULL,
  `config_color_bk` varchar(20) DEFAULT NULL,
  `config_color_top` varchar(20) DEFAULT '222222',
  `config_colors` varchar(2000) DEFAULT NULL,
  `config_foto_round` int(11) DEFAULT 50,
  `config_site_keywords` text DEFAULT NULL,
  `config_site_description` text DEFAULT NULL,
  `config_site_ga` text DEFAULT NULL,
  `config_cep` varchar(20) DEFAULT NULL,
  `config_cep_unico` int(1) NOT NULL DEFAULT 0,
  `config_resumo_whats` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`config_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `config`
--

INSERT INTO `config` VALUES (1,'Flux Delivery','flux-delivery-png_1589341890.png','PHP STAFF','17:00 às 22:00 hrs de Segunda a Domingo',1,'30-45 min',2.75,'(11) 99999-8888','(11) 0000-0000','(11) 6666-6666','Av: São Paulo Nº 1048 - Centro - SP',1,'','#b31919','#000000','#e85b2c','#f1eee9',NULL,'#1f1e1e','bd=b31919&bh=000000&cd=e85b2c&ch=f1eee9&bt=1f1e1e&br=10',10,'PHP STAFF','PHP STAFF','','11701-540',0,1);

--
-- Table structure for table `cupom`
--

CREATE TABLE `cupom` (
  `cupom_id` int(11) NOT NULL AUTO_INCREMENT,
  `cupom_nome` varchar(50) DEFAULT NULL,
  `cupom_validade` date DEFAULT NULL,
  `cupom_valor` double DEFAULT NULL,
  `cupom_percent` int(4) DEFAULT NULL,
  `cupom_tipo` int(11) DEFAULT 1 COMMENT '1 = valor\r\n 2 = percent',
  PRIMARY KEY (`cupom_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cupom`
--

INSERT INTO `cupom` VALUES (1,'FICAEMCASA','2020-06-19',5,NULL,1);

--
-- Table structure for table `endereco`
--

CREATE TABLE `endereco` (
  `endereco_id` int(11) NOT NULL AUTO_INCREMENT,
  `endereco_cliente` int(11) DEFAULT NULL,
  `endereco_endereco` varchar(200) DEFAULT NULL,
  `endereco_numero` varchar(200) DEFAULT NULL,
  `endereco_bairro` varchar(200) DEFAULT NULL,
  `endereco_cidade` varchar(200) DEFAULT NULL,
  `endereco_uf` varchar(200) DEFAULT NULL,
  `endereco_cep` varchar(200) DEFAULT NULL,
  `endereco_referencia` varchar(200) DEFAULT NULL,
  `endereco_nome` varchar(200) DEFAULT NULL,
  `endereco_complemento` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`endereco_id`)
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `endereco`
--

INSERT INTO `endereco` VALUES (118,10,'Avenida Bartolomeu de Gusmão','10','Boqueirão','Santos','SP','11045-400',NULL,'casa','ap 5'),(119,11,'Avenida São Paulo','100','Boqueirão','Praia Grande','SP','11701-380',NULL,'Casa',''),(122,11,'Avenida São Paulo','500','Boqueirão','Praia Grande','SP','11701-380',NULL,'office',''),(123,17,'Rua Flamengo','555','Vila Guilhermina','Praia Grande','SP','11701-540',NULL,'Minha Casa',''),(124,18,'Rua Flamengo','111','Vila Guilhermina','Praia Grande','SP','11701-540',NULL,'Minha Casa','');

--
-- Table structure for table `entrega`
--

CREATE TABLE `entrega` (
  `entrega_id` int(11) NOT NULL AUTO_INCREMENT,
  `entrega_inicio` varchar(10) DEFAULT NULL,
  `entrega_fim` varchar(10) DEFAULT NULL,
  `entrega_taxa` decimal(10,2) DEFAULT NULL,
  `entrega_nome` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`entrega_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `entrega`
--

INSERT INTO `entrega` VALUES (6,'09780340','09780340',5.00,'Sao bernardo'),(8,'09175360','09175900',2.00,'Vila Helena'),(9,'09132000','09171200',2.00,'Vila Luzita'),(10,'09121400','09195750',2.00,'Vila Pires'),(11,'09175000','09180970',2.00,'Vila Linda'),(12,'09172580','09172750',2.00,'Vila Junqueira'),(13,'09020170','09030700',3.00,'Vila Assunção'),(14,'09030160','09180971',2.00,'Vila Alzira'),(15,'09176000','09176220',2.00,'Vila Marina'),(16,'09010000','09210900',2.00,'Centro de Santo Andre'),(17,'09190040','09181725',3.00,'Jardim Paraíso'),(18,'09185360','09185400',2.00,'Vila Apiaí'),(19,'09040210','09041900',3.00,'Vila Bastos'),(20,'09050000','09051560',3.00,'Vila Floresta'),(21,'09190000','09190999',3.00,'Vila Gilda'),(22,'09172000','09175835',2.00,'Jardim do Estádio'),(23,'09120470','09181340',2.00,'Jardim Progresso'),(24,'09185090','09185235',2.00,'Jardim Cristiane'),(25,'09170080','09290970',3.00,'Vila João Ramalho'),(26,'09170510','09171480',3.00,'Jardim Guarará'),(29,'09172422','09175260',2.00,'Vila Vitória'),(31,'09110620','09121290',2.00,'Vila Humaitá'),(32,'09110410','09111345',3.00,'Vila Homero Thon'),(33,'09130470','09132280',3.00,'Vila Suiça'),(34,'09182000','09182380',3.00,'Jd  Las Vegas'),(35,'18120000','18120990',1.00,'Mairinque - SP'),(36,'11718255','11718255',3.00,'santos sp'),(37,'11045400','11718255',2.53,'Santos e PG');

--
-- Table structure for table `foto`
--

CREATE TABLE `foto` (
  `foto_id` int(11) NOT NULL AUTO_INCREMENT,
  `foto_url` varchar(200) DEFAULT NULL,
  `foto_chamado` int(5) DEFAULT NULL,
  `foto_item` varchar(200) DEFAULT NULL,
  `foto_cliente` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`foto_id`),
  KEY `fk_foto_chamado_idx` (`foto_chamado`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `foto`
--


--
-- Table structure for table `grupo`
--

CREATE TABLE `grupo` (
  `grupo_id` int(5) NOT NULL AUTO_INCREMENT,
  `grupo_nome` varchar(200) DEFAULT NULL,
  `grupo_desc` varchar(200) DEFAULT NULL,
  `grupo_tipo` int(5) DEFAULT 1,
  `grupo_pos` int(5) DEFAULT 999,
  PRIMARY KEY (`grupo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `grupo`
--

INSERT INTO `grupo` VALUES (1,'Massa','Massa Pizza',1,1),(2,'Bordas','Bordas Pizza',1,2),(3,'Molhos','Molhos Extras',2,3),(5,'Porções','Porções Pastel',2,0),(6,'Tamanho','Tamanho Pizza',1,0);

--
-- Table structure for table `item`
--

CREATE TABLE `item` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_categoria` int(11) DEFAULT NULL,
  `item_nome` varchar(200) DEFAULT NULL,
  `item_desc` longtext DEFAULT NULL,
  `item_foto` varchar(200) DEFAULT NULL,
  `item_obs` longtext DEFAULT NULL,
  `item_preco` double(10,2) DEFAULT NULL,
  `item_codigo` varchar(200) NOT NULL,
  `item_ativo` int(2) DEFAULT 1,
  `item_promo` int(11) DEFAULT 0,
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=763 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `item`
--

INSERT INTO `item` VALUES (17,1,'ALICHE','ALICHE,MUSSA,PARMESAO E TOMATE.','img-6941-6018-jpeg_1452020013.JPEG','',38.00,'3',0,0),(26,1,'BACON','<b>MUSSA E BACON</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,34.00,'12',1,1),(29,1,'BROCOLIS I','<b>BROCOLIS,CATU E ALHO</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,34.00,'15',1,1),(32,1,'5 QUEIJOS','<b>MUSSA,PROVOLONE,GORGONZOLA,CATU,PARMESAO.</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,42.00,'18',1,0),(33,1,'CALABRESA','<b>CALABRESA E CBL</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,28.00,'19',1,0),(39,1,'2 QUEIJOS','<b>MUSSARELA E CATUPIRY</b>','img-6941-6018-jpeg_1452020013.JPEG','<p><br></p>',33.32,'26',1,0),(42,1,'ESCAROLA','<b>ESCAROLA,CBL,MUSSA E BACON</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,32.00,'29',1,0),(46,1,'FRANGO CAIPIRA','<b>FRANGO,MILHO ERVILHA E MUSSA</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,35.00,'33',1,0),(66,1,'PALMITO','<b>PALMITO,MUSSA E RDLS DE TOMATE</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,36.00,'53',1,0),(67,1,'PALMITO CATUPIRY','<b>PALMITO E CATU</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,38.00,'54',1,0),(69,1,'4 QUEIJOS I','<b>MUSSA,PARMESAO,PROVOLONE,GORGONZOLA.</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,38.00,'56',1,0),(84,1,'BANANA','<b>BANANA,CANELA E LEITE CONDENSADO</b>','banana-jpg_1479554029.jpg','<p><br></p>',27.00,'71',1,0),(85,11,'BANANA CHOCOLATE','<b>BANANA,LEITE CONDENSADO E CHOCOLATE</b>','bananachocolate-jpg_1479553519.jpg','<p><br></p>',32.00,'72',1,0),(86,11,'ROMEU E JULIETA','<b>GOIABADA E MUSSA</b>','romeu-jpg_1479554329.jpg','<p><br></p>',28.00,'73',1,0),(87,11,'BRIGADEIRO','<b>CHOCOLATE,LEITE CONDENSADO,GRANULADO E CEREJAS</b>','brigadeiro-jpg_1479553989.jpg','<p><br></p>',35.00,'74',1,0),(95,1,'JABA I','<b>JABA,CBL E CATU</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,39.00,'82',1,0),(101,1,'CAIPIRA','<b>FRANGO,CALABRESA MOIDA,MUSSA E CBL</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,35.00,'89',1,0),(120,1,'PROVOLONE','<b>MOLHO E  PROVOLONE</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,36.00,'108',1,0),(127,1,'VENEZA','<b>PALMITO,MUSSA,PRESUNTO E CATU</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,36.00,'115',1,0),(128,11,'PRESTIGIO','<b>CHOCOLATE,COCO RALADO E LEITE CONDENSADO</b>','prestigio-jpg_1479554145.jpg','<p><br></p>',35.00,'116',1,0),(129,11,'SONHO DE VALSA','<b>CHOCOLATE E SONHO DE VALSA</b>','sonho-png_1479554204.png','<p><br></p>',35.00,'117',1,0),(130,1,'PEPERONI','<b>PEPERONI,CBL,MUSSA E RDLS DE TOMATE</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,40.00,'118',1,0),(131,13,'CHOCOLATE','','esfiha-doce-jpg_1479553083.jpg','',4.50,'200',1,0),(132,13,'BANANA','','esfiha-doce-jpg_1479553083.jpg','',3.50,'201',1,0),(133,13,'ROMEU &JULIETA','','esfiha-doce-jpg_1479553083.jpg','goiabada, queijo mussarela',3.50,'202',1,0),(134,2,'CARNE','','esfiras-png_1463265819.png','carne moídda',3.50,'203',1,0),(135,2,'CALABRESA','','esfiras-png_1463265819.png','calabresa',3.50,'204',1,0),(136,2,'QUEIJO','','esfiras-png_1463265819.png','queijo mussarela',3.50,'205',1,0),(137,2,'CATUPIRY','catupiry','esfiras-png_1463265819.png','',3.50,'206',1,0),(138,2,'ATUM c/ CATUPIRY','','esfiras-png_1463265819.png','atum, catupiry',4.50,'207',1,0),(139,2,'FRANGO c/ CATUPIRY','','esfiras-png_1463265819.png','frango, catupiry',4.50,'208',1,0),(140,2,'MILHO c/ CATUPIRY','','esfiras-png_1463265819.png','milho, catupiry',4.50,'209',1,0),(141,2,'PALMITO c/ CATUPIRY','','esfiras-png_1463265819.png','palmito, catupiry',4.50,'210',1,0),(142,2,'DOIS QUEIJOS','','esfiras-png_1463265819.png','mussarela, catupiry',4.50,'211',1,0),(143,2,'CALABRESA c/ CATUPIRY','','esfiras-png_1463265819.png','calabresa, catupiry',4.50,'212',1,0),(144,2,'BACON c/ QUEIJO','','esfiras-png_1463265819.png','bacon, mussarela',4.50,'213',1,0),(145,2,'PALMITO c/ QUEIJO','','esfiras-png_1463265819.png','palimito, mussarela',4.50,'214',1,0),(151,4,'PACOTE 220','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,50.00,'220',1,0),(152,13,'BANANA c/ CHOCOLATE','','esfiha-doce-jpg_1479553083.jpg','banana, chocolate',4.50,'221',1,0),(154,2,'CARNE c/ QUEIJO','','esfiras-png_1463265819.png','carne, mussarela',4.50,'223',1,0),(156,4,'PACOTE 230','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,53.00,'230',1,0),(157,4,'PACOTE 240','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,50.00,'240',1,0),(158,4,'PACOTE 250','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,50.00,'250',1,0),(160,3,'T N T ENERGETICO','<b><br></b>','tnt-png_1479551860.png','<p><br></p>',10.00,'270',1,0),(161,15,'SU FRESH','<b>SUCOS</b>','logo-pizzaria-jpg_1462540961.jpg',NULL,2.50,'271',1,0),(162,15,'SUCO NATURAL 450 ML','<b>SUCO NATURAL</b>','logo-pizzaria-jpg_1462540961.jpg',NULL,6.00,'272',1,0),(163,3,'COCA-COLA 2LT','<b><br></b>','coca-jpg_1479551773.jpg','<p><br></p>',10.00,'300',1,0),(164,3,'FANTA 2LT','<b><br></b>','fanta-png_1479551166.png','<p><br></p>',9.00,'301',1,0),(165,3,'GUARANA ANT','<b><br></b>','guarana-png_1479551205.png','<p><br></p>',9.00,'302',1,0),(166,3,'GUARANA DOLLY','<b><br></b>','dolly-png_1479551224.png','<p><br></p>',6.00,'303',1,0),(167,3,'COCA LIGHT 2 LT','<b><br></b>','untitled-png_1479551145.png','<p><br></p>',10.00,'304',1,0),(168,3,'SPRITE 2L','','sprite-png_1479551317.png','',9.00,'305',1,0),(169,10,'COCA LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'306',1,0),(170,10,'FANTA LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'307',1,0),(171,10,'GUARANA LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'308',1,0),(172,10,'COCA LIGHT LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'309',1,0),(173,10,'MINE COCA','<b>COCA</b>','lata-jpg_1463101088.jpg',NULL,2.00,'310',1,0),(174,5,'BRAHMA LATA','','brahama-png_1479552071.png','',5.00,'311',1,0),(176,5,'ITAIPAVA','','itaipava-png_1479552115.png','',5.00,'313',1,0),(177,3,'GUARANA ZERO','<b><br></b>','guaranalight-png_1479551288.png','<p><br></p>',9.00,'315',1,0),(178,3,'COCA ZERO','<b><br></b>','cocalight-png_1479551099.png','<p><br></p>',10.00,'316',1,0),(179,3,'REFRI 600 ML','<b><br></b>','600x600-png_1479551668.png','<p><br></p>',6.50,'317',1,0),(185,5,'SKOL LATA','<b><br></b>','skol2-png_1479552151.png','<p><br></p>',4.50,'406',1,0),(188,5,'BOHEMIA LATA','<b><br></b>','bohemia-jpg_1479552314.jpg','<p><br></p>',4.50,'409',1,0),(189,5,'BRAHMA ZERO ALCOOL','','semalcool-png_1479552508.png','',4.50,'410',1,0),(190,14,'CAIP RUM BACARDI','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,11.00,'411',1,0),(191,14,'CAIPIRINHA PINGA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,8.50,'412',1,0),(192,14,'CAIPPIRINHA DE SMIRNOFF','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,13.00,'413',1,0),(193,14,'CAIPIRINHA STEINHAEG','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,12.00,'414',1,0),(194,14,'CAIPIRINHA DE SAKE','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,13.00,'415',1,0),(195,14,'WHISKY OLD EIGHT','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,9.00,'416',1,0),(196,14,'WISKY PASSPORT','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,11.00,'417',1,0),(197,14,'WHISKY RED LABEL','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,15.00,'418',1,0),(198,14,'WHISKYJ JB','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,15.00,'419',1,0),(199,14,'DOMECQ','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,6.00,'420',1,0),(200,14,'DREHER','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,4.00,'421',1,0),(201,14,'CAMPARI','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,8.00,'422',1,0),(202,14,'CINAR','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,4.00,'423',1,0),(203,14,'MARTINI','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,5.00,'424',1,0),(204,14,'STEINHAEGER','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,8.00,'425',1,0),(205,14,'SMIRNOFF','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,8.00,'426',1,0),(206,14,'SAN REMY','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,6.00,'427',1,0),(207,14,'TEQUILA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,15.00,'428',1,0),(208,14,'AMARULA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,9.00,'429',1,0),(209,14,'SALINAS','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,6.00,'430',1,0),(210,14,'SELETA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,6.00,'431',1,0),(211,14,'BOAZINHA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,6.00,'432',1,0),(212,14,'NEGA FULO','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,6.00,'433',1,0),(213,14,'SAO FCO','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,4.00,'434',1,0),(214,14,'YPIOCA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,4.00,'435',1,0),(215,14,'SAGATIBA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,5.00,'436',1,0),(216,6,'VINHO ALMADEN','<b></b>','vinhos-jpg_1463266382.jpg',NULL,45.00,'437',1,0),(217,6,'VINHO MOLDONI','<b></b>','vinhos-jpg_1463266382.jpg',NULL,19.90,'438',1,0),(218,6,'VINHO CASAL GARCIA','<b></b>','vinhos-jpg_1463266382.jpg',NULL,32.00,'439',1,0),(219,6,'VINHO LIEB FRAMICH','<b></b>','vinhos-jpg_1463266382.jpg',NULL,28.00,'440',1,0),(220,6,'VINHO SALTON','<b></b>','vinhos-jpg_1463266382.jpg',NULL,32.00,'441',1,0),(221,15,'SUCO MARACUJA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,5.50,'442',1,0),(222,15,'SUCO LARANJA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,5.50,'443',1,0),(223,15,'SUCO ACEROLA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,5.50,'444',1,0),(224,15,'SUCO ABACAXI','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,5.50,'445',1,0),(225,15,'SUCO MORANGO','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,5.50,'446',1,0),(226,15,'SUCO MANGA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,5.50,'447',1,0),(227,15,'SUCO C LEITE','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,7.00,'448',1,0),(228,10,'COCA COLA LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'449',1,0),(229,10,'FANTA LARAJA LATA','<b><br></b>','lata-jpg_1463101088.jpg','<p><br></p>',4.50,'450',1,0),(230,10,'FANTA UVA LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'451',1,0),(231,10,'GUARANA LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'452',1,0),(232,10,'SODA LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'453',1,0),(233,10,'COCA ZERO LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'454',1,0),(234,10,'GUARANA ZERO LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'455',1,0),(235,10,'TONICA LATA','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'456',1,0),(236,10,'H2O','<b></b>','lata-jpg_1463101088.jpg',NULL,4.00,'457',1,0),(237,10,'AGUA','<b></b>','lata-jpg_1463101088.jpg',NULL,3.00,'458',1,0),(238,10,'AGUA COM GAS','<b></b>','lata-jpg_1463101088.jpg',NULL,4.00,'459',1,0),(239,15,'LARANJA C ACEROLA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,7.00,'460',1,0),(240,10,'REFRI C LIMAO E GELO','<b></b>','lata-jpg_1463101088.jpg',NULL,5.00,'461',1,0),(241,5,'MALZBIER LATA E LONG','<b><br></b>','malzibie-png_1479552244.png','<p><br></p>',4.00,'462',1,0),(242,3,'REFRIG 2L','<b><br></b>','refr-2l-png_1479551688.png','<p><br></p>',11.00,'463',1,0),(243,6,'JARRA DE VINHO','<b><br></b>','vinhos-jpg_1463266382.jpg','<p><br></p>',19.00,'464',1,0),(244,6,'MEIA JARRA DE VINHO','<b></b>','vinhos-jpg_1463266382.jpg',NULL,11.00,'465',1,0),(245,6,'TAÇA DE VINHO','<b></b>','vinhos-jpg_1463266382.jpg',NULL,4.00,'466',1,0),(246,12,'PORÇOES','<b>PORÇOES</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,12.00,'467',1,0),(247,6,'PINGA 51  E  V  BARREIRO','<b></b>','vinhos-jpg_1463266382.jpg',NULL,3.00,'468',1,0),(248,6,'VINHO DO FRADE','<b></b>','vinhos-jpg_1463266382.jpg',NULL,18.00,'469',1,0),(249,6,'VINHO DO FRADE','<b></b>','vinhos-jpg_1463266382.jpg',NULL,18.00,'470',1,0),(250,10,'SCHWEPPES CITRUS','<b></b>','lata-jpg_1463101088.jpg',NULL,4.50,'471',1,0),(252,14,'SMIRNOFF ICE','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,6.00,'473',1,0),(253,15,'SUCO NATURAL 1 L','<b>SUCOS</b>','logo-pizzaria-jpg_1462540961.jpg',NULL,10.00,'474',1,0),(254,8,'PRODUTO EXTRA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,3.00,'500',1,0),(255,8,'DISCO DE PIZZA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,3.00,'501',1,0),(256,8,'BORDA DE CHEDDAR','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,3.00,'502',1,0),(257,9,'ENTREGA','<b></b>','logo-pizzaria-jpg_1462540961.jpg',NULL,2.00,'503',1,0),(259,3,'FANTA UVA','<b><br></b>','fantauva-png_1479551181.png','<p><br></p>',9.00,'507',1,0),(260,7,'ATUM','','img-6941-6018-jpeg_1452020013.JPEG','ATUM E CEBOLA',22.00,'601',1,0),(261,7,'ALHO','','img-6941-6018-jpeg_1452020013.JPEG','ALHO FRITO E MUSSARELA',20.00,'602',1,0),(262,7,'ALICHE','','img-6941-6018-jpeg_1452020013.JPEG','ALICHE,MUSSA,TOMATE E PARMESAO',23.00,'603',1,0),(268,7,'Baiana','','img-6941-6018-jpeg_1452020013.JPEG','CALABRESA MOIDA,PIMENTA,OVOS E CALABRESA',19.00,'609',1,0),(271,7,'BACON','','img-6941-6018-jpeg_1452020013.JPEG','MUSSARELA E BACON',22.00,'612',1,0),(272,7,'BOLOGNHESA','','img-6941-6018-jpeg_1452020013.JPEG','CARNE MOÍDA  E MUSSARELA',22.00,'613',1,0),(274,7,'BROCOLIS I','','img-6941-6018-jpeg_1452020013.JPEG','BROCOLIS, CATUPIRY E ALHO',22.00,'615',1,0),(276,7,'CATUPIRY','','img-6941-6018-jpeg_1452020013.JPEG','MOLHO DE TOMATE E CATUPIRY',20.00,'617',1,0),(277,7,'5 QUEIJOS','','img-6941-6018-jpeg_1452020013.JPEG','MUSSARELA, PROVOLONE, GORGONZOLA, CATUPIRY E PARMESAO',25.00,'618',1,0),(282,7,'CHAMPIGNON','','img-6941-6018-jpeg_1452020013.JPEG','CHAMPIGNON e MUSSARELA',22.00,'623',1,0),(284,7,'2 QUEIJOS','','img-6941-6018-jpeg_1452020013.JPEG','MUSSARELA e CATUPIRY',21.00,'626',1,0),(287,7,'ESCAROLA','','img-6941-6018-jpeg_1452020013.JPEG','ESCAROLA, MUSSARELA E  BACON',21.00,'629',1,0),(329,12,'BTO BANANA.DOCE','<b>BANANA,CANELA E LEITE CONDENSADO</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,17.00,'671',1,0),(330,12,'BTO BANANA CHOCOLAT','<b>BANANA,LEITE CONDENSADO E CHOCOLATE</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,18.00,'672',1,0),(331,12,'BTO ROMEU E JULIETA','<b>GOIABADA E MUSSA</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,18.00,'673',1,0),(332,12,'BTO BRIGADEIRO','<b>CHOCOLATE,LEITE CONDENSADO,GRANULADO E CEREJA</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,22.00,'674',1,0),(372,12,'BTO PRESTIGIO','<b>CHOCOLATE,COCOC RALADO E LEITE CONDENSADO</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,22.00,'716',1,0),(373,12,'BTO SONHO DE VALSA','<b>CHOCOLATE E BOMBONS SONHO DE VALSA</b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,22.00,'717',1,0),(376,15,'SUCO DE UVA SAN MARTIN','<b>SUCO</b>','logo-pizzaria-jpg_1462540961.jpg',NULL,22.00,'748',1,0),(377,6,'VINHO','<b></b>','vinhos-jpg_1463266382.jpg',NULL,17.00,'750',1,0),(378,6,'VINHO SAN MARTIN','<b>VINHO</b>','vinhos-jpg_1463266382.jpg',NULL,22.00,'751',1,0),(380,15,'LIMAO E GELO','<b>LIMAO E GELO</b>','logo-pizzaria-jpg_1462540961.jpg',NULL,1.00,'753',1,0),(381,14,'CAIPIRINHA MINEIRA','<b>CAIPIRINHA</b>','logo-pizzaria-jpg_1462540961.jpg',NULL,11.50,'754',1,0),(384,1,'ALHO','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,34.00,'1002',1,0),(393,1,'BAURU','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,34.00,'1011',1,0),(395,1,'BOLOGNESA I','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,36.00,'1013',1,0),(399,1,'CATUPIRY','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,34.00,'1017',1,0),(405,1,'CHAMPIGNOM','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,35.00,'1023',1,0),(420,1,'AMERICANA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,36.00,'1039',1,0),(422,1,'LOMBO I','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,36.00,'1041',1,0),(424,1,'MUSSARELA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,29.00,'1043',1,0),(428,1,'NAPOLITANA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,35.00,'1047',1,0),(430,1,'PERUANA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,38.00,'1049',1,0),(431,1,'PORTUGUESA I','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,37.00,'1050',1,0),(441,1,'RUCULA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,37.00,'1060',1,0),(444,1,'TOSCANA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,36.00,'1063',1,0),(446,1,'VEGETARIANA I','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,37.00,'1065',1,0),(452,11,'BANANA','<b><br></b>','banana-jpg_1479554049.jpg','<p><br></p>',30.00,'1071',1,0),(457,1,'MINEIRA I','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,36.00,'1076',1,0),(461,1,'PRIMAVERA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,38.00,'1080',1,0),(470,1,'ROMANA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,37.00,'1090',1,0),(483,1,'Natural','','img-6941-6018-jpeg_1452020013.JPEG','mussarela de bufala, oregano, tomate',37.00,'1103',1,0),(485,1,'Pizza Baiana','','img-6941-6018-jpeg_1452020013.JPEG','Mussarela, Calabresa, Pimenta, Molho de Tomate, Orégano e Azeitonas.',35.00,'1105',1,0),(569,12,'BTO BANANA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,19.00,'2071',1,0),(570,12,'BTO BANANA COM CHOCOLATE','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,21.00,'2072',1,0),(571,12,'BTO ROMEU E JULIETA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,21.00,'2073',1,0),(572,12,'BTO BRIGADEIRO','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,22.00,'2074',1,0),(613,12,'BTO PRESTIGIO','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,22.00,'2116',1,0),(614,12,'BTO SONHO DE VALSA','<b></b>','img-6941-6018-jpeg_1452020013.JPEG',NULL,24.00,'2117',1,0),(616,13,'BRIGADEIRO','','esfiha-doce-jpg_1479553083.jpg','chocolate, granulado',4.90,'2200',1,0),(617,13,'BEIJINHO','','esfiha-doce-jpg_1479553083.jpg','coco, leite condensado',3.90,'2201',1,0),(626,2,'PALMITO c/ CATUPIRY','','esfiras-png_1463265819.png','milho, catupiry',4.90,'2210',1,0),(639,2,'FRANGO','','esfiras-png_1463265819.png','frango desfiado',3.90,'2224',1,0),(716,4,'ACAI DE 500ML','<b></b>','logo-pizzaria-jpg_1462540961.jpg','',11.00,'226',1,0),(738,4,'COMBO ESFIHAS 1','<b>5CARNE,5 QUEIJO,5 CALABRESA,5 CATUPIRY</b>','logo-pizzaria-jpg_1462540961.jpg','5CARNE,5 QUEIJO,5 CALABRESA,5 CATUPIRY',42.00,'338',1,0),(739,4,'COMBO ESFIHAS 2','<b>5 CARNE,5 QUEIJO,5 BAURU,5 ATUM</b>','logo-pizzaria-jpg_1462540961.jpg','5 CARNE,5 QUEIJO,5 BAURU,5 ATUM',45.00,'339',1,0),(740,4,'COMBO ESFIHAS 3','<b>5CARNE,5QUEIJO,5 CALABRESA,5 PALMITO</b>','logo-pizzaria-jpg_1462540961.jpg','5CARNE,5QUEIJO,5 CALABRESA,5 PALMITO',44.00,'340',1,0),(741,4,'COMBO ESFIHAS 4','<b>5 CARNE,5 QUEIJO,5 CALABRESA, 5 BAURU</b>','logo-pizzaria-jpg_1462540961.jpg','5 CARNE,5 QUEIJO,5 CALABRESA, 5 BAURU',46.00,'341',1,0),(742,4,'COMBO ESFIHAS 5','<b>5CARNE,5 QUEIJO,5 CALABRESA,5 FRANGO C/CATUPIRY</b>','logo-pizzaria-jpg_1462540961.jpg','5CARNE,5 QUEIJO,5 CALABRESA,5 FRANGO C/CATUPIRY',45.00,'342',1,0),(743,4,'COMBO ESFIHAS 6','<b>5 CARNE,5 CALABRESA,5 CATUPIRY,ESCAROLA C CATUPIRY</b>','logo-pizzaria-jpg_1462540961.jpg','5 CARNE,5 CALABRESA,5 CATUPIRY,ESCAROLA C CATUPIRY',46.00,'343',1,0),(744,4,'COMBO ESFIHAS 7','<b>5 CARNE,5 QUEIJO,5CATUPIRY,5 ATUM</b>','logo-pizzaria-jpg_1462540961.jpg','5 CARNE,5 QUEIJO,5CATUPIRY,5 ATUM',45.00,'344',1,0),(745,4,'COMBO ESFIHAS 8','<b>5 ATUM,5 ESCAROLA,5 FRANGO,5 PALMITO</b>','logo-pizzaria-jpg_1462540961.jpg','5 ATUM,5 ESCAROLA,5 FRANGO,5 PALMITO',47.00,'345',1,0),(748,15,'DEL VALLE UVA 1 LT','<b></b>','logo-pizzaria-jpg_1462540961.jpg','',9.00,'508',1,0),(756,16,'Queijo','','images-jpeg_1585613376.jpeg','massa de pastel, queijo',8.00,'p002',1,0),(757,16,'Calabresa c/ Queijo','','images-jpeg_1585613629.jpeg','calabresa, queijo mussarela',8.30,'p003',1,0),(758,16,'Palmito','','images-jpeg_1585613849.jpeg','palmito, queijo mussarela e azeitonas',9.00,'005',1,0),(759,18,'Hamburguer','','a-jpg_1590764286.jpg','Pão de gergelim, açface, tomate e carne bovina',10.00,'',1,0),(760,18,'LANCHE ARTESANAL','','a-jpg_1590762942.jpg','PÃO, BIFE ARTESANAL, QUEIJO, BACON, SALADA E MOLHO ESPECIAL',18.50,'',1,0),(761,19,'Tacos','','t-jpg_1590762759.jpg','mussarela, acabate, tomate, pimentão',15.00,'',1,0),(762,19,'Burrito','','b-jpg_1590762807.jpg','frango, cebola, feijão vermelho,',21.00,'',1,0);

--
-- Table structure for table `opcao`
--

CREATE TABLE `opcao` (
  `opcao_id` int(11) NOT NULL AUTO_INCREMENT,
  `opcao_grupo` int(11) DEFAULT NULL,
  `opcao_nome` varchar(200) DEFAULT NULL,
  `opcao_desc` longtext DEFAULT NULL,
  `opcao_preco` double(10,2) DEFAULT NULL,
  `opcao_status` int(1) DEFAULT 1,
  PRIMARY KEY (`opcao_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `opcao`
--

INSERT INTO `opcao` VALUES (3,2,'Borda Recheada','asadasda',1.00,0),(4,2,'Borda Catupry','',3.00,1),(5,2,'Borda Vulcão','',5.00,1),(6,2,'Borda Coxinha','',10.00,0),(7,2,'Borda Tradicional','',0.00,1),(8,1,'Massa Tradicional',NULL,0.00,1),(9,1,'Massa Integral',NULL,5.75,1),(10,1,'Massa Folhada',NULL,6.99,1),(11,3,'Maionese',NULL,1.99,1),(12,3,'Catchup',NULL,1.20,1),(14,3,'Barbecue',NULL,1.50,1),(15,3,'Shoyo',NULL,1.00,1),(16,5,'Salada Extra',NULL,1.00,1),(17,5,'Molho Especial',NULL,1.50,1),(18,6,'Pequena',NULL,0.00,1),(19,6,'Média',NULL,10.00,1),(20,6,'Grande',NULL,20.00,1);

--
-- Table structure for table `pedido`
--

CREATE TABLE `pedido` (
  `pedido_id` int(11) NOT NULL AUTO_INCREMENT,
  `pedido_data` datetime DEFAULT NULL,
  `pedido_cliente` int(11) DEFAULT NULL,
  `pedido_local` int(11) unsigned zerofill DEFAULT NULL,
  `pedido_status` int(11) DEFAULT 1,
  `pedido_obs` text DEFAULT NULL,
  `pedido_desconto` decimal(10,2) DEFAULT NULL,
  `pedido_total` decimal(10,2) DEFAULT NULL,
  `pedido_entrega` decimal(10,2) DEFAULT NULL,
  `pedido_entrega_prazo` varchar(200) DEFAULT NULL,
  `pedido_entegrador` int(11) DEFAULT 0,
  `pedido_obs_pagto` varchar(200) DEFAULT NULL,
  `pedido_url_code` varchar(255) DEFAULT NULL,
  `pedido_pedidourl` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pedido_id`)
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pedido`
--


--
-- Table structure for table `pedido_lista`
--

CREATE TABLE `pedido_lista` (
  `lista_id` int(11) NOT NULL AUTO_INCREMENT,
  `lista_pedido` int(11) DEFAULT NULL,
  `lista_item` int(11) DEFAULT NULL,
  `lista_item_nome` varchar(500) DEFAULT NULL,
  `lista_item_preco` double(10,2) DEFAULT NULL,
  `lista_opcao` int(11) DEFAULT NULL,
  `lista_opcao_preco` double(10,2) DEFAULT NULL,
  `lista_opcao_nome` varchar(200) DEFAULT NULL,
  `lista_info` varchar(500) DEFAULT NULL,
  `lista_qtde` int(3) DEFAULT NULL,
  `lista_item_desc` text DEFAULT NULL,
  `lista_item_obs` text DEFAULT NULL,
  `lista_item_codigo` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`lista_id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pedido_lista`
--


--
-- Table structure for table `relprod`
--

CREATE TABLE `relprod` (
  `relprod_id` int(11) NOT NULL AUTO_INCREMENT,
  `relprod_grupo` int(5) DEFAULT NULL,
  `relprod_categoria` int(5) DEFAULT NULL,
  `relprod_status` int(1) DEFAULT 0,
  `relprod_pos` int(3) DEFAULT 0,
  PRIMARY KEY (`relprod_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `relprod`
--

INSERT INTO `relprod` VALUES (2,2,1,0,2),(3,1,1,0,1),(6,1,7,0,1),(7,1,13,0,1),(9,5,16,0,1),(11,6,1,0,0);


