File: /var/www/vhosts/creativefellows.nl/education.creativefellows.nl/db.sql
-- phpMyAdmin SQL Dump
-- version 4.7.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Gegenereerd op: 15 nov 2017 om 08:15
-- Serverversie: 5.6.35
-- PHP-versie: 5.6.31
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `cassette3_nec_hospital`
--
-- --------------------------------------------------------
--
-- 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;
--
-- Gegevens worden geëxporteerd voor tabel `categories`
--
INSERT INTO `categories` (`category_id`, `sectie_id`, `naam`, `url`, `position`, `sub_of`, `zichtbaar`, `active`) VALUES
(1, 15, 'Better security', '', 0, 0, 1, 1),
(2, 15, 'Improcing physical security', '', 0, 0, 1, 1),
(3, 15, 'acurate timeclock', '', 0, 0, 1, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `category_posities`
--
CREATE TABLE `category_posities` (
`category_positie_id` int(10) NOT NULL,
`category_id` int(10) NOT NULL,
`positie_id` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `choice_options`
--
CREATE TABLE `choice_options` (
`choice_id` int(10) UNSIGNED NOT NULL,
`field_id` mediumint(8) UNSIGNED NOT NULL,
`choice` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`value` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Gegevens worden geëxporteerd voor tabel `choice_options`
--
INSERT INTO `choice_options` (`choice_id`, `field_id`, `choice`, `value`) VALUES
(1, 31, 'hide loopback', '1');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `custom_css`
--
CREATE TABLE `custom_css` (
`custom_id` int(10) NOT NULL,
`css_class` varchar(250) NOT NULL,
`css` text NOT NULL,
`active` int(1) NOT NULL DEFAULT '1',
`position` int(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `custom_css`
--
INSERT INTO `custom_css` (`custom_id`, `css_class`, `css`, `active`, `position`) VALUES
(1, 'customer-quote', '', 1, 0),
(2, 'gray-callout', '', 1, 0),
(3, 'page-intro', '', 1, 0),
(4, 'vertical-align-columns-middle', '', 1, 0),
(5, 'ten-reasons', '', 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;
--
-- Gegevens worden geëxporteerd voor tabel `entry_posities`
--
INSERT INTO `entry_posities` (`entry_positie_id`, `unique_id`, `positie_id`) VALUES
(1, 2, 1),
(68, 3, 1),
(66, 4, 1),
(67, 5, 1),
(64, 6, 1),
(6, 7, 1),
(7, 8, 1),
(9, 10, 1),
(10, 11, 1),
(11, 12, 1),
(34, 17, 1),
(40, 18, 1),
(27, 21, 1),
(35, 22, 1),
(36, 23, 1),
(41, 24, 1),
(53, 19, 1),
(54, 26, 1),
(37, 20, 1),
(58, 27, 1),
(39, 31, 1),
(55, 32, 1),
(56, 33, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `entry_syns`
--
CREATE TABLE `entry_syns` (
`entry_syn_id` int(10) NOT NULL,
`uid` int(10) NOT NULL,
`field_id` int(10) NOT NULL,
`syn_id` int(10) NOT NULL,
`org_syn_id` int(10) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `entry_tags`
--
CREATE TABLE `entry_tags` (
`entry_tag_id` int(10) UNSIGNED NOT NULL,
`entry_id` int(10) UNSIGNED NOT NULL,
`template_id` int(10) 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,
`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`, `position`) VALUES
(1, 'Input', 'text', 'varchar(250)', 'Tekstveld', 0, 1, 1, 0, '', 0),
(5, 'Text', 'textarea', 'text', 'Tekstveld (multiline)', 1, 1, 1, 0, '', 0),
(6, 'Image', 'image', 'tinytext', 'Foto', 1, 0, 1, 0, '', 0),
(11, 'Tags', 'tag', 'text', 'Tags', 0, 0, 1, 0, '', 0),
(12, 'Entry links', 'link', 'varchar(250)', 'Links', 0, 0, 1, 0, '', 0),
(22, 'shop', 'shop', 'varchar(250)', 'Shop', 0, 0, 1, 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),
(3, 'autocomplete', 'autocomplete', 'int(10)', 'Autocomplete', 0, 0, 1, 0, '', 0),
(24, 'checkbox', 'checkbox', 'int(10)', 'Checkbox', 0, 1, 1, 0, '', 0),
(26, 'h1', 'h1', 'varchar(250)', 'h1', 0, 0, 1, 0, '<div class=\"col24 single-row\">\r\n<div class=\"column-wrapper\">\r\n<h1>{fields_contents}</h1>\r\n</div>\r\n</div>', 1),
(27, 'h2', 'h2', 'varchar(250)', 'h2', 0, 0, 1, 0, '<div class=\"col24 single-row\">\r\n<div class=\"column-wrapper\">\r\n<h2>{fields_contents}</h2>\r\n</div>\r\n</div>', 2),
(28, 'select', 'select', 'varchar(250)', 'Select', 0, 1, 1, 0, '', 0),
(29, 'Files', 'files', 'text', 'Files', 1, 0, 1, 0, '', 0),
(14, 'Date', 'datepicker', 'varchar(250)', 'Date', 0, 1, 1, 0, '', 0),
(31, 'radio', 'radio', 'int(10)', 'Radio', 0, 1, 1, 0, '', 0),
(32, 'Form group', 'formgroup', 'varchar(250)', 'Form group', 0, 1, 0, 0, '', 0),
(33, 'form', 'form', 'int(10)', 'form', 0, 0, 1, 0, '', 0),
(34, 'em', 'em', 'varchar(250)', 'em', 0, 0, 1, 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),
(36, 'cols', 'cols', 'text', 'cols', 0, 0, 1, 0, '', 0),
(37, 'Color', 'colorpicker', 'varchar(250)', 'color', 0, 0, 1, 0, '', 0),
(38, 'code', 'code', 'text', 'code', 0, 0, 0, 0, '', 0),
(40, '2-column', '2-column', 'text', '2-column', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n\r\n<div class=\"small-12 medium-6 large-6 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-6 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div', 4),
(39, '1-column', '1-column', 'text', '1-column', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"medium-12 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 3),
(51, 'custom', 'custom', 'custom', 'custom', 0, 0, 0, 1, '\r\n<div class=\"custom-code\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>', 17),
(42, '3-column', '3-column', 'text', '3-column', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"small-12 medium-4 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-4 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-4 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 5),
(41, '4-column', '4-column', 'text', '4-column', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"small-12 medium-6 large-3 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-6 large-3 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-6 large-3 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"small-12 medium-6 large-3 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 6),
(43, 'img', 'img', 'img', 'img', 0, 0, 0, 0, '<div class=\"image-full-width\">\r\n <div class=\"column-wrapper background\" edittype=\"image\">\r\n <img src=\"http://placehold.it/1200x300&text=IMAGE\">\r\n </div>\r\n</div>', 18),
(44, 'devider', 'devider', 'text', 'devider', 0, 0, 0, 0, '<div class=\"col24\"><div class=\"column-wrapper\" edittype=\"none\"><hr/></div></div>', 10),
(45, 'spacer', 'spacer', 'spacer', 'spacer', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"small-12 cell\">\r\n<div class=\"column-wrapper\">\r\n\r\n<div class=\"column-wrapper\" edittype=\"spacer\"><div class=\"default-spacer\"></div></div>\r\n\r\n</div>\r\n</div>\r\n</div>\r\n', 0),
(46, 'dragdrop', 'dragdrop', 'text', 'dragdrop', 0, 0, 1, 0, '', 0),
(48, '2-column-centered', '2-column-centered', 'text', '2-column-centered', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"medium-4 medium-offset-2 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-4 end cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 8),
(49, '3-column-centered', '3-column-centered', 'text', '3-column-centered', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"medium-2 medium-offset-3 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-2 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-2 end cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 9),
(50, '1-column-centered', '1-column-centered', 'text', '1-column-centered', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"medium-8 medium-offset-2 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n<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>', 7),
(54, 'showcase', 'showcase', 'showcase', 'showcase', 0, 0, 0, 1, '<div class=\"image-showcase\">\r\n<div class=\"showcase-case\" datagroup=\"case\">\r\n \r\n<div class=\"case-foreground row expanded\" edittype=\"textarea\">\r\n <div class=\"small-12 columns\">\r\n \r\n <div class=\"row intro-text\">\r\n <div class=\"small-12 medium-8 medium-offset-1 columns\">\r\n <div class=\"column-wrapper\" edittype=\"showcase-text\">\r\n\r\n <h1>Heading</h1>\r\n <p>Text</p>\r\n \r\n </div>\r\n </div>\r\n </div>\r\n \r\n </div>\r\n</div>\r\n\r\n<div class=\"column-wrapper case-background\" edittype=\"showcase-image\">\r\n <img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/necsl2100/images/sl2100-terminal-handset-office.jpg\">\r\n</div>\r\n \r\n</div>\r\n</div>\r\n', 16),
(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>', 12),
(57, 'item-links', 'item-links', 'category-link', 'item-links', 0, 0, 0, 0, '<div class=\"col6\">\r\n <div class=\"column-wrapper\" edittype=\"textarea\">\r\n <p>Room for image</p>\r\n </div>\r\n </div>\r\n\r\n <div class=\"col18\">\r\n <div class=\"column-wrapper\" edittype=\"textarea\">\r\n <p>Room for text</p>\r\n </div>\r\n</div>', 15),
(58, '1-4-column', '1-4-column', 'text', '1-4-column', 0, 0, 0, 0, '<div class=\"col6\">\r\n<div class=\"column-wrapper\" edittype=\"textarea\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col18\">\r\n<div class=\"column-wrapper\" edittype=\"textarea\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n</div>\r\n</div>', 13),
(59, 'geboortedatum', 'geboortedatum', 'varchar(250)', 'geboortedatum', 0, 1, 1, 0, '', 0),
(60, 'upload', 'upload', 'varchar(250)', 'upload', 0, 1, 1, 0, '', 0),
(61, 'postdata', 'postdata', 'varchar(250)', 'postdata', 0, 1, 1, 0, '', 0),
(63, '3-1-column', '3-1-column', 'text', '3-1-column', 0, 0, 0, 0, '<div class=\"col18\">\r\n<div class=\"column-wrapper\" edittype=\"textarea\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col6\">\r\n<div class=\"column-wrapper\" edittype=\"textarea\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n</div>\r\n</div>\r\n', 14),
(64, 'synoniem', 'synoniem', 'varchar(255)', 'synoniem', 0, 0, 1, 0, '', 0),
(62, 'Image-crop', 'image-crop', 'text', 'image-crop', 0, 0, 1, 0, '', 0),
(65, '4-column-centered', '4-column-centered', 'text', '4-column-centered', 0, 0, 0, 1, '<div class=\"grid-x grid-padding-x\">\r\n<div class=\"medium-2 medium-offset-2 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-2 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-2 cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n\r\n<div class=\"medium-2 end cell\">\r\n<div class=\"column-wrapper\">\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\r\n\r\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\r\n\r\n</div>\r\n</div>\r\n</div>', 9);
-- --------------------------------------------------------
--
-- 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,
`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;
--
-- Gegevens worden geëxporteerd voor tabel `forms`
--
INSERT INTO `forms` (`form_id`, `form_name`, `form_response`, `field_response`, `unique_id`, `active`, `form_desc`, `button_label`, `custom_handler`, `locked`) VALUES
(1, 'Contact NEC', 'generalsales@necam.com, ronald.schapendonk@emea.nec.com', 0, '58b7ea6ae8e92', 1, '<h2 style=\"text-align: center;\">Form succesfully sent</h2>\r\n\r\n<p style=\"text-align: center;\">Thank you for your request. An NEC representative will contact you shortly.</p>\r\n', 'Submit', '', 0);
-- --------------------------------------------------------
--
-- 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;
--
-- Gegevens worden geëxporteerd voor tabel `form_elements`
--
INSERT INTO `form_elements` (`form_element_id`, `unique_id`, `field_id`, `name`, `description`, `class`, `position`, `value`) VALUES
(1, '58b7ea6ae8e92', 1, 'Name2', '', '', 1, 1),
(2, '58b7ea6ae8e92', 1, 'E-mail', '', '', 4, 1),
(7, '58b7ea6ae8e92', 32, 'Please tell us about yourself', '', '', 0, 0),
(4, '58b7ea6ae8e92', 1, 'Company', '', '', 2, 1),
(5, '58b7ea6ae8e92', 1, 'State', '', '', 3, 1),
(8, '58b7ea6ae8e92', 32, 'Please provide explanation so your inquiry can be addressed appropriately', '', '', 8, 0),
(9, '58b7ea6ae8e92', 1, 'Phone number', '', '', 5, 1),
(14, '58b7ea6ae8e92', 5, 'Message', '', '', 9, 1),
(13, '58b7ea6ae8e92', 28, 'Are you a Dealer/Reseller?', '', '', 6, 0),
(15, '58b7ea6ae8e92', 24, 'checkbox', '', '', 10, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `form_elements_options`
--
CREATE TABLE `form_elements_options` (
`form_option_id` int(10) NOT NULL,
`form_element_id` int(10) NOT NULL,
`value` varchar(250) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Gegevens worden geëxporteerd voor tabel `form_elements_options`
--
INSERT INTO `form_elements_options` (`form_option_id`, `form_element_id`, `value`) VALUES
(1, 1, 'undefined'),
(2, 2, 'undefined'),
(7, 7, 'undefined'),
(4, 4, 'undefined'),
(5, 5, 'undefined'),
(8, 8, 'undefined'),
(9, 9, 'undefined'),
(19, 14, 'undefined'),
(17, 13, 'No'),
(18, 13, 'Yes'),
(20, 15, 'fdsafdsafdsafdsa');
-- --------------------------------------------------------
--
-- 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;
--
-- Gegevens worden geëxporteerd voor tabel `form_response`
--
INSERT INTO `form_response` (`form_response_id`, `uid`, `form_id`, `field_id`, `value`, `status`) VALUES
(1, '592fc7c378325', 1, 0, '', 1),
(2, '592fc7c378325', 1, 0, 'bas rozenbradn', 1),
(3, '592fc7c378325', 1, 0, 'creative fellows', 1),
(4, '592fc7c378325', 1, 0, 'ZH', 1),
(5, '592fc7c378325', 1, 0, 'bas@creativefellows.nl', 1),
(6, '592fc7c378325', 1, 0, '+31618409178', 1),
(7, '592fc7c378325', 1, 0, 'No', 1),
(8, '592fc7c378325', 1, 0, '', 1),
(9, '592fc7c378325', 1, 0, 'fdsaf dlksafdjslka jfdskla fjdska jfkdsjfkldsajklf djsakl fjdksa jfkdasjfldsjaf djkslf dsa', 1),
(10, '592fc7df3011d', 1, 0, '', 1),
(11, '592fc7df3011d', 1, 0, 'bas rozenbradn', 1),
(12, '592fc7df3011d', 1, 0, 'creative fellows', 1),
(13, '592fc7df3011d', 1, 0, 'ZH', 1),
(14, '592fc7df3011d', 1, 0, 'bas@creativefellows.nl', 1),
(15, '592fc7df3011d', 1, 0, '+31618409178', 1),
(16, '592fc7df3011d', 1, 0, 'No', 1),
(17, '592fc7df3011d', 1, 0, '', 1),
(18, '592fc7df3011d', 1, 0, 'fdsaf dlksafdjslka jfdskla fjdska jfkdsjfkldsajklf djsakl fjdksa jfkdasjfldsjaf djkslf dsa', 1),
(19, '592fcb41426fa', 1, 0, '', 1),
(20, '592fcb41426fa', 1, 0, 'bas rozenbradn', 1),
(21, '592fcb41426fa', 1, 0, 'creative fellows', 1),
(22, '592fcb41426fa', 1, 0, 'ZH', 1),
(23, '592fcb41426fa', 1, 0, 'bas@creativefellows.nl', 1),
(24, '592fcb41426fa', 1, 0, '+31618409178', 1),
(25, '592fcb41426fa', 1, 0, 'No', 1),
(26, '592fcb41426fa', 1, 0, '', 1),
(27, '592fcb41426fa', 1, 0, 'fdsaf dlksafdjslka jfdskla fjdska jfkdsjfkldsajklf djsakl fjdksa jfkdasjfldsjaf djkslf dsa', 1),
(28, '592fcb6b7b7d2', 1, 0, '', 1),
(29, '592fcb6b7b7d2', 1, 0, 'bas rozenbradn', 1),
(30, '592fcb6b7b7d2', 1, 0, 'creative fellows', 1),
(31, '592fcb6b7b7d2', 1, 0, 'ZH', 1),
(32, '592fcb6b7b7d2', 1, 0, 'bas@creativefellows.nl', 1),
(33, '592fcb6b7b7d2', 1, 0, '+31618409178', 1),
(34, '592fcb6b7b7d2', 1, 0, 'No', 1),
(35, '592fcb6b7b7d2', 1, 0, '', 1),
(36, '592fcb6b7b7d2', 1, 0, 'fdsaf dlksafdjslka jfdskla fjdska jfkdsjfkldsajklf djsakl fjdksa jfkdasjfldsjaf djkslf dsa', 1),
(37, '592fcc62bc68f', 1, 0, '', 1),
(38, '592fcc62bc68f', 1, 0, 'bas rozenbradn', 1),
(39, '592fcc62bc68f', 1, 0, 'creative fellows', 1),
(40, '592fcc62bc68f', 1, 0, 'ZH', 1),
(41, '592fcc62bc68f', 1, 0, 'bas@creativefellows.nl', 1),
(42, '592fcc62bc68f', 1, 0, '+31618409178', 1),
(43, '592fcc62bc68f', 1, 0, 'No', 1),
(44, '592fcc62bc68f', 1, 0, '', 1),
(45, '592fcc62bc68f', 1, 0, 'fdsaf dlksafdjslka jfdskla fjdska jfkdsjfkldsajklf djsakl fjdksa jfkdasjfldsjaf djkslf dsa', 1),
(46, '592ff7209debe', 1, 0, '', 1),
(47, '592ff7209debe', 1, 0, 'fds', 1),
(48, '592ff7209debe', 1, 0, 'fds', 1),
(49, '592ff7209debe', 1, 0, 'fdsa', 1),
(50, '592ff7209debe', 1, 0, 'fdsa', 1),
(51, '592ff7209debe', 1, 0, 'fdsafds', 1),
(52, '592ff7209debe', 1, 0, 'No', 1),
(53, '592ff7209debe', 1, 0, '', 1),
(54, '592ff7209debe', 1, 0, 'fdsa fdsfdsaf dsa\r\n', 1),
(55, '59a3ca88ef5ed', 1, 0, '', 1),
(56, '59a3ca88ef5ed', 1, 0, '', 1),
(57, '59a3ca88ef5ed', 1, 0, 'fsd', 1),
(58, '59a3ca88ef5ed', 1, 0, 'fds', 1),
(59, '59a3ca88ef5ed', 1, 0, 'gs', 1),
(60, '59a3ca88ef5ed', 1, 0, 'fds', 1),
(61, '59a3ca88ef5ed', 1, 0, 'No', 1),
(62, '59a3ca88ef5ed', 1, 0, '', 1),
(63, '59a3ca88ef5ed', 1, 0, 'gfdsgfdsgfds', 1),
(64, '59a3ca88ef5ed', 1, 0, '', 1),
(65, '59a3ca93be6b1', 1, 0, '', 1),
(66, '59a3ca93be6b1', 1, 0, '', 1),
(67, '59a3ca93be6b1', 1, 0, 'fsd', 1),
(68, '59a3ca93be6b1', 1, 0, 'fds', 1),
(69, '59a3ca93be6b1', 1, 0, 'gs', 1),
(70, '59a3ca93be6b1', 1, 0, 'fds', 1),
(71, '59a3ca93be6b1', 1, 0, 'No', 1),
(72, '59a3ca93be6b1', 1, 0, '', 1),
(73, '59a3ca93be6b1', 1, 0, 'gfdsgfdsgfds', 1),
(74, '59a3ca93be6b1', 1, 0, '', 1),
(75, '59a3caf20a48c', 1, 0, '', 1),
(76, '59a3caf20a48c', 1, 0, '', 1),
(77, '59a3caf20a48c', 1, 0, 'fdsa', 1),
(78, '59a3caf20a48c', 1, 0, 'fdsa', 1),
(79, '59a3caf20a48c', 1, 0, 'fdsa', 1),
(80, '59a3caf20a48c', 1, 0, 'fdsa', 1),
(81, '59a3caf20a48c', 1, 0, 'No', 1),
(82, '59a3caf20a48c', 1, 0, '', 1),
(83, '59a3caf20a48c', 1, 0, 'fdsafdsaffdsafdsa', 1),
(84, '59a3caf20a48c', 1, 0, '', 1);
-- --------------------------------------------------------
--
-- 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, 'NEC Enterprise Solutions', '', '', '', '', '', '', '', '', 'contact.hq@emea.nec.com', 'http://localhost:8888/necsl2100.com', '', '', 'https://www.facebook.com/nec.global', 'https://twitter.com/necenterprise', 'https://www.youtube.com/user/NECITPLATFORM', 'https://www.linkedin.com/company/nec-enterprise-solutions/', 'fdsa', '', 20, 1, 1, 0, 0, 4, '1300', '225', 21, 'images/nec-oabw.svg', 'height:24px;margin-bottom:24px;', 'basic', 0, 'Smart Healthcare Transformation', '#ec6706', '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
(1, 'us', 'us'),
(2, 'emea', 'emea');
-- --------------------------------------------------------
--
-- 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,
`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`, `section`, `category`, `position`, `repeat_items`, `active`) VALUES
(1, 'cases', '{cases}', '<div class=\"col8\">\n<div>\n\n<h4>{klant}</h4>\n<h3>{project}</h3>\n<a href=\"{link}\"></a>\n\n</div>\n<img src=\"{img}\" alt=\"\" class=\"item-image\" />\n</div>', 3, 0, 0, 3, 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,
`array` int(1) NOT NULL DEFAULT '0',
`index` 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_fields`
--
INSERT INTO `link_data_fields` (`link_data_field_id`, `template_data_id`, `template`, `field`, `array`, `index`, `active`) VALUES
(1, 1, '{klant}', 'klant', 0, 0, 1),
(2, 1, '{project}', 'project', 0, 0, 1),
(3, 1, '{img}', 'image', 1, 0, 1),
(4, 1, '{link}', 'entry_link', 0, 0, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `order_labels`
--
CREATE TABLE `order_labels` (
`label_id` int(10) NOT NULL,
`order_id` int(10) NOT NULL,
`consignment_id` varchar(255) NOT NULL,
`parcel_id` varchar(255) NOT NULL,
`tracktrace` varchar(255) NOT NULL,
`label` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `page_redirects`
--
CREATE TABLE `page_redirects` (
`redirect_id` int(10) NOT NULL,
`old_url` text CHARACTER SET latin1 NOT NULL,
`new_url` text CHARACTER SET latin1 NOT NULL,
`position` int(10) NOT NULL DEFAULT '0',
`active` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `page_section_content`
--
CREATE TABLE `page_section_content` (
`page_section_id` int(10) NOT NULL,
`page_id` int(10) NOT NULL,
`html` text CHARACTER SET latin1 NOT NULL,
`edittag` varchar(250) CHARACTER SET latin1 NOT NULL,
`datatype` varchar(250) CHARACTER SET latin1 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 CHARACTER SET latin1 NOT NULL,
`css` varchar(250) CHARACTER SET latin1 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 <section id=\"tpuxhcrbfo\" class=\"\"><div class=\"medium-12 columns\">\n<div class=\"column-wrapper\" style=\"\"><h1>Smart Healthcare Transformation</h1>\n\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n</div>\n</div></section>\n \n ', '1-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 0, 0),
(2, 1, '\n <section id=\"rbftiauioz\" class=\"\"><div class=\"image-showcase\">\n<div class=\"showcase-case\" datagroup=\"case\">\n \n<div class=\"case-foreground row expanded\" edittype=\"textarea\">\n <div class=\"small-12 columns\">\n \n <div class=\"row intro-text\">\n <div class=\"small-12 medium-8 medium-offset-1 columns\">\n <div class=\"column-wrapper\" edittype=\"showcase-text\"><ul>\n <li>Improve patient experience</li>\n <li>Information Assurance & Data Security</li>\n <li>Smart Mobility & Availability, Always and everywhere</li>\n <li>Reliable access to tools, information and people</li>\n <li>Comprehensive Security Solutions</li>\n</ul>\n</div>\n </div>\n </div>\n \n </div>\n</div>\n\n<div class=\"column-wrapper case-background\" edittype=\"showcase-image\">\n <img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/nec-transformation/images/smart-healthcare-transformation.jpg\">\n</div>\n \n</div>\n</div>\n</section>\n ', 'showcase', 'showcase', 'smart-transmation', '', 1, 0, '', '', 0, 0, 2, 0, 0),
(3, 1, '\n \n <section id=\"tfvypgmeph\" class=\"\"><div class=\"medium-12 columns\">\n<div class=\"column-wrapper background\" edittype=\"image\" style=\"\"><p><img src=\"http://placehold.it/1200x300&text=IMAGE\">fdsafdsa</p>\n</div>\n</div>\n\n</section>\n \n ', 'Image', 'text', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(4, 1, '<section id=\"geikxuihmz\" class=\"\"><div class=\"image-full-width\">\n <div class=\"column-wrapper background\" edittype=\"image\">\n <img src=\"http://placehold.it/1200x300&text=IMAGE\">\n </div>\n</div></section>', 'img', 'img', '', '', 0, 0, '', '', 0, 0, 4, 0, 0),
(5, 1, '<section id=\"cxgdhpszbh\" class=\"\"><div class=\"small-12 cell\">\n <div class=\"column-wrapper background\" edittype=\"image\">\n <img src=\"http://placehold.it/1200x300&text=IMAGE\">\n </div>\n</div></section>', 'img', 'img', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(6, 1, '\n <section id=\"vpcmupehkh\" class=\"\">\n<div class=\"medium-12 columns\">\n<div class=\"column-wrapper foreground\" edittype=\"text\">\n<p>Text here</p>\n</div> \n<div class=\"column-wrapper background\" edittype=\"image\"><img src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/nec-transformation/images/smart-healthcare-transformation.jpg\"></div>\n</div>\n\n</section>\n ', 'img', 'img', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(7, 1, '<section id=\"pqtqmfigne\" class=\"\">\n<div class=\"medium-12 columns\">\n<div class=\"column-wrapper\" edittype=\"textarea\">\n<p>Text here</p>\n</div> \n<div class=\"column-wrapper background\" edittype=\"image\">\n<img src=\"http://placehold.it/1200x300&text=IMAGE\">\n</div>\n</div>\n\n\n\n</section>', 'img', 'img', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(8, 1, '<section id=\"fbtprbbhkv\" class=\"\"><div class=\"medium-12 columns\">\n<div class=\"column-wrapper\">\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div></section>', '1-column', 'text', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(9, 2, '\n \n <section id=\"aipowqgcvl\" class=\"\"><div class=\"medium-12 columns\">\n<div class=\"column-wrapper\" style=\"\"><h1>Smart Healthcare Transformation</h1>\n\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n</div>\n</div></section>\n \n ', '1-column', 'text', '', '', 1, 0, '', '', 0, 0, 1, 0, 0),
(10, 1, '\n \n <section id=\"fwtsosafwu\" class=\"\"><div class=\"medium-12 columns\">\n<div class=\"column-wrapper\" style=\"\"><ul>\n <li>Improve patient experience</li>\n <li>Information Assurance & Data Security</li>\n <li>Smart Mobility & Availability, Always and everywhere</li>\n <li>Reliable access to tools, information and people</li>\n <li>Comprehensive Security Solutions</li>\n</ul>\n</div>\n</div></section>\n \n ', '1-column', 'text', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(11, 2, '<section id=\"kqwhyiguau\" class=\"\"><div class=\"small-12 medium-6 columns\">\n<div class=\"column-wrapper\">\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n\n<div class=\"small-12 medium-6 columns\">\n<div class=\"column-wrapper\">\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div></section>', '2-column', 'text', '', '', 0, 0, '', '', 0, 0, 2, 0, 0),
(12, 2, '\n <section id=\"btohrobnlc\" class=\"\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-12 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>Smart Healthcare Transformation</h1>\n\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n</div>\n</div>\n</div></section>\n ', '1-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 1, 0),
(13, 2, '\n <section id=\"atpiscuubg\" class=\"\"><div class=\"grid-x grid-padding-x\">\n\n<div class=\"small-12 medium-6 large-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>Smart Healthcare Transformation</h1>\n\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n</div>\n</div>\n\n<div class=\"small-12 medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>Smart Healthcare Transformation</h1>\n\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p>\n\n<p>Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu.</p>\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n</div>\n</div>\n</div></section>\n ', '2-column', 'text', '', '', 0, 0, '', '', 0, 0, 2, 1, 0),
(14, 2, '<section id=\"kouxsiilvm\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', '', 0, 0, '', '', 0, 0, 3, 0, 0),
(15, 2, '\n <section id=\"yugufkbbwa\" class=\"\"><div class=\"grid-x grid-padding-x\">\n\n<div class=\"small-12 medium-6 large-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>AAAAA</h1>\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n</div>\n</div>\n\n<div class=\"small-12 medium-6 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>AAAAA</h1>\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n</div>\n</div>\n</div></section>\n ', '2-column', 'text', '', '', 0, 0, '', '', 0, 14, 3, 1, 0),
(16, 1, '<section id=\"sbntuoqfen\" class=\"\"><div class=\"grid-x grid-padding-x\">\n\n<div class=\"small-12 medium-6 large-6 cell\">\n<div class=\"column-wrapper\">\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n\n<div class=\"small-12 medium-6 cell\">\n<div class=\"column-wrapper\">\n\n<p>In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a,</p>\n\n</div>\n</div>\n</div></section>', '2-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 0, 0),
(17, 1, '\n <section id=\"ooogenamwv\" class=\"\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-12 cell\">\n<div class=\"column-wrapper\" style=\"\"><ul class=\"no-bullet\">\n <li class=\"one\"><a href=\"#\">Improve patient experience</a></li>\n <li class=\"two\"><a href=\"#\">Information Assurance & Data Security</a></li>\n <li class=\"three\"><a href=\"#\">Smart Mobility & Availability, Always and everywhere</a></li>\n <li class=\"four\"><a href=\"#\">Reliable access to tools, information and people</a></li>\n <li class=\"five\"><a href=\"#\">Comprehensive Security Solutions</a></li>\n</ul>\n</div>\n</div>\n</div></section>\n ', '1-column', 'text', '', '', 0, 0, '', '', 0, 0, 1, 1, 0),
(18, 3, '\n \n \n <section id=\"supxuechbs\" class=\"\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-12 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>Better security with facial recognition</h1>\n\n<p>Simple Logon for patients and staff – no more remembering user name and password. Mobile and Website support for logon by facial recognition, Increase usage of patient portals and healthcare website tools Reduces data theft.</p>\n</div>\n</div>\n</div></section>\n \n \n ', '1-column', 'text', '', 'page-intro', 0, 0, '', '', 0, 0, 1, 0, 0),
(19, 3, '\n \n <section id=\"sarecsgcme\" class=\"\"><div class=\"grid-x grid-padding-x\">\n<div class=\"small-12 medium-4 cell\">\n<div class=\"column-wrapper\" style=\"\"><h2>Facial recognition technology</h2>\n\n<p>Dual factor authentication using facial recognition technology improves security for patients and staff, it also simplifies the logon procedure by replacing the username/password thus reduces data theft. <br>\n <br>\nSimplifying the logon procedure for patients and staff helps increases the usage of mobile devices and website portal usage due to the simplicity of facial recognition, thus reducing the paperwork and saving healthcare costs.</p>\n</div>\n</div>\n\n<div class=\"small-12 medium-4 cell\">\n<div class=\"column-wrapper\" style=\"\"><h2>Patient enrollment</h2>\n\n<p>A patient first needs to enroll to take advantage of the dual factor authentication process using the facial recognition technology.</p>\n\n<p>Enrollment can be enabled through a mobile phone or from a PC with web camera. In this case the patient is using his smartphone camera to capture his face and fills out his name and PIN. Now the patient is registered into the system</p>\n</div>\n</div>\n\n<div class=\"small-12 medium-4 cell\">\n<div class=\"column-wrapper\" style=\"\"><h2>Dual factor authentication</h2>\n\n<p>The Enrolled patient logs in using his face from his mobile phone. When the camera is invoked, the camera will detect the patient and perform facial recognition algorithms to match the patients face to a list of patients in the database. Since the patient has pre-enrolled, he or she is recognized and prompted with the PIN. When the correct PIN is entered, he will be verified and granted access. This dual factor authentication can be customized to meet any access requirements.<br>\n </p>\n\n<p> </p>\n</div>\n</div>\n</div></section>\n \n ', '3-column', 'text', '', '', 0, 0, '', '', 0, 0, 2, 0, 0),
(20, 3, '<section id=\"krotebbubt\" class=\"\"><div class=\"section-group\" edittype=\"group\"><div class=\"group-wrapper droppable-in-group\">{contents}</div></div></section>', 'Group', 'veld groep', '', '', 0, 0, '', '', 0, 0, 3, 1, 0),
(21, 3, '\n <section id=\"lwpimshorl\" class=\"\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-12 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>Better security with facial recognition</h1>\n\n<p>Simple Logon for patients and staff – no more remembering user name and password. Mobile and Website support for logon by facial recognition, Increase usage of patient portals and healthcare website tools Reduces data theft.</p>\n</div>\n</div>\n</div></section>\n ', '1-column', 'text', '', 'page-intro', 0, 0, '', '', 0, 20, 3, 1, 0),
(22, 3, '\n \n \n <section id=\"iqoseemwhd\" class=\"\"><div class=\"grid-x grid-padding-x\">\n<div class=\"small-12 medium-4 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><img alt=\"\" class=\"padded-border\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/necsl2100/images/scenarios/on-premises.jpg\"></p>\n\n<h3>Facial recognition technology</h3>\n\n<p>Dual factor authentication using facial recognition technology improves security for patients and staff, it also simplifies the logon procedure by replacing the username/password thus reduces data theft. <br>\n <br>\nSimplifying the logon procedure for patients and staff helps increases the usage of mobile devices and website portal usage due to the simplicity of facial recognition, thus reducing the paperwork and saving healthcare costs.</p>\n</div>\n</div>\n\n<div class=\"small-12 medium-4 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><img alt=\"\" class=\"padded-border\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/necsl2100/images/scenarios/on-premises.jpg\"></p>\n\n<h3>Patient enrollment</h3>\n\n<p>A patient first needs to enroll to take advantage of the dual factor authentication process using the facial recognition technology.</p>\n\n<p>Enrollment can be enabled through a mobile phone or from a PC with web camera. In this case the patient is using his smartphone camera to capture his face and fills out his name and PIN. Now the patient is registered into the system</p>\n</div>\n</div>\n\n<div class=\"small-12 medium-4 cell\">\n<div class=\"column-wrapper\" style=\"\"><p><img alt=\"\" class=\"padded-border\" src=\"https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/necsl2100/images/scenarios/on-premises.jpg\"></p>\n\n<h3>Dual factor authentication</h3>\n\n<p>The Enrolled patient logs in using his face from his mobile phone. When the camera is invoked, the camera will detect the patient and perform facial recognition algorithms to match the patients face to a list of patients in the database. Since the patient has pre-enrolled, he or she is recognized and prompted with the PIN. When the correct PIN is entered, he will be verified and granted access. This dual factor authentication can be customized to meet any access requirements.</p>\n</div>\n</div>\n</div></section>\n \n \n ', '3-column', 'text', '', '', 0, 0, '', '', 0, 20, 3, 1, 0),
(23, 6, '\n <section id=\"gaozycydeh\" class=\"\"><div class=\"grid-x grid-padding-x\">\n<div class=\"medium-12 cell\">\n<div class=\"column-wrapper\" style=\"\"><h1>Comprehensive Access Control Solutions</h1>\n\n<p>Unlike other biometric systems, facial recognition requires no physical or active interaction with the subject, making it one of the least intrusive yet highly accurate biometric modes. It enables faces to be recorded and archived at a distance, act as a crime deterrent, and help identify a person in real-time.</p>\n\n<h2>Enhaunching access control by:</h2>\n</div>\n</div>\n</div></section>\n ', '1-column', 'text', '', '', 0, 0, '', '', 0, 0, 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',
`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`, `kolommen`, `cssid`, `zichtbaar`, `position`, `custom`, `custom_code`, `sort`, `sitelinks`, `categories`, `redirect`, `active`) VALUES
(1, 'home', '', '', '', 2, '', '', 0, 0, 0, '', 0, 0, 0, '', 1),
(2, 'SL2100 in Action', '', '', '', 1, '', '', 0, 2, 0, '', 0, 0, 0, '', 0),
(3, 'Features', '', '', '', 1, '', '', 0, 3, 0, '', 0, 0, 0, '', 0),
(4, 'Phones', '', '', '', 1, '', '', 0, 4, 0, '', 0, 1, 0, '', 0),
(5, 'Applications', '', '', '', 1, '', '', 0, 5, 0, '', 0, 0, 0, '', 0),
(6, 'Contact us', '', '', '', 1, '', '', 0, 7, 0, '', 0, 0, 0, '', 0),
(7, 'EN', '', '', '', 1, '', '', 0, 0, 0, '', 0, 0, 0, '', 0),
(8, 'Resources', '', '', '', 1, '', '', 0, 6, 0, '', 0, 1, 0, '', 0),
(9, 'Calendars', '', '', '', 1, '', '', 0, 9, 0, '', 0, 0, 0, '', 0),
(10, 'Mobility', '', '', '', 1, '', '', 0, 3, 0, '', 0, 1, 0, '', 0),
(11, 'SL2100 Communications System', '', '', '', 1, '', '', 0, 2, 0, '', 0, 1, 0, '', 0),
(12, 'Footer Loopback', '', '', '', 1, '', '', 0, 8, 0, '', 0, 1, 0, '', 0),
(13, 'search', '', '', '', 5, '', '', 0, 3, 0, '', 0, 1, 0, '', 1),
(14, 'Smart Healthcare Transformation', '', '', '', 1, '', '', 1, 1, 0, '', 0, 1, 0, '', 0),
(15, 'Access Control Solutions', '', '', '', 1, '', '', 1, 2, 0, '', 0, 1, 0, '', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `sectie_categories`
--
CREATE TABLE `sectie_categories` (
`sectie_category_id` int(10) NOT NULL,
`sectie_id` int(10) NOT NULL,
`category_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `sectie_templates`
--
CREATE TABLE `sectie_templates` (
`sectie_templates_id` int(10) NOT NULL,
`sectie_id` int(10) NOT NULL,
`template_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `sectie_templates`
--
INSERT INTO `sectie_templates` (`sectie_templates_id`, `sectie_id`, `template_id`) VALUES
(1, 1, 1),
(2, 3, 2),
(3, 2, 1),
(4, 4, 1),
(5, 5, 1),
(6, 6, 1),
(7, 3, 1),
(8, 8, 1),
(9, 9, 1),
(10, 10, 1),
(11, 11, 1),
(12, 12, 3),
(13, 14, 1),
(14, 15, 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, 'default', 0, 0, 1),
(2, 'home', 0, 0, 1),
(3, 'project', 0, 0, 1),
(4, 'features', 0, 0, 1),
(5, 'search', 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_loopback`
--
CREATE TABLE `td_loopback` (
`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,
`language_id` int(10) NOT NULL DEFAULT '0',
`form_id` int(10) NOT NULL,
`stramien_id` int(10) NOT NULL,
`meta_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`meta_desc` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`page_redirect` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
`link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`file` text COLLATE utf8_unicode_ci,
`image` tinytext COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `td_page`
--
CREATE TABLE `td_page` (
`entry_id` int(10) NOT NULL,
`position` int(10) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`last_edit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`template_id` int(10) NOT NULL,
`unique_id` int(10) NOT NULL,
`language_id` int(10) NOT NULL DEFAULT '0',
`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,
`loopback` int(10) DEFAULT NULL,
`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`, `language_id`, `form_id`, `stramien_id`, `meta_title`, `meta_desc`, `page_redirect`, `titel`, `contents`, `loopback`, `image`) VALUES
(1, 0, 1, '2017-11-09 12:46:54', 1, 1, 0, 0, 0, '', '', '', 'Smart Healthcare Transformation', '', 0, ''),
(2, 0, 1, '2017-11-09 15:29:40', 1, 2, 0, 0, 0, '', '', '', 'Smart Healthcare Transformation', '', 0, ''),
(3, 0, 1, '2017-11-10 10:03:51', 1, 3, 0, 0, 0, 'Better security with facial recognition', '', '', 'Better security with facial recognition', '', 0, ''),
(4, 0, 1, '2017-11-10 13:31:35', 1, 4, 0, 0, 0, '', '', '', 'Improving Physical Security ', '', 0, ''),
(5, 0, 1, '2017-11-10 13:31:55', 1, 5, 0, 0, 0, '', '', '', 'More acurate timeclock check-in', '', 0, ''),
(6, 0, 1, '2017-11-14 15:48:16', 1, 6, 0, 0, 0, '', '', '', 'Comprehensive Access Control Solutions', '', 0, 'https://s3.eu-central-1.amazonaws.com/z3r2zxopa4uuqpw5a4ju/nec-transformation/images/access-control-solutions.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),
(2, 'case', 0, 1),
(3, 'loopback', 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,
`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`, `sub_of`, `type`, `overzicht`, `link_to`, `position`, `translate`, `active`) VALUES
(1, 1, 1, 'titel', 'titel', 0, 1, 0, 0, 0, 1, 1),
(2, 1, 46, 'contents', 'contents', 0, 1, 0, 0, 3, 1, 1),
(3, 2, 1, 'klant', 'klant', 0, 1, 0, 0, 0, 0, 1),
(4, 2, 1, 'project', 'project', 0, 1, 0, 0, 1, 0, 1),
(5, 2, 6, 'image', 'image', 0, 1, 0, 0, 2, 0, 1),
(6, 0, 0, '58b7dd857ed9e', '', 0, 1, 0, 0, 0, 0, 1),
(7, 0, 0, '58b7dd8f9da99', '', 0, 1, 0, 0, 0, 0, 1),
(8, 0, 0, '58b82228f26e1', '', 0, 1, 0, 0, 0, 0, 1),
(9, 0, 0, '58b822341ad40', '', 0, 1, 0, 0, 0, 0, 1),
(10, 0, 0, '58b8248a5b3b4', '', 0, 1, 0, 0, 0, 0, 1),
(11, 0, 0, '58b824921d0fc', '', 0, 1, 0, 0, 0, 0, 1),
(12, 0, 0, '58e639bd3aebe', '', 0, 1, 0, 0, 0, 0, 1),
(13, 0, 0, '58e639bdf277b', '', 0, 1, 0, 0, 0, 0, 1),
(15, 0, 0, '58e639c410993', '', 0, 1, 0, 0, 0, 0, 1),
(14, 0, 0, '58e639c1c7f3b', '', 0, 1, 0, 0, 0, 0, 1),
(16, 0, 0, '58e639c6d9426', '', 0, 1, 0, 0, 0, 0, 1),
(17, 0, 0, '58e639c9a93f0', '', 0, 1, 0, 0, 0, 0, 1),
(20, 0, 0, '58e63a3b45772', '', 0, 1, 0, 0, 0, 0, 1),
(18, 0, 0, '58e639dab9a8b', '', 0, 1, 0, 0, 0, 0, 1),
(19, 0, 0, '58e639ecd5022', '', 0, 1, 0, 0, 0, 0, 1),
(21, 0, 0, '58e63a425da78', '', 0, 1, 0, 0, 0, 0, 1),
(22, 0, 0, '58e63a46c76c4', '', 0, 1, 0, 0, 0, 0, 1),
(23, 0, 0, '58e63c842f7da', '', 0, 1, 0, 0, 0, 0, 1),
(24, 3, 1, 'title', 'title', 0, 1, 0, 0, 0, 0, 1),
(25, 3, 5, 'text', 'text', 0, 1, 0, 0, 0, 0, 1),
(26, 3, 12, 'link', 'link', 0, 1, 0, 0, 0, 0, 1),
(27, 3, 29, 'file', 'file', 0, 1, 0, 0, 0, 0, 1),
(28, 3, 6, 'image', 'image', 0, 1, 0, 0, 0, 0, 1),
(29, 0, 0, '5930256aa416f', '', 0, 1, 0, 0, 0, 0, 1),
(30, 0, 0, '5930256f2f16c', '', 0, 1, 0, 0, 0, 0, 1),
(31, 1, 24, 'loopback', 'loopback', 0, 1, 0, 0, 2, 1, 0),
(32, 1, 6, 'image', 'image', 0, 1, 0, 0, 1, 0, 1),
(33, 0, 0, '5a0b10a08717f', '', 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, '2017-11-09 12:46:54', '0000-00-00 00:00:00', 'Smart Healthcare Transformation', 'smart-healthcare-transformation'),
(2, 14, 1, 2, 0, 0, 0, 0, '2017-11-09 15:29:40', '0000-00-00 00:00:00', 'Smart Healthcare Transformation', 'smart-healthcare-transformation'),
(3, 15, 1, 3, 2, 0, 0, 0, '2017-11-09 23:00:00', '2017-11-14 16:11:58', 'Better security with facial recognition', 'better-security-with-facial-recognition'),
(4, 15, 1, 4, 2, 1, 0, 0, '2017-11-09 23:00:00', '2017-11-14 15:50:44', 'Improving Physical Security', 'improving-physical-security'),
(5, 15, 1, 5, 2, 2, 0, 0, '2017-11-09 23:00:00', '2017-11-14 15:50:50', 'More acurate timeclock check-in', 'more-acurate-timeclock-check-in'),
(6, 15, 1, 6, 2, 0, 0, 0, '2017-11-13 23:00:00', '2017-11-14 15:50:13', 'Comprehensive Access Control Solutions', 'comprehensive-access-control-solutions');
-- --------------------------------------------------------
--
-- 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`),
ADD KEY `module_entry_id` (`entry_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_loopback`
--
ALTER TABLE `td_loopback`
ADD PRIMARY KEY (`entry_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=4;
--
-- AUTO_INCREMENT voor een tabel `category_posities`
--
ALTER TABLE `category_posities`
MODIFY `category_positie_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `choice_options`
--
ALTER TABLE `choice_options`
MODIFY `choice_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `custom_css`
--
ALTER TABLE `custom_css`
MODIFY `custom_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT voor een tabel `entry_categories`
--
ALTER TABLE `entry_categories`
MODIFY `entry_category_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- 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=69;
--
-- 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) UNSIGNED 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=66;
--
-- AUTO_INCREMENT voor een tabel `forms`
--
ALTER TABLE `forms`
MODIFY `form_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `form_elements`
--
ALTER TABLE `form_elements`
MODIFY `form_element_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- 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=21;
--
-- AUTO_INCREMENT voor een tabel `form_response`
--
ALTER TABLE `form_response`
MODIFY `form_response_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;
--
-- 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=3;
--
-- AUTO_INCREMENT voor een tabel `link_data`
--
ALTER TABLE `link_data`
MODIFY `link_data_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 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=5;
--
-- 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=24;
--
-- 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=16;
--
-- 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=15;
--
-- AUTO_INCREMENT voor een tabel `stramiens`
--
ALTER TABLE `stramiens`
MODIFY `stramien_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT voor een tabel `synoniemen`
--
ALTER TABLE `synoniemen`
MODIFY `synoniem_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `synoniemen_default`
--
ALTER TABLE `synoniemen_default`
MODIFY `default_syn_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `tags`
--
ALTER TABLE `tags`
MODIFY `tag_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `td_loopback`
--
ALTER TABLE `td_loopback`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `td_page`
--
ALTER TABLE `td_page`
MODIFY `entry_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT voor een tabel `templates`
--
ALTER TABLE `templates`
MODIFY `template_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT voor een tabel `template_fields`
--
ALTER TABLE `template_fields`
MODIFY `template_field_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
--
-- 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=7;
--
-- 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;