IP : 18.119.159.83Hostname : 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/
phplite/
../
backdrop/
../
fiyo/
../
lychee/
../
lime/
lime.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 */;
-- -- Table structure for table `[[dbprefix]]answers` --
CREATE TABLE `[[dbprefix]]answers` ( `aid` int NOT NULL AUTO_INCREMENT, `qid` int NOT NULL, `code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `sortorder` int NOT NULL, `assessment_value` int NOT NULL DEFAULT '0', `scale_id` int NOT NULL DEFAULT '0', PRIMARY KEY (`aid`), KEY `[[dbprefix]]answers_idx` (`qid`,`code`,`scale_id`), KEY `[[dbprefix]]answers_idx2` (`sortorder`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- -- Table structure for table `[[dbprefix]]archived_table_settings` --
CREATE TABLE `[[dbprefix]]archived_table_settings` ( `id` int NOT NULL AUTO_INCREMENT, `survey_id` int NOT NULL, `user_id` int NOT NULL, `tbl_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tbl_type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime NOT NULL, `properties` text COLLATE utf8mb4_unicode_ci NOT NULL, `attributes` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- -- Table structure for table `[[dbprefix]]asset_version` --
CREATE TABLE `[[dbprefix]]asset_version` ( `id` int NOT NULL AUTO_INCREMENT, `path` text COLLATE utf8mb4_unicode_ci NOT NULL, `version` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- -- Table structure for table `[[dbprefix]]boxes` --
CREATE TABLE `[[dbprefix]]boxes` ( `id` int NOT NULL AUTO_INCREMENT, `position` int DEFAULT NULL, `url` text COLLATE utf8mb4_unicode_ci NOT NULL, `title` text COLLATE utf8mb4_unicode_ci NOT NULL, `buttontext` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ico` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `desc` text COLLATE utf8mb4_unicode_ci NOT NULL, `page` text COLLATE utf8mb4_unicode_ci NOT NULL, `usergroup` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ;
-- -- Dumping data for table `[[dbprefix]]boxes` --
INSERT INTO `[[dbprefix]]boxes` VALUES (1, 1, 'dashboard/view', 'Dashboard', 'View dashboard', 'ri-function-fill', 'View dashboard', 'welcome', -1), (2, 2, 'admin/globalsettings', 'Global settings', 'View global settings', 'ri-settings-3-fill', 'Edit global settings', 'welcome', -2), (3, 3, 'themeOptions', 'Themes', 'Edit themes', 'ri-paint-fill', 'The themes functionality allows you to edit survey-, admin- or question themes.', 'welcome', -2), (4, 4, 'userManagement/index', 'Manage administrators', 'Manage administrators', 'ri-group-line', 'The user management allows you to add additional users to your survey administration.', 'welcome', -2), (5, 5, 'admin/pluginmanager/sa/index', 'Plugins', 'Manage plugins', 'ri-plug-fill', 'Plugins can be used to add custom features', 'welcome', -2);
-- -- Table structure for table `[[dbprefix]]permissions` --
CREATE TABLE `[[dbprefix]]permissions` ( `id` int NOT NULL AUTO_INCREMENT, `entity` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `entity_id` int NOT NULL, `uid` int NOT NULL, `permission` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `create_p` int NOT NULL DEFAULT '0', `read_p` int NOT NULL DEFAULT '0', `update_p` int NOT NULL DEFAULT '0', `delete_p` int NOT NULL DEFAULT '0', `import_p` int NOT NULL DEFAULT '0', `export_p` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `[[dbprefix]]idx1_permissions` (`entity_id`,`entity`,`permission`,`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;
-- -- Dumping data for table `[[dbprefix]]permissions` --
-- -- Table structure for table `[[dbprefix]]saved_control` --
CREATE TABLE `[[dbprefix]]saved_control` ( `scid` int NOT NULL AUTO_INCREMENT, `sid` int NOT NULL DEFAULT '0', `srid` int NOT NULL DEFAULT '0', `identifier` text COLLATE utf8mb4_unicode_ci NOT NULL, `access_code` text COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(192) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip` text COLLATE utf8mb4_unicode_ci NOT NULL, `saved_thisstep` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `saved_date` datetime NOT NULL, `refurl` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`scid`), KEY `[[dbprefix]]idx1_saved_control` (`sid`), KEY `[[dbprefix]]idx2_saved_control` (`srid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- -- Dumping data for table `[[dbprefix]]settings_global` --
INSERT INTO `[[dbprefix]]settings_global` VALUES ('sendadmincreationemail', '1'), ('admincreationemailsubject', 'User registration at ''{SITENAME}'''), ('admincreationemailtemplate', '<p>Hello {FULLNAME}, </p><p>This is an automated email notification that a user has been created for you on the website <strong>''{SITENAME}''</strong>.</p><p></p><p>You can use now the following credentials to log in:</p><p><strong>Username</strong>: {USERNAME}</p><p><a href="{LOGINURL}">Click here to set your password</a></p><p>If you have any questions regarding this email, please do not hesitate to contact the site administrator at {SITEADMINEMAIL}.</p><p> </p><p>Thank you!</p>'), ('DBVersion', '627'), ('SessionName', '[[session_name]]'), ('sitename', '[[site_name]]'), ('siteadminname', '[[admin_realname]]'), ('siteadminemail', '[[admin_email]]'), ('siteadminbounce', '[[admin_email]]'), ('defaultlang', '[[language]]');
-- -- Dumping data for table `[[dbprefix]]templates` --
INSERT INTO `[[dbprefix]]templates` VALUES (1, 'vanilla', 'vanilla', 'Bootstrap Vanilla', '[[regtime]]', 'LimeSurvey GmbH', 'info@limesurvey.org', 'https://www.limesurvey.org/', 'Copyright (C) 2007-2019 The LimeSurvey Project Team\\r\\nAll rights reserved.', 'License: GNU/GPL License v2 or later, see LICENSE.php\\r\\n\\r\\nLimeSurvey is free software. This version may have been modified pursuant to the GNU General Public License, and as distributed it includes or is derivative of works licensed under the GNU General Public License or other free or open source software licenses. See COPYRIGHT.php for copyright notices and details.', '3.0', '3.0', 'views', 'files', 'A clean and simple base that can be used by developers to create their own Bootstrap based theme.', NULL, 1, ''), (2, 'fruity', 'fruity', 'Fruity', '[[regtime]]', 'LimeSurvey GmbH', 'info@limesurvey.org', 'https://www.limesurvey.org/', 'Copyright (C) 2007-2019 The LimeSurvey Project Team\\r\\nAll rights reserved.', 'License: GNU/GPL License v2 or later, see LICENSE.php\\r\\n\\r\\nLimeSurvey is free software. This version may have been modified pursuant to the GNU General Public License, and as distributed it includes or is derivative of works licensed under the GNU General Public License or other free or open source software licenses. See COPYRIGHT.php for copyright notices and details.', '3.0', '3.0', 'views', 'files', 'A fruity theme for a flexible use. This theme offers monochromes variations and many options for easy customizations.', NULL, 1, 'vanilla'), (3, 'bootswatch', 'bootswatch', 'Bootswatch', '[[regtime]]', 'LimeSurvey GmbH', 'info@limesurvey.org', 'https://www.limesurvey.org/', 'Copyright (C) 2007-2019 The LimeSurvey Project Team\\r\\nAll rights reserved.', 'License: GNU/GPL License v2 or later, see LICENSE.php\\r\\n\\r\\nLimeSurvey is free software. This version may have been modified pursuant to the GNU General Public License, and as distributed it includes or is derivative of works licensed under the GNU General Public License or other free or open source software licenses. See COPYRIGHT.php for copyright notices and details.', '3.0', '3.0', 'views', 'files', 'Based on BootsWatch Themes:<br><a href=''https://bootswatch.com/3/''>Visit Bootswatch page</a>', NULL, 1, 'vanilla'), (4, 'fruity_twentythree', 'fruity_twentythree', 'Fruity TwentyThree', '[[regtime]]', 'LimeSurvey GmbH', 'info@limesurvey.org', 'https://www.limesurvey.org/', 'Copyright (C) 2005 - 2023 LimeSurvey Gmbh, Inc. All rights reserved.', 'License: GNU/GPL License v2 or later, see LICENSE.php\\r\\n\\r\\nLimeSurvey is free software. This version may have been modified pursuant to the GNU General Public License, and as distributed it includes or is derivative of works licensed under the GNU General Public License or other free or open source software licenses. See COPYRIGHT.php for copyright notices and details.', '1.0.0', '3.0', 'views', 'files', 'Our default theme for a fruity and flexible use. This theme offers single color variations', NULL, 1, '');
-- -- Table structure for table `[[dbprefix]]user_in_permissionrole` --
CREATE TABLE `[[dbprefix]]user_in_permissionrole` ( `ptid` int NOT NULL, `uid` int NOT NULL, PRIMARY KEY (`ptid`,`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
/*!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 */;