File: /var/www/vhosts/creativefellows.nl/kjs.creativefellows.nl/db.sql
-- phpMyAdmin SQL Dump
-- version 4.9.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Gegenereerd op: 17 sep 2020 om 17:34
-- Serverversie: 5.7.26
-- PHP-versie: 7.3.9
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `cassette3_kiesjeschool_alphen`
--
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `bestellingen`
--
CREATE TABLE `bestellingen` (
`bestelling_id` int(10) NOT NULL,
`klant_id` int(10) NOT NULL,
`order_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`totaal` float NOT NULL,
`bezorgkosten` float NOT NULL,
`type_betaling` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`verzending` int(1) NOT NULL,
`opmerkingen` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`opmerkingen_intern` text NOT NULL,
`voltooid` int(1) NOT NULL,
`betaald` int(1) NOT NULL DEFAULT '0',
`status` int(1) NOT NULL DEFAULT '0',
`ideal_trans_id` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`tav` varchar(250) NOT NULL,
`straat` varchar(250) NOT NULL,
`huisnummer` varchar(250) NOT NULL,
`postcode` varchar(250) NOT NULL,
`plaats` varchar(250) NOT NULL,
`land` varchar(250) NOT NULL,
`in_archief` int(1) NOT NULL,
`html` text NOT NULL,
`parcel_id` varchar(255) NOT NULL,
`tracktrace` int(10) NOT NULL,
`label` blob NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `bestellingen_producten`
--
CREATE TABLE `bestellingen_producten` (
`bp_id` int(10) NOT NULL,
`uid` int(10) NOT NULL,
`bestelling_id` int(10) NOT NULL,
`aantal` int(10) NOT NULL,
`prijs` float NOT NULL,
`maat` varchar(255) NOT NULL,
`options` text NOT NULL,
`totaal` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `categories`
--
CREATE TABLE `categories` (
`category_id` int(10) NOT NULL,
`sectie_id` int(10) NOT NULL,
`naam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`position` int(1) NOT NULL DEFAULT '0',
`sub_of` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`zichtbaar` int(1) NOT NULL DEFAULT '1',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `categories`
--
INSERT INTO `categories` (`category_id`, `sectie_id`, `naam`, `url`, `position`, `sub_of`, `image`, `zichtbaar`, `active`) VALUES
(1, 3, 'Ashram College', 'ashram-college', 0, 0, NULL, 0, 1),
(2, 3, 'Scala College', 'scala-college', 0, 0, NULL, 0, 1),
(3, 3, 'Groene Hart Scholen', 'groene-hart-scholen', 0, 0, NULL, 0, 1),
(4, 3, 'Wellant College', 'wellant-college', 0, 0, NULL, 0, 1),
(5, 3, 'Alle Locaties', 'alle-locaties', 0, 0, NULL, 0, 1),
(6, 2, 'Ashram Alphen', 'ashram-alphen', 0, 0, NULL, 1, 1),
(7, 2, 'Ashram Nieuwkoop', 'ashram-nieuwkoop', 0, 0, NULL, 1, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `category_posities`
--
CREATE TABLE `category_posities` (
`category_positie_id` int(10) NOT NULL,
`category_id` int(10) NOT NULL,
`positie_id` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `choice_options`
--
CREATE TABLE `choice_options` (
`choice_id` int(10) UNSIGNED NOT NULL,
`field_id` mediumint(8) UNSIGNED NOT NULL,
`choice` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`value` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Gegevens worden geëxporteerd voor tabel `choice_options`
--
INSERT INTO `choice_options` (`choice_id`, `field_id`, `choice`, `value`) VALUES
(1, 19, 'hide buttons', '1');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `custom_css`
--
CREATE TABLE `custom_css` (
`custom_id` int(10) NOT NULL,
`css_class` varchar(250) NOT NULL,
`css` text NOT NULL,
`active` int(1) NOT NULL DEFAULT '1',
`position` int(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `custom_css`
--
INSERT INTO `custom_css` (`custom_id`, `css_class`, `css`, `active`, `position`) VALUES
(1, 'panel-blue', '', 1, 0),
(2, 'panel-pink', '', 1, 0),
(3, 'school-contact', '', 1, 0),
(4, 'school-locaties', '', 1, 0);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `entry_categories`
--
CREATE TABLE `entry_categories` (
`entry_category_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`category_id` int(10) NOT NULL,
`sectie_id` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `entry_categories`
--
INSERT INTO `entry_categories` (`entry_category_id`, `unique_id`, `category_id`, `sectie_id`) VALUES
(155, 9, 5, 3),
(161, 15, 5, 3),
(163, 16, 5, 3),
(165, 17, 5, 3),
(167, 18, 5, 3),
(169, 19, 5, 3),
(86, 20, 2, 3),
(88, 21, 2, 3),
(90, 22, 2, 3),
(102, 23, 4, 3),
(156, 24, 1, 3),
(154, 9, 1, 3),
(157, 24, 5, 3),
(87, 20, 5, 3),
(89, 21, 5, 3),
(91, 22, 5, 3),
(160, 15, 3, 3),
(162, 16, 3, 3),
(164, 17, 3, 3),
(166, 18, 3, 3),
(168, 19, 3, 3),
(103, 23, 5, 3),
(145, 2, 1, 3),
(172, 12, 3, 3),
(112, 13, 2, 3),
(113, 14, 4, 3),
(151, 28, 7, 2),
(150, 29, 7, 2),
(158, 30, 3, 0);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `entry_choices`
--
CREATE TABLE `entry_choices` (
`entry_choice_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`choice_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `entry_links`
--
CREATE TABLE `entry_links` (
`entry_link_id` int(10) NOT NULL,
`entry_id` int(10) NOT NULL,
`template_id` int(10) NOT NULL,
`link_type` int(1) NOT NULL,
`value` varchar(250) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `entry_posities`
--
CREATE TABLE `entry_posities` (
`entry_positie_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`positie_id` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `entry_posities`
--
INSERT INTO `entry_posities` (`entry_positie_id`, `unique_id`, `positie_id`) VALUES
(1, 8, 3),
(2, 7, 3),
(17, 12, 1),
(10, 13, 1),
(11, 14, 1),
(13, 2, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `entry_syns`
--
CREATE TABLE `entry_syns` (
`entry_syn_id` int(10) NOT NULL,
`uid` int(10) NOT NULL,
`field_id` int(10) NOT NULL,
`syn_id` int(10) NOT NULL,
`org_syn_id` int(10) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `entry_tags`
--
CREATE TABLE `entry_tags` (
`entry_tag_id` int(10) NOT NULL,
`unique_id` int(10) UNSIGNED NOT NULL,
`tag_id` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `entry_tags`
--
INSERT INTO `entry_tags` (`entry_tag_id`, `unique_id`, `tag_id`) VALUES
(65, 3, 1),
(71, 4, 1),
(67, 5, 1),
(73, 6, 1),
(68, 5, 2),
(88, 9, 2),
(70, 10, 2),
(69, 10, 1),
(30, 11, 1),
(29, 11, 2),
(84, 28, 1),
(83, 28, 4),
(90, 24, 1),
(89, 24, 4),
(82, 29, 4),
(81, 29, 1),
(66, 3, 2),
(87, 9, 1),
(72, 4, 2),
(74, 6, 2);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `field_types`
--
CREATE TABLE `field_types` (
`field_id` mediumint(8) UNSIGNED NOT NULL,
`name` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`form_element` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`datatype` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`description` varchar(250) NOT NULL,
`in_group` int(1) NOT NULL DEFAULT '0',
`in_formgenerator` int(1) NOT NULL DEFAULT '0',
`in_template` int(1) NOT NULL DEFAULT '0',
`in_dragdrop` int(1) NOT NULL DEFAULT '0',
`html` text NOT NULL,
`wrap` int(1) NOT NULL DEFAULT '1',
`position` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Gegevens worden geëxporteerd voor tabel `field_types`
--
INSERT INTO `field_types` (`field_id`, `name`, `form_element`, `datatype`, `description`, `in_group`, `in_formgenerator`, `in_template`, `in_dragdrop`, `html`, `wrap`, `position`) VALUES
(1, 'Input', 'text', 'varchar(250)', 'Tekstveld', 0, 1, 1, 0, '', 1, 0),
(5, 'Text', 'textarea', 'text', 'Tekstveld (multiline)', 1, 1, 1, 0, '', 1, 0),
(6, 'Image', 'image', 'tinytext', 'Foto', 1, 0, 1, 0, '', 1, 0),
(11, 'Tags', 'tag', 'text', 'Tags', 0, 0, 1, 0, '', 1, 0),
(12, 'Entry links', 'link', 'varchar(250)', 'Links', 0, 0, 1, 0, '', 1, 0),
(22, 'shop', 'shop', 'varchar(250)', 'Shop', 0, 0, 1, 0, '', 1, 0),
(25, 'Group', 'field_group', 'veld groep', 'Group', 0, 0, 0, 1, '<div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div>', 0, 0),
(3, 'autocomplete', 'autocomplete', 'int(10)', 'Autocomplete', 0, 0, 1, 0, '', 1, 0),
(24, 'checkbox', 'checkbox', 'int(10)', 'Checkbox', 0, 1, 1, 0, '', 1, 0),
(26, 'h1', 'h1', 'varchar(250)', 'h1', 0, 0, 1, 0, '<div class=\"col24 single-row\">\r\n<div class=\"column-wrapper\">\r\n<h1>{fields_contents}</h1>\r\n</div>\r\n</div>', 1, 1),
(27, 'h2', 'h2', 'varchar(250)', 'h2', 0, 0, 1, 0, '<div class=\"col24 single-row\">\r\n<div class=\"column-wrapper\">\r\n<h2>{fields_contents}</h2>\r\n</div>\r\n</div>', 1, 2),
(28, 'select', 'select', 'varchar(250)', 'Select', 0, 1, 1, 0, '', 1, 0),
(29, 'Files', 'files', 'text', 'Files', 1, 0, 1, 0, '', 1, 0),
(14, 'Date', 'datepicker', 'varchar(250)', 'Date', 0, 1, 1, 0, '', 1, 0),
(31, 'radio', 'radio', 'int(10)', 'Radio', 0, 1, 1, 0, '', 1, 0),
(32, 'Form group', 'formgroup', 'varchar(250)', 'Form group', 0, 1, 0, 0, '', 1, 0),
(33, 'form', 'form', 'int(10)', 'form', 0, 0, 1, 0, '', 1, 0),
(34, 'em', 'em', 'varchar(250)', 'em', 0, 0, 1, 0, '', 1, 0),
(35, 'share', 'share', 'text', 'share', 0, 0, 1, 0, '<span class=\'st_facebook_hcount\' displayText=\'Facebook\'></span>\r\n <span class=\'st_twitter_hcount\' displayText=\'Tweet\'></span>\r\n <span class=\'st_linkedin_hcount\' displayText=\'LinkedIn\'></span>\r\n <span class=\'st_googleplus_hcount\' displayText=\'Google +\'></span>\r\n <span class=\'st_email_hcount\' displayText=\'Email\'></span>', 1, 0),
(36, 'cols', 'cols', 'text', 'cols', 0, 0, 1, 0, '', 1, 0),
(37, 'Color', 'colorpicker', 'varchar(250)', 'color', 0, 0, 1, 0, '', 1, 0),
(38, 'code', 'code', 'text', 'code', 0, 0, 0, 0, '', 1, 0),
(40, '2-column', '2-column', 'text', '2-column', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n\r\n<div class=\"small-12 medium-6 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-6 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div', 1, 2),
(39, '1-column', '1-column', 'text', '1-column', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"medium-12 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 1, 1),
(51, 'custom', 'custom', 'custom', 'custom', 0, 0, 0, 1, '\r\n<div class=\"custom-code\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>', 0, 17),
(66, 'graph', 'graph', 'text', 'graph', 0, 0, 1, 0, '', 1, 18),
(42, '3-column', '3-column', 'text', '3-column', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"small-12 medium-4 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-4 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-4 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 1, 3),
(41, '4-column', '4-column', 'text', '4-column', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"small-12 medium-6 large-3 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-6 large-3 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-6 large-3 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-6 large-3 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 1, 4),
(43, 'img', 'img', 'img', 'Foto', 0, 0, 0, 1, '<div class=\"image-full-width\">\r\n <div class=\"column-wrapper background\" edittype=\"image\">\r\n <img src=\"http://placehold.it/1200x300&text=IMAGE\">\r\n </div>\r\n</div>', 1, 18),
(44, 'devider', 'devider', 'text', 'devider', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x hr-devider\">\r\n<div class=\"medium-12 cell\">\r\n<hr/>\r\n</div>\r\n</div>', 1, 0),
(45, 'spacer', 'spacer', 'spacer', 'spacer', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"small-12 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<div class=\"column-wrapper\" edittype=\"spacer\"><div class=\"default-spacer\"></div></div>\r\n\r\n</div>\r\n</div>\r\n</div>\r\n', 1, 0),
(46, 'dragdrop', 'dragdrop', 'text', 'dragdrop', 0, 0, 1, 0, '', 1, 0),
(48, '2-column-centered', '2-column-centered', 'text', '2-column-centered', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"medium-3 medium-offset-3 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-3 end cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 1, 8),
(49, '3-column-centered', '3-column-centered', 'text', '3-column-centered', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x align-center\">\r\n<div class=\"medium-3 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-3 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-3 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 1, 9),
(50, '1-column-centered', '1-column-centered', 'text', '1-column-centered', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x align-center\">\r\n<div class=\"small-12 medium-8 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 1, 7),
(54, 'showcase', 'showcase', 'showcase', 'showcase', 0, 0, 0, 1, '<section id=\"egghgcifke\" class=\"\">\r\n <div class=\"image-showcase\">\r\n <div class=\"showcase-case\" datagroup=\"case\">\r\n \r\n \r\n \r\n <div class=\"grid-container case-foreground\" edittype=\"textarea\">\r\n <div class=\"grid-x grid-padding-x align-middle\">\r\n \r\n <div class=\"small-12 cell\">\r\n <div class=\"column-wrapper\" edittype=\"showcase-text\">\r\n \r\n <h1>Heading</h1>\r\n <p>Text</p>\r\n \r\n </div>\r\n </div>\r\n \r\n </div> \r\n </div>\r\n\r\n <div class=\"column-wrapper case-background\" edittype=\"showcase-image\"> \r\n <img src=\"https://via.placeholder.com/1200x600?text=image\">\r\n </div>\r\n \r\n \r\n \r\n </div>\r\n </div>\r\n</section>', 0, 0),
(55, '1-2-column', '1-2-column', 'text', '2-column', 0, 0, 0, 0, '<div class=\"col8\">\r\n<div class=\"column-wrapper\" edittype=\"textarea\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col16\">\r\n<div class=\"column-wrapper\" edittype=\"textarea\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n</div>\r\n</div>', 1, 12),
(57, 'item-links', 'item-links', 'category-link', 'item-links', 0, 0, 0, 0, '<div class=\"col6\">\r\n <div class=\"column-wrapper\" edittype=\"textarea\">\r\n <p>Room for image</p>\r\n </div>\r\n </div>\r\n\r\n <div class=\"col18\">\r\n <div class=\"column-wrapper\" edittype=\"textarea\">\r\n <p>Room for text</p>\r\n </div>\r\n</div>', 1, 15),
(58, '1-4-column', '1-4-column', 'text', '1-4-column', 0, 0, 0, 0, '<div class=\"col6\">\r\n<div class=\"column-wrapper\" edittype=\"textarea\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col18\">\r\n<div class=\"column-wrapper\" edittype=\"textarea\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n</div>\r\n</div>', 1, 13),
(59, 'geboortedatum', 'geboortedatum', 'varchar(250)', 'geboortedatum', 0, 1, 1, 0, '', 1, 0),
(60, 'upload', 'upload', 'varchar(250)', 'upload', 0, 1, 1, 0, '', 1, 0),
(61, 'postdata', 'postdata', 'varchar(250)', 'postdata', 0, 1, 1, 0, '', 1, 0),
(63, '3-1-column', '3-1-column', 'text', '3-1-column', 0, 0, 0, 0, '<div class=\"col18\">\r\n<div class=\"column-wrapper\" edittype=\"textarea\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col6\">\r\n<div class=\"column-wrapper\" edittype=\"textarea\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n</div>\r\n</div>\r\n', 1, 14),
(64, 'synoniem', 'synoniem', 'varchar(255)', 'synoniem', 0, 0, 1, 0, '', 1, 0),
(62, 'Image-crop', 'image-crop', 'text', 'image-crop', 0, 0, 1, 0, '', 1, 0),
(65, '4-column-centered', '4-column-centered', 'text', '4-column-centered', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x text-center\">\r\n<div class=\"medium-2 medium-offset-2 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-2 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-2 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-2 end cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 1, 9),
(67, '5-column', '5-column', 'text', '5-column', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n\r\n</div>', 1, 5),
(68, '3-column - enlarge image', '3-column - enlarge image', 'text', '3-column - enlarge image', 0, 0, 0, 0, '<div class=\"grid-x grid-padding-x align-center enlarge-images\">\r\n<div class=\"small-12 medium-4 cell\">\r\n\r\n<div class=\"column-wrapper image\" edittype=\"image\">\r\n<img src=\"http://placehold.it/600x300&text=IMAGE\" class=\"lazyload\">\r\n</div>\r\n\r\n</div>\r\n\r\n\r\n\r\n<div class=\"small-12 medium-4 cell\">\r\n\r\n<div class=\"column-wrapper image\" edittype=\"image\">\r\n<img src=\"http://placehold.it/600x300&text=IMAGE\" class=\"lazyload\">\r\n</div>\r\n\r\n</div>\r\n\r\n\r\n\r\n<div class=\"small-12 medium-4 cell\">\r\n\r\n<div class=\"column-wrapper image\" edittype=\"image\">\r\n<img src=\"http://placehold.it/600x300&text=IMAGE\" class=\"lazyload\">\r\n</div>\r\n\r\n</div>\r\n\r\n</div>', 1, 6),
(76, '3-column options', '3-column options', 'text', '3-column options', 0, 0, 0, 0, '<div class=\"grid-x grid-padding-x text-center row-options\">\r\n\r\n<div class=\"medium-4 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<h3 edit=\"h\">Hotel Zeist</h3>\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n<div class=\"medium-4 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<h3 edit=\"h\">Hotel Zeist</h3>\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n<div class=\"medium-4 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<h3 edit=\"h\">Hotel Zeist</h3>\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n\r\n\r\n</div>', 1, 6),
(71, '2-column Impressie', '2-column Impressie', 'text', '2-column Impressie', 0, 0, 0, 0, '<div class=\"grid-x grid-padding-x align-center row-impression\">\r\n\r\n<div class=\"small-12 medium-6 cell\">\r\n<div class=\"column-wrapper image\" edittype=\"image\">\r\n<img src=\"https://placehold.it/600x300&text=IMAGE\" class=\"lazyload\">\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-6 cell\">\r\n<div class=\"column-wrapper image\" edittype=\"image\">\r\n<img src=\"https://placehold.it/600x300&text=IMAGE\" class=\"lazyload\">\r\n</div>\r\n</div>\r\n\r\n</div>', 1, 6),
(74, '1-column Impressie', '1-column Impressie', 'text', '1-column Impressie', 0, 0, 0, 0, '<div class=\"grid-x grid-padding-x align-center row-impression\">\r\n\r\n\r\n<div class=\"small-12 medium-12 cell\">\r\n<div class=\"column-wrapper image\" edittype=\"image\">\r\n<img src=\"https://placehold.it/1200x600&text=IMAGE\" class=\"lazyload\">\r\n</div>\r\n</div>\r\n\r\n</div>', 1, 6),
(69, '2-column callout', '2-column callout', 'text', '2-column callout', 0, 0, 0, 0, '<div class=\"grid-x grid-padding-x\">\r\n\r\n <div class=\"small-12 large-6 cell\">\r\n\r\n <div class=\"column-wrapper\">\r\n <div class=\"callout\">\r\n \r\n <h3>Titel</h3>\r\n <p>Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. </p>\r\n <a data-toggle=\"panel1\">Meer Informatie</a>\r\n \r\n <div id=\"panel1\" class=\"hide\" data-toggler=\"hide\">\r\n <p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n </div>\r\n \r\n </div>\r\n </div>\r\n \r\n \r\n\r\n </div>\r\n\r\n\r\n <div class=\"small-12 large-6 cell\">\r\n\r\n <div class=\"column-wrapper\">\r\n <div class=\"callout\">\r\n \r\n <h3>Titel</h3>\r\n <p>Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. </p>\r\n <a data-toggle=\"panel2\">Meer Informatie</a>\r\n \r\n <div id=\"panel2\" class=\"hide\" data-toggler=\"hide\">\r\n <p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n </div>\r\n \r\n </div>\r\n </div>\r\n\r\n </div>\r\n\r\n \r\n</div>\r\n', 1, 6),
(70, 'button', 'button', 'text', 'button', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"small-12 cell text-center\">\r\n\r\n <div class=\"column-wrapper link\" edittype=\"link\">\r\n <a href=\"#\" class=\"button primary\">Button text</a>\r\n </div>\r\n\r\n</div>\r\n</div>', 1, 6),
(72, '3-column imageslider', '3-column imageslider', 'image-slider', '3-column imageslider', 0, 0, 0, 0, '<div class=\"grid-x grid-padding-x align-center row-sliders text-center\">\r\n\r\n<div class=\"small-12 medium-4 cell\">\r\n <h3 edit=\"h\">Heading</h3>\r\n <div class=\"image-slider\">\r\n <div class=\"slider-case\" datagroup=\"case\">\r\n \r\n <div class=\"column-wrapper case-background\" edittype=\"showcase-image\"> \r\n <img src=\"https://via.placeholder.com/1200x600?text=image\">\r\n </div>\r\n \r\n </div>\r\n </div>\r\n\r\n</div>\r\n\r\n<div class=\"small-12 medium-4 cell\">\r\n <h3 edit=\"h\">Heading</h3>\r\n <div class=\"image-slider\">\r\n <div class=\"slider-case\" datagroup=\"case\">\r\n \r\n <div class=\"column-wrapper case-background\" edittype=\"showcase-image\"> \r\n <img src=\"https://via.placeholder.com/1200x600?text=image\">\r\n </div>\r\n \r\n </div>\r\n </div>\r\n\r\n</div>\r\n\r\n<div class=\"small-12 medium-4 cell\">\r\n <h3 edit=\"h\">Heading</h3>\r\n <div class=\"image-slider\">\r\n <div class=\"slider-case\" datagroup=\"case\">\r\n \r\n <div class=\"column-wrapper case-background\" edittype=\"showcase-image\"> \r\n <img src=\"https://via.placeholder.com/1200x600?text=image\">\r\n </div>\r\n \r\n </div>\r\n </div>\r\n\r\n</div>\r\n\r\n\r\n\r\n\r\n</div>', 1, 16),
(73, 'Youtube', 'Youtube', 'youtube-embed', 'Youtube', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x align-center text-center\">\r\n\r\n<div class=\"small-12 cell\">\r\n \r\n \r\n <div class=\"responsive-embed widescreen\" edittype=\"responsive-embed\">\r\n <iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/oLk4dZl6z4c\" frameborder=\"0\" allow=\"autoplay; encrypted-media\" allowfullscreen></iframe>\r\n </div>\r\n \r\n</div>\r\n\r\n\r\n</div>\r\n\r\n', 1, 16),
(75, '4-column options', '4-column options', 'text', '4-column options', 0, 0, 0, 0, '<div class=\"grid-x grid-padding-x text-center row-options\">\r\n\r\n<div class=\"medium-3 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<h3 edit=\"h\">Hotel Zeist</h3>\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n<div class=\"medium-3 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<h3 edit=\"h\">Hotel Zeist</h3>\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n<div class=\"medium-3 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<h3 edit=\"h\">Hotel Zeist</h3>\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n<div class=\"medium-3 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<h3 edit=\"h\">Hotel Zeist</h3>\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n</div>', 1, 6),
(77, '4-column links', '4-column links', 'text', '4-column links', 0, 0, 0, 0, '<div class=\"grid-x grid-padding-x text-center row-options\">\r\n\r\n<div class=\"medium-3 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n<div class=\"medium-3 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n<div class=\"medium-3 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n<div class=\"medium-3 cell\">\r\n\r\n<div class=\"card\">\r\n\r\n<div class=\"card-section\">\r\n<a href=\"#\" class=\"button hollow\" edit=\"button\">Boek een hotelkamer</a>\r\n</div>\r\n\r\n<div class=\"card-image\">\r\n<div class=\"column-wrapper\" edittype=\"image\">\r\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/figi/images/Single-hotelkamers-2.jpg\" class=\"lazyload\" alt=\"\">\r\n</div>\r\n</div>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n</div>', 1, 6),
(78, '4-column-callout', '4-column-callout', 'text', '4-column-callout', 0, 0, 0, 0, '<div class=\"grid-x grid-padding-x features-block\">\r\n\r\n <div class=\"small-12 medium-6 large-3 cell\">\r\n <div class=\"card\">\r\n \r\n <div class=\"card-image\">\r\n <div class=\"column-wrapper\" edittype=\"image\">\r\n <img src=\"http://placehold.it/600x300&text=IMAGE\" class=\"lazyload\">\r\n </div>\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n </div> \r\n <a href=\"#\" class=\"button\" edit=\"button\">Link label</a>\r\n </div>\r\n \r\n </div>\r\n </div>\r\n\r\n\r\n <div class=\"small-12 medium-6 large-3 cell\">\r\n <div class=\"card\">\r\n \r\n <div class=\"card-image\">\r\n <div class=\"column-wrapper\" edittype=\"image\">\r\n <img src=\"http://placehold.it/600x300&text=IMAGE\" class=\"lazyload\">\r\n </div>\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n </div> \r\n <a href=\"#\" class=\"button\" edit=\"button\">Link label</a>\r\n </div>\r\n \r\n </div>\r\n </div>\r\n\r\n\r\n <div class=\"small-12 medium-6 large-3 cell\">\r\n <div class=\"card\">\r\n \r\n <div class=\"card-image\">\r\n <div class=\"column-wrapper\" edittype=\"image\">\r\n <img src=\"http://placehold.it/600x300&text=IMAGE\" class=\"lazyload\">\r\n </div>\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n </div> \r\n <a href=\"#\" class=\"button\" edit=\"button\">Link label</a>\r\n </div>\r\n \r\n </div>\r\n </div>\r\n\r\n\r\n <div class=\"small-12 medium-6 large-3 cell\">\r\n <div class=\"card\">\r\n \r\n <div class=\"card-image\">\r\n <div class=\"column-wrapper\" edittype=\"image\">\r\n <img src=\"http://placehold.it/600x300&text=IMAGE\" class=\"lazyload\">\r\n </div>\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n </div> \r\n <a href=\"#\" class=\"button\" edit=\"button\">Link label</a>\r\n </div>\r\n \r\n </div>\r\n </div>\r\n\r\n\r\n</div>', 1, 6),
(79, '6-column', '6-column', 'text', '6-column', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-auto cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n\r\n</div>', 1, 6),
(80, '5-column-centered', '5-column-centered', 'text', '5-column-centered', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x text-center small-up-1 medium-up-5\">\r\n<div class=\"cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 1, 4),
(81, '5-column-centered', '5-column-centered', 'text', '5-column-centered', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x text-center small-up-1 medium-up-5\">\r\n<div class=\"cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 1, 4),
(84, 'locaties', 'locaties', 'text', 'locaties', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"cell small-12\">\r\n\r\n <div class=\"grid-container\">\r\n <div class=\"grid-x grid-padding-x full align-center text-center\">\r\n \r\n <div class=\"mall-12 medium-3 cell\">\r\n <div class=\"column-wrapper\" edit=\"text\">\r\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n </div>\r\n </div>\r\n \r\n <div class=\"mall-12 medium-3 cell\">\r\n <div class=\"column-wrapper\" edit=\"text\">\r\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n </div>\r\n </div>\r\n \r\n </div>\r\n </div>\r\n \r\n <div class=\"grid-x grid-padding-x full align-center text-center\">\r\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"http://placehold.it/1800x300&text=IMAGE\"></div>\r\n </div>\r\n\r\n</div>\r\n</div>\r\n', 1, 8);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `forms`
--
CREATE TABLE `forms` (
`form_id` int(10) NOT NULL,
`form_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`form_response` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`form_submitted` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`custom_form_code` text COLLATE utf8_unicode_ci NOT NULL,
`unique_id` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`active` int(1) NOT NULL DEFAULT '0',
`form_desc` text COLLATE utf8_unicode_ci NOT NULL,
`button_label` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`custom_handler` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`locked` int(1) NOT NULL DEFAULT '0',
`field_response` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `form_elements`
--
CREATE TABLE `form_elements` (
`form_element_id` int(10) NOT NULL,
`unique_id` varchar(25) CHARACTER SET latin1 NOT NULL DEFAULT '',
`field_id` int(10) NOT NULL DEFAULT '0',
`name` varchar(250) CHARACTER SET latin1 NOT NULL DEFAULT '',
`description` text CHARACTER SET latin1 NOT NULL,
`position` int(10) NOT NULL DEFAULT '0',
`class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`value` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `form_elements_options`
--
CREATE TABLE `form_elements_options` (
`form_option_id` int(10) NOT NULL,
`form_element_id` int(10) NOT NULL,
`value` varchar(250) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `form_response`
--
CREATE TABLE `form_response` (
`form_response_id` int(10) NOT NULL,
`uid` varchar(250) NOT NULL,
`form_id` int(10) NOT NULL,
`field_id` int(10) NOT NULL,
`value` text NOT NULL,
`status` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `htmltemplates`
--
CREATE TABLE `htmltemplates` (
`template_id` int(10) NOT NULL,
`titel` varchar(250) NOT NULL,
`omschrijving` text NOT NULL,
`html` text NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `instellingen`
--
CREATE TABLE `instellingen` (
`id` int(10) NOT NULL,
`bedrijfsnaam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`adres` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`postcode_woonplaats` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`telefoon` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`bank` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`bank_iban` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`bank_bic` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`kvk` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`btw` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`master_email` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`website` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`postbus` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`postbus_postcode_plaats` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`facebook_url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`twitter_url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`youtube_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`linkedin_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`pinterest_url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`googleplus_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`items_per_pagina` int(10) NOT NULL DEFAULT '20',
`ideal` int(1) NOT NULL DEFAULT '0',
`factuur` int(1) NOT NULL DEFAULT '0',
`automatische_incasso` int(1) NOT NULL DEFAULT '0',
`administratie_kosten` float NOT NULL DEFAULT '0',
`verzendkosten` float NOT NULL DEFAULT '0',
`prefix_order_nummer` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '2013',
`order_nummer` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
`btw_percentage` float NOT NULL DEFAULT '21',
`logo` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`logo_style` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`ideal_type` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'basic',
`webshop` int(1) NOT NULL DEFAULT '0',
`html_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`standaard_kleur` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '#000000',
`css` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`custom_header` text COLLATE utf8_unicode_ci NOT NULL,
`custom_footer` text COLLATE utf8_unicode_ci NOT NULL,
`custom_sidebar` text COLLATE utf8_unicode_ci NOT NULL,
`registration_mail` text COLLATE utf8_unicode_ci NOT NULL,
`toon_menu` int(1) NOT NULL DEFAULT '1',
`sticky_footer` int(1) NOT NULL DEFAULT '1',
`payoff` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`typekit` text COLLATE utf8_unicode_ci NOT NULL,
`google_analitics` text COLLATE utf8_unicode_ci NOT NULL,
`myparcel_user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`myparcel_apikey` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`tp_confirm_email` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `instellingen`
--
INSERT INTO `instellingen` (`id`, `bedrijfsnaam`, `adres`, `postcode_woonplaats`, `telefoon`, `bank`, `bank_iban`, `bank_bic`, `kvk`, `btw`, `master_email`, `website`, `postbus`, `postbus_postcode_plaats`, `facebook_url`, `twitter_url`, `youtube_url`, `linkedin_url`, `pinterest_url`, `googleplus_url`, `items_per_pagina`, `ideal`, `factuur`, `automatische_incasso`, `administratie_kosten`, `verzendkosten`, `prefix_order_nummer`, `order_nummer`, `btw_percentage`, `logo`, `logo_style`, `ideal_type`, `webshop`, `html_title`, `standaard_kleur`, `css`, `custom_header`, `custom_footer`, `custom_sidebar`, `registration_mail`, `toon_menu`, `sticky_footer`, `payoff`, `typekit`, `google_analitics`, `myparcel_user`, `myparcel_apikey`, `tp_confirm_email`) VALUES
(1, 'Kiesjeschoolalphen.nl', '', '', '', '', '', '', '', '', '', 'http://univergeblue2019.test:8888/', '', '', '', '', '', '', '', '', 20, 1, 1, 0, 0, 4, '1300', '1', 21, 'images/nec_oabw.svg', 'height:24px;margin-bottom:24px;', 'basic', 0, 'Kies je school Alphen', '#ec6600', 'isochips.css', '', '', '', '<div>\nBeste {voornaam} {achternaam},<br /><br />\nBedankt voor je registratie op verfenbehangland.nl. Onderstaand een bevestiging van de door jou ingegevoerde gegevens.<br /><br />\n \nGoedinbehang.nl\n</div>', 1, 1, '', '<link rel=\"stylesheet\" href=\"https://use.typekit.net/kde3lxt.css\">', '<!-- Global site tag (gtag.js) - Google Analytics --> <script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-69398813-1\"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag(\'js\', new Date()); gtag(\'config\', \'UA-69398813-1\'); </script>', 'goedinbehang', '9d01e9463abc1cd789f3657e7d64513954583197', 'Beste {naam_volledig},\r\n\r\nHiermee bevestigen wij dat uw bestelling met ordernummer {ordernummer} vandaag door ons is verzonden naar:\r\n\r\n{aflveradres}\r\n\r\nU kunt uw pakket volgen met de Track & Trace link die u in een aparte e-mail ontvangt.\r\n\r\nMocht er onverhoopt iets mis zijn met de bestelling, mail dan direct naar verkoop@goedinbehang.nl dan zullen wij er voor zorgen dat het probleem zo snel mogelijk wordt opgelost.\r\n\r\nWij danken u vriendelijk voor uw bestelling.\r\n\r\nMet vriendelijke groet,\r\n\r\nGoedinbehang.nl\r\n');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `klanten`
--
CREATE TABLE `klanten` (
`klant_id` int(11) NOT NULL,
`type_klant` int(1) NOT NULL DEFAULT '1',
`bedrijfsnaam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`kvk` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`btw` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`telefoon` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`wachtwoord` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`aanhef` int(1) NOT NULL,
`voornaam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`tussenvoegsel` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`achternaam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`straat` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`huisnummer` int(10) NOT NULL,
`postcode` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`plaats` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`land` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`locale` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NL',
`nieuwsbrief` int(1) NOT NULL DEFAULT '0',
`ideal` int(1) NOT NULL DEFAULT '1',
`factuur` int(1) NOT NULL DEFAULT '0',
`incasso` int(1) NOT NULL DEFAULT '0',
`administratiekosten` int(1) NOT NULL DEFAULT '1',
`gevonden` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`saldo` float NOT NULL,
`datum_aanmelding` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `kortingcode_reeks`
--
CREATE TABLE `kortingcode_reeks` (
`codereeks_id` int(10) NOT NULL,
`kortingscode_id` int(10) NOT NULL,
`code` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`used_by_klant` int(10) NOT NULL DEFAULT '0',
`date_used` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `kortingscodes`
--
CREATE TABLE `kortingscodes` (
`kortingscode_id` int(10) NOT NULL,
`naam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`bedrag_percentage` int(10) NOT NULL,
`type_code` int(1) NOT NULL,
`prefix` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`geldig_van` date NOT NULL DEFAULT '0000-00-00',
`geldig_tot` date NOT NULL DEFAULT '0000-00-00',
`aantal` int(10) NOT NULL,
`onbeperkt` int(11) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1',
`position` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `languages`
--
CREATE TABLE `languages` (
`language_id` int(10) NOT NULL,
`name` varchar(100) NOT NULL,
`url` varchar(255) NOT NULL,
`locale` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `languages`
--
INSERT INTO `languages` (`language_id`, `name`, `url`, `locale`) VALUES
(1, 'nl', '', 'nl_NL');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `link_data`
--
CREATE TABLE `link_data` (
`link_data_id` int(10) NOT NULL,
`name` varchar(255) NOT NULL,
`find` varchar(255) NOT NULL,
`template` text NOT NULL,
`entry` int(10) NOT NULL DEFAULT '0',
`section` int(10) NOT NULL,
`category` int(10) NOT NULL,
`position` int(10) NOT NULL DEFAULT '0',
`repeat_items` int(10) NOT NULL DEFAULT '0',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `link_data`
--
INSERT INTO `link_data` (`link_data_id`, `name`, `find`, `template`, `entry`, `section`, `category`, `position`, `repeat_items`, `active`) VALUES
(1, 'agenda', '{agenda}', '<div class=\"agenda-item\">\n<h4>{evenement}</h4>\n<p class=\"date-time\">{datum},{tijd}</p>\n<img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/logo/ashram-college-logo.png\">\n<p>{intro} <a href=\"{link}\" class=\"\">Meer informatie</a></p>\n</div>', 0, 2, 0, 0, 4, 1),
(2, 'Blue Reasons', '{blue_reasons}', '<div class=\"reason-detail hide\" id=\"reason-{uid}\">\n{description}\n</div>', 0, 11, 3, 0, 1, 0),
(3, 'Resources', '{resources}', '<div class=\"small-12 medium-6 large-3 cell\"><div class=\"card\">\n<div class=\"card-image\">\n<img src=\"{src}\">\n</div>\n<div class=\"card-section\">\n<h4>{title}</h4>\n<p>{description}</p>\n<a href=\"{pdf}\">Learn More</a>\n</div>\n</div>\n</div>', 0, 15, 17, 0, 1, 0);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `link_data_fields`
--
CREATE TABLE `link_data_fields` (
`link_data_field_id` int(10) NOT NULL,
`template_data_id` int(10) NOT NULL,
`template` varchar(255) NOT NULL,
`field` varchar(255) NOT NULL,
`intro` int(1) NOT NULL DEFAULT '0',
`array` int(1) NOT NULL DEFAULT '0',
`index` int(10) NOT NULL DEFAULT '0',
`function` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`pattern` varchar(20) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `link_data_fields`
--
INSERT INTO `link_data_fields` (`link_data_field_id`, `template_data_id`, `template`, `field`, `intro`, `array`, `index`, `function`, `pattern`, `active`) VALUES
(1, 1, '{evenement}', 'evenement', 0, 0, 0, '0', '', 1),
(2, 1, '{datum}', 'datum', 0, 0, 0, '3', '%A %e %B %Y', 1),
(3, 1, '{tijd}', 'tijd', 0, 0, 0, '0', '', 1),
(4, 2, '{title}', 'name', 0, 0, 0, '0', '', 1),
(5, 2, '{description}', 'text', 0, 0, 0, '0', '', 1),
(6, 2, '{uid}', 'uid', 0, 0, 0, '0', '', 1),
(7, 3, '{src}', 'image', 0, 1, 0, '0', '', 1),
(8, 3, '{title}', 'filename', 0, 0, 0, '0', '', 1),
(9, 3, '{description}', 'description', 0, 0, 0, '0', '', 1),
(10, 3, '{pdf}', 'file_upload', 0, 1, 0, '0', '', 1),
(11, 1, '{intro}', 'intro', 0, 0, 0, '0', '', 1),
(12, 1, '{link}', 'entry_link', 0, 0, 0, '0', '', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `order_labels`
--
CREATE TABLE `order_labels` (
`label_id` int(10) NOT NULL,
`order_id` int(10) NOT NULL,
`consignment_id` varchar(255) NOT NULL,
`parcel_id` varchar(255) NOT NULL,
`tracktrace` varchar(255) NOT NULL,
`label` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `page_redirects`
--
CREATE TABLE `page_redirects` (
`redirect_id` int(10) NOT NULL,
`old_url` text CHARACTER SET latin1 NOT NULL,
`new_url` text CHARACTER SET latin1 NOT NULL,
`position` int(10) NOT NULL DEFAULT '0',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `page_section_content`
--
CREATE TABLE `page_section_content` (
`page_section_id` int(10) NOT NULL,
`page_id` int(10) NOT NULL,
`language_id` int(10) NOT NULL DEFAULT '1',
`html` text COLLATE utf8_unicode_ci NOT NULL,
`edittag` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`datatype` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`element_id` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`element_class` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`fullpage` int(1) NOT NULL DEFAULT '0',
`custom` int(1) NOT NULL DEFAULT '0',
`custom_content` text COLLATE utf8_unicode_ci NOT NULL,
`css` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`link_data` int(10) NOT NULL DEFAULT '0',
`sub_of` int(10) NOT NULL DEFAULT '0',
`position` int(10) NOT NULL DEFAULT '1',
`status` int(1) NOT NULL DEFAULT '1',
`locked` int(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `page_section_content`
--
INSERT INTO `page_section_content` (`page_section_id`, `page_id`, `language_id`, `html`, `edittag`, `datatype`, `element_id`, `element_class`, `fullpage`, `custom`, `custom_content`, `css`, `link_data`, `sub_of`, `position`, `status`, `locked`) VALUES
(1, 1, 1, '\n \n \n \n <section id=\"qzwdiqcnnu\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-12 cell\">\n<div class=\"column-wrapper\" style=\"\"></div>\n</div>\n</div></section>\n \n ', '1-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 0, 0),
(4, 1, 1, '\n \n \n \n \n \n <section id=\"qmpiuefiat\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-center align-top\">\n<div class=\"medium-12 cell \">\n<div class=\"column-wrapper\" style=\"\"><h2>Welke school past bij jou?</h2>\n\n<p>Hoe weet je welke school het beste bij jou past? Om je op weg te helpen hebben we speciaal voor jou het KiesKompas ontwikkeld. Geef aan welke schoolniveaus je wilt vergelijken, in welk stadsdeel je zoekt en in welke extra’s je geïnteresseerd bent, zoals een sportklas of technasium. Vervolgens krijg je een duidelijk overzicht met scholen die aan jouw zoekcriteria voldoen. Ontdek met een paar muisklikken uit welke scholen jij kunt kiezen. Succes!</p>\n\n<p><a class=\"button white\" href=\"#\">KIESKOMPAS Alphen aan den Rijn</a></p>\n</div>\n</div>\n</div></section>\n \n \n ', '1-column', 'text', '', '', 0, 0, 'text-center align-top', '', 0, 3, 2, 0, 0),
(3, 1, 1, '<section id=\"xpikmlgdad\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'panel-blue', 0, 0, 'text-left align-top', '', 0, 0, 2, 1, 0),
(2, 1, 1, '\n \n <section id=\"fiindlkqkw\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-top\">\n\n<div class=\"small-12 medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>School kiezen moeilijk?</h1>\n\n<h4><strong>Kies je school Alphen maakt het makkelijker</strong></h4>\n\n<p>Ben je ook zo benieuwd naar welke middelbare school je straks zult gaan? Wij helpen je graag een handje.</p>\n\n<p>Op deze pagina vind je alle middelbare scholen van Alphen en omgeving, met een overzicht van alle activiteiten die deze scholen verzorgen om jou te helpen kiezen. Met de keuzehulp heb je snel overzicht. In de agenda zie je van alle scholen wanneer ze jou welkom willen heten.</p>\n\n<p><strong>Voor welke school kies jij?</strong></p>\n\n<p><a class=\"button primary\" href=\"#\">Waar ga jij kijken?</a></p>\n\n<p><img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/kiesjeschool-alphen.jpg\"></p>\n</div>\n</div>\n\n<div class=\"small-12 medium-5 medium-offset-1 cell\">\n<div class=\"column-wrapper\" style=\"\"><h2><strong>Agenda</strong></h2>\n\n<p>{agenda}</p>\n\n<p><a class=\"button secondary\" href=\"#\">Overzicht informatiedagen</a></p>\n</div>\n</div>\n</div></section>\n \n \n \n \n \n \n \n ', '2-column', 'text', '', '', 0, 0, 'text-left align-top', '', 1, 0, 1, 1, 0),
(45, 24, 1, '\n \n \n \n \n \n \n \n <section id=\"pvfdclwyke\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n\n<div class=\"small-12 medium-4 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><br>\n<img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-college-nieuwkoop.png\" style=\"width: 75%;\"></p>\n\n<p><strong>CONTACT</strong></p>\n\n<p>Marsdiep 289<br>\n2401 XH Alphen aan den Rijn<br>\nT. 0172 43 02 34<br>\nE. info@ashramcollege.nl</p>\n\n<p><a href=\"https://www.ashramcollege.nl/nieuwkoop/\"><strong>www.ashramcollege.nl</strong></a></p>\n\n<ul class=\"no-bullet labels\">\n <li>Vmbo-basis</li>\n <li>vmbo-kader</li>\n <li>vmbo-theoretische leerweg</li>\n <li>havo</li>\n</ul>\n</div>\n</div>\n\n<div class=\"small-12 medium-8 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>Ashram College<br>\nNieuwkoop</h1>\n\n<p>Je advies is vmbo of havo en je bent helemaal klaar voor de middelbare school. Je krijgt nieuwe vakken, voor elk vak een andere leraar en elk uur les in een ander lokaal. Spannend! Bij jou in de buurt is een kleine, veilige school die overzichtelijk is en waar je al snel iedereen kent – en zij jou.<br>\nDie school is het Ashram College in Nieuwkoop. Bij ons kun je de tijd van je leven hebben én een waardevol diploma halen, want al jaren slaagt bij ons jaar al meer dan 98%!</p>\n\n<p>Verder is het bij ons heel erg gezellig en leer je vooral door te doén! Je krijgt op een traditionele manier les, maar we gebruiken ook een chromebook en er worden door de leerlingen heel veel leuke activiteiten georganiseerd. Daarnaast krijg je alle kansen om kennis te maken met allerlei verschillende beroepen zodat je straks heel goed weet wat je later worden wilt. Nieuwsgierig geworden? Ga naar een van onze kennismakingsmiddagen en laat je verrassen!</p>\n</div>\n</div>\n</div></section>\n \n \n \n ', '2-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 1, 0),
(5, 1, 1, '<section id=\"bcvrlcvrrv\" class=\"grid-container\"><div class=\"grid-x grid-padding-x align-center\">\n<div class=\"small-12 medium-3 cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n</div></section>', '1-column-centered', 'text', '', '', 0, 0, '', '', 0, 3, 2, 0, 0),
(6, 1, 1, '\n \n \n \n <section id=\"ytmupbzyfw\" class=\"grid-container\"><div class=\"grid-x grid-padding-x align-center text-center align-top\">\n<div class=\" medium-8 cell\">\n<div class=\"column-wrapper\" style=\"\"><h2>Welke school past bij jou?</h2>\n\n<p>Hoe weet je welke school het beste bij jou past? Om je op weg te helpen hebben we speciaal voor jou de keuzehulp ontwikkeld. Geef aan welke schoolniveaus je wilt vergelijken, in welk stadsdeel je zoekt en in welke extra’s je geïnteresseerd bent, zoals een sportklas of technasium. Vervolgens krijg je een duidelijk overzicht met scholen die aan jouw zoekcriteria voldoen. Ontdek met een paar muisklikken uit welke scholen jij kunt kiezen. Succes!</p>\n\n<p><a class=\"button white\" href=\"/keuzehulp\">Keuzehulp Voortgezet Onderwijs Alphen aan den Rijn</a></p>\n</div>\n</div>\n</div></section>\n \n ', '1-column-centered', 'text', '', '', 0, 0, 'text-center align-top', '', 0, 3, 2, 1, 0),
(7, 1, 1, '\n \n \n \n <section id=\"haegbdnbuh\" class=\"grid-container\"><div class=\"image-full-width\">\n <div class=\"column-wrapper background\" edittype=\"image\">\n <img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/kiezen-wat-leuk-is.jpg\" alt=\"\">\n </div>\n</div></section>\n \n ', 'img', 'img', '', '', 1, 0, 'text-left align-top', '', 0, 0, 3, 1, 0),
(8, 1, 1, '\n \n \n \n <section id=\"dziwxozzxa\" class=\"\">\n<div class=\"custom-code\"><div id=\"school-locator\" class=\"locator\"></div></div></section>\n \n ', 'custom', 'custom', '', '', 0, 0, '', '', 0, 0, 4, 0, 0),
(9, 1, 1, '<section id=\"ptcpcxgtar\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'panel-pink', 0, 0, 'text-left align-top', '', 0, 0, 5, 0, 0),
(10, 1, 1, '\n \n \n \n \n \n <section id=\"ahubnwpffm\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"small-12 medium-6 large-3 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/logo/ashram-college-logo.png\"></p>\n</div>\n</div>\n\n<div class=\"small-12 medium-6 large-3 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/logo/Groene-Hart-logo.png\"></p>\n</div>\n</div>\n\n<div class=\"small-12 medium-6 large-3 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/logo/logo_scala.gif\"></p>\n</div>\n</div>\n\n<div class=\"small-12 medium-6 large-3 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/logo/wellant-college-logo.png\"></p>\n</div>\n</div>\n</div></section>\n \n \n ', '4-column', 'text', '', '', 0, 0, '', '', 0, 9, 5, 0, 0),
(11, 2, 1, '\n \n \n \n <section id=\"krmtzhzvfl\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-12 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>Ashram College in Alphen aan den Rijn</h1>\n\n<p>Op het Ashram College volg je een opleiding mavo, havo, vwo (atheneum of gymnasium). We zijn een creatieve school waar je vanaf het eerste jaar muziek, drama en beeldende vorming (Art-vakken) volgt en deze tot aan je examenjaar als keuzevak kunt blijven volgen. We vinden het belangrijk dat je leert wat je moet weten én dat je leert wat jij wilt leren. Naast de lessen in de klas en in de domeinen Art, Society, Science en Sport ga je tijdens de projecturen aan de slag met wat jij wilt. Vraag jij je vaak af hoe een Tesla nou precies werkt of heb je altijd eens een eigen tijdschrift over paarden willen maken? Dat kan tijdens de projecturen. Je leert - onder begeleiding van een docent - niet alleen meer over het onderwerp, maar ook over jezelf en je skills om projectmatig te werken. Natuurlijk helpen we je daar goed bij zodat je skills (onderzoeken, creatief denken, samenwerken etc.) ontwikkelt die je goed kunt gebruiken in de toekomst. In De Brugklas heb je een eigen coach met wie je jouw persoonlijke ontwikkeling bespreekt.</p>\n\n<p>Nieuw op het Ashram: coderen. Wist je dat computers een taal spreken? En als je die taal spreekt er een wereld voor je opengaat? Tijdens de lessen coderen ga je leren om te denken als een computer zodat je met gemak computerproblemen kunt oplossen én computers kunt laten doen wat jij wilt. Een stukje zelfredzaamheid in de digitale wereld is niet alleen handig, maar het geeft je ook een streepje voor.</p>\n</div>\n</div>\n</div></section>\n \n ', '1-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 0, 0),
(12, 2, 1, '\n \n \n \n \n \n \n \n \n \n \n \n <section id=\"yazearqpiz\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n\n<div class=\"small-12 medium-4 cell small-order-2 medium-order-1\">\n<div class=\"column-wrapper\" style=\"\"><p><br>\n<img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-college.png\" style=\"width: 75%;\"></p>\n\n<p><strong>www.ashramcollege.nl</strong></p>\n\n<ul class=\"no-bullet labels\">\n <li>MAVO</li>\n <li>HAVO</li>\n <li>VWO (atheneum)</li>\n <li>VWO (gymnasium)</li>\n <li>Nieuwkoop</li>\n <li>Alphen aan den rijn</li>\n</ul>\n</div>\n</div>\n\n<div class=\"small-12 medium-8 cell small-order-1 medium-order-2\">\n<div class=\"column-wrapper\" style=\"\"><h1>Ashram College</h1>\n\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. <strong>Donec quam felis, ultricies nec,</strong> pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. <strong>Nullam dictum felis</strong> eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. <strong>Aenean leo ligula, porttitor eu</strong>, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis feugiat.</p>\n</div>\n</div>\n</div></section>\n \n \n \n \n \n \n \n \n \n \n \n \n \n ', '2-column', 'text', '', '', 0, 0, '', '', 0, 0, 0, 1, 0),
(41, 26, 1, '\n \n \n \n \n \n <section id=\"upgwhambhq\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-top\">\n<div class=\"medium-12 cell \">\n<div class=\"column-wrapper\" style=\"\"><h1>Contactpersonen</h1>\n</div>\n</div>\n</div></section>\n \n \n ', '1-column', 'text', '', '', 0, 0, 'text-left align-top', '', 0, 0, 1, 1, 0),
(43, 26, 1, '\n \n <section id=\"qhpsgywrph\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-top\">\n\n<div class=\" medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><h3>Scala College</h3>\n\n<p>Voornaam Achternaam<br>\n<a href=\"mailto:naam@mailadres.nl\">naam@mailadres.nl</a></p>\n</div>\n</div>\n\n<div class=\" medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><h3>Wellant College</h3>\n\n<p>Voornaam Achternaam<br>\n<a href=\"mailto:naam@mailadres.nl\">naam@mailadres.nl</a></p>\n</div>\n</div>\n</div></section>\n ', '2-column', 'text', '', '', 0, 0, 'text-left align-top', '', 0, 0, 2, 1, 0),
(13, 2, 1, '<section id=\"zcwzykkmko\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'school-contact', 0, 0, 'text-left align-top', '', 0, 0, 2, 0, 0),
(14, 2, 1, '\n \n \n \n \n \n \n \n <section id=\"akpykslcpp\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-center align-top\">\n<div class=\"medium-12 cell \">\n<div class=\"column-wrapper\" style=\"\"><h2><strong>Vragen?</strong> Stel ze gerust<br>\naan onze instroomcoördinator</h2>\n</div>\n</div>\n</div></section>\n \n \n \n ', '1-column', 'text', '', '', 0, 0, 'text-center align-top', '', 0, 13, 2, 1, 0),
(15, 2, 1, '\n \n <section id=\"csiegwdyfs\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-middle\">\n\n<div class=\" medium-6 cell text-center medium-text-left\">\n<div class=\"column-wrapper\" style=\"\"><p class=\"portret\" style=\"text-align: right;\"><img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/PORTRET_HENK.jpg\"></p>\n</div>\n</div>\n\n<div class=\" medium-6 cell text-center medium-text-left\">\n<div class=\"column-wrapper\" style=\"\"><p><strong>Henk Wiegant</strong><br>\nAlphen aan den Rijn<br>\n<a href=\"mailto:h.wiegant@ashramcollege.nl\">h.wiegant@ashramcollege.nl</a></p>\n</div>\n</div>\n</div></section>\n \n \n ', '2-column', 'text', '', '', 0, 0, 'text-left align-middle', '', 0, 13, 2, 1, 0),
(16, 2, 1, '<section id=\"bbqaflnduv\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-3 medium-offset-3 cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n\n<div class=\"medium-3 end cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n</div></section>', '2-column-centered', 'text', '', '', 0, 0, '', '', 0, 0, 1, 0, 0),
(17, 2, 1, '<section id=\"yxmlfrqqqe\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', '', 0, 0, '', '', 0, 0, 1, 0, 0),
(18, 2, 1, '\n \n \n \n \n \n <section id=\"xetwuuelnc\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-3 medium-offset-3 cell\">\n<div class=\"column-wrapper\" style=\"\"><div class=\"card\"><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-alphen.png\">\n<div class=\"card-section\">\n<h4>Locatie<br>\nAlphen aan den rijn</h4>\n</div>\n</div>\n</div>\n</div>\n\n<div class=\"medium-3 end cell\">\n<div class=\"column-wrapper\" style=\"\"><div class=\"card\"><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-nieuwkoop.png\">\n<div class=\"card-section\">\n<h4>Locatie<br>\nNieuwkoop</h4>\n</div>\n</div>\n</div>\n</div>\n</div></section>\n \n \n ', '2-column-centered', 'text', '', '', 0, 0, '', '', 0, 17, 1, 0, 0),
(19, 2, 1, '<section id=\"bncwarzkmk\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n\n<div class=\"small-12 medium-6 cell\">\n<div class=\"column-wrapper\">\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n\n<div class=\"small-12 medium-6 cell\">\n<div class=\"column-wrapper\">\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n</div></section>', '2-column', 'text', '', '', 0, 0, '', '', 0, 17, 1, 0, 0),
(35, 9, 1, '\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n <section id=\"ftgvatfccm\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n\n<div class=\"small-12 medium-4 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><br>\n<img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-college-alphen.png\" style=\"width: 75%;\"></p>\n\n<p><strong>CONTACT</strong></p>\n\n<p>Achterweg 1<br>\n2421EB Nieuwkoop<br>\n0172 – 579216<br>\nE.nieuwkoop@ashramcollege.nl</p>\n\n<p><a href=\"https://www.ashramcollege.nl/alphen-aan-den-rijn/\"><strong>www.ashramcollege.nl</strong></a></p>\n\n<ul class=\"no-bullet labels\">\n <li>MAVO</li>\n <li>HAVO</li>\n <li>Atheneum</li>\n <li>Gymnasium</li>\n</ul>\n</div>\n</div>\n\n<div class=\"small-12 medium-8 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>Ashram College<br>\nAlphen aan den Rijn</h1>\n\n<p>Op het Ashram College volg je een opleiding <strong>mavo, havo, vwo (atheneum of gymnasium)</strong>. We zijn een creatieve school waar je vanaf het eerste jaar <strong>muziek, drama en beeldende vorming</strong> (Art-vakken) volgt en deze tot aan je examenjaar als keuzevak kunt blijven volgen. We vinden het belangrijk dat je leert wat je moet weten én dat je leert wat jij wilt leren. Naast de lessen in de klas en in de <strong>domeinen Art, Society, Science en Sport</strong> ga je tijdens de projecturen aan de slag met wat jij wilt. Vraag jij je vaak af hoe een Tesla nou precies werkt of heb je altijd eens een eigen tijdschrift over paarden willen maken? Dat kan tijdens de projecturen. Je leert - onder begeleiding van een docent - niet alleen meer over het onderwerp, maar ook over jezelf en je skills om projectmatig te werken. Natuurlijk helpen we je daar goed bij zodat je skills (onderzoeken, creatief denken, samenwerken etc.) ontwikkelt die je goed kunt gebruiken in de toekomst. <strong>In De Brugklas heb je een eigen coach</strong> met wie je jouw persoonlijke ontwikkeling bespreekt.</p>\n\n<h3>Nieuw op het Ashram: coderen</h3>\n\n<p>Wist je dat computers een taal spreken? En als je die taal spreekt er een wereld voor je opengaat? Tijdens de lessen coderen ga je leren om te denken als een computer zodat je met gemak computerproblemen kunt oplossen én computers kunt laten doen wat jij wilt. Een stukje zelfredzaamheid in de digitale wereld is niet alleen handig, maar het geeft je ook een streepje voor.</p>\n</div>\n</div>\n</div></section>\n \n \n \n \n \n \n \n \n \n \n ', '2-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 1, 0),
(20, 2, 1, '<section id=\"msonycozof\" class=\"grid-container\"><div class=\"image-full-width\">\n \n<div class=\"column-wrapper background\" edittype=\"image\">fdsfdfdsa\n </div>\n\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"http://placehold.it/1200x300&text=IMAGE\"></div>\n</div></section>', 'img2', 'img', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(21, 2, 1, '<section id=\"smfddtqpbg\" class=\"\"><section id=\"egghgcifke\" class=\"\">\n <div class=\"image-showcase\">\n <div class=\"showcase-case\" datagroup=\"case\">\n \n \n \n <div class=\"grid-container case-foreground\" edittype=\"textarea\">\n <div class=\"grid-x grid-padding-x align-middle\">\n \n <div class=\"small-12 cell\">\n <div class=\"column-wrapper\" edittype=\"showcase-text\">\n \n <h1>Heading</h1>\n <p>Text</p>\n \n </div>\n </div>\n \n </div> \n </div>\n\n <div class=\"column-wrapper case-background\" edittype=\"showcase-image\"> \n <img src=\"https://via.placeholder.com/1200x600?text=image\">\n </div>\n \n \n \n </div>\n </div>\n</section></section>', 'showcase', 'showcase', '', '', 0, 0, '', '', 0, 0, 4, 0, 0),
(22, 2, 1, '\n \n <section id=\"qzeobnxazu\" class=\"grid-container\"><div class=\"image-full-width\">\n \n <div class=\"column-wrapper foreground\">\n <div class=\"grid-container\">\n <div class=\"grid-x grid-padding-x align-center text-left align-top\">\n <div class=\"mall-12 medium-3 cell \">\n <div class=\"column-wrapper\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n <div class=\"mall-12 medium-3 cell \">\n <div class=\"column-wrapper\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n </div>\n </div> \n </div>\n\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"http://placehold.it/1200x300&text=IMAGE\"></div>\n \n</div></section>\n ', 'img2', 'img', '', '', 1, 0, 'text-left align-top', '', 0, 0, 3, 0, 0),
(23, 2, 1, '\n \n \n \n <section id=\"kdosulhigm\" class=\"grid-container\"><div class=\"grid-x grid-padding-x fluid text-left align-top\">\n\n <div class=\"column-wrapper foreground\">\n <div class=\"grid-container\">\n <div class=\"grid-x grid-padding-x align-center text-center\">\n \n <div class=\"mall-12 medium-3 cell \">\n <div class=\"column-wrapper\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n <div class=\"mall-12 medium-3 cell \">\n <div class=\"column-wrapper\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n </div>\n </div> \n </div>\n\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"http://placehold.it/1200x300&text=IMAGE\"></div>\n \n</div>\n</section>\n \n ', 'img2', 'img', '', '', 1, 0, 'text-left align-top', '', 0, 0, 3, 0, 0),
(24, 2, 1, '\n \n <section id=\"vvfhorkavf\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-top\">\n<div class=\"cell \">\n\n <div class=\"grid-x grid-padding-x full align-center text-center\">\n <div class=\"column-wrapper foreground\">\n fsgfsgfds\n </div>\n </div>\n\n <div class=\"grid-x grid-padding-x full align-center text-center\">\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"http://placehold.it/1200x300&text=IMAGE\"></div>\n </div>\n\n</div>\n</div>\n</section>\n ', 'img2', 'img', '', '', 1, 0, 'text-left align-top', '', 0, 0, 3, 0, 0),
(25, 2, 1, '\n \n <section id=\"gtactoqwri\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-top\">\n<div class=\"cell \">\n\n <div class=\"grid-x grid-padding-x full align-center text-center\">\n \n <div class=\"mall-12 medium-3 cell \">\n <div class=\"column-wrapper\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n <div class=\"mall-12 medium-3 cell \">\n <div class=\"column-wrapper\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n </div>\n\n <div class=\"grid-x grid-padding-x full align-center text-center\">\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"http://placehold.it/1800x300&text=IMAGE\"></div>\n </div>\n\n</div>\n</div></section>\n ', 'img2', 'img', '', '', 1, 0, 'text-left align-top', '', 0, 0, 3, 0, 0),
(26, 2, 1, '\n \n <section id=\"igdqvsdgxq\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-top\">\n<div class=\"cell \">\n\n <div class=\"grid-container\">\n <div class=\"grid-x grid-padding-x full align-center text-center\">\n \n <div class=\"mall-12 medium-3 cell \">\n <div class=\"column-wrapper\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n <div class=\"mall-12 medium-3 cell \">\n <div class=\"column-wrapper\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n </div>\n </div>\n \n <div class=\"grid-x grid-padding-x full align-center text-center\">\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"http://placehold.it/1800x300&text=IMAGE\"></div>\n </div>\n\n</div>\n</div>\n</section>\n ', 'img2', 'img', '', '', 1, 0, 'text-left align-top', '', 0, 0, 1, 0, 0),
(27, 2, 1, '\n \n \n \n <section id=\"paabxutrgw\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-top\">\n<div class=\"cell \">\n\n <div class=\"grid-container\">\n <div class=\"grid-x grid-padding-x full align-center text-center\">\n \n <div class=\"mall-12 medium-3 cell \">\n <div class=\"column-wrapper\" edit=\"text\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n <div class=\"mall-12 medium-3 cell \">\n <div class=\"column-wrapper\" edit=\"text\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n </div>\n </div>\n \n <div class=\"grid-x grid-padding-x full align-center text-center\">\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashram-college.jpg\" alt=\"\"></div>\n </div>\n\n</div>\n</div>\n</section>\n \n ', 'img2', 'img', '', '', 1, 0, 'text-left align-top', '', 0, 0, 3, 0, 0),
(28, 2, 1, '<section id=\"hpnqaxtkfx\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-3 medium-offset-3 cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n\n<div class=\"medium-3 end cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n</div>\n\n <div class=\"\">\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"http://placehold.it/1800x300&text=IMAGE\"></div>\n </div></section>', 'img2', 'img', '', '', 0, 0, '', '', 0, 0, 4, 0, 0),
(29, 2, 1, '<section id=\"gqspsoufzk\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-3 medium-offset-3 cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n\n<div class=\"medium-3 end cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n</div>\n\n </section>', 'img2', 'img', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(30, 2, 1, '<section id=\"ywtwrvepge\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-center small-up-1 medium-up-5\">\n<div class=\"cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n</div>\n</div>\n\n<div class=\"cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n</div>\n</div>\n\n<div class=\"cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n</div>\n</div>\n\n<div class=\"cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n</div>\n</div>\n\n<div class=\"cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n</div>\n</div>\n</div></section>', 'img2', 'img', '', '', 0, 0, '', '', 0, 0, 0, 0, 0),
(31, 2, 1, '\n \n <section id=\"tlwmsaoqku\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n\n<div class=\"small-12 medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\">\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n\n<div class=\"small-12 medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n</div>\n</div>\n</div></section>\n ', '2-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 0, 0),
(32, 2, 1, '<section id=\"hskiusolet\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-3 medium-offset-3 cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n\n<div class=\"medium-3 end cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n</div></section>', '2-column-centered', 'text', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(33, 2, 1, '\n \n <section id=\"yqseysvmcl\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"cell small-12\">\n\n <div class=\"grid-container\">\n <div class=\"grid-x grid-padding-x full align-center text-center\">\n \n <div class=\"mall-12 medium-3 cell\">\n <div class=\"column-wrapper\" edit=\"text\" style=\"\"><p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n</div>\n </div>\n \n <div class=\"mall-12 medium-3 cell\">\n <div class=\"column-wrapper\" edit=\"text\" style=\"\"><p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n</div>\n </div>\n \n </div>\n </div>\n \n <div class=\"grid-x grid-padding-x full align-center text-center\">\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"http://placehold.it/1800x300&text=IMAGE\"></div>\n </div><div id=\"default-selector\" class=\"layer\" style=\"\"><div class=\"case-contents\"><div class=\"selector-wrapper\"><label>Image</label><div id=\"image_visible\" class=\"selected-images colfix\"><div class=\"image-thumb\"><img src=\"http://placehold.it/1800x300&text=IMAGE\" id=\"selected-img\"></div></div><button class=\"button secondary init-imagefolder\" id=\"init-imagefolder\" type=\"button\">Browse</button><input type=\"hidden\" id=\"selected_img_name\" value=\"http://placehold.it/1800x300&text=IMAGE\" class=\"input browse\" autocomplete=\"off\"></div><label>Alternative text</label><div class=\"selector-wrapper\"><input type=\"text\" name=\"\" id=\"img-alt\"></div></div><button type=\"button\" class=\"button primary update-content\" id=\"default-button\"><i class=\"fa fa-arrow-circle-right\" aria-hidden=\"true\"></i> Update </button></div>\n\n</div>\n</div>\n</section>\n ', 'locaties', 'text', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(34, 2, 1, '<section id=\"mpqicpdazz\" class=\"grid-container full\">\r\n<div class=\"grid-x grid-padding-x text-left align-top\">\r\n<div class=\"cell small-12 no-transition\">\r\n \r\n <div class=\"grid-container foreground\">\r\n <div class=\"grid-x grid-margin-x grid-padding-x align-center text-center\">\r\n \r\n <div class=\"small-12 cell\">\r\n <div class=\"column-wrapper\" edit=\"text\" style=\"\">\r\n <h2>Locaties Ashram College</h2>\r\n </div>\r\n </div>\r\n \r\n\r\n <div class=\"small-10 medium-6 large-4 cell \">\r\n <div class=\"column-wrapper\" edit=\"text\" style=\"\"><h4>Alphen aan den rijn</h4>\r\n\r\n <p><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-alphen.png\"></p>\r\n\r\n <p><a href=\"/scholen-locaties/ashram/ashram-college-alphen\">Meer informatie</a></p>\r\n </div>\r\n </div>\r\n \r\n \r\n <div class=\"small-10 medium-6 large-4 cell \">\r\n <div class=\"column-wrapper\" edit=\"text\" style=\"\"><h4>Nieuwkoop</h4>\r\n\r\n <p><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-nieuwkoop.png\"></p>\r\n\r\n <p><a href=\"/scholen-locaties/ashram/ashram-college-nieuwkoop\">Meer informatie</a></p>\r\n </div>\r\n \r\n </div>\r\n </div>\r\n \r\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashram-middelbare-school-vo-alphen.jpg\" alt=\"\"></div>\r\n \r\n\r\n</div>\r\n</div>\r\n</section>', 'locaties', 'text', '', 'school-locaties', 1, 0, 'text-left align-top', '', 0, 0, 1, 1, 0),
(36, 9, 1, '<section id=\"eraqzkxlor\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"cell small-12\">\n\n <div class=\"grid-container\">\n <div class=\"grid-x grid-padding-x full align-center text-center\">\n \n <div class=\"mall-12 medium-3 cell\">\n <div class=\"column-wrapper\" edit=\"text\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n <div class=\"mall-12 medium-3 cell\">\n <div class=\"column-wrapper\" edit=\"text\">\n <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n </div>\n </div>\n \n </div>\n </div>\n \n <div class=\"grid-x grid-padding-x full align-center text-center\">\n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"http://placehold.it/1800x300&text=IMAGE\"></div>\n </div>\n\n</div>\n</div>\n</section>', 'locaties', 'text', '', '', 0, 0, '', '', 0, 0, 2, 0, 0),
(37, 9, 1, '<section id=\"scfqhlnkqt\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'school-contact', 0, 0, 'text-left align-top', '', 0, 0, 2, 1, 0),
(38, 9, 1, '\n \n \n \n <section id=\"dzifgznebu\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-center align-top\">\n<div class=\"medium-12 cell \">\n<div class=\"column-wrapper\" style=\"\"><h2><strong>Vragen?</strong> Stel ze gerust<br>\naan onze instroomcoördinator</h2>\n</div>\n</div>\n</div></section>\n \n ', '1-column', 'text', '', '', 0, 0, 'text-center align-top', '', 0, 37, 2, 1, 0),
(39, 9, 1, '\n \n \n \n <section id=\"mdmvmqvuni\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-middle\">\n\n<div class=\" medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><p class=\"portret\" style=\"text-align: right;\"><img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/PORTRET_HENK.jpg\"></p>\n</div>\n</div>\n\n<div class=\" medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><strong>Henk Wiegant</strong><br>\nAlphen aan den Rijn<br>\n<a href=\"mailto:h.wiegant@ashramcollege.nl\">h.wiegant@ashramcollege.nl</a></p>\n</div>\n</div>\n</div></section>\n \n ', '2-column', 'text', '', '', 0, 0, 'text-left align-middle', '', 0, 37, 2, 1, 0),
(40, 2, 1, '<section id=\"kmibxmttkk\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-12 cell\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n</div></section>', '1-column', 'text', '', '', 0, 0, '', '', 0, 0, 0, 0, 0),
(42, 26, 1, '\n \n \n \n <section id=\"tvqveaznsn\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-top\">\n\n<div class=\" medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><h3>Ashram College</h3>\n\n<p>Voornaam Achternaam<br>\n<a href=\"mailto:naam@mailadres.nl\">naam@mailadres.nl</a></p>\n</div>\n</div>\n\n<div class=\" medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><h3>Groene Hart Scholen</h3>\n\n<p>Voornaam Achternaam<br>\n<a href=\"mailto:naam@mailadres.nl\">naam@mailadres.nl</a></p>\n</div>\n</div>\n</div></section>\n \n ', '2-column', 'text', '', '', 0, 0, 'text-left align-top', '', 0, 0, 1, 1, 0),
(44, 27, 1, '\n \n \n \n \n \n <section id=\"kvmvpyhnar\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-12 cell\">\n<div class=\"column-wrapper\" style=\"\"><div class=\"content-block content-block--default \" id=\"\">\n<h1>Keuzehulp VO Alphen aan den Rijn</h1>\n\n<p>Hoe weet je welke school het beste bij jou past? Om je op weg te helpen hebben we speciaal voor jou de keuzehulp ontwikkeld. Geef aan welke schoolniveaus je wilt vergelijken, in welk stadsdeel je zoekt en in welke extra\'s je geïnteresseerd bent, zoals een sportklas of technasium. Vervolgens krijg je een duidelijk overzicht met scholen die aan jouw zoekcriteria voldoen. Ontdek met een paar muisklikken uit welke scholen jij kunt kiezen.</p>\n</div>\n</div>\n</div>\n</div></section>\n \n \n ', '1-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 1, 0),
(47, 24, 1, '\n \n <section id=\"ynomblcbwc\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-center align-top\">\n<div class=\"medium-12 cell \">\n<div class=\"column-wrapper\" style=\"\"><h2><strong>Vragen?</strong> Stel ze gerust<br>\naan onze instroomcoördinator</h2>\n</div>\n</div>\n</div></section>\n ', '1-column', 'text', '', '', 0, 0, 'text-center align-top', '', 0, 46, 2, 1, 0),
(46, 24, 1, '<section id=\"mtlwckzalh\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'school-contact', 0, 0, 'text-left align-top', '', 0, 0, 2, 1, 0),
(48, 24, 1, '\n \n <section id=\"ftcbisnnzm\" class=\"grid-container\"><div class=\"grid-x grid-padding-x text-left align-middle\">\n\n<div class=\" medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><p class=\"portret\" style=\"text-align: right;\"><img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/instromen-2-249x300.jpeg\"></p>\n</div>\n</div>\n\n<div class=\" medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><strong>Esther Lankhaar</strong><br>\nTeamleider vmbo basis-kader<br>\n<a href=\"mailto:e.lankhaar@ashramcollege.nl\">e.lankhaar@ashramcollege.nl</a></p>\n</div>\n</div>\n</div></section>\n ', '2-column', 'text', '', '', 0, 0, 'text-left align-middle', '', 0, 46, 2, 1, 0);
INSERT INTO `page_section_content` (`page_section_id`, `page_id`, `language_id`, `html`, `edittag`, `datatype`, `element_id`, `element_class`, `fullpage`, `custom`, `custom_content`, `css`, `link_data`, `sub_of`, `position`, `status`, `locked`) VALUES
(49, 12, 1, '\n \n \n \n <section id=\"eayumgldtw\" class=\"grid-container\"><div class=\"grid-x grid-padding-x\">\n\n<div class=\"small-12 medium-4 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><br>\n<img alt=\"\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/logo/Groene-Hart-logo.png\" style=\"width: 75%;\"></p>\n\n<p><strong>www.groenehartscholen.nl</strong></p>\n\n<ul class=\"no-bullet labels\">\n <li>MAVO</li>\n <li>HAVO</li>\n <li>VWO (atheneum)</li>\n <li>VWO (gymnasium)</li>\n <li>Nieuwkoop</li>\n <li>Alphen aan den rijn</li>\n</ul>\n</div>\n</div>\n\n<div class=\"small-12 medium-8 cell\">\n<div class=\"column-wrapper\" style=\"\"><section id=\"over\">\n<div>\n<div>\n<div>\n<div>\n<div>\n<div>\n<div>\n<h1>Groene Hart Scholen</h1>\n\n<p>Op het Groene Hart vinden we het belangrijk dat leerlingen de ruimte krijgen om zich te ontwikkelen. Samen ontdekken we waar onze leerlingen goed in zijn en wat bij hen past. Ook willen we ze uitdagen om te verbeteren wat minder goed gaat. We helpen elkaar hierbij en zorgen voor elkaar. We zijn een christelijke school met een open houding, waar iedereen welkom is. Onze school is een veilige plek waar leerlingen zichzelf mogen zijn en leren om elkaar te respecteren. Zo bereiden we onze leerlingen voor op het vervolgonderwijs en de maatschappij om hun eigen weg naar de toekomst te vinden.</p>\n\n<p>Wij bieden onderwijs van vmbo tot en met gymnasium aan zo’n 3.100 leerlingen verdeeld over vier vestigingen: het Leerpark, de Topmavo en het Lyceum in Alphen aan den Rijn en Rijnwoude in Hazerswoude. De Groene Hart Praktijkschool in Alphen aan den Rijn biedt praktijkonderwijs aan. Zo kunnen leerlingen op hun eigen niveau werken. We dagen ze uit om zich te ontwikkelen.</p>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n</section>\n</div>\n</div>\n</div></section>\n \n ', '2-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 1, 0),
(52, 12, 1, '\n \n \n \n \n \n \n <section id=\"mpqicpdazz\" class=\"grid-container full\">\n<div class=\"grid-x grid-padding-x text-left align-top\">\n<div class=\"cell small-12 no-transition\">\n \n \n <div class=\"grid-container foreground\">\n \n <div class=\"grid-x grid-margin-x grid-padding-x align-center text-center\">\n <div class=\"small-12 large-12 cell\">\n <div class=\"column-wrapper\" edit=\"text\" style=\"\"><h1>Locaties</h1>\n</div>\n </div>\n </div>\n \n <div class=\"grid-x grid-margin-x grid-padding-x align-center text-center small-up-2 large-up-5\">\n\n <div class=\"small-10 medium-6 large-3 cell school__locatie\">\n <div class=\"column-wrapper\" edit=\"text\" style=\"\"><h4>Leerpark</h4>\n\n<p><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/groene-hart/Leerpark.svg\"></p>\n\n<p><a href=\"scholen-locaties/groene-hart-leerpark\">Meer informatie</a></p>\n</div>\n </div>\n \n <div class=\"small-10 medium-6 large-3 cell school__locatie\">\n <div class=\"column-wrapper\" edit=\"text\" style=\"\"><h4>Topmavo</h4>\n\n<p><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/groene-hart/topmavo-kleur.svg\"></p>\n\n<p><a href=\"scholen-locaties/groene-hart-topmavo\">Meer informatie</a></p>\n</div>\n </div>\n \n <div class=\"small-10 medium-6 large-3 cell school__locatie\">\n <div class=\"column-wrapper\" edit=\"text\" style=\"\"><h4>Lyceum</h4>\n\n<p><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/groene-hart/lyceum-kleur.svg\"></p>\n\n<p><a href=\"scholen-locaties/groene-hart-lyceum\">Meer informatie</a></p>\n</div>\n </div>\n \n <div class=\"small-10 medium-6 large-3 cell school__locatie\">\n <div class=\"column-wrapper\" edit=\"text\" style=\"\"><h4>Rijnwoude</h4>\n\n<p><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/groene-hart/rijnwoude-kleur.svg\"></p>\n\n<p><a href=\"scholen-locaties/groene-hart-rijnwoude\">Meer informatie</a></p>\n</div>\n </div>\n \n <div class=\"small-10 medium-6 large-3 cell school__locatie\">\n <div class=\"column-wrapper\" edit=\"text\" style=\"\"><h4>Praktijkschool</h4>\n\n<p><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/groene-hart/praktijkschool.svg\"></p>\n\n<p><a href=\"scholen-locaties/groene-hart-praktijkschool\">Meer informatie</a></p>\n</div>\n </div>\n \n \n \n \n </div>\n \n \n </div>\n \n <div class=\"column-wrapper background\" edittype=\"image\"><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/groene-hart/Topmavo_fotoAnneliesVerhelst_29.jpg\" alt=\"\"></div>\n \n\n</div>\n</div>\n</section>\n \n \n \n ', 'locaties', 'text', '', 'school-locaties', 1, 0, 'text-left align-top', '', 0, 0, 2, 1, 0);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `prijzen_product`
--
CREATE TABLE `prijzen_product` (
`prijs_product_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`naam` varchar(250) NOT NULL,
`aantal` int(10) NOT NULL,
`van` float NOT NULL,
`voor` float NOT NULL,
`gewicht` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `pw_reset`
--
CREATE TABLE `pw_reset` (
`reset_id` int(10) NOT NULL,
`user_id` int(10) NOT NULL,
`code` varchar(50) NOT NULL,
`valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `secties`
--
CREATE TABLE `secties` (
`sectie_id` int(10) NOT NULL,
`naam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`meta_titel` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`meta_description` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`stramien` int(1) NOT NULL DEFAULT '1',
`section_view` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`category_view` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`kolommen` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`cssid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`zichtbaar` int(1) NOT NULL DEFAULT '1',
`position` int(1) NOT NULL,
`custom` int(1) NOT NULL,
`custom_code` text COLLATE utf8_unicode_ci NOT NULL,
`sort` int(10) NOT NULL,
`sitelinks` int(1) NOT NULL DEFAULT '1',
`categories` int(1) NOT NULL,
`redirect` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `secties`
--
INSERT INTO `secties` (`sectie_id`, `naam`, `url`, `meta_titel`, `meta_description`, `stramien`, `section_view`, `category_view`, `kolommen`, `cssid`, `zichtbaar`, `position`, `custom`, `custom_code`, `sort`, `sitelinks`, `categories`, `redirect`, `active`) VALUES
(1, 'Home', '', '', '', 1, 'view.default.php', '', '', '', 0, 0, 0, '', 0, 1, 0, '', 1),
(2, 'Agenda', 'agenda/', '', '', 1, '', '', '', '', 1, 2, 0, '', 0, 1, 0, '', 1),
(3, 'Scholen & locaties', 'scholen-locaties/', '', '', 2, 'view.locaties2.php', 'view.locaties2.php', '', '', 1, 1, 0, '', 0, 1, 0, '', 1),
(5, 'Contact', 'contact/', '', '', 4, '', '', '', '', 1, 4, 0, '', 0, 1, 0, '', 1),
(4, 'Keuzehulp', 'keuzehulp/', '', '', 5, '', '', '', '', 1, 3, 0, '', 0, 1, 0, '', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `sectie_categories`
--
CREATE TABLE `sectie_categories` (
`sectie_category_id` int(10) NOT NULL,
`sectie_id` int(10) NOT NULL,
`category_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `sectie_templates`
--
CREATE TABLE `sectie_templates` (
`sectie_templates_id` int(10) NOT NULL,
`sectie_id` int(10) NOT NULL,
`template_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `sectie_templates`
--
INSERT INTO `sectie_templates` (`sectie_templates_id`, `sectie_id`, `template_id`) VALUES
(1, 1, 1),
(2, 2, 5),
(4, 3, 6),
(6, 3, 1),
(7, 5, 7),
(8, 4, 7);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `stramiens`
--
CREATE TABLE `stramiens` (
`stramien_id` int(10) NOT NULL,
`naam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`position` int(10) NOT NULL,
`columns` int(10) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `stramiens`
--
INSERT INTO `stramiens` (`stramien_id`, `naam`, `position`, `columns`, `active`) VALUES
(1, 'default', 0, 0, 1),
(2, 'school', 0, 0, 1),
(3, 'locatie', 0, 0, 1),
(4, 'simple', 0, 0, 1),
(5, 'keuzehulp', 0, 0, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `synoniemen`
--
CREATE TABLE `synoniemen` (
`synoniem_id` int(11) NOT NULL,
`synoniem` varchar(255) NOT NULL,
`value` varchar(255) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `synoniemen_default`
--
CREATE TABLE `synoniemen_default` (
`default_syn_id` int(10) NOT NULL,
`field_id` int(10) NOT NULL,
`value` varchar(255) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `tags`
--
CREATE TABLE `tags` (
`tag_id` int(10) NOT NULL,
`name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`times_tagged` int(10) NOT NULL DEFAULT '0',
`position` int(10) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Gegevens worden geëxporteerd voor tabel `tags`
--
INSERT INTO `tags` (`tag_id`, `name`, `times_tagged`, `position`, `active`) VALUES
(1, 'ashram', 0, 0, 1),
(2, 'alphen', 0, 0, 1),
(3, 'ashran', 0, 0, 1),
(4, 'nieuwkoop', 0, 0, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_agenda`
--
CREATE TABLE `td_agenda` (
`entry_id` int(10) NOT NULL,
`position` int(10) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`last_edit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`template_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`form_id` int(10) NOT NULL,
`stramien_id` int(10) NOT NULL,
`meta_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`meta_desc` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`page_redirect` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`evenement` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`datum` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`tijd` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`omschrijving` text COLLATE utf8_unicode_ci,
`intro` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`school` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`aanmelden_via` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`logo` tinytext COLLATE utf8_unicode_ci,
`tags` text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `td_agenda`
--
INSERT INTO `td_agenda` (`entry_id`, `position`, `status`, `last_edit`, `template_id`, `unique_id`, `form_id`, `stramien_id`, `meta_title`, `meta_desc`, `page_redirect`, `evenement`, `datum`, `tijd`, `omschrijving`, `intro`, `school`, `aanmelden_via`, `logo`, `tags`) VALUES
(1, 0, 1, '2020-07-09 08:05:13', 5, 3, 0, 0, '', '', '', 'Oriëntatiemiddag 1', '2020-11-18', '13.15 - 16.30 uur', '<p>Ervaar hoe het is om een coach te hebben en maak kennis met de domeinen Art, Society, Science en Sport. Zo krijg je een goed beeld van de sfeer en het onderwijs op het Ashram College.</p>\r\n\r\n<h3>Locatie</h3>\r\n\r\n<p>Ashram College Alphen<br />\r\nMarsdiep 289<br />\r\n2401 XH Alphen aan den Rijn</p>\r\n\r\n<h3>Contact</h3>\r\n\r\n<p>Henk Wiegant<br />\r\nh.wiegant@ashramcollege.nl</p>\r\n', 'Voor de leerlingen van de basisscholen uit Alphen aan den Rijn', '2|-|', 'https://www.ashramcollege.nl', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/logo/ashram-college-logo.png', 'ashram,alphen,'),
(2, 0, 1, '2020-07-09 08:08:37', 5, 4, 0, 0, '', '', '', 'Oriëntatiemiddag 2', '2020-12-09', '13.15 - 16.30 uur', '<p>Ervaar hoe het is om een coach te hebben en maak kennis met de domeinen Art, Society, Science en Sport. Zo krijg je een goed beeld van de sfeer en het onderwijs op het Ashram College.</p>\r\n\r\n<h3>Locatie</h3>\r\n\r\n<p>Ashram College Alphen</i><br />\r\nMarsdiep 289<br />\r\n2401 XH Alphen aan den Rijn</p>\r\n\r\n<h4>Contact</h4>\r\n\r\n<p>Henk Wiegant<br />\r\n</i><a href=\"mailto:h.wiegant@ashramcollege.nl\">h.wiegant@ashramcollege.nl</i></a></i></p>\r\n', 'Voor de leerlingen van de basisscholen buiten Alphen aan den Rijn', '2|-|', 'https://www.ashramcollege.nl', '', 'ashram,alphen,'),
(3, 0, 1, '2020-07-09 08:34:31', 5, 5, 0, 0, '', '', '', 'Kennismakingsmiddag 1 gymnasium', '2020-11-19', '16.00 - 17.00 uur', '<p>Voor toekomstige vwo-leerlingen uit groep 7 en 8 organiseren we een kennismakingsmiddag gymnasium. Wees van harte welkom om deel te nemen aan een proeflesje en maak kennis met Latijn en Grieks op z’n Ashrams. </p>\r\n\r\n<h3>Locatie</h3>\r\n\r\n<p>Ashram College Alphen</i><br />\r\nMarsdiep 289<br />\r\n2401 XH Alphen aan den Rijn</i></p>\r\n\r\n<h3>Contact</h3>\r\n\r\n<p>Henk Wiegant<br />\r\n</i><a href=\"mailto:h.wiegant@ashramcollege.nl\">h.wiegant@ashramcollege.nl</i></a></i></p>\r\n', 'Voor toekomstige vwo-leerlingen uit groep 7 en 8 ', '2|-|', 'https://www.ashramcollege.nl', '', 'ashram,alphen,'),
(4, 0, 1, '2020-07-09 08:36:15', 5, 6, 0, 0, '', '', '', 'Kennismakingsmiddag 2 gymnasium', '2020-12-10', '16.00 - 17.00 uur', '<p>Voor toekomstige vwo-leerlingen uit groep 7 en 8 organiseren we een kennismakingsmiddag gymnasium. Wees van harte welkom om deel te nemen aan een proeflesje en maak kennis met Latijn en Grieks op z’n Ashrams. </p>\r\n\r\n<h3>Locatie</h3>\r\n\r\n<p>Ashram College Alphen<br />\r\nMarsdiep 289<br />\r\n2401 XH Alphen aan den Rijn</p>\r\n\r\n<h3>Contact</h3>\r\n\r\n<p>Henk Wiegant<br />\r\n<a href=\"mailto:h.wiegant@ashramcollege.nl\">h.wiegant@ashramcollege.nl</a></p>\r\n', 'Voor toekomstige vwo-leerlingen uit groep 7 en 8', '2|-|', 'https://www.ashramcollege.nl', '', 'ashram,alphen,'),
(5, 0, 1, '2020-07-16 09:03:26', 5, 10, 0, 0, '', '', '', 'Ouderinformatieavond', '2020-11-19', '19.00 – 20.30 uur', '<p class=\"Body\"><span style=\"mso-ansi-language:NL;mso-bidi-font-weight:bold\">Tijdens het Open Huis krijg je een goed beeld van de sfeer en het onderwijs op het Ashram College.</span></p>\r\n\r\n<h3>Locatie</h3>\r\n\r\n<p>Ashram College Alphen<br />\r\nMarsdiep 289<br />\r\n2401 XH Alphen aan den Rijn</p>\r\n\r\n<h3>Contact</h3>\r\n\r\n<p>Henk Wiegant<br />\r\nh.wiegant@ashramcollege.nl</p>\r\n', 'Ouderavond over onze onderwijsaanpak en de meerwaarde voor leerlingen', '2|-|', 'https://www.ashramcollege.nl', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-college-alphen.png', 'ashram,alphen,'),
(7, 0, 1, '2020-09-17 12:35:41', 5, 28, 0, 0, '', '', '', 'Kennismakingsmiddag 2', '2020-11-18', '14.00-16.00 uur', '<p>Tijdens de kennismakingsmiddagen kun je alvast de sfeer komen proeven op onze school. Samen met vriendjes en vriendinnetjes een dramales volgen? Of altijd al eens les willen hebben van een echte sportdocent? Dat kan op het Ashram in Nieuwkoop tijdens de kennismakingsmiddagen. Ontdekken of je talenten hebt in de keuken of dat je hele gave kapsels kunt maken bij je leeftijdsgenoten? Of toch het technieklokaal in? Zorg dat je erbij bent! We zien je graag terug bij een van deze lessen.</p>\r\n\r\n<h3>Aanmelden</h3>\r\n\r\n<p>Aanmelden kan vanaf 14 oktober via nieuwkoop@ashramcollege.nl</p>\r\n\r\n<h3>Locatie</h3>\r\n\r\n<p>Ashram College Nieuwkoop<br />\r\nAchterweg 1<br />\r\n2421EB Nieuwkoop</p>\r\n\r\n<h3>Contact</h3>\r\n\r\n<p>E.Lankhaar@ashramcollege.nl<br />\r\nF.Lyklema@ashramcollege.nl</p>\r\n', 'Proef tijdens de kennismakingsmiddagen alvast de sfeer op onze school', '24|-|', 'mailto:nieuwkoop@ashramcollege.nl', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-nieuwkoop.png', 'nieuwkoop,ashram'),
(6, 0, 1, '2020-07-16 09:06:17', 5, 11, 0, 0, '', '', '', 'Open Huis', '2021-01-15', '19.00 - 21.30 uur', '', 'Tijdens het Open Huis krijg je een goed beeld van de sfeer en het onderwijs op het Ashram College. ', '9|-|', 'https://www.ashramcollege.nl', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-college-alphen.png', 'alphen,ashram'),
(8, 0, 1, '2020-09-17 12:35:41', 5, 29, 0, 0, '', '', '', 'Kennismakingsmiddag 1', '2020-11-04', '14.00-16.00 uur', '<p>Tijdens de kennismakingsmiddagen kun je alvast de sfeer komen proeven op onze school. Samen met vriendjes en vriendinnetjes een dramales volgen? Of altijd al eens les willen hebben van een echte sportdocent? Dat kan op het Ashram in Nieuwkoop tijdens de kennismakingsmiddagen. Ontdekken of je talenten hebt in de keuken of dat je hele gave kapsels kunt maken bij je leeftijdsgenoten? Of toch het technieklokaal in? Zorg dat je erbij bent! We zien je graag terug bij een van deze lessen.</p>\r\n\r\n<h3>Aanmelden</h3>\r\n\r\n<p>Aanmelden kan vanaf 14 oktober via nieuwkoop@ashramcollege.nl</p>\r\n\r\n<h3>Locatie</h3>\r\n\r\n<p>Ashram College Nieuwkoop<br />\r\nAchterweg 1<br />\r\n2421EB Nieuwkoop</p>\r\n\r\n<h3>Contact</h3>\r\n\r\n<p>E.Lankhaar@ashramcollege.nl<br />\r\nF.Lyklema@ashramcollege.nl</p>\r\n', 'Proef tijdens de kennismakingsmiddagen alvast de sfeer op onze school.', '24|-|', 'mailto:nieuwkoop@ashramcollege.nl', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-nieuwkoop.png', 'ashram,nieuwkoop');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_faq`
--
CREATE TABLE `td_faq` (
`entry_id` int(10) NOT NULL,
`position` int(10) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`last_edit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`template_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`form_id` int(10) NOT NULL,
`stramien_id` int(10) NOT NULL,
`meta_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`meta_desc` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`page_redirect` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_feature`
--
CREATE TABLE `td_feature` (
`entry_id` int(10) NOT NULL,
`position` int(10) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`last_edit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`template_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`form_id` int(10) NOT NULL,
`stramien_id` int(10) NOT NULL,
`meta_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`meta_desc` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`page_redirect` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_page`
--
CREATE TABLE `td_page` (
`entry_id` int(10) NOT NULL,
`position` int(10) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`last_edit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`template_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`form_id` int(10) NOT NULL,
`stramien_id` int(10) NOT NULL,
`meta_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`meta_desc` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`page_redirect` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`contents` text COLLATE utf8_unicode_ci,
`afbeelding` tinytext COLLATE utf8_unicode_ci,
`image_foreground` tinytext COLLATE utf8_unicode_ci,
`showcase_text` text COLLATE utf8_unicode_ci,
`link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`lead` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`heading` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`loopback` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`buttons` int(10) DEFAULT NULL,
`tagline` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`alternative_button` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `td_page`
--
INSERT INTO `td_page` (`entry_id`, `position`, `status`, `last_edit`, `template_id`, `unique_id`, `form_id`, `stramien_id`, `meta_title`, `meta_desc`, `page_redirect`, `title`, `contents`, `afbeelding`, `image_foreground`, `showcase_text`, `link`, `lead`, `heading`, `loopback`, `buttons`, `tagline`, `alternative_button`) VALUES
(1, 0, 1, '2020-07-08 13:49:07', 1, 1, 0, 0, 'Kies je School Alphen | Keuzegids Voortgezet Onderwijs 2020 - 2021', '', '', 'Kies je school alphen', '', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/kiesjeschool-alphen-voorgezet-onderwijs.jpg', NULL, NULL, '', 'Regio Alphen aan den Rijn', '', '', 0, '', ''),
(2, 0, 1, '2020-07-09 12:05:29', 1, 7, 0, 0, '', '', '', 'Disclaimer', '', '', NULL, NULL, '', '', '', '', 0, '', ''),
(3, 0, 1, '2020-07-09 12:05:35', 1, 8, 0, 0, '', '', '', 'Cookies', '', '', NULL, NULL, '', '', '', '', 0, '', ''),
(4, 0, 1, '2020-07-23 11:38:56', 1, 25, 0, 0, '', '', '', 'Contact', '', '', NULL, NULL, '', '', '', '', 0, '', '');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_resource`
--
CREATE TABLE `td_resource` (
`entry_id` int(10) NOT NULL,
`position` int(10) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`last_edit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`template_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`form_id` int(10) NOT NULL,
`stramien_id` int(10) NOT NULL,
`meta_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`meta_desc` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`page_redirect` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`filename` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`description` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_upload` text COLLATE utf8_unicode_ci,
`image` tinytext COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_scholen`
--
CREATE TABLE `td_scholen` (
`entry_id` int(10) NOT NULL,
`position` int(10) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`last_edit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`template_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`form_id` int(10) NOT NULL,
`stramien_id` int(10) NOT NULL,
`meta_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`meta_desc` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`page_redirect` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`naam` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`plaats` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`contents` text COLLATE utf8_unicode_ci,
`afbeelding` tinytext COLLATE utf8_unicode_ci,
`slogan` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`tags` text COLLATE utf8_unicode_ci,
`impressie` text COLLATE utf8_unicode_ci,
`lengtegraad` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`breedtegraad` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`favicon` tinytext COLLATE utf8_unicode_ci,
`kleur` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`intro` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `td_scholen`
--
INSERT INTO `td_scholen` (`entry_id`, `position`, `status`, `last_edit`, `template_id`, `unique_id`, `form_id`, `stramien_id`, `meta_title`, `meta_desc`, `page_redirect`, `naam`, `plaats`, `contents`, `afbeelding`, `slogan`, `tags`, `impressie`, `lengtegraad`, `breedtegraad`, `favicon`, `kleur`, `intro`) VALUES
(1, 0, 1, '2020-07-09 08:03:47', 6, 2, 0, 0, 'Ashram College | Kies je school Alphen', '', '', 'Ashram College', 'Alphen aan den Rijn', '', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashram-college.jpg', 'Jouw toekomst is nu!', '', '', '', '', '', 'FFFFFF', ''),
(2, 0, 1, '2020-07-16 08:28:50', 6, 9, 0, 3, 'Ashram College Alphen aan den Rijn | Kies je School', '', '', 'Ashram College Alphen aan den Rijn', 'Alphen aan den Rijn', '', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/22_web.jpg', 'Jouw toekomst is nu!', 'ashram,alphen', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-site-1.jpg|*|https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-site-2.jpg|*|https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-site-3.jpg', '4.653390', '52.146900', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/ashram-favicon.png', 'A8B3D6', 'Op het Ashram College volg je een opleiding mavo, havo, vwo'),
(3, 0, 1, '2020-07-22 14:37:07', 6, 12, 0, 2, '', '', '', 'Groene Hart Scholen', '', '', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/groene-hart/Topmavo_fotoAnneliesVerhelst_25.jpg', 'Hart voor jouw talent', '', '', '', '', '', 'FFFFFF', ''),
(4, 0, 1, '2020-07-22 14:37:15', 6, 13, 0, 0, '', '', '', 'Scala College', '', '', '', '', '', '', '', '', '', 'FFFFFF', ''),
(5, 0, 1, '2020-07-22 14:37:20', 6, 14, 0, 0, '', '', '', 'Wellant College', '', '', '', '', '', '', '', '', '', 'FFFFFF', ''),
(6, 0, 1, '2020-07-23 08:48:37', 6, 15, 0, 3, '', '', '', 'Groene Hart Leerpark', '', '', '', '', '', '', '4.651490', '52.130940', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/groene-hart-favicon.png', '512178', ''),
(7, 0, 1, '2020-07-23 08:48:51', 6, 16, 0, 3, '', '', '', 'Groene Hart Lyceum', '', '', '', '', '', '', '4.658385', '52.1351953', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/groene-hart-favicon.png', '512178', ''),
(8, 0, 1, '2020-07-23 08:49:04', 6, 17, 0, 3, '', '', '', 'Groene Hart Praktijkschool', '', '', '', '', '', '', '4.6534', '52.13251', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/groene-hart-favicon.png', '512178', ''),
(9, 0, 1, '2020-07-23 08:49:15', 6, 18, 0, 3, '', '', '', 'Groene Hart Rijnwoude', '', '', '', '', '', '', '4.59418', '52.09968', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/groene-hart-favicon.png', '512178', ''),
(10, 0, 1, '2020-07-23 08:49:30', 6, 19, 0, 3, '', '', '', 'Groene Hart Topmavo', '', '', '', '', '', '', '4.65939', '52.13578', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/groene-hart-favicon.png', '512178', ''),
(11, 0, 1, '2020-07-23 08:50:08', 6, 20, 0, 0, '', '', '', 'Scala College Sacharovlaan', '', '', '', '', '', '', '4.655130', '52.128120', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/scala-favicon.png', 'D30351', ''),
(12, 0, 1, '2020-07-23 08:50:15', 6, 21, 0, 0, '', '', '', 'Scala College Diamantstraat', '', '', '', '', '', '', '4.678390', '52.142420', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/scala-favicon.png', 'D30351', ''),
(13, 0, 1, '2020-07-23 08:50:33', 6, 22, 0, 0, '', '', '', 'Scala College Nieuwe Sloot', '', '', '', '', '', '', '4.670840', '52.137810', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/scala-favicon.png', 'D30351', ''),
(14, 0, 1, '2020-07-23 08:51:55', 6, 23, 0, 0, '', '', '', 'Wellant VMBO Alphen aan den Rijn', '', '', '', '', '', '', '4.64929', '52.15131', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/wellant-favicon.png', '0092D2', ''),
(15, 0, 1, '2020-07-23 08:52:21', 6, 24, 0, 3, '', '', '', 'Ashram College Nieuwkoop', '', '', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/22_web.jpg', 'Thuis<br /> in de Wereld', 'nieuwkoop,ashram', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-site-2.jpg|*|https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/ashran/ashram-site-3.jpg', '4.773300', '52.149090', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/kiesjeschoolalphen/images/favicon/ashram-favicon.png', 'A8B3D6', 'Op het Ashram College volg je een opleiding mavo, havo, vwo'),
(16, 0, 1, '2020-09-17 12:55:26', 6, 30, 0, 0, '', '', '', 'Groene Hart Scholen', '', '', '', '', NULL, '', '', '', '', 'FFFFFF', '');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_simple`
--
CREATE TABLE `td_simple` (
`entry_id` int(10) NOT NULL,
`position` int(10) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`last_edit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`template_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`form_id` int(10) NOT NULL,
`stramien_id` int(10) NOT NULL,
`meta_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`meta_desc` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`page_redirect` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`naam` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`contents` text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `td_simple`
--
INSERT INTO `td_simple` (`entry_id`, `position`, `status`, `last_edit`, `template_id`, `unique_id`, `form_id`, `stramien_id`, `meta_title`, `meta_desc`, `page_redirect`, `naam`, `contents`) VALUES
(1, 0, 1, '2020-07-23 11:41:15', 7, 26, 0, 0, '', '', '', 'Contact', ''),
(2, 0, 1, '2020-07-23 12:14:12', 7, 27, 0, 0, '', '', '', 'Keuzehulp Voorgezet Onderwijs Alphen aan den Rijn e.o', '');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `templates`
--
CREATE TABLE `templates` (
`template_id` int(10) NOT NULL,
`naam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`position` int(10) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `templates`
--
INSERT INTO `templates` (`template_id`, `naam`, `position`, `active`) VALUES
(1, 'page', 0, 1),
(2, 'feature', 0, 1),
(3, 'resource', 0, 1),
(4, 'faq', 0, 1),
(5, 'agenda', 0, 1),
(6, 'scholen', 0, 1),
(7, 'simple', 0, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `template_fields`
--
CREATE TABLE `template_fields` (
`template_field_id` int(10) NOT NULL,
`template_id` int(10) NOT NULL,
`field_id` int(10) NOT NULL,
`field_naam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`field_user` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sub_of` int(10) NOT NULL DEFAULT '0',
`type` int(1) NOT NULL DEFAULT '0',
`overzicht` int(1) NOT NULL DEFAULT '0',
`link_to` int(10) NOT NULL DEFAULT '0',
`position` int(10) NOT NULL,
`translate` int(1) NOT NULL DEFAULT '0',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `template_fields`
--
INSERT INTO `template_fields` (`template_field_id`, `template_id`, `field_id`, `field_naam`, `field_user`, `value`, `sub_of`, `type`, `overzicht`, `link_to`, `position`, `translate`, `active`) VALUES
(1, 1, 1, 'title', 'title', '', 0, 1, 0, 0, 0, 0, 1),
(2, 1, 46, 'contents', 'contents', '', 0, 1, 0, 0, 9, 0, 1),
(3, 1, 6, 'afbeelding', 'afbeelding', '', 0, 1, 0, 0, 6, 0, 1),
(4, 1, 6, 'image_foreground', 'image_foreground', '', 0, 1, 0, 0, 7, 0, 0),
(5, 1, 5, 'showcase_text', 'showcase_text', '', 0, 1, 0, 0, 5, 0, 0),
(6, 1, 12, 'link', 'link', '', 0, 1, 0, 0, 8, 0, 1),
(7, 0, 0, '5c862d7c8a808', '', '', 0, 1, 0, 0, 0, 0, 1),
(8, 0, 0, '5c862d80c82ee', '', '', 0, 1, 0, 0, 0, 0, 1),
(9, 0, 0, '5c862d86bf5db', '', '', 0, 1, 0, 0, 0, 0, 1),
(10, 0, 0, '5c862d89a981b', '', '', 0, 1, 0, 0, 0, 0, 1),
(11, 1, 1, 'lead', 'lead', '', 0, 1, 0, 0, 4, 0, 1),
(12, 0, 0, '5c878a1f3642d', '', '', 0, 1, 0, 0, 0, 0, 1),
(13, 2, 1, 'name', 'name', '', 0, 1, 0, 0, 0, 0, 1),
(14, 2, 5, 'text', 'text', '', 0, 1, 0, 0, 0, 0, 1),
(15, 1, 1, 'heading', 'heading', '', 0, 1, 0, 0, 3, 0, 1),
(16, 0, 0, '5de7b1775c610', '', '', 0, 1, 0, 0, 0, 0, 1),
(17, 1, 1, 'loopback', 'loopback', '', 0, 1, 0, 0, 10, 0, 1),
(18, 0, 0, '5e984f0079626', '', '', 0, 1, 0, 0, 0, 0, 1),
(19, 1, 24, 'buttons', 'buttons', '', 0, 1, 0, 0, 1, 0, 1),
(20, 1, 1, 'tagline', 'tagline', '', 0, 1, 0, 0, 11, 0, 1),
(21, 0, 0, '5e9de7f64f4bf', '', '', 0, 1, 0, 0, 0, 0, 1),
(22, 1, 1, 'alternative_button', 'alternative_button', '', 0, 1, 0, 0, 2, 0, 1),
(23, 0, 0, '5ee9fc57460d7', '', '', 0, 1, 0, 0, 0, 0, 1),
(24, 3, 1, 'filename', 'filename', '', 0, 1, 0, 0, 0, 0, 1),
(25, 3, 1, 'description', 'description', '', 0, 1, 0, 0, 0, 0, 1),
(26, 3, 29, 'file_upload', 'file_upload', '', 0, 1, 0, 0, 0, 0, 1),
(27, 3, 6, 'image', 'image', '', 0, 1, 0, 0, 0, 0, 1),
(28, 4, 1, 'title', 'title', '', 0, 1, 0, 0, 0, 0, 1),
(29, 4, 5, 'text', 'text', '', 0, 1, 0, 0, 0, 0, 1),
(30, 0, 0, '5ef489818a2c9', '', '', 0, 1, 0, 0, 0, 0, 1),
(31, 5, 1, 'evenement', 'evenement', '', 0, 1, 0, 0, 0, 0, 1),
(32, 5, 14, 'datum', 'datum', '', 0, 1, 0, 0, 2, 0, 1),
(33, 5, 1, 'tijd', 'tijd', '', 0, 1, 0, 0, 3, 0, 1),
(34, 5, 5, 'omschrijving', 'omschrijving', '', 0, 1, 0, 0, 4, 0, 1),
(35, 5, 1, 'intro', 'intro', '', 0, 1, 0, 0, 1, 0, 1),
(36, 0, 0, '5f06ced9efa79', '', '', 0, 1, 0, 0, 0, 0, 1),
(37, 5, 12, 'school', 'school', '', 0, 1, 0, 0, 0, 0, 1),
(38, 6, 1, 'naam', 'naam', '', 0, 1, 0, 0, 0, 0, 1),
(39, 6, 1, 'plaats', 'plaats', '', 0, 1, 0, 0, 4, 0, 1),
(40, 6, 46, 'contents', 'contents', '', 0, 1, 0, 0, 5, 0, 1),
(41, 5, 1, 'aanmelden_via', 'aanmelden_via', '', 0, 1, 0, 0, 0, 0, 1),
(42, 5, 6, 'logo', 'logo', '', 0, 1, 0, 0, 0, 0, 1),
(43, 6, 6, 'afbeelding', 'afbeelding', '', 0, 1, 0, 0, 3, 0, 1),
(44, 6, 1, 'slogan', 'slogan', '', 0, 1, 0, 0, 1, 0, 1),
(45, 5, 11, 'tags', 'tags', '', 0, 1, 0, 0, 0, 0, 1),
(46, 0, 0, '5f0c1a5641e5d', '', '', 0, 1, 0, 0, 0, 0, 1),
(47, 6, 11, 'tags', 'tags', '', 0, 1, 0, 0, 2, 0, 1),
(48, 6, 6, 'impressie', 'impressie', '', 0, 1, 0, 0, 6, 0, 1),
(49, 6, 1, 'lengtegraad', 'lengtegraad', '', 0, 1, 0, 0, 8, 0, 1),
(50, 6, 1, 'breedtegraad', 'breedtegraad', '', 0, 1, 0, 0, 7, 0, 1),
(51, 0, 0, '5f1950475cc22', '', '', 0, 1, 0, 0, 0, 0, 1),
(52, 0, 0, '5f19504a7b014', '', '', 0, 1, 0, 0, 0, 0, 1),
(53, 0, 0, '5f1950efdb1ba', '', '', 0, 1, 0, 0, 0, 0, 1),
(54, 6, 6, 'favicon', 'favicon', '', 0, 1, 0, 0, 0, 0, 1),
(55, 6, 37, 'kleur', 'kleur', '', 0, 1, 0, 0, 0, 0, 1),
(56, 6, 1, 'intro', 'intro', '', 0, 1, 0, 0, 0, 0, 1),
(57, 7, 1, 'naam', 'naam', '', 0, 1, 0, 0, 0, 0, 1),
(58, 7, 46, 'contents', 'contents', '', 0, 1, 0, 0, 0, 0, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `translations`
--
CREATE TABLE `translations` (
`translation_id` int(10) NOT NULL,
`language_id` int(10) NOT NULL,
`element_id` int(100) NOT NULL,
`type` varchar(250) NOT NULL,
`value` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `unique_ids`
--
CREATE TABLE `unique_ids` (
`unique_id` int(10) NOT NULL,
`sectie_id` int(10) NOT NULL,
`template_id` int(10) NOT NULL,
`entry_id` int(10) NOT NULL,
`status` int(1) NOT NULL,
`position` int(10) NOT NULL,
`language_id` int(10) NOT NULL,
`translation_of_uid` int(10) NOT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`sortable` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `unique_ids`
--
INSERT INTO `unique_ids` (`unique_id`, `sectie_id`, `template_id`, `entry_id`, `status`, `position`, `language_id`, `translation_of_uid`, `created`, `last_update`, `sortable`, `url`) VALUES
(1, 1, 1, 1, 2, 0, 0, 0, '2020-07-07 22:00:00', '2020-07-14 09:00:16', 'Kies je school alphen', 'kies-je-school-alphen'),
(2, 3, 6, 1, 2, 0, 0, 0, '2020-07-08 22:00:00', '2020-09-17 12:46:09', 'Ashram College', 'ashram-college'),
(3, 2, 5, 1, 2, 0, 0, 0, '2020-07-08 22:00:00', '2020-09-17 12:46:31', 'Oriëntatiemiddag 1', 'orientatie-middag'),
(4, 2, 5, 2, 2, 3, 0, 0, '2020-07-08 22:00:00', '2020-09-17 12:46:51', 'Oriëntatiemiddag 2', 'orientatiemiddag'),
(5, 2, 5, 3, 2, 1, 0, 0, '2020-07-08 22:00:00', '2020-09-17 12:46:37', 'Kennismakingsmiddag 1 gymnasium', 'kennismakingsmiddag-1-gymnasium'),
(6, 2, 5, 4, 2, 4, 0, 0, '2020-07-08 22:00:00', '2020-09-17 12:46:55', 'Kennismakingsmiddag 2 gymnasium', 'kennismakingsmiddag-2-gymnasium'),
(7, 5, 1, 2, 2, 0, 0, 0, '2020-07-08 22:00:00', '2020-07-09 12:05:46', 'Disclaimer', 'disclaimer'),
(8, 5, 1, 3, 2, 0, 0, 0, '2020-07-08 22:00:00', '2020-07-09 12:05:42', 'Cookies', 'cookies'),
(9, 3, 6, 2, 2, 1, 0, 0, '2020-07-15 22:00:00', '2020-09-17 12:52:44', 'Ashram College Alphen aan den Rijn', 'ashram-college-alphen'),
(10, 2, 5, 5, 2, 2, 0, 0, '2020-07-15 22:00:00', '2020-09-17 12:46:40', 'Ouderinformatieavond', 'ouderinformatieavond'),
(11, 2, 5, 6, 2, 5, 0, 0, '2020-07-15 22:00:00', '2020-07-16 09:09:54', 'Open Huis', 'open-huis'),
(12, 3, 6, 3, 2, 0, 0, 0, '2020-07-21 22:00:00', '2020-09-17 13:00:59', 'Groene Hart Scholen', 'groene-hart-scholen'),
(13, 3, 6, 4, 2, 2, 0, 0, '2020-07-21 22:00:00', '2020-07-23 11:20:53', 'Scala College', 'scala-college'),
(14, 3, 6, 5, 2, 3, 0, 0, '2020-07-21 22:00:00', '2020-07-23 11:20:58', 'Wellant College', 'wellant-college'),
(15, 3, 6, 6, 2, 2, 0, 0, '2020-07-22 22:00:00', '2020-09-17 12:55:47', 'Groene Hart Leerpark', 'groene-hart-leerpark'),
(16, 3, 6, 7, 2, 3, 0, 0, '2020-07-22 22:00:00', '2020-09-17 12:55:53', 'Groene Hart Lyceum', 'groene-hart-lyceum'),
(17, 3, 6, 8, 2, 4, 0, 0, '2020-07-22 22:00:00', '2020-09-17 12:56:02', 'Groene Hart Praktijkschool', 'groene-hart-praktijkschool'),
(18, 3, 6, 9, 2, 5, 0, 0, '2020-07-22 22:00:00', '2020-09-17 12:56:10', 'Groene Hart Rijnwoude', 'groene-hart-rijnwoude'),
(19, 3, 6, 10, 2, 6, 0, 0, '2020-07-22 22:00:00', '2020-09-17 12:56:16', 'Groene Hart Topmavo', 'groene-hart-topmavo'),
(20, 3, 6, 11, 2, 0, 0, 0, '2020-07-22 22:00:00', '2020-07-23 09:42:37', 'Scala College Sacharovlaan', 'scala-college-sacharovlaan'),
(21, 3, 6, 12, 2, 1, 0, 0, '2020-07-22 22:00:00', '2020-07-23 09:42:43', 'Scala College Diamantstraat', 'scala-college-diamantstraat'),
(22, 3, 6, 13, 2, 2, 0, 0, '2020-07-22 22:00:00', '2020-07-23 09:42:50', 'Scala College Nieuwe Sloot', 'scala-college-nieuwe-sloot'),
(23, 3, 6, 14, 2, 0, 0, 0, '2020-07-22 22:00:00', '2020-07-23 09:43:30', 'Wellant VMBO Alphen aan den Rijn', 'wellant-vmbo-alphen-aan-den-rijn'),
(24, 3, 6, 15, 2, 2, 0, 0, '2020-07-22 22:00:00', '2020-09-17 12:52:50', 'Ashram College Nieuwkoop', 'ashram-college-nieuwkoop'),
(25, 5, 1, 4, 0, 0, 0, 0, '2020-07-23 11:38:56', '2020-07-23 11:38:56', 'Contact', 'contac'),
(26, 5, 7, 1, 2, 0, 0, 0, '2020-07-23 11:41:15', '2020-07-23 11:41:15', 'Contact', 'contact'),
(27, 4, 7, 2, 2, 0, 0, 0, '2020-07-22 22:00:00', '2020-07-23 12:17:04', 'Keuzehulp Voorgezet Onderwijs Alphen aan den Rijn e.o', 'keuzehulp'),
(28, 2, 5, 7, 2, 1, 0, 0, '2020-09-16 22:00:00', '2020-09-17 12:52:00', 'Kennismakingsmiddag 2', 'kennismakingsmid'),
(29, 2, 5, 8, 2, 0, 0, 0, '2020-09-16 22:00:00', '2020-09-17 12:51:55', 'Kennismakingsmiddag 1', 'fds'),
(30, 3, 6, 16, 0, 1, 0, 0, '2020-09-17 12:55:26', '2020-09-17 12:55:26', 'Groene Hart Scholen', 'groene-hart-scholen');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `users`
--
CREATE TABLE `users` (
`user_id` mediumint(8) UNSIGNED NOT NULL,
`email` tinytext CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`wachtwoord` tinytext CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`voor` varchar(250) NOT NULL,
`tussen` varchar(250) NOT NULL,
`achter` varchar(250) NOT NULL,
`admin` int(1) NOT NULL DEFAULT '0',
`position` int(10) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `variabelen`
--
CREATE TABLE `variabelen` (
`variabele_id` int(10) NOT NULL,
`field_id` varchar(250) NOT NULL,
`naam` varchar(250) NOT NULL,
`active` varchar(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `variabele_data`
--
CREATE TABLE `variabele_data` (
`variabele_data_id` int(10) NOT NULL,
`variabele_id` int(10) NOT NULL,
`naam` varchar(250) NOT NULL,
`position` int(10) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Indexen voor geëxporteerde tabellen
--
--
-- Indexen voor tabel `bestellingen`
--
ALTER TABLE `bestellingen`
ADD PRIMARY KEY (`bestelling_id`);
--
-- Indexen voor tabel `bestellingen_producten`
--
ALTER TABLE `bestellingen_producten`
ADD PRIMARY KEY (`bp_id`),
ADD KEY `product_id` (`uid`),
ADD KEY `bestelling_id` (`bestelling_id`);
--
-- Indexen voor tabel `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`category_id`);
--
-- Indexen voor tabel `category_posities`
--
ALTER TABLE `category_posities`
ADD PRIMARY KEY (`category_positie_id`),
ADD KEY `pagina_id` (`category_id`,`positie_id`);
--
-- Indexen voor tabel `choice_options`
--
ALTER TABLE `choice_options`
ADD PRIMARY KEY (`choice_id`),
ADD KEY `field_id` (`field_id`);
--
-- Indexen voor tabel `custom_css`
--
ALTER TABLE `custom_css`
ADD PRIMARY KEY (`custom_id`);
--
-- Indexen voor tabel `entry_categories`
--
ALTER TABLE `entry_categories`
ADD PRIMARY KEY (`entry_category_id`),
ADD KEY `unique_id` (`unique_id`,`category_id`);
--
-- Indexen voor tabel `entry_choices`
--
ALTER TABLE `entry_choices`
ADD PRIMARY KEY (`entry_choice_id`);
--
-- Indexen voor tabel `entry_links`
--
ALTER TABLE `entry_links`
ADD PRIMARY KEY (`entry_link_id`),
ADD KEY `entry_id` (`entry_id`,`template_id`);
--
-- Indexen voor tabel `entry_posities`
--
ALTER TABLE `entry_posities`
ADD PRIMARY KEY (`entry_positie_id`),
ADD KEY `pagina_id` (`unique_id`,`positie_id`);
--
-- Indexen voor tabel `entry_syns`
--
ALTER TABLE `entry_syns`
ADD PRIMARY KEY (`entry_syn_id`);
--
-- Indexen voor tabel `entry_tags`
--
ALTER TABLE `entry_tags`
ADD PRIMARY KEY (`entry_tag_id`);
--
-- Indexen voor tabel `field_types`
--
ALTER TABLE `field_types`
ADD PRIMARY KEY (`field_id`);
--
-- Indexen voor tabel `forms`
--
ALTER TABLE `forms`
ADD PRIMARY KEY (`form_id`);
--
-- Indexen voor tabel `form_elements`
--
ALTER TABLE `form_elements`
ADD PRIMARY KEY (`form_element_id`);
--
-- Indexen voor tabel `form_elements_options`
--
ALTER TABLE `form_elements_options`
ADD PRIMARY KEY (`form_option_id`);
--
-- Indexen voor tabel `form_response`
--
ALTER TABLE `form_response`
ADD PRIMARY KEY (`form_response_id`);
--
-- Indexen voor tabel `htmltemplates`
--
ALTER TABLE `htmltemplates`
ADD PRIMARY KEY (`template_id`);
--
-- Indexen voor tabel `instellingen`
--
ALTER TABLE `instellingen`
ADD PRIMARY KEY (`id`);
--
-- Indexen voor tabel `klanten`
--
ALTER TABLE `klanten`
ADD PRIMARY KEY (`klant_id`),
ADD KEY `incasso` (`incasso`);
--
-- Indexen voor tabel `kortingcode_reeks`
--
ALTER TABLE `kortingcode_reeks`
ADD PRIMARY KEY (`codereeks_id`),
ADD KEY `kortingscode_id` (`kortingscode_id`,`date_used`);
--
-- Indexen voor tabel `kortingscodes`
--
ALTER TABLE `kortingscodes`
ADD PRIMARY KEY (`kortingscode_id`);
--
-- Indexen voor tabel `languages`
--
ALTER TABLE `languages`
ADD PRIMARY KEY (`language_id`);
--
-- Indexen voor tabel `link_data`
--
ALTER TABLE `link_data`
ADD PRIMARY KEY (`link_data_id`);
--
-- Indexen voor tabel `link_data_fields`
--
ALTER TABLE `link_data_fields`
ADD PRIMARY KEY (`link_data_field_id`);
--
-- Indexen voor tabel `page_redirects`
--
ALTER TABLE `page_redirects`
ADD PRIMARY KEY (`redirect_id`);
--
-- Indexen voor tabel `page_section_content`
--
ALTER TABLE `page_section_content`
ADD PRIMARY KEY (`page_section_id`);
ALTER TABLE `page_section_content` ADD FULLTEXT KEY `html` (`html`);
--
-- Indexen voor tabel `prijzen_product`
--
ALTER TABLE `prijzen_product`
ADD PRIMARY KEY (`prijs_product_id`),
ADD KEY `unique_id` (`unique_id`);
--
-- Indexen voor tabel `pw_reset`
--
ALTER TABLE `pw_reset`
ADD PRIMARY KEY (`reset_id`);
--
-- Indexen voor tabel `secties`
--
ALTER TABLE `secties`
ADD PRIMARY KEY (`sectie_id`);
--
-- Indexen voor tabel `sectie_categories`
--
ALTER TABLE `sectie_categories`
ADD PRIMARY KEY (`sectie_category_id`);
--
-- Indexen voor tabel `sectie_templates`
--
ALTER TABLE `sectie_templates`
ADD PRIMARY KEY (`sectie_templates_id`);
--
-- Indexen voor tabel `stramiens`
--
ALTER TABLE `stramiens`
ADD PRIMARY KEY (`stramien_id`);
--
-- Indexen voor tabel `synoniemen`
--
ALTER TABLE `synoniemen`
ADD PRIMARY KEY (`synoniem_id`);
--
-- Indexen voor tabel `synoniemen_default`
--
ALTER TABLE `synoniemen_default`
ADD PRIMARY KEY (`default_syn_id`);
--
-- Indexen voor tabel `tags`
--
ALTER TABLE `tags`
ADD PRIMARY KEY (`tag_id`);
--
-- Indexen voor tabel `td_agenda`
--
ALTER TABLE `td_agenda`
ADD PRIMARY KEY (`entry_id`);
--
-- Indexen voor tabel `td_faq`
--
ALTER TABLE `td_faq`
ADD PRIMARY KEY (`entry_id`);
--
-- Indexen voor tabel `td_feature`
--
ALTER TABLE `td_feature`
ADD PRIMARY KEY (`entry_id`);
--
-- Indexen voor tabel `td_page`
--
ALTER TABLE `td_page`
ADD PRIMARY KEY (`entry_id`);
--
-- Indexen voor tabel `td_resource`
--
ALTER TABLE `td_resource`
ADD PRIMARY KEY (`entry_id`);
--
-- Indexen voor tabel `td_scholen`
--
ALTER TABLE `td_scholen`
ADD PRIMARY KEY (`entry_id`);
--
-- Indexen voor tabel `td_simple`
--
ALTER TABLE `td_simple`
ADD PRIMARY KEY (`entry_id`);
--
-- Indexen voor tabel `templates`
--
ALTER TABLE `templates`
ADD PRIMARY KEY (`template_id`),
ADD KEY `template_name` (`naam`);
--
-- Indexen voor tabel `template_fields`
--
ALTER TABLE `template_fields`
ADD PRIMARY KEY (`template_field_id`),
ADD KEY `template_id` (`template_id`,`field_id`);
--
-- Indexen voor tabel `translations`
--
ALTER TABLE `translations`
ADD PRIMARY KEY (`translation_id`);
--
-- Indexen voor tabel `unique_ids`
--
ALTER TABLE `unique_ids`
ADD PRIMARY KEY (`unique_id`),
ADD KEY `sectie_id` (`sectie_id`,`template_id`,`entry_id`);
--
-- Indexen voor tabel `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`user_id`);
--
-- Indexen voor tabel `variabelen`
--
ALTER TABLE `variabelen`
ADD PRIMARY KEY (`variabele_id`);
--
-- Indexen voor tabel `variabele_data`
--
ALTER TABLE `variabele_data`
ADD PRIMARY KEY (`variabele_data_id`),
ADD KEY `variabele_id` (`variabele_id`);
--
-- AUTO_INCREMENT voor geëxporteerde tabellen
--
--
-- AUTO_INCREMENT voor een tabel `bestellingen`
--
ALTER TABLE `bestellingen`
MODIFY `bestelling_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `bestellingen_producten`
--
ALTER TABLE `bestellingen_producten`
MODIFY `bp_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `categories`
--
ALTER TABLE `categories`
MODIFY `category_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT voor een tabel `category_posities`
--
ALTER TABLE `category_posities`
MODIFY `category_positie_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `choice_options`
--
ALTER TABLE `choice_options`
MODIFY `choice_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `custom_css`
--
ALTER TABLE `custom_css`
MODIFY `custom_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT voor een tabel `entry_categories`
--
ALTER TABLE `entry_categories`
MODIFY `entry_category_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=173;
--
-- AUTO_INCREMENT voor een tabel `entry_choices`
--
ALTER TABLE `entry_choices`
MODIFY `entry_choice_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `entry_links`
--
ALTER TABLE `entry_links`
MODIFY `entry_link_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `entry_posities`
--
ALTER TABLE `entry_posities`
MODIFY `entry_positie_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT voor een tabel `entry_syns`
--
ALTER TABLE `entry_syns`
MODIFY `entry_syn_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `entry_tags`
--
ALTER TABLE `entry_tags`
MODIFY `entry_tag_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;
--
-- AUTO_INCREMENT voor een tabel `field_types`
--
ALTER TABLE `field_types`
MODIFY `field_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;
--
-- AUTO_INCREMENT voor een tabel `forms`
--
ALTER TABLE `forms`
MODIFY `form_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `form_elements`
--
ALTER TABLE `form_elements`
MODIFY `form_element_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `form_elements_options`
--
ALTER TABLE `form_elements_options`
MODIFY `form_option_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `form_response`
--
ALTER TABLE `form_response`
MODIFY `form_response_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `htmltemplates`
--
ALTER TABLE `htmltemplates`
MODIFY `template_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `instellingen`
--
ALTER TABLE `instellingen`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `klanten`
--
ALTER TABLE `klanten`
MODIFY `klant_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `kortingcode_reeks`
--
ALTER TABLE `kortingcode_reeks`
MODIFY `codereeks_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `kortingscodes`
--
ALTER TABLE `kortingscodes`
MODIFY `kortingscode_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `languages`
--
ALTER TABLE `languages`
MODIFY `language_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `link_data`
--
ALTER TABLE `link_data`
MODIFY `link_data_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT voor een tabel `link_data_fields`
--
ALTER TABLE `link_data_fields`
MODIFY `link_data_field_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT voor een tabel `page_redirects`
--
ALTER TABLE `page_redirects`
MODIFY `redirect_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `page_section_content`
--
ALTER TABLE `page_section_content`
MODIFY `page_section_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
--
-- AUTO_INCREMENT voor een tabel `prijzen_product`
--
ALTER TABLE `prijzen_product`
MODIFY `prijs_product_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `pw_reset`
--
ALTER TABLE `pw_reset`
MODIFY `reset_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `secties`
--
ALTER TABLE `secties`
MODIFY `sectie_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT voor een tabel `sectie_categories`
--
ALTER TABLE `sectie_categories`
MODIFY `sectie_category_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `sectie_templates`
--
ALTER TABLE `sectie_templates`
MODIFY `sectie_templates_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT voor een tabel `stramiens`
--
ALTER TABLE `stramiens`
MODIFY `stramien_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT voor een tabel `synoniemen`
--
ALTER TABLE `synoniemen`
MODIFY `synoniem_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `synoniemen_default`
--
ALTER TABLE `synoniemen_default`
MODIFY `default_syn_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `tags`
--
ALTER TABLE `tags`
MODIFY `tag_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT voor een tabel `td_agenda`
--
ALTER TABLE `td_agenda`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT voor een tabel `td_faq`
--
ALTER TABLE `td_faq`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `td_feature`
--
ALTER TABLE `td_feature`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `td_page`
--
ALTER TABLE `td_page`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT voor een tabel `td_resource`
--
ALTER TABLE `td_resource`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `td_scholen`
--
ALTER TABLE `td_scholen`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT voor een tabel `td_simple`
--
ALTER TABLE `td_simple`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT voor een tabel `templates`
--
ALTER TABLE `templates`
MODIFY `template_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT voor een tabel `template_fields`
--
ALTER TABLE `template_fields`
MODIFY `template_field_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;
--
-- AUTO_INCREMENT voor een tabel `translations`
--
ALTER TABLE `translations`
MODIFY `translation_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `unique_ids`
--
ALTER TABLE `unique_ids`
MODIFY `unique_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT voor een tabel `users`
--
ALTER TABLE `users`
MODIFY `user_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `variabelen`
--
ALTER TABLE `variabelen`
MODIFY `variabele_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `variabele_data`
--
ALTER TABLE `variabele_data`
MODIFY `variabele_data_id` int(10) NOT NULL AUTO_INCREMENT;