File: /var/www/vhosts/creativefellows.nl/olimazi.creativefellows.nl/cassette3_grandbarmarie.sql
-- phpMyAdmin SQL Dump
-- version 5.1.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Gegenereerd op: 10 mrt 2022 om 15:14
-- Serverversie: 5.7.34
-- PHP-versie: 8.0.8
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_grandbarmarie`
--
-- --------------------------------------------------------
--
-- 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
(9, 'image-full-width', '', 1, 0),
(10, 'lead-text', '', 1, 0),
(11, 'background-green', '', 1, 0),
(12, 'no-padding', '', 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/711aac29ac6f4f71a0bb72b6fd817aa8-large.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/711aac29ac6f4f71a0bb72b6fd817aa8-large.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/711aac29ac6f4f71a0bb72b6fd817aa8-large.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),
(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 link__apics-pointer\" 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=\"apics-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=\"row row__images\"> \r\n<div class=\"grid-container full\"> \r\n<div class=\"grid-x\">\r\n \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://fakeimg.pl/600x600\">\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://fakeimg.pl/600x600\">\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://fakeimg.pl/600x600\">\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);
-- --------------------------------------------------------
--
-- 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, 'Grand Bar Marie', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 20, 1, 1, 0, 0, 4, '1300', '225', 21, '', 'height:24px;margin-bottom:24px;', 'basic', 0, 'Grand Bar Marie', '#c29e63', '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'),
(1, 'EN', 'en');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `link_data`
--
CREATE TABLE `link_data` (
`link_data_id` int(10) NOT NULL,
`name` varchar(255) NOT NULL,
`find` varchar(255) NOT NULL,
`template` text NOT NULL,
`entry` int(10) NOT NULL DEFAULT '0',
`section` int(10) NOT NULL,
`category` int(10) NOT NULL,
`position` int(10) NOT NULL DEFAULT '0',
`repeat_items` int(10) NOT NULL DEFAULT '0',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `link_data`
--
INSERT INTO `link_data` (`link_data_id`, `name`, `find`, `template`, `entry`, `section`, `category`, `position`, `repeat_items`, `active`) VALUES
(1, 'FAQ', '{faq}', '<li class=\"accordion-item\" data-accordion-item>\n <a href=\"#\" class=\"accordion-title\">{title}</a>\n <div class=\"accordion-content\" data-tab-content>\n {text}\n </div>\n</li>', 0, 9, 1, 0, 20, 1),
(2, 'Team', '{team}', '<div class=\"cell small-12 medium-3 text-center\">\n<div class=\"{class}\">\n<div class=\"team-member-image\"><img src=\"{image}\" alt=\"{name}\" /></div>\n<h3>{name}</h3>\n<p>{function}</p>\n<ul class=\"menu horizontal align-center\">\n <li class=\"contact-email\"><a href=\"mailto:{email}\" class=\"icon icon__email\">E-mail</a></li>\n <li class=\"contact-phone\"><a href=\"tel:{phone}\" class=\"icon icon__phone\">Telefoon</a></li>\n <li class=\"contact-linkedin\"><a href=\"{linkedin}\" class=\"icon icon__linkedin\">Linkedin</a></li>\n</ul>\n</div>\n</div>', 0, 9, 7, 0, 0, 1),
(3, 'blogs', '{blogs}', '<div class=\"cell small-12 medium-4 text-center\">\n<div class=\"card card__blog\">\n<div class=\"card-image\"><a href=\"{link}\"><img src=\"{image}\" alt=\"{name}\" /></a></div>\n<div class=\"card-section\">\n<div class=\"card-fixed-height\">\n<div class=\"card-date\">{datum}</div>\n<h3 class=\"card-title\"><span>{title}</span></h3>\n{lead}\n</div>\n<p class=\"card-read-more\"><a class=\"link link__apics-pointer\" href=\"{link}\">Lees meer</a></p>\n</div>\n</div>\n</div>', 0, 11, 0, 0, 0, 1);
-- --------------------------------------------------------
--
-- 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;
--
-- Gegevens worden geëxporteerd voor tabel `link_data_fields`
--
INSERT INTO `link_data_fields` (`link_data_field_id`, `template_data_id`, `template`, `field`, `intro`, `array`, `index`, `function`, `active`) VALUES
(1, 1, '{title}', 'title', 0, 0, 0, '0', 1),
(2, 1, '{text}', 'text', 0, 0, 0, '0', 1),
(3, 2, '{name}', 'name', 0, 0, 0, '0', 1),
(4, 2, '{function}', 'function', 0, 0, 0, '0', 1),
(5, 2, '{image}', 'image', 0, 1, 0, '0', 1),
(6, 2, '{class}', 'class', 0, 0, 0, '0', 1),
(7, 2, '{phone}', 'phone', 0, 0, 0, '0', 1),
(8, 2, '{linkedin}', 'linkedin', 0, 0, 0, '0', 1),
(9, 2, '{email}', 'email', 0, 0, 0, '0', 1),
(10, 3, '{title}', 'title', 0, 0, 0, '0', 1),
(12, 3, '{image}', 'image', 0, 1, 0, '0', 1),
(13, 3, '{link}', 'link', 0, 0, 0, '0', 1),
(14, 3, '{lead}', 'lead', 0, 0, 0, '0', 1),
(15, 3, '{datum}', 'date', 0, 0, 0, '1', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `order_labels`
--
CREATE TABLE `order_labels` (
`label_id` int(10) NOT NULL,
`order_id` int(10) NOT NULL,
`consignment_id` varchar(255) NOT NULL,
`parcel_id` varchar(255) NOT NULL,
`tracktrace` varchar(255) NOT NULL,
`label` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `page_redirects`
--
CREATE TABLE `page_redirects` (
`redirect_id` int(10) NOT NULL,
`old_url` text CHARACTER SET latin1 NOT NULL,
`new_url` text CHARACTER SET latin1 NOT NULL,
`position` int(10) NOT NULL DEFAULT '0',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `page_section_content`
--
CREATE TABLE `page_section_content` (
`page_section_id` int(10) NOT NULL,
`page_id` int(10) NOT NULL,
`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, '\n \n \n \n <section id=\"tkeakbnekt\" class=\"\"><div class=\"row row__image-xl\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x\">\n \n<div class=\" cell\">\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/grand-bar-marie-utrecht.jpg\">\n </div>\n</div>\n \n \n</div>\n</div>\n</div></section>\n \n ', 'Image', 'text', '', '', 1, 0, ' ', '', 0, 0, 1, 0, 0),
(2, 1, '\n \n \n \n \n \n \n \n \n \n \n \n \n \n <section id=\"ukdwdwbqhd\" class=\"\"><div class=\"row\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x text-left align-top\">\n \n<div class=\" cell parallax-scroll small-12 parallax-scroll\">\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/hermkens-muurschildering-utrecht(1).jpg\">\n </div>\n</div>\n \n \n</div>\n</div>\n</div></section>\n \n \n \n \n \n \n ', 'Image', 'text', 'hide', 'image-full-width', 0, 0, 'text-left align-top', 'small-12 parallax-scroll', 0, 0, 0, 0, 0),
(3, 1, '\n \n \n \n \n \n \n \n <section id=\"dymrotcuem\" class=\"\"><div class=\"page-row\"><div class=\"grid-container\"> \n <div class=\"grid-x grid-padding-x text-center align-top\">\n \n <div class=\" large-12 cell\">\n <div class=\"column-wrapper\" style=\"\"><h1>Fijnproeverij</h1>\n\n<h3>verse en lokale producten</h3>\n\n<p>Um que non nonsero quiamus aeperia quis magnimus atent eos estibusdae voloritat volupta Ut dolores accullaborum quiam, suntiatem facersp ernatur maxima que porem. Laboriam di soluptate por assendit et andel ilique none nisquam quibusa vel id quam, ipsae odissu. suntiatem facersp ernatur maxima que porem.</p>\n</div>\n </div>\n \n </div>\n</div>\n</div>\n</section>\n \n \n \n ', '1-column', 'text', '', 'lead-text', 0, 0, 'text-center align-top', '', 0, 0, 1, 1, 0),
(4, 1, '\n \n \n \n <section id=\"krgllcaoho\" class=\"\"><div class=\"row row__mask-images\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x align-middle\">\n \n <div class=\" medium-6 cell cell__text-left\">\n <div class=\"column-wrapper\" style=\"\"><h2>Fijnproeverij<br>\nmet verse lokale producten</h2>\n\n<p>Um que non nonsero quiamus aeperia quis magnimus atent eos estibusdae voloritat volupta Ut dolores accullaborum quiam, suntiatem facersp ernatur maxima que porem. Laboriam di soluptate por assendit et.</p>\n\n<p><a class=\"button button__marie\" href=\"#\">Reserveer een tafel</a></p>\n</div>\n </div>\n \n <div class=\" medium-6 cell cell__image-right\">\n\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\n <div class=\"apics-shape\"><img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/711aac29ac6f4f71a0bb72b6fd817aa8-large.JPG\"></div>\n </div>\n\n </div>\n \n</div>\n</div>\n</div>\n\n\n</section>\n \n ', 'Text | Image', 'text', '', '', 0, 0, ' align-middle', '', 0, 0, 2, 1, 0),
(5, 1, '\n \n \n \n \n \n <section id=\"cbkihfimrp\" class=\"\"><div class=\"row\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x text-left align-top\">\n \n<div class=\" medium-4 cell\">\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/grand-bar-marie.jpg\">\n </div>\n</div>\n<div class=\" medium-4 cell\">\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/grandbar-cocktails.jpg\">\n </div>\n</div>\n<div class=\" medium-4 cell\">\n <div class=\"column-wrapper\" edittype=\"image-lazy\">\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/fine-dining.jpg\">\n </div>\n</div>\n \n \n</div>\n</div>\n</div></section>\n \n \n ', '3-column image', 'text', '', '', 0, 0, 'text-left align-top', '', 0, 0, 3, 0, 0),
(6, 1, '<section id=\"tiyorfdrrp\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', 'background-green', 0, 0, ' ', '', 0, 0, 5, 1, 0),
(7, 1, '\n \n \n \n <section id=\"flipppvhxm\" 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>De smaak van vers</h2>\n\n<h3>Direct op tafel</h3>\n</div>\n </div>\n \n </div>\n</div>\n</div>\n</section>\n \n ', '1-column', 'text', '', '', 0, 0, 'text-center ', '', 0, 6, 0, 1, 0),
(9, 1, '<section id=\"pnadutyibv\" class=\"\"><div class=\"row row__images\"> \r\n<div class=\"grid-container full\"> \r\n<div class=\"grid-x text-left align-top\">\r\n \r\n<div class=\" medium-4 cell medium-4 small-4 medium-4\">\r\n <div class=\"column-wrapper jarallax\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image jarallax-img\" src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAQAAAC1HAwCAAAAC0lEQVR42mN8Vg8AAlEBZ0IDjCQAAAAASUVORK5CYII=\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/grand-bar-marie.jpg\">\r\n </div>\r\n</div>\r\n<div class=\" medium-4 cell medium-4 small-4 medium-4\">\r\n <div class=\"column-wrapper jarallax\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image jarallax-img\" src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAQAAAC1HAwCAAAAC0lEQVR42mN8Vg8AAlEBZ0IDjCQAAAAASUVORK5CYII=\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/grandbar-cocktails.jpg\">\r\n </div>\r\n</div>\r\n<div class=\" medium-4 cell medium-4 small-4 medium-4\">\r\n <div class=\"column-wrapper jarallax\" edittype=\"image-lazy\">\r\n <img alt=\"\" class=\"lazy-load-image jarallax-img\" src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAQAAAC1HAwCAAAAC0lEQVR42mN8Vg8AAlEBZ0IDjCQAAAAASUVORK5CYII=\" data-src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/food/fine-dining.jpg\">\r\n </div>\r\n</div>\r\n \r\n \r\n</div>\r\n</div>\r\n</div></section>', '3-column image', 'text', 'test', 'no-padding', 0, 0, 'text-left align-top', 'small-4 medium-4', 0, 0, 4, 1, 0),
(8, 1, '\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n <section id=\"mcsldduxyg\" class=\"\"><div class=\"page-row\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x text-center \">\n \n \n <div class=\" medium-4 large-4 cell\">\n <div class=\"column-wrapper\" style=\"\"><div class=\"card\"><img alt=\"\" class=\"lazy-load-image\" data-src=\"data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\">\n<div class=\"card-section\">\n<h4>de plek voor<br>\nelke gelegenheid</h4>\n\n<p>Um que non nonsero quiamus aeperia quis magnimus atent eos estibusdae voloritat volupta.</p>\n</div>\n</div>\n</div>\n </div>\n \n <div class=\" medium-4 large-4 cell\">\n <div class=\"column-wrapper\" style=\"\"><div class=\"card\"><img alt=\"\" class=\"lazy-load-image\" data-src=\"\">\n<div class=\"card-section\">\n<h4>de plek voor<br>\nelke gelegenheid</h4>\n\n<p>Um que non nonsero quiamus aeperia quis magnimus atent eos estibusdae voloritat volupta.</p>\n</div>\n</div>\n</div>\n </div>\n \n <div class=\" medium-4 large-4 cell\">\n <div class=\"column-wrapper\" style=\"\"><div class=\"card\"><img alt=\"\" class=\"lazy-load-image\" data-src=\"\">\n<div class=\"card-section\">\n<h4>de plek voor<br>\nelke gelegenheid</h4>\n\n<p>Um que non nonsero quiamus aeperia quis magnimus atent eos estibusdae voloritat volupta.</p>\n</div>\n</div>\n</div>\n </div>\n\n\n</div>\n</div>\n</div></section>\n \n \n \n \n \n \n \n \n \n ', '3-column', 'text', '', '', 0, 0, 'text-center ', '', 0, 6, 1, 0, 0),
(10, 1, '\n \n <section id=\"rccfiduxhg\" class=\"\"><div class=\"row row__call-to-action\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x\">\n\n<div class=\"small-12 cell\">\n\n<div class=\"column-wrapper link\" edittype=\"link\">\n<a href=\"#\" class=\"button primary\">Ontdek het verassende menu</a>\n</div>\n\n</div>\n\n</div>\n</div>\n</div></section>\n ', 'button', 'text', '', '', 0, 0, '', '', 0, 6, 5, 0, 0),
(11, 1, '\n \n \n \n <section id=\"gyixrsaeah\" 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=\"\"><div><a class=\"button button__marie\" href=\"#\">Ontdek het verassende menu</a></div>\n</div>\n </div>\n \n </div>\n</div>\n</div>\n</section>\n \n ', '1-column', 'text', '', '', 0, 0, 'text-center ', '', 0, 6, 3, 1, 0),
(13, 1, '\n \n \n \n \n \n \n \n <section id=\"dxmoiecggu\" class=\"\"><div class=\"page-row page-row__marketing\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x\" data-equalizer=\"\">\n\n \n <div class=\"small-12 medium-4 cell\">\n <div class=\"column-wrapper\" style=\"\"><div class=\"card\" data-equalizer-watch=\"\"><img alt=\"\" class=\"lazy-load-image\" data-src=\"data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\">\n<div class=\"card-section\">\n<h4>Heading</h4>\n\n<p>Description</p>\n\n<ul>\n <li>item A</li>\n <li>item B</li>\n <li>item C</li>\n <li>item Dfff</li>\n</ul>\n</div>\n</div>\n</div>\n </div>\n \n <div class=\"small-12 medium-4 cell\">\n <div class=\"column-wrapper\" style=\"\">\n <div class=\"card\" data-equalizer-watch=\"\">\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"\">\n <div class=\"card-section\"> \n <h4>Heading</h4>\n <p>Description</p>\n <ul>\n <li>item A</li>\n <li>item B</li>\n <li>item C</li>\n <li>item D</li>\n </ul>\n \n \n </div>\n \n </div>\n </div>\n </div>\n \n <div class=\"small-12 medium-4 cell\">\n <div class=\"column-wrapper\" style=\"\">\n <div class=\"card\" data-equalizer-watch=\"\">\n <img alt=\"\" class=\"lazy-load-image\" data-src=\"\">\n <div class=\"card-section\"> \n <h4>Heading</h4>\n <p>Description</p>\n <ul>\n <li>item A</li>\n <li>item B</li>\n <li>item C</li>\n <li>item D</li>\n </ul>\n \n \n </div>\n \n </div>\n </div>\n </div>\n \n \n \n \n \n</div>\n</div>\n</div></section>\n \n \n \n ', '3-column cards', 'text', '', '', 0, 0, '', '', 0, 6, 5, 0, 0),
(12, 1, '\n \n <section id=\"suhddizbdl\" class=\"\"><div class=\"page-row page-row__spacer\"> \n<div class=\"grid-container\"> \n<div class=\"grid-x grid-padding-x space-2\">\n \n<div class=\"small-12 cell\">\n<div class=\"default-spacer\"></div>\n</div>\n \n</div>\n</div>\n</div>\n</section>\n ', 'spacer', 'spacer', '', '', 0, 0, '', '', 0, 6, 2, 1, 0),
(14, 1, ' \r\n <section id=\"wezwwkpigu\" class=\"\"><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/711aac29ac6f4f71a0bb72b6fd817aa8-large.JPG\">\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\" style=\"\"><h4>Heading</h4>\r\n\r\n<p>Description</p>\r\n\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/711aac29ac6f4f71a0bb72b6fd817aa8-large.JPG\">\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\" style=\"\">\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/711aac29ac6f4f71a0bb72b6fd817aa8-large.JPG\">\r\n </div>\r\n \r\n <div class=\"card-section\">\r\n <div class=\"column-wrapper\" style=\"\">\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></section>\r\n ', '3-column cards', 'text', '', '', 0, 0, '', '', 0, 6, 1, 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, 'Grand Bar', '', '', '', 1, '', '', '', '', 1, 1, 0, '', 0, 1, 0, '', 1),
(3, 'Brasserie', '', '', '', 1, '', '', '', '', 1, 2, 0, '', 0, 1, 0, '', 1),
(4, 'Menu', '', '', '', 1, '', '', '', '', 1, 3, 0, '', 0, 1, 0, '', 1),
(5, 'Over ons', '', '', '', 1, '', '', '', '', 1, 4, 0, '', 0, 1, 0, '', 1),
(6, 'Contact', '', '', '', 1, '', '', '', '', 1, 5, 0, '', 0, 1, 0, '', 1),
(7, 'Reserveren', '', '', '', 1, '', '', '', '', 1, 6, 0, '', 0, 1, 0, '', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `sectie_categories`
--
CREATE TABLE `sectie_categories` (
`sectie_category_id` int(10) NOT NULL,
`sectie_id` int(10) NOT NULL,
`category_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `sectie_templates`
--
CREATE TABLE `sectie_templates` (
`sectie_templates_id` int(10) NOT NULL,
`sectie_id` int(10) NOT NULL,
`template_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `sectie_templates`
--
INSERT INTO `sectie_templates` (`sectie_templates_id`, `sectie_id`, `template_id`) VALUES
(1, 1, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `stramiens`
--
CREATE TABLE `stramiens` (
`stramien_id` int(10) NOT NULL,
`naam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`position` int(10) NOT NULL,
`columns` int(10) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `stramiens`
--
INSERT INTO `stramiens` (`stramien_id`, `naam`, `position`, `columns`, `active`) VALUES
(1, 'page', 0, 0, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `synoniemen`
--
CREATE TABLE `synoniemen` (
`synoniem_id` int(11) NOT NULL,
`synoniem` varchar(255) NOT NULL,
`value` varchar(255) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `synoniemen_default`
--
CREATE TABLE `synoniemen_default` (
`default_syn_id` int(10) NOT NULL,
`field_id` int(10) NOT NULL,
`value` varchar(255) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `tags`
--
CREATE TABLE `tags` (
`tag_id` int(10) NOT NULL,
`name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`times_tagged` int(10) NOT NULL DEFAULT '0',
`position` int(10) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_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,
`titel` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`contents` text COLLATE utf8_unicode_ci,
`image` tinytext COLLATE utf8_unicode_ci
) 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`, `titel`, `contents`, `image`) VALUES
(1, 0, 1, '2022-03-02 12:10:55', 1, 1, 0, 0, 'Grandbar Brasserie Marie Utrecht', '', '', 'Grand Bar Brasserie Marie', '', 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/grandbarmarie/images/hermkens-muurschildering-utrecht(1).jpg');
-- --------------------------------------------------------
--
-- 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);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `template_fields`
--
CREATE TABLE `template_fields` (
`template_field_id` int(10) NOT NULL,
`template_id` int(10) NOT NULL,
`field_id` int(10) NOT NULL,
`field_naam` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`field_user` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sub_of` int(10) NOT NULL DEFAULT '0',
`type` int(1) NOT NULL DEFAULT '0',
`overzicht` int(1) NOT NULL DEFAULT '0',
`link_to` int(10) NOT NULL DEFAULT '0',
`position` int(10) NOT NULL,
`translate` int(1) NOT NULL DEFAULT '0',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `template_fields`
--
INSERT INTO `template_fields` (`template_field_id`, `template_id`, `field_id`, `field_naam`, `field_user`, `value`, `sub_of`, `type`, `overzicht`, `link_to`, `position`, `translate`, `active`) VALUES
(1, 1, 1, 'titel', 'titel', '', 0, 1, 0, 0, 0, 0, 1),
(2, 1, 46, 'contents', 'contents', '', 0, 1, 0, 0, 2, 0, 1),
(3, 1, 6, 'image', 'image', '', 0, 1, 0, 0, 1, 0, 1),
(4, 0, 0, '6225fe667f471', '', '', 0, 1, 0, 0, 0, 0, 1),
(5, 0, 0, '6225ff0b9fdce', '', '', 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, '2022-03-01 23:00:00', '2022-03-07 12:45:33', 'Grand Bar Brasserie Marie', 'grand-bar-brasserie-marie');
-- --------------------------------------------------------
--
-- 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_page`
--
ALTER TABLE `td_page`
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=13;
--
-- 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=86;
--
-- AUTO_INCREMENT voor een tabel `forms`
--
ALTER TABLE `forms`
MODIFY `form_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `form_elements`
--
ALTER TABLE `form_elements`
MODIFY `form_element_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `form_elements_options`
--
ALTER TABLE `form_elements_options`
MODIFY `form_option_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `form_response`
--
ALTER TABLE `form_response`
MODIFY `form_response_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `htmltemplates`
--
ALTER TABLE `htmltemplates`
MODIFY `template_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `instellingen`
--
ALTER TABLE `instellingen`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `klanten`
--
ALTER TABLE `klanten`
MODIFY `klant_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `kortingcode_reeks`
--
ALTER TABLE `kortingcode_reeks`
MODIFY `codereeks_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `kortingscodes`
--
ALTER TABLE `kortingscodes`
MODIFY `kortingscode_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `languages`
--
ALTER TABLE `languages`
MODIFY `language_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `link_data`
--
ALTER TABLE `link_data`
MODIFY `link_data_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT voor een tabel `link_data_fields`
--
ALTER TABLE `link_data_fields`
MODIFY `link_data_field_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- 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=15;
--
-- 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=8;
--
-- 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=2;
--
-- AUTO_INCREMENT voor een tabel `stramiens`
--
ALTER TABLE `stramiens`
MODIFY `stramien_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `synoniemen`
--
ALTER TABLE `synoniemen`
MODIFY `synoniem_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `synoniemen_default`
--
ALTER TABLE `synoniemen_default`
MODIFY `default_syn_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `tags`
--
ALTER TABLE `tags`
MODIFY `tag_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `td_page`
--
ALTER TABLE `td_page`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `templates`
--
ALTER TABLE `templates`
MODIFY `template_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `template_fields`
--
ALTER TABLE `template_fields`
MODIFY `template_field_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- 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 */;