IP : 18.119.140.8Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
soho/
../
monsta/
../
agora/
../
humhub/
../
fork/
fork.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
CREATE TABLE `blog_posts` ( `id` int(11) NOT NULL COMMENT 'The real post id', `revision_id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `meta_id` int(11) NOT NULL, `language` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `introduction` text COLLATE utf8mb4_unicode_ci, `text` text COLLATE utf8mb4_unicode_ci, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(244) COLLATE utf8mb4_unicode_ci NOT NULL, `publish_on` datetime NOT NULL, `created_on` datetime NOT NULL, `edited_on` datetime NOT NULL, `hidden` tinyint(1) NOT NULL DEFAULT '0', `allow_comments` tinyint(1) NOT NULL DEFAULT '0', `num_comments` int(11) NOT NULL, PRIMARY KEY (`revision_id`), KEY `idx_status_language_hidden` (`status`,`language`,`hidden`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;
-- -- Dumping data for table `blog_posts` --
INSERT INTO `blog_posts` VALUES (1, 1, 1, 1, 11, 'en', 'Nunc sediam est', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n\n<ul>\n <li>Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.</li>\n <li>Quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit.</li>\n <li>Esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</li>\n</ul>\n\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n\n<ul>\n <li>Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.</li>\n <li>Quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit.</li>\n <li>Esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</li>\n</ul>\n\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n', NULL, 'active', '[[regtime]]', '[[regtime]]', '[[regtime]]', 0, 1, 2), (2, 2, 1, 1, 12, 'en', 'Lorem ipsum', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n\n<ul>\n <li>Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.</li>\n <li>Quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit.</li>\n <li>Esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</li>\n</ul>\n\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n\n<ul>\n <li>Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.</li>\n <li>Quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit.</li>\n <li>Esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</li>\n</ul>\n\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n', NULL, 'active', '[[regtime]]', '[[regtime]]', '[[regtime]]', 0, 1, 0);
-- -- Table structure for table `groups_rights_actions` --
CREATE TABLE `groups_rights_actions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL, `module` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT 'name of the module', `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'name of the action', `level` double NOT NULL DEFAULT '1' COMMENT 'unix type levels 1, 3, 5 and 7', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=95 ;
-- -- Dumping data for table `groups_rights_actions` --
-- -- Table structure for table `groups_settings` --
CREATE TABLE `groups_settings` ( `group_id` int(11) NOT NULL, `name` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT 'name of the setting', `value` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'serialized value', PRIMARY KEY (`group_id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Dumping data for table `groups_settings` --
INSERT INTO `groups_settings` VALUES (1, 'dashboard_sequence', 'a:3:{s:8:"Settings";a:1:{i:0;s:7:"Analyse";}s:5:"Users";a:1:{i:0;s:10:"Statistics";}s:4:"Blog";a:1:{i:0;s:8:"Comments";}}');
-- -- Table structure for table `modules_extras` --
CREATE TABLE `modules_extras` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for the extra.', `module` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT 'The name of the module this extra belongs to.', `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The label for this extra. It will be used for displaying purposes.', `action` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `data` text COLLATE utf8mb4_unicode_ci COMMENT 'A serialized value with the optional parameters', `hidden` tinyint(1) NOT NULL DEFAULT '0', `sequence` int(11) NOT NULL COMMENT 'The sequence in the backend.', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='The possible extras' AUTO_INCREMENT=16 ;
-- -- Table structure for table `modules_settings` --
CREATE TABLE `modules_settings` ( `module` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT 'name of the module', `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'name of the setting', `value` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'serialized value', PRIMARY KEY (`module`(25),`name`(100)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Dumping data for table `modules_settings` --
CREATE TABLE `pages` ( `id` int(11) NOT NULL COMMENT 'the real page_id', `revision_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT 'which user has created this page?', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'the parent_id for the page ', `template_id` int(11) NOT NULL DEFAULT '0' COMMENT 'the template to use', `meta_id` int(11) NOT NULL COMMENT 'linked meta information', `language` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'language of the content', `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'root' COMMENT 'page, header, footer, ...', `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `navigation_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'title that will be used in the navigation', `navigation_title_overwrite` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'should we override the navigation title', `hidden` tinyint(1) NOT NULL DEFAULT '1', `status` varchar(243) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active' COMMENT 'is this the active, archive or draft version', `publish_on` datetime NOT NULL, `data` text COLLATE utf8mb4_unicode_ci COMMENT 'serialized array that may contain type specific parameters', `created_on` datetime NOT NULL, `edited_on` datetime NOT NULL, `allow_move` tinyint(1) NOT NULL DEFAULT '1', `allow_children` tinyint(1) NOT NULL DEFAULT '1', `allow_edit` tinyint(1) NOT NULL DEFAULT '1', `allow_delete` tinyint(1) NOT NULL DEFAULT '1', `sequence` int(11) NOT NULL, PRIMARY KEY (`revision_id`), KEY `idx_id_status_hidden_language` (`id`,`status`,`hidden`,`language`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=10 ;
CREATE TABLE `pages_blocks` ( `revision_id` int(11) NOT NULL COMMENT 'The ID of the page that contains this block.', `position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `extra_id` int(11) DEFAULT NULL COMMENT 'The linked extra.', `extra_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'rich_text', `extra_data` text COLLATE utf8mb4_unicode_ci, `html` text COLLATE utf8mb4_unicode_ci COMMENT 'if this block is HTML this field should contain the real HTML.', `created_on` datetime NOT NULL, `edited_on` datetime NOT NULL, `visible` tinyint(1) NOT NULL DEFAULT '1', `sequence` int(11) NOT NULL, KEY `idx_rev_status` (`revision_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Dumping data for table `pages_blocks` --
INSERT INTO `pages_blocks` VALUES (1, 'main', NULL, 'rich_text', NULL, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam id magna. Proin euismod vestibulum tortor. Vestibulum eget nisl. Donec interdum quam at nunc. In laoreet orci sit amet sem. In sed metus ac nunc blandit ultricies. Maecenas sed tortor. Sed velit velit, mollis quis, ultricies tincidunt, dictum ac, felis. Integer hendrerit consectetur libero. Duis sem. Mauris tellus justo, sollicitudin at, vehicula eget, auctor vel, odio. Proin mattis. Mauris mollis elit sit amet lectus. Vestibulum in tortor sodales elit sollicitudin gravida. Integer scelerisque sollicitudin velit. Aliquam erat volutpat. Sed ut nisl congue justo pharetra accumsan.</p>', '[[regtime]]', '[[regtime]]', 1, 0), (1, 'top', 1, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (2, 'main', NULL, 'rich_text', NULL, '<p>Take a look at all the pages in our website:</p>', '[[regtime]]', '[[regtime]]', 1, 0), (2, 'main', 3, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 1), (2, 'top', 1, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (3, 'main', NULL, 'rich_text', NULL, '<p><strong>This website is property of [Bedrijfsnaam].</strong></p>\n<p><strong>Contact info:</strong><br />[Bedrijfsnaam]<br /> [Straatnaam] [Nummer]<br /> [Postcode] [Gemeente]</p>\n<p><strong>Adres maatschappelijk zetel:</strong><br />[Maatschappelijke zetel]<br /> [Straatnaam] [Nummer]<br /> [Postcode] [Gemeente]</p>\n<p>Telefoon:<br />E-mail:</p>\n<p>Ondernemingsnummer: BTW BE 0 [BTW-nummer]</p>\n<p>De toezichthoudende autoriteit: (wanneer uw activiteit aan een vergunningsstelsel is onderworpen)</p>\n<p>By accessing and using the website, you have expressly agreed to the following general conditions.</p>\n<h3>Intellectual property rights</h3>\n<p>The contents of this site, including trade marks, logos, drawings, data, product or company names, texts, images, etc. are protected by intellectual property rights and belong to [Bedrijfsnaam] or entitled third parties.</p>\n<h3>Liability limitation</h3>\n<p>The information on the website is general in nature. It is not adapted to personal or specific circumstances and can therefore not be regarded as personal, professional or judicial advice for the user.</p>\n<p>[Bedrijfsnaam] does everything in its power to ensure that the information made available is complete, correct, accurate and updated. However, despite these efforts inaccuracies may occur when providing information. If the information provided contains inaccuracies or if specific information on or via the site is unavailable, [Bedrijfsnaam] shall make the greatest effort to ensure that this is rectified as soon as possible.</p>\n<p>[Bedrijfsnaam] cannot be held responsible for direct or indirect damage caused by the use of the information on this site. The site manager should be contacted if the user has noticed any inaccuracies in the information provided by the site.</p>\n<p>The contents of the site (including links) may be adjusted, changed or extended at any time without any announcement or advance notice. [Bedrijfsnaam] gives no guarantees for the smooth operation of the website and cannot be held responsible in any way for the poor operation or temporary unavailability of the website or for any type of damage, direct or indirect, which may occur due to the access to or use of the website.</p>\n<p>[Bedrijfsnaam] can in no case be held liable, directly or indirectly, specifically or otherwise, vis-à-vis anyone for any damage attributable to the use of this site or any other one, in particular as the result of links or hyperlinks including, but not limited to, any loss, work interruption, damage of the user’s programs or other data on the computer system, hardware, software or otherwise.</p>\n<p>The website may contain hyperlinks to websites or pages of third parties or refer to these indirectly. The placing of links on these websites or pages shall not imply in any way the implicit approval of the contents thereof. [Bedrijfsnaam] expressly declares that it has no authority over the contents or over other features of these websites and can in no case be held responsible for the contents or features thereof or for any other type of damage resulting from their use.</p>\n<h3>Applicable legislation and competent courts</h3>\n<p>This site is governed by Belgian law. Only the courts of the district of Ghent are competent to settle any disputes.</p>\n<h3>Privacy policy</h3>\n<p>[Bedrijfsnaam] believes that your privacy is important. While most of the information on this site is available without having to ask the user for personal information, the user may be asked for some personal details. This information will only be used to ensure a better service. (e.g. for our customer database, to keep users informed of our activities, etc.). The user may, free of charge and on request, always prevent the use of his personal details for the purposes of direct marketing. In this regard, the user should contact [Bedrijfsnaam], [Adres bedrijf] or via [Email adres bedrijf]. Your personal details will never been transferred to any third parties (if this should occur, you will be informed).</p>\n<p>In accordance with the law on the processing of personal data of 8 December 1992, the user has the legal right to examine and possibly correct any of his/her personal details. Subject to proof of identity (copy of the user’s identity card), you can via a written, dated and signed request to [Bedrijfsnaam], [Adres bedrijf] or via [Email adres bedrijf], receive free of charge a written statement of the user’s personal details. If necessary, you may also ask for any incorrect, incomplete or irrelevant data to be adjusted.</p>\n<p>[Bedrijfsnaam] can collect non-personal anonymous or aggregate data such as browser type, IP address or operating system in use or the domain name of the website that led you to and from our website, ensuring optimum effectiveness of our website for all users.</p>\n<h3>The use of cookies</h3>\n<p>During a visit to the site, cookies may be placed on the hard drive of your computer. This is only in order to ensure that our site is geared to the needs of users returning to our website. These tiny files known as cookies are not used to ascertain the surfing habits of the visitor on other websites. Your internet browser enables you to disable these cookies, receive a warning when a cookie has been installed or have the cookies removed from your hard disc. For this purpose, consult the help function of your internet browser.</p>', '[[regtime]]', '[[regtime]]', 1, 0), (3, 'top', 1, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (4, 'main', NULL, 'rich_text', NULL, '<iframe src="http://notfound-static.fwebservices.be/404/index.html" width="100%" height="650" frameborder="0"></iframe>\n<p>This page doesn''t exist or is not accessible at this time. Take a look at the sitemap:</p>\n', '[[regtime]]', '[[regtime]]', 1, 0), (4, 'main', 3, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 1), (4, 'top', 1, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (5, 'main', 4, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (5, 'top', 1, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (6, 'main', NULL, 'rich_text', NULL, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam id magna. Proin euismod vestibulum tortor. Vestibulum eget nisl. Donec interdum quam at nunc. In laoreet orci sit amet sem. In sed metus ac nunc blandit ultricies. Maecenas sed tortor. Sed velit velit, mollis quis, ultricies tincidunt, dictum ac, felis. Integer hendrerit consectetur libero. Duis sem. Mauris tellus justo, sollicitudin at, vehicula eget, auctor vel, odio. Proin mattis. Mauris mollis elit sit amet lectus. Vestibulum in tortor sodales elit sollicitudin gravida. Integer scelerisque sollicitudin velit. Aliquam erat volutpat. Sed ut nisl congue justo pharetra accumsan.</p>', '[[regtime]]', '[[regtime]]', 1, 0), (6, 'main', 12, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 1), (6, 'main', 7, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 2), (6, 'top', 1, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (7, 'main', 6, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (7, 'main', 7, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 1), (7, 'main', 8, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 2), (7, 'main', 9, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 3), (7, 'main', 12, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 4), (7, 'top', 1, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (8, 'main', 13, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (8, 'top', 1, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0), (9, 'main', 2, 'rich_text', NULL, '', '[[regtime]]', '[[regtime]]', 1, 0);
CREATE TABLE `search_index` ( `module` varchar(255) CHARACTER SET utf8 NOT NULL, `other_id` int(11) NOT NULL, `field` varchar(64) CHARACTER SET utf8 NOT NULL, `value` text COLLATE utf8mb4_unicode_ci NOT NULL, `language` varchar(5) CHARACTER SET utf8 NOT NULL, `active` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`module`,`other_id`,`field`,`language`), FULLTEXT KEY `value` (`value`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Search index';
-- -- Dumping data for table `search_index` --
INSERT INTO `search_index` VALUES ('Pages', 2, 'title', 'Take a look at all the pages in our website: ', 'en', 1), ('Pages', 3, 'title', 'This website is property of [Bedrijfsnaam].\nContact info:[Bedrijfsnaam] [Straatnaam] [Nummer] [Postcode] [Gemeente]\nAdres maatschappelijk zetel:[Maatschappelijke zetel] [Straatnaam] [Nummer] [Postcode] [Gemeente]\nTelefoon:E-mail:\nOndernemingsnummer: BTW BE 0 [BTW-nummer]\nDe toezichthoudende autoriteit: (wanneer uw activiteit aan een vergunningsstelsel is onderworpen)\nBy accessing and using the website, you have expressly agreed to the following general conditions.\nIntellectual property rights\nThe contents of this site, including trade marks, logos, drawings, data, product or company names, texts, images, etc. are protected by intellectual property rights and belong to [Bedrijfsnaam] or entitled third parties.\nLiability limitation\nThe information on the website is general in nature. It is not adapted to personal or specific circumstances and can therefore not be regarded as personal, professional or judicial advice for the user.\n[Bedrijfsnaam] does everything in its power to ensure that the information made available is complete, correct, accurate and updated. However, despite these efforts inaccuracies may occur when providing information. If the information provided contains inaccuracies or if specific information on or via the site is unavailable, [Bedrijfsnaam] shall make the greatest effort to ensure that this is rectified as soon as possible.\n[Bedrijfsnaam] cannot be held responsible for direct or indirect damage caused by the use of the information on this site. The site manager should be contacted if the user has noticed any inaccuracies in the information provided by the site.\nThe contents of the site (including links) may be adjusted, changed or extended at any time without any announcement or advance notice. [Bedrijfsnaam] gives no guarantees for the smooth operation of the website and cannot be held responsible in any way for the poor operation or temporary unavailability of the website or for any type of damage, direct or indirect, which may occur due to the access to or use of the website.\n[Bedrijfsnaam] can in no case be held liable, directly or indirectly, specifically or otherwise, vis-à-vis anyone for any damage attributable to the use of this site or any other one, in particular as the result of links or hyperlinks including, but not limited to, any loss, work interruption, damage of the user’s programs or other data on the computer system, hardware, software or otherwise.\nThe website may contain hyperlinks to websites or pages of third parties or refer to these indirectly. The placing of links on these websites or pages shall not imply in any way the implicit approval of the contents thereof. [Bedrijfsnaam] expressly declares that it has no authority over the contents or over other features of these websites and can in no case be held responsible for the contents or features thereof or for any other type of damage resulting from their use.\nApplicable legislation and competent courts\nThis site is governed by Belgian law. Only the courts of the district of Ghent are competent to settle any disputes.\nPrivacy policy\n[Bedrijfsnaam] believes that your privacy is important. While most of the information on this site is available without having to ask the user for personal information, the user may be asked for some personal details. This information will only be used to ensure a better service. (e.g. for our customer database, to keep users informed of our activities, etc.). The user may, free of charge and on request, always prevent the use of his personal details for the purposes of direct marketing. In this regard, the user should contact [Bedrijfsnaam], [Adres bedrijf] or via [Email adres bedrijf]. Your personal details will never been transferred to any third parties (if this should occur, you will be informed).\nIn accordance with the law on the processing of personal data of 8 December 1992, the user has the legal right to examine and possibly correct any of his/her personal details. Subject to proof of identity (copy of the user’s identity card), you can via a written, dated and signed request to [Bedrijfsnaam], [Adres bedrijf] or via [Email adres bedrijf], receive free of charge a written statement of the user’s personal details. If necessary, you may also ask for any incorrect, incomplete or irrelevant data to be adjusted.\n[Bedrijfsnaam] can collect non-personal anonymous or aggregate data such as browser type, IP address or operating system in use or the domain name of the website that led you to and from our website, ensuring optimum effectiveness of our website for all users.\nThe use of cookies\nDuring a visit to the site, cookies may be placed on the hard drive of your computer. This is only in order to ensure that our site is geared to the needs of users returning to our website. These tiny files known as cookies are not used to ascertain the surfing habits of the visitor on other websites. Your internet browser enables you to disable these cookies, receive a warning when a cookie has been installed or have the cookies removed from your hard disc. For this purpose, consult the help function of your internet browser. ', 'en', 1), ('Pages', 404, 'title', '\nThis page doesn''t exist or is not accessible at this time. Take a look at the sitemap:\n ', 'en', 1), ('Pages', 4, 'title', ' ', 'en', 1), ('Pages', 1, 'title', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam id magna. Proin euismod vestibulum tortor. Vestibulum eget nisl. Donec interdum quam at nunc. In laoreet orci sit amet sem. In sed metus ac nunc blandit ultricies. Maecenas sed tortor. Sed velit velit, mollis quis, ultricies tincidunt, dictum ac, felis. Integer hendrerit consectetur libero. Duis sem. Mauris tellus justo, sollicitudin at, vehicula eget, auctor vel, odio. Proin mattis. Mauris mollis elit sit amet lectus. Vestibulum in tortor sodales elit sollicitudin gravida. Integer scelerisque sollicitudin velit. Aliquam erat volutpat. Sed ut nisl congue justo pharetra accumsan. ', 'en', 1), ('Pages', 405, 'title', ' ', 'en', 1), ('Pages', 406, 'title', ' ', 'en', 1), ('Pages', 407, 'title', '', 'en', 1), ('Blog', 1, 'title', 'Nunc sediam est', 'en', 1), ('Blog', 1, 'text', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\n\n\n Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.\n Quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit.\n Esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\n\n\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\n', 'en', 1), ('Blog', 2, 'title', 'Lorem ipsum', 'en', 1), ('Blog', 2, 'text', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\n\n\n Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.\n Quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit.\n Esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\n\n\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\n', 'en', 1);
-- -- Table structure for table `themes_templates` --
CREATE TABLE `themes_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for the template.', `theme` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The name of the theme.', `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The label for the template, will be used for displaying purposes.', `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Filename for the template.', `active` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Is this template active (as in: will it be used).', `data` text COLLATE utf8mb4_unicode_ci COMMENT 'A serialized array with data that is specific for this template (eg.: names for the blocks).', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='The possible templates' AUTO_INCREMENT=3 ;
-- -- Dumping data for table `themes_templates` --
-- -- Table structure for table `users_settings` --
CREATE TABLE `users_settings` ( `user_id` int(11) NOT NULL, `name` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT 'name of the setting', `value` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'serialized value', PRIMARY KEY (`user_id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Constraints for table `MediaFolder` -- ALTER TABLE `MediaFolder` ADD CONSTRAINT `FK_F8B3AB017897CFE7` FOREIGN KEY (`parentMediaFolderId`) REFERENCES `MediaFolder` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `MediaGroupMediaItem` -- ALTER TABLE `MediaGroupMediaItem` ADD CONSTRAINT `FK_BCC51AD827759A6A` FOREIGN KEY (`mediaItemId`) REFERENCES `MediaItem` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_BCC51AD86776CC71` FOREIGN KEY (`mediaGroupId`) REFERENCES `MediaGroup` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `MediaItem` -- ALTER TABLE `MediaItem` ADD CONSTRAINT `FK_3BE26384C1DCBB95` FOREIGN KEY (`mediaFolderId`) REFERENCES `MediaFolder` (`id`) ON DELETE CASCADE;
/*!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 */;