-- Asegurar que la conexión está en utf8mb4
SET NAMES utf8mb4;

-- Iniciar una transacción para asegurar la integridad de los datos
START TRANSACTION;

-- -----------------------------------------------------
-- Insertar Usuarios
-- -----------------------------------------------------
INSERT INTO `users` (`username`, `name`, `last_name`, `phone`, `email`, `password`) VALUES
('john_doe', 'John', 'Doe', '1234567890', 'john.doe@example.com', 'password_hash_1'),
('alice_smith', 'Alice', 'Smith', '0987654321', 'alice.smith@example.com', 'password_hash_2'),
('bob_williams', 'Bob', 'Williams', '1122334455', 'bob.williams@example.com', 'password_hash_3'),
('carol_jones', 'Carol', 'Jones', '2233445566', 'carol.jones@example.com', 'password_hash_4'),
('dave_brown', 'Dave', 'Brown', '3344556677', 'dave.brown@example.com', 'password_hash_5'),
('emily_green', 'Emily', 'Green', '4455667788', 'emily.green@example.com', 'password_hash_6'),
('frank_miller', 'Frank', 'Miller', '5566778899', 'frank.miller@example.com', 'password_hash_7'),
('grace_lee', 'Grace', 'Lee', '6677889900', 'grace.lee@example.com', 'password_hash_8');

-- -----------------------------------------------------
-- Insertar Roles
-- -----------------------------------------------------
INSERT INTO `roles` (`role_name`) VALUES
('admin'),
('manager'),
('employee'),
('customer');

-- -----------------------------------------------------
-- Insertar Empresas
-- -----------------------------------------------------
INSERT INTO `companies` (`company_name`, `description`) VALUES
('Company A', 'Descripción de Company A'),
('Company B', 'Descripción de Company B'),
('Company C', 'Descripción de Company C'),
('Company D', 'Descripción de Company D');

-- -----------------------------------------------------
-- Insertar Categorías (Ahora con 'company_id')
-- -----------------------------------------------------
INSERT INTO `categories` (`company_id`, `name`) VALUES
(1, 'Salud'),
(1, 'Belleza'),
(2, 'Educación'),
(3, 'Tecnología'),
(4, 'Alimentos');

-- -----------------------------------------------------
-- Insertar Subcategorías (Ahora con 'company_id')
-- -----------------------------------------------------
INSERT INTO `subcategories` (`category_id`, `company_id`, `name`) VALUES
(1, 1, 'Clínicas'), -- Company A - Salud
(2, 1, 'Barberías'), -- Company A - Belleza
(3, 2, 'Escuelas'), -- Company B - Educación
(4, 3, 'Desarrollo de Software'), -- Company C - Tecnología
(4, 3, 'Soporte Técnico'), -- Company C - Tecnología
(5, 4, 'Restaurantes'); -- Company D - Alimentos

-- -----------------------------------------------------
-- Insertar Direcciones
-- -----------------------------------------------------
INSERT INTO `addresses` (`street_address`, `address_line_2`, `postal_code`, `city`, `state`, `country`) VALUES
('123 Main St', 'Suite 100', '12345', 'City A', 'State A', 'Country A'),
('456 Elm St', NULL, '67890', 'City B', 'State B', 'Country B'),
('789 Oak St', 'Apt 5', '13579', 'City C', 'State C', 'Country C'),
('321 Pine St', NULL, '24680', 'City D', 'State D', 'Country D'),
('654 Maple Ave', 'Floor 2', '11223', 'City E', 'State E', 'Country E'),
('987 Cedar Rd', NULL, '33445', 'City F', 'State F', 'Country F'),
('159 Birch Blvd', 'Suite 200', '55667', 'City G', 'State G', 'Country G');

-- -----------------------------------------------------
-- Insertar Direcciones de Empresas
-- -----------------------------------------------------
INSERT INTO `company_addresses` (`company_id`, `address_id`) VALUES
(1, 1), -- Company A - 123 Main St
(2, 2), -- Company B - 456 Elm St
(3, 3), -- Company C - 789 Oak St
(4, 6), -- Company D - 987 Cedar Rd
(1, 7); -- Company A - 159 Birch Blvd

-- -----------------------------------------------------
-- Insertar Direcciones de Usuarios
-- -----------------------------------------------------
INSERT INTO `user_addresses` (`user_id`, `address_id`) VALUES
(1, 1), -- John Doe - 123 Main St
(2, 2), -- Alice Smith - 456 Elm St
(3, 3), -- Bob Williams - 789 Oak St
(4, 4), -- Carol Jones - 321 Pine St
(5, 5), -- Dave Brown - 654 Maple Ave
(6, 6), -- Emily Green - 987 Cedar Rd
(7, 7), -- Frank Miller - 159 Birch Blvd
(8, 4); -- Grace Lee - 321 Pine St

-- -----------------------------------------------------
-- Insertar Clientes
-- -----------------------------------------------------
INSERT INTO `customers` (`user_id`, `company_id`, `additional_info`) VALUES
(1, 1, 'Cliente VIP de Company A'),
(2, 2, 'Cliente Regular de Company B'),
(3, 3, 'Cliente Frecuente de Company C'),
(4, 4, 'Cliente Nuevo de Company D'),
(5, 1, 'Cliente Premium de Company A'),
(6, 3, 'Cliente Especial de Company C'),
(7, 2, 'Cliente Regular de Company B'),
(8, 4, 'Cliente Nuevo de Company D');

-- -----------------------------------------------------
-- Insertar Empleados
-- -----------------------------------------------------
INSERT INTO `employees` (`user_id`, `company_id`, `specialty`, `commission_rate`) VALUES
(3, 1, 'Especialista en Salud', 10.00),
(2, 1, 'Estilista Profesional', 15.00),
(1, 2, 'Profesor de Inglés', 20.00),
(4, 3, 'Desarrollador Full Stack', 25.00),
(5, 3, 'Soporte Técnico Senior', 30.00),
(6, 4, 'Chef Ejecutivo', 18.00),
(7, 4, 'Gerente de Restaurante', 22.00),
(8, 2, 'Asistente Administrativo', 12.00);

-- -----------------------------------------------------
-- Insertar Servicios
-- -----------------------------------------------------
INSERT INTO `services` (`company_id`, `service_name`, `description`, `price`, `discount`, `duration`, `commission_percentage`) VALUES
(1, 'Consulta Médica General', 'Consulta con médico general', 100.00, 10.00, '01:00:00', 10.00),
(1, 'Corte de Cabello', 'Corte y estilo de cabello', 50.00, 5.00, '00:30:00', 15.00),
(2, 'Clase de Inglés Básico', 'Curso de inglés para principiantes', 200.00, 0.00, '02:00:00', 20.00),
(3, 'Desarrollo de Aplicaciones Web', 'Creación de aplicaciones web a medida', 500.00, 50.00, '05:00:00', 30.00),
(3, 'Servicio de Soporte Técnico', 'Resolución de problemas técnicos', 300.00, 20.00, '04:00:00', 35.00),
(4, 'Menú Degustación', 'Experiencia gastronómica completa', 80.00, 10.00, '02:00:00', 15.00),
(4, 'Servicio de Catering', 'Catering para eventos especiales', 1000.00, 100.00, '08:00:00', 25.00),
(1, 'Masaje Terapéutico', 'Masaje para aliviar tensiones', 70.00, 0.00, '01:00:00', 12.00),
(2, 'Clase de Matemáticas Avanzadas', 'Curso para preparación de exámenes', 250.00, 0.00, '03:00:00', 22.00);

-- -----------------------------------------------------
-- Insertar Empleados y Servicios Relacionados
-- -----------------------------------------------------
INSERT INTO `employee_services` (`employee_id`, `service_id`, `company_id`) VALUES
(1, 3, 2), -- Empleado 1 - Clase de Inglés Básico
(2, 2, 1), -- Empleado 2 - Corte de Cabello
(3, 1, 1), -- Empleado 3 - Consulta Médica General
(4, 4, 3), -- Empleado 4 - Desarrollo de Aplicaciones Web
(5, 5, 3), -- Empleado 5 - Servicio de Soporte Técnico
(6, 6, 4), -- Empleado 6 - Menú Degustación
(7, 7, 4), -- Empleado 7 - Servicio de Catering
(2, 8, 1), -- Empleado 2 - Masaje Terapéutico
(8, 9, 2); -- Empleado 8 - Clase de Matemáticas Avanzadas

-- -----------------------------------------------------
-- Insertar Productos
-- -----------------------------------------------------
INSERT INTO `products` (`company_id`, `product_name`, `description`, `price`, `stock_quantity`, `commission_percentage`) VALUES
(1, 'Producto Salud A1', 'Vitaminas y suplementos', 20.00, 100, 5.00),
(1, 'Producto Belleza A2', 'Productos para el cuidado del cabello', 35.00, 200, 10.00),
(2, 'Libro de Inglés Básico', 'Material de estudio para el curso', 15.00, 150, 0.00),
(3, 'Software de Gestión', 'Aplicación para gestión empresarial', 200.00, 80, 30.00),
(4, 'Caja de Bombones Gourmet', 'Selección de chocolates artesanales', 50.00, 60, 20.00),
(2, 'Calculadora Científica', 'Herramienta para clases avanzadas', 25.00, 90, 15.00),
(3, 'Antivirus Premium', 'Protección avanzada para equipos', 80.00, 120, 25.00),
(4, 'Botella de Vino Reserva', 'Vino tinto de alta calidad', 60.00, 70, 18.00),
(1, 'Health Supplement A', 'A premium health supplement.', 29.99, 150, 5.00),
(1, 'Beauty Cream B', 'An organic beauty cream.', 45.50, 200, 10.00),
(2, 'English Course Book', 'Textbook for the English course.', 19.99, 100, 0.00);


-- -----------------------------------------------------
-- Insertar Reseñas
-- -----------------------------------------------------
INSERT INTO `reviews` (`user_id`, `company_id`, `rating`, `comment`) VALUES
(1, 1, 5, 'Excelente servicio médico. Muy profesionales.'),
(2, 1, 4, 'El corte de cabello fue bueno, pero la espera fue larga.'),
(3, 2, 5, 'Las clases de inglés son muy interactivas.'),
(4, 3, 4, 'El software desarrollado cumplió con nuestras expectativas.'),
(5, 4, 5, 'La comida estuvo deliciosa y el servicio impecable.'),
(6, 3, 5, 'El soporte técnico resolvió mi problema rápidamente.'),
(7, 2, 4, 'El material de estudio es de alta calidad.'),
(8, 4, 5, 'El servicio de catering hizo que nuestro evento fuera un éxito.');

-- -----------------------------------------------------
-- Insertar Horarios de Operación para Empresas
-- -----------------------------------------------------
INSERT INTO `company_operating_hours` (`company_id`, `day_of_week`, `open_time`, `close_time`, `interval_number`) VALUES
-- Company A
(1, 'Monday', '09:00:00', '18:00:00', 1),
(1, 'Tuesday', '09:00:00', '18:00:00', 1),
(1, 'Wednesday', '09:00:00', '18:00:00', 1),
(1, 'Thursday', '09:00:00', '18:00:00', 1),
(1, 'Friday', '09:00:00', '18:00:00', 1),
(1, 'Saturday', '10:00:00', '14:00:00', 1),
(1, 'Sunday', NULL, NULL, 1), -- Cerrado

-- Company B
(2, 'Monday', '08:00:00', '17:00:00', 1),
(2, 'Tuesday', '08:00:00', '17:00:00', 1),
(2, 'Wednesday', '08:00:00', '17:00:00', 1),
(2, 'Thursday', '08:00:00', '17:00:00', 1),
(2, 'Friday', '08:00:00', '17:00:00', 1),
(2, 'Saturday', NULL, NULL, 1), -- Cerrado
(2, 'Sunday', NULL, NULL, 1), -- Cerrado

-- Company C
(3, 'Monday', '09:00:00', '18:00:00', 1),
(3, 'Tuesday', '09:00:00', '18:00:00', 1),
(3, 'Wednesday', '09:00:00', '18:00:00', 1),
(3, 'Thursday', '09:00:00', '18:00:00', 1),
(3, 'Friday', '09:00:00', '18:00:00', 1),
(3, 'Saturday', '10:00:00', '16:00:00', 1),
(3, 'Sunday', NULL, NULL, 1), -- Cerrado

-- Company D
(4, 'Monday', '12:00:00', '22:00:00', 1),
(4, 'Tuesday', '12:00:00', '22:00:00', 1),
(4, 'Wednesday', '12:00:00', '22:00:00', 1),
(4, 'Thursday', '12:00:00', '22:00:00', 1),
(4, 'Friday', '12:00:00', '23:00:00', 1),
(4, 'Saturday', '10:00:00', '23:00:00', 1),
(4, 'Sunday', '10:00:00', '20:00:00', 1);

-- -----------------------------------------------------
-- Insertar Schedule Types (Ahora con 'company_id')
-- -----------------------------------------------------
INSERT INTO `schedule_types` (`company_id`, `description`, `days_available`) VALUES
(1, 'Horario Completo', 'Monday,Tuesday,Wednesday,Thursday,Friday'),
(1, 'Medio Tiempo', 'Monday,Wednesday,Friday'),
(2, 'Turno Mañana', 'Monday,Tuesday,Wednesday,Thursday,Friday'),
(3, 'Turno Tarde', 'Monday,Tuesday,Wednesday,Thursday,Friday'),
(4, 'Fin de Semana', 'Saturday,Sunday');

-- -----------------------------------------------------
-- Insertar Work Time Types (Ahora con 'company_id')
-- -----------------------------------------------------
INSERT INTO `work_time_types` (`company_id`, `start_time`, `end_time`, `lunch_start_time`, `lunch_end_time`) VALUES
(1, '09:00:00', '17:00:00', '12:00:00', '13:00:00'),
(1, '13:00:00', '21:00:00', '17:00:00', '18:00:00'),
(2, '08:00:00', '14:00:00', '11:00:00', '11:30:00'),
(3, '14:00:00', '22:00:00', '18:00:00', '18:30:00'),
(4, '10:00:00', '18:00:00', '14:00:00', '15:00:00');

-- -----------------------------------------------------
-- Insertar Employee Schedule Types (Ahora con 'company_id')
-- -----------------------------------------------------
INSERT INTO `employee_schedule_types` (`employee_id`, `schedule_type_id`, `company_id`) VALUES
(1, 1, 2), -- Empleado 1 - Horario Completo en Company B
(2, 2, 1), -- Empleado 2 - Medio Tiempo en Company A
(3, 1, 1), -- Empleado 3 - Horario Completo en Company A
(4, 3, 3), -- Empleado 4 - Turno Tarde en Company C
(5, 4, 3), -- Empleado 5 - Turno Tarde en Company C
(6, 5, 4), -- Empleado 6 - Fin de Semana en Company D
(7, 5, 4), -- Empleado 7 - Fin de Semana en Company D
(8, 2, 2); -- Empleado 8 - Medio Tiempo en Company B

-- -----------------------------------------------------
-- Insertar Employee Work Times (Ahora con 'company_id')
-- -----------------------------------------------------
INSERT INTO `employee_work_times` (`employee_id`, `work_time_type_id`, `company_id`) VALUES
(1, 3, 2), -- Empleado 1 - Turno Mañana en Company B
(2, 1, 1), -- Empleado 2 - Turno Día en Company A
(3, 1, 1), -- Empleado 3 - Turno Día en Company A
(4, 4, 3), -- Empleado 4 - Turno Tarde en Company C
(5, 4, 3), -- Empleado 5 - Turno Tarde en Company C
(6, 5, 4), -- Empleado 6 - Turno de Fin de Semana en Company D
(7, 5, 4), -- Empleado 7 - Turno de Fin de Semana en Company D
(8, 3, 2); -- Empleado 8 - Turno Mañana en Company B

-- -----------------------------------------------------
-- Insertar Company User Roles
-- -----------------------------------------------------
INSERT INTO `company_user_roles` (`company_id`, `user_id`, `role_id`) VALUES
(1, 1, 1), -- Company A - John Doe - Admin
(1, 2, 2), -- Company A - Alice Smith - Manager
(1, 3, 3), -- Company A - Bob Williams - Employee
(2, 4, 1), -- Company B - Carol Jones - Admin
(2, 5, 2), -- Company B - Dave Brown - Manager
(3, 5, 1), -- Company C - Dave Brown - Admin
(3, 6, 3), -- Company C - Emily Green - Employee
(4, 7, 1), -- Company D - Frank Miller - Admin
(4, 8, 2); -- Company D - Grace Lee - Manager

-- -----------------------------------------------------
-- Insertar Carts (Ahora con 'company_id')
-- -----------------------------------------------------
INSERT INTO `carts` (`customer_id`, `company_id`) VALUES
(1, 1),
(2, 2),
(3, 3),
(4, 4),
(5, 1),
(6, 3),
(7, 2),
(8, 4);

-- -----------------------------------------------------
-- Insertar Cart Items (Modificados)
-- -----------------------------------------------------
INSERT INTO `cart_items` (`cart_id`, `customer_id`, `company_id`) VALUES
(1, 1, 1),
(2, 2, 2),
(3, 3, 3),
(4, 4, 4),
(5, 5, 1),
(6, 6, 3),
(7, 7, 2),
(8, 8, 4);

-- -----------------------------------------------------
-- Insertar Cart Products
-- -----------------------------------------------------
INSERT INTO `cart_products` (`cart_item_id`, `product_id`, `quantity`) VALUES
(1, 1, 2), -- Cart 1 - Producto Salud A1 x2
(1, 2, 1), -- Cart 1 - Producto Belleza A2 x1
(2, 3, 3), -- Cart 2 - Libro de Inglés Básico x3
(3, 4, 1), -- Cart 3 - Software de Gestión x1
(4, 5, 2), -- Cart 4 - Caja de Bombones Gourmet x2
(5, 1, 1), -- Cart 5 - Producto Salud A1 x1
(6, 7, 2), -- Cart 6 - Antivirus Premium x2
(7, 6, 1), -- Cart 7 - Calculadora Científica x1
(8, 8, 3); -- Cart 8 - Botella de Vino Reserva x3

-- -----------------------------------------------------
-- Insertar Cart Services
-- -----------------------------------------------------
INSERT INTO `cart_services` (`cart_item_id`, `service_id`) VALUES
(1, 1), -- Cart 1 - Consulta Médica General
(2, 3), -- Cart 2 - Clase de Inglés Básico
(3, 4), -- Cart 3 - Desarrollo de Aplicaciones Web
(4, 6), -- Cart 4 - Menú Degustación
(5, 2), -- Cart 5 - Corte de Cabello
(6, 5), -- Cart 6 - Servicio de Soporte Técnico
(7, 9), -- Cart 7 - Clase de Matemáticas Avanzadas
(8, 7); -- Cart 8 - Servicio de Catering

-- -----------------------------------------------------
-- Insertar Appointments
-- -----------------------------------------------------
INSERT INTO `appointments` (`customer_id`, `company_id`, `appointment_datetime`, `status`, `total_duration`, `total_cost`) VALUES
(1, 1, '2024-10-01 10:00:00', 'confirmed', '01:00:00', 90.00),
(2, 2, '2024-10-02 14:00:00', 'pending', '02:00:00', 200.00),
(3, 3, '2024-10-03 09:00:00', 'completed', '05:00:00', 550.00),
(4, 4, '2024-10-04 19:00:00', 'confirmed', '02:00:00', 80.00),
(5, 1, '2024-10-05 11:00:00', 'cancelled', '00:30:00', 50.00),
(6, 3, '2024-10-06 13:00:00', 'confirmed', '04:00:00', 320.00),
(7, 2, '2024-10-07 15:00:00', 'completed', '03:00:00', 250.00),
(8, 4, '2024-10-08 12:00:00', 'confirmed', '08:00:00', 1000.00);

-- -----------------------------------------------------
-- Insertar Appointment Services
-- -----------------------------------------------------
INSERT INTO `appointment_services` (`appointment_id`, `service_id`, `employee_id`, `company_id`, `status`, `service_start_datetime`, `service_end_datetime`) VALUES
(1, 1, 3, 1, 'completed', '2024-10-01 10:00:00', '2024-10-01 11:00:00'),
(2, 3, 1, 2, 'pending', NULL, NULL),
(3, 4, 4, 3, 'completed', '2024-10-03 09:00:00', '2024-10-03 14:00:00'),
(4, 6, 6, 4, 'completed', '2024-10-04 19:00:00', '2024-10-04 21:00:00'),
(5, 2, 2, 1, 'cancelled', NULL, NULL),
(6, 5, 5, 3, 'confirmed', '2024-10-06 13:00:00', '2024-10-06 17:00:00'),
(7, 9, 8, 2, 'completed', '2024-10-07 15:00:00', '2024-10-07 18:00:00'),
(8, 7, 7, 4, 'confirmed', '2024-10-08 12:00:00', '2024-10-08 20:00:00');

-- -----------------------------------------------------
-- Insertar Appointment Products
-- -----------------------------------------------------
INSERT INTO `appointment_products` (`appointment_id`, `product_id`, `quantity`, `company_id`, `status`) VALUES
(1, 1, 2, 1, 'completed'),
(2, 3, 1, 2, 'pending'),
(3, 4, 1, 3, 'completed'),
(4, 5, 2, 4, 'completed'),
(5, 2, 1, 1, 'cancelled'),
(6, 7, 2, 3, 'confirmed'),
(7, 6, 1, 2, 'completed'),
(8, 8, 3, 4, 'confirmed');

-- -----------------------------------------------------
-- Insertar Service Subcategories (Ahora con 'company_id')
-- -----------------------------------------------------
INSERT INTO `service_subcategories` (`service_id`, `subcategory_id`, `company_id`) VALUES
(1, 1, 1), -- "Consulta Médica General" en "Clínicas" de Company A
(2, 2, 1), -- "Corte de Cabello" en "Barberías" de Company A
(3, 3, 2), -- "Clase de Inglés Básico" en "Escuelas" de Company B
(4, 4, 3), -- "Desarrollo de Aplicaciones Web" en "Desarrollo de Software" de Company C
(5, 5, 3), -- "Servicio de Soporte Técnico" en "Soporte Técnico" de Company C
(6, 6, 4), -- "Menú Degustación" en "Restaurantes" de Company D
(7, 6, 4); -- "Servicio de Catering" en "Restaurantes" de Company D


-- Insert images for products
INSERT INTO `product_images` (`product_id`, `image_url`, `sort_order`) VALUES
(1, 'https://picsum.photos/id/1/400/300', 1),
(1, 'https://picsum.photos/id/2/400/300', 2),
(2, 'https://picsum.photos/id/3/400/300', 1),
(2, 'https://picsum.photos/id/4/400/300', 2),
(3, 'https://picsum.photos/id/5/400/300', 1),
(3, 'https://picsum.photos/id/6/400/300', 2),
(4, 'https://picsum.photos/id/7/400/300', 1),
(4, 'https://picsum.photos/id/8/400/300', 2),
(5, 'https://picsum.photos/id/9/400/300', 1),
(5, 'https://picsum.photos/id/10/400/300', 2),
(6, 'https://picsum.photos/id/11/400/300', 1),
(6, 'https://picsum.photos/id/12/400/300', 2),
(7, 'https://picsum.photos/id/13/400/300', 1),
(7, 'https://picsum.photos/id/14/400/300', 2),
(8, 'https://picsum.photos/id/15/400/300', 1),
(8, 'https://picsum.photos/id/16/400/300', 2),
(9, 'https://picsum.photos/id/17/400/300', 1),
(10, 'https://picsum.photos/id/18/400/300', 1),
(11, 'https://picsum.photos/id/19/400/300', 1),
(11, 'https://picsum.photos/id/20/400/300', 2);



-- Insert images for services
INSERT INTO `service_images` (`service_id`, `image_url`, `sort_order`) VALUES
(1, 'https://picsum.photos/id/1/400/300', 1),
(1, 'https://picsum.photos/id/2/400/300', 2),
(2, 'https://picsum.photos/id/3/400/300', 1),
(2, 'https://picsum.photos/id/4/400/300', 2),
(3, 'https://picsum.photos/id/5/400/300', 1),
(3, 'https://picsum.photos/id/6/400/300', 2),
(4, 'https://picsum.photos/id/7/400/300', 1),
(4, 'https://picsum.photos/id/8/400/300', 2),
(5, 'https://picsum.photos/id/9/400/300', 1),
(5, 'https://picsum.photos/id/10/400/300', 2),
(6, 'https://picsum.photos/id/11/400/300', 1),
(6, 'https://picsum.photos/id/12/400/300', 2),
(7, 'https://picsum.photos/id/13/400/300', 1),
(7, 'https://picsum.photos/id/14/400/300', 2),
(8, 'https://picsum.photos/id/15/400/300', 1),
(8, 'https://picsum.photos/id/16/400/300', 2),
(9, 'https://picsum.photos/id/17/400/300', 1),
(9, 'https://picsum.photos/id/18/400/300', 2),
(9, 'https://picsum.photos/id/19/400/300', 3),
(9, 'https://picsum.photos/id/20/400/300', 4);


INSERT INTO `services` (`company_id`, `service_name`, `description`, `price`, `discount`, `duration`, `commission_percentage`) VALUES
(1, 'General Health Consultation', 'Consultation with a general practitioner.', 100.00, 10.00, '01:00:00', 10.00),
(2, 'Basic English Class', 'An introductory English class.', 200.00, 0.00, '02:00:00', 20.00),
(3, 'Web Application Development', 'Custom web app development.', 500.00, 50.00, '05:00:00', 30.00);

-- -----------------------------------------------------
-- Finalizar la Transacción
-- -----------------------------------------------------
COMMIT;
