--
-- Host: localhost    Database: statigenerali
-- ------------------------------------------------------


--
-- Table structure for table `base_data`
--

CREATE TABLE `base_data` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_date` date NOT NULL,
  `event_place` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hidden` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `base_data`
--

INSERT INTO `base_data` VALUES (16,'SGRE 2025 – Stati Generali del Rinnovamento Energetico','Seconda edizione degli Stati Generali del Rinnovamento Energetico, l’evento che riunisce tecnici, amministratori, imprese e organizzazioni per affrontare in modo operativo le sfide della transizione energetica nel patrimonio edilizio esistente.\n','2025-11-13','Base Milano','Offline',1);

--
-- Table structure for table `base_data_user`
--

CREATE TABLE `base_data_user` (
  `base_data_id` int NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`base_data_id`,`user_id`),
  KEY `IDX_85F08C263F31858` (`base_data_id`),
  KEY `IDX_85F08C26A76ED395` (`user_id`),
  CONSTRAINT `FK_85F08C263F31858` FOREIGN KEY (`base_data_id`) REFERENCES `base_data` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_85F08C26A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `base_data_user`
--

INSERT INTO `base_data_user` VALUES (16,49),(16,50),(16,52),(16,53),(16,54),(16,55),(16,56),(16,58),(16,60),(16,61),(16,62),(16,63),(16,64),(16,65),(16,67),(16,68),(16,69),(16,71),(16,72),(16,73),(16,74),(16,76),(16,78),(16,79),(16,80),(16,81),(16,82),(16,84),(16,85),(16,86),(16,87),(16,88),(16,89),(16,90),(16,91),(16,92),(16,93),(16,94),(16,96),(16,97),(16,99),(16,100),(16,101),(16,102),(16,104),(16,106),(16,109),(16,110),(16,111),(16,112),(16,113),(16,114),(16,115),(16,117),(16,118),(16,119),(16,120),(16,121),(16,123),(16,125),(16,126),(16,129),(16,130),(16,132),(16,133),(16,134),(16,135),(16,137),(16,139),(16,140),(16,141),(16,143),(16,144),(16,145),(16,146),(16,147),(16,148),(16,149),(16,150),(16,151),(16,153),(16,159),(16,160),(16,161),(16,162),(16,163),(16,164),(16,165),(16,166),(16,167),(16,168),(16,169),(16,170),(16,171),(16,172),(16,173),(16,174),(16,175),(16,176);

--
-- Table structure for table `content`
--

CREATE TABLE `content` (
  `id` int NOT NULL AUTO_INCREMENT,
  `media_id` int DEFAULT NULL,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_content` varchar(3000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `small_title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_small_title` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `reading_time` int DEFAULT NULL,
  `type_id` int NOT NULL,
  `url_video` varchar(1500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `partner_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_FEC530A9EA9FDD75` (`media_id`),
  KEY `IDX_FEC530A9C54C8C93` (`type_id`),
  KEY `IDX_FEC530A99393F8FE` (`partner_id`),
  CONSTRAINT `FK_FEC530A99393F8FE` FOREIGN KEY (`partner_id`) REFERENCES `partner` (`id`),
  CONSTRAINT `FK_FEC530A9C54C8C93` FOREIGN KEY (`type_id`) REFERENCES `content_type` (`id`),
  CONSTRAINT `FK_FEC530A9EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media_object` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content`
--

INSERT INTO `content` VALUES (1,NULL,'titolo','prova descrizione','test','Articolo',NULL,'2025-09-07',12,1,NULL,NULL),(2,NULL,'test','test','test','test',NULL,'2022-12-12',12,1,NULL,NULL),(3,NULL,'test','<b>test</b>','<b>test</b>','test',NULL,'2022-12-12',12,1,NULL,NULL),(4,15,'test','test','','test',NULL,'2022-12-12',0,2,NULL,NULL),(5,NULL,'test','test','','test',NULL,'2022-12-12',0,3,'<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/Ffe6lGP1CSs?si=3RGf6G3Yh-H2M-U8\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen></iframe>',NULL),(6,22,'test serale','test','<p>test</p>','test',NULL,'2022-12-12',0,1,'',NULL);

--
-- Table structure for table `content_type`
--

CREATE TABLE `content_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `button_text` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_more_button` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_type`
--

INSERT INTO `content_type` VALUES (1,'articles','Articoli','Leggi di più'),(2,'downloadable','Download','Download'),(3,'video','Video','Guarda');

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nome_provincia` varchar(150) NOT NULL,
  `sigla_provincia` varchar(5) NOT NULL,
  `regione` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `country`
--

INSERT INTO `country` VALUES (1,'Agrigento','AG','Sicilia'),(2,'Alessandria','AL','Piemonte'),(3,'Ancona','AN','Marche'),(4,'Aosta','AO','Valle d\'Aosta'),(5,'Arezzo','AR','Toscana'),(6,'Ascoli Piceno','AP','Marche'),(7,'Asti','AT','Piemonte'),(8,'Avellino','AV','Campania'),(9,'Bari','BA','Puglia'),(10,'Barletta-Andria-Trani','BT','Puglia'),(11,'Belluno','BL','Veneto'),(12,'Benevento','BN','Campania'),(13,'Bergamo','BG','Lombardia'),(14,'Biella','BI','Piemonte'),(15,'Bologna','BO','Emilia-Romagna'),(16,'Bolzano','BZ','Trentino-Alto Adige'),(17,'Brescia','BS','Lombardia'),(18,'Brindisi','BR','Puglia'),(19,'Cagliari','CA','Sardegna'),(20,'Caltanissetta','CL','Sicilia'),(21,'Campobasso','CB','Molise'),(22,'Caserta','CE','Campania'),(23,'Catania','CT','Sicilia'),(24,'Catanzaro','CZ','Calabria'),(25,'Chieti','CH','Abruzzo'),(26,'Como','CO','Lombardia'),(27,'Cosenza','CS','Calabria'),(28,'Cremona','CR','Lombardia'),(29,'Crotone','KR','Calabria'),(30,'Cuneo','CN','Piemonte'),(31,'Enna','EN','Sicilia'),(32,'Ferrara','FE','Emilia-Romagna'),(33,'Firenze','FI','Toscana'),(34,'Foggia','FG','Puglia'),(35,'Forlì-Cesena','FC','Emilia-Romagna'),(36,'Frosinone','FR','Lazio'),(37,'Genova','GE','Liguria'),(38,'Gorizia','GO','Friuli-Venezia Giulia'),(39,'Grosseto','GR','Toscana'),(40,'Imperia','IM','Liguria'),(41,'Isernia','IS','Molise'),(42,'L\'Aquila','AQ','Abruzzo'),(43,'La Spezia','SP','Liguria'),(44,'Latina','LT','Lazio'),(45,'Lecce','LE','Puglia'),(46,'Lecco','LC','Lombardia'),(47,'Livorno','LI','Toscana'),(48,'Lodi','LO','Lombardia'),(49,'Lucca','LU','Toscana'),(50,'Macerata','MC','Marche'),(51,'Mantova','MN','Lombardia'),(52,'Massa-Carrara','MS','Toscana'),(53,'Matera','MT','Basilicata'),(54,'Messina','ME','Sicilia'),(55,'Milano','MI','Lombardia'),(56,'Modena','MO','Emilia-Romagna'),(57,'Monza e della Brianza','MB','Lombardia'),(58,'Napoli','NA','Campania'),(59,'Novara','NO','Piemonte'),(60,'Nuoro','NU','Sardegna'),(61,'Oristano','OR','Sardegna'),(62,'Padova','PD','Veneto'),(63,'Palermo','PA','Sicilia'),(64,'Parma','PR','Emilia-Romagna'),(65,'Pavia','PV','Lombardia'),(66,'Perugia','PG','Umbria'),(67,'Pesaro e Urbino','PU','Marche'),(68,'Pescara','PE','Abruzzo'),(69,'Piacenza','PC','Emilia-Romagna'),(70,'Pisa','PI','Toscana'),(71,'Pistoia','PT','Toscana'),(72,'Pordenone','PN','Friuli-Venezia Giulia'),(73,'Potenza','PZ','Basilicata'),(74,'Prato','PO','Toscana'),(75,'Ragusa','RG','Sicilia'),(76,'Ravenna','RA','Emilia-Romagna'),(77,'Reggio Calabria','RC','Calabria'),(78,'Reggio Emilia','RE','Emilia-Romagna'),(79,'Rieti','RI','Lazio'),(80,'Rimini','RN','Emilia-Romagna'),(81,'Roma','RM','Lazio'),(82,'Rovigo','RO','Veneto'),(83,'Salerno','SA','Campania'),(84,'Sassari','SS','Sardegna'),(85,'Savona','SV','Liguria'),(86,'Siena','SI','Toscana'),(87,'Siracusa','SR','Sicilia'),(88,'Sondrio','SO','Lombardia'),(89,'Sud Sardegna','SU','Sardegna'),(90,'Taranto','TA','Puglia'),(91,'Teramo','TE','Abruzzo'),(92,'Terni','TR','Umbria'),(93,'Torino','TO','Piemonte'),(94,'Trapani','TP','Sicilia'),(95,'Trento','TN','Trentino-Alto Adige'),(96,'Treviso','TV','Veneto'),(97,'Trieste','TS','Friuli-Venezia Giulia'),(98,'Udine','UD','Friuli-Venezia Giulia'),(99,'Varese','VA','Lombardia'),(100,'Venezia','VE','Veneto'),(101,'Verbano-Cusio-Ossola','VB','Piemonte'),(102,'Vercelli','VC','Piemonte'),(103,'Verona','VR','Veneto'),(104,'Vibo Valentia','VV','Calabria'),(105,'Vicenza','VI','Veneto'),(106,'Viterbo','VT','Lazio');

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

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

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

INSERT INTO `doctrine_migration_versions` VALUES ('DoctrineMigrations\\Version20250716165938','2025-07-16 16:59:48',91),('DoctrineMigrations\\Version20250718160002','2025-07-18 16:00:21',132),('DoctrineMigrations\\Version20250721164014','2025-07-21 16:40:21',114),('DoctrineMigrations\\Version20250721190827','2025-07-21 19:08:30',56),('DoctrineMigrations\\Version20250722104856','2025-07-22 10:49:00',48),('DoctrineMigrations\\Version20250722111036','2025-07-22 11:10:44',121),('DoctrineMigrations\\Version20250722111407','2025-07-22 11:14:15',270),('DoctrineMigrations\\Version20250723142122','2025-07-23 14:21:35',27),('DoctrineMigrations\\Version20250723161103','2025-07-23 16:11:10',21),('DoctrineMigrations\\Version20250723165203','2025-07-23 16:52:15',71),('DoctrineMigrations\\Version20250723191201','2025-07-23 19:12:10',258),('DoctrineMigrations\\Version20250724182251','2025-07-24 18:23:00',51),('DoctrineMigrations\\Version20250725145553','2025-07-25 14:55:58',66),('DoctrineMigrations\\Version20250728185923','2025-07-28 18:59:40',51),('DoctrineMigrations\\Version20250805130354','2025-08-05 13:04:00',69),('DoctrineMigrations\\Version20250809174354','2025-08-09 17:44:04',34),('DoctrineMigrations\\Version20250813154630','2025-08-13 15:46:41',157),('DoctrineMigrations\\Version20250813162102','2025-08-13 16:21:14',79),('DoctrineMigrations\\Version20250826172753','2025-08-26 17:28:15',102),('DoctrineMigrations\\Version20250905194216','2025-09-05 19:42:30',168),('DoctrineMigrations\\Version20250905200633','2025-09-05 20:06:38',118),('DoctrineMigrations\\Version20250908132201','2025-09-08 13:22:05',41),('DoctrineMigrations\\Version20250909160707','2025-09-09 16:07:13',42),('DoctrineMigrations\\Version20250909162617','2025-09-09 16:26:25',24),('DoctrineMigrations\\Version20250910100215','2025-09-10 10:02:26',87),('DoctrineMigrations\\Version20250910100354','2025-09-10 10:03:59',121),('DoctrineMigrations\\Version20250914204151','2025-09-14 20:42:04',91),('DoctrineMigrations\\Version20250917140159','2025-09-17 14:02:05',238),('DoctrineMigrations\\Version20250917192248','2025-09-17 19:22:53',52);

--
-- Table structure for table `employment`
--

CREATE TABLE `employment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `employment` varchar(150) NOT NULL,
  `sub_event_id` int DEFAULT NULL,
  `base_data_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_BF089C98CB5806D2` (`sub_event_id`),
  KEY `IDX_BF089C983F31858` (`base_data_id`),
  CONSTRAINT `FK_BF089C983F31858` FOREIGN KEY (`base_data_id`) REFERENCES `base_data` (`id`),
  CONSTRAINT `FK_BF089C98CB5806D2` FOREIGN KEY (`sub_event_id`) REFERENCES `sub_event` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `employment`
--

INSERT INTO `employment` VALUES (2,'Amministratore',NULL,NULL),(3,'Ente pubblico',NULL,NULL),(4,'Professionista',NULL,NULL),(5,'Geometra',NULL,NULL),(6,'Perito',NULL,NULL),(7,'Architetto',NULL,NULL),(8,'Ingegnere',NULL,NULL),(9,'Azienda',NULL,NULL),(10,'Associazione',NULL,NULL),(11,'Privato',NULL,NULL),(12,'Ente del Terzo Settore',NULL,NULL),(13,'Altro',NULL,NULL);

--
-- Table structure for table `media_object`
--

CREATE TABLE `media_object` (
  `id` int NOT NULL AUTO_INCREMENT,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_object`
--

INSERT INTO `media_object` VALUES (1,NULL),(2,NULL),(3,'logoreteirene-6897aca77cdf5853784508.jpg'),(4,'logoreteirene-6897acd1baa15206565755.jpg'),(5,'logoreteirene-6897acdfc2f29059772934.jpg'),(6,'logoreteirene-6897ad13cd5c5393411972.jpg'),(7,'logoreteirene-6897ad215a0f8601170047.jpg'),(8,'chatgpt-image-2-ago-2025-21-55-31-689cb8eee64fa011795947.png'),(9,'chatgpt-image-2-ago-2025-21-55-31-689cbd07930e4117600007.png'),(10,'ritratto-all-aperto-di-una-donna-bionda-invecchiata-mezzo-ragazza-sexy-attraente-un-campo-con-i-fiori-il-bello-ha-invecchiato-142390806-68c02fad96620090871331.webp'),(11,'ritratto-all-aperto-di-una-donna-bionda-invecchiata-mezzo-ragazza-sexy-attraente-un-campo-con-i-fiori-il-bello-ha-invecchiato-142390806-68c02fc3baa94791913043.webp'),(12,'ritratto-all-aperto-di-una-donna-bionda-invecchiata-mezzo-ragazza-sexy-attraente-un-campo-con-i-fiori-il-bello-ha-invecchiato-142390806-68c02fd89f29a202373054.webp'),(13,'ritratto-all-aperto-di-una-donna-bionda-invecchiata-mezzo-ragazza-sexy-attraente-un-campo-con-i-fiori-il-bello-ha-invecchiato-142390806-68c030b13f51b457415485.webp'),(14,'ritratto-all-aperto-di-una-donna-bionda-invecchiata-mezzo-ragazza-sexy-attraente-un-campo-con-i-fiori-il-bello-ha-invecchiato-142390806-68c030c3d3411509412847.webp'),(15,'ritratto-all-aperto-di-una-donna-bionda-invecchiata-mezzo-ragazza-sexy-attraente-un-campo-con-i-fiori-il-bello-ha-invecchiato-142390806-68c030d0d6905902235836.webp'),(16,'screenshot-2025-08-02-095520-68c08f089d94c448801580.png'),(17,'screenshot-2025-08-02-095520-68c08f13bad8e719736000.png'),(18,'screenshot-2025-08-02-095520-68c08f253c155460328077.png'),(19,'screenshot-2025-08-02-095520-68c08f3b53610085170667.png'),(20,'screenshot-2025-08-02-095520-68c08f3d4f71a384205978.png'),(21,'479509813-17900087559104559-3792947613125458266-n-68c0903c94b63095586020.jpg'),(22,'479509813-17900087559104559-3792947613125458266-n-68c090a37ce0f450502120.jpg'),(23,'vella-lab-1400x788-68c1352d502c2443069741.jpg'),(24,'vella-lab-1400x788-68c1354394443929056570.jpg'),(25,'vella-lab-1400x788-68c135454f822389014369.jpg'),(26,'vella-lab-1400x788-68c135c013a7f874110432.jpg'),(27,'479509813-17900087559104559-3792947613125458266-n-68c158b554113405460380.jpg'),(28,'ritratto-all-aperto-di-una-donna-bionda-invecchiata-mezzo-ragazza-sexy-attraente-un-campo-con-i-fiori-il-bello-ha-invecchiato-142390806-68c1599b12b4d874241198.webp'),(29,'ritratto-all-aperto-di-una-donna-bionda-invecchiata-mezzo-ragazza-sexy-attraente-un-campo-con-i-fiori-il-bello-ha-invecchiato-142390806-68c15c94dc644525425892.webp');

--
-- Table structure for table `partner`
--

CREATE TABLE `partner` (
  `id` int NOT NULL AUTO_INCREMENT,
  `media_id` int DEFAULT NULL,
  `small_title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `button_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_312B3E16EA9FDD75` (`media_id`),
  CONSTRAINT `FK_312B3E16EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media_object` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partner`
--

INSERT INTO `partner` VALUES (1,29,'test','test','test','test');

--
-- Table structure for table `sub_event`
--

CREATE TABLE `sub_event` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `max_number` int DEFAULT NULL,
  `base_data_id` int NOT NULL,
  `main_event` tinyint(1) DEFAULT NULL,
  `profile_image` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D7EA6E1E3F31858` (`base_data_id`),
  CONSTRAINT `FK_D7EA6E1E3F31858` FOREIGN KEY (`base_data_id`) REFERENCES `base_data` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_event`
--

INSERT INTO `sub_event` VALUES (9,'Dalle sfide sistemiche alla spinta al Cambiamento','2025-11-13T10:30','In questa sessione di apertura, analizzeremo gli scenari attuali e definiremo una visione chiara per il futuro, trasformando gli ostacoli di oggi nelle più grandi opportunità di crescita e innovazione di domani.','BASE Milano Sala A','Offline',300,16,1,NULL),(10,'Analisi di scenario e impatto: Quanto ti costa non riqualificare?','2025-11-13T11:30','L\'inazione ha un prezzo, spesso più alto dell\'investimento. Scopriremo come trasformare la riqualificazione da un costo a un potente generatore di valore e capitale. Un intervento pensato per capovolgere le prospettive e ispirare all\'azione.','BASE Milano Sala A','Offline',300,16,1,NULL),(11,'Casi concreti: quando la riqualificazione diventa realtà.','0025-11-13T12:00','Oltre la teoria, le esperienze reali. Ascolteremo dalla voce dei protagonisti due storie emblematiche: sfide affrontate, soluzioni trovate e risultati raggiunti sul campo. ','BASE Milano Sala A','Offline',300,16,1,NULL),(12,'TERZO SETTORE | Capitale Sociale: Rigenerare Immobili per Rigenerare Comunità #1','2025-11-13T14:30','Ogni edificio del Terzo Settore è molto più di un contenitore: è un nodo vitale nella rete della coesione sociale. Riqualificarlo significa moltiplicare valore. \nUn incontro operativo per dirigenti, tecnici e organizzazioni del Terzo Settore.','BASE Milano Sala B','Offline',150,16,0,NULL),(13,'Percorso assembleare: come accompagnare il progetto verso l’approvazione #1','2025-11-13T14:30','Un progetto ben fatto non basta. Perché venga realizzato, deve essere compreso. Questa sessione è dedicata a chi, come amministratore o progettista, si trova a tradurre la complessità tecnica in un messaggio capace di attivare una decisione positiva.','BASE Milano Sala C','Offline',150,16,0,NULL),(17,'TERZO SETTORE | Capitale Sociale: Rigenerare Immobili per Rigenerare Comunità #2','2025-11-13T15:45','Ogni edificio del Terzo Settore è molto più di un contenitore: è un nodo vitale nella rete della coesione sociale. Riqualificarlo significa moltiplicare valore. \nUn incontro operativo per dirigenti, tecnici e organizzazioni del Terzo Settore.','BASE Milano Sala B','offline',150,16,0,NULL),(18,'Percorso assembleare: come accompagnare il progetto verso l’approvazione #2','2025-11-13T15:45','Un progetto ben fatto non basta. Perché venga realizzato, deve essere compreso. Questa sessione è dedicata a chi, come amministratore o progettista, si trova a tradurre la complessità tecnica in un messaggio capace di attivare una decisione positiva.','BASE Milano Sala C','offline',150,16,0,NULL);

--
-- Table structure for table `sub_event_user`
--

CREATE TABLE `sub_event_user` (
  `sub_event_id` int NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`sub_event_id`,`user_id`),
  KEY `IDX_BE93092FCB5806D2` (`sub_event_id`),
  KEY `IDX_BE93092FA76ED395` (`user_id`),
  CONSTRAINT `FK_BE93092FA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_BE93092FCB5806D2` FOREIGN KEY (`sub_event_id`) REFERENCES `sub_event` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_event_user`
--

INSERT INTO `sub_event_user` VALUES (9,49),(9,50),(9,52),(9,53),(9,54),(9,55),(9,56),(9,58),(9,60),(9,61),(9,62),(9,63),(9,64),(9,65),(9,67),(9,68),(9,69),(9,71),(9,72),(9,73),(9,74),(9,76),(9,78),(9,79),(9,80),(9,81),(9,82),(9,84),(9,85),(9,86),(9,87),(9,88),(9,89),(9,90),(9,91),(9,92),(9,93),(9,94),(9,96),(9,97),(9,99),(9,100),(9,101),(9,102),(9,104),(9,106),(9,109),(9,110),(9,111),(9,112),(9,113),(9,114),(9,115),(9,117),(9,118),(9,119),(9,120),(9,121),(9,123),(9,125),(9,126),(9,129),(9,130),(9,132),(9,133),(9,134),(9,135),(9,137),(9,139),(9,140),(9,141),(9,143),(9,144),(9,145),(9,146),(9,147),(9,148),(9,149),(9,150),(9,151),(9,153),(9,159),(9,160),(9,161),(9,162),(9,163),(9,164),(9,165),(9,166),(9,167),(9,168),(9,169),(9,170),(9,171),(9,172),(9,173),(9,174),(9,175),(9,176),(10,49),(10,50),(10,52),(10,53),(10,54),(10,55),(10,56),(10,58),(10,60),(10,61),(10,62),(10,63),(10,64),(10,65),(10,67),(10,68),(10,69),(10,71),(10,72),(10,73),(10,74),(10,76),(10,78),(10,79),(10,80),(10,81),(10,82),(10,84),(10,85),(10,86),(10,87),(10,88),(10,89),(10,90),(10,91),(10,92),(10,93),(10,94),(10,96),(10,97),(10,99),(10,100),(10,101),(10,102),(10,104),(10,106),(10,109),(10,110),(10,111),(10,112),(10,113),(10,114),(10,115),(10,117),(10,118),(10,119),(10,120),(10,121),(10,123),(10,125),(10,126),(10,129),(10,130),(10,132),(10,133),(10,134),(10,135),(10,137),(10,139),(10,140),(10,141),(10,143),(10,144),(10,145),(10,146),(10,147),(10,148),(10,149),(10,150),(10,151),(10,153),(10,159),(10,160),(10,161),(10,162),(10,163),(10,164),(10,165),(10,166),(10,167),(10,168),(10,169),(10,170),(10,171),(10,172),(10,173),(10,174),(10,175),(10,176),(11,49),(11,50),(11,52),(11,53),(11,54),(11,55),(11,56),(11,58),(11,60),(11,61),(11,62),(11,63),(11,64),(11,65),(11,67),(11,68),(11,69),(11,71),(11,72),(11,73),(11,74),(11,76),(11,78),(11,79),(11,80),(11,81),(11,82),(11,84),(11,85),(11,86),(11,87),(11,88),(11,89),(11,90),(11,91),(11,92),(11,93),(11,94),(11,96),(11,97),(11,99),(11,100),(11,101),(11,102),(11,104),(11,106),(11,109),(11,110),(11,111),(11,112),(11,113),(11,114),(11,115),(11,117),(11,118),(11,119),(11,120),(11,121),(11,123),(11,125),(11,126),(11,129),(11,130),(11,132),(11,133),(11,134),(11,135),(11,137),(11,139),(11,140),(11,141),(11,143),(11,144),(11,145),(11,146),(11,147),(11,148),(11,149),(11,150),(11,151),(11,153),(11,159),(11,160),(11,161),(11,162),(11,163),(11,164),(11,165),(11,166),(11,167),(11,168),(11,169),(11,170),(11,171),(11,172),(11,173),(11,174),(11,175),(11,176),(12,49),(12,53),(12,54),(12,58),(12,60),(12,63),(12,71),(12,82),(12,84),(12,92),(12,96),(12,100),(12,102),(12,104),(12,109),(12,110),(12,111),(12,119),(12,120),(12,129),(12,134),(12,135),(12,137),(12,151),(12,159),(12,161),(12,169),(12,171),(12,172),(12,176),(13,54),(13,55),(13,58),(13,71),(13,76),(13,82),(13,86),(13,91),(13,100),(13,102),(13,104),(13,111),(13,112),(13,113),(13,133),(13,144),(13,162),(13,163),(13,164),(13,166),(13,171),(17,49),(17,63),(17,129),(17,135),(17,144),(17,151),(17,159),(17,162),(17,163),(17,171),(18,133),(18,134),(18,137),(18,164),(18,166),(18,169),(18,171),(18,172);

--
-- Table structure for table `user_appointment`
--

CREATE TABLE `user_appointment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `date_time_appointment` datetime NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `professional` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_572331D1A76ED395` (`user_id`),
  CONSTRAINT `FK_572331D1A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_appointment`
--

INSERT INTO `user_appointment` VALUES (2,49,'2025-11-13 12:00:00','Consulenza materiali','Pippo','');

--
-- Table structure for table `user_detail`
--

CREATE TABLE `user_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fiscal_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` int DEFAULT NULL,
  `employment_id` int DEFAULT NULL,
  `company` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bio` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4B5464AEF92F3E70` (`country_id`),
  KEY `IDX_4B5464AE466E61E3` (`employment_id`),
  CONSTRAINT `FK_4B5464AE466E61E3` FOREIGN KEY (`employment_id`) REFERENCES `employment` (`id`),
  CONSTRAINT `FK_4B5464AEF92F3E70` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_detail`
--

INSERT INTO `user_detail` VALUES (1,'Pierluigi','Zavaroni','3408145226','zvrplg77c28g337e',NULL,NULL,NULL,NULL),(50,'Sergio','Simonazzi','348 7383897','SMNSRG63B04G337G',NULL,NULL,NULL,NULL),(51,'Laura','Teaca','3298209155','TCELRA02M63Z140E',NULL,NULL,NULL,NULL),(53,'Alberto','Frascotti','3483508793','FRSLRT62D10F205Z',NULL,NULL,NULL,NULL),(54,'Franco','Bontadini','3482373304','BNTFNC47L30F205X',NULL,NULL,NULL,NULL),(55,'Rolando','Moncada','3384303032','MNCRND58D21F205Z',NULL,NULL,NULL,NULL),(56,'Giovanni ','Fanfulla ','3349700465','Fnfgnn71b21a783a',NULL,NULL,NULL,NULL),(57,'Alessandro','Giani','3356238777','Gnilsn72p05h294s',NULL,NULL,NULL,NULL),(59,'Silvia','Fichera','3400871924','FCHSVM70R50I690G',NULL,NULL,NULL,NULL),(61,'Andrea','Couvert','3519719485','CVRNDR60A02L219A',NULL,NULL,NULL,NULL),(62,'Giancarlo','Sartini','3286615610','SRTGCR69B18H501F',NULL,NULL,NULL,NULL),(63,'Gianfranco','delfo','3356279585','DLFGFR58A11G273L',NULL,NULL,NULL,NULL),(64,'Giorgio','Secchi','3355435464','SCCGRG51H06C728V',NULL,NULL,NULL,NULL),(65,'Massimo ','Fasani ','3518478682','FSNMSM65R29F205F',NULL,NULL,NULL,NULL),(66,'Marco','Berardi','3488335495','BRRMRC88P01F704E',NULL,NULL,NULL,NULL),(68,'Lorenzo','Ricciardi','3939268292','RCCLNZ73L01F704W',NULL,NULL,NULL,NULL),(69,'Marco Andrea ','Ercoli','335690143','RCLMCN62M10F205A',NULL,NULL,NULL,NULL),(70,'marco','milanesi','3358256649','MLNMRC65S20F205Z',NULL,NULL,NULL,NULL),(71,'Pierluigi','Zavaroni','3408145226','zvrplg77c28g337e',64,2,'test','test'),(72,'Omar','Berlonghi','3351258642','Brlmro75s10d142z',NULL,NULL,NULL,NULL),(73,'Riccardo','Decarli','3489012955','DCRRCR48D18L848X',NULL,NULL,NULL,NULL),(74,'SIMONETTA','SORACE','3477146495','srcsnt76b42d969s',NULL,NULL,NULL,NULL),(75,'Silvia','Fasolo','3472723227','FSLSLV67R44A182E',NULL,NULL,NULL,NULL),(76,'Luca','Ferrari','03321520126','FRRLCU64M31E591K',NULL,NULL,NULL,NULL),(77,'Roberto','Grassi','0248400027','GRSRRT70E17F205Z',NULL,NULL,NULL,NULL),(79,'Corrado','Mascetti','3403440422','MSCCRD70L27C933X',NULL,NULL,NULL,NULL),(80,'Francesco Maurizio','Militello','3339216242','mltfnc58e09e591r',NULL,NULL,NULL,NULL),(81,'ETTORE FERRUCCIO','GILBERTI','3356644556','GLBTRF65T25F205A',NULL,NULL,NULL,NULL),(82,'Francesco','Avallone','3316320508','Vllfnc51r08g763x',NULL,NULL,NULL,NULL),(83,'Massimo','Cavagnini','3480094705','CVGMSM67D20B157C',NULL,NULL,NULL,NULL),(85,'Fausto Luigi','Franchi','333441971','FRNFTL70H09L319T',NULL,NULL,NULL,NULL),(86,'GIANMARCO','BECCARIA','3299304690','BCCGMR77B06A182W',NULL,NULL,NULL,NULL),(87,'Fabrizio','Viganò','3398364584','VGNFRZ65T01E617P',NULL,NULL,NULL,NULL),(88,'LUCA','ZAPPELLA','3355346597','ZPPLCU74D23F205H',NULL,NULL,NULL,NULL),(89,'Gian Francesco','Fregoni','3296623900','FRGGFR58M19H598I',NULL,NULL,NULL,NULL),(90,'Alessio','Santacroce','3276156482','SNTLSS76E26D643C',NULL,NULL,NULL,NULL),(91,'Gianni','Izzo','3403960790','ZZIGNN62P28D708E',NULL,NULL,NULL,NULL),(92,'Giorgio Enrico','Belloni','0227305825','BLLGGN68D16F205O',NULL,NULL,NULL,NULL),(93,'Alessandro','Mandelli','3429737326','MNDLSN71D19F133G',NULL,NULL,NULL,NULL),(94,'Luciano','Damiano','3923807551','DMNLCN57A15F027Y',NULL,NULL,NULL,NULL),(95,'Roberto ','Rizzo','3337617741','Rzzrrt69s10f205f',NULL,NULL,NULL,NULL),(97,'ANTONIO','CINOTTO','0125627127','CNTNTN68S22E379X',NULL,NULL,NULL,NULL),(98,'Maurizio Amos','Pontara','3393219166','PNTMZM51A15A539N',NULL,NULL,NULL,NULL),(100,'Mauro','Vanzini','3472721768','vnzmra70p05e349f',NULL,NULL,NULL,NULL),(101,'Giovanni','Dibennardo','368259529','dbngnn59p24c927p',NULL,NULL,NULL,NULL),(102,'Pasquale','Capezzuto','0805242099','CPZPQL57M24A662U',NULL,NULL,NULL,NULL),(103,'Barbara ','Caravella ','3206912424','Crvbbr71d56f839n',NULL,NULL,NULL,NULL),(105,'Francesco ','NADDEO','3335434660','Nddfnc70h02h703x',NULL,NULL,NULL,NULL),(107,'Cristina','Mazzola','0239660996','MZZCST79B51F205X',NULL,NULL,NULL,NULL),(110,'Francesco','MARINELLI','3356099243','MRNFNC55H18A662H',NULL,NULL,NULL,NULL),(111,'Cosimo ','Guida','3356806895','GDUCSM61S24A294S',NULL,NULL,NULL,NULL),(112,'Claudio','Borin','3281328768','BRNCLD77S22M109S',NULL,NULL,NULL,NULL),(113,'ANDREA','SBERNINI','328 9542923','SBRNDR81T19E734R',NULL,NULL,NULL,NULL),(114,'Paolo','Sodero','3483515263','SDRPLA63M15G478D',NULL,NULL,NULL,NULL),(115,'Riccardo','Calvi','3357044448','Clvrcr64l24f205s',NULL,NULL,NULL,NULL),(116,'Evy ','Lai','3478749772','LAIVYE75T65I452Y',NULL,NULL,NULL,NULL),(117,'Dimitri','Simonazzi','333 2334456','SMNDTR02p06G337C',NULL,NULL,NULL,NULL),(118,'GIORGIO GIANCARLO','GAVIGLIO','3482266613','GVGGGG56R17L219F',NULL,NULL,NULL,NULL),(119,'Caterina','Grasso','3203623746','GRSCRN75C61L219I',NULL,NULL,NULL,NULL),(120,'Davide','Buffelli','3206285621','BFFDVD83L30D851N',NULL,NULL,NULL,NULL),(121,'Marco Luigi','Leopizzi','0245388307','LPZMCL83D09D862X',NULL,NULL,NULL,NULL),(122,'Daniela','Bernasconi','0236548308','BRNDNL80C59F205O',NULL,NULL,NULL,NULL),(124,'Samuele','Altobelli ','0236548308','LTBSML03B11F704C',NULL,NULL,NULL,NULL),(126,'Andrea Alberto','Nostrini','0236548308','NSTNRL75P29F205Z',NULL,NULL,NULL,NULL),(127,'SALVATORE','OTTANA\'','3939218151','TTNSVT64M03C566Y',NULL,NULL,NULL,NULL),(130,'ing. filippo','caimi','3478395454','CMAFPP83C21E801P',NULL,NULL,NULL,NULL),(131,'Giancarlo','Rossi','0258306779','RSSGCR61B13F205J',NULL,NULL,NULL,NULL),(132,'Nolita','Web','3408145227','zvrplg77c28g337e',NULL,NULL,NULL,NULL),(133,'Davide','Munari','3292808727','MNRDVD86H05E379T',NULL,NULL,NULL,NULL),(134,'Carlo','Mingazzini','3483417191','MNGCRL51C14D458C',NULL,NULL,NULL,NULL),(135,'Jacopo','Aste','338111111','STAJCP83L03G628G',NULL,NULL,NULL,NULL),(136,'Giuseppe','Casarico ','3358103240','CSRGPP53C11F205W',NULL,NULL,NULL,NULL),(138,'Paola','Perniè',' 3484740338','PRNPLA72A41E958C',NULL,NULL,NULL,NULL),(140,'CARLO','BOSSI','0392311551','BSSCRL59M28B300R',NULL,NULL,NULL,NULL),(141,'MARIA GRAZIA','BOSSI','3389360133','RMNMGR61T60I690Y',NULL,NULL,NULL,NULL),(142,'SILVIA MARIA','fichera','3400871924','FCHSVM70R50I690G',NULL,NULL,NULL,NULL),(144,'Raffaele','Ciampini','3356971234','CMPRFL63A15D612O',NULL,NULL,NULL,NULL),(145,'Mario V.','Serini','029306942','SRNMVT64R19F205G',NULL,NULL,NULL,NULL),(146,'Lupo','Attardo','3280770140','TTRLTM79A18F205S',NULL,NULL,NULL,NULL),(147,'ORIANO','VALLI','3381683497','VLLRNO59C03E785W',NULL,NULL,NULL,NULL),(148,'Paolo','Lombardi','0292141960','LMBPLA60P17F205Q',NULL,NULL,NULL,NULL),(149,'marco','papagna','3475980103','ppgmrc63h02f205o',NULL,NULL,NULL,NULL),(150,'Fabio','Innocenti','3351874960','NNCFBA73B17F205A',NULL,NULL,NULL,NULL),(151,'Marta','Barengo','366 7752577','BRNMRT79E55F952J',NULL,NULL,NULL,NULL),(152,'Riccardo','Rossi','3351275684','rssrcr70e17d612p',NULL,NULL,NULL,NULL),(153,'Utente','Di Prova','3408145226','zvrplg77c28g337e',NULL,NULL,NULL,NULL),(154,'Fedele','Ventrella','3285339633','vntfdl79h04e951m',NULL,NULL,NULL,NULL),(155,'GIAN FRANCO','MELLINO','3391013926','MLLGFR69L16F205G',NULL,NULL,NULL,NULL),(160,'Giuseppe','Cabini','3336881301','CBNGPP66L08D142C',NULL,NULL,NULL,NULL),(161,'Francesca ','Ramacciotti','3755587033','RMCFNC88R52E715C',NULL,NULL,NULL,NULL),(162,'Maurizio ','Bonomi','3481550775','BNMMRZ65C09A246Q',NULL,NULL,NULL,NULL),(163,'BARBARA','SPINELLI','3409044340','SPNBBR75L52I690E',NULL,NULL,NULL,NULL),(164,'ANDREA','ARNOLDI','3270665779','RNLNDR70H18F205J',NULL,NULL,NULL,NULL),(165,'Massimo','Marescotti','02680985','MRSMSM70D19H827S',NULL,NULL,NULL,NULL),(166,'Paolo','Lanfranconi','3355437656','Lnfpla67m03d969r',NULL,NULL,NULL,NULL),(167,'Michele Luigi','Coffano','+390235982335','CFFMHL65R19F205G',NULL,NULL,NULL,NULL),(168,'Piero Angelo','Amante','3356590390','MNTPNG62B08L074U',NULL,NULL,NULL,NULL),(169,'Anna','Caldarella','0541 815811','CLDNNA92E54H163S',NULL,NULL,NULL,NULL),(170,'Massimo','Carosso','335314281','CRSMSM68M12D933V',NULL,NULL,NULL,NULL),(171,'Alfio','Foresti','3357492434','FRSLFA76E22A794K',NULL,NULL,NULL,NULL),(172,'luca','arena','0392300314','RNALCU79R22F205S',NULL,NULL,NULL,NULL),(173,'Mariarita','Masiero','3496496833','MSRMRT62H55A818S',57,7,NULL,NULL),(174,'Luca','Baldin','0444543133','bldlcu61r15l736i',105,12,NULL,NULL),(175,'Flavio','Parise','3466197411','PRSFLV65M09F464U',105,8,NULL,NULL),(176,'Alessandra','Parolini','3397031748','PRLLSN72P50L667H',NULL,7,NULL,NULL),(177,'Stefano','Barbera','3406816041','BRBSFN85C25A010E',65,8,NULL,NULL);


