-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: control_financiero
-- ------------------------------------------------------
-- Server version	10.4.32-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `alerts`
--

DROP TABLE IF EXISTS `alerts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alerts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `related_type` varchar(255) DEFAULT NULL,
  `related_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `alerts_user_id_foreign` (`user_id`),
  CONSTRAINT `alerts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alerts`
--

LOCK TABLES `alerts` WRITE;
/*!40000 ALTER TABLE `alerts` DISABLE KEYS */;
/*!40000 ALTER TABLE `alerts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache_locks`
--

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `credit_cards`
--

DROP TABLE IF EXISTS `credit_cards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `credit_cards` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `entity_name` varchar(255) NOT NULL,
  `card_name` varchar(255) NOT NULL,
  `card_masked` varchar(4) NOT NULL,
  `credit_limit` decimal(12,2) NOT NULL,
  `current_debt` decimal(12,2) NOT NULL DEFAULT 0.00,
  `currency` varchar(255) NOT NULL DEFAULT 'PEN',
  `closing_day` int(11) NOT NULL,
  `payment_day` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `credit_cards_user_id_foreign` (`user_id`),
  CONSTRAINT `credit_cards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `credit_cards`
--

LOCK TABLES `credit_cards` WRITE;
/*!40000 ALTER TABLE `credit_cards` DISABLE KEYS */;
/*!40000 ALTER TABLE `credit_cards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gmail_connections`
--

DROP TABLE IF EXISTS `gmail_connections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gmail_connections` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `access_token` text DEFAULT NULL,
  `refresh_token` text DEFAULT NULL,
  `expires_in` int(11) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `connected` tinyint(1) NOT NULL DEFAULT 0,
  `sync_status` varchar(255) NOT NULL DEFAULT 'Idle',
  `last_sync_at` timestamp NULL DEFAULT NULL,
  `total_emails_processed` int(11) NOT NULL DEFAULT 0,
  `total_payments_detected` int(11) NOT NULL DEFAULT 0,
  `total_transactions_detected` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gmail_connections_user_id_foreign` (`user_id`),
  CONSTRAINT `gmail_connections_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gmail_connections`
--

LOCK TABLES `gmail_connections` WRITE;
/*!40000 ALTER TABLE `gmail_connections` DISABLE KEYS */;
INSERT INTO `gmail_connections` VALUES (1,1,'eyJpdiI6Im9Fajc3RS82czlXeWdXRjhzUXpGVXc9PSIsInZhbHVlIjoibXczSUhIamZNTjYrVDF3cnNjYnRTaFJTVnpCcEg1NkZTTmNZYmI1QmFRajBWVnhPZzltMEUvWGV5aTVzUUZoMlN3alE3bTVUSEgxcjlUNHpEaE1udWgwNmZBa0grV2wzNEViUTJhNmZ3SGhaQ25ESlZFMWs1dnBaVTJJaEFOWDZrKysya1lhTDZ2VDRQbXZHWXh3dERtWmkvQ3k0UGNTbUsrVVRMUTFHY3hYZnNuUk1nV29oNFlTMEg4M2ZxTWdaQjM0Y0dwa0RBUERVb01WSHVvN0JPcFVhQ1NUdEpURDVGcU4vVTljeUovcGV6WDc2clRWMVozS1J6Ry9TSnFJbWJ6Zm4wdFZGMnB2ckdHREtvMm1vdnZ0emZ1OXVRdzBtQmFSSHNQeksvbnVoNXZNdkE4RGFLTkdrWWp3NWRKek1MOUEvRUFkY3lvOTlmMHJEYW11d0ZQcFExUlAzdVFnbXlUYUNwZEljM3dvPSIsIm1hYyI6Ijg5YjM3NDNmYzViNmJhOGJkNGM4MTNkNGI2OTYzNTNlMjUwZjA4MDRjYmJjMjhlODMxNWMzZTVhZWU1OWIzNmYiLCJ0YWciOiIifQ==','eyJpdiI6IkR1SXdFcUlrcHZsSWxLT2pjNktLdGc9PSIsInZhbHVlIjoiMkJrY0VabHRXYjVFQ0w2RnVoYkhTZHJ6ZmNFNnIyQnA1TUcrZ0s4MzJCejV5K0toTktnNVp1REJLL3FPWitNZFN3Y2FOSFBPK3lMVnJNSHh0b1ZBeTE0cllkeWR4NDlReG5RQVE3VHRYVWNuN2dhemVkclVPcDA5N1N0NlE5WmlJZy95S2R3dUxzRVFjVmlQYVBtRllmeHFwMzFCUGJkYkdneXY3dWY3dGlBPSIsIm1hYyI6IjVjODcyNWNlZjliM2QxM2NkYWZhNDUxMDllM2QyMTQzZDRlODdlODgxNGM4YjZiYWUzMTEzMWFkODg2MDZmNzkiLCJ0YWciOiIifQ==',3599,'luivarsan@gmail.com',1,'Idle','2026-07-03 09:14:54',100,0,72,'2026-07-02 03:27:35','2026-07-03 09:14:54');
/*!40000 ALTER TABLE `gmail_connections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gmail_processed_emails`
--

DROP TABLE IF EXISTS `gmail_processed_emails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gmail_processed_emails` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `message_id` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gmail_processed_emails_user_id_foreign` (`user_id`),
  KEY `gmail_processed_emails_message_id_index` (`message_id`),
  CONSTRAINT `gmail_processed_emails_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gmail_processed_emails`
--

LOCK TABLES `gmail_processed_emails` WRITE;
/*!40000 ALTER TABLE `gmail_processed_emails` DISABLE KEYS */;
INSERT INTO `gmail_processed_emails` VALUES (1,1,'19f2476887403639','2026-07-03 09:14:11','2026-07-03 09:14:11'),(2,1,'19f20b05a5036a1f','2026-07-03 09:14:11','2026-07-03 09:14:11'),(3,1,'19f1ea8716055358','2026-07-03 09:14:12','2026-07-03 09:14:12'),(4,1,'19f1e41828ffcdab','2026-07-03 09:14:12','2026-07-03 09:14:12'),(5,1,'19f1aeab21357725','2026-07-03 09:14:12','2026-07-03 09:14:12'),(6,1,'19f1ae6810a7d627','2026-07-03 09:14:13','2026-07-03 09:14:13'),(7,1,'19f1ad263d94d4aa','2026-07-03 09:14:13','2026-07-03 09:14:13'),(8,1,'19f18f6bc550affb','2026-07-03 09:14:14','2026-07-03 09:14:14'),(9,1,'19f13c64af2c1554','2026-07-03 09:14:14','2026-07-03 09:14:14'),(10,1,'19f13c267ad04386','2026-07-03 09:14:14','2026-07-03 09:14:14'),(11,1,'19f0ebccf29bca69','2026-07-03 09:14:14','2026-07-03 09:14:14'),(12,1,'19f0af6730f49d6f','2026-07-03 09:14:15','2026-07-03 09:14:15'),(13,1,'19f0a00ea6f21c16','2026-07-03 09:14:15','2026-07-03 09:14:15'),(14,1,'19f09a3fcbd8bc66','2026-07-03 09:14:16','2026-07-03 09:14:16'),(15,1,'19f06287111f5a13','2026-07-03 09:14:16','2026-07-03 09:14:16'),(16,1,'19f05c5880ad4d95','2026-07-03 09:14:17','2026-07-03 09:14:17'),(17,1,'19f058d9f2f3a274','2026-07-03 09:14:17','2026-07-03 09:14:17'),(18,1,'19f007904c6a771f','2026-07-03 09:14:17','2026-07-03 09:14:17'),(19,1,'19efff2a079b1e27','2026-07-03 09:14:18','2026-07-03 09:14:18'),(20,1,'19eff43872474522','2026-07-03 09:14:18','2026-07-03 09:14:18'),(21,1,'19eff179676437bc','2026-07-03 09:14:19','2026-07-03 09:14:19'),(22,1,'19efc553b8eb8314','2026-07-03 09:14:20','2026-07-03 09:14:20'),(23,1,'19ef72426e1aa2d7','2026-07-03 09:14:20','2026-07-03 09:14:20'),(24,1,'19ef5c53b7d92a9a','2026-07-03 09:14:20','2026-07-03 09:14:20'),(25,1,'19ef586d510d7103','2026-07-03 09:14:21','2026-07-03 09:14:21'),(26,1,'19eefd6b96d84cbd','2026-07-03 09:14:21','2026-07-03 09:14:21'),(27,1,'19eef9aa6761bddd','2026-07-03 09:14:22','2026-07-03 09:14:22'),(28,1,'19eecf57db00dc35','2026-07-03 09:14:22','2026-07-03 09:14:22'),(29,1,'19eecf0b974273e7','2026-07-03 09:14:23','2026-07-03 09:14:23'),(30,1,'19ee61c91a6c61c2','2026-07-03 09:14:24','2026-07-03 09:14:24'),(31,1,'19ee5c5acb5b2b2b','2026-07-03 09:14:24','2026-07-03 09:14:24'),(32,1,'19ee0d9047475062','2026-07-03 09:14:25','2026-07-03 09:14:25'),(33,1,'19edc95569d2c606','2026-07-03 09:14:25','2026-07-03 09:14:25'),(34,1,'19edc943ec5444f0','2026-07-03 09:14:26','2026-07-03 09:14:26'),(35,1,'19ed24a300084b90','2026-07-03 09:14:26','2026-07-03 09:14:26'),(36,1,'19ed165b68b06d0e','2026-07-03 09:14:27','2026-07-03 09:14:27'),(37,1,'19ed121b77cb9673','2026-07-03 09:14:27','2026-07-03 09:14:27'),(38,1,'19ecd74dabe45175','2026-07-03 09:14:28','2026-07-03 09:14:28'),(39,1,'19ecd7268ce86f56','2026-07-03 09:14:29','2026-07-03 09:14:29'),(40,1,'19eccfd2a5488d20','2026-07-03 09:14:29','2026-07-03 09:14:29'),(41,1,'19ec18bf48d74611','2026-07-03 09:14:29','2026-07-03 09:14:29'),(42,1,'19ebad0d36c988e3','2026-07-03 09:14:30','2026-07-03 09:14:30'),(43,1,'19eb86bd372ba88f','2026-07-03 09:14:30','2026-07-03 09:14:30'),(44,1,'19eb73421aa26dc9','2026-07-03 09:14:31','2026-07-03 09:14:31'),(45,1,'19eafc7e5fd1225c','2026-07-03 09:14:32','2026-07-03 09:14:32'),(46,1,'19eaeb747a6b47f6','2026-07-03 09:14:32','2026-07-03 09:14:32'),(47,1,'19eae6b04bd10d84','2026-07-03 09:14:32','2026-07-03 09:14:32'),(48,1,'19eadaede674aac4','2026-07-03 09:14:33','2026-07-03 09:14:33'),(49,1,'19ea77f9018fdec4','2026-07-03 09:14:33','2026-07-03 09:14:33'),(50,1,'19ea339a246b6ca0','2026-07-03 09:14:35','2026-07-03 09:14:35'),(51,1,'19e9d82a7297a3eb','2026-07-03 09:14:35','2026-07-03 09:14:35'),(52,1,'19e8f40926058128','2026-07-03 09:14:36','2026-07-03 09:14:36'),(53,1,'19e8aa0f43e07f4b','2026-07-03 09:14:36','2026-07-03 09:14:36'),(54,1,'19e8654628769278','2026-07-03 09:14:37','2026-07-03 09:14:37'),(55,1,'19e8589a5237a988','2026-07-03 09:14:37','2026-07-03 09:14:37'),(56,1,'19e8378f1ce31107','2026-07-03 09:14:38','2026-07-03 09:14:38'),(57,1,'19e7b54c78fbe612','2026-07-03 09:14:38','2026-07-03 09:14:38'),(58,1,'19e7b544b53c575f','2026-07-03 09:14:38','2026-07-03 09:14:38'),(59,1,'19e7976943742bff','2026-07-03 09:14:39','2026-07-03 09:14:39'),(60,1,'19e791f818242d83','2026-07-03 09:14:39','2026-07-03 09:14:39'),(61,1,'19e6bae6d76b6aaf','2026-07-03 09:14:39','2026-07-03 09:14:39'),(62,1,'19e6ac2b4cac050e','2026-07-03 09:14:40','2026-07-03 09:14:40'),(63,1,'19e6a6a8e03888fb','2026-07-03 09:14:40','2026-07-03 09:14:40'),(64,1,'19e68b21fd569e1c','2026-07-03 09:14:40','2026-07-03 09:14:40'),(65,1,'19e6605b62aa7f17','2026-07-03 09:14:41','2026-07-03 09:14:41'),(66,1,'19e65e89d0e1b57b','2026-07-03 09:14:41','2026-07-03 09:14:41'),(67,1,'19e658526dfa5097','2026-07-03 09:14:42','2026-07-03 09:14:42'),(68,1,'19e6517284b92082','2026-07-03 09:14:42','2026-07-03 09:14:42'),(69,1,'19e616b9317ff35e','2026-07-03 09:14:43','2026-07-03 09:14:43'),(70,1,'19e613861ee2e0e3','2026-07-03 09:14:43','2026-07-03 09:14:43'),(71,1,'19e5b46db50a6381','2026-07-03 09:14:43','2026-07-03 09:14:43'),(72,1,'19e57098e6194d59','2026-07-03 09:14:44','2026-07-03 09:14:44'),(73,1,'19e56c6b87e5942a','2026-07-03 09:14:44','2026-07-03 09:14:44'),(74,1,'19e56995b1b404bb','2026-07-03 09:14:45','2026-07-03 09:14:45'),(75,1,'19e5697b6e3f1bbe','2026-07-03 09:14:45','2026-07-03 09:14:45'),(76,1,'19e56947e247c275','2026-07-03 09:14:45','2026-07-03 09:14:45'),(77,1,'19e5662c39e2c70f','2026-07-03 09:14:46','2026-07-03 09:14:46'),(78,1,'19e556a192f34890','2026-07-03 09:14:46','2026-07-03 09:14:46'),(79,1,'19e55568e0a86c2f','2026-07-03 09:14:47','2026-07-03 09:14:47'),(80,1,'19e4b2736fee1837','2026-07-03 09:14:47','2026-07-03 09:14:47'),(81,1,'19e4778d83f285cc','2026-07-03 09:14:47','2026-07-03 09:14:47'),(82,1,'19e4734cda4dcc92','2026-07-03 09:14:48','2026-07-03 09:14:48'),(83,1,'19e41fde81db9cef','2026-07-03 09:14:48','2026-07-03 09:14:48'),(84,1,'19e41ed2d1934b62','2026-07-03 09:14:49','2026-07-03 09:14:49'),(85,1,'19e41d91e2008af4','2026-07-03 09:14:49','2026-07-03 09:14:49'),(86,1,'19e419d550c2bc3e','2026-07-03 09:14:49','2026-07-03 09:14:49'),(87,1,'19e4078956a73eb9','2026-07-03 09:14:49','2026-07-03 09:14:49'),(88,1,'19e3d0c51210f8bc','2026-07-03 09:14:50','2026-07-03 09:14:50'),(89,1,'19e364bb130846b4','2026-07-03 09:14:50','2026-07-03 09:14:50'),(90,1,'19e34503e82c5c64','2026-07-03 09:14:51','2026-07-03 09:14:51'),(91,1,'19e3450055d7e1f5','2026-07-03 09:14:51','2026-07-03 09:14:51'),(92,1,'19e3449ecfc74c41','2026-07-03 09:14:51','2026-07-03 09:14:51'),(93,1,'19e33943ab9e847b','2026-07-03 09:14:52','2026-07-03 09:14:52'),(94,1,'19e317b36fee97c2','2026-07-03 09:14:52','2026-07-03 09:14:52'),(95,1,'19e3154e1384e76c','2026-07-03 09:14:53','2026-07-03 09:14:53'),(96,1,'19e30cd34bf88e53','2026-07-03 09:14:53','2026-07-03 09:14:53'),(97,1,'19e308509eca1dc4','2026-07-03 09:14:53','2026-07-03 09:14:53'),(98,1,'19e3083c72942947','2026-07-03 09:14:54','2026-07-03 09:14:54'),(99,1,'19e2e75142305562','2026-07-03 09:14:54','2026-07-03 09:14:54'),(100,1,'19e2e70980091aa8','2026-07-03 09:14:54','2026-07-03 09:14:54');
/*!40000 ALTER TABLE `gmail_processed_emails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_batches`
--

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_batches`
--

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `merchant_category_rules`
--

DROP TABLE IF EXISTS `merchant_category_rules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `merchant_category_rules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `merchant_name` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `merchant_category_rules_user_id_merchant_name_unique` (`user_id`,`merchant_name`),
  CONSTRAINT `merchant_category_rules_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `merchant_category_rules`
--

LOCK TABLES `merchant_category_rules` WRITE;
/*!40000 ALTER TABLE `merchant_category_rules` DISABLE KEYS */;
/*!40000 ALTER TABLE `merchant_category_rules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_07_01_180001_create_gmail_connections_table',1),(5,'2026_07_01_180002_create_payments_table',1),(6,'2026_07_01_180003_create_transactions_table',1),(7,'2026_07_01_180004_create_alerts_table',1),(8,'2026_07_01_223559_create_personal_access_tokens_table',2),(9,'2026_07_02_162932_create_gmail_processed_emails_table',3),(10,'2026_07_02_162940_create_merchant_category_rules_table',3),(11,'2026_07_02_163117_add_category_to_transactions_table',4),(12,'2026_07_02_170701_create_credit_cards_table',5),(13,'2026_07_02_170702_add_credit_card_fields_to_payments_table',5),(14,'2026_07_12_231437_add_credit_card_fields_to_transactions_table',6);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_reset_tokens`
--

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payments`
--

DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `entity_name` varchar(255) NOT NULL,
  `concept` varchar(255) NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `currency` varchar(255) NOT NULL DEFAULT 'PEN',
  `due_date` date NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'Pendiente',
  `category` varchar(255) NOT NULL,
  `source` varchar(255) NOT NULL DEFAULT 'Manual',
  `confidence_score` decimal(5,2) NOT NULL DEFAULT 100.00,
  `email_subject` varchar(255) DEFAULT NULL,
  `email_summary` text DEFAULT NULL,
  `paid_at` timestamp NULL DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `operation_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `credit_card_id` bigint(20) unsigned DEFAULT NULL,
  `minimum_payment` decimal(12,2) DEFAULT NULL,
  `statement_period` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payments_user_id_foreign` (`user_id`),
  KEY `payments_credit_card_id_foreign` (`credit_card_id`),
  CONSTRAINT `payments_credit_card_id_foreign` FOREIGN KEY (`credit_card_id`) REFERENCES `credit_cards` (`id`) ON DELETE SET NULL,
  CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payments`
--

LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` text NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`),
  KEY `personal_access_tokens_expires_at_index` (`expires_at`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `personal_access_tokens`
--

LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
INSERT INTO `personal_access_tokens` VALUES (1,'App\\Models\\User',1,'auth_token','8bdebd09e227e1748cf3995314399b1d88e82ce2705c88eef913fd63398df547','[\"*\"]','2026-07-02 03:38:41',NULL,'2026-07-02 03:38:03','2026-07-02 03:38:41'),(2,'App\\Models\\User',1,'auth_token','6c3db80768e05baf16efc3e105155cd108e82bab5ace68c026d4ad562590daf6','[\"*\"]','2026-07-02 03:46:10',NULL,'2026-07-02 03:45:58','2026-07-02 03:46:10'),(3,'App\\Models\\User',1,'auth_token','e50916d85c91219baa65146ad19e251aa46102b93a58167cd1e928befb152f07','[\"*\"]','2026-07-02 03:50:56',NULL,'2026-07-02 03:49:46','2026-07-02 03:50:56'),(4,'App\\Models\\User',1,'auth_token','935d234068cb93240d331edc29521acdf7a8c9517b36898bc1e9abaf8dff57dc','[\"*\"]','2026-07-02 03:57:24',NULL,'2026-07-02 03:56:57','2026-07-02 03:57:24'),(5,'App\\Models\\User',1,'auth_token','686f08817bd3a045c816ee1247dc7eb6c2f6fc7b0f987ca94beb4ef2370297da','[\"*\"]','2026-07-02 20:25:29',NULL,'2026-07-02 20:03:58','2026-07-02 20:25:29'),(6,'App\\Models\\User',1,'auth_token','8da6a825eaacdf3a67bc65336eb074744b72667f98c98df8ce23c334ef28e3e9','[\"*\"]','2026-07-02 21:13:53',NULL,'2026-07-02 20:39:34','2026-07-02 21:13:53'),(7,'App\\Models\\User',1,'auth_token','58fa0c6ddd20dd415965e2de035ca150e622a1418c47d1c5486bda7427929376','[\"*\"]','2026-07-02 21:14:56',NULL,'2026-07-02 21:14:51','2026-07-02 21:14:56'),(8,'App\\Models\\User',1,'auth_token','bca47ea88273d72f40030842cec74d53c45b43a45049da191020744bf794453f','[\"*\"]','2026-07-02 21:17:57',NULL,'2026-07-02 21:17:28','2026-07-02 21:17:57'),(9,'App\\Models\\User',1,'auth_token','39c3342b2db2950f40519288852df42a1913dfa6aa31351b85c90b6c9c646c50','[\"*\"]','2026-07-02 21:21:50',NULL,'2026-07-02 21:21:22','2026-07-02 21:21:50'),(10,'App\\Models\\User',1,'auth_token','b273ad4aa1c2fcdca22042b96282367de16b565db140a1d874e319d60ae78589','[\"*\"]','2026-07-02 21:26:12',NULL,'2026-07-02 21:25:51','2026-07-02 21:26:12'),(11,'App\\Models\\User',1,'auth_token','8c36a556963889994409694e83cb623818695594622ab9de37be316c5248266d','[\"*\"]','2026-07-02 21:48:59',NULL,'2026-07-02 21:45:47','2026-07-02 21:48:59'),(12,'App\\Models\\User',1,'auth_token','01772b21c933fe9bf7a48a5c366411dd5e8e0076c8de2a762e64bb8d197c9e66','[\"*\"]','2026-07-02 21:56:34',NULL,'2026-07-02 21:56:24','2026-07-02 21:56:34'),(13,'App\\Models\\User',1,'auth_token','807ef52cc56d6d536960d7383a1af4c46608d488512151e820d7b6a37351cf99','[\"*\"]','2026-07-02 22:17:19',NULL,'2026-07-02 22:11:48','2026-07-02 22:17:19'),(14,'App\\Models\\User',1,'auth_token','8533dacedf32eb393653f41f25a52518df41e890609caa2adb614601a0f17286','[\"*\"]','2026-07-02 22:20:31',NULL,'2026-07-02 22:19:39','2026-07-02 22:20:31'),(15,'App\\Models\\User',1,'auth_token','356deed6f989936080c0531355ae43e21b705c4203784cbe9fa2791a22e4c80c','[\"*\"]','2026-07-02 22:33:25',NULL,'2026-07-02 22:32:52','2026-07-02 22:33:25'),(16,'App\\Models\\User',1,'auth_token','0b3404a97a771e56d18148f3166c6b52ec4079814f88a7076f89f91cc85978e2','[\"*\"]','2026-07-03 00:32:04',NULL,'2026-07-03 00:31:52','2026-07-03 00:32:04'),(17,'App\\Models\\User',1,'auth_token','477b55428c0cf404530248ff24c0e05d0d768f58233ee9acf8a3fab350577116','[\"*\"]','2026-07-03 07:54:26',NULL,'2026-07-03 07:54:14','2026-07-03 07:54:26'),(18,'App\\Models\\User',1,'auth_token','38f2d77d35cb8b3e764a9fe5c4aad981ae316d73f72f6c2c800a15d300c702aa','[\"*\"]','2026-07-03 08:01:55',NULL,'2026-07-03 08:01:32','2026-07-03 08:01:55'),(19,'App\\Models\\User',1,'auth_token','4327219f00a0d699504ecedd120238783542e1ec75f29ec3a37fca168ae1f7cd','[\"*\"]','2026-07-03 08:19:49',NULL,'2026-07-03 08:18:14','2026-07-03 08:19:49'),(20,'App\\Models\\User',1,'auth_token','4b36de363f4cdf6d7e100a2755122b9a9f4964b292521072ad7b7b62c37ffae1','[\"*\"]','2026-07-03 08:28:46',NULL,'2026-07-03 08:28:21','2026-07-03 08:28:46'),(21,'App\\Models\\User',1,'auth_token','49117e916cbe9a845e96c1c783a58995711979900b610f5de949b8a8e9000cec','[\"*\"]','2026-07-03 08:34:36',NULL,'2026-07-03 08:34:15','2026-07-03 08:34:36'),(22,'App\\Models\\User',1,'auth_token','b14b9760d813fd1279515ec6e82750b262d1a04f137a0175fdbaa9b8bdeec793','[\"*\"]','2026-07-03 08:39:41',NULL,'2026-07-03 08:39:34','2026-07-03 08:39:41'),(23,'App\\Models\\User',1,'auth_token','27e38bc7905d7ef842b1c0079ef053f2498b3d60771c93f1cc2a6f3da20ef831','[\"*\"]','2026-07-03 09:00:31',NULL,'2026-07-03 08:45:09','2026-07-03 09:00:31'),(24,'App\\Models\\User',1,'auth_token','838c9bd9e2b6cd3137ab04db7635d1ef3d17543a63a77aa5e6eb0e4f30a782e1','[\"*\"]','2026-07-03 09:15:11',NULL,'2026-07-03 09:07:03','2026-07-03 09:15:11'),(25,'App\\Models\\User',1,'auth_token','1b053b5e1a312c44de7a97eb716c782e40566ec1deec37584952bed64ae0f3d9','[\"*\"]','2026-07-13 04:37:42',NULL,'2026-07-13 04:32:07','2026-07-13 04:37:42'),(26,'App\\Models\\User',1,'auth_token','0ebb78e824f84c96125a3578d0a23b0fd37ea707925fc68b33368b2522b45879','[\"*\"]','2026-07-17 08:12:23',NULL,'2026-07-17 08:03:32','2026-07-17 08:12:23'),(27,'App\\Models\\User',1,'auth_token','04cd0ca7eeb1b63f0b859f5fb62d963f9551b31203f3c33762e6385fa886a79b','[\"*\"]','2026-07-20 08:05:17',NULL,'2026-07-20 08:05:11','2026-07-20 08:05:17'),(28,'App\\Models\\User',1,'auth_token','46a7265525fc1c6307a2a783b9a341f1442b1d7926db5e7f7f4d2966b0b62a8e','[\"*\"]','2026-07-20 08:37:14',NULL,'2026-07-20 08:37:10','2026-07-20 08:37:14');
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('4TamQaK2UKxY9TKNrFs254bONhOu0JSbZYWXbE5e',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWHZyY2s0NEhBeDlCaUdYT2M2RElzVU8ycVoySTRyeFhDT2taUGZCbCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDg6Imh0dHA6Ly9zaGFraW5lc3MtZGVzdGlueS1hYnNpbnRoZS5uZ3Jvay1mcmVlLmRldiI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1783005301);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `entity_name` varchar(255) NOT NULL,
  `account_name` varchar(255) NOT NULL DEFAULT 'Cuenta Principal',
  `account_masked` varchar(255) DEFAULT NULL,
  `movement_type` varchar(255) NOT NULL,
  `category` varchar(255) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `currency` varchar(255) NOT NULL DEFAULT 'PEN',
  `direction` varchar(255) NOT NULL,
  `channel` varchar(255) NOT NULL DEFAULT 'Banco',
  `related_person` varchar(255) DEFAULT NULL,
  `operation_code` varchar(255) DEFAULT NULL,
  `transaction_date` date NOT NULL,
  `transaction_time` time DEFAULT NULL,
  `source` varchar(255) NOT NULL DEFAULT 'Manual',
  `confidence_score` decimal(5,2) NOT NULL DEFAULT 100.00,
  `reconciliation_status` varchar(255) NOT NULL DEFAULT 'Pendiente',
  `reconciled_payment_id` bigint(20) unsigned DEFAULT NULL,
  `credit_card_id` bigint(20) unsigned DEFAULT NULL,
  `total_installments` int(11) NOT NULL DEFAULT 1,
  `installment_number` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transactions_user_id_foreign` (`user_id`),
  KEY `transactions_reconciled_payment_id_foreign` (`reconciled_payment_id`),
  KEY `transactions_credit_card_id_foreign` (`credit_card_id`),
  CONSTRAINT `transactions_credit_card_id_foreign` FOREIGN KEY (`credit_card_id`) REFERENCES `credit_cards` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transactions_reconciled_payment_id_foreign` FOREIGN KEY (`reconciled_payment_id`) REFERENCES `payments` (`id`) ON DELETE SET NULL,
  CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'jorge','luivarsan@gmail.com',NULL,'$2y$12$YRWhZqlEJTE7CZe1bWs/huxsQ/LfkT26Xgr0fIZlzV/kck848pLWa',NULL,'2026-07-02 03:27:35','2026-07-13 04:29:31');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-07-28 15:17:54