-- Barbería San Ramón: schema + seed for empty MySQL 8
-- Generated UTC: 2026-07-01 04:50:17
-- Login admin: admin@barbershop.com / password
-- Login barbero Maikel: 85334909 o +50685334909 / password
-- Clientes: teléfono (8 dígitos o 506...) / PIN = últimos 4 del número en la lista del seeder
-- Regenerar este archivo: php laravel-base/scripts/export_seed_sql.php
SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `appointment_photos`;
DROP TABLE IF EXISTS `appointments`;
DROP TABLE IF EXISTS `barber_blocks`;
DROP TABLE IF EXISTS `barber_services`;
DROP TABLE IF EXISTS `custom_service_logs`;
DROP TABLE IF EXISTS `push_subscriptions`;
DROP TABLE IF EXISTS `whatsapp_conversations`;
DROP TABLE IF EXISTS `failed_jobs`;
DROP TABLE IF EXISTS `job_batches`;
DROP TABLE IF EXISTS `jobs`;
DROP TABLE IF EXISTS `cache_locks`;
DROP TABLE IF EXISTS `cache`;
DROP TABLE IF EXISTS `personal_access_tokens`;
DROP TABLE IF EXISTS `barbers`;
DROP TABLE IF EXISTS `services`;
DROP TABLE IF EXISTS `users`;
DROP TABLE IF EXISTS `migrations`;

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('admin','barber','client') NOT NULL DEFAULT 'client',
  `phone` varchar(20) DEFAULT NULL,
  `avatar_url` varchar(500) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `barbers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `bio` text,
  `specialty` varchar(100) DEFAULT NULL,
  `working_days` json DEFAULT NULL,
  `work_start` time NOT NULL,
  `work_end` time NOT NULL,
  `display_order` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `barbers_user_id_foreign` (`user_id`),
  CONSTRAINT `barbers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `description` text,
  `duration_minutes` smallint NOT NULL,
  `price` decimal(8,2) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `barber_services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `barber_id` bigint unsigned NOT NULL,
  `service_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `barber_services_barber_id_service_id_unique` (`barber_id`,`service_id`),
  KEY `barber_services_service_id_foreign` (`service_id`),
  CONSTRAINT `barber_services_barber_id_foreign` FOREIGN KEY (`barber_id`) REFERENCES `barbers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `barber_services_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `appointments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint unsigned NOT NULL,
  `barber_id` bigint unsigned NOT NULL,
  `service_id` bigint unsigned NOT NULL,
  `appointment_date` date NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `status` enum('pending','confirmed','completed','cancelled') NOT NULL DEFAULT 'pending',
  `notes` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `appointments_client_id_foreign` (`client_id`),
  KEY `appointments_barber_id_appointment_date_status_index` (`barber_id`,`appointment_date`,`status`),
  KEY `appointments_service_id_foreign` (`service_id`),
  CONSTRAINT `appointments_barber_id_foreign` FOREIGN KEY (`barber_id`) REFERENCES `barbers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `appointments_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `appointments_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `appointment_photos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `appointment_id` bigint unsigned NOT NULL,
  `barber_id` bigint unsigned NOT NULL,
  `file_path` varchar(500) NOT NULL,
  `file_size_kb` smallint NOT NULL,
  `taken_at` timestamp NOT NULL,
  `notes` varchar(500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `appointment_photos_appointment_id_foreign` (`appointment_id`),
  KEY `appointment_photos_barber_id_foreign` (`barber_id`),
  CONSTRAINT `appointment_photos_appointment_id_foreign` FOREIGN KEY (`appointment_id`) REFERENCES `appointments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `appointment_photos_barber_id_foreign` FOREIGN KEY (`barber_id`) REFERENCES `barbers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `barber_blocks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `barber_id` bigint unsigned NOT NULL,
  `block_date` date NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `reason` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `barber_blocks_barber_id_foreign` (`barber_id`),
  CONSTRAINT `barber_blocks_barber_id_foreign` FOREIGN KEY (`barber_id`) REFERENCES `barbers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` text NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text,
  `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `custom_service_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `barber_id` bigint unsigned NOT NULL,
  `client_name` varchar(200) DEFAULT NULL,
  `client_id` bigint unsigned DEFAULT NULL,
  `description` text NOT NULL,
  `service_date` date NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custom_service_logs_barber_id_service_date_index` (`barber_id`,`service_date`),
  KEY `custom_service_logs_client_id_foreign` (`client_id`),
  CONSTRAINT `custom_service_logs_barber_id_foreign` FOREIGN KEY (`barber_id`) REFERENCES `barbers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `custom_service_logs_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `push_subscriptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subscribable_type` varchar(255) NOT NULL,
  `subscribable_id` bigint unsigned NOT NULL,
  `endpoint` varchar(500) NOT NULL,
  `public_key` varchar(255) DEFAULT NULL,
  `auth_token` varchar(255) DEFAULT NULL,
  `content_encoding` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `push_subs_sub_endpoint_unique` (`subscribable_type`,`subscribable_id`,`endpoint`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `whatsapp_conversations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(20) NOT NULL,
  `state` varchar(50) NOT NULL DEFAULT 'menu',
  `data` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `whatsapp_conversations_phone_unique` (`phone`),
  KEY `whatsapp_conversations_phone_index` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_reserved_at_available_at_index` (`queue`,`reserved_at`,`available_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `failed_jobs` (
  `id` bigint 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;

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `users` (`id`,`name`,`email`,`password`,`role`,`phone`,`avatar_url`,`is_active`,`remember_token`,`created_at`,`updated_at`) VALUES
(1,'Admin','admin@barbershop.com','$2y$10$aex4KczucPB9kQtGIuMVku3z1ewWR8zt5pnHUdUrxkLJyIZOeKZPS','admin',NULL,NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(2,'Maikel','+50685334909','$2y$10$aex4KczucPB9kQtGIuMVku3z1ewWR8zt5pnHUdUrxkLJyIZOeKZPS','barber','+50685334909',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(3,'Moisés','+50662203282','$2y$10$YeYmvAq4iR8FByuIrDZmLejXfzi9h5IRYE1W6yjLmWQR/ybyZ6HFG','client','+50662203282',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(4,'Kevin','+50683892496','$2y$10$CH2.9LSpL1k.1sVmYb69pe4OB1lxfva.uSSWG9soxg6fVXOF8pN0y','client','+50683892496',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(5,'Esteban','+50688065891','$2y$10$IfHSHfCvpgNXafM/pZ6h0eY.o3RM9jDhsTD.l/c3lP8Dppp.x3Hse','client','+50688065891',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(6,'Mariana','+50684814368','$2y$10$ZFWDSbUT32CI33FfcIIFGOQV0V0IM/Slr1kFVA3XrtNqggAFG1OkO','client','+50684814368',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(7,'Gabriel','+50672066890','$2y$10$h0IFM4pdGnJrnM6CgeF54uqyeoT3jUVld59Yrz01RwQiV5EkVVSl2','client','+50672066890',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(8,'Román','+50661376323','$2y$10$PhL4XCEPhSdJ7Rl84k1ri.DJIzPxHSy5C.GFFZ2JaNA70rDtq5uBW','client','+50661376323',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(9,'Wilfredo','+50683231477','$2y$10$qEmFtQtO3Q7ijFuhiUlP1uanvS/XoKigyPamXT.WZUybj8.9MK5ki','client','+50683231477',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(10,'Isaac','+50688412370','$2y$10$uj8BfLQTBS7uZpGijzTMseRV6ILeDBHmSThobAk.pWJQPBkskropK','client','+50688412370',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(11,'José','+50686693131','$2y$10$6Lcq.qTLrMwY706ldwEkRu5rTni47BWtpy3/OQPMF7Ifbx6ZMUhSi','client','+50686693131',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(12,'David','+50688468622','$2y$10$ewP25fRrqq.o1GJTT32ur.jKeob8qsO3BK7.xPYOBFNfayHTzWas6','client','+50688468622',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(13,'Edgardo','+50687395555','$2y$10$NKtQq7ttcubPNXThrqi.y.hezx/h0F.R3cnGJuD2PHjVJPHIa/Mki','client','+50687395555',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(14,'Melisa','+50689632442','$2y$10$gomI.xDkepqVC1Mm55ezm.qJ6lxuUjdSBNJ0dSEo8jCCnb7aYEwva','client','+50689632442',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(15,'Ronald','+50683444644','$2y$10$r/ThUEN39D7LyoujxtfAMOJyEtD1GZf2aFFY85hnJQPtXpk1EJLxK','client','+50683444644',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(16,'Cesar','+50688327508','$2y$10$vcv9yzbIANgNr8YWkcs71OQlOSTWpc3.wl95/3EXnMOO9/1N8klAS','client','+50688327508',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(17,'Seth','+50688394857','$2y$10$nWPVP/eYKF1itOglV25L3OOkKpbPiE7lMLcyIr/.eQiaFbY0ejD.G','client','+50688394857',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(18,'Randall','+50689495154','$2y$10$Cc5i3UbP8vrKgDU64BNMOelYm8Sy2.1nAUSuJ0rtWT5p4le2PkgRy','client','+50689495154',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(19,'Eduardo','+50684450305','$2y$10$tKPYOkteOgUGc1zY7snnAOsUW/ndbljiagXbACvqXh0IrCjdoxZJa','client','+50684450305',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(20,'Rick','+50660945196','$2y$10$NcsOD8zyWJRRxCixMLClq.1mvDCDRNiji/3Q8qpJCX/6JxpjJFj8e','client','+50660945196',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(21,'Juan','+50688451795','$2y$10$7OsZXhGxCL/pWb3eYbVyNO4AxF42TadgJLiFvx2NzNguAPCusnyjW','client','+50688451795',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(22,'Kerlin','+50683610121','$2y$10$qhhKjwkIWZiZlP3Wvuy1yeezY61TWTDTJXvimpHWgw3Yft/zou5mm','client','+50683610121',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(23,'Augusto','+50683440201','$2y$10$cVs0Yn7huoIgxiup11zYw.L2Ix8zzo2bzvweste7bI0JSYiuAPp8i','client','+50683440201',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(24,'Jason','+50688236658','$2y$10$FdmjzPbEN/7VgvfycYe8ouh.gviGKciov0vRy/7CRzY/9bRgJ5EBq','client','+50688236658',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(25,'Oscar','+50689108154','$2y$10$hYYzUBpqWBJIEc0hm5YgbOHCUIpmT79..ebes4aiYexnc8tg1hCty','client','+50689108154',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(26,'German','+50688459062','$2y$10$d6qz.p3z9x3ZCUDr5IExwOQvEfjF/pdUkbA7LGMDG1747lbO555ya','client','+50688459062',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(27,'Olivier','+50688113356','$2y$10$gn0msWulmBtvfCd59AhZFuX4n1GOSfnraqB2uHikmTrAm59D8bkJO','client','+50688113356',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(28,'Erik','+50685491602','$2y$10$nCEaTJcJlW6GM.y6YOrBWuhqf31BVDmY8pfZ00FO5sqlmiorQ15Z6','client','+50685491602',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(29,'Josue','+50689528420','$2y$10$lA43LishHtK0OgX/qpj41OHK4CIx0CMjFgk8xOsbhWsDsBVK4fd4O','client','+50689528420',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(30,'Diego','+50687800479','$2y$10$rGGf0Jx.vBWaLbcV1jz19OBW9obHuDQklKtMRA3EBc7fj0SR3UFnG','client','+50687800479',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(31,'Carlos','+50688804002','$2y$10$k1VLU1cctv6XMIcNta.BR.H0SyjiYvhXS3okzvvziG6Kv7cgNvWnm','client','+50688804002',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(32,'Diogenes','+50661609725','$2y$10$7UXMN8fJjQsNxDpnWyAAUObjCAjxMBcaGXBid8Ru4tfcqETaYBJ0G','client','+50661609725',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(33,'Eder','+50684881229','$2y$10$FHVOh8bRhB.UpYh1Axo20OPhxVkH25kQpnM1WiO9.Axn9QFBJlrLi','client','+50684881229',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(34,'Yirlany','+50687070343','$2y$10$qK52BXYT3XoEe5paMpXjoeP1z.qDy0AvwmlX/UslCCmBbrw6HV9Zm','client','+50687070343',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(35,'Carmen','+50683101824','$2y$10$imD56n4u11ylYCLIODMu5uJQgCP0N7Vu8F1wqSRGNCxcHCrxbIIO2','client','+50683101824',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(36,'Michael','+50683285085','$2y$10$PyAOCUxg18Y/YVMchZl/.u3qOkDK1FujsEFxyXrqD3KZvetb3pOlG','client','+50683285085',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(37,'Fabricio','+50687061385','$2y$10$UloTpDi0Mr.4n1IiL3emvuqF2cCqhoP3/Ztdo7s3XFQ60f5l9lBVe','client','+50687061385',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(38,'Monse','+50686796911','$2y$10$P8tXhgv2CbOcPzUAQvpEYuPjUtfp5KVyVIEAEhZX8DXuGmnfia2Tq','client','+50686796911',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(39,'Alex','+50689237070','$2y$10$bW1b0WcVg9MhxU2cSZHHZ.tvfP9TwyJaWtcMhCK9L88mFP8I4U3hO','client','+50689237070',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(40,'Alonso','+50670160184','$2y$10$6IYvq27pdYxIvWAmVO/BoOF9hT2b9lW/aAwYYpHZWl75cxuDAMNAy','client','+50670160184',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(41,'Sergio','+50688291243','$2y$10$GIzO29hmmUpJoRswWsLMTeePd4tzlB6BPaAQo22u4cOoqjDHBNeTO','client','+50688291243',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(42,'Jorge','+50684684782','$2y$10$AyW7YPjqaqzkastdoxBXl.uGLdh6Eb/kuRuQ1iE7r/T8yp9Bo58ge','client','+50684684782',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(43,'Rosvin','+50689156698','$2y$10$abc7qffQSWCSKxjnD4otD.zgVLGb71QCFl.4AgUgwQtUWn3UuH.RS','client','+50689156698',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(44,'Dr','+50683441007','$2y$10$f/qO6N/7sRy5BbkDtb1BnOhNwBQrtOLgMxXWVwG0yT.jcnPgrEsOy','client','+50683441007',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(45,'Herbert','+50688939195','$2y$10$E3U/PlNPjZTS1drSoGGAWO/XSaUED0izLDgveu9L5k4.PYAT/3mU6','client','+50688939195',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(46,'Mauricio','+50671130542','$2y$10$83bH.d1lHgNlGvgGEyyF1OmXJ.e2ctkPhiY9aO/dfp/BsLIh4g5Km','client','+50671130542',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(47,'Lukas','+50687706395','$2y$10$Q6vxDaZh2.XrJjS7.P9Ubeg.DZ6cVowiMXq0pKY.VDz0yWQ/y7ucO','client','+50687706395',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(48,'Manfreth','+50684956272','$2y$10$fD6NpdJu0BRXp5TfWNDjt.hZqgnlXL1oSJkM9XW0nlR7ItU87WO26','client','+50684956272',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(49,'Saul','+50660217777','$2y$10$7Oco7ufKeIqr2nE8m/WbLuTTi3ke/MIwW1/r0Jqx2wZGyBSAL661a','client','+50660217777',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(50,'Sebastian','+50660296926','$2y$10$JZISV5N7JkSTezr65emQBe8g2EXNXoV5/IWmtqlVuMhr9aa3sd3jS','client','+50660296926',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(51,'Savier','+50685333737','$2y$10$nT.cfaW2yxl339j6.IzOkuZATnAF8Ec.LWGl3aexQ9qi9UMwSDFn6','client','+50685333737',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(52,'Yeraldin','+50684559701','$2y$10$Txu.QBfxDs4.7hgmibO3rO1RJ1YN1hHCOEus6lQ/e16s2rT9tejfC','client','+50684559701',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(53,'Mainor','+50685671072','$2y$10$T4dYefMj5n2R1qHaqJXXdewCn4dpD1RPPdtEzZPIQ6lbU9Db3btrS','client','+50685671072',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(54,'Ignacio','+50683135334','$2y$10$h7d7pInF/vLCCH/1gkVl6OUZEEN6jgdMuQtEAT3g2JqeuMcMPo.8W','client','+50683135334',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(55,'Gerardo','+50688238233','$2y$10$61T6JZjTWLSFGY1bXsJtCumlr5yH8nNU8.mmO9uVS9xDI1r8WXenW','client','+50688238233',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(56,'Rocio','+50683470443','$2y$10$cveCGQ2fBruwv6srI.VmgegmnOEbXDYf4VUwN5jlnBivPpfOXorVq','client','+50683470443',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(57,'Jeremy','+50685607667','$2y$10$KQio718UuwTSKKpoMmopmuXgiFOHgDEOZS2NIW8pY/ya6ESke0sh2','client','+50685607667',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(58,'Ramón','+50688143400','$2y$10$nY.a2fzBpYLPIp.WwoznO.CTI4xwls4qiyQRDyy//RH/u20K/XHSG','client','+50688143400',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(59,'Karol','+50689393464','$2y$10$4OsnCF4snINgLHSECJhSBuVkYRixCztmG5uq7ALAlaDE2jT98e.ea','client','+50689393464',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(60,'Karla','+50684928358','$2y$10$GYj6XK.fryNwqVwzqCs98.8SLBqg8GoyDsuOlnEprH9DRWajeWdX.','client','+50684928358',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(61,'María','+50686537781','$2y$10$3iFYvUnNbZKAdEybMbqIwehk/HAmJq6K4ysXW5jpYtBTCzDbQ/A92','client','+50686537781',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(62,'Deiver','+50664167201','$2y$10$uG3O8BeQCt1bL5BkVJhkm.gK/9Rh1KyXO1fIUbAsBhuw7O8YTUeMu','client','+50664167201',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(63,'José M','+50683088106','$2y$10$Zb92yW/J2mjCbiimNbWXz.V6thEGcig3aIlvgIUSRTSSnVVq0s15S','client','+50683088106',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(64,'Kevin A','+50687084415','$2y$10$GycEzwgMPh2IPbrU.AC5.e4QT/n6C/GCherjYCzeVOKvPi4zNkFG6','client','+50687084415',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(65,'Edgardo A','+50688235288','$2y$10$s5OOL45M4zFrWjWLLBCsSenbaebue1RntnZzhxSHfw8nMUdESM2J.','client','+50688235288',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(66,'Michael A','+50688316910','$2y$10$K3L3F8.Mlyx53Z0GMor8be9EVh1NOH4AdZb29GH0/.ZbN2puloHX.','client','+50688316910',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(67,'Juan C','+50688884682','$2y$10$Jg7meik34Fa4pL8T/G2QZeJPgzFbXfnG7GGC1F7LT0PrCt55i5RLm','client','+50688884682',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(68,'Jorge A','+50686816085','$2y$10$Ivhc0c/a0SvLgvFyD9yR6u12b4bjbsTS3QtcEsEbwTdwiP6UjddzW','client','+50686816085',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(69,'Carlos A','+50683332873','$2y$10$pVjhj8D/eqv1JmFP/g1jeO0d/HbmCsTGKXC6gkyA1WWkqFXMDbvgy','client','+50683332873',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(70,'Carlos B','+50686945640','$2y$10$CC6mzFqjtku5FvHJ3lhheuddmegVzp3i4mOmCuuZ6.wJQ3/GlMPiy','client','+50686945640',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(71,'Carlos C','+50684603574','$2y$10$Mi3ev8.g9Uh4R9fwDUczsetN6gyW9PEaomaEbDO4UYA2KDE9rWNsC','client','+50684603574',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(72,'José L','+50683135029','$2y$10$V3HCam2u2HdpAHVWkNSI.uY4sD2n/fP6e61OMlRyFyEaYB.rjx0qS','client','+50683135029',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(73,'Jose R','+50684684751','$2y$10$//ysqEUTcCP4Qzk8LUgzMO/85XGIlAo2OWKZipXnRexVaeyrqNfVm','client','+50684684751',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(74,'Jennifer','+50687298490','$2y$10$8tqIWeBy7Gox79cAgpcUkempf0Rc1W4UDivpb2BhsjXe8YLOZtbH2','client','+50687298490',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(75,'José G','+50687044008','$2y$10$2Ux.TBLxBNOayxikhx9o6etE2636.eEutRvUOan8t7GBRcnjgz0H.','client','+50687044008',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(76,'Olga','+50683902207','$2y$10$K6g9J4jHXN/wNJkyeOre2erKl/DliPKEmkYdsr5oNEZaWeBFa.J3O','client','+50683902207',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(77,'Miguel','+50683217479','$2y$10$wZEWDCxdRMxi.ZcEHqQZBOmCWV3w138OtOGWGIaJ7IkNzJrOTk0BS','client','+50683217479',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(78,'Mauricio B','+50687114826','$2y$10$ot8qK4VsehiOBxMb.6i5G.TFao1Jkl9uVd71v6edLr.oJT7MptsMq','client','+50687114826',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(79,'Diego A','+50670189926','$2y$10$rncwEkatXpRZmMm9cgamo.7bevTKm0EylukurogMwJJrjya97bwNK','client','+50670189926',NULL,1,NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17');

INSERT INTO `barbers` (`id`,`user_id`,`bio`,`specialty`,`working_days`,`work_start`,`work_end`,`display_order`,`created_at`,`updated_at`) VALUES
(1,2,NULL,'Corte y Barba','[1,2,3,4,5,6]','06:00:00','20:00:00',1,'2026-07-01 04:50:17','2026-07-01 04:50:17');

INSERT INTO `services` (`id`,`name`,`category`,`description`,`duration_minutes`,`price`,`is_active`,`created_at`,`updated_at`) VALUES
(1,'Corte',NULL,NULL,30,8000.00,1,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(2,'Corte y Barba con Vapor',NULL,NULL,60,15000.00,1,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(3,'Corte y Barba Rápido',NULL,NULL,30,10000.00,1,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(4,'Corte y Barba Premium',NULL,NULL,60,18000.00,1,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(5,'Corte y Barba con Corte de Hijo',NULL,NULL,90,20000.00,1,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(6,'Corte Pixie',NULL,NULL,60,12000.00,1,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(7,'Corte Rápido',NULL,NULL,20,6000.00,1,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(8,'Barba',NULL,NULL,30,6000.00,1,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(9,'Padre e Hijo',NULL,NULL,60,15000.00,1,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(10,'Corte Cabello Medio',NULL,NULL,60,10000.00,1,'2026-07-01 04:50:17','2026-07-01 04:50:17');

INSERT INTO `barber_services` (`id`,`barber_id`,`service_id`) VALUES
(1,1,1),
(2,1,2),
(3,1,3),
(4,1,4),
(5,1,5),
(6,1,6),
(7,1,7),
(8,1,8),
(9,1,9),
(10,1,10);

INSERT INTO `appointments` (`id`,`client_id`,`barber_id`,`service_id`,`appointment_date`,`start_time`,`end_time`,`status`,`notes`,`created_at`,`updated_at`) VALUES
(1,2,1,5,'2026-03-11','10:00:00','11:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(2,2,1,1,'2026-03-11','11:30:00','12:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(3,3,1,1,'2026-03-11','14:00:00','14:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(4,2,1,1,'2026-03-11','15:00:00','15:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(5,4,1,1,'2026-03-11','16:00:00','16:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(6,5,1,1,'2026-03-11','17:00:00','17:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(7,6,1,1,'2026-03-11','17:30:00','18:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(8,7,1,1,'2026-03-11','18:00:00','18:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(9,8,1,1,'2026-03-11','18:30:00','19:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(10,9,1,2,'2026-03-12','10:00:00','11:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(11,10,1,3,'2026-03-12','11:00:00','11:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(12,11,1,2,'2026-03-12','14:30:00','15:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(13,12,1,4,'2026-03-12','16:00:00','17:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(14,13,1,3,'2026-03-12','17:00:00','17:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(15,14,1,1,'2026-03-12','17:30:00','18:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(16,15,1,1,'2026-03-12','18:30:00','19:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(17,16,1,1,'2026-03-12','19:00:00','19:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(18,17,1,2,'2026-03-13','07:00:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(19,18,1,1,'2026-03-13','08:00:00','08:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(20,19,1,3,'2026-03-13','08:30:00','09:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(21,20,1,1,'2026-03-13','11:30:00','12:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(22,21,1,1,'2026-03-13','12:00:00','12:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(23,4,1,1,'2026-03-13','14:00:00','14:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(24,22,1,1,'2026-03-13','14:30:00','15:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(25,23,1,2,'2026-03-13','15:00:00','16:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(26,24,1,3,'2026-03-13','16:00:00','16:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(27,25,1,2,'2026-03-13','16:30:00','17:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(28,26,1,8,'2026-03-13','17:30:00','18:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(29,27,1,9,'2026-03-13','18:00:00','19:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(30,67,1,3,'2026-03-13','19:00:00','19:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(31,28,1,1,'2026-03-14','07:00:00','07:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(32,29,1,2,'2026-03-14','10:00:00','11:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(33,30,1,1,'2026-03-14','11:00:00','11:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(34,31,1,2,'2026-03-14','11:30:00','12:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(35,32,1,1,'2026-03-14','16:00:00','16:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(36,69,1,1,'2026-03-17','10:00:00','10:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(37,33,1,1,'2026-03-17','10:30:00','11:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(38,34,1,6,'2026-03-17','16:00:00','17:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(39,35,1,6,'2026-03-17','17:00:00','18:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(40,75,1,2,'2026-03-17','18:00:00','19:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(41,76,1,1,'2026-03-17','19:00:00','19:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(42,36,1,3,'2026-03-18','11:00:00','11:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(43,72,1,1,'2026-03-18','12:00:00','12:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(44,10,1,3,'2026-03-18','14:30:00','15:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(45,73,1,1,'2026-03-18','15:00:00','15:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(46,74,1,1,'2026-03-18','16:00:00','16:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(47,63,1,1,'2026-03-18','16:30:00','17:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(48,37,1,1,'2026-03-18','17:30:00','18:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(49,38,1,6,'2026-03-18','18:00:00','19:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(50,39,1,1,'2026-03-19','10:00:00','10:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(51,40,1,2,'2026-03-19','14:00:00','15:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(52,41,1,8,'2026-03-19','17:30:00','18:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(53,42,1,1,'2026-03-19','18:00:00','18:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(54,43,1,1,'2026-03-19','18:30:00','19:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(55,44,1,7,'2026-03-19','19:00:00','19:20:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(56,18,1,1,'2026-03-20','07:30:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(57,45,1,1,'2026-03-20','08:00:00','08:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(58,19,1,3,'2026-03-20','08:30:00','09:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(59,77,1,1,'2026-03-20','10:00:00','10:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(60,46,1,2,'2026-03-20','11:30:00','12:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(61,64,1,2,'2026-03-20','14:00:00','15:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(62,39,1,1,'2026-03-20','15:00:00','15:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(63,71,1,1,'2026-03-20','16:00:00','16:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(64,47,1,1,'2026-03-20','17:30:00','18:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(65,25,1,2,'2026-03-20','18:00:00','19:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(66,48,1,1,'2026-03-20','19:00:00','19:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(67,49,1,1,'2026-03-21','06:30:00','07:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(68,65,1,2,'2026-03-21','07:00:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(69,28,1,1,'2026-03-21','08:00:00','08:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(70,67,1,3,'2026-03-21','08:30:00','09:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(71,68,1,1,'2026-03-21','09:00:00','09:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(72,79,1,2,'2026-03-21','10:00:00','11:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(73,66,1,3,'2026-03-21','11:00:00','11:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(74,62,1,1,'2026-03-21','12:00:00','12:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(75,50,1,1,'2026-03-21','16:30:00','17:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(76,2,1,2,'2026-03-24','10:00:00','11:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(77,3,1,1,'2026-03-24','12:00:00','12:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(78,16,1,1,'2026-03-24','18:00:00','18:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(79,51,1,1,'2026-03-24','18:30:00','19:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(80,70,1,1,'2026-03-25','10:00:00','10:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(81,52,1,6,'2026-03-25','10:30:00','11:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(82,78,1,1,'2026-03-25','17:30:00','18:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(83,10,1,3,'2026-03-26','10:30:00','11:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(84,13,1,3,'2026-03-26','17:00:00','17:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(85,53,1,1,'2026-03-26','19:30:00','20:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(86,28,1,1,'2026-03-27','08:00:00','08:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(87,19,1,3,'2026-03-27','08:30:00','09:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(88,54,1,1,'2026-03-27','10:00:00','10:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(89,64,1,1,'2026-03-27','14:00:00','14:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(90,40,1,3,'2026-03-27','14:30:00','15:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(91,55,1,1,'2026-03-27','15:00:00','15:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(92,28,1,1,'2026-03-28','07:00:00','07:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(93,67,1,3,'2026-03-28','07:30:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(94,68,1,1,'2026-03-28','08:30:00','09:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(95,57,1,2,'2026-03-28','10:00:00','11:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(96,29,1,2,'2026-03-28','11:00:00','12:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(97,56,1,10,'2026-03-28','11:00:00','12:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(98,58,1,9,'2026-03-28','15:00:00','16:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(99,63,1,1,'2026-03-31','17:00:00','17:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(100,28,1,1,'2026-04-11','07:00:00','07:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(101,67,1,3,'2026-04-11','07:30:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(102,59,1,6,'2026-04-11','15:00:00','16:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(103,37,1,1,'2026-04-15','17:30:00','18:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(104,64,1,2,'2026-04-17','14:00:00','15:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(105,49,1,1,'2026-04-18','06:30:00','07:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(106,65,1,2,'2026-04-18','07:00:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(107,28,1,1,'2026-04-18','08:00:00','08:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(108,67,1,3,'2026-04-18','08:30:00','09:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(109,68,1,1,'2026-04-18','09:00:00','09:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(110,66,1,3,'2026-04-18','11:00:00','11:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(111,61,1,6,'2026-04-21','16:00:00','17:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(112,60,1,1,'2026-04-23','16:30:00','17:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(113,64,1,1,'2026-04-24','14:00:00','14:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(114,28,1,1,'2026-04-25','07:00:00','07:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(115,67,1,3,'2026-04-25','07:30:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(116,37,1,1,'2026-05-13','17:30:00','18:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(117,64,1,2,'2026-05-15','14:00:00','15:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(118,49,1,1,'2026-05-16','06:30:00','07:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(119,65,1,2,'2026-05-16','07:00:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(120,67,1,3,'2026-05-16','08:00:00','08:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(121,68,1,1,'2026-05-16','08:30:00','09:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(122,66,1,3,'2026-05-16','11:00:00','11:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(123,64,1,1,'2026-05-22','14:00:00','14:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(124,67,1,3,'2026-05-23','07:30:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(125,64,1,2,'2026-05-29','14:00:00','15:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(126,65,1,2,'2026-05-30','07:00:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(127,67,1,3,'2026-05-30','08:00:00','08:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(128,68,1,1,'2026-05-30','08:30:00','09:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(129,64,1,2,'2026-06-12','14:00:00','15:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(130,65,1,2,'2026-06-13','07:00:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(131,67,1,3,'2026-06-13','08:00:00','08:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(132,68,1,1,'2026-06-13','08:30:00','09:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(133,64,1,1,'2026-06-19','14:00:00','14:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(134,49,1,1,'2026-06-20','06:30:00','07:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(135,67,1,3,'2026-06-20','07:30:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(136,64,1,2,'2026-06-26','14:00:00','15:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(137,65,1,2,'2026-06-27','07:00:00','08:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(138,67,1,3,'2026-06-27','08:00:00','08:30:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(139,68,1,1,'2026-06-27','08:30:00','09:00:00','completed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(140,49,1,1,'2026-07-11','06:30:00','07:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(141,67,1,3,'2026-07-11','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(142,68,1,1,'2026-07-11','08:00:00','08:30:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(143,64,1,1,'2026-07-17','14:00:00','14:30:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(144,67,1,3,'2026-07-18','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(145,64,1,2,'2026-07-24','14:00:00','15:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(146,67,1,3,'2026-07-25','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(147,68,1,1,'2026-07-25','08:30:00','09:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(148,64,1,1,'2026-07-31','14:00:00','14:30:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(149,49,1,1,'2026-08-15','06:30:00','07:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(150,67,1,3,'2026-08-15','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(151,67,1,3,'2026-08-22','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(152,68,1,1,'2026-08-22','08:30:00','09:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(153,67,1,3,'2026-08-29','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(154,67,1,3,'2026-09-12','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(155,49,1,1,'2026-09-19','06:30:00','07:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(156,67,1,3,'2026-09-19','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(157,68,1,1,'2026-09-19','08:30:00','09:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(158,67,1,3,'2026-09-26','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(159,37,1,1,'2026-09-30','17:30:00','18:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(160,49,1,1,'2026-10-17','06:30:00','07:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(161,67,1,3,'2026-10-17','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(162,68,1,1,'2026-10-17','08:30:00','09:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(163,67,1,3,'2026-10-24','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(164,37,1,1,'2026-10-28','17:30:00','18:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(165,67,1,3,'2026-10-31','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(166,68,1,1,'2026-10-31','08:30:00','09:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(167,67,1,3,'2026-11-14','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(168,68,1,1,'2026-11-14','08:30:00','09:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(169,49,1,1,'2026-11-21','06:30:00','07:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(170,67,1,3,'2026-11-21','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(171,37,1,1,'2026-11-25','17:30:00','18:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(172,67,1,3,'2026-11-28','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(173,68,1,1,'2026-11-28','08:30:00','09:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(174,67,1,3,'2026-12-12','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(175,68,1,1,'2026-12-12','08:30:00','09:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(176,49,1,1,'2026-12-19','06:30:00','07:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(177,67,1,3,'2026-12-19','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(178,37,1,1,'2026-12-23','17:30:00','18:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(179,67,1,3,'2026-12-26','07:30:00','08:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17'),
(180,68,1,1,'2026-12-26','08:30:00','09:00:00','confirmed',NULL,'2026-07-01 04:50:17','2026-07-01 04:50:17');

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1,'0001_01_01_000001_create_cache_table',1),
(2,'0001_01_01_000002_create_jobs_table',1),
(3,'2024_01_01_000001_create_users_table',1),
(4,'2024_01_01_000002_create_barbers_table',1),
(5,'2024_01_01_000003_create_services_table',1),
(6,'2024_01_01_000004_create_barber_services_table',1),
(7,'2024_01_01_000005_create_appointments_table',1),
(8,'2024_01_01_000006_create_appointment_photos_table',1),
(9,'2024_01_01_000007_create_barber_blocks_table',1),
(10,'2024_01_01_000008_add_category_to_services_table',1),
(11,'2024_01_01_000009_create_custom_service_logs_table',1),
(12,'2024_01_01_000010_create_push_subscriptions_table',1),
(13,'2024_01_01_000011_create_whatsapp_conversations_table',1),
(14,'2026_03_11_092816_create_personal_access_tokens_table',1);

ALTER TABLE `users` AUTO_INCREMENT = 80;
ALTER TABLE `barber_services` AUTO_INCREMENT = 11;
ALTER TABLE `appointments` AUTO_INCREMENT = 181;

SET FOREIGN_KEY_CHECKS=1;