-- Backup gerado em 2026-03-19 07:56:57
-- Banco de dados: tonyoli_controle

-- Estrutura da tabela `categorias`
DROP TABLE IF EXISTS `categorias`;
CREATE TABLE `categorias` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tipo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nome` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dados da tabela `categorias`
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('1', 'entrada', 'Zelle');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('2', 'entrada', 'Cheque');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('3', 'entrada', 'Dinheiro');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('4', 'saída', 'Mercado');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('5', 'saída', 'Água/Luz');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('6', 'saída', 'Empresa');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('7', 'saída', 'Pessoal');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('8', 'saída', 'Combustível');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('9', 'saída', 'Helper');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('10', 'saída', 'Aluguel');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('11', 'saída', 'Outros');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('12', 'entrada', 'Cartao');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('13', 'saída', 'Alimentacao Empresa');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('14', 'saída', 'Prestacao do Carro');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('15', 'saída', 'Seguro do carro');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('16', 'saída', 'Internet');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('17', 'saída', 'Telefone');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('18', 'saída', 'Escola da Rosa');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('19', 'saída', 'Oscar');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('20', 'saída', 'Car Wash');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('21', 'saída', 'Dentista');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('22', 'conta_pagar', 'Aluguel');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('23', 'conta_pagar', 'Água');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('24', 'conta_pagar', 'Luz');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('25', 'conta_pagar', 'Internet');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('26', 'conta_pagar', 'Telefone');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('27', 'conta_pagar', 'Impostos');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('28', 'conta_pagar', 'Fornecedores');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('29', 'conta_pagar', 'Salários');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('30', 'conta_pagar', 'Outros');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('31', 'conta_receber', 'Vendas');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('32', 'conta_receber', 'Serviços');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('33', 'conta_receber', 'Comissões');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('34', 'conta_receber', 'Reembolsos');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('35', 'conta_receber', 'Outros');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('36', 'saída', 'Gasto com carro ');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('37', 'saída', 'Cartao de credito');
INSERT INTO `categorias` (`id`, `tipo`, `nome`) VALUES ('38', 'saída', 'Pedagio');

-- Estrutura da tabela `compromissos`
DROP TABLE IF EXISTS `compromissos`;
CREATE TABLE `compromissos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `compromisso` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `atendido` tinyint DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Estrutura da tabela `contas`
DROP TABLE IF EXISTS `contas`;
CREATE TABLE `contas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `descricao` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `valor` decimal(10,2) NOT NULL,
  `data_vencimento` date NOT NULL,
  `tipo` enum('pagar','receber') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pendente','pago','cancelado') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pendente',
  `categoria_id` int DEFAULT NULL,
  `recorrente` tinyint(1) NOT NULL DEFAULT '0',
  `periodo_recorrencia` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `frequencia` enum('mensal','bimestral','trimestral','semestral','anual') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data_final` date DEFAULT NULL,
  `observacoes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `data_pagamento` date DEFAULT NULL,
  `valor_pago` decimal(10,2) DEFAULT NULL,
  `notificar` tinyint(1) NOT NULL DEFAULT '1',
  `emails_notificacao` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `dias_antecedencia` int NOT NULL DEFAULT '2',
  `data_criacao` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `categoria` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `categoria_id` (`categoria_id`),
  CONSTRAINT `contas_ibfk_1` FOREIGN KEY (`categoria_id`) REFERENCES `categorias` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dados da tabela `contas`
INSERT INTO `contas` (`id`, `descricao`, `valor`, `data_vencimento`, `tipo`, `status`, `categoria_id`, `recorrente`, `periodo_recorrencia`, `frequencia`, `data_final`, `observacoes`, `data_pagamento`, `valor_pago`, `notificar`, `emails_notificacao`, `dias_antecedencia`, `data_criacao`, `categoria`) VALUES ('1', 'test', '20.00', '0000-00-00', 'pagar', '', '9', '0', '', NULL, NULL, NULL, NULL, NULL, '1', 'beneoliver2013@gmail.com', '2', '2025-05-08 19:23:03', NULL);
INSERT INTO `contas` (`id`, `descricao`, `valor`, `data_vencimento`, `tipo`, `status`, `categoria_id`, `recorrente`, `periodo_recorrencia`, `frequencia`, `data_final`, `observacoes`, `data_pagamento`, `valor_pago`, `notificar`, `emails_notificacao`, `dias_antecedencia`, `data_criacao`, `categoria`) VALUES ('2', 'Conta de teste simples', '100.00', '2025-05-08', 'pagar', 'pendente', '4', '1', 'mensal', 'mensal', NULL, NULL, NULL, NULL, '1', 'teste@example.com', '2', '2025-05-08 19:37:28', NULL);
INSERT INTO `contas` (`id`, `descricao`, `valor`, `data_vencimento`, `tipo`, `status`, `categoria_id`, `recorrente`, `periodo_recorrencia`, `frequencia`, `data_final`, `observacoes`, `data_pagamento`, `valor_pago`, `notificar`, `emails_notificacao`, `dias_antecedencia`, `data_criacao`, `categoria`) VALUES ('3', 'Conta de teste simples', '100.00', '2025-05-08', 'pagar', 'pendente', '4', '1', 'mensal', 'mensal', NULL, NULL, NULL, NULL, '1', 'teste@example.com', '2', '2025-05-08 19:37:45', NULL);

-- Estrutura da tabela `contas_a_pagar`
DROP TABLE IF EXISTS `contas_a_pagar`;
CREATE TABLE `contas_a_pagar` (
  `id` int NOT NULL AUTO_INCREMENT,
  `valor` decimal(10,2) DEFAULT NULL,
  `descricao` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `categoria` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data_vencimento` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint DEFAULT '0',
  `recorrente` tinyint(1) DEFAULT '0',
  `frequencia` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dia_vencimento` int DEFAULT NULL,
  `proxima_data_vencimento` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data_fim` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Estrutura da tabela `customers`
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `address` text,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `zip` varchar(20) DEFAULT NULL,
  `notes` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb3;

-- Dados da tabela `customers`
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('7', 'Vikingbusiness llc', 'Vikingbusinessllc@gmail.com', '239 672 3217', '', 'Kissimmee', 'Florida', '34746', '5160 Adelaide dr', '2025-04-18 07:03:22', '2025-07-06 06:24:09');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('13', 'Anna', 'homeowners@greenheart.host', '+1 (954) 864-4781', '.', '', '', '', 'Chamada de Emergência 9:17', '2025-04-23 18:35:33', '2025-07-31 08:34:46');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('14', 'Pastor Jhon', '', '(407) 802-7813', 'Kirkman Rd', 'Orlando', 'FL', '32811', '', '2025-04-24 08:12:45', '2025-04-26 11:50:02');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('15', 'Scott ', '', '+1 (407) 756-2628', '160 south Phelps ave  Winter park FL', 'Orlando', 'FL', '32789', '', '2025-04-24 21:15:36', '2025-04-24 21:15:36');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('16', 'Paloma Froldi', '', '+1 (407) 360-5466', '8558 powder ridge trail', 'Orlando ', 'Fl', '', '', '2025-04-24 21:20:08', '2025-04-24 21:20:08');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('17', 'Brant Anderson ', 'brantanderson@shaw.ca', '+1 403-816-9692', '14094 Avenues of the groves ', 'Orlando ', 'Fl', '', '', '2025-04-24 21:26:48', '2025-04-24 21:26:48');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('18', 'Moses', '', '+1 (786) 797-2545', '3003 boat lift road ', 'Kissimme', 'Fl', '34746', '', '2025-04-24 21:31:11', '2025-04-24 21:31:11');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('19', 'Silvia', 'beneoliver2013@gmail.com', '321 914 9358', '2137 la due court ', 'Orlando ', 'FL', '32811', '', '2025-04-24 21:34:05', '2025-04-28 04:52:20');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('23', 'JOANEL PROPERTIES LLC', 'joseph.nagy2011@gmail.com', '347-209-4324', '5320 Paradise Cay Cir', 'Kisseemme', 'Fl', '34746', '', '2025-04-26 18:22:30', '2025-04-26 18:22:30');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('24', 'Isaaque Kinufer ', '', '+1 (407) 616-0926', '8406 sun dr', 'Orange Brosson', 'Fl', '', '', '2025-04-26 19:21:23', '2025-04-26 19:29:46');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('25', 'Ramesh Vanapalli', 'Rvanapalli@yahoo.com', '+1 (305) 798-5508', '', 'Orlando ', 'Fl', '', '', '2025-04-27 07:58:43', '2025-09-03 18:13:55');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('26', 'Ruthy Orlanda', '', '407 844 0675', '407 844 0675', 'Orlando', 'fl', '', '', '2025-04-28 04:57:51', '2025-04-28 04:57:51');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('27', 'Lily ', '', '+1 (407) 580-9374', '515 Winter Terrace', '  Winter Haven', 'Fl', '33881', '', '2025-04-29 09:27:18', '2025-04-29 09:27:18');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('28', 'Ghazala Shahab', 'ghazalashahabfl@gmail.com', '3212082139', '12156 Sumter Drive ', 'Orlando', 'Florida', '32824', '', '2025-04-29 14:38:16', '2025-04-29 14:38:16');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('29', 'Wendy ', '', '407 580 9374', '1468 Scarlet Oak Loop', '', 'Fl', '', '', '2025-04-29 18:28:19', '2025-06-15 16:31:29');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('30', 'Fabio Melli', '', '', '', '', '', '', '', '2025-05-01 09:51:37', '2025-05-01 09:51:37');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('32', 'Victor', '', '', '', '', '', '', '', '2025-05-02 09:17:21', '2025-05-02 09:17:21');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('38', 'Steve Hamlin', '', '(239) 887-8991', '17800 Palm View cir. Mount dora fl 32757 Just in case', 'Mount dora', 'Fl', '32757', '', '2025-05-05 19:18:10', '2025-05-05 19:18:10');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('39', 'Milena Russel', 'milena@overrussell.com.br', '3213934736', '1011 Lake Berkeley ', 'Kissimmee ', 'Fl', '34746', '', '2025-05-07 14:27:34', '2025-05-07 14:40:41');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('40', 'Simaria', '', '8633305121', '', 'Inovation', 'Fl', '32832', '', '2025-05-09 08:17:31', '2025-05-09 08:17:31');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('41', 'Kate ', 'admin@admin.com', '(407) 221-9640', '4015 Moores Station Rd.', 'Sanford', 'FL', '', '', '2025-05-13 10:26:52', '2025-06-06 09:12:57');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('42', 'Marty Mann ', 'martymann@hotmail.com', '+1 (407) 694-4823', 'Marty Mann 1921 Kings Point Blvd. Kissimmee, FL', 'Kisseemme', 'Fl', '34744', '', '2025-05-16 07:34:21', '2025-05-20 11:11:28');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('43', 'Wison', '', '', '3068 Bay laurel circle', 'Kissimmee', 'Fl', '34744', '', '2025-05-18 11:34:04', '2025-05-18 11:34:04');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('45', 'Douglas ', '', '', '530 goldenmoss loop,', 'Ocoee', 'Fl', '34761', 'Gate code is #2633', '2025-05-19 18:08:26', '2025-05-19 18:08:26');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('47', 'Michael ', '', '32835-6614', '‪7109 Yacht Basin Ave‬ ', 'Orlando ', 'Fl', '', '', '2025-05-20 09:07:55', '2025-05-20 09:07:55');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('49', 'Polar Bears', '', '305 965 6799', '4301 Lizshire Lane C-211', 'Orlando', 'FL', '32835', 'Secretaria Ianela', '2025-05-20 13:26:13', '2025-06-04 08:21:55');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('51', 'Alberto Gutierrez', 'Albertscie@gmail.com', '(786) 290-6664', '7753 Hyacinth Dr', 'Orlando', 'Fl', '32835', '', '2025-05-22 09:21:13', '2025-05-22 09:21:13');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('54', 'Emilio', '', '+1 (407) 535-2115', '988 Osceola trail', 'Casselberry', 'Fl', '32707', '', '2025-05-23 13:14:53', '2025-05-23 13:14:53');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('55', 'Alfredo ', '', '407 409 5005', '4020 Calabria Ave', 'Davenport', 'Fl', '33897', '', '2025-05-24 18:13:27', '2025-05-24 18:13:27');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('56', 'Roy Mara Días Angel Guerrero', '', '4079954639', '5109 Crown Haven Dr ', 'Kisseemme', 'Fl', '3474', '', '2025-05-28 07:05:16', '2025-05-28 07:05:16');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('57', '3200 Cimarron drive. Orlando. 32829', 'beneoliver2013@gmail.com', '3214192166', '3200 Cimarron drive. Orlando. 32829', 'Orlando', 'FL', '32811', '', '2025-05-28 14:46:35', '2025-05-28 14:46:35');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('58', '1 Rental Solution ', '', '', '5109 Crown Haven Dr', 'Kisseemme', 'Fl', '', '', '2025-05-29 18:51:23', '2025-05-29 18:57:56');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('80', 'Cris Macgrath', '', '832 276 2463', '14837 Trapper rd', 'Orlando', 'fl', '', '', '2025-06-03 13:38:31', '2025-06-03 13:48:48');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('96', 'Henry Bueno', '', '+1 (786) 709-7345', '14237 Holly Pond ct orlando fl 32824', 'Orlando ', 'Fl', '32824', '', '2025-06-10 05:18:14', '2025-06-10 05:18:14');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('97', 'Jacob', '', '+1 (321) 320-5158', '14090 Ave of the groves', 'Winter Garden', 'Fl', '', '', '2025-06-10 16:46:16', '2025-06-10 16:46:16');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('98', 'Dejacir', '', '', '', '', '', '', '', '2025-06-10 18:32:21', '2025-06-10 18:32:21');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('99', 'Dejacir', '', '', '', '', '', '', '', '2025-06-10 18:32:25', '2025-06-10 18:32:25');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('100', 'Michelle ', '', '+1 (407) 709-8516', '2114 W. Martin St. ', 'Kissimmee', 'Fl', '34741', '', '2025-06-15 15:08:38', '2025-06-15 15:08:38');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('101', '850 Monopoly Court Orlando Florida', '', '', '', '', '', '', '', '2025-06-18 14:37:31', '2025-06-18 14:37:31');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('102', 'Fabiana', '', '+1 (407) 595-4369', '230 Captain Hook Way', 'Davenport', 'Fl', '33387', '', '2025-06-25 08:57:08', '2025-06-25 08:57:08');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('103', 'Favio', '', '+1 (407) 722-2594', '2131 Tall Oak Dr Winter Garden, FL ', 'Winter Garden ', 'Fl', '34787', '', '2025-06-27 12:46:42', '2025-06-27 12:46:42');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('104', 'Fabio', '', '+1 (407) 722-2594', '', '', '', '', '', '2025-06-27 12:49:19', '2025-06-27 12:49:19');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('105', 'Andreia Cristina Mesquita ', '', '+55 24 99215-9640', '3001 Sunset Vista Blvd ', 'Kisseemme', 'Fl', '', '', '2025-07-01 08:03:06', '2025-07-01 08:03:06');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('106', 'Urbanstyle Barber', '', '+1 (407) 425-0333', '', 'Orlando', '', '', '', '2025-07-06 18:09:47', '2025-07-06 18:09:47');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('107', 'Urbanstyle Barber', '', '+1 (407) 425-0333', '', 'Orlando', '', '', '', '2025-07-07 07:54:47', '2025-07-07 07:54:47');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('108', 'Kaila Lin', '', '+1 (321) 300-6868', '9038 Sperry St,', 'Orlando', '', '32827', '', '2025-07-10 13:28:19', '2025-07-10 13:28:19');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('109', 'Erick Sampaio', '', '', '2517 dharma circle', 'Kisseemme', '', '', '', '2025-07-11 04:11:02', '2025-07-11 04:11:02');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('110', 'Alberto Elmorro ', '', '+1 (407) 885-4872', '8746 Fort Shea Ave  Orlando FL 32822', '', '', '', '', '2025-07-14 11:32:12', '2025-07-14 11:32:12');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('111', ' Fenestrum LLC', '', '', '2049 Traemoor Village Dr.,', 'Nashville', 'TN', '37209', '', '2025-07-15 14:41:19', '2025-07-15 14:49:33');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('112', 'Jeremy Langley', 'Jwl7272@aol.com', '+1 (859) 552-5224', '16530 Caju Rd', 'Clermont', 'FL', '34711', '', '2025-07-24 04:53:55', '2025-07-24 09:35:39');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('113', 'Nabil', '', '4076198349', '544 S Duncan dr', 'Tavares', 'FL', '32778', '', '2025-08-01 06:23:12', '2025-08-01 06:23:12');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('114', 'Jonatas ', '', '(352) 989-6503', '', 'Orlando ', '', '', '', '2025-08-01 11:02:23', '2025-08-01 11:02:23');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('115', 'Chad', '', '+1 (407) 583-7227', '564 Bitterwood ct ', 'Kissimmee', 'Fl', '34743', '', '2025-08-11 13:29:37', '2025-08-11 13:29:37');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('116', 'Sam Salim', 'samsalim2007@gmail.com', '+1 (321) 208-2139', '12156 Sumter dr', 'Orlando', 'Florida ', '32824', '', '2025-08-13 17:34:12', '2025-08-13 17:34:12');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('117', 'Debra Daniel', '', '', '1455 Beechwood dr', 'K', 'fl', '', '', '2025-08-25 06:46:09', '2025-08-25 06:46:09');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('118', 'Koffi', '', '763 2449017', '5016 Anzio Street', 'Orlando', 'fl', '32819', '', '2025-08-25 06:53:30', '2025-08-25 06:53:30');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('119', 'Nicolas Miguel', '', '917 9919765', '1905 Lazy Oaks Loop', 'Saint Cloud', 'fl', '34771', '', '2025-08-25 07:01:02', '2025-08-25 07:01:02');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('120', 'Randall', '', '407 3000244', '4311 Tomlinson Circle', 'Orlando', 'fl', '32829', '', '2025-08-25 07:12:25', '2025-08-25 07:12:25');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('121', '2941 cello ln', '', '+1 (904) 859-0505', '2941 Cello Ln, Kissimmee, FL 34741', 'Kissimmee', 'Fl', '34741', '', '2025-08-30 03:55:06', '2025-08-30 03:55:06');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('122', 'Sukhbir Singh', 'ssarsingh@yahoo.com', '(904) 859-0505', '', '', '', '', '', '2025-08-30 04:46:20', '2025-08-30 04:46:20');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('123', 'a', '', '', '', '', '', '', '', '2025-09-02 18:33:47', '2025-09-02 18:33:47');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('124', 'a', '', '', '', '', '', '', '', '2025-09-02 19:09:19', '2025-09-02 19:09:19');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('125', 'antonio', '323`1@d', '23`23`23`23`1', '', '', '', '', '', '2025-09-02 19:18:19', '2025-09-02 19:18:19');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('126', 'Neto', 'Fgf@g', '454444454', '', '', '', '', '', '2025-09-03 05:57:33', '2025-09-03 05:57:33');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('127', 'teste', 'jggu@g', '099888099', '', '', '', '', NULL, '2025-09-03 06:15:43', '2025-09-03 06:15:43');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('128', 'testeq', 'jhgjgg@g', '55555', '', '', '', '', NULL, '2025-09-03 06:21:49', '2025-09-03 06:21:49');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('129', 'testeq', '', '', '', '', '', '', NULL, '2025-09-03 06:22:27', '2025-09-03 06:22:27');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('130', 'marc', 'hfgh@g', '0080909-9-0', 'oihoiojuoij', 'oohihui', 'oi', '32811', NULL, '2025-09-03 06:26:59', '2025-09-03 06:26:59');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('131', 'marco', 'gtfyfytf@g', '099808', '', '', '', '', NULL, '2025-09-03 06:30:36', '2025-09-03 06:30:36');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('132', 'marcos', 'hff@g', '4765775775', '', '', '', '', NULL, '2025-09-03 06:40:58', '2025-09-03 06:40:58');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('133', 'Marcoss', '', '', '', '', '', '', NULL, '2025-09-03 06:53:14', '2025-09-03 06:53:14');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('134', 'marcu', 'd@g', '566755576', '', '', '', '', NULL, '2025-09-04 04:24:37', '2025-09-04 04:24:37');
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `notes`, `created_at`, `updated_at`) VALUES ('135', 'marci', 'a@g', '131313', '', '', '', '', NULL, '2025-09-04 04:33:12', '2025-09-04 04:33:12');

-- Estrutura da tabela `descricoes_predefinidas`
DROP TABLE IF EXISTS `descricoes_predefinidas`;
CREATE TABLE `descricoes_predefinidas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `categoria` varchar(100) NOT NULL,
  `descricao` varchar(255) NOT NULL,
  `tipo` enum('entrada','saída') NOT NULL DEFAULT 'saída',
  `ativo` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_categoria` (`categoria`),
  KEY `idx_tipo` (`tipo`),
  KEY `idx_ativo` (`ativo`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb3;

-- Dados da tabela `descricoes_predefinidas`
INSERT INTO `descricoes_predefinidas` (`id`, `categoria`, `descricao`, `tipo`, `ativo`, `created_at`) VALUES ('67', 'Mercado', 'Jonatas', 'saída', '1', '2025-08-11 23:00:15');
INSERT INTO `descricoes_predefinidas` (`id`, `categoria`, `descricao`, `tipo`, `ativo`, `created_at`) VALUES ('68', 'Combustível', 'Compania', 'saída', '1', '2025-08-11 23:02:20');
INSERT INTO `descricoes_predefinidas` (`id`, `categoria`, `descricao`, `tipo`, `ativo`, `created_at`) VALUES ('69', 'Água/Luz', 'Casa', 'saída', '1', '2025-08-11 23:06:54');

-- Estrutura da tabela `entradas`
DROP TABLE IF EXISTS `entradas`;
CREATE TABLE `entradas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `valor` decimal(10,2) DEFAULT NULL,
  `descricao` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `categoria` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=223 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dados da tabela `entradas`
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('130', '200.00', 'New hair', 'Zelle', '01/24/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('131', '110.00', 'Tyler', 'Zelle', '01/25/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('132', '360.00', 'gap home', 'Zelle', '01/26/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('134', '678.00', 'Deposito', 'Zelle', '01/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('136', '165.00', 'deposito', 'Cheque', '01/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('137', '150.00', 'Ramesh', 'Zelle', '01/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('138', '50.00', 'New hair', 'Zelle', '01/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('139', '20.00', 'D Expert', 'Zelle', '01/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('140', '360.00', 'Gap', 'Zelle', '02/09/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('142', '53.00', 'salgados ven', 'Zelle', '02/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('143', '250.00', 'praeter', 'Zelle', '02/13/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('144', '212.00', 'Fill solution', 'Zelle', '02/26/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('145', '270.00', 'Fernanda', 'Zelle', '02/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('146', '1000.00', 'Romade', 'Dinheiro', '01/01/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('147', '80.00', 'Edys', 'Zelle', '03/01/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('148', '580.00', 'Syed', 'Zelle', '03/04/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('149', '120.00', 'Ola Ham', 'Zelle', '03/04/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('150', '580.00', 'Adriana alves', 'Zelle', '03/06/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('151', '280.00', 'Sem descricao', 'Cheque', '03/06/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('152', '210.00', 'praeter', 'Zelle', '03/08/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('153', '320.00', 'Danielle Souza', 'Zelle', '03/11/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('154', '160.00', 'Noman', 'Zelle', '03/11/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('155', '140.00', 'urban', 'Zelle', '03/11/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('156', '938.00', 'Elmorro', 'Zelle', '03/18/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('157', '688.32', 'Streams church', 'Zelle', '03/18/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('158', '59.63', 'ebay', 'Zelle', '03/18/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('159', '75.00', 'Streams church', 'Zelle', '03/25/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('160', '80.00', 'Minervino', 'Zelle', '03/26/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('161', '40.00', 'Elmorro', 'Zelle', '03/27/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('163', '72.00', 'salgados ven', 'Zelle', '03/31/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('164', '360.00', 'Fill Solution', 'Zelle', '04/01/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('165', '610.00', 'Stream church', 'Zelle', '04/11/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('166', '60.00', 'JF Lopes', 'Zelle', '04/12/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('167', '20.00', 'Aryclives Alves', 'Zelle', '04/12/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('168', '170.00', 'Plaeter OPT', 'Zelle', '04/15/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('169', '122.00', 'cheque', 'Cheque', '04/17/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('170', '90.00', 'Sem descricao', 'Cheque', '04/17/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('171', '200.00', 'Baby Ruth', 'Zelle', '04/18/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('172', '375.40', 'Ronaldo', 'Zelle', '04/22/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('173', '120.00', 'Praeter', 'Zelle', '04/22/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('174', '240.00', 'Liz Torres', 'Zelle', '04/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('175', '450.00', 'Urban', 'Zelle', '04/30/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('176', '350.00', 'deposito atm', 'Dinheiro', '05/03/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('177', '180.00', 'svt bus', 'Zelle', '05/03/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('178', '450.00', 'ferro corp', 'Zelle', '05/10/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('179', '170.00', 'Plaeter OPT', 'Zelle', '05/09/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('180', '822.00', 'Plaeter OPT', 'Zelle', '05/13/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('181', '400.00', 'svt bus', 'Zelle', '05/13/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('183', '2900.00', 'Sem descricao', 'Cheque', '05/14/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('184', '2500.00', 'ferro corp', 'Zelle', '05/17/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('185', '140.00', 'itatiana', 'Zelle', '05/17/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('186', '3228.80', 'merchant', 'Zelle', '05/20/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('188', '200.00', 'valmir', 'Zelle', '05/13/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('189', '752.00', 'primelife', 'Zelle', '05/21/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('190', '3456.00', 'Sem descricao', 'Cheque', '05/22/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('191', '203.40', 'praeter', 'Zelle', '05/22/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('192', '170.00', 'cintia', 'Zelle', '05/22/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('194', '212.22', 'Sem descricao', 'Zelle', '05/28/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('195', '140.00', 'elmorro', 'Zelle', '05/28/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('197', '120.00', 'Ronaldo', 'Zelle', '05/28/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('198', '2304.00', 'Sem descricao', 'Cheque', '05/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('199', '147.38', 'Sem descricao', 'Zelle', '05/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('200', '40.00', 'Elmorro', 'Zelle', '05/29/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('201', '1120.00', 'Ana di sessa', 'Zelle', '05/30/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('202', '210.00', 'Jeffrey', 'Zelle', '05/30/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('203', '2027.00', 'Sem descricao', 'Cheque', '05/31/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('204', '1020.00', 'Ana Lima', 'Zelle', '06/03/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('205', '690.00', 'David Doyle', 'Zelle', '06/03/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('206', '630.00', 'Sem descricao', 'Cheque', '06/03/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('207', '270.00', 'Sem descricao', 'Cheque', '06/03/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('208', '60.00', 'Ana Lima', 'Zelle', '06/03/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('209', '735.00', 'Sem descricao', 'Dinheiro', '06/05/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('210', '200.00', 'Mahatma Haeri', 'Zelle', '06/05/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('211', '140.00', 'John Keepn', 'Zelle', '06/12/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('212', '2487.00', 'Sem descricao', 'Dinheiro', '06/18/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('213', '120.00', 'El morro', 'Zelle', '06/20/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('214', '36.00', 'Silmaria', 'Zelle', '06/20/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('215', '530.00', 'Wallace', 'Zelle', '06/24/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('216', '520.00', 'Daniel', 'Zelle', '06/24/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('217', '187.00', 'Sem descricao', 'Cartao', '06/24/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('218', '187.00', 'Sem descricao', 'Cartao', '06/24/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('219', '180.00', 'Praeter', 'Zelle', '06/24/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('220', '230.00', 'Itatiana', 'Zelle', '06/26/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('221', '250.00', 'Henry Bueno', 'Zelle', '06/27/24');
INSERT INTO `entradas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('222', '200.00', 'Filipe da Silva', 'Zelle', '06/27/24');

-- Estrutura da tabela `inventory`
DROP TABLE IF EXISTS `inventory`;
CREATE TABLE `inventory` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` text,
  `sku` varchar(50) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `cost` decimal(10,2) DEFAULT NULL,
  `quantity` int DEFAULT '0',
  `category` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb3;

-- Dados da tabela `inventory`
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('4', 'Ac Services', '', '100001', '160.00', '10.00', '10000', '', '2025-04-18 06:53:43', '2025-04-18 06:54:51');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('5', 'Frion R410 (Per Pound)', 'Freon R410', '10002', '90.00', '10.00', '23', 'Freon', '2025-04-23 17:13:03', '2025-04-23 17:13:35');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('6', 'Capacitor 45/440', '440Volts', '10003', '180.00', '8.00', '0', 'Eletric ', '2025-04-24 09:20:46', '2025-05-04 16:58:07');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('7', 'Contactor 1-1/2', 'Simple 30 Amp', '10004', '240.00', '14.00', '0', '', '2025-04-24 09:23:31', '2025-05-04 16:59:11');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('8', 'Contactor 2Contact', 'Double contact 30 Amp', '10005', '245.00', '15.00', '0', 'Eletric ', '2025-04-24 09:25:23', '2025-05-04 17:00:17');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('9', 'Call Fee', 'Up 10 Miles ', '10006', '80.00', '0.00', '0', 'Fee', '2025-04-24 09:26:53', '2025-04-24 09:26:53');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('10', 'Installation kit and Labor ', 'Regular installation ', '', '2860.00', '0.00', '0', '', '2025-04-24 09:29:25', '2025-04-24 09:29:25');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('11', 'Drain Float Switch', 'Installed', '', '220.00', '20.00', '0', 'Drain', '2025-04-24 20:18:02', '2025-07-24 10:01:26');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('12', 'Fuse 5/7 Amp', 'part&Labor', '', '180.00', '5.00', '0', 'Eletric ', '2025-04-24 20:19:27', '2025-04-24 20:23:37');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('13', 'Fuse 30Amp', 'Labor&part', '', '140.00', '0.00', '0', 'Eletric ', '2025-04-24 20:21:34', '2025-04-24 20:21:34');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('14', 'GE 30AMP FUSED AC DISCONNECT ', '', '043481000824', '60.00', '17.26', '0', 'Eletric ', '2025-04-25 06:40:11', '2025-04-25 06:40:11');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('15', 'Eletric wire 12-2 Orange (Per feet)', '', '048243984060', '4.00', '1.52', '0', 'Eletric ', '2025-04-25 06:46:54', '2025-04-25 06:46:54');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('16', 'STRAP 1/2\" PK25                      ', '', '051411261511', '14.50', '5.62', '0', 'Eletric ', '2025-04-25 06:52:33', '2025-04-25 06:52:33');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('17', '1/2\" Plastic conduit (Per Feet)', '', '032886045998', '5.00', '1.12', '0', 'Eletric ', '2025-04-25 07:05:38', '2025-05-04 16:56:57');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('18', 'Stop leak sealant', 'Sealant', '', '127.00', '27.00', '0', 'Sealant', '2025-04-25 20:12:07', '2025-04-25 20:12:07');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('19', 'Mini Split 12.000', 'New', '', '1500.00', '550.00', '2', 'Novo', '2025-04-25 20:43:22', '2025-04-25 20:43:22');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('20', '2,5 Tons Airdach', '', '', '2530.00', '1650.00', '0', 'New', '2025-04-26 19:37:02', '2025-04-26 19:37:02');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('21', 'Regular Thermostat ', '', '', '208.00', '32.00', '0', 'Thermostat ', '2025-04-27 08:02:52', '2025-04-27 08:02:52');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('24', 'Freon R22', '', '', '97.00', '20.00', '0', 'Freon', '2025-04-28 07:18:54', '2025-04-28 07:18:54');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('25', 'Capacitor 10/440', '', '', '60.00', '8.00', '0', 'Eletric ', '2025-04-28 07:19:55', '2025-04-28 07:19:55');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('26', 'Capacitor 10/440', '', '', '60.00', '8.00', '0', 'Eletric ', '2025-04-28 07:21:06', '2025-04-28 07:21:06');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('27', 'Desconect box', '', '', '60.00', '13.00', '0', '', '2025-04-29 10:28:45', '2025-04-29 10:28:45');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('28', 'Tuttocool 5tons H/P', '', '', '6800.00', '2200.00', '0', '', '2025-05-01 09:53:34', '2025-05-01 09:53:34');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('29', '5tons H/P Carrier', '', '', '8600.00', '4900.00', '0', '', '2025-05-01 09:54:44', '2025-05-01 09:54:44');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('30', '5tons Tuttocoll HP Condenser', '', '', '6760.00', '3255.00', '0', '', '2025-05-01 10:06:36', '2025-05-16 16:28:04');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('32', 'Fan motor ', 'Air Handler fan motor 230v 1/2hp', '8012B', '580.00', '96.00', '0', 'Us motor', '2025-05-07 14:33:18', '2025-05-07 14:33:18');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('33', '2Tons HP Carrier ', 'Parts and Labor (regular instalation)\r\n10 Years waranty by the Factory (Compressor)', '14.3 SEER', '7680.00', '3501.00', '1', 'Residential Ac System', '2025-05-12 08:02:09', '2025-05-12 08:14:10');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('34', '2Tons HP Oxbox Trane', 'Parts and Labor\r\n10 Years Warranty by the factory', '14.3 SEER', '5820.00', '2116.00', '1', 'Residential Ac System', '2025-05-12 08:07:48', '2025-05-12 08:07:48');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('35', '2Tons HP Ducane', 'Parts and Labor\r\n10 Years Warranty by the factory', '14.7 SEER', '6310.00', '2478.00', '1', 'Residential Ac System', '2025-05-12 08:11:51', '2025-05-12 08:11:51');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('36', 'Honeywell Thermostat', '', 'T4 Pro', '174.00', '44.00', '0', 'Thermostat ', '2025-05-12 18:54:07', '2025-05-13 05:31:33');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('37', 'Regular Drain Cleaning ', '', '', '160.00', '0.00', '0', 'Cleaning ', '2025-05-14 10:25:48', '2025-05-14 10:25:48');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('38', '3.5 Tons HP Tuttocool ', '', 'Installed ', '6290.00', '3689.00', '0', 'Units', '2025-05-16 16:34:51', '2025-05-16 16:37:00');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('39', 'Preventive maintenance ', '', '10782', '160.00', '10.00', '0', 'Maintenance ', '2025-05-18 11:36:40', '2025-05-18 11:36:40');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('40', '2.5 Tons Carrier', '', '', '6680.00', '3200.00', '0', 'Units', '2025-05-23 13:34:14', '2025-05-23 13:34:14');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('41', '2.5 Tons Tuttokool', '', '', '5780.00', '0.00', '0', 'Units ', '2025-05-23 13:36:48', '2025-05-23 13:36:48');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('42', '3.5 Tons SC Carrier', '10 years warranty by the factory ', 'New', '6500.00', '0.00', '0', 'Units', '2025-05-28 14:53:11', '2025-08-23 19:18:20');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('43', '2.5 Ducane Hp', '', '', '5830.00', '0.00', '0', '', '2025-06-27 12:53:03', '2025-06-27 12:53:03');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('44', 'Cleaning - Primary drain pan', 'Removal of built-up debris, sludge, and microbial growth from the primary drain pan to ensure proper drainage and prevent overflows or system shutdowns.', '', '150.00', '0.00', '0', 'Cleaning ', '2025-07-24 05:58:55', '2025-07-24 05:58:55');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('45', 'Cleaning - Drain line flush ', 'Clears clogs and buildup from the condensate drain line using pressurized flushing to restore proper drainage and prevent water backups or leaks.', '', '150.00', '0.00', '0', '', '2025-07-24 06:04:30', '2025-07-24 06:04:30');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('46', 'Cleaning - Drain line flush ', 'Clears clogs and buildup from the condensate drain line using pressurized flushing to restore proper drainage and prevent water backups or leaks.', '', '150.00', '0.00', '0', '', '2025-07-24 06:11:47', '2025-07-24 06:11:47');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('47', 'Cleaning - Blower wheel ', 'Removal of dust, dirt, and microbial buildup from the indoor blower wheel to restore airflow efficiency, improve air quality, and prevent system strain.', '', '180.00', '0.00', '0', 'Cleaning ', '2025-07-24 06:14:28', '2025-07-24 06:14:28');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('48', 'Blower motor replacement ', '', '', '530.00', '0.00', '0', 'Motor', '2025-07-24 09:58:25', '2025-07-24 09:58:25');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('49', 'Air Filter ', '', '', '22.00', '22.00', '0', 'Filter ', '2025-07-31 08:22:15', '2025-07-31 08:22:15');
INSERT INTO `inventory` (`id`, `name`, `description`, `sku`, `price`, `cost`, `quantity`, `category`, `created_at`, `updated_at`) VALUES ('50', 'Cleaning the clothes dryer duct', '', '', '160.00', '0.00', '0', 'Cleaning ', '2025-08-26 05:55:36', '2025-08-26 05:55:36');

-- Estrutura da tabela `lembretes`
DROP TABLE IF EXISTS `lembretes`;
CREATE TABLE `lembretes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `conta_id` int NOT NULL,
  `data_lembrete` date NOT NULL,
  `enviado` tinyint(1) NOT NULL DEFAULT '0',
  `data_envio` datetime DEFAULT NULL,
  `data_criacao` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `conta_id` (`conta_id`),
  CONSTRAINT `lembretes_ibfk_1` FOREIGN KEY (`conta_id`) REFERENCES `contas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Estrutura da tabela `saidas`
DROP TABLE IF EXISTS `saidas`;
CREATE TABLE `saidas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `valor` decimal(10,2) DEFAULT NULL,
  `descricao` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `categoria` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=679 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dados da tabela `saidas`
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('380', '36.74', 'Oldach', 'Empresa', '11/21/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('381', '64.89', 'Aaa', 'Empresa', '12/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('493', '112.51', 'walmart', 'Mercado', '01/25/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('494', '20.00', 'E-pass', 'Pedagio', '01/31/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('498', '80.00', 'Celebrate', 'Escola da Rosa', '02/01/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('499', '150.00', 'Barbara', 'Pessoal', '02/29/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('500', '26.25', 'gas', 'Combustível', '02/22/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('501', '166.98', 'Alimentacao empresa', 'Alimentacao Empresa', '02/29/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('503', '18.27', 'gas', 'Combustível', '02/01/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('504', '21.90', 'Silva', 'Mercado', '02/01/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('506', '20.62', 'gas', 'Combustível', '02/05/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('507', '44.98', 'internet', 'Internet', '02/07/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('509', '39.26', 'walmart', 'Mercado', '02/07/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('510', '61.69', 'Seabra food', 'Mercado', '02/09/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('511', '25.42', 'Silva', 'Mercado', '02/14/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('512', '71.85', 'walmart', 'Mercado', '02/14/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('514', '36.70', 'total cool', 'Empresa', '02/15/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('515', '20.00', 'e-pass', 'Pedagio', '02/15/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('517', '25.84', 'Seabra food', 'Mercado', '02/23/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('519', '109.00', 'barracao', 'Pessoal', '02/05/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('520', '405.00', 'Escola Rosa', 'Escola da Rosa', '01/02/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('523', '81.74', 'Oscar', 'Oscar', '01/01/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('525', '345.99', 'Sem descricao', 'Seguro do carro', '01/01/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('526', '214.42', 'Sem descricao', 'Telefone', '02/12/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('527', '39.65', 'Rodrigo', 'Mercado', '02/19/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('530', '26.16', 'Sem descricao', 'Combustível', '03/22/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('531', '99.00', 'exame', 'Pessoal', '03/22/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('532', '20.00', 'e-pass', 'Pedagio', '03/25/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('533', '93.73', 'seabra', 'Mercado', '03/25/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('534', '13.78', 'walmart', 'Mercado', '03/25/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('535', '55.38', 'oldach', 'Empresa', '03/25/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('536', '700.00', 'On-target contadora', 'Empresa', '03/07/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('537', '312.05', 'Oldach', 'Empresa', '03/04/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('538', '112.86', 'spectrum', 'Internet', '03/07/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('540', '89.72', 'seabra food', 'Mercado', '03/07/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('541', '30.01', 'Sem descricao', 'Combustível', '03/11/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('542', '20.00', 'epass', 'Pedagio', '03/11/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('543', '17.77', 'bravo', 'Mercado', '03/11/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('544', '48.10', 'Silva', 'Mercado', '03/11/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('545', '468.38', 'Telefone', 'Telefone', '03/12/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('546', '20.00', 'Sem descricao', 'Combustível', '03/14/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('547', '34.25', 'Sem descricao', 'Combustível', '03/15/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('548', '20.00', 'E-PASS', 'Combustível', '03/18/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('549', '176.64', 'Home Depot', 'Empresa', '03/18/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('550', '66.26', 'Sem descricao', 'Alimentacao Empresa', '03/31/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('552', '100.75', 'Home Depot', 'Empresa', '03/07/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('553', '60.00', 'On-target', 'Empresa', '04/02/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('554', '202.50', 'Celebration', 'Escola da Rosa', '04/11/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('555', '1969.00', 'Sem descricao', 'Aluguel', '04/03/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('556', '77.31', 'Rebel', 'Combustível', '04/01/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('557', '43.01', 'walmart', 'Mercado', '04/01/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('558', '76.53', 'walmart', 'Mercado', '04/01/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('559', '25.94', 'Silva', 'Mercado', '04/01/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('560', '20.00', 'e-pass', 'Pedagio', '04/02/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('561', '422.93', 'Sem descricao', 'Telefone', '04/02/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('562', '65.16', 'Sem descricao', 'Combustível', '04/02/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('563', '28.02', 'Home depot', 'Empresa', '04/09/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('564', '35.18', 'Seabra food', 'Mercado', '04/15/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('565', '18.07', 'Home depot', 'Empresa', '04/15/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('566', '29.83', 'walmart', 'Mercado', '04/16/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('567', '30.00', 'Sem descricao', 'Combustível', '04/17/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('568', '54.52', 'walmart', 'Mercado', '04/17/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('569', '314.18', 'aaa', 'Empresa', '04/19/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('570', '10.00', 'Garay olhos', 'Pessoal', '04/19/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('571', '70.80', 'Sem descricao', 'Combustível', '04/19/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('572', '20.00', 'epass', 'Pedagio', '04/22/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('573', '17.76', 'silva', 'Mercado', '04/22/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('574', '23.24', 'walmart', 'Mercado', '04/22/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('575', '62.67', 'Sem descricao', 'Combustível', '04/23/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('576', '44.49', 'walmart', 'Mercado', '04/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('577', '140.74', 'walmart', 'Mercado', '04/26/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('578', '20.00', 'epass', 'Pessoal', '04/29/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('579', '183.90', 'Sem descricao', 'Alimentacao Empresa', '04/30/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('580', '345.99', 'Sem descricao', 'Seguro do carro', '04/01/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('582', '216.36', 'Sem descricao', 'Água/Luz', '04/12/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('583', '335.00', 'Escola Rosa', 'Escola da Rosa', '05/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('584', '850.00', 'Escola Adriel', 'Outros', '05/23/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('585', '60.00', 'junior', 'Empresa', '05/28/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('586', '750.00', 'vlademir split', 'Empresa', '05/30/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('587', '85.79', 'taxa banco', 'Empresa', '05/31/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('588', '27.37', 'silva', 'Mercado', '05/03/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('589', '12.74', '+brazil', 'Mercado', '05/06/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('590', '138.25', 'walmart', 'Mercado', '05/06/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('591', '14.81', '+brazil', 'Mercado', '05/06/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('592', '237.81', 'tmoble', 'Telefone', '05/06/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('593', '66.26', 'lowes', 'Empresa', '05/06/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('594', '14.35', 'wamart', 'Mercado', '05/06/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('595', '69.69', 'gas', 'Combustível', '05/07/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('596', '79.08', 'bravo', 'Mercado', '05/07/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('597', '34.55', 'medico', 'Pessoal', '05/10/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('598', '108.91', 'Sem descricao', 'Internet', '05/13/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('599', '54.99', 'save a lot', 'Mercado', '05/13/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('600', '10.00', 'medico', 'Pessoal', '05/13/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('601', '49.70', 'walmart', 'Mercado', '05/13/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('602', '337.82', 'aaa', 'Empresa', '05/14/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('603', '239.44', 'walmart', 'Mercado', '05/14/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('604', '10.90', 'walmart', 'Mercado', '05/14/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('605', '42.94', 'walmart', 'Mercado', '05/14/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('606', '482.45', 'oldach', 'Empresa', '05/15/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('607', '23.35', 'home depot', 'Empresa', '05/15/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('608', '1170.50', 'aaa', 'Empresa', '05/16/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('609', '28.19', '+brasil', 'Mercado', '05/16/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('610', '58.58', 'aaa', 'Empresa', '05/16/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('611', '64.70', 'lowes', 'Empresa', '05/16/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('612', '140.00', 'epass', 'Pedagio', '05/31/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('613', '70.51', 'Sem descricao', 'Combustível', '05/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('614', '258.80', 'aaa', 'Empresa', '05/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('615', '84.67', 'home depot', 'Empresa', '05/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('616', '16.31', 'silva', 'Mercado', '05/28/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('617', '429.85', 'Sem descricao', 'Telefone', '05/28/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('618', '76.44', 'seabra', 'Mercado', '05/28/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('619', '6.99', 'publix', 'Mercado', '05/28/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('620', '79.00', 'Sem descricao', 'Combustível', '05/29/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('621', '71.00', 'Sem descricao', 'Combustível', '05/29/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('622', '219.45', 'aaa', 'Empresa', '05/30/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('623', '27.93', 'Sem descricao', 'Gasto com carro ', '05/30/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('624', '30.79', 'home depot', 'Empresa', '05/31/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('625', '24.89', 'Sem descricao', 'Combustível', '05/31/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('626', '33.59', 'Sem descricao', 'Combustível', '05/16/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('627', '37.70', 'oldach', 'Empresa', '05/17/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('628', '6.39', 'aaa', 'Empresa', '05/17/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('629', '2069.17', 'aaa', 'Empresa', '05/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('630', '55.94', 'Sem descricao', 'Combustível', '05/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('631', '53.90', 'Sem descricao', 'Combustível', '05/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('632', '40.24', 'silva', 'Mercado', '05/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('633', '131.48', 'walmart', 'Mercado', '05/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('634', '107.94', 'seabra', 'Mercado', '05/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('635', '32.06', 'bravo', 'Mercado', '05/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('636', '237.80', 'Sem descricao', 'Telefone', '05/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('637', '71.38', 'Sem descricao', 'Combustível', '05/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('638', '218.86', 'aaa', 'Empresa', '05/21/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('639', '159.03', 'lowes', 'Empresa', '05/21/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('640', '12.87', 'total cool', 'Empresa', '05/21/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('641', '39.59', 'walmart', 'Mercado', '05/21/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('642', '1665.55', 'aaa', 'Empresa', '05/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('643', '2208.25', 'aaa', 'Empresa', '05/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('644', '147.00', 'Sem descricao', 'Alimentacao Empresa', '05/31/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('645', '425.00', 'Celebration', 'Escola da Rosa', '06/04/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('646', '50.00', 'Jr', 'Helper', '06/11/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('647', '257.50', 'Pluris', 'Escola da Rosa', '06/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('648', '139.48', 'Walmart', 'Mercado', '06/03/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('649', '46.39', 'Rodrigo', 'Mercado', '06/03/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('650', '21.44', 'Sem descricao', 'Combustível', '06/03/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('651', '32.75', 'Alimento', 'Pessoal', '06/03/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('652', '45.49', 'Rodrigo', 'Mercado', '06/04/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('653', '49.95', 'Home depot', 'Empresa', '06/06/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('654', '101.77', 'Seabra', 'Mercado', '06/07/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('655', '87.70', 'Crazy hot b', 'Pessoal', '06/10/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('656', '6.39', 'Publix', 'Alimentacao Empresa', '06/10/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('657', '477.05', 'Walmart', 'Mercado', '06/11/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('658', '62.60', 'Sem descricao', 'Combustível', '06/11/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('659', '32.92', 'Aaa', 'Empresa', '06/11/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('660', '20.00', 'E-PASS', 'Pedagio', '06/17/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('661', '41.43', 'Total cool', 'Empresa', '06/18/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('662', '111.06', 'Walmart', 'Mercado', '06/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('663', '29.48', 'Silvas', 'Mercado', '06/20/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('664', '66.68', 'Rodrigo', 'Mercado', '06/21/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('665', '70.86', 'Sem descricao', 'Combustível', '06/21/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('666', '28.31', 'Bravo', 'Mercado', '06/21/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('667', '99.89', 'Walmart', 'Mercado', '06/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('668', '69.09', 'Oh Que bueno', 'Pessoal', '06/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('669', '69.09', 'Oh Que bueno', 'Pessoal', '06/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('670', '20.00', 'Epass', 'Pedagio', '06/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('671', '56.76', 'Walmart', 'Mercado', '11/24/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('672', '40.79', 'Aaa', 'Empresa', '06/25/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('673', '53.75', 'Seabra', 'Mercado', '06/25/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('674', '362.39', 'Sem descricao', 'Telefone', '06/26/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('675', '149.00', 'Dentista', 'Pessoal', '06/28/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('676', '149.00', 'Dentista', 'Pessoal', '06/28/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('677', '37.24', 'Silvas', 'Mercado', '06/28/24');
INSERT INTO `saidas` (`id`, `valor`, `descricao`, `categoria`, `data`) VALUES ('678', '242.63', 'Sem descricao', 'Alimentacao Empresa', '06/29/24');

-- Estrutura da tabela `usuarios`
DROP TABLE IF EXISTS `usuarios`;
CREATE TABLE `usuarios` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nome` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `senha` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipo` enum('admin','usuario') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'usuario',
  `data_criacao` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ativo` tinyint(1) DEFAULT '1',
  `ultimo_acesso` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dados da tabela `usuarios`
INSERT INTO `usuarios` (`id`, `username`, `password`, `nome`, `email`, `senha`, `tipo`, `data_criacao`, `ativo`, `ultimo_acesso`) VALUES ('1', 'admin', '$2y$10$VFBCwE8PbDeobR1BhgZGEumNLv0ZRER65GbHITJUfQU7csphmJ8RK', 'Administrador', 'admin@example.com', '', 'usuario', '2025-05-06 21:21:17', '1', NULL);
INSERT INTO `usuarios` (`id`, `username`, `password`, `nome`, `email`, `senha`, `tipo`, `data_criacao`, `ativo`, `ultimo_acesso`) VALUES ('2', NULL, NULL, 'tony', 'tony@tony.com', '$2y$10$9rt7lboaAkFx3c3wwWNPrOV9uC.8IrP0xis9tfk07JdkF7RjTaPJC', 'admin', '2025-05-15 20:30:24', '1', NULL);
INSERT INTO `usuarios` (`id`, `username`, `password`, `nome`, `email`, `senha`, `tipo`, `data_criacao`, `ativo`, `ultimo_acesso`) VALUES ('3', NULL, NULL, 'tony', 'admin@admin.com', '$2y$10$y1DDa/H0IZ5LspHJD1SemegnPgbU2ygdM2428E6yUpCWxmQKrpcfS', 'admin', '2025-05-15 23:12:38', '1', '2025-05-15 23:14:09');