-- phpMyAdmin SQL Dump -- version 5.2.2deb1+deb13u1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Feb 23, 2026 at 11:23 AM -- Server version: 11.8.3-MariaDB-0+deb13u1 from Debian -- PHP Version: 8.4.16 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `sc_Assicurazioni` -- -- -------------------------------------------------------- -- -- Table structure for table `Assicurazioni` -- CREATE TABLE `Assicurazioni` ( `CodAss` int(11) NOT NULL, `Nome` varchar(20) NOT NULL, `Sede` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `Assicurazioni` -- INSERT INTO `Assicurazioni` (`CodAss`, `Nome`, `Sede`) VALUES (123456787, 'Ass. Cosa Nostra', 'Napoli'), (123456788, 'Ass. Bianchi', 'Parigi'), (123456789, 'Ass. Rossi', 'Roma'); -- -------------------------------------------------------- -- -- Table structure for table `Auto` -- CREATE TABLE `Auto` ( `Targa` char(7) NOT NULL, `Marca` varchar(20) NOT NULL, `Cilindrata` decimal(10,0) NOT NULL, `Potenza` decimal(10,0) NOT NULL, `CodiceFiscale` char(16) NOT NULL, `CodAss` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `Auto` -- INSERT INTO `Auto` (`Targa`, `Marca`, `Cilindrata`, `Potenza`, `CodiceFiscale`, `CodAss`) VALUES ('ABCDEF1', 'BMW', 4, 55, 'BRGTDA25K94H67J9', 123456787), ('ABCDEF2', 'Kia', 7, 70, 'BRGTDA25K94H67J8', 123456787), ('ABCDEF3', 'Audi', 7, 70, 'BRGTDA25K94H67J9', 123456789), ('ABCDEF4', 'FIAT', 10, 125, 'BRGTDA25K94H67J9', 123456787); -- -------------------------------------------------------- -- -- Table structure for table `AutoCoinvolte` -- CREATE TABLE `AutoCoinvolte` ( `CodSin` int(11) NOT NULL, `Targa` char(7) NOT NULL, `Importo` decimal(10,0) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `AutoCoinvolte` -- INSERT INTO `AutoCoinvolte` (`CodSin`, `Targa`, `Importo`) VALUES (19841984, 'ABCDEF1', 2), (19841984, 'ABCDEF2', 10000), (50501795, 'ABCDEF2', 20), (50501795, 'ABCDEF3', 3722); -- -------------------------------------------------------- -- -- Table structure for table `Proprietari` -- CREATE TABLE `Proprietari` ( `CodiceFiscale` char(16) NOT NULL, `Nome` varchar(20) NOT NULL, `Cognome` varchar(20) NOT NULL, `Residenza` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `Proprietari` -- INSERT INTO `Proprietari` (`CodiceFiscale`, `Nome`, `Cognome`, `Residenza`) VALUES ('BRGTDA25K94H67J7', 'Franco', 'Rossi', 'Pomezia'), ('BRGTDA25K94H67J8', 'Luigi', 'Rossi', 'Roma'), ('BRGTDA25K94H67J9', 'Mario', 'Rossi', 'Latina'); -- -------------------------------------------------------- -- -- Table structure for table `Sinistro` -- CREATE TABLE `Sinistro` ( `CodSin` int(11) NOT NULL, `Localita` varchar(20) NOT NULL, `DataSinistro` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `Sinistro` -- INSERT INTO `Sinistro` (`CodSin`, `Localita`, `DataSinistro`) VALUES (19841984, 'Catania', '2025-10-17'), (50501795, 'Pomezia', '2024-10-07'); -- -- Indexes for dumped tables -- -- -- Indexes for table `Assicurazioni` -- ALTER TABLE `Assicurazioni` ADD PRIMARY KEY (`CodAss`); -- -- Indexes for table `Auto` -- ALTER TABLE `Auto` ADD PRIMARY KEY (`Targa`,`CodiceFiscale`,`CodAss`), ADD KEY `CodiceFiscale` (`CodiceFiscale`), ADD KEY `CodAss` (`CodAss`); -- -- Indexes for table `AutoCoinvolte` -- ALTER TABLE `AutoCoinvolte` ADD PRIMARY KEY (`CodSin`,`Targa`), ADD KEY `Targa` (`Targa`); -- -- Indexes for table `Proprietari` -- ALTER TABLE `Proprietari` ADD PRIMARY KEY (`CodiceFiscale`); -- -- Indexes for table `Sinistro` -- ALTER TABLE `Sinistro` ADD PRIMARY KEY (`CodSin`); -- -- Constraints for dumped tables -- -- -- Constraints for table `Auto` -- ALTER TABLE `Auto` ADD CONSTRAINT `Auto_ibfk_1` FOREIGN KEY (`CodiceFiscale`) REFERENCES `Proprietari` (`CodiceFiscale`), ADD CONSTRAINT `Auto_ibfk_2` FOREIGN KEY (`CodAss`) REFERENCES `Assicurazioni` (`CodAss`); -- -- Constraints for table `AutoCoinvolte` -- ALTER TABLE `AutoCoinvolte` ADD CONSTRAINT `AutoCoinvolte_ibfk_1` FOREIGN KEY (`Targa`) REFERENCES `Auto` (`Targa`); COMMIT; /*!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 */;