File: D:/HostingSpaces/SBogers10/reiskick.komma.nl/20200622-23-28-reiskick.sql
# ************************************************************
# Sequel Pro SQL dump
# Version 5446
#
# https://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 8.0.19)
# Database: reiskick
# Generation Time: 2020-06-22 21:28:05 +0000
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table action_logs
# ------------------------------------------------------------
DROP TABLE IF EXISTS `action_logs`;
CREATE TABLE `action_logs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`authenticatable_id` int unsigned DEFAULT NULL,
`authenticatable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`payload` blob,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `action_logs` WRITE;
/*!40000 ALTER TABLE `action_logs` DISABLE KEYS */;
INSERT INTO `action_logs` (`id`, `authenticatable_id`, `authenticatable_type`, `action`, `payload`, `created_at`, `updated_at`)
VALUES
(1,1,'Komma\\KMS\\Users\\Models\\KmsUser','Logged in successfully at the kms end',NULL,'2020-06-14 22:04:21','2020-06-14 22:04:21'),
(2,1,'Komma\\KMS\\Users\\Models\\KmsUser','Logged in successfully at the kms end',NULL,'2020-06-16 20:41:01','2020-06-16 20:41:01'),
(3,1,'Komma\\KMS\\Users\\Models\\KmsUser','Logged in successfully at the kms end',NULL,'2020-06-16 20:53:10','2020-06-16 20:53:10'),
(4,1,'Komma\\KMS\\Users\\Models\\KmsUser','Logged in successfully at the kms end',NULL,'2020-06-20 14:57:27','2020-06-20 14:57:27');
/*!40000 ALTER TABLE `action_logs` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table component_areas
# ------------------------------------------------------------
DROP TABLE IF EXISTS `component_areas`;
CREATE TABLE `component_areas` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`code_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`componentable_id` bigint unsigned NOT NULL,
`componentable_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table componentable_types
# ------------------------------------------------------------
DROP TABLE IF EXISTS `componentable_types`;
CREATE TABLE `componentable_types` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`component_type_id` bigint unsigned NOT NULL,
`componentable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`model_collection_provider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table components
# ------------------------------------------------------------
DROP TABLE IF EXISTS `components`;
CREATE TABLE `components` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`component_type_id` bigint unsigned NOT NULL,
`component_area_id` bigint unsigned NOT NULL,
`sort_order` int unsigned NOT NULL,
`version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`data` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `components_component_area_id_foreign` (`component_area_id`),
CONSTRAINT `components_component_area_id_foreign` FOREIGN KEY (`component_area_id`) REFERENCES `component_areas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table countries
# ------------------------------------------------------------
DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`active` tinyint(1) NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`continent` tinyint unsigned DEFAULT NULL,
`map_iso` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`home_grid_position` tinyint unsigned DEFAULT NULL,
`lft` int DEFAULT NULL,
`rgt` int DEFAULT NULL,
`tree` int DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` (`id`, `active`, `name`, `slug`, `continent`, `map_iso`, `home_grid_position`, `lft`, `rgt`, `tree`, `created_at`, `updated_at`)
VALUES
(2,0,'','',NULL,NULL,NULL,1,14,1,'2020-06-16 21:47:56','2020-06-16 21:47:56'),
(3,1,'Marokko','marokko-1',3,'MA',4,2,3,1,'2020-06-16 21:51:00','2020-06-20 16:52:13'),
(4,1,'Finland','finland',3,'FI',5,4,5,1,'2020-06-16 22:07:48','2020-06-20 16:30:00'),
(5,1,'Kroatië','kroatie-1',3,'HR',1,6,7,1,'2020-06-20 16:04:12','2020-06-20 16:30:07'),
(6,1,'Tanzania','tanzania',3,'TZ',2,8,9,1,'2020-06-20 16:07:56','2020-06-20 16:30:13'),
(7,1,'Sri Lanka','sri-lanka',3,'LK',3,10,11,1,'2020-06-20 16:09:22','2020-06-20 16:30:19'),
(8,1,'Bolivia','bolivia',3,'BO',6,12,13,1,'2020-06-20 16:11:32','2020-06-20 16:30:30');
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table documents
# ------------------------------------------------------------
DROP TABLE IF EXISTS `documents`;
CREATE TABLE `documents` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`file_system_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`mime_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sort_order` int DEFAULT NULL,
`documentable_id` bigint unsigned DEFAULT NULL,
`documentable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`thumb_image_url` mediumtext COLLATE utf8_unicode_ci,
`small_image_url` mediumtext COLLATE utf8_unicode_ci,
`medium_image_url` mediumtext COLLATE utf8_unicode_ci,
`large_image_url` mediumtext COLLATE utf8_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `documents` WRITE;
/*!40000 ALTER TABLE `documents` DISABLE KEYS */;
INSERT INTO `documents` (`id`, `key`, `name`, `file_system_path`, `mime_type`, `sort_order`, `documentable_id`, `documentable_type`, `thumb_image_url`, `small_image_url`, `medium_image_url`, `large_image_url`, `created_at`, `updated_at`)
VALUES
(1,'Documents-country','marokko','/uploads/country/marokko-040379200-1592337048.jpg','image/jpeg',1,3,'App\\Countries\\Country','/uploads/country/marokko-040379200-1592337048_thumb.jpg','/uploads/country/marokko-040379200-1592337048_small.jpg','/uploads/country/marokko-040379200-1592337048_medium.jpg','/uploads/country/marokko-040379200-1592337048_large.jpg','2020-06-16 21:50:49','2020-06-16 21:51:00'),
(2,'Documents-country','lapland','/uploads/country/lapland-092503600-1592338047.jpg','image/jpeg',1,4,'App\\Countries\\Country','/uploads/country/lapland-092503600-1592338047_thumb.jpg','/uploads/country/lapland-092503600-1592338047_small.jpg','/uploads/country/lapland-092503600-1592338047_medium.jpg','/uploads/country/lapland-092503600-1592338047_large.jpg','2020-06-16 22:07:28','2020-06-16 22:07:48'),
(4,'Documents-country','tanzania','/uploads/country/tanzania-078870000-1592662044.jpg','image/jpeg',1,6,'App\\Countries\\Country','/uploads/country/tanzania-078870000-1592662044_thumb.jpg','/uploads/country/tanzania-078870000-1592662044_small.jpg','/uploads/country/tanzania-078870000-1592662044_medium.jpg','/uploads/country/tanzania-078870000-1592662044_large.jpg','2020-06-20 16:07:25','2020-06-20 16:07:56'),
(5,'Documents-country','srilanka','/uploads/country/srilanka-090302800-1592662150.png','image/png',1,7,'App\\Countries\\Country','/uploads/country/srilanka-090302800-1592662150_thumb.png','/uploads/country/srilanka-090302800-1592662150_small.png','/uploads/country/srilanka-090302800-1592662150_medium.png','/uploads/country/srilanka-090302800-1592662150_large.png','2020-06-20 16:09:12','2020-06-20 16:09:22'),
(6,'Documents-country','bolivia','/uploads/country/bolivia-094735600-1592662270.jpg','image/jpeg',1,8,'App\\Countries\\Country','/uploads/country/bolivia-094735600-1592662270_thumb.jpg','/uploads/country/bolivia-094735600-1592662270_small.jpg','/uploads/country/bolivia-094735600-1592662270_medium.jpg','/uploads/country/bolivia-094735600-1592662270_large.jpg','2020-06-20 16:11:11','2020-06-20 16:11:32'),
(7,'Documents-country','Reiskick-Krka-meren-1-1-1','/uploads/country/reiskick-krka-meren-1-1-1-031845400-1592662935.jpg','image/jpeg',1,5,'App\\Countries\\Country','/uploads/country/reiskick-krka-meren-1-1-1-031845400-1592662935_thumb.jpg','/uploads/country/reiskick-krka-meren-1-1-1-031845400-1592662935_small.jpg','/uploads/country/reiskick-krka-meren-1-1-1-031845400-1592662935_medium.jpg','/uploads/country/reiskick-krka-meren-1-1-1-031845400-1592662935_large.jpg','2020-06-20 16:22:16','2020-06-20 16:22:17');
/*!40000 ALTER TABLE `documents` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table failed_jobs
# ------------------------------------------------------------
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`connection` text COLLATE utf8_unicode_ci NOT NULL,
`queue` text COLLATE utf8_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table jobs
# ------------------------------------------------------------
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`queue` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8_unicode_ci NOT NULL,
`attempts` tinyint unsigned NOT NULL,
`reserved_at` int unsigned DEFAULT NULL,
`available_at` int unsigned NOT NULL,
`created_at` int unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table kms_users
# ------------------------------------------------------------
DROP TABLE IF EXISTS `kms_users`;
CREATE TABLE `kms_users` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`role` int unsigned DEFAULT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`telephone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`culture` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`gender` int NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `kms_users` WRITE;
/*!40000 ALTER TABLE `kms_users` DISABLE KEYS */;
INSERT INTO `kms_users` (`id`, `role`, `password`, `email`, `telephone`, `first_name`, `last_name`, `culture`, `gender`, `created_at`, `updated_at`, `remember_token`)
VALUES
(1,1,'$2y$10$Rf2DG6QDGXfRKXNrfbZL5essbU4qu5xQCy7Wpqg.hrg87zdEU1LGC','info@komma.pro',NULL,'Komma','Super Admin','nl-NL',0,'2020-06-05 15:55:01','2020-06-05 15:55:01',NULL),
(2,2,'$2y$10$gE65ELsWQ9gU5E4Fay6ccu80Kq1l9W4yjO676A1.TMaIwFOFIJ0Me','support@komma.pro',NULL,'Komma','Admin','nl-NL',2,'2020-06-05 15:55:01','2020-06-05 15:55:01',NULL);
/*!40000 ALTER TABLE `kms_users` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table languages
# ------------------------------------------------------------
DROP TABLE IF EXISTS `languages`;
CREATE TABLE `languages` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`native_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`iso_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `languages` WRITE;
/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
INSERT INTO `languages` (`id`, `name`, `native_name`, `iso_2`)
VALUES
(1,'Abkhazian','Аҧсуа','ab'),
(2,'Afar','Afaraf','aa'),
(3,'Afrikaans','Afrikaans','af'),
(4,'Akan','Akan','ak'),
(5,'Albanian','Shqip','sq'),
(6,'Amharic','አማርኛ','am'),
(7,'Arabic','العربية','ar'),
(8,'Aragonese','Aragonés','an'),
(9,'Assamese','অসমীয়া','as'),
(10,'Armenian','Հայերեն','hy'),
(11,'Avaric','авар мацӀ','av'),
(12,'Avestan','avesta','ae'),
(13,'Aymara','aymar aru','ay'),
(14,'Azerbaijani','azərbaycan dili','az'),
(15,'Bashkir','башҡорт теле','ba'),
(16,'Bambara','bamanankan','bm'),
(17,'Basque','euskara','eu'),
(18,'Belarusian','Беларуская','be'),
(19,'Bengali','বাংলা','bn'),
(20,'Bihari','भोजपुरी','bh'),
(21,'Bislama','Bislama','bi'),
(22,'Bosnian','bosanski jezik','bs'),
(23,'Breton','brezhoneg','br'),
(24,'Bulgarian','български език','bg'),
(25,'Burmese','ဗမာစာ','my'),
(26,'Catalan; Valencian','Català','ca'),
(27,'Chamorro','Chamoru','ch'),
(28,'Chechen','нохчийн мотт','ce'),
(29,'Chichewa','chinyanja','ny'),
(30,'Chinese','\\\"中文 (Zhōngwén), 汉语, 漢語\\\"','zh'),
(31,'Chuvash','чӑваш чӗлхи','cv'),
(32,'Cornish','Kernewek','kw'),
(33,'Corsican','corsu','co'),
(34,'Cree','ᓀᐦᐃᔭᐍᐏᐣ','cr'),
(35,'Croatian','hrvatski','hr'),
(36,'Czech','česky','cs'),
(37,'Danish','dansk','da'),
(38,'Maldivian','ދިވެހި','dv'),
(39,'Dzongkha','རྫོང་ཁ','dz'),
(40,'English','English','en'),
(41,'Esperanto','Esperanto','eo'),
(42,'Estonian','eesti','et'),
(43,'Ewe','Eʋegbe','ee'),
(44,'Faroese','føroyskt','fo'),
(45,'Fijian','vosa Vakaviti','fj'),
(46,'Finnish','suomi','fi'),
(47,'French','français','fr'),
(48,'Fula','Pular','ff'),
(49,'Galician','Galego','gl'),
(50,'German','Deutsch','de'),
(51,'Greek','Ελληνικά','el'),
(52,'Gujarati','ગુજરાતી','gu'),
(53,'Haitian','Kreyòl ayisyen','ht'),
(54,'Hausa','Hausa, هَوُسَ','ha'),
(55,'Hebrew','עברית','he'),
(56,'Herero','Otjiherero','hz'),
(57,'Hindi','हिन्दी, हिंदी','hi'),
(58,'Hiri Motu','Hiri Motu','ho'),
(59,'Hungarian','Magyar','hu'),
(60,'Indonesian','Bahasa Indonesia','id'),
(61,'Irish','Gaeilge','ga'),
(62,'Igbo','Igbo','ig'),
(63,'Inupiaq','Iñupiaq','ik'),
(64,'Ido','Ido','io'),
(65,'Icelandic','Íslenska','is'),
(66,'Italian','Italiano','it'),
(67,'Inuktitut','ᐃᓄᒃᑎᑐᑦ','iu'),
(68,'Japanese','日本語','ja'),
(69,'Javanese','basa Jawa','jv'),
(70,'Georgian','ქართული','ka'),
(71,'Kongo','KiKongo','kg'),
(72,'Kazakh','Қазақ тілі','kk'),
(73,'Central Khmer','ភាសាខ្មែរ','km'),
(74,'Kannada','ಕನ್ನಡ','kn'),
(75,'Korean','韓國語','ko'),
(76,'Kanuri','Kanuri','kr'),
(77,'Kashmiri','कश्मीरी, كشميري','ks'),
(78,'Kurdish','Kurdî','ku'),
(79,'Komi','коми кыв','kv'),
(80,'Kirghiz','кыргыз тили','ky'),
(81,'Latin','latine','la'),
(82,'Luxembourgish','Lëtzebuergesch','lb'),
(83,'Luganda','Luganda','lg'),
(84,'Lingala','Lingála','ln'),
(85,'Lao','ພາສາລາວ','lo'),
(86,'Lithuanian','lietuvių kalba','lt'),
(87,'Luba-Katanga','Luba-Katanga','lu'),
(88,'Latvian','latviešu valoda','lv'),
(89,'Malagasy','Malagasy fiteny','mg'),
(90,'Marshallese','Kajin M̧ajeļ','mh'),
(91,'Manx','Gaelg, Gailck','gv'),
(92,'Māori','te reo Māori','mi'),
(93,'Macedonian','македонски јазик','mk'),
(94,'Malayalam','മലയാളം','ml'),
(95,'Mongolian','Монгол','mn'),
(96,'Marathi','मराठी','mr'),
(97,'Malay','bahasa Melayu, بهاس ملايو','ms'),
(98,'Maltese','Malti','mt'),
(99,'Nauru','Ekakairũ Naoero','na'),
(100,'North Ndebele','isiNdebele','nd'),
(101,'Nepali','नेपाली','ne'),
(102,'Ndonga','Owambo','ng'),
(103,'Norwegian','Norsk','no'),
(104,'Dutch','Nederlands','nl'),
(105,'South Ndebele','isiNdebele','nr'),
(106,'Navajo','Diné bizaad','nv'),
(107,'Oromo','Afaan Oromoo','om'),
(108,'Oriya','ଓଡ଼ିଆ','or'),
(109,'Ossetian','Ирон æвзаг','os'),
(110,'Punjabi','ਪੰਜਾਬੀ','pa'),
(111,'Pāli','पाऴि','pi'),
(112,'Persian','فارسی','fa'),
(113,'Polish','polski','pl'),
(114,'Portuguese','Português','pt'),
(115,'Quechua','Kichwa','qu'),
(116,'Kirundi','Rundi','rn'),
(117,'Romanian','română','ro'),
(118,'Russian','Русский язык','ru'),
(119,'Kinyarwanda','Ikinyarwanda','rw'),
(120,'Sanskrit','संस्कृतम्','sa'),
(121,'Sardinian','sardu','sc'),
(122,'Sindhi','सिन्धी, سنڌي، سندھی','sd'),
(123,'Northern Sami','Davvisámegiella','se'),
(124,'Sango','yângâ tî sängö','sg'),
(125,'Serbian','српски језик','sr'),
(126,'Gaelic','Gàidhlig','gd'),
(127,'Shona','chiShona','sn'),
(128,'Sinhala','සිංහල','si'),
(129,'Slovak','slovenčina','sk'),
(130,'Slovene','slovenščina','sl'),
(131,'Somali','Soomaaliga','so'),
(132,'Southern Sotho','Sesotho','st'),
(133,'Spain','España','es'),
(134,'Sundanese','Basa Sunda','su'),
(135,'Swahili','Kiswahili','sw'),
(136,'Swati','SiSwati','ss'),
(137,'Swedish','svenska','sv'),
(138,'Tamil','தமிழ்','ta'),
(139,'Telugu','తెలుగు','te'),
(140,'Tajik','toğikī','tg'),
(141,'Thai','ไทย','th'),
(142,'Tigrinya','ትግርኛ','ti'),
(143,'Tibetan','བོད་ཡིག','bo'),
(144,'Turkmen','Türkmen','tk'),
(145,'Tagalog','Wikang Tagalog','tl'),
(146,'Tswana','Setswana','tn'),
(147,'Tonga','faka Tonga','to'),
(148,'Turkish','Türkçe','tr'),
(149,'Tsonga','Xitsonga','ts'),
(150,'Tatar','tatarça','tt'),
(151,'Twi','Twi','tw'),
(152,'Tahitian','Reo Mā`ohi','ty'),
(153,'Uighur','Uyƣurqə','ug'),
(154,'Ukrainian','Українська','uk'),
(155,'Urdu','اردو','ur'),
(156,'Venda','Tshivenḓa','ve'),
(157,'Vietnamese','Tiếng Việt','vi'),
(158,'Volapük','Volapük','vo'),
(159,'Walloon','Walon','wa'),
(160,'Welsh','Cymraeg','cy'),
(161,'Wolof','Wollof','wo'),
(162,'Xhosa','isiXhosa','xh'),
(163,'Yoruba','Yorùbá','yo'),
(164,'Zhuang','Saw cuengh','za'),
(165,'Zulu','isiZulu','zu');
/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table migrations
# ------------------------------------------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`batch` int NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES
(43,'2016_08_04_000001_create_countries_table',1),
(44,'2016_08_04_000002_create_languages_table',1),
(45,'2016_08_04_000004_create_sites_table',1),
(46,'2016_08_04_000005_create_site_languages_table',1),
(47,'2016_08_04_000007_create_kms_users_table',1),
(48,'2016_08_04_000008_create_password_resets_table',1),
(49,'2016_08_04_000011_create_pages_table',1),
(50,'2016_08_04_000012_create_page_translations_table',1),
(51,'2016_08_04_000013_create_routes_table',1),
(52,'2016_08_04_000014_create_redirect_routes_table',1),
(53,'2018_03_02_132313_create_posts_table',1),
(54,'2018_03_02_132328_create_post_translations_table',1),
(55,'2018_03_20_092243_create_requests_table',1),
(56,'2018_03_30_141412_create_documents_table',1),
(57,'2018_08_17_094209_create_jobs_table',1),
(58,'2018_08_27_121528_create_actionlogger_table',1),
(59,'2018_11_02_143024_create_component_areas_table',1),
(60,'2018_11_16_134518_create_componentable_types_table',1),
(61,'2018_11_16_154518_create_components_table',1),
(62,'2019_05_09_082325_create_website_config_table',1),
(63,'2019_10_28_112714_create_failed_jobs_table',1),
(64,'2020_06_16_214658_add_timestamps_to_countries',2);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table page_translations
# ------------------------------------------------------------
DROP TABLE IF EXISTS `page_translations`;
CREATE TABLE `page_translations` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`page_id` bigint unsigned NOT NULL,
`language_id` bigint unsigned NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`meta_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`meta_description` text COLLATE utf8_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `page_translations_page_id_foreign` (`page_id`),
KEY `page_translations_language_id_foreign` (`language_id`),
CONSTRAINT `page_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`),
CONSTRAINT `page_translations_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `page_translations` WRITE;
/*!40000 ALTER TABLE `page_translations` DISABLE KEYS */;
INSERT INTO `page_translations` (`id`, `page_id`, `language_id`, `slug`, `name`, `description`, `meta_title`, `meta_description`, `created_at`, `updated_at`)
VALUES
(1,2,104,'home','home','','home',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(2,2,40,'home','home','','home',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(3,3,104,'over-ons','Over ons','','Over ons | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(4,3,40,'about-us','About us','','About | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(5,4,104,'diensten','Diensten','','Diensten | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(6,4,40,'services','Services','','Services | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(7,5,104,'projecten','Projecten','','Projecten | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(8,5,40,'projects','Projects','','Projects | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(9,6,104,'nieuws','Nieuws','','Nieuws | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(10,6,40,'news','Projects','','News | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(11,7,104,'referenties','Referenties','','Referenties | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(12,7,40,'testimonials','Testimonials','',NULL,NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(13,8,104,'contact','Contact','','Contact | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(14,8,40,'contact','Contact','','Contact | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(15,9,104,'algemene-voorwaarden','Algemene voorwaarden','','Algemene voorwaarden | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(16,9,40,'terms-and-conditions','Terms and conditions','',NULL,NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(17,10,104,'privacyverklaring','Privacyverklaring','','Privacyverklaring | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(18,10,40,'privacy-statement','Privacy statement','','Privacy statement | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(19,11,104,'disclaimer','Disclaimer','','Disclaimer | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(20,11,40,'disclaimer','Disclaimer','','Disclaimer | Komma',NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(21,12,104,'Vacatures','Vacatures','Onze vacatures',NULL,NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(22,12,40,'Vacancies','Vacancies','Our vacancies',NULL,NULL,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(23,13,104,'landen','Landen','','Landen | Reiskick','Landen | Reiskick','2020-06-20 16:26:50','2020-06-20 16:26:50');
/*!40000 ALTER TABLE `page_translations` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table pages
# ------------------------------------------------------------
DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`active` tinyint(1) NOT NULL,
`code_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`has_wildcard` tinyint(1) NOT NULL DEFAULT '0',
`lft` bigint DEFAULT NULL,
`rgt` bigint DEFAULT NULL,
`tree` int unsigned DEFAULT NULL,
`site_id` bigint unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
INSERT INTO `pages` (`id`, `active`, `code_name`, `has_wildcard`, `lft`, `rgt`, `tree`, `site_id`, `created_at`, `updated_at`)
VALUES
(1,0,NULL,0,1,26,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(2,1,'home',0,2,3,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(3,1,'about',0,4,5,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(4,1,'services',0,6,7,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(5,1,'projects',1,8,9,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(6,1,'posts',1,10,11,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(7,1,'references',0,12,13,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(8,1,'contact',0,14,15,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(9,1,'legal',0,16,17,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(10,1,'privacy',0,18,19,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(11,1,'disclaimer',0,20,21,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(12,1,'vacancies',1,22,23,1,1,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(13,1,'countries',1,24,25,1,1,'2020-06-20 16:26:50','2020-06-20 16:27:08');
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table password_resets
# ------------------------------------------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets` (
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table post_translations
# ------------------------------------------------------------
DROP TABLE IF EXISTS `post_translations`;
CREATE TABLE `post_translations` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`post_id` bigint unsigned NOT NULL,
`language_id` bigint unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`meta_description` text COLLATE utf8_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `post_translations_post_id_foreign` (`post_id`),
KEY `post_translations_language_id_foreign` (`language_id`),
CONSTRAINT `post_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`),
CONSTRAINT `post_translations_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `post_translations` WRITE;
/*!40000 ALTER TABLE `post_translations` DISABLE KEYS */;
INSERT INTO `post_translations` (`id`, `post_id`, `language_id`, `name`, `slug`, `description`, `meta_description`, `created_at`, `updated_at`)
VALUES
(1,1,40,'est asperiores et aut labore doloribus molestiae','est-asperiores-et-aut-labore-doloribus-molestiae','','Architecto vitae quidem culpa quisquam vel veritatis.','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(2,1,104,'sint aut voluptatibus','sint-aut-voluptatibus','','Deleniti delectus numquam ut dolorem harum id dolores.','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(3,2,40,'doloremque aut minima vel iste expedita','doloremque-aut-minima-vel-iste-expedita','','Sed sed enim dolorem culpa quia sequi ipsa quae.','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(4,2,104,'quia nobis rerum exercitationem sint repellendus et','quia-nobis-rerum-exercitationem-sint-repellendus-et','','Voluptatem ullam velit alias unde sint veritatis a.','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(5,3,40,'iure voluptatem adipisci','iure-voluptatem-adipisci','','Labore rem in est architecto.','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(6,3,104,'minus numquam ut porro maxime','minus-numquam-ut-porro-maxime','','Voluptatum officia nihil fugit quia tempora. Ad saepe sapiente dicta.','2020-06-05 15:55:03','2020-06-05 15:55:03');
/*!40000 ALTER TABLE `post_translations` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table posts
# ------------------------------------------------------------
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`active` tinyint(1) NOT NULL,
`date` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
INSERT INTO `posts` (`id`, `active`, `date`, `created_at`, `updated_at`)
VALUES
(1,1,'2020-02-26 15:55:03','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(2,1,'2020-03-27 15:55:03','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(3,1,'2020-05-03 15:55:03','2020-06-05 15:55:03','2020-06-05 15:55:03');
/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table redirect_routes
# ------------------------------------------------------------
DROP TABLE IF EXISTS `redirect_routes`;
CREATE TABLE `redirect_routes` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`route` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`routable_id` bigint unsigned NOT NULL,
`routable_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`site_id` bigint unsigned NOT NULL,
`language_id` bigint unsigned NOT NULL,
`redirect_code` int DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `redirect_routes_language_id_foreign` (`language_id`),
KEY `redirect_routes_site_id_foreign` (`site_id`),
CONSTRAINT `redirect_routes_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`),
CONSTRAINT `redirect_routes_site_id_foreign` FOREIGN KEY (`site_id`) REFERENCES `sites` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table requests
# ------------------------------------------------------------
DROP TABLE IF EXISTS `requests`;
CREATE TABLE `requests` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`origin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table routes
# ------------------------------------------------------------
DROP TABLE IF EXISTS `routes`;
CREATE TABLE `routes` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`route` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`routable_id` bigint unsigned NOT NULL,
`routable_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`site_id` bigint unsigned NOT NULL,
`language_id` bigint unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `routes_language_id_foreign` (`language_id`),
KEY `routes_site_id_foreign` (`site_id`),
CONSTRAINT `routes_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`),
CONSTRAINT `routes_site_id_foreign` FOREIGN KEY (`site_id`) REFERENCES `sites` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `routes` WRITE;
/*!40000 ALTER TABLE `routes` DISABLE KEYS */;
INSERT INTO `routes` (`id`, `route`, `alias`, `routable_id`, `routable_type`, `site_id`, `language_id`, `created_at`, `updated_at`)
VALUES
(1,'pages/2','/',1,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(2,'pages/2','/home',2,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(3,'pages/3','/over-ons',3,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(4,'pages/3','/about-us',4,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(5,'pages/4','/diensten',5,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(6,'pages/4','/services',6,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(7,'pages/5','/projecten',7,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(8,'pages/5','/projects',8,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(9,'posts','/nieuws',9,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(10,'posts','/projects-1',10,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(11,'pages/7','/referenties',11,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(12,'pages/7','/testimonials',12,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(13,'pages/8','/contact',13,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(14,'pages/8','/contact-1',14,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(15,'pages/9','/algemene-voorwaarden',15,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(16,'pages/9','/terms-and-conditions',16,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(17,'pages/10','/privacyverklaring',17,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(18,'pages/10','/privacy-statement',18,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(19,'pages/11','/disclaimer',19,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(20,'pages/11','/disclaimer-1',20,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(21,'pages/12','/vacatures',21,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(22,'pages/12','/vacancies',22,'App\\Pages\\Models\\PageTranslation',1,40,'2020-06-05 15:55:03','2020-06-05 15:55:03'),
(23,'countries','/landen',23,'App\\Pages\\Models\\PageTranslation',1,104,'2020-06-20 16:26:50','2020-06-20 16:26:50');
/*!40000 ALTER TABLE `routes` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table site_languages
# ------------------------------------------------------------
DROP TABLE IF EXISTS `site_languages`;
CREATE TABLE `site_languages` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`site_id` bigint unsigned NOT NULL,
`language_id` bigint unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `site_languages_site_id_foreign` (`site_id`),
KEY `site_languages_language_id_foreign` (`language_id`),
CONSTRAINT `site_languages_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`),
CONSTRAINT `site_languages_site_id_foreign` FOREIGN KEY (`site_id`) REFERENCES `sites` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `site_languages` WRITE;
/*!40000 ALTER TABLE `site_languages` DISABLE KEYS */;
INSERT INTO `site_languages` (`id`, `site_id`, `language_id`)
VALUES
(1,1,104);
/*!40000 ALTER TABLE `site_languages` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table sites
# ------------------------------------------------------------
DROP TABLE IF EXISTS `sites`;
CREATE TABLE `sites` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`default_language_id` bigint unsigned NOT NULL DEFAULT '104',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sites_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `sites` WRITE;
/*!40000 ALTER TABLE `sites` DISABLE KEYS */;
INSERT INTO `sites` (`id`, `slug`, `name`, `default_language_id`, `created_at`, `updated_at`)
VALUES
(1,'default','Default',104,'2020-06-05 15:55:01','2020-06-05 15:55:01');
/*!40000 ALTER TABLE `sites` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table website_config
# ------------------------------------------------------------
DROP TABLE IF EXISTS `website_config`;
CREATE TABLE `website_config` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`code_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `website_config` WRITE;
/*!40000 ALTER TABLE `website_config` DISABLE KEYS */;
INSERT INTO `website_config` (`id`, `code_name`, `value`, `created_at`, `updated_at`)
VALUES
(1,'company_url','https://reiskick.nl','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(2,'company_name','Reiskick','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(13,'company_social_facebook','https://www.facebook.com/pages/category/Blogger/Reiskick-830891303957196','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(15,'company_social_instagram','https://www.instagram.com/reiskick.nl','2020-06-05 15:55:03','2020-06-05 15:55:03'),
(16,'company_social_pinterest','https://nl.pinterest.com/jannickmarlieke','2020-06-05 15:55:03','2020-06-05 15:55:03');
/*!40000 ALTER TABLE `website_config` ENABLE KEYS */;
UNLOCK TABLES;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;