-- MySQL dump 10.13  Distrib 8.0.26, for Win64 (x86_64)
--
-- Host: localhost    Database: leganavale_lni
-- ------------------------------------------------------
-- Server version	8.0.18

/*!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 */;

--
-- Table structure for table `natante`
--

DROP TABLE IF EXISTS `natante`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `natante` (
  `idnatante` int(10) NOT NULL AUTO_INCREMENT,
  `TipoNatante` varchar(50) NOT NULL,
  `IDTipoRimessaggio` int(11) NOT NULL,
  `Lunghezza` double DEFAULT '0',
  `Larghezza` double DEFAULT '0',
  `Peso` double DEFAULT '0',
  `Length` double DEFAULT '0',
  `Width` double DEFAULT '0',
  `Weight` double DEFAULT '0',
  `Foto` varchar(255) DEFAULT '',
  `idtiposcansia` int(11) DEFAULT '4',
  PRIMARY KEY (`idnatante`),
  UNIQUE KEY `IDAttivita` (`idnatante`),
  UNIQUE KEY `TipoNatante_UNIQUE` (`TipoNatante`),
  KEY `fk_tiporimessaggio_idx` (`IDTipoRimessaggio`),
  KEY `fk_tiposcansia_idx` (`idtiposcansia`),
  CONSTRAINT `fk_tiporimessaggio` FOREIGN KEY (`IDTipoRimessaggio`) REFERENCES `causali` (`IDcausale`),
  CONSTRAINT `fk_tiposcansia` FOREIGN KEY (`idtiposcansia`) REFERENCES `tiposcansia` (`idtiposcansia`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `natante`
--

LOCK TABLES `natante` WRITE;
/*!40000 ALTER TABLE `natante` DISABLE KEYS */;
INSERT INTO `natante` VALUES (1,'420',21,4.1999998092651,1.6499999761581,100,13.779527664185,5.4133858680725,220.46200561523,'./FotoNatanti/420.gif',4),(2,'470',21,4.4,1.68,115,14.435696000000002,5.5118111999999995,253.5313,'./FotoNatanti/470.jpg',4),(5,'CANOA-Arenile',17,0,0,0,0,0,0,'./FotoNatanti/Kayak.jpg',4),(6,'CANOA-Coperto',13,0,0,0,0,0,0,'./FotoNatanti/canoa.jpg',4),(10,'DART 15',21,0,0,0,0,0,0,'./FotoNatanti/Dark16.jpg',4),(17,'Gommone',35,0,0,0,0,0,0,'',4),(26,'Laser Bahia',33,4.6,1.8,155,15.091864,5.905512,341.7161,'./FotoNatanti/Laser bahia.jpg',4),(27,'Mattia S',22,5.34,2.42,130,17.5196856,7.9396328,286.6006,'./FotoNatanti/Mattia S.jpg',4),(28,'Optimist',26,2.15,1.13,35,7.053806,3.7073491999999995,77.1617,'./FotoNatanti/optimist.jpg',4),(29,'Pattino',35,0,0,0,0,0,0,'',4),(32,'SK (Skipper)',28,3.75,1.6,90,12.303150177002,5.249344000000001,198.41580200195,'./FotoNatanti/SK.jpg',4),(36,'Kite surf',15,0,0,0,0,0,0,'./FotoNatanti/Kite.jpg',3),(37,'Trident 14',31,4.2,1.7,140,13.779528,5.577427999999999,308.6468,'./FotoNatanti/Trident 14.jpg',4),(38,'Vaurien',30,4.08,1.57,95,13.3858272,5.1509188,209.4389,'./FotoNatanti/Vaurien.jpg',4),(39,'Windsurf',14,0,0,0,0,0,0,'./FotoNatanti/Windsurf.jpg',2),(40,'X14',29,3.98,1.46,60,13.0577432,4.7900264,132.2772064209,'./FotoNatanti/X14.jpg',4),(41,'Lequipe',29,3.9,1.45,79,12.795276,4.757218,174.16497999999999,'./FotoNatanti/Lequipe.jpg',4),(53,'Marta 510',20,5.1,2.12,180,16.732284,6.9553808,396.8316,'./FotoNatanti/Marta 510.jpg',4),(55,'DART 16',1,NULL,0,0,0,0,0,'',4),(56,'Classe A',22,5.49,2.3,75,18.0118116,7.545932,165.3465,'./FotoNatanti/Class A.jpg',4),(57,'Tornado',19,5.84,3.08,140,19.160105599999998,10.1049872,308.6468,'./FotoNatanti/Tornado.jpg',4),(58,'Mattia 18',19,5.52,2.6,180,18.1102368,8.530184,396.8316,'./FotoNatanti/Mattia 18.jpg',4),(60,'Nacra 17',22,5.2,2.59,140,17.060368,8.4973756,308.6468,'./FotoNatanti/Nacra 17.jpg',4),(61,'Laser 4.7',30,4.1,1.39,59,13.451444,4.5603676,130.07258,'./FotoNatanti/Laser 470.jpg',4),(62,'Laser standard',30,4.1,1.39,59,13.451444,4.5603676,130.07258,'./FotoNatanti/Laser.jpg',4),(63,'Laser radial',30,4.1,1.39,59,13.451443999999999,4.560367599999999,130.07258,'./FotoNatanti/Laser radial.jpg',4),(64,'Sunfish',33,4.6,1.2,54.4,15.091864,3.9370079999999996,119.93132799999998,'./FotoNatanti/SunFish.jpg',4),(65,'FJ (Flying Junor)',30,4.04,1.5,91,13.2545936,4.92126,200.62042236328,'./FotoNatanti/FJ.jpg',4),(66,'FD (Flyng Dutchman)',34,6.1,1.7,165,20.013123999999998,5.577427999999999,363.7623,'./FotoNatanti/FD.jpg',4),(67,'Finn',32,4.5,1.51,119,14.763779640198,4.9540684,262.34977999999995,'./FotoNatanti/Finn.jpg',4),(68,'Trident 16',33,5,1.92,210,16.40419960022,6.299212799999999,462.9702,'./FotoNatanti/Trident 16.jpg',4),(69,'Snipe',33,4.72,1.52,173,15.485564799999999,4.9868768,381.39925999999997,'./FotoNatanti/Snipe.jpg',4),(70,'Hobie 14',21,4.25,2.34,242.5,13.943570137024,7.6771655999999995,534.6203499999999,'./FotoNatanti/Hobie 14.jpg',4),(71,'Hobie 15',20,4.95,2.26,155,16.240158,7.414698399999999,341.7161,'./FotoNatanti/Hobie15.jpg',4),(72,'Hobie 16',20,5.1,2.4,155,16.732284,7.874015999999999,341.7161,'./FotoNatanti/Hobie 16.jpg',4),(73,'Tiger',19,5.51,2.6,180,18.0774284,8.530184,396.8316,'./FotoNatanti/Tiger.jpg',4),(74,'Wild cat',20,5.46,2.59,180,17.9133864,8.4973756,396.8316,'./FotoNatanti/Wild cat.jpg',4),(75,'Twixxy',21,4.38,2.23,139,14.3700792,7.3162731999999995,306.44217999999995,'./FotoNatanti/Twixxy.jpg',4),(76,'Dragon',23,3.9,2.2,114,12.795276,7.217848000000001,251.32667999999998,'./FotoNatanti/Dragoon.jpg',4),(77,'-------',23,0,0,0,0,0,0,'',4),(86,'Nacra F18',19,5.486400000000001,2.5908,180.238,18,8.5,397,'./FotoNatanti/nacra f18.jpg',4);
/*!40000 ALTER TABLE `natante` 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 2021-10-05 14:58:12