-- MySQL dump 10.16  Distrib 10.1.38-MariaDB, for debian-linux-gnueabihf (armv7l)
--
-- Host: localhost    Database: dbcerematic
-- ------------------------------------------------------
-- Server version	10.1.38-MariaDB-0+deb9u1

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

DROP TABLE IF EXISTS `cornflakes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cornflakes` (
  `cornflakesID` int(11) NOT NULL AUTO_INCREMENT,
  `naam` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`cornflakesID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cornflakes`
--

LOCK TABLES `cornflakes` WRITE;
/*!40000 ALTER TABLE `cornflakes` DISABLE KEYS */;
INSERT INTO `cornflakes` VALUES (4,'Honey Pops'),(5,'Choco Balls'),(6,'Honey Balls'),(7,'Nesquick Balls'),(8,'Tresors'),(9,'Lennert');
/*!40000 ALTER TABLE `cornflakes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `meting`
--

DROP TABLE IF EXISTS `meting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meting` (
  `metingID` int(11) NOT NULL AUTO_INCREMENT,
  `sensorID` int(11) DEFAULT NULL,
  `waarde` varchar(50) DEFAULT NULL,
  `datum` datetime DEFAULT NULL,
  `reservoirID` int(11) DEFAULT NULL,
  PRIMARY KEY (`metingID`),
  KEY `value_idx` (`waarde`),
  KEY `fk_sensor_idx` (`sensorID`),
  KEY `fk_cornflakes_idx` (`reservoirID`),
  CONSTRAINT `fk_reservoir` FOREIGN KEY (`reservoirID`) REFERENCES `reservoir` (`reservoirID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_sensor` FOREIGN KEY (`sensorID`) REFERENCES `sensor` (`sensorID`)
) ENGINE=InnoDB AUTO_INCREMENT=2046 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `meting`
--

LOCK TABLES `meting` WRITE;
/*!40000 ALTER TABLE `meting` DISABLE KEYS */;
INSERT INTO `meting` VALUES (1001,1,'29','2019-06-11 15:25:56',1),(1002,5,'Aanwezig','2019-06-11 15:31:45',1),(1003,3,'61.32%','2019-06-11 15:31:45',1),(1004,1,'0','2019-06-11 15:31:45',1),(1005,5,'Afwezig','2019-06-11 15:31:45',2),(1006,3,'60.86%','2019-06-11 15:31:45',2),(1007,1,'-89','2019-06-11 15:31:46',2),(1008,5,'Afwezig','2019-06-11 15:31:48',2),(1009,3,'61.09%','2019-06-11 15:31:48',2),(1010,1,'0','2019-06-11 15:31:48',2),(1011,5,'Aanwezig','2019-06-11 15:32:02',1),(1012,3,'60.82%','2019-06-11 15:32:02',1),(1013,1,'0','2019-06-11 15:32:02',1),(1014,5,'Afwezig','2019-06-11 15:32:02',2),(1015,3,'61.09%','2019-06-11 15:32:02',2),(1016,1,'0','2019-06-11 15:32:02',2),(1017,5,'Aanwezig','2019-06-11 15:32:17',1),(1018,3,'61.09%','2019-06-11 15:32:17',1),(1019,1,'0','2019-06-11 15:32:17',1),(1020,5,'Afwezig','2019-06-11 15:32:18',2),(1021,3,'60.86%','2019-06-11 15:32:18',2),(1022,1,'0','2019-06-11 15:32:18',2),(1023,5,'Aanwezig','2019-06-11 15:32:23',1),(1024,3,'61.5%','2019-06-11 15:32:23',1),(1025,1,'0','2019-06-11 15:32:23',1),(1026,5,'Aanwezig','2019-06-11 15:32:32',1),(1027,3,'61.23%','2019-06-11 15:32:32',1),(1028,1,'0','2019-06-11 15:32:32',1),(1029,5,'Afwezig','2019-06-11 15:32:39',2),(1030,3,'60.95%','2019-06-11 15:32:39',2),(1031,1,'0','2019-06-11 15:32:39',2),(1032,5,'Afwezig','2019-06-11 15:32:45',2),(1033,3,'61.41%','2019-06-11 15:32:45',2),(1034,1,'0','2019-06-11 15:32:45',2),(1035,5,'Aanwezig','2019-06-11 15:32:54',1),(1036,3,'61.5%','2019-06-11 15:32:54',1),(1037,1,'0','2019-06-11 15:32:54',1),(1038,5,'Aanwezig','2019-06-11 15:34:06',1),(1039,3,'61.05%','2019-06-11 15:34:06',1),(1040,1,'0','2019-06-11 15:34:06',1),(1041,5,'Afwezig','2019-06-11 15:34:07',2),(1042,3,'60.77%','2019-06-11 15:34:07',2),(1043,1,'26','2019-06-11 15:34:07',2),(1044,5,'Aanwezig','2019-06-11 15:34:11',1),(1045,3,'61.64%','2019-06-11 15:34:11',1),(1046,1,'0','2019-06-11 15:34:11',1),(1047,5,'Afwezig','2019-06-11 15:34:15',2),(1048,3,'60.41%','2019-06-11 15:34:15',2),(1049,1,'0','2019-06-11 15:34:16',2),(1050,5,'Aanwezig','2019-06-11 15:34:41',1),(1051,3,'61.41%','2019-06-11 15:34:42',1),(1052,1,'0','2019-06-11 15:34:42',1),(1053,5,'Aanwezig','2019-06-11 15:34:43',1),(1054,3,'61.45%','2019-06-11 15:34:43',1),(1055,1,'0','2019-06-11 15:34:43',1),(1056,5,'Aanwezig','2019-06-11 15:34:51',1),(1057,3,'61.41%','2019-06-11 15:34:51',1),(1058,1,'0','2019-06-11 15:34:51',1),(1059,5,'Afwezig','2019-06-11 15:34:54',2),(1060,3,'60.86%','2019-06-11 15:34:54',2),(1061,1,'0','2019-06-11 15:34:54',2),(1062,5,'Aanwezig','2019-06-11 15:35:04',1),(1063,3,'62.0%','2019-06-11 15:35:04',1),(1064,1,'0','2019-06-11 15:35:04',1),(1065,5,'Afwezig','2019-06-11 15:35:08',2),(1066,3,'61.32%','2019-06-11 15:35:08',2),(1067,1,'0','2019-06-11 15:35:08',2),(1068,5,'Aanwezig','2019-06-11 15:36:29',1),(1069,3,'61.32%','2019-06-11 15:36:29',1),(1070,1,'0','2019-06-11 15:36:29',1),(1071,5,'Aanwezig','2019-06-11 15:36:36',1),(1072,3,'61.14%','2019-06-11 15:36:36',1),(1073,1,'0','2019-06-11 15:36:36',1),(1074,5,'Aanwezig','2019-06-11 15:48:36',2),(1075,3,'64.32%','2019-06-11 15:48:36',2),(1076,1,'0','2019-06-11 15:48:36',2),(1077,5,'Afwezig','2019-06-11 15:48:42',1),(1078,3,'61.41%','2019-06-11 15:48:42',1),(1079,1,'0','2019-06-11 15:48:42',1),(1080,5,'Afwezig','2019-06-11 16:25:58',1),(1081,3,'61.55%','2019-06-11 16:25:58',1),(1082,1,'0','2019-06-11 16:25:58',1),(1083,5,'Afwezig','2019-06-11 16:55:02',1),(1084,3,'52.05%','2019-06-11 16:55:02',1),(1085,1,'0','2019-06-11 16:55:02',1),(1086,5,'Afwezig','2019-06-11 16:55:24',1),(1087,3,'50.77%','2019-06-11 16:55:24',1),(1088,1,'0','2019-06-11 16:55:24',1),(1089,5,'Afwezig','2019-06-11 16:55:28',2),(1090,3,'64.73%','2019-06-11 16:55:28',2),(1091,1,'0','2019-06-11 16:55:28',2),(1092,5,'Afwezig','2019-06-11 16:55:58',1),(1093,3,'50.55%','2019-06-11 16:55:58',1),(1094,1,'0','2019-06-11 16:55:58',1),(1095,5,'Afwezig','2019-06-11 16:56:05',2),(1096,3,'64.91%','2019-06-11 16:56:06',2),(1097,1,'0','2019-06-11 16:56:06',2),(1098,5,'Afwezig','2019-06-11 16:56:07',2),(1099,3,'64.45%','2019-06-11 16:56:07',2),(1100,1,'0','2019-06-11 16:56:07',2),(1101,5,'Afwezig','2019-06-11 16:56:11',2),(1102,3,'64.05%','2019-06-11 16:56:11',2),(1103,1,'-100','2019-06-11 16:56:11',2),(1104,5,'Afwezig','2019-06-11 16:56:16',2),(1105,3,'64.18%','2019-06-11 16:56:16',2),(1106,5,'Afwezig','2019-06-11 16:56:16',2),(1107,1,'-2285','2019-06-11 16:56:16',2),(1108,3,'62.5%','2019-06-11 16:56:16',2),(1109,1,'-262','2019-06-11 16:56:16',2),(1110,5,'Afwezig','2019-06-11 16:56:29',1),(1111,3,'50.95%','2019-06-11 16:56:29',1),(1112,1,'0','2019-06-11 16:56:29',1),(1113,5,'Afwezig','2019-06-11 16:56:31',2),(1114,3,'64.5%','2019-06-11 16:56:31',2),(1115,1,'0','2019-06-11 16:56:31',2),(1116,5,'Afwezig','2019-06-11 16:56:44',1),(1117,3,'50.73%','2019-06-11 16:56:44',1),(1118,1,'0','2019-06-11 16:56:44',1),(1119,5,'Afwezig','2019-06-11 17:01:35',1),(1120,3,'50.14%','2019-06-11 17:01:35',1),(1121,1,'0','2019-06-11 17:01:35',1),(1122,5,'Afwezig','2019-06-12 12:38:26',1),(1123,5,'Aanwezig','2019-06-12 12:38:26',2),(1124,3,'63.91%','2019-06-12 12:38:26',1),(1125,3,'60.36%','2019-06-12 12:38:27',2),(1126,1,'0','2019-06-12 12:38:27',1),(1127,1,'0','2019-06-12 12:38:27',2),(1128,5,'Aanwezig','2019-06-12 12:38:30',2),(1129,3,'58.55%','2019-06-12 12:38:30',2),(1130,1,'0','2019-06-12 12:38:31',2),(1131,5,'Afwezig','2019-06-12 13:02:54',1),(1132,3,'58.5%','2019-06-12 13:02:54',1),(1133,1,'0','2019-06-12 13:02:54',1),(1134,5,'Aanwezig','2019-06-12 13:12:38',1),(1135,3,'58.73%','2019-06-12 13:12:38',1),(1136,1,'0','2019-06-12 13:12:38',1),(1137,5,'Aanwezig','2019-06-12 13:12:47',2),(1138,3,'58.09%','2019-06-12 13:12:47',2),(1139,1,'0','2019-06-12 13:12:47',2),(1140,5,'Aanwezig','2019-06-12 13:16:22',1),(1141,3,'60.5%','2019-06-12 13:16:22',1),(1142,1,'0','2019-06-12 13:16:22',1),(1143,5,'Aanwezig','2019-06-12 13:16:40',1),(1144,3,'58.32%','2019-06-12 13:16:40',1),(1145,1,'0','2019-06-12 13:16:40',1),(1146,5,'Aanwezig','2019-06-12 13:17:06',1),(1147,3,'36.18%','2019-06-12 13:17:06',1),(1148,1,'13','2019-06-12 13:17:06',1),(1149,5,'Aanwezig','2019-06-12 13:17:11',1),(1150,3,'36.45%','2019-06-12 13:17:11',1),(1151,1,'13','2019-06-12 13:17:11',1),(1152,5,'Aanwezig','2019-06-12 13:17:13',1),(1153,3,'36.32%','2019-06-12 13:17:13',1),(1154,1,'13','2019-06-12 13:17:13',1),(1155,5,'Aanwezig','2019-06-12 13:17:25',1),(1156,3,'47.77%','2019-06-12 13:17:25',1),(1157,1,'27','2019-06-12 13:17:25',1),(1158,5,'Aanwezig','2019-06-12 13:17:27',1),(1159,3,'47.5%','2019-06-12 13:17:27',1),(1160,1,'27','2019-06-12 13:17:27',1),(1161,5,'Aanwezig','2019-06-12 13:17:30',1),(1162,3,'47.5%','2019-06-12 13:17:30',1),(1163,1,'27','2019-06-12 13:17:30',1),(1164,5,'Aanwezig','2019-06-12 13:17:32',1),(1165,3,'47.05%','2019-06-12 13:17:33',1),(1166,1,'27','2019-06-12 13:17:33',1),(1167,5,'Aanwezig','2019-06-12 13:17:34',1),(1168,3,'47.36%','2019-06-12 13:17:34',1),(1169,1,'27','2019-06-12 13:17:34',1),(1170,5,'Aanwezig','2019-06-12 13:25:58',1),(1171,3,'60.05%','2019-06-12 13:25:58',1),(1172,1,'0','2019-06-12 13:25:58',1),(1173,5,'Aanwezig','2019-06-12 13:26:05',2),(1174,3,'54.41%','2019-06-12 13:26:05',2),(1175,1,'0','2019-06-12 13:26:05',2),(1176,5,'Aanwezig','2019-06-12 13:26:21',2),(1177,3,'65.64%','2019-06-12 13:26:21',2),(1178,1,'75','2019-06-12 13:26:21',2),(1179,5,'Aanwezig','2019-06-12 13:26:28',2),(1180,3,'63.5%','2019-06-12 13:26:28',2),(1181,1,'74','2019-06-12 13:26:28',2),(1182,5,'Aanwezig','2019-06-12 13:26:30',2),(1183,3,'64.0%','2019-06-12 13:26:30',2),(1184,1,'74','2019-06-12 13:26:30',2),(1185,5,'Aanwezig','2019-06-12 13:26:32',2),(1186,3,'63.27%','2019-06-12 13:26:32',2),(1187,1,'74','2019-06-12 13:26:32',2),(1188,5,'Aanwezig','2019-06-12 13:26:56',1),(1189,3,'93.5%','2019-06-12 13:26:56',1),(1190,1,'0','2019-06-12 13:26:56',1),(1191,5,'Afwezig','2019-06-12 13:26:59',2),(1192,3,'59.36%','2019-06-12 13:27:00',2),(1193,1,'-7','2019-06-12 13:27:00',2),(1194,5,'Afwezig','2019-06-12 13:27:05',2),(1195,3,'59.09%','2019-06-12 13:27:05',2),(1196,1,'1122','2019-06-12 13:27:05',2),(1197,5,'Aanwezig','2019-06-12 13:43:32',1),(1198,3,'60.18%','2019-06-12 13:43:32',1),(1199,1,'0','2019-06-12 13:43:32',1),(1200,5,'Aanwezig','2019-06-12 13:43:51',2),(1201,3,'61.73%','2019-06-12 13:43:51',2),(1202,1,'0','2019-06-12 13:43:51',2),(1203,5,'Aanwezig','2019-06-12 13:44:02',2),(1204,3,'61.86%','2019-06-12 13:44:02',2),(1205,1,'21','2019-06-12 13:44:02',2),(1206,5,'Aanwezig','2019-06-12 13:44:07',1),(1207,3,'89.82%','2019-06-12 13:44:07',1),(1208,1,'16','2019-06-12 13:44:07',1),(1209,5,'Aanwezig','2019-06-12 13:44:09',1),(1210,3,'93.0%','2019-06-12 13:44:09',1),(1211,1,'16','2019-06-12 13:44:09',1),(1212,5,'Aanwezig','2019-06-12 13:44:11',2),(1213,3,'61.91%','2019-06-12 13:44:11',2),(1214,1,'0','2019-06-12 13:44:11',2),(1215,5,'Aanwezig','2019-06-12 13:47:06',1),(1216,3,'86.59%','2019-06-12 13:47:06',1),(1217,1,'0','2019-06-12 13:47:06',1),(1218,5,'Aanwezig','2019-06-12 13:48:23',1),(1219,3,'59.86%','2019-06-12 13:48:23',1),(1220,1,'0','2019-06-12 13:48:23',1),(1221,5,'Aanwezig','2019-06-12 13:48:25',1),(1222,3,'88.77%','2019-06-12 13:48:25',1),(1223,1,'0','2019-06-12 13:48:25',1),(1224,5,'Aanwezig','2019-06-12 13:48:31',2),(1225,3,'61.5%','2019-06-12 13:48:31',2),(1226,1,'0','2019-06-12 13:48:31',2),(1227,5,'Aanwezig','2019-06-12 13:48:31',2),(1228,3,'61.36%','2019-06-12 13:48:31',2),(1229,1,'-10','2019-06-12 13:48:31',2),(1230,5,'Aanwezig','2019-06-12 13:48:37',1),(1231,3,'60.23%','2019-06-12 13:48:37',1),(1232,1,'0','2019-06-12 13:48:37',1),(1233,5,'Aanwezig','2019-06-12 13:48:38',1),(1234,3,'86.23%','2019-06-12 13:48:38',1),(1235,1,'0','2019-06-12 13:48:38',1),(1236,5,'Aanwezig','2019-06-12 13:48:39',1),(1237,3,'85.68%','2019-06-12 13:48:39',1),(1238,1,'-13','2019-06-12 13:48:39',1),(1239,5,'Aanwezig','2019-06-12 13:56:19',1),(1240,3,'89.09%','2019-06-12 13:56:20',1),(1241,5,'Aanwezig','2019-06-12 13:56:20',1),(1242,3,'80.32%','2019-06-12 13:56:21',1),(1243,5,'Aanwezig','2019-06-12 13:56:22',1),(1244,1,'0','2019-06-12 13:56:22',1),(1245,3,'89.68%','2019-06-12 13:56:23',1),(1246,5,'Aanwezig','2019-06-12 13:56:24',1),(1247,1,'0','2019-06-12 13:56:24',1),(1248,1,'0','2019-06-12 13:56:24',1),(1249,3,'89.55%','2019-06-12 13:56:26',1),(1250,5,'Aanwezig','2019-06-12 13:56:27',1),(1251,5,'Aanwezig','2019-06-12 13:59:06',1),(1252,3,'59.5%','2019-06-12 13:59:08',1),(1253,1,'248','2019-06-12 13:59:12',1),(1254,5,'Aanwezig','2019-06-12 13:59:16',2),(1255,3,'61.95%','2019-06-12 13:59:21',2),(1256,1,'-9','2019-06-12 13:59:25',2),(1257,5,'Aanwezig','2019-06-12 14:00:39',1),(1258,3,'57.73%','2019-06-12 14:00:40',1),(1259,1,'248','2019-06-12 14:00:42',1),(1260,5,'Aanwezig','2019-06-12 14:01:41',1),(1261,3,'57.91%','2019-06-12 14:01:41',1),(1262,1,'0','2019-06-12 14:01:41',1),(1263,5,'Aanwezig','2019-06-12 14:01:51',2),(1264,3,'68.18%','2019-06-12 14:01:51',2),(1265,1,'0','2019-06-12 14:01:51',2),(1266,5,'Aanwezig','2019-06-12 14:01:58',1),(1267,3,'58.0%','2019-06-12 14:01:58',1),(1268,1,'0','2019-06-12 14:01:58',1),(1269,5,'Aanwezig','2019-06-12 14:02:22',1),(1270,3,'57.64%','2019-06-12 14:02:22',1),(1271,1,'0','2019-06-12 14:02:22',1),(1272,5,'Aanwezig','2019-06-12 14:05:07',1),(1273,3,'58.0%','2019-06-12 14:05:07',1),(1274,1,'0','2019-06-12 14:05:07',1),(1275,5,'Aanwezig','2019-06-12 14:05:16',1),(1276,3,'57.41%','2019-06-12 14:05:16',1),(1277,1,'0','2019-06-12 14:05:16',1),(1278,5,'Aanwezig','2019-06-12 14:05:31',2),(1279,3,'62.09%','2019-06-12 14:05:31',2),(1280,1,'0','2019-06-12 14:05:31',2),(1281,5,'Aanwezig','2019-06-12 14:06:09',1),(1282,3,'57.68%','2019-06-12 14:06:09',1),(1283,1,'0','2019-06-12 14:06:09',1),(1284,5,'Aanwezig','2019-06-12 14:06:10',2),(1285,3,'61.86%','2019-06-12 14:06:10',2),(1286,1,'0','2019-06-12 14:06:10',2),(1287,5,'Aanwezig','2019-06-12 14:06:13',1),(1288,3,'57.68%','2019-06-12 14:06:13',1),(1289,1,'0','2019-06-12 14:06:13',1),(1290,5,'Aanwezig','2019-06-12 14:06:26',1),(1291,3,'54.91%','2019-06-12 14:06:26',1),(1292,1,'0','2019-06-12 14:06:26',1),(1293,5,'Aanwezig','2019-06-12 14:23:20',1),(1294,3,'57.59%','2019-06-12 14:23:20',1),(1295,1,'0','2019-06-12 14:23:20',1),(1296,5,'Aanwezig','2019-06-12 14:23:25',2),(1297,3,'63.64%','2019-06-12 14:23:25',2),(1298,1,'0','2019-06-12 14:23:25',2),(1299,5,'Aanwezig','2019-06-12 14:41:53',1),(1300,3,'57.86%','2019-06-12 14:41:53',1),(1301,1,'0','2019-06-12 14:41:54',1),(1302,5,'Afwezig','2019-06-12 14:41:59',1),(1303,3,'58.18%','2019-06-12 14:41:59',1),(1304,1,'-269','2019-06-12 14:41:59',1),(1305,5,'Aanwezig','2019-06-12 14:42:06',1),(1306,3,'58.55%','2019-06-12 14:42:06',1),(1307,1,'-14','2019-06-12 14:42:06',1),(1308,5,'Aanwezig','2019-06-12 14:44:13',1),(1309,3,'61.95%','2019-06-12 14:44:13',1),(1310,1,'0','2019-06-12 14:44:13',1),(1311,5,'Aanwezig','2019-06-12 14:44:17',2),(1312,3,'8.09%','2019-06-12 14:44:17',2),(1313,1,'0','2019-06-12 14:44:17',2),(1314,5,'Aanwezig','2019-06-12 14:44:21',2),(1315,3,'4.82%','2019-06-12 14:44:21',2),(1316,1,'0','2019-06-12 14:44:21',2),(1317,5,'Aanwezig','2019-06-12 14:44:32',2),(1318,3,'28.05%','2019-06-12 14:44:32',2),(1319,1,'13','2019-06-12 14:44:32',2),(1320,5,'Aanwezig','2019-06-12 14:44:37',2),(1321,3,'28.18%','2019-06-12 14:44:37',2),(1322,1,'13','2019-06-12 14:44:37',2),(1323,5,'Aanwezig','2019-06-12 14:44:39',2),(1324,3,'28.36%','2019-06-12 14:44:39',2),(1325,1,'13','2019-06-12 14:44:39',2),(1326,5,'Aanwezig','2019-06-12 14:44:42',2),(1327,3,'30.95%','2019-06-12 14:44:42',2),(1328,1,'13','2019-06-12 14:44:42',2),(1329,5,'Aanwezig','2019-06-12 14:44:45',2),(1330,3,'30.09%','2019-06-12 14:44:45',2),(1331,1,'13','2019-06-12 14:44:45',2),(1332,5,'Aanwezig','2019-06-12 14:44:57',1),(1333,3,'58.77%','2019-06-12 14:44:57',1),(1334,1,'13','2019-06-12 14:44:57',1),(1335,5,'Aanwezig','2019-06-12 14:45:49',1),(1336,3,'59.41%','2019-06-12 14:45:49',1),(1337,1,'0','2019-06-12 14:45:49',1),(1338,5,'Aanwezig','2019-06-12 14:46:28',1),(1339,3,'58.55%','2019-06-12 14:46:28',1),(1340,1,'0','2019-06-12 14:46:28',1),(1341,5,'Aanwezig','2019-06-12 14:47:41',1),(1342,3,'58.55%','2019-06-12 14:47:41',1),(1343,1,'0','2019-06-12 14:47:41',1),(1344,5,'Aanwezig','2019-06-12 14:47:55',1),(1345,3,'59.68%','2019-06-12 14:47:55',1),(1346,1,'24','2019-06-12 14:47:55',1),(1347,5,'Aanwezig','2019-06-12 14:50:44',1),(1348,3,'57.95%','2019-06-12 14:50:44',1),(1349,1,'24','2019-06-12 14:50:44',1),(1350,5,'Aanwezig','2019-06-12 14:50:49',1),(1351,3,'58.0%','2019-06-12 14:50:50',1),(1352,1,'24','2019-06-12 14:50:50',1),(1353,5,'Aanwezig','2019-06-12 14:50:51',1),(1354,3,'57.77%','2019-06-12 14:50:51',1),(1355,1,'24','2019-06-12 14:50:51',1),(1356,5,'Aanwezig','2019-06-12 14:51:06',1),(1357,3,'57.18%','2019-06-12 14:51:06',1),(1358,1,'0','2019-06-12 14:51:06',1),(1359,5,'Aanwezig','2019-06-12 14:51:16',1),(1360,3,'57.55%','2019-06-12 14:51:16',1),(1361,1,'0','2019-06-12 14:51:16',1),(1362,5,'Aanwezig','2019-06-12 14:52:15',1),(1363,3,'57.09%','2019-06-12 14:52:15',1),(1364,1,'0','2019-06-12 14:52:15',1),(1365,5,'Afwezig','2019-06-12 14:52:20',2),(1366,3,'29.86%','2019-06-12 14:52:20',2),(1367,1,'0','2019-06-12 14:52:21',2),(1368,5,'Afwezig','2019-06-12 14:52:27',2),(1369,3,'30.18%','2019-06-12 14:52:27',2),(1370,1,'0','2019-06-12 14:52:28',2),(1371,5,'Afwezig','2019-06-12 14:52:29',2),(1372,3,'30.23%','2019-06-12 14:52:29',2),(1373,1,'0','2019-06-12 14:52:29',2),(1374,5,'Afwezig','2019-06-12 14:52:35',2),(1375,3,'56.0%','2019-06-12 14:52:35',2),(1376,1,'20','2019-06-12 14:52:35',2),(1377,5,'Afwezig','2019-06-12 15:49:56',1),(1378,3,'-11733.68%','2019-06-12 15:49:56',1),(1379,1,'0','2019-06-12 15:49:56',1),(1380,5,'Afwezig','2019-06-12 15:50:03',1),(1381,3,'-11740.27%','2019-06-12 15:50:03',1),(1382,1,'0','2019-06-12 15:50:04',1),(1383,5,'Afwezig','2019-06-12 15:50:06',1),(1384,5,'Afwezig','2019-06-12 15:50:06',1),(1385,3,'-11762.18%','2019-06-12 15:50:06',1),(1386,3,'-11769.95%','2019-06-12 15:50:06',1),(1387,1,'0','2019-06-12 15:50:06',1),(1388,1,'0','2019-06-12 15:50:06',1),(1389,5,'Afwezig','2019-06-12 15:50:18',1),(1390,3,'-11875.05%','2019-06-12 15:50:18',1),(1391,1,'299','2019-06-12 15:50:19',1),(1392,5,'Afwezig','2019-06-12 15:50:20',1),(1393,3,'-11883.45%','2019-06-12 15:50:20',1),(1394,1,'299','2019-06-12 15:50:20',1),(1395,5,'Afwezig','2019-06-12 15:50:21',1),(1396,3,'-11775.95%','2019-06-12 15:50:22',1),(1397,5,'Afwezig','2019-06-12 15:50:22',1),(1398,1,'299','2019-06-12 15:50:22',1),(1399,3,'-11642.14%','2019-06-12 15:50:22',1),(1400,1,'299','2019-06-12 15:50:22',1),(1401,5,'Afwezig','2019-06-12 15:50:23',1),(1402,3,'-11847.09%','2019-06-12 15:50:23',1),(1403,1,'299','2019-06-12 15:50:23',1),(1404,5,'Afwezig','2019-06-12 15:50:28',2),(1405,3,'-223.77%','2019-06-12 15:50:28',2),(1406,1,'0','2019-06-12 15:50:28',2),(1407,5,'Afwezig','2019-06-12 15:50:38',2),(1408,3,'-221.91%','2019-06-12 15:50:38',2),(1409,1,'258','2019-06-12 15:50:38',2),(1410,5,'Afwezig','2019-06-12 15:50:39',2),(1411,3,'-40742.55%','2019-06-12 15:50:39',2),(1412,1,'259','2019-06-12 15:50:39',2),(1413,5,'Afwezig','2019-06-12 15:50:41',2),(1414,3,'-209.64%','2019-06-12 15:50:41',2),(1415,1,'263','2019-06-12 15:50:41',2),(1416,5,'Afwezig','2019-06-12 15:50:43',2),(1417,3,'-207.36%','2019-06-12 15:50:43',2),(1418,1,'265','2019-06-12 15:50:43',2),(1419,5,'Afwezig','2019-06-12 15:55:33',1),(1420,3,'54.64%','2019-06-12 15:55:33',1),(1421,1,'0','2019-06-12 15:55:33',1),(1422,5,'Afwezig','2019-06-12 15:56:13',1),(1423,3,'61.86%','2019-06-12 15:56:13',1),(1424,1,'0','2019-06-12 15:56:13',1),(1425,5,'Afwezig','2019-06-12 15:56:15',1),(1426,3,'64.09%','2019-06-12 15:56:15',1),(1427,1,'0','2019-06-12 15:56:15',1),(1428,5,'Afwezig','2019-06-12 15:56:20',2),(1429,3,'60.64%','2019-06-12 15:56:20',2),(1430,1,'0','2019-06-12 15:56:20',2),(1431,5,'Afwezig','2019-06-12 15:56:46',1),(1432,3,'63.91%','2019-06-12 15:56:46',1),(1433,1,'14','2019-06-12 15:56:46',1),(1434,5,'Afwezig','2019-06-12 15:56:47',2),(1435,3,'53.18%','2019-06-12 15:56:47',2),(1436,1,'0','2019-06-12 15:56:47',2),(1437,5,'Afwezig','2019-06-12 15:57:11',1),(1438,3,'64.45%','2019-06-12 15:57:11',1),(1439,1,'0','2019-06-12 15:57:11',1),(1440,5,'Afwezig','2019-06-12 15:57:39',1),(1441,3,'54.59%','2019-06-12 15:57:39',1),(1442,1,'24','2019-06-12 15:57:40',1),(1443,5,'Afwezig','2019-06-12 15:57:41',1),(1444,3,'54.68%','2019-06-12 15:57:41',1),(1445,1,'24','2019-06-12 15:57:41',1),(1446,5,'Afwezig','2019-06-13 14:21:09',1),(1447,3,'-12048.09%','2019-06-13 14:21:09',1),(1448,1,'0','2019-06-13 14:21:09',1),(1449,5,'Afwezig','2019-06-13 14:21:16',1),(1450,3,'-11985.91%','2019-06-13 14:21:16',1),(1451,1,'0','2019-06-13 14:21:16',1),(1452,5,'Afwezig','2019-06-13 14:21:25',2),(1453,3,'-390.64%','2019-06-13 14:21:25',2),(1454,1,'0','2019-06-13 14:21:25',2),(1455,5,'Afwezig','2019-06-13 14:21:37',2),(1456,3,'-388.77%','2019-06-13 14:21:38',2),(1457,1,'242','2019-06-13 14:21:38',2),(1458,5,'Afwezig','2019-06-13 14:21:38',2),(1459,3,'-48731.23%','2019-06-13 14:21:38',2),(1460,1,'241','2019-06-13 14:21:38',2),(1461,5,'Afwezig','2019-06-13 14:21:40',2),(1462,3,'-380.09%','2019-06-13 14:21:40',2),(1463,1,'241','2019-06-13 14:21:40',2),(1464,5,'Afwezig','2019-06-13 14:21:51',2),(1465,3,'-377.86%','2019-06-13 14:21:51',2),(1466,1,'257','2019-06-13 14:21:51',2),(1467,5,'Afwezig','2019-06-13 14:22:09',2),(1468,3,'-387.73%','2019-06-13 14:22:09',2),(1469,1,'1','2019-06-13 14:22:09',2),(1470,5,'Afwezig','2019-06-13 14:22:10',2),(1471,3,'-146.0%','2019-06-13 14:22:10',2),(1472,1,'2','2019-06-13 14:22:10',2),(1473,5,'Afwezig','2019-06-13 14:22:19',2),(1474,3,'-380.55%','2019-06-13 14:22:19',2),(1475,1,'225','2019-06-13 14:22:19',2),(1476,5,'Afwezig','2019-06-13 14:22:20',2),(1477,3,'-45879.18%','2019-06-13 14:22:20',2),(1478,1,'224','2019-06-13 14:22:20',2),(1479,5,'Afwezig','2019-06-13 14:22:22',2),(1480,3,'-312327.27%','2019-06-13 14:22:22',2),(1481,1,'224','2019-06-13 14:22:22',2),(1482,5,'Afwezig','2019-06-13 14:22:24',2),(1483,3,'-373.82%','2019-06-13 14:22:24',2),(1484,1,'223','2019-06-13 14:22:24',2),(1485,5,'Afwezig','2019-06-13 14:22:26',2),(1486,3,'-439.32%','2019-06-13 14:22:26',2),(1487,1,'223','2019-06-13 14:22:26',2),(1488,5,'Afwezig','2019-06-13 14:22:27',2),(1489,3,'-109624.18%','2019-06-13 14:22:27',2),(1490,1,'222','2019-06-13 14:22:27',2),(1491,5,'Afwezig','2019-06-13 14:22:29',2),(1492,3,'-365.86%','2019-06-13 14:22:29',2),(1493,1,'222','2019-06-13 14:22:29',2),(1494,5,'Afwezig','2019-06-13 14:22:31',2),(1495,3,'-369.77%','2019-06-13 14:22:31',2),(1496,1,'222','2019-06-13 14:22:31',2),(1497,5,'Afwezig','2019-06-13 14:22:33',2),(1498,3,'-325.59%','2019-06-13 14:22:33',2),(1499,1,'222','2019-06-13 14:22:33',2),(1500,5,'Afwezig','2019-06-13 14:22:34',2),(1501,3,'-404.05%','2019-06-13 14:22:34',2),(1502,1,'222','2019-06-13 14:22:35',2),(1503,5,'Afwezig','2019-06-13 14:22:37',2),(1504,3,'-367.09%','2019-06-13 14:22:37',2),(1505,1,'222','2019-06-13 14:22:37',2),(1506,5,'Afwezig','2019-06-13 14:22:39',2),(1507,3,'-573.18%','2019-06-13 14:22:39',2),(1508,5,'Afwezig','2019-06-13 14:22:39',2),(1509,1,'223','2019-06-13 14:22:39',2),(1510,3,'-65861.91%','2019-06-13 14:22:39',2),(1511,1,'213','2019-06-13 14:22:39',2),(1512,5,'Afwezig','2019-06-13 14:22:41',2),(1513,3,'-363.77%','2019-06-13 14:22:41',2),(1514,1,'222','2019-06-13 14:22:41',2),(1515,5,'Afwezig','2019-06-13 14:22:43',2),(1516,3,'-363.91%','2019-06-13 14:22:43',2),(1517,1,'221','2019-06-13 14:22:43',2),(1518,5,'Afwezig','2019-06-13 14:22:58',2),(1519,3,'-375.18%','2019-06-13 14:22:58',2),(1520,1,'231','2019-06-13 14:22:59',2),(1521,5,'Afwezig','2019-06-13 14:23:01',2),(1522,3,'-621.82%','2019-06-13 14:23:01',2),(1523,1,'231','2019-06-13 14:23:01',2),(1524,5,'Afwezig','2019-06-13 14:23:01',2),(1525,3,'-165.86%','2019-06-13 14:23:02',2),(1526,1,'232','2019-06-13 14:23:02',2),(1527,5,'Afwezig','2019-06-13 14:23:02',2),(1528,3,'-124918.82%','2019-06-13 14:23:02',2),(1529,1,'232','2019-06-13 14:23:02',2),(1530,5,'Afwezig','2019-06-13 14:23:04',2),(1531,3,'-301119.91%','2019-06-13 14:23:04',2),(1532,1,'231','2019-06-13 14:23:04',2),(1533,5,'Afwezig','2019-06-13 14:23:06',2),(1534,3,'-386885.05%','2019-06-13 14:23:06',2),(1535,1,'231','2019-06-13 14:23:06',2),(1536,5,'Afwezig','2019-06-13 14:23:07',2),(1537,3,'-344.05%','2019-06-13 14:23:07',2),(1538,1,'231','2019-06-13 14:23:07',2),(1539,5,'Afwezig','2019-06-13 14:23:08',2),(1540,3,'-351.09%','2019-06-13 14:23:08',2),(1541,1,'230','2019-06-13 14:23:08',2),(1542,5,'Afwezig','2019-06-13 14:23:10',2),(1543,3,'-355.14%','2019-06-13 14:23:10',2),(1544,1,'229','2019-06-13 14:23:10',2),(1545,5,'Afwezig','2019-06-13 14:23:19',2),(1546,3,'-372.32%','2019-06-13 14:23:19',2),(1547,1,'2','2019-06-13 14:23:19',2),(1548,5,'Afwezig','2019-06-13 14:26:10',1),(1549,3,'-657.09%','2019-06-13 14:26:10',1),(1550,1,'0','2019-06-13 14:26:11',1),(1551,5,'Afwezig','2019-06-13 14:26:14',2),(1552,3,'-13301781.23%','2019-06-13 14:26:14',2),(1553,1,'0','2019-06-13 14:26:14',2),(1554,5,'Afwezig','2019-06-13 14:26:15',2),(1555,3,'-303.68%','2019-06-13 14:26:15',2),(1556,1,'0','2019-06-13 14:26:15',2),(1557,5,'Afwezig','2019-06-13 14:26:26',2),(1558,3,'-319.73%','2019-06-13 14:26:26',2),(1559,1,'175','2019-06-13 14:26:26',2),(1560,5,'Afwezig','2019-06-13 14:26:29',2),(1561,3,'-215519.32%','2019-06-13 14:26:29',2),(1562,1,'173','2019-06-13 14:26:29',2),(1563,5,'Afwezig','2019-06-13 14:26:56',2),(1564,5,'Afwezig','2019-06-13 14:26:57',2),(1565,3,'-319.0%','2019-06-13 14:26:57',2),(1566,3,'-521.23%','2019-06-13 14:26:57',2),(1567,1,'168','2019-06-13 14:26:57',2),(1568,1,'168','2019-06-13 14:26:57',2),(1569,5,'Afwezig','2019-06-13 14:27:00',2),(1570,3,'95.59%','2019-06-13 14:27:00',2),(1571,1,'167','2019-06-13 14:27:01',2),(1572,5,'Afwezig','2019-06-13 14:27:01',2),(1573,3,'-413.41%','2019-06-13 14:27:01',2),(1574,1,'167','2019-06-13 14:27:02',2),(1575,5,'Afwezig','2019-06-13 14:27:04',2),(1576,5,'Afwezig','2019-06-13 14:27:04',2),(1577,3,'-179.09%','2019-06-13 14:27:04',2),(1578,3,'-89.73%','2019-06-13 14:27:04',2),(1579,1,'168','2019-06-13 14:27:04',2),(1580,1,'176','2019-06-13 14:27:04',2),(1581,5,'Afwezig','2019-06-13 14:27:04',2),(1582,3,'46.55%','2019-06-13 14:27:04',2),(1583,1,'183','2019-06-13 14:27:04',2),(1584,5,'Afwezig','2019-06-13 14:27:09',2),(1585,5,'Afwezig','2019-06-13 14:27:09',2),(1586,5,'Afwezig','2019-06-13 14:27:09',2),(1587,3,'-653.77%','2019-06-13 14:27:09',2),(1588,3,'-309.0%','2019-06-13 14:27:09',2),(1589,3,'-64244.95%','2019-06-13 14:27:09',2),(1590,1,'183','2019-06-13 14:27:09',2),(1591,1,'183','2019-06-13 14:27:09',2),(1592,1,'192','2019-06-13 14:27:09',2),(1593,5,'Afwezig','2019-06-13 14:27:11',2),(1594,3,'-305971.64%','2019-06-13 14:27:11',2),(1595,1,'191','2019-06-13 14:27:11',2),(1596,5,'Afwezig','2019-06-13 14:27:12',2),(1597,3,'-300.73%','2019-06-13 14:27:12',2),(1598,1,'191','2019-06-13 14:27:12',2),(1599,5,'Afwezig','2019-06-13 14:27:16',2),(1600,3,'-311.64%','2019-06-13 14:27:17',2),(1601,1,'192','2019-06-13 14:27:17',2),(1602,5,'Afwezig','2019-06-13 14:27:18',2),(1603,3,'-300.86%','2019-06-13 14:27:18',2),(1604,1,'191','2019-06-13 14:27:18',2),(1605,5,'Afwezig','2019-06-13 14:27:20',2),(1606,3,'-365.0%','2019-06-13 14:27:20',2),(1607,1,'156','2019-06-13 14:27:20',2),(1608,5,'Afwezig','2019-06-13 14:32:25',1),(1609,3,'-12272.45%','2019-06-13 14:32:25',1),(1610,1,'0','2019-06-13 14:32:25',1),(1611,5,'Afwezig','2019-06-13 14:32:31',2),(1612,3,'-294.59%','2019-06-13 14:32:31',2),(1613,1,'0','2019-06-13 14:32:31',2),(1614,5,'Afwezig','2019-06-13 14:32:41',2),(1615,3,'-293.23%','2019-06-13 14:32:42',2),(1616,1,'136','2019-06-13 14:32:42',2),(1617,5,'Afwezig','2019-06-13 14:32:45',2),(1618,3,'-287.82%','2019-06-13 14:32:45',2),(1619,1,'135','2019-06-13 14:32:45',2),(1620,5,'Afwezig','2019-06-13 14:32:46',2),(1621,3,'-72.64%','2019-06-13 14:32:46',2),(1622,1,'135','2019-06-13 14:32:46',2),(1623,5,'Afwezig','2019-06-13 14:32:53',2),(1624,3,'-614833.32%','2019-06-13 14:32:53',2),(1625,1,'151','2019-06-13 14:32:53',2),(1626,5,'Afwezig','2019-06-13 14:32:55',2),(1627,3,'-758327.91%','2019-06-13 14:32:55',2),(1628,1,'150','2019-06-13 14:32:55',2),(1629,5,'Afwezig','2019-06-13 14:33:13',2),(1630,3,'-290.14%','2019-06-13 14:33:14',2),(1631,1,'185','2019-06-13 14:33:14',2),(1632,5,'Afwezig','2019-06-13 14:33:16',2),(1633,3,'-193688.77%','2019-06-13 14:33:16',2),(1634,1,'181','2019-06-13 14:33:16',2),(1635,5,'Afwezig','2019-06-13 14:33:18',2),(1636,3,'-279.82%','2019-06-13 14:33:18',2),(1637,1,'179','2019-06-13 14:33:18',2),(1638,5,'Afwezig','2019-06-13 14:34:11',1),(1639,3,'-12422.68%','2019-06-13 14:34:11',1),(1640,1,'0','2019-06-13 14:34:11',1),(1641,5,'Afwezig','2019-06-13 14:34:19',2),(1642,3,'-278.09%','2019-06-13 14:34:19',2),(1643,1,'143','2019-06-13 14:34:19',2),(1644,5,'Afwezig','2019-06-13 14:34:19',2),(1645,3,'35.23%','2019-06-13 14:34:19',2),(1646,1,'-132','2019-06-13 14:34:19',2),(1647,5,'Afwezig','2019-06-13 14:34:30',2),(1648,3,'-278.95%','2019-06-13 14:34:31',2),(1649,5,'Afwezig','2019-06-13 14:34:31',2),(1650,5,'Afwezig','2019-06-13 14:34:31',2),(1651,1,'92','2019-06-13 14:34:31',2),(1652,3,'-33023.82%','2019-06-13 14:34:31',2),(1653,3,'69.09%','2019-06-13 14:34:31',2),(1654,1,'90','2019-06-13 14:34:31',2),(1655,1,'91','2019-06-13 14:34:32',2),(1656,5,'Afwezig','2019-06-13 14:34:34',2),(1657,3,'70.86%','2019-06-13 14:34:35',2),(1658,5,'Afwezig','2019-06-13 14:34:35',2),(1659,1,'89','2019-06-13 14:34:35',2),(1660,5,'Afwezig','2019-06-13 14:34:35',2),(1661,3,'-3518.23%','2019-06-13 14:34:35',2),(1662,3,'-317.59%','2019-06-13 14:34:35',2),(1663,1,'80','2019-06-13 14:34:35',2),(1664,1,'-337','2019-06-13 14:34:35',2),(1665,5,'Afwezig','2019-06-13 14:34:36',2),(1666,3,'-221808.86%','2019-06-13 14:34:36',2),(1667,1,'-50','2019-06-13 14:34:36',2),(1668,5,'Afwezig','2019-06-13 14:34:50',2),(1669,3,'-282.36%','2019-06-13 14:34:50',2),(1670,1,'80','2019-06-13 14:34:50',2),(1671,5,'Afwezig','2019-06-13 14:34:52',2),(1672,3,'-159341.64%','2019-06-13 14:34:52',2),(1673,1,'79','2019-06-13 14:34:52',2),(1674,5,'Afwezig','2019-06-13 15:37:34',1),(1675,3,'77.64%','2019-06-13 15:37:34',1),(1676,1,'0','2019-06-13 15:37:34',1),(1677,5,'Aanwezig','2019-06-13 15:37:45',1),(1678,3,'51.5%','2019-06-13 15:37:45',1),(1679,1,'284','2019-06-13 15:37:45',1),(1680,5,'Aanwezig','2019-06-13 15:37:49',1),(1681,3,'51.0%','2019-06-13 15:37:49',1),(1682,1,'293','2019-06-13 15:37:49',1),(1683,5,'Aanwezig','2019-06-13 15:37:52',1),(1684,3,'51.23%','2019-06-13 15:37:52',1),(1685,1,'296','2019-06-13 15:37:52',1),(1686,5,'Aanwezig','2019-06-13 15:37:57',1),(1687,3,'50.5%','2019-06-13 15:37:57',1),(1688,1,'237','2019-06-13 15:37:57',1),(1689,5,'Aanwezig','2019-06-13 15:37:59',1),(1690,3,'51.09%','2019-06-13 15:37:59',1),(1691,1,'242','2019-06-13 15:37:59',1),(1692,5,'Afwezig','2019-06-13 15:38:05',2),(1693,3,'68.0%','2019-06-13 15:38:05',2),(1694,1,'0','2019-06-13 15:38:05',2),(1695,5,'Aanwezig','2019-06-13 15:38:13',2),(1696,3,'65.59%','2019-06-13 15:38:13',2),(1697,1,'217','2019-06-13 15:38:13',2),(1698,5,'Aanwezig','2019-06-13 15:38:15',2),(1699,3,'65.73%','2019-06-13 15:38:15',2),(1700,1,'220','2019-06-13 15:38:15',2),(1701,5,'Aanwezig','2019-06-13 15:38:17',2),(1702,3,'65.73%','2019-06-13 15:38:17',2),(1703,1,'222','2019-06-13 15:38:17',2),(1704,5,'Aanwezig','2019-06-13 15:38:21',2),(1705,3,'66.36%','2019-06-13 15:38:21',2),(1706,1,'228','2019-06-13 15:38:22',2),(1707,5,'Aanwezig','2019-06-13 15:38:22',2),(1708,3,'65.68%','2019-06-13 15:38:23',2),(1709,1,'229','2019-06-13 15:38:24',2),(1710,5,'Aanwezig','2019-06-13 15:38:24',2),(1711,3,'65.73%','2019-06-13 15:38:25',2),(1712,1,'230','2019-06-13 15:38:26',2),(1713,5,'Aanwezig','2019-06-13 15:38:26',2),(1714,3,'65.73%','2019-06-13 15:38:26',2),(1715,1,'-395','2019-06-13 15:38:26',2),(1716,5,'Aanwezig','2019-06-13 15:38:27',2),(1717,3,'65.73%','2019-06-13 15:38:27',2),(1718,1,'262','2019-06-13 15:38:27',2),(1719,5,'Aanwezig','2019-06-13 15:38:29',2),(1720,3,'65.41%','2019-06-13 15:38:29',2),(1721,1,'235','2019-06-13 15:38:29',2),(1722,5,'Aanwezig','2019-06-13 15:38:30',2),(1723,3,'65.64%','2019-06-13 15:38:30',2),(1724,1,'235','2019-06-13 15:38:30',2),(1725,5,'Aanwezig','2019-06-13 19:02:54',1),(1726,3,'67.36%','2019-06-13 19:02:54',1),(1727,1,'-1','2019-06-13 19:02:55',1),(1728,5,'Aanwezig','2019-06-13 19:02:55',1),(1729,3,'67.5%','2019-06-13 19:02:55',1),(1730,1,'0','2019-06-13 19:02:55',1),(1731,5,'Aanwezig','2019-06-13 19:03:48',1),(1732,3,'67.45%','2019-06-13 19:03:48',1),(1733,1,'0','2019-06-13 19:03:48',1),(1734,5,'Aanwezig','2019-06-13 19:03:56',2),(1735,3,'55.91%','2019-06-13 19:03:56',2),(1736,1,'0','2019-06-13 19:03:56',2),(1737,5,'Afwezig','2019-06-13 19:07:11',1),(1738,3,'65.64%','2019-06-13 19:07:11',1),(1739,1,'31','2019-06-13 19:07:11',1),(1740,5,'Afwezig','2019-06-13 19:07:12',1),(1741,3,'65.5%','2019-06-13 19:07:12',1),(1742,1,'32','2019-06-13 19:07:12',1),(1743,5,'Afwezig','2019-06-13 19:07:13',1),(1744,3,'63.36%','2019-06-13 19:07:13',1),(1745,1,'33','2019-06-13 19:07:13',1),(1746,5,'Afwezig','2019-06-13 19:07:17',1),(1747,3,'63.68%','2019-06-13 19:07:18',1),(1748,1,'34','2019-06-13 19:07:18',1),(1749,5,'Afwezig','2019-06-13 19:07:21',1),(1750,3,'63.73%','2019-06-13 19:07:21',1),(1751,1,'34','2019-06-13 19:07:21',1),(1752,5,'Afwezig','2019-06-13 19:07:24',1),(1753,3,'63.18%','2019-06-13 19:07:24',1),(1754,1,'35','2019-06-13 19:07:24',1),(1755,5,'Afwezig','2019-06-13 19:07:34',1),(1756,3,'53.27%','2019-06-13 19:07:34',1),(1757,1,'58','2019-06-13 19:07:36',1),(1758,5,'Afwezig','2019-06-13 19:07:36',1),(1759,3,'51.23%','2019-06-13 19:07:36',1),(1760,5,'Afwezig','2019-06-13 19:07:36',1),(1761,1,'58','2019-06-13 19:07:36',1),(1762,3,'51.09%','2019-06-13 19:07:36',1),(1763,1,'58','2019-06-13 19:07:36',1),(1764,5,'Afwezig','2019-06-13 19:07:37',1),(1765,3,'51.18%','2019-06-13 19:07:37',1),(1766,1,'58','2019-06-13 19:07:37',1),(1767,5,'Afwezig','2019-06-13 19:14:42',1),(1768,3,'88.86%','2019-06-13 19:14:42',1),(1769,1,'0','2019-06-13 19:14:42',1),(1770,5,'Aanwezig','2019-06-13 19:14:54',2),(1771,3,'64.09%','2019-06-13 19:14:54',2),(1772,1,'0','2019-06-13 19:14:54',2),(1773,5,'Aanwezig','2019-06-13 19:15:05',2),(1774,3,'64.41%','2019-06-13 19:15:05',2),(1775,1,'409','2019-06-13 19:15:05',2),(1776,5,'Aanwezig','2019-06-13 19:15:06',2),(1777,3,'64.18%','2019-06-13 19:15:06',2),(1778,1,'0','2019-06-13 19:15:06',2),(1779,5,'Aanwezig','2019-06-13 19:15:12',1),(1780,3,'90.05%','2019-06-13 19:15:12',1),(1781,1,'0','2019-06-13 19:15:12',1),(1782,5,'Aanwezig','2019-06-13 19:15:17',2),(1783,3,'64.59%','2019-06-13 19:15:17',2),(1784,1,'0','2019-06-13 19:15:17',2),(1785,5,'Afwezig','2019-06-13 19:16:30',1),(1786,3,'90.59%','2019-06-13 19:16:30',1),(1787,1,'0','2019-06-13 19:16:30',1),(1788,5,'Afwezig','2019-06-13 19:16:39',1),(1789,3,'90.41%','2019-06-13 19:16:40',1),(1790,1,'6','2019-06-13 19:16:40',1),(1791,5,'Afwezig','2019-06-13 19:16:50',1),(1792,3,'90.95%','2019-06-13 19:16:50',1),(1793,1,'0','2019-06-13 19:16:50',1),(1794,5,'Aanwezig','2019-06-13 19:16:57',2),(1795,3,'23.05%','2019-06-13 19:16:57',2),(1796,1,'0','2019-06-13 19:16:57',2),(1797,5,'Aanwezig','2019-06-13 19:29:53',1),(1798,3,'60.0%','2019-06-13 19:29:53',1),(1799,1,'0','2019-06-13 19:29:53',1),(1800,5,'Aanwezig','2019-06-13 19:29:58',1),(1801,3,'63.27%','2019-06-13 19:29:58',1),(1802,1,'0','2019-06-13 19:29:58',1),(1803,5,'Aanwezig','2019-06-13 19:30:09',1),(1804,3,'46.18%','2019-06-13 19:30:09',1),(1805,1,'26','2019-06-13 19:30:09',1),(1806,5,'Aanwezig','2019-06-13 19:30:12',1),(1807,3,'46.0%','2019-06-13 19:30:12',1),(1808,1,'26','2019-06-13 19:30:12',1),(1809,5,'Aanwezig','2019-06-13 19:30:17',1),(1810,3,'46.14%','2019-06-13 19:30:17',1),(1811,1,'0','2019-06-13 19:30:17',1),(1812,5,'Aanwezig','2019-06-13 19:38:03',1),(1813,3,'18.77%','2019-06-13 19:38:03',1),(1814,1,'-19','2019-06-13 19:38:03',1),(1815,5,'Afwezig','2019-06-13 19:45:35',1),(1816,3,'92.18%','2019-06-13 19:45:35',1),(1817,1,'0','2019-06-13 19:45:35',1),(1818,5,'Aanwezig','2019-06-13 19:46:02',1),(1819,3,'92.18%','2019-06-13 19:46:03',1),(1820,1,'295','2019-06-13 19:46:03',1),(1821,5,'Aanwezig','2019-06-13 19:46:03',1),(1822,3,'93.05%','2019-06-13 19:46:04',1),(1823,1,'-482','2019-06-13 19:46:04',1),(1824,5,'Aanwezig','2019-06-13 19:46:04',1),(1825,3,'92.05%','2019-06-13 19:46:04',1),(1826,1,'299','2019-06-13 19:46:04',1),(1827,5,'Aanwezig','2019-06-13 19:46:06',1),(1828,3,'91.95%','2019-06-13 19:46:06',1),(1829,1,'297','2019-06-13 19:46:06',1),(1830,5,'Aanwezig','2019-06-13 19:46:07',1),(1831,3,'92.0%','2019-06-13 19:46:07',1),(1832,1,'299','2019-06-13 19:46:07',1),(1833,5,'Aanwezig','2019-06-13 19:46:12',1),(1834,3,'91.45%','2019-06-13 19:46:12',1),(1835,1,'272','2019-06-13 19:46:12',1),(1836,5,'Aanwezig','2019-06-13 19:46:13',1),(1837,3,'92.73%','2019-06-13 19:46:13',1),(1838,1,'274','2019-06-13 19:46:13',1),(1839,5,'Aanwezig','2019-06-13 19:46:14',1),(1840,3,'92.86%','2019-06-13 19:46:14',1),(1841,1,'274','2019-06-13 19:46:14',1),(1842,5,'Afwezig','2019-06-13 19:46:20',2),(1843,3,'65.18%','2019-06-13 19:46:20',2),(1844,1,'-15','2019-06-13 19:46:20',2),(1845,5,'Aanwezig','2019-06-13 19:46:29',2),(1846,3,'63.32%','2019-06-13 19:46:29',2),(1847,1,'253','2019-06-13 19:46:29',2),(1848,5,'Aanwezig','2019-06-13 19:46:33',2),(1849,3,'63.18%','2019-06-13 19:46:33',2),(1850,1,'274','2019-06-13 19:46:33',2),(1851,5,'Aanwezig','2019-06-14 08:38:11',1),(1852,3,'-118.59%','2019-06-14 08:38:11',1),(1853,1,'-5','2019-06-14 08:38:11',1),(1854,5,'Afwezig','2019-06-14 09:14:59',2),(1855,3,'121648075495389.6%','2019-06-14 09:14:59',2),(1856,1,'669','2019-06-14 09:15:00',2),(1857,5,'Aanwezig','2019-06-14 09:15:46',1),(1858,5,'Aanwezig','2019-06-14 09:15:46',1),(1859,3,'-121648079139819.56%','2019-06-14 09:15:47',1),(1860,3,'-121648079139819.56%','2019-06-14 09:15:47',1),(1861,1,'18','2019-06-14 09:15:48',1),(1862,1,'100','2019-06-14 09:15:48',1),(1863,5,'Aanwezig','2019-06-14 09:15:49',1),(1864,3,'-121648079150954.86%','2019-06-14 09:15:49',1),(1865,1,'324','2019-06-14 09:15:49',1),(1866,5,'Aanwezig','2019-06-14 09:15:49',1),(1867,3,'-121648079151319.58%','2019-06-14 09:15:49',1),(1868,1,'313','2019-06-14 09:15:49',1),(1869,5,'Afwezig','2019-06-14 09:16:39',2),(1870,3,'-368.64%','2019-06-14 09:16:39',2),(1871,1,'0','2019-06-14 09:16:39',2),(1872,5,'Afwezig','2019-06-14 09:17:41',2),(1873,3,'494.59%','2019-06-14 09:17:41',2),(1874,1,'26','2019-06-14 09:17:41',2),(1875,5,'Afwezig','2019-06-14 09:17:46',2),(1876,5,'Afwezig','2019-06-14 09:17:46',2),(1877,3,'495.95%','2019-06-14 09:17:47',2),(1878,3,'494.64%','2019-06-14 09:17:47',2),(1879,1,'19','2019-06-14 09:17:47',2),(1880,1,'19','2019-06-14 09:17:47',2),(1881,5,'Afwezig','2019-06-14 09:18:49',2),(1882,3,'-152.23%','2019-06-14 09:18:50',2),(1883,1,'29','2019-06-14 09:18:50',2),(1884,5,'Afwezig','2019-06-14 09:19:51',2),(1885,3,'4521063.86%','2019-06-14 09:19:52',2),(1886,1,'1','2019-06-14 09:19:52',2),(1887,5,'Afwezig','2019-06-14 09:19:54',2),(1888,3,'4538319.95%','2019-06-14 09:19:55',2),(1889,1,'1','2019-06-14 09:19:56',2),(1890,5,'Afwezig','2019-06-14 09:19:57',2),(1891,5,'Afwezig','2019-06-14 09:19:58',2),(1892,3,'4855234.55%','2019-06-14 09:19:59',2),(1893,3,'99.5%','2019-06-14 09:19:59',2),(1894,1,'3','2019-06-14 09:20:00',2),(1895,1,'3','2019-06-14 09:20:00',2),(1896,5,'Afwezig','2019-06-14 09:22:40',2),(1897,5,'Afwezig','2019-06-14 09:22:40',2),(1898,3,'-667.82%','2019-06-14 09:22:40',2),(1899,3,'-327.68%','2019-06-14 09:22:40',2),(1900,1,'-70','2019-06-14 09:22:40',2),(1901,1,'-71','2019-06-14 09:22:40',2),(1902,5,'Aanwezig','2019-06-14 09:23:12',1),(1903,3,'-121648114018835.33%','2019-06-14 09:23:12',1),(1904,1,'-8','2019-06-14 09:23:12',1),(1905,5,'Aanwezig','2019-06-14 09:23:13',1),(1906,3,'-121648114018835.33%','2019-06-14 09:23:13',1),(1907,1,'11','2019-06-14 09:23:13',1),(1908,5,'Afwezig','2019-06-14 09:49:48',1),(1909,3,'7.09%','2019-06-14 09:49:48',1),(1910,1,'0','2019-06-14 09:49:48',1),(1911,5,'Afwezig','2019-06-14 10:06:10',1),(1912,3,'0.73%','2019-06-14 10:06:10',1),(1913,1,'0','2019-06-14 10:06:10',1),(1914,5,'Afwezig','2019-06-14 10:06:17',2),(1915,3,'38.0%','2019-06-14 10:06:17',2),(1916,1,'0','2019-06-14 10:06:17',2),(1917,5,'Aanwezig','2019-06-14 10:06:25',2),(1918,3,'31.02%','2019-06-14 10:06:25',2),(1919,1,'220','2019-06-14 10:06:25',2),(1920,5,'Aanwezig','2019-06-14 10:06:26',2),(1921,3,'31.37%','2019-06-14 10:06:26',2),(1922,1,'222','2019-06-14 10:06:26',2),(1923,5,'Aanwezig','2019-06-14 10:26:17',1),(1924,3,'0.68%','2019-06-14 10:26:17',1),(1925,1,'0','2019-06-14 10:26:17',1),(1926,5,'Aanwezig','2019-06-14 10:26:19',1),(1927,3,'0.59%','2019-06-14 10:26:19',1),(1928,1,'0','2019-06-14 10:26:19',1),(1929,5,'Afwezig','2019-06-14 12:40:59',1),(1930,3,'2.49%','2019-06-14 12:40:59',1),(1931,1,'0','2019-06-14 12:40:59',1),(1932,5,'Aanwezig','2019-06-14 12:41:01',2),(1933,3,'52.29%','2019-06-14 12:41:01',2),(1934,1,'0','2019-06-14 12:41:01',2),(1935,5,'Aanwezig','2019-06-14 12:41:05',2),(1936,3,'44.15%','2019-06-14 12:41:05',2),(1937,1,'0','2019-06-14 12:41:05',2),(1938,5,'Afwezig','2019-06-14 12:52:37',1),(1939,3,'88.98%','2019-06-14 12:52:37',1),(1940,1,'-3','2019-06-14 12:52:37',1),(1941,5,'Afwezig','2019-06-14 13:28:22',1),(1942,3,'93.12%','2019-06-14 13:28:22',1),(1943,1,'0','2019-06-14 13:28:22',1),(1944,5,'Afwezig','2019-06-14 13:45:12',1),(1945,3,'-5.27%','2019-06-14 13:45:12',1),(1946,1,'0','2019-06-14 13:45:12',1),(1947,5,'Afwezig','2019-06-14 13:45:19',1),(1948,3,'-4.98%','2019-06-14 13:45:19',1),(1949,1,'-119','2019-06-14 13:45:19',1),(1950,5,'Afwezig','2019-06-14 13:45:21',1),(1951,3,'-5.07%','2019-06-14 13:45:22',1),(1952,1,'-60','2019-06-14 13:45:22',1),(1953,5,'Afwezig','2019-06-14 13:45:23',1),(1954,5,'Afwezig','2019-06-14 13:45:23',1),(1955,3,'-1.12%','2019-06-14 13:45:23',1),(1956,3,'-5.07%','2019-06-14 13:45:23',1),(1957,1,'0','2019-06-14 13:45:23',1),(1958,1,'0','2019-06-14 13:45:23',1),(1959,5,'Afwezig','2019-06-14 13:45:25',2),(1960,3,'61.46%','2019-06-14 13:45:25',2),(1961,1,'0','2019-06-14 13:45:25',2),(1962,5,'Afwezig','2019-06-14 13:45:35',2),(1963,3,'59.56%','2019-06-14 13:45:35',2),(1964,1,'-1','2019-06-14 13:45:35',2),(1965,5,'Afwezig','2019-06-14 13:46:15',1),(1966,3,'-5.51%','2019-06-14 13:46:15',1),(1967,1,'-11','2019-06-14 13:46:15',1),(1968,5,'Afwezig','2019-06-14 13:46:26',1),(1969,3,'-2.88%','2019-06-14 13:46:26',1),(1970,1,'238','2019-06-14 13:46:26',1),(1971,5,'Afwezig','2019-06-14 13:46:26',1),(1972,3,'-2.83%','2019-06-14 13:46:26',1),(1973,1,'239','2019-06-14 13:46:26',1),(1974,5,'Afwezig','2019-06-14 13:46:27',1),(1975,3,'-2.73%','2019-06-14 13:46:27',1),(1976,1,'241','2019-06-14 13:46:27',1),(1977,5,'Afwezig','2019-06-14 13:46:36',2),(1978,3,'58.98%','2019-06-14 13:46:36',2),(1979,1,'0','2019-06-14 13:46:36',2),(1980,5,'Aanwezig','2019-06-14 13:46:42',2),(1981,3,'59.27%','2019-06-14 13:46:42',2),(1982,1,'193','2019-06-14 13:46:42',2),(1983,5,'Aanwezig','2019-06-14 13:46:45',2),(1984,3,'59.07%','2019-06-14 13:46:45',2),(1985,1,'200','2019-06-14 13:46:45',2),(1986,5,'Aanwezig','2019-06-14 13:46:46',2),(1987,3,'59.12%','2019-06-14 13:46:46',2),(1988,1,'201','2019-06-14 13:46:46',2),(1989,5,'Aanwezig','2019-06-14 13:46:52',2),(1990,3,'57.41%','2019-06-14 13:46:52',2),(1991,1,'221','2019-06-14 13:46:52',2),(1992,5,'Aanwezig','2019-06-14 13:46:55',2),(1993,3,'59.12%','2019-06-14 13:46:55',2),(1994,1,'222','2019-06-14 13:46:55',2),(1995,5,'Afwezig','2019-06-14 13:47:51',1),(1996,3,'0%','2019-06-14 13:47:51',1),(1997,1,'0','2019-06-14 13:47:51',1),(1998,5,'Afwezig','2019-06-14 13:48:04',1),(1999,3,'0%','2019-06-14 13:48:04',1),(2000,1,'229','2019-06-14 13:48:04',1),(2001,5,'Afwezig','2019-06-14 13:48:09',1),(2002,3,'0%','2019-06-14 13:48:09',1),(2003,1,'226','2019-06-14 13:48:09',1),(2004,5,'Aanwezig','2019-06-14 13:48:22',1),(2005,3,'0%','2019-06-14 13:48:22',1),(2006,1,'295','2019-06-14 13:48:22',1),(2007,5,'Aanwezig','2019-06-14 13:48:23',1),(2008,3,'0%','2019-06-14 13:48:23',1),(2009,1,'294','2019-06-14 13:48:23',1),(2010,5,'Afwezig','2019-06-14 13:48:29',1),(2011,3,'0%','2019-06-14 13:48:29',1),(2012,1,'-1','2019-06-14 13:48:29',1),(2013,5,'Aanwezig','2019-06-14 13:48:37',1),(2014,3,'0%','2019-06-14 13:48:37',1),(2015,1,'298','2019-06-14 13:48:37',1),(2016,5,'Aanwezig','2019-06-14 13:48:38',1),(2017,3,'0%','2019-06-14 13:48:38',1),(2018,1,'293','2019-06-14 13:48:38',1),(2019,5,'Afwezig','2019-06-14 13:48:49',2),(2020,3,'63.07%','2019-06-14 13:48:49',2),(2021,1,'0','2019-06-14 13:48:49',2),(2022,5,'Aanwezig','2019-06-14 13:48:55',2),(2023,3,'59.17%','2019-06-14 13:48:55',2),(2024,1,'252','2019-06-14 13:48:55',2),(2025,5,'Aanwezig','2019-06-14 13:48:56',2),(2026,3,'59.27%','2019-06-14 13:48:56',2),(2027,1,'-52','2019-06-14 13:48:56',2),(2028,5,'Aanwezig','2019-06-14 13:48:59',2),(2029,3,'58.54%','2019-06-14 13:48:59',2),(2030,1,'259','2019-06-14 13:48:59',2),(2031,5,'Afwezig','2019-06-14 13:49:41',1),(2032,3,'0.44%','2019-06-14 13:49:41',1),(2033,1,'0','2019-06-14 13:49:41',1),(2034,5,'Afwezig','2019-06-14 13:49:46',2),(2035,3,'59.07%','2019-06-14 13:49:46',2),(2036,1,'0','2019-06-14 13:49:46',2),(2037,5,'Afwezig','2019-06-14 13:49:54',1),(2038,3,'0.73%','2019-06-14 13:49:54',1),(2039,1,'-1','2019-06-14 13:49:54',1),(2040,5,'Afwezig','2019-06-14 13:49:55',2),(2041,3,'57.07%','2019-06-14 13:49:55',2),(2042,1,'0','2019-06-14 13:49:55',2),(2043,5,'Afwezig','2019-06-14 13:56:42',1),(2044,3,'0.49%','2019-06-14 13:56:42',1),(2045,1,'0','2019-06-14 13:56:42',1);
/*!40000 ALTER TABLE `meting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `portie`
--

DROP TABLE IF EXISTS `portie`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `portie` (
  `portieID` int(11) NOT NULL AUTO_INCREMENT,
  `cornflakesID` int(11) DEFAULT NULL,
  `grootte` varchar(45) DEFAULT NULL,
  `datum` datetime DEFAULT NULL,
  `reservoirID` int(11) DEFAULT NULL,
  PRIMARY KEY (`portieID`),
  KEY `fk_reservoirr_idx` (`reservoirID`),
  KEY `fk_cornflakes_idx` (`cornflakesID`),
  CONSTRAINT `fk_reservoirr` FOREIGN KEY (`reservoirID`) REFERENCES `reservoir` (`reservoirID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=212 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `portie`
--

LOCK TABLES `portie` WRITE;
/*!40000 ALTER TABLE `portie` DISABLE KEYS */;
INSERT INTO `portie` VALUES (14,4,'Klein','2019-06-11 15:14:47',1),(15,4,'Klein','2019-06-11 16:26:09',1),(16,4,'Klein','2019-06-12 13:17:03',1),(17,4,'Klein','2019-06-12 13:17:21',1),(18,5,'Klein','2019-06-12 13:26:18',2),(19,4,'Klein','2019-06-12 13:43:43',1),(20,5,'Gemiddeld','2019-06-12 13:43:57',2),(21,4,'Gemiddeld','2019-06-12 13:47:18',1),(22,4,'Klein','2019-06-12 14:10:08',1),(23,5,'Klein','2019-06-12 14:23:30',2),(24,4,'Klein','2019-06-12 14:42:11',1),(25,5,'Klein','2019-06-12 14:44:30',2),(26,4,'Klein','2019-06-12 14:44:54',1),(27,4,'Gemiddeld','2019-06-12 14:47:53',1),(28,5,'Klein','2019-06-12 14:52:33',2),(29,6,'Gemiddeld','2019-06-12 15:57:22',1),(30,9,'Klein','2019-06-13 19:04:03',2),(31,6,'Klein','2019-06-13 19:06:49',1),(32,6,'Klein','2019-06-13 19:07:29',1),(33,9,'Groot','2019-06-13 19:15:38',2),(34,9,'Groot','2019-06-13 19:15:50',2),(35,9,'Klein','2019-06-13 19:16:09',2),(36,9,'Klein','2019-06-13 19:16:23',2),(37,9,'Klein','2019-06-13 19:23:45',2),(38,6,'Klein','2019-06-13 19:26:16',1),(39,6,'Klein','2019-06-13 19:27:13',1),(40,6,'Klein','2019-06-13 19:27:16',1),(41,9,'Klein','2019-06-13 19:27:20',2),(42,9,'Klein','2019-06-13 19:27:27',2),(43,6,'Klein','2019-06-13 19:27:56',1),(44,6,'Klein','2019-06-13 19:27:58',1),(45,9,'Klein','2019-06-13 19:28:03',2),(46,6,'Klein','2019-06-13 19:28:26',1),(47,6,'Klein','2019-06-13 19:29:04',1),(48,6,'Klein','2019-06-13 19:29:05',1),(49,9,'Klein','2019-06-13 19:29:07',2),(50,9,'Klein','2019-06-13 19:29:11',2),(51,6,'Klein','2019-06-13 19:30:05',1),(52,9,'Klein','2019-06-13 19:33:41',2),(53,9,'Klein','2019-06-13 19:33:43',2),(54,6,'Klein','2019-06-13 19:33:47',1),(55,9,'Klein','2019-06-13 19:37:32',2),(56,6,'Klein','2019-06-13 19:37:34',1),(57,6,'Klein','2019-06-13 19:37:35',1),(58,6,'Klein','2019-06-13 19:37:37',1),(59,6,'Klein','2019-06-13 19:38:21',1),(60,6,'Klein','2019-06-13 19:38:28',1),(61,9,'Klein','2019-06-13 19:41:40',2),(62,9,'Groot','2019-06-13 19:41:51',2),(63,9,'Klein','2019-06-13 19:41:52',2),(64,9,'Klein','2019-06-13 19:41:53',2),(65,9,'Klein','2019-06-13 19:42:24',2),(66,9,'Klein','2019-06-13 19:42:30',2),(67,9,'Klein','2019-06-13 19:42:32',2),(68,9,'Klein','2019-06-13 19:42:32',2),(69,9,'Klein','2019-06-13 19:42:33',2),(70,9,'Klein','2019-06-13 19:42:34',2),(71,9,'Klein','2019-06-13 19:41:40',2),(72,9,'Groot','2019-06-13 19:44:29',2),(73,9,'Groot','2019-06-13 19:44:29',2),(74,9,'Klein','2019-06-13 19:44:31',2),(75,9,'Klein','2019-06-13 19:44:31',2),(76,9,'Klein','2019-06-13 19:44:32',2),(77,9,'Klein','2019-06-13 19:44:33',2),(78,6,'Klein','2019-06-13 19:44:35',1),(79,6,'Klein','2019-06-13 19:44:36',1),(80,9,'Klein','2019-06-13 19:47:12',2),(81,9,'Klein','2019-06-13 19:47:15',2),(82,9,'Klein','2019-06-13 19:47:15',2),(83,9,'Klein','2019-06-13 19:47:22',2),(84,9,'Klein','2019-06-13 19:52:48',2),(85,6,'Klein','2019-06-14 06:27:37',1),(86,6,'Klein','2019-06-14 08:38:48',1),(87,6,'Klein','2019-06-14 08:38:51',1),(88,6,'Klein','2019-06-14 08:38:56',1),(89,6,'Klein','2019-06-14 08:38:58',1),(90,6,'Klein','2019-06-14 08:39:05',1),(91,6,'Klein','2019-06-14 08:39:08',1),(92,6,'Klein','2019-06-14 08:39:11',1),(93,6,'Klein','2019-06-14 08:39:13',1),(94,6,'Klein','2019-06-14 08:39:15',1),(95,6,'Klein','2019-06-14 08:39:17',1),(96,6,'Klein','2019-06-14 08:39:18',1),(97,6,'Klein','2019-06-14 08:46:29',1),(98,6,'Klein','2019-06-14 08:48:17',1),(99,6,'Klein','2019-06-14 09:04:18',1),(100,6,'Klein','2019-06-14 09:05:57',1),(101,6,'Klein','2019-06-14 09:05:58',1),(102,6,'Klein','2019-06-14 09:06:01',1),(103,6,'Klein','2019-06-14 09:07:28',1),(104,9,'Klein','2019-06-14 09:08:13',2),(105,9,'Klein','2019-06-14 09:08:14',2),(106,9,'Klein','2019-06-14 09:08:15',2),(107,9,'Klein','2019-06-14 09:08:21',2),(108,9,'Klein','2019-06-14 09:10:19',2),(109,9,'Klein','2019-06-14 09:10:23',2),(110,9,'Klein','2019-06-14 09:10:25',2),(111,9,'Klein','2019-06-14 09:10:29',2),(112,9,'Klein','2019-06-14 09:10:32',2),(113,6,'Klein','2019-06-14 09:10:47',1),(114,6,'Klein','2019-06-14 09:12:20',1),(115,6,'Klein','2019-06-14 09:12:21',1),(116,9,'Klein','2019-06-14 09:21:09',2),(117,9,'Klein','2019-06-14 09:21:15',2),(118,9,'Klein','2019-06-14 09:21:18',2),(119,9,'Klein','2019-06-14 09:21:26',2),(120,9,'Klein','2019-06-14 09:21:30',2),(121,6,'Klein','2019-06-14 09:37:37',1),(122,6,'Klein','2019-06-14 09:38:26',1),(123,6,'Klein','2019-06-14 09:38:49',1),(124,6,'Klein','2019-06-14 09:38:50',1),(125,6,'Klein','2019-06-14 09:38:51',1),(126,6,'Klein','2019-06-14 09:38:51',1),(127,6,'Klein','2019-06-14 09:39:37',1),(128,6,'Klein','2019-06-14 09:39:40',1),(129,6,'Klein','2019-06-14 10:06:30',1),(130,6,'Klein','2019-06-14 10:06:31',1),(131,6,'Klein','2019-06-14 10:06:36',1),(132,6,'Klein','2019-06-14 10:06:37',1),(133,6,'Klein','2019-06-14 10:06:49',1),(134,9,'Klein','2019-06-14 10:06:59',2),(135,9,'Klein','2019-06-14 10:07:13',2),(136,9,'Klein','2019-06-14 10:07:14',2),(137,9,'Klein','2019-06-14 10:07:17',2),(138,9,'Klein','2019-06-14 10:07:20',2),(139,9,'Klein','2019-06-14 10:07:21',2),(140,9,'Klein','2019-06-14 10:07:26',2),(141,6,'Klein','2019-06-14 10:07:27',1),(142,6,'Klein','2019-06-14 10:07:29',1),(143,6,'Klein','2019-06-14 10:07:30',1),(144,6,'Klein','2019-06-14 10:07:31',1),(145,6,'Klein','2019-06-14 10:07:31',1),(146,6,'Klein','2019-06-14 10:07:48',1),(147,6,'Klein','2019-06-14 10:07:49',1),(148,6,'Klein','2019-06-14 10:07:50',1),(149,6,'Klein','2019-06-14 10:07:50',1),(150,6,'Klein','2019-06-14 10:07:51',1),(151,6,'Klein','2019-06-14 10:07:52',1),(152,6,'Klein','2019-06-14 10:07:53',1),(153,6,'Klein','2019-06-14 10:07:55',1),(154,6,'Klein','2019-06-14 10:07:56',1),(155,9,'Klein','2019-06-14 10:08:24',2),(156,9,'Klein','2019-06-14 10:08:25',2),(157,9,'Gemiddeld','2019-06-14 10:08:31',2),(158,9,'Klein','2019-06-14 10:08:39',2),(159,9,'Klein','2019-06-14 10:08:41',2),(160,9,'Klein','2019-06-14 10:08:44',2),(161,6,'Klein','2019-06-14 10:08:48',1),(162,6,'Klein','2019-06-14 10:08:49',1),(163,6,'Klein','2019-06-14 10:08:49',1),(164,6,'Klein','2019-06-14 10:08:50',1),(165,6,'Klein','2019-06-14 10:08:51',1),(166,6,'Klein','2019-06-14 10:08:53',1),(167,6,'Klein','2019-06-14 12:17:29',1),(168,9,'Klein','2019-06-14 12:17:30',2),(169,9,'Groot','2019-06-14 12:39:53',2),(170,6,'Klein','2019-06-14 12:39:55',1),(171,6,'Klein','2019-06-14 12:40:21',1),(172,6,'Klein','2019-06-14 12:40:22',1),(173,6,'Klein','2019-06-14 12:40:22',1),(174,6,'Klein','2019-06-14 12:40:31',1),(175,6,'Klein','2019-06-14 12:40:33',1),(176,9,'Klein','2019-06-14 12:41:11',2),(177,9,'Klein','2019-06-14 12:41:12',2),(178,9,'Klein','2019-06-14 12:42:07',2),(179,9,'Klein','2019-06-14 12:42:08',2),(180,6,'Klein','2019-06-14 12:42:14',1),(181,9,'Klein','2019-06-14 12:42:21',2),(182,9,'Klein','2019-06-14 12:42:22',2),(183,9,'Klein','2019-06-14 12:43:54',2),(184,6,'Klein','2019-06-14 12:44:31',1),(185,6,'Klein','2019-06-14 12:44:32',1),(186,6,'Klein','2019-06-14 12:44:33',1),(187,6,'Klein','2019-06-14 12:51:37',1),(188,6,'Klein','2019-06-14 12:51:38',1),(189,6,'Klein','2019-06-14 12:51:39',1),(190,6,'Klein','2019-06-14 12:51:39',1),(191,6,'Klein','2019-06-14 12:53:41',1),(192,6,'Klein','2019-06-14 12:57:06',1),(193,6,'Klein','2019-06-14 12:58:20',1),(194,6,'Klein','2019-06-14 12:58:20',1),(195,6,'Klein','2019-06-14 13:28:28',1),(196,9,'Klein','2019-06-14 13:43:32',2),(197,9,'Klein','2019-06-14 13:43:33',2),(198,9,'Klein','2019-06-14 13:43:34',2),(199,9,'Klein','2019-06-14 13:44:29',2),(200,9,'Klein','2019-06-14 13:44:30',2),(201,6,'Klein','2019-06-14 13:44:38',1),(202,9,'Klein','2019-06-14 13:49:09',2),(203,9,'Klein','2019-06-14 13:49:26',2),(204,4,'Groot','2019-06-14 14:23:03',2),(205,6,'Klein','2019-06-14 14:23:08',1),(206,4,'Klein','2019-06-14 14:28:49',2),(207,4,'Klein','2019-06-14 14:28:51',2),(208,4,'Klein','2019-06-14 14:28:51',2),(209,4,'Klein','2019-06-14 14:28:52',2),(210,4,'Klein','2019-06-14 14:28:53',2),(211,4,'Klein','2019-06-14 14:28:58',2);
/*!40000 ALTER TABLE `portie` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reservoir`
--

DROP TABLE IF EXISTS `reservoir`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reservoir` (
  `reservoirID` int(11) NOT NULL,
  `naam` varchar(100) DEFAULT NULL,
  `cornflakesID` int(11) DEFAULT NULL,
  PRIMARY KEY (`reservoirID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reservoir`
--

LOCK TABLES `reservoir` WRITE;
/*!40000 ALTER TABLE `reservoir` DISABLE KEYS */;
INSERT INTO `reservoir` VALUES (1,'Links',6),(2,'Rechts',4);
/*!40000 ALTER TABLE `reservoir` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sensor`
--

DROP TABLE IF EXISTS `sensor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sensor` (
  `sensorID` int(11) NOT NULL,
  `beschrijving` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`sensorID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sensor`
--

LOCK TABLES `sensor` WRITE;
/*!40000 ALTER TABLE `sensor` DISABLE KEYS */;
INSERT INTO `sensor` VALUES (1,'Gewicht Links'),(2,'Gewicht Rechts'),(3,'Sonor Links'),(4,'Sonor Rechts'),(5,'Detector Links'),(6,'Detector Rechts');
/*!40000 ALTER TABLE `sensor` 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 2019-06-14 14:37:35
