--
-- 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,3),(16,18),(16,19),(16,24),(16,28),(16,31),(16,32),(16,33),(16,36),(16,39),(16,42),(16,43),(16,46);

--
-- 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);

--
-- 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=8 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');

--
-- 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,
  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=14 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','Dalle sfide sistemiche alla spinta al Cambiamento.','BASE MIlano','Offline',300,16,0),(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.\n','BASE Milano Sala A','Offline',300,16,0),(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','Offine',304,16,0),(12,'TERZO SETTORE | Capitale Sociale: Rigenerare Immobili per Rigenerare Comunità','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.','BASE Milano Sala B','Offline',150,16,1),(13,'Percorso assembleare: come accompagnare il progetto verso l’approvazione','2025-11-13T14:30','Questa sessione è dedicata a chi, come amministratore o progettista, si trova a tradurre la complessità tecnica in un messaggio chiaro e convincente, capace di attivare una decisione positiva.','BASE Milano Sala C','Offline',150,16,1);

--
-- 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 (12,3),(12,18),(12,19),(12,24),(12,28),(12,31),(12,32),(12,33),(12,36),(12,39),(12,42),(12,43),(12,46),(13,3),(13,18),(13,19),(13,24),(13,28),(13,31),(13,32),(13,33),(13,36),(13,39),(13,42),(13,43),(13,46);

--
-- 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_detail` VALUES (1,'Pierluigi','Zavaroni','3408145226','zvrplg77c28g337e'),(2,'Pippo','Pluto','3408145226','zvrplg77c28g337e'),(4,'pippo','pluto','3408145226','zvrplg'),(5,'Pippo','Pluto','3408145226','zvrplg77c28g337e'),(6,'Pippo','Pluto','3408145226','zvrplg77c28g337e'),(7,'Pippo','Pluto','3408145226','zvrplg77c28g337e'),(8,'pippo','pluto','3408145226','zvrplg77c28g337e'),(9,'Pippo','Pluto','3408145226','zvrplg77c28g337e'),(11,'pippo','pluto','3408145226','zvrplg77c28g337e'),(12,'pippo','pluto','3408145226','zvrplg77c28g337e'),(13,'pippo','pluto','3408145226','zvrplg77c28g337e'),(14,'pippo','pluto','3408145226','zvrplg77c28g337e'),(15,'parmaliberaa@gmail.com','pippoo','3408145226','zvrplg77c28g337e'),(16,'pippo','pluto','3408145226','zvrplg77c28g337e'),(17,'Sergio','Simonazzi','3487383897','SMNSRG63B04G337G'),(18,'pippo','pluto','3408145226','zvrplg77c28g337e'),(19,'Sergio','Simonazzi','348 7383897','SMNSRG63B04G337G'),(20,'Laura','Teaca','3286209155','TCELRA02M63Z140E'),(25,'Pippo','Pluto','3408145226','zvrplg77c28g337e'),(26,'trtrtt','trtrttft','3408145226','zvrplg77c28g337e'),(29,'Pippo','Pippi','3452323334','SMNSRG63B04G337G'),(30,'Pippo','Pluto','3408145226','zvrplg77c28g337e'),(31,'piosifidfii','jufdjfdjk','3408145226','zvrplg77c28g337e'),(32,'ptrptep','djkjfdkjjk','3408145226','zvrplg77c28g337e'),(33,'pippo','pdksoo','3408145226','zvrplg77c28g337e'),(34,'fsffss','fssds','3408145226','zvrplg77c28g337e'),(37,'Pierluigi','Zavaroni','3408145226','zvrplg77c28g337e'),(38,'test','test','340','test'),(40,'test','test','340','test'),(43,'Pippo','Pulto','3408145226','zvrplg77c28g337e'),(44,'Sergio','Simonazzi','3487383897','SMNSRG63B04G337G'),(45,'pippo','pluto','3408145226','zvrplg77c28g337e'),(46,'piptptoeor','ereri','3408145226','zvrplg77c28g337e'),(47,'pippo','pluto','3408145226','zvrplg77c28g337e');


