IP : 13.59.55.51Hostname : 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/
webmail/
./
../
clip/
../
dolibarr/
../
./
pimcore/
pimcore.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 `website_settings` --
CREATE TABLE `website_settings` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(190) NOT NULL DEFAULT '', `type` enum('text','document','asset','object','bool') DEFAULT NULL, `data` text, `language` varchar(15) NOT NULL DEFAULT '', `siteId` int unsigned DEFAULT NULL, `creationDate` int unsigned DEFAULT '0', `modificationDate` int unsigned DEFAULT '0', PRIMARY KEY (`id`), KEY `name` (`name`), KEY `siteId` (`siteId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- -- Constraints for dumped tables --
-- -- Constraints for table `assets_image_thumbnail_cache` -- ALTER TABLE `assets_image_thumbnail_cache` ADD CONSTRAINT `FK_assets_image_thumbnail_cache_assets` FOREIGN KEY (`cid`) REFERENCES `assets` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `assets_metadata` -- ALTER TABLE `assets_metadata` ADD CONSTRAINT `FK_assets_metadata_assets` FOREIGN KEY (`cid`) REFERENCES `assets` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `classificationstore_collectionrelations` -- ALTER TABLE `classificationstore_collectionrelations` ADD CONSTRAINT `FK_classificationstore_collectionrelations_groups` FOREIGN KEY (`groupId`) REFERENCES `classificationstore_groups` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `classificationstore_relations` -- ALTER TABLE `classificationstore_relations` ADD CONSTRAINT `FK_classificationstore_relations_classificationstore_groups` FOREIGN KEY (`groupId`) REFERENCES `classificationstore_groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_classificationstore_relations_classificationstore_keys` FOREIGN KEY (`keyId`) REFERENCES `classificationstore_keys` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `documents_editables` -- ALTER TABLE `documents_editables` ADD CONSTRAINT `fk_documents_editables_documents` FOREIGN KEY (`documentId`) REFERENCES `documents` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `documents_email` -- ALTER TABLE `documents_email` ADD CONSTRAINT `fk_documents_email_documents` FOREIGN KEY (`id`) REFERENCES `documents` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `documents_hardlink` -- ALTER TABLE `documents_hardlink` ADD CONSTRAINT `fk_documents_hardlink_documents` FOREIGN KEY (`id`) REFERENCES `documents` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `documents_link` -- ALTER TABLE `documents_link` ADD CONSTRAINT `fk_documents_link_documents` FOREIGN KEY (`id`) REFERENCES `documents` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `documents_page` -- ALTER TABLE `documents_page` ADD CONSTRAINT `fk_documents_page_documents` FOREIGN KEY (`id`) REFERENCES `documents` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `documents_snippet` -- ALTER TABLE `documents_snippet` ADD CONSTRAINT `fk_documents_snippet_documents` FOREIGN KEY (`id`) REFERENCES `documents` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `documents_translations` -- ALTER TABLE `documents_translations` ADD CONSTRAINT `fk_documents_translations_documents` FOREIGN KEY (`id`) REFERENCES `documents` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `email_log` -- ALTER TABLE `email_log` ADD CONSTRAINT `fk_email_log_documents` FOREIGN KEY (`documentId`) REFERENCES `documents` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `gridconfig_favourites` -- ALTER TABLE `gridconfig_favourites` ADD CONSTRAINT `fk_gridconfig_favourites_gridconfigs` FOREIGN KEY (`gridConfigId`) REFERENCES `gridconfigs` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `gridconfig_shares` -- ALTER TABLE `gridconfig_shares` ADD CONSTRAINT `fk_gridconfig_shares_gridconfigs` FOREIGN KEY (`gridConfigId`) REFERENCES `gridconfigs` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `object_url_slugs` -- ALTER TABLE `object_url_slugs` ADD CONSTRAINT `fk_object_url_slugs__objectId` FOREIGN KEY (`objectId`) REFERENCES `objects` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `quantityvalue_units` -- ALTER TABLE `quantityvalue_units` ADD CONSTRAINT `fk_baseunit` FOREIGN KEY (`baseunit`) REFERENCES `quantityvalue_units` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
-- -- Constraints for table `sites` -- ALTER TABLE `sites` ADD CONSTRAINT `fk_sites_documents` FOREIGN KEY (`rootId`) REFERENCES `documents` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `users_workspaces_asset` -- ALTER TABLE `users_workspaces_asset` ADD CONSTRAINT `fk_users_workspaces_asset_assets` FOREIGN KEY (`cid`) REFERENCES `assets` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_users_workspaces_asset_users` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `users_workspaces_document` -- ALTER TABLE `users_workspaces_document` ADD CONSTRAINT `fk_users_workspaces_document_documents` FOREIGN KEY (`cid`) REFERENCES `documents` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_users_workspaces_document_users` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `users_workspaces_object` -- ALTER TABLE `users_workspaces_object` ADD CONSTRAINT `fk_users_workspaces_object_objects` FOREIGN KEY (`cid`) REFERENCES `objects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_users_workspaces_object_users` FOREIGN KEY (`userId`) REFERENCES `users` (`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 */;