--
-- Host: localhost    Database: usacli
-- ------------------------------------------------------


--
-- Table structure for table `booking`
--

CREATE TABLE `booking` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slot` datetime NOT NULL,
  `user_booking_id` int DEFAULT NULL,
  `slot_end` datetime NOT NULL,
  `location_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E00CEDDEA457DA8C` (`user_booking_id`),
  KEY `IDX_E00CEDDE64D218E` (`location_id`),
  CONSTRAINT `FK_E00CEDDE64D218E` FOREIGN KEY (`location_id`) REFERENCES `location` (`id`),
  CONSTRAINT `FK_E00CEDDEA457DA8C` FOREIGN KEY (`user_booking_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `booking`
--

INSERT INTO `booking` VALUES (3,'2025-12-24 15:30:00',3,'2025-12-24 16:30:00',1),(4,'2025-12-24 16:30:00',1,'2025-12-24 17:30:00',1),(5,'2025-12-25 16:00:00',3,'2025-12-25 17:00:00',1),(6,'2025-12-26 11:00:00',3,'2025-12-26 12:00:00',1),(7,'2025-12-22 11:00:00',3,'2025-12-22 12:00:00',1);

--
-- Table structure for table `closure_days`
--

CREATE TABLE `closure_days` (
  `id` int NOT NULL AUTO_INCREMENT,
  `start` datetime NOT NULL,
  `end` datetime NOT NULL,
  `title` varchar(255) NOT NULL,
  `location_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_208867FA64D218E` (`location_id`),
  CONSTRAINT `FK_208867FA64D218E` FOREIGN KEY (`location_id`) REFERENCES `location` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `closure_days`
--


--
-- Table structure for table `doctrine_migration_versions`
--

CREATE TABLE `doctrine_migration_versions` (
  `version` varchar(191) NOT NULL,
  `executed_at` datetime DEFAULT NULL,
  `execution_time` int DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `doctrine_migration_versions`
--

INSERT INTO `doctrine_migration_versions` VALUES ('DoctrineMigrations\\Version20251218154711','2025-12-18 15:47:17',32),('DoctrineMigrations\\Version20251219154549','2025-12-19 15:46:21',22),('DoctrineMigrations\\Version20251219160106','2025-12-19 16:01:14',203),('DoctrineMigrations\\Version20251219170556','2025-12-19 17:06:03',281),('DoctrineMigrations\\Version20251219170945','2025-12-19 17:09:50',90),('DoctrineMigrations\\Version20251219171126','2025-12-19 17:11:30',182),('DoctrineMigrations\\Version20251223202522','2025-12-23 20:25:29',91);

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `open_day` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `location`
--

INSERT INTO `location` VALUES (1,'Campo Calcetto','[{\"day\": 1, \"time\": \"12-21\"}, {\"day\": 2, \"time\": \"12-21\"}, {\"day\": 3, \"time\": \"12-21\"}, {\"day\": 4, \"time\": \"12-21\"}, {\"day\": 5, \"time\": \"12-21\"}, {\"day\": 6, \"time\": \"12-21\"}]'),(2,'Palestra Due','[{\"day\": 1, \"time\": \"10-18\"}]');


