-- MySQL dump 10.19 Distrib 10.3.39-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: edelmanw_rooster -- ------------------------------------------------------ -- Server version 10.3.39-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=145 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-03-06 17:34:47','Arie Noordermeer','voorzitter@geertekerk.nl','06 12 92 98 94','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-03-06 18:16:06','Pieter Dronkers','pdronkers@hotmail.com','','Voorgangers',1),(33,'2023-01-25 09:57:26','2023-03-06 18:18:02','Foeke Knoppers','fknoppers@hetnet.nl','','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-03-06 17:53:20','Hugo Quené','hugo.quene@freedom.nl','','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-03-06 17:53:52','Cor Stolk','cor.stolk@casema.nl','','AVers',1),(39,'2023-01-25 10:27:06','2023-03-06 17:54:35','Martijn Noordermeer','martijn.noordermeer@gmail.com','','AVers',1),(40,'2023-01-25 11:00:31','2023-03-06 17:41:07','Nel Cornelissen','ncornelissen@hotmail.com','','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-03-06 17:57:13','Petra Sloot','petrasloot7@hotmail.com','','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-03-06 18:13:59','Piet Pols','pietpols@gmail.com','','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-03-06 17:55:14','Martijn Lijzen','martijnlijzen@hotmail.nl',NULL,'AVers',1),(47,'2023-01-30 14:25:14','2023-03-06 17:56:00','Hugo Lijzen','hugolijzen@hotmail.com',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),(102,'2023-02-11 14:30:57','2023-03-06 17:35:42','Wendela Schenk','wensch@xs4all.nl','06 20 27 73 99','Kerkenraad',1),(103,'2023-02-11 14:31:24','2023-02-13 17:53:16','','',NULL,'Kerkenraad',0),(104,'2023-02-11 14:33:09','2023-03-06 17:36:20','Adri Onnekink','adrionnekink@ziggo.nl','06 14 02 47 18','Kerkenraad',1),(105,'2023-02-11 14:33:40','2023-03-06 17:37:12','Elja Algra','sp137977@telfort.nl','06 16 86 42 19','Kerkenraad',1),(106,'2023-02-11 14:36:10','2023-03-06 17:37:53','Jitske Bilijam','jitske.bilijam@casema.nl','06 14 62 75 77','Kerkenraad',1),(107,'2023-02-11 14:36:36','2023-03-06 17:38:26','Paulies de Groot','ropaul@ziggo.nl','06 22 19 13 22','Kerkenraad',1),(108,'2023-02-11 14:36:43','2023-03-06 17:39:17','Margriet Adema','margriet.adema@kpnmail.nl','06 55 17 85 09','Kerkenraad',1),(109,'2023-02-11 14:39:16','2023-03-06 17:40:12','Wouter-Jan Schouten','mail@wjfschouten.nl','06 22 41 07 61','Kerkenraad',1),(110,'2023-02-13 16:54:29','2023-03-06 17:41:47','Marthy van de Kamp','marthyvandekamp@gmail.com',NULL,'Kosters',1),(111,'2023-02-13 16:54:49','2023-03-06 17:43:21','Gijsbert van der Heijden ','gijsbo2000@gmail.com',NULL,'Kosters',1),(112,'2023-02-13 16:55:21','2023-03-06 17:43:50','Lucy Hardeman ','dielemanlucy@telfort.nl',NULL,'Kosters',1),(113,'2023-02-13 16:55:42','2023-03-06 17:44:16','Trudy Schreuder Goedheijt','trudysg@gmail.com',NULL,'Kosters',1),(114,'2023-02-13 16:56:15','2023-03-06 17:44:48','John Wimpel  ','johanwimpel@gmail.com',NULL,'Kosters',1),(115,'2023-02-13 16:56:40','2023-03-06 17:45:40','Rob van der Plaat','rob.vanderplaat@planet.nl',NULL,'Kosters',1),(116,'2023-02-13 16:57:58','2023-03-06 17:46:13','Jeep Meesters en Elly Scholten','jeepelly@ziggo.nl',NULL,'Kosters',1),(117,'2023-02-13 16:58:30','2023-03-06 17:46:45','Marieke Fonk','Mfonk@casema.nl',NULL,'Kosters',1),(118,'2023-02-13 16:58:48','2023-03-06 17:47:18','Tet Engelsma','t.engelsma@gmail.com',NULL,'Kosters',1),(119,'2023-02-13 16:59:30','2023-03-06 17:48:06','Dieuwke Piebenga','dieuwkepiebenga@hotmail.com',NULL,'Kosters',1),(120,'2023-02-13 16:59:59','2023-03-06 17:48:35','Karin Wagenaar','karin@wagenaar-psychotherapie.nl',NULL,'Kosters',1),(121,'2023-02-13 17:04:05','2023-03-06 17:49:38','Sascha Laoh','saschalaoh@hotmail.com',NULL,'Kosters',1),(122,'2023-02-13 17:07:11','2023-03-06 17:50:12','Lennard Lamers  ','lennard.lamers@planet.nl',NULL,'Kosters',1),(123,'2023-02-13 17:11:39','2023-03-06 17:50:54','Aalke Blindenbach','blindenbach@xs4all.nl',NULL,'Kosters',1),(124,'2023-02-13 17:15:22','2023-03-06 17:51:42','Wouter Beekhuis','beekhuiswf@hotmail.com',NULL,'Kosters',1),(125,'2023-02-13 17:19:57','2023-03-06 17:52:32','Hans Kapteijn','hanskapteijn@kpnmail.nl',NULL,'Kosters',1),(126,'2023-02-13 17:26:59','2023-03-06 18:10:19','Gerda Faddegon','gerda.faddegon@telfort.nl',NULL,'Informanten',1),(127,'2023-02-13 17:27:11','2023-03-06 18:09:27','Alkelien Ignatius','a.ignatius@hccnet.nl',NULL,'Informanten',1),(128,'2023-02-13 17:27:23','2023-03-06 18:11:08','Tineke Kuitert','tikuitert@gmail.com',NULL,'Informanten',1),(129,'2023-02-13 17:27:34','2023-03-06 18:12:26','Doorle Offerhaus','offerhausd@gmail.com',NULL,'Informanten',1),(130,'2023-02-13 17:27:47','2023-02-13 18:27:47','Piet Pols','',NULL,'Informanten',1),(131,'2023-02-13 17:27:59','2023-03-06 18:13:22','Machteld Schothorst','machteld.schothorst@gmail.com',NULL,'Informanten',1),(132,'2023-02-14 13:50:04','2023-03-06 17:57:45','Wouter Beekhuis','beekhuiswf@hotmail.com',NULL,'Crecheleiders',1),(133,'2023-02-14 13:50:34','2023-03-08 11:27:02','Annemie Rutgers ','annemievr@gmail.com',NULL,'Crecheleiders',1),(134,'2023-02-14 13:50:41','2023-03-06 17:58:52','Annet van Biezen ','a.v.biezen@ziggo.nl',NULL,'Crecheleiders',1),(135,'2023-02-14 13:50:55','2023-03-06 17:59:24','Marije van den Broek ','marijebroek@hotmail.com',NULL,'Crecheleiders',1),(136,'2023-02-14 13:51:14','2023-03-06 17:59:56','Willemijn van der Zwaard ','w.vanderzwaard@gmail.com',NULL,'Crecheleiders',1),(137,'2023-02-14 13:51:28','2023-03-06 18:08:26','Bart Kooiman ','bkooiman@gmail.com',NULL,'Crecheleiders',1),(138,'2023-02-14 13:51:44','2023-03-06 18:00:54','Roosmarijn Luiken ','roosmarijnluiken@gmail.com',NULL,'Crecheleiders',1),(139,'2023-02-14 13:51:59','2023-03-06 18:01:28','Mieke van der Vegt ','miekevdvegt@gmail.com',NULL,'Crecheleiders',1),(140,'2023-02-14 13:52:39','2023-03-06 18:06:20','Dennis Broeders ','christelselhorst@gmail.com',NULL,'Crecheleiders',1),(141,'2023-02-14 13:52:44','2023-03-06 18:01:52','Marcel van de Peut ','marcelvdpeut@hotmail.com',NULL,'Crecheleiders',1),(142,'2023-02-14 13:52:55','2023-03-06 18:05:02','Evelien Dijkstra','eveliendijkstra@gmail.com',NULL,'Crecheleiders',1),(143,'2023-02-14 13:53:18','2023-03-06 18:06:39','Christel Selhorst','christelselhorst@gmail.com',NULL,'Crecheleiders',1),(144,'2023-02-14 13:53:32','2023-03-06 18:02:45','Gerard van den Berg ','bergggf@gmail.com',NULL,'Crecheleiders',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=353 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'),(177,'Maarten','2023-02-12: Omschrijving => Bevestiging ambtdragers','2023-02-10 00:01:29'),(178,'Marthe','2023-02-12: Dopen => 0','2023-02-10 11:28:21'),(179,'Marthe','2023-02-12: Verteluur => 1','2023-02-10 11:28:25'),(180,'Marthe','2023-02-26: Verteluur => 1','2023-02-10 11:28:30'),(181,'Marthe','2023-02-26: Creche => 1','2023-02-10 11:29:11'),(182,'Marthe','2023-03-12: Verteluur => 1','2023-02-10 11:29:15'),(183,'Marthe','2023-03-12: Creche => 1','2023-02-10 11:29:27'),(184,'Marthe','2023-02-26: Crecheleiding => [\"42\"]','2023-02-10 11:30:43'),(185,'Marthe','2023-02-26: Crecheleiding => []','2023-02-10 11:30:44'),(186,'Marthe','2023-02-26: Crecheleiding => [\"42\"]','2023-02-10 11:30:49'),(187,'Marthe','2023-02-26: Crecheleiding => []','2023-02-10 11:30:51'),(188,'Marthe','2023-04-02: Verteluur => 1','2023-02-10 11:31:33'),(189,'Marthe','2023-04-02: Creche => 1','2023-02-10 11:31:40'),(190,'Marthe','2023-04-09: Creche => 1','2023-02-10 11:31:44'),(191,'Marthe','2023-04-09: Tafelviering => 1','2023-02-10 11:31:48'),(192,'Marthe','2023-04-09: Tafelviering => 0','2023-02-10 11:31:50'),(193,'Marthe','2023-04-09: Verteluur => 1','2023-02-10 11:31:52'),(194,'Marthe','2023-04-23: Verteluur => 1','2023-02-10 11:32:18'),(195,'Marthe','2023-04-23: Creche => 1','2023-02-10 11:32:23'),(196,'Marthe','2023-05-14: Creche => 1','2023-02-10 11:32:34'),(197,'Marthe','2023-05-14: Verteluur => 1','2023-02-10 11:32:42'),(198,'Marthe','2023-04-23: Creche => 0','2023-02-10 11:32:46'),(199,'Marthe','2023-05-28: Verteluur => 1','2023-02-10 11:33:02'),(200,'Marthe','2023-06-11: Verteluur => 1','2023-02-10 11:33:09'),(201,'Marthe','2023-06-11: Creche => 1','2023-02-10 11:33:16'),(202,'ulijn','2023-02-12: Kerkenraad_1 => [\"105\"]','2023-02-11 15:40:06'),(203,'ulijn','2023-02-12: Kerkenraad_2 => [\"107\"]','2023-02-11 15:40:15'),(204,'ulijn','2023-02-19: Kerkenraad_1 => [\"102\"]','2023-02-11 15:40:43'),(205,'ulijn','2023-02-19: Kerkenraad_2 => [\"109\"]','2023-02-11 15:40:48'),(206,'Maarten','2023-07-02: Muziek => [\"27\"]','2023-02-13 09:39:57'),(207,'Maarten','2023-03-19: Muziek => [\"28\"]','2023-02-13 09:40:29'),(208,'Maarten','2023-02-26: Muziek => [\"27\"]','2023-02-13 09:40:32'),(209,'Maarten','2023-03-05: Muziek => [\"27\"]','2023-02-13 09:40:33'),(210,'Maarten','2023-03-12: Muziek => [\"27\"]','2023-02-13 09:40:35'),(211,'Maarten','2023-04-06: Muziek => [\"28\"]','2023-02-13 09:40:55'),(212,'Maarten','2023-04-06: Muziek => [\"28\",\"27\"]','2023-02-13 09:40:57'),(213,'Maarten','2023-04-07: Muziek => [\"28\"]','2023-02-13 09:40:59'),(214,'Maarten','2023-04-07: Muziek => [\"28\",\"27\"]','2023-02-13 09:41:00'),(215,'Maarten','2023-04-09: Muziek => [\"28\"]','2023-02-13 09:41:02'),(216,'Maarten','2023-04-09: Muziek => [\"28\",\"27\"]','2023-02-13 09:41:03'),(217,'Maarten','2023-04-16: Muziek => [\"28\"]','2023-02-13 09:41:12'),(218,'Maarten','2023-04-23: Muziek => [\"28\"]','2023-02-13 09:41:19'),(219,'Maarten','2023-04-23: Muziek => [\"28\",\"27\"]','2023-02-13 09:41:21'),(220,'Maarten','2023-04-23: Koor => Kamerkoor','2023-02-13 09:41:26'),(221,'Maarten','2023-05-28: Muziek => [\"28\"]','2023-02-13 09:41:40'),(222,'Maarten','2023-05-28: Muziek => [\"28\",\"27\"]','2023-02-13 09:41:42'),(223,'Maarten','2023-05-21: Muziek => []','2023-02-13 09:41:46'),(224,'Maarten','2023-06-18: Muziek => [\"27\"]','2023-02-13 09:41:57'),(225,'Maarten','2023-06-18: Koor => Kamerkoor','2023-02-13 09:41:59'),(226,'Maarten','2023-06-18: Muziek => [\"27\",\"28\"]','2023-02-13 09:42:00'),(227,'Maarten','2023-06-18: Muziek => [\"28\"]','2023-02-13 09:42:04'),(228,'Maarten','2023-06-18: Muziek => [\"28\",\"27\"]','2023-02-13 09:42:05'),(229,'Maarten','2023-06-25: Muziek => [\"28\"]','2023-02-13 09:42:19'),(230,'Maarten','2023-07-09: Muziek => [\"28\"]','2023-02-13 09:42:27'),(231,'Maarten','2023-07-16: Muziek => [\"28\"]','2023-02-13 09:42:28'),(232,'Maarten','2023-08-13: Muziek => [\"28\"]','2023-02-13 09:42:49'),(233,'Maarten','2023-08-20: Muziek => [\"28\"]','2023-02-13 09:42:53'),(234,'Maarten','2023-09-10: Muziek => [\"28\"]','2023-02-13 09:42:58'),(235,'Maarten','2023-09-10: Muziek => [\"28\",\"27\"]','2023-02-13 09:43:00'),(236,'Maarten','2023-09-10: Koor => Cantorij','2023-02-13 09:43:02'),(237,'Maarten','2023-03-26: Muziek => [\"27\"]','2023-02-13 09:43:24'),(238,'Maarten','2023-04-02: Muziek => [\"27\"]','2023-02-13 09:43:27'),(239,'Maarten','2023-04-30: Muziek => [\"27\"]','2023-02-13 09:43:31'),(240,'Maarten','2023-05-07: Muziek => [\"27\"]','2023-02-13 09:43:33'),(241,'Maarten','2023-05-14: Muziek => [\"27\"]','2023-02-13 09:43:37'),(242,'Maarten','2023-06-04: Muziek => [\"27\"]','2023-02-13 09:43:40'),(243,'Maarten','2023-06-11: Muziek => [\"27\"]','2023-02-13 09:43:42'),(244,'Maarten','2023-07-23: Muziek => [\"27\"]','2023-02-13 09:43:53'),(245,'Maarten','2023-07-30: Muziek => [\"27\"]','2023-02-13 09:43:54'),(246,'Maarten','2023-08-06: Muziek => [\"27\"]','2023-02-13 09:43:57'),(247,'',': verwijderd','2023-02-13 09:44:37'),(248,'ulijn','2023-02-26: Kerkenraad_1 => [\"102\"]','2023-02-13 17:46:54'),(249,'ulijn','2023-02-26: Kerkenraad_2 => [\"108\"]','2023-02-13 17:47:19'),(250,'ulijn','2023-03-05: Kerkenraad_1 => [\"106\"]','2023-02-13 17:47:40'),(251,'ulijn','2023-03-05: Kerkenraad_2 => [\"104\"]','2023-02-13 17:47:50'),(252,'ulijn','2023-03-12: Kerkenraad_1 => [\"107\"]','2023-02-13 17:48:03'),(253,'ulijn','2023-03-12: Kerkenraad_2 => [\"29\"]','2023-02-13 17:48:20'),(254,'ulijn','2023-03-19: Kerkenraad_1 => [\"108\"]','2023-02-13 17:48:33'),(255,'ulijn','2023-03-19: Kerkenraad_2 => [\"102\"]','2023-02-13 17:48:46'),(256,'ulijn','2023-03-26: Kerkenraad_1 => [\"104\"]','2023-02-13 17:48:55'),(257,'ulijn','2023-03-26: Kerkenraad_2 => [\"108\"]','2023-02-13 17:49:01'),(258,'ulijn','2023-04-02: Kerkenraad_1 => [\"106\"]','2023-02-13 17:49:20'),(259,'ulijn','2023-04-02: Kerkenraad_2 => [\"29\"]','2023-02-13 17:49:29'),(260,'ulijn','2023-04-06: Kerkenraad_1 => [\"102\"]','2023-02-13 17:49:51'),(261,'ulijn','2023-04-06: Kerkenraad_2 => [\"104\"]','2023-02-13 17:49:58'),(262,'ulijn','2023-04-07: Kerkenraad_1 => [\"102\"]','2023-02-13 17:50:20'),(263,'ulijn','2023-04-07: Kerkenraad_2 => [\"106\"]','2023-02-13 17:50:26'),(264,'ulijn','2023-04-09: Kerkenraad_1 => [\"29\"]','2023-02-13 17:50:38'),(265,'ulijn','2023-04-09: Kerkenraad_2 => [\"108\"]','2023-02-13 17:50:44'),(266,'ulijn','2023-04-16: Kerkenraad_1 => [\"109\"]','2023-02-13 17:50:58'),(267,'ulijn','2023-04-16: Kerkenraad_2 => [\"106\"]','2023-02-13 17:51:11'),(268,'ulijn','2023-04-23: Kerkenraad_1 => [\"29\"]','2023-02-13 17:51:23'),(269,'ulijn','2023-04-23: Kerkenraad_2 => [\"105\"]','2023-02-13 17:51:27'),(270,'ulijn','2023-04-30: Kerkenraad_1 => [\"109\"]','2023-02-13 17:51:48'),(271,'ulijn','2023-04-30: Kerkenraad_2 => [\"107\"]','2023-02-13 17:51:56'),(272,'ulijn','2023-02-19: Kosters => [\"110\"]','2023-02-13 18:00:40'),(273,'ulijn','2023-02-19: Kosters => [\"110\",\"111\"]','2023-02-13 18:00:52'),(274,'ulijn','2023-02-26: Kosters => [\"113\"]','2023-02-13 18:01:12'),(275,'ulijn','2023-02-26: Kosters => [\"113\",\"112\"]','2023-02-13 18:01:18'),(276,'ulijn','2023-03-05: Kosters => [\"114\"]','2023-02-13 18:01:35'),(277,'ulijn','2023-03-05: Kosters => [\"114\",\"115\"]','2023-02-13 18:01:55'),(278,'ulijn','2023-03-12: Kosters => [\"116\"]','2023-02-13 18:02:06'),(279,'ulijn','2023-03-19: Kosters => [\"118\"]','2023-02-13 18:02:31'),(280,'ulijn','2023-03-19: Kosters => [\"118\",\"117\"]','2023-02-13 18:02:38'),(281,'ulijn','2023-03-26: Kosters => [\"120\"]','2023-02-13 18:02:50'),(282,'ulijn','2023-03-26: Kosters => [\"120\",\"110\"]','2023-02-13 18:02:55'),(283,'ulijn','2023-04-02: Kosters => [\"111\"]','2023-02-13 18:03:18'),(284,'ulijn','2023-04-02: Kosters => [\"111\",\"119\"]','2023-02-13 18:03:26'),(285,'ulijn','2023-04-02: Kosters => [\"111\",\"119\",\"121\"]','2023-02-13 18:04:18'),(286,'ulijn','2023-04-02: Kosters => [\"111\",\"119\"]','2023-02-13 18:10:13'),(287,'ulijn','2023-04-06: Kosters => [\"40\"]','2023-02-13 18:10:34'),(288,'ulijn','2023-04-06: Kosters => [\"40\",\"113\"]','2023-02-13 18:10:51'),(289,'ulijn','2023-04-07: Kosters => [\"123\"]','2023-02-13 18:12:03'),(290,'ulijn','2023-04-09: Kosters => [\"115\"]','2023-02-13 18:12:50'),(291,'ulijn','2023-04-09: Kosters => [\"115\",\"112\"]','2023-02-13 18:12:58'),(292,'ulijn','2023-04-09: Kosters => [\"115\",\"112\",\"121\"]','2023-02-13 18:13:04'),(293,'ulijn','2023-04-16: Kosters => [\"114\"]','2023-02-13 18:13:39'),(294,'ulijn','2023-04-16: Kosters => [\"114\",\"122\"]','2023-02-13 18:13:44'),(295,'ulijn','2023-04-23: Kosters => [\"111\"]','2023-02-13 18:14:07'),(296,'ulijn','2023-04-23: Kosters => [\"111\",\"124\"]','2023-02-13 18:16:04'),(297,'ulijn','2023-04-30: Kosters => [\"110\"]','2023-02-13 18:16:18'),(298,'ulijn','2023-04-30: Kosters => [\"110\",\"113\"]','2023-02-13 18:16:22'),(299,'ulijn','2023-05-07: Kosters => [\"117\"]','2023-02-13 18:17:07'),(300,'ulijn','2023-05-07: Kosters => [\"117\",\"119\"]','2023-02-13 18:17:10'),(301,'ulijn','2023-05-14: Kosters => [\"118\"]','2023-02-13 18:17:30'),(302,'ulijn','2023-05-14: Kosters => [\"118\",\"123\"]','2023-02-13 18:17:34'),(303,'ulijn','2023-05-21: Kosters => [\"123\"]','2023-02-13 18:17:51'),(304,'ulijn','2023-05-21: Kosters => [\"123\",\"114\"]','2023-02-13 18:17:57'),(305,'ulijn','2023-05-28: Kosters => [\"122\"]','2023-02-13 18:20:31'),(306,'ulijn','2023-05-28: Kosters => [\"122\",\"125\"]','2023-02-13 18:20:34'),(307,'ulijn','2023-05-28: Kosters => [\"122\",\"125\",\"121\"]','2023-02-13 18:20:42'),(308,'ulijn','2023-06-04: Kosters => [\"112\"]','2023-02-13 18:21:05'),(309,'ulijn','2023-06-04: Kosters => [\"112\",\"122\"]','2023-02-13 18:21:11'),(310,'ulijn','2023-06-11: Kosters => [\"116\"]','2023-02-13 18:21:25'),(311,'ulijn','2023-06-18: Kosters => [\"113\"]','2023-02-13 18:22:04'),(312,'ulijn','2023-06-18: Kosters => [\"113\",\"125\"]','2023-02-13 18:22:08'),(313,'ulijn','2023-02-26: Informatietafel => [\"128\"]','2023-02-13 18:28:27'),(314,'ulijn','2023-03-05: Informatietafel => [\"130\"]','2023-02-13 18:28:41'),(315,'ulijn','2023-03-12: Informatietafel => [\"126\"]','2023-02-13 18:28:51'),(316,'ulijn','2023-03-19: Informatietafel => [\"129\"]','2023-02-13 18:29:05'),(317,'ulijn','2023-03-26: Informatietafel => [\"128\"]','2023-02-13 18:29:17'),(318,'ulijn','2023-04-02: Informatietafel => [\"131\"]','2023-02-13 18:29:32'),(319,'ulijn','2023-04-09: Informatietafel => [\"129\"]','2023-02-13 18:30:07'),(320,'ulijn','2023-04-23: Informatietafel => [\"126\"]','2023-02-13 18:30:28'),(321,'ulijn','2023-02-26: Crecheleiding => [\"132\"]','2023-02-14 14:54:37'),(322,'ulijn','2023-02-26: Crecheleiding => [\"132\",\"133\"]','2023-02-14 14:54:41'),(323,'ulijn','2023-03-12: Crecheleiding => [\"134\"]','2023-02-14 14:55:02'),(324,'ulijn','2023-03-12: Crecheleiding => [\"134\",\"135\"]','2023-02-14 14:55:16'),(325,'ulijn','2023-04-02: Crecheleiding => [\"42\"]','2023-02-14 14:55:33'),(326,'ulijn','2023-04-02: Crecheleiding => [\"42\",\"136\"]','2023-02-14 14:55:41'),(327,'ulijn','2023-04-09: Crecheleiding => [\"137\"]','2023-02-14 14:55:55'),(328,'ulijn','2023-04-09: Crecheleiding => [\"137\",\"138\"]','2023-02-14 14:56:00'),(329,'ulijn','2023-05-14: Crecheleiding => [\"139\"]','2023-02-14 14:56:46'),(330,'ulijn','2023-05-14: Crecheleiding => [\"139\",\"140\"]','2023-02-14 14:56:52'),(331,'ulijn','2023-06-11: Crecheleiding => [\"141\"]','2023-02-14 14:57:26'),(332,'ulijn','2023-06-11: Crecheleiding => [\"141\",\"142\"]','2023-02-14 14:57:31'),(333,'Maarten','2023-05-07: Voorganger => [\"3\"]','2023-02-23 13:45:20'),(334,'Maarten','2023-06-11: Voorganger => [\"3\",\"45\"]','2023-02-23 13:45:29'),(335,'Maarten','2023-04-16: Omschrijving => Quasi modo geniti','2023-02-23 13:50:49'),(336,'Maarten','2023-04-23: Omschrijving => Misericordia','2023-02-23 13:51:06'),(337,'Maarten','2023-04-30: Omschrijving => Jubilate','2023-02-23 13:51:14'),(338,'Maarten','2023-05-07: Omschrijving => Cantate','2023-02-23 13:51:24'),(339,'Maarten','2023-05-14: Omschrijving => Rogate','2023-02-23 13:51:41'),(340,'Maarten','2023-05-21: Omschrijving => Exaudi','2023-02-23 13:51:52'),(341,'Liesbeth','2023-04-16: Collectanten => [\"56\",\"63\",\"64\"]','2023-03-13 11:39:48'),(342,'Liesbeth','2023-04-16: Collectanten => [\"56\",\"63\",\"64\",\"68\"]','2023-03-13 11:40:08'),(343,'Liesbeth','2023-05-21: Collectanten => [\"41\",\"51\",\"56\"]','2023-03-13 11:40:25'),(344,'Liesbeth','2023-05-21: Collectanten => [\"41\",\"51\",\"56\",\"63\"]','2023-03-13 11:40:31'),(345,'Liesbeth','2023-06-25: Collectanten => [\"49\",\"56\",\"68\"]','2023-03-13 11:40:56'),(346,'Liesbeth','2023-06-25: Collectanten => [\"49\",\"56\",\"68\",\"66\"]','2023-03-13 11:41:01'),(347,'Marthe','2023-05-14: Thema => Doopdienst! ','2023-03-16 15:31:53'),(348,'Marthe','2023-05-14: Dopen => 1','2023-03-16 15:31:53'),(349,'Marthe','2023-05-14: Thema verwijderd','2023-03-16 15:32:38'),(350,'Maarten','2024-12-01: Voorganger => [\"2\"]','2023-05-30 11:23:55'),(351,'Maarten','2024-12-08: Voorganger => [\"3\"]','2023-05-30 11:24:04'),(352,'Maarten','2024-12-15: Voorganger => [\"1\"]','2023-05-30 11:24:11'); /*!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-02-09 23:03:29','2023-01-08','10:30:00','','','',1,0,0,'','','','','','',0,'','','','','','Gertrut en JMJ','','Kerkopstelling'),(63,'2022-10-17 09:09:00','2023-02-09 23:04:36','2023-01-15','10:30:00','Week van de eenheid','[\"1\",\"2\"]','',0,0,NULL,'','','','','','',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-11 14:40:15','2023-02-12','10:30:00','Bevestiging ambtdragers','[\"1\"]','',NULL,0,1,'[\"27\"]','','[\"105\"]','[\"107\"]','','[\"48\",\"58\",\"59\",\"66\"]',NULL,'','[\"96\"]','','[\"47\",\"46\"]','[\"37\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(68,'2022-10-17 09:09:00','2023-02-13 17:00:52','2023-02-19','10:30:00','','[\"3\"]','',NULL,NULL,NULL,'[\"27\"]','','[\"102\"]','[\"109\"]','[\"110\",\"111\"]','[\"41\",\"57\",\"60\",\"68\"]',0,'','[\"94\"]','','[\"35\"]','[\"39\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(69,'2022-10-17 09:09:00','2023-02-14 13:54:41','2023-02-26','10:30:00','Eerste van de veertigdagen','[\"2\"]','Gedragen door een engel',NULL,NULL,1,'[\"27\"]','','[\"102\"]','[\"108\"]','[\"113\",\"112\"]','[\"51\",\"52\",\"53\",\"61\"]',1,'[\"132\",\"133\"]','[\"91\"]','[\"128\"]','[\"36\"]','[\"47\",\"46\"]','JMJ',NULL,'Kerkopstelling'),(70,'2022-10-17 09:09:00','2023-02-13 17:28:41','2023-03-05','10:30:00','Tweede van de veertigdagen','[\"25\"]','Gedragen door elkaar',0,NULL,NULL,'[\"27\"]','','[\"106\"]','[\"104\"]','[\"114\",\"115\"]','[\"49\",\"56\",\"62\",\"60\"]',NULL,'','[\"93\"]','[\"130\"]','[\"39\"]','[\"35\"]','JMJ',NULL,'Kerkopstelling'),(71,'2022-10-17 09:09:00','2023-02-14 13:55:16','2023-03-12','10:30:00','Derde van de veertigdagen','[\"3\"]','Gedragen in gebed',NULL,NULL,1,'[\"27\"]','','[\"107\"]','[\"29\"]','[\"116\"]','[\"54\",\"55\",\"63\",\"67\"]',1,'[\"134\",\"135\"]','[\"76\"]','[\"126\"]','[\"37\"]','[\"36\"]','JMJ',NULL,'Kerkopstelling'),(72,'2022-10-17 09:09:00','2023-02-13 17:29:05','2023-03-19','10:30:00','Vierde van de veertigdagen','[\"2\"]','Gedragen door een lied',NULL,NULL,NULL,'[\"28\"]','','[\"108\"]','[\"102\"]','[\"118\",\"117\"]','[\"50\",\"51\",\"66\",\"64\"]',NULL,'','[\"97\"]','[\"129\"]','[\"35\"]','[\"37\"]','JMJ',NULL,'Kerkopstelling'),(73,'2022-10-17 09:09:00','2023-02-13 17:29:17','2023-03-26','10:30:00','Vijfde van de veertigdagen','[\"1\"]','Gedragen door een beeld',1,NULL,NULL,'[\"27\"]','','[\"104\"]','[\"108\"]','[\"120\",\"110\"]','[\"48\",\"58\",\"60\",\"61\"]',NULL,'','[\"92\"]','[\"128\"]','[\"47\",\"46\"]','[\"39\"]','JMJ',NULL,'Kerkopstelling'),(74,'2022-10-17 09:09:00','2023-02-14 13:55:40','2023-04-02','10:30:00','Palmzondag','[\"3\"]','Gedragen door een ezel',NULL,NULL,1,'[\"27\"]','','[\"106\"]','[\"29\"]','[\"111\",\"119\"]','[\"52\",\"53\",\"65\"]',1,'[\"42\",\"136\"]','[\"72\"]','[\"131\"]','[\"36\"]','[\"35\"]','JMJ',NULL,'Kerkopstelling'),(75,'2022-10-17 09:09:00','2023-02-13 17:10:51','2023-04-06','19:30:00','Witte Donderdag','[\"2\"]',NULL,1,NULL,NULL,'[\"28\",\"27\"]','Cantorij','[\"102\"]','[\"104\"]','[\"40\",\"113\"]','[\"41\",\"57\",\"62\",\"68\"]',NULL,'','[\"74\"]','','[\"39\"]','[\"47\",\"46\"]','JMJ',NULL,'Afwijkend'),(76,'2022-10-17 09:09:00','2023-02-13 17:12:03','2023-04-07','19:30:00','Goede Vrijdag','[\"3\"]',NULL,NULL,NULL,NULL,'[\"28\",\"27\"]','Kamerkoor','[\"102\"]','[\"106\"]','[\"123\"]','',NULL,'','[\"74\"]','','[\"37\"]','[\"36\"]','geen',NULL,'Afwijkend'),(77,'2022-10-17 09:09:00','2023-02-14 13:56:00','2023-04-09','10:30:00','Pasen','[\"1\"]',NULL,0,NULL,1,'[\"28\",\"27\"]','Cantorij','[\"29\"]','[\"108\"]','[\"115\",\"112\",\"121\"]','[\"49\",\"54\",\"55\",\"59\"]',1,'[\"137\",\"138\"]','[\"74\"]','[\"129\"]','[\"47\",\"46\"]','[\"37\"]','Gertrut en JMJ',NULL,'Dwarsopstelling'),(78,'2022-10-17 09:09:00','2023-03-13 10:40:08','2023-04-16','10:30:00','Quasi modo geniti','[\"32\"]',NULL,NULL,NULL,NULL,'[\"28\"]','','[\"109\"]','[\"106\"]','[\"114\",\"122\"]','[\"56\",\"63\",\"64\",\"68\"]',NULL,'','[\"77\"]','','[\"36\"]','[\"47\",\"46\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(79,'2022-10-17 09:09:00','2023-02-23 12:51:06','2023-04-23','10:30:00','Misericordia','[\"2\"]',NULL,NULL,NULL,1,'[\"28\",\"27\"]','Kamerkoor','[\"29\"]','[\"105\"]','[\"111\",\"124\"]','[\"51\",\"58\",\"61\",\"67\"]',0,'','[\"84\"]','[\"126\"]','[\"35\"]','[\"39\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(80,'2022-10-17 09:09:00','2023-02-23 12:51:14','2023-04-30','10:30:00','Jubilate','[\"1\"]',NULL,NULL,NULL,NULL,'[\"27\"]','','[\"109\"]','[\"107\"]','[\"110\",\"113\"]','[\"48\",\"50\",\"60\",\"65\"]',NULL,'','[\"80\"]','','[\"39\"]','[\"35\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(81,'2022-10-17 09:09:00','2023-02-23 12:51:24','2023-05-07','10:30:00','Cantate','[\"3\"]',NULL,1,NULL,NULL,'[\"27\"]','','','','[\"117\",\"119\"]','[\"52\",\"53\",\"62\"]',NULL,'','[\"83\"]','','[\"37\"]','[\"47\",\"46\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(82,'2022-10-17 09:09:00','2023-03-16 14:32:38','2023-05-14','10:30:00','Rogate','[\"1\"]','',NULL,1,1,'[\"27\"]','','','','[\"118\",\"123\"]','[\"54\",\"55\",\"41\",\"57\"]',1,'[\"139\",\"140\"]','[\"82\"]','','[\"35\"]','[\"37\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(83,'2022-10-17 09:09:00','2023-03-13 10:40:31','2023-05-21','10:30:00','Exaudi','[\"2\"]',NULL,NULL,NULL,NULL,'[]','','','','[\"123\",\"114\"]','[\"41\",\"51\",\"56\",\"63\"]',NULL,'','','','[\"47\",\"46\"]','[\"36\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(84,'2022-10-17 09:09:00','2023-02-13 17:20:42','2023-05-28','10:30:00','Pinksteren','[\"3\",\"2\",\"1\"]',NULL,NULL,NULL,1,'[\"28\",\"27\"]','Cantorij','','','[\"122\",\"125\",\"121\"]','[\"48\",\"59\",\"63\",\"65\"]',NULL,'','[\"88\"]','','[\"36\"]','[\"39\"]','Gertrut en JMJ',NULL,'Dwarsopstelling'),(85,'2022-10-17 09:09:00','2023-02-13 17:21:11','2023-06-04','10:30:00',NULL,'[\"26\"]',NULL,NULL,NULL,NULL,'[\"27\"]','','','','[\"112\",\"122\"]','[\"58\",\"60\",\"61\"]',NULL,'','[\"99\"]','','[\"37\"]','[\"47\",\"46\"]','Gertrut en JMJ',NULL,'Kerkopstelling'),(86,'2022-10-17 09:09:00','2023-02-23 12:45:29','2023-06-11','10:30:00',NULL,'[\"3\",\"45\"]',NULL,1,NULL,1,'[\"27\"]','','','','[\"116\"]','[\"52\",\"53\",\"66\",\"67\"]',1,'[\"141\",\"142\"]','[\"71\"]','','[]','[]','Gertrut en JMJ',NULL,'Kerkopstelling'),(87,'2022-10-17 09:09:00','2023-02-13 17:22:08','2023-06-18','10:30:00',NULL,'[\"1\"]',NULL,NULL,NULL,NULL,'[\"28\",\"27\"]','Kamerkoor','','','[\"113\",\"125\"]','[\"54\",\"55\",\"62\",\"64\"]',NULL,'','[\"79\"]','','[]','[]','Gertrut en JMJ',NULL,'Kerkopstelling'),(88,'2022-10-17 09:09:00','2023-03-13 10:41:01','2023-06-25','10:30:00',NULL,'[\"31\"]',NULL,NULL,NULL,NULL,'[\"28\"]','','','','','[\"49\",\"56\",\"68\",\"66\"]',NULL,'','[\"86\"]','','[]','[]','Gertrut en JMJ',NULL,'Kerkopstelling'),(89,'2022-10-17 09:09:00','2023-02-13 08:39:57','2023-07-02','10:30:00',NULL,'[\"3\"]',NULL,NULL,NULL,NULL,'[\"27\"]','','','','','[\"48\",\"50\",\"51\"]',NULL,'','[\"85\"]','','[]','[]','Gertrut en JMJ',NULL,'Kerkopstelling'),(90,'2022-10-17 09:09:00','2023-02-13 08:42:27','2023-07-09','10:30:00',NULL,'[\"1\"]',NULL,NULL,NULL,NULL,'[\"28\"]','','','','','[\"58\",\"59\",\"60\",\"61\"]',NULL,'','[\"87\"]','','[]','','Gertrut en JMJ',NULL,'Kerkopstelling'),(91,'2022-10-17 09:09:00','2023-02-13 08:42:28','2023-07-16','10:30:00',NULL,'[\"32\"]',NULL,NULL,NULL,NULL,'[\"28\"]','','','','','[\"62\",\"65\",\"66\",\"67\"]',NULL,'','[\"101\"]','','[]','','Gertrut en JMJ',NULL,'Kerkopstelling'),(92,'2022-10-17 09:09:00','2023-02-13 08:43:53','2023-07-23','10:30:00','DoRe in Do','',NULL,NULL,NULL,NULL,'[\"27\"]','','','','','',NULL,'','[]','','','[]','Gertrut en JMJ',NULL,NULL),(93,'2022-10-17 09:09:00','2023-02-13 08:43:54','2023-07-30','10:30:00','DoRe in Do','',NULL,NULL,NULL,NULL,'[\"27\"]','','','','','',NULL,'','[]','','','[]','Gertrut en JMJ',NULL,NULL),(94,'2022-10-17 09:09:00','2023-02-13 08:43:57','2023-08-06','10:30:00','DoRe in Re','[\"2\"]',NULL,NULL,NULL,NULL,'[\"27\"]','','','','','',NULL,'','[\"70\"]','','[]','','Gertrut en JMJ',NULL,'Kerkopstelling'),(95,'2022-10-17 09:09:00','2023-02-13 08:42:49','2023-08-13','10:30:00','DoRe in Re','[\"33\"]',NULL,NULL,NULL,NULL,'[\"28\"]','','','','','',NULL,'','[\"73\"]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(96,'2022-10-17 09:09:00','2023-02-13 08:42:53','2023-08-20','10:30:00',NULL,'[\"2\"]',NULL,1,NULL,NULL,'[\"28\"]','','','','','',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-13 08:43:02','2023-09-10','10:30:00','Startzondag','[\"1\"]',NULL,NULL,NULL,NULL,'[\"28\",\"27\"]','Cantorij','','','','',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-05-30 09:23:55','2024-12-01','10:30:00',NULL,'[\"2\"]',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(823,'2023-01-02 11:45:31','2023-05-30 09:24:04','2024-12-08','10:30:00',NULL,'[\"3\"]',NULL,NULL,NULL,NULL,'','',NULL,NULL,'',NULL,NULL,'',NULL,'','','',NULL,NULL,'Kerkopstelling'),(824,'2023-01-02 11:45:31','2023-05-30 09:24:11','2024-12-15','10:30:00',NULL,'[\"1\"]',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, `reset_token` varchar(64) DEFAULT 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','$2y$10$2tdwAS04SJPOGWwTY9L6m.OLYa5ynX0wVe772TKCUBts0wqBaDMiO','mgvanderbijl@gmail.com',1,'beheer',NULL),(2,'Cantor','$2y$10$OAyDB4Ljy08EQrrgDJxoLusIjYBmQJsbjnNZYKFc5F3H1k8DaIfpe','cantor@geertekerk.nl',0,'cantor',NULL),(3,'Audiovisueel','$2y$10$nTgrefhz2bPx/YWqUDhAWOKiIIay2eh36h1lXDndSchkmCKu4D3x.','mgvanderbijl+audiovisueel@gmail.com',0,'audiovisueel_view',NULL),(4,'AudiovisueelAdmin','$2y$10$xBi3PnqiQ5C2B8u9/jkaQeZMyOdNsxmql6xYUWH.r.bDeUPy43Ydu','mgvanderbijl+audiovisueeladmin@gmail.com',0,'Audiovisueel_edit',NULL),(5,'Marthe','$2y$10$DAJQyNT0Re2BDp6Wk7Zb2uIkQowhJC9fROAbh.iJa42kgrN1/Ul3q','marthedevries@dds.nl',0,'PC',NULL),(6,'Ilse','$2y$10$b9gMfzOMPXUs3.CnJ1dDn.PCWAt3zsDOKlBQfpsG.Qh5ByHa9.Sne','ilsekiekebosch@hotmail.com',0,'Audiovisueel_edit',NULL),(7,'ulijn','$2y$10$JJkP630aMGre6fPZEEt6feh8DWb9se9n3htclq6nk7gvLz1FpiGr.','wim.ulijn@t-mobilethuis.nl ',0,'beheer',NULL),(8,'vdpavoordt','$2y$10$VnOhmnTxSTSX/aYYemgTyOO5PLSUvj37uj24jXL8LP5GaUIPESBZW','coordinator-rgu@geertekerk.nl',0,'kr_readonly',NULL),(9,'Lense','$2y$10$GMliQxBaeSUhRg01LlgIhezgp8XDLn1PDX48uwmaUUA4iJKgnKve.','lensejlijzen@gmail.com',0,'PC',NULL),(10,'Claartje','$2y$10$FAm.6MjDIbjkXAevAIeWXevWESSQC1mfOPqqVxYEO.IXMPoeqnHcS','claartjekruijff@ziggo.nl ',0,'PC',NULL),(11,'Liesbeth','$2y$10$4ywo.NmpYSpy3NTzFzQkQeXbiGN3pE2WKX0HtsWwc3qSRH.fx4tgm','info@remonstranten.org',0,'Liesbeth',NULL); /*!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; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `session_id` varchar(64) NOT NULL, `user_id` int(11) NOT NULL, `expiration_time` datetime NOT NULL, `created_at` datetime DEFAULT current_timestamp(), `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `user_id` (`user_id`), CONSTRAINT `sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `Users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` VALUES (67,'9a09da44ad80af3b5ee74146c7b7c138',1,'2023-05-31 19:25:01','2023-05-01 19:25:01','2023-05-01 19:25:01'),(68,'7fa72dedfda1edbedc21530ed1d939af',1,'2023-06-14 17:45:30','2023-05-15 17:45:30','2023-05-15 17:45:30'),(69,'5e390d34932d53f009ae79262bc1ff4a',1,'2023-06-29 10:06:04','2023-05-30 10:06:04','2023-05-30 10:06:04'); /*!40000 ALTER TABLE `sessions` 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-05-31 4:00:01