-- https://www.phpmyadmin.net/
--
-- Gegenereerd op: 22 nov 2021 om 13:53
-- Serverversie: 5.7.33-0ubuntu0.16.04.1-log
-- PHP-versie: 7.1.33

START TRANSACTION;



--
-- Database: `jorden_albertheijn`
--

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `action_events`
--

CREATE TABLE `action_events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actionable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actionable_id` bigint(20) UNSIGNED NOT NULL,
  `target_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED DEFAULT NULL,
  `fields` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'running',
  `exception` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `original` text COLLATE utf8mb4_unicode_ci,
  `changes` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Gegevens worden geëxporteerd voor tabel `action_events`
--

INSERT INTO `action_events` (`id`, `batch_id`, `user_id`, `name`, `actionable_type`, `actionable_id`, `target_type`, `target_id`, `model_type`, `model_id`, `fields`, `status`, `exception`, `created_at`, `updated_at`, `original`, `changes`) VALUES
(1, '94d418e4-7922-4aee-9df2-5c815cf5629a', 1, 'Create', 'App\\Article', 1, 'App\\Article', 1, 'App\\Article', 1, '', 'finished', '', '2021-11-08 14:51:56', '2021-11-08 14:51:56', NULL, '{\"title\":\"test\",\"content\":\"egrewg\",\"bron\":null,\"image\":\"YeyKK1ns2ajlSxwwpMSOdZ6eBEdOHCycu1icoAH5.png\",\"created_at\":\"2021-11-08 15:51:56\",\"id\":1}'),
(2, '94d7eb4a-5bb7-46b9-91e2-c69f0796774a', 1, 'Update', 'App\\ArticleType', 1, 'App\\ArticleType', 1, 'App\\ArticleType', 1, '', 'finished', '', '2021-11-10 12:27:43', '2021-11-10 12:27:43', '{\"color\":\"red\"}', '{\"color\":\"#FF0000\"}'),
(3, '94d7f900-d279-444c-b549-a1d01b0b148c', 1, 'Update', 'App\\ArticleType', 1, 'App\\ArticleType', 1, 'App\\ArticleType', 1, '', 'finished', '', '2021-11-10 13:06:04', '2021-11-10 13:06:04', '{\"icon\":\"n.v.t\"}', '{\"icon\":\"far fa-address-book\"}'),
(4, '94d813ae-c85c-444c-bdd9-d8d06b6fb601', 1, 'Update', 'App\\Article', 1, 'App\\Article', 1, 'App\\Article', 1, '', 'finished', '', '2021-11-10 14:20:40', '2021-11-10 14:20:40', '{\"bron\":null,\"image\":\"YeyKK1ns2ajlSxwwpMSOdZ6eBEdOHCycu1icoAH5.png\"}', '{\"bron\":\"www.google.com\",\"image\":\"9GI9PpZb3TqekJkzoDRxl8JigzgJFYFwZdEfQto7.png\"}'),
(5, '94d8193b-e7fc-4853-8d80-d3265e354e97', 1, 'Update', 'App\\Article', 1, 'App\\Article', 1, 'App\\Article', 1, '', 'finished', '', '2021-11-10 14:36:12', '2021-11-10 14:36:12', '{\"image\":\"9GI9PpZb3TqekJkzoDRxl8JigzgJFYFwZdEfQto7.png\"}', '{\"image\":\"91pgf502QA7YKb7VhNgtHbGinLKeH6XyyrhRnOad.png\"}'),
(6, '94d81a13-9be8-46e9-8c69-a1060852544c', 1, 'Update', 'App\\Article', 1, 'App\\Article', 1, 'App\\Article', 1, '', 'finished', '', '2021-11-10 14:38:33', '2021-11-10 14:38:33', '{\"image\":\"91pgf502QA7YKb7VhNgtHbGinLKeH6XyyrhRnOad.png\"}', '{\"image\":\"article_images\\/vhF2gKTX1u8Oz8SprVTH5JmSY3ghDyfbPrZ3iC6f.png\"}'),
(7, '94d81bf8-fbec-4b04-b55a-7561f3cf211f', 1, 'Update', 'App\\Article', 1, 'App\\Article', 1, 'App\\Article', 1, '', 'finished', '', '2021-11-10 14:43:51', '2021-11-10 14:43:51', '{\"image\":\"article_images\\/vhF2gKTX1u8Oz8SprVTH5JmSY3ghDyfbPrZ3iC6f.png\"}', '{\"image\":\"article_images\\/qnfNshbSxFMdcXn8PYOOB5jGflEgFGf2FChk3u6f.png\"}'),
(8, '94d81f7f-1a36-4d9c-9140-6218955b6319', 1, 'Update', 'App\\ArticleType', 1, 'App\\ArticleType', 1, 'App\\ArticleType', 1, '', 'finished', '', '2021-11-10 14:53:42', '2021-11-10 14:53:42', '{\"color\":\"#FF0000\",\"icon\":\"far fa-address-book\"}', '{\"color\":\"#FF7000\",\"icon\":\"fab fa-blogger\"}'),
(9, '94d81ffb-f561-4de9-8518-9d0e9e1940e4', 1, 'Create', 'App\\ArticleType', 2, 'App\\ArticleType', 2, 'App\\ArticleType', 2, '', 'finished', '', '2021-11-10 14:55:04', '2021-11-10 14:55:04', NULL, '{\"name\":\"actie\",\"color\":\"#000000\",\"icon\":\"fab fa-cc-discover\",\"created_at\":\"2021-11-10 15:55:04\",\"id\":2}'),
(10, '94d82021-1d74-4493-9491-481a8810912a', 1, 'Update', 'App\\ArticleType', 2, 'App\\ArticleType', 2, 'App\\ArticleType', 2, '', 'finished', '', '2021-11-10 14:55:28', '2021-11-10 14:55:28', '{\"color\":\"#000000\"}', '{\"color\":\"#B7E6B3\"}'),
(11, '94d82025-7b02-4170-b0d1-91a3f135386c', 1, 'Update', 'App\\ArticleType', 2, 'App\\ArticleType', 2, 'App\\ArticleType', 2, '', 'finished', '', '2021-11-10 14:55:31', '2021-11-10 14:55:31', '{\"color\":\"#B7E6B3\"}', '{\"color\":\"#4ABF40\"}'),
(12, '94d8264c-876b-4b89-9dab-66bd2fc37654', 1, 'Update', 'App\\Article', 1, 'App\\Article', 1, 'App\\Article', 1, '', 'finished', '', '2021-11-10 15:12:43', '2021-11-10 15:12:43', '{\"content\":\"egrewg\",\"image\":\"article_images\\/qnfNshbSxFMdcXn8PYOOB5jGflEgFGf2FChk3u6f.png\"}', '{\"content\":\"Curabitur aliquet quam id dui posuere blandit. Curabitur aliquet quam id dui posuere blandit. Pellentesque in ipsum id orci porta dapibus. Sed porttitor lectus nibh. Vivamus suscipit tortor eget felis porttitor volutpat.\\n\\nVivamus suscipit tortor eget felis porttitor volutpat. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Nulla quis lorem ut libero malesuada feugiat. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui.\\n\\nCurabitur non nulla sit amet nisl tempus convallis quis ac lectus. Nulla porttitor accumsan tincidunt. Cras ultricies ligula sed magna dictum porta. Cras ultricies ligula sed magna dictum porta. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula.\",\"image\":\"article_images\\/LnbdoakcMWdJNavXWt1MLLTvcyAsekFCFaZIUHEm.png\"}'),
(13, '94d8c591-5854-4963-b6c8-675813e9323f', 1, 'Update', 'App\\Article', 1, 'App\\Article', 1, 'App\\Article', 1, '', 'finished', '', '2021-11-10 22:38:04', '2021-11-10 22:38:04', '{\"article_type_id\":1}', '{\"article_type_id\":2}'),
(14, '94d8c789-923a-4dd8-8734-3ff6cc01a430', 1, 'Update', 'App\\Article', 1, 'App\\Article', 1, 'App\\Article', 1, '', 'finished', '', '2021-11-10 22:43:35', '2021-11-10 22:43:35', '{\"article_type_id\":2}', '{\"article_type_id\":1}'),
(15, '94d8c792-54ba-4b63-ad67-1c48223a718a', 1, 'Update', 'App\\Article', 1, 'App\\Article', 1, 'App\\Article', 1, '', 'finished', '', '2021-11-10 22:43:41', '2021-11-10 22:43:41', '{\"article_type_id\":1}', '{\"article_type_id\":2}'),
(16, '94dbcbc6-3235-44a1-b5f7-d6878ff4b87a', 1, 'Create', 'App\\ArticleType', 3, 'App\\ArticleType', 3, 'App\\ArticleType', 3, '', 'finished', '', '2021-11-12 10:42:55', '2021-11-12 10:42:55', NULL, '{\"name\":\"nieuws\",\"color\":\"#FE2525\",\"icon\":\"fas fa-address-book\",\"created_at\":\"2021-11-12 11:42:55\",\"id\":3}'),
(17, '94dbcbec-fa0f-45be-b4f8-974efc77f78d', 1, 'Create', 'App\\Article', 2, 'App\\Article', 2, 'App\\Article', 2, '', 'finished', '', '2021-11-12 10:43:20', '2021-11-12 10:43:20', NULL, '{\"title\":\"nieuws bericht\",\"content\":\"sdafsafsdfdgds\",\"bron\":null,\"image\":\"article_images\\/ilh3mXAkvV7VQK3pK9dyR8OTodkSc8vmSpXgYqo8.png\",\"article_type_id\":3,\"created_at\":\"2021-11-12 11:43:20\",\"id\":2}'),
(18, '94de0dbb-38eb-4985-a414-3123dcbead19', 1, 'Create', 'App\\ArticleType', 4, 'App\\ArticleType', 4, 'App\\ArticleType', 4, '', 'finished', '', '2021-11-13 13:39:00', '2021-11-13 13:39:00', NULL, '{\"name\":\"blog\",\"color\":\"#3192E3\",\"icon\":\"far fa-newspaper\",\"created_at\":\"2021-11-13 14:38:58\",\"id\":4}'),
(19, '94de0dd5-d473-43c1-97f7-72eb05f664c0', 1, 'Create', 'App\\Article', 3, 'App\\Article', 3, 'App\\Article', 3, '', 'finished', '', '2021-11-13 13:39:17', '2021-11-13 13:39:17', NULL, '{\"title\":\"Gezond fruit  wordt steeds goedkoper\",\"content\":\"Pellentesque in ipsum id orci porta dapibus. Nulla porttitor accumsan tincidunt. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Vivamus suscipit tortor eget felis porttitor volutpat. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Vivamus suscipit tortor eget felis porttitor volutpat. Donec rutrum congue leo eget malesuada. Sed porttitor lectus nibh. Nulla porttitor accumsan tincidunt.\\n\\nPraesent sapien massa, convallis a pellentesque nec, egestas non nisi. Nulla porttitor accumsan tincidunt. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Vivamus suscipit tortor eget felis porttitor volutpat. Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Nulla quis lorem ut libero malesuada feugiat. Donec rutrum congue leo eget malesuada. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Sed porttitor lectus nibh.\",\"bron\":\"https:\\/\\/www.ah.nl\\/\",\"image\":\"article_images\\/YXKpwXVQLn3CeBnJ8bgqcGSzo9wXseBJgwkzCLYT.jpeg\",\"article_type_id\":2,\"created_at\":\"2021-11-13 14:39:17\",\"id\":3}'),
(20, '94de0dde-5ecc-4bb4-9ecd-38c512bcc5b5', 1, 'Update', 'App\\Article', 3, 'App\\Article', 3, 'App\\Article', 3, '', 'finished', '', '2021-11-13 13:39:23', '2021-11-13 13:39:23', '{\"article_type_id\":2}', '{\"article_type_id\":4}'),
(21, '94e21e4e-b388-4042-8418-023fdeb591ee', 1, 'Create', 'OptimistDigital\\NovaPageManager\\Models\\Page', 1, 'OptimistDigital\\NovaPageManager\\Models\\Page', 1, 'OptimistDigital\\NovaPageManager\\Models\\Page', 1, '', 'finished', '', '2021-11-15 14:08:39', '2021-11-15 14:08:39', NULL, '{\"name\":\"Nieuws &acties\",\"slug\":\"nieuws-acties\",\"parent_id\":null,\"template\":\"nieuws_acties\",\"locale\":\"en\",\"updated_at\":\"2021-11-15T15:08:39.000000Z\",\"created_at\":\"2021-11-15T15:08:39.000000Z\",\"id\":1,\"path\":\"\\/nieuws-acties\"}'),
(22, '94e22287-dee8-4067-92ad-6b989620acab', 1, 'Create', 'OptimistDigital\\NovaPageManager\\Models\\Page', 2, 'OptimistDigital\\NovaPageManager\\Models\\Page', 2, 'OptimistDigital\\NovaPageManager\\Models\\Page', 2, '', 'finished', '', '2021-11-15 14:20:28', '2021-11-15 14:20:28', NULL, '{\"name\":\"Homepage\",\"slug\":\"home\",\"parent_id\":null,\"template\":\"Homepage\",\"locale\":\"nl\",\"updated_at\":\"2021-11-15T15:20:28.000000Z\",\"created_at\":\"2021-11-15T15:20:28.000000Z\",\"id\":2,\"path\":\"\\/home\"}'),
(23, '94e227ce-b395-4d92-b23d-94d9bf3d417f', 1, 'Create', 'OptimistDigital\\NovaPageManager\\Models\\Page', 3, 'OptimistDigital\\NovaPageManager\\Models\\Page', 3, 'OptimistDigital\\NovaPageManager\\Models\\Page', 3, '', 'finished', '', '2021-11-15 14:35:13', '2021-11-15 14:35:13', NULL, '{\"name\":\"test\",\"slug\":\"test\",\"parent_id\":null,\"template\":\"nieuws_acties\",\"locale\":\"nl\",\"updated_at\":\"2021-11-15T15:35:13.000000Z\",\"created_at\":\"2021-11-15T15:35:13.000000Z\",\"id\":3,\"path\":\"\\/test\"}'),
(24, '94e22825-e7f4-4c11-81de-b3771da0dbc4', 1, 'Create', 'OptimistDigital\\NovaPageManager\\Models\\Page', 4, 'OptimistDigital\\NovaPageManager\\Models\\Page', 4, 'OptimistDigital\\NovaPageManager\\Models\\Page', 4, '', 'finished', '', '2021-11-15 14:36:10', '2021-11-15 14:36:10', NULL, '{\"name\":\"Homepage\",\"slug\":\"home\",\"parent_id\":null,\"template\":\"Homepage\",\"locale\":\"nl\",\"updated_at\":\"2021-11-15T15:36:10.000000Z\",\"created_at\":\"2021-11-15T15:36:10.000000Z\",\"id\":4,\"path\":\"\\/home\"}'),
(25, '94e22a14-533d-4132-a3e4-3ac8fb857cfe', 1, 'Update', 'OptimistDigital\\NovaPageManager\\Models\\Page', 4, 'OptimistDigital\\NovaPageManager\\Models\\Page', 4, 'OptimistDigital\\NovaPageManager\\Models\\Page', 4, '', 'finished', '', '2021-11-15 14:41:34', '2021-11-15 14:41:34', '{\"data\":null}', '{\"data\":\"{\\\"main\\\":[{\\\"layout\\\":\\\"banner\\\",\\\"key\\\":\\\"HG1iCEMyWBqUCX7A\\\",\\\"attributes\\\":{\\\"title\\\":\\\"Mainbanner\\\",\\\"image\\\":\\\"1\\\",\\\"images\\\":[],\\\"call_to_action\\\":[]}}],\\\"meta_title\\\":\\\"test\\\",\\\"meta_description\\\":null,\\\"meta_keywords\\\":null,\\\"meta_robots\\\":null}\"}'),
(26, '94e9fecb-d2dc-4a0c-a650-37691d7e12a5', 1, 'Delete', 'OptimistDigital\\NovaPageManager\\Models\\Page', 3, 'OptimistDigital\\NovaPageManager\\Models\\Page', 3, 'OptimistDigital\\NovaPageManager\\Models\\Page', 3, '', 'finished', '', '2021-11-19 12:07:10', '2021-11-19 12:07:10', NULL, NULL),
(27, '94f0183c-bb3f-4e6f-8f30-d1d8dfc2a4d7', 1, 'Create', 'App\\User', 2, 'App\\User', 2, 'App\\User', 2, '', 'finished', '', '2021-11-22 12:53:17', '2021-11-22 12:53:17', NULL, '{\"name\":\"nanveen\",\"email\":\"naveen@sdi.la\",\"updated_at\":\"2021-11-22T13:53:16.000000Z\",\"created_at\":\"2021-11-22T13:53:16.000000Z\",\"id\":2}');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `articles`
--

CREATE TABLE `articles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `bron` longtext COLLATE utf8mb4_unicode_ci,
  `image` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `article_type_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Gegevens worden geëxporteerd voor tabel `articles`
--

INSERT INTO `articles` (`id`, `title`, `content`, `bron`, `image`, `deleted_at`, `created_at`, `updated_at`, `article_type_id`) VALUES
(1, 'test', 'Curabitur aliquet quam id dui posuere blandit. Curabitur aliquet quam id dui posuere blandit. Pellentesque in ipsum id orci porta dapibus. Sed porttitor lectus nibh. Vivamus suscipit tortor eget felis porttitor volutpat.\n\nVivamus suscipit tortor eget felis porttitor volutpat. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Nulla quis lorem ut libero malesuada feugiat. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui.\n\nCurabitur non nulla sit amet nisl tempus convallis quis ac lectus. Nulla porttitor accumsan tincidunt. Cras ultricies ligula sed magna dictum porta. Cras ultricies ligula sed magna dictum porta. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula.', 'https://www.google.com/', 'article_images/LnbdoakcMWdJNavXWt1MLLTvcyAsekFCFaZIUHEm.png', NULL, '2021-11-08 14:51:56', '2021-11-10 22:43:41', 2),
(2, 'nieuws bericht', 'sdafsafsdfdgds', NULL, 'article_images/ilh3mXAkvV7VQK3pK9dyR8OTodkSc8vmSpXgYqo8.png', NULL, '2021-11-12 10:43:20', '2021-11-12 10:43:20', 3),
(3, 'Gezond fruit  wordt steeds goedkoper', 'Pellentesque in ipsum id orci porta dapibus. Nulla porttitor accumsan tincidunt. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Vivamus suscipit tortor eget felis porttitor volutpat. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Vivamus suscipit tortor eget felis porttitor volutpat. Donec rutrum congue leo eget malesuada. Sed porttitor lectus nibh. Nulla porttitor accumsan tincidunt.\n\nPraesent sapien massa, convallis a pellentesque nec, egestas non nisi. Nulla porttitor accumsan tincidunt. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Vivamus suscipit tortor eget felis porttitor volutpat. Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Nulla quis lorem ut libero malesuada feugiat. Donec rutrum congue leo eget malesuada. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Sed porttitor lectus nibh.', 'https://www.ah.nl/', 'article_images/YXKpwXVQLn3CeBnJ8bgqcGSzo9wXseBJgwkzCLYT.jpeg', NULL, '2021-11-13 13:39:17', '2021-11-13 13:39:23', 4);

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `article_types`
--

CREATE TABLE `article_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Gegevens worden geëxporteerd voor tabel `article_types`
--

INSERT INTO `article_types` (`id`, `name`, `color`, `icon`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'test', '#FF7000', 'fab fa-blogger', NULL, NULL, '2021-11-10 14:53:42'),
(2, 'actie', '#4ABF40', 'fab fa-cc-discover', NULL, '2021-11-10 14:55:04', '2021-11-10 14:55:31'),
(3, 'nieuws', '#FE2525', 'fas fa-address-book', NULL, '2021-11-12 10:42:55', '2021-11-12 10:42:55'),
(4, 'blog', '#3192E3', 'far fa-newspaper', NULL, '2021-11-13 13:38:58', '2021-11-13 13:38:58');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Gegevens worden geëxporteerd voor tabel `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2018_01_01_000000_create_action_events_table', 1),
(4, '2019_05_10_000000_add_fields_to_action_events_table', 1),
(11, '2021_11_08_140131_create_article_types_table', 2),
(12, '2021_11_08_140132_create_articles_table', 2),
(13, '2021_11_08_142756_add_foreign_key_articles', 2),
(14, '2019_03_13_000000_create_page_manager_tables', 3),
(15, '2019_04_18_000001_add_child_parent_relationships', 3),
(16, '2019_04_24_000002_create_region_and_pages_tables', 3),
(17, '2019_05_03_000003_make_slug_locale_pair_unique', 3),
(18, '2019_06_10_000004_add_draft_fields_to_page', 3),
(19, '2019_11_29_000005_make_slug_locale_published_parent_id_pair_unique', 3),
(20, '2019_11_29_000006_make_seo_fields_longer', 3),
(21, '2020_01_01_000000_create_nova_media_library_table', 4);

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `nova_media_library`
--

CREATE TABLE `nova_media_library` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `folder` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `private` tinyint(1) NOT NULL DEFAULT '0',
  `lp` tinyint(1) NOT NULL DEFAULT '0',
  `options` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Gegevens worden geëxporteerd voor tabel `nova_media_library`
--

INSERT INTO `nova_media_library` (`id`, `title`, `created`, `type`, `folder`, `name`, `private`, `lp`, `options`) VALUES
(1, 'ahonline_largeBanner', '2021-11-15 14:41:01', 'Image', '/', 'ahonline-largebanner-16369908611wUsS.jfif', 0, 0, '{\"mime\":\"image\",\"wh\":[1440,300],\"size\":\"47.31 kb\",\"img_sizes\":[\"thumb\",\"medium\"]}');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `nova_page_manager_regions`
--

CREATE TABLE `nova_page_manager_regions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale_parent_id` bigint(20) DEFAULT NULL,
  `data` json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexen voor geëxporteerde tabellen
--

--
-- Indexen voor tabel `action_events`
--
ALTER TABLE `action_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `action_events_actionable_type_actionable_id_index` (`actionable_type`,`actionable_id`),
  ADD KEY `action_events_batch_id_model_type_model_id_index` (`batch_id`,`model_type`,`model_id`),
  ADD KEY `action_events_user_id_index` (`user_id`);

--
-- Indexen voor tabel `articles`
--
ALTER TABLE `articles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `articles_article_type_id_foreign` (`article_type_id`);

--
-- Indexen voor tabel `article_types`
--
ALTER TABLE `article_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexen voor tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexen voor tabel `nova_media_library`
--
ALTER TABLE `nova_media_library`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nova_media_library_title_index` (`title`),
  ADD KEY `nova_media_library_created_index` (`created`),
  ADD KEY `nova_media_library_type_index` (`type`),
  ADD KEY `nova_media_library_folder_index` (`folder`);

--
-- Indexen voor tabel `nova_page_manager_regions`
--
ALTER TABLE `nova_page_manager_regions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nova_page_manager_locale_template` (`locale`,`template`);

--
-- AUTO_INCREMENT voor geëxporteerde tabellen
--

--
-- AUTO_INCREMENT voor een tabel `action_events`
--
ALTER TABLE `action_events`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT voor een tabel `articles`
--
ALTER TABLE `articles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT voor een tabel `article_types`
--
ALTER TABLE `article_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT voor een tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT voor een tabel `nova_media_library`
--
ALTER TABLE `nova_media_library`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT voor een tabel `nova_page_manager_regions`
--
ALTER TABLE `nova_page_manager_regions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Beperkingen voor geëxporteerde tabellen
--

--
-- Beperkingen voor tabel `articles`
--
ALTER TABLE `articles`
  ADD CONSTRAINT `articles_article_type_id_foreign` FOREIGN KEY (`article_type_id`) REFERENCES `article_types` (`id`);
COMMIT;

