--
-- Host: localhost    Database: blueco_fleet_manager
-- ------------------------------------------------------


--
-- Table structure for table `ship`
--

CREATE TABLE `ship` (
  `ship_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `eni_number` int(11) DEFAULT NULL,
  `obm_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `api_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `engine_p_id` int(10) unsigned DEFAULT NULL,
  `engine_s_id` int(10) unsigned DEFAULT NULL,
  `category_id` int(10) unsigned DEFAULT NULL,
  `max_tonnage` int(10) unsigned DEFAULT '0',
  `is_deleted` tinyint(1) DEFAULT '0',
  `usage_green_min_lh` float unsigned DEFAULT '0',
  `usage_orange_min_lh` float unsigned DEFAULT '0',
  `usage_red_min_lh` float unsigned DEFAULT '0',
  `usage_green_min_ltonkm` float DEFAULT '0',
  `usage_orange_min_ltonkm` float DEFAULT '0',
  `usage_red_min_ltonkm` float DEFAULT '0',
  `imo_registration` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `construction_year` smallint(6) unsigned DEFAULT NULL,
  `rated_power_kwh` int(10) unsigned NOT NULL,
  `rated_speed_rpm` int(11) unsigned NOT NULL,
  `ship_length_cm` int(11) unsigned NOT NULL,
  `ship_width_cm` int(11) unsigned NOT NULL,
  `max_draft_cm` int(11) unsigned NOT NULL,
  `cargo_type` int(11) unsigned NOT NULL,
  `empty_weight_ton` double DEFAULT '0',
  `kwh_formula` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `save_for_ilt` tinyint(4) NOT NULL DEFAULT '0',
  `has_teu` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`ship_id`),
  UNIQUE KEY `raspberry_id_UNIQUE` (`obm_id`),
  UNIQUE KEY `api_key` (`api_key`),
  KEY `fk_ship_company1_idx` (`company_id`),
  KEY `fk_ship_engine1_idx` (`engine_p_id`),
  KEY `fk_ship_shipcategory1_idx` (`category_id`),
  KEY `fk_ship_engine2_idx` (`engine_s_id`),
  CONSTRAINT `fk_ship_company1` FOREIGN KEY (`company_id`) REFERENCES `company` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_ship_shipcategory1` FOREIGN KEY (`category_id`) REFERENCES `shipcategory` (`category_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT `ship_ibfk_1` FOREIGN KEY (`engine_p_id`) REFERENCES `engine` (`engine_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT `ship_ibfk_2` FOREIGN KEY (`engine_s_id`) REFERENCES `engine` (`engine_id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ship`
--

INSERT INTO `ship` VALUES (1,'Frisian Hopper',NULL,'0000000059c27625','l4gHRmCdDwbBURgQGorp7YpvpmYsAk09',4,2,2,NULL,1500,0,0,40,70,0,100,200,'244660395',NULL,298,1800,8000,1000,250,1,0,NULL,0,0),(2,'Imperial Gas 74',NULL,'00000000a6e7fbc3','hBQwvh9x4lymx32xM1',3,4,4,NULL,1131,0,0,50,150,0,4,8,'4008290',NULL,634,1940,8500,1140,250,2,0,'',0,0),(4,'Ms Flora',NULL,'00000000fc2e0ea2','lQw4JZ7D7MNdkQGdAzL1og6tRGD0Ea4',5,8,NULL,NULL,575,0,0,40,60,4,8,12,'3340157',NULL,294,1200,5500,660,245,1,215,'0.0000001729*RPM*RPM*RPM',0,0),(5,'Testschip nieuw',NULL,'123','ZkttqVjYaWPymXXGJ5Lpa',2,NULL,NULL,NULL,NULL,0,5,10,20,5,10,20,'456',NULL,789,123,456,789,10,2,0,NULL,0,0),(6,'Volkerak',NULL,'DELETED_2016030_000000003208336a','xkJdfLnWC1kESor1UO',6,2,NULL,NULL,575,1,0,20,40,0,4,8,'1',NULL,1,1,1,1,1,0,0,NULL,0,0),(7,'Ms Jolien',NULL,'00000000789b4a17','5Gpi_PQT2L77g9vRcYLsx5V0gDzO8_2',7,3,NULL,NULL,2083,0,0,80,130,0,2,3,'4805300',NULL,808,375,1050,952,297,1,603,'',0,0),(8,'Ms Hendrika',NULL,'00000000538ba028','CEMJs5s-hV5K8Bba7Mi3SHmao',8,5,NULL,NULL,3163,0,0,70,100,0,2,4,'02326642',NULL,1119,1600,11000,1145,355,1,850,'0.0000003*RPM*RPM*RPM-0.00003*RPM*RPM+0.0005*RPM+0.1631',1,0),(9,'Ms Aqua-Myra',NULL,'000000007b019b16','wR9Pn3ZqDbTWvC2hryk0JIR8D2IVqQ',9,6,NULL,NULL,3168,0,0,150,300,0,10,15,'2319046',NULL,1491,1600,11000,1139,372,5,950,'',0,1),(10,'Mt Leidsegracht',NULL,'00000000f53b1307','85xqKFsUtzneGQhDWlSIaM',10,7,NULL,NULL,465,0,0,56,65,0,7,8,'2312117',NULL,349,1835,5350,660,258,2,360,'0.000000046*pow(RPM, 3.0067)',0,0),(11,'Ms Keimpe',NULL,'000000005f86955a','vnNuyqJ16oRNgJQCX',11,10,NULL,NULL,858,0,0,50,100,0,4,6,'2103571',NULL,410,1800,6000,792,325,1,173,'(0.0000000955*pow(RPM,2.996))/1.341',0,0),(12,'Ms Sensation',NULL,'0000000042ca2e81','tBqSLBcpXxPnqSW9Ln3UX5',12,11,11,NULL,5008,0,0,150,300,0,3,6,'2326239',NULL,1400,1600,13500,1710,335,5,1710,'0.000000443*RPM*RPM*RPM-0.000293*RPM*RPM+0.2452*RPM-57.1814',0,1),(13,'Ms Sensation SB',NULL,'000000007fde2933','6O5PCnpIi0TSpnoK',12,11,NULL,NULL,5008,1,0,100,200,0,3,6,'2326239',NULL,1400,1600,13500,1710,335,5,1710,'0.000000443*RPM*RPM*RPM-0.000293*RPM*RPM+0.2452*RPM-57.1814',0,0),(14,'Testopstelling Econosto',NULL,'000000002033f5f1','-51zKGVa0ZFJKPA2X2cmNHTGfe_egi',13,3,3,NULL,0,0,0,2,4,0,2,4,'0',NULL,0,0,0,0,0,0,0,'',0,0),(15,'Ms Condor',NULL,'0000000006e86911','PFDo8kYM24v9f6v5MtpPEITSFCgra',15,9,9,NULL,3050,0,0,50,75,0,2,4,'2317585',NULL,441,1600,11000,1140,337,1,600,'0.00000009*pow(RPM,3.0231)',0,0),(16,'Ms Westerschelde',NULL,'000000008416916d','OhnqxZ-ANQvvwc_6XJ-a',6,12,12,NULL,1000,0,0,50,100,0,2,4,'2324612',NULL,365,1800,6397,1555,240,4,820,'',0,0),(17,'Test vessel Couach',NULL,'0000000024182fa6','V_Pw2jRiUS6pqVPW4KHQbx',16,11,NULL,NULL,50,0,0,50,100,0,4,8,'1',NULL,1,1,1,1,1,3,1,'',0,0),(18,'Ms Independent SB',NULL,'0000000082e27992','E7D3QFAxm12dNOV68kbKze',17,5,NULL,NULL,5061,1,0,75,150,0,4,6,'02322924',NULL,1249,1600,17160,1140,340,1,1500,'0.000000305*RPM*RPM*RPM',0,0),(19,'Ms Independent',NULL,'00000000c1063dc1','m5lpl0Pw2Rt-Och5m',17,5,5,NULL,5616,0,0,75,150,0,4,6,'02322924',NULL,1249,1600,17160,1140,340,1,1500,'0.000000305*RPM*RPM*RPM',0,0),(20,'Ms Fossa',NULL,'00000000dcb81b16','Bsscg26Lwn8AXb_C6ZGrNnEnfed',18,13,NULL,NULL,1169,0,0,50,100,0,2,4,'2315889',NULL,691,1800,7996,820,269,1,395,'0.0000001185*RPM*RPM*RPM',0,0),(21,'Ms Zagri 15',NULL,'00000000ccfb6343','wej1OnSYJPSUTo-PzxZI',19,10,NULL,NULL,1378,0,0,50,75,0,4,6,'2311615',NULL,500,1800,7300,858,325,1,475,'0.0000000858*RPM*RPM*RPM',0,0),(22,'Ms Kilstroom',NULL,'00000000cbe8e1e1','0wry66VKnm840lIMTWThHGBOo50zwF1',20,14,NULL,NULL,2502,0,0,75,150,0,4,8,'2325856',NULL,1109,1000,10500,1050,316,1,700,'0.00000111*RPM*RPM*RPM',0,0),(23,'Ms Max Kern',NULL,'0000000053230424','g9w0i6_E2oJyVs0cy5jU50ff',17,15,15,NULL,5262,0,0,75,150,0,4,6,'02331553',NULL,970,1800,17196,1145,357,1,1503,'0.0011*FUEL*FUEL+3.7861*FUEL',0,0),(24,'Ms Max Kern SB',NULL,'00000000496e1c7a','1SGlT5kYwzxkm0Wdi7Nif19jKzeCKb',17,15,NULL,NULL,5262,1,0,75,150,0,4,6,'02331553',NULL,970,1800,17196,1145,357,1,1503,'0.0011*FUEL*FUEL+3.7861*FUEL',0,0),(25,'Ms For-Ever',NULL,'00000000985cd9d5','_HTi_nb5sP7NQev_XHihS8TjttBV-4tf',22,16,16,NULL,1883,0,0,70,80,0,2,3,'02334650',NULL,386,1800,9000,1050,300,5,650,'-0.00000007257*RPM*RPM*RPM+0.0001456*RPM*RPM+0.1856*RPM',0,1),(26,'Mt Schippersgracht',NULL,'00000000826b3864','082TXWTMFfOlr64gkp',10,17,NULL,NULL,500,0,0,50,75,0,4,6,'02315154',NULL,368,1800,5500,660,239,2,335,'',0,0),(27,'Test environment Testo Germany',NULL,'00000000b80f8966','-HruKezvk6AM8btncGcHfR6DQBAI',1,2,NULL,NULL,1,0,0,0,0,0,0,0,'1',NULL,1,1,1,1,1,0,1,'',0,0),(28,'Mt Keizersgracht',NULL,'000000002d006c75','qmlXGD8Y6fUhcyKAtBhxzbS',10,18,NULL,NULL,620,0,0,50,75,0,5,7,'02205324',NULL,358,1800,5514,720,272,2,420,'',0,0),(29,'RPI-dev-full',NULL,'00000000a69d604f','fIFUoanYsduY5_q8lCtPlMazTl',1,2,2,NULL,1000,0,0,6,12,0,6,12,'1',NULL,1,1,1,1,1,1,1,'',0,0),(30,'Mts Louisa',NULL,'0000000053e86105','1zq-nD0t0vYoaKzef5qMXI2dGz0l',23,19,NULL,NULL,2772,0,0,50,75,0,3,6,'02337033',NULL,1029,1600,11000,1145,365,2,1200,'0.000000255*RPM*RPM*RPM',0,0),(31,'RPI-dev-MTU',NULL,'0000000091736ece','WfECi17SMzzUXaIxCtdL7',1,11,NULL,NULL,1,0,0,2,4,0,5,10,'1',NULL,1,1,1,1,1,0,1,'',0,0),(32,'RPI-dev-Testo',NULL,'00000000a712b83b','ye8Gj51QfZnnPinSII5Hyv4fq9Nw',1,2,NULL,NULL,1000,0,0,40,60,0,4,6,'1',NULL,1,1,1,11,1,1,1,'',0,0),(33,'Mts Calamus',NULL,'00000000de16d3e9','ZW5eesYtQXlHCQ9w_JvuDmb7Q6czoC5R',25,5,NULL,NULL,2408,0,0,150,200,0,3,6,'02325966',NULL,1014,1600,9000,1150,362,2,850,'',0,0),(34,'Testbank MPD',NULL,'0000000068016c59','FosDoaXmzKacLjB41_',23,19,NULL,NULL,1,0,0,1,2,0,1,2,'1',NULL,1,1,1,1,1,1,1,'',0,0);

--
-- Table structure for table `ship_config`
--

CREATE TABLE `ship_config` (
  `ship_id` int(10) unsigned NOT NULL,
  `config_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ship_id`,`config_key`),
  CONSTRAINT `ship_config_ibfk_1` FOREIGN KEY (`ship_id`) REFERENCES `ship` (`ship_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ship_config`
--

INSERT INTO `ship_config` VALUES (1,'FLOWMETER_TYPE','blueco'),(1,'GPS_TYPE','GPRMC'),(1,'OBM_ENGINE_SOURCE','sensor'),(2,'FLOWMETER_TYPE','external'),(2,'GPS_TYPE','GPRMC'),(2,'OBM_ENGINE_SOURCE','sensor'),(4,'FLOWMETER_TYPE','blueco'),(4,'GPS_TYPE','GPRMC'),(4,'OBM_ENGINE_SOURCE','sensor'),(5,'FLOWMETER_TYPE','blueco'),(5,'GPS_TYPE','GPGGA'),(5,'OBM_ENGINE_SOURCE','sensor'),(6,'FLOWMETER_TYPE','blueco'),(6,'GPS_TYPE','GPRMC'),(6,'OBM_ENGINE_SOURCE','sensor'),(7,'FLOWMETER_TYPE','blueco'),(7,'GPS_TYPE','GPRMC'),(7,'OBM_ENGINE_SOURCE','sensor'),(8,'FLOWMETER_TYPE','blueco'),(8,'GPS_TYPE','GPRMC'),(8,'OBM_ENGINE_SOURCE','engine'),(9,'FLOWMETER_TYPE','blueco'),(9,'GPS_TYPE','GPRMC'),(9,'OBM_ENGINE_SOURCE','sensor'),(10,'FLOWMETER_TYPE','blueco'),(10,'GPS_TYPE','GPRMC'),(10,'OBM_ENGINE_SOURCE','sensor'),(11,'FLOWMETER_TYPE','blueco'),(11,'GPS_TYPE','GPRMC'),(11,'OBM_ENGINE_SOURCE','sensor'),(12,'FLOWMETER_TYPE','blueco'),(12,'GPS_TYPE','GPRMC'),(12,'OBM_ENGINE_SOURCE','engine'),(13,'FLOWMETER_TYPE','blueco'),(13,'GPS_TYPE','GPRMC'),(13,'OBM_ENGINE_SOURCE','engine'),(14,'FLOWMETER_TYPE','blueco'),(14,'GPS_TYPE','GPRMC'),(14,'OBM_ENGINE_SOURCE','sensor'),(15,'FLOWMETER_TYPE','blueco'),(15,'GPS_TYPE','GPRMC'),(15,'OBM_ENGINE_SOURCE','sensor'),(16,'FLOWMETER_TYPE','blueco'),(16,'GPS_TYPE','GPRMC'),(16,'OBM_ENGINE_SOURCE','sensor'),(17,'FLOWMETER_TYPE','engine'),(17,'GPS_TYPE','GPGGA'),(17,'OBM_ENGINE_SOURCE','engine'),(18,'FLOWMETER_TYPE','engine'),(18,'GPS_TYPE','GPRMC'),(18,'OBM_ENGINE_SOURCE','engine'),(19,'FLOWMETER_TYPE','blueco'),(19,'GPS_TYPE','GPRMC'),(19,'OBM_ENGINE_SOURCE','engine'),(20,'FLOWMETER_TYPE','blueco'),(20,'GPS_TYPE','GPRMC'),(20,'OBM_ENGINE_SOURCE','sensor'),(21,'FLOWMETER_TYPE','external'),(21,'GPS_TYPE','GPRMC'),(21,'OBM_ENGINE_SOURCE','sensor'),(22,'FLOWMETER_TYPE','blueco'),(22,'GPS_TYPE','GPRMC'),(22,'OBM_ENGINE_SOURCE','sensor'),(23,'FLOWMETER_TYPE','blueco'),(23,'GPS_TYPE','GPRMC'),(23,'OBM_ENGINE_SOURCE','engine'),(24,'FLOWMETER_TYPE','blueco'),(24,'GPS_TYPE','GPRMC'),(24,'OBM_ENGINE_SOURCE','engine'),(25,'FLOWMETER_TYPE','blueco'),(25,'GPS_TYPE','GPRMC'),(25,'OBM_ENGINE_SOURCE','engine'),(26,'FLOWMETER_TYPE','engine'),(26,'GPS_TYPE','GPRMC'),(26,'OBM_ENGINE_SOURCE','engine'),(27,'FLOWMETER_TYPE','blueco'),(27,'GPS_TYPE','GPRMC'),(27,'OBM_ENGINE_SOURCE','sensor'),(28,'FLOWMETER_TYPE','blueco'),(28,'GPS_TYPE','GPRMC'),(28,'OBM_ENGINE_SOURCE','sensor'),(29,'FLOWMETER_TYPE','blueco'),(29,'GPS_TYPE','GPRMC'),(29,'OBM_ENGINE_SOURCE','sensor'),(30,'FLOWMETER_TYPE','engine'),(30,'GPS_TYPE','GPRMC'),(30,'OBM_ENGINE_SOURCE','engine'),(31,'FLOWMETER_TYPE','blueco'),(31,'GPS_TYPE','GPRMC'),(31,'OBM_ENGINE_SOURCE','engine'),(32,'FLOWMETER_TYPE','blueco'),(32,'GPS_TYPE','GPRMC'),(32,'OBM_ENGINE_SOURCE','sensor'),(33,'FLOWMETER_TYPE','blueco'),(33,'GPS_TYPE','GPRMC'),(33,'OBM_ENGINE_SOURCE','engine'),(34,'FLOWMETER_TYPE','engine'),(34,'GPS_TYPE','GPRMC'),(34,'OBM_ENGINE_SOURCE','engine');

--
-- Table structure for table `ship_note`
--

CREATE TABLE `ship_note` (
  `trip_note_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` text COLLATE utf8_unicode_ci,
  `insert_date` datetime DEFAULT NULL,
  `ship_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`trip_note_id`),
  KEY `fk_trip_note_ship1_idx` (`ship_id`),
  KEY `insert_date_idx` (`insert_date`),
  KEY `insert_date_ship_idx` (`insert_date`,`ship_id`),
  CONSTRAINT `fk_trip_note_ship1` FOREIGN KEY (`ship_id`) REFERENCES `ship` (`ship_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ship_note`
--

INSERT INTO `ship_note` VALUES (1,'Test 1','2016-01-21 12:17:59',1),(2,'Test 2','2016-01-21 12:18:10',1),(3,'Test 3','2016-01-21 15:19:27',1),(4,'Test 4','2016-01-21 15:26:29',1),(5,'STILGELEGEN VAN 22:00 TOT 06:30 UUR.','2016-03-05 07:36:07',1),(6,'tik in motor','2016-03-25 11:19:47',7),(7,'test','2016-06-08 19:22:08',10),(8,'Eerste echte proeftrip','2016-06-30 13:58:52',4),(9,'Doet ´t niet','2016-07-02 13:08:22',4),(10,'Router doet ´t wel.<br>Kastje met hard en software kan ik niet in kijken. <br>Flowmeter led flits keurig elke seconde op 900 toeren met nu geladen schip. Dus waarschijnlijk een software matig probleem.','2016-07-02 13:22:15',4),(11,'Geen wijziging in foutive weergave verbruik','2016-07-03 05:58:56',4),(12,'GPS werkt ook niet, zowel positie als snelheid','2016-07-03 06:21:55',4),(13,'Vol aan op de D\'Kil. Geen uitlezing. Led op de Florwmeter doetl het keurig, nu 1 flash per 1/2 seconde, regelmatig.','2016-07-03 10:10:08',4),(14,'Opstarten nieuwe triep geeft ook geen resultaat.<br>','2016-07-03 10:14:34',4),(15,'de hele zaak moet gereset worden, maar hoe?','2016-07-03 13:22:00',4),(16,'Tour gestartet in Duisburg Km 784<br>Pegel Oestrich: 223','2016-07-13 16:59:04',2),(17,'Pegel Oestrich:  273','2016-07-16 06:12:01',2),(18,'Pegel Oestrich:  267 (-10)','2016-07-19 12:03:20',2),(19,'Pegel Oestrich: 267 ( -10 )<br>','2016-07-19 12:06:20',2),(20,'Pegel Oestrich: 254 ( -13 )','2016-07-20 12:08:43',2),(21,'Pegel Oestrich: 242 ( -12 )','2016-07-21 07:17:46',2),(22,'Pegel Oestrich: 242 ( -12 )','2016-07-21 07:17:56',2),(23,'Pegel Oestrich: 242 ( -12 )','2016-07-21 07:17:56',2),(24,'Pegel Oestrich: 242 ( -12 )','2016-07-21 07:17:57',2),(25,'Pegel Oestrich: 242 ( -12 )','2016-07-21 07:17:58',2),(26,'Pegel Oestrich : 243 (  1 )','2016-07-22 07:14:33',2),(27,'Pegel Oestrich: 233 (-10 )','2016-07-23 07:03:09',2),(28,'Pegel Oestrich : 246 (  13 )','2016-07-24 06:00:14',2),(29,'De Rpm zijn weer dol','2016-09-22 13:20:47',15),(30,'nix gut','2016-10-02 16:35:27',2),(31,'bij deze reis is het schip gelijk lastig geladen.<br>het stuurd moeilijk en het loopt slechter.<br>bij andere reizen laden we 10 cm voor over en dan loopt het schip beter weg dus meer snelheid','2016-11-30 07:21:04',10),(32,'met vloed mee dus voor stroom half geladen','2016-12-13 13:40:08',10),(33,'30-12-2016 Stuurboord motor geeft dubbele brandstof verbruik aan.<br>Omgevingsdruk staat altijd op 1013 HPA','2016-12-30 07:37:19',15),(34,'Trip   1       Wdam           Doel','2017-01-25 15:31:36',21),(35,'2017     2','2017-01-26 09:01:00',21),(36,'5    R Dam         Ravenswaaij','2017-02-02 05:48:00',21),(37,'Ravenswaaij           Heerewaarden','2017-02-02 08:47:35',21),(38,'6   2017    heerewaarden        Rdam','2017-02-02 14:03:19',21),(39,'Reis 7     Rdam    Doel    Leeg','2017-02-06 11:22:43',21),(40,'reis  8  Hedel  Heerew     Schravendeel','2017-02-07 12:32:56',21),(41,'2<br>','2017-02-27 15:40:13',11),(42,'diepte 7 meter','2017-02-28 04:36:02',11),(43,'diepte 6 meter<br>','2017-02-28 04:46:27',11),(44,'1620 max','2017-02-28 05:22:33',11),(45,'2 meter diep','2017-02-28 07:47:50',11),(46,'4 meter diepte','2017-02-28 08:11:50',11),(47,'diepte 2.50 meter','2017-02-28 08:22:55',11),(48,'diepte 2 meter','2017-02-28 08:29:22',11),(49,'1604 max','2017-02-28 08:33:10',11),(50,'met andere branstof gaan varen','2017-04-07 11:10:18',10),(51,'Op 09-04-2017 2773 ton containers bij geladen','2017-04-09 14:03:32',19),(52,'tonnen vergeten : tot liht oyen  was het 474','2017-04-12 09:12:42',10),(53,'geht nicht','2017-06-07 16:52:14',2),(54,'geht immer noch nicht','2017-06-07 16:52:39',2),(55,'leeg afvarig van de werf te heusden naar zwijndrecht om te bunkeren, aansluiten naar de geulhaven','2017-09-05 13:27:36',30),(56,'bij mpd de haven in voor ene korte instelling','2017-09-05 15:55:23',30),(57,'Neue Reise - Bergfahrt     Rotterdam-Worms   <br>Beladen mit 1300Ton        Tiefgang 208cm','2017-09-06 18:54:13',30),(58,'reise Rotterdam - Marl    mit   2000 Ton','2017-10-04 12:43:11',30),(59,'Reise Rotterdam - Frankfurt a/Main<br>mit 1500Ton','2017-10-07 18:42:01',30),(60,'uit val gehed','2017-11-16 14:56:56',10);

--
-- Table structure for table `ship_obm`
--

CREATE TABLE `ship_obm` (
  `ship_id` int(10) unsigned NOT NULL,
  `obm_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ship_id`,`obm_id`),
  KEY `fk_ship_module_module1_idx` (`obm_id`),
  KEY `fk_ship_module_ship1_idx` (`ship_id`),
  CONSTRAINT `fk_ship_module_module1` FOREIGN KEY (`obm_id`) REFERENCES `obm` (`obm_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_ship_module_ship1` FOREIGN KEY (`ship_id`) REFERENCES `ship` (`ship_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ship_obm`
--

INSERT INTO `ship_obm` VALUES (1,1),(2,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(2,2),(4,2),(5,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,2),(14,2),(15,2),(17,2),(18,2),(19,2),(20,2),(21,2),(22,2),(23,2),(24,2),(25,2),(26,2),(28,2),(29,2),(30,2),(31,2),(32,2),(33,2),(34,2),(4,3),(5,3),(8,3),(10,3),(11,3),(12,3),(13,3),(14,3),(15,3),(17,3),(18,3),(19,3),(20,3),(21,3),(22,3),(25,3),(27,3),(29,3),(30,3),(31,3),(32,3),(33,3);

--
-- Table structure for table `ship_user`
--

CREATE TABLE `ship_user` (
  `ship_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  KEY `ship_id` (`ship_id`,`user_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `ship_user_ibfk_1` FOREIGN KEY (`ship_id`) REFERENCES `ship` (`ship_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ship_user_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ship_user`
--

INSERT INTO `ship_user` VALUES (2,13),(2,35),(2,36),(4,48),(4,49),(8,25),(10,10),(10,12),(12,32),(13,32),(19,55),(23,40),(24,40),(25,44),(30,52),(30,53),(30,54);


