--
-- Host: localhost    Database: noss2142_reserved
-- ------------------------------------------------------


--
-- Table structure for table `clientes`
--

CREATE TABLE `clientes` (
  `idcliente` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `celular` varchar(11) NOT NULL,
  `data_cadastro` date NOT NULL,
  `aceita_receber_mensagen_whatsapp` char(1) DEFAULT NULL,
  `idempresa` int(11) DEFAULT NULL,
  PRIMARY KEY (`idcliente`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `clientes`
--

INSERT INTO `clientes` (`idcliente`, `nome`, `email`, `celular`, `data_cadastro`, `aceita_receber_mensagen_whatsapp`, `idempresa`) VALUES (2,'Erivan Rodrigues','Teste@teste','81983250809','2024-10-29',NULL,2),(3,'Carlinhos','Teste@teste','81995275352','2024-10-29',NULL,2),(4,'Jonny primo lais','Teste@teste','81979043146','2024-10-31',NULL,2),(5,'mayza','teste','81998432560','2025-01-03',NULL,2),(6,'marcio jose mergulhao','teste','81999872765','2025-01-07',NULL,2),(7,'wilma via modas','teste','81997534196','2025-01-07',NULL,2),(8,'eroene ','teste','819999999','2025-01-07',NULL,2),(9,'karla karine','teste','81997332735','2025-01-07',NULL,2),(10,'marcellos bar','teste','8199999999','2025-01-07',NULL,2),(11,'mayza ','teste','81998432560','2025-01-07',NULL,2),(12,'liliane nascimento ','lili','81984296678','2025-01-09',NULL,2),(13,'rosangela silva ','rosangela ','81984189065','2025-01-09',NULL,2),(14,'liliane dona madu','liliane','81985395838','2025-01-09',NULL,2),(15,'erica prima de jorginho ','erica ','81993091635','2025-01-09',NULL,2),(16,'bibi','bibi',' 8199696144','2025-01-09','T',2),(17,'xixi ','xixi','81988717956','2025-01-09',NULL,2),(18,'rosilene vizinha','rosilene','8199999999','2025-01-09',NULL,2),(19,'michel doido ','michel','81986516395','2025-01-09',NULL,2),(20,'Marilene Luíza ','marilene ','8198164380','2025-01-09',NULL,2),(21,'João Vitor Leite ','joao ','81984752330','2025-01-10',NULL,2),(22,'moises la na ladeira','moises','81998966842','2025-01-10',NULL,2),(23,'Papa moto táxi romilson','Teste','81996766479','2025-01-10',NULL,2),(24,'Luiz Carlos amigo anderson','Teste','81994987409','2025-01-12',NULL,2),(25,'Regina Melquiades','regina ','81999210796','2025-01-13',NULL,2),(26,'adriano abacora ','adriano','81992571406','2025-01-14',NULL,2),(27,'José Edson \"Neto\"','jose','81996004799','2025-01-16',NULL,2),(28,'maria filha ','maria','81985425577','2025-01-16',NULL,2),(29,'pedro filho ','pedro','81985425577','2025-01-16',NULL,2),(30,'LARA ','lara ','81985425577','2025-01-16',NULL,2),(31,'marcia maria','marcia','81996982362','2025-01-16',NULL,2),(32,'Alerson moura','alerson','4784282575','2025-01-17',NULL,2),(33,'CLAUDINETE FELICIANO DE MELO','claudinete','81985514083','2025-01-24',NULL,2),(34,'milena marcio barbosa','teste','81994230921','2025-01-24',NULL,2),(35,'maria alessandra','maria ','81986656534','2025-01-27',NULL,2),(36,'mariana','mariana ','8199195‑291','2025-01-27',NULL,2),(37,'Thayanne Rêgo.','thayane','81998597143','2025-01-29',NULL,2),(38,'maria eduarda','duda ','81988641524','2025-02-03',NULL,2),(39,'Joyce evellen','joyce','81984681650','2025-02-06',NULL,2),(40,'Fabio dono','Fabio@gruponexustelecom.com.br','81998135058','2025-02-08','T',2),(41,'AMIGO MANOEL ','manoel','8198554125','2025-02-10',NULL,2),(42,'Gilvania','gilvania','81985352920','2025-02-10',NULL,2),(43,'diego dias','diego ','81985425577','2025-02-11',NULL,2),(44,'Francielle Nunes Diniz','francielle','81986892094','2025-02-12',NULL,2),(45,'evellyn ','evelyn ','819937423','2025-02-13',NULL,2),(46,'cunhado bibi ','cunhado','81985352920','2025-02-22',NULL,2),(47,'TAMIRES NASCIMENTO ','tamires','81991768064','2025-02-22',NULL,2),(48,'dede motoqueiro bibi ','dede ','81981762348','2025-02-26',NULL,2),(49,'GABRIEL ','GABRIEL','81985972555','2025-03-07',NULL,2),(50,'Juninho filho Samuel ','juninho ',' 8196383597','2025-03-08',NULL,2),(51,'adrielly luna','adrielly','8199868734','2025-03-12',NULL,2),(52,'jeffinho ','jefinho','819 8651639','2025-03-12',NULL,2),(53,'caio','caio','9813-5058','2025-03-13',NULL,2),(54,'PEDRO VIIZINHO ','pedro',' 98135058','2025-03-17',NULL,2),(55,'jonnes mistureba','jonnes','8197910807','2025-03-18',NULL,2),(56,'Leandro Alberes','leandro','81986161359','2025-03-18',NULL,2),(57,'EROENE ','EROENE','81985425577','2025-03-19',NULL,2),(58,'matheus henrique siqueira campos','matheus ','81984710969','2025-03-20',NULL,2),(59,'Micheline da Silva','micheline','8198391051','2025-03-20',NULL,2),(60,'Tamires Elizia','tamires','81987936430','2025-03-25',NULL,2),(61,'Júnior Santos ','junior','81998966842','2025-04-02',NULL,2),(62,'Vitor De Lima Primo Amanda','vitor ','8199808060','2025-04-11',NULL,2),(63,'ROMILSON ','ROMILSON','81998876921','2025-04-12','T',2),(64,'adryel barros ','adryel ','8199616-429','2025-04-14',NULL,2),(65,'romilson amigo ','romilson','81988769210','2025-04-16',NULL,2),(66,'Rai marcelo ','rai','8198698389','2025-04-24',NULL,2),(67,'Bárbara Gonzaga','barbara ','81987260482','2025-04-29',NULL,2),(68,'Mayara ellen Bastos','mayara ','81996858676','2025-04-29',NULL,2),(69,'PATRICIA AMIGA DE VEIA ','PATRICIA ','819','2025-04-30',NULL,2),(70,'Dodo','Teste@teste','81985569575','2025-04-30',NULL,2),(71,'Cida tia de Misael','Teste','81986212177','2025-05-04',NULL,2),(72,'Magali Maria de Jesus silva','Teste','81986211119','2025-05-08',NULL,2),(73,'Pombo','Teste','81994999820','2025-05-08',NULL,2),(74,'Fábio boy lava jato','Teste','81998818977','2025-05-16',NULL,2),(75,'Vanessa unha','Teste','81989596986','2025-05-19',NULL,2),(76,'JONNHY LENNON','TESTE','81984712252','2025-05-23',NULL,2),(77,'deusiana rua ','teste','81988703019','2025-06-02',NULL,2),(78,'Andresa da Silva Martins ','andresa','81987319132','2025-06-07',NULL,2),(79,'KELY GERENTE','KELY ',' 9374-2375','2025-06-11',NULL,2),(80,'JOELSINHO ','joelsinho','81987770978','2025-06-12','T',2),(81,'Yasmin Farias','yasmin','9954-1727','2025-06-30',NULL,2),(82,'marcelinho ','marcelinho','8199991-695','2025-07-10',NULL,2),(83,'ALLISON HENRIQUE PERERA DA SILVA','alisson','81987717120','2025-07-12',NULL,2),(84,'Larinha bomba ','larinha','81987866529','2025-07-12',NULL,2),(85,'POMBO','POMBO','81994999820','2025-07-12',NULL,2),(86,'Linwany SORTEIO ','ANNY','8198733112','2025-07-22',NULL,2),(87,'Diego gondim','Teste','81998364759','2025-07-24',NULL,2),(88,'CAMILA SOUZA ','camila','81999855866','2025-08-06',NULL,2),(89,'ANA FLAVIA','flavia','81989162993','2025-08-09',NULL,2),(90,'ISABELA ','isabela','81985651859','2025-09-01',NULL,2),(91,'Adriel','Teste','81996164299','2025-09-02',NULL,2),(92,'PAI FABINHO ','paifabio','81999646384','2025-09-04',NULL,2),(93,'Romulo lima','Rômulo lima','81988052541','2025-09-12','T',2),(94,'dj Jadson','djjadson','81999221593','2025-09-16','T',2),(95,'beatriz pepe ','biapepe89@hotmail.com','81985425577','2025-09-18','T',2),(96,'Felipe','felipe@controllinformatica.com.br','35987037651','2025-09-18','T',1),(97,'Geisy camila','Teste@teste','81983950243','2025-09-25','T',2),(98,'Patrícia Maria da silva','Teste@teste','8198570‑625','2025-09-28','T',2),(99,'Felipe','teste','35987037651','2025-09-30','T',2),(100,'Marcela esposa de marcellos bar','Teste@teste','81998222121','2025-10-03','T',2),(101,'Douglas pm','Teste@teste','81997784856','2025-10-04','T',2),(102,'Geisy Camila','ndgeisygeilly@gmail.com','81983950243','2025-10-05','T',2),(103,'Mayara','Mayara ','81997930444','2025-10-06','T',2),(104,'Isabela Silva','isabela','81985651859','2025-10-08','T',2),(105,'Jorginho ','8198699-4423','8198699-442','2025-10-09','T',2),(106,'Adriele maga ','maga ','81999312328','2025-10-13','T',2),(107,'Lessa locutor ','lesa ','81984698085','2025-10-13','T',2),(108,'mana ','mana','81996714611','2025-10-13','T',2),(109,'samuel juininho ','samuel ','81996383597','2025-10-20','T',2),(110,'VEA ','VEA','81986917893','2025-10-20','T',2),(111,'Paulo Braga ','PAULo','8995485846‬','2025-10-27','T',2),(112,'JANE ','jane ','81987732272','2025-10-29','T',2),(113,'ANA CARLA MARQUES','ANA','81973281725','2025-11-01','T',2),(114,'Pelada amigos da zoeira','pelada','81985510635','2025-11-01','T',2),(115,'Andsson Rodrigues Lemos','andsson ','81986999132','2025-11-05','T',2),(116,'Luciana Pereira da Silva','luciana','81996530332','2025-11-06','T',2),(117,'Drielly Cordeiro','drielly ','81994505383','2025-11-06','T',2),(118,'Andricy Amorim Dos Santos','81991699837','81991699837','2025-11-08','T',2),(119,'V farias advocacia','81996828097','81996828097','2025-11-08','T',2),(120,'Ivoneide escola castelo do saber','ivoneide','81985050760','2025-11-10','T',2),(121,'sabrina hellen mendes morais','teste','81993570041','2025-11-11','T',2),(122,'Chrystian Gomes','Chrystian','81998958711','2025-11-13','T',2),(123,'Hevelyn Morgana','Hevelyn','81995248277','2025-12-01','T',2),(124,'SEVERINO LINDO ','LINDO ','81996598579','2025-12-02','T',2),(125,'MARIANA PESSOA ','mariana   ','8199195291 ','2025-12-09','T',2),(126,'CONFRA NEXUS TELECOM ','NEXUS','81988852785','2025-12-10','T',2),(127,'FERNANDO ','FERNANDO','81998492660','2025-12-16','T',2),(128,'Walbiano Alves','Walbiano ','81985948823','2025-12-29','T',2),(129,' Carlinhos','carlinhos','81995275352','2025-12-30','T',2),(130,'Jessé arruda ','jose','81979161267','2025-12-30','T',2),(131,'Bloco Caçadores de Cachaça','bloco','81997245848','2026-01-02','T',2),(132,'Lucimaria braz','Teste','81986989839','2026-01-05','T',2),(133,'Chinara natian','Teste','81996884629','2026-01-07','T',2),(134,'NATALIA RODRIGUES','TESTE','81998487233','2026-01-08','T',2),(135,'Érika Lourena','Teste','81986334194','2026-01-08','T',2),(136,'João Paulo Mendes da silva','Teste','81993499844','2026-01-09','T',2),(137,'Natally malheiros','Teste','81996250637','2026-01-10','T',2),(138,'Leandro Bruno Ferreira da silva','Teste','81986256153','2026-01-13','T',2),(139,'Camila nunes','Teste','81997009404','2026-01-14','T',2),(140,'Gabriel messias','Teste','81987734871','2026-01-17','T',2),(141,'Marcina dias dos santos','Teste','81987300529','2026-01-20','T',2),(142,'Marcina dias','Teste','81987300529','2026-01-21','T',2),(143,'dinho cabeça','dinhocabeça12@hotmail.com','81993207691','2026-01-21','T',2),(144,'Adrielly cardoso','Adrielly.cardoso23@gmail.com','995077561','2026-01-21','T',2);

--
-- Table structure for table `configuracao`
--

CREATE TABLE `configuracao` (
  `idconfig` int(11) NOT NULL AUTO_INCREMENT,
  `permitir_eventos_dias` char(1) DEFAULT 'S',
  `idempresa` int(10) unsigned DEFAULT NULL,
  `idtoken` varchar(100) DEFAULT NULL,
  `msg_dias` int(11) DEFAULT NULL,
  `logo` text DEFAULT NULL,
  `contato` varchar(30) DEFAULT NULL,
  `choque` char(1) DEFAULT NULL,
  PRIMARY KEY (`idconfig`),
  KEY `fk_configuracao_idempresa` (`idempresa`),
  CONSTRAINT `fk_configuracao_idempresa` FOREIGN KEY (`idempresa`) REFERENCES `system_unit` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `configuracao`
--

INSERT INTO `configuracao` (`idconfig`, `permitir_eventos_dias`, `idempresa`, `idtoken`, `msg_dias`, `logo`, `contato`, `choque`) VALUES (2,'S',2,'carlos_andre',1,NULL,'81985478976','F'),(8,'S',1,'felipe',1,NULL,'35987037651','F');

--
-- Table structure for table `forma_pagto`
--

CREATE TABLE `forma_pagto` (
  `idpagto` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) NOT NULL,
  PRIMARY KEY (`idpagto`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `forma_pagto`
--

INSERT INTO `forma_pagto` (`idpagto`, `nome`) VALUES (1,'Dinheiro'),(2,'Cartão'),(3,'Cheque'),(4,'Pix'),(5,'Permuta');

--
-- Table structure for table `produto`
--

CREATE TABLE `produto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(100) NOT NULL,
  `compra` double NOT NULL,
  `venda` double NOT NULL,
  `margem` double NOT NULL,
  `idempresa` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `produto`
--

INSERT INTO `produto` (`id`, `nome`, `compra`, `venda`, `margem`, `idempresa`) VALUES (1,'teste',0.01,0.11,1000,1);

--
-- Table structure for table `produto_venda`
--

CREATE TABLE `produto_venda` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `venda_id` int(11) NOT NULL,
  `produto_id` int(11) NOT NULL,
  `valor` double NOT NULL,
  `qtd` int(11) NOT NULL,
  `total` double NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_produto_venda_1_1` (`venda_id`),
  KEY `fk_produto_venda_2_2` (`produto_id`),
  CONSTRAINT `fk_produto_venda_1_1` FOREIGN KEY (`venda_id`) REFERENCES `venda` (`id`),
  CONSTRAINT `fk_produto_venda_2_2` FOREIGN KEY (`produto_id`) REFERENCES `produto` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `produto_venda`
--


--
-- Table structure for table `quadra`
--

CREATE TABLE `quadra` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` text NOT NULL,
  `idempresa` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `quadra`
--

INSERT INTO `quadra` (`id`, `nome`, `idempresa`) VALUES (1,'teste',1);

--
-- Table structure for table `reserva`
--

CREATE TABLE `reserva` (
  `idreserva` int(11) NOT NULL AUTO_INCREMENT,
  `idstatus` int(11) DEFAULT NULL,
  `forma_pagto_id` int(11) DEFAULT NULL,
  `clientes_id` int(11) DEFAULT NULL,
  `data_reserva` datetime NOT NULL,
  `qtd_pessoas` int(11) DEFAULT NULL,
  `comprovante` varchar(200) DEFAULT NULL,
  `obs` text DEFAULT NULL,
  `data_cadastro` datetime DEFAULT NULL,
  `valor` double DEFAULT NULL,
  `idempresa` int(10) unsigned DEFAULT NULL,
  `hora_reserva` time DEFAULT NULL,
  `data_reserva_final` datetime DEFAULT NULL,
  `idstatusmsg` int(11) DEFAULT 0,
  PRIMARY KEY (`idreserva`),
  KEY `fk_reserva_idstatus` (`idstatus`),
  KEY `fk_reserva_forma_pagto_id` (`forma_pagto_id`),
  KEY `fk_reserva_clientes_id` (`clientes_id`),
  KEY `fk_reserva_idempresa` (`idempresa`),
  CONSTRAINT `fk_reserva_clientes_id` FOREIGN KEY (`clientes_id`) REFERENCES `clientes` (`idcliente`),
  CONSTRAINT `fk_reserva_forma_pagto_id` FOREIGN KEY (`forma_pagto_id`) REFERENCES `forma_pagto` (`idpagto`),
  CONSTRAINT `fk_reserva_idempresa` FOREIGN KEY (`idempresa`) REFERENCES `system_unit` (`id`),
  CONSTRAINT `fk_reserva_idstatus` FOREIGN KEY (`idstatus`) REFERENCES `status` (`idstatus`)
) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `reserva`
--

INSERT INTO `reserva` (`idreserva`, `idstatus`, `forma_pagto_id`, `clientes_id`, `data_reserva`, `qtd_pessoas`, `comprovante`, `obs`, `data_cadastro`, `valor`, `idempresa`, `hora_reserva`, `data_reserva_final`, `idstatusmsg`) VALUES (1,4,4,2,'2024-11-17 00:00:00',50,'app/documents/comprovantes/1/e7671719-fdf5-4289-8719-bc79db3393d0.jpeg','Foi pago 300.00 dia 29 de outubro','2024-10-29 18:48:00',600,2,NULL,NULL,0),(2,2,4,3,'2024-12-07 00:00:00',50,NULL,'Pagou 250.00 ','2024-10-29 21:14:00',500,2,NULL,NULL,0),(3,2,4,3,'2024-11-30 00:00:00',50,NULL,'Pagou 250 dia 28 de outubro','2024-10-29 21:15:00',500,2,NULL,NULL,0),(4,2,4,4,'2024-12-22 00:00:00',50,NULL,'Já pagou 600.00 dia 31/10','2024-10-31 18:22:00',600,2,NULL,NULL,0),(6,2,2,2,'2024-12-17 00:00:00',100,NULL,NULL,'2024-12-16 15:11:00',600,2,NULL,NULL,0),(7,2,4,5,'2025-01-26 00:00:00',60,NULL,'ja pagou 300,00 resta 300,00\r\npagaou dia 03/01','2025-01-03 18:09:00',600,2,NULL,NULL,0),(8,2,4,6,'2025-01-08 00:00:00',60,NULL,'ja pagou 200,00 dia 06/01','2025-01-07 11:41:00',400,2,NULL,NULL,0),(9,2,5,7,'2025-01-09 00:00:00',60,NULL,'permuta ','2025-01-07 11:42:00',0,2,NULL,NULL,0),(10,2,4,8,'2025-01-12 00:00:00',60,NULL,'ja foi pago','2025-01-07 11:43:00',400,2,NULL,NULL,0),(11,2,4,9,'2025-01-19 00:00:00',60,NULL,'ja foi pago 300,00 dia 07/01','2025-01-07 11:44:00',600,2,NULL,NULL,0),(12,2,5,10,'2025-01-21 00:00:00',60,NULL,'permutta','2025-01-07 11:45:00',0,2,NULL,NULL,0),(13,2,4,12,'2025-02-15 00:00:00',60,NULL,'Já está pago $250,00  ','2025-01-09 11:52:00',500,2,NULL,NULL,0),(15,2,4,14,'2025-01-11 00:00:00',60,NULL,'já esta pago $300,00','2025-01-09 12:03:00',600,2,NULL,NULL,0),(16,2,4,15,'2025-01-17 00:00:00',60,NULL,'já está pago $200,00 resta 250,00 ','2025-01-09 12:06:00',450,2,NULL,NULL,0),(17,2,4,15,'2025-02-09 00:00:00',60,NULL,'JA PAGOU OS 550','2025-01-09 12:08:00',0,2,NULL,NULL,0),(18,2,4,17,'2025-02-08 00:00:00',60,NULL,'falta pagar ','2025-01-09 12:09:00',500,2,NULL,NULL,0),(19,2,4,18,'2025-02-16 00:00:00',60,NULL,'foi pago dia 06/01','2025-01-09 12:09:00',500,2,NULL,NULL,0),(21,2,4,20,'2025-03-15 00:00:00',60,'app/documents/comprovantes/21/f7fed5ea-fe45-4634-a23f-5318728859e6.jpg','PAGO$ 300,00 RESTA $300,00 ','2025-01-09 14:27:00',600,2,NULL,NULL,0),(22,2,4,22,'2025-01-16 00:00:00',60,NULL,'moises','2025-01-10 12:23:00',250,2,NULL,NULL,0),(23,2,4,23,'2025-03-29 00:00:00',60,NULL,'Já pagou 200','2025-01-10 18:39:00',500,2,NULL,NULL,0),(24,3,4,24,'2025-03-09 00:00:00',60,NULL,'Falta pagar ','2025-01-12 20:04:00',500,2,NULL,NULL,0),(25,2,4,25,'2025-02-23 00:00:00',60,'app/documents/comprovantes/25/bda241c6-379a-45a9-aad1-1e495b055ccf.jpg','PAGO $300,00 RESTA $300,00 ','2025-01-13 16:31:00',600,2,NULL,NULL,0),(26,2,4,26,'2025-03-22 00:00:00',60,NULL,'PAGO $200,00 DIA 23/01 \r\nPAGO $200,00 21/03 ','2025-01-14 11:13:00',600,2,NULL,NULL,0),(27,2,4,27,'2025-03-23 00:00:00',60,NULL,'PAGO 300,00 \r\nPAGO $300,00 18/03 \r\nTUDO PAGO JÁ','2025-01-16 14:05:00',600,2,NULL,NULL,0),(28,2,4,28,'2025-01-24 00:00:00',60,NULL,'0800','2025-01-16 14:28:00',0,2,NULL,NULL,0),(29,2,4,29,'2025-03-14 00:00:00',60,NULL,'0800','2025-01-16 14:30:00',0,2,NULL,NULL,0),(30,4,4,30,'2025-04-21 00:00:00',60,NULL,'0800','2025-01-16 14:30:00',0,2,NULL,NULL,0),(31,2,4,31,'2025-02-22 00:00:00',60,NULL,'PAGO $200,00 \r\npago + 200,00 avista a kely 03/02 \r\nPAGO $200,00 DIA 17/02 ','2025-01-16 15:46:00',600,2,NULL,NULL,0),(32,2,4,32,'2025-03-08 00:00:00',60,NULL,'PAGO $300,00 RESTA $300,00 ','2025-01-17 09:03:00',600,2,NULL,NULL,0),(33,2,4,33,'2025-03-30 00:00:00',60,NULL,'PAGO $300,00 \r\nPAGO $150,00 18/03 \r\nPAGO $150,00 26/03 \r\nTUDO PAGO ','2025-01-24 08:06:00',600,2,NULL,NULL,0),(34,2,4,34,'2025-01-27 00:00:00',60,NULL,'0800','2025-01-24 20:06:00',0,2,NULL,NULL,0),(35,1,4,35,'2025-05-11 00:00:00',60,NULL,'PAGO $300,00 RESTA 300,00 ','2025-01-27 09:36:00',600,2,NULL,NULL,0),(36,2,4,36,'2025-01-28 00:00:00',60,NULL,'0800','2025-01-27 17:19:00',0,2,NULL,NULL,0),(37,2,4,37,'2025-03-16 00:00:00',60,NULL,'PAGO $300,00 RESTA 300,00 ','2025-01-29 17:57:00',600,2,NULL,NULL,0),(40,2,4,38,'2025-02-17 00:00:00',60,NULL,'.','2025-02-03 14:02:00',0,2,NULL,NULL,0),(41,3,4,39,'2025-04-06 00:00:00',60,'app/documents/comprovantes/41/comprovante_picpay_pix_06-02-2025-11-41-30.pdf','PAGO $300,00 06/02\r\n RESTA $300,00 ','2025-02-06 11:43:00',600,2,NULL,NULL,0),(42,2,4,40,'2025-03-17 00:00:00',60,NULL,'Festa de lukinha','2025-02-08 23:56:00',0,2,NULL,NULL,0),(43,3,4,24,'2025-04-13 00:00:00',60,NULL,'FALTA PAGAR','2025-02-09 10:37:00',500,2,NULL,NULL,0),(44,2,4,41,'2025-02-28 00:00:00',60,NULL,'PAGO $175,00 RESTA $175,00','2025-02-10 15:29:00',350,2,NULL,NULL,0),(45,2,4,42,'2025-03-02 00:00:00',60,'app/documents/comprovantes/45/1739216035249.pdf','JÁ ESTÁ PAGO \r\n10/02 ','2025-02-10 16:34:00',600,2,NULL,NULL,0),(46,2,4,43,'2025-02-18 00:00:00',60,NULL,'000','2025-02-11 10:08:00',0,2,NULL,NULL,0),(47,2,4,44,'2025-02-13 00:00:00',60,NULL,'PAGO 175,00 12/02 \r\nFALTA 175,00','2025-02-12 08:13:00',350,2,NULL,NULL,0),(48,4,4,45,'2025-04-26 00:00:00',60,NULL,'TUDO OK !\r\nPAGO 250,00 a kelly pessoalmente (dia 13/02) \r\n PAGO 250,00 A KELLY PESSOALMENTE DIA 19/04  ','2025-02-13 09:17:00',500,2,NULL,NULL,0),(49,2,4,46,'2025-03-18 00:00:00',60,NULL,'PAGO $150\r\nRESTA 150','2025-02-22 17:29:00',300,2,NULL,NULL,0),(50,2,4,47,'2025-03-01 00:00:00',60,NULL,'PAGO $300,00\r\nRESTA $300,00 ','2025-02-22 17:30:00',600,2,NULL,NULL,0),(51,2,4,48,'2025-03-04 00:00:00',60,NULL,NULL,'2025-02-26 08:02:00',450,2,NULL,NULL,0),(52,2,4,49,'2025-03-09 00:00:00',60,NULL,'PAGO$ 250,00 \r\nRESTA $250,00 ','2025-03-07 15:44:00',500,2,NULL,NULL,0),(53,4,4,50,'2025-04-12 00:00:00',60,NULL,'PAGO $200,00\r\nRESTA $300,00 ','2025-03-08 08:03:00',500,2,NULL,NULL,0),(54,1,4,51,'2025-05-30 00:00:00',60,NULL,'TUDO PAGO!\r\nPIX FEITO DIA 11/03 ','2025-03-12 09:07:00',350,2,NULL,NULL,0),(55,2,4,52,'2025-05-04 00:00:00',60,NULL,'PAGO $ 250,00 12/03 \r\nRESTA $300,00 ','2025-03-12 14:57:00',550,2,NULL,NULL,0),(56,4,4,53,'2025-04-01 00:00:00',60,NULL,'0800','2025-03-13 14:03:00',0,2,NULL,NULL,0),(57,1,4,54,'2025-05-10 00:00:00',60,NULL,'PAGO $200,00 31/03 \r\nPAGO$200,00 11/04 ','2025-03-17 14:27:00',400,2,NULL,NULL,0),(58,2,4,55,'2025-03-19 00:00:00',60,NULL,'.','2025-03-18 10:58:00',200,2,NULL,NULL,0),(59,4,4,56,'2025-04-27 00:00:00',60,NULL,'PAGO $300,00 18/03\r\nPAGO $300,00 15/04 \r\nTUDO PAGO ','2025-03-18 11:42:00',600,2,NULL,NULL,0),(60,4,4,8,'2025-04-29 00:00:00',60,NULL,'VAI PAGAR AINDA ','2025-03-19 09:10:00',0,2,NULL,NULL,0),(61,1,4,58,'2025-05-18 00:00:00',60,NULL,'PAGO 300,00 DIA 19/03 \r\nRESTA 300,00 ','2025-03-20 08:15:00',600,2,NULL,NULL,0),(62,4,4,59,'2025-04-28 00:00:00',60,NULL,'TUDO OK \r\nPAGO $175,00 20/03 \r\nPAGO $ 175,00 26/04 ','2025-03-20 14:31:00',350,2,NULL,NULL,0),(63,4,4,60,'2025-03-31 00:00:00',60,NULL,'PAGO $200,00 DIA 24/03\r\nPAGO $150,00 31/03 ','2025-03-25 09:30:00',350,2,NULL,NULL,0),(64,4,4,61,'2025-04-09 00:00:00',60,NULL,NULL,'2025-04-02 07:56:00',200,2,NULL,NULL,0),(65,4,4,62,'2025-04-15 00:00:00',60,NULL,'FALTA PAGAR. \r\n','2025-04-11 08:03:00',250,2,NULL,NULL,0),(66,2,4,63,'2025-05-16 00:00:00',60,NULL,'INFORMAR O VALOR\r\n','2025-04-12 15:48:00',0,2,NULL,NULL,0),(67,4,4,64,'2025-04-16 00:00:00',60,NULL,'JÁ FOI PAGO! ','2025-04-14 16:56:00',250,2,NULL,NULL,0),(68,2,4,65,'2025-05-09 00:00:00',60,NULL,'.','2025-04-16 09:33:00',0,2,NULL,NULL,0),(69,4,4,66,'2025-05-01 00:00:00',60,'app/documents/comprovantes/69/1745928380246+(1).pdf','TUDO PAGO!\r\npix feito 29/04 ','2025-04-24 15:35:00',300,2,NULL,NULL,0),(70,4,4,67,'2025-07-27 00:00:00',50,'app/documents/comprovantes/70/6878f594601db_2025_05_29_130121.pdf','TUDO OK \r\nPAGO 29/04 300,00 \r\nPAGO 29/05$300,00 ','2025-04-29 13:59:00',600,2,NULL,NULL,0),(71,1,4,68,'2025-05-31 00:00:00',60,'app/documents/comprovantes/71/ef9a16c4-8509-41a1-bb3a-2f5099200bdd.jpg','PAGO $250,00 29/04\r\n','2025-04-29 14:04:00',600,2,NULL,NULL,0),(72,2,4,69,'2025-05-26 00:00:00',60,NULL,'VAI PAGAR AINDA ','2025-04-30 15:43:00',400,2,NULL,NULL,0),(73,4,4,70,'2025-05-03 00:00:00',60,NULL,'Já pagou dia 30/04','2025-04-30 21:59:00',550,2,NULL,NULL,0),(74,2,4,71,'2025-06-01 00:00:00',60,NULL,'Pago 225,00 dia 05/05','2025-05-04 15:48:00',450,2,NULL,NULL,0),(75,2,4,64,'2025-05-14 00:00:00',60,NULL,'Já foi pago','2025-05-07 18:47:00',200,2,NULL,NULL,0),(76,2,4,72,'2025-06-21 00:00:00',60,NULL,'Já pagou 300 dia 08/05 ','2025-05-08 16:32:00',600,2,NULL,NULL,0),(77,2,4,73,'2025-06-22 00:00:00',60,NULL,'Pagou 200 dia 09/06\r\nresta 300,00 dia do evento vai pagar ','2025-05-08 19:44:00',500,2,NULL,NULL,0),(78,2,4,74,'2025-06-15 00:00:00',60,NULL,'Não pagou nada','2025-05-16 09:08:00',500,2,NULL,NULL,0),(79,4,4,75,'2025-06-29 00:00:00',60,NULL,'Pagou 200 resta 300','2025-05-19 20:36:00',500,2,NULL,NULL,0),(80,2,4,64,'2025-05-28 00:00:00',60,NULL,'Já foi pago','2025-05-23 11:13:00',200,2,NULL,NULL,0),(81,4,4,76,'2025-06-14 00:00:00',60,NULL,'JA PAGOU 250,00 DIA 23/05\r\nRESTA 250,00','2025-05-23 19:09:00',500,2,NULL,NULL,0),(82,2,4,65,'2025-06-08 00:00:00',60,NULL,'Gratis','2025-05-31 10:44:00',0.01,2,NULL,NULL,0),(83,4,4,77,'2025-07-06 00:00:00',60,NULL,'ja pagou 200,00 dia 02/06\r\nresta 300,00 vai pagar no dia','2025-06-02 14:07:00',500,2,NULL,NULL,0),(84,4,4,54,'2025-06-23 00:00:00',60,NULL,'vai pagar $700,00 dia 23/24 ','2025-06-06 15:03:00',700,2,NULL,NULL,0),(85,4,4,54,'2025-06-24 00:00:00',60,NULL,'vai pagar $700,00 dia 23 e 24  ','2025-06-06 15:04:00',700,2,NULL,NULL,0),(86,2,4,78,'2025-12-31 09:00:00',60,'app/documents/comprovantes/86/6905fd2abc15e_whatsapp_image_2025_10_31_at_22.29.37.jpeg','Recibo referente a locação do espaço MPL eventos localizado na rua Egas Muniz n:64\r\n  O evento vai será  realizado no dia dia 31 de dezembro de 2025 dando a continuidade  dia 01 de janeiro de 2026. pelo Responsável: Andresa da Silva Martins  CPF: 135.331.094-96  \r\ncom o valor pago dos 50%  de $850,00 na data 10/06  e Em outubro finalizar o restante dos 850,00 que totaliza no total de  1.700\r\n\r\nPagamento finalizado dia 31/10 do valor de 850,00\r\nTudo OK  1.700\r\n\r\n\r\n\r\n\r\n','2025-06-07 15:53:00',1700,2,NULL,'2026-01-01 09:00:00',0),(87,4,4,79,'2025-06-19 00:00:00',60,NULL,'...','2025-06-11 17:32:00',0,2,NULL,NULL,0),(88,4,4,80,'2025-12-14 09:00:00',60,NULL,'PAGO 300,00 DIA 11/06 \r\nPAGO $300,00 08/12 \r\nTUDO OK\r\n','2025-06-12 08:13:00',600,2,NULL,'2025-12-14 09:00:00',0),(89,3,4,82,'2025-09-14 00:00:00',60,NULL,'.','2025-06-24 23:34:00',600,2,NULL,NULL,0),(90,3,4,63,'2025-07-05 00:00:00',1,NULL,NULL,'2025-06-25 21:52:00',0.01,2,NULL,NULL,0),(91,4,4,65,'2025-07-15 00:00:00',1,NULL,'Romilson é shevechenco','2025-06-26 14:40:00',0.01,2,NULL,NULL,0),(92,2,4,65,'2025-07-01 00:00:00',1,NULL,'1','2025-06-27 16:52:00',0.01,2,NULL,NULL,0),(93,4,4,81,'2025-07-12 00:00:00',60,'app/documents/comprovantes/93/00ecc0ed-ec20-49bf-95a0-c9d2f871a197.jpg','PAGO 30/06 300,00 \r\nPAGO  01/07 $300,00 ','2025-06-30 14:03:00',600,2,NULL,NULL,0),(94,4,4,15,'2025-07-22 00:00:00',1,NULL,'300,00 ','2025-07-06 17:45:00',300,2,NULL,NULL,0),(95,4,4,40,'2025-08-09 00:00:00',60,NULL,'....','2025-07-11 14:54:00',0,2,NULL,NULL,0),(96,4,4,40,'2025-08-10 00:00:00',60,NULL,'....','2025-07-11 14:55:00',0,2,NULL,NULL,0),(97,4,4,16,'2025-09-27 09:00:00',60,NULL,'....','2025-07-11 14:55:00',0,2,NULL,'2025-09-27 19:00:00',0),(98,4,4,65,'2025-09-28 09:00:00',60,NULL,'...','2025-07-11 14:56:00',0,2,NULL,'2025-09-28 19:00:00',0),(99,4,4,83,'2025-08-03 00:00:00',60,'app/documents/comprovantes/99/687262ef35e69_comprovante_2025_07_12_102140.pdf','PAGO $300,00 12/07 \r\nRESTA $300,00 ','2025-07-12 10:27:00',600,2,NULL,NULL,0),(100,4,4,84,'2025-08-17 00:00:00',60,NULL,'JÁ ESTÁ PAGO ','2025-07-12 14:02:00',300,2,NULL,NULL,0),(101,4,4,85,'2025-07-20 00:00:00',60,NULL,'TUDO OK! ','2025-07-12 15:23:00',500,2,NULL,NULL,0),(102,3,4,63,'2025-11-09 09:00:00',60,NULL,NULL,'2025-07-21 22:08:00',0.01,2,NULL,'2025-11-09 09:00:00',0),(103,4,4,86,'2025-07-29 00:00:00',60,NULL,'SORTEIO INSTAGRAM ','2025-07-22 09:05:00',0,2,NULL,NULL,0),(104,3,4,87,'2025-08-16 00:00:00',60,NULL,'Não pagou','2025-07-24 19:17:00',400,2,NULL,NULL,0),(105,3,4,40,'2025-09-29 09:00:00',60,NULL,'Ricardo pedreiro','2025-07-25 22:24:00',0.01,2,NULL,'2025-09-29 19:00:00',0),(106,3,4,63,'2025-08-31 09:00:00',60,NULL,'...','2025-07-29 10:25:00',0,2,NULL,'2025-08-31 10:00:00',0),(107,4,4,52,'2025-08-18 00:00:00',60,NULL,NULL,'2025-08-01 21:21:00',0.01,2,NULL,NULL,0),(108,2,4,88,'2025-08-30 00:00:00',60,'app/documents/comprovantes/108/68933a373f7c5_1754478896822.pdf','PAGO $300,00 06/08\r\nRESTA $300,00 ','2025-08-06 08:19:00',600,2,NULL,NULL,0),(110,4,4,89,'2025-08-16 00:00:00',60,'app/documents/comprovantes/110/68978188a351a_b723fdd0_ba63_4cc3_897e_4d9992094c47.jpeg','PAGO$400,00\r\nRESTA $200,00 ','2025-08-09 14:11:00',600,2,NULL,NULL,0),(111,3,4,40,'2025-09-21 09:00:00',60,NULL,'Batizado filho de tarlison','2025-08-19 11:43:00',0.01,2,NULL,'2025-09-21 10:00:00',0),(112,4,4,52,'2025-08-24 00:00:00',60,NULL,'JÁ ESTÁ PAGO ','2025-08-20 14:55:00',500,2,NULL,NULL,0),(113,3,4,40,'2025-10-26 09:00:00',60,NULL,'Batizado Erivelton filho de tarlison','2025-08-26 19:41:00',0.01,2,NULL,'2025-10-26 09:00:00',0),(114,3,4,40,'2025-09-21 09:00:00',60,NULL,'Festa marcelinho','2025-08-27 11:32:00',0.01,2,NULL,'2025-09-21 19:00:00',0),(115,4,4,90,'2025-09-18 00:00:00',60,NULL,'PAGO $200,00 \r\nRESTA $200,00 ','2025-09-01 11:25:00',400,2,NULL,NULL,0),(116,3,4,64,'2025-10-06 09:00:00',60,NULL,'Adriel gerente marcellos bar','2025-09-02 20:08:00',400,2,NULL,'2025-10-06 09:00:00',0),(117,2,4,92,'2025-11-08 09:00:00',60,NULL,'PAI DE  FABINHO \r\n','2025-09-04 11:36:00',0,2,NULL,'2025-11-08 19:00:00',0),(118,2,4,93,'2025-12-28 09:00:00',60,NULL,'Resta 400\r\npago $22/12 \r\nTUDO OK ','2025-09-12 12:48:00',800,2,NULL,'2025-12-28 09:00:00',0),(119,4,4,91,'2025-09-16 00:00:00',60,NULL,'Gerente marcellos bar','2025-09-13 17:54:00',0.01,2,NULL,NULL,0),(120,4,4,36,'2025-09-17 00:00:00',60,NULL,'Pago','2025-09-15 12:50:00',200,2,NULL,NULL,0),(121,3,4,94,'2025-10-15 09:00:00',60,NULL,'...','2025-09-16 14:37:00',0,2,NULL,'2025-10-15 09:00:00',0),(122,4,4,84,'2025-09-24 09:00:00',60,NULL,'Já foi reservado só não veiu no dia','2025-09-16 18:09:00',0.01,2,NULL,'2025-09-24 19:00:00',0),(123,4,1,95,'2025-09-19 09:00:00',1,NULL,NULL,'2025-09-18 17:17:00',1,2,NULL,'2025-09-19 19:00:00',0),(124,3,1,96,'2025-09-18 22:20:00',1,NULL,NULL,'2025-09-18 22:21:00',50,1,NULL,'2025-09-18 23:20:00',0),(125,4,2,96,'2025-09-19 10:29:00',1,NULL,NULL,'2025-09-19 10:28:00',50,1,NULL,'2025-09-19 10:29:00',0),(126,3,1,96,'2025-09-19 10:51:00',1,NULL,NULL,'2025-09-19 10:51:00',1,1,NULL,'2025-09-19 10:51:00',0),(127,4,4,97,'2025-10-19 19:30:00',60,NULL,'Já foi pago 300 dia 25/09\r\nResta 400,00','2025-09-25 18:19:00',700,2,NULL,NULL,0),(128,4,4,98,'2025-10-02 09:55:00',60,NULL,'Já foi pago','2025-09-28 15:36:00',300,2,NULL,'2025-10-02 19:00:00',0),(130,4,4,100,'2025-11-30 09:00:00',60,NULL,'Pago 300,00 dia 03/10','2025-10-03 22:10:00',600,2,NULL,'2025-11-30 19:00:00',0),(131,4,4,101,'2025-11-23 09:00:00',60,NULL,'Pagou 250,00 dia 04/10','2025-10-04 23:02:00',500,2,NULL,'2025-11-23 19:00:00',0),(132,4,4,102,'2025-11-02 09:00:00',60,'app/documents/comprovantes/132/6904c5c9e3278_4d1e6e65_ef68_4eae_97dd_9b60631f9d1e.jpg','Pagou 300 dia 25/09\r\nPAGO 400,00 31/10 \r\nTUDO OK ','2025-10-05 18:11:00',700,2,NULL,'2025-11-02 19:00:00',0),(134,4,4,103,'2025-10-22 09:00:00',60,'app/documents/comprovantes/134/68e4121521ae7_427e721f_3ec1_413f_8e10_97416bfe0744.jpg','pago $ 250,00 PIX 06/10 \r\nresta $250,00 ','2025-10-06 16:00:00',500,2,NULL,'2025-10-22 19:00:00',0),(135,2,4,65,'2025-11-22 09:00:00',60,NULL,'.','2025-10-08 10:50:00',0.01,2,NULL,'2025-11-22 19:00:00',0),(136,4,4,104,'2025-11-09 09:00:00',60,'app/documents/comprovantes/136/68e6795565f1e_dae894f2_4fc5_4eb8_ada1_f68c2beb028a.jpg','PAGO $350,00 08/10\r\nRESTA $350,00 ','2025-10-08 11:43:00',700,2,NULL,'2025-11-09 19:00:00',0),(137,4,4,105,'2025-11-16 09:00:00',60,NULL,'Pago 350,00 dia 09/10','2025-10-09 09:15:00',700,2,NULL,'2025-11-16 20:00:00',0),(138,4,4,106,'2025-10-19 09:00:00',60,NULL,'MAGA PRIMA FABIO ','2025-10-13 08:02:00',0,2,NULL,'2025-10-19 19:00:00',0),(139,4,4,107,'2025-11-15 09:00:00',60,NULL,'$400,00 \r\n','2025-10-13 09:04:00',400,2,NULL,'2025-11-15 19:00:00',0),(140,4,5,108,'2025-10-27 09:00:00',60,NULL,'0800','2025-10-13 10:23:00',0,2,NULL,'2025-10-27 19:00:00',0),(141,4,4,109,'2025-10-31 09:00:00',60,NULL,'PAGO 150,00 \r\nRESTA 250,00 ','2025-10-20 11:33:00',400,2,NULL,'2025-10-31 19:00:00',0),(142,2,4,110,'2025-10-30 09:00:00',60,NULL,'0,00','2025-10-20 11:36:00',0.01,2,NULL,'2025-10-30 19:00:00',0),(143,2,4,111,'2026-01-11 09:00:00',60,NULL,'Pago 300,00 27/10\r\nResta 300,00 ','2025-10-27 17:10:00',600,2,NULL,'2026-01-11 19:00:00',1),(144,2,4,112,'2025-11-29 09:00:00',60,NULL,'PAGO $200,00 29/10 \r\nRESTA $500,00 ','2025-10-29 15:07:00',700,2,NULL,'2025-11-29 19:00:00',0),(145,2,4,113,'2025-12-06 09:00:00',60,'app/documents/comprovantes/145/6905fc734a453_comprovante_picpay_pix_01112025090715_1.pdf','Pago $ 350,00 01/11\r\nresta $350,00 ','2025-11-01 09:25:00',700,2,NULL,'2025-12-06 19:00:00',0),(146,4,4,114,'2025-12-13 09:00:00',60,'app/documents/comprovantes/146/6906401b882e7_9b724878_c66f_4d90_967a_205c09d92ff8.jpg','PAGO $300,00 01/11\r\nPAGO $400,00 12/12 \r\nTUDO OK \r\n','2025-11-01 14:14:00',700,2,NULL,'2025-12-13 19:00:00',0),(147,3,4,110,'2025-12-24 09:00:00',60,NULL,'VEA MÃE FABINHO ','2025-11-05 14:04:00',0,2,NULL,'2025-12-25 19:00:00',0),(148,4,4,115,'2025-12-07 19:00:00',60,'app/documents/comprovantes/148/690b9397b358f_comprovante_picpay_pix_05_11_2025_15_09_21_1.pdf','PAGO $350,00 05/11 \r\nRESTA $350,00 ','2025-11-05 15:10:00',700,2,NULL,'2025-12-07 19:00:00',0),(149,4,1,40,'2025-12-18 09:00:00',10,NULL,'FABIO DONO',NULL,0,2,NULL,'2025-12-18 20:00:00',0),(150,2,4,116,'2026-01-20 09:00:00',60,'app/documents/comprovantes/150/690cd56f97b20_1762447636954.pdf','PAGO $300,00 DIA 06/11 \r\n','2025-11-06 14:05:00',300,2,NULL,'2026-01-20 19:00:00',1),(151,2,4,117,'2025-12-21 09:00:00',60,'app/documents/comprovantes/151/690cf73d64a24_06f27bf0_1e9f_46f0_8802_baf01b5528ae.jpg','PAGO 06/11 $350,00\r\nRESTA $350,00 \r\n','2025-11-06 16:27:00',700,2,NULL,'2025-12-21 19:00:00',0),(152,4,4,118,'2026-01-07 09:00:00',60,'app/documents/comprovantes/152/690f3ef1512b5_comprovante_picpay_pix_08112025092853.pdf','pago dia 08/11 250,00\r\nresta 250,00','2025-11-08 09:58:00',500,2,NULL,'2026-01-07 19:00:00',1),(153,3,4,119,'2025-12-20 07:00:00',60,NULL,'pago dia 08/11 - valor 350,00',NULL,700,2,NULL,'2025-12-20 19:00:00',0),(154,3,4,120,'2025-12-19 09:00:00',60,NULL,'VAI PAGAR A KELY 11/11 ','2025-11-10 11:51:00',500,2,NULL,'2025-12-19 19:00:00',0),(155,4,4,121,'2025-12-20 09:00:00',60,NULL,'pago 350,00 dia 11/11\r\nresta 350,00','2025-11-11 20:15:00',700,2,NULL,'2025-12-20 19:00:00',0),(156,4,4,122,'2025-12-27 09:00:00',60,'app/documents/comprovantes/156/6915bf4a6f4f9_f1488087_0294_4363_bb47_8e04857caa7e.jpg','PAGO $350,00 13/11\r\nRESTA $350,00 ','2025-11-13 08:20:00',700,2,NULL,'2025-12-27 19:00:00',0),(157,2,4,110,'2025-11-27 09:00:00',60,NULL,'MÃE FABIO ','2025-11-18 10:28:00',0,2,NULL,'2025-11-27 19:00:00',0),(158,4,4,123,'2025-12-08 09:00:00',60,NULL,'PAGO PIX $500,00 \r\n01/12 TUDO OK ','2025-12-01 14:36:00',500,2,NULL,'2025-12-08 19:00:00',0),(159,2,4,124,'2026-03-01 09:00:00',60,NULL,'pago $50,00 02/12','2025-12-02 15:29:00',50,2,NULL,'2026-03-01 19:00:00',0),(160,2,4,125,'2025-12-10 09:00:00',60,NULL,'TUDO OK. \r\n','2025-12-09 11:49:00',400,2,NULL,'2025-12-10 19:00:00',0),(161,4,4,126,'2026-01-10 09:00:00',60,NULL,'confra nexus telecom ','2025-12-10 08:21:00',0,2,NULL,'2026-01-10 19:00:00',1),(162,2,3,63,'2026-04-26 09:00:00',60,NULL,'....','2025-12-15 08:03:00',0,2,NULL,'2026-04-26 19:00:00',0),(163,2,4,127,'2025-12-26 09:00:00',60,NULL,'PAGO $250,00 16/12\r\nRESTA $250,00 ','2025-12-16 15:20:00',500,2,NULL,'2025-12-26 20:00:00',0),(164,2,4,10,'2026-01-13 09:00:00',60,NULL,'0800 - marcelo bar ','2025-12-29 09:50:00',0,2,NULL,'2026-01-13 19:00:00',0),(165,4,4,128,'2026-01-04 09:00:00',60,'app/documents/comprovantes/165/6952882c569dd_ae77bec3_2108_4c9e_a7ce_f2d160d151cc.jpg','PAGO $350,00 29/12 \r\nRESTA $350,00 ','2025-12-29 10:46:00',700,2,NULL,'2026-01-04 19:00:00',1),(166,3,1,96,'2025-12-30 15:55:00',1,NULL,NULL,'2025-12-29 15:59:00',1,1,NULL,'2025-12-30 19:55:00',1),(167,3,1,96,'2025-12-30 09:45:00',1,NULL,NULL,'2025-12-29 16:15:00',0.01,1,NULL,'2025-12-30 17:00:00',1),(168,2,4,3,'2026-01-24 09:00:00',60,NULL,'PAGO $ 300,00 29/12\r\nRESTA $300,00 ','2025-12-30 08:19:00',600,2,NULL,'2026-01-24 19:00:00',0),(169,4,4,130,'2026-01-05 09:00:00',60,NULL,'PAGO $200,00 30/12\r\nRESTA $200,00 ','2025-12-30 14:08:00',400,2,NULL,'2026-01-05 19:00:00',1),(170,3,4,131,'2026-02-17 09:00:00',60,NULL,'pagou \r\n250,00 dia 05/01\r\nresta 250,00','2026-01-02 09:18:00',500,2,NULL,'2026-02-17 09:00:00',0),(171,2,4,132,'2026-02-18 09:00:00',60,NULL,'Pago 200,00 dia 05/02\r\nResta 200,00','2026-01-05 22:07:00',400,2,NULL,'2026-02-18 19:00:00',0),(172,4,4,133,'2026-01-12 09:00:00',60,NULL,'JA ESTA PAGO 400,00','2026-01-07 23:27:00',400,2,NULL,'2026-01-12 18:55:00',1),(173,2,4,134,'2026-01-18 09:00:00',60,NULL,'PAGOU 300,00 DIA 08/01\r\nRESTA 300,00 ','2026-01-08 11:35:00',600,2,NULL,'2026-01-18 19:00:00',1),(174,2,4,135,'2026-01-22 09:00:00',60,NULL,'Pagou 200 dia 08/01\r\n tudo ok','2026-01-08 21:35:00',400,2,NULL,'2026-01-21 19:00:00',1),(175,2,4,40,'2026-01-15 09:50:00',60,NULL,NULL,'2026-01-09 12:45:00',0.01,2,NULL,'2026-01-15 12:45:00',1),(176,2,4,136,'2026-01-31 09:00:00',60,NULL,'Pago 300,00\r\nResta 300,00','2026-01-09 18:14:00',600,2,NULL,'2026-01-31 19:00:00',0),(177,2,4,137,'2026-02-21 09:00:00',60,NULL,'Pago 300,00 dia 10/01\r\nResta 350,00 vai ficar até as 21','2026-01-10 15:58:00',600,2,NULL,'2026-02-21 19:00:00',0),(178,2,4,82,'2026-01-19 09:00:00',60,NULL,'Pagou 200,00 dia 11/01\r\nResta 200,00','2026-01-11 14:58:00',400,2,NULL,'2026-01-19 19:00:00',0),(179,2,4,73,'2026-01-17 09:00:00',60,NULL,'Já está pago 500,00','2026-01-12 22:07:00',500,2,NULL,'2026-01-17 19:00:00',0),(180,2,4,138,'2026-02-08 09:00:00',60,NULL,'Pago 300,00 13/01\r\nResta 300,00','2026-01-13 13:39:00',600,2,NULL,'2026-02-08 19:00:00',0),(181,2,4,139,'2026-01-25 09:00:00',60,NULL,'Pago 300,00 14/01\r\nResta 300,00','2026-01-14 09:50:00',600,2,NULL,'2026-01-25 19:00:00',1),(182,2,4,140,'2026-02-16 09:00:00',60,NULL,'Pago 228,00 17/01\r\ntudo pago','2026-01-17 10:35:00',400,2,NULL,'2026-02-16 19:00:00',0),(183,2,4,141,'2026-02-01 09:00:00',60,NULL,'Pago 300,00 dia 20/01\r\nResta 300,00','2026-01-20 16:35:00',600,2,NULL,'2026-02-01 19:00:00',0),(184,2,4,141,'2026-02-07 09:00:00',60,NULL,'Pago 300,00 dia 21/01\r\nResta 300.00','2026-01-21 08:42:00',600,2,NULL,'2026-02-07 19:00:00',0),(185,2,4,143,'2026-03-29 19:00:00',50,NULL,'vai pagar no pix ','2026-01-21 12:51:00',600,2,NULL,NULL,0),(186,2,4,144,'2026-02-15 19:00:00',50,NULL,'Pagou 300 dia 21/01\r\nResta 300',NULL,600,2,NULL,NULL,0);

--
-- Table structure for table `reserva_arena`
--

CREATE TABLE `reserva_arena` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idclientes` int(11) NOT NULL,
  `quadra_id` int(11) NOT NULL,
  `data_inicio` datetime NOT NULL,
  `data_final` datetime NOT NULL,
  `obs` text DEFAULT NULL,
  `pagamento` char(1) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `idempresa` int(10) unsigned DEFAULT NULL,
  `valor` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_reserva_arena_1_1` (`idclientes`),
  KEY `fk_reserva_arena_2_2` (`quadra_id`),
  KEY `fk_reserva_arena_3_3` (`idempresa`),
  CONSTRAINT `fk_reserva_arena_1_1` FOREIGN KEY (`idclientes`) REFERENCES `clientes` (`idcliente`),
  CONSTRAINT `fk_reserva_arena_2_2` FOREIGN KEY (`quadra_id`) REFERENCES `quadra` (`id`),
  CONSTRAINT `fk_reserva_arena_3_3` FOREIGN KEY (`idempresa`) REFERENCES `system_unit` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `reserva_arena`
--

INSERT INTO `reserva_arena` (`id`, `idclientes`, `quadra_id`, `data_inicio`, `data_final`, `obs`, `pagamento`, `status`, `idempresa`, `valor`) VALUES (1,96,1,'2025-10-07 06:30:00','2025-10-07 07:30:00',NULL,'0','2',1,50),(5,96,1,'2025-10-08 06:30:00','2025-10-08 07:30:00',NULL,'0','0',1,50);

--
-- Table structure for table `status`
--

CREATE TABLE `status` (
  `idstatus` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(30) NOT NULL,
  `cor` varchar(10) NOT NULL,
  PRIMARY KEY (`idstatus`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`idstatus`, `nome`, `cor`) VALUES (1,'Confirmado','#2b7527'),(2,'Reservado','#2b5c94'),(3,'Cancelado','#a11a20'),(4,'Realizado','#6b6b6b');

--
-- Table structure for table `system_document`
--

CREATE TABLE `system_document` (
  `id` int(11) NOT NULL,
  `system_user_id` int(11) DEFAULT NULL,
  `title` text NOT NULL,
  `description` text DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `submission_date` date DEFAULT NULL,
  `archive_date` date DEFAULT NULL,
  `filename` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_system_document_category_id` (`category_id`),
  KEY `fk_system_document_system_user_id` (`system_user_id`),
  CONSTRAINT `fk_system_document_category_id` FOREIGN KEY (`category_id`) REFERENCES `system_document_category` (`id`),
  CONSTRAINT `fk_system_document_system_user_id` FOREIGN KEY (`system_user_id`) REFERENCES `system_users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_document`
--


--
-- Table structure for table `system_document_category`
--

CREATE TABLE `system_document_category` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_document_category`
--

INSERT INTO `system_document_category` (`id`, `name`) VALUES (1,'Documentação');

--
-- Table structure for table `system_document_group`
--

CREATE TABLE `system_document_group` (
  `id` int(11) NOT NULL,
  `document_id` int(11) NOT NULL,
  `system_group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_system_document_group_document_id` (`document_id`),
  KEY `fk_system_document_group_system_group_id` (`system_group_id`),
  CONSTRAINT `fk_system_document_group_document_id` FOREIGN KEY (`document_id`) REFERENCES `system_document` (`id`),
  CONSTRAINT `fk_system_document_group_system_group_id` FOREIGN KEY (`system_group_id`) REFERENCES `system_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_document_group`
--


--
-- Table structure for table `system_document_user`
--

CREATE TABLE `system_document_user` (
  `id` int(11) NOT NULL,
  `document_id` int(11) NOT NULL,
  `system_user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_system_document_user_document_id` (`document_id`),
  KEY `fk_system_document_user_system_user_id` (`system_user_id`),
  CONSTRAINT `fk_system_document_user_document_id` FOREIGN KEY (`document_id`) REFERENCES `system_document` (`id`),
  CONSTRAINT `fk_system_document_user_system_user_id` FOREIGN KEY (`system_user_id`) REFERENCES `system_users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_document_user`
--


--
-- Table structure for table `system_group`
--

CREATE TABLE `system_group` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `uuid` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_group`
--

INSERT INTO `system_group` (`id`, `name`, `uuid`) VALUES (1,'Admin',NULL),(2,'Standard',NULL),(3,'Reserved',NULL),(4,'Dashboard','54cdfa34-b3e9-4e8d-bfc4-aa83cf30d1b0'),(5,'Reservas','95e76f9b-752d-435b-86e2-41e0c468c9f0'),(6,'Clientes','79c8148c-c946-482d-9f8e-a22b4ddb06be'),(7,'Calendário ','9f5b6218-7d64-42ff-b422-240801621f4f'),(8,'Configuração','e8b9ed8e-52ee-4bb4-a54a-c45f26d0c926'),(9,'Relatorios','91059d5a-2373-4524-beac-a96442e60131'),(10,'Arena MPL','97d1b33c-bbc0-4bb5-844d-875d764aded1'),(11,'MPL Eventos','c0f74335-e92c-4103-8ecc-c6cfda9294b1');

--
-- Table structure for table `system_group_program`
--

CREATE TABLE `system_group_program` (
  `id` int(11) NOT NULL,
  `system_group_id` int(11) NOT NULL,
  `system_program_id` int(11) NOT NULL,
  `actions` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sys_group_program_program_idx` (`system_program_id`),
  KEY `sys_group_program_group_idx` (`system_group_id`),
  CONSTRAINT `fk_system_group_program_system_group_id` FOREIGN KEY (`system_group_id`) REFERENCES `system_group` (`id`),
  CONSTRAINT `fk_system_group_program_system_program_id` FOREIGN KEY (`system_program_id`) REFERENCES `system_program` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_group_program`
--

INSERT INTO `system_group_program` (`id`, `system_group_id`, `system_program_id`, `actions`) VALUES (1,1,1,NULL),(2,1,2,NULL),(3,1,3,NULL),(4,1,4,NULL),(5,1,5,NULL),(6,1,6,NULL),(7,1,8,NULL),(8,1,9,NULL),(9,1,11,NULL),(10,1,14,NULL),(11,1,15,NULL),(12,2,10,NULL),(13,2,12,NULL),(14,2,13,NULL),(15,2,16,NULL),(16,2,17,NULL),(17,2,18,NULL),(18,2,19,NULL),(19,2,20,NULL),(20,1,21,NULL),(21,2,22,NULL),(22,2,23,NULL),(23,2,24,NULL),(24,2,25,NULL),(25,1,26,NULL),(26,1,27,NULL),(27,1,28,NULL),(28,1,29,NULL),(29,2,30,NULL),(30,1,31,NULL),(31,1,32,NULL),(32,1,33,NULL),(33,1,34,NULL),(34,1,35,NULL),(35,1,36,NULL),(36,1,36,NULL),(37,1,37,NULL),(38,1,38,NULL),(39,1,39,NULL),(40,1,40,NULL),(41,1,41,NULL),(42,1,42,NULL),(44,1,44,'[]'),(45,1,43,'[]'),(46,1,45,'[]'),(47,1,46,'[]'),(48,1,47,'[]'),(56,1,48,'[]'),(58,1,49,'[]'),(60,1,50,'[]'),(72,3,12,'[]'),(73,3,13,'[]'),(74,3,43,'[]'),(75,3,44,'[]'),(76,3,45,'[]'),(77,3,46,'[]'),(78,3,47,'[]'),(79,3,48,'[]'),(80,3,49,'[]'),(81,3,50,'[]'),(82,3,51,'[]'),(83,3,53,'[]'),(90,3,54,'[]'),(93,4,43,'[]'),(94,4,44,'[]'),(95,4,45,'[]'),(96,4,46,'[]'),(97,4,47,'[]'),(98,4,49,'[]'),(99,4,50,'[]'),(100,4,51,'[]'),(101,4,52,'[]'),(102,4,53,'[]'),(103,4,54,'[]'),(104,5,47,'[]'),(105,5,54,'[]'),(106,6,44,'[]'),(107,6,54,'[]'),(108,7,49,'[]'),(109,7,50,'[]'),(110,7,54,'[]'),(111,8,53,'[]'),(112,8,54,'[]'),(113,9,54,NULL),(114,10,55,NULL),(115,10,56,NULL),(116,10,57,NULL),(117,10,58,NULL),(118,10,59,NULL),(119,10,60,NULL),(120,10,61,NULL),(121,10,62,NULL),(122,10,63,NULL),(123,11,47,NULL),(124,11,46,NULL),(125,11,49,NULL),(126,11,50,NULL),(127,11,45,NULL),(128,11,54,NULL),(129,8,64,NULL),(130,8,44,NULL),(131,8,43,NULL),(132,8,51,NULL),(133,10,65,NULL);

--
-- Table structure for table `system_message`
--

CREATE TABLE `system_message` (
  `id` int(11) NOT NULL,
  `system_user_id` int(11) NOT NULL,
  `system_user_to_id` int(11) NOT NULL,
  `subject` text NOT NULL,
  `message` text DEFAULT NULL,
  `dt_message` datetime DEFAULT NULL,
  `checked` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_system_message_system_user_id` (`system_user_id`),
  KEY `fk_system_message_system_user_to_id` (`system_user_to_id`),
  CONSTRAINT `fk_system_message_system_user_id` FOREIGN KEY (`system_user_id`) REFERENCES `system_users` (`id`),
  CONSTRAINT `fk_system_message_system_user_to_id` FOREIGN KEY (`system_user_to_id`) REFERENCES `system_users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_message`
--


--
-- Table structure for table `system_notification`
--

CREATE TABLE `system_notification` (
  `id` int(11) NOT NULL,
  `system_user_id` int(11) NOT NULL,
  `system_user_to_id` int(11) NOT NULL,
  `subject` text DEFAULT NULL,
  `message` text DEFAULT NULL,
  `dt_message` datetime DEFAULT NULL,
  `action_url` text DEFAULT NULL,
  `action_label` text DEFAULT NULL,
  `icon` text DEFAULT NULL,
  `checked` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_system_notification_system_user_id` (`system_user_id`),
  KEY `fk_system_notification_system_user_to_id` (`system_user_to_id`),
  CONSTRAINT `fk_system_notification_system_user_id` FOREIGN KEY (`system_user_id`) REFERENCES `system_users` (`id`),
  CONSTRAINT `fk_system_notification_system_user_to_id` FOREIGN KEY (`system_user_to_id`) REFERENCES `system_users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_notification`
--


--
-- Table structure for table `system_preference`
--

CREATE TABLE `system_preference` (
  `id` varchar(255) NOT NULL,
  `preference` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_preference`
--


--
-- Table structure for table `system_program`
--

CREATE TABLE `system_program` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `controller` text NOT NULL,
  `actions` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_program`
--

INSERT INTO `system_program` (`id`, `name`, `controller`, `actions`) VALUES (1,'System Group Form','SystemGroupForm',NULL),(2,'System Group List','SystemGroupList',NULL),(3,'System Program Form','SystemProgramForm',NULL),(4,'System Program List','SystemProgramList',NULL),(5,'System User Form','SystemUserForm',NULL),(6,'System User List','SystemUserList',NULL),(7,'Common Page','CommonPage',NULL),(8,'System PHP Info','SystemPHPInfoView',NULL),(9,'System ChangeLog View','SystemChangeLogView',NULL),(10,'Welcome View','WelcomeView',NULL),(11,'System Sql Log','SystemSqlLogList',NULL),(12,'System Profile View','SystemProfileView',NULL),(13,'System Profile Form','SystemProfileForm',NULL),(14,'System SQL Panel','SystemSQLPanel',NULL),(15,'System Access Log','SystemAccessLogList',NULL),(16,'System Message Form','SystemMessageForm',NULL),(17,'System Message List','SystemMessageList',NULL),(18,'System Message Form View','SystemMessageFormView',NULL),(19,'System Notification List','SystemNotificationList',NULL),(20,'System Notification Form View','SystemNotificationFormView',NULL),(21,'System Document Category List','SystemDocumentCategoryFormList',NULL),(22,'System Document Form','SystemDocumentForm',NULL),(23,'System Document Upload Form','SystemDocumentUploadForm',NULL),(24,'System Document List','SystemDocumentList',NULL),(25,'System Shared Document List','SystemSharedDocumentList',NULL),(26,'System Unit Form','SystemUnitForm',NULL),(27,'System Unit List','SystemUnitList',NULL),(28,'System Access stats','SystemAccessLogStats',NULL),(29,'System Preference form','SystemPreferenceForm',NULL),(30,'System Support form','SystemSupportForm',NULL),(31,'System PHP Error','SystemPHPErrorLogView',NULL),(32,'System Database Browser','SystemDatabaseExplorer',NULL),(33,'System Table List','SystemTableList',NULL),(34,'System Data Browser','SystemDataBrowser',NULL),(35,'System Menu Editor','SystemMenuEditor',NULL),(36,'System Request Log','SystemRequestLogList',NULL),(37,'System Request Log View','SystemRequestLogView',NULL),(38,'System Administration Dashboard','SystemAdministrationDashboard',NULL),(39,'System Log Dashboard','SystemLogDashboard',NULL),(40,'System Session dump','SystemSessionDumpView',NULL),(41,'System files diff','SystemFilesDiff',NULL),(42,'System Information','SystemInformationView',NULL),(43,'Clientes Form','ClientesForm',NULL),(44,'Clientes List','ClientesList',NULL),(45,'Dashboard','Dashboard',NULL),(46,'Reserva Form','ReservaForm',NULL),(47,'Reserva List','ReservaList',NULL),(48,'Config Form','ConfigForm',NULL),(49,'Reserva Calendar Form','ReservaCalendarForm',NULL),(50,'Reserva Calendar Form View','ReservaCalendarFormView',NULL),(51,'Configurações','ConfiguracaoForm',NULL),(52,'Cadastro de unidade ','UnidadeForm',NULL),(53,'Configuração','ConfiguracaoHeaderList',NULL),(54,'Reserva document','ReservaDocument',NULL),(55,'Calendário(Form)','ReservaArenaCalendarForm',NULL),(56,'Calendário(View)','ReservaArenaCalendarFormView',NULL),(57,'Cadastro de quadra','QuadraForm',NULL),(58,'Quadras','QuadraHeaderList',NULL),(59,'Reservas','ReservaArenaList',NULL),(60,'Cadastro de reserva','ReservaArenaForm',NULL),(61,'Cadastro de venda','VendaForm',NULL),(62,'Vendas','VendaList',NULL),(63,'Produtos','ProdutoList',NULL),(64,'Cadastro de produto','ProdutoForm',NULL),(65,'Dashboard','DashboardArena',NULL);

--
-- Table structure for table `system_unit`
--

CREATE TABLE `system_unit` (
  `id` int(10) unsigned NOT NULL,
  `name` text NOT NULL,
  `connection_name` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_unit`
--

INSERT INTO `system_unit` (`id`, `name`, `connection_name`) VALUES (1,'Matriz','matriz'),(2,'MPL Eventos',NULL);

--
-- Table structure for table `system_user_group`
--

CREATE TABLE `system_user_group` (
  `id` int(11) NOT NULL,
  `system_user_id` int(11) NOT NULL,
  `system_group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sys_user_group_group_idx` (`system_group_id`),
  KEY `sys_user_group_user_idx` (`system_user_id`),
  CONSTRAINT `fk_system_user_group_system_group_id` FOREIGN KEY (`system_group_id`) REFERENCES `system_group` (`id`),
  CONSTRAINT `fk_system_user_group_system_user_id` FOREIGN KEY (`system_user_id`) REFERENCES `system_users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_user_group`
--

INSERT INTO `system_user_group` (`id`, `system_user_id`, `system_group_id`) VALUES (39,2,3),(40,2,4),(41,2,5),(42,2,6),(43,2,7),(44,2,8),(45,2,9),(46,4,3),(47,4,4),(48,4,5),(49,4,6),(50,4,7),(51,4,8),(52,4,9),(53,1,1),(54,1,2),(55,1,3),(56,1,4),(57,1,5),(58,1,6),(59,1,7),(60,1,8),(61,1,9),(62,1,10),(63,1,11),(64,3,3),(65,3,4),(66,3,5),(67,3,6),(68,3,7),(69,3,8),(70,3,9),(71,3,10),(72,3,11);

--
-- Table structure for table `system_user_program`
--

CREATE TABLE `system_user_program` (
  `id` int(11) NOT NULL,
  `system_user_id` int(11) NOT NULL,
  `system_program_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sys_user_program_program_idx` (`system_program_id`),
  KEY `sys_user_program_user_idx` (`system_user_id`),
  CONSTRAINT `fk_system_user_program_system_program_id` FOREIGN KEY (`system_program_id`) REFERENCES `system_program` (`id`),
  CONSTRAINT `fk_system_user_program_system_user_id` FOREIGN KEY (`system_user_id`) REFERENCES `system_users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_user_program`
--

INSERT INTO `system_user_program` (`id`, `system_user_id`, `system_program_id`) VALUES (1,2,7);

--
-- Table structure for table `system_user_unit`
--

CREATE TABLE `system_user_unit` (
  `id` int(11) NOT NULL,
  `system_user_id` int(11) NOT NULL,
  `system_unit_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_system_user_unit_system_user_id` (`system_user_id`),
  KEY `fk_system_user_unit_system_unit_id` (`system_unit_id`),
  CONSTRAINT `fk_system_user_unit_system_unit_id` FOREIGN KEY (`system_unit_id`) REFERENCES `system_unit` (`id`),
  CONSTRAINT `fk_system_user_unit_system_user_id` FOREIGN KEY (`system_user_id`) REFERENCES `system_users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `system_user_unit`
--

INSERT INTO `system_user_unit` (`id`, `system_user_id`, `system_unit_id`) VALUES (9,2,1),(10,4,2),(11,1,1),(12,1,2),(13,3,2);

--
-- Table structure for table `venda`
--

CREATE TABLE `venda` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idclientes` int(11) NOT NULL,
  `data_venda` date NOT NULL,
  `total` double NOT NULL,
  `pagamento` varchar(20) NOT NULL,
  `idempresa` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_venda_1_1` (`idclientes`),
  CONSTRAINT `fk_venda_1_1` FOREIGN KEY (`idclientes`) REFERENCES `clientes` (`idcliente`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `venda`
--


--
-- Dumping events for database 'noss2142_reserved'
--

--
-- Dumping routines for database 'noss2142_reserved'
--


