IP : 18.222.166.12Hostname : 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/
../
proc/
self/
root/
var/
softaculous/
prototype/
../
wp49/
../
eventum/
../
humhub/
humhub.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 */;
INSERT INTO `comment` VALUES (1, 'Nike – Just buy it. :wink:', 'humhub\\modules\\post\\models\\Post', 2, '[[regtime]]', 2, '[[regtime]]', 2), (2, 'Calvin Klein – Between love and madness lies obsession.', 'humhub\\modules\\post\\models\\Post', 2, '[[regtime]]', 3, '[[regtime]]', 3);
-- -- Dumping data for table `content_fulltext` --
INSERT INTO `content_fulltext` VALUES (6, '6 \nWe''re looking for great slogans of famous brands. Maybe you can come up with some samples? \n', '\n\nNike – Just buy it. :wink:\n\n\n\nCalvin Klein – Between love and madness lies obsession.\n\n \n', ' \n');
INSERT INTO `group` VALUES (1, 'Administrators', 'Default group for administrators of this HumHub Installation', '[[regtime]]', NULL, NULL, NULL, NULL, 1, 0, 0, 0, 0, 100, 0), (2, 'Users', 'Default group for all newly registered users of the network', '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, 0, 1, 0, 1, 0, 100, 0);
INSERT INTO `post` VALUES (1, 'Yay! I''ve just installed HumHub :sunglasses:', NULL, '[[regtime]]', 1, '[[regtime]]', 1), (2, 'We''re looking for great slogans of famous brands. Maybe you can come up with some samples?', NULL, '[[regtime]]', 1, '[[regtime]]', 1);
INSERT INTO `user_password` VALUES (1, 1, 'bcrypt', '[[admin_pass]]', '[[salt]]', '[[regtime]]');
-- -- Constraints for dumped tables --
-- -- Constraints for table `comment` -- ALTER TABLE `comment` ADD CONSTRAINT `fk_comment-created_by` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `content` -- ALTER TABLE `content` ADD CONSTRAINT `fk-contentcontainer` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `fk-create-user` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `fk-update-user` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `contentcontainer_blocked_users` -- ALTER TABLE `contentcontainer_blocked_users` ADD CONSTRAINT `fk-contentcontainer-blocked-users-rel-contentcontainer-id` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk-contentcontainer-blocked-users-rel-user-id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `contentcontainer_module` -- ALTER TABLE `contentcontainer_module` ADD CONSTRAINT `fk_contentcontainer` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `contentcontainer_setting` -- ALTER TABLE `contentcontainer_setting` ADD CONSTRAINT `fk-contentcontainerx` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `contentcontainer_tag_relation` -- ALTER TABLE `contentcontainer_tag_relation` ADD CONSTRAINT `fk-contentcontainer-tag-rel-contentcontainer-id` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk-contentcontainer-tag-rel-tag-id` FOREIGN KEY (`tag_id`) REFERENCES `contentcontainer_tag` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `content_fulltext` -- ALTER TABLE `content_fulltext` ADD CONSTRAINT `fk_content_fulltext` FOREIGN KEY (`content_id`) REFERENCES `content` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `content_tag` -- ALTER TABLE `content_tag` ADD CONSTRAINT `fk-content-tag-container-id` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk-content-tag-parent-id` FOREIGN KEY (`parent_id`) REFERENCES `content_tag` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `content_tag_relation` -- ALTER TABLE `content_tag_relation` ADD CONSTRAINT `fk-content-tag-rel-content-id` FOREIGN KEY (`content_id`) REFERENCES `content` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk-content-tag-rel-tag-id` FOREIGN KEY (`tag_id`) REFERENCES `content_tag` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `file` -- ALTER TABLE `file` ADD CONSTRAINT `fk_file-created_by` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `file_history` -- ALTER TABLE `file_history` ADD CONSTRAINT `fk_file_history` FOREIGN KEY (`file_id`) REFERENCES `file` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `fk_file_history_user` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
-- -- Constraints for table `group_permission` -- ALTER TABLE `group_permission` ADD CONSTRAINT `fk_group_permission-group_id` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `group_space` -- ALTER TABLE `group_space` ADD CONSTRAINT `fk-group_space-group` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk-group_space-space` FOREIGN KEY (`space_id`) REFERENCES `space` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `group_user` -- ALTER TABLE `group_user` ADD CONSTRAINT `fk-group-group` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk-user-group` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `like` -- ALTER TABLE `like` ADD CONSTRAINT `fk_like-created_by` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `fk_like-target_user_id` FOREIGN KEY (`target_user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `live` -- ALTER TABLE `live` ADD CONSTRAINT `contentcontainer` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `notification` -- ALTER TABLE `notification` ADD CONSTRAINT `fk_notification-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `profile` -- ALTER TABLE `profile` ADD CONSTRAINT `fk_profile-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `profile_field` -- ALTER TABLE `profile_field` ADD CONSTRAINT `fk_profile_field-profile_field_category_id` FOREIGN KEY (`profile_field_category_id`) REFERENCES `profile_field_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `space_membership` -- ALTER TABLE `space_membership` ADD CONSTRAINT `fk_space_membership-space_id` FOREIGN KEY (`space_id`) REFERENCES `space` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `fk_space_membership-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `user_auth` -- ALTER TABLE `user_auth` ADD CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `user_follow` -- ALTER TABLE `user_follow` ADD CONSTRAINT `fk_user_follow-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `user_friendship` -- ALTER TABLE `user_friendship` ADD CONSTRAINT `fk-friend` FOREIGN KEY (`friend_user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk-user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `user_http_session` -- ALTER TABLE `user_http_session` ADD CONSTRAINT `fk_user_http_session-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `user_mentioning` -- ALTER TABLE `user_mentioning` ADD CONSTRAINT `fk_user_mentioning-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `user_password` -- ALTER TABLE `user_password` ADD CONSTRAINT `fk_user_password-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE 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 */;