/*
 Navicat Premium Dump SQL

 Source Server         : dbKl
 Source Server Type    : MySQL
 Source Server Version : 100621 (10.6.21-MariaDB-cll-lve-log)
 Source Host           : 127.0.0.1:3306
 Source Schema         : glabeevs_klpartys

 Target Server Type    : MySQL
 Target Server Version : 100621 (10.6.21-MariaDB-cll-lve-log)
 File Encoding         : 65001

 Date: 10/04/2025 18:59:48
*/


-- ----------------------------
-- Table structure for cart_items
-- ----------------------------
CREATE TABLE `cart_items`  (
  `cart_item_id` int NOT NULL AUTO_INCREMENT,
  `cart_id` int NOT NULL COMMENT 'ID del carrito',
  `product_id` int NULL DEFAULT NULL COMMENT 'ID del producto agregado al carrito',
  `package_id` int NULL DEFAULT NULL COMMENT 'ID del paquete agregado al carrito',
  `character_id` int NULL DEFAULT NULL COMMENT 'ID del personaje agregado al carrito',
  `quantity` int NULL DEFAULT 1 COMMENT 'Cantidad del producto, paquete o personaje',
  PRIMARY KEY (`cart_item_id`) USING BTREE,
  INDEX `cart_id`(`cart_id` ASC) USING BTREE,
  INDEX `product_id`(`product_id` ASC) USING BTREE,
  INDEX `package_id`(`package_id` ASC) USING BTREE,
  INDEX `character_id`(`character_id` ASC) USING BTREE,
  CONSTRAINT `cart_items_ibfk_1` FOREIGN KEY (`cart_id`) REFERENCES `shopping_cart` (`cart_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `cart_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`product_id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT `cart_items_ibfk_3` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT `cart_items_ibfk_4` FOREIGN KEY (`character_id`) REFERENCES `characters` (`character_id`) ON DELETE SET NULL ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cart_items
-- ----------------------------
INSERT INTO `cart_items` VALUES (1, 1, 1, NULL, NULL, 1);
INSERT INTO `cart_items` VALUES (2, 1, 3, NULL, NULL, 1);
INSERT INTO `cart_items` VALUES (3, 1, NULL, NULL, 1, 1);
INSERT INTO `cart_items` VALUES (4, 2, NULL, 3, NULL, 1);
INSERT INTO `cart_items` VALUES (5, 3, NULL, 4, NULL, 1);
INSERT INTO `cart_items` VALUES (6, 3, NULL, NULL, NULL, 1);
INSERT INTO `cart_items` VALUES (7, 4, NULL, 5, 10, 1);
INSERT INTO `cart_items` VALUES (8, 4, 2, NULL, NULL, 1);
INSERT INTO `cart_items` VALUES (9, 4, 4, NULL, NULL, 5);

-- ----------------------------
-- Table structure for character_availability
-- ----------------------------
CREATE TABLE `character_availability`  (
  `availability_id` int NOT NULL AUTO_INCREMENT,
  `character_id` int NOT NULL COMMENT 'ID del personaje',
  `date` date NOT NULL COMMENT 'Fecha de disponibilidad',
  `start_time` time NOT NULL COMMENT 'Hora de inicio de disponibilidad',
  `end_time` time NOT NULL COMMENT 'Hora de fin de disponibilidad',
  `location_id` int NULL DEFAULT 1 COMMENT 'Indica si está disponible en ese horario',
  PRIMARY KEY (`availability_id`) USING BTREE,
  UNIQUE INDEX `unique_character_time`(`character_id` ASC, `date` ASC, `start_time` ASC, `end_time` ASC) USING BTREE,
  CONSTRAINT `character_availability_ibfk_1` FOREIGN KEY (`character_id`) REFERENCES `characters` (`character_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of character_availability
-- ----------------------------
INSERT INTO `character_availability` VALUES (1, 1, '2025-03-30', '09:00:00', '12:00:00', 1);
INSERT INTO `character_availability` VALUES (2, 1, '2025-03-30', '14:00:00', '17:00:00', 1);
INSERT INTO `character_availability` VALUES (3, 2, '2025-03-30', '09:00:00', '12:00:00', 1);
INSERT INTO `character_availability` VALUES (4, 2, '2025-03-30', '14:00:00', '17:00:00', 2);
INSERT INTO `character_availability` VALUES (5, 3, '2025-03-30', '09:00:00', '12:00:00', 2);
INSERT INTO `character_availability` VALUES (6, 3, '2025-03-30', '14:00:00', '17:00:00', 2);
INSERT INTO `character_availability` VALUES (7, 4, '2025-03-31', '09:00:00', '12:00:00', 1);
INSERT INTO `character_availability` VALUES (8, 4, '2025-03-31', '14:00:00', '17:00:00', 2);
INSERT INTO `character_availability` VALUES (9, 5, '2025-04-01', '10:00:00', '13:00:00', 1);
INSERT INTO `character_availability` VALUES (10, 5, '2025-04-01', '15:00:00', '18:00:00', 1);
INSERT INTO `character_availability` VALUES (11, 6, '2025-04-02', '09:00:00', '12:00:00', 1);
INSERT INTO `character_availability` VALUES (12, 7, '2025-04-03', '14:00:00', '17:00:00', 1);
INSERT INTO `character_availability` VALUES (13, 8, '2025-04-04', '10:00:00', '13:00:00', 1);
INSERT INTO `character_availability` VALUES (14, 9, '2025-04-05', '15:00:00', '18:00:00', 1);
INSERT INTO `character_availability` VALUES (15, 10, '2025-04-06', '09:00:00', '12:00:00', 1);
INSERT INTO `character_availability` VALUES (16, 11, '2025-04-07', '14:00:00', '17:00:00', 1);
INSERT INTO `character_availability` VALUES (17, 12, '2025-04-08', '10:00:00', '13:00:00', 1);
INSERT INTO `character_availability` VALUES (18, 13, '2025-03-30', '09:00:00', '12:00:00', 1);
INSERT INTO `character_availability` VALUES (19, 14, '2025-03-31', '14:00:00', '17:00:00', 1);
INSERT INTO `character_availability` VALUES (20, 15, '2025-04-01', '10:00:00', '13:00:00', 1);

-- ----------------------------
-- Table structure for character_names
-- ----------------------------
CREATE TABLE `character_names`  (
  `character_id` int NOT NULL COMMENT 'ID del personaje',
  `es_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'Nombre del personaje (ej. Elsa, Superman)',
  `thumbnail` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'URL de la imagen del personaje con este nombre',
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Indica si el personaje está habilitado o deshabilitado',
  `en_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`character_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of character_names
-- ----------------------------
INSERT INTO `character_names` VALUES (1, 'Blanca Nieves', NULL, 1, 'Snow White');
INSERT INTO `character_names` VALUES (2, 'Cenicienta', NULL, 1, 'Cinderella');
INSERT INTO `character_names` VALUES (3, 'Rapunzel', NULL, 1, 'Rapunzel');
INSERT INTO `character_names` VALUES (4, 'Bella', NULL, 1, 'Belle');
INSERT INTO `character_names` VALUES (5, 'Ana', NULL, 1, 'Anna');
INSERT INTO `character_names` VALUES (6, 'Elsa', NULL, 1, 'Elsa');
INSERT INTO `character_names` VALUES (7, 'Mirabel', NULL, 1, 'Mirabel');
INSERT INTO `character_names` VALUES (8, 'Isabella', NULL, 1, 'Isabela');
INSERT INTO `character_names` VALUES (9, 'Mamá Noel', NULL, 1, 'Mrs. Claus');
INSERT INTO `character_names` VALUES (10, 'Papá Noel', NULL, 1, 'Santa Claus');
INSERT INTO `character_names` VALUES (11, 'Elfos navideños', NULL, 1, 'Christmas Elves');
INSERT INTO `character_names` VALUES (12, 'Hombre Araña', NULL, 1, 'Spiderman');
INSERT INTO `character_names` VALUES (13, 'Capitán América', NULL, 1, 'Captain America');
INSERT INTO `character_names` VALUES (14, 'Bruno', NULL, 1, 'Bruno');
INSERT INTO `character_names` VALUES (15, 'Blippi', NULL, 1, 'Blippi');
INSERT INTO `character_names` VALUES (16, 'Mickey Mouse', NULL, 1, 'Mickey Mouse');
INSERT INTO `character_names` VALUES (17, 'Minnie', NULL, 1, 'Minnie Mouse');
INSERT INTO `character_names` VALUES (18, 'Sonic', NULL, 1, 'Sonic ');
INSERT INTO `character_names` VALUES (19, 'Vaca Lola', NULL, 1, 'Lola the Cow');
INSERT INTO `character_names` VALUES (20, 'Bestia', NULL, 1, 'Beast');

-- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters`  (
  `character_id` int NOT NULL AUTO_INCREMENT,
  `character_name_id` int NOT NULL COMMENT 'Descripción del personaje',
  `price` decimal(10, 2) NOT NULL COMMENT 'Precio del personaje',
  `duration_hours` int NOT NULL COMMENT 'Duración en horas del personaje',
  PRIMARY KEY (`character_id`) USING BTREE,
  INDEX `fk_characters_character_names_1`(`character_name_id` ASC) USING BTREE,
  CONSTRAINT `fk_characters_character_names_1` FOREIGN KEY (`character_name_id`) REFERENCES `character_names` (`character_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of characters
-- ----------------------------
INSERT INTO `characters` VALUES (1, 1, 250.00, 2);
INSERT INTO `characters` VALUES (2, 2, 250.00, 2);
INSERT INTO `characters` VALUES (3, 3, 250.00, 2);
INSERT INTO `characters` VALUES (4, 4, 250.00, 2);
INSERT INTO `characters` VALUES (5, 5, 280.00, 2);
INSERT INTO `characters` VALUES (6, 6, 280.00, 2);
INSERT INTO `characters` VALUES (7, 7, 280.00, 2);
INSERT INTO `characters` VALUES (8, 8, 280.00, 2);
INSERT INTO `characters` VALUES (9, 9, 300.00, 2);
INSERT INTO `characters` VALUES (10, 10, 300.00, 2);
INSERT INTO `characters` VALUES (11, 11, 300.00, 2);
INSERT INTO `characters` VALUES (12, 12, 300.00, 2);
INSERT INTO `characters` VALUES (13, 13, 320.00, 2);
INSERT INTO `characters` VALUES (14, 14, 320.00, 2);
INSERT INTO `characters` VALUES (15, 15, 320.00, 2);
INSERT INTO `characters` VALUES (16, 16, 320.00, 2);
INSERT INTO `characters` VALUES (17, 17, 350.00, 2);
INSERT INTO `characters` VALUES (18, 18, 350.00, 2);
INSERT INTO `characters` VALUES (19, 19, 350.00, 2);
INSERT INTO `characters` VALUES (20, 20, 350.00, 2);

-- ----------------------------
-- Table structure for customers
-- ----------------------------
CREATE TABLE `customers`  (
  `customer_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Nombre completo del cliente',
  `email` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Correo electrónico del cliente',
  `phone` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Número telefónico del cliente',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`customer_id`) USING BTREE,
  UNIQUE INDEX `unique_email`(`email` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of customers
-- ----------------------------
INSERT INTO `customers` VALUES (1, 'Juan Pérez', 'juan.perez@example.com', '+573001234567', '2025-03-19 16:51:24');
INSERT INTO `customers` VALUES (2, 'María López', 'maria.lopez@example.com', '+573009876543', '2025-03-21 16:51:24');
INSERT INTO `customers` VALUES (3, 'Carlos Rodríguez', 'carlos.rodriguez@example.com', '+573005551234', '2025-03-24 16:51:24');
INSERT INTO `customers` VALUES (4, 'Ana Martínez', 'ana.martinez@example.com', '+573007778899', '2025-03-26 16:51:24');
INSERT INTO `customers` VALUES (5, 'Pedro Gómez', 'pedro.gomez@example.com', '+573004445566', '2025-03-28 16:51:24');

-- ----------------------------
-- Table structure for events
-- ----------------------------
CREATE TABLE `events`  (
  `event_id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL COMMENT 'ID del cliente que realiza la reserva',
  `cart_id` int NOT NULL COMMENT 'ID del carrito que contiene los productos/paquetes/personajes seleccionados',
  `location_id` int NOT NULL COMMENT 'Ciudad donde se realizará el evento',
  `address` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Dirección exacta donde se realizará el evento',
  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Título descriptivo del evento',
  `description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL COMMENT 'Detalles adicionales o instrucciones especiales',
  `event_date` date NOT NULL COMMENT 'Fecha programada para el evento',
  `start_time` time NOT NULL COMMENT 'Hora de inicio del evento',
  `end_time` time NOT NULL COMMENT 'Hora de finalización del evento',
  `duration_hours` int NOT NULL COMMENT 'Duración del evento en horas',
  `total_price` decimal(10, 2) NOT NULL COMMENT 'Precio total estimado antes de pagar',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`event_id`) USING BTREE,
  INDEX `customer_id`(`customer_id` ASC) USING BTREE,
  INDEX `location_id`(`location_id` ASC) USING BTREE,
  INDEX `cart_id`(`cart_id` ASC) USING BTREE,
  CONSTRAINT `events_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`customer_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `events_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `locations` (`location_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `events_ibfk_3` FOREIGN KEY (`cart_id`) REFERENCES `shopping_cart` (`cart_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of events
-- ----------------------------
INSERT INTO `events` VALUES (1, 1, 1, 1, 'Calle 123 #45-67, Barrio Centro', 'Cumpleaños de Sofía', 'Fiesta de cumpleaños número 5 de Sofía', '2025-04-13', '14:00:00', '17:00:00', 3, 520000.00, '2025-03-24 17:03:44');
INSERT INTO `events` VALUES (2, 2, 2, 2, 'Carrera 78 #90-12, Urbanización Los Pinos', 'Cumpleaños de Valentina', 'Fiesta temática de princesas para Valentina', '2025-04-08', '15:00:00', '18:00:00', 3, 650000.00, '2025-03-26 17:03:44');
INSERT INTO `events` VALUES (3, 3, 3, 3, 'Avenida Principal #34-56, Conjunto Residencial El Bosque', 'Cumpleaños de Santiago', 'Fiesta de superhéroes para Santiago', '2025-04-18', '10:00:00', '13:00:00', 3, 830000.00, '2025-03-27 17:03:44');
INSERT INTO `events` VALUES (4, 1, 2, 3, 'Calle 123 #45-67', 'Cumpleaños Infantil', 'Evento con payasos y piñata', '2025-05-01', '14:00:00', '17:00:00', 3, 500.00, '2025-04-08 17:16:42');
INSERT INTO `events` VALUES (5, 1, 2, 3, 'Calle 123 #45-67', 'Bautizo', 'Decoración temática y refrigerios', '2025-05-01', '14:30:00', '17:30:00', 3, 650.00, '2025-04-08 17:16:42');
INSERT INTO `events` VALUES (6, 1, 3, 3, 'Calle 123 #45-67', 'Reunión Familiar', 'Parrillada y música en vivo', '2025-05-01', '15:00:00', '18:00:00', 3, 700.00, '2025-04-08 17:16:42');

-- ----------------------------
-- Table structure for location_travel_time
-- ----------------------------
CREATE TABLE `location_travel_time`  (
  `travel_time_id` int NOT NULL AUTO_INCREMENT,
  `origin_id` int NOT NULL COMMENT 'ID de la ciudad de origen',
  `destination_id` int NOT NULL COMMENT 'ID de la ciudad de destino',
  `travel_time` int NOT NULL COMMENT 'Tiempo de viaje en minutos entre las dos ciudades',
  PRIMARY KEY (`travel_time_id`) USING BTREE,
  UNIQUE INDEX `unique_route`(`origin_id` ASC, `destination_id` ASC) USING BTREE,
  INDEX `destination_id`(`destination_id` ASC) USING BTREE,
  CONSTRAINT `location_travel_time_ibfk_1` FOREIGN KEY (`origin_id`) REFERENCES `locations` (`location_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `location_travel_time_ibfk_2` FOREIGN KEY (`destination_id`) REFERENCES `locations` (`location_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 183 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for locations
-- ----------------------------
CREATE TABLE `locations`  (
  `location_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Nombre de la ciudad',
  PRIMARY KEY (`location_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of locations
-- ----------------------------
INSERT INTO `locations` VALUES (1, 'Greenville');
INSERT INTO `locations` VALUES (2, 'Greer');
INSERT INTO `locations` VALUES (3, 'Taylors');
INSERT INTO `locations` VALUES (4, 'Lyman');
INSERT INTO `locations` VALUES (5, 'Duncan');
INSERT INTO `locations` VALUES (6, 'Spartanburg');
INSERT INTO `locations` VALUES (7, 'Charlotte');
INSERT INTO `locations` VALUES (8, 'Asheville');
INSERT INTO `locations` VALUES (9, 'Columbia');
INSERT INTO `locations` VALUES (10, 'Atlanta');
INSERT INTO `locations` VALUES (11, 'Anderson');
INSERT INTO `locations` VALUES (12, 'Easley');
INSERT INTO `locations` VALUES (13, 'Piedmont');
INSERT INTO `locations` VALUES (14, 'Simsonvilleión');

-- ----------------------------
-- Table structure for package_character_options
-- ----------------------------
CREATE TABLE `package_character_options`  (
  `package_id` int NOT NULL COMMENT 'ID del paquete',
  `character_id` int NOT NULL COMMENT 'ID del personaje disponible para este paquete',
  PRIMARY KEY (`package_id`, `character_id`) USING BTREE,
  INDEX `character_id`(`character_id` ASC) USING BTREE,
  CONSTRAINT `package_character_options_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `package_character_options_ibfk_2` FOREIGN KEY (`character_id`) REFERENCES `characters` (`character_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of package_character_options
-- ----------------------------
INSERT INTO `package_character_options` VALUES (1, 1);
INSERT INTO `package_character_options` VALUES (1, 2);
INSERT INTO `package_character_options` VALUES (1, 3);
INSERT INTO `package_character_options` VALUES (1, 4);
INSERT INTO `package_character_options` VALUES (1, 5);
INSERT INTO `package_character_options` VALUES (2, 1);
INSERT INTO `package_character_options` VALUES (2, 2);
INSERT INTO `package_character_options` VALUES (2, 3);
INSERT INTO `package_character_options` VALUES (2, 4);
INSERT INTO `package_character_options` VALUES (2, 5);
INSERT INTO `package_character_options` VALUES (2, 6);
INSERT INTO `package_character_options` VALUES (2, 7);
INSERT INTO `package_character_options` VALUES (2, 8);
INSERT INTO `package_character_options` VALUES (2, 9);
INSERT INTO `package_character_options` VALUES (2, 10);
INSERT INTO `package_character_options` VALUES (5, 1);
INSERT INTO `package_character_options` VALUES (5, 2);
INSERT INTO `package_character_options` VALUES (5, 3);
INSERT INTO `package_character_options` VALUES (5, 4);
INSERT INTO `package_character_options` VALUES (5, 5);
INSERT INTO `package_character_options` VALUES (5, 6);
INSERT INTO `package_character_options` VALUES (5, 7);
INSERT INTO `package_character_options` VALUES (5, 8);
INSERT INTO `package_character_options` VALUES (5, 9);
INSERT INTO `package_character_options` VALUES (5, 10);
INSERT INTO `package_character_options` VALUES (5, 11);
INSERT INTO `package_character_options` VALUES (5, 12);
INSERT INTO `package_character_options` VALUES (5, 13);
INSERT INTO `package_character_options` VALUES (5, 14);
INSERT INTO `package_character_options` VALUES (5, 15);
INSERT INTO `package_character_options` VALUES (5, 16);
INSERT INTO `package_character_options` VALUES (5, 17);
INSERT INTO `package_character_options` VALUES (5, 18);
INSERT INTO `package_character_options` VALUES (5, 19);
INSERT INTO `package_character_options` VALUES (5, 20);

-- ----------------------------
-- Table structure for package_products
-- ----------------------------
CREATE TABLE `package_products`  (
  `package_id` int NOT NULL COMMENT 'ID del paquete',
  `product_id` int NOT NULL COMMENT 'ID del producto',
  `quantity` int NULL DEFAULT 1 COMMENT 'Cantidad del producto dentro del paquete',
  PRIMARY KEY (`package_id`, `product_id`) USING BTREE,
  INDEX `product_id`(`product_id` ASC) USING BTREE,
  CONSTRAINT `package_products_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `package_products_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`product_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of package_products
-- ----------------------------
INSERT INTO `package_products` VALUES (1, 1, 1);
INSERT INTO `package_products` VALUES (1, 5, 1);
INSERT INTO `package_products` VALUES (1, 7, 1);
INSERT INTO `package_products` VALUES (2, 2, 1);
INSERT INTO `package_products` VALUES (2, 3, 1);
INSERT INTO `package_products` VALUES (2, 4, 1);
INSERT INTO `package_products` VALUES (2, 5, 1);
INSERT INTO `package_products` VALUES (2, 7, 1);
INSERT INTO `package_products` VALUES (3, 1, 1);
INSERT INTO `package_products` VALUES (3, 3, 1);
INSERT INTO `package_products` VALUES (3, 5, 1);
INSERT INTO `package_products` VALUES (4, 1, 1);
INSERT INTO `package_products` VALUES (4, 3, 1);
INSERT INTO `package_products` VALUES (4, 5, 1);
INSERT INTO `package_products` VALUES (5, 2, 1);
INSERT INTO `package_products` VALUES (5, 3, 1);
INSERT INTO `package_products` VALUES (5, 4, 1);
INSERT INTO `package_products` VALUES (5, 6, 1);

-- ----------------------------
-- Table structure for packages
-- ----------------------------
CREATE TABLE `packages`  (
  `package_id` int NOT NULL AUTO_INCREMENT,
  `es_package_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Nombre del paquete',
  `total_price` decimal(10, 2) NOT NULL COMMENT 'Precio total del paquete',
  `duration_hours` int NOT NULL COMMENT 'Duración del paquete en horas',
  `description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL COMMENT 'Descripción del paquete',
  `image_url` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL COMMENT 'URL de la imagen del paquete',
  `character_id` int NULL DEFAULT NULL COMMENT 'ID del personaje predeterminado del paquete, puede ser NULL si no tiene personaje',
  `allows_character_selection` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Indica si el cliente puede seleccionar un personaje después de elegir el paquete',
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Indica si el paquete está habilitado o deshabilitado',
  PRIMARY KEY (`package_id`) USING BTREE,
  INDEX `character_id`(`character_id` ASC) USING BTREE,
  CONSTRAINT `packages_ibfk_1` FOREIGN KEY (`character_id`) REFERENCES `characters` (`character_id`) ON DELETE SET NULL ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of packages
-- ----------------------------
INSERT INTO `packages` VALUES (1, 'Básico', 450.00, 3, 'Paquete básico que incluye decoración y animación', 'data:image/jpeg;base64,[BLOB]', NULL, 1, 1);
INSERT INTO `packages` VALUES (2, 'Premium', 750.00, 4, 'Paquete premium con decoración, animación, torta y fotografía', 'data:image/jpeg;base64,[BLOB]', NULL, 1, 1);
INSERT INTO `packages` VALUES (3, 'Princesa', 650.00, 3, 'Paquete temático de princesa con personaje incluido', 'data:image/jpeg;base64,[BLOB]', 1, 0, 1);
INSERT INTO `packages` VALUES (4, 'Superhéroe', 650.00, 3, 'Paquete temático de superhéroe con personaje incluido', 'data:image/jpeg;base64,[BLOB]', 3, 0, 1);
INSERT INTO `packages` VALUES (5, 'Deluxe', 950.00, 5, 'Paquete completo con todos los servicios premium', 'data:image/jpeg;base64,[BLOB]', NULL, 1, 1);

-- ----------------------------
-- Table structure for payments
-- ----------------------------
CREATE TABLE `payments`  (
  `payment_id` int NOT NULL AUTO_INCREMENT,
  `event_id` int NOT NULL COMMENT 'Evento asociado al pago',
  `amount` decimal(10, 2) NOT NULL COMMENT 'Monto total pagado por el evento',
  `payment_method` enum('stripe','paypal','transfer','cash') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Método de pago utilizado',
  `transaction_id` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'Identificador único de la transacción (para pagos electrónicos)',
  `status` enum('pending','completed','failed','refunded') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'pending' COMMENT 'Estado del pago',
  `payment_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `customer_id` int NOT NULL COMMENT 'ID del cliente que realizó el pago',
  `notes` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL COMMENT 'Notas adicionales sobre el pago',
  PRIMARY KEY (`payment_id`) USING BTREE,
  INDEX `event_id`(`event_id` ASC) USING BTREE,
  INDEX `customer_id`(`customer_id` ASC) USING BTREE,
  CONSTRAINT `payments_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`event_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `payments_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`customer_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of payments
-- ----------------------------
INSERT INTO `payments` VALUES (1, 1, 520000.00, 'transfer', 'TRANS123456', 'completed', '2025-03-25 17:03:44', 1, 'Pago completo por transferencia bancaria');
INSERT INTO `payments` VALUES (2, 2, 325000.00, 'paypal', 'PAY987654321', 'completed', '2025-03-27 17:03:44', 2, 'Pago del 50% por adelantado');
INSERT INTO `payments` VALUES (3, 2, 325000.00, 'paypal', 'PAY987654322', 'pending', '2025-04-03 17:03:44', 2, 'Pago del 50% restante pendiente');
INSERT INTO `payments` VALUES (4, 3, 830000.00, 'cash', NULL, 'pending', '2025-04-13 17:03:44', 3, 'Pago en efectivo el día del evento');

-- ----------------------------
-- Table structure for product_types
-- ----------------------------
CREATE TABLE `product_types`  (
  `type_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Nombre del tipo de producto (Evento, Producto físico, etc.)',
  `description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL COMMENT 'Descripción del tipo de producto',
  PRIMARY KEY (`type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of product_types
-- ----------------------------
INSERT INTO `product_types` VALUES (1, 'Evento', 'Servicios de animación y entretenimiento');
INSERT INTO `product_types` VALUES (2, 'Producto Físico', 'Artículos tangibles como decoraciones');
INSERT INTO `product_types` VALUES (3, 'Servicio', 'Servicios adicionales como fotografía');

-- ----------------------------
-- Table structure for products
-- ----------------------------
CREATE TABLE `products`  (
  `product_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Nombre del producto',
  `description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL COMMENT 'Descripción del producto',
  `price` decimal(10, 2) NOT NULL COMMENT 'Precio del producto',
  `duration_hours` int NULL DEFAULT 0 COMMENT 'Duración en horas si aplica',
  `type_id` int NULL DEFAULT NULL COMMENT 'Tipo de producto',
  `image_url` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL COMMENT 'URL de la imagen del producto',
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Indica si el producto está habilitado o deshabilitado',
  PRIMARY KEY (`product_id`) USING BTREE,
  INDEX `type_id`(`type_id` ASC) USING BTREE,
  CONSTRAINT `products_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `product_types` (`type_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of products
-- ----------------------------
INSERT INTO `products` VALUES (1, 'Personaje adicional', 'Servicio de animación básica sin personajes', 150.00, 0, 2, 'data:image/jpeg;base64,[BLOB]', 1);
INSERT INTO `products` VALUES (2, 'Decoración Premium', 'Decoración temática premium con elementos personalizados', 250.00, 0, 2, 'data:image/jpeg;base64,[BLOB]', 1);
INSERT INTO `products` VALUES (3, 'Torta Temática', 'Torta personalizada según el tema del evento', 120.00, 0, 2, 'data:image/jpeg;base64,[BLOB]', 1);
INSERT INTO `products` VALUES (4, 'Fotografía Profesional', 'Servicio de fotografía durante el evento', 18.00, 2, 3, 'data:image/jpeg;base64,[BLOB]', 1);
INSERT INTO `products` VALUES (5, 'Piñata Personalizada', 'Piñata temática personalizada', 80.00, 0, 2, 'data:image/jpeg;base64,[BLOB]', 1);
INSERT INTO `products` VALUES (6, 'Máquina de Burbujas', 'Máquina de burbujas para ambientación', 60.00, 2, 2, 'data:image/jpeg;base64,[BLOB]', 1);
INSERT INTO `products` VALUES (7, 'Pintucarita', 'Pintura de cara', 250.00, 2, 1, 'data:image/jpeg;base64,[BLOB]', 1);

-- ----------------------------
-- Table structure for shopping_cart
-- ----------------------------
CREATE TABLE `shopping_cart`  (
  `cart_id` int NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Fecha de creación del carrito',
  PRIMARY KEY (`cart_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of shopping_cart
-- ----------------------------
INSERT INTO `shopping_cart` VALUES (1, '2025-03-24 17:00:34');
INSERT INTO `shopping_cart` VALUES (2, '2025-03-26 17:00:34');
INSERT INTO `shopping_cart` VALUES (3, '2025-03-28 17:00:34');
INSERT INTO `shopping_cart` VALUES (4, '2025-03-29 17:00:34');

