-- MySQL dump 10.13  Distrib 8.0.33, for Win64 (x86_64)
--
-- Host: localhost    Database: fidelidade_ivone_cabelo_cia
-- ------------------------------------------------------
-- Server version	8.0.33

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `cliente`
--

DROP TABLE IF EXISTS `cliente`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cliente` (
  `CODIGO_CLIENTE` int NOT NULL,
  `NOME` varchar(45) NOT NULL,
  `TELEFONE` varchar(45) DEFAULT NULL,
  `PONTOS` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '0',
  `DATA_RESGATE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`CODIGO_CLIENTE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cliente`
--

LOCK TABLES `cliente` WRITE;
/*!40000 ALTER TABLE `cliente` DISABLE KEYS */;
INSERT INTO `cliente` VALUES (3,'Cecilia Muta',NULL,'5',NULL),(99,'Fernanda Souza Ribeiro',NULL,'1',NULL),(107,'Alessandra Worm',NULL,'1',NULL),(156,'Mary Freire',NULL,'2',NULL),(189,'Ana Beatriz Dias','63992370947','5',''),(232,'Jardeth Mª R. Casimiro Prado','63984115724','-1','13/09/2023'),(245,'Leia Ayres Cavalcante',NULL,'1',NULL),(254,'Gina Leite Goubart',NULL,'1',NULL),(259,'Rogeria Bertoli C.',NULL,'5',NULL),(267,'Alessandra F. Bragança','63992273555','-10','04/08/2023'),(273,'Debora Regina H. Galan','63984032810','5',''),(314,'Elizângela Rodrigues Fernandes Luz','63999479225','3',''),(351,'Denise Dias de Santana',NULL,'11',NULL),(391,'Alessandra de Fatima Soares (amiga Lorena)','63981210912','6',NULL),(397,'Eloa Hegele','63984041170','2','12/03/2024'),(423,'Anna Paula A. M. Falcão Coelho','63999121906','4',NULL),(441,'Geisa  Leite',NULL,'2',NULL),(490,'Monica Soa Martins','63999733443','-1','07/10/2023'),(531,'Edna Agnolin',NULL,'5',NULL),(596,'Jordana O. Rocha (mãe Valentina)',NULL,'7',NULL),(606,'Maria Ines Zago Garcia',NULL,'2',NULL),(619,'Luiza Paula Fernandes','63999859100','3',''),(622,'Naima   Worm',NULL,'9',NULL),(634,'Kelma Lima Souza Rodrigues','63999965052','3',''),(649,'Monica Teles Camargo','6332154302','0','29/01/2024'),(661,'Maria Tereza Lemes Moreira','63984575602','8',NULL),(695,'Gisele Bertollo',NULL,'1',NULL),(754,'Maria de Lurdes [lurdinha]',NULL,'9',NULL),(763,'Anna Paula Falcao','63999121906','0','05/07/2023'),(824,'Adriana Puertas Zago (bombom)',NULL,'7',NULL),(863,'Ednalva Fidelis de Brito Valadares',NULL,'10',NULL),(869,'Clara Maria Veloso Neves','63992270416','1',''),(1000,'Kleber Cardoso','63992927110','1','28/07/2023'),(1004,'Beatriz Militao O. Gagliardi','63984817462','2',''),(1046,'Sueli  Moreto',NULL,'18',NULL),(1261,'Francielly   Alcanfor',NULL,'2',NULL),(1330,'Marina Bragança [filha da Alessandra]',NULL,'0',NULL),(1393,'Natalia Ferraciolle Correa',NULL,'1',NULL),(1419,'Nubia Zago Garcia[filha da Ines]',NULL,'1',NULL),(1455,'Cleria Rezende Silveira','63981014347','1',''),(1487,'Camilla Martins Malta',NULL,'0',NULL),(1542,'Eliene Batista de Sousa',NULL,'3',''),(1850,'Irenilde Batista de Oliveira Neto','63981027452','4','06/11/2023'),(1872,'Maria das Graças ( Gracy )',NULL,'1',NULL),(1891,'Jielly Cafe',NULL,'5',NULL),(1922,'Flávia Almeida Valadares','63999765094','6',NULL),(2022,'Talyanna F. Antunes',NULL,'2',NULL),(2037,'Mônica Aparecida da Rocha Silva','63999716166','5',''),(2201,'Rita de Cássia',NULL,'1',NULL),(2327,'Cinthya Iaccino','63999551277','1',NULL),(2418,'Amanda Carvalho Cavalcante','63985110364','0',''),(2499,'Elizangela Gomes Medeiro (filha Rosa)',NULL,'5',NULL),(2565,'Solange Costa',NULL,'6',NULL),(2617,'Carolina Tedecos Azevedo',NULL,'0',NULL),(2642,'Patricia Martins Santos Aires',NULL,'1',NULL),(2725,'Milza Sonia','63992113565','-4','29/07/2023'),(2759,'Eliene Bandeira Barros Fragoso','63992040852','3','01/08/2023'),(2788,'Janaina Santo Amori de Carvalho',NULL,'1',NULL),(2881,'Elenir Schelive',NULL,'4',NULL),(2992,'Gabriella Cristine Novak','63992313333','-4','11/10/2023'),(2995,'Ivone de Oliveira Dias Costa',NULL,'0',''),(3179,'Ivanildes Ferreira Lopes',NULL,'1',NULL),(3411,'Flavia Mendes Ribeiro',NULL,'2',NULL),(3415,'Jaqueline Assakawa Ludgero','63992000909','6',''),(3429,'Egrimarcia',NULL,'4',NULL),(3473,'Rejane Haefliger','63981216769','2',''),(3504,'Fernanda Sena',NULL,'8',NULL),(3526,'Rita Helena Galdiolly Paes','63992277304','3',''),(3535,'Aline Gonçalves França','63984135838','2',''),(3661,'Fabyana Candido Teles (esposa do Vinicim)',NULL,'1',NULL),(3814,'Marta Bernardes Moreira',NULL,'9',NULL),(3861,'Lariane Azevedo',NULL,'1',NULL),(3880,'Rafaela Rocha','63999392096','4',''),(3905,'Ana Beatriz Bandeira Fragoso(filha Eliene)',NULL,'2',NULL),(3920,'Mariane Jordão','6332133006','0',''),(4031,'Luciana Ribeiro Cançado',NULL,'0',NULL),(4050,'Poliana(noiva)',NULL,'6',NULL),(4224,'Suely S P Silva',NULL,'5',NULL),(4247,'Denise Maria Cabral Martins',NULL,'6',NULL),(4297,'Kamila Gomes',NULL,'0',NULL),(4369,'Sabrina Assakawa Ludgero(noiva)',NULL,'6',NULL),(4477,'Marta Moreira Soares',NULL,'0',''),(4538,'Nadia Cristina Araujo. ',NULL,'4',NULL),(4687,'Naiuzy Leite',NULL,'4',NULL),(4692,'Simone BARBOSA SILVEIRA',NULL,'7',NULL),(4759,'Leticia Vieira',NULL,'5',NULL),(4784,'Claudia Dourado',NULL,'0',NULL),(4786,'Milena Dourado Guimaraes',NULL,'7',NULL),(4801,'Pollyana Mota Prates',NULL,'2',NULL),(5028,'Maria Das Dores Lustosa Da Siva( Tov )',NULL,'0',NULL),(5156,'Amelia Maria',NULL,'15',NULL),(5263,'Vitoria Espintula',NULL,'0',NULL),(5277,'Andreia Souza',NULL,'3',NULL),(5327,'Mary Fregonesi','63981105911','3','05/03/2024'),(5362,'Pamela Patricia','66996692157','9',''),(5375,'Marcia Cavalcante',NULL,'5','02/02/2024'),(5424,'Ione',NULL,'1',NULL),(5585,'Estela',NULL,'3',NULL),(5612,'Euliana',NULL,'7',NULL),(5658,'Carolina Malta',NULL,'10',NULL),(5674,'Ana Lucia',NULL,'1',NULL),(5741,'Carolina Raquel Galan',NULL,'1',NULL),(5746,'Romenia Lagare',NULL,'1',NULL),(5778,'Vera Lucia Azevedo',NULL,'3',NULL),(5840,'Marcia Noleto',NULL,'0',NULL),(5877,'Anabelle R. Bandeira','63981042021','14',NULL),(5907,'Larissa Urzedo','62999508183','4',''),(5908,'Welita Cordeiro de Freitas',NULL,'2',NULL),(5972,'Tatiane Alves',NULL,'3',NULL),(6073,'Leomara Lopes Martins(amiga da Fabiana)',NULL,'1',NULL),(6142,'Lucymara Pereira Lima','63984428614','1',''),(6275,'Lorena Marques Almeida',NULL,'3',NULL),(6322,'Maria do Socorro Moreira Borges Toledo','63984814936','-5','26/10/2023'),(6347,'Marta',NULL,'1',NULL),(6452,'Maria Andressa Ortega ( Mae da Ligia Ortega)',NULL,'6',NULL),(6579,'Juliana Rodrigues (filha da Maria Salma)',NULL,'0',NULL),(6595,'Rosangela Coutinho',NULL,'0',NULL),(6695,'Karine',NULL,'8',NULL),(6740,'Anisia Batista Alves',NULL,'1',NULL),(6788,'Anielle Souza Pereira','63984536080','4','08/08/2023'),(6876,'Virlene Queiroz Torres',NULL,'0',NULL),(7009,'Amelia Dantas',NULL,'4',NULL),(7026,'Neila Wollmann','63992234024','4','04/08/2023'),(7064,'Francielly Moreira da Silva Martins',NULL,'6',NULL),(7105,'Luciana Santos Monturil','63992216514','-3','03/10/2023'),(7278,'Sueli (mae da Maria Tereza Lemos)',NULL,'1',NULL),(7317,'Jacquelinne Bete',NULL,'2',NULL),(7342,'Sueli',NULL,'15',NULL),(7409,'Thelma Couto ( Tia Alessandra De Fatima)',NULL,'6',NULL),(7445,'Fernanda',NULL,'1',NULL),(7481,'Carla Pereira Gomes Pinheiro Majully',NULL,'1',NULL),(7505,'Michele Araujo  ( Amiga Do Kleber)','63985014424','22',NULL),(7528,'Cyntia Regina Barnabé',NULL,'2',NULL),(7555,'Suzi Pedal',NULL,'1',NULL),(7564,'Roseli Bitzcof de Moura',NULL,'3',NULL),(7616,'Lara Ferreira Galvão Melo','63999911896','1',''),(7670,'Eflavia',NULL,'0',''),(7733,'Kamila De Oliveira Lotze','63984969942','3',''),(7766,'Araida Dias Pereira',NULL,'7',NULL),(7828,'Narranny Silva Martins',NULL,'0',NULL),(7834,'Janaina Fogaça','63985110197','4','25/01/2024'),(7851,'Ana Lucia Coelho',NULL,'1',NULL),(7871,'Geralda De Sousa Pacheco',NULL,'3',NULL),(7884,'Lais',NULL,'0',NULL),(7901,'Caroline Calaça  Maus','63984060154','2',''),(7911,'Zizeuda Almeida da Silva',NULL,'18',NULL),(7916,'Luzia (mae da Ludne)',NULL,'2',NULL),(8021,'Maria Dalva',NULL,'1',''),(8134,'Suely Ferreira',NULL,'5',NULL),(8147,'Selma Soledade',NULL,'3',NULL),(8149,'Elisabete Antonia Poznicov',NULL,'0',NULL),(8156,'Divina Aparecida Santana',NULL,'2',NULL),(8212,'Gleysi Cardoso Duarte Muller','63981132886','8','28/06/2023'),(8216,'Ilian Maria Pinheiro Nolasco',NULL,'4',NULL),(8287,'Fernanda Gouveia','63984797323','0',''),(8312,'Ana Carolina Matte','63981041232','9',''),(8517,'Leidiane Abalem','63981212071','2','20/11/2023'),(8521,'Aparecida Kristênia','63984449621','0','26/02/2024'),(8559,'Nara Cristiane Lopes Vasconos Barbosa','63992694000','3',''),(8652,'Eldice Aires',NULL,'3',NULL),(8802,'Lucia de Fatima Pinhal Caland',NULL,'0',NULL),(8863,'Damiana Rosena de Lima',NULL,'2',NULL),(8954,'Patricia Tavares',NULL,'0',''),(8988,'Silvana N. Galante Santos ( Igreja)','63984480323','8',NULL),(9007,'Pollyana Gomes De Souza Pimenta','63992530147','13',''),(9010,'Raquelina Maria Das Dores Nunes',NULL,'0',NULL),(9147,'Amelia Lima (mel)',NULL,'2',NULL),(9163,'Maria de Fatima Rodrigues da Silva',NULL,'2',NULL),(9226,'Adla Quinta Fayad',NULL,'4',NULL),(9244,'Sarah Gellonne',NULL,'1',NULL),(9362,'Nelma Souza Mota','63984753283','2','29/01/2024'),(9374,'Regina Ferreira Rodrigues','63984660120','6','05/12/2023'),(9392,'Raiany Batista De Sousa',NULL,'3',NULL),(9394,'Yasmin Oliveira (filha Da Caroline Terezinha)',NULL,'1',NULL),(9396,'Gisa Lemos (irma da Elizangela da Chacara)',NULL,'7',NULL),(9401,'Iranete Marinho Dias da Silva',NULL,'0',NULL),(9406,'Lucila Trobine',NULL,'8',NULL),(9418,'Paula Cristina Araujo','63992434223','1',''),(9488,'Luisa Bandeira Fragoso',' ','7','20/11/2023'),(9512,'Nadia PEREIRA DA SILVA (mae Da Naisa)',NULL,'1',NULL),(9517,'Luciana Manaia C Lopes Tov',NULL,'7',NULL),(9541,'Rita Carrijo',NULL,'7',NULL),(9550,'Nayane O. Alvarenga',NULL,'0',NULL),(9589,'Simone Dorosz','63984048284','7',NULL),(9642,'Antonia Carneiro de Sousa Neto Araujo','63984730882','6',''),(9649,'Ana Marta Rocha',NULL,'2',NULL),(9695,'Eliane de Assis',NULL,'1',NULL),(9714,'Agatha Prado',NULL,'7',NULL),(9740,'Ana Paula Viana Oliveira','63999732476','1',''),(9803,'Eduada Cristina Alves de Araujo','63992996262','8',''),(9829,'Alana Cristina dos Santos Moarais',NULL,'0',NULL),(9831,'Márcia Mendes Marques Braga','63992032377','4',''),(9842,'Simone Rodrigues de Noleto',NULL,'0',NULL),(9847,'Rosangela Cruz Coelho Freitas ( Tov)',NULL,'8',NULL),(9860,'Katia Cristina Costa','63984907846','7',''),(9878,'Juliana Vicente',NULL,'3',NULL),(9930,'Cristiane Saldanha','63981255377','2',''),(9964,'Maria Gloria Da Costa Xavier',NULL,'3',NULL),(9971,'Fabiana Brugger Rodrigues','981334472','1',''),(10008,'Ana Cristina Dos Santos Andrade Tov',NULL,'9',NULL),(10020,'Egidia Cipriano De Sousa','63984735601','3',''),(10034,'Edina Fernandes Leao',NULL,'1',NULL),(10059,'PETRA OLIVEIRA BRITO',NULL,'1',NULL),(10068,'Noeldina Cabral ( Dina)',NULL,'0','15/12/2023'),(10126,'Gessi Morreira',NULL,'4',NULL),(10141,'Cintia Campos Queiros De Sousa','63984563300','1',''),(10154,'Mirian Das Meces Perreira',NULL,'2',NULL),(10156,'Flavya Fernandes Alencar',NULL,'0',''),(10183,'Alice Gomes Soares',NULL,'3',NULL),(10185,'Carmem Dias De Araujo',NULL,'2',NULL),(10195,'Jussara Maysa','63999141946','1',''),(10210,'Ariadna De Aguiar Vieira Nascimento',NULL,'8',NULL),(10240,'MARIA GILVANETE RODRIGUES',NULL,'6',NULL),(10247,'Leidiane Cristaldo',NULL,'2',NULL),(10268,'Maria Goretti Nunes',NULL,'2','01/02/2024'),(10289,'Esffania Gonçalves Ferreira Pereira','63999711703','1','27/07/2023'),(10309,'Dhuliet  F. Katerine Milhomem ','63999180758','0','28/06/2023'),(10322,'Kellen Cristina Rodrigues',NULL,'0',NULL),(10326,'Dahelma  Teles',NULL,'2',NULL),(10331,'Sara Da Silva Lima','63984473459','-2','23/08/2023'),(10332,'Elisa Teixeira','63992970770','1',''),(10350,'Juliana Selestrina','66992193497','0','14/12/2023'),(10367,'Noemia Sirilo Cunha','94991093056','5',NULL),(10369,'TERENILZA S AMORIM',NULL,'3',NULL),(10404,'Maria Luisa Vasconcelos','63992903392','4',''),(10410,'Iradian Pereira De Oliveira Morais',NULL,'0',NULL),(10419,'Maisa Rodrigues Pacheco',NULL,'1',NULL),(10420,'Cristiane Cardoso Moreira Pinto','62996433348','9',''),(10424,'Hedi Sogra Michele Fogaça',NULL,'4',NULL),(10442,'Samarah Queiroz De Oliveira',NULL,'0',NULL),(10455,'Deyse Lemes Dos Santos',NULL,'0',NULL),(10466,'Eliene Fernandes Bandeira',NULL,'0',NULL),(10471,'Jane Maciel',NULL,'1',''),(10473,'Silvania Barbosa De Oliveira','63992884718','17','26/08/2023'),(10488,'Arlette Mascarenhas','63992625251','0',''),(10492,'Luiza ( Filha Da Gisa Lemos)',NULL,'1',NULL),(10493,'Julia ( Filha Da Gisa Lemos)',NULL,'1',NULL),(10499,'Samila Da Silva ( Fazenda Da Esperança)',NULL,'5',NULL),(10511,'Mariangela  Martins De Sousa','63999601576','3',''),(10515,'Sandra Assunção',NULL,'6',NULL),(10518,'Karoline Vasconcelos De Sousa',NULL,'0',NULL),(10525,'Danielle Dias Danaga','63984212529','2','14/10/2023'),(10548,'Manuela Santana',NULL,'7',NULL),(10551,'CANDIDA MARIA DA PAZ NONATO ( Tov)',NULL,'1',NULL),(10556,'Clara Bueno',NULL,'0',NULL),(10557,'Lilian Kelly Neves Souza Rodrigues','63984531085','7','01/08/2023'),(10567,'Adriana Cavalcante','63999790275','2','14/02/2024'),(10588,'Luzia Carmem De Oliveira Barroso',NULL,'0',NULL),(10609,'Noeme Pacheco Tonaco','63999929356','2',''),(10620,'Raquel Correia Barros',NULL,'3',NULL),(10626,'Rosane Marizete Possebon',NULL,'0',NULL),(10634,'Luiza Vasques',NULL,'1',NULL),(10639,'Carmelita Mae Da Luciana Furtado CCI',NULL,'0',NULL),(10641,'Maria Teresa Vasconcelos','63984472754','11','23/08/2023'),(10668,'Mironeide Feitosa Prado',NULL,'3',''),(10671,'Ellen Campos','63999406715','6',''),(10686,'Alzira Parente Moreno',NULL,'1',NULL),(10691,'Fernanda Cardoso','62999402515','1','12/01/2024'),(10696,'Maria Cecilia Alves De Sousa Moura','63984114360','1',''),(10698,'Marina Sousa Vasconceclos',NULL,'0',NULL),(10701,'Regina Rodrigues Renovato',NULL,'9',NULL),(10706,'Maria Do Esperito Santo ( Diarista',NULL,'6',NULL),(10707,'Mara Liliana Lopes De Amaral','63992627281','0','29/02/2024'),(10708,'Julliany Valina Cavalcante',NULL,'0',NULL),(10721,'Stela Ribeira','63984129794','0',''),(10726,'Glacielle',NULL,'7',NULL),(10736,'Valentina Rocha Dantas  ( Filha Da Jordana )',NULL,'0',NULL),(10740,'Dinomar Alves De Oliveira Soares',NULL,'3',NULL),(10741,'Jaqueline Borges',NULL,'0',NULL),(10743,'CARLA DOS REIS CORREIA ALENCA',NULL,'2',NULL),(10753,'BRENDA  MELO',NULL,'1',NULL),(10766,'Joselucia Lima Silva De Alencar',NULL,'1',NULL),(10772,'Denise ( Mae Da Giovanna Felipe)',NULL,'12','28/11/2023'),(10775,'Dhovana Ceolin',NULL,'2',NULL),(10779,'Carla Adriana Fliegner',NULL,'3',NULL),(10783,'Katia Maria De Oliveira Lotze',NULL,'1',NULL),(10794,'Zulmira Avelino Batista',NULL,'1',NULL),(10801,'Ana Lucia Soares Carvalho Aguiar',NULL,'1',''),(10805,'Ana Paula Oliveira Dorosz',NULL,'5',NULL),(10811,'Thayse Sá',NULL,'2',NULL),(10817,'Hadassa ( Filha Da Regina Ferreira)',NULL,'5',NULL),(10819,'Maria Carolina Oliveira',NULL,'4',NULL),(10820,'Roberta Mara De Oliveira Vergara','63981053999','8','20/01/2024'),(10822,'ELOISA PARENTE MORENO TAVARES DE SANTANA',NULL,'2',NULL),(10823,'PEDRINA SOUSA',NULL,'1',NULL),(10824,'Jaqueline Ghinato',NULL,'14',NULL),(10825,'Gabriela ( Gaby) ( Filha Da Katia)',NULL,'1',NULL),(10826,'Paula Gorge Maia',NULL,'2',NULL),(10827,'Geane Gonçalves De A Lemida',NULL,'0','26/02/2024'),(10833,'Sara Falcão',NULL,'3',NULL),(10835,'Isabela Bonges Rodrugues',NULL,'1',NULL),(10837,'Maria Lucia Umeno Alencar','63996465089','10','22/12/2023'),(10839,'Regina Olveira Perreira Ananias',NULL,'2',NULL),(10840,'Maria Dos Santos Marinho',NULL,'1',NULL),(10842,'Solange Martins De Oliveira','63992455458','5',NULL),(10843,'Leticia Paz Duarte',NULL,'1',NULL),(10849,'Jullianny Alves  ( Corretora)',NULL,'20',NULL),(10851,'FERNANDA GUTIEERREZ',NULL,'1',NULL),(10856,'Marildes Martins Da Silva Rocha',NULL,'2',NULL),(10859,'Bianca Mãe Leticia',NULL,'3',NULL),(10860,'Ueliton Luiz F Da Silva',NULL,'1',NULL),(10861,'Tereza Nel Wieczoren',NULL,'6',NULL),(10862,'Maria Clara Remde',NULL,'2',NULL),(10863,'IRAY MARCIA BADARÓ',NULL,'1',NULL),(10865,'Altaides Ivo Dos Santos',NULL,'1',NULL),(10867,'Luiz Guilherme ( Filho Da Maria Tereza)',NULL,'2',NULL),(10868,'Andreza Brandão',NULL,'5',NULL),(10869,'Solange M Oliveira',NULL,'4',NULL),(10875,'Adriana  (Professora)',NULL,'1',NULL),(10876,'Alzira ( Pedal)',NULL,'2',NULL),(10879,'Dr. Edna',NULL,'16','13/12/2023'),(10880,'Ana Flavia',NULL,'2',NULL),(10882,'Naiulse',NULL,'1',NULL),(10883,'Jusceli Segala',NULL,'2',NULL),(10885,'Ana Marcia Coelho',NULL,'9',NULL),(10889,'Anaides Siusa',NULL,'1',NULL),(10892,'Rosemary Marcondes Accioly',NULL,'1',NULL),(10893,'Lane Lima',NULL,'1',NULL),(10898,'DIONE RAMOS (PARQUE DOS IDOSOS)',NULL,'1',NULL),(10902,'Zilda Da Motta',NULL,'3',NULL),(10903,'Ana Luisa  ( Afilhada Da Araida)',NULL,'6',NULL),(10904,'Vania Oliveira',NULL,'3',NULL),(10909,'LUCIANA ( Irma Da Pollyana Pimenta)',NULL,'2',NULL),(10914,'Rayzza Cavalcante',NULL,'4',NULL),(10917,'Ileana',NULL,'4',NULL),(10918,'Doralice ( Mae Da Maria Gilvanete',NULL,'1',NULL),(10920,'Elisandra Scapin ( Cliente Da Cleyde)',NULL,'7',NULL),(10928,'Zenaide Maciel Ramos',NULL,'2',NULL),(10933,'Renata Murad',NULL,'4',NULL),(10938,'Vag Lan Gomes Borges ( Cliente Cleyde)',NULL,'8',NULL);
/*!40000 ALTER TABLE `cliente` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pontos_expirados`
--

DROP TABLE IF EXISTS `pontos_expirados`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pontos_expirados` (
  `PONTOS` int NOT NULL DEFAULT '0',
  `DATA_EXPIRACAO` date NOT NULL,
  `CLIENTE_CODIGO_CLIENTE` int NOT NULL,
  KEY `CLIENTE_CODIGO_CLIENTE` (`CLIENTE_CODIGO_CLIENTE`),
  CONSTRAINT `pontos_expirados_ibfk_1` FOREIGN KEY (`CLIENTE_CODIGO_CLIENTE`) REFERENCES `cliente` (`CODIGO_CLIENTE`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pontos_expirados`
--

LOCK TABLES `pontos_expirados` WRITE;
/*!40000 ALTER TABLE `pontos_expirados` DISABLE KEYS */;
INSERT INTO `pontos_expirados` VALUES (2,'2023-07-22',1000),(2,'2023-11-17',619),(1,'2023-11-17',5907),(2,'2023-11-17',10289),(3,'2023-11-18',6322),(1,'2023-11-18',8312),(1,'2023-11-18',8954),(2,'2023-11-18',9418),(1,'2023-11-18',9740),(1,'2023-11-18',10721),(1,'2023-11-19',10473),(1,'2023-11-19',10671),(3,'2023-11-23',490),(1,'2023-11-23',2418),(1,'2023-11-23',2759),(4,'2023-11-23',10609),(1,'2023-11-24',3526),(4,'2023-11-24',7026),(1,'2023-11-24',7733),(1,'2023-11-24',8559),(5,'2023-11-24',10641),(1,'2023-11-25',3920),(1,'2023-11-25',10609),(1,'2023-11-25',10691),(2,'2023-11-26',314),(1,'2023-11-26',634),(5,'2023-11-26',9007),(1,'2023-11-26',10668),(2,'2023-11-27',3535),(3,'2023-11-27',9362),(1,'2023-11-27',10473),(4,'2023-11-30',7105),(1,'2023-11-30',10156),(2,'2023-11-30',10331),(1,'2023-11-30',10471),(2,'2023-11-30',10525),(2,'2023-12-01',1850),(2,'2023-12-01',1850),(1,'2023-12-01',10350),(1,'2023-12-01',10473),(1,'2023-12-02',232),(3,'2023-12-02',267),(8,'2023-12-02',3473),(3,'2023-12-02',9488),(1,'2023-12-03',2725),(4,'2023-12-03',2992),(7,'2023-12-03',3415),(1,'2023-12-03',9642),(1,'2023-12-03',9860),(4,'2023-12-06',5327),(2,'2023-12-06',8517),(3,'2023-12-06',10289),(4,'2023-12-07',619),(4,'2023-12-07',1542),(1,'2023-12-07',4477),(11,'2023-12-07',6322),(4,'2023-12-07',10557),(1,'2023-12-09',189),(2,'2023-12-09',273),(5,'2023-12-09',3880),(1,'2023-12-09',7670),(8,'2023-12-09',8287),(1,'2023-12-09',10141),(1,'2023-12-09',10801),(2,'2023-12-10',2995),(5,'2023-12-10',10420),(3,'2023-12-10',10473),(1,'2023-12-10',10488),(7,'2023-12-13',649),(2,'2023-12-13',10350),(1,'2023-12-13',10588),(1,'2023-12-14',8802),(8,'2023-12-14',10691),(1,'2023-12-15',10708),(3,'2023-12-16',634),(1,'2023-12-16',7901),(1,'2023-12-16',9401),(4,'2023-12-16',10620),(3,'2023-12-17',397),(3,'2023-12-17',490),(6,'2023-12-17',2327),(3,'2023-12-17',2725),(4,'2023-12-17',2992),(1,'2023-12-17',10473),(1,'2023-12-17',10736),(1,'2023-12-20',869),(1,'2023-12-22',2992),(1,'2023-12-23',314),(7,'2023-12-24',267),(2,'2023-12-24',1850),(3,'2023-12-24',2725),(1,'2023-12-24',5327),(1,'2023-12-24',9550),(3,'2023-12-27',2725),(1,'2023-12-27',5375),(1,'2023-12-27',10466),(4,'2023-12-27',10473),(2,'2023-12-27',10811),(2,'2023-12-28',2418),(2,'2023-12-28',6322),(3,'2023-12-28',8212),(2,'2023-12-28',10309),(1,'2023-12-28',10455),(3,'2023-12-29',391),(2,'2023-12-29',8517),(1,'2023-12-29',10126),(2,'2023-12-29',10154),(2,'2023-12-29',10473),(2,'2023-12-29',10609),(4,'2023-12-29',10626),(1,'2023-12-30',2499),(1,'2023-12-30',9374),(4,'2023-12-30',10557),(1,'2023-12-31',2499),(1,'2023-12-31',9374),(4,'2023-12-31',10557),(1,'2024-01-01',2022),(1,'2024-01-01',2725),(1,'2024-01-01',5263),(4,'2024-01-01',5327),(1,'2024-01-01',6595),(4,'2024-01-01',7828),(4,'2024-01-01',9842),(1,'2024-01-04',5028),(3,'2024-01-04',6322),(1,'2024-01-04',10289),(2,'2024-01-04',10499),(5,'2024-01-04',10641),(2,'2024-01-04',10701),(4,'2024-01-05',423),(1,'2024-01-05',6876),(3,'2024-01-06',314),(6,'2024-01-06',9374),(3,'2024-01-06',10404),(1,'2024-01-06',10473),(1,'2024-01-07',314),(5,'2024-01-07',7105),(1,'2024-01-07',10141),(3,'2024-01-11',9362),(3,'2024-01-11',9860),(1,'2024-01-11',10518),(2,'2024-02-17',9418),(2,'2024-02-17',490);
/*!40000 ALTER TABLE `pontos_expirados` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pontos_periodo`
--

DROP TABLE IF EXISTS `pontos_periodo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pontos_periodo` (
  `CLIENTE_CODIGO_CLIENTE` int NOT NULL,
  `PONTOS` int NOT NULL DEFAULT '0',
  `DATA_PONTUACAO` date NOT NULL,
  `CODIGO_VENDA` int NOT NULL DEFAULT '0',
  KEY `CLIENTE_CODIGO_CLIENTE` (`CLIENTE_CODIGO_CLIENTE`),
  KEY `CODIGO_VENDA` (`CODIGO_VENDA`),
  CONSTRAINT `pontos_periodo_ibfk_1` FOREIGN KEY (`CLIENTE_CODIGO_CLIENTE`) REFERENCES `cliente` (`CODIGO_CLIENTE`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `pontos_periodo_ibfk_2` FOREIGN KEY (`CODIGO_VENDA`) REFERENCES `vendas` (`CODIGO_VENDA`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pontos_periodo`
--

LOCK TABLES `pontos_periodo` WRITE;
/*!40000 ALTER TABLE `pontos_periodo` DISABLE KEYS */;
INSERT INTO `pontos_periodo` VALUES (189,1,'2023-06-09',125817),(232,1,'2023-06-02',125765),(254,1,'2023-07-17',126147),(267,3,'2023-06-02',125770),(267,7,'2023-06-24',125963),(273,2,'2023-06-09',125805),(314,2,'2023-05-26',125705),(314,1,'2023-06-23',125945),(314,3,'2023-07-06',126075),(314,1,'2023-07-07',126083),(391,3,'2023-06-29',125999),(397,3,'2023-06-17',125893),(423,4,'2023-07-05',126064),(490,3,'2023-05-23',125669),(490,3,'2023-06-17',125908),(619,2,'2023-05-17',125630),(619,4,'2023-06-07',125801),(619,1,'2023-07-15',126140),(634,1,'2023-05-26',125700),(634,3,'2023-06-16',125881),(649,7,'2023-06-13',125843),(649,2,'2023-06-23',125948),(661,1,'2023-07-17',126148),(869,1,'2023-06-20',125911),(1542,4,'2023-06-07',125803),(1850,2,'2023-06-01',125749),(1850,2,'2023-06-01',125750),(1850,2,'2023-06-24',125955),(1850,2,'2023-07-15',126142),(2022,1,'2023-07-01',126027),(2022,1,'2023-07-21',126182),(2037,1,'2023-07-18',126158),(2327,6,'2023-06-17',125896),(2418,1,'2023-05-23',125666),(2418,2,'2023-06-28',125980),(2499,1,'2023-06-30',126019),(2725,1,'2023-06-03',125785),(2725,3,'2023-06-17',125905),(2725,3,'2023-06-24',125964),(2725,3,'2023-06-27',125966),(2725,1,'2023-07-01',126030),(2725,1,'2023-07-15',126146),(2759,1,'2023-05-23',125661),(2992,4,'2023-06-03',125786),(2992,4,'2023-06-17',125891),(2992,1,'2023-06-22',125928),(2995,2,'2023-06-10',125829),(3415,7,'2023-06-03',125784),(3473,8,'2023-06-02',125763),(3526,1,'2023-05-24',125678),(3526,1,'2023-07-20',126169),(3535,2,'2023-05-27',125716),(3880,5,'2023-06-09',125814),(3920,1,'2023-05-25',125686),(4477,1,'2023-06-07',125798),(5028,1,'2023-07-04',126038),(5263,1,'2023-07-01',126021),(5327,4,'2023-06-06',125787),(5327,1,'2023-06-24',125954),(5327,4,'2023-07-01',126022),(5375,1,'2023-06-27',125976),(5907,1,'2023-05-17',125627),(5907,1,'2023-07-15',126144),(6322,3,'2023-05-18',125646),(6322,11,'2023-06-07',125796),(6322,2,'2023-06-28',125983),(6322,3,'2023-07-04',126046),(6595,1,'2023-07-01',126033),(6788,1,'2023-07-21',126174),(6876,1,'2023-07-05',126063),(7026,4,'2023-05-24',125674),(7026,1,'2023-06-23',125940),(7105,4,'2023-05-30',125733),(7105,5,'2023-07-07',126089),(7278,1,'2023-07-03',126034),(7505,5,'2023-07-18',126155),(7670,1,'2023-06-09',125806),(7733,1,'2023-05-24',125673),(7766,4,'2023-07-21',126180),(7828,4,'2023-07-01',126028),(7834,7,'2023-07-15',126143),(7901,1,'2023-06-16',125882),(8021,1,'2023-05-31',125745),(8212,3,'2023-06-28',125986),(8287,8,'2023-06-09',125818),(8312,1,'2023-05-18',125637),(8312,2,'2023-07-14',126133),(8517,2,'2023-06-06',125789),(8517,1,'2023-06-23',125950),(8517,2,'2023-06-29',126002),(8559,1,'2023-05-24',125671),(8802,1,'2023-06-14',125854),(8954,1,'2023-05-18',125642),(9007,5,'2023-05-26',125703),(9362,3,'2023-05-27',125713),(9362,3,'2023-07-11',126094),(9374,2,'2023-05-31',125740),(9374,1,'2023-06-21',125917),(9374,1,'2023-06-30',126018),(9374,6,'2023-07-06',126071),(9374,3,'2023-07-14',126135),(9374,3,'2023-07-17',126150),(9374,1,'2023-07-19',126162),(9401,1,'2023-06-16',125868),(9418,2,'2023-05-18',125633),(9488,3,'2023-06-02',125766),(9541,1,'2023-07-18',126159),(9550,1,'2023-06-24',125962),(9642,1,'2023-06-03',125772),(9642,1,'2023-06-21',125922),(9649,2,'2023-07-14',126132),(9740,1,'2023-05-18',125643),(9803,3,'2023-05-31',125739),(9842,4,'2023-07-01',126025),(9860,1,'2023-06-03',125777),(9860,3,'2023-07-11',126092),(10008,3,'2023-07-21',126183),(10059,1,'2023-07-20',126167),(10068,4,'2023-07-14',126138),(10126,1,'2023-06-29',125998),(10141,1,'2023-06-09',125822),(10141,1,'2023-07-07',126087),(10154,2,'2023-06-29',125994),(10156,1,'2023-05-30',125720),(10268,2,'2023-07-21',126179),(10289,2,'2023-05-17',125626),(10289,3,'2023-06-06',125791),(10289,1,'2023-07-04',126036),(10309,2,'2023-06-28',125988),(10331,2,'2023-05-30',125730),(10350,1,'2023-06-01',125753),(10350,2,'2023-06-13',125836),(10350,2,'2023-06-23',125935),(10367,3,'2023-07-14',126139),(10404,3,'2023-07-06',126077),(10420,5,'2023-06-10',125823),(10424,2,'2023-07-19',126161),(10455,1,'2023-06-28',125989),(10466,1,'2023-06-21',125914),(10466,1,'2023-06-27',125967),(10471,1,'2023-05-30',125728),(10473,1,'2023-05-19',125655),(10473,1,'2023-05-27',125717),(10473,1,'2023-06-01',125756),(10473,3,'2023-06-10',125828),(10473,1,'2023-06-17',125890),(10473,4,'2023-06-27',125971),(10473,2,'2023-06-29',126000),(10473,1,'2023-07-06',126079),(10473,5,'2023-07-19',126164),(10488,1,'2023-06-10',125831),(10499,2,'2023-07-04',126039),(10499,2,'2023-07-19',126160),(10518,1,'2023-07-11',126091),(10525,2,'2023-05-30',125735),(10551,1,'2023-07-18',126152),(10557,4,'2023-06-07',125800),(10557,4,'2023-06-30',126016),(10588,1,'2023-06-13',125837),(10609,4,'2023-05-23',125663),(10609,1,'2023-05-25',125688),(10609,2,'2023-06-29',125997),(10620,4,'2023-06-16',125877),(10626,4,'2023-06-29',125992),(10641,5,'2023-05-24',125681),(10641,5,'2023-07-04',126045),(10668,1,'2023-05-26',125701),(10671,1,'2023-05-19',125653),(10691,1,'2023-05-25',125687),(10691,8,'2023-06-14',125848),(10701,2,'2023-07-04',126047),(10708,1,'2023-06-15',125857),(10721,1,'2023-05-18',125647),(10736,1,'2023-06-17',125902),(10772,3,'2023-07-14',126131),(10772,1,'2023-07-14',126134),(10801,1,'2023-06-09',125816),(10805,3,'2023-06-21',125920),(10811,2,'2023-06-27',125975),(1000,2,'2023-01-22',777),(5375,1,'2023-07-25',126213),(490,1,'2023-07-25',126215),(754,2,'2023-07-25',126184),(10525,5,'2023-07-25',126187),(9394,1,'2023-07-25',126190),(397,2,'2023-07-25',126191),(2759,3,'2023-07-25',126195),(3661,1,'2023-07-25',126197),(754,2,'2023-07-25',126198),(245,1,'2023-07-25',126199),(2725,1,'2023-07-25',126201),(6322,4,'2023-07-25',126207),(7409,2,'2023-07-25',126208),(10515,3,'2023-07-25',126219),(6788,2,'2023-07-25',126221),(2642,1,'2023-07-26',126223),(10548,2,'2023-07-26',126228),(10350,2,'2023-07-26',126229),(10819,3,'2023-07-26',126230),(10289,4,'2023-07-27',126236),(5327,3,'2023-07-27',126239),(9392,3,'2023-07-27',126243),(10820,4,'2023-07-28',126250),(10420,2,'2023-07-28',126257),(9589,2,'2023-07-28',126260),(6788,3,'2023-07-28',126263),(5362,4,'2023-07-29',126264),(10822,2,'2023-07-29',126269),(10473,1,'2023-07-29',126270),(10823,1,'2023-07-29',126271),(10185,2,'2023-07-29',126272),(6073,1,'2023-07-31',126274),(3905,1,'2023-07-31',126279),(10825,1,'2023-08-01',126282),(10824,2,'2023-08-01',126283),(661,4,'2023-08-01',126284),(10557,4,'2023-08-01',126285),(9374,2,'2023-08-01',126286),(2022,1,'2023-08-01',126287),(10826,2,'2023-08-02',126289),(391,2,'2023-08-02',126291),(10701,2,'2023-08-02',126295),(8517,3,'2023-08-02',126296),(9740,1,'2023-08-02',126297),(5746,1,'2023-08-02',126300),(7026,10,'2023-08-02',126301),(5327,3,'2023-08-03',126306),(8988,8,'2023-08-03',126307),(10473,2,'2023-08-03',126308),(9860,2,'2023-08-04',126309),(8521,6,'2023-08-04',126313),(6322,2,'2023-08-04',126316),(7026,1,'2023-08-04',126321),(9517,1,'2023-08-04',126322),(10641,3,'2023-08-05',126324),(8559,3,'2023-08-09',126333),(10367,2,'2023-08-09',126335),(10419,1,'2023-08-10',126338),(1850,2,'2023-08-10',126339),(10801,1,'2023-08-10',126341),(397,2,'2023-08-10',126342),(5877,8,'2023-08-11',126349),(1850,6,'2023-08-11',126350),(9541,1,'2023-08-14',126365),(9418,2,'2023-08-17',126373),(490,2,'2023-08-17',126376),(10331,8,'2023-08-19',126379),(10473,3,'2023-08-19',126383),(5277,3,'2023-08-19',126384),(10210,4,'2023-08-19',126385),(9695,1,'2023-08-22',126390),(10289,1,'2023-08-24',126398),(423,3,'2023-08-26',126405),(10835,1,'2023-08-26',126407),(10811,0,'2023-08-29',126411),(5375,1,'2023-08-29',126412),(10268,1,'2023-08-29',126413),(10641,0,'2023-08-30',126414),(10471,0,'2023-08-30',126415),(7105,3,'2023-08-30',126420),(5840,0,'2023-08-30',126422),(1419,1,'2023-08-31',126427),(596,1,'2023-08-31',126428),(6579,0,'2023-08-31',126429),(4692,3,'2023-08-31',126430),(3880,0,'2023-08-31',126433),(9589,3,'2023-09-01',126434),(7911,0,'2023-09-01',126435),(6322,4,'2023-09-01',126436),(4786,0,'2023-09-01',126437),(2788,1,'2023-09-01',126439),(863,3,'2023-09-01',126440),(10805,1,'2023-09-01',126442),(9244,1,'2023-09-01',126443),(314,0,'2023-09-02',126444),(10820,3,'2023-09-02',126445),(1850,1,'2023-09-02',126446),(4247,2,'2023-09-02',126447),(10671,0,'2023-09-02',126448),(10525,1,'2023-09-02',126449),(7834,2,'2023-09-02',126450),(2499,1,'2023-09-02',126451),(9860,1,'2023-09-02',126453),(10473,1,'2023-09-02',126454),(10641,3,'2023-09-05',126463),(9803,2,'2023-09-05',126464),(9374,3,'2023-09-05',126465),(10668,3,'2023-09-05',126467),(10837,5,'2023-09-05',126469),(4538,2,'2023-09-06',126473),(9847,2,'2023-09-06',126481),(10840,1,'2023-09-06',126483),(4297,0,'2023-09-06',126484),(5327,2,'2023-09-09',126492),(10842,5,'2023-09-09',126493),(4369,3,'2023-09-09',126494),(10772,6,'2023-09-09',126495),(1922,6,'2023-09-09',126496),(10833,3,'2023-09-09',126497),(9374,0,'2023-09-11',126498),(9488,1,'2023-09-12',126501),(10839,1,'2023-09-13',126503),(9007,3,'2023-09-13',126504),(9007,1,'2023-09-13',126505),(10671,1,'2023-09-13',126506),(2327,0,'2023-09-13',126510),(7733,0,'2023-09-14',126513),(8156,0,'2023-09-14',126518),(824,4,'2023-09-14',126519),(9878,3,'2023-09-14',126521),(10843,1,'2023-09-14',126522),(2759,0,'2023-09-15',126523),(2992,3,'2023-09-15',126524),(8134,2,'2023-09-15',126525),(10557,3,'2023-09-15',126527),(7884,0,'2023-09-15',126528),(3526,1,'2023-09-15',126529),(273,0,'2023-09-16',126532),(3411,0,'2023-09-16',126533),(10499,2,'2023-09-16',126535),(6740,1,'2023-09-16',126536),(7911,1,'2023-09-16',126537),(7409,2,'2023-09-16',126538),(10473,2,'2023-09-16',126541),(863,1,'2023-09-16',126542),(8134,1,'2023-09-16',126543),(10289,2,'2023-09-18',126547),(9418,1,'2023-09-20',126552),(10499,1,'2023-09-20',126553),(490,2,'2023-09-20',126554),(490,0,'2023-09-21',126563),(10741,0,'2023-09-21',126564),(7026,1,'2023-09-21',126565),(8312,1,'2023-09-22',126566),(9589,1,'2023-09-22',126569),(3411,1,'2023-09-22',126571),(2617,0,'2023-09-22',126572),(8212,1,'2023-09-23',126574),(189,2,'2023-09-26',126578),(3179,1,'2023-09-26',126581),(7026,0,'2023-09-26',126582),(8134,2,'2023-09-26',126583),(314,0,'2023-09-27',126585),(10811,0,'2023-09-27',126586),(7911,3,'2023-09-28',126587),(156,2,'2023-09-28',126588),(5375,0,'2023-09-29',126593),(6322,2,'2023-09-29',126595),(869,0,'2023-09-29',126597),(10840,0,'2023-09-29',126598),(9362,2,'2023-09-29',126603),(9860,1,'2023-09-29',126604),(259,1,'2023-09-29',126605),(259,4,'2023-09-29',126607),(10473,1,'2023-09-29',126608),(10851,1,'2023-09-30',126611),(9714,4,'2023-09-30',126613),(10849,2,'2023-09-30',126615),(10824,1,'2023-09-30',126618),(649,5,'2023-09-30',126620),(7555,1,'2023-09-30',126624),(10753,0,'2023-09-30',126626),(2725,0,'2023-09-30',126628),(2881,2,'2023-10-02',126630),(2881,2,'2023-10-02',126633),(5612,1,'2023-10-02',126635),(4050,6,'2023-10-02',126636),(622,4,'2023-10-02',126637),(273,1,'2023-10-03',126639),(9396,2,'2023-10-03',126642),(7105,1,'2023-10-03',126643),(695,1,'2023-10-03',126646),(754,1,'2023-10-03',126651),(6275,3,'2023-10-03',126652),(6073,0,'2023-10-03',126655),(10671,1,'2023-10-04',126660),(10548,2,'2023-10-04',126661),(2759,1,'2023-10-04',126662),(4687,1,'2023-10-04',126663),(5746,0,'2023-10-04',126664),(8517,1,'2023-10-04',126665),(1487,0,'2023-10-04',126667),(351,3,'2023-10-04',126669),(5327,2,'2023-10-06',126675),(10779,1,'2023-10-06',126678),(10824,2,'2023-10-07',126683),(661,0,'2023-10-07',126688),(9829,0,'2023-10-09',126691),(490,0,'2023-10-10',126701),(10268,2,'2023-10-10',126702),(10126,1,'2023-10-11',126703),(10609,0,'2023-10-11',126704),(9512,1,'2023-10-11',126706),(9517,6,'2023-10-11',126707),(2992,2,'2023-10-11',126710),(4692,1,'2023-10-11',126712),(10837,5,'2023-10-11',126714),(8156,1,'2023-10-11',126715),(5327,1,'2023-10-13',126717),(423,1,'2023-10-13',126718),(10827,6,'2023-10-13',126719),(10634,1,'2023-10-13',126720),(7901,1,'2023-10-13',126726),(7342,2,'2023-10-13',126727),(3905,1,'2023-10-13',126728),(3,1,'2023-10-13',126729),(1850,2,'2023-10-14',126731),(10691,5,'2023-10-14',126732),(9226,3,'2023-10-14',126733),(10567,1,'2023-10-14',126735),(5362,2,'2023-10-14',126736),(10686,1,'2023-10-14',126737),(5362,2,'2023-10-14',126739),(2725,1,'2023-10-14',126741),(4784,0,'2023-10-16',126747),(5907,2,'2023-10-16',126748),(6452,3,'2023-10-17',126750),(10811,0,'2023-10-17',126752),(596,1,'2023-10-17',126754),(10736,0,'2023-10-17',126755),(7528,2,'2023-10-17',126757),(10805,1,'2023-10-17',126759),(10154,2,'2023-10-18',126762),(10701,1,'2023-10-18',126766),(606,2,'2023-10-19',126768),(9406,8,'2023-10-19',126770),(4786,7,'2023-10-19',126773),(8312,1,'2023-10-20',126776),(10856,2,'2023-10-20',126777),(314,0,'2023-10-20',126778),(10183,2,'2023-10-20',126781),(7555,0,'2023-10-21',126784),(10671,0,'2023-10-21',126787),(10404,2,'2023-10-21',126789),(7911,1,'2023-10-21',126794),(10473,1,'2023-10-21',126796),(2759,1,'2023-10-21',126797),(2725,0,'2023-10-21',126800),(2725,1,'2023-10-21',126801),(10849,3,'2023-10-21',126802),(9488,1,'2023-10-23',126806),(5908,1,'2023-10-23',126807),(10289,1,'2023-10-23',126808),(10859,3,'2023-10-23',126809),(3535,2,'2023-10-24',126810),(10350,5,'2023-10-24',126812),(7064,4,'2023-10-24',126817),(9010,0,'2023-10-25',126822),(3814,4,'2023-10-25',126826),(10707,2,'2023-10-26',126833),(6322,1,'2023-10-26',126840),(9550,0,'2023-10-26',126841),(4031,0,'2023-10-26',126844),(7445,1,'2023-10-27',126847),(8517,1,'2023-10-27',126853),(6788,1,'2023-10-27',126854),(5908,1,'2023-10-27',126856),(10860,1,'2023-10-27',126857),(8156,1,'2023-10-27',126858),(9396,2,'2023-10-27',126859),(10862,2,'2023-10-28',126863),(4224,5,'2023-10-28',126864),(1261,2,'2023-10-28',126865),(10525,0,'2023-10-28',126866),(10034,1,'2023-10-28',126867),(10861,6,'2023-10-28',126868),(10493,1,'2023-10-28',126869),(10473,1,'2023-10-28',126870),(5156,4,'2023-10-28',126871),(10783,1,'2023-10-30',126882),(10863,1,'2023-10-30',126884),(10794,1,'2023-10-31',126887),(10706,1,'2023-10-31',126888),(1046,4,'2023-11-01',126891),(10548,1,'2023-11-01',126900),(9541,1,'2023-11-01',126901),(7871,2,'2023-11-01',126902),(7871,1,'2023-11-01',126903),(107,1,'2023-11-03',126909),(10865,1,'2023-11-03',126913),(10473,1,'2023-11-03',126918),(10641,3,'2023-11-03',126923),(531,5,'2023-11-03',126924),(10811,2,'2023-11-03',126925),(10849,1,'2023-11-04',126928),(5327,7,'2023-11-04',126929),(1850,1,'2023-11-04',126930),(3415,6,'2023-11-04',126931),(10557,3,'2023-11-04',126932),(1891,2,'2023-11-06',126937),(2759,1,'2023-11-07',126939),(10240,3,'2023-11-07',126941),(10867,1,'2023-11-07',126942),(7766,3,'2023-11-07',126945),(6695,8,'2023-11-07',126948),(10671,1,'2023-11-08',126950),(10410,0,'2023-11-08',126951),(7317,0,'2023-11-09',126955),(10240,1,'2023-11-09',126956),(7409,1,'2023-11-09',126957),(10820,2,'2023-11-09',126960),(9847,2,'2023-11-09',126961),(10839,1,'2023-11-10',126968),(10706,2,'2023-11-10',126969),(10868,1,'2023-11-10',126970),(9007,1,'2023-11-10',126973),(490,1,'2023-11-10',126976),(9714,2,'2023-11-10',126977),(490,1,'2023-11-10',126979),(10424,1,'2023-11-11',126981),(10824,1,'2023-11-11',126983),(7911,3,'2023-11-11',126984),(5375,1,'2023-11-11',126985),(10869,4,'2023-11-11',126987),(7528,0,'2023-11-11',126988),(397,3,'2023-11-11',126992),(9541,2,'2023-11-11',126993),(10473,2,'2023-11-11',126994),(10473,2,'2023-11-11',126995),(9374,3,'2023-11-13',127003),(6322,2,'2023-11-13',127005),(2759,0,'2023-11-14',127007),(5612,1,'2023-11-14',127008),(10706,3,'2023-11-14',127010),(10775,1,'2023-11-14',127013),(6322,2,'2023-11-14',127014),(9488,0,'2023-11-14',127015),(10819,1,'2023-11-14',127016),(10701,1,'2023-11-16',127019),(391,3,'2023-11-16',127021),(5612,1,'2023-11-16',127024),(2037,3,'2023-11-16',127026),(10126,1,'2023-11-17',127028),(273,2,'2023-11-17',127029),(10183,1,'2023-11-17',127031),(10525,0,'2023-11-17',127032),(314,0,'2023-11-17',127033),(10837,3,'2023-11-17',127034),(10837,3,'2023-11-17',127035),(863,1,'2023-11-18',127038),(9362,5,'2023-11-18',127039),(8517,1,'2023-11-18',127040),(8517,1,'2023-11-18',127041),(8147,3,'2023-11-18',127042),(3504,8,'2023-11-18',127043),(9878,0,'2023-11-20',127052),(5375,1,'2023-11-20',127053),(863,2,'2023-11-20',127054),(4759,5,'2023-11-20',127055),(2201,1,'2023-11-20',127058),(10875,1,'2023-11-24',127085),(10698,0,'2023-11-24',127087),(10876,2,'2023-11-24',127090),(10840,0,'2023-11-24',127092),(619,2,'2023-11-24',127093),(634,2,'2023-11-24',127097),(1850,1,'2023-11-25',127098),(10567,1,'2023-11-25',127099),(10473,2,'2023-11-25',127103),(5972,3,'2023-11-25',127104),(10772,8,'2023-11-28',127110),(9488,2,'2023-11-28',127111),(3535,0,'2023-11-28',127113),(7342,2,'2023-11-28',127115),(4247,5,'2023-11-29',127119),(8212,4,'2023-11-29',127123),(9362,2,'2023-12-01',127141),(7911,3,'2023-12-01',127143),(9396,1,'2023-12-01',127144),(7733,2,'2023-12-01',127153),(9803,2,'2023-12-01',127154),(8312,2,'2023-12-01',127156),(10068,5,'2023-12-01',127157),(7009,4,'2023-12-01',127158),(869,0,'2023-12-01',127159),(10322,0,'2023-12-02',127162),(10880,2,'2023-12-02',127165),(10879,8,'2023-12-04',127169),(5028,0,'2023-12-04',127170),(10701,1,'2023-12-05',127173),(9488,1,'2023-12-05',127175),(754,1,'2023-12-05',127178),(10882,1,'2023-12-06',127191),(5612,2,'2023-12-06',127195),(2499,5,'2023-12-06',127197),(10883,2,'2023-12-06',127198),(10557,1,'2023-12-07',127209),(10556,0,'2023-12-07',127210),(8149,0,'2023-12-08',127214),(622,2,'2023-12-08',127216),(10726,6,'2023-12-08',127218),(10008,2,'2023-12-08',127220),(189,0,'2023-12-08',127222),(9847,4,'2023-12-08',127225),(5156,2,'2023-12-08',127227),(314,1,'2023-12-09',127236),(10889,1,'2023-12-09',127237),(5877,6,'2023-12-09',127239),(10849,1,'2023-12-09',127241),(10567,1,'2023-12-09',127244),(351,3,'2023-12-09',127245),(10879,3,'2023-12-09',127246),(10442,0,'2023-12-11',127250),(9374,0,'2023-12-11',127251),(10805,0,'2023-12-11',127252),(1004,1,'2023-12-11',127255),(10641,4,'2023-12-11',127256),(10743,2,'2023-12-12',127262),(2992,1,'2023-12-12',127264),(6322,1,'2023-12-12',127265),(9878,0,'2023-12-13',127268),(10893,1,'2023-12-13',127269),(10892,1,'2023-12-13',127270),(7916,2,'2023-12-13',127273),(5375,1,'2023-12-13',127274),(10840,0,'2023-12-13',127275),(10609,2,'2023-12-14',127285),(1850,1,'2023-12-14',127288),(5327,4,'2023-12-14',127289),(10898,1,'2023-12-14',127292),(6788,1,'2023-12-14',127294),(9589,1,'2023-12-15',127296),(10473,3,'2023-12-15',127297),(10775,1,'2023-12-15',127302),(9860,1,'2023-12-15',127306),(9878,0,'2023-12-15',127307),(9374,0,'2023-12-15',127310),(10824,2,'2023-12-15',127311),(661,3,'2023-12-15',127312),(9163,2,'2023-12-15',127313),(7505,3,'2023-12-16',127317),(490,1,'2023-12-18',127326),(9971,0,'2023-12-18',127333),(7901,0,'2023-12-19',127338),(397,1,'2023-12-19',127339),(9878,0,'2023-12-19',127341),(7505,7,'2023-12-19',127344),(7505,7,'2023-12-20',127345),(10268,2,'2023-12-20',127348),(314,1,'2023-12-20',127349),(10726,1,'2023-12-20',127351),(10557,4,'2023-12-20',127352),(10885,3,'2023-12-20',127353),(8212,1,'2023-12-20',127354),(9226,1,'2023-12-21',127358),(3411,1,'2023-12-21',127359),(5907,1,'2023-12-21',127360),(4692,1,'2023-12-21',127361),(10902,3,'2023-12-21',127364),(1419,0,'2023-12-21',127367),(7834,1,'2023-12-21',127371),(3,3,'2023-12-21',127372),(10903,3,'2023-12-22',127380),(10903,3,'2023-12-22',127382),(3814,3,'2023-12-22',127384),(314,1,'2023-12-22',127385),(1330,0,'2023-12-22',127386),(7911,1,'2023-12-22',127387),(5375,1,'2023-12-22',127388),(869,1,'2023-12-22',127389),(10837,4,'2023-12-22',127392),(2759,1,'2023-12-22',127395),(2327,1,'2023-12-23',127400),(7342,2,'2023-12-23',127401),(3880,4,'2023-12-23',127402),(10473,0,'2023-12-23',127404),(9642,2,'2023-12-23',127407),(10879,5,'2023-12-26',127408),(3,1,'2023-12-26',127409),(5658,5,'2023-12-26',127411),(596,1,'2023-12-26',127412),(4801,2,'2023-12-26',127414),(5375,1,'2023-12-26',127415),(10849,1,'2023-12-26',127416),(5658,5,'2023-12-26',127418),(10473,3,'2023-12-26',127419),(10473,2,'2023-12-27',127421),(10740,3,'2023-12-27',127422),(9714,1,'2023-12-28',127424),(10740,0,'2023-12-29',127433),(10466,1,'2023-12-29',127434),(9007,4,'2023-12-29',127437),(4692,1,'2023-12-29',127438),(8216,2,'2023-12-29',127440),(397,1,'2023-12-30',127442),(8517,1,'2023-12-30',127443),(6347,1,'2024-01-02',127446),(9488,1,'2024-01-03',127451),(10515,3,'2024-01-04',127455),(441,1,'2024-01-04',127456),(10701,2,'2024-01-05',127459),(8312,1,'2024-01-05',127460),(10369,2,'2024-01-05',127461),(10268,2,'2024-01-05',127462),(3861,1,'2024-01-05',127464),(9147,2,'2024-01-06',127471),(5327,2,'2024-01-06',127472),(7342,5,'2024-01-06',127473),(1891,3,'2024-01-06',127474),(5674,1,'2024-01-06',127476),(2725,0,'2024-01-06',127478),(5375,1,'2024-01-08',127482),(10691,0,'2024-01-08',127483),(10639,0,'2024-01-08',127484),(5741,1,'2024-01-08',127485),(490,1,'2024-01-09',127487),(6322,2,'2024-01-09',127488),(10904,3,'2024-01-09',127490),(7342,2,'2024-01-10',127495),(10811,0,'2024-01-10',127496),(10620,3,'2024-01-10',127498),(8521,4,'2024-01-10',127501),(273,1,'2024-01-11',127502),(10548,2,'2024-01-11',127504),(9642,0,'2024-01-11',127506),(1850,2,'2024-01-11',127508),(863,0,'2024-01-11',127509),(5840,0,'2024-01-11',127511),(9964,1,'2024-01-11',127512),(824,2,'2024-01-11',127513),(4538,2,'2024-01-12',127515),(10820,2,'2024-01-12',127516),(10641,3,'2024-01-12',127517),(5375,1,'2024-01-12',127518),(7911,3,'2024-01-13',127524),(7851,1,'2024-01-16',127530),(754,1,'2024-01-17',127533),(10909,2,'2024-01-18',127535),(10473,1,'2024-01-18',127537),(3473,2,'2024-01-18',127538),(10827,4,'2024-01-19',127548),(596,4,'2024-01-19',127551),(10914,4,'2024-01-19',127553),(8652,3,'2024-01-20',127556),(10849,4,'2024-01-20',127558),(10879,3,'2024-01-22',127570),(5612,1,'2024-01-23',127580),(10268,1,'2024-01-23',127581),(5375,1,'2024-01-23',127585),(8517,1,'2024-01-24',127591),(10824,2,'2024-01-24',127593),(9362,1,'2024-01-24',127597),(10707,4,'2024-01-24',127598),(10824,1,'2024-01-25',127600),(10420,3,'2024-01-25',127601),(10867,1,'2024-01-25',127603),(7834,4,'2024-01-25',127604),(3905,1,'2024-01-26',127608),(3905,1,'2024-01-26',127609),(10817,5,'2024-01-26',127615),(10511,1,'2024-01-26',127616),(5156,4,'2024-01-26',127618),(9860,1,'2024-01-27',127621),(10473,1,'2024-01-27',127626),(397,1,'2024-01-27',127630),(10247,2,'2024-01-27',127632),(351,2,'2024-01-27',127636),(10885,6,'2024-01-27',127640),(10671,1,'2024-01-29',127648),(9362,2,'2024-01-29',127650),(8863,2,'2024-01-29',127656),(10879,2,'2024-01-30',127657),(6452,3,'2024-02-01',127666),(10849,2,'2024-02-01',127671),(5375,1,'2024-02-02',127677),(4687,3,'2024-02-02',127678),(1046,4,'2024-02-02',127679),(10779,2,'2024-02-02',127680),(1046,4,'2024-02-02',127683),(9964,2,'2024-02-03',127688),(9642,1,'2024-02-03',127690),(10492,1,'2024-02-03',127692),(9642,1,'2024-02-03',127693),(10473,2,'2024-02-03',127694),(2565,4,'2024-02-03',127697),(7564,3,'2024-02-03',127698),(10641,1,'2024-02-05',127701),(10525,2,'2024-02-06',127708),(5327,3,'2024-02-06',127709),(9396,1,'2024-02-07',127714),(10918,1,'2024-02-08',127721),(10126,2,'2024-02-08',127726),(754,1,'2024-02-08',127728),(189,3,'2024-02-08',127730),(10557,3,'2024-02-08',127732),(10641,2,'2024-02-08',127733),(10240,2,'2024-02-09',127735),(6788,1,'2024-02-09',127738),(490,1,'2024-02-09',127744),(10641,2,'2024-02-09',127746),(441,1,'2024-02-09',127748),(7481,1,'2024-02-10',127752),(5778,1,'2024-02-10',127754),(9541,2,'2024-02-12',127757),(8212,2,'2024-02-12',127759),(10473,1,'2024-02-12',127761),(2565,2,'2024-02-12',127762),(10920,1,'2024-02-12',127763),(5375,1,'2024-02-12',127764),(7064,2,'2024-02-14',127765),(5778,2,'2024-02-14',127768),(10567,2,'2024-02-14',127769),(10268,2,'2024-02-14',127772),(7026,1,'2024-02-14',127773),(6322,4,'2024-02-15',127778),(5327,1,'2024-02-15',127779),(8312,1,'2024-02-15',127780),(754,1,'2024-02-15',127783),(10141,1,'2024-02-16',127787),(3526,1,'2024-02-16',127789),(7911,2,'2024-02-16',127792),(863,3,'2024-02-17',127796),(10849,2,'2024-02-17',127803),(2725,4,'2024-02-17',127804),(2725,1,'2024-02-17',127805),(10879,5,'2024-02-17',127806),(10210,4,'2024-02-17',127808),(397,1,'2024-02-20',127812),(490,1,'2024-02-20',127813),(7342,2,'2024-02-21',127818),(10473,2,'2024-02-21',127819),(10820,7,'2024-02-22',127824),(5327,1,'2024-02-22',127829),(8517,1,'2024-02-23',127833),(5375,1,'2024-02-23',127839),(10772,4,'2024-02-23',127843),(10917,4,'2024-02-23',127844),(10557,1,'2024-02-23',127846),(2759,1,'2024-02-24',127854),(1542,3,'2024-02-24',127858),(1850,1,'2024-02-24',127860),(10473,1,'2024-02-24',127863),(10766,1,'2024-02-27',127873),(10369,1,'2024-02-27',127877),(5424,1,'2024-02-27',127878),(7409,1,'2024-02-27',127879),(10701,2,'2024-02-29',127896),(10511,1,'2024-02-29',127901),(10671,1,'2024-03-01',127909),(10691,1,'2024-03-01',127910),(10641,3,'2024-03-01',127915),(9860,1,'2024-03-01',127916),(273,1,'2024-03-02',127919),(10849,4,'2024-03-02',127922),(10928,2,'2024-03-02',127923),(5585,3,'2024-03-02',127924),(824,1,'2024-03-02',127928),(5156,5,'2024-03-04',127932),(9396,1,'2024-03-05',127934),(5327,2,'2024-03-05',127935),(7105,3,'2024-03-06',127941),(5612,1,'2024-03-06',127944),(10473,2,'2024-03-06',127945),(7911,1,'2024-03-07',127948),(3814,1,'2024-03-07',127950),(10424,1,'2024-03-07',127952),(1393,1,'2024-03-07',127954),(10920,6,'2024-03-07',127955),(10824,1,'2024-03-08',127961),(622,3,'2024-03-08',127963),(9374,2,'2024-03-08',127965),(3429,4,'2024-03-08',127966),(10933,4,'2024-03-09',127971),(10326,2,'2024-03-09',127972),(9488,2,'2024-03-09',127975),(397,1,'2024-03-09',127978),(10868,4,'2024-03-09',127982),(351,3,'2024-03-09',127984),(5375,1,'2024-03-11',127987),(10525,1,'2024-03-11',127989),(2759,2,'2024-03-12',127990),(10008,4,'2024-03-12',127993),(4692,1,'2024-03-14',128006),(8312,1,'2024-03-14',128010),(391,1,'2024-03-15',128018),(6788,1,'2024-03-15',128021),(10824,2,'2024-03-15',128022),(5375,1,'2024-03-15',128023),(8216,2,'2024-03-15',128024),(10471,1,'2024-03-15',128026),(9642,1,'2024-03-16',128029),(9007,4,'2024-03-16',128030),(10753,1,'2024-03-16',128031),(10473,1,'2024-03-16',128033),(7317,2,'2024-03-16',128036),(9488,1,'2024-03-18',128037),(10671,1,'2024-03-18',128039),(4369,3,'2024-03-18',128043),(3814,1,'2024-03-20',128047),(10289,1,'2024-03-20',128048),(8517,1,'2024-03-21',128053),(1046,4,'2024-03-21',128054),(10420,4,'2024-03-21',128057),(7901,1,'2024-03-22',128061),(99,1,'2024-03-22',128064),(1872,1,'2024-03-23',128070),(1046,2,'2024-03-23',128071),(10938,8,'2024-03-23',128080),(10473,2,'2024-03-23',128081),(9488,1,'2024-03-23',128083);
/*!40000 ALTER TABLE `pontos_periodo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `resgate`
--

DROP TABLE IF EXISTS `resgate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `resgate` (
  `DATA_RESGATE` date NOT NULL,
  `HORA_RESGATE` time NOT NULL,
  `CLIENTE_CODIGO_CLIENTE` int NOT NULL,
  KEY `fk_resgate_cliente1_idx` (`CLIENTE_CODIGO_CLIENTE`),
  CONSTRAINT `fk_resgate_cliente1` FOREIGN KEY (`CLIENTE_CODIGO_CLIENTE`) REFERENCES `cliente` (`CODIGO_CLIENTE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `resgate`
--

LOCK TABLES `resgate` WRITE;
/*!40000 ALTER TABLE `resgate` DISABLE KEYS */;
INSERT INTO `resgate` VALUES ('2023-06-28','16:29:56',8212),('2023-06-28','16:58:39',10309),('2023-06-29','17:00:35',10473),('2023-07-05','16:14:40',763),('2023-07-27','12:02:59',10289),('2023-07-28','22:02:31',1000),('2023-07-28','22:10:57',1000),('2023-07-29','17:23:17',2725),('2023-08-01','09:45:41',2759),('2023-08-01','15:49:55',10557),('2023-08-04','15:01:17',267),('2023-08-04','16:13:13',6322),('2023-08-04','18:01:21',7026),('2023-08-08','11:01:40',6788),('2023-08-19','15:06:11',5327),('2023-08-23','12:08:00',1850),('2023-08-23','12:13:04',10641),('2023-08-23','12:16:26',10331),('2023-08-26','16:41:40',10473),('2023-09-13','15:56:24',232),('2023-10-03','15:58:18',7105),('2023-10-07','14:59:27',490),('2023-10-11','15:57:04',2992),('2023-10-14','15:50:33',10525),('2023-10-26','15:16:54',6322),('2023-11-06','11:46:52',1850),('2023-11-20','11:27:00',9488),('2023-11-20','11:27:06',8517),('2023-11-21','15:16:33',5327),('2023-11-28','12:13:19',10772),('2023-12-05','16:34:58',9374),('2023-12-13','16:06:16',10879),('2023-12-14','10:48:01',10350),('2023-12-15','12:04:03',10068),('2023-12-22','16:52:53',10837),('2024-01-12','16:55:49',10691),('2024-01-20','10:42:08',10820),('2024-01-25','17:33:20',7834),('2024-01-29','10:41:54',649),('2024-01-29','15:41:36',9362),('2024-02-01','10:09:56',10268),('2024-02-02','14:52:16',5375),('2024-02-14','16:07:37',10567),('2024-02-26','10:25:14',8521),('2024-02-26','10:30:33',10827),('2024-02-29','16:54:46',10707),('2024-03-05','15:36:16',5327),('2024-03-12','16:24:38',397);
/*!40000 ALTER TABLE `resgate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `update_manual_pontos`
--

DROP TABLE IF EXISTS `update_manual_pontos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `update_manual_pontos` (
  `DATA_UPDATE` date NOT NULL,
  `HORA_UPDATE` time NOT NULL,
  `QTD_PONTOS_UPDATE` int NOT NULL,
  `CLIENTE_CODIGO_CLIENTE` int NOT NULL,
  KEY `fk_update_manual_pontos_cliente1_idx` (`CLIENTE_CODIGO_CLIENTE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `update_manual_pontos`
--

LOCK TABLES `update_manual_pontos` WRITE;
/*!40000 ALTER TABLE `update_manual_pontos` DISABLE KEYS */;
INSERT INTO `update_manual_pontos` VALUES ('2023-06-10','16:54:37',10,232),('2023-06-27','21:05:22',7,2725),('2023-06-29','19:55:35',2,10473),('2023-07-28','22:02:25',10,1000),('2023-07-28','22:10:52',11,1000),('2023-07-28','22:12:33',1,10289),('2023-08-02','20:31:22',2,10557),('2023-08-02','21:16:57',4,10557),('2023-09-23','16:39:09',0,10473),('2023-10-23','18:02:31',6,10289),('2023-11-07','10:05:22',0,3905),('2023-11-07','10:05:49',7,9488),('2023-11-07','10:09:13',9,9488),('2023-11-07','10:09:25',0,2759),('2023-11-14','12:56:23',0,2759),('2023-11-14','12:56:41',10,9488),('2023-12-01','19:00:54',0,10466),('2023-12-01','19:01:09',4,9488),('2023-12-01','19:02:11',10,10068),('2023-12-01','19:02:27',6,4247),('2023-12-14','10:47:46',10,10350),('2024-01-12','17:40:46',3,10641),('2024-02-24','13:10:06',3,1850);
/*!40000 ALTER TABLE `update_manual_pontos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendas`
--

DROP TABLE IF EXISTS `vendas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vendas` (
  `CODIGO_VENDA` int NOT NULL,
  `DATA_VENDA` date NOT NULL,
  `VALOR` int NOT NULL,
  `CLIENTE_CODIGO_CLIENTE` int NOT NULL,
  UNIQUE KEY `CODIGO_VENDA` (`CODIGO_VENDA`),
  KEY `fk_vendas_cliente_idx` (`CLIENTE_CODIGO_CLIENTE`),
  CONSTRAINT `fk_vendas_cliente` FOREIGN KEY (`CLIENTE_CODIGO_CLIENTE`) REFERENCES `cliente` (`CODIGO_CLIENTE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendas`
--

LOCK TABLES `vendas` WRITE;
/*!40000 ALTER TABLE `vendas` DISABLE KEYS */;
INSERT INTO `vendas` VALUES (777,'2023-01-22',150,1000),(125626,'2023-05-17',165,10289),(125627,'2023-05-17',113,5907),(125630,'2023-05-17',170,619),(125633,'2023-05-18',198,9418),(125637,'2023-05-18',85,8312),(125642,'2023-05-18',120,8954),(125643,'2023-05-18',128,9740),(125646,'2023-05-18',215,6322),(125647,'2023-05-18',88,10721),(125653,'2023-05-19',95,10671),(125655,'2023-05-19',100,10473),(125661,'2023-05-23',73,2759),(125663,'2023-05-23',290,10609),(125666,'2023-05-23',115,2418),(125669,'2023-05-23',248,490),(125671,'2023-05-24',110,8559),(125673,'2023-05-24',75,7733),(125674,'2023-05-24',290,7026),(125678,'2023-05-24',98,3526),(125681,'2023-05-24',373,10641),(125686,'2023-05-25',85,3920),(125687,'2023-05-25',90,10691),(125688,'2023-05-25',80,10609),(125700,'2023-05-26',108,634),(125701,'2023-05-26',100,10668),(125703,'2023-05-26',368,9007),(125705,'2023-05-26',150,314),(125713,'2023-05-27',210,9362),(125716,'2023-05-27',200,3535),(125717,'2023-05-27',120,10473),(125720,'2023-05-30',80,10156),(125728,'2023-05-30',90,10471),(125730,'2023-05-30',180,10331),(125733,'2023-05-30',320,7105),(125735,'2023-05-30',168,10525),(125739,'2023-05-31',260,9803),(125740,'2023-05-31',192,9374),(125745,'2023-05-31',80,8021),(125749,'2023-06-01',160,1850),(125750,'2023-06-01',160,1850),(125753,'2023-06-01',80,10350),(125756,'2023-06-01',80,10473),(125763,'2023-06-02',578,3473),(125765,'2023-06-02',90,232),(125766,'2023-06-02',270,9488),(125770,'2023-06-02',220,267),(125772,'2023-06-03',110,9642),(125777,'2023-06-03',75,9860),(125784,'2023-06-03',530,3415),(125785,'2023-06-03',138,2725),(125786,'2023-06-03',280,2992),(125787,'2023-06-06',310,5327),(125789,'2023-06-06',200,8517),(125791,'2023-06-06',260,10289),(125796,'2023-06-07',813,6322),(125798,'2023-06-07',88,4477),(125800,'2023-06-07',318,10557),(125801,'2023-06-07',345,619),(125803,'2023-06-07',330,1542),(125805,'2023-06-09',165,273),(125806,'2023-06-09',100,7670),(125814,'2023-06-09',395,3880),(125816,'2023-06-09',80,10801),(125817,'2023-06-09',108,189),(125818,'2023-06-09',600,8287),(125822,'2023-06-09',123,10141),(125823,'2023-06-10',400,10420),(125828,'2023-06-10',210,10473),(125829,'2023-06-10',150,2995),(125831,'2023-06-10',110,10488),(125836,'2023-06-13',178,10350),(125837,'2023-06-13',83,10588),(125843,'2023-06-13',500,649),(125848,'2023-06-14',600,10691),(125854,'2023-06-14',135,8802),(125857,'2023-06-15',130,10708),(125868,'2023-06-16',80,9401),(125877,'2023-06-16',280,10620),(125881,'2023-06-16',228,634),(125882,'2023-06-16',90,7901),(125890,'2023-06-17',130,10473),(125891,'2023-06-17',340,2992),(125893,'2023-06-17',260,397),(125896,'2023-06-17',470,2327),(125902,'2023-06-17',75,10736),(125905,'2023-06-17',210,2725),(125908,'2023-06-17',226,490),(125911,'2023-06-20',80,869),(125914,'2023-06-21',78,10466),(125917,'2023-06-21',70,9374),(125920,'2023-06-21',210,10805),(125922,'2023-06-21',70,9642),(125928,'2023-06-22',80,2992),(125935,'2023-06-23',170,10350),(125940,'2023-06-23',88,7026),(125945,'2023-06-23',70,314),(125948,'2023-06-23',170,649),(125950,'2023-06-23',125,8517),(125954,'2023-06-24',138,5327),(125955,'2023-06-24',170,1850),(125962,'2023-06-24',135,9550),(125963,'2023-06-24',520,267),(125964,'2023-06-24',218,2725),(125966,'2023-06-27',218,2725),(125967,'2023-06-27',78,10466),(125971,'2023-06-27',300,10473),(125975,'2023-06-27',150,10811),(125976,'2023-06-27',85,5375),(125980,'2023-06-28',175,2418),(125983,'2023-06-28',163,6322),(125986,'2023-06-28',226,8212),(125988,'2023-06-28',175,10309),(125989,'2023-06-28',115,10455),(125992,'2023-06-29',290,10626),(125994,'2023-06-29',145,10154),(125997,'2023-06-29',168,10609),(125998,'2023-06-29',108,10126),(125999,'2023-06-29',222,391),(126000,'2023-06-29',140,10473),(126002,'2023-06-29',170,8517),(126016,'2023-06-30',330,10557),(126018,'2023-06-30',83,9374),(126019,'2023-06-30',98,2499),(126021,'2023-07-01',90,5263),(126022,'2023-07-01',318,5327),(126025,'2023-07-01',340,9842),(126027,'2023-07-01',108,2022),(126028,'2023-07-01',328,7828),(126030,'2023-07-01',93,2725),(126033,'2023-07-01',135,6595),(126034,'2023-07-03',130,7278),(126036,'2023-07-04',100,10289),(126038,'2023-07-04',70,5028),(126039,'2023-07-04',200,10499),(126045,'2023-07-04',393,10641),(126046,'2023-07-04',270,6322),(126047,'2023-07-04',150,10701),(126063,'2023-07-05',108,6876),(126064,'2023-07-05',300,423),(126071,'2023-07-06',450,9374),(126075,'2023-07-06',270,314),(126077,'2023-07-06',270,10404),(126079,'2023-07-06',108,10473),(126083,'2023-07-07',70,314),(126087,'2023-07-07',100,10141),(126089,'2023-07-07',403,7105),(126091,'2023-07-11',80,10518),(126092,'2023-07-11',228,9860),(126094,'2023-07-11',230,9362),(126131,'2023-07-14',230,10772),(126132,'2023-07-14',168,9649),(126133,'2023-07-14',160,8312),(126134,'2023-07-14',73,10772),(126135,'2023-07-14',210,9374),(126138,'2023-07-14',310,10068),(126139,'2023-07-14',245,10367),(126140,'2023-07-15',125,619),(126142,'2023-07-15',198,1850),(126143,'2023-07-15',518,7834),(126144,'2023-07-15',128,5907),(126146,'2023-07-15',93,2725),(126147,'2023-07-17',108,254),(126148,'2023-07-17',88,661),(126150,'2023-07-17',245,9374),(126152,'2023-07-18',105,10551),(126155,'2023-07-18',388,7505),(126158,'2023-07-18',115,2037),(126159,'2023-07-18',70,9541),(126160,'2023-07-19',190,10499),(126161,'2023-07-19',148,10424),(126162,'2023-07-19',78,9374),(126164,'2023-07-19',358,10473),(126167,'2023-07-20',115,10059),(126169,'2023-07-20',110,3526),(126174,'2023-07-21',108,6788),(126179,'2023-07-21',195,10268),(126180,'2023-07-21',325,7766),(126182,'2023-07-21',88,2022),(126183,'2023-07-21',260,10008),(126184,'2023-07-22',205,754),(126187,'2023-07-22',390,10525),(126190,'2023-07-22',110,9394),(126191,'2023-07-22',160,397),(126195,'2023-07-22',228,2759),(126197,'2023-07-22',70,3661),(126198,'2023-07-22',175,754),(126199,'2023-07-22',100,245),(126201,'2023-07-22',138,2725),(126207,'2023-07-24',338,6322),(126208,'2023-07-24',195,7409),(126213,'2023-07-25',120,5375),(126215,'2023-07-25',95,490),(126219,'2023-07-25',240,10515),(126221,'2023-07-25',168,6788),(126223,'2023-07-26',80,2642),(126228,'2023-07-26',178,10548),(126229,'2023-07-26',198,10350),(126230,'2023-07-26',250,10819),(126236,'2023-07-27',280,10289),(126239,'2023-07-27',248,5327),(126243,'2023-07-27',250,9392),(126250,'2023-07-28',310,10820),(126257,'2023-07-28',140,10420),(126260,'2023-07-28',203,9589),(126263,'2023-07-28',250,6788),(126264,'2023-07-29',298,5362),(126269,'2023-07-29',160,10822),(126270,'2023-07-29',103,10473),(126271,'2023-07-29',120,10823),(126272,'2023-07-29',180,10185),(126274,'2023-07-31',80,6073),(126279,'2023-07-31',100,3905),(126282,'2023-08-01',78,10825),(126283,'2023-08-01',165,10824),(126284,'2023-08-01',280,661),(126285,'2023-08-01',290,10557),(126286,'2023-08-01',163,9374),(126287,'2023-08-01',108,2022),(126289,'2023-08-02',160,10826),(126291,'2023-08-02',185,391),(126295,'2023-08-02',150,10701),(126296,'2023-08-02',250,8517),(126297,'2023-08-02',128,9740),(126300,'2023-08-02',80,5746),(126301,'2023-08-02',760,7026),(126306,'2023-08-03',228,5327),(126307,'2023-08-03',583,8988),(126308,'2023-08-03',155,10473),(126309,'2023-08-04',145,9860),(126313,'2023-08-04',450,8521),(126316,'2023-08-04',145,6322),(126321,'2023-08-04',100,7026),(126322,'2023-08-04',80,9517),(126324,'2023-08-05',235,10641),(126333,'2023-08-09',220,8559),(126335,'2023-08-09',150,10367),(126338,'2023-08-10',105,10419),(126339,'2023-08-10',180,1850),(126341,'2023-08-10',110,10801),(126342,'2023-08-10',190,397),(126349,'2023-08-11',600,5877),(126350,'2023-08-11',450,1850),(126365,'2023-08-14',100,9541),(126373,'2023-08-17',170,9418),(126376,'2023-08-17',190,490),(126379,'2023-08-19',600,10331),(126383,'2023-08-19',245,10473),(126384,'2023-08-19',220,5277),(126385,'2023-08-19',340,10210),(126390,'2023-08-22',180,9695),(126398,'2023-08-24',110,10289),(126405,'2023-08-26',350,423),(126407,'2023-08-26',120,10835),(126411,'2023-08-29',90,10811),(126412,'2023-08-29',120,5375),(126413,'2023-08-29',140,10268),(126414,'2023-08-30',90,10641),(126415,'2023-08-30',80,10471),(126420,'2023-08-30',350,7105),(126422,'2023-08-30',80,5840),(126427,'2023-08-31',135,1419),(126428,'2023-08-31',130,596),(126429,'2023-08-31',85,6579),(126430,'2023-08-31',360,4692),(126433,'2023-08-31',95,3880),(126434,'2023-09-01',300,9589),(126435,'2023-09-01',85,7911),(126436,'2023-09-01',445,6322),(126437,'2023-09-01',85,4786),(126439,'2023-09-01',130,2788),(126440,'2023-09-01',330,863),(126442,'2023-09-01',105,10805),(126443,'2023-09-01',135,9244),(126444,'2023-09-02',70,314),(126445,'2023-09-02',305,10820),(126446,'2023-09-02',160,1850),(126447,'2023-09-02',260,4247),(126448,'2023-09-02',70,10671),(126449,'2023-09-02',185,10525),(126450,'2023-09-02',205,7834),(126451,'2023-09-02',100,2499),(126453,'2023-09-02',185,9860),(126454,'2023-09-02',105,10473),(126463,'2023-09-05',345,10641),(126464,'2023-09-05',260,9803),(126465,'2023-09-05',310,9374),(126467,'2023-09-05',330,10668),(126469,'2023-09-05',540,10837),(126473,'2023-09-06',200,4538),(126481,'2023-09-06',240,9847),(126483,'2023-09-06',115,10840),(126484,'2023-09-06',80,4297),(126492,'2023-09-09',260,5327),(126493,'2023-09-09',580,10842),(126494,'2023-09-09',300,4369),(126495,'2023-09-09',600,10772),(126496,'2023-09-09',650,1922),(126497,'2023-09-09',300,10833),(126498,'2023-09-11',80,9374),(126501,'2023-09-12',110,9488),(126503,'2023-09-13',110,10839),(126504,'2023-09-13',330,9007),(126505,'2023-09-13',150,9007),(126506,'2023-09-13',105,10671),(126510,'2023-09-13',70,2327),(126513,'2023-09-14',75,7733),(126518,'2023-09-14',90,8156),(126519,'2023-09-14',405,824),(126521,'2023-09-14',300,9878),(126522,'2023-09-14',180,10843),(126523,'2023-09-15',80,2759),(126524,'2023-09-15',300,2992),(126525,'2023-09-15',230,8134),(126527,'2023-09-15',340,10557),(126528,'2023-09-15',70,7884),(126529,'2023-09-15',110,3526),(126532,'2023-09-16',90,273),(126533,'2023-09-16',70,3411),(126535,'2023-09-16',200,10499),(126536,'2023-09-16',190,6740),(126537,'2023-09-16',150,7911),(126538,'2023-09-16',200,7409),(126541,'2023-09-16',215,10473),(126542,'2023-09-16',160,863),(126543,'2023-09-16',160,8134),(126547,'2023-09-18',280,10289),(126552,'2023-09-20',105,9418),(126553,'2023-09-20',130,10499),(126554,'2023-09-20',200,490),(126563,'2023-09-21',70,490),(126564,'2023-09-21',70,10741),(126565,'2023-09-21',180,7026),(126566,'2023-09-22',125,8312),(126569,'2023-09-22',110,9589),(126571,'2023-09-22',110,3411),(126572,'2023-09-22',80,2617),(126574,'2023-09-23',120,8212),(126578,'2023-09-26',210,189),(126581,'2023-09-26',180,3179),(126582,'2023-09-26',70,7026),(126583,'2023-09-26',230,8134),(126585,'2023-09-27',70,314),(126586,'2023-09-27',80,10811),(126587,'2023-09-28',390,7911),(126588,'2023-09-28',280,156),(126593,'2023-09-29',88,5375),(126595,'2023-09-29',205,6322),(126597,'2023-09-29',85,869),(126598,'2023-09-29',70,10840),(126603,'2023-09-29',225,9362),(126604,'2023-09-29',148,9860),(126605,'2023-09-29',108,259),(126607,'2023-09-29',400,259),(126608,'2023-09-29',113,10473),(126611,'2023-09-30',135,10851),(126613,'2023-09-30',440,9714),(126615,'2023-09-30',200,10849),(126618,'2023-09-30',160,10824),(126620,'2023-09-30',500,649),(126624,'2023-09-30',150,7555),(126626,'2023-09-30',75,10753),(126628,'2023-09-30',70,2725),(126630,'2023-10-02',255,2881),(126633,'2023-10-02',255,2881),(126635,'2023-10-02',180,5612),(126636,'2023-10-02',600,4050),(126637,'2023-10-02',440,622),(126639,'2023-10-03',160,273),(126642,'2023-10-03',230,9396),(126643,'2023-10-03',115,7105),(126646,'2023-10-03',100,695),(126651,'2023-10-03',100,754),(126652,'2023-10-03',300,6275),(126655,'2023-10-03',90,6073),(126660,'2023-10-04',130,10671),(126661,'2023-10-04',250,10548),(126662,'2023-10-04',160,2759),(126663,'2023-10-04',110,4687),(126664,'2023-10-04',90,5746),(126665,'2023-10-04',145,8517),(126667,'2023-10-04',90,1487),(126669,'2023-10-04',320,351),(126675,'2023-10-06',230,5327),(126678,'2023-10-06',160,10779),(126683,'2023-10-07',220,10824),(126688,'2023-10-07',70,661),(126691,'2023-10-09',85,9829),(126701,'2023-10-10',70,490),(126702,'2023-10-10',235,10268),(126703,'2023-10-11',140,10126),(126704,'2023-10-11',85,10609),(126706,'2023-10-11',140,9512),(126707,'2023-10-11',675,9517),(126710,'2023-10-11',280,2992),(126712,'2023-10-11',100,4692),(126714,'2023-10-11',540,10837),(126715,'2023-10-11',120,8156),(126717,'2023-10-13',110,5327),(126718,'2023-10-13',140,423),(126719,'2023-10-13',640,10827),(126720,'2023-10-13',120,10634),(126726,'2023-10-13',160,7901),(126727,'2023-10-13',230,7342),(126728,'2023-10-13',140,3905),(126729,'2023-10-13',130,3),(126731,'2023-10-14',230,1850),(126732,'2023-10-14',580,10691),(126733,'2023-10-14',394,9226),(126735,'2023-10-14',140,10567),(126736,'2023-10-14',200,5362),(126737,'2023-10-14',160,10686),(126739,'2023-10-14',200,5362),(126741,'2023-10-14',150,2725),(126747,'2023-10-16',70,4784),(126748,'2023-10-16',255,5907),(126750,'2023-10-17',300,6452),(126752,'2023-10-17',90,10811),(126754,'2023-10-17',130,596),(126755,'2023-10-17',90,10736),(126757,'2023-10-17',230,7528),(126759,'2023-10-17',175,10805),(126762,'2023-10-18',210,10154),(126766,'2023-10-18',150,10701),(126768,'2023-10-19',250,606),(126770,'2023-10-19',800,9406),(126773,'2023-10-19',700,4786),(126776,'2023-10-20',160,8312),(126777,'2023-10-20',240,10856),(126778,'2023-10-20',70,314),(126781,'2023-10-20',290,10183),(126784,'2023-10-21',75,7555),(126787,'2023-10-21',70,10671),(126789,'2023-10-21',270,10404),(126794,'2023-10-21',110,7911),(126796,'2023-10-21',107,10473),(126797,'2023-10-21',180,2759),(126800,'2023-10-21',92,2725),(126801,'2023-10-21',168,2725),(126802,'2023-10-21',360,10849),(126806,'2023-10-23',120,9488),(126807,'2023-10-23',180,5908),(126808,'2023-10-23',175,10289),(126809,'2023-10-23',300,10859),(126810,'2023-10-24',285,3535),(126812,'2023-10-24',510,10350),(126817,'2023-10-24',475,7064),(126822,'2023-10-25',90,9010),(126826,'2023-10-25',420,3814),(126833,'2023-10-26',260,10707),(126840,'2023-10-26',170,6322),(126841,'2023-10-26',90,9550),(126844,'2023-10-26',90,4031),(126847,'2023-10-27',100,7445),(126853,'2023-10-27',120,8517),(126854,'2023-10-27',115,6788),(126856,'2023-10-27',180,5908),(126857,'2023-10-27',180,10860),(126858,'2023-10-27',115,8156),(126859,'2023-10-27',260,9396),(126863,'2023-10-28',270,10862),(126864,'2023-10-28',550,4224),(126865,'2023-10-28',230,1261),(126866,'2023-10-28',70,10525),(126867,'2023-10-28',102,10034),(126868,'2023-10-28',669,10861),(126869,'2023-10-28',175,10493),(126870,'2023-10-28',157,10473),(126871,'2023-10-28',460,5156),(126882,'2023-10-30',120,10783),(126884,'2023-10-30',150,10863),(126887,'2023-10-31',160,10794),(126888,'2023-10-31',180,10706),(126891,'2023-11-01',460,1046),(126900,'2023-11-01',190,10548),(126901,'2023-11-01',170,9541),(126902,'2023-11-01',200,7871),(126903,'2023-11-01',140,7871),(126909,'2023-11-03',110,107),(126913,'2023-11-03',120,10865),(126918,'2023-11-03',105,10473),(126923,'2023-11-03',325,10641),(126924,'2023-11-03',530,531),(126925,'2023-11-03',290,10811),(126928,'2023-11-04',150,10849),(126929,'2023-11-04',720,5327),(126930,'2023-11-04',140,1850),(126931,'2023-11-04',600,3415),(126932,'2023-11-04',340,10557),(126937,'2023-11-06',250,1891),(126939,'2023-11-07',140,2759),(126941,'2023-11-07',330,10240),(126942,'2023-11-07',100,10867),(126945,'2023-11-07',375,7766),(126948,'2023-11-07',800,6695),(126950,'2023-11-08',105,10671),(126951,'2023-11-08',90,10410),(126955,'2023-11-09',70,7317),(126956,'2023-11-09',110,10240),(126957,'2023-11-09',145,7409),(126960,'2023-11-09',260,10820),(126961,'2023-11-09',200,9847),(126968,'2023-11-10',120,10839),(126969,'2023-11-10',228,10706),(126970,'2023-11-10',140,10868),(126973,'2023-11-10',150,9007),(126976,'2023-11-10',160,490),(126977,'2023-11-10',260,9714),(126979,'2023-11-10',100,490),(126981,'2023-11-11',140,10424),(126983,'2023-11-11',170,10824),(126984,'2023-11-11',310,7911),(126985,'2023-11-11',110,5375),(126987,'2023-11-11',430,10869),(126988,'2023-11-11',90,7528),(126992,'2023-11-11',340,397),(126993,'2023-11-11',235,9541),(126994,'2023-11-11',207,10473),(126995,'2023-11-11',207,10473),(127003,'2023-11-13',355,9374),(127005,'2023-11-13',230,6322),(127007,'2023-11-14',90,2759),(127008,'2023-11-14',180,5612),(127010,'2023-11-14',322,10706),(127013,'2023-11-14',180,10775),(127014,'2023-11-14',290,6322),(127015,'2023-11-14',70,9488),(127016,'2023-11-14',150,10819),(127019,'2023-11-16',150,10701),(127021,'2023-11-16',397,391),(127024,'2023-11-16',150,5612),(127026,'2023-11-16',345,2037),(127028,'2023-11-17',110,10126),(127029,'2023-11-17',260,273),(127031,'2023-11-17',175,10183),(127032,'2023-11-17',90,10525),(127033,'2023-11-17',70,314),(127034,'2023-11-17',350,10837),(127035,'2023-11-17',370,10837),(127038,'2023-11-18',120,863),(127039,'2023-11-18',540,9362),(127040,'2023-11-18',155,8517),(127041,'2023-11-18',120,8517),(127042,'2023-11-18',300,8147),(127043,'2023-11-18',800,3504),(127052,'2023-11-20',85,9878),(127053,'2023-11-20',180,5375),(127054,'2023-11-20',250,863),(127055,'2023-11-20',530,4759),(127058,'2023-11-20',150,2201),(127085,'2023-11-24',150,10875),(127087,'2023-11-24',85,10698),(127090,'2023-11-24',250,10876),(127092,'2023-11-24',70,10840),(127093,'2023-11-24',225,619),(127097,'2023-11-24',240,634),(127098,'2023-11-25',170,1850),(127099,'2023-11-25',120,10567),(127103,'2023-11-25',250,10473),(127104,'2023-11-25',345,5972),(127110,'2023-11-28',820,10772),(127111,'2023-11-28',270,9488),(127113,'2023-11-28',90,3535),(127115,'2023-11-28',230,7342),(127119,'2023-11-29',560,4247),(127123,'2023-11-29',450,8212),(127141,'2023-12-01',220,9362),(127143,'2023-12-01',300,7911),(127144,'2023-12-01',142,9396),(127153,'2023-12-01',255,7733),(127154,'2023-12-01',260,9803),(127156,'2023-12-01',220,8312),(127157,'2023-12-01',540,10068),(127158,'2023-12-01',400,7009),(127159,'2023-12-01',85,869),(127162,'2023-12-02',70,10322),(127165,'2023-12-02',200,10880),(127169,'2023-12-04',870,10879),(127170,'2023-12-04',70,5028),(127173,'2023-12-05',150,10701),(127175,'2023-12-05',142,9488),(127178,'2023-12-05',130,754),(127191,'2023-12-06',135,10882),(127195,'2023-12-06',250,5612),(127197,'2023-12-06',550,2499),(127198,'2023-12-06',240,10883),(127209,'2023-12-07',100,10557),(127210,'2023-12-07',90,10556),(127214,'2023-12-08',90,8149),(127216,'2023-12-08',205,622),(127218,'2023-12-08',695,10726),(127220,'2023-12-08',240,10008),(127222,'2023-12-08',80,189),(127225,'2023-12-08',450,9847),(127227,'2023-12-08',230,5156),(127236,'2023-12-09',130,314),(127237,'2023-12-09',120,10889),(127239,'2023-12-09',620,5877),(127241,'2023-12-09',150,10849),(127244,'2023-12-09',120,10567),(127245,'2023-12-09',325,351),(127246,'2023-12-09',350,10879),(127250,'2023-12-11',90,10442),(127251,'2023-12-11',70,9374),(127252,'2023-12-11',80,10805),(127255,'2023-12-11',180,1004),(127256,'2023-12-11',460,10641),(127262,'2023-12-12',200,10743),(127264,'2023-12-12',100,2992),(127265,'2023-12-12',120,6322),(127268,'2023-12-13',75,9878),(127269,'2023-12-13',140,10893),(127270,'2023-12-13',150,10892),(127273,'2023-12-13',260,7916),(127274,'2023-12-13',110,5375),(127275,'2023-12-13',70,10840),(127285,'2023-12-14',230,10609),(127288,'2023-12-14',170,1850),(127289,'2023-12-14',415,5327),(127292,'2023-12-14',142,10898),(127294,'2023-12-14',110,6788),(127296,'2023-12-15',175,9589),(127297,'2023-12-15',370,10473),(127302,'2023-12-15',110,10775),(127306,'2023-12-15',182,9860),(127307,'2023-12-15',85,9878),(127310,'2023-12-15',90,9374),(127311,'2023-12-15',245,10824),(127312,'2023-12-15',365,661),(127313,'2023-12-15',240,9163),(127317,'2023-12-16',390,7505),(127326,'2023-12-18',120,490),(127333,'2023-12-18',70,9971),(127338,'2023-12-19',90,7901),(127339,'2023-12-19',190,397),(127341,'2023-12-19',85,9878),(127344,'2023-12-19',750,7505),(127345,'2023-12-20',720,7505),(127348,'2023-12-20',200,10268),(127349,'2023-12-20',120,314),(127351,'2023-12-20',150,10726),(127352,'2023-12-20',452,10557),(127353,'2023-12-20',330,10885),(127354,'2023-12-20',100,8212),(127358,'2023-12-21',180,9226),(127359,'2023-12-21',100,3411),(127360,'2023-12-21',100,5907),(127361,'2023-12-21',100,4692),(127364,'2023-12-21',320,10902),(127367,'2023-12-21',95,1419),(127371,'2023-12-21',120,7834),(127372,'2023-12-21',330,3),(127380,'2023-12-22',370,10903),(127382,'2023-12-22',370,10903),(127384,'2023-12-22',330,3814),(127385,'2023-12-22',160,314),(127386,'2023-12-22',90,1330),(127387,'2023-12-22',160,7911),(127388,'2023-12-22',130,5375),(127389,'2023-12-22',161,869),(127392,'2023-12-22',480,10837),(127395,'2023-12-22',150,2759),(127400,'2023-12-23',150,2327),(127401,'2023-12-23',280,7342),(127402,'2023-12-23',440,3880),(127404,'2023-12-23',80,10473),(127407,'2023-12-23',260,9642),(127408,'2023-12-26',530,10879),(127409,'2023-12-26',160,3),(127411,'2023-12-26',550,5658),(127412,'2023-12-26',150,596),(127414,'2023-12-26',200,4801),(127415,'2023-12-26',110,5375),(127416,'2023-12-26',150,10849),(127418,'2023-12-26',550,5658),(127419,'2023-12-26',300,10473),(127421,'2023-12-27',265,10473),(127422,'2023-12-27',370,10740),(127424,'2023-12-28',120,9714),(127433,'2023-12-29',80,10740),(127434,'2023-12-29',163,10466),(127437,'2023-12-29',440,9007),(127438,'2023-12-29',105,4692),(127440,'2023-12-29',240,8216),(127442,'2023-12-30',120,397),(127443,'2023-12-30',175,8517),(127446,'2024-01-02',120,6347),(127451,'2024-01-03',102,9488),(127455,'2024-01-04',325,10515),(127456,'2024-01-04',150,441),(127459,'2024-01-05',245,10701),(127460,'2024-01-05',125,8312),(127461,'2024-01-05',260,10369),(127462,'2024-01-05',283,10268),(127464,'2024-01-05',130,3861),(127471,'2024-01-06',250,9147),(127472,'2024-01-06',290,5327),(127473,'2024-01-06',530,7342),(127474,'2024-01-06',350,1891),(127476,'2024-01-06',140,5674),(127478,'2024-01-06',75,2725),(127482,'2024-01-08',110,5375),(127483,'2024-01-08',80,10691),(127484,'2024-01-08',90,10639),(127485,'2024-01-08',110,5741),(127487,'2024-01-09',120,490),(127488,'2024-01-09',230,6322),(127490,'2024-01-09',340,10904),(127495,'2024-01-10',280,7342),(127496,'2024-01-10',90,10811),(127498,'2024-01-10',330,10620),(127501,'2024-01-10',460,8521),(127502,'2024-01-11',130,273),(127504,'2024-01-11',200,10548),(127506,'2024-01-11',70,9642),(127508,'2024-01-11',250,1850),(127509,'2024-01-11',95,863),(127511,'2024-01-11',80,5840),(127512,'2024-01-11',110,9964),(127513,'2024-01-11',216,824),(127515,'2024-01-12',230,4538),(127516,'2024-01-12',200,10820),(127517,'2024-01-12',345,10641),(127518,'2024-01-12',155,5375),(127524,'2024-01-13',350,7911),(127530,'2024-01-16',120,7851),(127533,'2024-01-17',190,754),(127535,'2024-01-18',280,10909),(127537,'2024-01-18',155,10473),(127538,'2024-01-18',253,3473),(127548,'2024-01-19',415,10827),(127551,'2024-01-19',400,596),(127553,'2024-01-19',475,10914),(127556,'2024-01-20',330,8652),(127558,'2024-01-20',460,10849),(127570,'2024-01-22',330,10879),(127580,'2024-01-23',190,5612),(127581,'2024-01-23',120,10268),(127585,'2024-01-23',110,5375),(127591,'2024-01-24',170,8517),(127593,'2024-01-24',232,10824),(127597,'2024-01-24',180,9362),(127598,'2024-01-24',420,10707),(127600,'2024-01-25',100,10824),(127601,'2024-01-25',390,10420),(127603,'2024-01-25',100,10867),(127604,'2024-01-25',480,7834),(127608,'2024-01-26',120,3905),(127609,'2024-01-26',120,3905),(127615,'2024-01-26',500,10817),(127616,'2024-01-26',160,10511),(127618,'2024-01-26',430,5156),(127621,'2024-01-27',145,9860),(127626,'2024-01-27',120,10473),(127630,'2024-01-27',160,397),(127632,'2024-01-27',210,10247),(127636,'2024-01-27',280,351),(127640,'2024-01-27',600,10885),(127648,'2024-01-29',130,10671),(127650,'2024-01-29',200,9362),(127656,'2024-01-29',250,8863),(127657,'2024-01-30',260,10879),(127666,'2024-02-01',300,6452),(127671,'2024-02-01',292,10849),(127677,'2024-02-02',120,5375),(127678,'2024-02-02',300,4687),(127679,'2024-02-02',460,1046),(127680,'2024-02-02',200,10779),(127683,'2024-02-02',460,1046),(127688,'2024-02-03',260,9964),(127690,'2024-02-03',110,9642),(127692,'2024-02-03',190,10492),(127693,'2024-02-03',110,9642),(127694,'2024-02-03',210,10473),(127697,'2024-02-03',410,2565),(127698,'2024-02-03',300,7564),(127701,'2024-02-05',190,10641),(127708,'2024-02-06',240,10525),(127709,'2024-02-06',350,5327),(127714,'2024-02-07',170,9396),(127721,'2024-02-08',160,10918),(127726,'2024-02-08',200,10126),(127728,'2024-02-08',190,754),(127730,'2024-02-08',330,189),(127732,'2024-02-08',330,10557),(127733,'2024-02-08',220,10641),(127735,'2024-02-09',240,10240),(127738,'2024-02-09',170,6788),(127744,'2024-02-09',120,490),(127746,'2024-02-09',230,10641),(127748,'2024-02-09',120,441),(127752,'2024-02-10',138,7481),(127754,'2024-02-10',120,5778),(127757,'2024-02-12',220,9541),(127759,'2024-02-12',200,8212),(127761,'2024-02-12',110,10473),(127762,'2024-02-12',230,2565),(127763,'2024-02-12',100,10920),(127764,'2024-02-12',110,5375),(127765,'2024-02-14',210,7064),(127768,'2024-02-14',250,5778),(127769,'2024-02-14',200,10567),(127772,'2024-02-14',285,10268),(127773,'2024-02-14',150,7026),(127778,'2024-02-15',425,6322),(127779,'2024-02-15',140,5327),(127780,'2024-02-15',125,8312),(127783,'2024-02-15',150,754),(127787,'2024-02-16',180,10141),(127789,'2024-02-16',150,3526),(127792,'2024-02-16',210,7911),(127796,'2024-02-17',300,863),(127803,'2024-02-17',260,10849),(127804,'2024-02-17',400,2725),(127805,'2024-02-17',135,2725),(127806,'2024-02-17',560,10879),(127808,'2024-02-17',410,10210),(127812,'2024-02-20',105,397),(127813,'2024-02-20',170,490),(127818,'2024-02-21',280,7342),(127819,'2024-02-21',225,10473),(127824,'2024-02-22',700,10820),(127829,'2024-02-22',170,5327),(127833,'2024-02-23',150,8517),(127839,'2024-02-23',160,5375),(127843,'2024-02-23',400,10772),(127844,'2024-02-23',490,10917),(127846,'2024-02-23',100,10557),(127854,'2024-02-24',140,2759),(127858,'2024-02-24',390,1542),(127860,'2024-02-24',140,1850),(127863,'2024-02-24',110,10473),(127873,'2024-02-27',130,10766),(127877,'2024-02-27',120,10369),(127878,'2024-02-27',130,5424),(127879,'2024-02-27',125,7409),(127896,'2024-02-29',200,10701),(127901,'2024-02-29',190,10511),(127909,'2024-03-01',130,10671),(127910,'2024-03-01',110,10691),(127915,'2024-03-01',350,10641),(127916,'2024-03-01',120,9860),(127919,'2024-03-02',170,273),(127922,'2024-03-02',450,10849),(127923,'2024-03-02',250,10928),(127924,'2024-03-02',380,5585),(127928,'2024-03-02',150,824),(127932,'2024-03-04',590,5156),(127934,'2024-03-05',120,9396),(127935,'2024-03-05',230,5327),(127941,'2024-03-06',370,7105),(127944,'2024-03-06',190,5612),(127945,'2024-03-06',205,10473),(127948,'2024-03-07',150,7911),(127950,'2024-03-07',190,3814),(127952,'2024-03-07',103,10424),(127954,'2024-03-07',150,1393),(127955,'2024-03-07',600,10920),(127961,'2024-03-08',100,10824),(127963,'2024-03-08',315,622),(127965,'2024-03-08',228,9374),(127966,'2024-03-08',420,3429),(127971,'2024-03-09',400,10933),(127972,'2024-03-09',250,10326),(127975,'2024-03-09',285,9488),(127978,'2024-03-09',160,397),(127982,'2024-03-09',420,10868),(127984,'2024-03-09',345,351),(127987,'2024-03-11',110,5375),(127989,'2024-03-11',190,10525),(127990,'2024-03-12',288,2759),(127993,'2024-03-12',445,10008),(128006,'2024-03-14',105,4692),(128010,'2024-03-14',175,8312),(128018,'2024-03-15',107,391),(128021,'2024-03-15',150,6788),(128022,'2024-03-15',230,10824),(128023,'2024-03-15',160,5375),(128024,'2024-03-15',240,8216),(128026,'2024-03-15',120,10471),(128029,'2024-03-16',190,9642),(128030,'2024-03-16',400,9007),(128031,'2024-03-16',120,10753),(128033,'2024-03-16',110,10473),(128036,'2024-03-16',260,7317),(128037,'2024-03-18',190,9488),(128039,'2024-03-18',120,10671),(128043,'2024-03-18',300,4369),(128047,'2024-03-20',120,3814),(128048,'2024-03-20',120,10289),(128053,'2024-03-21',150,8517),(128054,'2024-03-21',480,1046),(128057,'2024-03-21',480,10420),(128061,'2024-03-22',100,7901),(128064,'2024-03-22',100,99),(128070,'2024-03-23',120,1872),(128071,'2024-03-23',230,1046),(128080,'2024-03-23',800,10938),(128081,'2024-03-23',205,10473),(128083,'2024-03-23',120,9488);
/*!40000 ALTER TABLE `vendas` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-03-23 19:30:00
