-- 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


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 `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 `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 `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 `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 `barber_services` AUTO_INCREMENT = 11;
ALTER TABLE `appointments` AUTO_INCREMENT = 181;

