--
-- Host: localhost    Database: edelmanw_rooster
-- ------------------------------------------------------


--
-- Table structure for table `Dido`
--

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=48 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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-01-24 08:36:42','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-01-25 12:01:04','Hans Everwennink','','','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-01-25 12:03:06','Liesbeth Orthel','','','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);

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

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=23 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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');

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

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;

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

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),('beheer','Streamkey',0),('cantor','Streamkey',0),('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','Streamkey',1),('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','Streamkey',2),('Audiovisueel_edit','Luiden',0),('Audiovisueel_edit','Aantekeningen',0),('Audiovisueel_edit','Opstelling',1),('beheer','Vimeo',0),('cantor','Vimeo',0),('audiovisueel_view','Vimeo',1),('Audiovisueel_edit','Vimeo',2),('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','Streamkey',0),('PC','Vimeo',0),('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','Streamkey',0),('kr_readonly','Vimeo',0),('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);

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

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,
  `Streamkey` varchar(50) DEFAULT NULL,
  `Vimeo` varchar(40) DEFAULT 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;

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

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,'','','','','','asdfasdf','https://vimeo.linkie','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-06 07:03:44','2023-02-12','10:30:00','','[\"1\"]','',NULL,1,NULL,'','','','','','',NULL,'','','','[\"47\",\"46\"]','[\"37\"]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(68,'2022-10-17 09:09:00','2023-02-05 19:29:32','2023-02-19','10:30:00','','[\"3\"]','',NULL,NULL,NULL,'','','','','','',0,'','','','[\"35\"]','[\"39\"]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(69,'2022-10-17 09:09:00','2023-01-30 14:28:13','2023-02-26','10:30:00','Eerste van de veertigdagen','[\"2\"]','Gedragen door een engel',NULL,NULL,NULL,'','','','','','',NULL,'','','','[\"36\"]','[\"47\",\"46\"]','','','JMJ',NULL,'Kerkopstelling'),(70,'2022-10-17 09:09:00','2023-01-26 12:31:23','2023-03-05','10:30:00','Tweede van de veertigdagen','[\"25\"]','Gedragen door elkaar',0,NULL,NULL,'','','','','','',NULL,'','','','[\"39\"]','[\"35\"]','','','JMJ',NULL,'Kerkopstelling'),(71,'2022-10-17 09:09:00','2023-01-25 10:28:41','2023-03-12','10:30:00','Derde van de veertigdagen','[\"3\"]','Gedragen in gebed',NULL,NULL,NULL,'','','','','','',NULL,'','','','[\"37\"]','[\"36\"]','','','JMJ',NULL,'Kerkopstelling'),(72,'2022-10-17 09:09:00','2023-01-30 07:30:56','2023-03-19','10:30:00','Vierde van de veertigdagen','[\"2\"]','Gedragen door een lied',NULL,NULL,NULL,'','','','','','',NULL,'','','','[\"35\"]','[\"37\"]','','','JMJ',NULL,'Kerkopstelling'),(73,'2022-10-17 09:09:00','2023-01-30 14:28:19','2023-03-26','10:30:00','Vijfde van de veertigdagen','[\"1\"]','Gedragen door een beeld',1,NULL,NULL,'','','','','','',NULL,'','','','[\"47\",\"46\"]','[\"39\"]','','','JMJ',NULL,'Kerkopstelling'),(74,'2022-10-17 09:09:00','2023-01-25 10:28:35','2023-04-02','10:30:00','Palmzondag','[\"3\"]','Gedragen door een ezel',NULL,NULL,NULL,'','','','','','',NULL,'','','','[\"36\"]','[\"35\"]','','','JMJ',NULL,'Kerkopstelling'),(75,'2022-10-17 09:09:00','2023-01-30 14:28:26','2023-04-06','19:30:00','Witte Donderdag','[\"2\"]',NULL,1,NULL,NULL,'','Cantorij','','','','',NULL,'','','','[\"39\"]','[\"47\",\"46\"]','','','JMJ',NULL,'Afwijkend'),(76,'2022-10-17 09:09:00','2023-01-25 10:28:30','2023-04-07','19:30:00','Goede Vrijdag','[\"3\"]',NULL,NULL,NULL,NULL,'','Kamerkoor','','','','',NULL,'','','','[\"37\"]','[\"36\"]','','','geen',NULL,'Afwijkend'),(77,'2022-10-17 09:09:00','2023-01-30 14:28:34','2023-04-09','10:30:00','Pasen','[\"1\"]',NULL,NULL,NULL,NULL,'','Cantorij','','','','',NULL,'','','','[\"47\",\"46\"]','[\"37\"]','','','Gertrut en JMJ',NULL,'Dwarsopstelling'),(78,'2022-10-17 09:09:00','2023-02-04 10:18:09','2023-04-16','10:30:00','','[\"32\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[\"36\"]','[\"47\",\"46\"]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(79,'2022-10-17 09:09:00','2023-01-30 07:25:21','2023-04-23','10:30:00',NULL,'[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[\"35\"]','[\"39\"]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(80,'2022-10-17 09:09:00','2023-01-25 10:28:20','2023-04-30','10:30:00',NULL,'[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[\"39\"]','[\"35\"]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(81,'2022-10-17 09:09:00','2023-01-30 14:28:46','2023-05-07','10:30:00',NULL,'[\"3\",\"45\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','','','[\"37\"]','[\"47\",\"46\"]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(82,'2022-10-17 09:09:00','2023-01-25 10:28:16','2023-05-14','10:30:00','','[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[\"35\"]','[\"37\"]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(83,'2022-10-17 09:09:00','2023-01-30 14:28:52','2023-05-21','10:30:00','Hemelvaart','[\"2\"]',NULL,NULL,NULL,NULL,'[\"28\"]','','','','','',NULL,'','','','[\"47\",\"46\"]','[\"36\"]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(84,'2022-10-17 09:09:00','2023-01-25 10:28:13','2023-05-28','10:30:00','Pinksteren','[\"3\",\"2\",\"1\"]',NULL,NULL,NULL,NULL,'','Cantorij','','','','',NULL,'','','','[\"36\"]','[\"39\"]','','','Gertrut en JMJ',NULL,'Dwarsopstelling'),(85,'2022-10-17 09:09:00','2023-01-30 14:28:59','2023-06-04','10:30:00',NULL,'[\"26\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[\"37\"]','[\"47\",\"46\"]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(86,'2022-10-17 09:09:00','2023-01-30 07:37:23','2023-06-11','10:30:00',NULL,'[\"3\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','','','[]','[]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(87,'2022-10-17 09:09:00','2023-01-30 07:37:22','2023-06-18','10:30:00',NULL,'[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[]','[]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(88,'2022-10-17 09:09:00','2023-01-30 07:37:22','2023-06-25','10:30:00',NULL,'[\"31\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[]','[]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(89,'2022-10-17 09:09:00','2023-01-30 07:37:20','2023-07-02','10:30:00',NULL,'[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[]','[]','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(90,'2022-10-17 09:09:00','2023-01-30 07:36:38','2023-07-09','10:30:00',NULL,'[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(91,'2022-10-17 09:09:00','2023-01-30 07:36:35','2023-07-16','10:30:00',NULL,'[\"32\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(92,'2022-10-17 09:09:00','2023-01-30 07:36:34','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-01-30 07:36:33','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-01-30 07:36:32','2023-08-06','10:30:00','DoRe in Re','[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','[]','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(95,'2022-10-17 09:09:00','2023-01-25 09:58:47','2023-08-13','10:30:00','DoRe in Re','[\"33\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(96,'2022-10-17 09:09:00','2023-01-25 09:58:45','2023-08-20','10:30:00',NULL,'[\"2\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(97,'2022-10-17 09:09:00','2023-01-25 09:58:42','2023-08-27','10:30:00',NULL,'[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(98,'2022-10-17 09:09:00','2023-01-25 09:58:40','2023-09-03','10:30:00',NULL,'[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(99,'2022-10-17 09:09:00','2023-01-25 09:58:38','2023-09-10','10:30:00','Startzondag','[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Dwarsopstelling'),(100,'2022-10-17 09:09:00','2023-01-25 09:58:32','2023-09-17','10:30:00',NULL,'[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(101,'2022-10-17 09:09:00','2023-01-25 09:58:29','2023-09-24','10:30:00',NULL,'[\"3\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(102,'2022-10-17 09:09:00','2023-01-25 09:58:26','2023-10-01','10:30:00','','[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(103,'2022-10-17 09:09:00','2023-01-25 09:58:23','2023-10-08','10:30:00','Coming Out Sunday','[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(104,'2022-10-17 09:09:00','2023-01-25 09:58:21','2023-10-15','10:30:00','','[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(105,'2022-10-17 09:09:00','2023-01-25 09:59:08','2023-10-22','10:30:00','Vredeszondag','[\"1\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(106,'2022-10-17 09:09:00','2023-01-25 09:59:16','2023-10-29','10:30:00',NULL,'[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(107,'2022-10-17 09:09:00','2023-01-25 09:59:29','2023-11-05','10:30:00','Herdenken van de overledenen','[\"2\",\"3\",\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(108,'2022-10-17 09:09:00','2023-01-25 09:59:31','2023-11-12','10:30:00',NULL,'[\"1\"]',NULL,1,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(109,'2022-10-17 09:09:00','2023-01-25 09:59:33','2023-11-19','10:30:00',NULL,'[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(110,'2022-10-17 09:09:00','2023-01-25 09:59:35','2023-11-26','10:30:00',NULL,'[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','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-01-25 09:59:45','2023-12-24','19:00:00','Kerstavond','[\"3\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut',NULL,'Afwijkend'),(115,'2022-10-17 09:09:00','2023-01-25 09:59:48','2023-12-24','22:00:00','Kerstnacht','[\"2\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','Gertrut en JMJ',NULL,'Kerkopstelling'),(116,'2022-10-17 09:09:00','2023-01-25 09:59:50','2023-12-25','10:30:00','Kerstmorgen','[\"1\"]',NULL,NULL,NULL,NULL,'','','','','','',NULL,'','','','','','','','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,'','','',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,'','','',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,'','','',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,'','','',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,'','','',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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,NULL,NULL,'Dwarsopstelling');

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

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;

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

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),('Streamkey',NULL),('Tafelviering',NULL),('Thema',NULL),('Tijd',NULL),('updated_at',NULL),('Verteluur',NULL),('Vimeo',NULL),('Voorganger','Voorgangers');

--
-- Dumping routines for database 'edelmanw_rooster'
--


