-- Barbería San Ramón: schema + seed for empty MySQL 8
-- Generated UTC: 2026-05-01 03:16:14
-- 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$aqfV2zBAy3NGDpAQqn.le.4SxL28UBXOQQZYr2PVfQzF.Y3zSMUfi','admin',NULL,NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(2,'Maikel','+50685334909','$2y$10$aqfV2zBAy3NGDpAQqn.le.4SxL28UBXOQQZYr2PVfQzF.Y3zSMUfi','barber','+50685334909',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(3,'Moisés','+50662203282','$2y$10$Su8SYIOGANv1yh95Ty.kveIrRyVZ59TOdm21kjMv.yZphYZq0IrxS','client','+50662203282',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(4,'Kevin','+50683892496','$2y$10$UFZLx0yJOSno1ezGCxGiz.XOOwVQcrhiaEa6kw4lxpVx5IKHN8uFS','client','+50683892496',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(5,'Esteban','+50688065891','$2y$10$AKiwa3iRkxwwCC3eN3KZEetfkA07kQEp8aImLgalLmsRrnFfPTmEG','client','+50688065891',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(6,'Mariana','+50684814368','$2y$10$GJGrLki7Kmt3lnAZhDDxlupy2slml7JvFraLAfz/hwX/AxDpsyeMm','client','+50684814368',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(7,'Gabriel','+50672066890','$2y$10$WGNGn0t3M.jijdgdOlZcEOxvZjFDBztjAd/FnfNByYcJukFHVDUQC','client','+50672066890',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(8,'Román','+50661376323','$2y$10$L0pjQ8JgfQHrwYW7RiGpQeGnYLmHqsuwdUL6Ji.K7E5JsOPZ7x552','client','+50661376323',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(9,'Wilfredo','+50683231477','$2y$10$aWPAV80GB.AmZEgnnNcRZONAiyFnyJA0sRWPvd9hb.9h3dQcW.huO','client','+50683231477',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(10,'Isaac','+50688412370','$2y$10$uOt73pj8Oucusz6ELDipFuf3Zw6GwAFGfY0CUlZySeTzOeACvpo7.','client','+50688412370',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(11,'José','+50686693131','$2y$10$6ZMCEKHnDHjT7Ejad1qHSuyAHxL0p9uXfjcnuOVZ3HZuaw5bBX3Am','client','+50686693131',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(12,'David','+50688468622','$2y$10$X4OYxRgmnynmCa6P32E9L.E.bubvPeCMGtr/xlLMgDiBkNTPkztA2','client','+50688468622',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(13,'Edgardo','+50687395555','$2y$10$swA5nVYukWkoF3yNqg3Ty.Yps.N8de5vobO3MX6gmdJ/KSpJUXv16','client','+50687395555',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(14,'Melisa','+50689632442','$2y$10$8ZTuLM9a7BhY.dfL7tR9gORgzKZ32nHuJm2VgE18k50wpCvdVjD4K','client','+50689632442',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(15,'Ronald','+50683444644','$2y$10$QwBtyEbwy8RypQFvdP76mOqEy2pXex1keQmPyAUUpkOmWSfg07phO','client','+50683444644',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(16,'Cesar','+50688327508','$2y$10$xlF32CewRBuIPRS6dIsJhOm2U9xqUegemfNexojpsLfrechvs6/MO','client','+50688327508',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(17,'Seth','+50688394857','$2y$10$6aVeOpHUFTAo2Wy9sVpKTOTTiZ0k6aIEnYUIAyPmvPcXlCWjmHgpS','client','+50688394857',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(18,'Randall','+50689495154','$2y$10$UKfnDJ11xnU2uLS12.68su0eh2Np69Ol2CrED3N1.alqqxixZ1jYa','client','+50689495154',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(19,'Eduardo','+50684450305','$2y$10$KsqdyWnY86GbTiT7fU4gu.n2evvdOnncxJPA5mRi.H/g0dWDLGrXu','client','+50684450305',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(20,'Rick','+50660945196','$2y$10$8V5UOnjkHeJdnEh2Tn3StOPg7j695XNNB9ggTAM2yo7now3mgWQUy','client','+50660945196',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(21,'Juan','+50688451795','$2y$10$SSiOJC7mAUzAqivo6MQ9/uLAjHK31VY0T.CeDPwnqmCzOuCm3y2VK','client','+50688451795',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(22,'Kerlin','+50683610121','$2y$10$XrKNUhAnxl3oIhYnG6Zgke.rtgeyX62Rr5SVJoWIS.L5/x/Ylhl6i','client','+50683610121',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(23,'Augusto','+50683440201','$2y$10$jXwyb7p8jD1kD6imRguh9O3xHIUX1yk9Yr8X57QBbIKMA/m3IPyJO','client','+50683440201',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(24,'Jason','+50688236658','$2y$10$Rb9AUvxlqp/Di6TmIEaI1eNnok//oQX6FgxFux8EeHVqevUoX2wWm','client','+50688236658',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(25,'Oscar','+50689108154','$2y$10$Q0obASfP5hS3OTtfBO8Kt.S5Hvd5QoYd5RnvHmJNm56qCXl5gbjuG','client','+50689108154',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(26,'German','+50688459062','$2y$10$/HkzavcDoJw5sREUo/ptQuOWI9HlLjpgAfPn8.N1BVgxZnQFbdSnW','client','+50688459062',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(27,'Olivier','+50688113356','$2y$10$mHecB/rLcWOuuEPaecacEeOZCdxirixe/t7lR72BrM9Ax7aWtSJTG','client','+50688113356',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(28,'Erik','+50685491602','$2y$10$0A.6YsEwrrZoxCRMYAauFe41kGTeXVdukMyRLlVovP608UUpLSL9i','client','+50685491602',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(29,'Josue','+50689528420','$2y$10$.ImGjRqrpPEOnvy7u/.uWuexN9DGpCGfu32PLgxjddBC2WQBXk1jC','client','+50689528420',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(30,'Diego','+50687800479','$2y$10$OmPuJeJ2zQVyES3417luxunRq0LkMQrrC.Vnhgr086U3ZVu3qdb52','client','+50687800479',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(31,'Carlos','+50688804002','$2y$10$0ZwZDRw9Y8jr/t2/dvc3E.d1VwKGCxOimpL6GHvf5l6yfoM2IDgXq','client','+50688804002',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(32,'Diogenes','+50661609725','$2y$10$L1QgqT22cfnvjHWzAZ//aOw.umZn310fRjvfWMR8J5lks.Mp08V2W','client','+50661609725',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(33,'Eder','+50684881229','$2y$10$73yEvTWw0waKrb1MYqFbM.GV1QGOzW4L48QMUIL67l1VCeUXcV2zO','client','+50684881229',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(34,'Yirlany','+50687070343','$2y$10$7.4IFJTmCBFXuJILhxbFtuByvVPO2HGJNv8OkPgUkJWST.3r6fy7i','client','+50687070343',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(35,'Carmen','+50683101824','$2y$10$ZXIM84K/ld6ck.n2gmYcveTszeA6I4Oht9A/cj0vGxJTTAeIxTnNu','client','+50683101824',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(36,'Michael','+50683285085','$2y$10$m/lySMj.qeMwU/qJfcJ9auD77RQSDuLqvtimZWFHbew07XhZ7Avp6','client','+50683285085',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(37,'Fabricio','+50687061385','$2y$10$SahnWmZGPi46Qn0tYsmhie.QQyZhjJCzoe3JnJ6.G0G5/a2rcFRzK','client','+50687061385',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(38,'Monse','+50686796911','$2y$10$eLxatw0ntvLjPJWogREFK.JFzjg6eiB2dRj3R1Oi1x4eESGI5.FGO','client','+50686796911',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(39,'Alex','+50689237070','$2y$10$sdCIQa0iyb4yI6CbH2fNQeFxqsiHFiM4ayTkJ6.PRupmEV1n4dfqK','client','+50689237070',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(40,'Alonso','+50670160184','$2y$10$2AGXoSX4Byk8ekzcdv5Q3uPHkdUtSh2JFDTb5HgIGdPAkD3o5zPoa','client','+50670160184',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(41,'Sergio','+50688291243','$2y$10$IEDSQT.9UPY4XJU0tFQNLO5zBWPeBbS4Q5jH0yWfEsN8BpKIlSjxG','client','+50688291243',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(42,'Jorge','+50684684782','$2y$10$aASa571ykicX2B1VGDuxb.z47KiSRxMAxQdc8YdumQraCul/Eh/ji','client','+50684684782',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(43,'Rosvin','+50689156698','$2y$10$93pQVBBJgw6iiDca1VIUO.Kf8QA9lsO5D9AMspagqUzYvk617METC','client','+50689156698',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(44,'Dr','+50683441007','$2y$10$B3/P5mNGCT7GF88u3thONezv8PLRUFdUL4RsVbnJAXewmqfs9TLuG','client','+50683441007',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(45,'Herbert','+50688939195','$2y$10$JymnrXOOrI7NCBcAzGYpe.3uVeweSl4CPXUF/rlJN4peUgs.qSsla','client','+50688939195',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(46,'Mauricio','+50671130542','$2y$10$P8BPlP8rzehO/uc61mul2OYxzfc3wzR2jQa7Jh8hYVxIVMhxWv6Ji','client','+50671130542',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(47,'Lukas','+50687706395','$2y$10$vG5bVScrgEY06nsniDlV4.FdwGg4H7/7uBPD756dJi/CpskN1.SB6','client','+50687706395',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(48,'Manfreth','+50684956272','$2y$10$t447oAnaHTl2fpFlUtjEXOyGe3ayjdF1vMEL5WfiIxobxL6LDB9ei','client','+50684956272',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(49,'Saul','+50660217777','$2y$10$h2aYpdld6rzs2utRMHIWSOgcE4gGnyrnrj5CGOX2JDjJmDMXMf56G','client','+50660217777',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(50,'Sebastian','+50660296926','$2y$10$CbzpJqGX1Q.3CpvDiEWaW.QYT/UYWtIp43Mxtfx41yUSHSGxQlmA6','client','+50660296926',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(51,'Savier','+50685333737','$2y$10$NXEoxEh85jLgvAyBnXtDm.ZQZFqP4xaCuUEh.BJIv6vu2oVWOFXLy','client','+50685333737',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(52,'Yeraldin','+50684559701','$2y$10$TlaFA4/.oIuNBbHpNEoEfurKh0.saWV4IBP0idu.pAzy1Nlo1OWnm','client','+50684559701',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(53,'Mainor','+50685671072','$2y$10$jn86owj06VWQ0rWr3KjX/u5dh.q6h3cxGp2fv3mZObH9GIyTrAr.y','client','+50685671072',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(54,'Ignacio','+50683135334','$2y$10$.cRarepmKMfsBGhu2Igm5OwEexphB1zzoUzNhP3DnqgH6ySRVzLmq','client','+50683135334',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(55,'Gerardo','+50688238233','$2y$10$KBLW1Q56XTgaWOV7fnlQHeZxuFXiPcFfmdULTVHF5QNp.Mlba0OKC','client','+50688238233',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(56,'Rocio','+50683470443','$2y$10$Om/yAEgvoKe9yQTG.xD6jOMTJ0KOZ369yKNVvIlkk5W4tMipF5KzS','client','+50683470443',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(57,'Jeremy','+50685607667','$2y$10$P5QBx3.KqhjWghHXkpkx1e/FP6JMVnEaUoIVQf356UHwDW.DdUEt2','client','+50685607667',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(58,'Ramón','+50688143400','$2y$10$hI1u8KpJbnOXBvx01c.AOeGIHH5XtmOSUw3NMAXXDMVHFyAgbIFbS','client','+50688143400',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(59,'Karol','+50689393464','$2y$10$4lHwYiK473M5b.aY3gwfh.UTk4NXlj9MRcaP5KKhurAzfaH8mBLBe','client','+50689393464',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(60,'Karla','+50684928358','$2y$10$.RO8Ag/xL1CtGQGWEwaPr.Prm268I95i4r19WTQCSYfjLCq3phI/u','client','+50684928358',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(61,'María','+50686537781','$2y$10$cLKhIcWpgZ/HRIsUNiiQL.MYHOm6359fhNZLNGcVWGbQhL6rzVZPu','client','+50686537781',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(62,'Deiver','+50664167201','$2y$10$FaJkI0LKHJs7n89o2x6PP.bmj2D4QskFb6/7vyQbV74h6FuY8ZOwK','client','+50664167201',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(63,'José M','+50683088106','$2y$10$YxWaVbJ69anE0iETOSZm3emdVNOfvRPXAPzqojuNcaNGBOTiQM7qO','client','+50683088106',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(64,'Kevin A','+50687084415','$2y$10$ArQrsPTJPRGjMj1QO3AEK.Kz98Avp7Fg7sd2g7nETRervj2TdEtCm','client','+50687084415',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(65,'Edgardo A','+50688235288','$2y$10$ThZrnVmzVu8giXKnUDh61.JP7VNWQ1uDcWPnLppDz5pVcKJkcnksW','client','+50688235288',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(66,'Michael A','+50688316910','$2y$10$CekEdzJD4/8C3poG1kxV/u95Kv9jmqJbK1qoml2nxbszAyKCHTeC2','client','+50688316910',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(67,'Juan C','+50688884682','$2y$10$4S7Au4fxEXuld8d7aw.TyuwbQZfcFlapxB0YoJyPMldeusyYbi3IS','client','+50688884682',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(68,'Jorge A','+50686816085','$2y$10$PT5F/x6j/E6KmRy6iZqqyuZwWv6.LpV46OfV0LJSpvXXoJTiRaQ9.','client','+50686816085',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(69,'Carlos A','+50683332873','$2y$10$IQ0S1XVUvpDPlJNauPQZbuR4YbLhqNaD2WrCrE8PfC71t160N7Iza','client','+50683332873',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(70,'Carlos B','+50686945640','$2y$10$2o6mXcYEDeC3BNgcYq.HneUBnzd5TE6g35vGOYir1Pe5zFR7HL.ie','client','+50686945640',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(71,'Carlos C','+50684603574','$2y$10$pCFXntBejj.GgvnzfjCUb.J/791HdY5tOh8QGuvb5gtvLjAqONwPa','client','+50684603574',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(72,'José L','+50683135029','$2y$10$I0WKLgJMZX6KkTez.GKdEeHt32o2Z6n5KHu3nTz3cgSlHFBt0m.OS','client','+50683135029',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(73,'Jose R','+50684684751','$2y$10$KTdwlR6vif9Ep4mWHpimWugAHl7MgEFifv3LvS0sFKEdD5mHoUbNq','client','+50684684751',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(74,'Jennifer','+50687298490','$2y$10$R5v/nh1aRSdeUbZDjmH/CuXfgYdIfykQmovsb1vadBfXETO9HaL.u','client','+50687298490',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(75,'José G','+50687044008','$2y$10$JthkNmSrZcuBD5XzFN193u6GbMEpsccrpmrjyTuYizd.j18TLHFNm','client','+50687044008',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(76,'Olga','+50683902207','$2y$10$F1XDp2GkCSZBo6YBw88JG.1mQgyomsGHWkATx7NKCjK8m3klbMMlW','client','+50683902207',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(77,'Miguel','+50683217479','$2y$10$WDHG0QffK3h4T2wTM9F7TOTzPpI7qzh7urrimwWkZee7C9zjR394O','client','+50683217479',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(78,'Mauricio B','+50687114826','$2y$10$k1iovGAgSJsMTaOg05iPyulyB11/y54nhS4trVRNqiT0h9BKQtVKu','client','+50687114826',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(79,'Diego A','+50670189926','$2y$10$/lUuTpPABa3ilArDzxw76u0d/pjyV1nN1IYOSJc80RrKI/ZntTeCK','client','+50670189926',NULL,1,NULL,'2026-05-01 03:16:14','2026-05-01 03:16:14');

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-05-01 03:16:14','2026-05-01 03:16:14');

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-05-01 03:16:14','2026-05-01 03:16:14'),
(2,'Corte y Barba con Vapor',NULL,NULL,60,15000.00,1,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(3,'Corte y Barba Rápido',NULL,NULL,30,10000.00,1,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(4,'Corte y Barba Premium',NULL,NULL,60,18000.00,1,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(5,'Corte y Barba con Corte de Hijo',NULL,NULL,90,20000.00,1,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(6,'Corte Pixie',NULL,NULL,60,12000.00,1,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(7,'Corte Rápido',NULL,NULL,20,6000.00,1,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(8,'Barba',NULL,NULL,30,6000.00,1,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(9,'Padre e Hijo',NULL,NULL,60,15000.00,1,'2026-05-01 03:16:14','2026-05-01 03:16:14'),
(10,'Corte Cabello Medio',NULL,NULL,60,10000.00,1,'2026-05-01 03:16:14','2026-05-01 03:16:14');

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

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;