IP : 18.119.127.16Hostname : 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/
fiyo/
../
front/
../
wp57/
../
xcloner/
../
flarum/
flarum.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 */;
-- -- Constraints for table `[[dbprefix]]access_tokens` -- ALTER TABLE `[[dbprefix]]access_tokens` ADD CONSTRAINT `[[dbprefix]]access_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]api_keys` -- ALTER TABLE `[[dbprefix]]api_keys` ADD CONSTRAINT `[[dbprefix]]api_keys_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]discussions` -- ALTER TABLE `[[dbprefix]]discussions` ADD CONSTRAINT `[[dbprefix]]discussions_first_post_id_foreign` FOREIGN KEY (`first_post_id`) REFERENCES `[[dbprefix]]posts` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]discussions_hidden_user_id_foreign` FOREIGN KEY (`hidden_user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]discussions_last_post_id_foreign` FOREIGN KEY (`last_post_id`) REFERENCES `[[dbprefix]]posts` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]discussions_last_posted_user_id_foreign` FOREIGN KEY (`last_posted_user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]discussions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]discussion_tag` -- ALTER TABLE `[[dbprefix]]discussion_tag` ADD CONSTRAINT `[[dbprefix]]discussion_tag_discussion_id_foreign` FOREIGN KEY (`discussion_id`) REFERENCES `[[dbprefix]]discussions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]discussion_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `[[dbprefix]]tags` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]discussion_user` -- ALTER TABLE `[[dbprefix]]discussion_user` ADD CONSTRAINT `[[dbprefix]]discussion_user_discussion_id_foreign` FOREIGN KEY (`discussion_id`) REFERENCES `[[dbprefix]]discussions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]discussion_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]email_tokens` -- ALTER TABLE `[[dbprefix]]email_tokens` ADD CONSTRAINT `[[dbprefix]]email_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]flags` -- ALTER TABLE `[[dbprefix]]flags` ADD CONSTRAINT `[[dbprefix]]flags_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]posts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]flags_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]group_permission` -- ALTER TABLE `[[dbprefix]]group_permission` ADD CONSTRAINT `[[dbprefix]]group_permission_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]groups` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]group_user` -- ALTER TABLE `[[dbprefix]]group_user` ADD CONSTRAINT `[[dbprefix]]group_user_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]group_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]login_providers` -- ALTER TABLE `[[dbprefix]]login_providers` ADD CONSTRAINT `[[dbprefix]]login_providers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]notifications` -- ALTER TABLE `[[dbprefix]]notifications` ADD CONSTRAINT `[[dbprefix]]notifications_from_user_id_foreign` FOREIGN KEY (`from_user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]password_tokens` -- ALTER TABLE `[[dbprefix]]password_tokens` ADD CONSTRAINT `[[dbprefix]]password_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]posts` -- ALTER TABLE `[[dbprefix]]posts` ADD CONSTRAINT `[[dbprefix]]posts_discussion_id_foreign` FOREIGN KEY (`discussion_id`) REFERENCES `[[dbprefix]]discussions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]posts_edited_user_id_foreign` FOREIGN KEY (`edited_user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]posts_hidden_user_id_foreign` FOREIGN KEY (`hidden_user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]posts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]post_likes` -- ALTER TABLE `[[dbprefix]]post_likes` ADD CONSTRAINT `[[dbprefix]]post_likes_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]posts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]post_likes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]post_mentions_group` -- ALTER TABLE `[[dbprefix]]post_mentions_group` ADD CONSTRAINT `[[dbprefix]]post_mentions_group_mentions_group_id_foreign` FOREIGN KEY (`mentions_group_id`) REFERENCES `[[dbprefix]]groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]post_mentions_group_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]posts` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]post_mentions_post` -- ALTER TABLE `[[dbprefix]]post_mentions_post` ADD CONSTRAINT `[[dbprefix]]post_mentions_post_mentions_post_id_foreign` FOREIGN KEY (`mentions_post_id`) REFERENCES `[[dbprefix]]posts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]post_mentions_post_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]posts` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]post_mentions_tag` -- ALTER TABLE `[[dbprefix]]post_mentions_tag` ADD CONSTRAINT `[[dbprefix]]post_mentions_tag_mentions_tag_id_foreign` FOREIGN KEY (`mentions_tag_id`) REFERENCES `[[dbprefix]]tags` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]post_mentions_tag_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]posts` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]post_mentions_user` -- ALTER TABLE `[[dbprefix]]post_mentions_user` ADD CONSTRAINT `[[dbprefix]]post_mentions_user_mentions_user_id_foreign` FOREIGN KEY (`mentions_user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]post_mentions_user_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]posts` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]post_user` -- ALTER TABLE `[[dbprefix]]post_user` ADD CONSTRAINT `[[dbprefix]]post_user_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]posts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]post_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]tags` -- ALTER TABLE `[[dbprefix]]tags` ADD CONSTRAINT `[[dbprefix]]tags_last_posted_discussion_id_foreign` FOREIGN KEY (`last_posted_discussion_id`) REFERENCES `[[dbprefix]]discussions` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]tags_last_posted_user_id_foreign` FOREIGN KEY (`last_posted_user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]tags_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `[[dbprefix]]tags` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]tag_user` -- ALTER TABLE `[[dbprefix]]tag_user` ADD CONSTRAINT `[[dbprefix]]tag_user_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `[[dbprefix]]tags` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]tag_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]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 */;