IP : 3.136.18.14Hostname : 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/
moodle/
../
xmb/
../
modx/
../
freshrss/
../
tcexam/
tcexam.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 */;
-- -- Dumping data for table `[[dbprefix]]usrgroups` --
INSERT INTO `[[dbprefix]]usrgroups` VALUES (2, 1);
-- -- Constraints for dumped tables --
-- -- Constraints for table `[[dbprefix]]answers` -- ALTER TABLE `[[dbprefix]]answers` ADD CONSTRAINT `[[dbprefix]]answers_ibfk_1` FOREIGN KEY (`answer_question_id`) REFERENCES `[[dbprefix]]questions` (`question_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]modules` -- ALTER TABLE `[[dbprefix]]modules` ADD CONSTRAINT `[[dbprefix]]modules_ibfk_1` FOREIGN KEY (`module_user_id`) REFERENCES `[[dbprefix]]users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]questions` -- ALTER TABLE `[[dbprefix]]questions` ADD CONSTRAINT `[[dbprefix]]questions_ibfk_1` FOREIGN KEY (`question_subject_id`) REFERENCES `[[dbprefix]]subjects` (`subject_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]subjects` -- ALTER TABLE `[[dbprefix]]subjects` ADD CONSTRAINT `[[dbprefix]]subjects_ibfk_2` FOREIGN KEY (`subject_module_id`) REFERENCES `[[dbprefix]]modules` (`module_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]subjects_ibfk_1` FOREIGN KEY (`subject_user_id`) REFERENCES `[[dbprefix]]users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]testgroups` -- ALTER TABLE `[[dbprefix]]testgroups` ADD CONSTRAINT `[[dbprefix]]testgroups_ibfk_2` FOREIGN KEY (`tstgrp_group_id`) REFERENCES `[[dbprefix]]user_groups` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]testgroups_ibfk_1` FOREIGN KEY (`tstgrp_test_id`) REFERENCES `[[dbprefix]]tests` (`test_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]tests` -- ALTER TABLE `[[dbprefix]]tests` ADD CONSTRAINT `[[dbprefix]]tests_ibfk_1` FOREIGN KEY (`test_user_id`) REFERENCES `[[dbprefix]]users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]testsslcerts` -- ALTER TABLE `[[dbprefix]]testsslcerts` ADD CONSTRAINT `[[dbprefix]]testsslcerts_ibfk_2` FOREIGN KEY (`tstssl_ssl_id`) REFERENCES `[[dbprefix]]sslcerts` (`ssl_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]testsslcerts_ibfk_1` FOREIGN KEY (`tstssl_test_id`) REFERENCES `[[dbprefix]]tests` (`test_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]tests_logs` -- ALTER TABLE `[[dbprefix]]tests_logs` ADD CONSTRAINT `[[dbprefix]]tests_logs_ibfk_2` FOREIGN KEY (`testlog_testuser_id`) REFERENCES `[[dbprefix]]tests_users` (`testuser_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]tests_logs_ibfk_1` FOREIGN KEY (`testlog_question_id`) REFERENCES `[[dbprefix]]questions` (`question_id`) ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]tests_logs_answers` -- ALTER TABLE `[[dbprefix]]tests_logs_answers` ADD CONSTRAINT `[[dbprefix]]tests_logs_answers_ibfk_2` FOREIGN KEY (`logansw_testlog_id`) REFERENCES `[[dbprefix]]tests_logs` (`testlog_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]tests_logs_answers_ibfk_1` FOREIGN KEY (`logansw_answer_id`) REFERENCES `[[dbprefix]]answers` (`answer_id`) ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]tests_users` -- ALTER TABLE `[[dbprefix]]tests_users` ADD CONSTRAINT `[[dbprefix]]tests_users_ibfk_2` FOREIGN KEY (`testuser_test_id`) REFERENCES `[[dbprefix]]tests` (`test_id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]tests_users_ibfk_1` FOREIGN KEY (`testuser_user_id`) REFERENCES `[[dbprefix]]users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]test_subjects` -- ALTER TABLE `[[dbprefix]]test_subjects` ADD CONSTRAINT `[[dbprefix]]test_subjects_ibfk_2` FOREIGN KEY (`subjset_tsubset_id`) REFERENCES `[[dbprefix]]test_subject_set` (`tsubset_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]test_subjects_ibfk_1` FOREIGN KEY (`subjset_subject_id`) REFERENCES `[[dbprefix]]subjects` (`subject_id`) ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]test_subject_set` -- ALTER TABLE `[[dbprefix]]test_subject_set` ADD CONSTRAINT `[[dbprefix]]test_subject_set_ibfk_1` FOREIGN KEY (`tsubset_test_id`) REFERENCES `[[dbprefix]]tests` (`test_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `[[dbprefix]]usrgroups` -- ALTER TABLE `[[dbprefix]]usrgroups` ADD CONSTRAINT `[[dbprefix]]usrgroups_ibfk_2` FOREIGN KEY (`usrgrp_group_id`) REFERENCES `[[dbprefix]]user_groups` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]usrgroups_ibfk_1` FOREIGN KEY (`usrgrp_user_id`) REFERENCES `[[dbprefix]]users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
/*!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 */;