File: /var/www/vhosts/creativefellows.nl/desingelfysio.creativefellows.nl/cassette3_fysiovdberg.sql
-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Gegenereerd op: 11 feb 2025 om 19:18
-- Serverversie: 5.7.34
-- PHP-versie: 7.4.21
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `cassette3_fysiovdberg`
--
-- --------------------------------------------------------
--
-- 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',
`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;
-- --------------------------------------------------------
--
-- 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, 'showcase', '', 1, 0),
(2, 'black', '', 1, 0),
(3, 'service-selector', '', 1, 0),
(4, 'customer-quotes', '', 1, 0),
(5, 'about', '', 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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, '', 0, 0),
(5, 'Text', 'textarea', 'text', 'Tekstveld (multiline)', 1, 1, 1, 0, '', 0, 0),
(6, 'Image', 'image', 'tinytext', 'Foto', 1, 0, 1, 0, '', 0, 0),
(11, 'Tags', 'tag', 'text', 'Tags', 0, 0, 1, 0, '', 0, 0),
(12, 'Entry links', 'link', 'varchar(250)', 'Links', 0, 0, 1, 0, '', 0, 0),
(22, 'shop', 'shop', 'varchar(250)', 'Shop', 0, 0, 0, 0, '', 0, 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, '', 0, 0),
(24, 'checkbox', 'checkbox', 'int(10)', 'Checkbox', 0, 1, 1, 0, '', 0, 0),
(28, 'select', 'select', 'varchar(250)', 'Select', 0, 1, 1, 0, '', 0, 0),
(29, 'Files', 'files', 'text', 'Files', 1, 0, 1, 0, '', 0, 0),
(30, 'Date', 'datepicker', 'varchar(250)', 'Date', 0, 0, 1, 0, '', 0, 0),
(31, 'radio', 'radio', 'int(10)', 'Radio', 0, 1, 1, 0, '', 0, 0),
(32, 'Form group', 'formgroup', 'varchar(250)', 'Form group', 0, 1, 0, 0, '', 0, 0),
(33, 'form', 'form', 'int(10)', 'form', 0, 0, 1, 0, '', 0, 0),
(34, 'em', 'em', 'varchar(250)', 'em', 0, 0, 1, 0, '', 0, 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>', 0, 0),
(36, 'cols', 'cols', 'text', 'cols', 0, 0, 1, 0, '', 0, 0),
(37, 'Color', 'colorpicker', 'varchar(250)', 'color', 0, 0, 1, 0, '', 0, 0),
(38, 'code', 'code', 'text', 'code', 0, 0, 0, 0, '', 0, 0),
(39, 'Pagina introductie', 'Pagina introductie', 'text', 'Pagina introductie', 0, 0, 0, 0, '<div class=\"page-row page-row__introduction\"><div class=\"grid-container\"> \r\n <div class=\"grid-x grid-padding-x text-center align-middle align-center\">\r\n \r\n <div class=\"small-12 cell\">\r\n <div class=\"column-wrapper\">\r\n <h1>Lorem ipsum dolor sit amet, consectetuer adipiscing elit.</h1>\r\n <p>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</div>\r\n', 0, 0),
(40, '2-column', '2-column', 'text', '2-column', 0, 0, 0, 1, '<div class=\"row row__default\"> \r\n<div class=\"grid-container\"> \r\n<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 <p>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 <div class=\"small-12 medium-6 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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</div>\r\n\r\n\r\n', 0, 2),
(67, '5-column', '5-column', 'text', '5-column', 0, 0, 0, 0, '<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x small-up-1 medium-up-5\">\r\n<div class=\"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=\"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=\"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 class=\"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=\"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>\r\n</div>', 0, 0),
(51, 'Custom code', 'custom', 'custom', 'custom', 0, 0, 0, 1, '<div class=\"custom-code\"></div>\r\n', 0, 9),
(56, 'img', 'img', 'img-sub', 'img', 0, 0, 0, 0, ' <div class=\"image-full-width\">\r\n \r\n <div class=\"foreground hrzntl-spacer\">\r\n <div class=\"inner-wrapper\">\r\n \r\n <div class=\"col24\">\r\n <div style=\"\" class=\"column-wrapper\"><p>CLick to edit</p></div>\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://placehold.it/1200x300&text=IMAGE\"></div>\r\n</div>\r\n', 0, 0),
(42, '3-column', '3-column', 'text', '3-column', 0, 0, 0, 1, '<div class=\"page-row\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x\">\r\n \r\n \r\n <div class=\"small-12 medium-4 large-4 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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=\"small-12 medium-4 large-4 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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=\"small-12 medium-4 large-4 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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\r\n</div>\r\n</div>\r\n</div>', 0, 3),
(68, '3-column - images', '3-column - images', 'text', '3-column - images', 0, 0, 0, 0, '<div class=\"page-row\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x align-center\">\r\n \r\n \r\n <div class=\"small-12 medium-4 large-4 cell\">\r\n <div class=\"column-wrapper image image__corner\" edittype=\"image\">\r\n <img src=\"https://placehold.it/600x300&text=IMAGE\">\r\n </div>\r\n </div>\r\n \r\n <div class=\"small-12 medium-4 large-4 cell\">\r\n <div class=\"column-wrapper image image__corner\" edittype=\"image\">\r\n <img src=\"https://placehold.it/600x300&text=IMAGE\">\r\n </div>\r\n </div>\r\n\r\n<div class=\"small-12 medium-4 large-4 cell\">\r\n <div class=\"column-wrapper image image__corner\" edittype=\"image\">\r\n <img src=\"https://placehold.it/600x300&text=IMAGE\">\r\n </div>\r\n </div>\r\n\r\n\r\n</div>\r\n</div>\r\n</div>\r\n\r\n', 0, 6),
(41, '4-column', '4-column', 'text', '4-column', 0, 0, 0, 1, '<div class=\"page-row\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x\">\r\n \r\n <div class=\"small-12 medium-6 large-3 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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 <div class=\"small-12 medium-6 large-3 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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=\"small-12 medium-6 large-3 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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 <div class=\"small-12 medium-6 large-3 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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</div>', 0, 4),
(44, 'devider', 'devider', 'text', 'devider', 0, 0, 0, 1, '<div class=\"page-row page-row__devider\">\r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x align-middle\">\r\n \r\n<div class=\"small-12 large-12 cell\"><hr/></div>\r\n \r\n</div>\r\n</div>\r\n</div>', 0, 8),
(45, 'spacer', 'spacer', 'spacer', 'spacer', 0, 0, 0, 1, '<div class=\"page-row page-row__spacer\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x\">\r\n \r\n<div class=\"small-12 cell\">\r\n<div class=\"default-spacer\"></div>\r\n</div>\r\n \r\n</div>\r\n</div>\r\n</div>\r\n', 0, 7),
(46, 'dragdrop', 'dragdrop', 'text', 'dragdrop', 0, 0, 1, 0, '', 0, 0),
(48, '2-column-centered', '2-column-centered', 'text', '2-column-centered', 0, 0, 0, 0, '<div class=\"col8 offset4\">\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=\"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', 0, 0),
(49, '3-column-centered', '3-column-centered', 'text', '3-column-centered', 0, 0, 0, 0, '<div class=\"col6 offset3\">\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\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\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>', 0, 0),
(50, '1-column-centered', '1-column-centered', 'text', '1-column-centered', 0, 0, 0, 0, '<div class=\"col16 offset4\">\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>', 0, 0),
(54, 'showcase', 'showcase', 'showcase\r\n', 'showcase', 0, 0, 0, 0, '<div class=\"image-showcase\">\r\n <div class=\"case-foreground\" edittype=\"textarea\">\r\n <div class=\"column-wrapper\" edittype=\"showcase-text\">\r\n <h1>heading 1</h1>\r\n <p>text goes here</p>\r\n </div>\r\n </div>\r\n\r\n\r\n <div class=\"column-wrapper case-background\" edittype=\"showcase-image\">\r\n <img src=\"https://placehold.it/1200x500&text=background\">\r\n </div>\r\n</div>', 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>', 0, 0),
(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>', 0, 0),
(58, '2-1-column', '2-1-column', 'text', '2-1-column', 0, 0, 0, 0, '<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</div>\r\n</div>\r\n\r\n<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>', 0, 0),
(59, 'geboortedatum', 'geboortedatum', 'varchar(250)', 'geboortedatum', 0, 1, 1, 0, '', 0, 0),
(60, 'upload', 'upload', 'varchar(250)', 'upload', 0, 1, 1, 0, '', 0, 0),
(61, '6-column', '6-column', 'text', '6-column', 0, 0, 0, 0, '<div class=\"col4\">\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=\"col4\">\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=\"col4\">\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=\"col4\">\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=\"col4\">\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=\"col4\">\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', 0, 0),
(62, 'button', 'button', 'text', 'button', 0, 0, 0, 1, '<div class=\"row row__call-to-action\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x\">\r\n\r\n<div class=\"small-12 cell\">\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\r\n</div>\r\n</div>\r\n</div>', 0, 6),
(63, '2-row-1-column-2-column', '2-row-1-column-2-column', 'text', '1-column', 0, 0, 0, 0, '<div class=\"col24\">\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</div>\r\n</div>\r\n<div class=\"col12\">\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</div>\r\n</div>\r\n<div class=\"col12\">\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</div>\r\n</div>', 0, 0),
(64, 'tabs', 'tabs', 'text', 'tabs', 0, 0, 0, 0, '<div class=\"\">\r\n <div class=\"column-wrapper\">\r\n\r\n <div class=\"tab-navigation\">\r\n \r\n <ul class=\"\">\r\n <li class=\"col6\"><a href=\"#tabs-1\">Header</a></li>\r\n <li class=\"col6\"><a href=\"#tabs-2\">Header</a></li>\r\n <li class=\"col6\"><a href=\"#tabs-3\">Header</a></li>\r\n <li class=\"col6\"><a href=\"#tabs-4\">Header</a></li>\r\n </ul>\r\n \r\n <div class=\"col24 sub-grid\" id=\"tabs-1\">\r\n <div class=\"col12\">\r\n <h2>Redefining the Rules <br />of Engagement</h2> \r\n <p>What does it take to succeed in today’s fast moving business environment? Success depends on a responsive workforce outfitted with adaptive solutions for anytime, anywhere access.</p>\r\n <p><a href=\"\" class=\"primary-link\"><i class=\"fa fa-arrow-circle-right\"></i> Explore the possibilities</a></p>\r\n </div>\r\n <div class=\"col9 offset3 vert-offset-1\">\r\n <img src=\"images/business-agility.jpg\" alt=\"\" />\r\n </div>\r\n </div>\r\n \r\n <div class=\"col24 sub-grid\" id=\"tabs-2\">\r\n <div class=\"col12\">\r\n <h2>Collaborative<br />Communities</h2> \r\n <p>Aliquam vulputate, pede vel vehicula accumsan, mi neque rutrum erat, eu congue orci lorem eget lorem. Vestibulum non ante..</p>\r\n <p><a href=\"\" class=\"primary-link\"><i class=\"fa fa-arrow-circle-right\"></i> Explore the possibilities</a></p>\r\n </div>\r\n <div class=\"col9 offset3 vert-offset-1\">\r\n <img src=\"http://placehold.it/397x260/e8e8e8/e8e8e8\" alt=\"\" />\r\n </div>\r\n </div>\r\n \r\n <div class=\"col24 sub-grid\" id=\"tabs-3\">\r\n <div class=\"col12\">\r\n <h2>Fostering alliances across and beyond boundaries</h2> \r\n <p>Cultivating a collaborative atmosphere has never been more vital.Responsiveness depends on simple yet specific techniques that promote openness and transparency to achieve a dynamic and informed work environment.</p>\r\n <p><a href=\"\" class=\"primary-link\"><i class=\"fa fa-arrow-circle-right\"></i> Explore the possibilities</a></p>\r\n </div>\r\n <div class=\"col9 offset3 vert-offset-1\">\r\n <img src=\"images/collaborative-communities.jpg\" alt=\"\" />\r\n </div>\r\n </div>\r\n \r\n <div class=\"col24 sub-grid\" id=\"tabs-4\">\r\n <div class=\"col12\">\r\n <h2>Assured Services</h2> \r\n <p>Aliquam vulputate, pede vel vehicula accumsan, mi neque rutrum erat, eu congue orci lorem eget lorem. Vestibulum non ante..</p>\r\n <p><a href=\"\" class=\"primary-link\"><i class=\"fa fa-arrow-circle-right\"></i> Explore the possibilities</a></p>\r\n </div>\r\n <div class=\"col9 offset3 vert-offset-1\">\r\n <img src=\"http://placehold.it/397x260/e8e8e8/e8e8e8\" alt=\"\" />\r\n </div>\r\n </div>\r\n \r\n </div>\r\n \r\n </div>\r\n</div>', 0, 0),
(65, '5-column', '5-column', 'text', '5-column', 0, 0, 0, 0, '\r\n<div class=\"col4-5\">\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=\"col4-5\">\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=\"col4-5\">\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=\"col4-5\">\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=\"col4-5\">\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>', 0, 0),
(66, '4-column-centered', '4-column-centered', 'text', '4-column-centered', 0, 0, 0, 0, '<div class=\"col4 offset4\">\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=\"col4\">\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=\"col4\">\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=\"col4\">\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', 0, 0),
(69, '2-column - images', '2-column - images', 'text', '2-column - images', 0, 0, 0, 0, '<div class=\"page-row\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x align-center\">\r\n \r\n \r\n <div class=\"small-12 medium-4 large-4 cell\">\r\n <div class=\"column-wrapper image image__corner\" edittype=\"image\">\r\n <img src=\"https://placehold.it/600x300&text=IMAGE\">\r\n </div>\r\n </div>\r\n \r\n <div class=\"small-12 medium-4 large-4 cell\">\r\n <div class=\"column-wrapper image image__corner\" edittype=\"image\">\r\n <img src=\"https://placehold.it/600x300&text=IMAGE\">\r\n </div>\r\n </div>\r\n\r\n\r\n</div>\r\n</div>\r\n</div>\r\n', 0, 6),
(70, 'Call to action', 'Call to action', 'text', 'Call to action', 0, 0, 0, 0, '<div class=\"page-row page-row__call-to-action\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x align-middle\">\r\n \r\n <div class=\"small-12 medium-9 cell\">\r\n <div class=\"column-wrapper\">\r\n <p><strong>Bij de Fundatie gaan stijl en aandacht hand in hand met elkaar. Op basis van uw persoonlijke wensen zorgen we voor een unieke bijeenkomst.</strong><br />\r\nMeer weten? Bel <a href=\"tel:0302310351\">030 231 0351</a>, app <a href=\"https://wa.me/0645704366?text=Fundatie%20van%20Renswoude%20Utrecht\">06 457 043 66</a> of mail naar <a href=\"mailto:chatelaine@fvru.nl\">chatelaine@fvru.nl</a></p>\r\n\r\n </div>\r\n </div>\r\n <div class=\"small-12 medium-3 cell\">\r\n <div class=\"column-wrapper link\" edittype=\"link\">\r\n <a href=\"/contact/offerte-aanvragen\" class=\"button primary expanded\">Vrijblijvende offerte</a>\r\n </div>\r\n </div>\r\n \r\n</div>\r\n</div>\r\n</div>', 0, 0),
(71, '1-column', '1-column', 'text', '1-column', 0, 0, 0, 1, '<div class=\"page-row\"><div class=\"grid-container\"> \r\n <div class=\"grid-x grid-padding-x align-middle\">\r\n \r\n <div class=\"small-12 large-12 cell\">\r\n <div class=\"column-wrapper\">\r\n <h2>Lorem ipsum dolor sit amet, consectetuer adipiscing elit.</h2>\r\n <p>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</div>\r\n', 0, 1),
(72, 'Callout', 'Callout', 'text', 'Callout', 0, 0, 0, 0, '<div class=\"page-row\"><div class=\"grid-container\"> \r\n <div class=\"grid-x grid-padding-x align-middle\">\r\n \r\n <div class=\"small-12 cell\">\r\n <div class=\"callout column-wrapper\">\r\n <h2>Lorem ipsum dolor sit amet, consectetuer adipiscing elit.</h2>\r\n <p>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</div>\r\n', 0, 0),
(73, '6-column', '6-column', 'text', '6-column', 0, 0, 0, 0, '<div class=\"page-row\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x\">\r\n \r\n <div class=\"small-6 medium-3 large-2 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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=\"small-6 medium-3 large-2 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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=\"small-6 medium-3 large-2 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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=\"small-6 medium-3 large-2 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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=\"small-6 medium-3 large-2 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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=\"small-6 medium-3 large-2 cell\">\r\n <div class=\"column-wrapper\">\r\n <p>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 \r\n</div>\r\n</div>\r\n</div>', 0, 0),
(81, '3-column cards', '3-column cards', 'text', '3-column cards', 0, 0, 0, 1, '<div class=\"page-row page-row__cards\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x\" data-equalizer>\r\n\r\n \r\n <div class=\"small-12 medium-4 cell\">\r\n \r\n <div class=\"card\" data-equalizer-watch>\r\n \r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/fruit-de-mer-marie.jpg\">\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <h4>Heading</h4>\r\n <p>Description</p>\r\n <ul>\r\n <li>item A</li>\r\n <li>item B</li>\r\n <li>item C</li>\r\n <li>item D</li>\r\n </ul>\r\n </div>\r\n </div>\r\n \r\n \r\n </div>\r\n \r\n </div>\r\n \r\n <div class=\"small-12 medium-4 cell\">\r\n \r\n <div class=\"card\" data-equalizer-watch>\r\n \r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/fruit-de-mer-marie.jpg\">\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <h4>Heading</h4>\r\n <p>Description</p>\r\n <ul>\r\n <li>item A</li>\r\n <li>item B</li>\r\n <li>item C</li>\r\n <li>item D</li>\r\n </ul>\r\n </div>\r\n </div>\r\n \r\n \r\n </div>\r\n \r\n </div>\r\n \r\n <div class=\"small-12 medium-4 cell\">\r\n \r\n <div class=\"card\" data-equalizer-watch>\r\n \r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/fruit-de-mer-marie.jpg\">\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <h4>Heading</h4>\r\n <p>Description</p>\r\n <ul>\r\n <li>item A</li>\r\n <li>item B</li>\r\n <li>item C</li>\r\n <li>item D</li>\r\n </ul>\r\n </div>\r\n </div>\r\n \r\n \r\n </div>\r\n \r\n </div>\r\n \r\n \r\n \r\n \r\n</div>\r\n</div>\r\n</div>', 0, 5),
(86, 'Parallax image', 'Image', 'text', 'Image', 0, 0, 0, 1, '<div class=\"row row_parallax\"> \r\n<div class=\"grid-container full\"> \r\n<div class=\"grid-x\">\r\n \r\n<div class=\"small-12 cell\">\r\n<div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <img class=\"jarallax-img\" src=\"https://fakeimg.pl/1200x600\" alt=\"\" loading=\"lazy\">\r\n</div>\r\n</div>\r\n \r\n</div>\r\n</div>\r\n</div>', 0, 2),
(76, 'Youtube', 'Youtube', 'youtube-embed', 'Youtube', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x align-center text-center\">\r\n<div class=\"small-12 cell\"> \r\n <div class=\"responsive-embed widescreen\" edittype=\"responsive-embed\">\r\n \r\n </div> \r\n</div>\r\n</div>\r\n\r\n', 0, 16),
(82, 'Text | Image', 'Text | Image', 'text', 'Text | Image', 0, 0, 0, 1, '<div class=\"row row__mask-images\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x\">\r\n \r\n <div class=\"small-12 medium-6 cell cell__text-left\">\r\n <div class=\"column-wrapper\">\r\n \r\n <h2>Lorem ipsum dolor sit amet, consectetur adipiscing elit</h2>\r\n <p>Praesent aliquam arcu diam, vel condimentum elit consectetur vehicula. Sed vulputate finibus ipsum id eleifend. Cras laoreet orci sit amet metus pretium finibus. Cras diam enim, posuere quis enim ut, auctor fringilla libero. Maecenas suscipit, massa finibus finibus bibendum, justo odio sodales leo, congue rhoncus mi dolor nec arcu. Donec a lorem vitae ante tincidunt ultrices vitae non purus. Sed id mauris nisi. Pellentesque rutrum fermentum feugiat. Cras quis orci at nisl ornare finibus. Phasellus vel congue dolor, non tempus ipsum. </p>\r\n <p><a class=\"link\" href=\"#\">In dignissim elit ac commodo pulvinar</a></p>\r\n\r\n </div>\r\n </div>\r\n \r\n <div class=\"small-12 medium-6 cell cell__image-right\">\r\n\r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <div class=\"shape\"><img alt=\"\" class=\"lazy-load-image\" data-src=\"https://fakeimg.pl/700x500\"></div>\r\n </div>\r\n\r\n </div>\r\n \r\n</div>\r\n</div>\r\n</div>\r\n\r\n\r\n', 0, 2),
(83, 'Image', 'Image', 'text', 'Image', 0, 0, 0, 1, '<div class=\"row\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x\">\r\n \r\n<div class=\"small-12 cell\">\r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://fakeimg.pl/1200x600\">\r\n </div>\r\n</div>\r\n \r\n \r\n</div>\r\n</div>\r\n</div>', 0, 2),
(85, '3-column image', '3-column image', 'text', '3-column image', 0, 0, 0, 1, '<div class=\"page-row page-row__images\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x\">\r\n \r\n<div class=\"small-12 medium-4 cell\">\r\n\r\n<div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n<img alt=\"\" class=\"lazy-load-image\" data-src=\"https://placehold.co/600x600\">\r\n</div>\r\n \r\n<div class=\"column-wrapper\">\r\n<h3>Heading</h3>\r\n<p>Description</p>\r\n</div>\r\n \r\n\r\n</div>\r\n<div class=\"small-12 medium-4 cell\">\r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n<img alt=\"\" class=\"lazy-load-image\" data-src=\"https://placehold.co/600x600\">\r\n</div>\r\n \r\n<div class=\"column-wrapper\">\r\n<h3>Heading</h3>\r\n<p>Description</p>\r\n</div>\r\n</div>\r\n<div class=\"small-12 medium-4 cell\">\r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n<img alt=\"\" class=\"lazy-load-image\" data-src=\"https://placehold.co/600x600\">\r\n</div>\r\n \r\n<div class=\"column-wrapper\">\r\n<h3>Heading</h3>\r\n<p>Description</p>\r\n</div>\r\n</div>\r\n \r\n \r\n</div>\r\n</div>\r\n</div>', 0, 2),
(84, 'antispam', 'antispam', 'varchar(250)', 'Antispam', 0, 1, 1, 0, '', 0, 0),
(87, '4-column cards', '4-column cards', 'text', '4-column cards', 0, 0, 0, 1, '<div class=\"page-row page-row__cards\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x\" data-equalizer>\r\n\r\n \r\n <div class=\"small-12 medium-3 cell\">\r\n \r\n <div class=\"card\" data-equalizer-watch>\r\n \r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/fruit-de-mer-marie.jpg\">\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <h4>Heading</h4>\r\n <p>Description</p>\r\n <ul>\r\n <li>item A</li>\r\n <li>item B</li>\r\n <li>item C</li>\r\n <li>item D</li>\r\n </ul>\r\n </div>\r\n </div>\r\n \r\n \r\n </div>\r\n \r\n </div>\r\n \r\n <div class=\"small-12 medium-3 cell\">\r\n \r\n <div class=\"card\" data-equalizer-watch>\r\n \r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/fruit-de-mer-marie.jpg\">\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <h4>Heading</h4>\r\n <p>Description</p>\r\n <ul>\r\n <li>item A</li>\r\n <li>item B</li>\r\n <li>item C</li>\r\n <li>item D</li>\r\n </ul>\r\n </div>\r\n </div>\r\n \r\n \r\n </div>\r\n \r\n </div>\r\n \r\n <div class=\"small-12 medium-3 cell\">\r\n \r\n <div class=\"card\" data-equalizer-watch>\r\n \r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/fruit-de-mer-marie.jpg\">\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <h4>Heading</h4>\r\n <p>Description</p>\r\n <ul>\r\n <li>item A</li>\r\n <li>item B</li>\r\n <li>item C</li>\r\n <li>item D</li>\r\n </ul>\r\n </div>\r\n </div>\r\n \r\n \r\n </div>\r\n \r\n </div>\r\n \r\n <div class=\"small-12 medium-3 cell\">\r\n \r\n <div class=\"card\" data-equalizer-watch>\r\n \r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/fruit-de-mer-marie.jpg\">\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\">\r\n <h4>Heading</h4>\r\n <p>Description</p>\r\n <ul>\r\n <li>item A</li>\r\n <li>item B</li>\r\n <li>item C</li>\r\n <li>item D</li>\r\n </ul>\r\n </div>\r\n </div>\r\n \r\n \r\n </div>\r\n \r\n </div>\r\n \r\n \r\n \r\n \r\n</div>\r\n</div>\r\n</div>', 0, 5),
(88, '12-column imageslider', '12-column imageslider', 'image-slider', '12-column imageslider', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x align-center row-sliders text-center\">\r\n\r\n <div class=\"cell small-12\">\r\n<span edit=\"h\" style=\"display:none;\"></span>\r\n <div class=\"image-slider image-slider__500\">\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=1200x600\">\r\n </div>\r\n \r\n </div>\r\n </div>\r\n </div>\r\n\r\n\r\n</div>', 1, 16);
INSERT INTO `field_types` (`field_id`, `name`, `form_element`, `datatype`, `description`, `in_group`, `in_formgenerator`, `in_template`, `in_dragdrop`, `html`, `wrap`, `position`) VALUES
(89, 'Menukaart', 'Menukaart', 'text', 'Menukaart', 0, 0, 0, 1, '<div class=\"row row__menu-item\"> \r\n<div class=\"grid-container\"> \r\n<div class=\"grid-x grid-padding-x align-middle\">\r\n \r\n <div class=\"small-12 medium-6 cell\">\r\n <div class=\"column-wrapper\">\r\n \r\n <h2>Menukaart</h2>\r\n\r\n<ul class=\"menu-list\">\r\n <li><strong>12 UURTJE</strong> <em class=\"price float-right\">16</em> mulligatawny | brioche Pata Negra | garnalenkroketje</li>\r\n <li><strong>12 UURTJE</strong> <em class=\"price float-right\">16</em> mulligatawny | brioche Pata Negra | garnalenkroketje</li>\r\n <li><strong>12 UURTJE</strong> <em class=\"price float-right\">16</em> mulligatawny | brioche Pata Negra | garnalenkroketje</li>\r\n <li><strong>12 UURTJE</strong> <em class=\"price float-right\">16</em> mulligatawny | brioche Pata Negra | garnalenkroketje</li>\r\n <li><strong>12 UURTJE</strong> <em class=\"price float-right\">16</em> mulligatawny | brioche Pata Negra | garnalenkroketje</li>\r\n</ul>\r\n\r\n \r\n </div>\r\n </div>\r\n \r\n <div class=\"small-12 medium-6 cell\">\r\n\r\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\r\n <div class=\"\"><img alt=\"\" class=\"lazy-load-image\" data-src=\"https://fakeimg.pl/700x500\"></div>\r\n </div>\r\n\r\n </div>\r\n \r\n</div>\r\n</div>\r\n</div>\r\n\r\n\r\n', 0, 2);
-- --------------------------------------------------------
--
-- 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` text COLLATE utf8_unicode_ci NOT NULL,
`custom_form_code` text COLLATE utf8_unicode_ci NOT NULL,
`field_response` int(10) NOT NULL DEFAULT '0',
`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'
) 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,
`class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`position` int(10) NOT NULL DEFAULT '0',
`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` text 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, 'Fysiotherapie van den Berg', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 20, 1, 1, 0, 0, 0, '1300', '1', 21, '', 'height:24px;margin-bottom:24px;', 'basic', 0, 'Fysiotherapie van den Berg', '#eb5d40', '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,
`locale` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `languages`
--
INSERT INTO `languages` (`language_id`, `name`, `locale`) VALUES
(0, '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;
-- --------------------------------------------------------
--
-- 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,
`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`, `html`, `edittag`, `datatype`, `element_id`, `element_class`, `fullpage`, `custom`, `custom_content`, `css`, `link_data`, `sub_of`, `position`, `status`, `locked`) VALUES
(1, 1, '<section id=\"xgvkbpomth\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'showcase', 0, 0, 'text-left align-middle', '', 0, 0, 0, 1, 0),
(2, 1, '\n \n \n \n \n \n <section id=\"vnafvfxbsd\" class=\"\"><div class=\"page-row\"><div class=\"grid-container\"> \n <div class=\"grid-x grid-padding-x align-middle\">\n \n <div class=\" large-12 cell\">\n <div class=\"column-wrapper\" style=\"\"><h1>Ook zonder verwijzing<br>\nkunt u meestal bij de<br>\nfysiotherapeut terecht</h1>\n\n<p><a href=\"#\">Veelgestelde vragen</a></p>\n\n<div class=\"image\"><img alt=\"\" src=\"https://d6vns6qvgyzc8.cloudfront.net/fysiovandenberg/images/fysio-van-den-berg-alphen2.jpg\"></div>\n</div>\n </div>\n \n </div>\n</div>\n</div>\n</section>\n \n \n ', '1-column', 'text', '', '', 0, 0, ' align-middle', '', 0, 1, 1, 1, 0),
(3, 1, '<section id=\"tecdkyimcl\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'service-selector', 0, 0, ' ', '', 0, 0, 1, 1, 0),
(4, 1, '\n \n \n \n \n \n \n \n <section id=\"oyzarpgziw\" class=\"\"><div class=\"custom-code\"><div class=\"grid-container\">\n<div class=\"grid-x grid-padding-x\">\n\n<div class=\"cell small 12\">\n<ul class=\"menu menu__service-groups\">\n <li><a href=\"#\" class=\"selected\">Fysiotherapie</a></li>\n <li><a href=\"#\">Revalidatie</a></li>\n <li><a href=\"#\">Special voor vrouwen</a></li>\n <li><a href=\"#\">Stress en burnout</a></li>\n <li><a href=\"#\">Kinderen</a></li>\n <li><a href=\"#\">Overige specilisaties</a></li>\n</ul>\n</div>\n\n<div class=\"cell small-12\">\n<h2><strong>Fysiotherapie:</strong> \nDé oplossing voor pijn en bewegingsklachten</h2>\n<p>Een fysiotherapeut helpt mensen met pijn of bewegingsklachten door blessures, overbelasting, een verkeerde houding of na een operatie. Ook bij chronische pijn of revalidatie na een ongeval biedt fysiotherapie uitkomst. Met gerichte behandelingen en advies zorgt de fysiotherapeut ervoor dat patiënten weer soepel en pijnvrij kunnen bewegen.</p>\n\n<ul class=\"menu menu__solutions-for\">\n <li><a href=\"#\">Rug</a></li>\n <li><a href=\"#\">Schouder</a></li>\n <li><a href=\"#\">Knie</a></li>\n <li><a href=\"#\">Voet en enkel</a></li>\n <li><a href=\"#\">Hand en pols</a></li>\n <li><a href=\"#\">Nek</a></li>\n</ul>\n\n<ul class=\"pagination\">\n <li class=\"current\">1/2</li>\n <li class=\"page-link page-link__prev\"><a href=\"#\"></a></li>\n <li class=\"page-link page-link__next\"><a href=\"#\"></a></li>\n</ul>\n\n\n\n</div>\n\n</div>\n</div></div>\n</section>\n \n \n \n ', 'Custom code', 'custom', '', '', 0, 0, '', '', 0, 3, 2, 1, 0),
(5, 1, '<section id=\"frlaknuufy\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'black', 0, 0, ' ', '', 0, 0, 4, 1, 0),
(6, 1, '<section id=\"aicgvmrewh\" class=\"\"><div class=\"row row__default\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x\">\n \n <div class=\"small-12 medium-6 cell\">\n <div class=\"column-wrapper\">\n <p>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 class=\"small-12 medium-6 cell\">\n <div class=\"column-wrapper\">\n <p>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\n</section>', '2-column', 'text', '', '', 0, 0, '', '', 0, 5, 1, 0, 0),
(7, 1, '\n \n <section id=\"ewvpcnrxtl\" class=\"\"><div class=\"page-row\"><div class=\"grid-container\"> \n <div class=\"grid-x grid-padding-x text-center \">\n \n <div class=\" large-12 cell\">\n <div class=\"column-wrapper\" style=\"\"><h2>Altijd een locatie in de buurt</h2>\n</div>\n </div>\n \n </div>\n</div>\n</div>\n</section>\n ', '1-column', 'text', '', '', 0, 0, 'text-center ', '', 0, 5, 0, 1, 0),
(8, 1, '<section id=\"vtppvidwsm\" class=\"\"><div class=\"page-row\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x\">\n \n <div class=\"small-12 medium-6 large-3 cell\">\n <div class=\"column-wrapper\">\n <p>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 class=\"small-12 medium-6 large-3 cell\">\n <div class=\"column-wrapper\">\n <p>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=\"small-12 medium-6 large-3 cell\">\n <div class=\"column-wrapper\">\n <p>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 class=\"small-12 medium-6 large-3 cell\">\n <div class=\"column-wrapper\">\n <p>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></section>', '4-column', 'text', '', '', 0, 0, '', '', 0, 5, 3, 1, 0),
(9, 1, '<section id=\"sefutndabt\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'about', 0, 0, ' ', '', 0, 0, 3, 1, 0),
(10, 1, '\n \n \n \n \n \n \n \n <section id=\"zlswpprnyv\" class=\"\"><div class=\"row row__default\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x align-middle\">\n \n <div class=\" medium-6 cell\">\n <div class=\"column-wrapper\" style=\"\"><div class=\"mask-image\"><img alt=\"\" src=\"https://d6vns6qvgyzc8.cloudfront.net/fysiovandenberg/images/behandelmethodes-fysio-vd-berg.jpg\"></div>\n</div>\n </div>\n <div class=\" medium-6 cell\">\n <div class=\"column-wrapper\" style=\"\"><h2>Fysiotherapie van den Berg</h2>\n\n<p>Fysiotherapie van den Berg met effectieve behandelmethodes, hoge patiënttevredenheid en zorgcontracten met alle zorgverzekeraars.</p>\n\n<p>Bij ons krijgt u de aandacht die u verdient. Wij stellen u op uw gemak en gaan samen op zoek naar de bron van de klacht. Wij stellen snel een diagnose en leggen u graag uit wat er aan de hand is. Daarna bepalen wij samen met u het doel van de behandelingen. Door onze efficiënte aanpak zorgen wij ervoor dat u zo snel mogelijk van uw klachten af komt. Wij helpen u!</p>\n\n<p><a class=\"button primary\" href=\"#\">Maak kennis met ons team</a> <a class=\"button white\" href=\"#\">Onze specialisaties</a></p>\n</div>\n </div>\n \n</div>\n</div>\n</div>\n\n\n</section>\n \n \n \n ', '2-column', 'text', '', '', 0, 0, ' align-middle', '', 0, 9, 4, 1, 0),
(11, 1, '<section id=\"eisdzolzlm\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'customer-quotes', 0, 0, ' ', '', 0, 0, 2, 1, 0),
(12, 1, '\n \n \n \n <section id=\"yqmarziohn\" class=\"\"><div class=\"page-row\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x\">\n \n <div class=\" medium-6 large-3 cell cell__line-right\">\n <div class=\"column-wrapper\" style=\"\"><h3 style=\"text-align: right;\">Wat klanten<br>\nover ons<br>\nzeggen</h3>\n\n<p><img alt=\"\" src=\"https://d6vns6qvgyzc8.cloudfront.net/fysiovandenberg/images/fysio-van-den-berg-fc.svg\"></p>\n</div>\n </div>\n <div class=\" medium-6 large-3 cell\">\n <div class=\"column-wrapper\" style=\"\"><p>\"Heel vakkundig van mijn frozen shoulders afgeholpen door Jelmer.Goede en vriendelijke behandeling. Aanrader.\"</p>\n\n<p><br>\n<strong>Claudia</strong><br>\n<img alt=\"\" src=\"https://d6vns6qvgyzc8.cloudfront.net/fysiovandenberg/images/stars.png\" style=\"height: 10px; width: 64px;\"></p>\n</div>\n </div>\n\n <div class=\" medium-6 large-3 cell\">\n <div class=\"column-wrapper\" style=\"\"><p>\"Ontzettend goed geholpen door Erik, Ik kwam daar terecht voor mijn nek. En ik ben weer als herboren. Wat een Super leuke aardige man, die weet waar hij mee bezig is.\"</p>\n\n<p><strong>Linda</strong><br>\n<img alt=\"\" src=\"https://d6vns6qvgyzc8.cloudfront.net/fysiovandenberg/images/stars.png\" style=\"height: 10px; width: 64px;\"></p>\n</div>\n </div>\n <div class=\" medium-6 large-3 cell\">\n <div class=\"column-wrapper\" style=\"\"><p>\"De beste fysiotherapie in de regio! Ik heb een paar maanden met mijn therapeut Raoul getraind en nu zijn bijna alle pijnen weg.\"</p>\n\n<p><br>\n<strong>Ye-li</strong><br>\n<img alt=\"\" src=\"https://d6vns6qvgyzc8.cloudfront.net/fysiovandenberg/images/stars.png\" style=\"height: 10px; width: 64px;\"></p>\n</div>\n </div>\n \n</div>\n</div>\n</div></section>\n \n ', '4-column', 'text', '', '', 0, 0, '', '', 0, 11, 3, 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, '', '', '', '', 0, 0, 0, '', 0, 1, 0, '', 1),
(2, 'Aanbod', 'aanbod', '', '', 1, '', '', '', '', 1, 1, 0, '', 0, 1, 0, '', 1),
(3, 'Bewegingsklachten', 'bewegingsklachten', '', '', 1, '', '', '', '', 1, 2, 0, '', 0, 1, 0, '', 1),
(4, 'Over ons', 'over-ons', '', '', 1, '', '', '', '', 1, 4, 0, '', 0, 1, 0, '', 1),
(5, 'data', '', '', '', 1, '', '', '', '', 0, 7, 0, '', 0, 1, 0, '', 1),
(6, 'Vergoedingen', 'vergoedingen', '', '', 1, '', '', '', '', 1, 3, 0, '', 0, 1, 0, '', 1),
(8, 'Afspraak maken', 'afspraak-maken', '', '', 1, '', '', '', '', 1, 6, 0, '', 0, 1, 0, '', 0),
(7, 'Contact', 'contact', '', '', 1, '', '', '', '', 1, 5, 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
(2, 1, 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),
(2, 'taxatie', 0, 0, 1),
(3, 'taxatie-verstuurd', 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_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_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,
`image` tinytext COLLATE utf8_unicode_ci,
`image_footer` tinytext COLLATE utf8_unicode_ci,
`call_to_action` int(10) DEFAULT NULL,
`button` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`formitable` int(10) DEFAULT NULL,
`lead` 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`, `image`, `image_footer`, `call_to_action`, `button`, `formitable`, `lead`) VALUES
(1, 0, 1, '2025-02-10 11:00:57', 1, 1, 0, 0, '', '', '', 'Fysiotherapie van den Berg', '', '', NULL, NULL, NULL, NULL, '');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_qoute`
--
CREATE TABLE `td_qoute` (
`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,
`quote` text COLLATE utf8_unicode_ci,
`brand` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`image` tinytext COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_showcase`
--
CREATE TABLE `td_showcase` (
`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,
`lead` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`image` tinytext COLLATE utf8_unicode_ci,
`link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- 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, 'showcase', 0, 1),
(3, 'qoute', 0, 1),
(4, 'faq', 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, 6, 0, 1),
(3, 1, 6, 'image', 'image', '', 0, 1, 0, 0, 5, 0, 1),
(4, 0, 0, '6225fe667f471', '', '', 0, 1, 0, 0, 0, 0, 1),
(5, 0, 0, '6225ff0b9fdce', '', '', 0, 1, 0, 0, 0, 0, 1),
(6, 2, 1, 'titel', 'titel', '', 0, 1, 0, 0, 0, 0, 1),
(7, 2, 1, 'lead', 'lead', '', 0, 1, 0, 0, 0, 0, 1),
(8, 2, 6, 'image', 'image', '', 0, 1, 0, 0, 0, 0, 1),
(9, 2, 12, 'link', 'link', '', 0, 1, 0, 0, 0, 0, 1),
(10, 1, 6, 'image_footer', 'image_footer', '', 0, 1, 0, 0, 7, 0, 0),
(11, 0, 0, '624ab22cbb09c', '', '', 0, 1, 0, 0, 0, 0, 1),
(12, 1, 24, 'call_to_action', 'call_to_action', '', 0, 1, 0, 0, 2, 0, 0),
(13, 1, 12, 'button', 'button', '', 0, 1, 0, 0, 3, 0, 0),
(14, 1, 24, 'formitable', 'formitable', '', 0, 1, 0, 0, 4, 0, 0),
(15, 1, 1, 'lead', 'lead', '', 0, 1, 0, 0, 1, 0, 1),
(16, 0, 0, '65e983bf7b68e', '', '', 0, 1, 0, 0, 0, 0, 1),
(17, 0, 0, '6660408326347', '', '', 0, 1, 0, 0, 0, 0, 1),
(18, 3, 1, 'name', 'name', '', 0, 1, 0, 0, 0, 0, 1),
(19, 3, 5, 'quote', 'quote', '', 0, 1, 0, 0, 0, 0, 1),
(20, 4, 1, 'title', 'title', '', 0, 1, 0, 0, 0, 0, 1),
(21, 4, 5, 'text', 'text', '', 0, 1, 0, 0, 0, 0, 1),
(22, 3, 1, 'brand', 'brand', '', 0, 1, 0, 0, 0, 0, 1),
(23, 3, 6, 'image', 'image', '', 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, '2025-02-09 23:00:00', '2025-02-10 12:41:09', 'Fysiotherapie van den Berg', 'fysiotherapie-van-den-berg');
-- --------------------------------------------------------
--
-- 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_faq`
--
ALTER TABLE `td_faq`
ADD PRIMARY KEY (`entry_id`);
--
-- Indexen voor tabel `td_page`
--
ALTER TABLE `td_page`
ADD PRIMARY KEY (`entry_id`);
--
-- Indexen voor tabel `td_qoute`
--
ALTER TABLE `td_qoute`
ADD PRIMARY KEY (`entry_id`);
--
-- Indexen voor tabel `td_showcase`
--
ALTER TABLE `td_showcase`
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 voor een tabel `custom_css`
--
ALTER TABLE `custom_css`
MODIFY `custom_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- 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 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=90;
--
-- 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=13;
--
-- 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=9;
--
-- 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=3;
--
-- AUTO_INCREMENT voor een tabel `stramiens`
--
ALTER TABLE `stramiens`
MODIFY `stramien_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- 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_faq`
--
ALTER TABLE `td_faq`
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=2;
--
-- AUTO_INCREMENT voor een tabel `td_qoute`
--
ALTER TABLE `td_qoute`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `td_showcase`
--
ALTER TABLE `td_showcase`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `templates`
--
ALTER TABLE `templates`
MODIFY `template_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT voor een tabel `template_fields`
--
ALTER TABLE `template_fields`
MODIFY `template_field_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- 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=2;
--
-- 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;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;