Error en el script 2
hola Andrés, me parece que hay un error en el script del módulo 2 del repositorio de Github porque crea una tabla Itinerary con atributos que no corresponden a la entidad Itinerary
hola Andrés, me parece que hay un error en el script del módulo 2 del repositorio de Github porque crea una tabla Itinerary con atributos que no corresponden a la entidad Itinerary
hola Andrés, me parece que hay un error en el script del módulo 2 del repositorio de Github porque crea una tabla Itinerary con atributos que no corresponden a la entidad Itinerary
hola Andrés, me parece que hay un error en el script del módulo 2 del repositorio de Github porque crea una tabla Itinerary con atributos que no corresponden a la entidad Itinerary
Hola Adrian, lo dices porque la tabla Itinerary tiene un atributo itinerary_id que no existe en la entidad? Si ese es el caso ese atributo se usa para hacer el join de manera transparente contra la tabla de Price. Podrias cambiar el nombre por otro valor y hacer lo mismo en el mapping.
Si no es el caso que menciono por favor me das mas detalle al respecto.
Hola Andres, a mi el error que me dio fue el que esta abajo, yo lo resolví modificando el orden en que se ejecutan las query, ya que hay dependencias entre ellas. Dejo la solución abajo. Yo utilice Azure Data Studio en un Mac con chip M1
El orden que cambie fue este: price itinerary reservation passenger segment
________ ( ERROR ) ________
4:00:17 PMStarted executing query at Line 18 Commands completed successfully 4:00:17 PMStarted executing query at Line 25 Total execution time: 00:00:00.005 1824 (HY000): Failed to open the referenced table 'price'
____________ (SOLUCION) __________
-- Host: 127.0.0.1 Database: flights_reservation
-- Server version 8.0.33
/*!40101 SET @OLD_CHARACTER_SET_CLIENT= @@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS= @@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION= @@@COLLATION_CONNECTION /; /!50503 SET NAMES utf8 /; /!40103 SET @OLD_TIME_ZONE= @@@TIME_ZONE /; /!40103 SET TIME_ZONE='+00:00' /; /!40014 SET @OLD_UNIQUE_CHECKS= @@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /; /!40014 SET @OLD_FOREIGN_KEY_CHECKS= @@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /; /!40101 SET @OLD_SQL_MODE= @@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /; /!40111 SET @OLD_SQL_NOTES= @@@SQL_NOTES, SQL_NOTES=0 */;
priceDROP TABLE IF EXISTS price;
/*!40101 SET @saved_cs_client = [@ [@ [@ [@ @@@character_set_client](https://ed.team/u/@@character_set_client)](https://ed.team/u/@@character_set_client)](https://ed.team/u/@@character_set_client)](https://ed.team/u/@@character_set_client) /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE price (
base_price decimal(38,2) NOT NULL,
total_price decimal(38,2) NOT NULL,
total_tax decimal(38,2) NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
priceLOCK TABLES price WRITE;
/*!40000 ALTER TABLE price DISABLE KEYS /;
/!40000 ALTER TABLE price ENABLE KEYS */;
UNLOCK TABLES;
itineraryDROP TABLE IF EXISTS itinerary;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE itinerary (
id bigint AUTO_INCREMENT PRIMARY KEY,
itinerary_id bigint DEFAULT NULL,
UNIQUE KEY UK_nuabwliqt5wnaafbfe1mjqdtu (itinerary_id),
CONSTRAINT FKfuq1y9btsw9if6vuyrnngvw0j FOREIGN KEY (itinerary_id) REFERENCES price (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
itineraryLOCK TABLES itinerary WRITE;
/*!40000 ALTER TABLE itinerary DISABLE KEYS /;
/!40000 ALTER TABLE itinerary ENABLE KEYS */;
UNLOCK TABLES;
reservationDROP TABLE IF EXISTS reservation;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE reservation (
creation_date date NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY,
itinerary_id bigint DEFAULT NULL,
KEY FKmm7xy4cybogy2irexcsttlvi2 (itinerary_id),
CONSTRAINT FKmm7xy4cybogy2irexcsttlvi2 FOREIGN KEY (itinerary_id) REFERENCES itinerary (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
reservationLOCK TABLES reservation WRITE;
/*!40000 ALTER TABLE reservation DISABLE KEYS /;
/!40000 ALTER TABLE reservation ENABLE KEYS */;
UNLOCK TABLES;
passengerDROP TABLE IF EXISTS passenger;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE passenger (
birthday date NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY,
reservation_id bigint DEFAULT NULL,
first_name varchar(30) NOT NULL,
last_name varchar(30) NOT NULL,
document_number varchar(255) NOT NULL,
document_type varchar(255) NOT NULL,
KEY FKp4qdewtk73iwqerswqtqs0g1q (reservation_id),
CONSTRAINT FKp4qdewtk73iwqerswqtqs0g1q FOREIGN KEY (reservation_id) REFERENCES reservation (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
passengerLOCK TABLES passenger WRITE;
/*!40000 ALTER TABLE passenger DISABLE KEYS /;
/!40000 ALTER TABLE passenger ENABLE KEYS */;
UNLOCK TABLES;
segmentDROP TABLE IF EXISTS segment;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE segment (
carrier varchar(3) NOT NULL,
destination varchar(3) NOT NULL,
origin varchar(3) NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY,
itinerary_id bigint DEFAULT NULL,
arrival varchar(255) NOT NULL,
departure varchar(255) NOT NULL,
KEY FK8l81wkolgwmpxhicuc9o6u141 (itinerary_id),
CONSTRAINT FK8l81wkolgwmpxhicuc9o6u141 FOREIGN KEY (itinerary_id) REFERENCES itinerary (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
segmentLOCK TABLES segment WRITE;
/*!40000 ALTER TABLE segment DISABLE KEYS /;
/!40000 ALTER TABLE segment ENABLE KEYS /;
UNLOCK TABLES;
/!40103 SET TIME_ZONE @=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE @=@OLD_SQL_MODE /; /!40014 SET FOREIGN_KEY_CHECKS @=@OLD_FOREIGN_KEY_CHECKS /; /!40014 SET UNIQUE_CHECKS @=@OLD_UNIQUE_CHECKS /; /!40101 SET CHARACTER_SET_CLIENT @=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS @=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION @=@OLD_COLLATION_CONNECTION /; /!40111 SET SQL_NOTES @=@OLD_SQL_NOTES */;
-- Dump completed on 2023-11-07 13:20:57
Hola Adrian, lo dices porque la tabla Itinerary tiene un atributo itinerary_id que no existe en la entidad? Si ese es el caso ese atributo se usa para hacer el join de manera transparente contra la tabla de Price. Podrias cambiar el nombre por otro valor y hacer lo mismo en el mapping.
Si no es el caso que menciono por favor me das mas detalle al respecto.
Hola Andres, a mi el error que me dio fue el que esta abajo, yo lo resolví modificando el orden en que se ejecutan las query, ya que hay dependencias entre ellas. Dejo la solución abajo. Yo utilice Azure Data Studio en un Mac con chip M1
El orden que cambie fue este: price itinerary reservation passenger segment
________ ( ERROR ) ________
4:00:17 PMStarted executing query at Line 18 Commands completed successfully 4:00:17 PMStarted executing query at Line 25 Total execution time: 00:00:00.005 1824 (HY000): Failed to open the referenced table 'price'
____________ (SOLUCION) __________
-- Host: 127.0.0.1 Database: flights_reservation
-- Server version 8.0.33
/*!40101 SET @OLD_CHARACTER_SET_CLIENT= @@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS= @@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION= @@@COLLATION_CONNECTION /; /!50503 SET NAMES utf8 /; /!40103 SET @OLD_TIME_ZONE= @@@TIME_ZONE /; /!40103 SET TIME_ZONE='+00:00' /; /!40014 SET @OLD_UNIQUE_CHECKS= @@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /; /!40014 SET @OLD_FOREIGN_KEY_CHECKS= @@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /; /!40101 SET @OLD_SQL_MODE= @@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /; /!40111 SET @OLD_SQL_NOTES= @@@SQL_NOTES, SQL_NOTES=0 */;
priceDROP TABLE IF EXISTS price;
/*!40101 SET @saved_cs_client = [@ [@ [@ [@ @@@character_set_client](https://ed.team/u/@@character_set_client)](https://ed.team/u/@@character_set_client)](https://ed.team/u/@@character_set_client)](https://ed.team/u/@@character_set_client) /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE price (
base_price decimal(38,2) NOT NULL,
total_price decimal(38,2) NOT NULL,
total_tax decimal(38,2) NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
priceLOCK TABLES price WRITE;
/*!40000 ALTER TABLE price DISABLE KEYS /;
/!40000 ALTER TABLE price ENABLE KEYS */;
UNLOCK TABLES;
itineraryDROP TABLE IF EXISTS itinerary;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE itinerary (
id bigint AUTO_INCREMENT PRIMARY KEY,
itinerary_id bigint DEFAULT NULL,
UNIQUE KEY UK_nuabwliqt5wnaafbfe1mjqdtu (itinerary_id),
CONSTRAINT FKfuq1y9btsw9if6vuyrnngvw0j FOREIGN KEY (itinerary_id) REFERENCES price (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
itineraryLOCK TABLES itinerary WRITE;
/*!40000 ALTER TABLE itinerary DISABLE KEYS /;
/!40000 ALTER TABLE itinerary ENABLE KEYS */;
UNLOCK TABLES;
reservationDROP TABLE IF EXISTS reservation;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE reservation (
creation_date date NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY,
itinerary_id bigint DEFAULT NULL,
KEY FKmm7xy4cybogy2irexcsttlvi2 (itinerary_id),
CONSTRAINT FKmm7xy4cybogy2irexcsttlvi2 FOREIGN KEY (itinerary_id) REFERENCES itinerary (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
reservationLOCK TABLES reservation WRITE;
/*!40000 ALTER TABLE reservation DISABLE KEYS /;
/!40000 ALTER TABLE reservation ENABLE KEYS */;
UNLOCK TABLES;
passengerDROP TABLE IF EXISTS passenger;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE passenger (
birthday date NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY,
reservation_id bigint DEFAULT NULL,
first_name varchar(30) NOT NULL,
last_name varchar(30) NOT NULL,
document_number varchar(255) NOT NULL,
document_type varchar(255) NOT NULL,
KEY FKp4qdewtk73iwqerswqtqs0g1q (reservation_id),
CONSTRAINT FKp4qdewtk73iwqerswqtqs0g1q FOREIGN KEY (reservation_id) REFERENCES reservation (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
passengerLOCK TABLES passenger WRITE;
/*!40000 ALTER TABLE passenger DISABLE KEYS /;
/!40000 ALTER TABLE passenger ENABLE KEYS */;
UNLOCK TABLES;
segmentDROP TABLE IF EXISTS segment;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE segment (
carrier varchar(3) NOT NULL,
destination varchar(3) NOT NULL,
origin varchar(3) NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY,
itinerary_id bigint DEFAULT NULL,
arrival varchar(255) NOT NULL,
departure varchar(255) NOT NULL,
KEY FK8l81wkolgwmpxhicuc9o6u141 (itinerary_id),
CONSTRAINT FK8l81wkolgwmpxhicuc9o6u141 FOREIGN KEY (itinerary_id) REFERENCES itinerary (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
segmentLOCK TABLES segment WRITE;
/*!40000 ALTER TABLE segment DISABLE KEYS /;
/!40000 ALTER TABLE segment ENABLE KEYS /;
UNLOCK TABLES;
/!40103 SET TIME_ZONE @=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE @=@OLD_SQL_MODE /; /!40014 SET FOREIGN_KEY_CHECKS @=@OLD_FOREIGN_KEY_CHECKS /; /!40014 SET UNIQUE_CHECKS @=@OLD_UNIQUE_CHECKS /; /!40101 SET CHARACTER_SET_CLIENT @=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS @=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION @=@OLD_COLLATION_CONNECTION /; /!40111 SET SQL_NOTES @=@OLD_SQL_NOTES */;
-- Dump completed on 2023-11-07 13:20:57
Hola Adrian, lo dices porque la tabla Itinerary tiene un atributo itinerary_id que no existe en la entidad? Si ese es el caso ese atributo se usa para hacer el join de manera transparente contra la tabla de Price. Podrias cambiar el nombre por otro valor y hacer lo mismo en el mapping.
Si no es el caso que menciono por favor me das mas detalle al respecto.
Hola Andres, a mi el error que me dio fue el que esta abajo, yo lo resolví modificando el orden en que se ejecutan las query, ya que hay dependencias entre ellas. Dejo la solución abajo. Yo utilice Azure Data Studio en un Mac con chip M1
El orden que cambie fue este: price itinerary reservation passenger segment
________ ( ERROR ) ________
4:00:17 PMStarted executing query at Line 18 Commands completed successfully 4:00:17 PMStarted executing query at Line 25 Total execution time: 00:00:00.005 1824 (HY000): Failed to open the referenced table 'price'
____________ (SOLUCION) __________
-- Host: 127.0.0.1 Database: flights_reservation
-- Server version 8.0.33
/*!40101 SET @OLD_CHARACTER_SET_CLIENT= @@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS= @@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION= @@@COLLATION_CONNECTION /; /!50503 SET NAMES utf8 /; /!40103 SET @OLD_TIME_ZONE= @@@TIME_ZONE /; /!40103 SET TIME_ZONE='+00:00' /; /!40014 SET @OLD_UNIQUE_CHECKS= @@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /; /!40014 SET @OLD_FOREIGN_KEY_CHECKS= @@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /; /!40101 SET @OLD_SQL_MODE= @@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /; /!40111 SET @OLD_SQL_NOTES= @@@SQL_NOTES, SQL_NOTES=0 */;
priceDROP TABLE IF EXISTS price;
/*!40101 SET @saved_cs_client = [@ [@ [@ [@ @@@character_set_client](https://ed.team/u/@@character_set_client)](https://ed.team/u/@@character_set_client)](https://ed.team/u/@@character_set_client)](https://ed.team/u/@@character_set_client) /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE price (
base_price decimal(38,2) NOT NULL,
total_price decimal(38,2) NOT NULL,
total_tax decimal(38,2) NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
priceLOCK TABLES price WRITE;
/*!40000 ALTER TABLE price DISABLE KEYS /;
/!40000 ALTER TABLE price ENABLE KEYS */;
UNLOCK TABLES;
itineraryDROP TABLE IF EXISTS itinerary;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE itinerary (
id bigint AUTO_INCREMENT PRIMARY KEY,
itinerary_id bigint DEFAULT NULL,
UNIQUE KEY UK_nuabwliqt5wnaafbfe1mjqdtu (itinerary_id),
CONSTRAINT FKfuq1y9btsw9if6vuyrnngvw0j FOREIGN KEY (itinerary_id) REFERENCES price (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
itineraryLOCK TABLES itinerary WRITE;
/*!40000 ALTER TABLE itinerary DISABLE KEYS /;
/!40000 ALTER TABLE itinerary ENABLE KEYS */;
UNLOCK TABLES;
reservationDROP TABLE IF EXISTS reservation;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE reservation (
creation_date date NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY,
itinerary_id bigint DEFAULT NULL,
KEY FKmm7xy4cybogy2irexcsttlvi2 (itinerary_id),
CONSTRAINT FKmm7xy4cybogy2irexcsttlvi2 FOREIGN KEY (itinerary_id) REFERENCES itinerary (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
reservationLOCK TABLES reservation WRITE;
/*!40000 ALTER TABLE reservation DISABLE KEYS /;
/!40000 ALTER TABLE reservation ENABLE KEYS */;
UNLOCK TABLES;
passengerDROP TABLE IF EXISTS passenger;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE passenger (
birthday date NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY,
reservation_id bigint DEFAULT NULL,
first_name varchar(30) NOT NULL,
last_name varchar(30) NOT NULL,
document_number varchar(255) NOT NULL,
document_type varchar(255) NOT NULL,
KEY FKp4qdewtk73iwqerswqtqs0g1q (reservation_id),
CONSTRAINT FKp4qdewtk73iwqerswqtqs0g1q FOREIGN KEY (reservation_id) REFERENCES reservation (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
passengerLOCK TABLES passenger WRITE;
/*!40000 ALTER TABLE passenger DISABLE KEYS /;
/!40000 ALTER TABLE passenger ENABLE KEYS */;
UNLOCK TABLES;
segmentDROP TABLE IF EXISTS segment;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE segment (
carrier varchar(3) NOT NULL,
destination varchar(3) NOT NULL,
origin varchar(3) NOT NULL,
id bigint AUTO_INCREMENT PRIMARY KEY,
itinerary_id bigint DEFAULT NULL,
arrival varchar(255) NOT NULL,
departure varchar(255) NOT NULL,
KEY FK8l81wkolgwmpxhicuc9o6u141 (itinerary_id),
CONSTRAINT FK8l81wkolgwmpxhicuc9o6u141 FOREIGN KEY (itinerary_id) REFERENCES itinerary (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;
segmentLOCK TABLES segment WRITE;
/*!40000 ALTER TABLE segment DISABLE KEYS /;
/!40000 ALTER TABLE segment ENABLE KEYS /;
UNLOCK TABLES;
/!40103 SET TIME_ZONE @=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE @=@OLD_SQL_MODE /; /!40014 SET FOREIGN_KEY_CHECKS @=@OLD_FOREIGN_KEY_CHECKS /; /!40014 SET UNIQUE_CHECKS @=@OLD_UNIQUE_CHECKS /; /!40101 SET CHARACTER_SET_CLIENT @=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS @=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION @=@OLD_COLLATION_CONNECTION /; /!40111 SET SQL_NOTES @=@OLD_SQL_NOTES */;
-- Dump completed on 2023-11-07 13:20:57