File: /var/www/vhosts/creativefellows.nl/test.creativefellows.nl/debets/db.txt
-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Gegenereerd op: 21 jan 2021 om 17:07
-- Serverversie: 5.7.32
-- PHP-versie: 7.3.24
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `cassette3_debets_hr`
--
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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
(6, 2, 1),
(2, 3, 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;
-- --------------------------------------------------------
--
-- 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-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</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),
(83, 'Files_localized', 'files_localized', 'text', 'Files_localized', 1, 0, 1, 0, '', 1, 0);
-- --------------------------------------------------------
--
-- 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, 'Nicolette Debets HR', '', '', '', '', '', '', '', '', '', 'http://debets.test:8888/', '', '', '', '', '', '', '', '', 20, 1, 1, 0, 0, 4, '1300', '1', 21, '', 'height:24px;margin-bottom:24px;', 'basic', 0, 'Debets HR', '#1a4766', '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, '', '', '', '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,
`label` varchar(50) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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 `resource_localization`
--
CREATE TABLE `resource_localization` (
`file_id` int(10) NOT NULL,
`page_id` varchar(255) DEFAULT NULL,
`parent` int(10) NOT NULL DEFAULT '0',
`filename` varchar(255) DEFAULT NULL,
`alt_header` varchar(255) DEFAULT NULL,
`alt_body` varchar(255) DEFAULT NULL,
`image` varchar(500) DEFAULT NULL,
`lang` varchar(3) DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 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.page.php', 'view.page.php', '', '', 0, 0, 0, '', 0, 1, 0, '', 1),
(2, 'HR Interim', 'hr-interim', '', '', 1, 'view.page.php', 'view.page.php', '', '', 1, 0, 0, '', 0, 1, 0, '', 1),
(3, 'HR Projecten', 'hr-projecten', '', '', 1, 'view.page.php', 'view.page.php', '', '', 1, 0, 0, '', 0, 1, 0, '', 1),
(4, 'Ervaring', 'ervaring', '', '', 1, 'view.page.php', 'view.page.php', '', '', 1, 0, 0, '', 0, 1, 0, '', 1),
(5, 'Contact', 'contact', '', '', 1, 'view.page.php', 'view.page.php', '', '', 1, 0, 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, 1),
(3, 3, 1),
(4, 4, 1),
(5, 5, 1);
-- --------------------------------------------------------
--
-- 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, 'page', 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;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_default`
--
CREATE TABLE `td_default` (
`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,
`titel` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`tekst` text COLLATE utf8_unicode_ci,
`subtitel` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `td_default`
--
INSERT INTO `td_default` (`entry_id`, `position`, `status`, `last_edit`, `template_id`, `unique_id`, `form_id`, `stramien_id`, `meta_title`, `meta_desc`, `page_redirect`, `titel`, `tekst`, `subtitel`) VALUES
(1, 0, 1, '2021-01-14 09:30:57', 1, 1, 0, 0, '', '', '', 'Nicolette Debets HR', '<h4>betrokken, betrouwbaar, toegankelijk</h4>\r\n\r\n<h1>HUMAN RESOURCE professional</h1>\r\n\r\n<p><em>Ik ben Nicolette Debets. Ik heb brede ervaring bij als HR-professional bij zowel non-profit als commerciële organisaties, bij grote en kleine bedrijven, als manager en als adviseur, beleidsmatig, coördinerend en aansturend maar ook uitvoerend.</em></p>\r\n\r\n<p>Mijn kracht ligt in opdrachten waar om een generalist wordt gevraagd. Door mijn brede diepe kennis weet ik snel te handelen in nieuwe situaties. Bij de uitvoer van mijn opdrachten stel ik mij betrokken, betrouwbaar en toegankelijk op. Ik geloof er in dat dit de manier is om samen te werken en te komen tot de gewenste resultaten. Door samen te werken, te luisteren, te durven én te doen. Het is de kunst om zaken bespreekbaar te maken in een organisatie en daar op te acteren.</p>\r\n\r\n<p>Ik ben van mening dat HR, op welk niveau ook, baat heeft bij een persoonlijke aanpak en professionele benadering. Want ik geloof er in dat jouw medewerkers het succes van jouw organisatie zijn. De juiste persoon op de juiste plaats gaat jou verder helpen om duurzaam een gezonde organisatie te zijn waarbij mooie resultaten neergezet worden.</p>\r\n\r\n<p>Om duurzaam deze gezonde organisatie neer te zetten of te zijn geef jij daar je energie, daar waar dat nodig is. Daar heb je emphatisch vermogen voor nodig, durf en het aangaan met elkaar.</p>\r\n', ''),
(2, 0, 1, '2021-01-18 15:38:08', 1, 2, 0, 0, '', '', '', 'HR Interim', '<p><em>Ik versterk organisaties graag bij tactische en strategische vraagstukken, tijdelijke pieken of bij verlof. Omdat ik op een persoonlijke en toegankelijke manier werk, weet ik snel resultaten te bereiken.</em></p>\r\n\r\n<p>Mijn kracht ligt in het snel overzien van de werkzaamheden die er liggen en in een korte tijd processen inzichtelijk maken en overzicht creëren.<br />\r\nIk ben inzetbaar als adviseur of manager. Ik neem mijn eigen ervaring, mening en kwaliteiten mee en zet die in om een optimaal resultaat voor de klant te bereiken.</p>\r\n\r\n<p>Daarnaast geloof ik echt in duurzame oplossingen, ik ga voor de aanpak die op de lange termijn werkt voor jouw organisatie.</p>\r\n', 'Mijn KRACHT'),
(3, 0, 1, '2021-01-18 15:38:10', 1, 3, 0, 0, '', '', '', 'Page 2', '', ''),
(4, 0, 1, '2021-01-18 15:38:13', 1, 4, 0, 0, '', '', '', 'Page 3', '', '');
-- --------------------------------------------------------
--
-- 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, 'default', 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, 'titel', 'titel', '', 0, 1, 0, 0, 0, 0, 1),
(2, 1, 5, 'tekst', 'tekst', '', 0, 1, 0, 0, 2, 0, 1),
(3, 1, 1, 'subtitel', 'subtitel', '', 0, 1, 0, 0, 1, 0, 1),
(4, 0, 0, '6009a4e2338bb', '', '', 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, '2021-01-13 23:00:00', '2021-01-21 16:05:16', 'Nicolette Debets HR', '/'),
(2, 2, 1, 2, 2, 0, 0, 0, '2021-01-17 23:00:00', '2021-01-21 15:59:43', 'HR Interim', 'hr-interim'),
(3, 2, 1, 3, 2, 1, 0, 0, '2021-01-17 23:00:00', '2021-01-18 15:38:28', 'Page 2', 'page-2'),
(4, 2, 1, 4, 2, 2, 0, 0, '2021-01-18 15:38:13', '2021-01-18 15:38:13', 'Page 3', 'page-3');
-- --------------------------------------------------------
--
-- 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 `resource_localization`
--
ALTER TABLE `resource_localization`
ADD PRIMARY KEY (`file_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_default`
--
ALTER TABLE `td_default`
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 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 voor een tabel `entry_categories`
--
ALTER TABLE `entry_categories`
MODIFY `entry_category_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- 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=7;
--
-- 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 voor een tabel `field_types`
--
ALTER TABLE `field_types`
MODIFY `field_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;
--
-- 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 voor een tabel `link_data`
--
ALTER TABLE `link_data`
MODIFY `link_data_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- 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 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 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 `resource_localization`
--
ALTER TABLE `resource_localization`
MODIFY `file_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=6;
--
-- AUTO_INCREMENT voor een tabel `stramiens`
--
ALTER TABLE `stramiens`
MODIFY `stramien_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 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 voor een tabel `td_default`
--
ALTER TABLE `td_default`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT voor een tabel `templates`
--
ALTER TABLE `templates`
MODIFY `template_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `template_fields`
--
ALTER TABLE `template_fields`
MODIFY `template_field_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- 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=5;
--
-- 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;