-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdados.sql
More file actions
137 lines (118 loc) · 35.6 KB
/
dados.sql
File metadata and controls
137 lines (118 loc) · 35.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
-- MySQL dump 10.13 Distrib 8.0.42, for Win64 (x86_64)
--
-- Host: localhost Database: xp_zone
-- ------------------------------------------------------
-- Server version 8.0.42
/*!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 utf8 */;
/*!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 `clientes`
--
DROP TABLE IF EXISTS `clientes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clientes` (
`idclientes` int NOT NULL AUTO_INCREMENT,
`nome_clientes` varchar(45) NOT NULL,
`estado_clientes` varchar(45) DEFAULT NULL,
PRIMARY KEY (`idclientes`)
) ENGINE=InnoDB AUTO_INCREMENT=241 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `clientes`
--
LOCK TABLES `clientes` WRITE;
/*!40000 ALTER TABLE `clientes` DISABLE KEYS */;
INSERT INTO `clientes` VALUES (1,'Ana Souza','GO'),(2,'Bruno Lima','GO'),(3,'Carlos Mendes','PA'),(4,'Daniela Silva','MT'),(5,'Eduardo Costa','MG'),(6,'Fernanda Oliveira','MG'),(7,'Gabriel Almeida','PI'),(8,'Helena Castro','MG'),(9,'Igor Pereira','PR'),(10,'Juliana Ramos','PE'),(11,'Lucas Silva','SP'),(12,'Ana Beatriz Rocha','RJ'),(13,'Carlos Eduardo Almeida','MG'),(14,'Fernanda Souza','BA'),(15,'Marcos Vinícius Lima','RS'),(16,'Juliana Castro','PR'),(17,'Pedro Henrique Oliveira','PE'),(18,'Camila Ribeiro','CE'),(19,'Gabriel Fernandes','DF'),(20,'Larissa Martins','GO'),(21,'Renan Costa','SC'),(22,'Beatriz Cardoso','ES'),(23,'Thiago Menezes','AM'),(24,'Aline Duarte','MA'),(25,'João Pedro Nunes','PA'),(26,'Sabrina Lopes','PB'),(27,'Vinícius Machado','RN'),(28,'Patrícia Freitas','PI'),(29,'Diego Barros','MT'),(30,'Isabela Moura','MS'),(31,'Caio Pinto','SE'),(32,'Natália Figueiredo','TO'),(33,'Andréa Teixeira','AC'),(34,'Rafael Antunes','RO'),(35,'Bianca Guimarães','AP'),(36,'Gustavo Pires','RR'),(37,'Elaine Tavares','AL'),(38,'Matheus Sampaio','RS'),(39,'Joana Lima','SP'),(40,'Danilo Rezende','RJ'),(41,'Luana Barbosa','MG'),(42,'Rogério Campos','BA'),(43,'Paula Monteiro','PR'),(44,'Fábio Neves','CE'),(45,'Simone Braga','PE'),(46,'Henrique Rocha','GO'),(47,'Adriana Cunha','AM'),(48,'Otávio Fernandes','PA'),(49,'Daniela Soares','PB'),(50,'Luciano Mendes','MA'),(51,'Letícia Nogueira','RN'),(52,'Rodrigo Azevedo','MT'),(53,'Eduarda Silva','MS'),(54,'Igor Farias','SC'),(55,'Vanessa Moraes','ES'),(56,'Tainá Araújo','TO'),(57,'Bruno Batista','RO'),(58,'Amanda Xavier','AC'),(59,'Felipe Duarte','RR'),(60,'Priscila Vieira','AP'),(61,'Murilo Peixoto','AL'),(62,'Tatiane Reis','SE'),(63,'Giovana Mello','SP'),(64,'Cauã Viana','RJ'),(65,'Milena Paiva','MG'),(66,'Luan Ribeiro','RS'),(67,'Juliane Costa','PR'),(68,'Samuel Teixeira','PE'),(69,'Débora Martins','CE'),(70,'Hugo Fernandes','DF'),(71,'Brenda Castro','GO'),(72,'Wesley Andrade','SC'),(73,'Viviane Lopes','ES'),(74,'Leonardo Cardoso','AM'),(75,'Carla Torres','MA'),(76,'Douglas Almeida','PA'),(77,'Isadora Matos','PB'),(78,'Leandro Nascimento','PI'),(79,'Tatiana Sales','MT'),(80,'Nelson Brito','MS'),(81,'Evelyn Moura','SE'),(82,'Ricardo Silva','TO'),(83,'Flávia Rocha','AC'),(84,'Renata Gomes','RO'),(85,'Marcelo Barros','RR'),(86,'Jéssica Lima','AP'),(87,'João Paulo Costa','AL'),(88,'Cristiane Souza','SP'),(89,'Sandro Oliveira','RJ'),(90,'Cíntia Menezes','MG'),(91,'Érico Pacheco','BA'),(92,'Sueli Santos','RS'),(93,'Hélio Fonseca','PR'),(94,'Bianca Ramos','CE'),(95,'Wellington Lopes','PE'),(96,'Silvana Pereira','GO'),(97,'Caíque Rocha','AM'),(98,'Marta Xavier','PA'),(99,'Ronaldo Dias','PB'),(100,'Nívia Carvalho','MA'),(101,'Jefferson Macedo','RN'),(102,'Tereza Lima','PI'),(103,'Mariana Guedes','MT'),(104,'Cristiano Campos','MS'),(105,'Andressa Faria','SE'),(106,'Eliane Borges','TO'),(107,'Victor Almeida','RO'),(108,'Juliana Prado','AC'),(109,'Túlio Amaral','RR'),(110,'Lorena Cunha','AP'),(111,'Tatiana Vieira','AL'),(112,'Carlos Henrique Luz','SP'),(113,'Juliano César','RJ'),(114,'Tânia Maria','MG'),(115,'Giselle Nogueira','BA'),(116,'Cauê Moura','RS'),(117,'Tatiane Ferreira','PR'),(118,'Danilo Gonçalves','PE'),(119,'Alessandra Barros','CE'),(120,'Thiago Ramos','DF'),(121,'Janaína Sousa','GO'),(122,'Gustavo Pinto','SC'),(123,'Vanessa Lima','ES'),(124,'Luciano Gomes','AM'),(125,'Rosana Duarte','MA'),(126,'Alex Teixeira','PA'),(127,'Caroline Machado','PB'),(128,'Renato Andrade','PI'),(129,'Jéssica Farias','MT'),(130,'Luciene Costa','MS'),(131,'Murilo Lima','SE'),(132,'Monique Tavares','TO'),(133,'Davi Campos','AC'),(134,'Rayssa Moraes','RO'),(135,'Vinícius Prado','RR'),(136,'Suelen Silva','AP'),(137,'André Luiz Gomes','AL'),(138,'Mirela Fernandes','SP'),(139,'Cauã Neves','RJ'),(140,'Juliana Martins','MG'),(141,'Tiago Costa','RS'),(142,'Amanda Oliveira','BA'),(143,'Eduardo Nunes','PR'),(144,'Roberta Souza','CE'),(145,'Caio Vinícius','PE'),(146,'Gabriela Lopes','GO'),(147,'Yuri Ferreira','AM'),(148,'Daniela Amaral','MA'),(149,'Bruno Rodrigues','PA'),(150,'Adriano Castro','PB'),(151,'Isis Rocha','PI'),(152,'Felipe Lima','MT'),(153,'Larissa Fernandes','MS'),(154,'Mônica Barros','SE'),(155,'Diogo Silveira','TO'),(156,'Sheila Martins','AC'),(157,'Hugo Ribeiro','RO'),(158,'Robson Carvalho','RR'),(159,'Sabrina Duarte','AP'),(160,'Mariana Souza','AL'),(161,'Rodrigo Monteiro','SP'),(162,'Renata Vieira','RJ'),(163,'Leonardo Moura','MG'),(164,'Viviane Gomes','BA'),(165,'Otávio Lima','RS'),(166,'Beatriz Andrade','PR'),(167,'Henrique Costa','PE'),(168,'Evelyn Oliveira','CE'),(169,'Bruno Almeida','DF'),(170,'Júlia Ferreira','GO'),(171,'Aline Cardoso','SC'),(172,'Vinícius Ramos','ES'),(173,'Nathália Nogueira','AM'),(174,'William Campos','MA'),(175,'Lívia Melo','PA'),(176,'Rafael Machado','PB'),(177,'Bianca Fonseca','PI'),(178,'Fábio Lima','MT'),(179,'Vanessa Santos','MS'),(180,'Camila Reis','SE'),(181,'Jéssica Ribeiro','TO'),(182,'Lucas Nogueira','AC'),(183,'Larissa Siqueira','RO'),(184,'Ricardo Pires','RR'),(185,'Luísa Costa','AP'),(186,'Alan Tavares','AL'),(187,'Débora Rocha','SP'),(188,'Cristiano Vieira','RJ'),(189,'Tatiane Gomes','MG'),(190,'Edson Barbosa','BA'),(191,'Nayara Martins','RS'),(192,'Marcos Souza','PR'),(193,'Vanessa Silva','PE'),(194,'Fernando Lima','CE'),(195,'Flávia Campos','DF'),(196,'Anderson Cardoso','GO'),(197,'Daniel Santos','SC'),(198,'Eduardo Silva','ES'),(199,'Tatiane Freitas','AM'),(200,'Bruno Costa','MA'),(201,'Larissa Duarte','PA'),(202,'Juliano Melo','PB'),(203,'Cátia Oliveira','PI'),(204,'Rodrigo Vieira','MT'),(205,'Kelly Souza','MS'),(206,'Fábio Fernandes','SE'),(207,'Carla Ramos','TO');
/*!40000 ALTER TABLE `clientes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `produtos_servicos`
--
DROP TABLE IF EXISTS `produtos_servicos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `produtos_servicos` (
`idprodutos_servicos` int NOT NULL AUTO_INCREMENT,
`nome_produtos_servicos` varchar(45) NOT NULL,
`valor_produtos_servicos` decimal(10,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`idprodutos_servicos`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `produtos_servicos`
--
LOCK TABLES `produtos_servicos` WRITE;
/*!40000 ALTER TABLE `produtos_servicos` DISABLE KEYS */;
INSERT INTO `produtos_servicos` VALUES (1,'Mouse Longitec 305',229.90),(2,'Teclado mecânico K68',119.90),(3,'SSD M2 Kingston',419.90),(4,'Funko Pop Homem de Ferro',194.12),(5,'Caneca Star Wars Darth Vader',387.55),(6,'Almofada Controle Nintendo',316.09),(7,'Mousepad Gamer Naruto',206.14),(8,'Chaveiro Pokébola',180.54),(9,'Luminária Super Mario Question Block',281.56),(10,'Relógio de Parede Batman',414.51),(11,'Camiseta Stranger Things',52.78),(12,'Poster Vingadores Endgame',236.86),(13,'Mochila Harry Potter',339.44),(14,'Carteira Game of Thrones',103.01),(15,'Capinha para Celular Marvel',159.48),(16,'Quadro Decorativo Zelda',215.43),(17,'Boné Dragon Ball Z',141.67),(18,'Action Figure Groot',457.53),(19,'Caderno Death Note',238.32),(20,'Quebra-Cabeça Hogwarts',516.79),(21,'Mouse RGB Cyberpunk',102.99),(22,'Controle Sem Fio Xbox Halo Edition',505.69),(23,'Suporte para Fone de Ouvido Mandaloriano',571.04),(24,'Caneca térmica Hogwarts',307.94),(25,'Chaveiro Baby Yoda',168.08),(26,'Fone de ouvido Star Wars',451.83),(27,'Tapete de porta You Shall Not Pass',168.18),(28,'Mousepad Rick and Morty',167.47),(29,'Capacete Colecionável Stormtrooper',300.97),(30,'Porta-copos One Piece',538.77),(31,'Luminária 3D Totoro',126.92),(32,'Camiseta The Witcher',242.06),(33,'Garrafa Térmica Loki',148.91),(34,'Bloco de notas Portal',246.65),(35,'Adesivos Among Us',389.18),(36,'Almofada Pac-Man',144.62),(37,'Caneca PlayStation',543.55),(38,'Miniatura Batmóvel',153.02),(39,'Carteira Zelda',59.96),(40,'Boneco colecionável Venom',163.55),(41,'Camiseta Attack on Titan',160.83),(42,'Caderno Marvel',464.07),(43,'Relógio digital Iron Man',284.84),(44,'Capinha iPhone Goku',364.15),(45,'Fone de ouvido Pikachu',152.79),(46,'Poster Blade Runner 2049',194.58),(47,'Boné Capitão América',528.07),(48,'Moletom Hogwarts',475.96),(49,'Pulseira Homem-Aranha',352.23),(50,'Boneco Thanos articulado',470.66),(51,'Estátua Kratos God of War',137.53),(52,'Kit de ímãs The Office',539.30),(53,'Luminária Pokébola',406.87),(54,'Camiseta Mandalorian',552.43),(55,'Controle PS5 Spider-Man Edition',251.68),(56,'Caneca Cyberpunk 2077',266.90),(57,'Pelúcia Kirby',437.15),(58,'Camiseta Resident Evil',324.47),(59,'Porta-retrato Star Wars',86.49),(60,'Mousepad Marvel Avengers',150.96),(61,'Caderno Stranger Things',486.85),(62,'Moletom The Last of Us',505.97),(63,'Pôster Cyberpunk',488.66),(64,'Chaveiro Among Us',386.67),(65,'Camiseta Sonic',238.47),(66,'Boneco R2D2 colecionável',234.44),(67,'Garrafa térmica Marvel',144.33),(68,'Caneca Among Us',488.03),(69,'Luminária Iron Man',298.91),(70,'Carteira Assassins Creed',468.95),(71,'Adesivo Rick and Morty',569.26),(72,'Camiseta Mortal Kombat',472.42),(73,'Caixa de som Bluetooth Groot',293.03),(74,'Almofada Mario Kart',452.48),(75,'Caneta Harry Potter',92.73),(76,'Controle arcade retrô',87.72),(77,'Fone sem fio Goku Edition',135.26),(78,'Miniatura Millennium Falcon',158.26),(79,'Livro de arte Zelda',256.02),(80,'Camiseta Rick and Morty',426.70),(81,'Chaveiro Game Boy',170.32),(82,'Moletom Pokémon',354.47),(83,'Capa para notebook Stranger Things',348.91),(84,'Quadro Loki',473.69),(85,'Action Figure Sub-Zero',500.95),(86,'Mouse gamer RGB One Piece',251.00),(87,'Caneca The Mandalorian',450.44),(88,'Almofada Donkey Kong',409.20),(89,'Pôster WandaVision',287.21),(90,'Miniatura Robô Wall-E',579.62),(91,'Carteira Batman',155.61),(92,'Camiseta Star Wars Millennium Falcon',207.86),(93,'Pelúcia Totoro',252.90),(94,'Mousepad The Witcher',573.50),(95,'Relógio digital Goku',346.63),(96,'Caderno Hogwarts',484.38),(97,'Chaveiro Zelda Triforce',281.71),(98,'Boné The Legend of Zelda',271.03),(99,'Caneca Genshin Impact',471.97),(100,'Fone de ouvido Demon Slayer',510.32),(101,'Luminária Minecraft',323.34),(102,'Porta lápis Thor',417.97),(103,'Camiseta Fullmetal Alchemist',496.33),(104,'Carteira One Piece',248.43),(105,'Camiseta Tokyo Ghoul',442.49);
/*!40000 ALTER TABLE `produtos_servicos` 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` (
`idvendas` int NOT NULL AUTO_INCREMENT,
`vendas_produtos_servicos` int DEFAULT NULL,
`vendas_clientes` int DEFAULT NULL,
`vendas_vendedores` int DEFAULT NULL,
`desconto` decimal(5,2) DEFAULT '0.00',
`valor_final` decimal(10,2) DEFAULT '0.00',
`vendas_departamento` varchar(45) DEFAULT NULL,
`vendas_data` date DEFAULT NULL,
PRIMARY KEY (`idvendas`),
KEY `clientes_idx` (`vendas_clientes`),
KEY `produtos_idx` (`vendas_produtos_servicos`),
KEY `vendedores_idx` (`vendas_vendedores`),
CONSTRAINT `clientes` FOREIGN KEY (`vendas_clientes`) REFERENCES `clientes` (`idclientes`),
CONSTRAINT `produtos` FOREIGN KEY (`vendas_produtos_servicos`) REFERENCES `produtos_servicos` (`idprodutos_servicos`),
CONSTRAINT `vendedores` FOREIGN KEY (`vendas_vendedores`) REFERENCES `vendedores` (`idvendedores`)
) ENGINE=InnoDB AUTO_INCREMENT=910 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!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 (1,12,45,3,10.00,135.00,'Loja física','2023-10-02'),(2,88,201,5,0.00,89.90,'Loja online','2023-10-02'),(3,5,178,2,15.00,425.50,'Loja física','2023-10-03'),(4,103,32,1,5.00,237.00,'Loja online','2023-10-03'),(5,67,199,6,25.00,1125.00,'Loja física','2023-10-04'),(6,41,123,4,20.00,316.80,'Loja online','2023-10-05'),(7,9,76,3,0.00,75.00,'Loja física','2023-10-06'),(8,92,110,2,10.00,405.00,'Loja online','2023-10-07'),(9,14,155,1,5.00,190.00,'Loja física','2023-10-08'),(10,55,88,5,15.00,722.50,'Loja online','2023-10-09'),(11,27,112,4,0.00,65.00,'Loja física','2023-10-10'),(12,73,45,6,10.00,198.00,'Loja online','2023-10-11'),(13,104,189,3,20.00,476.00,'Loja física','2023-10-12'),(14,18,30,2,5.00,142.50,'Loja online','2023-10-13'),(15,61,77,1,15.00,637.50,'Loja física','2023-10-14'),(16,33,144,5,25.00,937.50,'Loja online','2023-10-15'),(17,96,56,4,0.00,120.00,'Loja física','2023-10-16'),(18,7,198,3,10.00,270.00,'Loja online','2023-10-17'),(19,82,22,2,5.00,237.50,'Loja física','2023-10-18'),(20,49,167,1,15.00,552.50,'Loja online','2023-10-19'),(21,105,93,6,20.00,400.00,'Loja física','2023-10-20'),(22,29,11,5,0.00,45.00,'Loja online','2023-10-21'),(23,64,78,4,10.00,171.00,'Loja física','2023-10-22'),(24,3,134,3,5.00,95.00,'Loja online','2023-10-23'),(25,87,205,2,25.00,1125.00,'Loja física','2023-10-24'),(26,51,99,1,0.00,80.00,'Loja online','2023-10-25'),(27,22,177,6,15.00,425.00,'Loja física','2023-10-26'),(28,76,43,5,20.00,320.00,'Loja online','2023-10-27'),(29,13,156,4,5.00,142.50,'Loja física','2023-10-28'),(30,94,89,3,10.00,315.00,'Loja online','2023-10-29'),(31,38,122,2,0.00,55.00,'Loja física','2023-10-30'),(32,101,67,1,25.00,937.50,'Loja online','2023-10-31'),(33,16,145,6,5.00,190.00,'Loja física','2023-11-01'),(34,72,33,5,15.00,510.00,'Loja online','2023-11-02'),(35,45,188,4,20.00,400.00,'Loja física','2023-11-03'),(36,8,76,3,0.00,120.00,'Loja online','2023-11-04'),(37,97,114,2,10.00,270.00,'Loja física','2023-11-05'),(38,24,98,1,5.00,142.50,'Loja online','2023-11-06'),(39,83,56,6,15.00,552.50,'Loja física','2023-11-07'),(40,37,201,5,25.00,1125.00,'Loja online','2023-11-08'),(41,62,123,4,0.00,65.00,'Loja física','2023-11-09'),(42,19,45,3,20.00,480.00,'Loja online','2023-11-10'),(43,105,178,2,5.00,237.50,'Loja física','2023-11-11'),(44,41,32,1,10.00,360.00,'Loja online','2023-11-12'),(45,78,199,6,15.00,637.50,'Loja física','2023-11-13'),(46,11,110,5,0.00,45.00,'Loja online','2023-11-14'),(47,89,155,4,25.00,937.50,'Loja física','2023-11-15'),(48,35,88,3,5.00,95.00,'Loja online','2023-11-16'),(49,102,112,2,10.00,198.00,'Loja física','2023-11-17'),(50,47,189,1,20.00,480.00,'Loja online','2023-11-18'),(51,6,30,6,0.00,120.00,'Loja física','2023-11-19'),(52,91,77,5,15.00,425.00,'Loja online','2023-11-20'),(53,26,144,4,5.00,190.00,'Loja física','2023-11-21'),(54,84,56,3,10.00,315.00,'Loja online','2023-11-22'),(55,39,198,2,25.00,1125.00,'Loja física','2023-11-23'),(56,104,22,1,0.00,80.00,'Loja online','2023-11-24'),(57,17,167,6,20.00,320.00,'Loja física','2023-11-25'),(58,73,93,5,5.00,142.50,'Loja online','2023-11-26'),(59,48,11,4,10.00,270.00,'Loja física','2023-11-27'),(60,1,78,3,15.00,510.00,'Loja online','2023-11-28'),(61,86,134,2,0.00,55.00,'Loja física','2023-11-29'),(62,31,205,1,5.00,237.50,'Loja online','2023-11-30'),(63,99,99,6,25.00,937.50,'Loja física','2023-12-01'),(64,42,177,5,10.00,198.00,'Loja online','2023-12-02'),(65,15,43,4,20.00,400.00,'Loja física','2023-12-03'),(66,93,156,3,0.00,120.00,'Loja online','2023-12-04'),(67,28,89,2,15.00,425.00,'Loja física','2023-12-05'),(68,85,122,1,5.00,190.00,'Loja online','2023-12-06'),(69,40,67,6,10.00,315.00,'Loja física','2023-12-07'),(70,103,145,5,25.00,1125.00,'Loja online','2023-12-08'),(71,20,33,4,0.00,65.00,'Loja física','2023-12-09'),(72,77,188,3,20.00,480.00,'Loja online','2023-12-10'),(73,50,76,2,5.00,142.50,'Loja física','2023-12-11'),(74,4,114,1,15.00,637.50,'Loja online','2023-12-12'),(75,81,98,6,0.00,45.00,'Loja física','2023-12-13'),(76,34,56,5,10.00,270.00,'Loja online','2023-12-14'),(77,100,201,4,5.00,95.00,'Loja física','2023-12-15'),(78,23,123,3,25.00,937.50,'Loja online','2023-12-16'),(79,90,45,2,10.00,198.00,'Loja física','2023-12-17'),(80,53,178,1,20.00,320.00,'Loja online','2023-12-18'),(81,10,32,6,0.00,120.00,'Loja física','2023-12-19'),(82,95,199,5,15.00,425.00,'Loja online','2023-12-20'),(83,30,110,4,5.00,190.00,'Loja física','2023-12-21'),(84,79,155,3,10.00,315.00,'Loja online','2023-12-22'),(85,44,88,2,25.00,1125.00,'Loja física','2023-12-23'),(86,2,112,1,0.00,80.00,'Loja online','2023-12-24'),(87,87,189,6,20.00,400.00,'Loja física','2023-12-25'),(88,36,30,5,5.00,142.50,'Loja online','2023-12-26'),(89,101,77,4,15.00,510.00,'Loja física','2023-12-27'),(90,21,144,3,0.00,55.00,'Loja online','2023-12-28'),(91,80,56,2,10.00,270.00,'Loja física','2023-12-29'),(92,43,198,1,5.00,237.50,'Loja online','2023-12-30'),(93,98,22,6,25.00,937.50,'Loja física','2023-12-31'),(94,25,167,5,10.00,198.00,'Loja online','2023-10-01'),(95,82,93,4,20.00,480.00,'Loja física','2023-10-04'),(96,9,11,3,0.00,120.00,'Loja online','2023-10-05'),(97,92,78,2,15.00,425.00,'Loja física','2023-10-06'),(98,14,134,1,5.00,190.00,'Loja online','2023-10-07'),(99,55,205,6,10.00,315.00,'Loja física','2023-10-08'),(100,27,99,5,25.00,1125.00,'Loja online','2023-10-09'),(101,73,177,4,0.00,65.00,'Loja física','2023-10-10'),(102,104,43,3,20.00,400.00,'Loja online','2023-10-11'),(103,18,156,2,5.00,142.50,'Loja física','2023-10-12'),(104,61,89,1,15.00,637.50,'Loja online','2023-10-13'),(105,33,122,6,0.00,45.00,'Loja física','2023-10-14'),(106,96,67,5,10.00,270.00,'Loja online','2023-10-15'),(107,7,145,4,5.00,95.00,'Loja física','2023-10-16'),(108,82,33,3,25.00,937.50,'Loja online','2023-10-17'),(109,49,188,2,10.00,198.00,'Loja física','2023-10-18'),(110,105,76,1,20.00,320.00,'Loja online','2023-10-19'),(111,29,114,6,0.00,120.00,'Loja física','2023-10-20'),(112,64,98,5,15.00,425.00,'Loja online','2023-10-21'),(113,3,56,4,5.00,190.00,'Loja física','2023-10-22'),(114,87,201,3,10.00,315.00,'Loja online','2023-10-23'),(115,51,123,2,25.00,1125.00,'Loja física','2023-10-24'),(116,22,45,1,0.00,80.00,'Loja online','2023-10-25'),(117,76,178,6,20.00,400.00,'Loja física','2023-10-26'),(118,13,32,5,5.00,142.50,'Loja online','2023-10-27'),(119,94,199,4,15.00,510.00,'Loja física','2023-10-28'),(120,38,110,3,0.00,55.00,'Loja online','2023-10-29'),(121,101,155,2,10.00,270.00,'Loja física','2023-10-30'),(122,16,88,1,5.00,237.50,'Loja online','2023-10-31'),(123,72,112,6,25.00,937.50,'Loja física','2023-11-01'),(124,45,189,5,10.00,198.00,'Loja online','2023-11-02'),(125,8,30,4,20.00,480.00,'Loja física','2023-11-03'),(126,97,77,3,0.00,120.00,'Loja online','2023-11-04'),(127,24,144,2,15.00,425.00,'Loja física','2023-11-05'),(128,83,56,1,5.00,190.00,'Loja online','2023-11-06'),(129,37,198,6,10.00,315.00,'Loja física','2023-11-07'),(130,62,22,5,25.00,1125.00,'Loja online','2023-11-08'),(131,19,167,4,0.00,65.00,'Loja física','2023-11-09'),(132,105,93,3,20.00,400.00,'Loja online','2023-11-10'),(133,41,11,2,5.00,142.50,'Loja física','2023-11-11'),(134,78,78,1,15.00,637.50,'Loja online','2023-11-12'),(135,11,134,6,0.00,45.00,'Loja física','2023-11-13'),(136,89,205,5,10.00,270.00,'Loja online','2023-11-14'),(137,35,99,4,5.00,95.00,'Loja física','2023-11-15'),(138,102,177,3,25.00,937.50,'Loja online','2023-11-16'),(139,47,43,2,10.00,198.00,'Loja física','2023-11-17'),(140,6,156,1,20.00,320.00,'Loja online','2023-11-18'),(141,91,89,6,0.00,120.00,'Loja física','2023-11-19'),(142,26,122,5,15.00,425.00,'Loja online','2023-11-20'),(143,84,67,4,5.00,190.00,'Loja física','2023-11-21'),(144,39,145,3,10.00,315.00,'Loja online','2023-11-22'),(145,104,33,2,25.00,1125.00,'Loja física','2023-11-23'),(146,17,188,1,0.00,80.00,'Loja online','2023-11-24'),(147,73,76,6,20.00,400.00,'Loja física','2023-11-25'),(148,48,114,5,5.00,142.50,'Loja online','2023-11-26'),(149,1,98,4,15.00,510.00,'Loja física','2023-11-27'),(150,86,56,3,0.00,55.00,'Loja online','2023-11-28'),(151,31,201,2,10.00,270.00,'Loja física','2023-11-29'),(152,99,123,1,5.00,237.50,'Loja online','2023-11-30'),(153,42,45,6,25.00,937.50,'Loja física','2023-12-01'),(154,15,178,5,10.00,198.00,'Loja online','2023-12-02'),(155,93,32,4,20.00,480.00,'Loja física','2023-12-03'),(156,28,199,3,0.00,120.00,'Loja online','2023-12-04'),(157,85,110,2,15.00,425.00,'Loja física','2023-12-05'),(158,40,155,1,5.00,190.00,'Loja online','2023-12-06'),(159,103,88,6,10.00,315.00,'Loja física','2023-12-07'),(160,20,112,5,25.00,1125.00,'Loja online','2023-12-08'),(161,77,189,4,0.00,65.00,'Loja física','2023-12-09'),(162,50,30,3,20.00,400.00,'Loja online','2023-12-10'),(163,4,77,2,5.00,142.50,'Loja física','2023-12-11'),(164,81,144,1,15.00,637.50,'Loja online','2023-12-12'),(165,34,56,6,0.00,45.00,'Loja física','2023-12-13'),(166,100,198,5,10.00,270.00,'Loja online','2023-12-14'),(167,23,22,4,5.00,95.00,'Loja física','2023-12-15'),(168,90,167,3,25.00,937.50,'Loja online','2023-12-16'),(169,53,93,2,10.00,198.00,'Loja física','2023-12-17'),(170,10,11,1,20.00,320.00,'Loja online','2023-12-18'),(171,95,78,6,0.00,120.00,'Loja física','2023-12-19'),(172,30,134,5,15.00,425.00,'Loja online','2023-12-20'),(173,79,205,4,5.00,190.00,'Loja física','2023-12-21'),(174,44,99,3,10.00,315.00,'Loja online','2023-12-22'),(175,2,177,2,25.00,1125.00,'Loja física','2023-12-23'),(176,87,43,1,0.00,80.00,'Loja online','2023-12-24'),(177,36,156,6,20.00,400.00,'Loja física','2023-12-25'),(178,101,89,5,5.00,142.50,'Loja online','2023-12-26'),(179,21,122,4,15.00,510.00,'Loja física','2023-12-27'),(180,80,67,3,0.00,55.00,'Loja online','2023-12-28'),(181,43,145,2,10.00,270.00,'Loja física','2023-12-29'),(182,98,33,1,5.00,237.50,'Loja online','2023-12-30'),(183,25,188,6,25.00,937.50,'Loja física','2023-12-31'),(184,82,93,5,10.00,198.00,'Loja online','2023-10-01'),(185,9,11,4,20.00,480.00,'Loja física','2023-10-02'),(186,92,78,3,0.00,120.00,'Loja online','2023-10-03'),(187,14,134,2,15.00,425.00,'Loja física','2023-10-04'),(188,55,205,1,5.00,190.00,'Loja online','2023-10-05'),(189,27,99,6,10.00,315.00,'Loja física','2023-10-06'),(190,73,177,5,25.00,1125.00,'Loja online','2023-10-07'),(191,104,43,4,0.00,65.00,'Loja física','2023-10-08'),(192,18,156,3,20.00,400.00,'Loja online','2023-10-09'),(193,61,89,2,5.00,142.50,'Loja física','2023-10-10'),(194,33,122,1,15.00,637.50,'Loja online','2023-10-11'),(195,96,67,6,0.00,45.00,'Loja física','2023-10-12'),(196,7,145,5,10.00,270.00,'Loja online','2023-10-13'),(197,82,33,4,5.00,95.00,'Loja física','2023-10-14'),(198,49,188,3,25.00,937.50,'Loja online','2023-10-15'),(199,105,76,2,10.00,198.00,'Loja física','2023-10-16'),(200,29,114,1,20.00,320.00,'Loja online','2023-10-17'),(201,64,98,6,0.00,120.00,'Loja física','2023-10-18'),(202,3,56,5,15.00,425.00,'Loja online','2023-10-19'),(203,87,201,4,5.00,190.00,'Loja física','2023-10-20'),(204,51,123,3,10.00,315.00,'Loja online','2023-10-21'),(205,22,45,2,25.00,1125.00,'Loja física','2023-10-22'),(206,76,178,1,0.00,80.00,'Loja online','2023-10-23'),(207,13,32,6,20.00,400.00,'Loja física','2023-10-24'),(208,94,199,5,5.00,142.50,'Loja online','2023-10-25'),(209,38,110,4,15.00,510.00,'Loja física','2023-10-26'),(210,101,155,3,0.00,55.00,'Loja online','2023-10-27'),(211,16,88,2,10.00,270.00,'Loja física','2023-10-28'),(212,72,112,1,5.00,237.50,'Loja online','2023-10-29'),(213,45,189,6,25.00,937.50,'Loja física','2023-10-30'),(214,8,30,5,10.00,198.00,'Loja online','2023-10-31'),(215,97,77,4,20.00,480.00,'Loja física','2023-11-01'),(216,24,144,3,0.00,120.00,'Loja online','2023-11-02'),(217,83,56,2,15.00,425.00,'Loja física','2023-11-03'),(218,37,198,1,5.00,190.00,'Loja online','2023-11-04'),(219,62,22,6,10.00,315.00,'Loja física','2023-11-05'),(220,19,167,5,25.00,1125.00,'Loja online','2023-11-06'),(221,105,93,4,0.00,65.00,'Loja física','2023-11-07'),(222,41,11,3,20.00,400.00,'Loja online','2023-11-08'),(223,78,78,2,5.00,142.50,'Loja física','2023-11-09'),(224,11,134,1,15.00,637.50,'Loja online','2023-11-10'),(225,89,205,6,0.00,45.00,'Loja física','2023-11-11'),(226,35,99,5,10.00,270.00,'Loja online','2023-11-12'),(227,102,177,4,5.00,95.00,'Loja física','2023-11-13'),(228,47,43,3,25.00,937.50,'Loja online','2023-11-14'),(229,6,156,2,10.00,198.00,'Loja física','2023-11-15'),(230,91,89,1,20.00,320.00,'Loja online','2023-11-16'),(231,26,122,6,0.00,120.00,'Loja física','2023-11-17'),(232,84,67,5,15.00,425.00,'Loja online','2023-11-18'),(233,39,145,4,5.00,190.00,'Loja física','2023-11-19'),(234,104,33,3,10.00,315.00,'Loja online','2023-11-20'),(235,17,188,2,25.00,1125.00,'Loja física','2023-11-21'),(236,73,76,1,0.00,80.00,'Loja online','2023-11-22'),(237,48,114,6,20.00,400.00,'Loja física','2023-11-23'),(238,1,98,5,5.00,142.50,'Loja online','2023-11-24'),(239,86,56,4,15.00,510.00,'Loja física','2023-11-25'),(240,31,201,3,0.00,55.00,'Loja online','2023-11-26'),(241,99,123,2,10.00,270.00,'Loja física','2023-11-27'),(242,42,45,1,5.00,237.50,'Loja online','2023-11-28'),(243,15,178,6,25.00,937.50,'Loja física','2023-11-29'),(244,93,32,5,10.00,198.00,'Loja online','2023-11-30'),(245,28,199,4,20.00,480.00,'Loja física','2023-12-01'),(246,85,110,3,0.00,120.00,'Loja online','2023-12-02'),(247,40,155,2,15.00,425.00,'Loja física','2023-12-03'),(248,103,88,1,5.00,190.00,'Loja online','2023-12-04'),(249,20,112,6,10.00,315.00,'Loja física','2023-12-05'),(250,77,189,5,25.00,1125.00,'Loja online','2023-12-06'),(251,50,30,4,0.00,65.00,'Loja física','2023-12-07'),(252,4,77,3,20.00,400.00,'Loja online','2023-12-08'),(253,81,144,2,5.00,142.50,'Loja física','2023-12-09'),(254,34,56,1,15.00,637.50,'Loja online','2023-12-10'),(255,100,198,6,0.00,45.00,'Loja física','2023-12-11'),(256,23,22,5,10.00,270.00,'Loja online','2023-12-12'),(257,90,167,4,5.00,95.00,'Loja física','2023-12-13'),(258,53,93,3,25.00,937.50,'Loja online','2023-12-14'),(259,10,11,2,10.00,198.00,'Loja física','2023-12-15'),(260,95,78,1,20.00,320.00,'Loja online','2023-12-16'),(261,30,134,6,0.00,120.00,'Loja física','2023-12-17'),(262,79,205,5,15.00,425.00,'Loja online','2023-12-18'),(263,44,99,4,5.00,190.00,'Loja física','2023-12-19'),(264,2,177,3,10.00,315.00,'Loja online','2023-12-20'),(265,87,43,2,25.00,1125.00,'Loja física','2023-12-21'),(266,36,156,1,0.00,80.00,'Loja online','2023-12-22'),(267,101,89,6,20.00,400.00,'Loja física','2023-12-23'),(268,21,122,5,5.00,142.50,'Loja online','2023-12-24'),(269,80,67,4,15.00,510.00,'Loja física','2023-12-25'),(270,43,145,3,0.00,55.00,'Loja online','2023-12-26'),(271,98,33,2,10.00,270.00,'Loja física','2023-12-27'),(272,25,188,1,5.00,237.50,'Loja online','2023-12-28'),(273,82,76,6,25.00,937.50,'Loja física','2023-12-29'),(274,9,114,5,10.00,198.00,'Loja online','2023-12-30'),(275,92,98,4,20.00,480.00,'Loja física','2023-12-31'),(276,14,56,3,0.00,120.00,'Loja online','2023-10-01'),(277,55,201,2,15.00,425.00,'Loja física','2023-10-02'),(278,27,123,1,5.00,190.00,'Loja online','2023-10-03'),(279,73,45,6,10.00,315.00,'Loja física','2023-10-04'),(280,104,178,5,25.00,1125.00,'Loja online','2023-10-05'),(281,18,32,4,0.00,65.00,'Loja física','2023-10-06'),(282,61,199,3,20.00,400.00,'Loja online','2023-10-07'),(283,33,110,2,5.00,142.50,'Loja física','2023-10-08'),(284,96,155,1,15.00,637.50,'Loja online','2023-10-09'),(285,7,88,6,0.00,45.00,'Loja física','2023-10-10'),(286,82,112,5,10.00,270.00,'Loja online','2023-10-11'),(287,49,189,4,5.00,95.00,'Loja física','2023-10-12'),(288,105,30,3,25.00,937.50,'Loja online','2023-10-13'),(289,29,77,2,10.00,198.00,'Loja física','2023-10-14'),(290,64,144,1,20.00,320.00,'Loja online','2023-10-15'),(291,3,56,6,0.00,120.00,'Loja física','2023-10-16'),(292,87,198,5,15.00,425.00,'Loja online','2023-10-17'),(293,51,22,4,5.00,190.00,'Loja física','2023-10-18'),(294,22,167,3,10.00,315.00,'Loja online','2023-10-19'),(295,76,93,2,25.00,1125.00,'Loja física','2023-10-20'),(296,13,11,1,0.00,80.00,'Loja online','2023-10-21'),(297,94,78,6,20.00,400.00,'Loja física','2023-10-22'),(298,38,134,5,5.00,142.50,'Loja online','2023-10-23'),(299,101,205,4,15.00,510.00,'Loja física','2023-10-24'),(300,16,99,3,0.00,55.00,'Loja online','2023-10-25'),(301,72,177,2,10.00,270.00,'Loja física','2023-10-26'),(302,45,43,1,5.00,237.50,'Loja online','2023-10-27'),(303,8,156,6,25.00,937.50,'Loja física','2023-10-28'),(304,97,89,5,10.00,198.00,'Loja online','2023-10-29'),(305,24,122,4,20.00,480.00,'Loja física','2023-10-30'),(306,83,67,3,0.00,120.00,'Loja online','2023-10-31'),(307,37,145,2,15.00,425.00,'Loja física','2023-11-01'),(308,62,33,1,5.00,190.00,'Loja online','2023-11-02'),(309,19,188,6,10.00,315.00,'Loja física','2023-11-03'),(310,105,76,5,25.00,1125.00,'Loja online','2023-11-04'),(311,41,114,4,0.00,65.00,'Loja física','2023-11-05'),(312,78,98,3,20.00,400.00,'Loja online','2023-11-06'),(313,11,56,2,5.00,142.50,'Loja física','2023-11-07'),(314,89,201,1,15.00,637.50,'Loja online','2023-11-08'),(315,35,123,6,0.00,45.00,'Loja física','2023-11-09'),(316,102,45,5,10.00,270.00,'Loja online','2023-11-10'),(317,47,178,4,5.00,95.00,'Loja física','2023-11-11'),(318,6,32,3,25.00,937.50,'Loja online','2023-11-12'),(319,91,199,2,10.00,198.00,'Loja física','2023-11-13'),(320,26,110,1,20.00,320.00,'Loja online','2023-11-14'),(321,84,155,6,0.00,120.00,'Loja física','2023-11-15'),(322,39,88,5,15.00,425.00,'Loja online','2023-11-16'),(323,104,112,4,5.00,190.00,'Loja física','2023-11-17'),(324,17,189,3,10.00,315.00,'Loja online','2023-11-18'),(325,73,30,2,25.00,1125.00,'Loja física','2023-11-19'),(326,48,77,1,0.00,80.00,'Loja online','2023-11-20'),(327,1,144,6,20.00,400.00,'Loja física','2023-11-21'),(328,86,56,5,5.00,142.50,'Loja online','2023-11-22'),(329,31,198,4,15.00,510.00,'Loja física','2023-11-23'),(330,99,22,3,0.00,55.00,'Loja online','2023-11-24'),(331,42,167,2,10.00,270.00,'Loja física','2023-11-25'),(332,15,93,1,5.00,237.50,'Loja online','2023-11-26'),(333,93,11,6,25.00,937.50,'Loja física','2023-11-27'),(334,28,78,5,10.00,198.00,'Loja online','2023-11-28'),(335,85,134,4,20.00,480.00,'Loja física','2023-11-29'),(336,40,205,3,0.00,120.00,'Loja online','2023-11-30'),(337,103,99,2,15.00,425.00,'Loja física','2023-12-01'),(338,20,177,1,5.00,190.00,'Loja online','2023-12-02'),(339,77,43,6,10.00,315.00,'Loja física','2023-12-03'),(340,50,156,5,25.00,1125.00,'Loja online','2023-12-04'),(341,4,89,4,0.00,65.00,'Loja física','2023-12-05'),(342,81,122,3,20.00,400.00,'Loja online','2023-12-06'),(343,34,67,2,5.00,142.50,'Loja física','2023-12-07'),(344,100,145,1,15.00,637.50,'Loja online','2023-12-08'),(345,23,33,6,0.00,45.00,'Loja física','2023-12-09'),(346,90,188,5,10.00,270.00,'Loja online','2023-12-10'),(347,53,76,4,5.00,95.00,'Loja física','2023-12-11'),(348,10,114,3,25.00,937.50,'Loja online','2023-12-12'),(349,95,98,2,10.00,198.00,'Loja física','2023-12-13'),(350,30,56,1,20.00,320.00,'Loja online','2023-12-14'),(351,79,201,6,0.00,120.00,'Loja física','2023-12-15'),(352,44,123,5,15.00,425.00,'Loja online','2023-12-16'),(353,2,45,4,5.00,190.00,'Loja física','2023-12-17'),(354,87,178,3,10.00,315.00,'Loja online','2023-12-18'),(355,36,32,2,25.00,1125.00,'Loja física','2023-12-19'),(356,101,199,1,0.00,80.00,'Loja online','2023-12-20'),(357,21,110,6,20.00,400.00,'Loja física','2023-12-21'),(358,80,155,5,5.00,142.50,'Loja online','2023-12-22'),(359,43,88,4,15.00,510.00,'Loja física','2023-12-23'),(360,98,112,3,0.00,55.00,'Loja online','2023-12-24'),(361,25,189,2,10.00,270.00,'Loja física','2023-12-25'),(362,82,30,1,5.00,237.50,'Loja online','2023-12-26'),(363,9,77,6,25.00,937.50,'Loja física','2023-12-27'),(364,92,144,5,10.00,198.00,'Loja online','2023-12-28'),(365,14,56,4,20.00,480.00,'Loja física','2023-12-29'),(366,55,198,3,0.00,120.00,'Loja online','2023-12-30'),(367,27,22,2,15.00,425.00,'Loja física','2023-12-31'),(368,73,167,1,5.00,190.00,'Loja online','2023-10-01'),(369,104,93,6,10.00,315.00,'Loja física','2023-10-02'),(370,18,11,5,25.00,1125.00,'Loja online','2023-10-03'),(371,61,78,4,0.00,65.00,'Loja física','2023-10-04'),(372,33,134,3,20.00,400.00,'Loja online','2023-10-05'),(373,96,205,2,5.00,142.50,'Loja física','2023-10-06'),(374,7,99,1,15.00,637.50,'Loja online','2023-10-07'),(375,82,177,6,0.00,45.00,'Loja física','2023-10-08'),(376,49,43,5,10.00,270.00,'Loja online','2023-10-09'),(377,105,156,4,5.00,95.00,'Loja física','2023-10-10'),(378,29,89,3,25.00,937.50,'Loja online','2023-10-11'),(379,64,122,2,10.00,198.00,'Loja física','2023-10-12'),(380,3,67,1,20.00,320.00,'Loja online','2023-10-13'),(381,87,145,6,0.00,120.00,'Loja física','2023-10-14'),(382,51,33,5,15.00,425.00,'Loja online','2023-10-15'),(383,22,188,4,5.00,190.00,'Loja física','2023-10-16'),(384,76,76,3,10.00,315.00,'Loja online','2023-10-17'),(385,13,114,2,25.00,1125.00,'Loja física','2023-10-18'),(386,94,98,1,0.00,80.00,'Loja online','2023-10-19'),(387,38,56,6,20.00,400.00,'Loja física','2023-10-20'),(388,101,201,5,5.00,142.50,'Loja online','2023-10-21'),(389,16,123,4,15.00,510.00,'Loja física','2023-10-22'),(390,72,45,3,0.00,55.00,'Loja online','2023-10-23'),(391,45,178,2,10.00,270.00,'Loja física','2023-10-24'),(392,8,32,1,5.00,237.50,'Loja online','2023-10-25'),(393,97,199,6,25.00,937.50,'Loja física','2023-10-26'),(394,24,110,5,10.00,198.00,'Loja online','2023-10-27'),(395,83,155,4,20.00,480.00,'Loja física','2023-10-28'),(396,37,88,3,0.00,120.00,'Loja online','2023-10-29'),(397,62,112,2,15.00,425.00,'Loja física','2023-10-30'),(398,19,189,1,5.00,190.00,'Loja online','2023-10-31'),(399,105,30,6,10.00,315.00,'Loja física','2023-11-01'),(400,41,77,5,25.00,1125.00,'Loja online','2023-11-02');
/*!40000 ALTER TABLE `vendas` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vendedores`
--
DROP TABLE IF EXISTS `vendedores`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vendedores` (
`idvendedores` int NOT NULL AUTO_INCREMENT,
`nome_vendedores` varchar(45) NOT NULL,
PRIMARY KEY (`idvendedores`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vendedores`
--
LOCK TABLES `vendedores` WRITE;
/*!40000 ALTER TABLE `vendedores` DISABLE KEYS */;
INSERT INTO `vendedores` VALUES (1,'Bryan Rodrigues'),(2,'Davi Matias'),(3,'Ítalo Alves'),(4,'João Vitor Dias'),(5,'Samarha Oliveira'),(6,'Sarah Oliveira');
/*!40000 ALTER TABLE `vendedores` 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 2025-05-18 19:36:58