-- MySQL dump 10.19  Distrib 10.3.38-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: edelmanw_rooster
-- ------------------------------------------------------
-- Server version	10.3.38-MariaDB

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

DROP TABLE IF EXISTS `Dido`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Dido` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `name` varchar(50) NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  `telefoon` varchar(30) DEFAULT NULL,
  `group_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Dido`
--

LOCK TABLES `Dido` WRITE;
/*!40000 ALTER TABLE `Dido` DISABLE KEYS */;
INSERT INTO `Dido` VALUES (1,'2023-01-14 22:17:18','2023-01-24 08:27:59','Marthe de Vries','mgvanderbijl+Marthe@gmail.com','','Voorgangers',1),(2,'2023-01-14 22:17:18','2023-01-17 17:11:19','Lense Lijzen','mgvanderbijl+Lense@gmail.com','','Voorgangers',1),(3,'2023-01-14 22:17:34','2023-01-17 17:11:19','Claartje Kruijff','mgvanderbijl+Claartje@gmail.com','','Voorgangers',1),(5,'2023-01-15 22:26:42','2023-01-17 17:06:21','Florus Kruyne','mgvanderbijl+florus@gmail.com','','Voorgangers',1),(25,'2023-01-22 21:23:46','2023-01-22 22:23:46','Annemarieke van der Woude','','','Voorgangers',1),(26,'2023-01-22 21:25:05','2023-01-22 22:25:05','Leonie van Staveren','','','Voorgangers',1),(27,'2023-01-24 07:36:42','2023-02-07 16:39:21','Maarten van der Bijl','mgvanderbijl@gmail.com','','Musici',1),(28,'2023-01-24 07:36:47','2023-01-24 08:36:47','Ere Lievonen','ere@erelievonen.org','','Musici',1),(29,'2023-01-24 07:38:08','2023-01-28 09:20:30','Arie Noordermeer','','1234567890','Kerkenraad',1),(30,'2023-01-24 14:47:09','2023-01-24 15:47:09','Maarten van Kapel','','','Musici',1),(31,'2023-01-25 09:55:57','2023-01-25 10:55:57','Alleke Wieringa','','','Voorgangers',1),(32,'2023-01-25 09:56:52','2023-01-25 10:56:52','Pieter Dronkers','','','Voorgangers',1),(33,'2023-01-25 09:57:26','2023-01-25 10:57:26','Foeke Knoppers','','','Voorgangers',1),(34,'2023-01-25 09:58:00','2023-01-25 10:58:00','Friso Boogerd','','','Voorgangers',1),(35,'2023-01-25 10:26:32','2023-01-25 11:26:32','Hugo Quené','','','AVers',1),(36,'2023-01-25 10:26:41','2023-01-30 15:23:09','Ilse Kiekebosch','ilsekiekebosch@hotmail.com','','AVers',1),(37,'2023-01-25 10:26:48','2023-01-25 11:26:48','Cor Stolk','','','AVers',1),(39,'2023-01-25 10:27:06','2023-01-25 11:27:06','Martijn Noordermeer','','','AVers',1),(40,'2023-01-25 11:00:31','2023-01-25 12:00:31','Nel Cornelissen','','','Kosters',1),(41,'2023-01-25 11:01:04','2023-02-08 11:47:51','Hans Everwennink','jw.everwennink@casema.nl','','Collectanten',1),(42,'2023-01-25 11:02:41','2023-01-25 12:02:41','Petra Sloot','','','Crecheleiders',1),(43,'2023-01-25 11:03:06','2023-02-08 12:30:55','Liesbeth Orthel','liesbeth.orthel@gmail.com','','Bloemisten',1),(44,'2023-01-25 11:03:20','2023-01-25 12:03:20','Piet Pols','','','Informanten',1),(45,'2023-01-26 12:46:04','2023-01-26 13:46:04','Jorn den Hertog','','','Voorgangers',1),(46,'2023-01-30 14:25:06','2023-01-30 15:25:06','Martijn Lijzen','',NULL,'AVers',1),(47,'2023-01-30 14:25:14','2023-01-30 15:25:14','Hugo Lijzen','',NULL,'AVers',1),(48,'2023-02-08 10:48:02','2023-02-08 11:48:58','Crina van Belzen','crinavanbelzen@kpnmail.nl',NULL,'Collectanten',1),(49,'2023-02-08 10:49:03','2023-02-08 11:50:51','Hans van Commenée','hans.van.commenee@xs4all.nl',NULL,'Collectanten',1),(50,'2023-02-08 10:49:53','2023-02-08 11:49:53','Reinie van Boetzelaer','r.j.van.boetzelaer@kpnmail.nl',NULL,'Collectanten',1),(51,'2023-02-08 10:51:30','2023-02-08 11:51:30','Nel Cornelissen','ncornelissen@hotmail.com',NULL,'Collectanten',1),(52,'2023-02-08 10:52:56','2023-02-08 11:52:56','Dion van Es','vanes.everwennink@gmail.com',NULL,'Collectanten',1),(53,'2023-02-08 10:53:12','2023-02-08 11:53:12','Simone van Es-Everwennink','vanes.everwennink@gmail.com',NULL,'Collectanten',1),(54,'2023-02-08 10:54:04','2023-02-08 11:54:04','Luuk Evers','levers@xs4all.nl',NULL,'Collectanten',1),(55,'2023-02-08 10:54:44','2023-02-08 11:54:44','Francine van Leeuwen','fcvleeuw@xs4all.nl',NULL,'Collectanten',1),(56,'2023-02-08 10:55:35','2023-02-08 11:55:35','Jeroen Everwennink','jeverwennink@gmail.com',NULL,'Collectanten',1),(57,'2023-02-08 10:56:31','2023-02-08 11:56:31','Wil Everwennink-Onnekink','jw.everwennink@casema.nl',NULL,'Collectanten',1),(58,'2023-02-08 10:57:06','2023-02-08 11:57:06','Mirjam Koelewijn','mgkoelewijn@gmail.com',NULL,'Collectanten',1),(59,'2023-02-08 10:58:15','2023-02-08 11:58:15','Marthy van de Kamp-van der Zwet','marthyvandekamp@gmail.com',NULL,'Collectanten',1),(60,'2023-02-08 10:59:03','2023-02-08 11:59:03','Marian van Leeuwen-Scheltema','marianscheltema@gmail.com',NULL,'Collectanten',1),(61,'2023-02-08 10:59:46','2023-02-08 11:59:46','Ineke Ludikhuize','ludikhuize@gmail.com',NULL,'Collectanten',1),(62,'2023-02-08 11:00:31','2023-02-08 12:00:31','Anke van Maanen','ankevanmaanen@hotmail.com',NULL,'Collectanten',1),(63,'2023-02-08 11:00:48','2023-02-08 12:00:48','Liesbeth Orthel','liesbeth.orthel@gmail.com',NULL,'Collectanten',1),(64,'2023-02-08 11:01:45','2023-02-08 12:01:45','Caecilia van Peursem','c.v.peursem@casema.nl',NULL,'Collectanten',1),(65,'2023-02-08 11:02:36','2023-02-08 12:02:36','Sytske Scheltema','sscheltema@xs4all.nl',NULL,'Collectanten',1),(66,'2023-02-08 11:03:29','2023-02-08 12:03:29','Joan Schmidt','joannemieke@kpnmail.nl',NULL,'Collectanten',1),(67,'2023-02-08 11:08:25','2023-02-08 12:08:25','Fenneken Smit-Spaan','smit.maarssen@gmail.com',NULL,'Collectanten',1),(68,'2023-02-08 11:09:05','2023-02-08 12:09:05','Lies van Weezel','l.gvanweezel@planet.nl',NULL,'Collectanten',1),(69,'2023-02-08 11:30:58','2023-02-08 12:31:24','Aalke Blindenbach','blindenbach@xs4all.nl',NULL,'Bloemisten',1),(70,'2023-02-08 11:31:53','2023-02-08 12:31:53','Tiny de Boer','tentdeboer@ziggo.nl',NULL,'Bloemisten',1),(71,'2023-02-08 11:32:22','2023-02-08 12:32:22','Beertje de Boer','beertjedeboer@gmail.com',NULL,'Bloemisten',1),(72,'2023-02-08 11:32:52','2023-02-08 12:32:52','Hansje Bootsma-Nolen','jmcbootsma-nolen@ziggo.nl',NULL,'Bloemisten',1),(73,'2023-02-08 11:33:37','2023-02-08 12:33:37','Hannie van den Burg-Holleman','hannieburgholleman@gmail.com',NULL,'Bloemisten',1),(74,'2023-02-08 11:34:11','2023-02-08 12:34:11','Nel Cornelissen','ncornelissen@hotmail.com',NULL,'Bloemisten',1),(75,'2023-02-08 11:34:46','2023-02-08 12:34:46','Gerda Faddegon','gerda.faddegon@telfort.nl',NULL,'Bloemisten',1),(76,'2023-02-08 11:35:41','2023-02-08 12:35:41','Marieke Fonk','mfonk@casema.nl',NULL,'Bloemisten',1),(77,'2023-02-08 11:36:10','2023-02-08 12:36:10','Judith Fournier','judithmoesman@gmail.com',NULL,'Bloemisten',1),(78,'2023-02-08 11:36:38','2023-02-08 12:36:38','Rinus Gerlofsma','rinus.gerlofsma@xs4all.nl',NULL,'Bloemisten',1),(79,'2023-02-08 11:37:06','2023-02-08 12:37:58','Els Jimkes','ejimkes@gmail.com',NULL,'Bloemisten',1),(80,'2023-02-08 11:38:10','2023-02-08 12:38:10','Madelon Kapteijn','madelonkapteijn@kpnmail.nl',NULL,'Bloemisten',1),(81,'2023-02-08 11:38:27','2023-02-08 12:39:17','Stef Knuvelder','pvanbeukelen@gmail.com',NULL,'Bloemisten',1),(82,'2023-02-08 11:39:36','2023-02-08 12:39:36','Mirjam Koelewijn','mgkoelewijn@gmail.com',NULL,'Bloemisten',1),(83,'2023-02-08 11:41:28','2023-02-08 12:41:28','Mary Kuiper','MaryKuiper@mk-perspectief.nl',NULL,'Bloemisten',1),(84,'2023-02-08 11:44:08','2023-02-08 12:44:08','Tineke Kuitert','tikuitert@gmail.com',NULL,'Bloemisten',1),(85,'2023-02-08 11:44:39','2023-02-08 12:44:39','Marian van Leeuwen-Scheltema','marianscheltema@gmail.com',NULL,'Bloemisten',1),(86,'2023-02-08 11:45:32','2023-02-08 12:45:32','Jorien de Loor','joriendeloor@gmail.com',NULL,'Bloemisten',1),(87,'2023-02-08 11:46:47','2023-02-08 12:46:47','Dorine Maris','tjemaris@hotmail.com',NULL,'Bloemisten',1),(88,'2023-02-08 11:47:46','2023-02-08 12:47:46','Fien Mollema','finiemollema@gmail.com',NULL,'Bloemisten',1),(89,'2023-02-08 11:51:29','2023-02-08 12:51:29','Liesbeth Orthel','liesbeth.orthel@gmail.com',NULL,'Bloemisten',1),(90,'2023-02-08 11:52:36','2023-02-08 12:52:36','Inge van de Pavoordt','ingevandepavoordt@kpnmail.nl',NULL,'Bloemisten',1),(91,'2023-02-08 11:53:01','2023-02-08 12:53:01','Caecilia van Peursem','c.v.peursem@casema.nl',NULL,'Bloemisten',1),(92,'2023-02-08 11:53:44','2023-02-08 12:53:44','Mieke Raedts','mraedtsdehaes@gmail.com',NULL,'Bloemisten',1),(93,'2023-02-08 11:54:05','2023-02-08 12:54:05','Sytske Scheltema','sscheltema@xs4all.nl',NULL,'Bloemisten',1),(94,'2023-02-08 11:54:59','2023-02-08 12:54:59','Wendela Schenk','wensch@xs4all.nl',NULL,'Bloemisten',1),(95,'2023-02-08 11:55:55','2023-02-08 12:55:55','Barbara Schouten','barbara.schouten@planet.nl',NULL,'Bloemisten',1),(96,'2023-02-08 11:57:57','2023-02-08 12:57:57','Els Snijders','j.g.snijders@hetnet.nl',NULL,'Bloemisten',1),(97,'2023-02-08 11:58:27','2023-02-08 12:58:27','Annemieke Straver','joannemieke@kpnmail.nl',NULL,'Bloemisten',1),(98,'2023-02-08 12:00:13','2023-02-08 13:00:13','Jacobi Verheul','jverheulvliegenthart@gmail.com',NULL,'Bloemisten',1),(99,'2023-02-08 12:00:56','2023-02-08 13:00:56','Lies van Weezel','l.gvanweezel@planet.nl',NULL,'Bloemisten',1),(100,'2023-02-08 12:05:10','2023-02-08 13:07:15','Dieuwke Piebenga','dieuwkepiebenga@hotmail.com',NULL,'Bloemisten',1),(101,'2023-02-08 12:12:26','2023-02-08 13:12:26','Ineke Hoogstrate','hoogstr.looij@gmail.com',NULL,'Bloemisten',1);
/*!40000 ALTER TABLE `Dido` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Logbook`
--

DROP TABLE IF EXISTS `Logbook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Logbook` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gebruiker` varchar(30) NOT NULL,
  `message` varchar(225) NOT NULL,
  `timestamp` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Logbook`
--

LOCK TABLES `Logbook` WRITE;
/*!40000 ALTER TABLE `Logbook` DISABLE KEYS */;
INSERT INTO `Logbook` VALUES (1,'Maarten','Datum: 2023-02-05 Omschrijving => asdf','2023-02-05 20:33:03'),(2,'Maarten','Datum: 2023-02-12 Omschrijving => df','2023-02-05 20:33:04'),(3,'Maarten','edit 2023-02-05: Omschrijving => ','2023-02-05 20:33:49'),(4,'Maarten','edit 2023-02-12: Omschrijving => ','2023-02-05 20:33:50'),(5,'Maarten','2023-02-05: Omschrijving => asdf','2023-02-05 20:35:01'),(6,'Maarten','2023-02-12: Omschrijving => asdf','2023-02-05 20:35:02'),(7,'Maarten','2023-02-05: Omschrijving => verwijderd','2023-02-05 20:35:04'),(8,'Maarten','2023-02-12: Omschrijving => asdfasdf','2023-02-05 20:35:05'),(9,'Maarten','2023-02-12: Omschrijving verwijderd','2023-02-05 20:35:58'),(10,'Maarten','2023-02-05: Tijd => 10:31','2023-02-05 20:36:36'),(11,'Maarten','2023-02-05: Voorganger => [\"2\",\"31\"]','2023-02-05 20:36:38'),(12,'Maarten','2023-02-05: Thema => asdf','2023-02-05 20:36:43'),(13,'Maarten','2023-02-05: Voorganger => [\"2\"]','2023-02-05 20:36:43'),(14,'Maarten','2023-02-05: Thema verwijderd','2023-02-05 20:36:47'),(15,'Maarten','2023-02-05: Dopen => 1','2023-02-05 20:36:47'),(16,'Maarten','2023-02-05: Dopen => 0','2023-02-05 20:36:48'),(17,'Maarten','2023-02-05: Verteluur => 1','2023-02-05 20:36:49'),(18,'Maarten','2023-02-05: Verteluur => 0','2023-02-05 20:36:49'),(19,'Ilse','2023-02-12: Dopen => 0','2023-02-05 20:42:10'),(20,'Ilse','2023-02-12: Dopen => 1','2023-02-05 20:42:10'),(21,'Maarten','2023-02-12: Dopen => 0','2023-02-06 08:03:43'),(22,'Maarten','2023-02-12: Dopen => 1','2023-02-06 08:03:44'),(23,'Maarten','2023-02-12: Muziek => [\"27\"]','2023-02-07 07:31:28'),(24,'Maarten','2023-02-12: Voorganger => [\"1\",\"25\"]','2023-02-07 16:06:04'),(25,'Maarten','2023-02-19: Muziek => [\"27\"]','2023-02-07 16:38:59'),(26,'Liesbeth','2023-02-12: Voorganger => [\"1\"]','2023-02-08 10:01:53'),(27,'Liesbeth','2023-02-12: Collectanten => [\"48\"]','2023-02-08 12:09:35'),(28,'Liesbeth','2023-02-12: Collectanten => [\"48\",\"58\"]','2023-02-08 12:09:51'),(29,'Liesbeth','2023-02-12: Collectanten => [\"48\",\"58\",\"59\"]','2023-02-08 12:10:00'),(30,'Liesbeth','2023-02-12: Collectanten => [\"48\",\"58\",\"59\",\"66\"]','2023-02-08 12:10:08'),(31,'Liesbeth','2023-02-19: Collectanten => [\"41\"]','2023-02-08 12:10:35'),(32,'Liesbeth','2023-02-19: Collectanten => [\"41\",\"57\"]','2023-02-08 12:10:41'),(33,'Liesbeth','2023-02-19: Collectanten => [\"41\",\"57\",\"60\"]','2023-02-08 12:10:52'),(34,'Liesbeth','2023-02-19: Collectanten => [\"41\",\"57\",\"60\",\"68\"]','2023-02-08 12:11:03'),(35,'Liesbeth','2023-02-26: Collectanten => [\"51\"]','2023-02-08 12:11:14'),(36,'Liesbeth','2023-02-26: Collectanten => [\"51\",\"52\"]','2023-02-08 12:11:35'),(37,'Liesbeth','2023-02-26: Collectanten => [\"51\",\"52\",\"53\"]','2023-02-08 12:11:41'),(38,'Liesbeth','2023-02-26: Collectanten => [\"51\",\"52\",\"53\",\"61\"]','2023-02-08 12:11:52'),(39,'Liesbeth','2023-03-05: Collectanten => [\"49\"]','2023-02-08 12:15:33'),(40,'Liesbeth','2023-03-05: Collectanten => [\"49\",\"56\"]','2023-02-08 12:15:47'),(41,'Liesbeth','2023-03-05: Collectanten => [\"49\",\"56\",\"62\"]','2023-02-08 12:15:57'),(42,'Liesbeth','2023-03-05: Collectanten => [\"49\",\"56\",\"62\",\"60\"]','2023-02-08 12:16:18'),(43,'Liesbeth','2023-03-12: Collectanten => [\"54\"]','2023-02-08 12:16:27'),(44,'Liesbeth','2023-03-12: Collectanten => [\"54\",\"55\"]','2023-02-08 12:16:32'),(45,'Liesbeth','2023-03-12: Collectanten => [\"54\",\"55\",\"63\"]','2023-02-08 12:16:53'),(46,'Liesbeth','2023-03-12: Collectanten => [\"54\",\"55\",\"63\",\"67\"]','2023-02-08 12:16:59'),(47,'Liesbeth','2023-03-19: Collectanten => [\"50\"]','2023-02-08 12:17:11'),(48,'Liesbeth','2023-03-19: Collectanten => [\"50\",\"51\"]','2023-02-08 12:17:17'),(49,'Liesbeth','2023-03-19: Collectanten => [\"50\",\"51\",\"66\"]','2023-02-08 12:17:29'),(50,'Liesbeth','2023-03-19: Collectanten => [\"50\",\"51\",\"66\",\"64\"]','2023-02-08 12:17:33'),(51,'Liesbeth','2023-03-26: Collectanten => [\"48\"]','2023-02-08 12:17:45'),(52,'Liesbeth','2023-03-26: Collectanten => [\"48\",\"58\"]','2023-02-08 12:17:56'),(53,'Liesbeth','2023-03-26: Collectanten => [\"48\",\"58\",\"60\"]','2023-02-08 12:18:07'),(54,'Liesbeth','2023-03-26: Collectanten => [\"48\",\"58\",\"60\",\"61\"]','2023-02-08 12:18:14'),(55,'Liesbeth','2023-04-02: Collectanten => [\"52\"]','2023-02-08 12:18:21'),(56,'Liesbeth','2023-04-02: Collectanten => [\"52\",\"53\"]','2023-02-08 12:18:30'),(57,'Liesbeth','2023-04-02: Collectanten => [\"52\",\"53\",\"65\"]','2023-02-08 12:18:45'),(58,'Liesbeth','2023-04-06: Collectanten => [\"41\"]','2023-02-08 12:19:02'),(59,'Liesbeth','2023-04-06: Collectanten => [\"41\",\"57\"]','2023-02-08 12:19:09'),(60,'Liesbeth','2023-04-06: Collectanten => [\"41\",\"57\",\"62\"]','2023-02-08 12:19:20'),(61,'Liesbeth','2023-04-06: Collectanten => [\"41\",\"57\",\"62\",\"68\"]','2023-02-08 12:19:29'),(62,'Liesbeth','2023-04-09: Collectanten => [\"49\"]','2023-02-08 12:20:02'),(63,'Liesbeth','2023-04-09: Collectanten => [\"49\",\"54\"]','2023-02-08 12:20:11'),(64,'Liesbeth','2023-04-09: Collectanten => [\"49\",\"54\",\"55\"]','2023-02-08 12:20:16'),(65,'Liesbeth','2023-04-09: Collectanten => [\"49\",\"54\",\"55\",\"59\"]','2023-02-08 12:20:25'),(66,'Liesbeth','2023-04-16: Collectanten => [\"56\"]','2023-02-08 12:20:40'),(67,'Liesbeth','2023-04-16: Collectanten => [\"56\",\"63\"]','2023-02-08 12:20:52'),(68,'Liesbeth','2023-04-16: Collectanten => [\"56\",\"63\",\"64\"]','2023-02-08 12:21:00'),(69,'Liesbeth','2023-04-16: Collectanten => [\"56\",\"63\",\"64\",\"66\"]','2023-02-08 12:21:08'),(70,'Liesbeth','2023-04-23: Collectanten => [\"51\"]','2023-02-08 12:21:29'),(71,'Liesbeth','2023-04-23: Collectanten => [\"51\",\"58\"]','2023-02-08 12:21:38'),(72,'Liesbeth','2023-04-23: Collectanten => [\"51\",\"58\",\"61\"]','2023-02-08 12:21:45'),(73,'Liesbeth','2023-04-23: Collectanten => [\"51\",\"58\",\"61\",\"67\"]','2023-02-08 12:21:53'),(74,'Liesbeth','2023-04-30: Collectanten => [\"48\"]','2023-02-08 12:21:59'),(75,'Liesbeth','2023-04-30: Collectanten => [\"48\",\"50\"]','2023-02-08 12:22:03'),(76,'Liesbeth','2023-04-30: Collectanten => [\"48\",\"50\",\"60\"]','2023-02-08 12:22:13'),(77,'Liesbeth','2023-04-30: Collectanten => [\"48\",\"50\",\"60\",\"65\"]','2023-02-08 12:22:22'),(78,'Liesbeth','2023-05-07: Collectanten => [\"52\"]','2023-02-08 12:22:29'),(79,'Liesbeth','2023-05-07: Collectanten => [\"52\",\"53\"]','2023-02-08 12:22:36'),(80,'Liesbeth','2023-05-07: Collectanten => [\"52\",\"53\",\"62\"]','2023-02-08 12:22:45'),(81,'Liesbeth','2023-05-14: Collectanten => [\"54\"]','2023-02-08 12:23:00'),(82,'Liesbeth','2023-05-14: Collectanten => [\"54\",\"55\"]','2023-02-08 12:23:05'),(83,'Liesbeth','2023-05-14: Collectanten => [\"54\",\"55\",\"41\"]','2023-02-08 12:23:13'),(84,'Liesbeth','2023-05-14: Collectanten => [\"54\",\"55\",\"41\",\"57\"]','2023-02-08 12:23:17'),(85,'Liesbeth','2023-05-21: Collectanten => [\"41\"]','2023-02-08 12:23:33'),(86,'Liesbeth','2023-05-21: Collectanten => [\"41\",\"51\"]','2023-02-08 12:23:38'),(87,'Liesbeth','2023-05-21: Collectanten => [\"41\",\"51\",\"56\"]','2023-02-08 12:23:48'),(88,'Liesbeth','2023-05-21: Collectanten => [\"41\",\"51\",\"56\",\"68\"]','2023-02-08 12:23:57'),(89,'Liesbeth','2023-05-28: Collectanten => [\"48\"]','2023-02-08 12:24:10'),(90,'Liesbeth','2023-05-28: Collectanten => [\"48\",\"59\"]','2023-02-08 12:24:18'),(91,'Liesbeth','2023-05-28: Collectanten => [\"48\",\"59\",\"63\"]','2023-02-08 12:24:25'),(92,'Liesbeth','2023-05-28: Collectanten => [\"48\",\"59\",\"63\",\"65\"]','2023-02-08 12:24:34'),(93,'Liesbeth','2023-06-04: Collectanten => [\"58\"]','2023-02-08 12:24:45'),(94,'Liesbeth','2023-06-04: Collectanten => [\"58\",\"60\"]','2023-02-08 12:25:34'),(95,'Liesbeth','2023-06-04: Collectanten => [\"58\",\"60\",\"61\"]','2023-02-08 12:25:41'),(96,'Liesbeth','2023-06-11: Collectanten => [\"52\"]','2023-02-08 12:25:58'),(97,'Liesbeth','2023-06-11: Collectanten => [\"52\",\"53\"]','2023-02-08 12:26:02'),(98,'Liesbeth','2023-06-11: Collectanten => [\"52\",\"53\",\"66\"]','2023-02-08 12:26:12'),(99,'Liesbeth','2023-06-11: Collectanten => [\"52\",\"53\",\"66\",\"67\"]','2023-02-08 12:26:16'),(100,'Liesbeth','2023-06-18: Collectanten => [\"54\"]','2023-02-08 12:26:42'),(101,'Liesbeth','2023-06-18: Collectanten => [\"54\",\"55\"]','2023-02-08 12:26:47'),(102,'Liesbeth','2023-06-18: Collectanten => [\"54\",\"55\",\"62\"]','2023-02-08 12:26:58'),(103,'Liesbeth','2023-06-18: Collectanten => [\"54\",\"55\",\"62\",\"64\"]','2023-02-08 12:27:06'),(104,'Liesbeth','2023-06-25: Collectanten => [\"49\"]','2023-02-08 12:27:20'),(105,'Liesbeth','2023-06-25: Collectanten => [\"49\",\"56\"]','2023-02-08 12:27:28'),(106,'Liesbeth','2023-06-25: Collectanten => [\"49\",\"56\",\"63\"]','2023-02-08 12:27:36'),(107,'Liesbeth','2023-06-25: Collectanten => [\"49\",\"56\",\"63\",\"68\"]','2023-02-08 12:27:48'),(108,'Liesbeth','2023-07-02: Collectanten => [\"48\"]','2023-02-08 12:28:04'),(109,'Liesbeth','2023-07-02: Collectanten => [\"48\",\"50\"]','2023-02-08 12:28:10'),(110,'Liesbeth','2023-07-02: Collectanten => [\"48\",\"50\",\"51\"]','2023-02-08 12:28:19'),(111,'Liesbeth','2023-07-09: Collectanten => [\"58\"]','2023-02-08 12:28:31'),(112,'Liesbeth','2023-07-09: Collectanten => [\"58\",\"59\"]','2023-02-08 12:28:37'),(113,'Liesbeth','2023-07-09: Collectanten => [\"58\",\"59\",\"60\"]','2023-02-08 12:28:43'),(114,'Liesbeth','2023-07-09: Collectanten => [\"58\",\"59\",\"60\",\"61\"]','2023-02-08 12:28:52'),(115,'Liesbeth','2023-07-16: Collectanten => [\"62\"]','2023-02-08 12:29:07'),(116,'Liesbeth','2023-07-16: Collectanten => [\"62\",\"65\"]','2023-02-08 12:29:15'),(117,'Liesbeth','2023-07-16: Collectanten => [\"62\",\"65\",\"66\"]','2023-02-08 12:29:23'),(118,'Liesbeth','2023-07-16: Collectanten => [\"62\",\"65\",\"66\",\"67\"]','2023-02-08 12:29:31'),(119,'Liesbeth','2023-02-12: Bloemen => [\"96\"]','2023-02-08 13:07:32'),(120,'Liesbeth','2023-02-19: Bloemen => [\"94\"]','2023-02-08 13:07:40'),(121,'Liesbeth','2023-02-26: Bloemen => [\"91\"]','2023-02-08 13:07:45'),(122,'Liesbeth','2023-03-05: Bloemen => [\"93\"]','2023-02-08 13:07:50'),(123,'Liesbeth','2023-03-12: Bloemen => [\"76\"]','2023-02-08 13:08:00'),(124,'Liesbeth','2023-03-19: Bloemen => [\"97\"]','2023-02-08 13:08:08'),(125,'Liesbeth','2023-03-26: Bloemen => [\"92\"]','2023-02-08 13:08:19'),(126,'Liesbeth','2023-04-02: Bloemen => [\"72\"]','2023-02-08 13:08:28'),(127,'Liesbeth','2023-04-06: Bloemen => [\"74\"]','2023-02-08 13:08:32'),(128,'Liesbeth','2023-04-07: Bloemen => [\"74\"]','2023-02-08 13:08:41'),(129,'Liesbeth','2023-04-09: Bloemen => [\"74\"]','2023-02-08 13:09:03'),(130,'Liesbeth','2023-04-16: Bloemen => [\"77\"]','2023-02-08 13:09:11'),(131,'Liesbeth','2023-04-23: Bloemen => [\"84\"]','2023-02-08 13:09:32'),(132,'Liesbeth','2023-04-30: Bloemen => [\"80\"]','2023-02-08 13:09:40'),(133,'Liesbeth','2023-05-07: Bloemen => [\"83\"]','2023-02-08 13:09:52'),(134,'Liesbeth','2023-05-14: Bloemen => [\"82\"]','2023-02-08 13:09:58'),(135,'Liesbeth','2023-05-28: Bloemen => [\"88\"]','2023-02-08 13:10:10'),(136,'Liesbeth','2023-06-04: Bloemen => [\"99\"]','2023-02-08 13:10:15'),(137,'Liesbeth','2023-06-11: Bloemen => [\"71\"]','2023-02-08 13:10:23'),(138,'Liesbeth','2023-06-18: Bloemen => [\"79\"]','2023-02-08 13:10:46'),(139,'Liesbeth','2023-06-25: Bloemen => [\"86\"]','2023-02-08 13:10:51'),(140,'Liesbeth','2023-07-02: Bloemen => [\"85\"]','2023-02-08 13:10:55'),(141,'Liesbeth','2023-07-09: Bloemen => [\"87\"]','2023-02-08 13:11:01'),(142,'Liesbeth','2023-07-16: Bloemen => [\"101\"]','2023-02-08 13:12:46'),(143,'Liesbeth','2023-07-23: Bloemen => [\"70\"]','2023-02-08 13:12:52'),(144,'Liesbeth','2023-07-30: Bloemen => [\"73\"]','2023-02-08 13:12:57'),(145,'Liesbeth','2023-08-06: Bloemen => [\"77\"]','2023-02-08 13:13:02'),(146,'Liesbeth','2023-08-13: Bloemen => [\"69\"]','2023-02-08 13:13:07'),(147,'Liesbeth','2023-08-20: Bloemen => [\"89\"]','2023-02-08 13:13:13'),(148,'Liesbeth','2023-08-27: Bloemen => [\"88\"]','2023-02-08 13:13:21'),(149,'Liesbeth','2023-07-23: Bloemen => []','2023-02-08 13:13:47'),(150,'Liesbeth','2023-07-30: Bloemen => []','2023-02-08 13:13:48'),(151,'Liesbeth','2023-08-06: Bloemen => []','2023-02-08 13:13:50'),(152,'Liesbeth','2023-08-13: Bloemen => []','2023-02-08 13:13:51'),(153,'Liesbeth','2023-08-20: Bloemen => []','2023-02-08 13:13:53'),(154,'Liesbeth','2023-08-27: Bloemen => []','2023-02-08 13:13:56'),(155,'Liesbeth','2023-08-06: Bloemen => [\"70\"]','2023-02-08 13:14:19'),(156,'Liesbeth','2023-08-13: Bloemen => [\"73\"]','2023-02-08 13:14:23'),(157,'Liesbeth','2023-08-20: Bloemen => [\"77\"]','2023-02-08 13:14:32'),(158,'Liesbeth','2023-08-27: Bloemen => [\"69\"]','2023-02-08 13:14:38'),(159,'Liesbeth','2023-09-03: Bloemen => [\"89\"]','2023-02-08 13:14:44'),(160,'Liesbeth','2023-09-10: Bloemen => [\"88\"]','2023-02-08 13:14:56'),(161,'Liesbeth','2023-09-17: Bloemen => [\"75\"]','2023-02-08 13:15:00'),(162,'Liesbeth','2023-09-24: Bloemen => [\"82\"]','2023-02-08 13:15:08'),(163,'Liesbeth','2023-10-01: Bloemen => [\"92\"]','2023-02-08 13:15:14'),(164,'Liesbeth','2023-10-08: Bloemen => [\"78\"]','2023-02-08 13:15:21'),(165,'Liesbeth','2023-10-15: Bloemen => [\"90\"]','2023-02-08 13:15:31'),(166,'Liesbeth','2023-10-22: Bloemen => [\"99\"]','2023-02-08 13:15:37'),(167,'Liesbeth','2023-10-29: Bloemen => [\"73\"]','2023-02-08 13:15:47'),(168,'Liesbeth','2023-10-29: Bloemen => []','2023-02-08 13:15:51'),(169,'Liesbeth','2023-10-29: Bloemen => [\"72\"]','2023-02-08 13:15:54'),(170,'Liesbeth','2023-11-05: Bloemen => [\"96\"]','2023-02-08 13:16:17'),(171,'Liesbeth','2023-11-12: Bloemen => [\"93\"]','2023-02-08 13:16:23'),(172,'Liesbeth','2023-11-19: Bloemen => [\"86\"]','2023-02-08 13:16:28'),(173,'Liesbeth','2023-11-26: Bloemen => [\"69\"]','2023-02-08 13:16:32'),(174,'Liesbeth','2023-12-24: Bloemen => [\"88\"]','2023-02-08 13:16:52'),(175,'Liesbeth','2023-12-24: Bloemen => [\"88\"]','2023-02-08 13:17:01'),(176,'Liesbeth','2023-12-25: Bloemen => [\"88\"]','2023-02-08 13:17:13');
/*!40000 ALTER TABLE `Logbook` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Permissions`
--

DROP TABLE IF EXISTS `Permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Permissions` (
  `role` varchar(255) DEFAULT NULL,
  `field` varchar(255) DEFAULT NULL,
  `permission` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Permissions`
--

LOCK TABLES `Permissions` WRITE;
/*!40000 ALTER TABLE `Permissions` DISABLE KEYS */;
INSERT INTO `Permissions` VALUES ('beheer','id',0),('beheer','created_at',0),('beheer','updated_at',0),('beheer','Datum',2),('beheer','Tijd',2),('beheer','Omschrijving',2),('beheer','Voorganger',2),('beheer','Thema',2),('beheer','Dopen',2),('beheer','Creche',2),('beheer','Verteluur',2),('beheer','Aantekeningen',2),('beheer','Opstelling',2),('beheer','Tafelviering',2),('cantor','id',0),('cantor','created_at',0),('cantor','updated_at',0),('cantor','Datum',1),('cantor','Tijd',1),('cantor','Omschrijving',1),('cantor','Voorganger',1),('cantor','Thema',1),('cantor','Tafelviering',1),('cantor','Dopen',1),('cantor','Creche',0),('cantor','Verteluur',0),('cantor','Aantekeningen',2),('cantor','Opstelling',2),('beheer','Muziek',2),('beheer','Collectanten',2),('beheer','Bloemen',2),('beheer','Luiden',2),('cantor','Muziek',2),('cantor','Collectanten',0),('cantor','Bloemen',0),('cantor','Luiden',2),('audiovisueel_view','id',0),('audiovisueel_view','created_at',0),('audiovisueel_view','updated_at',0),('audiovisueel_view','Datum',1),('audiovisueel_view','Tijd',1),('audiovisueel_view','Omschrijving',1),('audiovisueel_view','Voorganger',1),('audiovisueel_view','Thema',0),('audiovisueel_view','Tafelviering',1),('audiovisueel_view','Dopen',1),('audiovisueel_view','Creche',0),('audiovisueel_view','Verteluur',0),('audiovisueel_view','Muziek',1),('audiovisueel_view','Collectanten',0),('audiovisueel_view','Bloemen',0),('audiovisueel_view','Luiden',0),('audiovisueel_view','Aantekeningen',0),('audiovisueel_view','Opstelling',1),('Audiovisueel_edit','id',0),('Audiovisueel_edit','created_at',0),('Audiovisueel_edit','updated_at',0),('Audiovisueel_edit','Datum',1),('Audiovisueel_edit','Tijd',1),('Audiovisueel_edit','Omschrijving',1),('Audiovisueel_edit','Voorganger',1),('Audiovisueel_edit','Thema',0),('Audiovisueel_edit','Tafelviering',1),('Audiovisueel_edit','Dopen',1),('Audiovisueel_edit','Creche',0),('Audiovisueel_edit','Verteluur',0),('Audiovisueel_edit','Muziek',1),('Audiovisueel_edit','Collectanten',0),('Audiovisueel_edit','Bloemen',0),('Audiovisueel_edit','Luiden',0),('Audiovisueel_edit','Aantekeningen',0),('Audiovisueel_edit','Opstelling',1),('PC','id',0),('PC','created_at',0),('PC','updated_at',0),('PC','Datum',1),('PC','Tijd',1),('PC','Omschrijving',2),('PC','Voorganger',2),('PC','Thema',2),('PC','Tafelviering',2),('PC','Dopen',2),('PC','Creche',2),('PC','Verteluur',2),('PC','Muziek',1),('PC','Collectanten',1),('PC','Bloemen',1),('PC','Luiden',0),('PC','Aantekeningen',2),('PC','Opstelling',1),('kr_readonly','id',0),('kr_readonly','created_at',0),('kr_readonly','updated_at',0),('kr_readonly','Datum',1),('kr_readonly','Tijd',1),('kr_readonly','Omschrijving',1),('kr_readonly','Voorganger',1),('kr_readonly','Thema',1),('kr_readonly','Tafelviering',1),('kr_readonly','Dopen',1),('kr_readonly','Creche',1),('kr_readonly','Verteluur',1),('kr_readonly','Muziek',1),('kr_readonly','Collectanten',1),('kr_readonly','Bloemen',1),('kr_readonly','Luiden',1),('kr_readonly','Aantekeningen',1),('kr_readonly','Opstelling',1),('beheer','Informatietafel',2),('cantor','Informatietafel',0),('audiovisueel_view','Informatietafel',0),('Audiovisueel_edit','Informatietafel',0),('PC','Informatietafel',0),('kr_readonly','Informatietafel',1),('beheer','Crecheleiding',2),('cantor','Crecheleiding',0),('audiovisueel_view','Crecheleiding',0),('Audiovisueel_edit','Crecheleiding',0),('PC','Crecheleiding',2),('kr_readonly','Crecheleiding',1),('beheer','Kosters',2),('cantor','Kosters',0),('audiovisueel_view','Kosters',0),('Audiovisueel_edit','Kosters',0),('PC','Kosters',0),('kr_readonly','Kosters',1),('beheer','Koor',2),('cantor','Koor',2),('audiovisueel_view','Koor',1),('Audiovisueel_edit','Koor',1),('PC','Koor',1),('kr_readonly','Koor',1),('beheer','Audiovisueel_1',2),('beheer','Audiovisueel_2',2),('cantor','Audiovisueel_1',0),('cantor','Audiovisueel_2',0),('audiovisueel_view','Audiovisueel_1',1),('audiovisueel_view','Audiovisueel_2',1),('Audiovisueel_edit','Audiovisueel_1',2),('Audiovisueel_edit','Audiovisueel_2',2),('PC','Audiovisueel_1',1),('PC','Audiovisueel_2',1),('kr_readonly','Audiovisueel_1',1),('kr_readonly','Audiovisueel_2',1),('beheer','Kerkenraad_1',2),('beheer','Kerkenraad_2',2),('cantor','Kerkenraad_1',1),('cantor','Kerkenraad_2',1),('audiovisueel_view','Kerkenraad_1',0),('audiovisueel_view','Kerkenraad_2',0),('Audiovisueel_edit','Kerkenraad_1',0),('Audiovisueel_edit','Kerkenraad_2',0),('PC','Kerkenraad_1',1),('PC','Kerkenraad_2',1),('kr_readonly','Kerkenraad_1',1),('kr_readonly','Kerkenraad_2',1),('Liesbeth','id',0),('Liesbeth','created_at',0),('Liesbeth','updated_at',0),('Liesbeth','Datum',1),('Liesbeth','Tijd',1),('Liesbeth','Omschrijving',1),('Liesbeth','Voorganger',2),('Liesbeth','Thema',1),('Liesbeth','Tafelviering',1),('Liesbeth','Dopen',1),('Liesbeth','Verteluur',1),('Liesbeth','Muziek',1),('Liesbeth','Koor',1),('Liesbeth','Kerkenraad_1',0),('Liesbeth','Kerkenraad_2',0),('Liesbeth','Kosters',0),('Liesbeth','Collectanten',2),('Liesbeth','Creche',0),('Liesbeth','Crecheleiding',0),('Liesbeth','Bloemen',2),('Liesbeth','Informatietafel',0),('Liesbeth','Audiovisueel_1',0),('Liesbeth','Audiovisueel_2',0),('Liesbeth','Luiden',0),('Liesbeth','Aantekeningen',0),('Liesbeth','Opstelling',0);
/*!40000 ALTER TABLE `Permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Rooster`
--

DROP TABLE IF EXISTS `Rooster`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Rooster` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Datum` date NOT NULL,
  `Tijd` time DEFAULT NULL,
  `Omschrijving` varchar(45) DEFAULT NULL,
  `Voorganger` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `Thema` varchar(45) DEFAULT NULL,
  `Tafelviering` tinyint(1) DEFAULT NULL,
  `Dopen` tinyint(1) DEFAULT NULL,
  `Verteluur` tinyint(1) DEFAULT NULL,
  `Muziek` longtext NOT NULL,
  `Koor` varchar(40) DEFAULT NULL,
  `Kerkenraad_1` longtext DEFAULT NULL,
  `Kerkenraad_2` longtext DEFAULT NULL,
  `Kosters` longtext DEFAULT NULL,
  `Collectanten` longtext DEFAULT NULL,
  `Creche` tinyint(1) DEFAULT NULL,
  `Crecheleiding` longtext DEFAULT NULL,
  `Bloemen` longtext DEFAULT NULL,
  `Informatietafel` longtext DEFAULT NULL,
  `Audiovisueel_1` longtext NOT NULL,
  `Audiovisueel_2` longtext NOT NULL,
  `Luiden` varchar(40) DEFAULT NULL,
  `Aantekeningen` text DEFAULT NULL,
  `Opstelling` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=890 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Rooster`
--

LOCK TABLES `Rooster` WRITE;
/*!40000 ALTER TABLE `Rooster` DISABLE KEYS */;
INSERT INTO `Rooster` VALUES (1,'2022-10-13 12:18:09','2023-01-02 18:32:45','2023-01-01','10:30:00','Nieuwjaarsontvangst','','',0,0,0,'','','','','','',0,'','','','','','Gertrut en JMJ','','Kerkopstelling'),(62,'2022-10-17 09:09:00','2023-01-06 14:58:43','2023-01-08','10:30:00','','','',1,0,0,'','','','','Naam1\nNaam2','Crina van Belzen\nMirjam Koelewijn\nMarian van Leeuwen\nAnke van Maanen',0,'','','','','','Gertrut en JMJ','','Kerkopstelling'),(63,'2022-10-17 09:09:00','2023-01-14 22:47:23','2023-01-15','10:30:00','Week van de eenheid','[\"1\",\"2\"]','',0,0,NULL,'','','','','','Dion van Es\nSimone van Es\nLiesbeth Orthel\nLies van Weezel',0,'','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(64,'2022-10-17 09:09:00','2023-01-14 22:38:45','2023-01-22','10:30:00','Week van de eenheid','[\"1\"]','',NULL,1,NULL,'','','','','','',NULL,'','','','','','Gertrut en JMJ','Doopdienst ','Kerkopstelling'),(65,'2022-10-17 09:09:00','2023-01-26 23:08:46','2023-01-29','10:30:00','','[\"5\"]','',NULL,NULL,NULL,'[\"27\"]','','[\"29\"]','[]','','',NULL,'','','','[\"36\"]','[\"35\"]','Gertrut en JMJ','asdf','Kerkopstelling'),(66,'2022-10-17 09:09:00','2023-02-05 19:36:49','2023-02-05','10:31:00','','[\"2\"]','',1,0,0,'[\"27\"]','Cantorij','','','[\"40\"]','',NULL,'','','','[\"37\"]','[\"39\"]','Gertrut en JMJ',NULL,'Dwarsopstelling'),(67,'2022-10-17 09:09:00','2023-02-08 12:07:32','2023-02-12','10:30:00','','[\"1\"]','',NULL,1,NULL,'[\"27\"]','','','','','[\"48\",\"58\",\"59\",\"66\"]',NULL,'','[\"96\"]','','[\"47\",\"46\"]','[\"37\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(68,'2022-10-17 09:09:00','2023-02-08 12:07:40','2023-02-19','10:30:00','','[\"3\"]','',NULL,NULL,NULL,'[\"27\"]','','','','','[\"41\",\"57\",\"60\",\"68\"]',0,'','[\"94\"]','','[\"35\"]','[\"39\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(69,'2022-10-17 09:09:00','2023-02-08 12:07:45','2023-02-26','10:30:00','Eerste van de veertigdagen','[\"2\"]','Gedragen door een engel',NULL,NULL,NULL,'','','','','','[\"51\",\"52\",\"53\",\"61\"]',NULL,'','[\"91\"]','','[\"36\"]','[\"47\",\"46\"]','JMJ',NULL,'Kerkopstelling'),(70,'2022-10-17 09:09:00','2023-02-08 12:07:50','2023-03-05','10:30:00','Tweede van de veertigdagen','[\"25\"]','Gedragen door elkaar',0,NULL,NULL,'','','','','','[\"49\",\"56\",\"62\",\"60\"]',NULL,'','[\"93\"]','','[\"39\"]','[\"35\"]','JMJ',NULL,'Kerkopstelling'),(71,'2022-10-17 09:09:00','2023-02-08 12:08:00','2023-03-12','10:30:00','Derde van de veertigdagen','[\"3\"]','Gedragen in gebed',NULL,NULL,NULL,'','','','','','[\"54\",\"55\",\"63\",\"67\"]',NULL,'','[\"76\"]','','[\"37\"]','[\"36\"]','JMJ',NULL,'Kerkopstelling'),(72,'2022-10-17 09:09:00','2023-02-08 12:08:08','2023-03-19','10:30:00','Vierde van de veertigdagen','[\"2\"]','Gedragen door een lied',NULL,NULL,NULL,'','','','','','[\"50\",\"51\",\"66\",\"64\"]',NULL,'','[\"97\"]','','[\"35\"]','[\"37\"]','JMJ',NULL,'Kerkopstelling'),(73,'2022-10-17 09:09:00','2023-02-08 12:08:19','2023-03-26','10:30:00','Vijfde van de veertigdagen','[\"1\"]','Gedragen door een beeld',1,NULL,NULL,'','','','','','[\"48\",\"58\",\"60\",\"61\"]',NULL,'','[\"92\"]','','[\"47\",\"46\"]','[\"39\"]','JMJ',NULL,'Kerkopstelling'),(74,'2022-10-17 09:09:00','2023-02-08 12:08:28','2023-04-02','10:30:00','Palmzondag','[\"3\"]','Gedragen door een ezel',NULL,NULL,NULL,'','','','','','[\"52\",\"53\",\"65\"]',NULL,'','[\"72\"]','','[\"36\"]','[\"35\"]','JMJ',NULL,'Kerkopstelling'),(75,'2022-10-17 09:09:00','2023-02-08 12:08:32','2023-04-06','19:30:00','Witte Donderdag','[\"2\"]',NULL,1,NULL,NULL,'','Cantorij','','','','[\"41\",\"57\",\"62\",\"68\"]',NULL,'','[\"74\"]','','[\"39\"]','[\"47\",\"46\"]','JMJ',NULL,'Afwijkend'),(76,'2022-10-17 09:09:00','2023-02-08 12:08:40','2023-04-07','19:30:00','Goede Vrijdag','[\"3\"]',NULL,NULL,NULL,NULL,'','Kamerkoor','','','','',NULL,'','[\"74\"]','','[\"37\"]','[\"36\"]','geen',NULL,'Afwijkend'),(77,'2022-10-17 09:09:00','2023-02-08 12:09:03','2023-04-09','10:30:00','Pasen','[\"1\"]',NULL,NULL,NULL,NULL,'','Cantorij','','','','[\"49\",\"54\",\"55\",\"59\"]',NULL,'','[\"74\"]','','[\"47\",\"46\"]','[\"37\"]','Gertrut en JMJ',NULL,'Dwarsopstelling'),(78,'2022-10-17 09:09:00','2023-02-08 12:09:11','2023-04-16','10:30:00','','[\"32\"]',NULL,NULL,NULL,NULL,'','','','','','[\"56\",\"63\",\"64\",\"66\"]',NULL,'','[\"77\"]','','[\"36\"]','[\"47\",\"46\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(79,'2022-10-17 09:09:00','2023-02-08 12:09:32','2023-04-23','10:30:00',NULL,'[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','[\"51\",\"58\",\"61\",\"67\"]',NULL,'','[\"84\"]','','[\"35\"]','[\"39\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(80,'2022-10-17 09:09:00','2023-02-08 12:09:40','2023-04-30','10:30:00',NULL,'[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','[\"48\",\"50\",\"60\",\"65\"]',NULL,'','[\"80\"]','','[\"39\"]','[\"35\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(81,'2022-10-17 09:09:00','2023-02-08 12:09:52','2023-05-07','10:30:00',NULL,'[\"3\",\"45\"]',NULL,1,NULL,NULL,'','','','','','[\"52\",\"53\",\"62\"]',NULL,'','[\"83\"]','','[\"37\"]','[\"47\",\"46\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(82,'2022-10-17 09:09:00','2023-02-08 12:09:58','2023-05-14','10:30:00','','[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','[\"54\",\"55\",\"41\",\"57\"]',NULL,'','[\"82\"]','','[\"35\"]','[\"37\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(83,'2022-10-17 09:09:00','2023-02-08 11:23:57','2023-05-21','10:30:00','Hemelvaart','[\"2\"]',NULL,NULL,NULL,NULL,'[\"28\"]','','','','','[\"41\",\"51\",\"56\",\"68\"]',NULL,'','','','[\"47\",\"46\"]','[\"36\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(84,'2022-10-17 09:09:00','2023-02-08 12:10:10','2023-05-28','10:30:00','Pinksteren','[\"3\",\"2\",\"1\"]',NULL,NULL,NULL,NULL,'','Cantorij','','','','[\"48\",\"59\",\"63\",\"65\"]',NULL,'','[\"88\"]','','[\"36\"]','[\"39\"]','Gertrut en JMJ',NULL,'Dwarsopstelling'),(85,'2022-10-17 09:09:00','2023-02-08 12:10:15','2023-06-04','10:30:00',NULL,'[\"26\"]',NULL,NULL,NULL,NULL,'','','','','','[\"58\",\"60\",\"61\"]',NULL,'','[\"99\"]','','[\"37\"]','[\"47\",\"46\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(86,'2022-10-17 09:09:00','2023-02-08 12:10:23','2023-06-11','10:30:00',NULL,'[\"3\"]',NULL,1,NULL,NULL,'','','','','','[\"52\",\"53\",\"66\",\"67\"]',NULL,'','[\"71\"]','','[]','[]','Gertrut en JMJ',NULL,'Kerkopstelling'),(87,'2022-10-17 09:09:00','2023-02-08 12:10:46','2023-06-18','10:30:00',NULL,'[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','[\"54\",\"55\",\"62\",\"64\"]',NULL,'','[\"79\"]','','[]','[]','Gertrut en JMJ',NULL,'Kerkopstelling'),(88,'2022-10-17 09:09:00','2023-02-08 12:10:51','2023-06-25','10:30:00',NULL,'[\"31\"]',NULL,NULL,NULL,NULL,'','','','','','[\"49\",\"56\",\"63\",\"68\"]',NULL,'','[\"86\"]','','[]','[]','Gertrut en JMJ',NULL,'Kerkopstelling'),(89,'2022-10-17 09:09:00','2023-02-08 12:10:55','2023-07-02','10:30:00',NULL,'[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','[\"48\",\"50\",\"51\"]',NULL,'','[\"85\"]','','[]','[]','Gertrut en JMJ',NULL,'Kerkopstelling'),(90,'2022-10-17 09:09:00','2023-02-08 12:11:01','2023-07-09','10:30:00',NULL,'[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','[\"58\",\"59\",\"60\",\"61\"]',NULL,'','[\"87\"]','','[]','','Gertrut en JMJ',NULL,'Kerkopstelling'),(91,'2022-10-17 09:09:00','2023-02-08 12:12:46','2023-07-16','10:30:00',NULL,'[\"32\"]',NULL,NULL,NULL,NULL,'','','','','','[\"62\",\"65\",\"66\",\"67\"]',NULL,'','[\"101\"]','','[]','','Gertrut en JMJ',NULL,'Kerkopstelling'),(92,'2022-10-17 09:09:00','2023-02-08 12:13:47','2023-07-23','10:30:00','DoRe in Do','',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[]','','','[]','Gertrut en JMJ',NULL,NULL),(93,'2022-10-17 09:09:00','2023-02-08 12:13:48','2023-07-30','10:30:00','DoRe in Do','',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[]','','','[]','Gertrut en JMJ',NULL,NULL),(94,'2022-10-17 09:09:00','2023-02-08 12:14:19','2023-08-06','10:30:00','DoRe in Re','[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"70\"]','','[]','','Gertrut en JMJ',NULL,'Kerkopstelling'),(95,'2022-10-17 09:09:00','2023-02-08 12:14:23','2023-08-13','10:30:00','DoRe in Re','[\"33\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"73\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(96,'2022-10-17 09:09:00','2023-02-08 12:14:32','2023-08-20','10:30:00',NULL,'[\"2\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','[\"77\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(97,'2022-10-17 09:09:00','2023-02-08 12:14:38','2023-08-27','10:30:00',NULL,'[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"69\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(98,'2022-10-17 09:09:00','2023-02-08 12:14:44','2023-09-03','10:30:00',NULL,'[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"89\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(99,'2022-10-17 09:09:00','2023-02-08 12:14:56','2023-09-10','10:30:00','Startzondag','[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"88\"]','','','','Gertrut en JMJ',NULL,'Dwarsopstelling'),(100,'2022-10-17 09:09:00','2023-02-08 12:15:00','2023-09-17','10:30:00',NULL,'[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"75\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(101,'2022-10-17 09:09:00','2023-02-08 12:15:08','2023-09-24','10:30:00',NULL,'[\"3\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','[\"82\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(102,'2022-10-17 09:09:00','2023-02-08 12:15:14','2023-10-01','10:30:00','','[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"92\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(103,'2022-10-17 09:09:00','2023-02-08 12:15:21','2023-10-08','10:30:00','Coming Out Sunday','[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"78\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(104,'2022-10-17 09:09:00','2023-02-08 12:15:31','2023-10-15','10:30:00','','[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"90\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(105,'2022-10-17 09:09:00','2023-02-08 12:15:37','2023-10-22','10:30:00','Vredeszondag','[\"1\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','[\"99\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(106,'2022-10-17 09:09:00','2023-02-08 12:15:54','2023-10-29','10:30:00',NULL,'[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"72\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(107,'2022-10-17 09:09:00','2023-02-08 12:16:17','2023-11-05','10:30:00','Herdenken van de overledenen','[\"2\",\"3\",\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"96\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(108,'2022-10-17 09:09:00','2023-02-08 12:16:23','2023-11-12','10:30:00',NULL,'[\"1\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','[\"93\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(109,'2022-10-17 09:09:00','2023-02-08 12:16:28','2023-11-19','10:30:00',NULL,'[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"86\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(110,'2022-10-17 09:09:00','2023-02-08 12:16:32','2023-11-26','10:30:00',NULL,'[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"69\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(111,'2022-10-17 09:09:00','2023-01-25 09:59:37','2023-12-03','10:30:00','Eerste van de advent','[\"1\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','','','','','Gertrut',NULL,'Kerkopstelling'),(112,'2022-10-17 09:09:00','2023-01-25 09:59:42','2023-12-10','10:30:00','Tweede van de advent','[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','Gertrut',NULL,'Kerkopstelling'),(113,'2022-10-17 09:09:00','2023-01-25 09:59:43','2023-12-17','10:30:00','Derde van de advent','[\"34\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','Gertrut',NULL,'Kerkopstelling'),(114,'2022-10-17 09:09:00','2023-02-08 12:16:52','2023-12-24','19:00:00','Kerstavond','[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"88\"]','','','','Gertrut',NULL,'Afwijkend'),(115,'2022-10-17 09:09:00','2023-02-08 12:17:01','2023-12-24','22:00:00','Kerstnacht','[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"88\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(116,'2022-10-17 09:09:00','2023-02-08 12:17:13','2023-12-25','10:30:00','Kerstmorgen','[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','[\"88\"]','','','','Gertrut en JMJ',NULL,'Dwarsopstelling'),(118,'2022-10-19 20:24:43','2023-01-02 18:32:45','2022-10-30','10:30:00',NULL,'','',0,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Kerkopstelling'),(119,'2022-10-19 20:24:53','2023-01-02 18:32:45','2022-10-30','10:30:00','','',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Dwarsopstelling'),(120,'2022-10-19 20:24:57','2023-01-02 18:32:45','2022-11-06','10:30:00',NULL,'','',NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Kerkopstelling'),(121,'2022-10-19 20:25:05','2023-01-02 18:32:45','2022-11-13','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Kerkopstelling'),(122,'2022-10-19 20:25:15','2023-01-02 18:32:45','2022-11-20','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Kerkopstelling'),(123,'2022-10-19 20:25:22','2023-01-02 18:32:45','2022-11-27','10:30:00','Eerste van de advent','',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Kerkopstelling'),(124,'2022-10-19 20:25:29','2023-01-02 18:32:45','2022-12-04','10:30:00','Tweede van de advent','',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Kerkopstelling'),(125,'2022-10-19 20:25:39','2023-01-02 18:32:45','2022-12-11','10:30:00','Derde van de advent','',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Kerkopstelling'),(126,'2022-10-19 20:25:45','2023-01-02 18:32:45','2022-12-18','10:30:00','Vierde van de advent','',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Kerkopstelling'),(127,'2022-10-19 20:25:56','2023-01-02 18:32:45','2022-12-24','19:00:00','Kerstavond','',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Afwijkend'),(128,'2022-10-19 20:26:03','2023-01-02 18:32:45','2022-12-24','22:00:00','Kerstnacht','',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Kerkopstelling'),(129,'2022-10-19 20:26:11','2023-01-02 18:32:45','2022-12-25','10:30:00','Kerstmorgen','',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','',NULL,'Dwarsopstelling'),(775,'2023-01-02 11:45:31','2023-01-25 09:59:52','2024-01-07','10:30:00','Nieuwjaarsontvangst','[\"3\"]',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(776,'2023-01-02 11:45:31','2023-01-05 21:02:32','2024-01-14','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(777,'2023-01-02 11:45:31','2023-01-05 21:02:33','2024-01-21','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(778,'2023-01-02 11:45:31','2023-01-05 21:02:36','2024-01-28','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(779,'2023-01-02 11:45:31','2023-01-05 21:02:38','2024-02-04','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(780,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-02-11','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(781,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-02-18','10:30:00','Eerste van de veertigdagen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(782,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-02-25','10:30:00','Tweede van de veertigdagen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(783,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-03-03','10:30:00','Derde van de veertigdagen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(784,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-03-10','10:30:00','Vierde van de veertigdagen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(785,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-03-17','10:30:00','Vijfde van de veertigdagen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(786,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-03-24','10:30:00','Palmzondag','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(787,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-03-31','10:30:00','Pasen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Dwarsopstelling'),(788,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-04-07','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(789,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-04-14','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(790,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-04-21','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(791,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-04-28','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(792,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-05-05','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(793,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-05-12','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(794,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-05-19','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(795,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-05-26','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(796,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-06-02','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(797,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-06-09','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(798,'2023-01-02 11:45:31','2023-01-02 23:28:34','2024-06-16','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(799,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-06-23','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(800,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-06-30','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(801,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-07-07','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(802,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-07-14','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(803,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-07-21','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(804,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-07-28','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(805,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-08-04','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(806,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-08-11','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(807,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-08-18','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(808,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-08-25','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(809,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-09-01','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(810,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-09-08','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(811,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-09-15','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(812,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-09-22','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(813,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-09-29','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(814,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-10-06','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(815,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-10-13','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(816,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-10-20','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(817,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-10-27','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(818,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-11-03','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(819,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-11-10','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(820,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-11-17','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(821,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-11-24','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(822,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-12-01','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(823,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-12-08','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(824,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-12-15','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(825,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-12-22','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(826,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-12-29','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(827,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-03-28','19:30:00','Witte Donderdag','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Afwijkend'),(828,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-03-29','19:30:00','Goede Vrijdag','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Afwijkend'),(829,'2023-01-02 11:45:31','2023-01-02 18:32:45','2024-12-24','19:00:00','Kerstavond','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Afwijkend'),(830,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-01-05','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(831,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-01-12','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(832,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-01-19','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(833,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-01-26','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(834,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-02-02','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(835,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-02-09','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(836,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-02-16','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(837,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-02-23','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(838,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-03-02','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(839,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-03-09','10:30:00','Eerste van de veertigdagen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(840,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-03-16','10:30:00','Tweede van de veertigdagen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(841,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-03-23','10:30:00','Derde van de veertigdagen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(842,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-03-30','10:30:00','Vierde van de veertigdagen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(843,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-04-06','10:30:00','Vijfde van de veertigdagen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(844,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-04-13','10:30:00','Palmzondag','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(845,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-04-20','10:30:00','Pasen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Dwarsopstelling'),(846,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-04-27','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(847,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-05-04','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(848,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-05-11','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(849,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-05-18','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(850,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-05-25','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(851,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-06-01','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(852,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-06-08','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(853,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-06-15','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(854,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-06-22','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(855,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-06-29','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(856,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-07-06','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(857,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-07-13','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(858,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-07-20','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(859,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-07-27','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(860,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-08-03','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(861,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-08-10','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(862,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-08-17','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(863,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-08-24','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(864,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-08-31','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(865,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-09-07','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(866,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-09-14','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(867,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-09-21','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(868,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-09-28','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(869,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-10-05','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(870,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-10-12','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(871,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-10-19','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(872,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-10-26','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(873,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-11-02','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(874,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-11-09','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(875,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-11-16','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(876,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-11-23','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(877,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-11-30','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(878,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-12-07','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(879,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-12-14','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(880,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-12-21','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(881,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-12-28','10:30:00',NULL,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(882,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-04-17','19:30:00','Witte Donderdag','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Afwijkend'),(883,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-04-18','19:30:00','Goede Vrijdag','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Afwijkend'),(884,'2023-01-02 11:48:11','2023-01-02 18:32:45','2025-12-24','19:00:00','Kerstavond','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Afwijkend'),(885,'2023-01-02 14:04:31','2023-01-02 18:32:45','2024-12-24','22:00:00','Kerstnacht','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(886,'2023-01-02 14:04:41','2023-01-02 18:32:45','2024-12-25','00:00:10','Kerst','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Dwarsopstelling'),(887,'2023-01-02 14:04:51','2023-01-02 18:32:45','2025-12-24','22:00:00','Kerstnacht','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(889,'2023-01-02 14:05:07','2023-01-02 18:32:45','2025-12-25','10:30:00','Kerstmorgen','',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Dwarsopstelling');
/*!40000 ALTER TABLE `Rooster` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Users`
--

DROP TABLE IF EXISTS `Users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `naam` text NOT NULL,
  `password` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `admin` tinyint(1) NOT NULL,
  `role` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Users`
--

LOCK TABLES `Users` WRITE;
/*!40000 ALTER TABLE `Users` DISABLE KEYS */;
INSERT INTO `Users` VALUES (1,'Maarten','admin','mgvanderbijl@gmail.com',1,'beheer'),(2,'Cantor','can','cantor@geertekerk.nl',0,'cantor'),(3,'Audiovisueel','MultiMed1@','mgvanderbijl+audiovisueel@gmail.com',0,'audiovisueel_view'),(4,'AudiovisueelAdmin','MultiMed1@','mgvanderbijl+audiovisueeladmin@gmail.com',0,'Audiovisueel_edit'),(5,'Marthe','Marthe1234','marthedevries@dds.nl',0,'PC'),(6,'Ilse','Ilse1234','ilsekiekebosch@hotmail.com',0,'Audiovisueel_edit'),(7,'ulijn','ulijn12!','wim.ulijn@t-mobilethuis.nl ',0,'beheer'),(8,'vdpavoordt','inge12!','coordinator-rgu@geertekerk.nl',0,'kr_readonly'),(9,'Lense','Lense12#','lensejlijzen@gmail.com',0,'PC'),(10,'Claartje','Claartje###','claartjekruijff@ziggo.nl ',0,'PC'),(11,'Liesbeth','Orthel!!!','info@remonstranten.org',0,'Liesbeth');
/*!40000 ALTER TABLE `Users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rooster_columns`
--

DROP TABLE IF EXISTS `rooster_columns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rooster_columns` (
  `column_name` varchar(255) NOT NULL,
  `group_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`column_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rooster_columns`
--

LOCK TABLES `rooster_columns` WRITE;
/*!40000 ALTER TABLE `rooster_columns` DISABLE KEYS */;
INSERT INTO `rooster_columns` VALUES ('Aantekeningen',NULL),('Audiovisueel_1','AVers'),('Audiovisueel_2','AVers'),('Bloemen','Bloemisten'),('Collectanten','Collectanten'),('created_at',NULL),('Creche',NULL),('Crecheleiding','Crecheleiders'),('Datum',NULL),('Dopen',NULL),('id',NULL),('Informatietafel','Informanten'),('Kerkenraad_1','Kerkenraad'),('Kerkenraad_2','Kerkenraad'),('Koor',NULL),('Kosters','Kosters'),('Luiden',NULL),('Muziek','Musici'),('Omschrijving',NULL),('Opstelling',NULL),('Tafelviering',NULL),('Thema',NULL),('Tijd',NULL),('updated_at',NULL),('Verteluur',NULL),('Voorganger','Voorgangers');
/*!40000 ALTER TABLE `rooster_columns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'edelmanw_rooster'
--
/*!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 2023-02-09  4:00:01